remove rows if they contain ?

1 visualización (últimos 30 días)
Catherine Branter
Catherine Branter el 23 de Feb. de 2019
Editada: Image Analyst el 23 de Feb. de 2019
I want to remove all rows that contain ?
The issue is that ? could be in any of my 14 columns
I tried this code ("data" is the name of my table here)
data(ismember(data,'?'),:)=[];
but i get the error
Error using tabular/ismember (line 37)
A and B must both be tables, or both be timetables.
  1 comentario
madhan ravi
madhan ravi el 23 de Feb. de 2019
upload your table as .mat file

Iniciar sesión para comentar.

Respuestas (1)

Image Analyst
Image Analyst el 23 de Feb. de 2019
Editada: Image Analyst el 23 de Feb. de 2019
This works:
column1 = {'a'; 'b'; '?'; 'c'; 'd'}
column2 = {'a'; '?'; 'x'; 'c'; 'd'}
data = table(column1, column2)
% Now that we have sample data, delete any column with a '?' in it.
rowsToDelete = any(contains(data{:, :} , '?'), 2)
data(rowsToDelete, :) = []

Categorías

Más información sobre Tables en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by