Delete row when one cell is empty

7 views (last 30 days)
Pauli
Pauli on 6 May 2019
Commented: Pauli on 6 May 2019
Hi,
I'm trying to delete those rows in an array that contain one empty cell. I have only to columns.
Is there an easy way to do this? I tried using ismissing() with an if statement, but can't seem to get the right result.
Thank you!
  1 Comment
Jan
Jan on 6 May 2019
Please post a meaningful example, your code and explain, what "can't seem to get the right result" explicitly means.

Sign in to comment.

Accepted Answer

Jan
Jan on 6 May 2019
Edited: Jan on 6 May 2019
Perhaps:
C = {'a', 'b'; ...
[], 'c'; ...
'd', 'q'}
m = any(cellfun('isempty', C), 2); % Any cell in row is empty
C(m, :) = []
You wrote "one empty cell". This might mean:
C = {'a', 'b'; ...
{}, 'c'; ...
[], 'q'}
And you want to remove the 2nd row only, because you mean really an empty cell, but not the empty matrix. Maybe you want to keep the row, if it contains 2 empty cell, oder at least one empty array. Please explain this exactly.
  3 Comments
Jan
Jan on 6 May 2019
Do you mean:
probs(probs(:,2) < 0.5, :) = [];
% ^
Pauli
Pauli on 6 May 2019
Just found the mistake too. Thank you!

Sign in to comment.

More Answers (0)

Categories

Find more on Cell Arrays 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!