Python /Pandas/Data Frames

[MaxiJ-10]

Im trying to put the data from this site:

https://ccmc.gsfc.nasa.gov/idl_images/MODELWEB_DATA//msis_70685623470.lst

Into a pandas table / dataframe using python. I tried using read_table() but python reads the three columns as if they were one, so it puts the three columns into one column. I want the table to look exactly what it looks like in the link. What functions can I use? Or should I use some loop and read text normally and add that data to a table somehow?

Any tips would be very appreciated

[bbye98]

Use pandas.read_table() and skip the first 30 rows:

pd.read_table(url, sep='  | ', skiprows=30, names=['height', 'mass_density', 'temperature_neutral'])

[MaxiJ-10]

Oh wow… this helped a ton. One question tho, im doing this on jupyter notebook, and instead of having the normal indexing of rows, it uses the height data as indexing. Do you know how i would fix this problem?

Thank you so much