Append column given a 'year' condition
    조회 수: 4 (최근 30일)
  
       이전 댓글 표시
    
I have a cell type variable A with 30000 rows and 29 columns, for example:
    b1  *b2*      b3      b4      b5      b6      b7 ...     
 A={7  1999  28,14  1388  33  78  39021
    8  2002  44,44  150  4  56  60012
    12  2002  54,46  100  21  49  40701
    13  1998  46,41  189  22  44  30901...}.
Column b2 gives different years. I am trying to a ppend a new column that, for example, gives 1 if the year in b2 is after 2000 and 0 if the year in b2 is before 2000 . For instance in this example I would get:
    b1  *b2*      b3      b4      b5      b6      b7 ...  b30    
  A={7  1999  28,14  1388  33  78  39021      0
     8  2002  44,44  150  4  56  60012      1
     12  2002  54,46  100  21  49  40701      1
     13  1998  46,41  189  22  44  30901...   0}.
Can someone help me please? Thank you.
채택된 답변
추가 답변 (1개)
  José-Luis
      
 2014년 9월 2일
        A = num2cell(1995 + randi(10,[20 1]));
A(:,end+1) = num2cell( cell2mat(A) >= 2000)
댓글 수: 0
참고 항목
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!

