I want to use dataframe values as column names and simplify the dataframe.

I tried df.stack() and then index.map('{0[0]}_{0[1]}'.format)

Input_df(Got this df by doing a groupby):

link price  dateA     1    01/01A     2    01/02A     1.2  01/03

Desired_ouput:

link price_01/01 price_01/02 price_01/03A      1            2         1.2

Forget mapping over a multiindex

df.set_index(['link', 'date']).price.unstack().add_prefix('price_')date  price_01/01  price_01/02  price_01/03
link                                       
A             1.0          2.0          1.2