AyoseLuca-Copy1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "df_dwells   = pd.read_csv('hack4good_dwells.csv',sep = ',',low_memory=False)\n",
    "df_journeys = pd.read_csv('hack4good_journeys.csv',sep = ',',low_memory=False)\n",
    "df_antenas  = pd.read_csv('hack4good_antenas.csv',sep = ',',low_memory=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date_dt</th>\n",
       "      <th>cod_dpto</th>\n",
       "      <th>cod_mpio</th>\n",
       "      <th>3g_traf_dl</th>\n",
       "      <th>3g_traf_ul</th>\n",
       "      <th>3g_completadas</th>\n",
       "      <th>3g_no_completadas</th>\n",
       "      <th>2g_traf_dl</th>\n",
       "      <th>2g_traf_ul</th>\n",
       "      <th>2g_completadas</th>\n",
       "      <th>2g_no_completadas</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>151</td>\n",
       "      <td>97064.59</td>\n",
       "      <td>29742.52</td>\n",
       "      <td>46244.2</td>\n",
       "      <td>142.91</td>\n",
       "      <td>4087.43</td>\n",
       "      <td>1894.83</td>\n",
       "      <td>54002.78</td>\n",
       "      <td>760.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>159</td>\n",
       "      <td>94733.57</td>\n",
       "      <td>27905.78</td>\n",
       "      <td>45393.2</td>\n",
       "      <td>140.91</td>\n",
       "      <td>4054.11</td>\n",
       "      <td>1875.10</td>\n",
       "      <td>53740.78</td>\n",
       "      <td>775.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>164</td>\n",
       "      <td>99831.15</td>\n",
       "      <td>29797.12</td>\n",
       "      <td>47074.2</td>\n",
       "      <td>141.91</td>\n",
       "      <td>5001.48</td>\n",
       "      <td>2506.91</td>\n",
       "      <td>62167.78</td>\n",
       "      <td>960.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>168</td>\n",
       "      <td>105423.94</td>\n",
       "      <td>31321.79</td>\n",
       "      <td>48437.2</td>\n",
       "      <td>141.91</td>\n",
       "      <td>4567.01</td>\n",
       "      <td>2235.54</td>\n",
       "      <td>63718.78</td>\n",
       "      <td>1061.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>181</td>\n",
       "      <td>124949.04</td>\n",
       "      <td>37388.72</td>\n",
       "      <td>51702.2</td>\n",
       "      <td>144.91</td>\n",
       "      <td>8198.19</td>\n",
       "      <td>4561.57</td>\n",
       "      <td>99530.78</td>\n",
       "      <td>1653.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>195</td>\n",
       "      <td>94856.47</td>\n",
       "      <td>28506.45</td>\n",
       "      <td>46335.2</td>\n",
       "      <td>146.91</td>\n",
       "      <td>5153.91</td>\n",
       "      <td>2489.21</td>\n",
       "      <td>86624.78</td>\n",
       "      <td>1506.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>198</td>\n",
       "      <td>113556.43</td>\n",
       "      <td>32971.95</td>\n",
       "      <td>51635.2</td>\n",
       "      <td>149.91</td>\n",
       "      <td>4183.39</td>\n",
       "      <td>1975.84</td>\n",
       "      <td>66288.78</td>\n",
       "      <td>965.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>205</td>\n",
       "      <td>172020.52</td>\n",
       "      <td>50355.48</td>\n",
       "      <td>66383.2</td>\n",
       "      <td>147.91</td>\n",
       "      <td>4732.49</td>\n",
       "      <td>2391.03</td>\n",
       "      <td>80197.78</td>\n",
       "      <td>1125.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>206</td>\n",
       "      <td>126537.23</td>\n",
       "      <td>38042.33</td>\n",
       "      <td>59257.2</td>\n",
       "      <td>144.91</td>\n",
       "      <td>4727.70</td>\n",
       "      <td>2467.83</td>\n",
       "      <td>74445.78</td>\n",
       "      <td>1022.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>210</td>\n",
       "      <td>99415.88</td>\n",
       "      <td>28802.64</td>\n",
       "      <td>45492.2</td>\n",
       "      <td>143.91</td>\n",
       "      <td>4405.19</td>\n",
       "      <td>2182.88</td>\n",
       "      <td>57264.78</td>\n",
       "      <td>1105.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>215</td>\n",
       "      <td>109218.53</td>\n",
       "      <td>31766.64</td>\n",
       "      <td>49678.2</td>\n",
       "      <td>143.91</td>\n",
       "      <td>4278.78</td>\n",
       "      <td>2032.32</td>\n",
       "      <td>61301.78</td>\n",
       "      <td>848.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>222</td>\n",
       "      <td>104924.59</td>\n",
       "      <td>32863.12</td>\n",
       "      <td>50042.2</td>\n",
       "      <td>142.91</td>\n",
       "      <td>4169.65</td>\n",
       "      <td>1993.79</td>\n",
       "      <td>59894.78</td>\n",
       "      <td>884.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>223</td>\n",
       "      <td>96711.31</td>\n",
       "      <td>29112.97</td>\n",
       "      <td>46568.2</td>\n",
       "      <td>141.91</td>\n",
       "      <td>5191.48</td>\n",
       "      <td>2696.63</td>\n",
       "      <td>67746.78</td>\n",
       "      <td>999.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>227</td>\n",
       "      <td>96770.36</td>\n",
       "      <td>30208.69</td>\n",
       "      <td>46104.2</td>\n",
       "      <td>141.91</td>\n",
       "      <td>4066.80</td>\n",
       "      <td>1885.07</td>\n",
       "      <td>55373.78</td>\n",
       "      <td>781.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>239</td>\n",
       "      <td>114177.72</td>\n",
       "      <td>32164.84</td>\n",
       "      <td>53051.2</td>\n",
       "      <td>147.91</td>\n",
       "      <td>4293.18</td>\n",
       "      <td>2079.69</td>\n",
       "      <td>61584.78</td>\n",
       "      <td>890.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>245</td>\n",
       "      <td>109767.94</td>\n",
       "      <td>31836.35</td>\n",
       "      <td>47616.2</td>\n",
       "      <td>156.91</td>\n",
       "      <td>4556.97</td>\n",
       "      <td>2327.34</td>\n",
       "      <td>68423.78</td>\n",
       "      <td>1253.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>247</td>\n",
       "      <td>98653.32</td>\n",
       "      <td>28757.47</td>\n",
       "      <td>45624.2</td>\n",
       "      <td>142.91</td>\n",
       "      <td>4388.09</td>\n",
       "      <td>2150.52</td>\n",
       "      <td>59116.78</td>\n",
       "      <td>918.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>254</td>\n",
       "      <td>92913.84</td>\n",
       "      <td>28047.03</td>\n",
       "      <td>46371.2</td>\n",
       "      <td>141.91</td>\n",
       "      <td>4376.20</td>\n",
       "      <td>2310.24</td>\n",
       "      <td>61178.78</td>\n",
       "      <td>935.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>255</td>\n",
       "      <td>122946.36</td>\n",
       "      <td>40844.73</td>\n",
       "      <td>52082.2</td>\n",
       "      <td>165.91</td>\n",
       "      <td>7154.02</td>\n",
       "      <td>2958.23</td>\n",
       "      <td>73470.78</td>\n",
       "      <td>1368.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>257</td>\n",
       "      <td>96588.28</td>\n",
       "      <td>29149.97</td>\n",
       "      <td>45767.2</td>\n",
       "      <td>141.91</td>\n",
       "      <td>4504.11</td>\n",
       "      <td>2242.80</td>\n",
       "      <td>65335.78</td>\n",
       "      <td>1184.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>259</td>\n",
       "      <td>107422.99</td>\n",
       "      <td>31255.84</td>\n",
       "      <td>48546.2</td>\n",
       "      <td>140.91</td>\n",
       "      <td>5285.98</td>\n",
       "      <td>2689.34</td>\n",
       "      <td>75583.78</td>\n",
       "      <td>1146.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>263</td>\n",
       "      <td>91066.47</td>\n",
       "      <td>27482.79</td>\n",
       "      <td>44025.2</td>\n",
       "      <td>142.91</td>\n",
       "      <td>5673.36</td>\n",
       "      <td>2725.56</td>\n",
       "      <td>60538.78</td>\n",
       "      <td>855.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>265</td>\n",
       "      <td>93404.99</td>\n",
       "      <td>27790.09</td>\n",
       "      <td>44738.2</td>\n",
       "      <td>139.91</td>\n",
       "      <td>4196.27</td>\n",
       "      <td>1988.69</td>\n",
       "      <td>56845.78</td>\n",
       "      <td>850.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>278</td>\n",
       "      <td>91985.86</td>\n",
       "      <td>27443.39</td>\n",
       "      <td>44135.2</td>\n",
       "      <td>142.91</td>\n",
       "      <td>4033.60</td>\n",
       "      <td>1862.97</td>\n",
       "      <td>51435.78</td>\n",
       "      <td>733.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>282</td>\n",
       "      <td>91667.38</td>\n",
       "      <td>27548.70</td>\n",
       "      <td>44643.2</td>\n",
       "      <td>141.91</td>\n",
       "      <td>4047.15</td>\n",
       "      <td>1872.85</td>\n",
       "      <td>52438.78</td>\n",
       "      <td>748.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>291</td>\n",
       "      <td>93986.40</td>\n",
       "      <td>27793.83</td>\n",
       "      <td>44946.2</td>\n",
       "      <td>141.91</td>\n",
       "      <td>4075.77</td>\n",
       "      <td>1895.50</td>\n",
       "      <td>53037.78</td>\n",
       "      <td>789.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>293</td>\n",
       "      <td>95488.98</td>\n",
       "      <td>28248.43</td>\n",
       "      <td>45545.2</td>\n",
       "      <td>142.91</td>\n",
       "      <td>4093.59</td>\n",
       "      <td>1900.31</td>\n",
       "      <td>55039.78</td>\n",
       "      <td>786.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>298</td>\n",
       "      <td>146186.35</td>\n",
       "      <td>37286.42</td>\n",
       "      <td>52333.2</td>\n",
       "      <td>147.91</td>\n",
       "      <td>5850.60</td>\n",
       "      <td>3036.76</td>\n",
       "      <td>76208.78</td>\n",
       "      <td>1135.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>303</td>\n",
       "      <td>91853.61</td>\n",
       "      <td>27555.39</td>\n",
       "      <td>44563.2</td>\n",
       "      <td>142.91</td>\n",
       "      <td>4073.47</td>\n",
       "      <td>1919.78</td>\n",
       "      <td>52404.78</td>\n",
       "      <td>734.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5</td>\n",
       "      <td>304</td>\n",
       "      <td>97316.98</td>\n",
       "      <td>28666.19</td>\n",
       "      <td>46956.2</td>\n",
       "      <td>143.91</td>\n",
       "      <td>4972.26</td>\n",
       "      <td>2700.13</td>\n",
       "      <td>78049.78</td>\n",
       "      <td>1749.86</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>75249</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>85</td>\n",
       "      <td>439</td>\n",
       "      <td>115913.24</td>\n",
       "      <td>31618.59</td>\n",
       "      <td>48878.2</td>\n",
       "      <td>198.91</td>\n",
       "      <td>4506.58</td>\n",
       "      <td>1975.92</td>\n",
       "      <td>55172.78</td>\n",
       "      <td>782.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75250</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>85</td>\n",
       "      <td>453</td>\n",
       "      <td>94657.20</td>\n",
       "      <td>28003.74</td>\n",
       "      <td>44316.2</td>\n",
       "      <td>148.91</td>\n",
       "      <td>4152.48</td>\n",
       "      <td>1904.70</td>\n",
       "      <td>52195.78</td>\n",
       "      <td>745.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75251</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>85</td>\n",
       "      <td>493</td>\n",
       "      <td>99013.46</td>\n",
       "      <td>28346.89</td>\n",
       "      <td>44608.2</td>\n",
       "      <td>242.91</td>\n",
       "      <td>4215.23</td>\n",
       "      <td>1940.87</td>\n",
       "      <td>52335.78</td>\n",
       "      <td>753.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75252</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>85</td>\n",
       "      <td>555</td>\n",
       "      <td>365279.46</td>\n",
       "      <td>90563.96</td>\n",
       "      <td>142595.2</td>\n",
       "      <td>462.91</td>\n",
       "      <td>16537.67</td>\n",
       "      <td>7202.90</td>\n",
       "      <td>124286.78</td>\n",
       "      <td>1627.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75253</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>85</td>\n",
       "      <td>557</td>\n",
       "      <td>103825.85</td>\n",
       "      <td>30292.20</td>\n",
       "      <td>45915.2</td>\n",
       "      <td>146.91</td>\n",
       "      <td>4706.93</td>\n",
       "      <td>2174.95</td>\n",
       "      <td>53533.78</td>\n",
       "      <td>759.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75254</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>85</td>\n",
       "      <td>598</td>\n",
       "      <td>197889.12</td>\n",
       "      <td>60979.80</td>\n",
       "      <td>65362.2</td>\n",
       "      <td>183.91</td>\n",
       "      <td>11820.91</td>\n",
       "      <td>5024.88</td>\n",
       "      <td>72352.78</td>\n",
       "      <td>1048.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75255</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>85</td>\n",
       "      <td>637</td>\n",
       "      <td>117106.24</td>\n",
       "      <td>33540.87</td>\n",
       "      <td>45861.2</td>\n",
       "      <td>188.91</td>\n",
       "      <td>4538.77</td>\n",
       "      <td>2122.97</td>\n",
       "      <td>56003.78</td>\n",
       "      <td>804.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75256</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>85</td>\n",
       "      <td>645</td>\n",
       "      <td>166614.21</td>\n",
       "      <td>42260.73</td>\n",
       "      <td>55593.2</td>\n",
       "      <td>150.91</td>\n",
       "      <td>5135.96</td>\n",
       "      <td>2398.96</td>\n",
       "      <td>57066.78</td>\n",
       "      <td>797.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75257</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>85</td>\n",
       "      <td>669</td>\n",
       "      <td>143271.49</td>\n",
       "      <td>37085.39</td>\n",
       "      <td>51466.2</td>\n",
       "      <td>164.91</td>\n",
       "      <td>5837.90</td>\n",
       "      <td>2630.98</td>\n",
       "      <td>57475.78</td>\n",
       "      <td>835.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75258</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>85</td>\n",
       "      <td>682</td>\n",
       "      <td>141729.00</td>\n",
       "      <td>38192.76</td>\n",
       "      <td>51397.2</td>\n",
       "      <td>155.91</td>\n",
       "      <td>5871.75</td>\n",
       "      <td>2581.30</td>\n",
       "      <td>59635.78</td>\n",
       "      <td>847.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75259</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>85</td>\n",
       "      <td>750</td>\n",
       "      <td>150967.09</td>\n",
       "      <td>43073.84</td>\n",
       "      <td>53119.2</td>\n",
       "      <td>158.91</td>\n",
       "      <td>5297.77</td>\n",
       "      <td>2296.79</td>\n",
       "      <td>59900.78</td>\n",
       "      <td>836.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75260</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>86</td>\n",
       "      <td>1031</td>\n",
       "      <td>179772.53</td>\n",
       "      <td>51072.27</td>\n",
       "      <td>75921.2</td>\n",
       "      <td>192.91</td>\n",
       "      <td>6438.43</td>\n",
       "      <td>3313.81</td>\n",
       "      <td>83917.78</td>\n",
       "      <td>1257.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75261</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>86</td>\n",
       "      <td>1043</td>\n",
       "      <td>103646.08</td>\n",
       "      <td>30884.29</td>\n",
       "      <td>48097.2</td>\n",
       "      <td>141.91</td>\n",
       "      <td>4263.79</td>\n",
       "      <td>2019.21</td>\n",
       "      <td>53549.78</td>\n",
       "      <td>794.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75262</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>86</td>\n",
       "      <td>1047</td>\n",
       "      <td>98133.38</td>\n",
       "      <td>29709.21</td>\n",
       "      <td>47045.2</td>\n",
       "      <td>144.91</td>\n",
       "      <td>4503.99</td>\n",
       "      <td>2068.51</td>\n",
       "      <td>66041.78</td>\n",
       "      <td>899.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75263</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>86</td>\n",
       "      <td>1057</td>\n",
       "      <td>140012.02</td>\n",
       "      <td>38933.65</td>\n",
       "      <td>51767.2</td>\n",
       "      <td>149.91</td>\n",
       "      <td>5452.50</td>\n",
       "      <td>2224.64</td>\n",
       "      <td>59208.78</td>\n",
       "      <td>852.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75264</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>86</td>\n",
       "      <td>1060</td>\n",
       "      <td>99500.04</td>\n",
       "      <td>28393.11</td>\n",
       "      <td>44176.2</td>\n",
       "      <td>140.91</td>\n",
       "      <td>5745.22</td>\n",
       "      <td>2382.08</td>\n",
       "      <td>57214.78</td>\n",
       "      <td>918.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75265</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>86</td>\n",
       "      <td>1064</td>\n",
       "      <td>125961.13</td>\n",
       "      <td>35458.81</td>\n",
       "      <td>54247.2</td>\n",
       "      <td>150.91</td>\n",
       "      <td>6068.37</td>\n",
       "      <td>2905.48</td>\n",
       "      <td>62433.78</td>\n",
       "      <td>906.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75266</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>86</td>\n",
       "      <td>1073</td>\n",
       "      <td>102931.64</td>\n",
       "      <td>33074.88</td>\n",
       "      <td>46862.2</td>\n",
       "      <td>146.91</td>\n",
       "      <td>4794.88</td>\n",
       "      <td>2165.60</td>\n",
       "      <td>58390.78</td>\n",
       "      <td>930.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75268</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>86</td>\n",
       "      <td>1075</td>\n",
       "      <td>160292.00</td>\n",
       "      <td>46100.54</td>\n",
       "      <td>61670.2</td>\n",
       "      <td>167.91</td>\n",
       "      <td>7339.78</td>\n",
       "      <td>3291.74</td>\n",
       "      <td>70362.78</td>\n",
       "      <td>1067.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75269</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>86</td>\n",
       "      <td>1076</td>\n",
       "      <td>105028.34</td>\n",
       "      <td>29652.35</td>\n",
       "      <td>48096.2</td>\n",
       "      <td>145.91</td>\n",
       "      <td>8461.24</td>\n",
       "      <td>3432.64</td>\n",
       "      <td>62392.78</td>\n",
       "      <td>979.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75270</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>86</td>\n",
       "      <td>1077</td>\n",
       "      <td>95895.55</td>\n",
       "      <td>28065.44</td>\n",
       "      <td>44187.2</td>\n",
       "      <td>140.91</td>\n",
       "      <td>6530.14</td>\n",
       "      <td>2722.81</td>\n",
       "      <td>58783.78</td>\n",
       "      <td>945.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75271</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>88</td>\n",
       "      <td>3</td>\n",
       "      <td>228046.95</td>\n",
       "      <td>84211.99</td>\n",
       "      <td>64043.2</td>\n",
       "      <td>149.91</td>\n",
       "      <td>8266.06</td>\n",
       "      <td>3306.63</td>\n",
       "      <td>60214.78</td>\n",
       "      <td>826.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75272</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>88</td>\n",
       "      <td>4</td>\n",
       "      <td>1038928.54</td>\n",
       "      <td>381246.24</td>\n",
       "      <td>332996.2</td>\n",
       "      <td>1273.91</td>\n",
       "      <td>34123.63</td>\n",
       "      <td>11221.54</td>\n",
       "      <td>209160.78</td>\n",
       "      <td>1717.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75273</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>91</td>\n",
       "      <td>1085</td>\n",
       "      <td>222156.74</td>\n",
       "      <td>61946.77</td>\n",
       "      <td>56873.2</td>\n",
       "      <td>456.91</td>\n",
       "      <td>6893.92</td>\n",
       "      <td>4022.07</td>\n",
       "      <td>74462.78</td>\n",
       "      <td>1002.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75274</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>94</td>\n",
       "      <td>850</td>\n",
       "      <td>151545.58</td>\n",
       "      <td>38163.80</td>\n",
       "      <td>55985.2</td>\n",
       "      <td>486.91</td>\n",
       "      <td>6826.38</td>\n",
       "      <td>3344.93</td>\n",
       "      <td>63115.78</td>\n",
       "      <td>733.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75275</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>95</td>\n",
       "      <td>924</td>\n",
       "      <td>255870.05</td>\n",
       "      <td>77271.49</td>\n",
       "      <td>72215.2</td>\n",
       "      <td>233.91</td>\n",
       "      <td>17242.45</td>\n",
       "      <td>7129.16</td>\n",
       "      <td>111396.78</td>\n",
       "      <td>1651.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75276</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>95</td>\n",
       "      <td>965</td>\n",
       "      <td>132579.50</td>\n",
       "      <td>39233.38</td>\n",
       "      <td>51522.2</td>\n",
       "      <td>151.91</td>\n",
       "      <td>7243.27</td>\n",
       "      <td>3469.40</td>\n",
       "      <td>97998.78</td>\n",
       "      <td>1648.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75277</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>95</td>\n",
       "      <td>987</td>\n",
       "      <td>125390.76</td>\n",
       "      <td>36567.37</td>\n",
       "      <td>48738.2</td>\n",
       "      <td>146.91</td>\n",
       "      <td>8074.98</td>\n",
       "      <td>3594.88</td>\n",
       "      <td>77537.78</td>\n",
       "      <td>1200.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75278</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>97</td>\n",
       "      <td>1010</td>\n",
       "      <td>160266.14</td>\n",
       "      <td>41574.70</td>\n",
       "      <td>52669.2</td>\n",
       "      <td>216.91</td>\n",
       "      <td>5455.34</td>\n",
       "      <td>2481.65</td>\n",
       "      <td>57191.78</td>\n",
       "      <td>722.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75279</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>99</td>\n",
       "      <td>396</td>\n",
       "      <td>174290.46</td>\n",
       "      <td>45704.45</td>\n",
       "      <td>62372.2</td>\n",
       "      <td>1062.91</td>\n",
       "      <td>7490.86</td>\n",
       "      <td>4138.31</td>\n",
       "      <td>75884.78</td>\n",
       "      <td>879.86</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>69618 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          date_dt  cod_dpto  cod_mpio  3g_traf_dl  3g_traf_ul  3g_completadas  \\\n",
       "0      2015-02-01         5       151    97064.59    29742.52         46244.2   \n",
       "1      2015-02-01         5       159    94733.57    27905.78         45393.2   \n",
       "2      2015-02-01         5       164    99831.15    29797.12         47074.2   \n",
       "3      2015-02-01         5       168   105423.94    31321.79         48437.2   \n",
       "4      2015-02-01         5       181   124949.04    37388.72         51702.2   \n",
       "5      2015-02-01         5       195    94856.47    28506.45         46335.2   \n",
       "6      2015-02-01         5       198   113556.43    32971.95         51635.2   \n",
       "7      2015-02-01         5       205   172020.52    50355.48         66383.2   \n",
       "8      2015-02-01         5       206   126537.23    38042.33         59257.2   \n",
       "9      2015-02-01         5       210    99415.88    28802.64         45492.2   \n",
       "10     2015-02-01         5       215   109218.53    31766.64         49678.2   \n",
       "11     2015-02-01         5       222   104924.59    32863.12         50042.2   \n",
       "12     2015-02-01         5       223    96711.31    29112.97         46568.2   \n",
       "13     2015-02-01         5       227    96770.36    30208.69         46104.2   \n",
       "14     2015-02-01         5       239   114177.72    32164.84         53051.2   \n",
       "15     2015-02-01         5       245   109767.94    31836.35         47616.2   \n",
       "17     2015-02-01         5       247    98653.32    28757.47         45624.2   \n",
       "18     2015-02-01         5       254    92913.84    28047.03         46371.2   \n",
       "19     2015-02-01         5       255   122946.36    40844.73         52082.2   \n",
       "20     2015-02-01         5       257    96588.28    29149.97         45767.2   \n",
       "21     2015-02-01         5       259   107422.99    31255.84         48546.2   \n",
       "22     2015-02-01         5       263    91066.47    27482.79         44025.2   \n",
       "23     2015-02-01         5       265    93404.99    27790.09         44738.2   \n",
       "24     2015-02-01         5       278    91985.86    27443.39         44135.2   \n",
       "25     2015-02-01         5       282    91667.38    27548.70         44643.2   \n",
       "27     2015-02-01         5       291    93986.40    27793.83         44946.2   \n",
       "28     2015-02-01         5       293    95488.98    28248.43         45545.2   \n",
       "29     2015-02-01         5       298   146186.35    37286.42         52333.2   \n",
       "30     2015-02-01         5       303    91853.61    27555.39         44563.2   \n",
       "31     2015-02-01         5       304    97316.98    28666.19         46956.2   \n",
       "...           ...       ...       ...         ...         ...             ...   \n",
       "75249  2015-04-30        85       439   115913.24    31618.59         48878.2   \n",
       "75250  2015-04-30        85       453    94657.20    28003.74         44316.2   \n",
       "75251  2015-04-30        85       493    99013.46    28346.89         44608.2   \n",
       "75252  2015-04-30        85       555   365279.46    90563.96        142595.2   \n",
       "75253  2015-04-30        85       557   103825.85    30292.20         45915.2   \n",
       "75254  2015-04-30        85       598   197889.12    60979.80         65362.2   \n",
       "75255  2015-04-30        85       637   117106.24    33540.87         45861.2   \n",
       "75256  2015-04-30        85       645   166614.21    42260.73         55593.2   \n",
       "75257  2015-04-30        85       669   143271.49    37085.39         51466.2   \n",
       "75258  2015-04-30        85       682   141729.00    38192.76         51397.2   \n",
       "75259  2015-04-30        85       750   150967.09    43073.84         53119.2   \n",
       "75260  2015-04-30        86      1031   179772.53    51072.27         75921.2   \n",
       "75261  2015-04-30        86      1043   103646.08    30884.29         48097.2   \n",
       "75262  2015-04-30        86      1047    98133.38    29709.21         47045.2   \n",
       "75263  2015-04-30        86      1057   140012.02    38933.65         51767.2   \n",
       "75264  2015-04-30        86      1060    99500.04    28393.11         44176.2   \n",
       "75265  2015-04-30        86      1064   125961.13    35458.81         54247.2   \n",
       "75266  2015-04-30        86      1073   102931.64    33074.88         46862.2   \n",
       "75268  2015-04-30        86      1075   160292.00    46100.54         61670.2   \n",
       "75269  2015-04-30        86      1076   105028.34    29652.35         48096.2   \n",
       "75270  2015-04-30        86      1077    95895.55    28065.44         44187.2   \n",
       "75271  2015-04-30        88         3   228046.95    84211.99         64043.2   \n",
       "75272  2015-04-30        88         4  1038928.54   381246.24        332996.2   \n",
       "75273  2015-04-30        91      1085   222156.74    61946.77         56873.2   \n",
       "75274  2015-04-30        94       850   151545.58    38163.80         55985.2   \n",
       "75275  2015-04-30        95       924   255870.05    77271.49         72215.2   \n",
       "75276  2015-04-30        95       965   132579.50    39233.38         51522.2   \n",
       "75277  2015-04-30        95       987   125390.76    36567.37         48738.2   \n",
       "75278  2015-04-30        97      1010   160266.14    41574.70         52669.2   \n",
       "75279  2015-04-30        99       396   174290.46    45704.45         62372.2   \n",
       "\n",
       "       3g_no_completadas  2g_traf_dl  2g_traf_ul  2g_completadas  \\\n",
       "0                 142.91     4087.43     1894.83        54002.78   \n",
       "1                 140.91     4054.11     1875.10        53740.78   \n",
       "2                 141.91     5001.48     2506.91        62167.78   \n",
       "3                 141.91     4567.01     2235.54        63718.78   \n",
       "4                 144.91     8198.19     4561.57        99530.78   \n",
       "5                 146.91     5153.91     2489.21        86624.78   \n",
       "6                 149.91     4183.39     1975.84        66288.78   \n",
       "7                 147.91     4732.49     2391.03        80197.78   \n",
       "8                 144.91     4727.70     2467.83        74445.78   \n",
       "9                 143.91     4405.19     2182.88        57264.78   \n",
       "10                143.91     4278.78     2032.32        61301.78   \n",
       "11                142.91     4169.65     1993.79        59894.78   \n",
       "12                141.91     5191.48     2696.63        67746.78   \n",
       "13                141.91     4066.80     1885.07        55373.78   \n",
       "14                147.91     4293.18     2079.69        61584.78   \n",
       "15                156.91     4556.97     2327.34        68423.78   \n",
       "17                142.91     4388.09     2150.52        59116.78   \n",
       "18                141.91     4376.20     2310.24        61178.78   \n",
       "19                165.91     7154.02     2958.23        73470.78   \n",
       "20                141.91     4504.11     2242.80        65335.78   \n",
       "21                140.91     5285.98     2689.34        75583.78   \n",
       "22                142.91     5673.36     2725.56        60538.78   \n",
       "23                139.91     4196.27     1988.69        56845.78   \n",
       "24                142.91     4033.60     1862.97        51435.78   \n",
       "25                141.91     4047.15     1872.85        52438.78   \n",
       "27                141.91     4075.77     1895.50        53037.78   \n",
       "28                142.91     4093.59     1900.31        55039.78   \n",
       "29                147.91     5850.60     3036.76        76208.78   \n",
       "30                142.91     4073.47     1919.78        52404.78   \n",
       "31                143.91     4972.26     2700.13        78049.78   \n",
       "...                  ...         ...         ...             ...   \n",
       "75249             198.91     4506.58     1975.92        55172.78   \n",
       "75250             148.91     4152.48     1904.70        52195.78   \n",
       "75251             242.91     4215.23     1940.87        52335.78   \n",
       "75252             462.91    16537.67     7202.90       124286.78   \n",
       "75253             146.91     4706.93     2174.95        53533.78   \n",
       "75254             183.91    11820.91     5024.88        72352.78   \n",
       "75255             188.91     4538.77     2122.97        56003.78   \n",
       "75256             150.91     5135.96     2398.96        57066.78   \n",
       "75257             164.91     5837.90     2630.98        57475.78   \n",
       "75258             155.91     5871.75     2581.30        59635.78   \n",
       "75259             158.91     5297.77     2296.79        59900.78   \n",
       "75260             192.91     6438.43     3313.81        83917.78   \n",
       "75261             141.91     4263.79     2019.21        53549.78   \n",
       "75262             144.91     4503.99     2068.51        66041.78   \n",
       "75263             149.91     5452.50     2224.64        59208.78   \n",
       "75264             140.91     5745.22     2382.08        57214.78   \n",
       "75265             150.91     6068.37     2905.48        62433.78   \n",
       "75266             146.91     4794.88     2165.60        58390.78   \n",
       "75268             167.91     7339.78     3291.74        70362.78   \n",
       "75269             145.91     8461.24     3432.64        62392.78   \n",
       "75270             140.91     6530.14     2722.81        58783.78   \n",
       "75271             149.91     8266.06     3306.63        60214.78   \n",
       "75272            1273.91    34123.63    11221.54       209160.78   \n",
       "75273             456.91     6893.92     4022.07        74462.78   \n",
       "75274             486.91     6826.38     3344.93        63115.78   \n",
       "75275             233.91    17242.45     7129.16       111396.78   \n",
       "75276             151.91     7243.27     3469.40        97998.78   \n",
       "75277             146.91     8074.98     3594.88        77537.78   \n",
       "75278             216.91     5455.34     2481.65        57191.78   \n",
       "75279            1062.91     7490.86     4138.31        75884.78   \n",
       "\n",
       "       2g_no_completadas  \n",
       "0                 760.86  \n",
       "1                 775.86  \n",
       "2                 960.86  \n",
       "3                1061.86  \n",
       "4                1653.86  \n",
       "5                1506.86  \n",
       "6                 965.86  \n",
       "7                1125.86  \n",
       "8                1022.86  \n",
       "9                1105.86  \n",
       "10                848.86  \n",
       "11                884.86  \n",
       "12                999.86  \n",
       "13                781.86  \n",
       "14                890.86  \n",
       "15               1253.86  \n",
       "17                918.86  \n",
       "18                935.86  \n",
       "19               1368.86  \n",
       "20               1184.86  \n",
       "21               1146.86  \n",
       "22                855.86  \n",
       "23                850.86  \n",
       "24                733.86  \n",
       "25                748.86  \n",
       "27                789.86  \n",
       "28                786.86  \n",
       "29               1135.86  \n",
       "30                734.86  \n",
       "31               1749.86  \n",
       "...                  ...  \n",
       "75249             782.86  \n",
       "75250             745.86  \n",
       "75251             753.86  \n",
       "75252            1627.86  \n",
       "75253             759.86  \n",
       "75254            1048.86  \n",
       "75255             804.86  \n",
       "75256             797.86  \n",
       "75257             835.86  \n",
       "75258             847.86  \n",
       "75259             836.86  \n",
       "75260            1257.86  \n",
       "75261             794.86  \n",
       "75262             899.86  \n",
       "75263             852.86  \n",
       "75264             918.86  \n",
       "75265             906.86  \n",
       "75266             930.86  \n",
       "75268            1067.86  \n",
       "75269             979.86  \n",
       "75270             945.86  \n",
       "75271             826.86  \n",
       "75272            1717.86  \n",
       "75273            1002.86  \n",
       "75274             733.86  \n",
       "75275            1651.86  \n",
       "75276            1648.86  \n",
       "75277            1200.86  \n",
       "75278             722.86  \n",
       "75279             879.86  \n",
       "\n",
       "[69618 rows x 11 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_antenas.dropna(axis=0,how='any',inplace=True)\n",
    "df_dwells.dropna(axis=0,how='any',inplace=True)\n",
    "df_journeys.dropna(axis=0,how='any',inplace=True)\n",
    "\n",
    "df_dwells = df_dwells[['cod_mpio','dwells','people']]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date_dt</th>\n",
       "      <th>cod_dpto</th>\n",
       "      <th>cod_mpio</th>\n",
       "      <th>3g_traf_dl</th>\n",
       "      <th>3g_traf_ul</th>\n",
       "      <th>3g_completadas</th>\n",
       "      <th>3g_no_completadas</th>\n",
       "      <th>2g_traf_dl</th>\n",
       "      <th>2g_traf_ul</th>\n",
       "      <th>2g_completadas</th>\n",
       "      <th>2g_no_completadas</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>13.0</td>\n",
       "      <td>167.0</td>\n",
       "      <td>96302</td>\n",
       "      <td>28594.9</td>\n",
       "      <td>46263.8</td>\n",
       "      <td>142.528</td>\n",
       "      <td>4105.25</td>\n",
       "      <td>1909.36</td>\n",
       "      <td>54400.2</td>\n",
       "      <td>765.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>15.0</td>\n",
       "      <td>279.0</td>\n",
       "      <td>94132.5</td>\n",
       "      <td>28111.4</td>\n",
       "      <td>45557.3</td>\n",
       "      <td>142.618</td>\n",
       "      <td>4072.67</td>\n",
       "      <td>1898.44</td>\n",
       "      <td>54189.7</td>\n",
       "      <td>783.826</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>15.0</td>\n",
       "      <td>370.0</td>\n",
       "      <td>107697</td>\n",
       "      <td>31894.1</td>\n",
       "      <td>48360.9</td>\n",
       "      <td>142.573</td>\n",
       "      <td>5044.22</td>\n",
       "      <td>2543.55</td>\n",
       "      <td>62298.7</td>\n",
       "      <td>990.984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>15.0</td>\n",
       "      <td>426.0</td>\n",
       "      <td>103768</td>\n",
       "      <td>30961.3</td>\n",
       "      <td>48850.8</td>\n",
       "      <td>143.045</td>\n",
       "      <td>4534.37</td>\n",
       "      <td>2180.38</td>\n",
       "      <td>62521.5</td>\n",
       "      <td>1024.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>15.0</td>\n",
       "      <td>490.0</td>\n",
       "      <td>128998</td>\n",
       "      <td>37061.5</td>\n",
       "      <td>56308</td>\n",
       "      <td>147.427</td>\n",
       "      <td>7710.89</td>\n",
       "      <td>4313.09</td>\n",
       "      <td>101312</td>\n",
       "      <td>1720.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>15.0</td>\n",
       "      <td>523.0</td>\n",
       "      <td>97729.5</td>\n",
       "      <td>29552.4</td>\n",
       "      <td>46484.7</td>\n",
       "      <td>146.607</td>\n",
       "      <td>5285.73</td>\n",
       "      <td>2733.45</td>\n",
       "      <td>88063.1</td>\n",
       "      <td>1656.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>15.0</td>\n",
       "      <td>533.0</td>\n",
       "      <td>114356</td>\n",
       "      <td>34022.2</td>\n",
       "      <td>53058.7</td>\n",
       "      <td>148.741</td>\n",
       "      <td>4220.75</td>\n",
       "      <td>2026.13</td>\n",
       "      <td>67326.9</td>\n",
       "      <td>1042.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>15.0</td>\n",
       "      <td>550.0</td>\n",
       "      <td>174792</td>\n",
       "      <td>47491.7</td>\n",
       "      <td>80644.7</td>\n",
       "      <td>160.416</td>\n",
       "      <td>4844.73</td>\n",
       "      <td>2469.21</td>\n",
       "      <td>88973.4</td>\n",
       "      <td>1313.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>15.0</td>\n",
       "      <td>558.0</td>\n",
       "      <td>143586</td>\n",
       "      <td>42940.2</td>\n",
       "      <td>66757.5</td>\n",
       "      <td>151.191</td>\n",
       "      <td>4713.82</td>\n",
       "      <td>2373.19</td>\n",
       "      <td>79516.1</td>\n",
       "      <td>1048.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>15.0</td>\n",
       "      <td>584.0</td>\n",
       "      <td>97577.5</td>\n",
       "      <td>28770.7</td>\n",
       "      <td>45454.3</td>\n",
       "      <td>142.73</td>\n",
       "      <td>4494.73</td>\n",
       "      <td>2209.11</td>\n",
       "      <td>57889.6</td>\n",
       "      <td>859.826</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>15.0</td>\n",
       "      <td>636.0</td>\n",
       "      <td>112317</td>\n",
       "      <td>33749.4</td>\n",
       "      <td>51533.1</td>\n",
       "      <td>144.854</td>\n",
       "      <td>4465.04</td>\n",
       "      <td>2166.99</td>\n",
       "      <td>63494.4</td>\n",
       "      <td>960.759</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>15.0</td>\n",
       "      <td>705.0</td>\n",
       "      <td>106108</td>\n",
       "      <td>30962.3</td>\n",
       "      <td>51199.1</td>\n",
       "      <td>143.359</td>\n",
       "      <td>4223.89</td>\n",
       "      <td>2022.47</td>\n",
       "      <td>60647</td>\n",
       "      <td>894.343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>15.0</td>\n",
       "      <td>710.0</td>\n",
       "      <td>96380.3</td>\n",
       "      <td>28831.3</td>\n",
       "      <td>46651.7</td>\n",
       "      <td>142.876</td>\n",
       "      <td>5051.87</td>\n",
       "      <td>2636.24</td>\n",
       "      <td>66561.3</td>\n",
       "      <td>1000.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>17.0</td>\n",
       "      <td>560.0</td>\n",
       "      <td>95406.1</td>\n",
       "      <td>28970.9</td>\n",
       "      <td>46708.9</td>\n",
       "      <td>144</td>\n",
       "      <td>4068.49</td>\n",
       "      <td>1886.62</td>\n",
       "      <td>56125.6</td>\n",
       "      <td>795.961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>17.0</td>\n",
       "      <td>638.0</td>\n",
       "      <td>115770</td>\n",
       "      <td>33839.3</td>\n",
       "      <td>55005.7</td>\n",
       "      <td>148.314</td>\n",
       "      <td>4327.72</td>\n",
       "      <td>2094.3</td>\n",
       "      <td>61617.9</td>\n",
       "      <td>885.085</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>17.0</td>\n",
       "      <td>674.0</td>\n",
       "      <td>104419</td>\n",
       "      <td>32064.5</td>\n",
       "      <td>47105.9</td>\n",
       "      <td>155.82</td>\n",
       "      <td>4639.61</td>\n",
       "      <td>2324.1</td>\n",
       "      <td>66174.9</td>\n",
       "      <td>1220.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1112.0</td>\n",
       "      <td>99166.1</td>\n",
       "      <td>28860.1</td>\n",
       "      <td>45628.1</td>\n",
       "      <td>142.629</td>\n",
       "      <td>4535.13</td>\n",
       "      <td>2263.47</td>\n",
       "      <td>62126.4</td>\n",
       "      <td>1032.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>94784.6</td>\n",
       "      <td>28304.1</td>\n",
       "      <td>46514.9</td>\n",
       "      <td>141.977</td>\n",
       "      <td>4396.24</td>\n",
       "      <td>2116.97</td>\n",
       "      <td>60209.6</td>\n",
       "      <td>947.984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1013.0</td>\n",
       "      <td>130162</td>\n",
       "      <td>38611.7</td>\n",
       "      <td>54631.4</td>\n",
       "      <td>172.674</td>\n",
       "      <td>7700.96</td>\n",
       "      <td>3261.78</td>\n",
       "      <td>75400.8</td>\n",
       "      <td>1410.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1030.0</td>\n",
       "      <td>94333.8</td>\n",
       "      <td>28562.3</td>\n",
       "      <td>45843</td>\n",
       "      <td>143.977</td>\n",
       "      <td>4594.56</td>\n",
       "      <td>2310.03</td>\n",
       "      <td>64859.7</td>\n",
       "      <td>1145.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1035.0</td>\n",
       "      <td>108551</td>\n",
       "      <td>32060</td>\n",
       "      <td>51165.4</td>\n",
       "      <td>143.775</td>\n",
       "      <td>5219.95</td>\n",
       "      <td>2646.23</td>\n",
       "      <td>75607.8</td>\n",
       "      <td>1120.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>19.0</td>\n",
       "      <td>897.0</td>\n",
       "      <td>92243.4</td>\n",
       "      <td>27555.5</td>\n",
       "      <td>44050.5</td>\n",
       "      <td>141.708</td>\n",
       "      <td>5927.1</td>\n",
       "      <td>3093.77</td>\n",
       "      <td>62434.2</td>\n",
       "      <td>882.512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>19.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>96339.4</td>\n",
       "      <td>28011.3</td>\n",
       "      <td>45213.1</td>\n",
       "      <td>142.607</td>\n",
       "      <td>4273.42</td>\n",
       "      <td>2034.41</td>\n",
       "      <td>56937.3</td>\n",
       "      <td>882.107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>19.0</td>\n",
       "      <td>932.0</td>\n",
       "      <td>92210.3</td>\n",
       "      <td>27641.9</td>\n",
       "      <td>44239</td>\n",
       "      <td>142.225</td>\n",
       "      <td>4037.59</td>\n",
       "      <td>1867.9</td>\n",
       "      <td>51404.1</td>\n",
       "      <td>738.321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>19.0</td>\n",
       "      <td>952.0</td>\n",
       "      <td>93226.1</td>\n",
       "      <td>27908.4</td>\n",
       "      <td>44957.4</td>\n",
       "      <td>142.18</td>\n",
       "      <td>4055.56</td>\n",
       "      <td>1882.87</td>\n",
       "      <td>52625.8</td>\n",
       "      <td>751.815</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>19.0</td>\n",
       "      <td>984.0</td>\n",
       "      <td>94939.4</td>\n",
       "      <td>28083.6</td>\n",
       "      <td>45139.8</td>\n",
       "      <td>142.168</td>\n",
       "      <td>4093.33</td>\n",
       "      <td>1918.52</td>\n",
       "      <td>53012.2</td>\n",
       "      <td>779.309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>19.0</td>\n",
       "      <td>988.0</td>\n",
       "      <td>94795</td>\n",
       "      <td>28139.2</td>\n",
       "      <td>45833.7</td>\n",
       "      <td>142.281</td>\n",
       "      <td>4110.91</td>\n",
       "      <td>1916.42</td>\n",
       "      <td>55039.3</td>\n",
       "      <td>788.545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>20.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>136969</td>\n",
       "      <td>38509.4</td>\n",
       "      <td>54188</td>\n",
       "      <td>144.843</td>\n",
       "      <td>6011.54</td>\n",
       "      <td>3123.72</td>\n",
       "      <td>77636.5</td>\n",
       "      <td>1177.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>303</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>20.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>92048.5</td>\n",
       "      <td>27577.9</td>\n",
       "      <td>44749.2</td>\n",
       "      <td>141.989</td>\n",
       "      <td>4054.72</td>\n",
       "      <td>1889.4</td>\n",
       "      <td>52327.6</td>\n",
       "      <td>741.613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>20.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>98926.7</td>\n",
       "      <td>29334.7</td>\n",
       "      <td>47515.4</td>\n",
       "      <td>145.135</td>\n",
       "      <td>5132.58</td>\n",
       "      <td>2708.9</td>\n",
       "      <td>76739</td>\n",
       "      <td>1190.97</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>555</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>52.0</td>\n",
       "      <td>1002.0</td>\n",
       "      <td>353267</td>\n",
       "      <td>91449.3</td>\n",
       "      <td>123489</td>\n",
       "      <td>415.359</td>\n",
       "      <td>16106</td>\n",
       "      <td>6975.06</td>\n",
       "      <td>116946</td>\n",
       "      <td>1599.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>557</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>52.0</td>\n",
       "      <td>1005.0</td>\n",
       "      <td>109175</td>\n",
       "      <td>31259.9</td>\n",
       "      <td>45747.8</td>\n",
       "      <td>146.618</td>\n",
       "      <td>4576.92</td>\n",
       "      <td>2040.6</td>\n",
       "      <td>53292.8</td>\n",
       "      <td>762.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>598</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>54.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>196893</td>\n",
       "      <td>55465.8</td>\n",
       "      <td>62878.2</td>\n",
       "      <td>185.539</td>\n",
       "      <td>11737.6</td>\n",
       "      <td>5046.58</td>\n",
       "      <td>70512.4</td>\n",
       "      <td>1114.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>637</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>66.0</td>\n",
       "      <td>707.0</td>\n",
       "      <td>114029</td>\n",
       "      <td>32203.9</td>\n",
       "      <td>45999.4</td>\n",
       "      <td>183.314</td>\n",
       "      <td>4554.7</td>\n",
       "      <td>2146.49</td>\n",
       "      <td>55451.4</td>\n",
       "      <td>821.163</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>645</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>68.0</td>\n",
       "      <td>248.0</td>\n",
       "      <td>161125</td>\n",
       "      <td>45137.5</td>\n",
       "      <td>54177.5</td>\n",
       "      <td>149.775</td>\n",
       "      <td>5044.63</td>\n",
       "      <td>2333.79</td>\n",
       "      <td>56624.7</td>\n",
       "      <td>791.017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>669</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>68.0</td>\n",
       "      <td>333.0</td>\n",
       "      <td>140428</td>\n",
       "      <td>41007.1</td>\n",
       "      <td>50720.7</td>\n",
       "      <td>149.168</td>\n",
       "      <td>5704.61</td>\n",
       "      <td>2580.31</td>\n",
       "      <td>57318.7</td>\n",
       "      <td>864.759</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>682</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>68.0</td>\n",
       "      <td>386.0</td>\n",
       "      <td>132741</td>\n",
       "      <td>38293.9</td>\n",
       "      <td>50007.6</td>\n",
       "      <td>148.202</td>\n",
       "      <td>6045.98</td>\n",
       "      <td>2616.04</td>\n",
       "      <td>58693.2</td>\n",
       "      <td>862.905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>750</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>73.0</td>\n",
       "      <td>851.0</td>\n",
       "      <td>146201</td>\n",
       "      <td>40414.7</td>\n",
       "      <td>52390.2</td>\n",
       "      <td>151.697</td>\n",
       "      <td>5235.28</td>\n",
       "      <td>2261.38</td>\n",
       "      <td>59552.9</td>\n",
       "      <td>828.321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1031</th>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>15.0</td>\n",
       "      <td>505.0</td>\n",
       "      <td>175599</td>\n",
       "      <td>54264.3</td>\n",
       "      <td>70761.1</td>\n",
       "      <td>181.876</td>\n",
       "      <td>6334.68</td>\n",
       "      <td>3266.83</td>\n",
       "      <td>80937.6</td>\n",
       "      <td>1192.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043</th>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>15.0</td>\n",
       "      <td>535.0</td>\n",
       "      <td>103707</td>\n",
       "      <td>32535</td>\n",
       "      <td>47991.3</td>\n",
       "      <td>143.506</td>\n",
       "      <td>4425.03</td>\n",
       "      <td>2115.59</td>\n",
       "      <td>54092.2</td>\n",
       "      <td>797.972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1047</th>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>15.0</td>\n",
       "      <td>542.0</td>\n",
       "      <td>98837.5</td>\n",
       "      <td>29760</td>\n",
       "      <td>46574.5</td>\n",
       "      <td>145.517</td>\n",
       "      <td>4454.53</td>\n",
       "      <td>2099.16</td>\n",
       "      <td>66639.1</td>\n",
       "      <td>949.321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1057</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>153876</td>\n",
       "      <td>43206.1</td>\n",
       "      <td>50889.6</td>\n",
       "      <td>148.977</td>\n",
       "      <td>5048.8</td>\n",
       "      <td>2200.95</td>\n",
       "      <td>58902.9</td>\n",
       "      <td>846.714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1060</th>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>15.0</td>\n",
       "      <td>639.0</td>\n",
       "      <td>100583</td>\n",
       "      <td>29050.2</td>\n",
       "      <td>44514.2</td>\n",
       "      <td>142.506</td>\n",
       "      <td>5197.5</td>\n",
       "      <td>2256.25</td>\n",
       "      <td>56189.3</td>\n",
       "      <td>888.062</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1064</th>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>15.0</td>\n",
       "      <td>686.0</td>\n",
       "      <td>139326</td>\n",
       "      <td>37455.1</td>\n",
       "      <td>55242</td>\n",
       "      <td>161.18</td>\n",
       "      <td>5363.42</td>\n",
       "      <td>2320.1</td>\n",
       "      <td>61630.6</td>\n",
       "      <td>908.208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1073</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>102055</td>\n",
       "      <td>30802.1</td>\n",
       "      <td>46327.5</td>\n",
       "      <td>145.236</td>\n",
       "      <td>4994.37</td>\n",
       "      <td>2200.55</td>\n",
       "      <td>58983.8</td>\n",
       "      <td>918.264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1075</th>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>17.0</td>\n",
       "      <td>574.0</td>\n",
       "      <td>160251</td>\n",
       "      <td>48925.8</td>\n",
       "      <td>61255.4</td>\n",
       "      <td>163.573</td>\n",
       "      <td>6205.97</td>\n",
       "      <td>2818.6</td>\n",
       "      <td>67243.9</td>\n",
       "      <td>1079.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1076</th>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>17.0</td>\n",
       "      <td>580.0</td>\n",
       "      <td>109486</td>\n",
       "      <td>34215.7</td>\n",
       "      <td>47821.4</td>\n",
       "      <td>147.281</td>\n",
       "      <td>7250.14</td>\n",
       "      <td>2945.63</td>\n",
       "      <td>60221.6</td>\n",
       "      <td>945.377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1077</th>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>17.0</td>\n",
       "      <td>596.0</td>\n",
       "      <td>96364.2</td>\n",
       "      <td>28185.2</td>\n",
       "      <td>44259.7</td>\n",
       "      <td>142.506</td>\n",
       "      <td>6288.14</td>\n",
       "      <td>2696.99</td>\n",
       "      <td>58235</td>\n",
       "      <td>946.871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>249313</td>\n",
       "      <td>79622.1</td>\n",
       "      <td>60351.1</td>\n",
       "      <td>153.753</td>\n",
       "      <td>8260.33</td>\n",
       "      <td>3341.66</td>\n",
       "      <td>59861.1</td>\n",
       "      <td>792.332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>5.0</td>\n",
       "      <td>181.0</td>\n",
       "      <td>989993</td>\n",
       "      <td>365462</td>\n",
       "      <td>290824</td>\n",
       "      <td>1455.21</td>\n",
       "      <td>30385.4</td>\n",
       "      <td>10772.5</td>\n",
       "      <td>199451</td>\n",
       "      <td>1576.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1085</th>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>17.0</td>\n",
       "      <td>652.0</td>\n",
       "      <td>205129</td>\n",
       "      <td>56207</td>\n",
       "      <td>54252.5</td>\n",
       "      <td>1011.26</td>\n",
       "      <td>7159.1</td>\n",
       "      <td>4109.53</td>\n",
       "      <td>70415.8</td>\n",
       "      <td>779.456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>850</th>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>5.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>146186</td>\n",
       "      <td>39107</td>\n",
       "      <td>54125.4</td>\n",
       "      <td>880.461</td>\n",
       "      <td>6590.31</td>\n",
       "      <td>3135.99</td>\n",
       "      <td>60570.7</td>\n",
       "      <td>725.748</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>924</th>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>5.0</td>\n",
       "      <td>445.0</td>\n",
       "      <td>270307</td>\n",
       "      <td>84576.1</td>\n",
       "      <td>67307.7</td>\n",
       "      <td>198.168</td>\n",
       "      <td>16754.7</td>\n",
       "      <td>6816.83</td>\n",
       "      <td>103823</td>\n",
       "      <td>1696.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>965</th>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>11.0</td>\n",
       "      <td>726.0</td>\n",
       "      <td>130496</td>\n",
       "      <td>38433</td>\n",
       "      <td>50918.1</td>\n",
       "      <td>148</td>\n",
       "      <td>7862.42</td>\n",
       "      <td>3709.86</td>\n",
       "      <td>109150</td>\n",
       "      <td>2082.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>13.0</td>\n",
       "      <td>121.0</td>\n",
       "      <td>126147</td>\n",
       "      <td>36435.5</td>\n",
       "      <td>48455.8</td>\n",
       "      <td>147.213</td>\n",
       "      <td>7925.19</td>\n",
       "      <td>3521.93</td>\n",
       "      <td>82048.6</td>\n",
       "      <td>1960.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1010</th>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>15.0</td>\n",
       "      <td>405.0</td>\n",
       "      <td>159056</td>\n",
       "      <td>39497.1</td>\n",
       "      <td>52214.5</td>\n",
       "      <td>477.225</td>\n",
       "      <td>5225.52</td>\n",
       "      <td>2393.91</td>\n",
       "      <td>56806.7</td>\n",
       "      <td>723.208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>396</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>25.0</td>\n",
       "      <td>725.0</td>\n",
       "      <td>162295</td>\n",
       "      <td>45319.6</td>\n",
       "      <td>59215</td>\n",
       "      <td>1276.27</td>\n",
       "      <td>7005.44</td>\n",
       "      <td>3984.44</td>\n",
       "      <td>73288.1</td>\n",
       "      <td>849.051</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>491</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>44.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>92429.3</td>\n",
       "      <td>27827.3</td>\n",
       "      <td>44542.2</td>\n",
       "      <td>142.751</td>\n",
       "      <td>4093.44</td>\n",
       "      <td>1887.62</td>\n",
       "      <td>51163.4</td>\n",
       "      <td>723.996</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>763</th>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>76.0</td>\n",
       "      <td>719.0</td>\n",
       "      <td>94484.6</td>\n",
       "      <td>27903.6</td>\n",
       "      <td>44498.3</td>\n",
       "      <td>154.16</td>\n",
       "      <td>4105.73</td>\n",
       "      <td>1892.19</td>\n",
       "      <td>51767.6</td>\n",
       "      <td>735.542</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>635</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>94188.5</td>\n",
       "      <td>28413.5</td>\n",
       "      <td>44680.7</td>\n",
       "      <td>142.472</td>\n",
       "      <td>4050.96</td>\n",
       "      <td>1868.32</td>\n",
       "      <td>51121.8</td>\n",
       "      <td>735.673</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>784 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         date_dt  cod_dpto  cod_mpio 3g_traf_dl 3g_traf_ul 3g_completadas  \\\n",
       "151   2015-02-01      13.0     167.0      96302    28594.9        46263.8   \n",
       "159   2015-02-01      15.0     279.0    94132.5    28111.4        45557.3   \n",
       "164   2015-02-01      15.0     370.0     107697    31894.1        48360.9   \n",
       "168   2015-02-01      15.0     426.0     103768    30961.3        48850.8   \n",
       "181   2015-02-01      15.0     490.0     128998    37061.5          56308   \n",
       "195   2015-02-01      15.0     523.0    97729.5    29552.4        46484.7   \n",
       "198   2015-02-01      15.0     533.0     114356    34022.2        53058.7   \n",
       "205   2015-02-01      15.0     550.0     174792    47491.7        80644.7   \n",
       "206   2015-02-01      15.0     558.0     143586    42940.2        66757.5   \n",
       "210   2015-02-01      15.0     584.0    97577.5    28770.7        45454.3   \n",
       "215   2015-02-01      15.0     636.0     112317    33749.4        51533.1   \n",
       "222   2015-02-01      15.0     705.0     106108    30962.3        51199.1   \n",
       "223   2015-02-01      15.0     710.0    96380.3    28831.3        46651.7   \n",
       "227   2015-02-01      17.0     560.0    95406.1    28970.9        46708.9   \n",
       "239   2015-02-01      17.0     638.0     115770    33839.3        55005.7   \n",
       "245   2015-02-01      17.0     674.0     104419    32064.5        47105.9   \n",
       "247   2015-02-01      17.0    1112.0    99166.1    28860.1        45628.1   \n",
       "254   2015-02-01      18.0    1000.0    94784.6    28304.1        46514.9   \n",
       "255   2015-02-01      18.0    1013.0     130162    38611.7        54631.4   \n",
       "257   2015-02-01      18.0    1030.0    94333.8    28562.3          45843   \n",
       "259   2015-02-01      18.0    1035.0     108551      32060        51165.4   \n",
       "263   2015-02-01      19.0     897.0    92243.4    27555.5        44050.5   \n",
       "265   2015-02-01      19.0     900.0    96339.4    28011.3        45213.1   \n",
       "278   2015-02-01      19.0     932.0    92210.3    27641.9          44239   \n",
       "282   2015-02-01      19.0     952.0    93226.1    27908.4        44957.4   \n",
       "291   2015-02-01      19.0     984.0    94939.4    28083.6        45139.8   \n",
       "293   2015-02-01      19.0     988.0      94795    28139.2        45833.7   \n",
       "298   2015-02-01      20.0      56.0     136969    38509.4          54188   \n",
       "303   2015-02-01      20.0      78.0    92048.5    27577.9        44749.2   \n",
       "304   2015-02-01      20.0      82.0    98926.7    29334.7        47515.4   \n",
       "...          ...       ...       ...        ...        ...            ...   \n",
       "555   2015-02-01      52.0    1002.0     353267    91449.3         123489   \n",
       "557   2015-02-01      52.0    1005.0     109175    31259.9        45747.8   \n",
       "598   2015-02-01      54.0     180.0     196893    55465.8        62878.2   \n",
       "637   2015-02-01      66.0     707.0     114029    32203.9        45999.4   \n",
       "645   2015-02-01      68.0     248.0     161125    45137.5        54177.5   \n",
       "669   2015-02-01      68.0     333.0     140428    41007.1        50720.7   \n",
       "682   2015-02-01      68.0     386.0     132741    38293.9        50007.6   \n",
       "750   2015-02-01      73.0     851.0     146201    40414.7        52390.2   \n",
       "1031  2015-02-02      15.0     505.0     175599    54264.3        70761.1   \n",
       "1043  2015-02-02      15.0     535.0     103707      32535        47991.3   \n",
       "1047  2015-02-02      15.0     542.0    98837.5      29760        46574.5   \n",
       "1057         NaN       NaN       NaN     153876    43206.1        50889.6   \n",
       "1060  2015-02-02      15.0     639.0     100583    29050.2        44514.2   \n",
       "1064  2015-02-02      15.0     686.0     139326    37455.1          55242   \n",
       "1073         NaN       NaN       NaN     102055    30802.1        46327.5   \n",
       "1075  2015-02-02      17.0     574.0     160251    48925.8        61255.4   \n",
       "1076  2015-02-02      17.0     580.0     109486    34215.7        47821.4   \n",
       "1077  2015-02-02      17.0     596.0    96364.2    28185.2        44259.7   \n",
       "3     2015-02-01       5.0     168.0     249313    79622.1        60351.1   \n",
       "4     2015-02-01       5.0     181.0     989993     365462         290824   \n",
       "1085  2015-02-02      17.0     652.0     205129      56207        54252.5   \n",
       "850   2015-02-02       5.0     198.0     146186      39107        54125.4   \n",
       "924   2015-02-02       5.0     445.0     270307    84576.1        67307.7   \n",
       "965   2015-02-02      11.0     726.0     130496      38433        50918.1   \n",
       "987   2015-02-02      13.0     121.0     126147    36435.5        48455.8   \n",
       "1010  2015-02-02      15.0     405.0     159056    39497.1        52214.5   \n",
       "396   2015-02-01      25.0     725.0     162295    45319.6          59215   \n",
       "491   2015-02-01      44.0      43.0    92429.3    27827.3        44542.2   \n",
       "763   2015-02-01      76.0     719.0    94484.6    27903.6        44498.3   \n",
       "635          NaN       NaN       NaN    94188.5    28413.5        44680.7   \n",
       "\n",
       "     3g_no_completadas 2g_traf_dl 2g_traf_ul 2g_completadas 2g_no_completadas  \n",
       "151            142.528    4105.25    1909.36        54400.2            765.77  \n",
       "159            142.618    4072.67    1898.44        54189.7           783.826  \n",
       "164            142.573    5044.22    2543.55        62298.7           990.984  \n",
       "168            143.045    4534.37    2180.38        62521.5           1024.06  \n",
       "181            147.427    7710.89    4313.09         101312           1720.78  \n",
       "195            146.607    5285.73    2733.45        88063.1           1656.03  \n",
       "198            148.741    4220.75    2026.13        67326.9           1042.06  \n",
       "205            160.416    4844.73    2469.21        88973.4           1313.68  \n",
       "206            151.191    4713.82    2373.19        79516.1           1048.05  \n",
       "210             142.73    4494.73    2209.11        57889.6           859.826  \n",
       "215            144.854    4465.04    2166.99        63494.4           960.759  \n",
       "222            143.359    4223.89    2022.47          60647           894.343  \n",
       "223            142.876    5051.87    2636.24        66561.3           1000.69  \n",
       "227                144    4068.49    1886.62        56125.6           795.961  \n",
       "239            148.314    4327.72     2094.3        61617.9           885.085  \n",
       "245             155.82    4639.61     2324.1        66174.9           1220.75  \n",
       "247            142.629    4535.13    2263.47        62126.4           1032.74  \n",
       "254            141.977    4396.24    2116.97        60209.6           947.984  \n",
       "255            172.674    7700.96    3261.78        75400.8           1410.49  \n",
       "257            143.977    4594.56    2310.03        64859.7           1145.99  \n",
       "259            143.775    5219.95    2646.23        75607.8           1120.96  \n",
       "263            141.708     5927.1    3093.77        62434.2           882.512  \n",
       "265            142.607    4273.42    2034.41        56937.3           882.107  \n",
       "278            142.225    4037.59     1867.9        51404.1           738.321  \n",
       "282             142.18    4055.56    1882.87        52625.8           751.815  \n",
       "291            142.168    4093.33    1918.52        53012.2           779.309  \n",
       "293            142.281    4110.91    1916.42        55039.3           788.545  \n",
       "298            144.843    6011.54    3123.72        77636.5           1177.04  \n",
       "303            141.989    4054.72     1889.4        52327.6           741.613  \n",
       "304            145.135    5132.58     2708.9          76739           1190.97  \n",
       "...                ...        ...        ...            ...               ...  \n",
       "555            415.359      16106    6975.06         116946           1599.65  \n",
       "557            146.618    4576.92     2040.6        53292.8            762.04  \n",
       "598            185.539    11737.6    5046.58        70512.4           1114.53  \n",
       "637            183.314     4554.7    2146.49        55451.4           821.163  \n",
       "645            149.775    5044.63    2333.79        56624.7           791.017  \n",
       "669            149.168    5704.61    2580.31        57318.7           864.759  \n",
       "682            148.202    6045.98    2616.04        58693.2           862.905  \n",
       "750            151.697    5235.28    2261.38        59552.9           828.321  \n",
       "1031           181.876    6334.68    3266.83        80937.6           1192.65  \n",
       "1043           143.506    4425.03    2115.59        54092.2           797.972  \n",
       "1047           145.517    4454.53    2099.16        66639.1           949.321  \n",
       "1057           148.977     5048.8    2200.95        58902.9           846.714  \n",
       "1060           142.506     5197.5    2256.25        56189.3           888.062  \n",
       "1064            161.18    5363.42     2320.1        61630.6           908.208  \n",
       "1073           145.236    4994.37    2200.55        58983.8           918.264  \n",
       "1075           163.573    6205.97     2818.6        67243.9           1079.24  \n",
       "1076           147.281    7250.14    2945.63        60221.6           945.377  \n",
       "1077           142.506    6288.14    2696.99          58235           946.871  \n",
       "3              153.753    8260.33    3341.66        59861.1           792.332  \n",
       "4              1455.21    30385.4    10772.5         199451           1576.89  \n",
       "1085           1011.26     7159.1    4109.53        70415.8           779.456  \n",
       "850            880.461    6590.31    3135.99        60570.7           725.748  \n",
       "924            198.168    16754.7    6816.83         103823           1696.34  \n",
       "965                148    7862.42    3709.86         109150            2082.8  \n",
       "987            147.213    7925.19    3521.93        82048.6           1960.07  \n",
       "1010           477.225    5225.52    2393.91        56806.7           723.208  \n",
       "396            1276.27    7005.44    3984.44        73288.1           849.051  \n",
       "491            142.751    4093.44    1887.62        51163.4           723.996  \n",
       "763             154.16    4105.73    1892.19        51767.6           735.542  \n",
       "635            142.472    4050.96    1868.32        51121.8           735.673  \n",
       "\n",
       "[784 rows x 11 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    " \n",
    "#Suma de Trafico total por municipio\n",
    "municipios = df_antenas['cod_mpio'].unique()\n",
    "trafico = ['3g_traf_dl', '3g_traf_ul' ,'3g_completadas','3g_no_completadas' ,'2g_traf_dl', '2g_traf_ul', '2g_completadas','2g_no_completadas']\n",
    "\n",
    "new_df = pd.DataFrame(data=None, index=municipios, columns=df_antenas.columns.values, dtype=None, copy=False)\n",
    "new_df['date_dt'] = df_antenas['date_dt'] \n",
    "new_df['cod_dpto'] = df_antenas['cod_dpto']\n",
    "new_df['cod_mpio'] = df_antenas['cod_mpio']\n",
    "for i in municipios:\n",
    "    aux = df_antenas.loc[df_antenas['cod_mpio'] == i]\n",
    "    for j in trafico:\n",
    "        new_df[j].loc[i]=aux[j].mean()\n",
    "    #v = aux['3g_traf_dl'].sum() / aux['3g_traf_dl'].count()\n",
    "    #new_df.loc[i]=v\n",
    "new_df  \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[ 151  159  164  168  181  195  198  205  206  210  215  222  223  227  239\n",
      "  245  247  254  255  257  259  263  265  278  282  291  293  298  303  304\n",
      "  308  310  317  320  327  331  334  337  341  344  345  350  355  357  358\n",
      "  367  368  369  371  372  373  376  378  381  389  393  394  399  400  407\n",
      "  409  412  414  415  417  419  423  424  429  430  431  433  435  438  441\n",
      "  445  448  452  455  459  465  466  468  472  474  476  477  481  482  494\n",
      "  497  507  525  544 1122   13   15   20   21   22   23   24   27   28   29\n",
      "   30   31   34   37   38   39   47   55  726   32   40   46   52   53   57\n",
      "   61   65   68   69   70   74   76   77   83   84   86   92  103  120  121\n",
      "  128  138  145  148  160  165  167  177  192  199  202  236  243  279  356\n",
      "  363  365  370  402  405  421  426  440  444  449  462  463  464  471  479\n",
      "  485  486  490  496  500  501  502  505  506  509  511  517  521  522  523\n",
      "  530  531  533  535  536  537  539  542  545  550  558  562  568  578  584\n",
      "  591  600  633  636  639  661  662  672  686  699  705  710  514  547  548\n",
      "  560  561  566  574  580  596  605  608  610  615  618  638  643  652  653\n",
      "  667  668  674 1110 1112  920  956  964  973  994  997 1000 1013 1022 1030\n",
      " 1033 1035 1045 1048  896  897  899  900  902  903  906  908  909  912  918\n",
      "  921  925  927  928  929  932  941  944  949  952  953  954  957  960  963\n",
      "  967  972  980  984  986  988 1107   25   41   56   58   62   66   73   78\n",
      "   82   85   90   95   96   98  112  137  139  152  161  173  176  179  191\n",
      "  203  207  105  106  116  117  118  119  123  127  130  131  133  136  141\n",
      "  143  146  147  149  154  155  169  171  174  182  188  189  197  200  211\n",
      "  503  549  556  571  581  585  597  609  620  621  626  630  632  642  647\n",
      "  654  656  660  663  665  666  671  675  680  681  683  687  690  694  697\n",
      "  698  702  708  709  711  714  716  718  721  723  724  725  727  730  732\n",
      "  736  737  738  741  742  745  746  754  756  760  761  765  766  768  770\n",
      "  771  779  780  783  787  788  794  798  803  805  806  807  810  812  813\n",
      "  814  823  828  831  166  390  595  628  631 1114 1116 1117  891  898  901\n",
      "  905  911  913  916  922  923  930  931  933  934  935  940  945  946  950\n",
      "  961  976  977  978  981  983  985  989  993  996    2    5    6    7    8\n",
      "   10   11   16   17   18   43   44   50 1088 1089    9   12   14   19   26\n",
      "   35   36   42   45   54   64   72   79   80   81   87   88  101  102  113\n",
      "  115 1091 1092 1095  720  757  796  802  804  819  821  836  847  854  858\n",
      "  860  877  878  881  883  884  887  895  904  907  926  939  948  951  971\n",
      "  979  990  992  998  999 1002 1003 1005 1007 1008 1011 1015 1018 1019 1021\n",
      " 1023 1025 1026 1027 1029 1032 1036 1038 1039 1041 1044 1046 1049 1051 1052\n",
      " 1053 1055 1059 1061 1062 1063 1065 1067 1068 1069 1070 1105  134  180  183\n",
      "  184  186  190  193  194  213  216  217  220  221  224  229  234  244  249\n",
      "  749  751  758  764  775  776  781  786  811  815  570  590  592  594  622\n",
      "  658  670  673  696  707  713  717  201  225  228  231  233  248  256  258\n",
      "  261  262  267  268  269  270  283  284  289  290  295  297  299  305  313\n",
      "  314  321  326  328  333  335  349  351  352  353  359  362  379  380  386\n",
      "  392  397  420  422  437  443  457  458  460  475   75   89   93   94   97\n",
      "  100  104  107  109  110  111  114  126  129  135  140  150  153  162  163\n",
      "  172 1108 1109  612  616  641  644  655  657  700  701  733  735  747  753\n",
      "  759  767  773  789  808  818  822  824  826  827  829  832  834  835  841\n",
      "  843  845  851  852  856  857  864  869  872  875  880  885  893  691  719\n",
      "  722  728  743  748  752  755  769  774  777  778  785  790  792  797  799\n",
      "  816  825  830  833  838  839  840  842  846  849  859  861  862  863  865\n",
      "  867  868  871  879  882  886  888  892  894  272  275  276  300  324  325\n",
      "  406  439  453  493  555  557  598  637  645  669  682  750 1031 1043 1047\n",
      " 1057 1060 1064 1073 1075 1076 1077    3    4 1085  850  924  965  987 1010\n",
      "  396  491  763  635]\n",
      "784\n"
     ]
    }
   ],
   "source": [
    "municipios = df_antenas['cod_mpio'].unique()\n",
    "print(municipios)\n",
    "print(len(municipios))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "814\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/usr/local/lib/python2.7/dist-packages/ipykernel/__main__.py:12: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cod_mpio</th>\n",
       "      <th>dwells</th>\n",
       "      <th>people</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>151</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>159</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>164</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>168</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>181</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>195</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>198</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>205</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>206</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>210</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>215</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>223</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>227</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>239</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>245</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>246</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>247</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>254</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>255</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>257</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>259</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>263</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>265</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>282</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>286</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>293</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>298</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>303</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70229</th>\n",
       "      <td>493</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70230</th>\n",
       "      <td>520</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70231</th>\n",
       "      <td>555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70232</th>\n",
       "      <td>557</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70233</th>\n",
       "      <td>598</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70234</th>\n",
       "      <td>637</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70235</th>\n",
       "      <td>645</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70236</th>\n",
       "      <td>669</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70237</th>\n",
       "      <td>682</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70238</th>\n",
       "      <td>750</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70239</th>\n",
       "      <td>1031</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70240</th>\n",
       "      <td>1040</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70241</th>\n",
       "      <td>1043</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70242</th>\n",
       "      <td>1047</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70243</th>\n",
       "      <td>1057</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70244</th>\n",
       "      <td>1060</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70245</th>\n",
       "      <td>1064</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70246</th>\n",
       "      <td>1073</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70247</th>\n",
       "      <td>1074</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70248</th>\n",
       "      <td>1075</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70249</th>\n",
       "      <td>1076</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70250</th>\n",
       "      <td>1077</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70251</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70252</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70253</th>\n",
       "      <td>850</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70254</th>\n",
       "      <td>924</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70255</th>\n",
       "      <td>965</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70256</th>\n",
       "      <td>1010</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70257</th>\n",
       "      <td>416</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70258</th>\n",
       "      <td>575</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>70259 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       cod_mpio dwells people\n",
       "0           151    NaN    NaN\n",
       "1           159    NaN    NaN\n",
       "2           164    NaN    NaN\n",
       "3           168    NaN    NaN\n",
       "4           181    NaN    NaN\n",
       "5           195    NaN    NaN\n",
       "6           198    NaN    NaN\n",
       "7           205    NaN    NaN\n",
       "8           206    NaN    NaN\n",
       "9           210    NaN    NaN\n",
       "10          215    NaN    NaN\n",
       "11          222    NaN    NaN\n",
       "12          223    NaN    NaN\n",
       "13          227    NaN    NaN\n",
       "14          239    NaN    NaN\n",
       "15          245    NaN    NaN\n",
       "16          246    NaN    NaN\n",
       "17          247    NaN    NaN\n",
       "18          254    NaN    NaN\n",
       "19          255    NaN    NaN\n",
       "20          257    NaN    NaN\n",
       "21          259    NaN    NaN\n",
       "22          263    NaN    NaN\n",
       "23          265    NaN    NaN\n",
       "24          282    NaN    NaN\n",
       "25          286    NaN    NaN\n",
       "26          291    NaN    NaN\n",
       "27          293    NaN    NaN\n",
       "28          298    NaN    NaN\n",
       "29          303    NaN    NaN\n",
       "...         ...    ...    ...\n",
       "70229       493    NaN    NaN\n",
       "70230       520    NaN    NaN\n",
       "70231       555    NaN    NaN\n",
       "70232       557    NaN    NaN\n",
       "70233       598    NaN    NaN\n",
       "70234       637    NaN    NaN\n",
       "70235       645    NaN    NaN\n",
       "70236       669    NaN    NaN\n",
       "70237       682    NaN    NaN\n",
       "70238       750    NaN    NaN\n",
       "70239      1031    NaN    NaN\n",
       "70240      1040    NaN    NaN\n",
       "70241      1043    NaN    NaN\n",
       "70242      1047    NaN    NaN\n",
       "70243      1057    NaN    NaN\n",
       "70244      1060    NaN    NaN\n",
       "70245      1064    NaN    NaN\n",
       "70246      1073    NaN    NaN\n",
       "70247      1074    NaN    NaN\n",
       "70248      1075    NaN    NaN\n",
       "70249      1076    NaN    NaN\n",
       "70250      1077    NaN    NaN\n",
       "70251         3    NaN    NaN\n",
       "70252         4    NaN    NaN\n",
       "70253       850    NaN    NaN\n",
       "70254       924    NaN    NaN\n",
       "70255       965    NaN    NaN\n",
       "70256      1010    NaN    NaN\n",
       "70257       416    NaN    NaN\n",
       "70258       575    NaN    NaN\n",
       "\n",
       "[70259 rows x 3 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    " \n",
    "municipios = df_dwells['cod_mpio'].unique() \n",
    "print(len(municipios))\n",
    "dwells =['cod_mpio','dwells' , 'people']\n",
    "new_df2 = pd.DataFrame(data=None, index=None, columns=dwells, dtype=None, copy=False) \n",
    "dwells= dwells[1:]\n",
    "new_df2['cod_mpio'] = df_dwells['cod_mpio']\n",
    "c = 0\n",
    "for i in municipios:\n",
    "    aux = df_dwells.loc[df_dwells['cod_mpio'] == i]\n",
    "    for j in dwells:\n",
    "        new_df2.iloc[c][j] = aux[j].mean() \n",
    "    c+=1\n",
    "new_df2  \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}