How do replace NaN values and delete full zero's columns from matlab table?
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
ahmed obaid
le 7 Avr 2017
Réponse apportée : Peter Perkins
le 7 Avr 2017
Dear experiences ...
i have a data stored in excel file which contain some empty cells (no values)..
- when i read this data by use read table.. i need to replace first NaN table cells by 0.
- then .. eliminate columns that fully contain 0's values along with header names ..
thanks
0 commentaires
Réponse acceptée
KSSV
le 7 Avr 2017
k = rand(10) ; % some random data
% put some Nan's
k(randsample(1:numel(k),10)) = NaN ;
% make a column zero
k(:,7) = 0 ;
% replace Nan's with zeros
k(isnan(k)) = 0 ;
k=k(:,any(k)) ; % remove columns with zeros
5 commentaires
Plus de réponses (1)
Peter Perkins
le 7 Avr 2017
It seems like you're going against the grain here. There are tools to identify and remove missing values, but they mostly work with NaN as the flag for that. It sounds like maybe you have other zeros in the data that you want to preserve? Still, it seems like you're trying to use 0 as the flag for a missing value, and that's going to be more awkward than using the standard thing.
In recent versions of MATLAB, you can use rmmissing to find and remove variables in a table based on various criteria. But it's looking for NaN. You can replace 0's in your table with NaNs, using standardizeMissing, and then use rmmissing.
You could use varfun like this (this assumes all the variables in t are numeric, easy to change if that's not true):
t = varfun(@(x) x(isnan(x)) = 0, t);
allZero = varfun(@(x)all(x==0), t, 'UniformOutput', true);
t = t(:,~allZero);
0 commentaires
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!