Helping filling missing data with 0 value

2 次查看（过去 30 天）
Anh Vu
Anh Vu 2018-4-9
评论： Razvan Carbunescu 2018-4-11
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
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 个评论
Razvan Carbunescu
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Matrix Indexing 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by