Remove column in cell data

6 visualizzazioni (ultimi 30 giorni)
Mohamad Agung Prawira Negara
Commentato: jonas il 13 Ago 2018
I have a cell such as
C={};
C{1,1}='A';
C{1,2}='B';
C{1,3}='C';
C{2,1}=[1 0 1;0 0 1;2 1 -1];
C{2,2}=[1 2 -1;-1 0 1;0 1 -1];
C{2,3}=[1 0 -1;-1 0 1;-1 1 -1];
C{3,1}=5/9;
C{3,2}=2/9;
C{3,3}=-1/9;
C =
3×3 cell array
{'A' } {'B' } {'C' }
{3×3 double} {3×3 double} {3×3 double}
{[ 0.5556]} {[ 0.2222]} {[ -0.1111]}
I want to remove a column which have the value -1<=x>=1 in all of the elements in the matrix at the second row. Such that
C =
3×2 cell array
{'A' } {'B' }
{3×3 double} {3×3 double}
{[ 0.5556]} {[ 0.2222]}
  4 Commenti
Mohamad Agung Prawira Negara
Modificato: Mohamad Agung Prawira Negara il 13 Ago 2018
What I mean is that all elements of 3x3 arrays (all 9 elements is -1<=x<=1). As for C{2,2}, it has 2 in one of the elements.
jonas
jonas il 13 Ago 2018
Modificato: jonas il 13 Ago 2018
So what you mean is that you want to keep columns where at least one element (out of 9) lies outside of the specified bounds?

Accedi per commentare.

Risposta accettata

jonas
jonas il 13 Ago 2018
Modificato: jonas il 13 Ago 2018
Try this
B=cellfun(@(x) sum(sum(abs(x)>1)),C(2,:),'uniformoutput',false)
B=cell2mat(B);
C(:,B<1)=[]
C =
3×2 cell array
{'A' } {'B' }
{3×3 double} {3×3 double}
{[ 0.5556]} {[ 0.2222]}
  2 Commenti
Mohamad Agung Prawira Negara
Thanks, this one works for me
jonas
jonas il 13 Ago 2018
No problem! It only works for symmetric bounds. Just so you know.

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Operators and Elementary Operations 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