Reading in excel files with wrapped headers onto pandas

user_8300107 0
Viewed 82

I want to import excel sheets as data frames and export as csv. I need to do this for quite a few files. However, the headers of all files are arranged in two rows.

Thus, when I read the files, I get the headers as Fuel Temp \n(Deg C),Air Charge Temp \n(Deg C) and so on.

How do I read these files into dataframes without the '\n'?

pandas excel python
1 Answers

I believe you need str.replace:

df.columns = df.columns.str.replace('\n', '')
user_29010020
Related