This case study analyzes how annual members and casual riders use Cyclistic bike‑share services differently. Using 5.6M+ rides from 2022 and Python, the analysis explores ride length, day of week, bike type, and seasonality to support membership growth strategies.
Python (Pandas, NumPy, Matplotlib, Seaborn)
Jupyter Notebook
Google Sheets
Data visualization techniques
Data cleaning and transformation
Exploratory data analysis (EDA)
Data Collection: Combined 12 months of Cyclistic ride data (5.6M+ rows).
Data Cleaning: Removed nulls, fixed data types, calculated ride length, filtered invalid rides.
Feature Engineering: Extracted day of week, hour of day, ride type, and user type.
Exploratory Analysis: Identified behavioral patterns across members vs casual riders.
Visualization: Created charts to highlight trends in usage, duration, and bike type.
Insights & Recommendations: Developed actionable strategies to increase membership conversions.
Members ride more on weekdays, while casual riders peak on weekends.
Casual riders take longer rides on average than members.
Members peak at 17:00 (commute hours), casual riders peak midday.
Members prefer classic bikes; casual riders use electric bikes more.
Both groups peak in summer, with casual riders showing stronger seasonality.
Members ride mostly during commute hours
Casual riders ride more on weekends
Members prefer classic bikes; casual riders use electric bikes more
Casual riders take longer rides on average
Promote membership to casual riders with weekend discounts
Increase bike availability during commute hours
Expand electric bike fleet for casual riders
Target marketing based on seasonal usage patterns