Why Python reads columns of the .txt as a single column?

Asked Oct 01 '20 at 12:07

Active Oct 07 '20 at 14:26

Viewed 73 times

I've just started learning Python and I need to open the dataset. The file is .txt. The problem is when I read the file, Python merges all its columns into one.

The original txt looks like this:

I write the code in the Jupyter-notebook.

datareader = pd.read_csv ('data.txt', delimiter=None, header=[1,2])
datareader

Python output looks like this:

What am I doing wrong? How to open the data correctly?

edited Oct 07 '20 at 14:26

Barmar

741,623
53
500
612

asked Oct 01 '20 at 12:07

Polina

you need to add a delimiter ```delimiter=r"\s+"``` – Yash Oct 01 '20 at 12:09
`delimiter=None` why? may be you want `header=None` – deadshot Oct 01 '20 at 12:09
@YashShah thank you! I tried different delimiters but didn't come up with the one you offered . Now the file opens correctly – Polina Oct 01 '20 at 12:18

Why Python reads columns of the .txt as a single column?

0 Answers0