Group data for location

2 次查看（过去 30 天）
Sarah Yun
Sarah Yun 2019-12-28
评论： Walter Roberson 2019-12-29
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
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
Sarah Yun 2019-12-28
Hello
Is it possible to group by year?
I want to make two groups
First group for years 2000 and 2010
Second group for 2010 to 2015
Can this code do this?
Thank you.
Walter Roberson
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 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by