Changing data in excel from NA to a previous number in the column?
2 views (last 30 days)
Show older comments
Omar Bayomie
on 12 Jul 2020
Answered: Chaitanya Mallela
on 16 Jul 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 Comments
Accepted Answer
Chaitanya Mallela
on 16 Jul 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 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!