MATLAB Answers

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

1 ビュー (過去 30 日間)
alpedhuez
alpedhuez 2021 年 8 月 21 日
コメント済み: alpedhuez 2021 年 8 月 23 日
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?

採用された回答

Stephen
Stephen 2021 年 8 月 21 日
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.
  1 件のコメント
alpedhuez
alpedhuez 2021 年 8 月 23 日
Thank you. Let me work on it.

サインインしてコメントする。

その他の回答 (0 件)

タグ

製品


リリース

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by