how should i read a csv file without the 'unnamed' row with pandas?

Question

I am writing to a .csv file with:

my_data_frame.to_cav("some_path")

When trying to read the file with:

pd.read_csv("some_path")

I can tell that an unnamed column was added. How can i fix that?

Can you add sample of `csv`? – jezrael May 02 '16 at 07:33 — jezrael, May 02 '16 at 07:33

score 39 · Accepted Answer · answered May 02 '16 at 07:34

39

to_csv() writes an index per default, so you can either disable index when saving your CSV:

df.to_csv('file.csv', index=False)

or specify an index column when reading:

df = pd.read_csv('file.csv', index_col=0)

answered May 02 '16 at 07:34

Ok, that is the solution. Thanks. – avicohen May 02 '16 at 07:36
of course, but the site tell me i need to wait several minutes before thah. – avicohen May 02 '16 at 07:40

1 Answers1