Baselight
Sign In

Cyclist Capstone Project

Data comparing casual and member bike riders in Chicago from 11/2021 - 10/2022

@kaggle.nixonthao_cyclist_capstone_project

Loading...
Loading...

About this Dataset

Cyclist Capstone Project

Here are 12 months of data on the divvy bicycle sharing service in Chicago. The data was combined to a data frame in which combined all the month's data into one. Therefore, the data was cleaned, organized, sorted, and filtered to find key takeaways on increase rental memberships.

Data is from November 2021 - October 2022
There are 13 columns:
RIDE_ID
RIDEABLE_TYPE
STARTED_AT
ENDED_AT
START_STATION_NAME
START_STATION_ID
END_STATION_NAME
END_STATION_ID
START_LAT
START_LNG

I added two columns, Ride_Length and WeekDays, in R to find more data for the business task.

Here are the files and overall markdown.

Tables

Apr 2022

@kaggle.nixonthao_cyclist_capstone_project.apr_2022
  • 14.42 MB
  • 371,249 rows
  • 13 columns
Loading... 
CREATE TABLE apr_2022 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

Aug 2022

@kaggle.nixonthao_cyclist_capstone_project.aug_2022
  • 30.68 MB
  • 785,932 rows
  • 13 columns
Loading... 
CREATE TABLE aug_2022 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

Dec 2021

@kaggle.nixonthao_cyclist_capstone_project.dec_2021
  • 10.36 MB
  • 247,540 rows
  • 13 columns
Loading... 
CREATE TABLE dec_2021 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

Feb 2022

@kaggle.nixonthao_cyclist_capstone_project.feb_2022
  • 4.76 MB
  • 115,609 rows
  • 13 columns
Loading... 
CREATE TABLE feb_2022 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

Jan 2022

@kaggle.nixonthao_cyclist_capstone_project.jan_2022
  • 4.38 MB
  • 103,770 rows
  • 13 columns
Loading... 
CREATE TABLE jan_2022 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

July 2022

@kaggle.nixonthao_cyclist_capstone_project.july_2022
  • 31.74 MB
  • 823,488 rows
  • 13 columns
Loading... 
CREATE TABLE july_2022 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

June 2022

@kaggle.nixonthao_cyclist_capstone_project.june_2022
  • 28.52 MB
  • 769,204 rows
  • 13 columns
Loading... 
CREATE TABLE june_2022 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

Mar 2022

@kaggle.nixonthao_cyclist_capstone_project.mar_2022
  • 11.02 MB
  • 284,042 rows
  • 13 columns
Loading... 
CREATE TABLE mar_2022 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

May 2022

@kaggle.nixonthao_cyclist_capstone_project.may_2022
  • 24.02 MB
  • 634,858 rows
  • 13 columns
Loading... 
CREATE TABLE may_2022 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202111 Divvy Tripdata

@kaggle.nixonthao_cyclist_capstone_project.n_202111_divvy_tripdata
  • 20.18 MB
  • 359,978 rows
  • 13 columns
Loading... 
CREATE TABLE n_202111_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202112 Divvy Tripdata

@kaggle.nixonthao_cyclist_capstone_project.n_202112_divvy_tripdata
  • 13.23 MB
  • 247,540 rows
  • 13 columns
Loading... 
CREATE TABLE n_202112_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202201 Divvy Tripdata

@kaggle.nixonthao_cyclist_capstone_project.n_202201_divvy_tripdata
  • 5.54 MB
  • 103,770 rows
  • 13 columns
Loading... 
CREATE TABLE n_202201_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202202 Divvy Tripdata

@kaggle.nixonthao_cyclist_capstone_project.n_202202_divvy_tripdata
  • 6.11 MB
  • 115,609 rows
  • 13 columns
Loading... 
CREATE TABLE n_202202_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202203 Divvy Tripdata

@kaggle.nixonthao_cyclist_capstone_project.n_202203_divvy_tripdata
  • 14.24 MB
  • 284,042 rows
  • 13 columns
Loading... 
CREATE TABLE n_202203_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202204 Divvy Tripdata

@kaggle.nixonthao_cyclist_capstone_project.n_202204_divvy_tripdata
  • 18.67 MB
  • 371,249 rows
  • 13 columns
Loading... 
CREATE TABLE n_202204_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202205 Divvy Tripdata

@kaggle.nixonthao_cyclist_capstone_project.n_202205_divvy_tripdata
  • 31.33 MB
  • 634,858 rows
  • 13 columns
Loading... 
CREATE TABLE n_202205_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202206 Divvy Tripdata

@kaggle.nixonthao_cyclist_capstone_project.n_202206_divvy_tripdata
  • 37.52 MB
  • 769,204 rows
  • 13 columns
Loading... 
CREATE TABLE n_202206_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202207 Divvy Tripdata

@kaggle.nixonthao_cyclist_capstone_project.n_202207_divvy_tripdata
  • 41.31 MB
  • 823,488 rows
  • 13 columns
Loading... 
CREATE TABLE n_202207_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202208 Divvy Tripdata

@kaggle.nixonthao_cyclist_capstone_project.n_202208_divvy_tripdata
  • 39.81 MB
  • 785,932 rows
  • 13 columns
Loading... 
CREATE TABLE n_202208_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202209 Divvy Publictripdata

@kaggle.nixonthao_cyclist_capstone_project.n_202209_divvy_publictripdata
  • 35.42 MB
  • 701,339 rows
  • 13 columns
Loading... 
CREATE TABLE n_202209_divvy_publictripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202210 Divvy Tripdata

@kaggle.nixonthao_cyclist_capstone_project.n_202210_divvy_tripdata
  • 28.36 MB
  • 558,685 rows
  • 13 columns
Loading... 
CREATE TABLE n_202210_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

Nov 2021

@kaggle.nixonthao_cyclist_capstone_project.nov_2021
  • 16.06 MB
  • 359,978 rows
  • 13 columns
Loading... 
CREATE TABLE nov_2021 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

Oct 2022

@kaggle.nixonthao_cyclist_capstone_project.oct_2022
  • 21.98 MB
  • 558,685 rows
  • 13 columns
Loading... 
CREATE TABLE oct_2022 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

Sept 2022

@kaggle.nixonthao_cyclist_capstone_project.sept_2022
  • 27.2 MB
  • 701,339 rows
  • 13 columns
Loading... 
CREATE TABLE sept_2022 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

Share link

Anyone who has the link will be able to view this.