Append new column considering the distribution of the elemnts in a column

Question

Maria 2014-8-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/151358-append-new-column-considering-the-distribution-of-the-elemnts-in-a-column

评论： Maria 2014-8-18

I have a cell type variable with 20000 rows and 9 columns. For example:

                          c3 
  A={ 4197  0  53,0  15  28  254  90202  1996 0
      4207  0  45,1  11  62  1762  80402  1996 0
      4215  0  15,4  10  49  279  100301  1996 1
      4220  0  51,4  7  54  308  80402  1996 0
      4221  0  7,6  19  69  100  60110  1996 1

Considering c3, I previously appended a new column to variable A that has the value of 1 if the value in c3 corresponds to the bottom 5th percentile of all the values in c3 and zero otherwise. I am now trying to append another column that has the value of 1 if the value in c3 is in between the 5th to 10th percentile of all the values in c3 and zero otherwise. I tried to apply the previuos code I used by adding the condition 'greater than' (<):

p10Val1 = prctile( [A{:,3}], [10] );
A(:,end+1) = {0}
A(p5Val1< [A{:,3}] <= p10Val1, end ) = {1}

But it is not working.

Can someone help? Thank you.

2 个评论
显示无隐藏无

Adam 2014-8-18

Please try to use . rather than , in pasting data like that in future. It isn't a big issue, it is just that little bit easier for someone to help you if they can just paste straight from your question into Matlab!

Maria 2014-8-18