How to re-arrange Python Pandas dataframe shifting col header to next row and re-name merged header

Asked Apr 04 '18 at 05:05

Active Apr 04 '18 at 07:11

Viewed 41 times

I have a python pandas data frame which looks like the following in excel table:

I want it to look like the following using python.Have tried but not able to find the solution.Please help!!

edited Apr 04 '18 at 07:11

Shir

asked Apr 04 '18 at 05:05

PSarkar

What did you try so far? How do you read the excel table to Pandas? – Shir Apr 04 '18 at 05:41
excel_file1 = 'filepath\\file.xlsx' df1=pd.read_excel(excel_file1,sheet_name=0)..in this sheet the above problem exists... – PSarkar Apr 06 '18 at 06:26

0 Answers0