How can I count how many rows in a table have the same date?

Question

Andreas B 2018-6-12

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/405220-how-can-i-count-how-many-rows-in-a-table-have-the-same-date

评论： Peter Perkins 2018-7-5

image.png

Hey Guys,

I would like to count how many rows are within one day. Please take a look on the Image. There are a lot of rows an they differ from day to day. I simple want to count them and safe this number in a variable.

The next question I have is, how can I count rows within a day and a time period. Like I want to know how man Logs a created from 00:00 to 02:00 am, then from 02:00 - 04:00 pm.

Thank you for your help.

Best regards Andreas

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

jonas 2018-6-12

编辑：jonas 2018-6-12

You probably want to use either the unique() function or logical indexing, can you upload some data to work with?

请先登录，再进行评论。

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

Answer 1

Sean de Wolski 2018-6-14

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/405220-how-can-i-count-how-many-rows-in-a-table-have-the-same-date#answer_324725

编辑：Sean de Wolski 2018-6-14

convert table to timetable table2timetable.

retime the timetable with count as the function

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Sam Cook 2018-6-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/405220-how-can-i-count-how-many-rows-in-a-table-have-the-same-date#answer_324698

在 MATLAB Online 中打开

First, you need a range of times (buckets/intervals) to check. This will vary depending on exactly what time periods you're interested in (hourly, daily, etc). Here the time period is every 2 hours from June 13 to June 14.

times = datetime(2018, 6, 13):hours(2):datetime(2018, 6, 14);

Then, for each interval, you want to count the number of rows that are within that interval. Again, this code will vary based on how your data is formatted. In this example, 'data' is a datetime vector.

counts = zeros(1, length(times) - 1);
for i=1:length(times) - 1
  intStart = times(i);
  intEnd = time(i + 1);
  counts(i) = nnz(data > intStart & data <= intEnd);
end

These counts refer to their respective interval (EG counts(1) is the number of entries from times(1) to times(2), counts(5) from times(5) to times(6), etc).