Context

Sourced from an open-data repository, the dataset is provided by a Chicago-based bike-sharing company. It includes information about trips made with the bike-sharing service and the available bike-dock stations. Initially assigned as part of the Google Data Analytics course, I was tasked with analyzing a bike-sharing service dataset for insights. This led me to an open-data source, and after a thorough data cleaning process, the finalized dataset is now shared on this page. Further details about the data cleaning process can be found in this Medium story.

Content: Data Descriptions

Within the dataset package, you will find two distinct schemas or tables: 'trips' and 'stations,' each contained in the form of a CSV file.

1. Trips Table

The trips table contains records of trips done with the bike-sharing service. The fields for this table are:

• trip_id: unique ID attached to each trip taken
• starttime: date and time trip started, in CST
• stoptime: date and time trip ended, in CST
• bikeid: ID attached to each bike
• tripduration: time of trip in seconds
• from_station_name: name of station where trip originated
• to_station_name: name of station where trip terminated
• from_station_id: ID of station where trip originated
• to_station_id: ID of station where trip terminated
• usertype: "Customer" is a rider who purchased a 24-Hour Pass; "Subscriber" is a rider who purchased an Annual Membership
• gender: gender of rider, only available for Subscribers i.e. NULL for “Customer”
• birthyear: birth year of rider, only available for Subscribers i.e. NULL for “Customer”

2. Stations Table

The stations table contains records of available bike-dock stations as of 2016. The fields for this table are:

• id: unique ID attached to each station
• station_name: station name
• latitude: station latitude
• longitude: station longitude
• dpcapacity: number of total docks at each station as of 12/31/2016
• online_date: date the station went live in the system

Acknowledgements: Sources & License

Original (raw-data) source can be found here, provided under the license.