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

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

Answer 1

[Cris LaPierre]

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.

[Josh Beaumont]

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]

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.