'How can I read a document with pandas (python) that don't look like the average one?

I am trying to get the values from the colums from a file. The doc looks like this the data I want to read

So all the examples I have found uses pd.read_csv or pd.DataFrame but all data usually have a clear header an nothing on top of the data (I have like 10 lines of code I don't really need for what I am doing).

Also, I think maybe there is something wrong because I tried to run:

data = pd.read_csv('tdump_BIL_100_-96_17010100.txt',header=15)

and I get

pd.read_csv output

which is just the row in one column, so there is no separation apparently, and therefore no way of getting the columns I need.

So my question is if there is a way to get the data from this file with pandas and how to get it.



Solution 1:[1]

If a defined number, skip the initial rows, indicate that no header is present, and that values are separated by spaces.

df = pd.read_csv(filename, skiprows=15, header=None, sep='\s+')

See read_csv for documentation.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 mozway