How to count number of days within datetime array

18 visualizzazioni (ultimi 30 giorni)
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!

Risposta accettata

Kanupriya Singh
Kanupriya Singh il 9 Lug 2020
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 Commenti
Louise Wilson
Louise Wilson il 9 Lug 2020
Thanks Kanupriya-I have actually since done this before you replied and it's the only method I have found to work!
Louise Wilson
Louise Wilson il 9 Lug 2020
[Tally,~,bin]=histcounts(tt,'BinMethod','day');
days=nnz(Tally);

Accedi per commentare.

Più risposte (1)

madhan ravi
madhan ravi il 8 Lug 2020
Use retime() with 'daily' 'count' .
  1 Commento
Louise Wilson
Louise Wilson il 8 Lug 2020
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.

Accedi per commentare.

Categorie

Scopri di più su Timetables in Help Center e File Exchange

Prodotti


Release

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by