pandas: split merged header from excel

Question

i have an excel file with merged header like this

what i want is header like this using pandas

I tried using this solution: https://stackoverflow.com/a/27424102/12934577

but it return sequence item 0: expected str instance, float found

Answer 1

You might need to use str instead like in that answer:

df.columns = df.iloc[0:2].apply(lambda x: '.'.join([str(y) for y in x if y]), axis=0)