metadata/probe-to-timezone.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import sqlite3\n",
    "pd.set_option('mode.chained_assignment', None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "conn = sqlite3.connect('../data/netflix-data.db')\n",
    "df = pd.read_sql_query('select * from msmpoint', con=conn)\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>skunitid</th>\n",
       "      <th>msmid</th>\n",
       "      <th>name</th>\n",
       "      <th>hardware</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>200172</td>\n",
       "      <td>43429f748f4711e3b77500e08147c934</td>\n",
       "      <td>samsbox14</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>950238</td>\n",
       "      <td>383d4f02bfe111e693d000e08147c934</td>\n",
       "      <td>samsbox102</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>660078</td>\n",
       "      <td>f3d48fe4be7311e4a00300e08147c934</td>\n",
       "      <td>samsbox38</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>632466</td>\n",
       "      <td>1833f5c8d3dc11e4b42200e08147c934</td>\n",
       "      <td>samsbox59</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>658899</td>\n",
       "      <td>dadf6ae0be6e11e4a67900e08147c934</td>\n",
       "      <td>samsbox36</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>148644</td>\n",
       "      <td>635cd9468afc11e2901a00e08147c934</td>\n",
       "      <td>samsbox03</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>241733</td>\n",
       "      <td>7931bc2ea87811e3914e00e08147c934</td>\n",
       "      <td>samsbox17</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>632394</td>\n",
       "      <td>835a36a8eaa411e4aabb00e08147c934</td>\n",
       "      <td>samsbox62</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>660150</td>\n",
       "      <td>0319d9e6d3d711e4990c00e08147c934</td>\n",
       "      <td>samsbox56</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>19602</td>\n",
       "      <td>1c122042829e11e3a2f800e08147c934</td>\n",
       "      <td>samsbox13</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>525918</td>\n",
       "      <td>7cb11ea8c97411e4a00300e08147c934</td>\n",
       "      <td>samsbox51</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>200864</td>\n",
       "      <td>8c3652e2810611e3a2f800e08147c934</td>\n",
       "      <td>samsbox12</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>632406</td>\n",
       "      <td>07ff9a68c1c111e49ffd00e08147c934</td>\n",
       "      <td>samsbox43</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>950212</td>\n",
       "      <td>c4042aeca7fe11e6a78700e08147c934</td>\n",
       "      <td>samsbox84</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>950210</td>\n",
       "      <td>54183734b71f11e68b9000e08147c934</td>\n",
       "      <td>samsbox98</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>658895</td>\n",
       "      <td>a2a0f6a6b5c911e49e2800e08147c934</td>\n",
       "      <td>samsbox28</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>148634</td>\n",
       "      <td>756a5566d51411e2ac9f00e08147c934</td>\n",
       "      <td>samsbox06</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>632438</td>\n",
       "      <td>0d33c84ec65b11e49ffd00e08147c934</td>\n",
       "      <td>samsbox48</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>148220</td>\n",
       "      <td>ee63c7e6291811e4ae5700e08147c934</td>\n",
       "      <td>samsbox21</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>660166</td>\n",
       "      <td>3cef0680c1be11e4b42200e08147c934</td>\n",
       "      <td>samsbox40</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>950236</td>\n",
       "      <td>f91df828ab7a11e6bc2b00e08147c934</td>\n",
       "      <td>samsbox96</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>660130</td>\n",
       "      <td>209cb620516611e5a7c400e08147c934</td>\n",
       "      <td>samsbox79</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>129210</td>\n",
       "      <td>b9932adee24711e288cf00e08147c934</td>\n",
       "      <td>samsbox10</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>658737</td>\n",
       "      <td>d72c328ac1bf11e4990c00e08147c934</td>\n",
       "      <td>samsbox41</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>632288</td>\n",
       "      <td>6cbffc96eaa611e4aabb00e08147c934</td>\n",
       "      <td>samsbox66</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>950240</td>\n",
       "      <td>f482b888b6c611e68b9000e08147c934</td>\n",
       "      <td>samsbox97</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>660132</td>\n",
       "      <td>f377da562b1f11e588fa00e08147c934</td>\n",
       "      <td>samsbox77</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>950206</td>\n",
       "      <td>8f51598abd9a11e69d4e00e08147c934</td>\n",
       "      <td>samsbox101</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>660862</td>\n",
       "      <td>e681bb1cc97411e4a69300e08147c934</td>\n",
       "      <td>samsbox52</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>950218</td>\n",
       "      <td>3c43328ca9bc11e6bc2b00e08147c934</td>\n",
       "      <td>samsbox91</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>950230</td>\n",
       "      <td>62101974a80111e698c100e08147c934</td>\n",
       "      <td>samsbox88</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>658893</td>\n",
       "      <td>f7ccdbaab5c811e4895500e08147c934</td>\n",
       "      <td>samsbox27</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>148650</td>\n",
       "      <td>915c1bf6b4a311e2a0d300e08147c934</td>\n",
       "      <td>samsbox04</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>632386</td>\n",
       "      <td>d6c7ad5c297911e5b82400e08147c934</td>\n",
       "      <td>samsbox74</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>658739</td>\n",
       "      <td>b161960cb5cc11e4b42200e08147c934</td>\n",
       "      <td>samsbox30</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>631352</td>\n",
       "      <td>85342e725f6a11e486cd00e08147c934</td>\n",
       "      <td>samsbox22</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>661030</td>\n",
       "      <td>f837b51cd3e411e49ffd00e08147c934</td>\n",
       "      <td>samsbox61</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>241735</td>\n",
       "      <td>92d329488fd611e3b77500e08147c934</td>\n",
       "      <td>samsbox15</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>123256</td>\n",
       "      <td>bdf8bc9a8af611e2a74900e08147c934</td>\n",
       "      <td>samsbox02</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>483702</td>\n",
       "      <td>1ac50686606611e4b7ae00e08147c934</td>\n",
       "      <td>samsbox24</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>658741</td>\n",
       "      <td>ee3c3528b5cc11e4990c00e08147c934</td>\n",
       "      <td>samsbox31</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>474346</td>\n",
       "      <td>45792d9aaf4411e3971a00e08147c934</td>\n",
       "      <td>samsbox19</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>661028</td>\n",
       "      <td>1597073682de11e59b8700e08147c934</td>\n",
       "      <td>samsbox80</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>659046</td>\n",
       "      <td>1133553ed3dc11e4895500e08147c934</td>\n",
       "      <td>samsbox58</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>665660</td>\n",
       "      <td>582d67f6297f11e5891700e08147c934</td>\n",
       "      <td>samsbox76</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>660170</td>\n",
       "      <td>0ac18d78c97911e4a67900e08147c934</td>\n",
       "      <td>samsbox54</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>167808</td>\n",
       "      <td>28ea168ace7111e28ebf00e08147c934</td>\n",
       "      <td>samsbox05</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>901936</td>\n",
       "      <td>3ad3bcdc737511e6accc00e08147c934</td>\n",
       "      <td>samsbox81</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>950202</td>\n",
       "      <td>fa260994bb8911e6b5e300e08147c934</td>\n",
       "      <td>samsbox100</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>940010</td>\n",
       "      <td>ee394284a03311e69d4e00e08147c934</td>\n",
       "      <td>samsbox82</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>660120</td>\n",
       "      <td>2fa51e40c1c011e49e2800e08147c934</td>\n",
       "      <td>samsbox42</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>950224</td>\n",
       "      <td>fcb2241ea83211e6bc2b00e08147c934</td>\n",
       "      <td>samsbox90</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>635734</td>\n",
       "      <td>02892dd4be6e11e49ffd00e08147c934</td>\n",
       "      <td>samsbox34</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>658901</td>\n",
       "      <td>17c17a6eb5ca11e4817000e08147c934</td>\n",
       "      <td>samsbox29</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>631646</td>\n",
       "      <td>358555645f7311e486cd00e08147c934</td>\n",
       "      <td>samsbox23</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>660860</td>\n",
       "      <td>848b60b0c98e11e4a69300e08147c934</td>\n",
       "      <td>samsbox55</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>660864</td>\n",
       "      <td>07e1bc68c65911e4a69300e08147c934</td>\n",
       "      <td>samsbox45</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>663070</td>\n",
       "      <td>1a04fadc1a9f11e59f9400e08147c934</td>\n",
       "      <td>samsbox72</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>663072</td>\n",
       "      <td>e2b84a2c41b611e5957200e08147c934</td>\n",
       "      <td>samsbox78</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>950226</td>\n",
       "      <td>518484b2aa9711e69d4e00e08147c934</td>\n",
       "      <td>samsbox92</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>102 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    skunitid                             msmid        name   hardware\n",
       "0     200172  43429f748f4711e3b77500e08147c934   samsbox14    WR741ND\n",
       "1     950238  383d4f02bfe111e693d000e08147c934  samsbox102      SKWB8\n",
       "2     660078  f3d48fe4be7311e4a00300e08147c934   samsbox38    WDR3600\n",
       "3     632466  1833f5c8d3dc11e4b42200e08147c934   samsbox59    WR741ND\n",
       "4     658899  dadf6ae0be6e11e4a67900e08147c934   samsbox36    WDR3600\n",
       "5     148644  635cd9468afc11e2901a00e08147c934   samsbox03  WR741NDv4\n",
       "6     241733  7931bc2ea87811e3914e00e08147c934   samsbox17    WR741ND\n",
       "7     632394  835a36a8eaa411e4aabb00e08147c934   samsbox62    WR741ND\n",
       "8     660150  0319d9e6d3d711e4990c00e08147c934   samsbox56  WR741NDv4\n",
       "9      19602  1c122042829e11e3a2f800e08147c934   samsbox13    WR741ND\n",
       "10    525918  7cb11ea8c97411e4a00300e08147c934   samsbox51    WR741ND\n",
       "11    200864  8c3652e2810611e3a2f800e08147c934   samsbox12    WR741ND\n",
       "12    632406  07ff9a68c1c111e49ffd00e08147c934   samsbox43    WR741ND\n",
       "13    950212  c4042aeca7fe11e6a78700e08147c934   samsbox84      SKWB8\n",
       "14    950210  54183734b71f11e68b9000e08147c934   samsbox98      SKWB8\n",
       "15    658895  a2a0f6a6b5c911e49e2800e08147c934   samsbox28    WDR3600\n",
       "16    148634  756a5566d51411e2ac9f00e08147c934   samsbox06  WR741NDv4\n",
       "17    632438  0d33c84ec65b11e49ffd00e08147c934   samsbox48    WR741ND\n",
       "18    148220  ee63c7e6291811e4ae5700e08147c934   samsbox21  WR741NDv4\n",
       "19    660166  3cef0680c1be11e4b42200e08147c934   samsbox40    WDR3600\n",
       "20    950236  f91df828ab7a11e6bc2b00e08147c934   samsbox96      SKWB8\n",
       "21    660130  209cb620516611e5a7c400e08147c934   samsbox79    WDR3600\n",
       "22    129210  b9932adee24711e288cf00e08147c934   samsbox10  WR741NDv4\n",
       "23    658737  d72c328ac1bf11e4990c00e08147c934   samsbox41    WDR3600\n",
       "24    632288  6cbffc96eaa611e4aabb00e08147c934   samsbox66    WR741ND\n",
       "25    950240  f482b888b6c611e68b9000e08147c934   samsbox97      SKWB8\n",
       "26    660132  f377da562b1f11e588fa00e08147c934   samsbox77    WDR3600\n",
       "27    950206  8f51598abd9a11e69d4e00e08147c934  samsbox101      SKWB8\n",
       "28    660862  e681bb1cc97411e4a69300e08147c934   samsbox52  WR741NDv4\n",
       "29    950218  3c43328ca9bc11e6bc2b00e08147c934   samsbox91      SKWB8\n",
       "..       ...                               ...         ...        ...\n",
       "72    950230  62101974a80111e698c100e08147c934   samsbox88      SKWB8\n",
       "73    658893  f7ccdbaab5c811e4895500e08147c934   samsbox27    WDR3600\n",
       "74    148650  915c1bf6b4a311e2a0d300e08147c934   samsbox04  WR741NDv4\n",
       "75    632386  d6c7ad5c297911e5b82400e08147c934   samsbox74    WR741ND\n",
       "76    658739  b161960cb5cc11e4b42200e08147c934   samsbox30  WR741NDv4\n",
       "77    631352  85342e725f6a11e486cd00e08147c934   samsbox22    WR741ND\n",
       "78    661030  f837b51cd3e411e49ffd00e08147c934   samsbox61    WDR3600\n",
       "79    241735  92d329488fd611e3b77500e08147c934   samsbox15    WR741ND\n",
       "80    123256  bdf8bc9a8af611e2a74900e08147c934   samsbox02  WR741NDv4\n",
       "81    483702  1ac50686606611e4b7ae00e08147c934   samsbox24    WDR3600\n",
       "82    658741  ee3c3528b5cc11e4990c00e08147c934   samsbox31  WR741NDv4\n",
       "83    474346  45792d9aaf4411e3971a00e08147c934   samsbox19    WDR3600\n",
       "84    661028  1597073682de11e59b8700e08147c934   samsbox80    WDR3600\n",
       "85    659046  1133553ed3dc11e4895500e08147c934   samsbox58    WDR3600\n",
       "86    665660  582d67f6297f11e5891700e08147c934   samsbox76  WR741NDv4\n",
       "87    660170  0ac18d78c97911e4a67900e08147c934   samsbox54    WDR3600\n",
       "88    167808  28ea168ace7111e28ebf00e08147c934   samsbox05  WR741NDv4\n",
       "89    901936  3ad3bcdc737511e6accc00e08147c934   samsbox81      SKWB8\n",
       "90    950202  fa260994bb8911e6b5e300e08147c934  samsbox100      SKWB8\n",
       "91    940010  ee394284a03311e69d4e00e08147c934   samsbox82      SKWB8\n",
       "92    660120  2fa51e40c1c011e49e2800e08147c934   samsbox42  WR741NDv4\n",
       "93    950224  fcb2241ea83211e6bc2b00e08147c934   samsbox90      SKWB8\n",
       "94    635734  02892dd4be6e11e49ffd00e08147c934   samsbox34    WR741ND\n",
       "95    658901  17c17a6eb5ca11e4817000e08147c934   samsbox29    WDR3600\n",
       "96    631646  358555645f7311e486cd00e08147c934   samsbox23    WR741ND\n",
       "97    660860  848b60b0c98e11e4a69300e08147c934   samsbox55    WDR3600\n",
       "98    660864  07e1bc68c65911e4a69300e08147c934   samsbox45  WR741NDv4\n",
       "99    663070  1a04fadc1a9f11e59f9400e08147c934   samsbox72    WDR3600\n",
       "100   663072  e2b84a2c41b611e5957200e08147c934   samsbox78    WDR3600\n",
       "101   950226  518484b2aa9711e69d4e00e08147c934   samsbox92      SKWB8\n",
       "\n",
       "[102 rows x 4 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# load metadata of probes; required to get skunitid for merging\n",
    "probes_metadata = pd.read_csv('metadata.txt', engine = 'python', sep = '|', skiprows = 3, skipfooter = 1, names = ['probe', 'since', 'hardware', 'asnv4', 'asnv6', 'location', 'type', 'test'])\n",
    "probes_metadata = probes_metadata[['probe', 'since', 'hardware', 'asnv4', 'asnv6', 'location', 'type']].reset_index().drop('index', 1)\n",
    "# replace probe number with name to merge with table 'msmpoint' to get skunitid\n",
    "# strip whitespace from beginning and end of string\n",
    "probes_metadata['probe'] = probes_metadata['probe'].str.replace('#', 'samsbox').str.strip()\n",
    "\n",
    "probes = pd.merge(probes_metadata, df, left_on = 'probe', right_on = 'name')\n",
    "probes = probes.rename(columns = {'skunitid' : 'unit_id', 'asnv4' : 'src_asn_v4', 'asnv6' : 'src_asn_v6'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>probe</th>\n",
       "      <th>since</th>\n",
       "      <th>hardware_x</th>\n",
       "      <th>src_asn_v4</th>\n",
       "      <th>src_asn_v6</th>\n",
       "      <th>location</th>\n",
       "      <th>type</th>\n",
       "      <th>unit_id</th>\n",
       "      <th>msmid</th>\n",
       "      <th>name</th>\n",
       "      <th>hardware_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>samsbox01</td>\n",
       "      <td>2013, Mar 12</td>\n",
       "      <td>WR741NDv4</td>\n",
       "      <td>AS680</td>\n",
       "      <td>AS680</td>\n",
       "      <td>Bremen</td>\n",
       "      <td>NREN</td>\n",
       "      <td>62712</td>\n",
       "      <td>28f784568afa11e2b54500e08147c934</td>\n",
       "      <td>samsbox01</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>samsbox02</td>\n",
       "      <td>2017, Jan 18</td>\n",
       "      <td>WR741NDv4</td>\n",
       "      <td>AS8767</td>\n",
       "      <td>AS8767</td>\n",
       "      <td>Munich</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>123256</td>\n",
       "      <td>bdf8bc9a8af611e2a74900e08147c934</td>\n",
       "      <td>samsbox02</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>samsbox03</td>\n",
       "      <td>2013, Mar 12</td>\n",
       "      <td>WR741NDv4</td>\n",
       "      <td>AS24956</td>\n",
       "      <td>AS24956</td>\n",
       "      <td>Braunschweig</td>\n",
       "      <td>BUSINESS</td>\n",
       "      <td>148644</td>\n",
       "      <td>635cd9468afc11e2901a00e08147c934</td>\n",
       "      <td>samsbox03</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>samsbox04</td>\n",
       "      <td>2016, Jan 12</td>\n",
       "      <td>WR741NDv4</td>\n",
       "      <td>AS3320</td>\n",
       "      <td>AS3320</td>\n",
       "      <td>Oldenburg</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>148650</td>\n",
       "      <td>915c1bf6b4a311e2a0d300e08147c934</td>\n",
       "      <td>samsbox04</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>samsbox05</td>\n",
       "      <td>2016, Jul 08</td>\n",
       "      <td>WR741NDv4</td>\n",
       "      <td>AS5607</td>\n",
       "      <td>AS5607</td>\n",
       "      <td>London</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>167808</td>\n",
       "      <td>28ea168ace7111e28ebf00e08147c934</td>\n",
       "      <td>samsbox05</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>samsbox06</td>\n",
       "      <td>2013, Jun 14</td>\n",
       "      <td>WR741NDv4</td>\n",
       "      <td>AS3269</td>\n",
       "      <td>AS3269</td>\n",
       "      <td>Torino</td>\n",
       "      <td>LAB</td>\n",
       "      <td>148634</td>\n",
       "      <td>756a5566d51411e2ac9f00e08147c934</td>\n",
       "      <td>samsbox06</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>samsbox07</td>\n",
       "      <td>2013, Jun 19</td>\n",
       "      <td>WR741NDv4</td>\n",
       "      <td>AS8903</td>\n",
       "      <td>AS8903</td>\n",
       "      <td>Madrid</td>\n",
       "      <td>LAB</td>\n",
       "      <td>181536</td>\n",
       "      <td>689e8df6d8fd11e297d600e08147c934</td>\n",
       "      <td>samsbox07</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>samsbox08</td>\n",
       "      <td>2013, Jun 21</td>\n",
       "      <td>WR741NDv4</td>\n",
       "      <td>AS2614</td>\n",
       "      <td>AS2614</td>\n",
       "      <td>Timisoara</td>\n",
       "      <td>NREN</td>\n",
       "      <td>143666</td>\n",
       "      <td>93758a3eda6511e2814500e08147c934</td>\n",
       "      <td>samsbox08</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>samsbox09</td>\n",
       "      <td>2013, Jun 27</td>\n",
       "      <td>WR741NDv4</td>\n",
       "      <td>AS13030</td>\n",
       "      <td>AS13030</td>\n",
       "      <td>Olten</td>\n",
       "      <td>BUSINESS</td>\n",
       "      <td>148648</td>\n",
       "      <td>d8bd1eecdf1311e2814500e08147c934</td>\n",
       "      <td>samsbox09</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>samsbox10</td>\n",
       "      <td>2016, Mar 27</td>\n",
       "      <td>WR741NDv4</td>\n",
       "      <td>AS2856</td>\n",
       "      <td>AS2856</td>\n",
       "      <td>Ipswich</td>\n",
       "      <td>LAB</td>\n",
       "      <td>129210</td>\n",
       "      <td>b9932adee24711e288cf00e08147c934</td>\n",
       "      <td>samsbox10</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>samsbox11</td>\n",
       "      <td>2014, Jan 17</td>\n",
       "      <td>WR741ND</td>\n",
       "      <td>AS50989</td>\n",
       "      <td>AS1257</td>\n",
       "      <td>Stockholm</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>239416</td>\n",
       "      <td>9a890ef67f9511e3908700e08147c934</td>\n",
       "      <td>samsbox11</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>samsbox12</td>\n",
       "      <td>2014, Jan 19</td>\n",
       "      <td>WR741ND</td>\n",
       "      <td>AS4685</td>\n",
       "      <td>AS4718</td>\n",
       "      <td>Fukuoka</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>200864</td>\n",
       "      <td>8c3652e2810611e3a2f800e08147c934</td>\n",
       "      <td>samsbox12</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>samsbox13</td>\n",
       "      <td>2014, Jan 21</td>\n",
       "      <td>WR741ND</td>\n",
       "      <td>AS12715</td>\n",
       "      <td>AS12715</td>\n",
       "      <td>Madrid</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>19602</td>\n",
       "      <td>1c122042829e11e3a2f800e08147c934</td>\n",
       "      <td>samsbox13</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>samsbox14</td>\n",
       "      <td>2014, Feb 06</td>\n",
       "      <td>WR741ND</td>\n",
       "      <td>AS18070</td>\n",
       "      <td>AS18070</td>\n",
       "      <td>Niigata</td>\n",
       "      <td>IXP</td>\n",
       "      <td>200172</td>\n",
       "      <td>43429f748f4711e3b77500e08147c934</td>\n",
       "      <td>samsbox14</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>samsbox15</td>\n",
       "      <td>2016, Jul 02</td>\n",
       "      <td>WR741ND</td>\n",
       "      <td>AS12392</td>\n",
       "      <td>AS12392</td>\n",
       "      <td>Gembloux</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>241735</td>\n",
       "      <td>92d329488fd611e3b77500e08147c934</td>\n",
       "      <td>samsbox15</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>samsbox16</td>\n",
       "      <td>2014, Feb 17</td>\n",
       "      <td>WR741NDv4</td>\n",
       "      <td>AS513</td>\n",
       "      <td>AS513</td>\n",
       "      <td>CERN</td>\n",
       "      <td>RESEARCH</td>\n",
       "      <td>181532</td>\n",
       "      <td>05fc09a697e511e3913100e08147c934</td>\n",
       "      <td>samsbox16</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>samsbox17</td>\n",
       "      <td>2014, Mar 10</td>\n",
       "      <td>WR741ND</td>\n",
       "      <td>AS9031</td>\n",
       "      <td>AS9031</td>\n",
       "      <td>Alleur</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>241733</td>\n",
       "      <td>7931bc2ea87811e3914e00e08147c934</td>\n",
       "      <td>samsbox17</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>samsbox18</td>\n",
       "      <td>2014, Mar 03</td>\n",
       "      <td>WDR3600</td>\n",
       "      <td>AS680</td>\n",
       "      <td>AS680</td>\n",
       "      <td>Bremen</td>\n",
       "      <td>NREN</td>\n",
       "      <td>201338</td>\n",
       "      <td>27b0bd32a2fb11e3a2f800e08147c934</td>\n",
       "      <td>samsbox18</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>samsbox19</td>\n",
       "      <td>2015, Nov 07</td>\n",
       "      <td>WDR3600</td>\n",
       "      <td>AS3265</td>\n",
       "      <td>AS3265</td>\n",
       "      <td>Hengelo</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>474346</td>\n",
       "      <td>45792d9aaf4411e3971a00e08147c934</td>\n",
       "      <td>samsbox19</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>samsbox20</td>\n",
       "      <td>2014, Mar 19</td>\n",
       "      <td>WR741ND</td>\n",
       "      <td>AS2518</td>\n",
       "      <td>AS2516</td>\n",
       "      <td>Shizuoka</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>241743</td>\n",
       "      <td>60e88ffeaf3e11e3971a00e08147c934</td>\n",
       "      <td>samsbox20</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>samsbox21</td>\n",
       "      <td>2014, Aug 21</td>\n",
       "      <td>WR741NDv4</td>\n",
       "      <td>AS1741</td>\n",
       "      <td>AS1741</td>\n",
       "      <td>Helsinki</td>\n",
       "      <td>NREN</td>\n",
       "      <td>148220</td>\n",
       "      <td>ee63c7e6291811e4ae5700e08147c934</td>\n",
       "      <td>samsbox21</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>samsbox22</td>\n",
       "      <td>2014, Oct 29</td>\n",
       "      <td>WR741ND</td>\n",
       "      <td>AS8708</td>\n",
       "      <td>AS8708</td>\n",
       "      <td>Roman</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>631352</td>\n",
       "      <td>85342e725f6a11e486cd00e08147c934</td>\n",
       "      <td>samsbox22</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>samsbox23</td>\n",
       "      <td>2014, Oct 29</td>\n",
       "      <td>WR741ND</td>\n",
       "      <td>AS197451</td>\n",
       "      <td>AS197451</td>\n",
       "      <td>Brno</td>\n",
       "      <td>RESEARCH</td>\n",
       "      <td>631646</td>\n",
       "      <td>358555645f7311e486cd00e08147c934</td>\n",
       "      <td>samsbox23</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>samsbox24</td>\n",
       "      <td>2015, Jul 14</td>\n",
       "      <td>WDR3600</td>\n",
       "      <td>AS8426</td>\n",
       "      <td>AS8426</td>\n",
       "      <td>Southampton</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>483702</td>\n",
       "      <td>1ac50686606611e4b7ae00e08147c934</td>\n",
       "      <td>samsbox24</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>samsbox25</td>\n",
       "      <td>2015, Jan 15</td>\n",
       "      <td>WR741ND</td>\n",
       "      <td>AS1759</td>\n",
       "      <td>AS1759</td>\n",
       "      <td>Tarttila</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>632384</td>\n",
       "      <td>5cb438409c1711e4887c00e08147c934</td>\n",
       "      <td>samsbox25</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>samsbox26</td>\n",
       "      <td>2015, Feb 16</td>\n",
       "      <td>WDR3600</td>\n",
       "      <td>AS5607</td>\n",
       "      <td>AS5607</td>\n",
       "      <td>London</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>658891</td>\n",
       "      <td>a63430ccb5c811e4a69300e08147c934</td>\n",
       "      <td>samsbox26</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>samsbox27</td>\n",
       "      <td>2015, Feb 16</td>\n",
       "      <td>WDR3600</td>\n",
       "      <td>AS7922</td>\n",
       "      <td>AS7922</td>\n",
       "      <td>Philadelphia</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>658893</td>\n",
       "      <td>f7ccdbaab5c811e4895500e08147c934</td>\n",
       "      <td>samsbox27</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>samsbox28</td>\n",
       "      <td>2015, Feb 16</td>\n",
       "      <td>WDR3600</td>\n",
       "      <td>AS209</td>\n",
       "      <td>AS209</td>\n",
       "      <td>Golden</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>658895</td>\n",
       "      <td>a2a0f6a6b5c911e49e2800e08147c934</td>\n",
       "      <td>samsbox28</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>samsbox29</td>\n",
       "      <td>2017, Jan 24</td>\n",
       "      <td>WDR3600</td>\n",
       "      <td>AS7247</td>\n",
       "      <td>AS7247</td>\n",
       "      <td>Fremont</td>\n",
       "      <td>DATACENTER</td>\n",
       "      <td>658901</td>\n",
       "      <td>17c17a6eb5ca11e4817000e08147c934</td>\n",
       "      <td>samsbox29</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>samsbox30</td>\n",
       "      <td>2015, Feb 16</td>\n",
       "      <td>WR741NDv4</td>\n",
       "      <td>AS7922</td>\n",
       "      <td>AS7922</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>658739</td>\n",
       "      <td>b161960cb5cc11e4b42200e08147c934</td>\n",
       "      <td>samsbox30</td>\n",
       "      <td>WR741NDv4</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>samsbox73</td>\n",
       "      <td>2015, Jul 14</td>\n",
       "      <td>WDR3600</td>\n",
       "      <td>AS8121</td>\n",
       "      <td>AS8121</td>\n",
       "      <td>Ashburn</td>\n",
       "      <td>DATACENTER</td>\n",
       "      <td>658903</td>\n",
       "      <td>b47cfb7c297811e5983500e08147c934</td>\n",
       "      <td>samsbox73</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>samsbox74</td>\n",
       "      <td>2015, Jul 14</td>\n",
       "      <td>WR741ND</td>\n",
       "      <td>AS20625</td>\n",
       "      <td>AS20625</td>\n",
       "      <td>Bollnas</td>\n",
       "      <td>BUSINESS</td>\n",
       "      <td>632386</td>\n",
       "      <td>d6c7ad5c297911e5b82400e08147c934</td>\n",
       "      <td>samsbox74</td>\n",
       "      <td>WR741ND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>samsbox75</td>\n",
       "      <td>2015, Jul 14</td>\n",
       "      <td>WDR3600</td>\n",
       "      <td>AS13030</td>\n",
       "      <td>AS13030</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>660852</td>\n",
       "      <td>bd085c6a297c11e5a98a00e08147c934</td>\n",
       "      <td>samsbox75</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>samsbox76</td>\n",
       "      <td>2015, Jul 14</td>\n",
       "      <td>WR741NDv4</td>\n",
       "      <td>AS6648</td>\n",
       "      <td>-</td>\n",
       "      <td>Quezon City</td>\n",
       "      <td>NREN</td>\n",
       "      <td>665660</td>\n",
       "      <td>582d67f6297f11e5891700e08147c934</td>\n",
       "      <td>samsbox76</td>\n",
       "      <td>WR741NDv4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>samsbox77</td>\n",
       "      <td>2015, Aug 19</td>\n",
       "      <td>WDR3600</td>\n",
       "      <td>AS5381</td>\n",
       "      <td>AS5381</td>\n",
       "      <td>Oslo</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>660132</td>\n",
       "      <td>f377da562b1f11e588fa00e08147c934</td>\n",
       "      <td>samsbox77</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>samsbox78</td>\n",
       "      <td>2015, Aug 14</td>\n",
       "      <td>WDR3600</td>\n",
       "      <td>AS7922</td>\n",
       "      <td>AS7922</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>663072</td>\n",
       "      <td>e2b84a2c41b611e5957200e08147c934</td>\n",
       "      <td>samsbox78</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>samsbox79</td>\n",
       "      <td>2016, Sep 11</td>\n",
       "      <td>WDR3600</td>\n",
       "      <td>AS2119</td>\n",
       "      <td>AS2119</td>\n",
       "      <td>Bergen</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>660130</td>\n",
       "      <td>209cb620516611e5a7c400e08147c934</td>\n",
       "      <td>samsbox79</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>samsbox80</td>\n",
       "      <td>2015, Nov 04</td>\n",
       "      <td>WDR3600</td>\n",
       "      <td>AS14877</td>\n",
       "      <td>-</td>\n",
       "      <td>Harrisburg</td>\n",
       "      <td>NREN</td>\n",
       "      <td>661028</td>\n",
       "      <td>1597073682de11e59b8700e08147c934</td>\n",
       "      <td>samsbox80</td>\n",
       "      <td>WDR3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>samsbox81</td>\n",
       "      <td>2016, Sep 19</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS2119</td>\n",
       "      <td>AS2119</td>\n",
       "      <td>Jessheim</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>901936</td>\n",
       "      <td>3ad3bcdc737511e6accc00e08147c934</td>\n",
       "      <td>samsbox81</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>samsbox82</td>\n",
       "      <td>2016, Nov 08</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS2119</td>\n",
       "      <td>AS2119</td>\n",
       "      <td>Oslo</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>940010</td>\n",
       "      <td>ee394284a03311e69d4e00e08147c934</td>\n",
       "      <td>samsbox82</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>samsbox83</td>\n",
       "      <td>2016, Nov 12</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS9031</td>\n",
       "      <td>AS9031</td>\n",
       "      <td>Brussels</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950208</td>\n",
       "      <td>1c6705f2a7fe11e6bc2b00e08147c934</td>\n",
       "      <td>samsbox83</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>samsbox84</td>\n",
       "      <td>2016, Nov 12</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS5466</td>\n",
       "      <td>AS5466</td>\n",
       "      <td>Wicklow</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950212</td>\n",
       "      <td>c4042aeca7fe11e6a78700e08147c934</td>\n",
       "      <td>samsbox84</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>samsbox85</td>\n",
       "      <td>2016, Nov 12</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS15659</td>\n",
       "      <td>AS15659</td>\n",
       "      <td>Hagan</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950216</td>\n",
       "      <td>4c04575aa7ff11e698c100e08147c934</td>\n",
       "      <td>samsbox85</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>samsbox86</td>\n",
       "      <td>2016, Nov 12</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS5603</td>\n",
       "      <td>AS5603</td>\n",
       "      <td>Domzale</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950222</td>\n",
       "      <td>1a95a254a80011e6b5e300e08147c934</td>\n",
       "      <td>samsbox86</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>samsbox87</td>\n",
       "      <td>2016, Nov 12</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS51615</td>\n",
       "      <td>AS51615</td>\n",
       "      <td>Nova Gorica</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950228</td>\n",
       "      <td>3cf9a07ea80111e698c100e08147c934</td>\n",
       "      <td>samsbox87</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>samsbox88</td>\n",
       "      <td>2016, Nov 12</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS5607</td>\n",
       "      <td>AS5607</td>\n",
       "      <td>Kent</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950230</td>\n",
       "      <td>62101974a80111e698c100e08147c934</td>\n",
       "      <td>samsbox88</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>samsbox89</td>\n",
       "      <td>2016, Nov 13</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS7922</td>\n",
       "      <td>AS7922</td>\n",
       "      <td>Sunnyvale</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950232</td>\n",
       "      <td>919dbdb8a80111e6accc00e08147c934</td>\n",
       "      <td>samsbox89</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>samsbox90</td>\n",
       "      <td>2016, Nov 13</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS34779</td>\n",
       "      <td>AS34779</td>\n",
       "      <td>Ptuj</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950224</td>\n",
       "      <td>fcb2241ea83211e6bc2b00e08147c934</td>\n",
       "      <td>samsbox90</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>samsbox91</td>\n",
       "      <td>2016, Nov 13</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS8708</td>\n",
       "      <td>AS8708</td>\n",
       "      <td>Costinesti</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950218</td>\n",
       "      <td>3c43328ca9bc11e6bc2b00e08147c934</td>\n",
       "      <td>samsbox91</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>samsbox92</td>\n",
       "      <td>2016, Nov 15</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS34779</td>\n",
       "      <td>AS34779</td>\n",
       "      <td>Ljubljana</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950226</td>\n",
       "      <td>518484b2aa9711e69d4e00e08147c934</td>\n",
       "      <td>samsbox92</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>samsbox93</td>\n",
       "      <td>2016, Nov 15</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS7922</td>\n",
       "      <td>AS7922</td>\n",
       "      <td>Seattle</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950234</td>\n",
       "      <td>79700590aab111e6bc2b00e08147c934</td>\n",
       "      <td>samsbox93</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>samsbox94</td>\n",
       "      <td>2016, Nov 15</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS3265</td>\n",
       "      <td>AS3265</td>\n",
       "      <td>Houten</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950214</td>\n",
       "      <td>0821c5a6ab2c11e698c100e08147c934</td>\n",
       "      <td>samsbox94</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>samsbox95</td>\n",
       "      <td>2016, Nov 15</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS5603</td>\n",
       "      <td>AS5603</td>\n",
       "      <td>Skofja Loka</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950220</td>\n",
       "      <td>ae6fdc1eab3511e69d4e00e08147c934</td>\n",
       "      <td>samsbox95</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>samsbox96</td>\n",
       "      <td>2016, Nov 16</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS7922</td>\n",
       "      <td>AS7922</td>\n",
       "      <td>Michigan</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950236</td>\n",
       "      <td>f91df828ab7a11e6bc2b00e08147c934</td>\n",
       "      <td>samsbox96</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>samsbox97</td>\n",
       "      <td>2016, Nov 30</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS20375</td>\n",
       "      <td>AS20375</td>\n",
       "      <td>Port Moody</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950240</td>\n",
       "      <td>f482b888b6c611e68b9000e08147c934</td>\n",
       "      <td>samsbox97</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>samsbox98</td>\n",
       "      <td>2016, Nov 30</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS3320</td>\n",
       "      <td>AS3320</td>\n",
       "      <td>Munich</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950210</td>\n",
       "      <td>54183734b71f11e68b9000e08147c934</td>\n",
       "      <td>samsbox98</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>samsbox99</td>\n",
       "      <td>2016, Dec 02</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS45873</td>\n",
       "      <td>AS31732</td>\n",
       "      <td>Doncaster</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950204</td>\n",
       "      <td>058c8356b81211e6b5e300e08147c934</td>\n",
       "      <td>samsbox99</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>samsbox100</td>\n",
       "      <td>2016, Dec 06</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS4739</td>\n",
       "      <td>AS4739</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950202</td>\n",
       "      <td>fa260994bb8911e6b5e300e08147c934</td>\n",
       "      <td>samsbox100</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>samsbox101</td>\n",
       "      <td>2016, Dec 09</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS23655</td>\n",
       "      <td>AS23655</td>\n",
       "      <td>Christchurch</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950206</td>\n",
       "      <td>8f51598abd9a11e69d4e00e08147c934</td>\n",
       "      <td>samsbox101</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>samsbox102</td>\n",
       "      <td>2016, Dec 12</td>\n",
       "      <td>SKWB8</td>\n",
       "      <td>AS12271</td>\n",
       "      <td>AS12271</td>\n",
       "      <td>New York City</td>\n",
       "      <td>RESIDENTIAL</td>\n",
       "      <td>950238</td>\n",
       "      <td>383d4f02bfe111e693d000e08147c934</td>\n",
       "      <td>samsbox102</td>\n",
       "      <td>SKWB8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>102 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          probe           since   hardware_x  src_asn_v4  src_asn_v6  \\\n",
       "0     samsbox01   2013, Mar 12    WR741NDv4    AS680       AS680       \n",
       "1     samsbox02   2017, Jan 18    WR741NDv4    AS8767      AS8767      \n",
       "2     samsbox03   2013, Mar 12    WR741NDv4    AS24956     AS24956     \n",
       "3     samsbox04   2016, Jan 12    WR741NDv4    AS3320      AS3320      \n",
       "4     samsbox05   2016, Jul 08    WR741NDv4    AS5607      AS5607      \n",
       "5     samsbox06   2013, Jun 14    WR741NDv4    AS3269      AS3269      \n",
       "6     samsbox07   2013, Jun 19    WR741NDv4    AS8903      AS8903      \n",
       "7     samsbox08   2013, Jun 21    WR741NDv4    AS2614      AS2614      \n",
       "8     samsbox09   2013, Jun 27    WR741NDv4    AS13030     AS13030     \n",
       "9     samsbox10   2016, Mar 27    WR741NDv4    AS2856      AS2856      \n",
       "10    samsbox11   2014, Jan 17    WR741ND      AS50989     AS1257      \n",
       "11    samsbox12   2014, Jan 19    WR741ND      AS4685      AS4718      \n",
       "12    samsbox13   2014, Jan 21    WR741ND      AS12715     AS12715     \n",
       "13    samsbox14   2014, Feb 06    WR741ND      AS18070     AS18070     \n",
       "14    samsbox15   2016, Jul 02    WR741ND      AS12392     AS12392     \n",
       "15    samsbox16   2014, Feb 17    WR741NDv4    AS513       AS513       \n",
       "16    samsbox17   2014, Mar 10    WR741ND      AS9031      AS9031      \n",
       "17    samsbox18   2014, Mar 03    WDR3600      AS680       AS680       \n",
       "18    samsbox19   2015, Nov 07    WDR3600      AS3265      AS3265      \n",
       "19    samsbox20   2014, Mar 19    WR741ND      AS2518      AS2516      \n",
       "20    samsbox21   2014, Aug 21    WR741NDv4    AS1741      AS1741      \n",
       "21    samsbox22   2014, Oct 29    WR741ND      AS8708      AS8708      \n",
       "22    samsbox23   2014, Oct 29    WR741ND      AS197451    AS197451    \n",
       "23    samsbox24   2015, Jul 14    WDR3600      AS8426      AS8426      \n",
       "24    samsbox25   2015, Jan 15    WR741ND      AS1759      AS1759      \n",
       "25    samsbox26   2015, Feb 16    WDR3600      AS5607      AS5607      \n",
       "26    samsbox27   2015, Feb 16    WDR3600      AS7922      AS7922      \n",
       "27    samsbox28   2015, Feb 16    WDR3600      AS209       AS209       \n",
       "28    samsbox29   2017, Jan 24    WDR3600      AS7247      AS7247      \n",
       "29    samsbox30   2015, Feb 16    WR741NDv4    AS7922      AS7922      \n",
       "..          ...             ...          ...         ...         ...   \n",
       "72    samsbox73   2015, Jul 14    WDR3600      AS8121      AS8121      \n",
       "73    samsbox74   2015, Jul 14    WR741ND      AS20625     AS20625     \n",
       "74    samsbox75   2015, Jul 14    WDR3600      AS13030     AS13030     \n",
       "75    samsbox76   2015, Jul 14    WR741NDv4    AS6648      -           \n",
       "76    samsbox77   2015, Aug 19    WDR3600      AS5381      AS5381      \n",
       "77    samsbox78   2015, Aug 14    WDR3600      AS7922      AS7922      \n",
       "78    samsbox79   2016, Sep 11    WDR3600      AS2119      AS2119      \n",
       "79    samsbox80   2015, Nov 04    WDR3600      AS14877     -           \n",
       "80    samsbox81   2016, Sep 19    SKWB8        AS2119      AS2119      \n",
       "81    samsbox82   2016, Nov 08    SKWB8        AS2119      AS2119      \n",
       "82    samsbox83   2016, Nov 12    SKWB8        AS9031      AS9031      \n",
       "83    samsbox84   2016, Nov 12    SKWB8        AS5466      AS5466      \n",
       "84    samsbox85   2016, Nov 12    SKWB8        AS15659     AS15659     \n",
       "85    samsbox86   2016, Nov 12    SKWB8        AS5603      AS5603      \n",
       "86    samsbox87   2016, Nov 12    SKWB8        AS51615     AS51615     \n",
       "87    samsbox88   2016, Nov 12    SKWB8        AS5607      AS5607      \n",
       "88    samsbox89   2016, Nov 13    SKWB8        AS7922      AS7922      \n",
       "89    samsbox90   2016, Nov 13    SKWB8        AS34779     AS34779     \n",
       "90    samsbox91   2016, Nov 13    SKWB8        AS8708      AS8708      \n",
       "91    samsbox92   2016, Nov 15    SKWB8        AS34779     AS34779     \n",
       "92    samsbox93   2016, Nov 15    SKWB8        AS7922      AS7922      \n",
       "93    samsbox94   2016, Nov 15    SKWB8        AS3265      AS3265      \n",
       "94    samsbox95   2016, Nov 15    SKWB8        AS5603      AS5603      \n",
       "95    samsbox96   2016, Nov 16    SKWB8        AS7922      AS7922      \n",
       "96    samsbox97   2016, Nov 30    SKWB8        AS20375     AS20375     \n",
       "97    samsbox98   2016, Nov 30    SKWB8        AS3320      AS3320      \n",
       "98    samsbox99   2016, Dec 02    SKWB8        AS45873     AS31732     \n",
       "99   samsbox100   2016, Dec 06    SKWB8        AS4739      AS4739      \n",
       "100  samsbox101   2016, Dec 09    SKWB8        AS23655     AS23655     \n",
       "101  samsbox102   2016, Dec 12    SKWB8        AS12271     AS12271     \n",
       "\n",
       "                       location            type unit_id  \\\n",
       "0     Bremen                      NREN            62712   \n",
       "1     Munich                      RESIDENTIAL    123256   \n",
       "2     Braunschweig                BUSINESS       148644   \n",
       "3     Oldenburg                   RESIDENTIAL    148650   \n",
       "4     London                      RESIDENTIAL    167808   \n",
       "5     Torino                      LAB            148634   \n",
       "6     Madrid                      LAB            181536   \n",
       "7     Timisoara                   NREN           143666   \n",
       "8     Olten                       BUSINESS       148648   \n",
       "9     Ipswich                     LAB            129210   \n",
       "10    Stockholm                   RESIDENTIAL    239416   \n",
       "11    Fukuoka                     RESIDENTIAL    200864   \n",
       "12    Madrid                      RESIDENTIAL     19602   \n",
       "13    Niigata                     IXP            200172   \n",
       "14    Gembloux                    RESIDENTIAL    241735   \n",
       "15    CERN                        RESEARCH       181532   \n",
       "16    Alleur                      RESIDENTIAL    241733   \n",
       "17    Bremen                      NREN           201338   \n",
       "18    Hengelo                     RESIDENTIAL    474346   \n",
       "19    Shizuoka                    RESIDENTIAL    241743   \n",
       "20    Helsinki                    NREN           148220   \n",
       "21    Roman                       RESIDENTIAL    631352   \n",
       "22    Brno                        RESEARCH       631646   \n",
       "23    Southampton                 RESIDENTIAL    483702   \n",
       "24    Tarttila                    RESIDENTIAL    632384   \n",
       "25    London                      RESIDENTIAL    658891   \n",
       "26    Philadelphia                RESIDENTIAL    658893   \n",
       "27    Golden                      RESIDENTIAL    658895   \n",
       "28    Fremont                     DATACENTER     658901   \n",
       "29    Atlanta                     RESIDENTIAL    658739   \n",
       "..                          ...             ...     ...   \n",
       "72    Ashburn                     DATACENTER     658903   \n",
       "73    Bollnas                     BUSINESS       632386   \n",
       "74    Zurich                      RESIDENTIAL    660852   \n",
       "75    Quezon City                 NREN           665660   \n",
       "76    Oslo                        RESIDENTIAL    660132   \n",
       "77    Chicago                     RESIDENTIAL    663072   \n",
       "78    Bergen                      RESIDENTIAL    660130   \n",
       "79    Harrisburg                  NREN           661028   \n",
       "80    Jessheim                    RESIDENTIAL    901936   \n",
       "81    Oslo                        RESIDENTIAL    940010   \n",
       "82    Brussels                    RESIDENTIAL    950208   \n",
       "83    Wicklow                     RESIDENTIAL    950212   \n",
       "84    Hagan                       RESIDENTIAL    950216   \n",
       "85    Domzale                     RESIDENTIAL    950222   \n",
       "86    Nova Gorica                 RESIDENTIAL    950228   \n",
       "87    Kent                        RESIDENTIAL    950230   \n",
       "88    Sunnyvale                   RESIDENTIAL    950232   \n",
       "89    Ptuj                        RESIDENTIAL    950224   \n",
       "90    Costinesti                  RESIDENTIAL    950218   \n",
       "91    Ljubljana                   RESIDENTIAL    950226   \n",
       "92    Seattle                     RESIDENTIAL    950234   \n",
       "93    Houten                      RESIDENTIAL    950214   \n",
       "94    Skofja Loka                 RESIDENTIAL    950220   \n",
       "95    Michigan                    RESIDENTIAL    950236   \n",
       "96    Port Moody                  RESIDENTIAL    950240   \n",
       "97    Munich                      RESIDENTIAL    950210   \n",
       "98    Doncaster                   RESIDENTIAL    950204   \n",
       "99    Brisbane                    RESIDENTIAL    950202   \n",
       "100   Christchurch                RESIDENTIAL    950206   \n",
       "101   New York City               RESIDENTIAL    950238   \n",
       "\n",
       "                                msmid        name hardware_y  \n",
       "0    28f784568afa11e2b54500e08147c934   samsbox01  WR741NDv4  \n",
       "1    bdf8bc9a8af611e2a74900e08147c934   samsbox02  WR741NDv4  \n",
       "2    635cd9468afc11e2901a00e08147c934   samsbox03  WR741NDv4  \n",
       "3    915c1bf6b4a311e2a0d300e08147c934   samsbox04  WR741NDv4  \n",
       "4    28ea168ace7111e28ebf00e08147c934   samsbox05  WR741NDv4  \n",
       "5    756a5566d51411e2ac9f00e08147c934   samsbox06  WR741NDv4  \n",
       "6    689e8df6d8fd11e297d600e08147c934   samsbox07  WR741NDv4  \n",
       "7    93758a3eda6511e2814500e08147c934   samsbox08  WR741NDv4  \n",
       "8    d8bd1eecdf1311e2814500e08147c934   samsbox09  WR741NDv4  \n",
       "9    b9932adee24711e288cf00e08147c934   samsbox10  WR741NDv4  \n",
       "10   9a890ef67f9511e3908700e08147c934   samsbox11    WR741ND  \n",
       "11   8c3652e2810611e3a2f800e08147c934   samsbox12    WR741ND  \n",
       "12   1c122042829e11e3a2f800e08147c934   samsbox13    WR741ND  \n",
       "13   43429f748f4711e3b77500e08147c934   samsbox14    WR741ND  \n",
       "14   92d329488fd611e3b77500e08147c934   samsbox15    WR741ND  \n",
       "15   05fc09a697e511e3913100e08147c934   samsbox16  WR741NDv4  \n",
       "16   7931bc2ea87811e3914e00e08147c934   samsbox17    WR741ND  \n",
       "17   27b0bd32a2fb11e3a2f800e08147c934   samsbox18    WDR3600  \n",
       "18   45792d9aaf4411e3971a00e08147c934   samsbox19    WDR3600  \n",
       "19   60e88ffeaf3e11e3971a00e08147c934   samsbox20    WR741ND  \n",
       "20   ee63c7e6291811e4ae5700e08147c934   samsbox21  WR741NDv4  \n",
       "21   85342e725f6a11e486cd00e08147c934   samsbox22    WR741ND  \n",
       "22   358555645f7311e486cd00e08147c934   samsbox23    WR741ND  \n",
       "23   1ac50686606611e4b7ae00e08147c934   samsbox24    WDR3600  \n",
       "24   5cb438409c1711e4887c00e08147c934   samsbox25    WR741ND  \n",
       "25   a63430ccb5c811e4a69300e08147c934   samsbox26    WDR3600  \n",
       "26   f7ccdbaab5c811e4895500e08147c934   samsbox27    WDR3600  \n",
       "27   a2a0f6a6b5c911e49e2800e08147c934   samsbox28    WDR3600  \n",
       "28   17c17a6eb5ca11e4817000e08147c934   samsbox29    WDR3600  \n",
       "29   b161960cb5cc11e4b42200e08147c934   samsbox30  WR741NDv4  \n",
       "..                                ...         ...        ...  \n",
       "72   b47cfb7c297811e5983500e08147c934   samsbox73    WDR3600  \n",
       "73   d6c7ad5c297911e5b82400e08147c934   samsbox74    WR741ND  \n",
       "74   bd085c6a297c11e5a98a00e08147c934   samsbox75    WDR3600  \n",
       "75   582d67f6297f11e5891700e08147c934   samsbox76  WR741NDv4  \n",
       "76   f377da562b1f11e588fa00e08147c934   samsbox77    WDR3600  \n",
       "77   e2b84a2c41b611e5957200e08147c934   samsbox78    WDR3600  \n",
       "78   209cb620516611e5a7c400e08147c934   samsbox79    WDR3600  \n",
       "79   1597073682de11e59b8700e08147c934   samsbox80    WDR3600  \n",
       "80   3ad3bcdc737511e6accc00e08147c934   samsbox81      SKWB8  \n",
       "81   ee394284a03311e69d4e00e08147c934   samsbox82      SKWB8  \n",
       "82   1c6705f2a7fe11e6bc2b00e08147c934   samsbox83      SKWB8  \n",
       "83   c4042aeca7fe11e6a78700e08147c934   samsbox84      SKWB8  \n",
       "84   4c04575aa7ff11e698c100e08147c934   samsbox85      SKWB8  \n",
       "85   1a95a254a80011e6b5e300e08147c934   samsbox86      SKWB8  \n",
       "86   3cf9a07ea80111e698c100e08147c934   samsbox87      SKWB8  \n",
       "87   62101974a80111e698c100e08147c934   samsbox88      SKWB8  \n",
       "88   919dbdb8a80111e6accc00e08147c934   samsbox89      SKWB8  \n",
       "89   fcb2241ea83211e6bc2b00e08147c934   samsbox90      SKWB8  \n",
       "90   3c43328ca9bc11e6bc2b00e08147c934   samsbox91      SKWB8  \n",
       "91   518484b2aa9711e69d4e00e08147c934   samsbox92      SKWB8  \n",
       "92   79700590aab111e6bc2b00e08147c934   samsbox93      SKWB8  \n",
       "93   0821c5a6ab2c11e698c100e08147c934   samsbox94      SKWB8  \n",
       "94   ae6fdc1eab3511e69d4e00e08147c934   samsbox95      SKWB8  \n",
       "95   f91df828ab7a11e6bc2b00e08147c934   samsbox96      SKWB8  \n",
       "96   f482b888b6c611e68b9000e08147c934   samsbox97      SKWB8  \n",
       "97   54183734b71f11e68b9000e08147c934   samsbox98      SKWB8  \n",
       "98   058c8356b81211e6b5e300e08147c934   samsbox99      SKWB8  \n",
       "99   fa260994bb8911e6b5e300e08147c934  samsbox100      SKWB8  \n",
       "100  8f51598abd9a11e69d4e00e08147c934  samsbox101      SKWB8  \n",
       "101  383d4f02bfe111e693d000e08147c934  samsbox102      SKWB8  \n",
       "\n",
       "[102 rows x 11 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "probes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "probes['location'] = probes['location'].str.strip()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "import geopy\n",
    "from tzwhere import tzwhere"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "g = geopy.geocoders.Nominatim(user_agent='my-app')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "tz = tzwhere.tzwhere()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "import time\n",
    "from geopy.exc import GeocoderTimedOut"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "def loc_to_tz(loc):\n",
    "    timezone = ''\n",
    "    try:\n",
    "        location = g.geocode(loc)\n",
    "        timezone = tz.tzNameAt(location[-1][0], location[-1][1])\n",
    "    except GeocoderTimedOut as e:\n",
    "        print(loc, e)\n",
    "    except Exception as e:\n",
    "        print(loc, e)\n",
    "        \n",
    "    return timezone"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CERN Service timed out\n",
      "Atlanta Service timed out\n"
     ]
    }
   ],
   "source": [
    "probes['timezone'] = probes['location'].apply(loc_to_tz)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "p = probes[['unit_id', 'msmid', 'location', 'timezone']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>unit_id</th>\n",
       "      <th>msmid</th>\n",
       "      <th>location</th>\n",
       "      <th>timezone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>62712</td>\n",
       "      <td>28f784568afa11e2b54500e08147c934</td>\n",
       "      <td>Bremen</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>123256</td>\n",
       "      <td>bdf8bc9a8af611e2a74900e08147c934</td>\n",
       "      <td>Munich</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>148644</td>\n",
       "      <td>635cd9468afc11e2901a00e08147c934</td>\n",
       "      <td>Braunschweig</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>148650</td>\n",
       "      <td>915c1bf6b4a311e2a0d300e08147c934</td>\n",
       "      <td>Oldenburg</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>167808</td>\n",
       "      <td>28ea168ace7111e28ebf00e08147c934</td>\n",
       "      <td>London</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>148634</td>\n",
       "      <td>756a5566d51411e2ac9f00e08147c934</td>\n",
       "      <td>Torino</td>\n",
       "      <td>Europe/Rome</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>181536</td>\n",
       "      <td>689e8df6d8fd11e297d600e08147c934</td>\n",
       "      <td>Madrid</td>\n",
       "      <td>Europe/Madrid</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>143666</td>\n",
       "      <td>93758a3eda6511e2814500e08147c934</td>\n",
       "      <td>Timisoara</td>\n",
       "      <td>Europe/Bucharest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>148648</td>\n",
       "      <td>d8bd1eecdf1311e2814500e08147c934</td>\n",
       "      <td>Olten</td>\n",
       "      <td>Europe/Zurich</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>129210</td>\n",
       "      <td>b9932adee24711e288cf00e08147c934</td>\n",
       "      <td>Ipswich</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>239416</td>\n",
       "      <td>9a890ef67f9511e3908700e08147c934</td>\n",
       "      <td>Stockholm</td>\n",
       "      <td>Europe/Stockholm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>200864</td>\n",
       "      <td>8c3652e2810611e3a2f800e08147c934</td>\n",
       "      <td>Fukuoka</td>\n",
       "      <td>Asia/Tokyo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>19602</td>\n",
       "      <td>1c122042829e11e3a2f800e08147c934</td>\n",
       "      <td>Madrid</td>\n",
       "      <td>Europe/Madrid</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>200172</td>\n",
       "      <td>43429f748f4711e3b77500e08147c934</td>\n",
       "      <td>Niigata</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>241735</td>\n",
       "      <td>92d329488fd611e3b77500e08147c934</td>\n",
       "      <td>Gembloux</td>\n",
       "      <td>Europe/Brussels</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>181532</td>\n",
       "      <td>05fc09a697e511e3913100e08147c934</td>\n",
       "      <td>CERN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>241733</td>\n",
       "      <td>7931bc2ea87811e3914e00e08147c934</td>\n",
       "      <td>Alleur</td>\n",
       "      <td>Europe/Brussels</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>201338</td>\n",
       "      <td>27b0bd32a2fb11e3a2f800e08147c934</td>\n",
       "      <td>Bremen</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>474346</td>\n",
       "      <td>45792d9aaf4411e3971a00e08147c934</td>\n",
       "      <td>Hengelo</td>\n",
       "      <td>Europe/Amsterdam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>241743</td>\n",
       "      <td>60e88ffeaf3e11e3971a00e08147c934</td>\n",
       "      <td>Shizuoka</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>148220</td>\n",
       "      <td>ee63c7e6291811e4ae5700e08147c934</td>\n",
       "      <td>Helsinki</td>\n",
       "      <td>Europe/Helsinki</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>631352</td>\n",
       "      <td>85342e725f6a11e486cd00e08147c934</td>\n",
       "      <td>Roman</td>\n",
       "      <td>Europe/Paris</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>631646</td>\n",
       "      <td>358555645f7311e486cd00e08147c934</td>\n",
       "      <td>Brno</td>\n",
       "      <td>Europe/Prague</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>483702</td>\n",
       "      <td>1ac50686606611e4b7ae00e08147c934</td>\n",
       "      <td>Southampton</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>632384</td>\n",
       "      <td>5cb438409c1711e4887c00e08147c934</td>\n",
       "      <td>Tarttila</td>\n",
       "      <td>Europe/Helsinki</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>658891</td>\n",
       "      <td>a63430ccb5c811e4a69300e08147c934</td>\n",
       "      <td>London</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>658893</td>\n",
       "      <td>f7ccdbaab5c811e4895500e08147c934</td>\n",
       "      <td>Philadelphia</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>658895</td>\n",
       "      <td>a2a0f6a6b5c911e49e2800e08147c934</td>\n",
       "      <td>Golden</td>\n",
       "      <td>America/Denver</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>658901</td>\n",
       "      <td>17c17a6eb5ca11e4817000e08147c934</td>\n",
       "      <td>Fremont</td>\n",
       "      <td>America/Los_Angeles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>658739</td>\n",
       "      <td>b161960cb5cc11e4b42200e08147c934</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>658903</td>\n",
       "      <td>b47cfb7c297811e5983500e08147c934</td>\n",
       "      <td>Ashburn</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>632386</td>\n",
       "      <td>d6c7ad5c297911e5b82400e08147c934</td>\n",
       "      <td>Bollnas</td>\n",
       "      <td>Europe/Stockholm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>660852</td>\n",
       "      <td>bd085c6a297c11e5a98a00e08147c934</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>Europe/Zurich</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>665660</td>\n",
       "      <td>582d67f6297f11e5891700e08147c934</td>\n",
       "      <td>Quezon City</td>\n",
       "      <td>Asia/Manila</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>660132</td>\n",
       "      <td>f377da562b1f11e588fa00e08147c934</td>\n",
       "      <td>Oslo</td>\n",
       "      <td>Europe/Oslo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>663072</td>\n",
       "      <td>e2b84a2c41b611e5957200e08147c934</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>America/Chicago</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>660130</td>\n",
       "      <td>209cb620516611e5a7c400e08147c934</td>\n",
       "      <td>Bergen</td>\n",
       "      <td>Europe/Oslo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>661028</td>\n",
       "      <td>1597073682de11e59b8700e08147c934</td>\n",
       "      <td>Harrisburg</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>901936</td>\n",
       "      <td>3ad3bcdc737511e6accc00e08147c934</td>\n",
       "      <td>Jessheim</td>\n",
       "      <td>Europe/Oslo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>940010</td>\n",
       "      <td>ee394284a03311e69d4e00e08147c934</td>\n",
       "      <td>Oslo</td>\n",
       "      <td>Europe/Oslo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>950208</td>\n",
       "      <td>1c6705f2a7fe11e6bc2b00e08147c934</td>\n",
       "      <td>Brussels</td>\n",
       "      <td>Europe/Brussels</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>950212</td>\n",
       "      <td>c4042aeca7fe11e6a78700e08147c934</td>\n",
       "      <td>Wicklow</td>\n",
       "      <td>Europe/Dublin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>950216</td>\n",
       "      <td>4c04575aa7ff11e698c100e08147c934</td>\n",
       "      <td>Hagan</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>950222</td>\n",
       "      <td>1a95a254a80011e6b5e300e08147c934</td>\n",
       "      <td>Domzale</td>\n",
       "      <td>Europe/Ljubljana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>950228</td>\n",
       "      <td>3cf9a07ea80111e698c100e08147c934</td>\n",
       "      <td>Nova Gorica</td>\n",
       "      <td>Europe/Ljubljana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>950230</td>\n",
       "      <td>62101974a80111e698c100e08147c934</td>\n",
       "      <td>Kent</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>950232</td>\n",
       "      <td>919dbdb8a80111e6accc00e08147c934</td>\n",
       "      <td>Sunnyvale</td>\n",
       "      <td>America/Los_Angeles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>950224</td>\n",
       "      <td>fcb2241ea83211e6bc2b00e08147c934</td>\n",
       "      <td>Ptuj</td>\n",
       "      <td>Europe/Ljubljana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>950218</td>\n",
       "      <td>3c43328ca9bc11e6bc2b00e08147c934</td>\n",
       "      <td>Costinesti</td>\n",
       "      <td>Europe/Bucharest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>950226</td>\n",
       "      <td>518484b2aa9711e69d4e00e08147c934</td>\n",
       "      <td>Ljubljana</td>\n",
       "      <td>Europe/Ljubljana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>950234</td>\n",
       "      <td>79700590aab111e6bc2b00e08147c934</td>\n",
       "      <td>Seattle</td>\n",
       "      <td>America/Los_Angeles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>950214</td>\n",
       "      <td>0821c5a6ab2c11e698c100e08147c934</td>\n",
       "      <td>Houten</td>\n",
       "      <td>Europe/Amsterdam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>950220</td>\n",
       "      <td>ae6fdc1eab3511e69d4e00e08147c934</td>\n",
       "      <td>Skofja Loka</td>\n",
       "      <td>Europe/Ljubljana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>950236</td>\n",
       "      <td>f91df828ab7a11e6bc2b00e08147c934</td>\n",
       "      <td>Michigan</td>\n",
       "      <td>America/Detroit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>950240</td>\n",
       "      <td>f482b888b6c611e68b9000e08147c934</td>\n",
       "      <td>Port Moody</td>\n",
       "      <td>America/Vancouver</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>950210</td>\n",
       "      <td>54183734b71f11e68b9000e08147c934</td>\n",
       "      <td>Munich</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>950204</td>\n",
       "      <td>058c8356b81211e6b5e300e08147c934</td>\n",
       "      <td>Doncaster</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>950202</td>\n",
       "      <td>fa260994bb8911e6b5e300e08147c934</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>Australia/Brisbane</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>950206</td>\n",
       "      <td>8f51598abd9a11e69d4e00e08147c934</td>\n",
       "      <td>Christchurch</td>\n",
       "      <td>Pacific/Auckland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>950238</td>\n",
       "      <td>383d4f02bfe111e693d000e08147c934</td>\n",
       "      <td>New York City</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>102 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    unit_id                             msmid       location  \\\n",
       "0     62712  28f784568afa11e2b54500e08147c934         Bremen   \n",
       "1    123256  bdf8bc9a8af611e2a74900e08147c934         Munich   \n",
       "2    148644  635cd9468afc11e2901a00e08147c934   Braunschweig   \n",
       "3    148650  915c1bf6b4a311e2a0d300e08147c934      Oldenburg   \n",
       "4    167808  28ea168ace7111e28ebf00e08147c934         London   \n",
       "5    148634  756a5566d51411e2ac9f00e08147c934         Torino   \n",
       "6    181536  689e8df6d8fd11e297d600e08147c934         Madrid   \n",
       "7    143666  93758a3eda6511e2814500e08147c934      Timisoara   \n",
       "8    148648  d8bd1eecdf1311e2814500e08147c934          Olten   \n",
       "9    129210  b9932adee24711e288cf00e08147c934        Ipswich   \n",
       "10   239416  9a890ef67f9511e3908700e08147c934      Stockholm   \n",
       "11   200864  8c3652e2810611e3a2f800e08147c934        Fukuoka   \n",
       "12    19602  1c122042829e11e3a2f800e08147c934         Madrid   \n",
       "13   200172  43429f748f4711e3b77500e08147c934        Niigata   \n",
       "14   241735  92d329488fd611e3b77500e08147c934       Gembloux   \n",
       "15   181532  05fc09a697e511e3913100e08147c934           CERN   \n",
       "16   241733  7931bc2ea87811e3914e00e08147c934         Alleur   \n",
       "17   201338  27b0bd32a2fb11e3a2f800e08147c934         Bremen   \n",
       "18   474346  45792d9aaf4411e3971a00e08147c934        Hengelo   \n",
       "19   241743  60e88ffeaf3e11e3971a00e08147c934       Shizuoka   \n",
       "20   148220  ee63c7e6291811e4ae5700e08147c934       Helsinki   \n",
       "21   631352  85342e725f6a11e486cd00e08147c934          Roman   \n",
       "22   631646  358555645f7311e486cd00e08147c934           Brno   \n",
       "23   483702  1ac50686606611e4b7ae00e08147c934    Southampton   \n",
       "24   632384  5cb438409c1711e4887c00e08147c934       Tarttila   \n",
       "25   658891  a63430ccb5c811e4a69300e08147c934         London   \n",
       "26   658893  f7ccdbaab5c811e4895500e08147c934   Philadelphia   \n",
       "27   658895  a2a0f6a6b5c911e49e2800e08147c934         Golden   \n",
       "28   658901  17c17a6eb5ca11e4817000e08147c934        Fremont   \n",
       "29   658739  b161960cb5cc11e4b42200e08147c934        Atlanta   \n",
       "..      ...                               ...            ...   \n",
       "72   658903  b47cfb7c297811e5983500e08147c934        Ashburn   \n",
       "73   632386  d6c7ad5c297911e5b82400e08147c934        Bollnas   \n",
       "74   660852  bd085c6a297c11e5a98a00e08147c934         Zurich   \n",
       "75   665660  582d67f6297f11e5891700e08147c934    Quezon City   \n",
       "76   660132  f377da562b1f11e588fa00e08147c934           Oslo   \n",
       "77   663072  e2b84a2c41b611e5957200e08147c934        Chicago   \n",
       "78   660130  209cb620516611e5a7c400e08147c934         Bergen   \n",
       "79   661028  1597073682de11e59b8700e08147c934     Harrisburg   \n",
       "80   901936  3ad3bcdc737511e6accc00e08147c934       Jessheim   \n",
       "81   940010  ee394284a03311e69d4e00e08147c934           Oslo   \n",
       "82   950208  1c6705f2a7fe11e6bc2b00e08147c934       Brussels   \n",
       "83   950212  c4042aeca7fe11e6a78700e08147c934        Wicklow   \n",
       "84   950216  4c04575aa7ff11e698c100e08147c934          Hagan   \n",
       "85   950222  1a95a254a80011e6b5e300e08147c934        Domzale   \n",
       "86   950228  3cf9a07ea80111e698c100e08147c934    Nova Gorica   \n",
       "87   950230  62101974a80111e698c100e08147c934           Kent   \n",
       "88   950232  919dbdb8a80111e6accc00e08147c934      Sunnyvale   \n",
       "89   950224  fcb2241ea83211e6bc2b00e08147c934           Ptuj   \n",
       "90   950218  3c43328ca9bc11e6bc2b00e08147c934     Costinesti   \n",
       "91   950226  518484b2aa9711e69d4e00e08147c934      Ljubljana   \n",
       "92   950234  79700590aab111e6bc2b00e08147c934        Seattle   \n",
       "93   950214  0821c5a6ab2c11e698c100e08147c934         Houten   \n",
       "94   950220  ae6fdc1eab3511e69d4e00e08147c934    Skofja Loka   \n",
       "95   950236  f91df828ab7a11e6bc2b00e08147c934       Michigan   \n",
       "96   950240  f482b888b6c611e68b9000e08147c934     Port Moody   \n",
       "97   950210  54183734b71f11e68b9000e08147c934         Munich   \n",
       "98   950204  058c8356b81211e6b5e300e08147c934      Doncaster   \n",
       "99   950202  fa260994bb8911e6b5e300e08147c934       Brisbane   \n",
       "100  950206  8f51598abd9a11e69d4e00e08147c934   Christchurch   \n",
       "101  950238  383d4f02bfe111e693d000e08147c934  New York City   \n",
       "\n",
       "                timezone  \n",
       "0          Europe/Berlin  \n",
       "1          Europe/Berlin  \n",
       "2          Europe/Berlin  \n",
       "3          Europe/Berlin  \n",
       "4          Europe/London  \n",
       "5            Europe/Rome  \n",
       "6          Europe/Madrid  \n",
       "7       Europe/Bucharest  \n",
       "8          Europe/Zurich  \n",
       "9          Europe/London  \n",
       "10      Europe/Stockholm  \n",
       "11            Asia/Tokyo  \n",
       "12         Europe/Madrid  \n",
       "13                  None  \n",
       "14       Europe/Brussels  \n",
       "15                        \n",
       "16       Europe/Brussels  \n",
       "17         Europe/Berlin  \n",
       "18      Europe/Amsterdam  \n",
       "19                  None  \n",
       "20       Europe/Helsinki  \n",
       "21          Europe/Paris  \n",
       "22         Europe/Prague  \n",
       "23         Europe/London  \n",
       "24       Europe/Helsinki  \n",
       "25         Europe/London  \n",
       "26      America/New_York  \n",
       "27        America/Denver  \n",
       "28   America/Los_Angeles  \n",
       "29                        \n",
       "..                   ...  \n",
       "72      America/New_York  \n",
       "73      Europe/Stockholm  \n",
       "74         Europe/Zurich  \n",
       "75           Asia/Manila  \n",
       "76           Europe/Oslo  \n",
       "77       America/Chicago  \n",
       "78           Europe/Oslo  \n",
       "79      America/New_York  \n",
       "80           Europe/Oslo  \n",
       "81           Europe/Oslo  \n",
       "82       Europe/Brussels  \n",
       "83         Europe/Dublin  \n",
       "84      America/New_York  \n",
       "85      Europe/Ljubljana  \n",
       "86      Europe/Ljubljana  \n",
       "87         Europe/London  \n",
       "88   America/Los_Angeles  \n",
       "89      Europe/Ljubljana  \n",
       "90      Europe/Bucharest  \n",
       "91      Europe/Ljubljana  \n",
       "92   America/Los_Angeles  \n",
       "93      Europe/Amsterdam  \n",
       "94      Europe/Ljubljana  \n",
       "95       America/Detroit  \n",
       "96     America/Vancouver  \n",
       "97         Europe/Berlin  \n",
       "98         Europe/London  \n",
       "99    Australia/Brisbane  \n",
       "100     Pacific/Auckland  \n",
       "101     America/New_York  \n",
       "\n",
       "[102 rows x 4 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "p"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "no_res = p[(p['timezone'] == '')]\n",
    "while not no_res.empty:\n",
    "    no_res['timezone'] = no_res['location'].apply(loc_to_tz)\n",
    "    p.update(no_res)\n",
    "    no_res = p[(p['timezone'] == '')]\n",
    "    time.sleep(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>unit_id</th>\n",
       "      <th>msmid</th>\n",
       "      <th>location</th>\n",
       "      <th>timezone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>62712</td>\n",
       "      <td>28f784568afa11e2b54500e08147c934</td>\n",
       "      <td>Bremen</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>123256</td>\n",
       "      <td>bdf8bc9a8af611e2a74900e08147c934</td>\n",
       "      <td>Munich</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>148644</td>\n",
       "      <td>635cd9468afc11e2901a00e08147c934</td>\n",
       "      <td>Braunschweig</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>148650</td>\n",
       "      <td>915c1bf6b4a311e2a0d300e08147c934</td>\n",
       "      <td>Oldenburg</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>167808</td>\n",
       "      <td>28ea168ace7111e28ebf00e08147c934</td>\n",
       "      <td>London</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>148634</td>\n",
       "      <td>756a5566d51411e2ac9f00e08147c934</td>\n",
       "      <td>Torino</td>\n",
       "      <td>Europe/Rome</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>181536</td>\n",
       "      <td>689e8df6d8fd11e297d600e08147c934</td>\n",
       "      <td>Madrid</td>\n",
       "      <td>Europe/Madrid</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>143666</td>\n",
       "      <td>93758a3eda6511e2814500e08147c934</td>\n",
       "      <td>Timisoara</td>\n",
       "      <td>Europe/Bucharest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>148648</td>\n",
       "      <td>d8bd1eecdf1311e2814500e08147c934</td>\n",
       "      <td>Olten</td>\n",
       "      <td>Europe/Zurich</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>129210</td>\n",
       "      <td>b9932adee24711e288cf00e08147c934</td>\n",
       "      <td>Ipswich</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>239416</td>\n",
       "      <td>9a890ef67f9511e3908700e08147c934</td>\n",
       "      <td>Stockholm</td>\n",
       "      <td>Europe/Stockholm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>200864</td>\n",
       "      <td>8c3652e2810611e3a2f800e08147c934</td>\n",
       "      <td>Fukuoka</td>\n",
       "      <td>Asia/Tokyo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>19602</td>\n",
       "      <td>1c122042829e11e3a2f800e08147c934</td>\n",
       "      <td>Madrid</td>\n",
       "      <td>Europe/Madrid</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>200172</td>\n",
       "      <td>43429f748f4711e3b77500e08147c934</td>\n",
       "      <td>Niigata</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>241735</td>\n",
       "      <td>92d329488fd611e3b77500e08147c934</td>\n",
       "      <td>Gembloux</td>\n",
       "      <td>Europe/Brussels</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>181532</td>\n",
       "      <td>05fc09a697e511e3913100e08147c934</td>\n",
       "      <td>CERN</td>\n",
       "      <td>Europe/Zurich</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>241733</td>\n",
       "      <td>7931bc2ea87811e3914e00e08147c934</td>\n",
       "      <td>Alleur</td>\n",
       "      <td>Europe/Brussels</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>201338</td>\n",
       "      <td>27b0bd32a2fb11e3a2f800e08147c934</td>\n",
       "      <td>Bremen</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>474346</td>\n",
       "      <td>45792d9aaf4411e3971a00e08147c934</td>\n",
       "      <td>Hengelo</td>\n",
       "      <td>Europe/Amsterdam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>241743</td>\n",
       "      <td>60e88ffeaf3e11e3971a00e08147c934</td>\n",
       "      <td>Shizuoka</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>148220</td>\n",
       "      <td>ee63c7e6291811e4ae5700e08147c934</td>\n",
       "      <td>Helsinki</td>\n",
       "      <td>Europe/Helsinki</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>631352</td>\n",
       "      <td>85342e725f6a11e486cd00e08147c934</td>\n",
       "      <td>Roman</td>\n",
       "      <td>Europe/Paris</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>631646</td>\n",
       "      <td>358555645f7311e486cd00e08147c934</td>\n",
       "      <td>Brno</td>\n",
       "      <td>Europe/Prague</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>483702</td>\n",
       "      <td>1ac50686606611e4b7ae00e08147c934</td>\n",
       "      <td>Southampton</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>632384</td>\n",
       "      <td>5cb438409c1711e4887c00e08147c934</td>\n",
       "      <td>Tarttila</td>\n",
       "      <td>Europe/Helsinki</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>658891</td>\n",
       "      <td>a63430ccb5c811e4a69300e08147c934</td>\n",
       "      <td>London</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>658893</td>\n",
       "      <td>f7ccdbaab5c811e4895500e08147c934</td>\n",
       "      <td>Philadelphia</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>658895</td>\n",
       "      <td>a2a0f6a6b5c911e49e2800e08147c934</td>\n",
       "      <td>Golden</td>\n",
       "      <td>America/Denver</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>658901</td>\n",
       "      <td>17c17a6eb5ca11e4817000e08147c934</td>\n",
       "      <td>Fremont</td>\n",
       "      <td>America/Los_Angeles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>658739</td>\n",
       "      <td>b161960cb5cc11e4b42200e08147c934</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>658903</td>\n",
       "      <td>b47cfb7c297811e5983500e08147c934</td>\n",
       "      <td>Ashburn</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>632386</td>\n",
       "      <td>d6c7ad5c297911e5b82400e08147c934</td>\n",
       "      <td>Bollnas</td>\n",
       "      <td>Europe/Stockholm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>660852</td>\n",
       "      <td>bd085c6a297c11e5a98a00e08147c934</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>Europe/Zurich</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>665660</td>\n",
       "      <td>582d67f6297f11e5891700e08147c934</td>\n",
       "      <td>Quezon City</td>\n",
       "      <td>Asia/Manila</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>660132</td>\n",
       "      <td>f377da562b1f11e588fa00e08147c934</td>\n",
       "      <td>Oslo</td>\n",
       "      <td>Europe/Oslo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>663072</td>\n",
       "      <td>e2b84a2c41b611e5957200e08147c934</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>America/Chicago</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>660130</td>\n",
       "      <td>209cb620516611e5a7c400e08147c934</td>\n",
       "      <td>Bergen</td>\n",
       "      <td>Europe/Oslo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>661028</td>\n",
       "      <td>1597073682de11e59b8700e08147c934</td>\n",
       "      <td>Harrisburg</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>901936</td>\n",
       "      <td>3ad3bcdc737511e6accc00e08147c934</td>\n",
       "      <td>Jessheim</td>\n",
       "      <td>Europe/Oslo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>940010</td>\n",
       "      <td>ee394284a03311e69d4e00e08147c934</td>\n",
       "      <td>Oslo</td>\n",
       "      <td>Europe/Oslo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>950208</td>\n",
       "      <td>1c6705f2a7fe11e6bc2b00e08147c934</td>\n",
       "      <td>Brussels</td>\n",
       "      <td>Europe/Brussels</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>950212</td>\n",
       "      <td>c4042aeca7fe11e6a78700e08147c934</td>\n",
       "      <td>Wicklow</td>\n",
       "      <td>Europe/Dublin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>950216</td>\n",
       "      <td>4c04575aa7ff11e698c100e08147c934</td>\n",
       "      <td>Hagan</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>950222</td>\n",
       "      <td>1a95a254a80011e6b5e300e08147c934</td>\n",
       "      <td>Domzale</td>\n",
       "      <td>Europe/Ljubljana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>950228</td>\n",
       "      <td>3cf9a07ea80111e698c100e08147c934</td>\n",
       "      <td>Nova Gorica</td>\n",
       "      <td>Europe/Ljubljana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>950230</td>\n",
       "      <td>62101974a80111e698c100e08147c934</td>\n",
       "      <td>Kent</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>950232</td>\n",
       "      <td>919dbdb8a80111e6accc00e08147c934</td>\n",
       "      <td>Sunnyvale</td>\n",
       "      <td>America/Los_Angeles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>950224</td>\n",
       "      <td>fcb2241ea83211e6bc2b00e08147c934</td>\n",
       "      <td>Ptuj</td>\n",
       "      <td>Europe/Ljubljana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>950218</td>\n",
       "      <td>3c43328ca9bc11e6bc2b00e08147c934</td>\n",
       "      <td>Costinesti</td>\n",
       "      <td>Europe/Bucharest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>950226</td>\n",
       "      <td>518484b2aa9711e69d4e00e08147c934</td>\n",
       "      <td>Ljubljana</td>\n",
       "      <td>Europe/Ljubljana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>950234</td>\n",
       "      <td>79700590aab111e6bc2b00e08147c934</td>\n",
       "      <td>Seattle</td>\n",
       "      <td>America/Los_Angeles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>950214</td>\n",
       "      <td>0821c5a6ab2c11e698c100e08147c934</td>\n",
       "      <td>Houten</td>\n",
       "      <td>Europe/Amsterdam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>950220</td>\n",
       "      <td>ae6fdc1eab3511e69d4e00e08147c934</td>\n",
       "      <td>Skofja Loka</td>\n",
       "      <td>Europe/Ljubljana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>950236</td>\n",
       "      <td>f91df828ab7a11e6bc2b00e08147c934</td>\n",
       "      <td>Michigan</td>\n",
       "      <td>America/Detroit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>950240</td>\n",
       "      <td>f482b888b6c611e68b9000e08147c934</td>\n",
       "      <td>Port Moody</td>\n",
       "      <td>America/Vancouver</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>950210</td>\n",
       "      <td>54183734b71f11e68b9000e08147c934</td>\n",
       "      <td>Munich</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>950204</td>\n",
       "      <td>058c8356b81211e6b5e300e08147c934</td>\n",
       "      <td>Doncaster</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>950202</td>\n",
       "      <td>fa260994bb8911e6b5e300e08147c934</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>Australia/Brisbane</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>950206</td>\n",
       "      <td>8f51598abd9a11e69d4e00e08147c934</td>\n",
       "      <td>Christchurch</td>\n",
       "      <td>Pacific/Auckland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>950238</td>\n",
       "      <td>383d4f02bfe111e693d000e08147c934</td>\n",
       "      <td>New York City</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>102 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    unit_id                             msmid       location  \\\n",
       "0     62712  28f784568afa11e2b54500e08147c934         Bremen   \n",
       "1    123256  bdf8bc9a8af611e2a74900e08147c934         Munich   \n",
       "2    148644  635cd9468afc11e2901a00e08147c934   Braunschweig   \n",
       "3    148650  915c1bf6b4a311e2a0d300e08147c934      Oldenburg   \n",
       "4    167808  28ea168ace7111e28ebf00e08147c934         London   \n",
       "5    148634  756a5566d51411e2ac9f00e08147c934         Torino   \n",
       "6    181536  689e8df6d8fd11e297d600e08147c934         Madrid   \n",
       "7    143666  93758a3eda6511e2814500e08147c934      Timisoara   \n",
       "8    148648  d8bd1eecdf1311e2814500e08147c934          Olten   \n",
       "9    129210  b9932adee24711e288cf00e08147c934        Ipswich   \n",
       "10   239416  9a890ef67f9511e3908700e08147c934      Stockholm   \n",
       "11   200864  8c3652e2810611e3a2f800e08147c934        Fukuoka   \n",
       "12    19602  1c122042829e11e3a2f800e08147c934         Madrid   \n",
       "13   200172  43429f748f4711e3b77500e08147c934        Niigata   \n",
       "14   241735  92d329488fd611e3b77500e08147c934       Gembloux   \n",
       "15   181532  05fc09a697e511e3913100e08147c934           CERN   \n",
       "16   241733  7931bc2ea87811e3914e00e08147c934         Alleur   \n",
       "17   201338  27b0bd32a2fb11e3a2f800e08147c934         Bremen   \n",
       "18   474346  45792d9aaf4411e3971a00e08147c934        Hengelo   \n",
       "19   241743  60e88ffeaf3e11e3971a00e08147c934       Shizuoka   \n",
       "20   148220  ee63c7e6291811e4ae5700e08147c934       Helsinki   \n",
       "21   631352  85342e725f6a11e486cd00e08147c934          Roman   \n",
       "22   631646  358555645f7311e486cd00e08147c934           Brno   \n",
       "23   483702  1ac50686606611e4b7ae00e08147c934    Southampton   \n",
       "24   632384  5cb438409c1711e4887c00e08147c934       Tarttila   \n",
       "25   658891  a63430ccb5c811e4a69300e08147c934         London   \n",
       "26   658893  f7ccdbaab5c811e4895500e08147c934   Philadelphia   \n",
       "27   658895  a2a0f6a6b5c911e49e2800e08147c934         Golden   \n",
       "28   658901  17c17a6eb5ca11e4817000e08147c934        Fremont   \n",
       "29   658739  b161960cb5cc11e4b42200e08147c934        Atlanta   \n",
       "..      ...                               ...            ...   \n",
       "72   658903  b47cfb7c297811e5983500e08147c934        Ashburn   \n",
       "73   632386  d6c7ad5c297911e5b82400e08147c934        Bollnas   \n",
       "74   660852  bd085c6a297c11e5a98a00e08147c934         Zurich   \n",
       "75   665660  582d67f6297f11e5891700e08147c934    Quezon City   \n",
       "76   660132  f377da562b1f11e588fa00e08147c934           Oslo   \n",
       "77   663072  e2b84a2c41b611e5957200e08147c934        Chicago   \n",
       "78   660130  209cb620516611e5a7c400e08147c934         Bergen   \n",
       "79   661028  1597073682de11e59b8700e08147c934     Harrisburg   \n",
       "80   901936  3ad3bcdc737511e6accc00e08147c934       Jessheim   \n",
       "81   940010  ee394284a03311e69d4e00e08147c934           Oslo   \n",
       "82   950208  1c6705f2a7fe11e6bc2b00e08147c934       Brussels   \n",
       "83   950212  c4042aeca7fe11e6a78700e08147c934        Wicklow   \n",
       "84   950216  4c04575aa7ff11e698c100e08147c934          Hagan   \n",
       "85   950222  1a95a254a80011e6b5e300e08147c934        Domzale   \n",
       "86   950228  3cf9a07ea80111e698c100e08147c934    Nova Gorica   \n",
       "87   950230  62101974a80111e698c100e08147c934           Kent   \n",
       "88   950232  919dbdb8a80111e6accc00e08147c934      Sunnyvale   \n",
       "89   950224  fcb2241ea83211e6bc2b00e08147c934           Ptuj   \n",
       "90   950218  3c43328ca9bc11e6bc2b00e08147c934     Costinesti   \n",
       "91   950226  518484b2aa9711e69d4e00e08147c934      Ljubljana   \n",
       "92   950234  79700590aab111e6bc2b00e08147c934        Seattle   \n",
       "93   950214  0821c5a6ab2c11e698c100e08147c934         Houten   \n",
       "94   950220  ae6fdc1eab3511e69d4e00e08147c934    Skofja Loka   \n",
       "95   950236  f91df828ab7a11e6bc2b00e08147c934       Michigan   \n",
       "96   950240  f482b888b6c611e68b9000e08147c934     Port Moody   \n",
       "97   950210  54183734b71f11e68b9000e08147c934         Munich   \n",
       "98   950204  058c8356b81211e6b5e300e08147c934      Doncaster   \n",
       "99   950202  fa260994bb8911e6b5e300e08147c934       Brisbane   \n",
       "100  950206  8f51598abd9a11e69d4e00e08147c934   Christchurch   \n",
       "101  950238  383d4f02bfe111e693d000e08147c934  New York City   \n",
       "\n",
       "                timezone  \n",
       "0          Europe/Berlin  \n",
       "1          Europe/Berlin  \n",
       "2          Europe/Berlin  \n",
       "3          Europe/Berlin  \n",
       "4          Europe/London  \n",
       "5            Europe/Rome  \n",
       "6          Europe/Madrid  \n",
       "7       Europe/Bucharest  \n",
       "8          Europe/Zurich  \n",
       "9          Europe/London  \n",
       "10      Europe/Stockholm  \n",
       "11            Asia/Tokyo  \n",
       "12         Europe/Madrid  \n",
       "13                  None  \n",
       "14       Europe/Brussels  \n",
       "15         Europe/Zurich  \n",
       "16       Europe/Brussels  \n",
       "17         Europe/Berlin  \n",
       "18      Europe/Amsterdam  \n",
       "19                  None  \n",
       "20       Europe/Helsinki  \n",
       "21          Europe/Paris  \n",
       "22         Europe/Prague  \n",
       "23         Europe/London  \n",
       "24       Europe/Helsinki  \n",
       "25         Europe/London  \n",
       "26      America/New_York  \n",
       "27        America/Denver  \n",
       "28   America/Los_Angeles  \n",
       "29      America/New_York  \n",
       "..                   ...  \n",
       "72      America/New_York  \n",
       "73      Europe/Stockholm  \n",
       "74         Europe/Zurich  \n",
       "75           Asia/Manila  \n",
       "76           Europe/Oslo  \n",
       "77       America/Chicago  \n",
       "78           Europe/Oslo  \n",
       "79      America/New_York  \n",
       "80           Europe/Oslo  \n",
       "81           Europe/Oslo  \n",
       "82       Europe/Brussels  \n",
       "83         Europe/Dublin  \n",
       "84      America/New_York  \n",
       "85      Europe/Ljubljana  \n",
       "86      Europe/Ljubljana  \n",
       "87         Europe/London  \n",
       "88   America/Los_Angeles  \n",
       "89      Europe/Ljubljana  \n",
       "90      Europe/Bucharest  \n",
       "91      Europe/Ljubljana  \n",
       "92   America/Los_Angeles  \n",
       "93      Europe/Amsterdam  \n",
       "94      Europe/Ljubljana  \n",
       "95       America/Detroit  \n",
       "96     America/Vancouver  \n",
       "97         Europe/Berlin  \n",
       "98         Europe/London  \n",
       "99    Australia/Brisbane  \n",
       "100     Pacific/Auckland  \n",
       "101     America/New_York  \n",
       "\n",
       "[102 rows x 4 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "p"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# ================================ "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>unit_id</th>\n",
       "      <th>msmid</th>\n",
       "      <th>location</th>\n",
       "      <th>timezone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>200172</td>\n",
       "      <td>43429f748f4711e3b77500e08147c934</td>\n",
       "      <td>Niigata</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>241743</td>\n",
       "      <td>60e88ffeaf3e11e3971a00e08147c934</td>\n",
       "      <td>Shizuoka</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   unit_id                             msmid  location timezone\n",
       "13  200172  43429f748f4711e3b77500e08147c934   Niigata     None\n",
       "19  241743  60e88ffeaf3e11e3971a00e08147c934  Shizuoka     None"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "p[p['timezone'].isnull()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "if not p[p['timezone'].isnull()].empty:\n",
    "    # lat, long\n",
    "    niigata = (37.90222, 139.02361)\n",
    "    shizuoka = (34.97695, 138.38306)\n",
    "\n",
    "    p.iloc[13]['timezone'] = tz.tzNameAt(niigata[0], niigata[1])\n",
    "    p.iloc[19]['timezone'] = tz.tzNameAt(shizuoka[0], shizuoka[1])\n",
    "\n",
    "    p[p['timezone'].isnull()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>unit_id</th>\n",
       "      <th>msmid</th>\n",
       "      <th>location</th>\n",
       "      <th>timezone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>62712</td>\n",
       "      <td>28f784568afa11e2b54500e08147c934</td>\n",
       "      <td>Bremen</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>123256</td>\n",
       "      <td>bdf8bc9a8af611e2a74900e08147c934</td>\n",
       "      <td>Munich</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>148644</td>\n",
       "      <td>635cd9468afc11e2901a00e08147c934</td>\n",
       "      <td>Braunschweig</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>148650</td>\n",
       "      <td>915c1bf6b4a311e2a0d300e08147c934</td>\n",
       "      <td>Oldenburg</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>167808</td>\n",
       "      <td>28ea168ace7111e28ebf00e08147c934</td>\n",
       "      <td>London</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>148634</td>\n",
       "      <td>756a5566d51411e2ac9f00e08147c934</td>\n",
       "      <td>Torino</td>\n",
       "      <td>Europe/Rome</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>181536</td>\n",
       "      <td>689e8df6d8fd11e297d600e08147c934</td>\n",
       "      <td>Madrid</td>\n",
       "      <td>Europe/Madrid</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>143666</td>\n",
       "      <td>93758a3eda6511e2814500e08147c934</td>\n",
       "      <td>Timisoara</td>\n",
       "      <td>Europe/Bucharest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>148648</td>\n",
       "      <td>d8bd1eecdf1311e2814500e08147c934</td>\n",
       "      <td>Olten</td>\n",
       "      <td>Europe/Zurich</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>129210</td>\n",
       "      <td>b9932adee24711e288cf00e08147c934</td>\n",
       "      <td>Ipswich</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>239416</td>\n",
       "      <td>9a890ef67f9511e3908700e08147c934</td>\n",
       "      <td>Stockholm</td>\n",
       "      <td>Europe/Stockholm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>200864</td>\n",
       "      <td>8c3652e2810611e3a2f800e08147c934</td>\n",
       "      <td>Fukuoka</td>\n",
       "      <td>Asia/Tokyo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>19602</td>\n",
       "      <td>1c122042829e11e3a2f800e08147c934</td>\n",
       "      <td>Madrid</td>\n",
       "      <td>Europe/Madrid</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>200172</td>\n",
       "      <td>43429f748f4711e3b77500e08147c934</td>\n",
       "      <td>Niigata</td>\n",
       "      <td>Asia/Tokyo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>241735</td>\n",
       "      <td>92d329488fd611e3b77500e08147c934</td>\n",
       "      <td>Gembloux</td>\n",
       "      <td>Europe/Brussels</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>181532</td>\n",
       "      <td>05fc09a697e511e3913100e08147c934</td>\n",
       "      <td>CERN</td>\n",
       "      <td>Europe/Zurich</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>241733</td>\n",
       "      <td>7931bc2ea87811e3914e00e08147c934</td>\n",
       "      <td>Alleur</td>\n",
       "      <td>Europe/Brussels</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>201338</td>\n",
       "      <td>27b0bd32a2fb11e3a2f800e08147c934</td>\n",
       "      <td>Bremen</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>474346</td>\n",
       "      <td>45792d9aaf4411e3971a00e08147c934</td>\n",
       "      <td>Hengelo</td>\n",
       "      <td>Europe/Amsterdam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>241743</td>\n",
       "      <td>60e88ffeaf3e11e3971a00e08147c934</td>\n",
       "      <td>Shizuoka</td>\n",
       "      <td>Asia/Tokyo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>148220</td>\n",
       "      <td>ee63c7e6291811e4ae5700e08147c934</td>\n",
       "      <td>Helsinki</td>\n",
       "      <td>Europe/Helsinki</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>631352</td>\n",
       "      <td>85342e725f6a11e486cd00e08147c934</td>\n",
       "      <td>Roman</td>\n",
       "      <td>Europe/Paris</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>631646</td>\n",
       "      <td>358555645f7311e486cd00e08147c934</td>\n",
       "      <td>Brno</td>\n",
       "      <td>Europe/Prague</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>483702</td>\n",
       "      <td>1ac50686606611e4b7ae00e08147c934</td>\n",
       "      <td>Southampton</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>632384</td>\n",
       "      <td>5cb438409c1711e4887c00e08147c934</td>\n",
       "      <td>Tarttila</td>\n",
       "      <td>Europe/Helsinki</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>658891</td>\n",
       "      <td>a63430ccb5c811e4a69300e08147c934</td>\n",
       "      <td>London</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>658893</td>\n",
       "      <td>f7ccdbaab5c811e4895500e08147c934</td>\n",
       "      <td>Philadelphia</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>658895</td>\n",
       "      <td>a2a0f6a6b5c911e49e2800e08147c934</td>\n",
       "      <td>Golden</td>\n",
       "      <td>America/Denver</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>658901</td>\n",
       "      <td>17c17a6eb5ca11e4817000e08147c934</td>\n",
       "      <td>Fremont</td>\n",
       "      <td>America/Los_Angeles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>658739</td>\n",
       "      <td>b161960cb5cc11e4b42200e08147c934</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>658903</td>\n",
       "      <td>b47cfb7c297811e5983500e08147c934</td>\n",
       "      <td>Ashburn</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>632386</td>\n",
       "      <td>d6c7ad5c297911e5b82400e08147c934</td>\n",
       "      <td>Bollnas</td>\n",
       "      <td>Europe/Stockholm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>660852</td>\n",
       "      <td>bd085c6a297c11e5a98a00e08147c934</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>Europe/Zurich</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>665660</td>\n",
       "      <td>582d67f6297f11e5891700e08147c934</td>\n",
       "      <td>Quezon City</td>\n",
       "      <td>Asia/Manila</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>660132</td>\n",
       "      <td>f377da562b1f11e588fa00e08147c934</td>\n",
       "      <td>Oslo</td>\n",
       "      <td>Europe/Oslo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>663072</td>\n",
       "      <td>e2b84a2c41b611e5957200e08147c934</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>America/Chicago</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>660130</td>\n",
       "      <td>209cb620516611e5a7c400e08147c934</td>\n",
       "      <td>Bergen</td>\n",
       "      <td>Europe/Oslo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>661028</td>\n",
       "      <td>1597073682de11e59b8700e08147c934</td>\n",
       "      <td>Harrisburg</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>901936</td>\n",
       "      <td>3ad3bcdc737511e6accc00e08147c934</td>\n",
       "      <td>Jessheim</td>\n",
       "      <td>Europe/Oslo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>940010</td>\n",
       "      <td>ee394284a03311e69d4e00e08147c934</td>\n",
       "      <td>Oslo</td>\n",
       "      <td>Europe/Oslo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>950208</td>\n",
       "      <td>1c6705f2a7fe11e6bc2b00e08147c934</td>\n",
       "      <td>Brussels</td>\n",
       "      <td>Europe/Brussels</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>950212</td>\n",
       "      <td>c4042aeca7fe11e6a78700e08147c934</td>\n",
       "      <td>Wicklow</td>\n",
       "      <td>Europe/Dublin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>950216</td>\n",
       "      <td>4c04575aa7ff11e698c100e08147c934</td>\n",
       "      <td>Hagan</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>950222</td>\n",
       "      <td>1a95a254a80011e6b5e300e08147c934</td>\n",
       "      <td>Domzale</td>\n",
       "      <td>Europe/Ljubljana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>950228</td>\n",
       "      <td>3cf9a07ea80111e698c100e08147c934</td>\n",
       "      <td>Nova Gorica</td>\n",
       "      <td>Europe/Ljubljana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>950230</td>\n",
       "      <td>62101974a80111e698c100e08147c934</td>\n",
       "      <td>Kent</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>950232</td>\n",
       "      <td>919dbdb8a80111e6accc00e08147c934</td>\n",
       "      <td>Sunnyvale</td>\n",
       "      <td>America/Los_Angeles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>950224</td>\n",
       "      <td>fcb2241ea83211e6bc2b00e08147c934</td>\n",
       "      <td>Ptuj</td>\n",
       "      <td>Europe/Ljubljana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>950218</td>\n",
       "      <td>3c43328ca9bc11e6bc2b00e08147c934</td>\n",
       "      <td>Costinesti</td>\n",
       "      <td>Europe/Bucharest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>950226</td>\n",
       "      <td>518484b2aa9711e69d4e00e08147c934</td>\n",
       "      <td>Ljubljana</td>\n",
       "      <td>Europe/Ljubljana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>950234</td>\n",
       "      <td>79700590aab111e6bc2b00e08147c934</td>\n",
       "      <td>Seattle</td>\n",
       "      <td>America/Los_Angeles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>950214</td>\n",
       "      <td>0821c5a6ab2c11e698c100e08147c934</td>\n",
       "      <td>Houten</td>\n",
       "      <td>Europe/Amsterdam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>950220</td>\n",
       "      <td>ae6fdc1eab3511e69d4e00e08147c934</td>\n",
       "      <td>Skofja Loka</td>\n",
       "      <td>Europe/Ljubljana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>950236</td>\n",
       "      <td>f91df828ab7a11e6bc2b00e08147c934</td>\n",
       "      <td>Michigan</td>\n",
       "      <td>America/Detroit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>950240</td>\n",
       "      <td>f482b888b6c611e68b9000e08147c934</td>\n",
       "      <td>Port Moody</td>\n",
       "      <td>America/Vancouver</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>950210</td>\n",
       "      <td>54183734b71f11e68b9000e08147c934</td>\n",
       "      <td>Munich</td>\n",
       "      <td>Europe/Berlin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>950204</td>\n",
       "      <td>058c8356b81211e6b5e300e08147c934</td>\n",
       "      <td>Doncaster</td>\n",
       "      <td>Europe/London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>950202</td>\n",
       "      <td>fa260994bb8911e6b5e300e08147c934</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>Australia/Brisbane</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>950206</td>\n",
       "      <td>8f51598abd9a11e69d4e00e08147c934</td>\n",
       "      <td>Christchurch</td>\n",
       "      <td>Pacific/Auckland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>950238</td>\n",
       "      <td>383d4f02bfe111e693d000e08147c934</td>\n",
       "      <td>New York City</td>\n",
       "      <td>America/New_York</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>102 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    unit_id                             msmid       location  \\\n",
       "0     62712  28f784568afa11e2b54500e08147c934         Bremen   \n",
       "1    123256  bdf8bc9a8af611e2a74900e08147c934         Munich   \n",
       "2    148644  635cd9468afc11e2901a00e08147c934   Braunschweig   \n",
       "3    148650  915c1bf6b4a311e2a0d300e08147c934      Oldenburg   \n",
       "4    167808  28ea168ace7111e28ebf00e08147c934         London   \n",
       "5    148634  756a5566d51411e2ac9f00e08147c934         Torino   \n",
       "6    181536  689e8df6d8fd11e297d600e08147c934         Madrid   \n",
       "7    143666  93758a3eda6511e2814500e08147c934      Timisoara   \n",
       "8    148648  d8bd1eecdf1311e2814500e08147c934          Olten   \n",
       "9    129210  b9932adee24711e288cf00e08147c934        Ipswich   \n",
       "10   239416  9a890ef67f9511e3908700e08147c934      Stockholm   \n",
       "11   200864  8c3652e2810611e3a2f800e08147c934        Fukuoka   \n",
       "12    19602  1c122042829e11e3a2f800e08147c934         Madrid   \n",
       "13   200172  43429f748f4711e3b77500e08147c934        Niigata   \n",
       "14   241735  92d329488fd611e3b77500e08147c934       Gembloux   \n",
       "15   181532  05fc09a697e511e3913100e08147c934           CERN   \n",
       "16   241733  7931bc2ea87811e3914e00e08147c934         Alleur   \n",
       "17   201338  27b0bd32a2fb11e3a2f800e08147c934         Bremen   \n",
       "18   474346  45792d9aaf4411e3971a00e08147c934        Hengelo   \n",
       "19   241743  60e88ffeaf3e11e3971a00e08147c934       Shizuoka   \n",
       "20   148220  ee63c7e6291811e4ae5700e08147c934       Helsinki   \n",
       "21   631352  85342e725f6a11e486cd00e08147c934          Roman   \n",
       "22   631646  358555645f7311e486cd00e08147c934           Brno   \n",
       "23   483702  1ac50686606611e4b7ae00e08147c934    Southampton   \n",
       "24   632384  5cb438409c1711e4887c00e08147c934       Tarttila   \n",
       "25   658891  a63430ccb5c811e4a69300e08147c934         London   \n",
       "26   658893  f7ccdbaab5c811e4895500e08147c934   Philadelphia   \n",
       "27   658895  a2a0f6a6b5c911e49e2800e08147c934         Golden   \n",
       "28   658901  17c17a6eb5ca11e4817000e08147c934        Fremont   \n",
       "29   658739  b161960cb5cc11e4b42200e08147c934        Atlanta   \n",
       "..      ...                               ...            ...   \n",
       "72   658903  b47cfb7c297811e5983500e08147c934        Ashburn   \n",
       "73   632386  d6c7ad5c297911e5b82400e08147c934        Bollnas   \n",
       "74   660852  bd085c6a297c11e5a98a00e08147c934         Zurich   \n",
       "75   665660  582d67f6297f11e5891700e08147c934    Quezon City   \n",
       "76   660132  f377da562b1f11e588fa00e08147c934           Oslo   \n",
       "77   663072  e2b84a2c41b611e5957200e08147c934        Chicago   \n",
       "78   660130  209cb620516611e5a7c400e08147c934         Bergen   \n",
       "79   661028  1597073682de11e59b8700e08147c934     Harrisburg   \n",
       "80   901936  3ad3bcdc737511e6accc00e08147c934       Jessheim   \n",
       "81   940010  ee394284a03311e69d4e00e08147c934           Oslo   \n",
       "82   950208  1c6705f2a7fe11e6bc2b00e08147c934       Brussels   \n",
       "83   950212  c4042aeca7fe11e6a78700e08147c934        Wicklow   \n",
       "84   950216  4c04575aa7ff11e698c100e08147c934          Hagan   \n",
       "85   950222  1a95a254a80011e6b5e300e08147c934        Domzale   \n",
       "86   950228  3cf9a07ea80111e698c100e08147c934    Nova Gorica   \n",
       "87   950230  62101974a80111e698c100e08147c934           Kent   \n",
       "88   950232  919dbdb8a80111e6accc00e08147c934      Sunnyvale   \n",
       "89   950224  fcb2241ea83211e6bc2b00e08147c934           Ptuj   \n",
       "90   950218  3c43328ca9bc11e6bc2b00e08147c934     Costinesti   \n",
       "91   950226  518484b2aa9711e69d4e00e08147c934      Ljubljana   \n",
       "92   950234  79700590aab111e6bc2b00e08147c934        Seattle   \n",
       "93   950214  0821c5a6ab2c11e698c100e08147c934         Houten   \n",
       "94   950220  ae6fdc1eab3511e69d4e00e08147c934    Skofja Loka   \n",
       "95   950236  f91df828ab7a11e6bc2b00e08147c934       Michigan   \n",
       "96   950240  f482b888b6c611e68b9000e08147c934     Port Moody   \n",
       "97   950210  54183734b71f11e68b9000e08147c934         Munich   \n",
       "98   950204  058c8356b81211e6b5e300e08147c934      Doncaster   \n",
       "99   950202  fa260994bb8911e6b5e300e08147c934       Brisbane   \n",
       "100  950206  8f51598abd9a11e69d4e00e08147c934   Christchurch   \n",
       "101  950238  383d4f02bfe111e693d000e08147c934  New York City   \n",
       "\n",
       "                timezone  \n",
       "0          Europe/Berlin  \n",
       "1          Europe/Berlin  \n",
       "2          Europe/Berlin  \n",
       "3          Europe/Berlin  \n",
       "4          Europe/London  \n",
       "5            Europe/Rome  \n",
       "6          Europe/Madrid  \n",
       "7       Europe/Bucharest  \n",
       "8          Europe/Zurich  \n",
       "9          Europe/London  \n",
       "10      Europe/Stockholm  \n",
       "11            Asia/Tokyo  \n",
       "12         Europe/Madrid  \n",
       "13            Asia/Tokyo  \n",
       "14       Europe/Brussels  \n",
       "15         Europe/Zurich  \n",
       "16       Europe/Brussels  \n",
       "17         Europe/Berlin  \n",
       "18      Europe/Amsterdam  \n",
       "19            Asia/Tokyo  \n",
       "20       Europe/Helsinki  \n",
       "21          Europe/Paris  \n",
       "22         Europe/Prague  \n",
       "23         Europe/London  \n",
       "24       Europe/Helsinki  \n",
       "25         Europe/London  \n",
       "26      America/New_York  \n",
       "27        America/Denver  \n",
       "28   America/Los_Angeles  \n",
       "29      America/New_York  \n",
       "..                   ...  \n",
       "72      America/New_York  \n",
       "73      Europe/Stockholm  \n",
       "74         Europe/Zurich  \n",
       "75           Asia/Manila  \n",
       "76           Europe/Oslo  \n",
       "77       America/Chicago  \n",
       "78           Europe/Oslo  \n",
       "79      America/New_York  \n",
       "80           Europe/Oslo  \n",
       "81           Europe/Oslo  \n",
       "82       Europe/Brussels  \n",
       "83         Europe/Dublin  \n",
       "84      America/New_York  \n",
       "85      Europe/Ljubljana  \n",
       "86      Europe/Ljubljana  \n",
       "87         Europe/London  \n",
       "88   America/Los_Angeles  \n",
       "89      Europe/Ljubljana  \n",
       "90      Europe/Bucharest  \n",
       "91      Europe/Ljubljana  \n",
       "92   America/Los_Angeles  \n",
       "93      Europe/Amsterdam  \n",
       "94      Europe/Ljubljana  \n",
       "95       America/Detroit  \n",
       "96     America/Vancouver  \n",
       "97         Europe/Berlin  \n",
       "98         Europe/London  \n",
       "99    Australia/Brisbane  \n",
       "100     Pacific/Auckland  \n",
       "101     America/New_York  \n",
       "\n",
       "[102 rows x 4 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "p"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "p.to_csv('probes-timezones.csv', sep=';', index=False, header=True)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}