How can one reshape this table?

Question

alpedhuez 2021-7-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/889172-how-can-one-reshape-this-table

编辑： Matt J 2021-7-30

Consider a table T with

group          date        visitor
age 18-24  1/1/2021 10
age 18-24  1/2/2021  20
age 25-34 1/1/2021  10
age 25-34  1/2/2021 30

I want to reshape the matrix as

date   age18-24 age 25-34
1/1/2021   10     10
1/2/2021   20     30

How can one do this?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Matt J 2021-7-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/889172-how-can-one-reshape-this-table#answer_757367

编辑：Matt J 2021-7-30

在 MATLAB Online 中打开

tst.mat

Perhaps as follows?

load tst
T
T = 4×3 table
        group            date        visitor
    _____________    ____________    _______

    {'age 18-24'}    {'1/1/2021'}      10   
    {'age 18-24'}    {'1/2/2021'}      20   
    {'age 25-34'}    {'1/1/2021'}      10   
    {'age 25-34'}    {'1/2/2021'}      30   
[Gage,IDage]=findgroups(T(:,1));
[Gdate,IDdate]=findgroups(T(:,2));
Tnew=[ IDdate, array2table( accumarray([Gdate,Gage],T{:,3}) , 'Var',IDage{:,1})]
Tnew = 2×3 table
        date        age 18-24    age 25-34
    ____________    _________    _________

    {'1/1/2021'}       10           10    
    {'1/2/2021'}       20           30    