How can i filter data using time frames?
1 次查看(过去 30 天)
显示 更早的评论
Hi,
I got a table with 2 colums. In the first is the time in datetime and in the second colum is data associated with the time. I have data for each our of each day for multiple years and I want to calculate the mean of the data for a given year.
How can I access my data in relation to the time and select that i just want the data of a given year?
7 个评论
Eric Sofen
2020-6-9
If you want to do the calculation one-year-at-a-time rather than calculating averages for all years, you can use the timerange method on your timetable to select all values within the specified year, then calculate the average of the corresponding data variable.
Adam Danz
2020-6-9
In order to see your data we need to
- Download the file
- unzip the file
- read in the data
- convert to datetime
and at any point, we may do something differently than you did so our result might not work with your style of reading in and formatting the data. Reduce the amount of work we need to do before we can start helping you by either reproducing a small sample of your table that we can copy-paste into our systems or supply your code that we can apply to your data.
I agree with Start that a timetable is most appropriate and that retime would be simple to apply once your data are in a timetable.
You can probably read in the data using readtable() then convert to a timetable using table2timetable(). Then you can apply retime().
回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Timetables 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!