Olympic Data Analysis
Interactive exploration of Olympic participation and medals through country, sport and year filters.
2024
Pandas aggregation and Streamlit visualizations.
System overview
Pandas/Streamlit exploration of historical Olympic participation and medals. Country, sport and year filters feed aggregates, demographic views and comparisons over athlete records.
Exploration views
- Medal tallies compare results across selected years and countries.
- Country analysis connects participation and medals over time.
- Athlete views explore age and other recorded characteristics across sports.
- Historical trends expose changing participation and event coverage through interactive filters.
From records to a view
- Athlete/event data
- NOC-region join
- Cleaning and selection
- Question-specific aggregation
- Interactive chart
The selection and aggregation change with the user’s question; the source tables remain a common foundation.