How to avoid Python/Pandas creating an index in a saved csv?

Use index=False.

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

python csv indexing pandas

There are two ways to handle the situation where we do not want the index to be stored in csv file.

As others have stated you can use index=False while saving your
dataframe to csv file.
df.to_csv('file_name.csv',index=False)
Or you can save your dataframe as it is with an index, and while reading you just drop the column unnamed 0 containing your previous index.Simple!
df.to_csv(' file_name.csv ')
df_new = pd.read_csv('file_name.csv').drop(['unnamed 0'],axis=1)

python csv indexing pandas

If you want no index, read file using:

import pandas as pddf = pd.read_csv('file.csv', index_col=0)

save it using

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

CodeHunter