what changes are required in the code?

i have a data base with name gender and age not necessarily in the same order, some data base is gender name age. for example
'name' 'gender' 'age'
'mary' 'f' 25
'john' 'm' 35
'anna' 'f' 30
'paul' 'm' 22
'elaina' 'f' 38
what changes is required in the code so that i can only display femate above age of 30 and less that 40
function [patient] = filterpatients_cell(data)
colage = data(strcmp(data(1,:),'age'),1);
if colage == 30 && colage <= 40
col = strcmp(data(1,:),'gender');
out = data(strcmp(data(:,col),'f'),1);
end
patient = out;

 Accepted Answer

A table would be good to deal with.
name = {'mary','john','anna','paul','elaina'}' ;
gender = {'f', 'm', 'f', 'm', 'f'}' ;
age = [25, 35, 30, 22, 38]' ;
T = table(name,gender,age)
T = 5×3 table
name gender age __________ ______ ___ {'mary' } {'f'} 25 {'john' } {'m'} 35 {'anna' } {'f'} 30 {'paul' } {'m'} 22 {'elaina'} {'f'} 38
% Get females
idx = strcmp(T.gender,'f') ;
% GEt age
T1 = T(idx,:) ;
idx = T1.age >= 30 & T1.age <= 40 ;
T2 = T1(idx,:)
T2 = 2×3 table
name gender age __________ ______ ___ {'anna' } {'f'} 30 {'elaina'} {'f'} 38

3 Comments

is it possible with cell array? instead of table as i would like to only display the names at the end. and don't want to manually enter the input as given value is a small part of the database.
It is possible with cell array. Other question is not clear.
Can you explain how it is possible using cell array?

Sign in to comment.

More Answers (0)

Categories

Products

Release

R2021b

Tags

Asked:

on 18 Nov 2021

Commented:

on 18 Nov 2021

Community Treasure Hunt

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

Start Hunting!