Member-only story

Studying up for the Tokyo 2021 Olympics with SQL

Querying a PostgreSQL Database with Python, displaying results with Pandas, and visualizing with Matplotlib

Sejal Dua
TDS Archive
18 min readJul 20, 2021

--

Now more than ever, I am wishing I was a professional athlete in the best shape of my life, gearing up for the Tokyo 2021 Olympics. But rather than feeling sorry for myself as I set up my spot on the couch with pillows, blankets, and a non-vegetable snack, I figured this would be an opportune time to apply some of my SQL knowledge (shoutout to Udemy and Coursera) and learn a thing or two from the historical olympic dataset. Four — well, now five — years is a significant amount of time. To put it into perspective, at the time of the last Summer Olympics, I had never coded before and had approximately zero exposure to data science. In this span of time, it can be difficult to situate ourselves into the right spirit whilst watching the olympics. I know I personally just stare at the screen in awe of the unimaginable athletic prowess being put on display. Not this time around, though!

Source: https://unsplash.com/photos/ZIoi-47zV88 by @kfdias

The motivation for this project is ask and answer questions about how the Olympics have evolved over time, including questions about the participation and performance of women, the variation in athletic build (i.e. height, weight, age) by sport and by nation, and the nature of…

--

--

TDS Archive
TDS Archive

Published in TDS Archive

An archive of data science, data analytics, data engineering, machine learning, and artificial intelligence writing from the former Towards Data Science Medium publication.

Sejal Dua
Sejal Dua

Written by Sejal Dua

Data Scientist @ NBA | Formerly @ Nike | Writing about Python, ML, NLP, Data Visualization, Music, and Sports | sejaldua.com

Responses (1)