how can I write a function

Question

0 个投票

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

if i have to use this database as cell array and only get the names of male how i do so?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Follow Question

Answer 1

Dave B 2021-11-17

编辑：Dave B 2021-11-17

在 MATLAB Online 中打开

0 个投票

Your data look similar to this (as you've described them):

load patients
data=[{'name'} {'gender'} {'age'}; LastName Gender num2cell(Age)]

You just use strcmp to compare strings, and specify you want the rows where gender contains 'm' and column 1

data(strcmp(data(:,2),'Male'),1) % obviously you'll use 'm' in your case
ans = 47×1 cell array
    {'Smith'    }
    {'Johnson'  }
    {'Wilson'   }
    {'Moore'    }
    {'Jackson'  }
    {'White'    }
    {'Martin'   }
    {'Thompson' }
    {'Martinez' }
    {'Robinson' }
    {'Hall'     }
    {'Hernandez'}
    {'King'     }
    {'Scott'    }
    {'Green'    }
    {'Baker'    }
    {'Nelson'   }
    {'Mitchell' }
    {'Perez'    }
    {'Roberts'  }
    {'Turner'   }
    {'Phillips' }
    {'Parker'   }
    {'Edwards'  }
    {'Collins'  }
    {'Stewart'  }
    {'Reed'     }
    {'Bell'     }
    {'Murphy'   }
    {'Ward'     }

If it were me, I'd put these in a table and use strings, it's so much better!

t=array2table(data(2:end,:),'VariableNames',data(1,:));
t.name=string(t.name);
t.gender=categorical(t.gender);
t.age=cell2mat(t.age);
t.name(t.gender=="Male")
ans = 47×1 string array
    "Smith"
    "Johnson"
    "Wilson"
    "Moore"
    "Jackson"
    "White"
    "Martin"
    "Thompson"
    "Martinez"
    "Robinson"
    "Hall"
    "Hernandez"
    "King"
    "Scott"
    "Green"
    "Baker"
    "Nelson"
    "Mitchell"
    "Perez"
    "Roberts"
    "Turner"
    "Phillips"
    "Parker"
    "Edwards"
    "Collins"
    "Stewart"
    "Reed"
    "Bell"
    "Murphy"
    "Ward"

5 个评论
显示 3更早的评论隐藏 3更早的评论

Dave B 2021-11-17

编辑：Dave B 2021-11-18

在 MATLAB Online 中打开

Re how to generalize, this is why using a table makes more sense, because then you can refer to a variable name instead of a number. However you could look at the first row with the same principal

load patients
data=[{'name'} {'gender'} {'age'}; LastName Gender num2cell(Age)];
col = strcmp(data(1,:),'gender');
data(strcmp(data(:,col),'Male'),1) 
ans = 47×1 cell array
    {'Smith'    }
    {'Johnson'  }
    {'Wilson'   }
    {'Moore'    }
    {'Jackson'  }
    {'White'    }
    {'Martin'   }
    {'Thompson' }
    {'Martinez' }
    {'Robinson' }
    {'Hall'     }
    {'Hernandez'}
    {'King'     }
    {'Scott'    }
    {'Green'    }
    {'Baker'    }
    {'Nelson'   }
    {'Mitchell' }
    {'Perez'    }
    {'Roberts'  }
    {'Turner'   }
    {'Phillips' }
    {'Parker'   }
    {'Edwards'  }
    {'Collins'  }
    {'Stewart'  }
    {'Reed'     }
    {'Bell'     }
    {'Murphy'   }
    {'Ward'     }

Re how to apply to age

this approach won't work, 'age' can't be compared to 30.
strcmp just compares strings, it's not useful for numbers.
=< is not a matlab operation
If age a cell, you'll have to convert it to a matrix, and then it'll be off by one row because of the headings.
Really just use a table, your life will be much easier!

Manav Divekar 2021-11-18

with this code im getting an emply cell.

Dave B 2021-11-18

Sorry i've updated the code, and added a demo (but really my intent ws to give you a strategy you can use rather than to write the code for you).

请先登录，再进行评论。

how can I write a function

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

5 个评论
显示 3更早的评论隐藏 3更早的评论

更多回答（0 个）

类别

产品

版本

标签

Community Treasure Hunt

how can I write a function

0 个评论 显示 -2更早的评论 隐藏 -2更早的评论

采纳的回答

5 个评论 显示 3更早的评论 隐藏 3更早的评论

更多回答（0 个）

类别

产品

版本

标签

另请参阅

Community Treasure Hunt

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

5 个评论
显示 3更早的评论隐藏 3更早的评论