I have a table that looks like the following:
| category | feature_a | feature_b |
|---|---|---|
| top20 | 3 | 5 |
| top10 | 2 | 6 |
| top10 | 1 | 7 |
| top20 | 4 | 8 |
What I am trying to do is to create a pivot table that looks like the following:
| features | top20 | top10 |
|---|---|---|
| feature_a | 7 | 3 |
| feature_b | 13 | 13 |
Each of the values in the second table is the sum of each feature per each category. I am reading the documentations on the pivot table 