MATLAB: How to display a certain range of rows from a sorted column based on a particular column value in matlab

A=
name age gender
larry 4 M
roy 6 M
jim 6 F
tom 8 M
kim 9 F

now i want to display students who are 6 years old

Best Answer

 A(A.age==6,:)

Related Solutions

MATLAB: Convert matrix to vector of structs

Here's the solution I ultimately used and prefer, where "M" is a real matrix:

data = struct( 'id', M(:,11), ... 
               'PSAtests', M(:,1), ... 
               'PSAestimate', M(:,3), ... 
               'PSA', M(:,10), ... 
               'isActual', 1-M(:,4), ... 
               'age', M(:,5), ... 
               'cancer', M(:,6), ... 
               'cancerAge', M(:,7), ... 
               'biopsy', M(:,8), ... 
               'biopsyAge', M(:,9) );

Then, if I wish to modify "data", I use the function "subsetstruct" which is part of Matlog, provided at the following URL:

http://www.ise.ncsu.edu/kay/matlog/MatlogRef.htm#subsetstruct

To use "subsetstruct", I simply create a logical index array and can create a new struct which is a subset of my "data" struct, for example:

olderpatients = subsetstruct(data,data.age>80);

I'm very happy with this solution. And thanks for everyone's help.

MATLAB: Find matched string in table

Compare the text data stored in the table with a string array. Let's build a sample using the example from the documentation for the table function.

load patients
patients = table(LastName,Gender,Age,Height,Weight,Smoker,Systolic,Diastolic);

Let's extract patients under 40, separated by gender.

malePatientsUnder40 = patients(patients.Gender == "Male" & patients.Age < 40, :)
femalePatientsUnder40 = patients(patients.Gender == "Female" & patients.Age < 40, :)

Let's check against the full list of patients under 40.

patientsUnder40 = patients(patients.Age < 40, :);

Combine the male and female patients into one larger table and compare it against the full list.

isequal(sortrows([malePatientsUnder40; femalePatientsUnder40]), sortrows(patientsUnder40))

Best Answer

Related Solutions

MATLAB: Convert matrix to vector of structs

MATLAB: Find matched string in table

Related Question