Welcome to the Lok Sabha Election Analysis project! This repository contains the code and resources used to analyze the Lok Sabha election results for the years 2014 and 2019. This project is part of the Resume Challenge Project 11 by Codebasics.

The main objective of this project is to provide a detailed examination of electoral trends, voting patterns, and key metrics across India's parliamentary constituencies during the 2014 and 2019 Lok Sabha elections. We aim to enrich public understanding of the electoral process in India and highlight key insights that have shaped the country's democracy over these years.

• Power BI: For data visualization and creating interactive dashboards.
• Excel: For initial data exploration and cleaning.
• Python: For data cleaning, transformation, and advanced analytics.

• Source: Election data for 2014 and 2019 was sourced from the Election Commission of India.
• Cleaning: Removed duplicates, handled missing values, and standardized constituency names.
• Transformation: Merged datasets from 2014 and 2019 for comparative analysis, created additional columns for derived metrics.

• Winning Candidate and Party: Identification of winning candidates and their respective parties for each constituency.
• Voter Turnout: Calculation of voter turnout percentage at the national and state levels.
• Vote Share: Analysis of vote share distribution among parties.
• Margin of Victory: Measurement of the vote margin between winning candidates and runners-up.
• Correlations: Examined correlations between voter turnout and factors like literacy rates, GDP, and postal votes percentage.

To interactively explore the insights derived from this analysis, please visit the Power BI dashboard through the following link: Power BI Dashboard

For a detailed walkthrough of the project, including the methodologies, findings, and recommendations, please watch the full presentation video on YouTube: YouTube Presentation Video

• AtliQ Media: For their support and the opportunity to present these insights.
• Dhaval Patel and Hemanand: For their invaluable guidance and contributions.
• Codebasics and Election Commission of India: For making this project possible.

This project aims to provide valuable insights into the electoral landscape of India. By examining past election data, we hope to contribute to a more informed and engaged electorate. Thank you for your interest, and we look forward to sharing our findings with you.