Oscar Awards Dashboard

A Streamlit data dashboard exploring nearly a century of Academy Awards nominations and wins.

I built this project to turn the public Academy Awards dataset (~11,000 nomination records from 1927 to today) into an interactive tool for exploring trends, rather than a static report. The app lets users filter by year range, category, and winner status, then surfaces the data through KPI summaries, time-series trends, and ranked breakdowns (top categories, most-nominated people, most-awarded films), alongside a searchable, exportable data table.

Stack: 

Python, Pandas for data cleaning and aggregation, Plotly for interactive charts, Streamlit for the app layer.

A few engineering choices worth calling out:

1. Data loading is memoized with st.cache_data so filtering and re-rendering stay fast without re-reading the CSV on every interaction.

2. File paths are resolved relative to the script's own location (Path(__file__)) rather than the working directory — a small detail, but it's what makes the app portable across local runs and the cloud host's different execution environment.

3. Chart colors follow a single validated categorical palette (contrast- and colorblind-checked) applied consistently across every chart, rather than default library colors chosen ad hoc per chart.

Deployment: hosted on Streamlit Community Cloud, connected directly to a GitHub repository — pushing a change to the repo redeploys the live app automatically. No server management involved.

Link to live dashboard!