Table: Add only selected collumns

Question

Nycholas Maia 2019-1-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/438785-table-add-only-selected-collumns

评论： Nycholas Maia 2019-1-8

% Set a dummy array content:
name = {'Joe'; 'Elisa'; 'John'};
age = [30; 10; 25];
weigth = [100; 150; 180];
% Set 'select_collumns' array:
% The index (1) reference to 'name' array
% The index (2) reference to 'age' array
% The index (3) reference to 'weigth' array
selected = [1, 0, 1];
% Create a table with only select collumns: (1) Name and (3) Weigth:
How could I do it?
% Exemple:
table(name, weigth);

The main ideia is pass a 'select array' that will produce a table with only the select collumns.

How can I do it?

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

请先登录，再进行评论。

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

Answer 1

Guillaume 2019-1-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/438785-table-add-only-selected-collumns#answer_355518

在 MATLAB Online 中打开

1. Create the full table first, however you were going to create it:

name = {'Joe'; 'Elisa'; 'John'};
age = [30; 10; 25];
weigth = [100; 150; 180];       %note that weigth is mispelled, should be weight
t = table(name, age, weight)

2. use logical indexing to select the columns you want:

selected = [1, 0, 1];
selected = logical(selected); 
%or create it directly as logical:
%selected = [true, false, true];
filteredtable = t(:, selected)  %only keep selected columns