Remove column in cell data

6 visualizaciones (últimos 30 días)
Mohamad Agung Prawira Negara
Mohamad Agung Prawira Negara el 13 de Ag. de 2018
Comentada: jonas el 13 de Ag. de 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 comentarios
Mohamad Agung Prawira Negara
Mohamad Agung Prawira Negara el 13 de Ag. de 2018
Editada: Mohamad Agung Prawira Negara el 13 de Ag. de 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 el 13 de Ag. de 2018
Editada: jonas el 13 de Ag. de 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?

Iniciar sesión para comentar.

Respuesta aceptada

jonas
jonas el 13 de Ag. de 2018
Editada: jonas el 13 de Ag. de 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 comentarios
Mohamad Agung Prawira Negara
Mohamad Agung Prawira Negara el 13 de Ag. de 2018
Thanks, this one works for me
jonas
jonas el 13 de Ag. de 2018
No problem! It only works for symmetric bounds. Just so you know.

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Operators and Elementary Operations en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by