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

1

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)

answered Jan 6, 2016 at 6:55

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Collectives™ on Stack Overflow

write to csv from dataframes using python panda

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related