The aim of this project is to analyze the data in detail of power generation in different power stations in India with expected power generation, actual power generation, over-produced or under-produced power generation.
Introduction
This report contains information about the generation of power in different power station.
Visuals of the stations according to their production are made.
The over generated and under generated power stations are also shown.
Problem Statement
In this we have to find the quantity of power generated by different power stations in India.
Which power stations can meet the goal and which are not.
Which stations are generating highest amount of energy.
Methodolgy
Step 1 – Data Importing
First, we have to load the dataset, and clean it.
Step 2 – Data Cleaning
We have to remove the empty values.
Step 3 - Visualization
· Then, the visuals are built according to the data, using charts and graphs for ease of understanding.
Analysis
First analysis is done for the top 10 number of stations in India using count of power station.
Here, we can see that maximum number of stations are of NTPC Ltd., followed by GMR RNERG, NHPC, NPCIL, TATA PCL and so on.
In the second analysis, the amount of power production is analyzed in different power stations in India.
In the top 10 power stations, we can see that NTPC Ltd. Is producing the maximum power after that Maharashtra then APL and so on
The next analysis is showing the comparison between the estimated power that needed to be generated and the actual power generated.
In this we can see that NTPC Ltd. And DVC is producing more than the estimation.
Maharashtra and APL are not fulfilling the need.
The next analysis is about the top 5 stations that are producing excess power.
Here NPCL Ltd. Is in first position, GCEL is in second position after that GPL, DVC and then SPL.
The last analysis contains the last 10 stations that are producing less than the estimated production.
The last station is APL.
Insights
From this we conclude that, which power station are producing more than the needed amount.
Which power stations need to increase the power generation.
How much power is generated by the power stations.
Recommendations
We can analyze the power consumption of the states and cities.
Compare the data of power consumption of states and cities and power generated in that state.
According to that analysis the power stations can increase their power generations to fulfill the demands.
Conclusion
From this we conclude that some power stations need to increase the power generation and some should produce according to the estimation.