Get new variable if a cell in a column changes - Matlab

1 次查看（过去 30 天）

Maria 2014-6-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/137590-get-new-variable-if-a-cell-in-a-column-changes-matlab

评论： Azzi Abdelmalek 2014-6-26

I have a cell-type variable X and I would like to have variable X separated in different variables for each different Firm (X(:,1). Meaning, everytime Firm name changes I get a new variable. Example:

Firm 
'ABC'  0,5  46  19970224
'ABC'  0,6  29  19970424
'EFD'  0,5  145  19970218
'EFD'  0,5  36  19970206
'GHI'  0,7  9  19971023
'LMN'  0,2  735  19970311

I would like to get:

 X1:
 'ABC'  0,5  46  19970224
 'ABC'  0,6  29  19970424
X2:
 'EFD'  0,5  145  19970218
 'EFD'  0,5  36  19970206
X3:
'GHI'  0,7  9  19971023
X4: 
'LMN'  0,2  735  19970311

Can anyone help? Considering my variable type is 'cell', with both strings and numbers.

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

请先登录，再进行评论。

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

采纳的回答

Azzi Abdelmalek 2014-6-25

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/137590-get-new-variable-if-a-cell-in-a-column-changes-matlab#answer_142463

在 MATLAB Online 中打开

firm={'ABC'  0,5  46  19970224
'ABC'  0,6  29  19970424
'EFD'  0,5  145  19970218
'EFD'  0,5  36  19970206
'GHI'  0,7  9  19971023
'LMN'  0,2  735  19970311}
[a,b,c]=unique(firm(:,1))
out=accumarray(c,(1:numel(c))',[],@(x) {firm(x,:)})
out{1}
out{2}
out{3}
out{4}