Data from Edinburgh’s Just Eat bicycle hire scheme from January 2021
The assignment requires you to analyse data from Edinburgh’s Just Eat bicycle hire scheme from January 2021. The data include trips with a duration of at least one minute, made during Just Eat Cycles’ regular opening times. This excludes cancelled trips and bikes moved by the JustEat team.
Variable definitions are given below:
Variables Format Description
started_at Timestamp Timestamp of when the trip started
ended_at Timestamp Timestamp of when the trip ended
duration Integer Duration of trip in seconds
start_station_id String Unique ID for start station
start_station_name String Name of start station
start_station_description String Description of where start station is located
start_station_latitude Decimal degrees in WGS84 Latitude of start station
start_station_longitude Decimal degrees in WGS84 Longitude of start station
end_station_id String Unique ID for end station
end_station_name String Name of end station
end_station_description String Description of where end station is located
end_station_latitude Decimal degrees in WGS84 Latitude of end station
end_station_longitude Decimal degrees in WGS84 Longitude of end station
Questions
Give summary statistics for the trip duration along with your interpretation of the results.
Plot the distribution of the trip duration.
Plot how many trips start at each of the 10 most popular stations for trips to start at.
Make a table showing the 10 most popular origin-destination pairs and the number of trips between them.
Plot the distribution of trip duration for each of the 10 most popular stations for trips to start at.
