How To Analyze Election Results Like a Data Journalist: The Beginner's Guide
Turn raw vote counts into clear insights with free tools, real‑time data, and proven techniques.
Election outcomes shape policy and public opinion—so knowing how to read the numbers is essential. With Lula da Silva’s narrow win in São Paulo, the stakes are higher than ever. This guide shows you how to transform raw data into actionable stories in just a few simple steps.
Step 1: Gather Official Vote Data
Start on Brazil’s Tribunal Superior Eleitoral (TSE) portal, where you can download the finalized vote totals in CSV format. Use Google Sheets or Excel to import the file; the download button is located under the “Resultados” tab. Double‑check the header fields for any typos before proceeding, as a single mis‑named column can throw off your analysis.
Step 2: Clean and Visualize the Data
Open the CSV in Python’s Pandas library or use the free Datawrapper editor. Remove any rows that contain only aggregate totals and convert all numeric strings to integers. Create a bar chart of vote shares—Pandas’ `plot.bar()` or Datawrapper’s “Bar Chart” template will instantly reveal Lula’s 51.7% win in São Paulo. The visual step helps you spot outliers before you dig deeper.
Step 3: Map Results to Demographics
Merge the vote data with census shapefiles from the Brazilian Institute of Geography and Statistics (IBGE). Using QGIS or the free ArcGIS Online viewer, overlay the vote percentages onto municipal boundaries. Highlight areas where Lula’s margin was less than 5%; these are the swing regions that could shift future elections.
Step 4: Identify Key Swing Regions
Run a simple logistic regression in R or Python to see which demographic variables—income, education, age—correlate with the narrow margins. Export the model’s coefficients to a concise table. The regression output tells you exactly which groups are most likely to flip in the next campaign, giving you a data‑driven narrative.
Step 5: Communicate Findings to the Public
Publish your charts and insights on a platform like Medium or a personal blog, tagging relevant hashtags such as #BrazilElections2026. Embed interactive maps with StoryMapJS so readers can explore the data themselves. Finish with a short summary that explains why Lula’s 51.7% win matters for policy and future elections—the summary is the hook that keeps readers engaged.
Always cross‑check data from TSE with a secondary source like the Instituto Datafolha to catch any discrepancies before publishing.
Now you can turn raw vote counts into compelling stories that inform voters, analysts, and policymakers. By following these five steps, you’ve built a repeatable workflow for any election. Keep practicing, and soon you’ll be the go‑to analyst for Brazil’s political shifts.
