How successful is Lyft at BayWheels?
Team Members - Himank Dave (hjdvae2) and Madhura Kulkarni (msk10)
Bay Wheels is a regional public bicycle sharing system in the San Francisco Bay Area of California. Lyft Bikes and Scooters, LLC (“Bikeshare”) operates the Bay Wheels bicycle sharing service. The original data consists of data from 2017 to October 2022. But, we decided to go with 2021 and 2022 data. This was very large in in itself and hence, we downsampled the data to 50,000 observations to make the visualizations. Data includes rider’s information regarding the type of the bike and details about the source and destination of the station. The EDA and the code to get the final data can be found here
Rides per bike-type VS Year
We were interested to find out the most-used bike-type. In the above visualization, we can see the distribution of number of rides over different bike-types in the year 2021 and 2022. Surprisingly, the number of rides taken for the docked bike is extremely less as compared to the other two-bike types.
Moving forward, we wanted to know the subscription pattern of the riders. From the above nested pie chart, we can conclude that number of casual riders and member riders are fairly the same in 2021 as well as 2022. One important thing to note down here is that our data has records till October 2022 and clearly the use of the Bikeshare service has increased than the past year.
Contextual Visualizations
For contextual visualizations, we decided to go with one of the popular bike-sharing services in United States which is the Citi-bike for NYC. For our analysis, due to memory constraints, we used the data for the year 2021 only. The below two visualizations were built in Tableau.
From the above visualizations, we can infer that number of riders riding the docked-bike is significantly high and most of the riders using the citi-bike service are subscribed to their service. The main conclusion to conclude from all the above visualizations is that Baywheels team definitely need to consider their low docked-bike riders and how they can increase their subscribers for overall popularity and profit.