aluguel_bike_final.ipynb

{"cells":[{"metadata":{"trusted":true},"cell_type":"code","source":"import numpy as np\nimport pandas as pd","execution_count":6,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"data = pd.read_csv('bikes.csv')\ndata.head()","execution_count":7,"outputs":[{"output_type":"execute_result","execution_count":7,"data":{"text/plain":"     city      dteday  season  yr  mkt  mnth  holiday  weekday  workingday  \\\n0  city_0  2011-01-01       1   0    0     1        0        6           0   \n1  city_0  2011-01-02       1   0    0     1        0        0           0   \n2  city_0  2011-01-03       1   0    0     1        0        1           1   \n3  city_0  2011-01-04       1   0    0     1        0        2           1   \n4  city_0  2011-01-05       1   0    0     1        0        3           1   \n\n   weathersit      temp     atemp       hum  windspeed  stock   cnt  target  \n0           2  0.344167  0.363625  0.805833   0.160446    997   929  1257.0  \n1           2  0.363478  0.353739  0.696087   0.248539   1231   765  1096.0  \n2           1  0.196364  0.189405  0.437273   0.248309   1395  1395  1430.0  \n3           1  0.200000  0.212122  0.590435   0.160296   1651  1641   885.0  \n4           1  0.226957  0.229270  0.436957   0.186900   2334  1671  1210.0  ","text/html":"<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>city</th>\n      <th>dteday</th>\n      <th>season</th>\n      <th>yr</th>\n      <th>mkt</th>\n      <th>mnth</th>\n      <th>holiday</th>\n      <th>weekday</th>\n      <th>workingday</th>\n      <th>weathersit</th>\n      <th>temp</th>\n      <th>atemp</th>\n      <th>hum</th>\n      <th>windspeed</th>\n      <th>stock</th>\n      <th>cnt</th>\n      <th>target</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>city_0</td>\n      <td>2011-01-01</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0</td>\n      <td>6</td>\n      <td>0</td>\n      <td>2</td>\n      <td>0.344167</td>\n      <td>0.363625</td>\n      <td>0.805833</td>\n      <td>0.160446</td>\n      <td>997</td>\n      <td>929</td>\n      <td>1257.0</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>city_0</td>\n      <td>2011-01-02</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>2</td>\n      <td>0.363478</td>\n      <td>0.353739</td>\n      <td>0.696087</td>\n      <td>0.248539</td>\n      <td>1231</td>\n      <td>765</td>\n      <td>1096.0</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>city_0</td>\n      <td>2011-01-03</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>1</td>\n      <td>1</td>\n      <td>0.196364</td>\n      <td>0.189405</td>\n      <td>0.437273</td>\n      <td>0.248309</td>\n      <td>1395</td>\n      <td>1395</td>\n      <td>1430.0</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>city_0</td>\n      <td>2011-01-04</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0</td>\n      <td>2</td>\n      <td>1</td>\n      <td>1</td>\n      <td>0.200000</td>\n      <td>0.212122</td>\n      <td>0.590435</td>\n      <td>0.160296</td>\n      <td>1651</td>\n      <td>1641</td>\n      <td>885.0</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>city_0</td>\n      <td>2011-01-05</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0</td>\n      <td>3</td>\n      <td>1</td>\n      <td>1</td>\n      <td>0.226957</td>\n      <td>0.229270</td>\n      <td>0.436957</td>\n      <td>0.186900</td>\n      <td>2334</td>\n      <td>1671</td>\n      <td>1210.0</td>\n    </tr>\n  </tbody>\n</table>\n</div>"},"metadata":{}}]},{"metadata":{"trusted":true},"cell_type":"code","source":"data.columns","execution_count":12,"outputs":[{"output_type":"execute_result","execution_count":12,"data":{"text/plain":"Index(['city', 'dteday', 'season', 'yr', 'mkt', 'mnth', 'holiday', 'weekday',\n       'workingday', 'weathersit', 'temp', 'atemp', 'hum', 'windspeed',\n       'stock', 'cnt', 'target'],\n      dtype='object')"},"metadata":{}}]},{"metadata":{"trusted":true},"cell_type":"code","source":"Q1: Influência do clima na quantidade de bikes alugadas\nQ2: Diferença na quantidade de bikes alugadas em diferentes dias da semana\nQ3: Diferença da quantidade de bikes alugadas nos anos de 2011 e 2012","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"Light Snow, Light Rain + Thunderstorm + Scattered clouds, Light Rain + Scattered clouds","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"cnt_weather3 = data[data['weathersit'] == 3][['cnt','dteday']]\ncnt_weather3.sort_values(by=['cnt'], ascending = [True])","execution_count":26,"outputs":[{"output_type":"execute_result","execution_count":26,"data":{"text/plain":"         cnt      dteday\n28445      0  2012-10-29\n112510     0  2012-10-29\n69381      0  2012-10-29\n68650      0  2012-10-29\n10170      0  2012-10-29\n...      ...         ...\n132220  5744  2012-10-02\n67892   5749  2012-10-02\n84632   5793  2012-07-21\n119793  5842  2012-10-02\n96401   5934  2012-10-02\n\n[4200 rows x 2 columns]","text/html":"<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>cnt</th>\n      <th>dteday</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>28445</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>112510</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>69381</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>68650</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>10170</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>66457</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>24059</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>114703</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>63533</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>10901</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>59147</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>118358</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>58416</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>120551</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>57685</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>56223</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>55492</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>54030</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>52568</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>51106</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>12363</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>50375</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>48913</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>126399</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>70843</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>71574</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>146136</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>109586</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>21866</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>93504</th>\n      <td>0</td>\n      <td>2012-10-29</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>56123</th>\n      <td>5482</td>\n      <td>2012-07-21</td>\n    </tr>\n    <tr>\n      <th>94866</th>\n      <td>5493</td>\n      <td>2012-07-21</td>\n    </tr>\n    <tr>\n      <th>90480</th>\n      <td>5514</td>\n      <td>2012-07-21</td>\n    </tr>\n    <tr>\n      <th>15918</th>\n      <td>5515</td>\n      <td>2012-07-21</td>\n    </tr>\n    <tr>\n      <th>62775</th>\n      <td>5525</td>\n      <td>2012-10-02</td>\n    </tr>\n    <tr>\n      <th>56927</th>\n      <td>5526</td>\n      <td>2012-10-02</td>\n    </tr>\n    <tr>\n      <th>11605</th>\n      <td>5553</td>\n      <td>2012-10-02</td>\n    </tr>\n    <tr>\n      <th>92746</th>\n      <td>5565</td>\n      <td>2012-10-02</td>\n    </tr>\n    <tr>\n      <th>97790</th>\n      <td>5566</td>\n      <td>2012-07-21</td>\n    </tr>\n    <tr>\n      <th>19646</th>\n      <td>5604</td>\n      <td>2012-10-02</td>\n    </tr>\n    <tr>\n      <th>86094</th>\n      <td>5609</td>\n      <td>2012-07-21</td>\n    </tr>\n    <tr>\n      <th>90553</th>\n      <td>5612</td>\n      <td>2012-10-02</td>\n    </tr>\n    <tr>\n      <th>38579</th>\n      <td>5629</td>\n      <td>2012-07-21</td>\n    </tr>\n    <tr>\n      <th>106562</th>\n      <td>5630</td>\n      <td>2012-07-21</td>\n    </tr>\n    <tr>\n      <th>54661</th>\n      <td>5631</td>\n      <td>2012-07-21</td>\n    </tr>\n    <tr>\n      <th>139530</th>\n      <td>5635</td>\n      <td>2012-10-02</td>\n    </tr>\n    <tr>\n      <th>82439</th>\n      <td>5638</td>\n      <td>2012-07-21</td>\n    </tr>\n    <tr>\n      <th>64968</th>\n      <td>5644</td>\n      <td>2012-10-02</td>\n    </tr>\n    <tr>\n      <th>94939</th>\n      <td>5651</td>\n      <td>2012-10-02</td>\n    </tr>\n    <tr>\n      <th>117600</th>\n      <td>5666</td>\n      <td>2012-10-02</td>\n    </tr>\n    <tr>\n      <th>36386</th>\n      <td>5666</td>\n      <td>2012-07-21</td>\n    </tr>\n    <tr>\n      <th>108097</th>\n      <td>5669</td>\n      <td>2012-10-02</td>\n    </tr>\n    <tr>\n      <th>75860</th>\n      <td>5672</td>\n      <td>2012-07-21</td>\n    </tr>\n    <tr>\n      <th>75933</th>\n      <td>5676</td>\n      <td>2012-10-02</td>\n    </tr>\n    <tr>\n      <th>119062</th>\n      <td>5691</td>\n      <td>2012-10-02</td>\n    </tr>\n    <tr>\n      <th>132220</th>\n      <td>5744</td>\n      <td>2012-10-02</td>\n    </tr>\n    <tr>\n      <th>67892</th>\n      <td>5749</td>\n      <td>2012-10-02</td>\n    </tr>\n    <tr>\n      <th>84632</th>\n      <td>5793</td>\n      <td>2012-07-21</td>\n    </tr>\n    <tr>\n      <th>119793</th>\n      <td>5842</td>\n      <td>2012-10-02</td>\n    </tr>\n    <tr>\n      <th>96401</th>\n      <td>5934</td>\n      <td>2012-10-02</td>\n    </tr>\n  </tbody>\n</table>\n<p>4200 rows × 2 columns</p>\n</div>"},"metadata":{}}]},{"metadata":{"trusted":true},"cell_type":"code","source":"cnt_weather3.mean()","execution_count":35,"outputs":[{"output_type":"execute_result","execution_count":35,"data":{"text/plain":"cnt    1973.595\ndtype: float64"},"metadata":{}}]},{"metadata":{"trusted":true},"cell_type":"code","source":"Clear, Few clouds, Partly cloudy, Partly cloudy","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"cnt_weather1 = data[data['weathersit'] == 1][['cnt','dteday']]\ncnt_weather1.sort_values(by=['cnt'], ascending = [True])","execution_count":38,"outputs":[{"output_type":"execute_result","execution_count":38,"data":{"text/plain":"         cnt      dteday\n32921     50  2011-01-27\n58506     50  2011-01-27\n107814    50  2011-12-24\n107815    50  2011-12-25\n21211     50  2011-01-13\n...      ...         ...\n29146   9783  2012-09-29\n18167   9799  2012-09-15\n54731   9848  2012-09-29\n116852  9853  2012-09-15\n53986   9867  2012-09-15\n\n[92600 rows x 2 columns]","text/html":"<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>cnt</th>\n      <th>dteday</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>32921</th>\n      <td>50</td>\n      <td>2011-01-27</td>\n    </tr>\n    <tr>\n      <th>58506</th>\n      <td>50</td>\n      <td>2011-01-27</td>\n    </tr>\n    <tr>\n      <th>107814</th>\n      <td>50</td>\n      <td>2011-12-24</td>\n    </tr>\n    <tr>\n      <th>107815</th>\n      <td>50</td>\n      <td>2011-12-25</td>\n    </tr>\n    <tr>\n      <th>21211</th>\n      <td>50</td>\n      <td>2011-01-13</td>\n    </tr>\n    <tr>\n      <th>108940</th>\n      <td>50</td>\n      <td>2011-01-22</td>\n    </tr>\n    <tr>\n      <th>135974</th>\n      <td>50</td>\n      <td>2011-01-09</td>\n    </tr>\n    <tr>\n      <th>108945</th>\n      <td>50</td>\n      <td>2011-01-27</td>\n    </tr>\n    <tr>\n      <th>21225</th>\n      <td>50</td>\n      <td>2011-01-27</td>\n    </tr>\n    <tr>\n      <th>21228</th>\n      <td>50</td>\n      <td>2011-01-30</td>\n    </tr>\n    <tr>\n      <th>92863</th>\n      <td>50</td>\n      <td>2011-01-27</td>\n    </tr>\n    <tr>\n      <th>73857</th>\n      <td>50</td>\n      <td>2011-01-27</td>\n    </tr>\n    <tr>\n      <th>76045</th>\n      <td>50</td>\n      <td>2011-01-22</td>\n    </tr>\n    <tr>\n      <th>109277</th>\n      <td>50</td>\n      <td>2011-12-25</td>\n    </tr>\n    <tr>\n      <th>109659</th>\n      <td>50</td>\n      <td>2011-01-10</td>\n    </tr>\n    <tr>\n      <th>56298</th>\n      <td>50</td>\n      <td>2011-01-12</td>\n    </tr>\n    <tr>\n      <th>135261</th>\n      <td>50</td>\n      <td>2011-01-27</td>\n    </tr>\n    <tr>\n      <th>21956</th>\n      <td>50</td>\n      <td>2011-01-27</td>\n    </tr>\n    <tr>\n      <th>22287</th>\n      <td>50</td>\n      <td>2011-12-24</td>\n    </tr>\n    <tr>\n      <th>111120</th>\n      <td>50</td>\n      <td>2011-01-09</td>\n    </tr>\n    <tr>\n      <th>22687</th>\n      <td>50</td>\n      <td>2011-01-27</td>\n    </tr>\n    <tr>\n      <th>133794</th>\n      <td>50</td>\n      <td>2011-01-22</td>\n    </tr>\n    <tr>\n      <th>53721</th>\n      <td>50</td>\n      <td>2011-12-25</td>\n    </tr>\n    <tr>\n      <th>56313</th>\n      <td>50</td>\n      <td>2011-01-27</td>\n    </tr>\n    <tr>\n      <th>59219</th>\n      <td>50</td>\n      <td>2011-01-09</td>\n    </tr>\n    <tr>\n      <th>95787</th>\n      <td>50</td>\n      <td>2011-01-27</td>\n    </tr>\n    <tr>\n      <th>107483</th>\n      <td>50</td>\n      <td>2011-01-27</td>\n    </tr>\n    <tr>\n      <th>14642</th>\n      <td>50</td>\n      <td>2011-01-23</td>\n    </tr>\n    <tr>\n      <th>98711</th>\n      <td>50</td>\n      <td>2011-01-27</td>\n    </tr>\n    <tr>\n      <th>139636</th>\n      <td>50</td>\n      <td>2011-01-16</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>61310</th>\n      <td>9596</td>\n      <td>2012-09-29</td>\n    </tr>\n    <tr>\n      <th>18181</th>\n      <td>9601</td>\n      <td>2012-09-29</td>\n    </tr>\n    <tr>\n      <th>62034</th>\n      <td>9610</td>\n      <td>2012-09-22</td>\n    </tr>\n    <tr>\n      <th>32056</th>\n      <td>9616</td>\n      <td>2012-09-15</td>\n    </tr>\n    <tr>\n      <th>113942</th>\n      <td>9628</td>\n      <td>2012-09-29</td>\n    </tr>\n    <tr>\n      <th>80302</th>\n      <td>9635</td>\n      <td>2012-09-15</td>\n    </tr>\n    <tr>\n      <th>100784</th>\n      <td>9635</td>\n      <td>2012-09-29</td>\n    </tr>\n    <tr>\n      <th>131472</th>\n      <td>9652</td>\n      <td>2012-09-15</td>\n    </tr>\n    <tr>\n      <th>64234</th>\n      <td>9654</td>\n      <td>2012-09-29</td>\n    </tr>\n    <tr>\n      <th>5009</th>\n      <td>9663</td>\n      <td>2012-09-15</td>\n    </tr>\n    <tr>\n      <th>94191</th>\n      <td>9673</td>\n      <td>2012-09-15</td>\n    </tr>\n    <tr>\n      <th>54724</th>\n      <td>9689</td>\n      <td>2012-09-22</td>\n    </tr>\n    <tr>\n      <th>62027</th>\n      <td>9706</td>\n      <td>2012-09-15</td>\n    </tr>\n    <tr>\n      <th>64220</th>\n      <td>9715</td>\n      <td>2012-09-15</td>\n    </tr>\n    <tr>\n      <th>101501</th>\n      <td>9717</td>\n      <td>2012-09-15</td>\n    </tr>\n    <tr>\n      <th>25491</th>\n      <td>9728</td>\n      <td>2012-09-29</td>\n    </tr>\n    <tr>\n      <th>62041</th>\n      <td>9734</td>\n      <td>2012-09-29</td>\n    </tr>\n    <tr>\n      <th>54000</th>\n      <td>9741</td>\n      <td>2012-09-29</td>\n    </tr>\n    <tr>\n      <th>25477</th>\n      <td>9746</td>\n      <td>2012-09-15</td>\n    </tr>\n    <tr>\n      <th>65682</th>\n      <td>9754</td>\n      <td>2012-09-15</td>\n    </tr>\n    <tr>\n      <th>83957</th>\n      <td>9762</td>\n      <td>2012-09-15</td>\n    </tr>\n    <tr>\n      <th>92729</th>\n      <td>9766</td>\n      <td>2012-09-15</td>\n    </tr>\n    <tr>\n      <th>130010</th>\n      <td>9769</td>\n      <td>2012-09-15</td>\n    </tr>\n    <tr>\n      <th>65696</th>\n      <td>9769</td>\n      <td>2012-09-29</td>\n    </tr>\n    <tr>\n      <th>100770</th>\n      <td>9776</td>\n      <td>2012-09-15</td>\n    </tr>\n    <tr>\n      <th>29146</th>\n      <td>9783</td>\n      <td>2012-09-29</td>\n    </tr>\n    <tr>\n      <th>18167</th>\n      <td>9799</td>\n      <td>2012-09-15</td>\n    </tr>\n    <tr>\n      <th>54731</th>\n      <td>9848</td>\n      <td>2012-09-29</td>\n    </tr>\n    <tr>\n      <th>116852</th>\n      <td>9853</td>\n      <td>2012-09-15</td>\n    </tr>\n    <tr>\n      <th>53986</th>\n      <td>9867</td>\n      <td>2012-09-15</td>\n    </tr>\n  </tbody>\n</table>\n<p>92600 rows × 2 columns</p>\n</div>"},"metadata":{}}]},{"metadata":{"trusted":true},"cell_type":"code","source":"cnt_weather1.mean()","execution_count":37,"outputs":[{"output_type":"execute_result","execution_count":37,"data":{"text/plain":"cnt    5009.506793\ndtype: float64"},"metadata":{}}]},{"metadata":{"trusted":true},"cell_type":"code","source":"","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"data[data['weekday'] == 6][['weekday','cnt']].mean()","execution_count":69,"outputs":[{"output_type":"execute_result","execution_count":69,"data":{"text/plain":"weekday       6.000000\ncnt        4686.245048\ndtype: float64"},"metadata":{}}]},{"metadata":{"trusted":true},"cell_type":"code","source":"data[['weekday','cnt']].mean()","execution_count":61,"outputs":[{"output_type":"execute_result","execution_count":61,"data":{"text/plain":"weekday       2.997264\ncnt        4641.033352\ndtype: float64"},"metadata":{}}]},{"metadata":{"trusted":true},"cell_type":"code","source":"4360 ~ 4690 -> variação da média nos dias da semana","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"Quantidade de bikes alugadas nos anos de 2011 e 2012","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"scrolled":true},"cell_type":"code","source":"data[data['yr'] == 0]['cnt'].sum()","execution_count":83,"outputs":[{"output_type":"execute_result","execution_count":83,"data":{"text/plain":"262768114"},"metadata":{}}]},{"metadata":{"trusted":true},"cell_type":"code","source":"data[data['yr'] == 1]['cnt'].sum()","execution_count":80,"outputs":[{"output_type":"execute_result","execution_count":80,"data":{"text/plain":"415750962"},"metadata":{}}]}],"metadata":{"kernelspec":{"name":"python3","display_name":"Python 3","language":"python"},"language_info":{"name":"python","version":"3.6.9","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"}},"nbformat":4,"nbformat_minor":4}