Group data for location
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Sarah Yun
am 28 Dez. 2019
Kommentiert: Walter Roberson
am 29 Dez. 2019
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 Kommentare
Akzeptierte Antwort
Walter Roberson
am 28 Dez. 2019
Bearbeitet: Walter Roberson
am 28 Dez. 2019
group = [ones(size(A,1) + size(B,1),1); 2*ones(size(C,1),1)];
2 Kommentare
Walter Roberson
am 29 Dez. 2019
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.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Tables finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!