remove nan from table with string and numeric type
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi,
I have data as cell data type like:
'HRD_0085' [ 190.7900]
'HRD_0086' [ 11.6500]
'WAT_0087' [ NaN]
etc.
I was trying to apply formula like below in order to get rid of all rows with nan but it doesnt work:
out = C(any(cellfun(@(x)any(~isnan(x)),C),2),:);
Any clue?
Thanks a lot
0 commentaires
Réponse acceptée
Stephen23
le 12 Juin 2017
C = {
'HRD_0085' [ 190.7900]
'HRD_0086' [ 11.6500]
'WAT_0087' [ NaN]
};
C(~cellfun(@isnan,C(:,2)),:)
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Statistics and Machine Learning Toolbox 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!