How do replace NaN values and delete full zero's columns from matlab table?
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
ahmed obaid
am 7 Apr. 2017
Beantwortet: Peter Perkins
am 7 Apr. 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 Kommentare
Akzeptierte Antwort
KSSV
am 7 Apr. 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 Kommentare
Weitere Antworten (1)
Peter Perkins
am 7 Apr. 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 Kommentare
Siehe auch
Kategorien
Mehr zu Tables finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!