Assign values to numbers and recount after a fixed interval

Question

Hammad Khan 2020-2-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/506150-assign-values-to-numbers-and-recount-after-a-fixed-interval

回答： Steven Lord 2020-2-18

Hi.I have to assign number values to each day's each hour's precipitaton values. (starting from 1,end at 730 as the data is for two years). I want that the when the next day's 12:00am strikes it restarts counting from 2. e.g. And then when next year's date and time occur, it again gets a value of 1. Basically the values should be independent of the year.

Date Time Precipitation Values

1-1-1987 00:00 19 1

1-1-1987 01:00 19.2 1

.

1-1-1987 23:00 20 1

2-1-1987 00:00 25 2

.

12-31-1987 22:00 0.2 365

12-31-1987 23:00 0.4 365

.

1-1-1988 00:00 1.2 1

1-1-1988 01:00 3.4 1

Can anyone guide how to do this using loops?

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

Stephen23 2020-2-18

Just add one to the 'Time' value.

请先登录，再进行评论。

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

Answer 1

Murugan C 2020-2-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/506150-assign-values-to-numbers-and-recount-after-a-fixed-interval#answer_416152

在 MATLAB Online 中打开

consider excel as my input.

[numdata, textdata, rawdata] = xlsread('Test_data.xlsx');
timecolomn = (datestr( numdata(:,1), 'HH:MM' ));
for i = 1 : length(timecolomn)
    g = strsplit(timecolomn(i,:),':');
    if str2double(g{2}) == 0
        value1{i} = str2double(g{1});       
    end
end
value_row = ['Values'; value1'];
rawdata = [rawdata value_row];
xlswrite('AddedValue.xlsx', rawdata)