Pandas' .read_excel() method (https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html) has the option to specify multiple header rows, using the header argument. So if the first two rows are indices like in your case, you would specify: header=[0, 1]