Is there a way to manipulate pandas pivot table to obtain a specific format of output?

Question

i got this pivot table result

my pivot table code looks like this:

result = pd.pivot_table(excel, values=["Percent"], columns='Date', index='items', aggfunc={"Percent":np.mean})

but i need to looks like this:

Anyone knows how i can get it?

i tried:

result.reset_index(level=0, drop=True)

but drops the wrong column

Answer 1

You don't need to specify aggfunc with a dict as you have only one column of value:

result = excel.pivot_table(index='items', columns='Date',
                           values='Percent', aggfunc='mean')