This project presents an in-depth analysis of electricity consumption across major Indian states during the years 2019 and 2020. It highlights consumption patterns, regional differences, seasonal variations, and the effects of the COVID-19 lockdown on energy demand.
(All insights are based on the project PDF.)
- Analyze state-wise monthly and daily electricity consumption.
- Identify patterns, seasonal trends, correlations, and demand fluctuations.
- Compare high-consumption states to understand regional differences.
- Provide insights to support energy planning and distribution strategies.
- Total Records: 503
- Features: 34 columns representing Indian states and union territories
- Includes monthly and daily energy consumption data for 2019–2020
- Date column converted into datetime format for time-series analysis
- Strong positive correlations among northern states like Punjab, Haryana, Rajasthan, and Uttar Pradesh.
- Some southern and northeastern states show opposite or weak correlation trends.
- Correlation with Month and Day_of_Week indicates seasonal and weekly impact on electricity usage.
- Maharashtra, Gujarat, and Uttar Pradesh record the highest monthly consumption.
- Sikkim, Mizoram, Nagaland, and Arunachal Pradesh show the lowest energy usage.
- Visible seasonal fluctuations across multiple states throughout the year.
- Maharashtra consistently stays above 400 MW and leads in consumption.
- Uttar Pradesh shows high variability.
- Punjab and Haryana remain moderate and stable.
- Delhi records the lowest values among the major states.
- Highest median values in Maharashtra, Gujarat, and Tamil Nadu.
- Lowest medians appear in Mizoram, Nagaland, and Tripura.
- Some states show large variations and outliers, indicating occasional demand spikes.
- Highest consumption in January.
- Lowest consumption during June and July.
- Fairly stable usage from March to October.
- High consumption days around mid-August and certain weekends.
- Low consumption mostly on Sundays.
- Greater fluctuations during summer and monsoon seasons.
- Maharashtra ranks first in both average and peak consumption.
- Gujarat and Uttar Pradesh follow.
- West Bengal ranks at 11th position overall.
- Maharashtra remains the top consumer across all months.
- Gujarat, Tamil Nadu, and Uttar Pradesh show consistent, significant demand.
- Northeastern states like Mizoram, Nagaland, and Arunachal Pradesh consume the least energy.
- West Bengal holds the 11th place in overall energy consumption.
- Python
- Pandas
- NumPy
- Matplotlib / Seaborn
- Jupyter Notebook
Visualization Techniques:
- Heatmaps
- Line plots
- Time-series charts
- Swarm plots
- Radar charts
- Box plots
- Shevanti Nandi (CSE/22/05)
- Anirban Kundu (CSE/22/13)
- Sandipan Rakshit (CSE/22/14)
- Arin Ganguly (CSE/22/46)
- Ankan Das (CSE/22/59)
- Abhijit Dey (CSE/22/56)