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

Answer 1

[David Fletcher]

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

[Anh Vu]

Thank you so much

[Razvan Carbunescu]

Can probably make this more compact with indexing

fullData = [(1:365)' zeros(365,1)];
fullData(data(:,1),2) = data(:,2);