This project aims to explore and analyze Uber pickup data in New York during the period from April to September 2014.
The primary objectives of this project are to gain insights into Uber pickup patterns, explore correlations between pickups and time, location, and weather conditions, and create visualizations to better understand the trends in the data.
Disclaimer: It's important to consider that this analysis is limited by the time frame of the data and that the patterns of trips may vary seasonally due to factors like weather conditions, holidays, or special events. Further analysis with data over a longer time frame could reveal more about seasonal trends.
The project utilized two datasets:
- Uber Pickups Data: Obtained by FiveThirtyEight from the NYC Taxi & Limousine Commission (TLC), providing the date, time, and coordinates of Uber pickups in New York City from April to September 2014 (Source).
- Weather Data: Scraped from the website Weather Spark, providing hourly weather conditions in New York City for the same period.
- Uber datasets were concatenated, and the dates and hours were parsed.
- Weather dataset was cleaned, with the dates parsed and the hours converted to 24-hour format, the numeric values parsed, and the categorical values standardized.
- For each dataset, a table was created with a surrogate key to serve as the primary key, and a composite index was created on the date and hour columns to optimize querying and retrieving data.
- EDA was performed using SQL queries to investigate patterns, relationships, and trends within the data. Various statistical and aggregate functions were utilized to extract meaningful insights about the demand for Uber and pickup patterns and correlations.
- For each dataset, a column combining date and hour was created to serve as a composite key to create the many to one relationship between the uber_pickups and weather tables.
- Five columns (day_of_month, day_name, month_name, time_slot, rush_hours) and three measures (total_rides_count, avg_trips_per_day, avg_trips_per_hour) were calculated in the uber_pickups table to further expand the analysis.
- Three columns (temp_category, wind_category, vis_category) were calculated in the weather table to categorize the weather condition to make it easier to interpret.
- EDA was performed by creating a series of visualizations to answer key questions and display crucial metrics. At the end, a comprehensive and interactive dashboard was built, incorporating the visualizations and metrics derived from the analysis.
For the detailed findings and insights of the analysis, please refer to the Notebook.