Creating a new table from values in a table that meet a condition

7 次查看（过去 30 天）
Josh Beaumont
Josh Beaumont 2021-3-9
评论： Cris LaPierre 2021-3-10
Hello,
I currently have a table with different variables. I would like to create a new table from the values in which meet a condition.
For example, there is a table of test scores from a set of students and I want to create a new table with student name and score displayed of those students that scored above a certain mark and discards those that scored below.
How would I go about doing this?
Thanks for your help

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

采纳的回答

Cris LaPierre
Cris LaPierre 2021-3-9
Logical indexing. See Ch 12 of MATLAB Onramp.
If you are actually working with a table and not a matrix, you may find this page helpful as well. The first column indicates what the output datatype will be.
  2 个评论
Josh Beaumont
Josh Beaumont 2021-3-10
Hello,
Thank you for your answer. Is there a way that other columns are kept as well in table form? I have managed to eliminate any data that does not meet the condition but have created an array that has removed all other columns of data. For example, I now have the scores that meet a condition but do not have any data about those scores (names etc)
Thanks for your help
Cris LaPierre
Cris LaPierre 2021-3-10
Of course, but how are you doing your filtering?
I would suggest creating an index for the values you want to keep, then use the linked page to create a table that is a subset of the original table. My answer here may help. It this situation, the data was filtered to only keep a specific time each day.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Downloads 的更多信息

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by