Saving the header of a dataframe to a csv file in pandas

Question

I have a dataframe in pandas as such

Name    Age    Gender
Emily   10     female
Rob     12     male

I want to save a csv file from this dataframe so that it looks like so

Index     ColumnName
0         Name
1         Age
2         Gender

I can't find anything online which tell me how I can do this.

J. Doe · Accepted Answer · 2018-07-19 12:59:06Z

3

pd.DataFrame({"ColumnName": df.columns}).to_csv("path/to/file.csv")

answered Jul 19, 2018 at 12:59

J. Doe

3,6443 gold badges26 silver badges44 bronze badges

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

1 Answer 1