Delete row in matrix and move

2 次查看(过去 30 天)
Hi, I have Matrix [500000 rows x 3 columns]. In 3 columns are data from -1100 to +1000. I want delete a row if in 3 columns data are < -900. Next I'd like to move another rows in a place of deleted column and wrie as a new matrix. For example:
A=[20 30 40; 20 40 -930; 30 40 600];
In the 2nd row in 3d column is -930. I'd like to have
B=[20 30 40; 30 40 600];
Thanks for your help

采纳的回答

KALYAN ACHARJYA
KALYAN ACHARJYA 2018-8-2
编辑:KALYAN ACHARJYA 2018-8-2
Let assume matrix M, It deletes the rows having element less than -900
M(M(:, 3)<-900, :)=[]

更多回答(1 个)

Jitender Gangwar
Jitender Gangwar 2018-8-2
Hello Sebastian,
I understand you want to remove the rows containing values less than -900. I believe this can be achieved by using the 'find' function.
Hereby is an illustrative code for your reference:
A = [20 30 40; 20 40 -930; 30 40 600];
[r, c] = find(A < -900);
A(r, :) = [];
I hope this answers your query.

类别

Help CenterFile Exchange 中查找有关 Introduction to Installation and Licensing 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by