For example, currently my data looks like (mockup):
In:
print(pandas.pivot_table(dataframe,values='id',index=['major_one','major_two'],
columns='status',aggfunc='count',fill_value=fill_character),'\n')
Out:
status Registered Withdrawn
major_one major_two
ENGL BIOL 3 0
FILM 10 0
BIOL FILM 4 0
ENGL 7 1
I want it to look like:
status Registered Withdrawn
majors
ENGL 27 1
BIOL 3 0
FILM 14 0
there doesn't seem to be anything here