Table: Add only selected collumns

1 visualizzazione (ultimi 30 giorni)
Nycholas Maia
Nycholas Maia il 8 Gen 2019
Commentato: Nycholas Maia il 8 Gen 2019
% 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?

Risposta accettata

Guillaume
Guillaume il 8 Gen 2019
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
  1 Commento
Nycholas Maia
Nycholas Maia il 8 Gen 2019
Thank you so much Guillaume for your quick response!

Accedi per commentare.

Più risposte (0)

Prodotti


Release

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by