Append column given a 'year' condition

2 Ansichten (letzte 30 Tage)
Maria
Maria am 2 Sep. 2014
Kommentiert: Maria am 2 Sep. 2014
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.
  2 Kommentare
José-Luis
José-Luis am 2 Sep. 2014
Is A a cell array?
Maria
Maria am 2 Sep. 2014
yes.

Melden Sie sich an, um zu kommentieren.

Melden Sie sich an, um diese Frage zu beantworten.

Akzeptierte Antwort

Guillaume
Guillaume am 2 Sep. 2014
Bearbeitet: Guillaume am 2 Sep. 2014
A(:, end+1) = num2cell([A{:, 2}] >= 2000);
  2 Kommentare
Guillaume
Guillaume am 2 Sep. 2014
However, if you only have numbers in your cell array, why aren't you using a matrix? It makes manipulation much easier
A = cell2mat(A);
A(:, end+1) = A(:, 2) >= 2000;
Maria
Maria am 2 Sep. 2014
you are right. Thanks

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (1)

José-Luis
José-Luis am 2 Sep. 2014
A = num2cell(1995 + randi(10,[20 1]));
A(:,end+1) = num2cell( cell2mat(A) >= 2000)

Kategorien

Mehr zu Data Type Conversion finden Sie in Help Center und File Exchange

Tags

Produkte

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by