试用软件

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

2 次查看（过去 30 天）

显示更早的评论

Mustafa Sobhy 2022-4-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1698325-how-te-delete-certain-coulmns-from-a-table-with-respect-to-the-header

回答： Voss 2022-4-16

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!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Voss 2022-4-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1698325-how-te-delete-certain-coulmns-from-a-table-with-respect-to-the-header#answer_944405

在 MATLAB Online 中打开

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]}

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

类别

MATLAB Language Fundamentals Data Types Numeric Types Logical

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品

MATLAB

版本

R2021a

Community Treasure Hunt

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

Translated by

试用软件