Remove column in cell data

6 Ansichten (letzte 30 Tage)
Mohamad Agung Prawira Negara
Kommentiert: jonas am 13 Aug. 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 Kommentare
Mohamad Agung Prawira Negara
Bearbeitet: Mohamad Agung Prawira Negara am 13 Aug. 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 am 13 Aug. 2018
Bearbeitet: jonas am 13 Aug. 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?

Melden Sie sich an, um zu kommentieren.

Akzeptierte Antwort

jonas
jonas am 13 Aug. 2018
Bearbeitet: jonas am 13 Aug. 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 Kommentare
Mohamad Agung Prawira Negara
Thanks, this one works for me
jonas
jonas am 13 Aug. 2018
No problem! It only works for symmetric bounds. Just so you know.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Operators and Elementary Operations finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by