Seoul Bike Trip Duration Prediction

Predict the Bike Trip Duration while considering atmospheric factors

@kaggle.saurabhshahane_seoul_bike_trip_duration_prediction

Table List

1 table(166.25 MB)

For Modeling

@kaggle.saurabhshahane_seoul_bike_trip_duration_prediction.for_modeling

166.25 MB
9601139 rows
26 columns

unnamed_0 Unnamed: 0	duration Duration	distance Distance	plong PLong	platd PLatd	dlong DLong	dlatd DLatd	haversine Haversine	pmonth Pmonth	pday Pday	pmin Pmin	dmonth Dmonth	dday Dday	dmin Dmin	temp Temp	wind Wind	humid Humid	groundtemp GroundTemp	dust Dust
	3	50	37.544666	126.888359	37.544666	126.888359		1	1		1	1	4	-3.2	0.5	40	-2.2	25
1	24	7670	37.506199	127.003944	37.55125	127.035103	5.713528999751687	1	1		1	1	25	-3.2	0.5	40	-2.2	25
2	8	1390	37.54459	127.057083	37.537014	127.061096	0.9137016437363148	1	1		1	1	9	-3.2	0.5	40	-2.2	25
3	8	1820	37.571102	127.02356	37.561447	127.03492	1.4680270819019492	1	1	1	1	1	10	-3.2	0.5	40	-2.2	25
4	4	850	37.573242	127.015907	37.565849	127.016403	0.823226716442688	1	1	1	1	1	6	-3.2	0.5	40	-2.2	25
5	8	1800	37.571102	127.02356	37.561447	127.03492	1.4680270819019492	1	1	1	1	1	10	-3.2	0.5	40	-2.2	25
6	25	4770	37.593288	127.036667	37.5825	126.998535	3.5676435605172747	1	1	1	1	1	27	-3.2	0.5	40	-2.2	25
7	4	630	37.552914	126.836571	37.557968	126.838287	0.5819823196118913	1	1	2	1	1	6	-3.2	0.5	40	-2.2	25
8	3	950	37.45995300000001	127.024742	37.455799	127.016289	0.8775242011717056	1	1	2	1	1	5	-3.2	0.5	40	-2.2	25
9	25	3900	37.527122	127.028717	37.539654	127.05258899999998	2.524430309608685	1	1	2	1	1	28	-3.2	0.5	40	-2.2	25


CREATE TABLE for_modeling (
  "unnamed_0" BIGINT,
  "duration" BIGINT,
  "distance" BIGINT,
  "plong" DOUBLE,
  "platd" DOUBLE,
  "dlong" DOUBLE,
  "dlatd" DOUBLE,
  "haversine" DOUBLE,
  "pmonth" BIGINT,
  "pday" BIGINT,
  "phour" BIGINT,
  "pmin" BIGINT,
  "pdweek" BIGINT,
  "dmonth" BIGINT,
  "dday" BIGINT,
  "dhour" BIGINT,
  "dmin" BIGINT,
  "ddweek" BIGINT,
  "temp" DOUBLE,
  "precip" DOUBLE,
  "wind" DOUBLE,
  "humid" DOUBLE,
  "solar" DOUBLE,
  "snow" DOUBLE,
  "groundtemp" DOUBLE,
  "dust" DOUBLE
);