I have a dataframe df
name | level | index |
---|---|---|
apple | a | 100.178 |
apple | b | 84.075 |
apple | c | 78.585 |
apple | d | 94.936 |
orange | a | 104.707 |
orange | b | 109.452 |
orange | c | 115.746 |
orange | d | 117.172 |
I want to map the index
column based on level
column values in df2
which has only id
and name1
column initially this way:-
id | name1 | a_index | b_index | c_index | d_index |
---|---|---|---|---|---|
1 | apple | 100.178 | 84.075 | 78.585 | 94.936 |
2 | apple | 100.178 | 84.075 | 78.585 | 94.936 |
3 | orange | 104.707 | 109.452 | 115.746 | 117.172 |
4 | apple | 100.178 | 84.075 | 78.585 | 94.936 |