How to find a special numbers among time series data

Hi,

I have hourly data in seconds in one column and in the other worksheet I have specific time values with an amount, I want to assign the specific values from "special time-values" worksheet to the "time-second" worksheet and impose 0 value for the other time-seconds that they don't have value. I attached excel file here.

How is it possible to write a code in matlab?

Hope to hear from you. Sepideh

[Azzi Abdelmalek]

This is not clear

Answer 1

[Hikaru]

There might be a more efficient way to do this. But, the code below should work.

timesecond = xlsread('time.xlsx'); % reads the first sheet
special = xlsread('time.xlsx','special time-values'); % reads the second sheet, 2-column variable

c = 0;
for ii = 1:length(special)
    ind = find(special(ii,1)==timesecond);
    c = [c;ind];
end

c(1)=[];
tvalue = zeros(length(timesecond),1);

for jj = 1:length(special)
    tvalue(c(jj)) = special(jj,2);
end