Pandas: parse merged header columns from Excel
Suppose your DataFrame is df: import numpy as np import pandas as pd nan = np.nan df = pd.DataFrame([ (nan, nan, nan, ‘Auto loan’, nan) , (‘Branch Code’, ‘Branch Name’, ‘Region’, ‘No of accounts’ , ‘Portfolio Outstanding’) , (3000, ‘Name1’, ‘Central’, 0, 0) , (3001, ‘Name2’, ‘Central’, 0, 0) ]) so that it looks like … Read more