write to csv from dataframes using python panda

Question

This is my csv file.

Uid,Message,Status 9425252526,Hello 1,0 9425252527,Hello 2,0 9425252528,Hello 3,0 9425252529,Hello 4,0 9425252530,Hello 5,0

if I convert it to pandas dataframe and write it back to another file,it adds this unwanted extra column as below (leftmost column)

,Uid,Message,Status 0,9425252526,Hello 1,0 1,9425252527,Hello 2,0 2,9425252528,Hello 3,0 3,9425252529,Hello 4,0 4,9425252530,Hello 5,0

How to remove this column ?

ranlot · Accepted Answer · 2016-01-06 06:58:57Z

2

Assuming you named your dataframe df. You need to set the index to false:

df.to_csv("yourFile.csv", index=False)

answered Jan 6, 2016 at 6:58

ranlot

6561 gold badge6 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jezrael · Accepted Answer · 2016-01-06 06:55:58Z

You need add index=False to to_csv:

print df.to_csv(index=False) "Uid,Message,Status" "9425252526,Hello 1,0" "9425252527,Hello 2,0" "9425252528,Hello 3,0" "9425252529,Hello 4,0" "9425252530,Hello 5,0"

Or with filename:

df.to_csv('filename', index=False)

Collectives™ on Stack Overflow

write to csv from dataframes using python panda

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related