How to count number of days within datetime array

7 次查看（过去 30 天）
Louise Wilson
Louise Wilson 2020-7-8
评论： Louise Wilson 2020-7-9
I have a timetable which spans a year. The intervals between the datetimes varies from one minute to ten minutes. I am interested in finding out how many days contain any data at all. I tried using histogram but this returns an empty bin on days in which there was no data collected, and so conflates days where there was data collected but the values were 0, and data where there was no data collected.
numberdays=histogram(timetable.DateTime,'BinMethod','day');
This seems like it should be simple but I am sorry I can't figure it out!

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

采纳的回答

Kanupriya Singh
Kanupriya Singh 2020-7-9
Since your previous attempts are returning you empty data for days that are not in your datetime array, you could calculate the number of days that have any data by using this function-
nnz(x)
This will return you the number of non-zero elements in the array.
  2 个评论
Louise Wilson
Louise Wilson 2020-7-9
Thanks Kanupriya-I have actually since done this before you replied and it's the only method I have found to work!

请先登录，再进行评论。

更多回答（1 个）

madhan ravi
madhan ravi 2020-7-8
Use retime() with 'daily' 'count' .
  1 个评论
Louise Wilson
Louise Wilson 2020-7-8
Thanks for your response Madhan. I tried this:
countdays=retime(Kawau_counts,'daily','count');
but it does the same as my attempt above. It lists all days between the first datetime and last datetime in my timetable, and so creates rows for datetimes that never existed in my timetable in the first place.

请先登录，再进行评论。

类别

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

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by