How to convert 15minute data to hourly data

Hi , I have 15 minute power output data for a Pv powerplant over a year. I would like to convert it into hourly data. I imported the raw data through an excel file into the matlab live script. now I am unsure how to combine the values

Answer 1

[Lucien Hollins]

Hi I understand you would like to learn about managing table data. Please refer to this documentation to learn the basics of dealing with tables:

Create and Work with Tables - MATLAB & Simulink (mathworks.com)

I believe for your specific case, you would like to extract every fourth value. To do this, you can try the following command:

Reduceddata = Rawmasterdata(1:4:end,:);

This will generate a new variable called Reduceddata that begins at your first data point and includes every fourth point afterwards. If you would like to start at a different data point (e.g. on the hour mark), you can change the command to

Reduceddata = Rawmasterdata(4:4:end,:);

If instead you would prefer to take the hourly averaged data, you may find the following MATLAB answer helpful:

Convert 10-minute wind data into hourly wind data - MATLAB Answers - MATLAB Central (mathworks.com)

[Ritika Srinivasan]

Hello! Thank you for the help I would like to sum the 4 values and the time stamp as well to reflect the hourly values. I also have the problem that the vlaues in my table change every time I run the script I have attached a picture of my code here. I was wondering why that happens.

Before I click run:

After I click run: