Project case study

Decoding the 2026 Tamil Nadu Assembly Election

Non-partisan, ECI-data-only analysis built for a one-hour TV show, with an interactive Streamlit dashboard and a 10-slide stakeholder deck.

Problem

AtliQ Media needed a data-only, non-partisan story for a one-hour TV show on the 2026 Tamil Nadu Assembly Election results, using only Election Commission of India (ECI) data. Built for Codebasics Resume Project Challenge #21.

Approach

Loaded the 2021 and 2026 candidate-level results and the constituency master, parsed the 2026 registered electors from the Tamil Nadu CEO website, and calculated constituency-level turnout (votes polled / electors). Identified winners per constituency for both years, then computed vote share, margin, seat flips and turnout change. Combined everything into one master dataset (234 constituencies x 22 columns), then built an interactive Streamlit dashboard and a 10-slide stakeholder deck.

  • Record turnout: 86.2%, up 12.8 points from 73.4% in 2021. Constituencies above 85% turnout rose from 5 to 146 of 234.
  • Chennai Metro had the steepest regional climb: 63.4% to 84.6% (+21.2 points).
  • The seat flip: 163 of 234 constituencies (about 7 in 10) elected a different winning party than in 2021.
  • The margin shift: the median winning vote share fell from 48.2% to 37.4%, and 64 constituencies were won with under 35% of valid votes. Despite record turnout, winners needed a smaller share of votes.

Tools

PythonPandasPlotlyStreamlitBeautifulSoupData Storytelling

Key Insights

  • Record turnout: 86.2%, up 12.8 points from 73.4% in 2021. Constituencies above 85% turnout rose from 5 to 146 of 234.
  • Chennai Metro had the steepest regional climb: 63.4% to 84.6% (+21.2 points).
  • The seat flip: 163 of 234 constituencies (about 7 in 10) elected a different winning party than in 2021.
  • The margin shift: the median winning vote share fell from 48.2% to 37.4%, and 64 constituencies were won with under 35% of valid votes. Despite record turnout, winners needed a smaller share of votes.

Data limitations

  • 2026 turnout uses the April 2026 electoral roll as the denominator. ECI's final audited Form-20 data had not been released at the time, so minor variations are possible.
  • No alliance-level data: parties are analysed individually as recorded by ECI.
  • Descriptive only: no causal claims about why turnout rose, seats changed or margins shifted.

Links