Group data for location

Question

Sarah Yun 2019-12-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/498321-group-data-for-location

评论： Walter Roberson 2019-12-29

采纳的回答： Walter Roberson

在 MATLAB Online 中打开

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2019-12-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/498321-group-data-for-location#answer_408000

编辑：Walter Roberson 2019-12-28

在 MATLAB Online 中打开

group = [ones(size(A,1) + size(B,1),1); 2*ones(size(C,1),1)];

2 个评论
显示无隐藏无

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 2019-12-29

在 MATLAB Online 中打开

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.

请先登录，再进行评论。