Working with Excel Tables and Importing them.

1 次查看（过去 30 天）
Minjun Seo
Minjun Seo 2019-8-12
评论： Walter Roberson 2019-8-13
After I import the table from Excel, how can I make a new table with only the names of the columns that you input somewhere?

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

采纳的回答

Walter Roberson
Walter Roberson 2019-8-13
mask = ismember(YourTable.Properties.VariableNames, ListOfColumnsYouWant);
NewTable = YourTable(:,mask);
  2 个评论
Minjun Seo
Minjun Seo 2019-8-13
编辑：Minjun Seo 2019-8-13
Thank you, but If I wanted multiple columns, do I seperate each column with a comma?
Walter Roberson
Walter Roberson 2019-8-13
Here, YourTable stands for the name of your table. Properties and VariableNames are literal things to put in. ListOfColumnsYouWant would be a cell array of character vectors.
>> T = array2table(randi(9,4,3))
T =
4×3 table
Var1 Var2 Var3
____ ____ ____
2 5 8
9 8 9
2 8 5
3 2 7
>> T.Properties.VariableNames
ans =
1×3 cell array
{'Var1'} {'Var2'} {'Var3'}
>> ListOfColumnsYouWant = {'Var3', 'Var1'};
>> mask = ismember(T.Properties.VariableNames, ListOfColumnsYouWant);
>> NewTable = T(:,mask)
NewTable =
4×2 table
Var1 Var3
____ ____
2 8
9 9
2 5
3 7

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by