How to drop the index column while writing the DataFrame in a .csv file in Pandas? [duplicate]

Question

My DataFrame contains two columns named 'a','b'. Now when I created a csv file of this DataFrame:

df.to_csv('myData.csv')

And when I opened this in an excel file, there is an extra column with indices that appears alongside the columns 'a' and 'b', but I don't want that. I only want columns 'a' and 'b' to appear in the excel sheet.

Is there any way to do this?

Answer 1

Try,

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