transform data from hourly to quarter hourly

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.

[VBBV]

Use timetable and retime functions

[Giuseppe D'Amico]

how should i write the function to get quarter hourly data?

[VBBV]

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

[Giuseppe D'Amico]

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

Answer 1

[Daniel Pollard]

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

The vector x can be datetime values.

[Giuseppe D'Amico]

would you give me an example of how to use it?

[Daniel Pollard]

The documentation that I linked to contains numerous examples, including some which I think are directly applicable to your situation. What more example do you need?

[Giuseppe D'Amico]

I'm trying but it always gives me a mistake and I don't understand what I'm wrong

[Daniel Pollard]

Usually the error messages are useful. What exactly does it say?

[Giuseppe D'Amico]

noy enough input argument.

[Giuseppe D'Amico]

hello, sorry I managed to solve.

Thank you very much, especially for your patience.

[Daniel Pollard]

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.