A simple analysis of Uber pickups
As we all know about the Uber rides, and the revolution it made in 21st century. It provides us an easy and effective way to book a ride with no efforts.
Today, we are going to do a simple analysis of Uber pickups in New York. I took the data set from kaggle to perform this analysis. You can check out these datasets here. The full data set consists of 6 months data of year 2014 starting from April to September, and have about 4.5 million of records.
Now, what kind of questions can we arise in order to make the analysis fruitful? So here I’ve just listed down some of the common question that we are going to answer by analyzing the data. Okay, so the questions or objectives are :
- Growth in rides/pickups along time
- Hours of the day which were busy enough
- Days of week which had more number of pickups
- Impact of holidays on pickups and much more.
The questions are pretty simple to answer. We will use some visualizations or graphs, which will help us to get the answer of above questions.
So, let’s dive into the analysis.
1. Growth in rides/pickups along time -
We can see positive growth in rides during the six months. Number of pickups were less in April, but month by month they increased amazingly and at the end of September 2014, rides increased by more than 1.5%. This shows that people started using uber cabs for transportation at a large scale, also drivers started using uber.
So, our answer is yes, there was a growth in rides/pickups.
2. Hours of the day which were busy enough -
There was a rush from afternoon to evening. This says that most of the rides were taken after 10 A.M.. Because people use to go anywhere at this time whether it is trip, college, office, school etc. Most of the works are done during afternoon to evening and people visit different places at this time so this can be the reason for large number of pickups.
Rides were less between the hours 0–7 as compared to other hours because people sleep at this time.
So, the most busy hours of a day start from 10 A.M. and end at 11 P.M..
3. Days of week which had more number of pickups -
Rides on Sunday and Monday were less as compare to other days. Sunday had very less rides, it may be due to weekend or most places like school, college and offices are closed on Sunday and most of the people stay at home.
Between Tuesday and Saturday, there are so many rides because these are working days.
4. Impact of holidays on pickups -
During these six months that is from April to September 2014, there were three holidays:
- Memorial day : (May 26)
- Independence day : (July 4)
- Labor Day : (September 1)
All the graphs have the same conclusion, that pickups were very less on holidays. In the month of May, there was a holiday for Memorial day and at that day pickups were lowest for that month. This was the same case with July and September.
This is because most of the places were closed, and people were not taking rides as usual because of the holidays. So, holidays were those days when uber has less pickups as compare to other days.
Now, what else?
As we can see more pickups were there after 13:00, because this is the usual time when people visit place like malls, hospitals etc. Also we can observe the hours 7–8 have more pickups, may be students were taking the rides during these hours between Monday to Friday.
Also, pickups were higher in late night on Friday and Saturday, because the next day they have weekends and it’s a common thing that people enjoy their weekends till late night. Again, Sunday has very less rides as compare to other days followed by Monday.
So, this was a small analysis. I tried to show some insights that I got by analyzing the data. I hope you would like this small and simple analysis.