how to exclude a row based on a column value?

5 次查看(过去 30 天)
Dear All, I have a matrix called M, composed of 15 columns and 100000 rows, the third column supposed to be the month so the values in it must be from 1 to 12, how can i check if there is a value out of this range in this column, for example 13 or 0 or any thing not between 1 and 12? and after that delete the row that carries this error number?

采纳的回答

Star Strider
Star Strider 2018-2-13
Try this:
M_edited = M((M(:,3)>=1) & (M(:,3)<=12), :);
It assigns only the rows in ‘M’ with months from 1 to 12 in ‘M_edited’. The others are not copied to it.
  8 个评论

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by