0

i want the sum of all subcounts printed in a pivot table.

table = pd.pivot_table(df, index = ['value1', 'value2'], values = ['value3'], aggfunc = [np.count_nonzero])

Output of print(table.loc[value1example]):

                                 count_nonzero
                               value3
value2
 value2examplea                           766
 value2exampleb                           265
 value2examplec                           19

I want the following:

                                 count_nonzero
                               value3
value2                                   950
 value2examplea                           766
 value2exampleb                           265
 value2examplec                           19

Do you have an idea?

Laki
  • 41
  • 4

0 Answers0