How do replace NaN values and delete full zero's columns from matlab table?
6 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
ahmed obaid
el 7 de Abr. de 2017
Respondida: Peter Perkins
el 7 de Abr. de 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 comentarios
Respuesta aceptada
KSSV
el 7 de Abr. de 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 comentarios
Más respuestas (1)
Peter Perkins
el 7 de Abr. de 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 comentarios
Ver también
Categorías
Más información sobre Tables en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!