extract column name of table with Nan column
    7 vues (au cours des 30 derniers jours)
  
       Afficher commentaires plus anciens
    
    joms
 le 17 Mai 2019
  
    
    
    
    
    Réponse apportée : Peter Perkins
    
 le 20 Mai 2019
            How can i return the label name of column with values all Nan
sample1=[1 2 3]';%Sample data
sample2=[4 5 6]';%Sample data
sample3=[7 8 9]';%Sample data
sample4=nan(3,1);%Sample data
patients = table(sample4,sample2,sample3)
sample4    sample2    sample3
    _______    _______    _______
    NaN        4          7      
    NaN        5          8      
    NaN        Nan        9      
output should be 'sample4' as cell array
    NanLabels={'sample4'}
0 commentaires
Réponse acceptée
Plus de réponses (1)
  Peter Perkins
    
 le 20 Mai 2019
        Using {:,:} to convert the entire table to a homogeneous array is perhaps one way to do this, but scales badly very quickly as the table gets big.
allMissing = all(ismissing(patients),1)
gives you a logical vector of variables in the table all of whose values are missing (whether or not they are numeric). Use that as a subscript into patients.Properties.VariableNames.
0 commentaires
Voir également
Catégories
				En savoir plus sur Logical 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!


