Group data for location
1 次查看(过去 30 天)
显示 更早的评论
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
0 个评论
采纳的回答
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 个评论
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 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!