Writing pandas dataframe headers in one column in excel

Question

i have a big csv file which i cannot open in excel, but somehow I need to sort it further in excel and for this i only need the column headers of my frame, so far i got with a pandas dataframe:

cols = df.columns.tolist()

which leads to a long list of column names:

['ID',
 'ABUNG KZ',
 'ABSTIMMKS',
 'BETR ABWEBUEHR',
 'BETR ABWITEN',
 'AGR ',
 'ANSCH',
 'ANSCHRIFT',
 ...
]

How can I write this list into a excel file, that I have this in one column, all column names in a diffferent row so that it looks like (in excel):

Names
ID
ABUNG KZ
...

PV8 · Accepted Answer · 2020-05-22 08:39:57Z

2

Try the following code:

cols = df.columns.tolist()

data = {'Names': cols} 

df2 = pd.DataFrame(data)
df2.to_excel('df_excel.xlsx', index=False)

edited May 22, 2020 at 8:39

PV8

6,3689 gold badges54 silver badges113 bronze badges

answered May 22, 2020 at 8:36

oreopot

3,4592 gold badges23 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

Writing pandas dataframe headers in one column in excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related