Sad Shayari Attitude Status Love Shayari Dosti Shayari Suvichar Dard Bhari Shayari Attitude Shayari Good Morning Shayari Good Night Shayari Birthday Shayari Funny Shayari Urdu Shayari Desh Bhakti Shayari 2 Line Shayari Sorry Shayari Bewafa Shayari

Home Python Tutorial pandas to_csv with no index

pandas to_csv with no index

Deep Learning Machine Learning pandas Tutorial Python Tutorial

Solution:

use index=False while saving your dataframe to CSV file.
```
df.to_csv('file_name.csv',index=False)
```
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)
```
Another solution if you want to keep this column as an index.
```
pd.read_csv('filename.csv', index_col='Unnamed: 0')
```