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; }

}

​