Borrar filtros
Borrar filtros

How te delete certain coulmns from a table with respect to the header

2 visualizaciones (últimos 30 días)
Mustafa Sobhy
Mustafa Sobhy el 16 de Abr. de 2022
Respondida: Voss el 16 de Abr. de 2022
I need to delete all (AA) columns from a huge table like this
AA B AA B C .. G
1 1 1 1 1 .. 1
3 0 2 5 6 .. 5
4 5 8 9 6 .. 0
0 2 8 8 7 .. 2
Thanks in advance!

Respuestas (1)

Voss
Voss el 16 de Abr. de 2022
I'm unable to create a table with more than one column called 'AA'
AA = [1; 3; 4; 0];
B = [1; 0; 5; 2];
table(AA,B,AA)
ans = 4×3 table
AA B AA_1 __ _ ____ 1 1 1 3 0 3 4 5 4 0 2 0
So I'll assume you have a cell array:
T = {'AA' 'B' 'AA' 'C'; 1 1 1 1; 3 0 2 6; 4 5 8 6; 0 2 8 7}
T = 5×4 cell array
{'AA'} {'B'} {'AA'} {'C'} {[ 1]} {[1]} {[ 1]} {[1]} {[ 3]} {[0]} {[ 2]} {[6]} {[ 4]} {[5]} {[ 8]} {[6]} {[ 0]} {[2]} {[ 8]} {[7]}
% now delete the columns of T whose element in the first row is 'AA':
T(:,strcmp(T(1,:),'AA')) = []
T = 5×2 cell array
{'B'} {'C'} {[1]} {[1]} {[0]} {[6]} {[5]} {[6]} {[2]} {[7]}

Categorías

Más información sobre Logical en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by