Context

A bike-sharing service is a shared transport service in which bicycles are made available for shared use to individuals on a short-term basis for a certain price or free. Many bike share systems allow people to borrow a bike from a station and return it at another station belonging to the same system.

Content

This dataset contains bike trips of a bike-sharing company in New York for one month. The dataset consists of ≈ 1.6M rows and 11 columns. The attributes are:
1. start_time (numeric): the time when a trip starts (in NYC local time).
2. stop_time (numeric): the time when a trip is over (in NYC local time).
3. start_station_id (categorical): a unique code to identify a station where a trip begins.
4. start_station_name (categorical): the name of a station where a trip begins.
5. end_station_id (categorical): a unique code to identify a station where a trip is over.
6. end_station_name (categorical): the name of a station where a trip is over.
7. user_type (categorical): the type of bike user.
8. bike_id (categorical): a unique code to identify a bike user.
9. gender (categorical): gender of the user.
10. age (numeric): age of the user.
11. trip_duration (numeric): the duration of a trip (in minutes).

Acknowledgements

The dataset was accessed from the big query public dataset.
Photo by Michael Walk on Unsplash

Inspiration

Based on the above dataset, try to find the answer to the following questions.

1. Who is the largest group of users in May 2018?
   (to answer this question, you may group the users based on some variables, e.g. user_type, gender, and age group).
2. How was the daily trend of the number of trips and number of users in May 2018?
3. What is the station that the users visit most in May 2018?