extracting index number if an item exist in some columns while not in the rest columns

1 次查看（过去 30 天）

显示更早的评论

mirewuti muhetaer 2020-3-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/513243-extracting-index-number-if-an-item-exist-in-some-columns-while-not-in-the-rest-columns

评论： mirewuti muhetaer 2020-3-27

采纳的回答： Akira Agata

Hi,

let us say, i have a data table which has following form:

Index name A1 A2 A3,,,,,A10

and there is an item called David. The interesting things is David is in some of the columns (david is not A1, A2 columns and is in the rest of the columns).

I am interesed in the extracting the index number of david whether is in column or not (if not in the column, may return o or NaN), i tried hard, but could not write the corresponding code, can some one help?

Thanks.

4 个评论
显示 2更早的评论隐藏 2更早的评论

mirewuti muhetaer 2020-3-27

Yes, exactly !!

mirewuti muhetaer 2020-3-27

Hi, @Waler:

it appears at most once in each column.

Thanks.

请先登录，再进行评论。

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

采纳的回答

Akira Agata 2020-3-27

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/513243-extracting-index-number-if-an-item-exist-in-some-columns-while-not-in-the-rest-columns#answer_422264

在 MATLAB Online 中打开

OK. Then, the solution would be like this:

% Sample table
Name = {'David','Bowie','Lynch','Mirewuti','Muhetaer','Akira','Agata'};
rng('default'); % for reproducability
T = table(Name(randperm(7,6))',Name(randperm(7,6))',Name(randperm(7,6))',Name(randperm(7,6))',...
  'VariableNames',{'A1','A2','A3','A4'});
% Find the column which contains 'David'
idx = strcmp(T{:,:},'David');
idx = any(idx);
% Return the column name
colName = T.Properties.VariableNames(idx);

[Sample Table]

>> T

T =

6×4 table

A1 A2 A3 A4

____________ ____________ ____________ ____________

{'Lynch' } {'Akira' } {'Muhetaer'} {'Lynch' }

{'Bowie' } {'Bowie' } {'David' } {'Mirewuti'}

{'Mirewuti'} {'Mirewuti'} {'Bowie' } {'Akira' }

{'David' } {'Muhetaer'} {'Lynch' } {'Agata' }

{'Akira' } {'Lynch' } {'Akira' } {'David' }

{'Agata' } {'Agata' } {'Mirewuti'} {'Muhetaer'}

[Extracted column name]

>> colName

colName =

1×3 cell array

{'A1'} {'A3'} {'A4'}

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

mirewuti muhetaer 2020-3-27

It helps a lot.

Really appreciated !!!

请先登录，再进行评论。

类别

MATLAB Language Fundamentals Matrices and Arrays Matrix Indexing

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

Community Treasure Hunt

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

Start Hunting!

Translated by