Way to automatically name csv file from data frame in python without taking index and header from dataframe

Question

I have a Data Frame with one column consisting of Names
When i access the names from the dataframe as

filename = frcl.iloc[[i]]
file = open(''+str(filename)+'.csv', 'w')

It creates CSV file with name with index and header in the CSV File Name
Eg; if i have Apple and Bat in Dataframe it creates csv file with 00Apple.csv and 01Bat.csv
how to take dataframe content with out index and header?

Shunya · Accepted Answer · 2022-06-06 12:58:33Z

2

You can use panda's method to_string() and specify the argument index=False to avoid including the row's index.

filename = frcl.iloc[[i]].to_string(index=False)
file = open(''+filename+'.csv', 'w')

answered Jun 6, 2022 at 12:58

Shunya

2,5244 gold badges20 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kalyan N Over a year ago

filename = frcl.iloc[[i]].to_string(index=False,header=0) This worked thank you.

Collectives™ on Stack Overflow

Way to automatically name csv file from data frame in python without taking index and header from dataframe

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related