Clear Filters
Clear Filters

Compare cell arrays and delete rows

1 view (last 30 days)
I have two cell arrays: JFM06avg(1x2) and JFM06D(88x3). I want to compare the value from the first cell in the first row from the array JFM06avg(9.3576) to the each cell in the second column of the array JFM06D. Then if the value in JFM06D is less than the value of JFM06avg then the row must be deleted.Attached are the two files.
  1 Comment
the cyclist
the cyclist on 5 Jul 2016
Note that JFM06avg is not a cell array. It is numeric. This will matter for the syntax, at least in my solution.

Sign in to comment.

Accepted Answer

the cyclist
the cyclist on 5 Jul 2016
Here is one way:
rowToDelete = [JFM06D{:,2}] < JFM06avg(1);
JFM06D(rowToDelete,:) = [];

More Answers (0)

Categories

Find more on Data Types in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!