Clear Filters
Clear Filters

How to find a special numbers among time series data

2 views (last 30 days)
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

Answers (1)

Hikaru
Hikaru on 12 Aug 2015
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

Categories

Find more on Dates and Time in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!