使用LINQ显示时间跨度内每小时的平均值

using System;
using System.Collections.Generic;
using System.Linq;

public class Program
{
    public static void Main()
    {
        // 假设有一个包含时间戳和数值的数据集合
        List<DataPoint> data = new List<DataPoint>
        {
            new DataPoint { Timestamp = new DateTime(2022, 1, 1, 10, 30, 0), Value = 10 },
            new DataPoint { Timestamp = new DateTime(2022, 1, 1, 11, 15, 0), Value = 20 },
            new DataPoint { Timestamp = new DateTime(2022, 1, 1, 11, 45, 0), Value = 30 },
            new DataPoint { Timestamp = new DateTime(2022, 1, 1, 12, 10, 0), Value = 40 },
            new DataPoint { Timestamp = new DateTime(2022, 1, 1, 12, 45, 0), Value = 50 }
        };

        // 按照时间戳排序
        var sortedData = data.OrderBy(d => d.Timestamp);

        // 按照小时分组并计算平均值
        var hourlyAverage = sortedData.GroupBy(d => d.Timestamp.Hour)
                                       .Select(g => new
                                       {
                                           Hour = g.Key,
                                           AverageValue = g.Average(d => d.Value)
                                       });

        // 显示每小时的平均值
        foreach (var hourData in hourlyAverage)
        {
            Console.WriteLine($"Hour: {hourData.Hour}, Average Value: {hourData.AverageValue}");
        }
    }
}

public class DataPoint
{
    public DateTime Timestamp { get; set; }
    public int Value { get; set; }
}