Changing data in excel from NA to a previous number in the column?
    4 次查看(过去 30 天)
  
       显示 更早的评论
    
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 个评论
采纳的回答
  Chaitanya Mallela
    
 2020-7-16
        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 个评论
更多回答(0 个)
另请参阅
类别
				在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
			
	Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!

