C# Online Compiler | .NET Fiddle

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

public class Program
{
    public static void Main()
    {
        List<TrafficData> trafficData = new List<TrafficData>
        {
            new TrafficData { DataID = 1, IntersectionID = 101, Timestamp = new DateTime(2023, 3, 10, 8, 0, 0), VehicleCount = 150, AverageSpeed = 40 },
            new TrafficData { DataID = 2, IntersectionID = 101, Timestamp = new DateTime(2023, 3, 10, 10, 0, 0), VehicleCount = 200, AverageSpeed = 35 },
            new TrafficData { DataID = 3, IntersectionID = 102, Timestamp = new DateTime(2023, 3, 10, 8, 0, 0), VehicleCount = 100, AverageSpeed = 45 },
            new TrafficData { DataID = 4, IntersectionID = 102, Timestamp = new DateTime(2023, 3, 10, 17, 30, 0), VehicleCount = 180, AverageSpeed = 30 },
            // Simulating a scenario with no peak hour data for Intersection 101
            new TrafficData { DataID = 5, IntersectionID = 101, Timestamp = new DateTime(2023, 3, 10, 11, 0, 0), VehicleCount = 180, AverageSpeed = 25 },
        };

        // Step 1: Calculate the total vehicle count and the average speed for each intersection
        var statsByIntersection = trafficData
            .GroupBy(td => td.IntersectionID)
            .Select(g => new
            {
                IntersectionID = g.Key,
                TotalVehicleCount = g.Sum(td => td.VehicleCount),
                AverageSpeed = g.Average(td => td.AverageSpeed)
            })
            .ToList();

        // Step 2: Identify the intersection with the highest total vehicle count
        var busiestIntersection = statsByIntersection
            .OrderByDescending(i => i.TotalVehicleCount)
            .First();

        Console.WriteLine($"Busiest Intersection: {busiestIntersection.IntersectionID}, Total Vehicle Count: {busiestIntersection.TotalVehicleCount}");

        // Step 3: Determine the variation in average speed during peak hours compared to non-peak hours
        var peakHoursReadings = trafficData
            .Where(td => td.IntersectionID == busiestIntersection.IntersectionID &&
                         (td.Timestamp.Hour >= 7 && td.Timestamp.Hour <= 9 || td.Timestamp.Hour >= 17 && td.Timestamp.Hour <= 19))
            .ToList(); // Collect the readings first to avoid multiple enumeration

        var nonPeakHoursReadings = trafficData
            .Where(td => td.IntersectionID == busiestIntersection.IntersectionID &&
                         (td.Timestamp.Hour < 7 || td.Timestamp.Hour > 9) && (td.Timestamp.Hour < 17 || td.Timestamp.Hour > 19))
            .ToList(); // Collect the readings first to avoid multiple enumeration

        var peakHoursSpeed = peakHoursReadings.Any() ? peakHoursReadings.Average(td => td.AverageSpeed) : 0;
        var nonPeakHoursSpeed = nonPeakHoursReadings.Any() ? nonPeakHoursReadings.Average(td => td.AverageSpeed) : 0;

        Console.WriteLine(peakHoursReadings.Any()
            ? $"Average Speed During Peak Hours: {peakHoursSpeed} km/h"
            : "No data available for peak hours.");

        Console.WriteLine(nonPeakHoursReadings.Any()
            ? $"Average Speed During Non-Peak Hours: {nonPeakHoursSpeed} km/h"
            : "No data available for non-peak hours.");
    }
}

public class TrafficData
{
    public int DataID { get; set; }
    public int IntersectionID { get; set; }
    public DateTime Timestamp { get; set; }
    public int VehicleCount { get; set; }
    public double AverageSpeed { get; set; }
}

 
using System;
using System.Collections.Generic;
using System.Linq;
​
public class Program
{
    public static void Main()
    {
        List<TrafficData> trafficData = new List<TrafficData>
        {
            new TrafficData { DataID = 1, IntersectionID = 101, Timestamp = new DateTime(2023, 3, 10, 8, 0, 0), VehicleCount = 150, AverageSpeed = 40 },
            new TrafficData { DataID = 2, IntersectionID = 101, Timestamp = new DateTime(2023, 3, 10, 10, 0, 0), VehicleCount = 200, AverageSpeed = 35 },
            new TrafficData { DataID = 3, IntersectionID = 102, Timestamp = new DateTime(2023, 3, 10, 8, 0, 0), VehicleCount = 100, AverageSpeed = 45 },
            new TrafficData { DataID = 4, IntersectionID = 102, Timestamp = new DateTime(2023, 3, 10, 17, 30, 0), VehicleCount = 180, AverageSpeed = 30 },
            // Simulating a scenario with no peak hour data for Intersection 101
            new TrafficData { DataID = 5, IntersectionID = 101, Timestamp = new DateTime(2023, 3, 10, 11, 0, 0), VehicleCount = 180, AverageSpeed = 25 },
        };
​
        // Step 1: Calculate the total vehicle count and the average speed for each intersection
        var statsByIntersection = trafficData
            .GroupBy(td => td.IntersectionID)
            .Select(g => new
            {
                IntersectionID = g.Key,

Cached Result

El formato es valido: 13:00
El formato es valido: 13:00
El formato no es valido