How to delete a row of a matrix if value in a particular column is less than a specified value?

40 次查看（过去 30 天）
Bobby Dow
Bobby Dow 2017-2-20
评论： Bobby Dow 2017-2-21
say I have a 3x4 matrix
data = [5 1 200 33; 3 0.5 100 33; 4.5 1.5 150 33]
I want to delete the entire row if the value in 1st column is less than 4.
it should return a 2x4 matrix looking like the following:
datanew = [5 1 200 33; 4.5 1.5 150 33]
I am going to apply this to a much larger matrix, like 10000x4 size, and think a loop is the way to go, but I am unsure on how to go about it.
Thanks Bob

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

采纳的回答

John Chilleri
John Chilleri 2017-2-20
编辑：John Chilleri 2017-2-20
Hello,
You can use this one liner,
datanew = data(data(:,1)>=4,:);
However, I chose to reverse the logic here, so instead of less than 4, you should write greater than or equal to (it's selecting the ones to keep).
Also, the data(:,1) is using the first column (just to be clear).
Hope this helps!

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by