Group data for location
显示 更早的评论
Hello,
I have sales data column for 3 indepedent stores, A, B and C, in 3 seperate tables
I want to merge table A and B and test if there is difference between this group and store C
So, store A + B against C
tableA
tableB
tableC
% Concatenate columns vertically
x = [A;B;C];
% the tables do not have equal rows,
% therefore must concatenate them into a single column and use a grouping variable
% How should I change next line to make group A+B and single group C
group = [1 + zeros(size(A)); 2 + zeros(size(B)); 3 + zeros(size(C))];
% How should I change next line to make group A+B and single group C?
Thank you
采纳的回答
Walter Roberson
2019-12-28
编辑：Walter Roberson
2019-12-28
group = [ones(size(A,1) + size(B,1),1); 2*ones(size(C,1),1)];
2 个评论
Sarah Yun
2019-12-28
Walter Roberson
2019-12-29
group = (x.Year < 2010) + 1;
However you need to resolve the question of whether year 2010 is first group or second group.
Here, x represents the [A;B;C] combined table you made. x.Year assumes that there is a variable in the table named Year; if not then use an appropriate expression to extract the year from what you do have.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
