Azzera filtri
Azzera filtri

Erase rows of a cell based on a condition

1 visualizzazione (ultimi 30 giorni)
I have a cell array with 20 000 rows (A - numbers are not repeated) and 17 columns (years). In the example below I only present 6 columns and 5 rows.
CA:
A 1997 1999 2000 2001 2002
13 189 189 39 39 39
16 183 183 183 183 183
18 76 76 76 76 28
22 [] [] [] [] 123
25 [] [] [] [] []´
I am trying to erase the rows that do not present at least two consecutive values. And in case the value changes , to get a new variable only with these specific rows.
CA:
A 1997 1999 2000 2001 2002
13 189 189 39 39 39
16 183 183 183 183 183
18 76 76 76 76 28
NEW:
A 1997 1999 2000 2001 2002
13 189 189 39 39 39

Risposta accettata

Azzi Abdelmalek
Azzi Abdelmalek il 19 Lug 2014
Modificato: Azzi Abdelmalek il 19 Lug 2014
To get CA
A ={ ' A' 1997 1999 2000 2001 2002
13 189 189 39 39 39
16 183 183 183 183 183
18 76 76 76 76 28
22 [] [] [] [] 123
25 [] [] [] [] []}
B=A(2:end,:);
idx=~cellfun(@isempty,B)
B(arrayfun(@(x) isempty(strfind(idx(x,:),[1 1])),1:size(idx,1)),:)=[]
CA=[A(1,:) ;B]
It's not clear how did you get NEW
  1 Commento
Maria
Maria il 19 Lug 2014
I am sorry for the late response. 'NEW' is just a new variable I got if I only consider the rows in which I observe a change in the values when passing from column to column. In my example it would be row 1 and 2 only. Thank you for the help.

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Characters and Strings in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by