JavaScript
x
16
16
1
df1:
2
Id Rick Nick Tom Jerry
3
101 2000 3000 4000 6500
4
101 5000 9000 8000 2500
5
101 6000 8000 6000 6300
6
7
Dict1= {Rick:G-1, Nick:G-2, Tom:G-3, Jerry:G-4}
8
9
df_output:
10
11
Id Rick Nick Tom Jerry
12
Desc G-1 G-2 G-3 G-4
13
101 2000 3000 4000 6500
14
101 5000 9000 8000 2500
15
101 6000 8000 6000 6300
16
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:
JavaScript
1
3
1
(pd.Series(Dict1).to_frame().T
2
.append(df,sort=False).fillna({"Id":"Desc"}).loc[:,df.columns])
3
Or:
JavaScript
1
3
1
pd.concat((pd.DataFrame.from_dict(Dict1,orient='index').T,
2
df),sort=False).fillna({"Id":"Desc"}).reindex(df.columns,axis=1)
3
JavaScript
1
6
1
Id Rick Nick Tom Jerry
2
0 Desc G-1 G-2 G-3 G-4
3
0 101 2000 3000 4000 6500
4
1 101 5000 9000 8000 2500
5
2 101 6000 8000 6000 6300
6