Lucas Carrasquilla

Work

Things I've made.

Published pieces

7

Lo que conviene tener presente hoy

Gandour Electoral · 20 cards

Five readings of the Colombian electorate from Atlas-Intel microdata, May 2026, published on the day of the first round. On what the poll says, and on what it does not reach.

Movilización en segunda vuelta

Gandour Electoral · Video · 1:41

The polling places where Petrismo concentrated its vote in 2018 and 2022 have a territorial correlation of 0.95. Over practically the same polling places, between the first and second rounds of 2022 it added 453,329 votes in Bogotá and 2,753,245 nationally, 32.3% more than in the first round.

Crónica de un resultado anunciado

Gandour Electoral · Video · 13:48

Government approval as the variable that orders the contest. Among those who disapprove, 92% back one candidate in the runoff; among those who approve, 94% back the other. What holds the larger group together is a shared rejection rather than a common ideology.

El Mundial que ven las matemáticas

Gandour Fútbol · 16 cards

Three branches of mathematics applied to the 2026 World Cup group stage: a random walk over the passing network, linear algebra to group playing styles, and simulation to estimate the table. 110,627 actions from 72 matches.

El mapa del territorio

Gandour Tecnología · 18 cards

The compute stack that artificial intelligence is built on, in six layers, from physical hardware to the economics of a token.

Elsewhere

3

Instagram

@gandour.analitica

Where the pieces are published: electoral, sports and technology analysis.

TikTok

@lucarrpa05

Short mathematics videos.

Medium

@lucascarrasquillaparra

Longer articles and notes.

Code

3

Public repositories.

understat_shotmap_scraper · Jupyter Notebook

Scrapes event data from understat.com.

TransMilenioPathFinder · JavaScript

Route finding over the TransMilenio network in Bogotá.

shotmap_plotter · Jupyter Notebook

Renders shot maps from match event data.

All code