How to create a pivot table from this table, Part 2
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
To generalize https://www.mathworks.com/matlabcentral/answers/898782-how-to-create-a-pivot-table-from-this-table-revised?s_tid=srchtitle,
suppose I have a table T
location gender sales
-----------------------------------------------------------
Customer 1 NY male 10
Customer 2 LA female 20
Customer 3 Austin female 15
Customer 4 LA female 10
Then I want to create a pivot table
Male sales Female sales
--------------------------------------------
NY 10 0
LA 0 30
Austin 0 15
I checked unstack and grpstat but I am not sure. What will be a next step?
0 commentaires
Réponse acceptée
Stephen23
le 21 Août 2021
customer = {'Customer 1';'Customer 2';'Customer 3';'Customer 4'};
location = {'NY';'LA';'Austin';'LA'};
gender = {'male';'female';'female';'female'};
sales = [10;20;15;10];
T = table(customer,location,gender,sales)
S = removevars(T,'customer');
S = groupsummary(S,{'location','gender'},'sum')
U = unstack(S,'sum_sales','gender')
etc.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!