data_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import plotly.express as px\n",
    "import numpy as np\n",
    "from datetime import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('data/data.csv', header=None, delimiter=';')\n",
    "df.columns = ['timestamp', 'station_id', 'mechanical_bike', 'electrical_bike', 'available_dock', 'is_renting', 'is_receiving']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "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>timestamp</th>\n",
       "      <th>station_id</th>\n",
       "      <th>mechanical_bike</th>\n",
       "      <th>electrical_bike</th>\n",
       "      <th>available_dock</th>\n",
       "      <th>is_renting</th>\n",
       "      <th>is_receiving</th>\n",
       "      <th>total_bike</th>\n",
       "      <th>capacity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>213688169</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>653222953</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>12.0</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>36255</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>7.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>37815204</td>\n",
       "      <td>10.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>13.0</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>17278902806</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>251039991</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>85002689</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>52</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>57.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>2515829865</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>12.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>516709288</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>19.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>120827885</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>37874517</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>66491398</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>14.0</td>\n",
       "      <td>47.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>17486274358</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>210403080</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>210561800</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>12.0</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>209063434</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>12.0</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>94555589</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9.0</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>244498842</td>\n",
       "      <td>29.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>43.0</td>\n",
       "      <td>49.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>210405211</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>43195240</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>501862076</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>100769544</td>\n",
       "      <td>33.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>34.0</td>\n",
       "      <td>40.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>207633746</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>51</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9.0</td>\n",
       "      <td>60.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>16560752067</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>210566542</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>56</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>59.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>210565680</td>\n",
       "      <td>23.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>25.0</td>\n",
       "      <td>33.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>85043758</td>\n",
       "      <td>10.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>13.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>54000559</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>210397939</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>82405965</td>\n",
       "      <td>36.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>39.0</td>\n",
       "      <td>42.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>213682736</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>47</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>52.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>128986726</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>33.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>54000581</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>11.0</td>\n",
       "      <td>33.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>13105968</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>653208733</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>27415224</td>\n",
       "      <td>21.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>30.0</td>\n",
       "      <td>32.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>907054879</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>123095125</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>49</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9.0</td>\n",
       "      <td>58.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>129094535</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>39.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>54000612</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8.0</td>\n",
       "      <td>41.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>80101533</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>7.0</td>\n",
       "      <td>33.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>599135701</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>13.0</td>\n",
       "      <td>41.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>102747146</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>2515403527</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>653132534</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>506455295</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>1057149522</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>210567545</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9.0</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>653197324</td>\n",
       "      <td>7.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>18.0</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>2515085147</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>19.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           timestamp   station_id  mechanical_bike  electrical_bike  \\\n",
       "0   16/04/23 - 19:20    213688169              0.0              1.0   \n",
       "1   16/04/23 - 19:20    653222953              7.0              5.0   \n",
       "2   16/04/23 - 19:20        36255              5.0              2.0   \n",
       "3   16/04/23 - 19:20     37815204             10.0              3.0   \n",
       "4   16/04/23 - 19:20  17278902806              0.0              0.0   \n",
       "5   16/04/23 - 19:20    251039991              0.0              3.0   \n",
       "6   16/04/23 - 19:20     85002689              3.0              2.0   \n",
       "7   16/04/23 - 19:20   2515829865              2.0             10.0   \n",
       "8   16/04/23 - 19:20    516709288              0.0              1.0   \n",
       "9   16/04/23 - 19:20    120827885              1.0              2.0   \n",
       "10  16/04/23 - 19:20     37874517              2.0              1.0   \n",
       "11  16/04/23 - 19:20     66491398              5.0              9.0   \n",
       "12  16/04/23 - 19:20  17486274358              0.0              0.0   \n",
       "13  16/04/23 - 19:20    210403080              1.0              3.0   \n",
       "14  16/04/23 - 19:20    210561800              8.0              4.0   \n",
       "15  16/04/23 - 19:20    209063434              9.0              3.0   \n",
       "16  16/04/23 - 19:20     94555589              3.0              6.0   \n",
       "17  16/04/23 - 19:20    244498842             29.0             14.0   \n",
       "18  16/04/23 - 19:20    210405211              5.0              0.0   \n",
       "19  16/04/23 - 19:20     43195240              2.0              8.0   \n",
       "20  16/04/23 - 19:20    501862076              0.0              5.0   \n",
       "21  16/04/23 - 19:20    100769544             33.0              1.0   \n",
       "22  16/04/23 - 19:20    207633746              5.0              4.0   \n",
       "23  16/04/23 - 19:20  16560752067              3.0              0.0   \n",
       "24  16/04/23 - 19:20    210566542              2.0              1.0   \n",
       "25  16/04/23 - 19:20    210565680             23.0              2.0   \n",
       "26  16/04/23 - 19:20     85043758             10.0              3.0   \n",
       "27  16/04/23 - 19:20     54000559              3.0              5.0   \n",
       "28  16/04/23 - 19:20    210397939              4.0              1.0   \n",
       "29  16/04/23 - 19:20     82405965             36.0              3.0   \n",
       "30  16/04/23 - 19:20    213682736              0.0              5.0   \n",
       "31  16/04/23 - 19:20    128986726              1.0              0.0   \n",
       "32  16/04/23 - 19:20     54000581              5.0              6.0   \n",
       "33  16/04/23 - 19:20     13105968              1.0              0.0   \n",
       "34  16/04/23 - 19:20    653208733              0.0              1.0   \n",
       "35  16/04/23 - 19:20     27415224             21.0              9.0   \n",
       "36  16/04/23 - 19:20    907054879             17.0              0.0   \n",
       "37  16/04/23 - 19:20    123095125              8.0              1.0   \n",
       "38  16/04/23 - 19:20    129094535              1.0              1.0   \n",
       "39  16/04/23 - 19:20     54000612              5.0              3.0   \n",
       "40  16/04/23 - 19:20     80101533              2.0              5.0   \n",
       "41  16/04/23 - 19:20    599135701              6.0              7.0   \n",
       "42  16/04/23 - 19:20    102747146              1.0              4.0   \n",
       "43  16/04/23 - 19:20   2515403527              1.0              0.0   \n",
       "44  16/04/23 - 19:20    653132534              3.0              2.0   \n",
       "45  16/04/23 - 19:20    506455295              0.0              0.0   \n",
       "46  16/04/23 - 19:20   1057149522              4.0              6.0   \n",
       "47  16/04/23 - 19:20    210567545              9.0              0.0   \n",
       "48  16/04/23 - 19:20    653197324              7.0             11.0   \n",
       "49  16/04/23 - 19:20   2515085147              3.0              2.0   \n",
       "\n",
       "    available_dock  is_renting  is_receiving  total_bike  capacity  \n",
       "0               34           1             1         1.0      35.0  \n",
       "1               18           1             1        12.0      30.0  \n",
       "2               14           1             1         7.0      21.0  \n",
       "3               17           1             1        13.0      30.0  \n",
       "4                0           0             0         0.0       0.0  \n",
       "5               22           1             1         3.0      25.0  \n",
       "6               52           1             1         5.0      57.0  \n",
       "7                8           1             1        12.0      20.0  \n",
       "8               18           1             1         1.0      19.0  \n",
       "9                9           1             1         3.0      12.0  \n",
       "10              18           1             1         3.0      21.0  \n",
       "11              33           1             1        14.0      47.0  \n",
       "12               0           0             0         0.0       0.0  \n",
       "13              17           1             1         4.0      21.0  \n",
       "14               3           1             1        12.0      15.0  \n",
       "15              17           1             1        12.0      29.0  \n",
       "16              17           1             1         9.0      26.0  \n",
       "17               6           1             1        43.0      49.0  \n",
       "18              15           1             1         5.0      20.0  \n",
       "19              15           1             1        10.0      25.0  \n",
       "20              15           1             1         5.0      20.0  \n",
       "21               6           1             1        34.0      40.0  \n",
       "22              51           1             1         9.0      60.0  \n",
       "23              27           1             1         3.0      30.0  \n",
       "24              56           1             1         3.0      59.0  \n",
       "25               8           1             1        25.0      33.0  \n",
       "26              22           1             1        13.0      35.0  \n",
       "27              13           1             1         8.0      21.0  \n",
       "28              12           1             1         5.0      17.0  \n",
       "29               3           1             1        39.0      42.0  \n",
       "30              47           1             1         5.0      52.0  \n",
       "31              32           1             1         1.0      33.0  \n",
       "32              22           1             1        11.0      33.0  \n",
       "33              20           1             1         1.0      21.0  \n",
       "34              37           1             1         1.0      38.0  \n",
       "35               2           1             1        30.0      32.0  \n",
       "36               3           1             1        17.0      20.0  \n",
       "37              49           1             1         9.0      58.0  \n",
       "38              37           1             1         2.0      39.0  \n",
       "39              33           1             1         8.0      41.0  \n",
       "40              26           1             1         7.0      33.0  \n",
       "41              28           1             1        13.0      41.0  \n",
       "42              18           1             1         5.0      23.0  \n",
       "43              25           1             1         1.0      26.0  \n",
       "44              20           1             1         5.0      25.0  \n",
       "45              16           1             1         0.0      16.0  \n",
       "46              11           1             1        10.0      21.0  \n",
       "47               8           1             1         9.0      17.0  \n",
       "48               4           1             1        18.0      22.0  \n",
       "49              14           1             1         5.0      19.0  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['total_bike'] = df.mechanical_bike + df.electrical_bike\n",
    "df['capacity'] = df.total_bike + df.available_dock\n",
    "df['timestamp'] = pd.to_datetime(df['timestamp'] * 60, unit='s') # Converting minutes to seconds\n",
    "df['timestamp'] = df['timestamp'].dt.strftime('%d/%m/%y - %H:%M')\n",
    "\n",
    "# df = df.groupby('station_id', as_index=False).agg('mean')\n",
    "# df = df.sort_values(['electrical_bike', 'mechanical_bike'], ascending=False)\n",
    "df.head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "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>station_id</th>\n",
       "      <th>name</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>capacity</th>\n",
       "      <th>stationCode</th>\n",
       "      <th>rental_methods</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>213688169</td>\n",
       "      <td>Benjamin Godard - Victor Hugo</td>\n",
       "      <td>48.865983</td>\n",
       "      <td>2.275725</td>\n",
       "      <td>35</td>\n",
       "      <td>16107</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>653222953</td>\n",
       "      <td>Mairie de Rosny-sous-Bois</td>\n",
       "      <td>48.871257</td>\n",
       "      <td>2.486581</td>\n",
       "      <td>30</td>\n",
       "      <td>31104</td>\n",
       "      <td>[CREDITCARD]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>36255</td>\n",
       "      <td>Toudouze - Clauzel</td>\n",
       "      <td>48.879296</td>\n",
       "      <td>2.337360</td>\n",
       "      <td>21</td>\n",
       "      <td>9020</td>\n",
       "      <td>[CREDITCARD]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>37815204</td>\n",
       "      <td>Mairie du 12ème</td>\n",
       "      <td>48.840855</td>\n",
       "      <td>2.387555</td>\n",
       "      <td>30</td>\n",
       "      <td>12109</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>17278902806</td>\n",
       "      <td>Rouget de L'isle - Watteau</td>\n",
       "      <td>48.778193</td>\n",
       "      <td>2.396302</td>\n",
       "      <td>0</td>\n",
       "      <td>44015</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1459</th>\n",
       "      <td>54000604</td>\n",
       "      <td>Ordener - Poissonniers</td>\n",
       "      <td>48.891214</td>\n",
       "      <td>2.351289</td>\n",
       "      <td>35</td>\n",
       "      <td>18023</td>\n",
       "      <td>[CREDITCARD]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1460</th>\n",
       "      <td>43247738</td>\n",
       "      <td>Ruisseau - Ordener</td>\n",
       "      <td>48.892995</td>\n",
       "      <td>2.340145</td>\n",
       "      <td>35</td>\n",
       "      <td>18026</td>\n",
       "      <td>[CREDITCARD]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1461</th>\n",
       "      <td>102311820</td>\n",
       "      <td>Clignancourt - Ordener</td>\n",
       "      <td>48.891458</td>\n",
       "      <td>2.348636</td>\n",
       "      <td>35</td>\n",
       "      <td>18024</td>\n",
       "      <td>[CREDITCARD]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1462</th>\n",
       "      <td>368766689</td>\n",
       "      <td>Westermeyer - Paul Vaillant-Couturier</td>\n",
       "      <td>48.819116</td>\n",
       "      <td>2.396664</td>\n",
       "      <td>25</td>\n",
       "      <td>42004</td>\n",
       "      <td>[CREDITCARD]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1463</th>\n",
       "      <td>315022587</td>\n",
       "      <td>Malesherbes - Place de la Madeleine</td>\n",
       "      <td>48.870406</td>\n",
       "      <td>2.323244</td>\n",
       "      <td>67</td>\n",
       "      <td>8004</td>\n",
       "      <td>[CREDITCARD]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1464 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       station_id                                   name        lat       lon  \\\n",
       "0       213688169          Benjamin Godard - Victor Hugo  48.865983  2.275725   \n",
       "1       653222953              Mairie de Rosny-sous-Bois  48.871257  2.486581   \n",
       "2           36255                     Toudouze - Clauzel  48.879296  2.337360   \n",
       "3        37815204                        Mairie du 12ème  48.840855  2.387555   \n",
       "4     17278902806             Rouget de L'isle - Watteau  48.778193  2.396302   \n",
       "...           ...                                    ...        ...       ...   \n",
       "1459     54000604                 Ordener - Poissonniers  48.891214  2.351289   \n",
       "1460     43247738                     Ruisseau - Ordener  48.892995  2.340145   \n",
       "1461    102311820                 Clignancourt - Ordener  48.891458  2.348636   \n",
       "1462    368766689  Westermeyer - Paul Vaillant-Couturier  48.819116  2.396664   \n",
       "1463    315022587    Malesherbes - Place de la Madeleine  48.870406  2.323244   \n",
       "\n",
       "      capacity stationCode rental_methods  \n",
       "0           35       16107            NaN  \n",
       "1           30       31104   [CREDITCARD]  \n",
       "2           21        9020   [CREDITCARD]  \n",
       "3           30       12109            NaN  \n",
       "4            0       44015            NaN  \n",
       "...        ...         ...            ...  \n",
       "1459        35       18023   [CREDITCARD]  \n",
       "1460        35       18026   [CREDITCARD]  \n",
       "1461        35       18024   [CREDITCARD]  \n",
       "1462        25       42004   [CREDITCARD]  \n",
       "1463        67        8004   [CREDITCARD]  \n",
       "\n",
       "[1464 rows x 7 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_stations = pd.read_json('data/data.json')\n",
    "df_stations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "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>timestamp</th>\n",
       "      <th>mechanical_bike</th>\n",
       "      <th>electrical_bike</th>\n",
       "      <th>available_dock</th>\n",
       "      <th>is_renting</th>\n",
       "      <th>is_receiving</th>\n",
       "      <th>total_bike</th>\n",
       "      <th>capacity</th>\n",
       "      <th>name</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>station_fill</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>Benjamin Godard - Victor Hugo</td>\n",
       "      <td>48.865983</td>\n",
       "      <td>2.275725</td>\n",
       "      <td>0.028571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>12.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>Mairie de Rosny-sous-Bois</td>\n",
       "      <td>48.871257</td>\n",
       "      <td>2.486581</td>\n",
       "      <td>0.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>7.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Toudouze - Clauzel</td>\n",
       "      <td>48.879296</td>\n",
       "      <td>2.337360</td>\n",
       "      <td>0.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>10.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>13.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>Mairie du 12ème</td>\n",
       "      <td>48.840855</td>\n",
       "      <td>2.387555</td>\n",
       "      <td>0.433333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Rouget de L'isle - Watteau</td>\n",
       "      <td>48.778193</td>\n",
       "      <td>2.396302</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>Cassini - Denfert-Rochereau</td>\n",
       "      <td>48.837526</td>\n",
       "      <td>2.336035</td>\n",
       "      <td>0.120000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>52</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>Jourdan - Stade Charléty</td>\n",
       "      <td>48.819428</td>\n",
       "      <td>2.343335</td>\n",
       "      <td>0.087719</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>12.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Basilique</td>\n",
       "      <td>48.936269</td>\n",
       "      <td>2.358867</td>\n",
       "      <td>0.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Charonne - Robert et Sonia Delaunay</td>\n",
       "      <td>48.855908</td>\n",
       "      <td>2.392571</td>\n",
       "      <td>0.052632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>Messine - Place Du Pérou</td>\n",
       "      <td>48.875448</td>\n",
       "      <td>2.315508</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Saint-Sulpice</td>\n",
       "      <td>48.851654</td>\n",
       "      <td>2.330808</td>\n",
       "      <td>0.142857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>14.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>Le Brun - Gobelins</td>\n",
       "      <td>48.835093</td>\n",
       "      <td>2.353468</td>\n",
       "      <td>0.297872</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Jean Rostand - Paul Vaillant Couturier</td>\n",
       "      <td>48.908168</td>\n",
       "      <td>2.453060</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Lacépède - Monge</td>\n",
       "      <td>48.843893</td>\n",
       "      <td>2.351966</td>\n",
       "      <td>0.190476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>12.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Saint-Romain - Cherche-Midi</td>\n",
       "      <td>48.847082</td>\n",
       "      <td>2.321375</td>\n",
       "      <td>0.800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>12.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>André Karman - République</td>\n",
       "      <td>48.910399</td>\n",
       "      <td>2.385136</td>\n",
       "      <td>0.413793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Pierre et Marie Curie - Maurice Thorez</td>\n",
       "      <td>48.815802</td>\n",
       "      <td>2.376805</td>\n",
       "      <td>0.346154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>29.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>43.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>Bois de Vincennes - Gare</td>\n",
       "      <td>48.836022</td>\n",
       "      <td>2.470834</td>\n",
       "      <td>0.877551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Beaux-Arts - Bonaparte</td>\n",
       "      <td>48.856452</td>\n",
       "      <td>2.334852</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>Silly - Galliéni</td>\n",
       "      <td>48.835584</td>\n",
       "      <td>2.232550</td>\n",
       "      <td>0.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Place Nelson Mandela</td>\n",
       "      <td>48.862091</td>\n",
       "      <td>2.196576</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>33.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>34.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Harpe - Saint-Germain</td>\n",
       "      <td>48.851519</td>\n",
       "      <td>2.343670</td>\n",
       "      <td>0.850000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>51</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>Grande Armée - Brunel</td>\n",
       "      <td>48.876116</td>\n",
       "      <td>2.288124</td>\n",
       "      <td>0.150000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>Bracion - Périphérique</td>\n",
       "      <td>48.826104</td>\n",
       "      <td>2.300455</td>\n",
       "      <td>0.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>56</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>Square Boucicaut</td>\n",
       "      <td>48.851296</td>\n",
       "      <td>2.325062</td>\n",
       "      <td>0.050847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>23.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>25.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>Vaneau - Sèvres</td>\n",
       "      <td>48.848563</td>\n",
       "      <td>2.320422</td>\n",
       "      <td>0.757576</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>10.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>13.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>Guersant - Gouvion-Saint-Cyr</td>\n",
       "      <td>48.882878</td>\n",
       "      <td>2.287667</td>\n",
       "      <td>0.371429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Jouffroy d'Abbans - Wagram</td>\n",
       "      <td>48.881973</td>\n",
       "      <td>2.301132</td>\n",
       "      <td>0.380952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>Thouin - Cardinal Lemoine</td>\n",
       "      <td>48.845047</td>\n",
       "      <td>2.349465</td>\n",
       "      <td>0.294118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>36.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>39.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>Froment - Bréguet</td>\n",
       "      <td>48.857041</td>\n",
       "      <td>2.372895</td>\n",
       "      <td>0.928571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>47</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>Morillons - Dantzig</td>\n",
       "      <td>48.833101</td>\n",
       "      <td>2.299380</td>\n",
       "      <td>0.096154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>Boétie - Ponthieu</td>\n",
       "      <td>48.871417</td>\n",
       "      <td>2.307679</td>\n",
       "      <td>0.030303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>11.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>Croulebarde - Corvisart</td>\n",
       "      <td>48.830982</td>\n",
       "      <td>2.348165</td>\n",
       "      <td>0.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Le Brix et Mesmin - Jourdan</td>\n",
       "      <td>48.822341</td>\n",
       "      <td>2.327862</td>\n",
       "      <td>0.047619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>Romainville - Vaillant-Couturier</td>\n",
       "      <td>48.867850</td>\n",
       "      <td>2.446748</td>\n",
       "      <td>0.026316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>21.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>30.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>Bir Hakeim</td>\n",
       "      <td>48.853844</td>\n",
       "      <td>2.289705</td>\n",
       "      <td>0.937500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Liberté - Vert-de-Maisons</td>\n",
       "      <td>48.790148</td>\n",
       "      <td>2.432863</td>\n",
       "      <td>0.850000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>49</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>Alibert - Jemmapes</td>\n",
       "      <td>48.871044</td>\n",
       "      <td>2.366104</td>\n",
       "      <td>0.155172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>Porte de Saint-Ouen - Bessières</td>\n",
       "      <td>48.897922</td>\n",
       "      <td>2.328515</td>\n",
       "      <td>0.051282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>Cambrai - Benjamin Constant</td>\n",
       "      <td>48.895947</td>\n",
       "      <td>2.381134</td>\n",
       "      <td>0.195122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>7.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>Chazelles - Courcelles</td>\n",
       "      <td>48.879407</td>\n",
       "      <td>2.303446</td>\n",
       "      <td>0.212121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>13.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>Ramponeau - Belleville</td>\n",
       "      <td>48.871031</td>\n",
       "      <td>2.379057</td>\n",
       "      <td>0.317073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Lagny - Victor Basch</td>\n",
       "      <td>48.848841</td>\n",
       "      <td>2.426325</td>\n",
       "      <td>0.217391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Saint-Cloud - Hippodrome</td>\n",
       "      <td>48.857721</td>\n",
       "      <td>2.254911</td>\n",
       "      <td>0.038462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>Louis Lejeune - Barbès</td>\n",
       "      <td>48.818074</td>\n",
       "      <td>2.326701</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Général Martial Valin - Pont du Garigliano</td>\n",
       "      <td>48.838231</td>\n",
       "      <td>2.270506</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Rond-point du Dr Albert Schweitzer</td>\n",
       "      <td>48.789809</td>\n",
       "      <td>2.314394</td>\n",
       "      <td>0.476190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>Raspail - Varenne</td>\n",
       "      <td>48.853148</td>\n",
       "      <td>2.326391</td>\n",
       "      <td>0.529412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>7.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>18.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Théâtre des Amandiers - Palais des sports</td>\n",
       "      <td>48.892649</td>\n",
       "      <td>2.213694</td>\n",
       "      <td>0.818182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>16/04/23 - 19:20</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Italie - Tolbiac</td>\n",
       "      <td>48.825572</td>\n",
       "      <td>2.357617</td>\n",
       "      <td>0.263158</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           timestamp  mechanical_bike  electrical_bike  available_dock  \\\n",
       "0   16/04/23 - 19:20              0.0              1.0              34   \n",
       "1   16/04/23 - 19:20              7.0              5.0              18   \n",
       "2   16/04/23 - 19:20              5.0              2.0              14   \n",
       "3   16/04/23 - 19:20             10.0              3.0              17   \n",
       "4   16/04/23 - 19:20              0.0              0.0               0   \n",
       "5   16/04/23 - 19:20              0.0              3.0              22   \n",
       "6   16/04/23 - 19:20              3.0              2.0              52   \n",
       "7   16/04/23 - 19:20              2.0             10.0               8   \n",
       "8   16/04/23 - 19:20              0.0              1.0              18   \n",
       "9   16/04/23 - 19:20              1.0              2.0               9   \n",
       "10  16/04/23 - 19:20              2.0              1.0              18   \n",
       "11  16/04/23 - 19:20              5.0              9.0              33   \n",
       "12  16/04/23 - 19:20              0.0              0.0               0   \n",
       "13  16/04/23 - 19:20              1.0              3.0              17   \n",
       "14  16/04/23 - 19:20              8.0              4.0               3   \n",
       "15  16/04/23 - 19:20              9.0              3.0              17   \n",
       "16  16/04/23 - 19:20              3.0              6.0              17   \n",
       "17  16/04/23 - 19:20             29.0             14.0               6   \n",
       "18  16/04/23 - 19:20              5.0              0.0              15   \n",
       "19  16/04/23 - 19:20              2.0              8.0              15   \n",
       "20  16/04/23 - 19:20              0.0              5.0              15   \n",
       "21  16/04/23 - 19:20             33.0              1.0               6   \n",
       "22  16/04/23 - 19:20              5.0              4.0              51   \n",
       "23  16/04/23 - 19:20              3.0              0.0              27   \n",
       "24  16/04/23 - 19:20              2.0              1.0              56   \n",
       "25  16/04/23 - 19:20             23.0              2.0               8   \n",
       "26  16/04/23 - 19:20             10.0              3.0              22   \n",
       "27  16/04/23 - 19:20              3.0              5.0              13   \n",
       "28  16/04/23 - 19:20              4.0              1.0              12   \n",
       "29  16/04/23 - 19:20             36.0              3.0               3   \n",
       "30  16/04/23 - 19:20              0.0              5.0              47   \n",
       "31  16/04/23 - 19:20              1.0              0.0              32   \n",
       "32  16/04/23 - 19:20              5.0              6.0              22   \n",
       "33  16/04/23 - 19:20              1.0              0.0              20   \n",
       "34  16/04/23 - 19:20              0.0              1.0              37   \n",
       "35  16/04/23 - 19:20             21.0              9.0               2   \n",
       "36  16/04/23 - 19:20             17.0              0.0               3   \n",
       "37  16/04/23 - 19:20              8.0              1.0              49   \n",
       "38  16/04/23 - 19:20              1.0              1.0              37   \n",
       "39  16/04/23 - 19:20              5.0              3.0              33   \n",
       "40  16/04/23 - 19:20              2.0              5.0              26   \n",
       "41  16/04/23 - 19:20              6.0              7.0              28   \n",
       "42  16/04/23 - 19:20              1.0              4.0              18   \n",
       "43  16/04/23 - 19:20              1.0              0.0              25   \n",
       "44  16/04/23 - 19:20              3.0              2.0              20   \n",
       "45  16/04/23 - 19:20              0.0              0.0              16   \n",
       "46  16/04/23 - 19:20              4.0              6.0              11   \n",
       "47  16/04/23 - 19:20              9.0              0.0               8   \n",
       "48  16/04/23 - 19:20              7.0             11.0               4   \n",
       "49  16/04/23 - 19:20              3.0              2.0              14   \n",
       "\n",
       "    is_renting  is_receiving  total_bike  capacity  \\\n",
       "0            1             1         1.0      35.0   \n",
       "1            1             1        12.0      30.0   \n",
       "2            1             1         7.0      21.0   \n",
       "3            1             1        13.0      30.0   \n",
       "4            0             0         0.0       0.0   \n",
       "5            1             1         3.0      25.0   \n",
       "6            1             1         5.0      57.0   \n",
       "7            1             1        12.0      20.0   \n",
       "8            1             1         1.0      19.0   \n",
       "9            1             1         3.0      12.0   \n",
       "10           1             1         3.0      21.0   \n",
       "11           1             1        14.0      47.0   \n",
       "12           0             0         0.0       0.0   \n",
       "13           1             1         4.0      21.0   \n",
       "14           1             1        12.0      15.0   \n",
       "15           1             1        12.0      29.0   \n",
       "16           1             1         9.0      26.0   \n",
       "17           1             1        43.0      49.0   \n",
       "18           1             1         5.0      20.0   \n",
       "19           1             1        10.0      25.0   \n",
       "20           1             1         5.0      20.0   \n",
       "21           1             1        34.0      40.0   \n",
       "22           1             1         9.0      60.0   \n",
       "23           1             1         3.0      30.0   \n",
       "24           1             1         3.0      59.0   \n",
       "25           1             1        25.0      33.0   \n",
       "26           1             1        13.0      35.0   \n",
       "27           1             1         8.0      21.0   \n",
       "28           1             1         5.0      17.0   \n",
       "29           1             1        39.0      42.0   \n",
       "30           1             1         5.0      52.0   \n",
       "31           1             1         1.0      33.0   \n",
       "32           1             1        11.0      33.0   \n",
       "33           1             1         1.0      21.0   \n",
       "34           1             1         1.0      38.0   \n",
       "35           1             1        30.0      32.0   \n",
       "36           1             1        17.0      20.0   \n",
       "37           1             1         9.0      58.0   \n",
       "38           1             1         2.0      39.0   \n",
       "39           1             1         8.0      41.0   \n",
       "40           1             1         7.0      33.0   \n",
       "41           1             1        13.0      41.0   \n",
       "42           1             1         5.0      23.0   \n",
       "43           1             1         1.0      26.0   \n",
       "44           1             1         5.0      25.0   \n",
       "45           1             1         0.0      16.0   \n",
       "46           1             1        10.0      21.0   \n",
       "47           1             1         9.0      17.0   \n",
       "48           1             1        18.0      22.0   \n",
       "49           1             1         5.0      19.0   \n",
       "\n",
       "                                          name        lat       lon  \\\n",
       "0                Benjamin Godard - Victor Hugo  48.865983  2.275725   \n",
       "1                    Mairie de Rosny-sous-Bois  48.871257  2.486581   \n",
       "2                           Toudouze - Clauzel  48.879296  2.337360   \n",
       "3                              Mairie du 12ème  48.840855  2.387555   \n",
       "4                   Rouget de L'isle - Watteau  48.778193  2.396302   \n",
       "5                  Cassini - Denfert-Rochereau  48.837526  2.336035   \n",
       "6                     Jourdan - Stade Charléty  48.819428  2.343335   \n",
       "7                                    Basilique  48.936269  2.358867   \n",
       "8          Charonne - Robert et Sonia Delaunay  48.855908  2.392571   \n",
       "9                     Messine - Place Du Pérou  48.875448  2.315508   \n",
       "10                               Saint-Sulpice  48.851654  2.330808   \n",
       "11                          Le Brun - Gobelins  48.835093  2.353468   \n",
       "12      Jean Rostand - Paul Vaillant Couturier  48.908168  2.453060   \n",
       "13                            Lacépède - Monge  48.843893  2.351966   \n",
       "14                 Saint-Romain - Cherche-Midi  48.847082  2.321375   \n",
       "15                   André Karman - République  48.910399  2.385136   \n",
       "16      Pierre et Marie Curie - Maurice Thorez  48.815802  2.376805   \n",
       "17                    Bois de Vincennes - Gare  48.836022  2.470834   \n",
       "18                      Beaux-Arts - Bonaparte  48.856452  2.334852   \n",
       "19                            Silly - Galliéni  48.835584  2.232550   \n",
       "20                       Place Nelson Mandela   48.862091  2.196576   \n",
       "21                       Harpe - Saint-Germain  48.851519  2.343670   \n",
       "22                       Grande Armée - Brunel  48.876116  2.288124   \n",
       "23                      Bracion - Périphérique  48.826104  2.300455   \n",
       "24                            Square Boucicaut  48.851296  2.325062   \n",
       "25                             Vaneau - Sèvres  48.848563  2.320422   \n",
       "26                Guersant - Gouvion-Saint-Cyr  48.882878  2.287667   \n",
       "27                  Jouffroy d'Abbans - Wagram  48.881973  2.301132   \n",
       "28                   Thouin - Cardinal Lemoine  48.845047  2.349465   \n",
       "29                           Froment - Bréguet  48.857041  2.372895   \n",
       "30                         Morillons - Dantzig  48.833101  2.299380   \n",
       "31                           Boétie - Ponthieu  48.871417  2.307679   \n",
       "32                     Croulebarde - Corvisart  48.830982  2.348165   \n",
       "33                 Le Brix et Mesmin - Jourdan  48.822341  2.327862   \n",
       "34            Romainville - Vaillant-Couturier  48.867850  2.446748   \n",
       "35                                  Bir Hakeim  48.853844  2.289705   \n",
       "36                   Liberté - Vert-de-Maisons  48.790148  2.432863   \n",
       "37                          Alibert - Jemmapes  48.871044  2.366104   \n",
       "38             Porte de Saint-Ouen - Bessières  48.897922  2.328515   \n",
       "39                 Cambrai - Benjamin Constant  48.895947  2.381134   \n",
       "40                     Chazelles - Courcelles   48.879407  2.303446   \n",
       "41                      Ramponeau - Belleville  48.871031  2.379057   \n",
       "42                        Lagny - Victor Basch  48.848841  2.426325   \n",
       "43                    Saint-Cloud - Hippodrome  48.857721  2.254911   \n",
       "44                      Louis Lejeune - Barbès  48.818074  2.326701   \n",
       "45  Général Martial Valin - Pont du Garigliano  48.838231  2.270506   \n",
       "46          Rond-point du Dr Albert Schweitzer  48.789809  2.314394   \n",
       "47                           Raspail - Varenne  48.853148  2.326391   \n",
       "48   Théâtre des Amandiers - Palais des sports  48.892649  2.213694   \n",
       "49                            Italie - Tolbiac  48.825572  2.357617   \n",
       "\n",
       "    station_fill  \n",
       "0       0.028571  \n",
       "1       0.400000  \n",
       "2       0.333333  \n",
       "3       0.433333  \n",
       "4       0.000000  \n",
       "5       0.120000  \n",
       "6       0.087719  \n",
       "7       0.600000  \n",
       "8       0.052632  \n",
       "9       0.250000  \n",
       "10      0.142857  \n",
       "11      0.297872  \n",
       "12      0.000000  \n",
       "13      0.190476  \n",
       "14      0.800000  \n",
       "15      0.413793  \n",
       "16      0.346154  \n",
       "17      0.877551  \n",
       "18      0.250000  \n",
       "19      0.400000  \n",
       "20      0.250000  \n",
       "21      0.850000  \n",
       "22      0.150000  \n",
       "23      0.100000  \n",
       "24      0.050847  \n",
       "25      0.757576  \n",
       "26      0.371429  \n",
       "27      0.380952  \n",
       "28      0.294118  \n",
       "29      0.928571  \n",
       "30      0.096154  \n",
       "31      0.030303  \n",
       "32      0.333333  \n",
       "33      0.047619  \n",
       "34      0.026316  \n",
       "35      0.937500  \n",
       "36      0.850000  \n",
       "37      0.155172  \n",
       "38      0.051282  \n",
       "39      0.195122  \n",
       "40      0.212121  \n",
       "41      0.317073  \n",
       "42      0.217391  \n",
       "43      0.038462  \n",
       "44      0.200000  \n",
       "45      0.000000  \n",
       "46      0.476190  \n",
       "47      0.529412  \n",
       "48      0.818182  \n",
       "49      0.263158  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.merge(df, df_stations[['station_id', 'name', 'lat', 'lon']], on=['station_id'], how='left')\n",
    "df = df.drop('station_id', axis=1)\n",
    "df['station_fill'] = np.where(df.capacity == 0, 0, df.total_bike / df.capacity)\n",
    "\n",
    "df.head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "fig = px.density_mapbox(df, lat='lat', lon='lon', z='station_fill', hover_name='name', hover_data='station_fill',\n",
    "                        center=dict(lat=48.8566, lon=2.3522), zoom=12, width=1500, height=800,\n",
    "                        mapbox_style=\"carto-positron\",\n",
    "                        radius=40, opacity=0.5)\n",
    "#fig.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['ratio_electric'] = np.where(df.total_bike == 0, 0, df.electrical_bike / df.total_bike)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "an integer is required (got type str)",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "Cell \u001b[0;32mIn[12], line 3\u001b[0m\n\u001b[1;32m      1\u001b[0m last_timestamp \u001b[39m=\u001b[39m df[\u001b[39m'\u001b[39m\u001b[39mtimestamp\u001b[39m\u001b[39m'\u001b[39m]\u001b[39m.\u001b[39mmax()\n\u001b[1;32m      2\u001b[0m df \u001b[39m=\u001b[39m df[df[\u001b[39m'\u001b[39m\u001b[39mtimestamp\u001b[39m\u001b[39m'\u001b[39m] \u001b[39m==\u001b[39m last_timestamp]\n\u001b[0;32m----> 3\u001b[0m datetime\u001b[39m.\u001b[39;49mfromtimestamp(last_timestamp \u001b[39m*\u001b[39;49m \u001b[39m60\u001b[39;49m)\u001b[39m.\u001b[39mstrftime(\u001b[39m'\u001b[39m\u001b[39m%d\u001b[39;00m\u001b[39m/\u001b[39m\u001b[39m%\u001b[39m\u001b[39mm/\u001b[39m\u001b[39m%\u001b[39m\u001b[39my - \u001b[39m\u001b[39m%\u001b[39m\u001b[39mH:\u001b[39m\u001b[39m%\u001b[39m\u001b[39mM\u001b[39m\u001b[39m'\u001b[39m)\n",
      "\u001b[0;31mTypeError\u001b[0m: an integer is required (got type str)"
     ]
    }
   ],
   "source": [
    "last_timestamp = df['timestamp'].max()\n",
    "df = df[df['timestamp'] == last_timestamp]\n",
    "datetime.fromtimestamp(last_timestamp * 60).strftime('%d/%m/%y - %H:%M')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "fig = px.scatter_mapbox(df, lat='lat', lon='lon', size='station_fill', hover_name='name', color='ratio_electric',\n",
    "                        center=dict(lat=48.8566, lon=2.3522), zoom=12, width=1500, height=800,\n",
    "                        mapbox_style=\"carto-positron\", opacity=0.5)\n",
    "# fig.show()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.6"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}