How to extract a subtable by rownames?

2 views (last 30 days)
JFz
JFz on 28 Oct 2016
Commented: JFz on 28 Oct 2016
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

Accepted Answer

Steven Lord
Steven Lord on 28 Oct 2016
Modifying the example on this documentation page a bit:
% 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)

Categories

Find more on Cell Arrays in Help Center and File Exchange

Tags

Products

Community Treasure Hunt

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

Start Hunting!