Baselight

Cyclistic Bikes: Members Vs. Casual Riders

Capstone project for Google Data Analytics Certificate

@kaggle.rachelcam17_cyclistic_bikes_members_vs_casual_riders

Loading...
Loading...

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
Loading...

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
Loading...

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
);

Share link

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