transform data from hourly to quarter hourly

5 次查看（过去 30 天）

显示更早的评论

Giuseppe D'Amico 2020-12-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/694345-transform-data-from-hourly-to-quarter-hourly

评论： Daniel Pollard 2020-12-17

采纳的回答： Daniel Pollard

example.xlsx

Hi everyone, I kindly ask you for help for a problem that I am facing, basically I have hourly data of active power produced by photovoltaic systems.

I would like to broaden the resolution of this data, transforming it from hourly to quarter hourly with some sort of fitting or interpolation.

How can it be done? is there any function on matlab that can help me?

Here is an example excel file.

Thanks in advance for your help.

4 个评论
显示 2更早的评论隐藏 2更早的评论

VBBV 2020-12-15

https://in.mathworks.com/help/matlab/timetables.html

Giuseppe D'Amico 2020-12-16

but what timestep should I write to have them in the quarter hour? and what interpolation method should I use?

请先登录，再进行评论。

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

采纳的回答

Daniel Pollard 2020-12-15

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/694345-transform-data-from-hourly-to-quarter-hourly#answer_575995

https://uk.mathworks.com/help/matlab/ref/interp1.html

The vector x can be datetime values.

7 个评论
显示 5更早的评论隐藏 5更早的评论

Giuseppe D'Amico 2020-12-16

hello, sorry I managed to solve.

Thank you very much, especially for your patience.

Daniel Pollard 2020-12-17

Excellent, I'm glad you managed to get it working. If you could accept the answer so other users know what helped solve your problem that would be great.

请先登录，再进行评论。

更多回答（0 个）

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

类别

MATLAB Language Fundamentals Data Types Dates and Time

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Translated by