Divvy Trips
Comparison between casual user and subscribers on how they use bikes.
@kaggle.fahrettingazicen_divvy_trips
Comparison between casual user and subscribers on how they use bikes.
@kaggle.fahrettingazicen_divvy_trips
Context
Used dataset provided by Coursera Google Data Analytics course.
Content
Dataset provides information about 'casual' users and 'subscriber' users on how they use bikes. Allows to observe specific attributes of each user type.
CREATE TABLE all_trips_v2 (
"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,
"date" TIMESTAMP,
"month" BIGINT,
"day" BIGINT,
"year" BIGINT,
"day_of_week" VARCHAR
);Anyone who has the link will be able to view this.