How to convert 15minute data to hourly data
12 views (last 30 days)
Show older comments
Ritika Srinivasan
on 30 Jul 2021
Commented: Ritika Srinivasan
on 1 Aug 2021
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
0 Comments
Accepted Answer
Lucien Hollins
on 30 Jul 2021
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:
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:
More Answers (0)
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!