Changing data in excel from NA to a previous number in the column?
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Omar Bayomie
el 12 de Jul. de 2020
Respondida: Chaitanya Mallela
el 16 de Jul. de 2020
I would like to change NA values for tempreature sensors with a previous number in the same column, to make the values consistent. The columns are more than 10000 rows (cells) of reported data, that's why it has to be automated?
0 comentarios
Respuesta aceptada
Chaitanya Mallela
el 16 de Jul. de 2020
T = readtable('filename.csv'); % read the file as table
T = fillmissing(T,'previous'); % fill NaNs with previous values
[r,c] = find(isnan(T{:,:})); % check remaining NaN present as a first value in the columns
if(~(isempty(r) && isempty(c)))
T(r,c) = {0}; % fIll with zeros
end
writetable(T,'filename.csv'); % write the table to file
0 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!