Find column names with particular names in MATLAB table

5 次查看（过去 30 天）
Dhruv Ghulati
Dhruv Ghulati 2015-12-21
评论： Peter Perkins 2019-2-17
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?

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

采纳的回答

Walter Roberson
Walter Roberson 2015-12-21
finalnbs(:,strncmp(finalnbs.Properties.VariableNames, 'connected', length('connected')) ) = [];

更多回答（2 个）

Renato Agurto
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);
Joseba Moreno
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

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by