CODEWITHSUNDEEP
pythonpandasdataframecsvjupyter-notebook
CephaloRhod
CephaloRhod

Reputation: 75

Exporting dataframe to csv not showing first column

I'm trying to export my df to a .csv file. The df has just two columns of data: the image name (.jpg), and the 'value_counts' of how many times that .jpg name occurs in the 'concat_Xenos.csv' file, i.e:

M116_13331848_13109013329679.jpg    19
M116_13331848_13109013316679.jpg    14
M116_13331848_13109013350679.jpg    12
M116_13331848_13109013332679.jpg    11
etc. etc. etc....

However, whenever I export the df, the .csv file only displayes the 'value_counts' column. How do I modify this?

My code is as follows:

concat_Xenos = r'C:\file_path\concat_Xenos.csv'

df = pd.read_csv(concat_Xenos, header=None, index_col=False)[0]
counts = df.value_counts()

export_csv = counts.to_csv (r'C:\file_path\concat_Xenos_valuecounts.csv', index=None, header=False)

Thanks! If any clarification is needed please ask :)

R

Upvotes: 0

Views: 2495

Answers (1)

Rakesh
Rakesh

Reputation: 82765

This is because the first column is set as index.

Use index=True: 

export_csv = counts.to_csv (r'C:\file_path\concat_Xenos_valuecounts.csv', index=True, header=False)

or you can reset your index before exporting. 

counts.reset_index(inplace=True)

Upvotes: 3

Related Questions