Embedded Files
Business Task
Business Task
Identify how casual riders use bike share services differently than members.
Bike Share data provided by Motivate International Inc. Please refer to the following link to retrieve original data sets:https://divvy-tripdata.s3.amazonaws.com/index.html. Of the data sets provided, this case study focuses on bike share data collected from April 2020 to March 2021.
Process and Clean Data
Process and Clean Data
Install necessary packages
Import previous 12 months worth of ride share data sets
Inspect Column names
Convert Data type/class from numeric to character
Rename columns
Ensure column names have been renamed and that data type is correct
Union Data frames
Remove unnecessary columns
View BikeTime tibble and inspect attributes
Parse out date and times in preparation for datetime analysis
Convert Character Class to numeric in order to perform calculations
Remove unwanted data from specified columns
Aggregate column Ride Length and group by User Type and compare the summary statistics
Analysis and Visualization
Analysis and Visualization
Find Average ride time by day of week
Plot average ride time by day of week
Plot number of rides per weekday
Omit observations that contain NA values and replot
Find average number of trips by time of day
Plot average number of trips by hour
Find both the total rides and average ride time by month
Plot total rides by month
Plot average ride time by month
Observations
Observations
Members take more trips during the weekday
Casual riders take more trips during the weekend
The average trip duration for members clocks in at around 20 minutes or less
The average trip duration for casual riders falls between 50 and 60+ minutes
Members tend to take more trips during the morning hours of 6 and 9 a.m., the lunch hours of 11 a.m. and 1 p.m., and evening hours of 4 and 6 p.m.
Casual rides are most frequent during the times of 12 and 5 p.m.
RIdership increases during summer months
While the average trip duration for both Members and Casual riders increase during the summer months, members' trip duration is the most consistent regardless of season
Conclusion
Conclusion
While casual riders tend to take longer trips on average, members use the ride share service more consistently and make up the majority of total rides.
Page updated
Google Sites
Report abuse