Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

Group a list of random datetime into user specified time Interval. This feature very like Excel Pivot Table Group Date Time in C#

  1. Forget Code
  2. C#
  3. Group a list of random datetime into user specified time Interval. This feature very like Excel Pivot Table Group Date Time 
  1. void Main()
  2. {
  3.     List<DateTime> ts = DateTimeData();
  4.  
  5.     //group by 15 minutes
  6.     Dictionary<DateTime,List<DateTime>> pivotDict = ts.GroupBy(t =>
  7.     {
  8.         var temp = t.AddMinutes(-(t.Minute % 15));
  9.         temp = temp.AddSeconds(-t.Second);
  10.         temp = temp.AddMilliseconds(-t.Millisecond);
  11.         return temp;
  12.     }).ToDictionary(gp => gp.Key, gp => gp.ToList());
  13.     
  14.     pivotDict.Dump();
  15.  
  16. }
  17.  
  18. public List<DateTime> DateTimeData()
  19. {
  20.     var ts = new List<DateTime>();
  21.     ts.Add(DateTime.Parse("2020/06/20 22:20:05"));
  22.     ts.Add(DateTime.Parse("2020/06/20 22:21:06"));
  23.     ts.Add(DateTime.Parse("2020/06/20 22:22:09"));
  24.     ts.Add(DateTime.Parse("2020/06/20 22:24:01"));
  25.     ts.Add(DateTime.Parse("2020/06/20 22:28:09"));
  26.     ts.Add(DateTime.Parse("2020/06/20 22:33:01"));
  27.     ts.Add(DateTime.Parse("2020/06/20 22:34:05"));
  28.     ts.Add(DateTime.Parse("2020/06/20 22:38:12"));
  29.     ts.Add(DateTime.Parse("2020/06/20 22:40:41"));
  30.     ts.Add(DateTime.Parse("2020/06/20 22:42:12"));
  31.     ts.Add(DateTime.Parse("2020/06/20 22:45:52"));
  32.     ts.Add(DateTime.Parse("2020/06/20 22:46:10"));
  33.     ts.Add(DateTime.Parse("2020/06/20 22:48:23"));
  34.     ts.Add(DateTime.Parse("2020/06/20 22:53:45"));
  35.     ts.Add(DateTime.Parse("2020/06/20 22:55:24"));
  36.     ts.Add(DateTime.Parse("2020/06/20 22:56:12"));
  37.     ts.Add(DateTime.Parse("2020/06/20 23:01:31"));
  38.     ts.Add(DateTime.Parse("2020/06/20 23:02:31"));
  39.     ts.Add(DateTime.Parse("2020/06/20 23:08:12"));
  40.     ts.Add(DateTime.Parse("2020/06/20 23:09:23"));
  41.     ts.Add(DateTime.Parse("2020/06/20 23:10:23"));
  42.     ts.Add(DateTime.Parse("2020/06/20 23:18:42"));
  43.     ts.Add(DateTime.Parse("2020/06/20 23:19:44"));
  44.     ts.Add(DateTime.Parse("2020/06/20 23:22:55"));
  45.     ts.Add(DateTime.Parse("2020/06/20 23:23:12"));
  46.     ts.Add(DateTime.Parse("2020/06/20 23:28:10"));
  47.     ts.Add(DateTime.Parse("2020/06/20 23:31:02"));
  48.     ts.Add(DateTime.Parse("2020/06/20 23:33:12"));
  49.     ts.Add(DateTime.Parse("2020/06/20 23:38:32"));
  50.     ts.Add(DateTime.Parse("2020/06/20 23:40:11"));
  51.     return ts;
  52. }


The output dictionary shows how do the groups looks like