df1:
Id Rick Nick Tom Jerry
101 2000 3000 4000 6500
101 5000 9000 8000 2500
101 6000 8000 6000 6300
Dict1= {Rick:G-1, Nick:G-2, Tom:G-3, Jerry:G-4}
df_output:
Id Rick Nick Tom Jerry
Desc G-1 G-2 G-3 G-4
101 2000 3000 4000 6500
101 5000 9000 8000 2500
101 6000 8000 6000 6300
I need to map Dictionary with Column Names & it should come just below the Headers
Advertisement
Answer
Try something like creating a df and appending:
(pd.Series(Dict1).to_frame().T
.append(df,sort=False).fillna({"Id":"Desc"}).loc[:,df.columns])
Or:
pd.concat((pd.DataFrame.from_dict(Dict1,orient='index').T,
df),sort=False).fillna({"Id":"Desc"}).reindex(df.columns,axis=1)
Id Rick Nick Tom Jerry 0 Desc G-1 G-2 G-3 G-4 0 101 2000 3000 4000 6500 1 101 5000 9000 8000 2500 2 101 6000 8000 6000 6300