Pandas Data frame Pivot Reset

Asked Apr 14 '18 at 10:24

Active Apr 14 '18 at 10:24

Viewed 33 times

I'm trying to apply pivot table on a data frame by using

intractionTableClicks = pd.pivot_table(read_sql_preroll_interaction,index = ["PLACEMENT"],values=["VWR_CLICKTHROUGH"],
                                               columns=["CLICK_TAG"],aggfunc=np.sum,fill_value=0)

but the output is coming like I want this to be like this I've already tried intractionTableClicks.reset_index(inplace=True)

asked Apr 14 '18 at 10:24

abhilash mishra

Abhilash just remove those square brackets for the column names in your code. – Bharath M Shetty Apr 14 '18 at 11:56
@Dark it's not giving the output as expected. – abhilash mishra Apr 15 '18 at 18:37
The answer is https://stackoverflow.com/questions/22233488/pandas-drop-a-level-from-a-multi-level-column-index – Reza energy Dec 09 '18 at 04:20

Pandas Data frame Pivot Reset

0 Answers0