C# Online Compiler | .NET Fiddle

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

public class Program
{
    public static void Main()
    {
        List<ElectricityConsumption> consumptionRecords = new List<ElectricityConsumption>
        {
            new ElectricityConsumption { RecordID = 1, Region = "North", Timestamp = new DateTime(2023, 1, 15, 10, 0, 0), ConsumedPower = 120.5 },
            new ElectricityConsumption { RecordID = 2, Region = "South", Timestamp = new DateTime(2023, 1, 15, 11, 0, 0), ConsumedPower = 110.0 },
            new ElectricityConsumption { RecordID = 3, Region = "North", Timestamp = new DateTime(2023, 1, 15, 12, 0, 0), ConsumedPower = 115.5 },
            new ElectricityConsumption { RecordID = 4, Region = "East", Timestamp = new DateTime(2023, 1, 15, 13, 0, 0), ConsumedPower = 130.0 },
            new ElectricityConsumption { RecordID = 5, Region = "North", Timestamp = new DateTime(2023, 1, 15, 14, 0, 0), ConsumedPower = 125.0 },
            // Add more electricity consumption records as needed
        };

        DateTime periodStart = new DateTime(2023, 1, 1);
        DateTime periodEnd = new DateTime(2023, 1, 31);

        // Step 1: Calculate the total power consumption for each region over the specified period
        var totalConsumptionByRegion = consumptionRecords
            .Where(c => c.Timestamp >= periodStart && c.Timestamp <= periodEnd)
            .GroupBy(c => c.Region)
            .Select(g => new { Region = g.Key, TotalConsumption = g.Sum(c => c.ConsumedPower) })
            .ToList();

        // Step 2: Identify the region with the highest total power consumption during this period
        var highestConsumptionRegion = totalConsumptionByRegion
            .OrderByDescending(r => r.TotalConsumption)
            .First();

        Console.WriteLine($"Region with Highest Power Consumption: {highestConsumptionRegion.Region}, Total Consumption: {highestConsumptionRegion.TotalConsumption} kWh");

        // Step 3: Analyze hourly consumption patterns in the highest consumption region
        var hourlyConsumptionPattern = consumptionRecords
            .Where(c => c.Region == highestConsumptionRegion.Region && c.Timestamp >= periodStart && c.Timestamp <= periodEnd)
            .GroupBy(c => c.Timestamp.Hour)
            .Select(g => new { Hour = g.Key, AverageConsumption = g.Average(c => c.ConsumedPower) })
            .OrderByDescending(h => h.AverageConsumption)
            .ToList();

        Console.WriteLine("Hourly Consumption Pattern in Highest Consumption Region:");
        foreach (var hour in hourlyConsumptionPattern)
        {
            Console.WriteLine($"Hour: {hour.Hour}, Average Consumption: {hour.AverageConsumption} kWh");
        }
    }
}

public class ElectricityConsumption
{
    public int RecordID { get; set; }
    public string Region { get; set; }
    public DateTime Timestamp { get; set; }
    public double ConsumedPower { get; set; }
}

 
using System;
using System.Collections.Generic;
using System.Linq;
​
public class Program
{
    public static void Main()
    {
        List<ElectricityConsumption> consumptionRecords = new List<ElectricityConsumption>
        {
            new ElectricityConsumption { RecordID = 1, Region = "North", Timestamp = new DateTime(2023, 1, 15, 10, 0, 0), ConsumedPower = 120.5 },
            new ElectricityConsumption { RecordID = 2, Region = "South", Timestamp = new DateTime(2023, 1, 15, 11, 0, 0), ConsumedPower = 110.0 },
            new ElectricityConsumption { RecordID = 3, Region = "North", Timestamp = new DateTime(2023, 1, 15, 12, 0, 0), ConsumedPower = 115.5 },
            new ElectricityConsumption { RecordID = 4, Region = "East", Timestamp = new DateTime(2023, 1, 15, 13, 0, 0), ConsumedPower = 130.0 },
            new ElectricityConsumption { RecordID = 5, Region = "North", Timestamp = new DateTime(2023, 1, 15, 14, 0, 0), ConsumedPower = 125.0 },
            // Add more electricity consumption records as needed
        };
​
        DateTime periodStart = new DateTime(2023, 1, 1);
        DateTime periodEnd = new DateTime(2023, 1, 31);
​
        // Step 1: Calculate the total power consumption for each region over the specified period
        var totalConsumptionByRegion = consumptionRecords
            .Where(c => c.Timestamp >= periodStart && c.Timestamp <= periodEnd)

0.9999999