Remove column in cell data

2 views (last 30 days)
Mohamad Agung Prawira Negara
Commented: jonas on 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 Comments
Mohamad Agung Prawira Negara
Edited: Mohamad Agung Prawira Negara on 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 on 13 Aug 2018
Edited: jonas on 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?

Sign in to comment.

Accepted Answer

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

Sign in to comment.

More Answers (0)

Categories

Find more on Data Types in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!