How to convert 15minute data to hourly data
조회 수: 12 (최근 30일)
이전 댓글 표시
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![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/698942/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/698942/image.png)
댓글 수: 0
채택된 답변
Lucien Hollins
2021년 7월 30일
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:
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Tables에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!