How to create a pivot table from this table (revised)
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Suppose I have a table T
location gender
-----------------------------------------------------------
Customer 1 NY male
Customer 2 LA female
Customer 3 Austin female
Customer 4 LA female
Then I want to create a pivot table
Male Female
--------------------------------------------
NY 1 0
LA 0 2
Austin 0 1
I checked unstack and grpstat but I am not sure. What will be a next step?
0 commentaires
Réponse acceptée
Dave B
le 15 Août 2021
Modifié(e) : Dave B
le 15 Août 2021
Maybe there's a simpler path, but how about using groupsummary followed by unstack?
% Generate your table
cust = {'Customer 1' 'Customer 2' 'Customer 3'};
location = categorical({'NY' 'LA' 'Austin'},{'NY' 'LA' 'Austin'})';
gender = categorical({'male' 'female' 'female'},{'male' 'female'})';
t=table(location,gender);
% groupsumamry for counts, unstack for pivot, and then set NaNs to 0
s=groupsummary(t,{'location' 'gender'});
result=unstack(s,'GroupCount','gender');
result.female(isnan(result.female))=0;
result.male(isnan(result.male))=0;
disp(result)
0 commentaires
Plus de réponses (1)
the cyclist
le 15 Août 2021
What you want to do is not really a pivot:
% Create your table
customer = {'1';'2';'3'};
location = {'NY';'LA';'Austin'};
gender = {'male';'female';'female'};
tbl = table(customer,location,gender)
% You don't need the above. It is just to create your data.
% Create columns for male and female
tbl.male = double(strcmp(tbl.gender,'male'));
tbl.female = double(strcmp(tbl.gender,'female'));
% Drop the gender column
tbl.gender = []
3 commentaires
the cyclist
le 15 Août 2021
Ah. I thought you just wanted to replace male/female with binary variables.
Voir également
Catégories
En savoir plus sur Matrices and Arrays 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!