remove rows if they contain ?

7 vues (au cours des 30 derniers jours)
Catherine Branter
Catherine Branter le 23 Fév 2019
Modifié(e) : Image Analyst le 23 Fév 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 commentaire
madhan ravi
madhan ravi le 23 Fév 2019
upload your table as .mat file

Connectez-vous pour commenter.

Réponses (1)

Image Analyst
Image Analyst le 23 Fév 2019
Modifié(e) : Image Analyst le 23 Fév 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, :) = []

Catégories

En savoir plus sur Tables dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by