清空筛选条件
清空筛选条件

How do i remove rows from a column based on the value of a corresponding column?

14 次查看（过去 30 天）
Tom Wetherill
Tom Wetherill 2013-3-28
I have a large amount of data that i need to process with Matlab but am quite a novice so unfamiliar with all but the basics. I effectively have a large data file containing thousands of entries and i need to know how i can remove a number of specific rows depending on the corresponding value if that makes any sense at all.
Column A is made up of depth values that range from .0000 to 2000.0000m and column B contains salinity values corresponding with each of these depths for a number of stations over a number of years. I want to find if i can remove all values from column B that correspond with values in column A that are less then or equal to 120.0000m.
If(A<=120.0000 then delete B)
I tried to convey this as best as i could in the expression above but don't know where to start with actual equations so any help would be much appreciated.

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

采纳的回答

Wayne King
Wayne King 2013-3-28
编辑：Wayne King 2013-3-28
Assume X is your data matrix,
Xnew = X(X(:,1)>120,:);
So for example:
X = randi(10,10,2);
Xnew = X(X(:,1)>6,:);
I'm assuming that by column A you mean the 1st column of the matrix.

更多回答（1 个）

Mahdi
Mahdi 2013-3-28
编辑：Mahdi 2013-3-28
Remove=find(A<=120.0000);
B(Remove)=[];
If you also want to remove these values from matrix A, then
A(Remove)=[];

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by