Ads by ProfitSence

Python Pandas to csv no index

Last Updated on Wednesday 5th Oct 2022

pandas to csv no index

pandas write csv without index.pandas to csv without index.

  • read_csv - Load a CSV file into a DataFrame.
  • to_csv - Write object to a comma-separated values (csv) file.
					import pandas as pd
df = pd.read_csv('file.csv', index_col=0)


pandas save csv without index

  • You can use index=False while saving your dataframe to csv file.
  • 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
					df.to_csv(' file_name.csv ')
df_new = pd.read_csv('file_name.csv').drop(['unnamed 0'],axis=1)


Save the CSV File Using

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



					df = pd.DataFrame({'name': ['Raphael', 'Donatello'],
                   'mask': ['red', 'purple'],
                   'weapon': ['sai', 'bo staff']})


If you want to keep this column as index.

					pd.read_csv('filename.csv', index_col='Unnamed: 0')


If you want a good format the next statement is the best

					df.to_csv('filename.csv', sep=',', encoding='utf-8', index=False)



pandas to csv no index
to_csv without index
pandas to_csv no index
pandas to csv without index
pandas to_csv without index
to_csv no index
dataframe to csv without index
pd to csv no index