Indexing dates yearly and quarterly.

1 次查看（过去 30 天）
Doheon Lee
Doheon Lee 2020-1-31
回答： dpb 2020-1-31
I have many tables, in which the first column is date and the second column in data.
And I want to separte these data yearly and montly.
For examply, from 2017-Jan-01 to 2017-Dec-31, and 2018-Jan-01 to 2018-Dec-31 and so on for yearly categrization. For quarterly categorization, from 2017-Jan-01 to 2017-Mar-31, from 2017-April-01 to 2017-Jun-31, etc.
As start dates and endd ates are any dates in a year, they may need to be detected first.
Please note that each yearly and quartely seprated data will be used in a loop temporaraly and deleted, so I do not need a table of yearly (or quartely) separated data.
Thank you in advance.

请先登录，再回答此问题。

回答（1 个）

dpb
dpb 2020-1-31
Use a timetable and retime with a custom method function.

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by