How to create a pivot table from this table, Part 2

2 次查看（过去 30 天）
alpedhuez
alpedhuez 2021-8-21
评论： alpedhuez 2021-8-23
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?

请先登录，再回答此问题。

采纳的回答

Stephen23
Stephen23 2021-8-21
Ran in:
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)
T = 4×4 table
customer location gender sales ______________ __________ __________ _____ {'Customer 1'} {'NY' } {'male' } 10 {'Customer 2'} {'LA' } {'female'} 20 {'Customer 3'} {'Austin'} {'female'} 15 {'Customer 4'} {'LA' } {'female'} 10
S = removevars(T,'customer');
S = groupsummary(S,{'location','gender'},'sum')
S = 3×4 table
location gender GroupCount sum_sales __________ __________ __________ _________ {'Austin'} {'female'} 1 15 {'LA' } {'female'} 2 30 {'NY' } {'male' } 1 10
U = unstack(S,'sum_sales','gender')
U = 3×4 table
location GroupCount female male __________ __________ ______ ____ {'Austin'} 1 15 NaN {'LA' } 2 30 NaN {'NY' } 1 NaN 10
etc.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by