Helping filling missing data with 0 value
显示 更早的评论
Hi everyone,
I have a data in the attachment. The left column represents all days from 1 to 365, but it is missing some values. I want to add missing values in the left column and 0 in the right column coresspondingly. Anyone can give me solutions. Thank you
采纳的回答
David Fletcher
2018-4-9
data=importdata('test.txt')
fullList=[(1:365)' zeros(365,1)];
partList=data(:,1);
isPresent=ismember(fullList,partList);
index=1;
missingVal=0;
for iter=1:365
if isPresent(iter)
fullList(iter,2)=partList(index);
index=index+1;
else
fullList(iter,2)=missingVal;
end
end
2 个评论
Anh Vu
2018-4-10
Razvan Carbunescu
2018-4-11
Can probably make this more compact with indexing
fullData = [(1:365)' zeros(365,1)];
fullData(data(:,1),2) = data(:,2);
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Whos 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
