{ "cells": [ { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [], "source": [ "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "import numpy as np\n", "\n", "from keras.models import Sequential\n", "from keras.layers import Dense, Activation\n", "from keras.activations import relu, sigmoid\n", "\n", "from sklearn.preprocessing import StandardScaler\n", "\n", "%matplotlib inline" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Description of the data:\n", "\n", "- instant: record index\n", "- dteday : date\n", "- season : season (1:springer, 2:summer, 3:fall, 4:winter)\n", "- yr : year (0: 2011, 1:2012)\n", "- mnth : month ( 1 to 12)\n", "- hr : hour (0 to 23)\n", "- holiday : weather day is holiday or not (extracted from [Web Link])\n", "- weekday : day of the week\n", "- workingday : if day is neither weekend nor holiday is 1, otherwise is 0.\n", "+ weathersit : \n", " - 1: Clear, Few clouds, Partly cloudy, Partly cloudy\n", " - 2: Mist + Cloudy, Mist + Broken clouds, Mist + Few clouds, Mist\n", " - 3: Light Snow, Light Rain + Thunderstorm + Scattered clouds, Light Rain + Scattered clouds\n", " - 4: Heavy Rain + Ice Pallets + Thunderstorm + Mist, Snow + Fog\n", "- temp : Normalized temperature in Celsius. The values are derived via (t-t_min)/(t_max-t_min), t_min=-8, t_max=+39 (only in hourly scale)\n", "- atemp: Normalized feeling temperature in Celsius. The values are derived via (t-t_min)/(t_max-t_min), t_min=-16, t_max=+50 (only in hourly scale)\n", "- hum: Normalized humidity. The values are divided to 100 (max)\n", "- windspeed: Normalized wind speed. The values are divided to 67 (max)\n", "- casual: count of casual users\n", "- registered: count of registered users\n", "- cnt: count of total rental bikes including both casual and registered" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/Users/sachin/anaconda/lib/python3.5/site-packages/pandas/core/ops.py:533: PerformanceWarning: Adding/subtracting array of DateOffsets to Series not vectorized\n", " \"Series not vectorized\", PerformanceWarning)\n" ] }, { "data": { "text/html": [ "
| \n", " | season | \n", "mnth | \n", "hr | \n", "holiday | \n", "weekday | \n", "workingday | \n", "weathersit | \n", "temp | \n", "hum | \n", "windspeed | \n", "cnt | \n", "time | \n", "t | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "6 | \n", "0 | \n", "1 | \n", "0.24 | \n", "0.81 | \n", "0.0 | \n", "16 | \n", "2011-01-01 00:00:00 | \n", "1.293840e+18 | \n", "
| 1 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "6 | \n", "0 | \n", "1 | \n", "0.22 | \n", "0.80 | \n", "0.0 | \n", "40 | \n", "2011-01-01 01:00:00 | \n", "1.293844e+18 | \n", "
| 2 | \n", "1 | \n", "1 | \n", "2 | \n", "0 | \n", "6 | \n", "0 | \n", "1 | \n", "0.22 | \n", "0.80 | \n", "0.0 | \n", "32 | \n", "2011-01-01 02:00:00 | \n", "1.293847e+18 | \n", "
| 3 | \n", "1 | \n", "1 | \n", "3 | \n", "0 | \n", "6 | \n", "0 | \n", "1 | \n", "0.24 | \n", "0.75 | \n", "0.0 | \n", "13 | \n", "2011-01-01 03:00:00 | \n", "1.293851e+18 | \n", "
| 4 | \n", "1 | \n", "1 | \n", "4 | \n", "0 | \n", "6 | \n", "0 | \n", "1 | \n", "0.24 | \n", "0.75 | \n", "0.0 | \n", "1 | \n", "2011-01-01 04:00:00 | \n", "1.293854e+18 | \n", "
| \n", " | temp | \n", "hum | \n", "windspeed | \n", "cnt | \n", "time | \n", "t | \n", "season_1 | \n", "season_2 | \n", "season_3 | \n", "season_4 | \n", "... | \n", "weekday_3 | \n", "weekday_4 | \n", "weekday_5 | \n", "weekday_6 | \n", "workingday_0 | \n", "workingday_1 | \n", "weathersit_1 | \n", "weathersit_2 | \n", "weathersit_3 | \n", "weathersit_4 | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "0.24 | \n", "0.81 | \n", "0.0 | \n", "16 | \n", "2011-01-01 00:00:00 | \n", "1.293840e+18 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 1 | \n", "0.22 | \n", "0.80 | \n", "0.0 | \n", "40 | \n", "2011-01-01 01:00:00 | \n", "1.293844e+18 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 2 | \n", "0.22 | \n", "0.80 | \n", "0.0 | \n", "32 | \n", "2011-01-01 02:00:00 | \n", "1.293847e+18 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 3 | \n", "0.24 | \n", "0.75 | \n", "0.0 | \n", "13 | \n", "2011-01-01 03:00:00 | \n", "1.293851e+18 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 4 | \n", "0.24 | \n", "0.75 | \n", "0.0 | \n", "1 | \n", "2011-01-01 04:00:00 | \n", "1.293854e+18 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
5 rows × 61 columns
\n", "| \n", " | temp | \n", "hum | \n", "windspeed | \n", "cnt | \n", "time | \n", "t | \n", "season_1 | \n", "season_2 | \n", "season_3 | \n", "season_4 | \n", "... | \n", "weekday_3 | \n", "weekday_4 | \n", "weekday_5 | \n", "weekday_6 | \n", "workingday_0 | \n", "workingday_1 | \n", "weathersit_1 | \n", "weathersit_2 | \n", "weathersit_3 | \n", "weathersit_4 | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "-1.334648 | \n", "0.947372 | \n", "-1.553889 | \n", "-0.956339 | \n", "2011-01-01 00:00:00 | \n", "-1.745435 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 1 | \n", "-1.438516 | \n", "0.895539 | \n", "-1.553889 | \n", "-0.824022 | \n", "2011-01-01 01:00:00 | \n", "-1.745236 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 2 | \n", "-1.438516 | \n", "0.895539 | \n", "-1.553889 | \n", "-0.868128 | \n", "2011-01-01 02:00:00 | \n", "-1.745038 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 3 | \n", "-1.334648 | \n", "0.636370 | \n", "-1.553889 | \n", "-0.972879 | \n", "2011-01-01 03:00:00 | \n", "-1.744840 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
| 4 | \n", "-1.334648 | \n", "0.636370 | \n", "-1.553889 | \n", "-1.039037 | \n", "2011-01-01 04:00:00 | \n", "-1.744641 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
5 rows × 61 columns
\n", "