[Solved] How can I turn this txt file to a pandas DataFrame?

Question

As MrSmily2019 said you will want to use https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_csv.html.

It does more than just CSV, it can do text. Additionally you can turn text files into csv. You file seems to be “TAB” delimited (how it know to separate) instead of comma. You can adjust the settings so it knows to do it on the appropriate character.

And example of how you would have to modify it is:

pandas.read_csv(filename, sep='\t', lineterminator="\r")

Accepted Answer

As MrSmily2019 said you will want to use https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_csv.html.

It does more than just CSV, it can do text. Additionally you can turn text files into csv. You file seems to be “TAB” delimited (how it know to separate) instead of comma. You can adjust the settings so it knows to do it on the appropriate character.

And example of how you would have to modify it is:

pandas.read_csv(filename, sep='\t', lineterminator="\r")