Skip to content

Juliarriibeiro/MTA-Transit

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

11 Commits
Β 
Β 
Β 
Β 

Repository files navigation

πŸ—½ MTA Subway Ridership Analysis (2020–2024)

This project explores how New York City subway ridership patterns have changed between 2020 and 2024, with a specific focus on:

  • πŸ“ˆ Overall ridership recovery since the pandemic
  • ⏰ Changes in peak commuting hours
  • πŸ—ΊοΈ Differences in subway usage by borough and station
  • πŸ’³ The transition from MetroCard to OMNY

πŸ” Research Question

How has MTA subway ridership changed from 2020 to 2024, and have peak commuting hours shifted over time?


πŸ“‚ Project Structure

This project includes two components:

1. 🐍 Python Workbook

Python was used to fetch, clean, and analyze the hourly ridership dataset via the NYC Open Data API. Key visualizations were generated using matplotlib, seaborn, and pandas.

πŸ“Ž View the Python Notebook here:
➑️ [MTA Transit 2020 - 2024.ipynb ](https://github.com/Juliarriibeiro/MTA-Transit/blob/45a6565360d22132ae4d32ddff0decfa30652a80/MTA%20Transit%202020%20-%202024.ipynb)


2. πŸ“Š Tableau Dashboard

Tableau was used to create an interactive dashboard that complements the Python analysis and allows users to explore patterns by year, borough, station, and payment method.

πŸ“Ž Explore the live dashboard on Tableau Public:
➑️ https://public.tableau.com/app/profile/julia.santos.ribeiro/viz/MTA-HowMTASubwayRidershipChangedfrom2020-2024/HowMTASubwayRidershipChanged20202024


πŸ“Œ Key Visuals

  • Stacked area chart of MetroCard vs OMNY usage by month
  • Hourly ridership heatmap comparing peak hours across years
  • Top 10 busiest stations ranked by total ridership
  • Borough-level trends showing geographic ridership shifts
  • Treemap & bubble charts to add interactivity and visual diversity

πŸ“š Data Source

NYC Open Data – MTA Subway Hourly Ridership (2020–2024)


πŸ§‘β€πŸ’» Technologies Used

  • Python: pandas, matplotlib, seaborn, requests
  • Tableau: interactive dashboard design, filters, color legends
  • GitHub: project hosting and documentation

πŸ‘©πŸ» Author

Julia Ribeiro


Feel free to fork, star, or reach out if you have feedback or want to collaborate!

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published