How to extract a subtable by rownames?
2 views (last 30 days)
Show older comments
Hi,
I have a table of 10 columns and one column represent last names. I would like to extract all the rows that belong to one last name. How to do that? Thanks in advance.
Jennifer
0 Comments
Accepted Answer
Steven Lord
on 28 Oct 2016
% Make a patients table
load patients
patients = table(Age,Gender,Height,Weight,Smoker,...
'RowNames',LastName);
% Give each patient a random first name
bloggers = {'Cleve'; 'Loren'; 'Guy'; 'Steve'; 'Stuart'; 'Hans'};
n = numel(bloggers);
p = size(patients, 1);
patients.FirstName = bloggers (randi([1 n], p, 1));
% Retrieve all patients named Steve using logical indexing
patientsNamedSteve = patients(strcmp(patients.FirstName, 'Steve'), :);
% There shouldn't be any patients named Aaron; check using logical indexing
patientsNamedAaron = patients(strcmp(patients.FirstName, 'Aaron'), :)
isempty(patientsNamedAaron) % true
More Answers (0)
See Also
Categories
Find more on Cell Arrays in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!