excel – Python: Combination of two rows with pandas read_excel

I read an Excel file with pandas and felt that there must be a better way to handle the way I create the column names. This is something like the Excel file that I read:

                                                                1 2 # 1 & # 39; is merged into the two cells above & # 39; a & # 39; and & bgr;
Date a b c d # likewise for & # 39; 2 & # 39; As opposed to "centered on selection"
January 1st 19 100 200 300 400
2 1st of February 19 101 201 301 401
3 1-Mar-19 102 202 302 402

I want that I am merging the columns "," b "," c & # 39; c & # 39; and & # 39; with & & 39; 1 & # 39; and & # 39; 2 & # 39; above, then I do the following to get my headers in the way that want to:

import pandas as pd
import json

xls = pd.ExcelFile (R: C:  Path_to  Excel_Pandas_Connector_Test.xls & # 39;)
df = pd.read_excel (xls, & # 39; Sheet1), header =[1]# uses the abcd line as column names

# I only want the most recent data day, so I do the following
json_str = df[df.Date == df['Date'].max ()].to_json (orient = & # 39; records & # 39; date_format = & quot; iso & # 39;)

dat_data = json.loads (json_str)[0]

def clean_json ():
global data
données_données['1a']      = dat_data.pop (& # 39; a & # 39;)
données_données['1b']      = dat_data.pop (& # 39; b)
données_données['2c']      = dat_data.pop (& # 39; c & # 39;)
données_données['2d']      = dat_data.pop (& # 39; d)

clean_json ()

print (json.dumps (dat_data, indent = 4))

My desired exit is:

{
"Date": "2019-03-01T00: 00: 00.000Z",
"1a": 102,
"1b": 202,
"2c": 302,
"2d": 402
}

It works as expected, but is there an integrated Pandas that I could have used to do the same thing instead of the clean_json function?