Uber Washington, D.C., Listings Analysis from July
2022 to July 2024
Saber Alshahrani, S3990788
October 4, 2024
Introduction
The rise of ride-sharing services like Uber has significantly
transformed urban transportation in cities worldwide, with Uber emerging
as a dominant player in the market. Uber reported its first full-year
profit since its initial public offering in 2023, marking a significant
milestone. This success, according to CEO Dara Khosrowshahi, is the
result of “strong, broad growth around the world.” (Catron 2024).
Thisachievement demonstrates Uber’s evolution from a disruptive startup
to aprofitable global transportation leader.
In Washington, D.C., Uber’s impact on transportation has been
substantial, reflecting broader trends of financial growth and evolving
labor rights. Recent data shows Uber conducted 2.57 billion rides in the
first quarter of 2024 and processed $68.9 billion in bookings in 2023
(Statista 2024). Additionally, Uber’s net revenue grew from $0.1 billion
in 2013 to $37.28 billion in 2023, highlighting the company’s
exponential growth over the past decade.
Objective
This analysis seeks to answer the following key questions:
1. What are the main trends in Uber ride demand, including peak
hours, days, and seasonal variations?
2. How do external factors, such as weather, events, or holidays,
influence ride patterns?
3. Which geographical areas show the highest demand for Uber pickups
and drop-offs?
4. How do fare amounts fluctuate over time, and what factors
contribute to these changes?
5. What insights can be drawn to help improve ride-sharing services
for stakeholders like drivers, urban planners, and policymakers?
Data Processing
Source: DC Ward map 2022 (Leonard, 2022)
The primary challenge with the Uber listings data was
that rides were denoted by specific pickup and drop-off locations across
Washington, D.C., without any higher-level categorization. To address
this, I conducted additional research and discovered that Washington,
D.C., is traditionally divided into wards, which are more commonly used
for urban planning and analysis.
By mapping each pickup and drop-off location to its corresponding
ward, I was able to categorize the data into 8 different wards,
providing a more structured view of ride-sharing activity across the
city. This grouping allowed for clearer identification of trends and
patterns within different areas of Washington, D.C., making the analysis
more meaningful and easier to interpret.
The 45 Neighborhoods of Washington
Source:DC Ward map 2022 (Wikitravel, 2022)
The data initially included listings across 45 different areas of
Washington, D.C., making it difficult to discern broader trends due to
the high level of detail. By grouping them according to the 8 wards of
Washington, D.C., the data became more manageable, enabling a clearer
examination of ride patterns, demand trends, and other key metrics.
This step was essential in transforming a highly granular dataset
into a more structured format, allowing for a more effective and
insightful analysis of Uber’s activity across the city. For example,
Ward 2 consistently showed the highest ride demand, indicating a central
hotspot for ride-sharing activity.
Data Visualization: Ride Demand by Ward
![]()
Data Visualization - Hourly Ride Demand
## `geom_smooth()` using formula = 'y ~ x'
![]()
Data Visualization - Fare Distribution
![]()
Data Visualization: Ride Demand by Day
![]()
Conclusion
The analysis of Uber ride listings in Washington, D.C., from July
2022 to July 2024 provided valuable insights into ride-sharing patterns
across the city. By grouping the 45 areas into 8 wards, we identified
key trends in ride demand, fare distributions, and peak usage times.
This study offers a comprehensive view of how ride-sharing is
utilized in Washington, D.C., and can serve as a valuable resource for
stakeholders, including Uber drivers, city planners, and policymakers.
Future analyses could incorporate external factors like weather, events,
or public transportation data to gain deeper insights into ride-sharing
dynamics in the city.
