How to find a special numbers among time series data

Question

SEPIDEH 2015-8-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/233216-how-to-find-a-special-numbers-among-time-series-data

回答： Hikaru 2015-8-12

time.xlsx

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Azzi Abdelmalek 2015-8-11

This is not clear

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Hikaru 2015-8-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/233216-how-to-find-a-special-numbers-among-time-series-data#answer_189050

在 MATLAB Online 中打开

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