Question: 1. From the dataset attached (EirGridSystemDemand2014.csv), read the data and perform a clean on the dataset. This includes replacing the null values and converting date

1. From the dataset attached (EirGridSystemDemand2014.csv), read the data and perform a clean on the dataset. This includes replacing the null values and converting date to DateTime format.

2. From the resulting data in 1 above, plot a graph representing a time series of the energy demand over a period of time for the year

3. Traverse through the dataset and compute the mean demand for each month. Plot the resulting values on to a bar graph showing the mean demand per month throughout the year

4. Write a script to search through the dataset and identify the mean values per hour. Plot the resulting values onto a bar graph showing the mean demand for each hour. This should be able to inform of what the peak hour for energy demand is among all the 24 hours of the day across the year.

Datase: https://drive.google.com/file/d/1m51YT_x2TIhC4dqY3b5wQDFtPXdyjvCg/view?usp=sharing

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!