This page highlights the visualizations I made for the final assignment in the Spring 2023 offering of MACS 30113: Big Data and High Performance Computing for Social Scientists, at the University of Chicago. The goal of the assignment was to practice PySpark and tools to visualize big data. You can read more about my takes on these visualizations in the README file located here.

Overview

The interactive map below highlights all trips taken via Divvy in Q3 of 2018 (weirdly, just July through September). Each shaded blue area corresponds to one of the community areas of Chicago, and each dot corresponds to a Divvy station. Hover over a station to see the relevant statistics associated with Divvy trips starting from that station:

  • Station Name: Name of the Divvy station.
  • Docks in Service: Number of bike docks in service.
  • Trip Count: Total number of trips starting from station in Q3 2018.
  • Trip Count (Normalized): Trip count divided by number of docks in service.

I created the "normalized" trip count measure to try to account for the fact that stations with high trip counts might be simply stocked with more bikes to ride. To create the measure, I divide a station's total trip count by the number of total bike docks available. This yields a station-level measure of bike usage in units of average trips per station bike.

Yellow and green correspond to the highest normalized trip counts, and blue and purple correspond the lowest. One takeaway from the map is that Divvy trips are the most frequent in the Loop (no surprise), and on the North Side. They are the least frequent on the South, Southwest, and West Sides of Chicago. You can read more about these geographic trends in my README.

Here is an additional bonus visualization of a week in the life of an average Divvy bike. I created a timelapse gif to track Divvy bike 3205 on its journey during the week of July 1-8, 2018. I picked bike 3205 because it begins the day on July 1 by being parked at the Ellis & 55th Divvy station, my local station when I used Divvy to commute to class during my first year of graduate school. As the visualization shows, the bike putzes around Hyde Park for a short time only before being ridden to the North Side, where it remains for the rest of the sample period.