I need help with converting hourly data to daily summation inside a cell

Question

BN 2021-8-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/898827-i-need-help-with-converting-hourly-data-to-daily-summation-inside-a-cell

评论： BN 2021-8-16

采纳的回答： Yazan

example.mat

在 MATLAB Online 中打开

Dear all,

I have a cell that contains hourly data of precipitation for the period 1987-2016. I want to convert these hourly data to the daily sum. I tried doing this using timetable and then retime,

daily_precip = cellfun(@(x) table2timetable(x,'RowTime','date'), example, 'uniformoutput', false);
output = retime(daily_precip,'daily','sum');

but I got an error.

Error in @(x)table2timetable(x,'RowTime','date')

So how to convert my hourly data to the daily sum for all the three tables inside the cell?

I attached my cell (namely example).

Thank you

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Yazan 2021-8-15

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/898827-i-need-help-with-converting-hourly-data-to-daily-summation-inside-a-cell#answer_767617

编辑：Yazan 2021-8-15

在 MATLAB Online 中打开

Note that the data type in the column date is char, not datetime. Try the following:

clc, clear
load('example.mat');
data = cell(size(example));
for ncell=1:length(example)
    data{ncell} = timetable(datetime(example{ncell}.date, 'Format', 'dd-MMM-yyyy HH:mm:ss'), example{ncell}.precip);
end
daily_precip = cellfun(@(x) retime(x, 'daily', 'sum'), data, 'UniformOutput', false);