Rental Bike Sharing Dataset

Rental Bike sharing in 2011 and 2012 based on given attributes

@kaggle.imakash3011_rental_bike_sharing

Table List

2 tables(296.89 KB)

Hour

@kaggle.imakash3011_rental_bike_sharing.hour

244.89 KB
17379 rows
17 columns

instant Instant	dteday Dteday	season Season	mnth Mnth	hr Hr	weekday Weekday	weathersit Weathersit	temp Temp	atemp Atemp	hum Hum	windspeed Windspeed	casual Casual	registered Registered	cnt Cnt
1	Sat Jan 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1		6	1	0.24	0.2879	0.81		3	13	16
2	Sat Jan 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	1	6	1	0.22	0.2727	0.8		8	32	40
3	Sat Jan 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	2	6	1	0.22	0.2727	0.8		5	27	32
4	Sat Jan 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	3	6	1	0.24	0.2879	0.75		3	10	13
5	Sat Jan 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	4	6	1	0.24	0.2879	0.75			1	1
6	Sat Jan 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	5	6	2	0.24	0.2576	0.75	0.0896		1	1
7	Sat Jan 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	6	6	1	0.22	0.2727	0.8		2		2
8	Sat Jan 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	7	6	1	0.2	0.2576	0.86		1	2	3
9	Sat Jan 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	8	6	1	0.24	0.2879	0.75		1	7	8
10	Sat Jan 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	9	6	1	0.32	0.3485	0.76		8	6	14


CREATE TABLE hour (
  "instant" BIGINT,
  "dteday" TIMESTAMP,
  "season" BIGINT,
  "yr" BIGINT,
  "mnth" BIGINT,
  "hr" BIGINT,
  "holiday" BIGINT,
  "weekday" BIGINT,
  "workingday" BIGINT,
  "weathersit" BIGINT,
  "temp" DOUBLE,
  "atemp" DOUBLE,
  "hum" DOUBLE,
  "windspeed" DOUBLE,
  "casual" BIGINT,
  "registered" BIGINT,
  "cnt" BIGINT
);