selecting specifi sequence of cells from a matrix

Question

ektor 2012-5-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/38250-selecting-specifi-sequence-of-cells-from-a-matrix

Hi, I have the price of one good (chocolate) that varies within one country (Greece) across time by store type, location, brand, pack size and whole market.

Using the following set of commands

%country
country=repmat({'Greece'}, [10,1]);    
%product
prod=repmat({'chocolate'}, [10,1]);      
%whole market
totalall1=repmat({'TTT'}, [5,1]); 
totalall2=repmat({0}, [5,1]);  
Totall=[ totalall1; totalall2];   
   %storetype 
   storetype1=repmat({'ST1'}, [2,1])   ;
   storetype2=repmat({'ST2'}, [2,1])   ;
   storetype3=repmat({'ST3'}, [2,1])   ;
    storetype4=repmat({'ST4'}, [4,1])   ;
    storetype=[storetype1; storetype2;storetype3;storetype4];
    %location
   location1=repmat({'l1'}, [3,1])   ;
   location2=repmat({'l2'}, [3,1])   ;
   location3=repmat({'l3'}, [4,1])   ;
  location=[ location1; location2;location3];
   %brand and pack size
  bsk1=[repmat({'b1' }, [4,1]) repmat({'ps0'  }, [4,1])];
   bsk2=[repmat({'b2' }, [4,1]) repmat({'ps1'  }, [4,1])];
   bsk3=[repmat({'b2' }, [2,1]) repmat({'ps2'  }, [2,1])];
    bb=[bsk1;bsk2;bsk3];
   myvarname = 'four_week';
   eval([sprintf(myvarname) '=[021108  301108  281208  250109 220209  220309  190409  170509  140609  120709]']);
    datemonthyear=four_week';
    price=[1.4; 2;1.3;2.1;4.5;3;1.1;2.4;4;1];
   mdata1  =[  country,prod, Totall,  storetype,  location, bb, num2cell(datemonthyear)  num2cell(price) ];

I create this output

mdata1 = 
    Columns 1 through 6
      'Greece'    'chocolate'    'TTT'    'ST1'    'l1'    'b1'
      'Greece'    'chocolate'    'TTT'    'ST1'    'l1'    'b1'
      'Greece'    'chocolate'    'TTT'    'ST2'    'l1'    'b1'
      'Greece'    'chocolate'    'TTT'    'ST2'    'l2'    'b1'
      'Greece'    'chocolate'    'TTT'    'ST3'    'l2'    'b2'
      'Greece'    'chocolate'    [  0]    'ST3'    'l2'    'b2'
      'Greece'    'chocolate'    [  0]    'ST4'    'l3'    'b2'
      'Greece'    'chocolate'    [  0]    'ST4'    'l3'    'b2'
      'Greece'    'chocolate'    [  0]    'ST4'    'l3'    'b2'
      'Greece'    'chocolate'    [  0]    'ST4'    'l3'    'b2'
    Columns 7 through 9
      'ps0'    [ 21108]    [1.4000]
      'ps0'    [301108]    [     2]
      'ps0'    [281208]    [1.3000]
      'ps0'    [250109]    [2.1000]
      'ps1'    [220209]    [4.5000]
      'ps1'    [220309]    [     3]
      'ps1'    [190409]    [1.1000]
      'ps1'    [170509]    [2.4000]
      'ps2'    [140609]    [     4]
      'ps2'    [120709]    [     1]

My question is the following. I want to develop a simple code that will enable me to find, for example, what the price of chocolate is in Greece when the product type is b1, location is l2, pack size is ps0, store type is st1 for the whole country (TTT). SO, I would like to get immediately the price that corresponds to a specific combination of store type, location, brand, pack size and whole market.

Thank you in advance, Stef

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Oleg Komarov 2012-5-13

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/38250-selecting-specifi-sequence-of-cells-from-a-matrix#answer_47689

在 MATLAB Online 中打开

You might want to consider a relational database management system (RDBMS) such as mySQL. There is a little bit of learning curve but these type of operations are way more intuitive and easy to accomplish than with MATLAB.

Otherwise, what you have to do is:

idx = strcmp(mdata1(:,4),'st1') & strcmp(mdata1(:,6),'b1') & ...
mdata1{idx,end}

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

ektor 2012-5-14

Thank oleg so much. it worked!

I was trying to save the output of mdata1{idx,end} into excel but so far I cant. Any suggestions?

Thank you again!

Stef

请先登录，再进行评论。

Answer 2

ektor 2012-5-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/38250-selecting-specifi-sequence-of-cells-from-a-matrix#answer_47698

It worked. THank you

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 3

ektor 2012-5-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/38250-selecting-specifi-sequence-of-cells-from-a-matrix#answer_47699

Thank oleg so much. it worked! I was trying to save the output of mdata1{idx,end} into excel but so far I cant. Any suggestions?

Thank you again! Stef

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 4

ektor 2012-5-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/38250-selecting-specifi-sequence-of-cells-from-a-matrix#answer_47702

Specifically, I want to save the output of mdata1{idx,end} into excel as well as the corresponding identifiers (that is the columns of store type, location, brand, pack size and whole market that correspond to the output of mdata1{idx,end})