Cyclisitic Trip Data 2019 (Google)

Take a look at my first case study! I had a lot of fun making this.

@kaggle.shainepepper_divvy_2019_trip_data_clean

Table List

1 table(28.52 MB)

Divvy Clean 2019 Final

@kaggle.shainepepper_divvy_2019_trip_data_clean.divvy_clean_2019_final

28.52 MB
1005523 rows
12 columns

trip_id Trip Id	start_time Start Time	end_time End Time	bike_id Bike Id	from_station_id From Station Id	from_station_name From Station Name	to_station_id To Station Id	to_station_name To Station Name	user_type User Type	gender Gender	birth_year Birth Year	trip_duration Trip Duration
21742446	Tue Jan 01 2019 00:13:45 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:43:28 GMT+0000 (Coordinated Universal Time)	252	123	California Ave & Milwaukee Ave	176	Clark St & Elm St	Subscriber	Male	1993	1783
21742449	Tue Jan 01 2019 00:16:06 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:19:03 GMT+0000 (Coordinated Universal Time)	2708	98	LaSalle St & Washington St	49	Dearborn St & Monroe St	Subscriber	Male	1984	177
21742450	Tue Jan 01 2019 00:18:41 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:20:21 GMT+0000 (Coordinated Universal Time)	2796	211	St. Clair St & Erie St	142	McClurg Ct & Erie St	Subscriber	Male	1990
21742451	Tue Jan 01 2019 00:18:43 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:47:30 GMT+0000 (Coordinated Universal Time)	6205	150	Fort Dearborn Dr & 31st St	148	State St & 33rd St	Subscriber	Male	1995	1727
21742460	Tue Jan 01 2019 00:24:27 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:47:03 GMT+0000 (Coordinated Universal Time)	5777	268	Lake Shore Dr & North Blvd	319	Greenview Ave & Diversey Pkwy	Customer	Female	1990	1356
21742461	Tue Jan 01 2019 00:25:28 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:27:10 GMT+0000 (Coordinated Universal Time)	3940	35	Streeter Dr & Grand Ave	35	Streeter Dr & Grand Ave	Subscriber	Male	1985	2
21742466	Tue Jan 01 2019 00:29:47 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:49:15 GMT+0000 (Coordinated Universal Time)	5026	85	Michigan Ave & Oak St	329	Lake Shore Dr & Diversey Pkwy	Subscriber	Male	1959	1168
21742468	Tue Jan 01 2019 00:33:09 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:50:25 GMT+0000 (Coordinated Universal Time)	2630	13	Wilton Ave & Diversey Pkwy	61	Wood St & Milwaukee Ave	Subscriber	Male	1991	136
21742475	Tue Jan 01 2019 00:45:37 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 01:17:51 GMT+0000 (Coordinated Universal Time)	5583	464	Damen Ave & Foster Ave	30	Ashland Ave & Augusta Blvd	Subscriber	Male	1991	1934
21742480	Tue Jan 01 2019 00:51:55 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:54:49 GMT+0000 (Coordinated Universal Time)	5629	206	Halsted St & Archer Ave	135	Halsted St & 21st St	Subscriber	Male	1989	174


CREATE TABLE divvy_clean_2019_final (
  "trip_id" DOUBLE,
  "start_time" TIMESTAMP,
  "end_time" TIMESTAMP,
  "bike_id" DOUBLE,
  "from_station_id" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_id" DOUBLE,
  "to_station_name" VARCHAR,
  "user_type" VARCHAR,
  "gender" VARCHAR,
  "birth_year" DOUBLE,
  "trip_duration" DOUBLE
);