Delete row when one cell is empty

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 comentario

Jan
Jan el 6 de Mayo de 2019
Please post a meaningful example, your code and explain, what "can't seem to get the right result" explicitly means.

Iniciar sesión para comentar.

 Respuesta aceptada

Jan
Jan el 6 de Mayo de 2019
Editada: Jan el 6 de Mayo de 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 comentarios

Pauli
Pauli el 6 de Mayo de 2019
Editada: Pauli el 6 de Mayo de 2019
Sorry, here some more details: I have a double consisting of two rows. In one of those rows I remove all values that are smaller than 0.5 and I want to delete the corresponding values in the other row so that the two columns have the same length again.
Tried using this for the deletion: probs(probs(:,2) < 0.5) = [];
Jan
Jan el 6 de Mayo de 2019
Do you mean:
probs(probs(:,2) < 0.5, :) = [];
% ^
Pauli
Pauli el 6 de Mayo de 2019
Just found the mistake too. Thank you!

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Preguntada:

el 6 de Mayo de 2019

Comentada:

el 6 de Mayo de 2019

Community Treasure Hunt

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

Start Hunting!

Translated by