Delete rows from a cell given a specific condition - Matlab

1 次查看（过去 30 天）

Maria 2014-6-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/137563-delete-rows-from-a-cell-given-a-specific-condition-matlab

评论： Maria 2014-6-25

I have a cell type big-variable sorted out by FIRM (A(:,2)) and I want to erase all the rows in which the same firm doesn’t appear at least 5 times in a row. In this example, A:

                FIRM 
'ABDR'  0,56  464  1641  19970224
'ABDR'  0,65  229  9208  19970424
'ABDR'  0,55  125  31867  19970218
'ABDR'  0,53  31  33103  19970206
'ABDR'  0,70  464  46008  19971023
'ABD'  0,06  435  8077  19970311
'ABD'  0,00  1503  44994  19970804
'ABFI'  2,07  1549  46532  19971209

I would like to get, A:

'ABDR'  0,56  464  1641  19970224
'ABDR'  0,65  229  9208  19970424
'ABDR'  0,55  125  31867  19970218
'ABDR'  0,53  31  33103  19970206
'ABDR'  0,70  464  46008  19971023

Can someone help me please? Thanks a lot.

采纳的回答

dpb 2014-6-25

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/137563-delete-rows-from-a-cell-given-a-specific-condition-matlab#answer_142434

在 MATLAB Online 中打开

Working just with the alpha column,

>> c={'ABDR';'ABDR';'ABDR';'ABDR';'ABDR';'ABD';'ABD';'ABFI'};
>> [u,~,i2]=unique(c);
>> [n,bin]=histc(i2,1:length(u));
>> c(bin==find(n>=5))
ans = 
  'ABDR'
  'ABDR'
  'ABDR'
  'ABDR'
  'ABDR'
>>

5 个评论
显示 3更早的评论隐藏 3更早的评论

dpb 2014-6-25

Yes, it is not working!

Well, need to see what isn't working and what the problem(s) are...can't see your terminal from here, unfortunately.

Maria 2014-6-25

I am sorry. I didn't mean to say 'it's not working!' the way it sounded. I am working on the code, I will let you know if I have any problem, or doubt and in case I do, I will clearly present my doubts. Thank you :)

请先登录，再进行评论。