Dataset: Cyclistic Bikes: Members Vs. Casual Riders

About this Dataset

Cyclistic Bikes: Members Vs. Casual Riders

"How do members and casual riders of Cyclistic Bikes use the bikes differently?"

I'm analyzing the dataset to find how the different rider types of Cyclistic Bikes use the bikes differently. This uses 1st Quarter (Jan-Mar) datasets provided in 2019 and 2020 from the Google Data Analytics Certificate.

Conclusion: Casual riders tend to use the rental bikes more frequently than Member riders. Casual riders tend to also ride longer in length during the work week, while members ride around the same length throughout the whole week. The number of riders in total did show an increase between 2019 Q1 and 2020 Q1, as highly suspected due to the impact of COVID-19.

This analysis is part of my first-ever capstone project as I become a data analyst! (Suggestions on improving readability is highly appreciated)

Tables

Clean Divvy Trips 2020 Q1

@kaggle.rachelcam17_cyclistic_bikes_members_vs_casual_riders.clean_divvy_trips_2020_q1

20.32 MB
426468 rows
19 columns


CREATE TABLE clean_divvy_trips_2020_q1 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" BIGINT,
  "end_station_name" VARCHAR,
  "end_station_id" BIGINT,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR,
  "ride_length" VARCHAR,
  "day_of_week" BIGINT,
  "mean_of_ride_length" VARCHAR,
  "max_ride_length" VARCHAR,
  "unique_members" VARCHAR,
  "avg_ride_length" VARCHAR
);

Clean Divvy Trips 2019 Q1

@kaggle.rachelcam17_cyclistic_bikes_members_vs_casual_riders.clean_divvy_trips_2019_q1

12.16 MB
365069 rows
15 columns


CREATE TABLE clean_divvy_trips_2019_q1 (
  "trip_id" BIGINT,
  "start_time" TIMESTAMP,
  "end_time" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR,
  "gender" VARCHAR,
  "birthyear" DOUBLE,
  "ride_length" VARCHAR,
  "day_of_week" BIGINT,
  "mean_of_ride_length" VARCHAR
);