Find column names with particular names in MATLAB table
34 ビュー (過去 30 日間)
表示 古いコメント
Hi there,
I have a massive table with 408 columns in MATLAB. I want to get rid of columns that start with the word "connected". Instead of having to manually check the table and do something like
finalnbs(:,212:364) = [];
Where
finalnbs
is the table, how do I find all columns in finalnbs which start with connected e.g.
connected*
And then remove those?
1 件のコメント
採用された回答
Walter Roberson
2015 年 12 月 21 日
finalnbs(:,strncmp(finalnbs.Properties.VariableNames, 'connected', length('connected')) ) = [];
0 件のコメント
その他の回答 (2 件)
Renato Agurto
2015 年 12 月 21 日
編集済み: Renato Agurto
2015 年 12 月 21 日
Hello
if "titles" is the first row of your table, then:
titles = finalnbs(1,:);
%Select the columns that should stay
idxs = cellfun(@(x) length(x) < 9 || ~strcmp(x(1:9),'connected'),titles);
finalnbs = finalnbs(:,idxs);
0 件のコメント
Joseba Moreno
2019 年 2 月 14 日
Hello,
I have a similar problem but in my case I would like to remove the columns which contain the word "free".
How can I do that?
Thanks!
Joseba
2 件のコメント
参考
カテゴリ
Find more on Matrices and Arrays in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!