Exploracion de geo voice dataset.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd; import numpy as np; import os;import random;import time;"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import random; import gzip;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Explorar geo datos de llamados (Voice)\n",
    "en un principio si los datos no son geolocalizados por antena no puedo saber quien llamo a la zona endemica. El objetivo es ver...\n",
    "\n",
    "* como se compone la base de datos\n",
    "* que sirve para el analisis de la mobilidad y del \"Gran Chaco\"\n",
    "* haria falta tambien tener el .cpp que asigna home a cada user\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "np.random.seed(2015)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "##setting general params\n",
    "rootdir=\"/home/juan/mobility-study\"\n",
    "os.chdir(rootdir)\n",
    "directory = \"0315\"; contract_type=\"Prepago\";\n",
    "day_streak=\"03-04\"\n",
    "input_file= 'datosgeo/%s/%s/Geo_Voz_%s_%s%s.txt.gz' % (directory,contract_type,contract_type,day_streak,directory)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'datosgeo/0315/Prepago/Geo_Voz_Prepago_03-040315.txt.gz'"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "input_file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Geo_Voz_Prepago_01-020315.txt.gz  Geo_Voz_Prepago_17-180315.txt.gz\r\n",
      "Geo_Voz_Prepago_03-040315.txt.gz  Geo_Voz_Prepago_19-200315.txt.gz\r\n",
      "Geo_Voz_Prepago_05-060315.txt.gz  Geo_Voz_Prepago_21-220315.txt.gz\r\n",
      "Geo_Voz_Prepago_09-100315.txt.gz  Geo_Voz_Prepago_23-230315.txt.gz\r\n",
      "Geo_Voz_Prepago_11-120315.txt.gz  Geo_Voz_Prepago_25-260315.txt.gz\r\n",
      "Geo_Voz_Prepago_13-140315.txt.gz  Geo_Voz_Prepago_27-280315.txt.gz\r\n",
      "Geo_Voz_Prepago_15-160315.txt.gz  Geo_Voz_Prepago_29-310315.txt.gz\r\n"
     ]
    }
   ],
   "source": [
    "!ls datosgeo/0315/Prepago/"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "==> standard input <==\n",
      "CONTRATO\tTELEFONO\tORIGEN\tDESTINO\tDIRECCION\tDURACION_SEGUNDOS\tUBICACIONCIUDAD\tLATITUD\tLONGITUD\tOPERADOR\tFECHA_LLAMADA\n",
      "\t00000B984B91C296144E8434BB08D508\t00000B984B91C296144E8434BB08D508\t5E6693E9FBF7E6F541DE2D17A771E443\tENTRANTE\t152\t\t\t\tIUSACELL          \t03/03/2015 05:55:15 a.m.\n",
      "\t00000C5D3BFBEBD919F6F68386C3DD5E\t00000C5D3BFBEBD919F6F68386C3DD5E\t0A8D39BFACCA596573FA1371E02A4EF2\tENTRANTE\t116\t\t15.85830556\t-97.04511111\tIUSACELL          \t04/03/2015 08:16:16 a.m.\n",
      "\t000011F2BE4C5E7D456026CD791185B3\t000011F2BE4C5E7D456026CD791185B3\t00F0D512BCD00EC7B9C666ECA0B645C3\tENTRANTE\t19\tMexicali\t32.574342\t-115.352511\tUNEFON            \t04/03/2015 06:05:47 p.m.\n",
      "\t00001228A0D38FB8D81365EDAB963130\t00001228A0D38FB8D81365EDAB963130\t106BD5A02DE8DADBE6DAF2E82EED04DE\tENTRANTE\t187\t\t20.73645278\t-103.4314972\tUNEFON            \t03/03/2015 05:05:32 p.m.\n",
      "\t0000129F4191FFD0963774D2307C7510\t0000129F4191FFD0963774D2307C7510\tB55022400C295828668E644CFDA58425\tENTRANTE\t46\tTehuacan\t18.45369522\t-97.40105726\tUNEFON            \t04/03/2015 02:08:59 p.m.\n",
      "\t0000129F4191FFD0963774D2307C7510\t0000129F4191FFD0963774D2307C7510\tD3E9BDC02EF826B7BB9E01B6F3EC00BC\tENTRANTE\t11\t\t18.4889\t-97.3836\tUNEFON            \t03/03/2015 01:09:30 p.m.\n",
      "\t00001ADC8C5705AB4FD8197B5024C1AA\t00001ADC8C5705AB4FD8197B5024C1AA\t56A4A3222955712FA7FAD539708013B0\tSALIENTE\t73\t\t17.85156525\t-97.82741882\tTELMEX            \t03/03/2015 07:34:11 p.m.\n",
      "\t00001ADC8C5705AB4FD8197B5024C1AA\t00001ADC8C5705AB4FD8197B5024C1AA\tD85D1DC9C58EB1C83D3D63A35E9FDD86\tSALIENTE\t14\t\t17.85156525\t-97.82741882\tIUSACELL          \t04/03/2015 06:59:54 p.m.\n",
      "\t00001ADC8C5705AB4FD8197B5024C1AA\t00001ADC8C5705AB4FD8197B5024C1AA\tD85D1DC9C58EB1C83D3D63A35E9FDD86\tSALIENTE\t16\t\t17.85156525\t-97.82741882\tIUSACELL          \t04/03/2015 08:06:36 p.m.\n",
      "head: cannot open `n10' for reading: No such file or directory\n",
      "\n",
      "gzip: stdout: Broken pipe\n"
     ]
    }
   ],
   "source": [
    "!zcat $input_file | head - n10"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "pd.read_csv?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "tabla_mensual = pd.read_csv(\n",
    "                input_file,\n",
    "                delim_whitespace=True,\n",
    "                #sep = \"\\t\",\n",
    "                names = ['Telefono','Target','Destination','Direction','Duration',\n",
    "                         'City','Latitude','Longitude','Operator','Date1','Date2','Date3'],\n",
    "                engine = 'c', lineterminator='\\n', skipinitialspace=True,\n",
    "                index_col=False,\n",
    "                skiprows = 2,\n",
    "                #usecols = ['Latitude','Longitude']\n",
    "    #dtype = {'Target':np.uint32,'Destination':np.uint32,'TimeStamp':np.uint32,\n",
    "     #                                 'Duration':np.uint16,'AntennaID':np.uint16,'Direction':np.object_}\n",
    "                )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "tabla_mensual.drop(['Telefono','Direction','Duration','Operator','Date1','Date2'],inplace=True,axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#tratamos de castear los valores de una series a cosas numericas y sino devolvemos False\n",
    "def try_int_cast(x):\n",
    "    try: \n",
    "        float(x)\n",
    "        return True\n",
    "    except:\n",
    "        return False"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "buff = tabla_mensual.ix[tabla_mensual['Date3'].isnull()]\n",
    "#buscamos todas aquellas filas que no podemos castear a \n",
    "buff2 = buff[~buff['City'].apply(lambda x: try_int_cast(x))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "tabla_mensual.drop(buff2.index.values,inplace=True,axis=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "#guardo los valores a reemplazar\n",
    "buff = tabla_mensual.ix[tabla_mensual['Date3'].isnull(),['City','Latitude']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#hago el reemplazo en ese indice\n",
    "indice = tabla_mensual.ix[tabla_mensual['Date3'].isnull()].index.values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#el .values es crucial. Si no esta, va a tratar de igualar los valores basandose en indice. En cambio\n",
    "#el .values tira los indices y lo ve com una \"matriz\" pura sin labels.\n",
    "tabla_mensual.loc[indice,['Latitude','Longitude']]= buff.values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "metadata": {
    "collapsed": false,
    "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>City</th>\n",
       "      <th>Latitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4307647</th>\n",
       "      <td>18.45705867</td>\n",
       "      <td>-95.35011002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2175989</th>\n",
       "      <td>18.64722222</td>\n",
       "      <td>-98.605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8792634</th>\n",
       "      <td>20.5478</td>\n",
       "      <td>-100.8228</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4878816</th>\n",
       "      <td>19.26988757</td>\n",
       "      <td>-99.65918728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5971496</th>\n",
       "      <td>19.085767</td>\n",
       "      <td>-98.199828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>790427</th>\n",
       "      <td>20.096808</td>\n",
       "      <td>-98.751367</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8937487</th>\n",
       "      <td>18.54232306</td>\n",
       "      <td>-92.65082833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4004321</th>\n",
       "      <td>14.68219444</td>\n",
       "      <td>-92.15552778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3213375</th>\n",
       "      <td>25.67732778</td>\n",
       "      <td>-100.3189194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5684929</th>\n",
       "      <td>20.50982306</td>\n",
       "      <td>-87.23321139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4824330</th>\n",
       "      <td>19.020333</td>\n",
       "      <td>-102.079414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4135497</th>\n",
       "      <td>22.123</td>\n",
       "      <td>-100.9202222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>711216</th>\n",
       "      <td>19.785</td>\n",
       "      <td>-97.3502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6677988</th>\n",
       "      <td>19.04622222</td>\n",
       "      <td>-100.0648056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4889027</th>\n",
       "      <td>19.5366735</td>\n",
       "      <td>-96.93734256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61331</th>\n",
       "      <td>20.0686</td>\n",
       "      <td>-97.0587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9652408</th>\n",
       "      <td>19.28263514</td>\n",
       "      <td>-98.4443496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8670077</th>\n",
       "      <td>16.86694444</td>\n",
       "      <td>-99.90416667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3625137</th>\n",
       "      <td>19.28428056</td>\n",
       "      <td>-99.53027778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4558884</th>\n",
       "      <td>19.29138819</td>\n",
       "      <td>-99.16139154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5272305</th>\n",
       "      <td>21.28063889</td>\n",
       "      <td>-101.8373056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1719346</th>\n",
       "      <td>19.621458</td>\n",
       "      <td>-99.037744</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7562382</th>\n",
       "      <td>19.47184722</td>\n",
       "      <td>-99.22673056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6211162</th>\n",
       "      <td>20.54722222</td>\n",
       "      <td>-102.4719444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516885</th>\n",
       "      <td>18.511553</td>\n",
       "      <td>-95.317167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3607948</th>\n",
       "      <td>18.031111</td>\n",
       "      <td>-93.811917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3671522</th>\n",
       "      <td>20.68728417</td>\n",
       "      <td>-88.20532056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7791657</th>\n",
       "      <td>19.34488889</td>\n",
       "      <td>-102.3651667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6723073</th>\n",
       "      <td>20.7135</td>\n",
       "      <td>-103.4241667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1679468</th>\n",
       "      <td>20.68728417</td>\n",
       "      <td>-88.20532056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5275592</th>\n",
       "      <td>19.32799581</td>\n",
       "      <td>-99.25940692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5791822</th>\n",
       "      <td>19.59083333</td>\n",
       "      <td>-96.94027778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70227</th>\n",
       "      <td>19.34488889</td>\n",
       "      <td>-102.3651667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2873196</th>\n",
       "      <td>18.87172222</td>\n",
       "      <td>-96.35163889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762687</th>\n",
       "      <td>19.292105</td>\n",
       "      <td>-99.149549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9956496</th>\n",
       "      <td>18.87036111</td>\n",
       "      <td>-97.71630556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>813483</th>\n",
       "      <td>25.74723443</td>\n",
       "      <td>-100.3599154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2170548</th>\n",
       "      <td>18.1078866</td>\n",
       "      <td>-96.09936061</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2622968</th>\n",
       "      <td>19.57175</td>\n",
       "      <td>-99.76602778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9493974</th>\n",
       "      <td>16.922194</td>\n",
       "      <td>-99.962556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7801715</th>\n",
       "      <td>20.6528</td>\n",
       "      <td>-103.4522278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3682666</th>\n",
       "      <td>19.000639</td>\n",
       "      <td>-98.214028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2047</th>\n",
       "      <td>20.66936111</td>\n",
       "      <td>-103.2557222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6261839</th>\n",
       "      <td>18.87763889</td>\n",
       "      <td>-96.75305556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>687683</th>\n",
       "      <td>20.54405556</td>\n",
       "      <td>-100.6920556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2141718</th>\n",
       "      <td>20.14332385</td>\n",
       "      <td>-101.1952751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3989538</th>\n",
       "      <td>16.89138889</td>\n",
       "      <td>-99.83416667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7698581</th>\n",
       "      <td>17.59111111</td>\n",
       "      <td>-99.09277778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6314120</th>\n",
       "      <td>20.045</td>\n",
       "      <td>-102.2827778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288709</th>\n",
       "      <td>20.67341667</td>\n",
       "      <td>-103.2816944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421673</th>\n",
       "      <td>14.870769</td>\n",
       "      <td>-92.285564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3303490</th>\n",
       "      <td>19.65924722</td>\n",
       "      <td>-99.12539167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3018350</th>\n",
       "      <td>18.36548333</td>\n",
       "      <td>-95.76816111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>811301</th>\n",
       "      <td>20.050206</td>\n",
       "      <td>-98.740094</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9021468</th>\n",
       "      <td>19.03669444</td>\n",
       "      <td>-98.14411111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3936308</th>\n",
       "      <td>17.43011139</td>\n",
       "      <td>-93.36741306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>330064</th>\n",
       "      <td>22.06531586</td>\n",
       "      <td>-100.649197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5277682</th>\n",
       "      <td>17.98032778</td>\n",
       "      <td>-93.38234722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3949309</th>\n",
       "      <td>20.61744722</td>\n",
       "      <td>-103.2474056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>947599</th>\n",
       "      <td>19.616239</td>\n",
       "      <td>-99.185069</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                City      Latitude\n",
       "4307647  18.45705867  -95.35011002\n",
       "2175989  18.64722222       -98.605\n",
       "8792634      20.5478     -100.8228\n",
       "4878816  19.26988757  -99.65918728\n",
       "5971496    19.085767    -98.199828\n",
       "790427     20.096808    -98.751367\n",
       "8937487  18.54232306  -92.65082833\n",
       "4004321  14.68219444  -92.15552778\n",
       "3213375  25.67732778  -100.3189194\n",
       "5684929  20.50982306  -87.23321139\n",
       "4824330    19.020333   -102.079414\n",
       "4135497       22.123  -100.9202222\n",
       "711216        19.785      -97.3502\n",
       "6677988  19.04622222  -100.0648056\n",
       "4889027   19.5366735  -96.93734256\n",
       "61331        20.0686      -97.0587\n",
       "9652408  19.28263514   -98.4443496\n",
       "8670077  16.86694444  -99.90416667\n",
       "3625137  19.28428056  -99.53027778\n",
       "4558884  19.29138819  -99.16139154\n",
       "5272305  21.28063889  -101.8373056\n",
       "1719346    19.621458    -99.037744\n",
       "7562382  19.47184722  -99.22673056\n",
       "6211162  20.54722222  -102.4719444\n",
       "516885     18.511553    -95.317167\n",
       "3607948    18.031111    -93.811917\n",
       "3671522  20.68728417  -88.20532056\n",
       "7791657  19.34488889  -102.3651667\n",
       "6723073      20.7135  -103.4241667\n",
       "1679468  20.68728417  -88.20532056\n",
       "...              ...           ...\n",
       "5275592  19.32799581  -99.25940692\n",
       "5791822  19.59083333  -96.94027778\n",
       "70227    19.34488889  -102.3651667\n",
       "2873196  18.87172222  -96.35163889\n",
       "762687     19.292105    -99.149549\n",
       "9956496  18.87036111  -97.71630556\n",
       "813483   25.74723443  -100.3599154\n",
       "2170548   18.1078866  -96.09936061\n",
       "2622968     19.57175  -99.76602778\n",
       "9493974    16.922194    -99.962556\n",
       "7801715      20.6528  -103.4522278\n",
       "3682666    19.000639    -98.214028\n",
       "2047     20.66936111  -103.2557222\n",
       "6261839  18.87763889  -96.75305556\n",
       "687683   20.54405556  -100.6920556\n",
       "2141718  20.14332385  -101.1952751\n",
       "3989538  16.89138889  -99.83416667\n",
       "7698581  17.59111111  -99.09277778\n",
       "6314120       20.045  -102.2827778\n",
       "288709   20.67341667  -103.2816944\n",
       "421673     14.870769    -92.285564\n",
       "3303490  19.65924722  -99.12539167\n",
       "3018350  18.36548333  -95.76816111\n",
       "811301     20.050206    -98.740094\n",
       "9021468  19.03669444  -98.14411111\n",
       "3936308  17.43011139  -93.36741306\n",
       "330064   22.06531586   -100.649197\n",
       "5277682  17.98032778  -93.38234722\n",
       "3949309  20.61744722  -103.2474056\n",
       "947599     19.616239    -99.185069\n",
       "\n",
       "[100 rows x 2 columns]"
      ]
     },
     "execution_count": 125,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "buff.sample(100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "metadata": {
    "collapsed": false,
    "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>Target</th>\n",
       "      <th>Destination</th>\n",
       "      <th>City</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Date3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3714794</th>\n",
       "      <td>5C28E3B10F2E5C377BA61A4095700418</td>\n",
       "      <td>C89D73B52F04CF3A18B56E15396D7BF2</td>\n",
       "      <td>Del</td>\n",
       "      <td>Miguel</td>\n",
       "      <td>Hidalgo</td>\n",
       "      <td>04/03/2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1208769</th>\n",
       "      <td>1DD85CC71801A1B48836C01C747FCE54</td>\n",
       "      <td>81A07EB44B8820AB281C99FD8FD2BBD9</td>\n",
       "      <td>Del</td>\n",
       "      <td>Tlahuac</td>\n",
       "      <td>19.295068</td>\n",
       "      <td>05:45:58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5652957</th>\n",
       "      <td>8C3CCB4D8CA3AD3BB481E7BD12E3F727</td>\n",
       "      <td>A41D9AC8E356B84EEC8E24E0F40E27E6</td>\n",
       "      <td>20.023511</td>\n",
       "      <td>20.023511</td>\n",
       "      <td>-98.8413</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7806954</th>\n",
       "      <td>C190852CF77278E8EB3F95391FF1EDA0</td>\n",
       "      <td>54A28B1DA237B0EBAA2A17C4DD4EB70C</td>\n",
       "      <td>Salina</td>\n",
       "      <td>Cruz</td>\n",
       "      <td>16.1897</td>\n",
       "      <td>01:20:41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6138282</th>\n",
       "      <td>983ACB6546F8F6BB3F25BC1CF1350A28</td>\n",
       "      <td>A417C47E2BAF014220894E39A233394D</td>\n",
       "      <td>Chimalhuacan</td>\n",
       "      <td>19.3865</td>\n",
       "      <td>-98.914194</td>\n",
       "      <td>p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9955551</th>\n",
       "      <td>F6B598A8AA63C8EA4435CABC0C1E6B1B</td>\n",
       "      <td>8F6A45BC5519F981968A47C9DC634AE0</td>\n",
       "      <td>Del</td>\n",
       "      <td>Iztacalco</td>\n",
       "      <td>19.38847</td>\n",
       "      <td>10:36:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10028510</th>\n",
       "      <td>F881B75551261C0E7ECAB1E9B9630136</td>\n",
       "      <td>B830CDFF47BD68330491B0162A2FBA8A</td>\n",
       "      <td>19.42677799</td>\n",
       "      <td>19.42677799</td>\n",
       "      <td>-99.10868169</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2339455</th>\n",
       "      <td>39F62DBA070C39B884065AB2DC895FD3</td>\n",
       "      <td>3C3AD6AF30989DF88339A0EE0DDF5C95</td>\n",
       "      <td>18.95805556</td>\n",
       "      <td>18.95805556</td>\n",
       "      <td>-98.23888889</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1169213</th>\n",
       "      <td>1CDFA83FB2AD2A6AF6E16FE23277A53E</td>\n",
       "      <td>6C22E3691A17816F4A5E7134996BF077</td>\n",
       "      <td>Del</td>\n",
       "      <td>Venustiano</td>\n",
       "      <td>Carranza</td>\n",
       "      <td>04/03/2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6912701</th>\n",
       "      <td>AB5CCB9B9DB6674149A499BF839BF853</td>\n",
       "      <td>5FCF8AF473C828D4A9B50B2B4064E62A</td>\n",
       "      <td>17.46747222</td>\n",
       "      <td>17.46747222</td>\n",
       "      <td>-97.21580556</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>977859</th>\n",
       "      <td>1822C8C835F186491FCCEC40D12F0238</td>\n",
       "      <td>9C65FDB3C7BCA7C502E4D2E91B922E4B</td>\n",
       "      <td>Temoaya</td>\n",
       "      <td>19.46221111</td>\n",
       "      <td>-99.59683056</td>\n",
       "      <td>p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2670424</th>\n",
       "      <td>42220A9E527C6B98FB1E7CD85CD022E4</td>\n",
       "      <td>80B96E684CEEBCB7C9C022AF168B88E7</td>\n",
       "      <td>19.36570556</td>\n",
       "      <td>19.36570556</td>\n",
       "      <td>-99.19762222</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6494249</th>\n",
       "      <td>A116890F9C67295CD158D09E4BE2C796</td>\n",
       "      <td>C6E85C4D50DF978511C7099F7D232C32</td>\n",
       "      <td>Tepeji</td>\n",
       "      <td>del</td>\n",
       "      <td>Rio</td>\n",
       "      <td>03/03/2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34968</th>\n",
       "      <td>00DA166C3D058B440D8EFBD89221724B</td>\n",
       "      <td>F7EFA33135DF23ADEAF3A9AC0FD7F22C</td>\n",
       "      <td>Del</td>\n",
       "      <td>Miguel</td>\n",
       "      <td>Hidalgo</td>\n",
       "      <td>03/03/2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2254087</th>\n",
       "      <td>37E196EFC52AE73D1DC35BACF4ACCA04</td>\n",
       "      <td>C2EA29E2921C7A3E9EC435027874C34E</td>\n",
       "      <td>17.85156525</td>\n",
       "      <td>17.85156525</td>\n",
       "      <td>-97.82741882</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5817016</th>\n",
       "      <td>904D9A0E485D0B33215CCB01069557C6</td>\n",
       "      <td>10FDA01C9255C726F7D0EDBDABCD3CC5</td>\n",
       "      <td>19.81722222</td>\n",
       "      <td>19.81722222</td>\n",
       "      <td>-97.35833333</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7609214</th>\n",
       "      <td>BCAE109572030AC916C27B422229EF3D</td>\n",
       "      <td>A958DA5C4103B07637816BA6C93D1B19</td>\n",
       "      <td>Dolores</td>\n",
       "      <td>Hidalgo</td>\n",
       "      <td>21.1622</td>\n",
       "      <td>06:56:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5583337</th>\n",
       "      <td>8A778ABDDEE40E4FCF8F8410D0249509</td>\n",
       "      <td>792A40E72A23378A801AE602250773AC</td>\n",
       "      <td>18.97655556</td>\n",
       "      <td>18.97655556</td>\n",
       "      <td>-97.79766667</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1381190</th>\n",
       "      <td>2221C8D875A3067F896F36073ABD83E2</td>\n",
       "      <td>EE8C4D82C541B2520C5B236CFB2EA1BD</td>\n",
       "      <td>Ecatepec</td>\n",
       "      <td>19.52527778</td>\n",
       "      <td>-99.07316667</td>\n",
       "      <td>p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7961837</th>\n",
       "      <td>C567E84851EE05FA4E88E7BCE57C77E8</td>\n",
       "      <td>F0BCE58C3275A01BCF716B32B0BB14EF</td>\n",
       "      <td>18.36548333</td>\n",
       "      <td>18.36548333</td>\n",
       "      <td>-95.76816111</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343958</th>\n",
       "      <td>087DA3D6472252A2E378F967D3A93668</td>\n",
       "      <td>B3DD282212079633E92DF3C0324875BA</td>\n",
       "      <td>20.29388889</td>\n",
       "      <td>20.29388889</td>\n",
       "      <td>-97.95447222</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3914091</th>\n",
       "      <td>610B911D8D0E038C256FD603257187A1</td>\n",
       "      <td>DA1447FF30FD61C9AD8F2B6649B40E17</td>\n",
       "      <td>19.616239</td>\n",
       "      <td>19.616239</td>\n",
       "      <td>-99.185069</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1773778</th>\n",
       "      <td>2BF01A65A36937AA99D5BF8AD2A08861</td>\n",
       "      <td>28CABABBAD2F50824907EC60C888CDBB</td>\n",
       "      <td>Ecatepec</td>\n",
       "      <td>19.646872</td>\n",
       "      <td>-99.064253</td>\n",
       "      <td>a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5766161</th>\n",
       "      <td>8F04A80E33D449266211608331BA5956</td>\n",
       "      <td>92A58414811E50787CC405BFEA92F6FB</td>\n",
       "      <td>Tapalpa</td>\n",
       "      <td>19.938592</td>\n",
       "      <td>-103.761203</td>\n",
       "      <td>p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1888140</th>\n",
       "      <td>2ECC16A151C4A7A41862118BEBCF88AD</td>\n",
       "      <td>E10C811993EAA885CC6D748F54DBF86D</td>\n",
       "      <td>20.08058507</td>\n",
       "      <td>20.08058507</td>\n",
       "      <td>-98.36244971</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5063185</th>\n",
       "      <td>7D8065DD5BDA219A63BC88E25A71A334</td>\n",
       "      <td>CCBCF7C0BC0EAB89C7994EE60DC42F36</td>\n",
       "      <td>16.74158333</td>\n",
       "      <td>16.74158333</td>\n",
       "      <td>-95.09422222</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7987868</th>\n",
       "      <td>C6166C5320397EC35E7DEE68D68A3DF5</td>\n",
       "      <td>2DFB08C64080A68FD9EA6D3A63499E5D</td>\n",
       "      <td>Chicoloapan</td>\n",
       "      <td>19.403225</td>\n",
       "      <td>-98.92703056</td>\n",
       "      <td>a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1297889</th>\n",
       "      <td>200B07CE4822385562279DE447B7D65B</td>\n",
       "      <td>B6F51EAFED48CE129F5B04B8CB9CA65D</td>\n",
       "      <td>Chalco</td>\n",
       "      <td>19.300106</td>\n",
       "      <td>-98.948692</td>\n",
       "      <td>a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126342</th>\n",
       "      <td>0329984128898F61EC5C810477503F76</td>\n",
       "      <td>C781FB3E7B348ADE122E12BEC9DDFAA9</td>\n",
       "      <td>Del</td>\n",
       "      <td>Iztapalapa</td>\n",
       "      <td>19.348417</td>\n",
       "      <td>07:21:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5501298</th>\n",
       "      <td>88766FDDF94C6BCA90EB95484E317A6C</td>\n",
       "      <td>22594217CE3D6AC89D8726096179C263</td>\n",
       "      <td>17.95936486</td>\n",
       "      <td>17.95936486</td>\n",
       "      <td>-102.1992935</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2254670</th>\n",
       "      <td>37E49668D50E585150163D09F743B5ED</td>\n",
       "      <td>FA6A2B6DE8E2AD9545093447402E280F</td>\n",
       "      <td>Garcia</td>\n",
       "      <td>25.79531667</td>\n",
       "      <td>-100.5861944</td>\n",
       "      <td>p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4790393</th>\n",
       "      <td>76C0151DAF6AB2A83CFEEA1B43D90B36</td>\n",
       "      <td>3728EB0A99C8D3E7315F55E738622D07</td>\n",
       "      <td>Del</td>\n",
       "      <td>Iztacalco</td>\n",
       "      <td>19.41575</td>\n",
       "      <td>02:43:31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2983693</th>\n",
       "      <td>49EA31E2309546788D0CE6D7C0F4E773</td>\n",
       "      <td>CA54EEF8F05E3EBC396E7E199ABF2E51</td>\n",
       "      <td>19.27791667</td>\n",
       "      <td>19.27791667</td>\n",
       "      <td>-99.64430556</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1415998</th>\n",
       "      <td>23011EF1F30F61430EBA19D8E94C907F</td>\n",
       "      <td>FC226C9E0E41CD8482C64077C1047838</td>\n",
       "      <td>Tecamac</td>\n",
       "      <td>19.659722</td>\n",
       "      <td>-99.0065</td>\n",
       "      <td>p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9374483</th>\n",
       "      <td>E8560717CA742FC01302FDEE207953A1</td>\n",
       "      <td>EE571D150C358B01A191A1EE1FF34373</td>\n",
       "      <td>Torreon</td>\n",
       "      <td>25.53583333</td>\n",
       "      <td>-103.4475</td>\n",
       "      <td>p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4547544</th>\n",
       "      <td>70CE6245C6489A222D4DF382B7DB431F</td>\n",
       "      <td>C410B5CC6C996CB1DC527869C34B6630</td>\n",
       "      <td>Del</td>\n",
       "      <td>Tlalpan</td>\n",
       "      <td>19.214444</td>\n",
       "      <td>06:27:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4393328</th>\n",
       "      <td>6CF63660B02E83925FE06CD352123C06</td>\n",
       "      <td>18AA70D5A4971A804E7E3BBDE2B18CC2</td>\n",
       "      <td>20.191028</td>\n",
       "      <td>20.191028</td>\n",
       "      <td>-99.272589</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3381154</th>\n",
       "      <td>53DE55B6A697426EDD4F508FA3364428</td>\n",
       "      <td>809F72144746116C32B761C23698871F</td>\n",
       "      <td>Monterrey</td>\n",
       "      <td>25.571069</td>\n",
       "      <td>-100.241078</td>\n",
       "      <td>p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6490624</th>\n",
       "      <td>A0FFAF50D0677D3BFA7939674C2141C2</td>\n",
       "      <td>CC40CEADC4B493E6AD13C7BBCA810415</td>\n",
       "      <td>19.73450556</td>\n",
       "      <td>19.73450556</td>\n",
       "      <td>-98.96965833</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803370</th>\n",
       "      <td>13CEE8267C0C192C4CE9DAA70D8EBCD1</td>\n",
       "      <td>513AA9AD47020D86C80D1B91CBE59CAB</td>\n",
       "      <td>Del</td>\n",
       "      <td>Xochimilco</td>\n",
       "      <td>19.26392879</td>\n",
       "      <td>11:01:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2659971</th>\n",
       "      <td>41DF84343B61DA9D73324C7C9D531FAF</td>\n",
       "      <td>8D6ADFABA3D9048E6211FC279B4A4C32</td>\n",
       "      <td>Teziutlan</td>\n",
       "      <td>19.785</td>\n",
       "      <td>-97.3502</td>\n",
       "      <td>p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6417289</th>\n",
       "      <td>9F2117B8A06156853D64026754F6D5AB</td>\n",
       "      <td>D5083C117D8E553292E30CF3FBB79869</td>\n",
       "      <td>Lerma</td>\n",
       "      <td>19.32868333</td>\n",
       "      <td>-99.46083333</td>\n",
       "      <td>a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1492869</th>\n",
       "      <td>24E9332FED923CD594D7AFD2B9A8E11C</td>\n",
       "      <td>34FE3C050A760E8BBDA12F32333E9CF4</td>\n",
       "      <td>19.66879444</td>\n",
       "      <td>19.66879444</td>\n",
       "      <td>-99.08935833</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1188063</th>\n",
       "      <td>1D4EDB4574509F0C88F4A20872AD3E7B</td>\n",
       "      <td>6FA5B37E92117A5BB7A05A8A2902A4A3</td>\n",
       "      <td>19.49283333</td>\n",
       "      <td>19.49283333</td>\n",
       "      <td>-99.12143889</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8640677</th>\n",
       "      <td>D63DFB55B54E3CD88C2FA0D3C4027011</td>\n",
       "      <td>C16F0B9D52691C82FE9EA7FDC31D427B</td>\n",
       "      <td>Villa</td>\n",
       "      <td>Hermosa</td>\n",
       "      <td>17.97645389</td>\n",
       "      <td>04:58:31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4711204</th>\n",
       "      <td>74D4C2EB2AE93CEADE42F37F938B5E57</td>\n",
       "      <td>5C0CC6FB8713A555DB00B36757BC365A</td>\n",
       "      <td>San</td>\n",
       "      <td>Luis</td>\n",
       "      <td>Potosi</td>\n",
       "      <td>03/03/2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3373567</th>\n",
       "      <td>53AB81F5256C056E2B49714653845A29</td>\n",
       "      <td>6FCE303B2DCA40C410DA3EFFC07A0F16</td>\n",
       "      <td>20.1174</td>\n",
       "      <td>20.1174</td>\n",
       "      <td>-98.3413</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2469368</th>\n",
       "      <td>3D38FBF697D2D5CE5633C99E9EE20196</td>\n",
       "      <td>22E075A23B3FA7F2BCCB7E49EFFC748A</td>\n",
       "      <td>17.0549223</td>\n",
       "      <td>17.0549223</td>\n",
       "      <td>-96.71952477</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221979</th>\n",
       "      <td>0584529E3DD449979F9CC526DAC543E8</td>\n",
       "      <td>87443B88E047EC6016C013440BAAB066</td>\n",
       "      <td>Nicolas</td>\n",
       "      <td>Romero</td>\n",
       "      <td>19.60333056</td>\n",
       "      <td>07:53:35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3072894</th>\n",
       "      <td>4C2ACBA13DCB568A7E61EBCA7061C8B9</td>\n",
       "      <td>820A48EE55F1DB3033F72E3AF3E376F7</td>\n",
       "      <td>Cuautitlan</td>\n",
       "      <td>Izcalli</td>\n",
       "      <td>19.67105477</td>\n",
       "      <td>10:35:20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1733974</th>\n",
       "      <td>2AF4FBF2F175AF24A499E5C37824FBD1</td>\n",
       "      <td>9D70EB873B5EDFBAEDE1E2D3897ABDB0</td>\n",
       "      <td>Puebla</td>\n",
       "      <td>19.008944</td>\n",
       "      <td>-98.200778</td>\n",
       "      <td>p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3016589</th>\n",
       "      <td>4AC222B0ECE66BD65F6594DE518B4A49</td>\n",
       "      <td>BEAFD0FF200EBBD2C5523EA9742139D6</td>\n",
       "      <td>Del</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>19.432414</td>\n",
       "      <td>11:09:36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1663810</th>\n",
       "      <td>2929ADDFB3DE446FD4CCFB7B6A761A33</td>\n",
       "      <td>7264D0211D3F6F3003D8EE0F0954D457</td>\n",
       "      <td>Del</td>\n",
       "      <td>Alvaro</td>\n",
       "      <td>Obregon</td>\n",
       "      <td>03/03/2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8613089</th>\n",
       "      <td>D588D9847270BC8A83BD854492274C31</td>\n",
       "      <td>99E878DE102E424E5B0B58D2A9CB2371</td>\n",
       "      <td>Del</td>\n",
       "      <td>Miguel</td>\n",
       "      <td>Hidalgo</td>\n",
       "      <td>03/03/2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6920469</th>\n",
       "      <td>AB8A52EAEC0780D25FB80334E0B10DA9</td>\n",
       "      <td>CBD8D7A0E1159AC8B261F4CEB9722588</td>\n",
       "      <td>18.36666667</td>\n",
       "      <td>18.36666667</td>\n",
       "      <td>-100.6819444</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1986625</th>\n",
       "      <td>314578F7ABFA58C427BC0A0136320DAA</td>\n",
       "      <td>4D7854616ACB315F27B0987F7C548D38</td>\n",
       "      <td>19.36683333</td>\n",
       "      <td>19.36683333</td>\n",
       "      <td>-99.09580556</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7241985</th>\n",
       "      <td>B38EF52F39BD1C3E120CE9AC5F34B4E6</td>\n",
       "      <td>6AED162F60E5734517D3A5B7DEE1662B</td>\n",
       "      <td>Naucalpan</td>\n",
       "      <td>19.4941</td>\n",
       "      <td>-99.308</td>\n",
       "      <td>a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6551062</th>\n",
       "      <td>A281580964AF8837E3BDF1CB3EC1E13F</td>\n",
       "      <td>A0190C278083414D9DFDC858AA98D041</td>\n",
       "      <td>16.902194</td>\n",
       "      <td>16.902194</td>\n",
       "      <td>-92.096694</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9524825</th>\n",
       "      <td>EC0E605280A9A6872314638653E5BE9E</td>\n",
       "      <td>3DEFFC0F469A922ADEDEC611C5887A36</td>\n",
       "      <td>Acolman</td>\n",
       "      <td>19.64630556</td>\n",
       "      <td>-98.89138889</td>\n",
       "      <td>p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3259893</th>\n",
       "      <td>50E2183EDEB55825D090100D1D950DB4</td>\n",
       "      <td>F6F4B559BCD0719E99E06E773B48FD1E</td>\n",
       "      <td>Chimalhuacan</td>\n",
       "      <td>19.4308</td>\n",
       "      <td>-98.9581</td>\n",
       "      <td>p.m.</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    Target                       Destination  \\\n",
       "3714794   5C28E3B10F2E5C377BA61A4095700418  C89D73B52F04CF3A18B56E15396D7BF2   \n",
       "1208769   1DD85CC71801A1B48836C01C747FCE54  81A07EB44B8820AB281C99FD8FD2BBD9   \n",
       "5652957   8C3CCB4D8CA3AD3BB481E7BD12E3F727  A41D9AC8E356B84EEC8E24E0F40E27E6   \n",
       "7806954   C190852CF77278E8EB3F95391FF1EDA0  54A28B1DA237B0EBAA2A17C4DD4EB70C   \n",
       "6138282   983ACB6546F8F6BB3F25BC1CF1350A28  A417C47E2BAF014220894E39A233394D   \n",
       "9955551   F6B598A8AA63C8EA4435CABC0C1E6B1B  8F6A45BC5519F981968A47C9DC634AE0   \n",
       "10028510  F881B75551261C0E7ECAB1E9B9630136  B830CDFF47BD68330491B0162A2FBA8A   \n",
       "2339455   39F62DBA070C39B884065AB2DC895FD3  3C3AD6AF30989DF88339A0EE0DDF5C95   \n",
       "1169213   1CDFA83FB2AD2A6AF6E16FE23277A53E  6C22E3691A17816F4A5E7134996BF077   \n",
       "6912701   AB5CCB9B9DB6674149A499BF839BF853  5FCF8AF473C828D4A9B50B2B4064E62A   \n",
       "977859    1822C8C835F186491FCCEC40D12F0238  9C65FDB3C7BCA7C502E4D2E91B922E4B   \n",
       "2670424   42220A9E527C6B98FB1E7CD85CD022E4  80B96E684CEEBCB7C9C022AF168B88E7   \n",
       "6494249   A116890F9C67295CD158D09E4BE2C796  C6E85C4D50DF978511C7099F7D232C32   \n",
       "34968     00DA166C3D058B440D8EFBD89221724B  F7EFA33135DF23ADEAF3A9AC0FD7F22C   \n",
       "2254087   37E196EFC52AE73D1DC35BACF4ACCA04  C2EA29E2921C7A3E9EC435027874C34E   \n",
       "5817016   904D9A0E485D0B33215CCB01069557C6  10FDA01C9255C726F7D0EDBDABCD3CC5   \n",
       "7609214   BCAE109572030AC916C27B422229EF3D  A958DA5C4103B07637816BA6C93D1B19   \n",
       "5583337   8A778ABDDEE40E4FCF8F8410D0249509  792A40E72A23378A801AE602250773AC   \n",
       "1381190   2221C8D875A3067F896F36073ABD83E2  EE8C4D82C541B2520C5B236CFB2EA1BD   \n",
       "7961837   C567E84851EE05FA4E88E7BCE57C77E8  F0BCE58C3275A01BCF716B32B0BB14EF   \n",
       "343958    087DA3D6472252A2E378F967D3A93668  B3DD282212079633E92DF3C0324875BA   \n",
       "3914091   610B911D8D0E038C256FD603257187A1  DA1447FF30FD61C9AD8F2B6649B40E17   \n",
       "1773778   2BF01A65A36937AA99D5BF8AD2A08861  28CABABBAD2F50824907EC60C888CDBB   \n",
       "5766161   8F04A80E33D449266211608331BA5956  92A58414811E50787CC405BFEA92F6FB   \n",
       "1888140   2ECC16A151C4A7A41862118BEBCF88AD  E10C811993EAA885CC6D748F54DBF86D   \n",
       "5063185   7D8065DD5BDA219A63BC88E25A71A334  CCBCF7C0BC0EAB89C7994EE60DC42F36   \n",
       "7987868   C6166C5320397EC35E7DEE68D68A3DF5  2DFB08C64080A68FD9EA6D3A63499E5D   \n",
       "1297889   200B07CE4822385562279DE447B7D65B  B6F51EAFED48CE129F5B04B8CB9CA65D   \n",
       "126342    0329984128898F61EC5C810477503F76  C781FB3E7B348ADE122E12BEC9DDFAA9   \n",
       "5501298   88766FDDF94C6BCA90EB95484E317A6C  22594217CE3D6AC89D8726096179C263   \n",
       "...                                    ...                               ...   \n",
       "2254670   37E49668D50E585150163D09F743B5ED  FA6A2B6DE8E2AD9545093447402E280F   \n",
       "4790393   76C0151DAF6AB2A83CFEEA1B43D90B36  3728EB0A99C8D3E7315F55E738622D07   \n",
       "2983693   49EA31E2309546788D0CE6D7C0F4E773  CA54EEF8F05E3EBC396E7E199ABF2E51   \n",
       "1415998   23011EF1F30F61430EBA19D8E94C907F  FC226C9E0E41CD8482C64077C1047838   \n",
       "9374483   E8560717CA742FC01302FDEE207953A1  EE571D150C358B01A191A1EE1FF34373   \n",
       "4547544   70CE6245C6489A222D4DF382B7DB431F  C410B5CC6C996CB1DC527869C34B6630   \n",
       "4393328   6CF63660B02E83925FE06CD352123C06  18AA70D5A4971A804E7E3BBDE2B18CC2   \n",
       "3381154   53DE55B6A697426EDD4F508FA3364428  809F72144746116C32B761C23698871F   \n",
       "6490624   A0FFAF50D0677D3BFA7939674C2141C2  CC40CEADC4B493E6AD13C7BBCA810415   \n",
       "803370    13CEE8267C0C192C4CE9DAA70D8EBCD1  513AA9AD47020D86C80D1B91CBE59CAB   \n",
       "2659971   41DF84343B61DA9D73324C7C9D531FAF  8D6ADFABA3D9048E6211FC279B4A4C32   \n",
       "6417289   9F2117B8A06156853D64026754F6D5AB  D5083C117D8E553292E30CF3FBB79869   \n",
       "1492869   24E9332FED923CD594D7AFD2B9A8E11C  34FE3C050A760E8BBDA12F32333E9CF4   \n",
       "1188063   1D4EDB4574509F0C88F4A20872AD3E7B  6FA5B37E92117A5BB7A05A8A2902A4A3   \n",
       "8640677   D63DFB55B54E3CD88C2FA0D3C4027011  C16F0B9D52691C82FE9EA7FDC31D427B   \n",
       "4711204   74D4C2EB2AE93CEADE42F37F938B5E57  5C0CC6FB8713A555DB00B36757BC365A   \n",
       "3373567   53AB81F5256C056E2B49714653845A29  6FCE303B2DCA40C410DA3EFFC07A0F16   \n",
       "2469368   3D38FBF697D2D5CE5633C99E9EE20196  22E075A23B3FA7F2BCCB7E49EFFC748A   \n",
       "221979    0584529E3DD449979F9CC526DAC543E8  87443B88E047EC6016C013440BAAB066   \n",
       "3072894   4C2ACBA13DCB568A7E61EBCA7061C8B9  820A48EE55F1DB3033F72E3AF3E376F7   \n",
       "1733974   2AF4FBF2F175AF24A499E5C37824FBD1  9D70EB873B5EDFBAEDE1E2D3897ABDB0   \n",
       "3016589   4AC222B0ECE66BD65F6594DE518B4A49  BEAFD0FF200EBBD2C5523EA9742139D6   \n",
       "1663810   2929ADDFB3DE446FD4CCFB7B6A761A33  7264D0211D3F6F3003D8EE0F0954D457   \n",
       "8613089   D588D9847270BC8A83BD854492274C31  99E878DE102E424E5B0B58D2A9CB2371   \n",
       "6920469   AB8A52EAEC0780D25FB80334E0B10DA9  CBD8D7A0E1159AC8B261F4CEB9722588   \n",
       "1986625   314578F7ABFA58C427BC0A0136320DAA  4D7854616ACB315F27B0987F7C548D38   \n",
       "7241985   B38EF52F39BD1C3E120CE9AC5F34B4E6  6AED162F60E5734517D3A5B7DEE1662B   \n",
       "6551062   A281580964AF8837E3BDF1CB3EC1E13F  A0190C278083414D9DFDC858AA98D041   \n",
       "9524825   EC0E605280A9A6872314638653E5BE9E  3DEFFC0F469A922ADEDEC611C5887A36   \n",
       "3259893   50E2183EDEB55825D090100D1D950DB4  F6F4B559BCD0719E99E06E773B48FD1E   \n",
       "\n",
       "                  City     Latitude     Longitude       Date3  \n",
       "3714794            Del       Miguel       Hidalgo  04/03/2015  \n",
       "1208769            Del      Tlahuac     19.295068    05:45:58  \n",
       "5652957      20.023511    20.023511      -98.8413         NaN  \n",
       "7806954         Salina         Cruz       16.1897    01:20:41  \n",
       "6138282   Chimalhuacan      19.3865    -98.914194        p.m.  \n",
       "9955551            Del    Iztacalco      19.38847    10:36:46  \n",
       "10028510   19.42677799  19.42677799  -99.10868169         NaN  \n",
       "2339455    18.95805556  18.95805556  -98.23888889         NaN  \n",
       "1169213            Del   Venustiano      Carranza  04/03/2015  \n",
       "6912701    17.46747222  17.46747222  -97.21580556         NaN  \n",
       "977859         Temoaya  19.46221111  -99.59683056        p.m.  \n",
       "2670424    19.36570556  19.36570556  -99.19762222         NaN  \n",
       "6494249         Tepeji          del           Rio  03/03/2015  \n",
       "34968              Del       Miguel       Hidalgo  03/03/2015  \n",
       "2254087    17.85156525  17.85156525  -97.82741882         NaN  \n",
       "5817016    19.81722222  19.81722222  -97.35833333         NaN  \n",
       "7609214        Dolores      Hidalgo       21.1622    06:56:52  \n",
       "5583337    18.97655556  18.97655556  -97.79766667         NaN  \n",
       "1381190       Ecatepec  19.52527778  -99.07316667        p.m.  \n",
       "7961837    18.36548333  18.36548333  -95.76816111         NaN  \n",
       "343958     20.29388889  20.29388889  -97.95447222         NaN  \n",
       "3914091      19.616239    19.616239    -99.185069         NaN  \n",
       "1773778       Ecatepec    19.646872    -99.064253        a.m.  \n",
       "5766161        Tapalpa    19.938592   -103.761203        p.m.  \n",
       "1888140    20.08058507  20.08058507  -98.36244971         NaN  \n",
       "5063185    16.74158333  16.74158333  -95.09422222         NaN  \n",
       "7987868    Chicoloapan    19.403225  -98.92703056        a.m.  \n",
       "1297889         Chalco    19.300106    -98.948692        a.m.  \n",
       "126342             Del   Iztapalapa     19.348417    07:21:29  \n",
       "5501298    17.95936486  17.95936486  -102.1992935         NaN  \n",
       "...                ...          ...           ...         ...  \n",
       "2254670         Garcia  25.79531667  -100.5861944        p.m.  \n",
       "4790393            Del    Iztacalco      19.41575    02:43:31  \n",
       "2983693    19.27791667  19.27791667  -99.64430556         NaN  \n",
       "1415998        Tecamac    19.659722      -99.0065        p.m.  \n",
       "9374483        Torreon  25.53583333     -103.4475        p.m.  \n",
       "4547544            Del      Tlalpan     19.214444    06:27:52  \n",
       "4393328      20.191028    20.191028    -99.272589         NaN  \n",
       "3381154      Monterrey    25.571069   -100.241078        p.m.  \n",
       "6490624    19.73450556  19.73450556  -98.96965833         NaN  \n",
       "803370             Del   Xochimilco   19.26392879    11:01:21  \n",
       "2659971      Teziutlan       19.785      -97.3502        p.m.  \n",
       "6417289          Lerma  19.32868333  -99.46083333        a.m.  \n",
       "1492869    19.66879444  19.66879444  -99.08935833         NaN  \n",
       "1188063    19.49283333  19.49283333  -99.12143889         NaN  \n",
       "8640677          Villa      Hermosa   17.97645389    04:58:31  \n",
       "4711204            San         Luis        Potosi  03/03/2015  \n",
       "3373567        20.1174      20.1174      -98.3413         NaN  \n",
       "2469368     17.0549223   17.0549223  -96.71952477         NaN  \n",
       "221979         Nicolas       Romero   19.60333056    07:53:35  \n",
       "3072894     Cuautitlan      Izcalli   19.67105477    10:35:20  \n",
       "1733974         Puebla    19.008944    -98.200778        p.m.  \n",
       "3016589            Del   Cuauhtemoc     19.432414    11:09:36  \n",
       "1663810            Del       Alvaro       Obregon  03/03/2015  \n",
       "8613089            Del       Miguel       Hidalgo  03/03/2015  \n",
       "6920469    18.36666667  18.36666667  -100.6819444         NaN  \n",
       "1986625    19.36683333  19.36683333  -99.09580556         NaN  \n",
       "7241985      Naucalpan      19.4941       -99.308        a.m.  \n",
       "6551062      16.902194    16.902194    -92.096694         NaN  \n",
       "9524825        Acolman  19.64630556  -98.89138889        p.m.  \n",
       "3259893   Chimalhuacan      19.4308      -98.9581        p.m.  \n",
       "\n",
       "[100 rows x 6 columns]"
      ]
     },
     "execution_count": 130,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tabla_mensual.sample(100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'UNEFON'"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "try: \n",
    "    int(buff2.loc[10328051].City)\n",
    "except\"\"   "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {
    "collapsed": false,
    "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>Target</th>\n",
       "      <th>Destination</th>\n",
       "      <th>City</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Date3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>00000C5D3BFBEBD919F6F68386C3DD5E</td>\n",
       "      <td>0A8D39BFACCA596573FA1371E02A4EF2</td>\n",
       "      <td>15.85830556</td>\n",
       "      <td>-97.04511111</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>000011F2BE4C5E7D456026CD791185B3</td>\n",
       "      <td>00F0D512BCD00EC7B9C666ECA0B645C3</td>\n",
       "      <td>Mexicali</td>\n",
       "      <td>32.574342</td>\n",
       "      <td>-115.352511</td>\n",
       "      <td>p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>00001228A0D38FB8D81365EDAB963130</td>\n",
       "      <td>106BD5A02DE8DADBE6DAF2E82EED04DE</td>\n",
       "      <td>20.73645278</td>\n",
       "      <td>-103.4314972</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0000129F4191FFD0963774D2307C7510</td>\n",
       "      <td>B55022400C295828668E644CFDA58425</td>\n",
       "      <td>Tehuacan</td>\n",
       "      <td>18.45369522</td>\n",
       "      <td>-97.40105726</td>\n",
       "      <td>p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0000129F4191FFD0963774D2307C7510</td>\n",
       "      <td>D3E9BDC02EF826B7BB9E01B6F3EC00BC</td>\n",
       "      <td>18.4889</td>\n",
       "      <td>-97.3836</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Target                       Destination  \\\n",
       "0  00000C5D3BFBEBD919F6F68386C3DD5E  0A8D39BFACCA596573FA1371E02A4EF2   \n",
       "1  000011F2BE4C5E7D456026CD791185B3  00F0D512BCD00EC7B9C666ECA0B645C3   \n",
       "2  00001228A0D38FB8D81365EDAB963130  106BD5A02DE8DADBE6DAF2E82EED04DE   \n",
       "3  0000129F4191FFD0963774D2307C7510  B55022400C295828668E644CFDA58425   \n",
       "4  0000129F4191FFD0963774D2307C7510  D3E9BDC02EF826B7BB9E01B6F3EC00BC   \n",
       "\n",
       "          City      Latitude     Longitude Date3  \n",
       "0  15.85830556  -97.04511111           NaN   NaN  \n",
       "1     Mexicali     32.574342   -115.352511  p.m.  \n",
       "2  20.73645278  -103.4314972           NaN   NaN  \n",
       "3     Tehuacan   18.45369522  -97.40105726  p.m.  \n",
       "4      18.4889      -97.3836           NaN   NaN  "
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tabla_mensual.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index([u'City', u'Latitude', u'Longitude', u'Operator', u'Date1', u'Date2'], dtype='object')"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tabla_mensual.columns[5:-1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Telefono</th>\n",
       "      <th>Target</th>\n",
       "      <th>Destination</th>\n",
       "      <th>Direction</th>\n",
       "      <th>Duration</th>\n",
       "      <th>City</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Operator</th>\n",
       "      <th>Date1</th>\n",
       "      <th>Date2</th>\n",
       "      <th>Date3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>00000C5D3BFBEBD919F6F68386C3DD5E</td>\n",
       "      <td>00000C5D3BFBEBD919F6F68386C3DD5E</td>\n",
       "      <td>0A8D39BFACCA596573FA1371E02A4EF2</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>116</td>\n",
       "      <td>15.85830556</td>\n",
       "      <td>-97.04511111</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/03/2015</td>\n",
       "      <td>08:16:16</td>\n",
       "      <td>a.m.</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>000011F2BE4C5E7D456026CD791185B3</td>\n",
       "      <td>000011F2BE4C5E7D456026CD791185B3</td>\n",
       "      <td>00F0D512BCD00EC7B9C666ECA0B645C3</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>19</td>\n",
       "      <td>Mexicali</td>\n",
       "      <td>32.574342</td>\n",
       "      <td>-115.352511</td>\n",
       "      <td>UNEFON</td>\n",
       "      <td>04/03/2015</td>\n",
       "      <td>06:05:47</td>\n",
       "      <td>p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>00001228A0D38FB8D81365EDAB963130</td>\n",
       "      <td>00001228A0D38FB8D81365EDAB963130</td>\n",
       "      <td>106BD5A02DE8DADBE6DAF2E82EED04DE</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>187</td>\n",
       "      <td>20.73645278</td>\n",
       "      <td>-103.4314972</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/03/2015</td>\n",
       "      <td>05:05:32</td>\n",
       "      <td>p.m.</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0000129F4191FFD0963774D2307C7510</td>\n",
       "      <td>0000129F4191FFD0963774D2307C7510</td>\n",
       "      <td>B55022400C295828668E644CFDA58425</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>46</td>\n",
       "      <td>Tehuacan</td>\n",
       "      <td>18.45369522</td>\n",
       "      <td>-97.40105726</td>\n",
       "      <td>UNEFON</td>\n",
       "      <td>04/03/2015</td>\n",
       "      <td>02:08:59</td>\n",
       "      <td>p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0000129F4191FFD0963774D2307C7510</td>\n",
       "      <td>0000129F4191FFD0963774D2307C7510</td>\n",
       "      <td>D3E9BDC02EF826B7BB9E01B6F3EC00BC</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>11</td>\n",
       "      <td>18.4889</td>\n",
       "      <td>-97.3836</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/03/2015</td>\n",
       "      <td>01:09:30</td>\n",
       "      <td>p.m.</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Telefono                            Target  \\\n",
       "0  00000C5D3BFBEBD919F6F68386C3DD5E  00000C5D3BFBEBD919F6F68386C3DD5E   \n",
       "1  000011F2BE4C5E7D456026CD791185B3  000011F2BE4C5E7D456026CD791185B3   \n",
       "2  00001228A0D38FB8D81365EDAB963130  00001228A0D38FB8D81365EDAB963130   \n",
       "3  0000129F4191FFD0963774D2307C7510  0000129F4191FFD0963774D2307C7510   \n",
       "4  0000129F4191FFD0963774D2307C7510  0000129F4191FFD0963774D2307C7510   \n",
       "\n",
       "                        Destination Direction Duration         City  \\\n",
       "0  0A8D39BFACCA596573FA1371E02A4EF2  ENTRANTE      116  15.85830556   \n",
       "1  00F0D512BCD00EC7B9C666ECA0B645C3  ENTRANTE       19     Mexicali   \n",
       "2  106BD5A02DE8DADBE6DAF2E82EED04DE  ENTRANTE      187  20.73645278   \n",
       "3  B55022400C295828668E644CFDA58425  ENTRANTE       46     Tehuacan   \n",
       "4  D3E9BDC02EF826B7BB9E01B6F3EC00BC  ENTRANTE       11      18.4889   \n",
       "\n",
       "       Latitude     Longitude    Operator       Date1     Date2 Date3  \n",
       "0  -97.04511111           NaN  04/03/2015    08:16:16      a.m.   NaN  \n",
       "1     32.574342   -115.352511      UNEFON  04/03/2015  06:05:47  p.m.  \n",
       "2  -103.4314972           NaN  03/03/2015    05:05:32      p.m.   NaN  \n",
       "3   18.45369522  -97.40105726      UNEFON  04/03/2015  02:08:59  p.m.  \n",
       "4      -97.3836           NaN  03/03/2015    01:09:30      p.m.   NaN  "
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{nan,\n",
       " 'ALESTRA           ',\n",
       " 'AVANTEL           ',\n",
       " 'AXTEL             ',\n",
       " 'BESTEL            ',\n",
       " 'BESTPHONE         ',\n",
       " 'CABLECOM          ',\n",
       " 'CABLEMAS          ',\n",
       " 'IP MATRIX         ',\n",
       " 'IUSACELL          ',\n",
       " 'IUSATEL           ',\n",
       " 'MARCATELCOM       ',\n",
       " 'MAXCOM            ',\n",
       " 'MEGA CABLE        ',\n",
       " 'MEGACABLE (MCM)   ',\n",
       " 'METRORED          ',\n",
       " 'MOVISTAR          ',\n",
       " 'NO IDENTIFICADO   ',\n",
       " 'OPCOM             ',\n",
       " 'OPERBES           ',\n",
       " 'PROTEL I-NEXT     ',\n",
       " 'PROTELOP          ',\n",
       " 'TELCEL            ',\n",
       " 'TELECABLE         ',\n",
       " 'TELEFONICA        ',\n",
       " 'TELMEX            ',\n",
       " 'TELNOR            ',\n",
       " 'TOTAL PLAY        ',\n",
       " 'UNEFON            '}"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#para ver valores unicos lo transformamos a un conjunto\n",
    "set(tabla.OPERADOR.values)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Obs.\n",
    "* estan cambiadas las columnas ORIGEN y DESTINO \n",
    "* CONTRATO es todo NaNs\n",
    "* OPERADORA y DURACION_SEGUNDOS no aportan info, "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index([u'TELEFONO', u'DESTINO', u'ORIGEN', u'DIRECCION', u'UBICACIONCIUDAD',\n",
       "       u'LATITUD', u'LONGITUD', u'OPERADOR', u'FECHA_LLAMADA'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tabla.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(7860676, 7)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tabla.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "tabla.rename(columns={'ORIGEN': 'DESTINO', 'DESTINO': 'ORIGEN'},inplace=True);\n",
    "#aunque suene extranyo tambien voy a tirar la columna ubicacion/ciudad porque tiene muchos NaNs y \n",
    "#porque solo miro la info a nivel 'departamental'\n",
    "tabla.drop(['CONTRATO','OPERADOR','DURACION_SEGUNDOS','UBICACIONCIUDAD'],axis=1,inplace=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false,
    "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>TELEFONO</th>\n",
       "      <th>DESTINO</th>\n",
       "      <th>ORIGEN</th>\n",
       "      <th>DIRECCION</th>\n",
       "      <th>LATITUD</th>\n",
       "      <th>LONGITUD</th>\n",
       "      <th>FECHA_LLAMADA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0000A5ECB320A23C19A91C515A51F04D</td>\n",
       "      <td>0000A5ECB320A23C19A91C515A51F04D</td>\n",
       "      <td>C2430855E8747E6F08EB709DE21FED58</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 08:09:34 a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0000A5ECB320A23C19A91C515A51F04D</td>\n",
       "      <td>0000A5ECB320A23C19A91C515A51F04D</td>\n",
       "      <td>C2430855E8747E6F08EB709DE21FED58</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 06:06:42 a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0000A5ECB320A23C19A91C515A51F04D</td>\n",
       "      <td>0000A5ECB320A23C19A91C515A51F04D</td>\n",
       "      <td>F687EB84F1786572AF0CC7C4BA1047D8</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 06:03:35 a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>353</th>\n",
       "      <td>0001A6980837058FD3819ED9236C4682</td>\n",
       "      <td>0001A6980837058FD3819ED9236C4682</td>\n",
       "      <td>57A17524BF266EEAA7AA425BDB58EC23</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 06:42:18 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>0001A6980837058FD3819ED9236C4682</td>\n",
       "      <td>0001A6980837058FD3819ED9236C4682</td>\n",
       "      <td>78F6B0001B8E7F3DCCFC573385A2F54D</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 05:19:30 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>0001A6980837058FD3819ED9236C4682</td>\n",
       "      <td>0001A6980837058FD3819ED9236C4682</td>\n",
       "      <td>78F6B0001B8E7F3DCCFC573385A2F54D</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 09:15:42 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <td>0001A6980837058FD3819ED9236C4682</td>\n",
       "      <td>0001A6980837058FD3819ED9236C4682</td>\n",
       "      <td>78F6B0001B8E7F3DCCFC573385A2F54D</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 09:16:47 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>0001A6980837058FD3819ED9236C4682</td>\n",
       "      <td>0001A6980837058FD3819ED9236C4682</td>\n",
       "      <td>78F6B0001B8E7F3DCCFC573385A2F54D</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 09:15:07 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>0001A6980837058FD3819ED9236C4682</td>\n",
       "      <td>0001A6980837058FD3819ED9236C4682</td>\n",
       "      <td>B1475C3F83AA1CC6E5969CED45F6EBE9</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 07:04:33 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>0001B96F3892319D191BCEEAE0AD48DD</td>\n",
       "      <td>0001B96F3892319D191BCEEAE0AD48DD</td>\n",
       "      <td>70C00DE41AB64A5720E59BDB6BE0BC05</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 10:04:14 a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>0002211BBDB2F20A6A3704EE8308E8CD</td>\n",
       "      <td>0002211BBDB2F20A6A3704EE8308E8CD</td>\n",
       "      <td>A8008C250D02D658BAD98B685BA8DA11</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 10:35:17 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>0002211BBDB2F20A6A3704EE8308E8CD</td>\n",
       "      <td>0002211BBDB2F20A6A3704EE8308E8CD</td>\n",
       "      <td>C69027AA23CB30894A53C2E96CB500C4</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 04:42:07 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>0002211BBDB2F20A6A3704EE8308E8CD</td>\n",
       "      <td>0002211BBDB2F20A6A3704EE8308E8CD</td>\n",
       "      <td>C69027AA23CB30894A53C2E96CB500C4</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 10:44:19 a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>416</th>\n",
       "      <td>0002211BBDB2F20A6A3704EE8308E8CD</td>\n",
       "      <td>0002211BBDB2F20A6A3704EE8308E8CD</td>\n",
       "      <td>E1ACBE412F93597289567A683D9F0F8A</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 10:40:05 a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>417</th>\n",
       "      <td>0002211BBDB2F20A6A3704EE8308E8CD</td>\n",
       "      <td>0002211BBDB2F20A6A3704EE8308E8CD</td>\n",
       "      <td>E1ACBE412F93597289567A683D9F0F8A</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 02:29:05 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>418</th>\n",
       "      <td>0002211BBDB2F20A6A3704EE8308E8CD</td>\n",
       "      <td>0002211BBDB2F20A6A3704EE8308E8CD</td>\n",
       "      <td>E1ACBE412F93597289567A683D9F0F8A</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 11:15:32 a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419</th>\n",
       "      <td>0002211BBDB2F20A6A3704EE8308E8CD</td>\n",
       "      <td>0002211BBDB2F20A6A3704EE8308E8CD</td>\n",
       "      <td>FAE4219CAE9D8F30B72BCB7BF99A5D3F</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 12:39:23 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>420</th>\n",
       "      <td>0002211BBDB2F20A6A3704EE8308E8CD</td>\n",
       "      <td>0002211BBDB2F20A6A3704EE8308E8CD</td>\n",
       "      <td>FAE4219CAE9D8F30B72BCB7BF99A5D3F</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 08:45:56 a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>00023355F4DA77D8BBA6C2D036AB5A54</td>\n",
       "      <td>00023355F4DA77D8BBA6C2D036AB5A54</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 02:01:23 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>00023355F4DA77D8BBA6C2D036AB5A54</td>\n",
       "      <td>00023355F4DA77D8BBA6C2D036AB5A54</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 01:47:58 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>432</th>\n",
       "      <td>00023355F4DA77D8BBA6C2D036AB5A54</td>\n",
       "      <td>00023355F4DA77D8BBA6C2D036AB5A54</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 01:28:23 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433</th>\n",
       "      <td>00023355F4DA77D8BBA6C2D036AB5A54</td>\n",
       "      <td>00023355F4DA77D8BBA6C2D036AB5A54</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 02:25:21 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>470</th>\n",
       "      <td>000295332E82ABF16A79F7CB0A7B987A</td>\n",
       "      <td>000295332E82ABF16A79F7CB0A7B987A</td>\n",
       "      <td>1F79850EAB29B4FC60BABE17D66E3C1C</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 05:59:15 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>0002A5415C55E5AFC7F6DC8D5CE35DA2</td>\n",
       "      <td>0002A5415C55E5AFC7F6DC8D5CE35DA2</td>\n",
       "      <td>3D2D6AD75153A452E301D4D01C45FFF2</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 09:31:56 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>479</th>\n",
       "      <td>0002A5415C55E5AFC7F6DC8D5CE35DA2</td>\n",
       "      <td>0002A5415C55E5AFC7F6DC8D5CE35DA2</td>\n",
       "      <td>3D2D6AD75153A452E301D4D01C45FFF2</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 07:43:38 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>480</th>\n",
       "      <td>0002A5415C55E5AFC7F6DC8D5CE35DA2</td>\n",
       "      <td>0002A5415C55E5AFC7F6DC8D5CE35DA2</td>\n",
       "      <td>3D2D6AD75153A452E301D4D01C45FFF2</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 06:32:35 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490</th>\n",
       "      <td>0002E8A1E262FEFF4C59EFD4390706BA</td>\n",
       "      <td>0002E8A1E262FEFF4C59EFD4390706BA</td>\n",
       "      <td>263BAA568380C2062565AAD57E05005D</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 07:45:54 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>527</th>\n",
       "      <td>00031FC14B85DA22CFDEE6316F8DCCC8</td>\n",
       "      <td>00031FC14B85DA22CFDEE6316F8DCCC8</td>\n",
       "      <td>6A4A89791A869A7E517B74732F9F56E4</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 07:05:18 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528</th>\n",
       "      <td>00031FC14B85DA22CFDEE6316F8DCCC8</td>\n",
       "      <td>00031FC14B85DA22CFDEE6316F8DCCC8</td>\n",
       "      <td>EB702A93A472C6D7680E4F6DF4B9089B</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 05:22:53 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>529</th>\n",
       "      <td>00031FC14B85DA22CFDEE6316F8DCCC8</td>\n",
       "      <td>00031FC14B85DA22CFDEE6316F8DCCC8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 05:58:30 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860241</th>\n",
       "      <td>FFFD0D44D53EBEF546329ED1414A9D1A</td>\n",
       "      <td>FFFD0D44D53EBEF546329ED1414A9D1A</td>\n",
       "      <td>21612D5F4DB99092B0E8C7B4CDD7AC46</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 02:40:41 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860319</th>\n",
       "      <td>FFFDBE92252414A3966ED9032951551F</td>\n",
       "      <td>FFFDBE92252414A3966ED9032951551F</td>\n",
       "      <td>4504C1C4B938B44060B8FE9D6A29762B</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 06:54:15 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860324</th>\n",
       "      <td>FFFDF8CE915CF7D7ED73B992BD64B52B</td>\n",
       "      <td>FFFDF8CE915CF7D7ED73B992BD64B52B</td>\n",
       "      <td>37072A9B38860B7383661DFBAB0D5E7B</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 03:06:18 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860325</th>\n",
       "      <td>FFFDF8CE915CF7D7ED73B992BD64B52B</td>\n",
       "      <td>FFFDF8CE915CF7D7ED73B992BD64B52B</td>\n",
       "      <td>6EDA1E458ACA5E54AEFDE8C6A43D51BC</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 03:29:50 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860326</th>\n",
       "      <td>FFFDF8CE915CF7D7ED73B992BD64B52B</td>\n",
       "      <td>FFFDF8CE915CF7D7ED73B992BD64B52B</td>\n",
       "      <td>BB69D32ADCA9CB6B0C50BB61B7438A8D</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 03:27:09 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860327</th>\n",
       "      <td>FFFDF8CE915CF7D7ED73B992BD64B52B</td>\n",
       "      <td>FFFDF8CE915CF7D7ED73B992BD64B52B</td>\n",
       "      <td>BB69D32ADCA9CB6B0C50BB61B7438A8D</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 03:27:35 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860328</th>\n",
       "      <td>FFFDF8CE915CF7D7ED73B992BD64B52B</td>\n",
       "      <td>FFFDF8CE915CF7D7ED73B992BD64B52B</td>\n",
       "      <td>BB69D32ADCA9CB6B0C50BB61B7438A8D</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 04:10:07 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860423</th>\n",
       "      <td>FFFE660BA1556BA6D79ED1DB7760D526</td>\n",
       "      <td>FFFE660BA1556BA6D79ED1DB7760D526</td>\n",
       "      <td>A01C179EF6A82AB129B7F242CC8BB9B3</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 03:59:37 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860424</th>\n",
       "      <td>FFFE660BA1556BA6D79ED1DB7760D526</td>\n",
       "      <td>FFFE660BA1556BA6D79ED1DB7760D526</td>\n",
       "      <td>A01C179EF6A82AB129B7F242CC8BB9B3</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 12:57:14 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860425</th>\n",
       "      <td>FFFE660BA1556BA6D79ED1DB7760D526</td>\n",
       "      <td>FFFE660BA1556BA6D79ED1DB7760D526</td>\n",
       "      <td>A01C179EF6A82AB129B7F242CC8BB9B3</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 12:36:37 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860426</th>\n",
       "      <td>FFFE660BA1556BA6D79ED1DB7760D526</td>\n",
       "      <td>FFFE660BA1556BA6D79ED1DB7760D526</td>\n",
       "      <td>A01C179EF6A82AB129B7F242CC8BB9B3</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 08:05:34 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860440</th>\n",
       "      <td>FFFE716B5E9C5CC510070D18C4A55C98</td>\n",
       "      <td>FFFE716B5E9C5CC510070D18C4A55C98</td>\n",
       "      <td>54AF537CC169DD0205EC89FA6BC99BC8</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 08:31:50 a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860494</th>\n",
       "      <td>FFFEC70310DA005F7E2FA736D616F569</td>\n",
       "      <td>FFFEC70310DA005F7E2FA736D616F569</td>\n",
       "      <td>219BDC99567AB0B630974C31C23085A8</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 10:54:58 a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860495</th>\n",
       "      <td>FFFEC70310DA005F7E2FA736D616F569</td>\n",
       "      <td>FFFEC70310DA005F7E2FA736D616F569</td>\n",
       "      <td>4F42F318DBD36CD6CF918325D98A1416</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 07:49:18 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860496</th>\n",
       "      <td>FFFEC70310DA005F7E2FA736D616F569</td>\n",
       "      <td>FFFEC70310DA005F7E2FA736D616F569</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 03:19:29 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860497</th>\n",
       "      <td>FFFEC70310DA005F7E2FA736D616F569</td>\n",
       "      <td>FFFEC70310DA005F7E2FA736D616F569</td>\n",
       "      <td>F3E3785ACAA1527242636538A0847B62</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 07:14:05 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860504</th>\n",
       "      <td>FFFECFF52CCC9286B78526C93F23DB0B</td>\n",
       "      <td>FFFECFF52CCC9286B78526C93F23DB0B</td>\n",
       "      <td>0487FD97D0BEA2B125E62C15BEA041D4</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 06:31:25 a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860505</th>\n",
       "      <td>FFFECFF52CCC9286B78526C93F23DB0B</td>\n",
       "      <td>FFFECFF52CCC9286B78526C93F23DB0B</td>\n",
       "      <td>A89EEA2762B88B31D4010AC73C16126F</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 05:33:48 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860506</th>\n",
       "      <td>FFFECFF52CCC9286B78526C93F23DB0B</td>\n",
       "      <td>FFFECFF52CCC9286B78526C93F23DB0B</td>\n",
       "      <td>A89EEA2762B88B31D4010AC73C16126F</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 04:44:37 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860515</th>\n",
       "      <td>FFFF0A10CE4748318A582A84F3D094F8</td>\n",
       "      <td>FFFF0A10CE4748318A582A84F3D094F8</td>\n",
       "      <td>D4F8CC7491DCD9382AAEE4F637309B03</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 10:04:50 a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860577</th>\n",
       "      <td>FFFF3BE176391DC4EE6C13C1BCC5695B</td>\n",
       "      <td>FFFF3BE176391DC4EE6C13C1BCC5695B</td>\n",
       "      <td>BC9E1571316E00522E2FD09224DCD8C3</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 06:58:54 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860578</th>\n",
       "      <td>FFFF3BE176391DC4EE6C13C1BCC5695B</td>\n",
       "      <td>FFFF3BE176391DC4EE6C13C1BCC5695B</td>\n",
       "      <td>BC9E1571316E00522E2FD09224DCD8C3</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 01:13:54 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860579</th>\n",
       "      <td>FFFF3BE176391DC4EE6C13C1BCC5695B</td>\n",
       "      <td>FFFF3BE176391DC4EE6C13C1BCC5695B</td>\n",
       "      <td>BC9E1571316E00522E2FD09224DCD8C3</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 03:46:43 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860580</th>\n",
       "      <td>FFFF3BE176391DC4EE6C13C1BCC5695B</td>\n",
       "      <td>FFFF3BE176391DC4EE6C13C1BCC5695B</td>\n",
       "      <td>BC9E1571316E00522E2FD09224DCD8C3</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 05:56:12 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860628</th>\n",
       "      <td>FFFF760400C57144ECDA0173FD7DD3DD</td>\n",
       "      <td>FFFF760400C57144ECDA0173FD7DD3DD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 10:10:52 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860641</th>\n",
       "      <td>FFFFB78860929E6E313B95C0278B3F56</td>\n",
       "      <td>FFFFB78860929E6E313B95C0278B3F56</td>\n",
       "      <td>95FF9642B3AD21E46720891300F076F6</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 02:29:21 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860667</th>\n",
       "      <td>FFFFE69BC4BE1B244AC2FD2D2533D178</td>\n",
       "      <td>FFFFE69BC4BE1B244AC2FD2D2533D178</td>\n",
       "      <td>85CA631EA4D58AE54845C0C64829F568</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 09:08:27 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860673</th>\n",
       "      <td>FFFFF366B5C239EFC72E7315BA26F087</td>\n",
       "      <td>FFFFF366B5C239EFC72E7315BA26F087</td>\n",
       "      <td>03B588FBC57816D14388C6C1B6D6C0E1</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 08:56:26 p.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860674</th>\n",
       "      <td>FFFFF366B5C239EFC72E7315BA26F087</td>\n",
       "      <td>FFFFF366B5C239EFC72E7315BA26F087</td>\n",
       "      <td>A1504D2D8C5AD547C307A538EBDFAD97</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2015 10:11:16 a.m.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860675</th>\n",
       "      <td>FFFFF366B5C239EFC72E7315BA26F087</td>\n",
       "      <td>FFFFF366B5C239EFC72E7315BA26F087</td>\n",
       "      <td>FBC66696DFEF224A00392173BD45A8B2</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2015 03:28:02 p.m.</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>662873 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 TELEFONO                           DESTINO  \\\n",
       "26       0000A5ECB320A23C19A91C515A51F04D  0000A5ECB320A23C19A91C515A51F04D   \n",
       "27       0000A5ECB320A23C19A91C515A51F04D  0000A5ECB320A23C19A91C515A51F04D   \n",
       "28       0000A5ECB320A23C19A91C515A51F04D  0000A5ECB320A23C19A91C515A51F04D   \n",
       "353      0001A6980837058FD3819ED9236C4682  0001A6980837058FD3819ED9236C4682   \n",
       "354      0001A6980837058FD3819ED9236C4682  0001A6980837058FD3819ED9236C4682   \n",
       "355      0001A6980837058FD3819ED9236C4682  0001A6980837058FD3819ED9236C4682   \n",
       "356      0001A6980837058FD3819ED9236C4682  0001A6980837058FD3819ED9236C4682   \n",
       "357      0001A6980837058FD3819ED9236C4682  0001A6980837058FD3819ED9236C4682   \n",
       "358      0001A6980837058FD3819ED9236C4682  0001A6980837058FD3819ED9236C4682   \n",
       "362      0001B96F3892319D191BCEEAE0AD48DD  0001B96F3892319D191BCEEAE0AD48DD   \n",
       "413      0002211BBDB2F20A6A3704EE8308E8CD  0002211BBDB2F20A6A3704EE8308E8CD   \n",
       "414      0002211BBDB2F20A6A3704EE8308E8CD  0002211BBDB2F20A6A3704EE8308E8CD   \n",
       "415      0002211BBDB2F20A6A3704EE8308E8CD  0002211BBDB2F20A6A3704EE8308E8CD   \n",
       "416      0002211BBDB2F20A6A3704EE8308E8CD  0002211BBDB2F20A6A3704EE8308E8CD   \n",
       "417      0002211BBDB2F20A6A3704EE8308E8CD  0002211BBDB2F20A6A3704EE8308E8CD   \n",
       "418      0002211BBDB2F20A6A3704EE8308E8CD  0002211BBDB2F20A6A3704EE8308E8CD   \n",
       "419      0002211BBDB2F20A6A3704EE8308E8CD  0002211BBDB2F20A6A3704EE8308E8CD   \n",
       "420      0002211BBDB2F20A6A3704EE8308E8CD  0002211BBDB2F20A6A3704EE8308E8CD   \n",
       "430      00023355F4DA77D8BBA6C2D036AB5A54  00023355F4DA77D8BBA6C2D036AB5A54   \n",
       "431      00023355F4DA77D8BBA6C2D036AB5A54  00023355F4DA77D8BBA6C2D036AB5A54   \n",
       "432      00023355F4DA77D8BBA6C2D036AB5A54  00023355F4DA77D8BBA6C2D036AB5A54   \n",
       "433      00023355F4DA77D8BBA6C2D036AB5A54  00023355F4DA77D8BBA6C2D036AB5A54   \n",
       "470      000295332E82ABF16A79F7CB0A7B987A  000295332E82ABF16A79F7CB0A7B987A   \n",
       "478      0002A5415C55E5AFC7F6DC8D5CE35DA2  0002A5415C55E5AFC7F6DC8D5CE35DA2   \n",
       "479      0002A5415C55E5AFC7F6DC8D5CE35DA2  0002A5415C55E5AFC7F6DC8D5CE35DA2   \n",
       "480      0002A5415C55E5AFC7F6DC8D5CE35DA2  0002A5415C55E5AFC7F6DC8D5CE35DA2   \n",
       "490      0002E8A1E262FEFF4C59EFD4390706BA  0002E8A1E262FEFF4C59EFD4390706BA   \n",
       "527      00031FC14B85DA22CFDEE6316F8DCCC8  00031FC14B85DA22CFDEE6316F8DCCC8   \n",
       "528      00031FC14B85DA22CFDEE6316F8DCCC8  00031FC14B85DA22CFDEE6316F8DCCC8   \n",
       "529      00031FC14B85DA22CFDEE6316F8DCCC8  00031FC14B85DA22CFDEE6316F8DCCC8   \n",
       "...                                   ...                               ...   \n",
       "7860241  FFFD0D44D53EBEF546329ED1414A9D1A  FFFD0D44D53EBEF546329ED1414A9D1A   \n",
       "7860319  FFFDBE92252414A3966ED9032951551F  FFFDBE92252414A3966ED9032951551F   \n",
       "7860324  FFFDF8CE915CF7D7ED73B992BD64B52B  FFFDF8CE915CF7D7ED73B992BD64B52B   \n",
       "7860325  FFFDF8CE915CF7D7ED73B992BD64B52B  FFFDF8CE915CF7D7ED73B992BD64B52B   \n",
       "7860326  FFFDF8CE915CF7D7ED73B992BD64B52B  FFFDF8CE915CF7D7ED73B992BD64B52B   \n",
       "7860327  FFFDF8CE915CF7D7ED73B992BD64B52B  FFFDF8CE915CF7D7ED73B992BD64B52B   \n",
       "7860328  FFFDF8CE915CF7D7ED73B992BD64B52B  FFFDF8CE915CF7D7ED73B992BD64B52B   \n",
       "7860423  FFFE660BA1556BA6D79ED1DB7760D526  FFFE660BA1556BA6D79ED1DB7760D526   \n",
       "7860424  FFFE660BA1556BA6D79ED1DB7760D526  FFFE660BA1556BA6D79ED1DB7760D526   \n",
       "7860425  FFFE660BA1556BA6D79ED1DB7760D526  FFFE660BA1556BA6D79ED1DB7760D526   \n",
       "7860426  FFFE660BA1556BA6D79ED1DB7760D526  FFFE660BA1556BA6D79ED1DB7760D526   \n",
       "7860440  FFFE716B5E9C5CC510070D18C4A55C98  FFFE716B5E9C5CC510070D18C4A55C98   \n",
       "7860494  FFFEC70310DA005F7E2FA736D616F569  FFFEC70310DA005F7E2FA736D616F569   \n",
       "7860495  FFFEC70310DA005F7E2FA736D616F569  FFFEC70310DA005F7E2FA736D616F569   \n",
       "7860496  FFFEC70310DA005F7E2FA736D616F569  FFFEC70310DA005F7E2FA736D616F569   \n",
       "7860497  FFFEC70310DA005F7E2FA736D616F569  FFFEC70310DA005F7E2FA736D616F569   \n",
       "7860504  FFFECFF52CCC9286B78526C93F23DB0B  FFFECFF52CCC9286B78526C93F23DB0B   \n",
       "7860505  FFFECFF52CCC9286B78526C93F23DB0B  FFFECFF52CCC9286B78526C93F23DB0B   \n",
       "7860506  FFFECFF52CCC9286B78526C93F23DB0B  FFFECFF52CCC9286B78526C93F23DB0B   \n",
       "7860515  FFFF0A10CE4748318A582A84F3D094F8  FFFF0A10CE4748318A582A84F3D094F8   \n",
       "7860577  FFFF3BE176391DC4EE6C13C1BCC5695B  FFFF3BE176391DC4EE6C13C1BCC5695B   \n",
       "7860578  FFFF3BE176391DC4EE6C13C1BCC5695B  FFFF3BE176391DC4EE6C13C1BCC5695B   \n",
       "7860579  FFFF3BE176391DC4EE6C13C1BCC5695B  FFFF3BE176391DC4EE6C13C1BCC5695B   \n",
       "7860580  FFFF3BE176391DC4EE6C13C1BCC5695B  FFFF3BE176391DC4EE6C13C1BCC5695B   \n",
       "7860628  FFFF760400C57144ECDA0173FD7DD3DD  FFFF760400C57144ECDA0173FD7DD3DD   \n",
       "7860641  FFFFB78860929E6E313B95C0278B3F56  FFFFB78860929E6E313B95C0278B3F56   \n",
       "7860667  FFFFE69BC4BE1B244AC2FD2D2533D178  FFFFE69BC4BE1B244AC2FD2D2533D178   \n",
       "7860673  FFFFF366B5C239EFC72E7315BA26F087  FFFFF366B5C239EFC72E7315BA26F087   \n",
       "7860674  FFFFF366B5C239EFC72E7315BA26F087  FFFFF366B5C239EFC72E7315BA26F087   \n",
       "7860675  FFFFF366B5C239EFC72E7315BA26F087  FFFFF366B5C239EFC72E7315BA26F087   \n",
       "\n",
       "                                   ORIGEN DIRECCION  LATITUD  LONGITUD  \\\n",
       "26       C2430855E8747E6F08EB709DE21FED58  ENTRANTE      NaN       NaN   \n",
       "27       C2430855E8747E6F08EB709DE21FED58  ENTRANTE      NaN       NaN   \n",
       "28       F687EB84F1786572AF0CC7C4BA1047D8  ENTRANTE      NaN       NaN   \n",
       "353      57A17524BF266EEAA7AA425BDB58EC23  ENTRANTE      NaN       NaN   \n",
       "354      78F6B0001B8E7F3DCCFC573385A2F54D  ENTRANTE      NaN       NaN   \n",
       "355      78F6B0001B8E7F3DCCFC573385A2F54D  ENTRANTE      NaN       NaN   \n",
       "356      78F6B0001B8E7F3DCCFC573385A2F54D  ENTRANTE      NaN       NaN   \n",
       "357      78F6B0001B8E7F3DCCFC573385A2F54D  ENTRANTE      NaN       NaN   \n",
       "358      B1475C3F83AA1CC6E5969CED45F6EBE9  ENTRANTE      NaN       NaN   \n",
       "362      70C00DE41AB64A5720E59BDB6BE0BC05  ENTRANTE      NaN       NaN   \n",
       "413      A8008C250D02D658BAD98B685BA8DA11  ENTRANTE      NaN       NaN   \n",
       "414      C69027AA23CB30894A53C2E96CB500C4  ENTRANTE      NaN       NaN   \n",
       "415      C69027AA23CB30894A53C2E96CB500C4  ENTRANTE      NaN       NaN   \n",
       "416      E1ACBE412F93597289567A683D9F0F8A  ENTRANTE      NaN       NaN   \n",
       "417      E1ACBE412F93597289567A683D9F0F8A  ENTRANTE      NaN       NaN   \n",
       "418      E1ACBE412F93597289567A683D9F0F8A  ENTRANTE      NaN       NaN   \n",
       "419      FAE4219CAE9D8F30B72BCB7BF99A5D3F  ENTRANTE      NaN       NaN   \n",
       "420      FAE4219CAE9D8F30B72BCB7BF99A5D3F  ENTRANTE      NaN       NaN   \n",
       "430                                   NaN  ENTRANTE      NaN       NaN   \n",
       "431                                   NaN  ENTRANTE      NaN       NaN   \n",
       "432                                   NaN  ENTRANTE      NaN       NaN   \n",
       "433                                   NaN  ENTRANTE      NaN       NaN   \n",
       "470      1F79850EAB29B4FC60BABE17D66E3C1C  ENTRANTE      NaN       NaN   \n",
       "478      3D2D6AD75153A452E301D4D01C45FFF2  ENTRANTE      NaN       NaN   \n",
       "479      3D2D6AD75153A452E301D4D01C45FFF2  ENTRANTE      NaN       NaN   \n",
       "480      3D2D6AD75153A452E301D4D01C45FFF2  ENTRANTE      NaN       NaN   \n",
       "490      263BAA568380C2062565AAD57E05005D  ENTRANTE      NaN       NaN   \n",
       "527      6A4A89791A869A7E517B74732F9F56E4  ENTRANTE      NaN       NaN   \n",
       "528      EB702A93A472C6D7680E4F6DF4B9089B  ENTRANTE      NaN       NaN   \n",
       "529                                   NaN  ENTRANTE      NaN       NaN   \n",
       "...                                   ...       ...      ...       ...   \n",
       "7860241  21612D5F4DB99092B0E8C7B4CDD7AC46  ENTRANTE      NaN       NaN   \n",
       "7860319  4504C1C4B938B44060B8FE9D6A29762B  ENTRANTE      NaN       NaN   \n",
       "7860324  37072A9B38860B7383661DFBAB0D5E7B  ENTRANTE      NaN       NaN   \n",
       "7860325  6EDA1E458ACA5E54AEFDE8C6A43D51BC  ENTRANTE      NaN       NaN   \n",
       "7860326  BB69D32ADCA9CB6B0C50BB61B7438A8D  ENTRANTE      NaN       NaN   \n",
       "7860327  BB69D32ADCA9CB6B0C50BB61B7438A8D  ENTRANTE      NaN       NaN   \n",
       "7860328  BB69D32ADCA9CB6B0C50BB61B7438A8D  ENTRANTE      NaN       NaN   \n",
       "7860423  A01C179EF6A82AB129B7F242CC8BB9B3  ENTRANTE      NaN       NaN   \n",
       "7860424  A01C179EF6A82AB129B7F242CC8BB9B3  ENTRANTE      NaN       NaN   \n",
       "7860425  A01C179EF6A82AB129B7F242CC8BB9B3  ENTRANTE      NaN       NaN   \n",
       "7860426  A01C179EF6A82AB129B7F242CC8BB9B3  ENTRANTE      NaN       NaN   \n",
       "7860440  54AF537CC169DD0205EC89FA6BC99BC8  ENTRANTE      NaN       NaN   \n",
       "7860494  219BDC99567AB0B630974C31C23085A8  ENTRANTE      NaN       NaN   \n",
       "7860495  4F42F318DBD36CD6CF918325D98A1416  ENTRANTE      NaN       NaN   \n",
       "7860496                               NaN  ENTRANTE      NaN       NaN   \n",
       "7860497  F3E3785ACAA1527242636538A0847B62  ENTRANTE      NaN       NaN   \n",
       "7860504  0487FD97D0BEA2B125E62C15BEA041D4  ENTRANTE      NaN       NaN   \n",
       "7860505  A89EEA2762B88B31D4010AC73C16126F  ENTRANTE      NaN       NaN   \n",
       "7860506  A89EEA2762B88B31D4010AC73C16126F  ENTRANTE      NaN       NaN   \n",
       "7860515  D4F8CC7491DCD9382AAEE4F637309B03  ENTRANTE      NaN       NaN   \n",
       "7860577  BC9E1571316E00522E2FD09224DCD8C3  ENTRANTE      NaN       NaN   \n",
       "7860578  BC9E1571316E00522E2FD09224DCD8C3  ENTRANTE      NaN       NaN   \n",
       "7860579  BC9E1571316E00522E2FD09224DCD8C3  ENTRANTE      NaN       NaN   \n",
       "7860580  BC9E1571316E00522E2FD09224DCD8C3  ENTRANTE      NaN       NaN   \n",
       "7860628                               NaN  ENTRANTE      NaN       NaN   \n",
       "7860641  95FF9642B3AD21E46720891300F076F6  ENTRANTE      NaN       NaN   \n",
       "7860667  85CA631EA4D58AE54845C0C64829F568  ENTRANTE      NaN       NaN   \n",
       "7860673  03B588FBC57816D14388C6C1B6D6C0E1  ENTRANTE      NaN       NaN   \n",
       "7860674  A1504D2D8C5AD547C307A538EBDFAD97  ENTRANTE      NaN       NaN   \n",
       "7860675  FBC66696DFEF224A00392173BD45A8B2  ENTRANTE      NaN       NaN   \n",
       "\n",
       "                    FECHA_LLAMADA  \n",
       "26       03/01/2015 08:09:34 a.m.  \n",
       "27       03/01/2015 06:06:42 a.m.  \n",
       "28       03/01/2015 06:03:35 a.m.  \n",
       "353      03/01/2015 06:42:18 p.m.  \n",
       "354      04/01/2015 05:19:30 p.m.  \n",
       "355      04/01/2015 09:15:42 p.m.  \n",
       "356      04/01/2015 09:16:47 p.m.  \n",
       "357      04/01/2015 09:15:07 p.m.  \n",
       "358      03/01/2015 07:04:33 p.m.  \n",
       "362      04/01/2015 10:04:14 a.m.  \n",
       "413      03/01/2015 10:35:17 p.m.  \n",
       "414      03/01/2015 04:42:07 p.m.  \n",
       "415      03/01/2015 10:44:19 a.m.  \n",
       "416      04/01/2015 10:40:05 a.m.  \n",
       "417      03/01/2015 02:29:05 p.m.  \n",
       "418      03/01/2015 11:15:32 a.m.  \n",
       "419      04/01/2015 12:39:23 p.m.  \n",
       "420      04/01/2015 08:45:56 a.m.  \n",
       "430      04/01/2015 02:01:23 p.m.  \n",
       "431      04/01/2015 01:47:58 p.m.  \n",
       "432      04/01/2015 01:28:23 p.m.  \n",
       "433      04/01/2015 02:25:21 p.m.  \n",
       "470      04/01/2015 05:59:15 p.m.  \n",
       "478      04/01/2015 09:31:56 p.m.  \n",
       "479      03/01/2015 07:43:38 p.m.  \n",
       "480      04/01/2015 06:32:35 p.m.  \n",
       "490      04/01/2015 07:45:54 p.m.  \n",
       "527      04/01/2015 07:05:18 p.m.  \n",
       "528      04/01/2015 05:22:53 p.m.  \n",
       "529      03/01/2015 05:58:30 p.m.  \n",
       "...                           ...  \n",
       "7860241  03/01/2015 02:40:41 p.m.  \n",
       "7860319  03/01/2015 06:54:15 p.m.  \n",
       "7860324  04/01/2015 03:06:18 p.m.  \n",
       "7860325  03/01/2015 03:29:50 p.m.  \n",
       "7860326  04/01/2015 03:27:09 p.m.  \n",
       "7860327  04/01/2015 03:27:35 p.m.  \n",
       "7860328  03/01/2015 04:10:07 p.m.  \n",
       "7860423  03/01/2015 03:59:37 p.m.  \n",
       "7860424  03/01/2015 12:57:14 p.m.  \n",
       "7860425  03/01/2015 12:36:37 p.m.  \n",
       "7860426  04/01/2015 08:05:34 p.m.  \n",
       "7860440  03/01/2015 08:31:50 a.m.  \n",
       "7860494  03/01/2015 10:54:58 a.m.  \n",
       "7860495  03/01/2015 07:49:18 p.m.  \n",
       "7860496  04/01/2015 03:19:29 p.m.  \n",
       "7860497  03/01/2015 07:14:05 p.m.  \n",
       "7860504  04/01/2015 06:31:25 a.m.  \n",
       "7860505  04/01/2015 05:33:48 p.m.  \n",
       "7860506  03/01/2015 04:44:37 p.m.  \n",
       "7860515  04/01/2015 10:04:50 a.m.  \n",
       "7860577  04/01/2015 06:58:54 p.m.  \n",
       "7860578  03/01/2015 01:13:54 p.m.  \n",
       "7860579  03/01/2015 03:46:43 p.m.  \n",
       "7860580  04/01/2015 05:56:12 p.m.  \n",
       "7860628  04/01/2015 10:10:52 p.m.  \n",
       "7860641  03/01/2015 02:29:21 p.m.  \n",
       "7860667  04/01/2015 09:08:27 p.m.  \n",
       "7860673  03/01/2015 08:56:26 p.m.  \n",
       "7860674  03/01/2015 10:11:16 a.m.  \n",
       "7860675  04/01/2015 03:28:02 p.m.  \n",
       "\n",
       "[662873 rows x 7 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#chequeo si hay info faltante\n",
    "tabla[pd.isnull(tabla).any(axis=1)]\n",
    "#resulta que hay como 600k de casi 8M"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "tabla.dropna(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "tabla2 = pd.read_csv(\"datosgeo/Prepago/Geo_Voz_Prepago_01-020115.txt.gz\",sep=\"\\t\")\n",
    "tabla2.drop(['CONTRATO','OPERADOR','DURACION_SEGUNDOS','UBICACIONCIUDAD'],axis=1,inplace=True)\n",
    "tabla2.rename(columns={'ORIGEN': 'DESTINO', 'DESTINO': 'ORIGEN'},inplace=True);\n",
    "tabla2.dropna(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample=tabla.ix[random.sample(tabla.index, 3*(10**5))]\n",
    "sample2=tabla2.ix[random.sample(tabla2.index, 3*(10**5))]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "del tabla; del tabla2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sample.index = range(1,len(sample)+1)\n",
    "sample2.index = range(1,len(sample2)+1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'04/01/2015 12:21:05 pm'"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test2=sample.ix[100].FECHA_LLAMADA\n",
    "test2[0:-3]+'m'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import time;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### paso el date a formato epoch"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "sample['FECHA_LLAMADA'] = sample['FECHA_LLAMADA'].map(lambda t: time.mktime(time.strptime(t[0:-3]+'m', \"%d/%m/%Y %I:%M:%S %p\")));\n",
    "sample2['FECHA_LLAMADA'] = sample2['FECHA_LLAMADA'].map(lambda t: time.mktime(time.strptime(t[0:-3]+'m', \"%d/%m/%Y %I:%M:%S %p\")));"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "sample.rename(columns={'FECHA_LLAMADA': 'FECHA_LLAMADA_EPOCH'},inplace=True);\n",
    "sample2.rename(columns={'FECHA_LLAMADA': 'FECHA_LLAMADA_EPOCH'},inplace=True);"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#hago un sort por el FECHA_LLAMADA para ver cuando arranca la base de datos \n",
    "tabla.index = range(1,len(tabla)+1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "tabla['FECHA_LLAMADA'] = tabla['FECHA_LLAMADA'].map(lambda t: time.mktime(time.strptime(t[0:-3]+'m', \"%d/%m/%Y %I:%M:%S %p\")));\n",
    "tabla.rename(columns={'FECHA_LLAMADA': 'FECHA_LLAMADA_EPOCH'},inplace=True);"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "tabla.sort_values(by='FECHA_LLAMADA_EPOCH',ascending=True,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>TELEFONO</th>\n",
       "      <th>DESTINO</th>\n",
       "      <th>ORIGEN</th>\n",
       "      <th>DIRECCION</th>\n",
       "      <th>UBICACIONCIUDAD</th>\n",
       "      <th>LATITUD</th>\n",
       "      <th>LONGITUD</th>\n",
       "      <th>FECHA_LLAMADA_EPOCH</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5015223</th>\n",
       "      <td>DC1F8BC68A6B6D22A7CBD4C9787BD9DB</td>\n",
       "      <td>DC1F8BC68A6B6D22A7CBD4C9787BD9DB</td>\n",
       "      <td>F1BB45B86CC4540E6194D6A28F177825</td>\n",
       "      <td>SALIENTE</td>\n",
       "      <td>Tlalnepantla</td>\n",
       "      <td>19.517500</td>\n",
       "      <td>-99.102500</td>\n",
       "      <td>1420070400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6984754</th>\n",
       "      <td>CBF4C39BE4C0EAC246FCD5D206C5D2E4</td>\n",
       "      <td>CBF4C39BE4C0EAC246FCD5D206C5D2E4</td>\n",
       "      <td>9877CC267054BD7E5871D9D5627FD507</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.966750</td>\n",
       "      <td>-99.247667</td>\n",
       "      <td>1420070400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10363183</th>\n",
       "      <td>E3595DB849B1CD0FC19187317ECA639F</td>\n",
       "      <td>E3595DB849B1CD0FC19187317ECA639F</td>\n",
       "      <td>139AD14F044D03AEE227024E84A615C6</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>Apan</td>\n",
       "      <td>19.710194</td>\n",
       "      <td>-98.448611</td>\n",
       "      <td>1420070400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9821410</th>\n",
       "      <td>76D12717E57C739DB1C2AE5ADA26BC92</td>\n",
       "      <td>76D12717E57C739DB1C2AE5ADA26BC92</td>\n",
       "      <td>30A61DC885EDDEA18B8AB707E5A84321</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>Guadalajara</td>\n",
       "      <td>20.670161</td>\n",
       "      <td>-103.382536</td>\n",
       "      <td>1420070400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6754731</th>\n",
       "      <td>501EF14B895B19BF0F6034C310EF85E0</td>\n",
       "      <td>501EF14B895B19BF0F6034C310EF85E0</td>\n",
       "      <td>2843788532C31620AF795210D4E8D891</td>\n",
       "      <td>ENTRANTE</td>\n",
       "      <td>Xonacatlan</td>\n",
       "      <td>19.405165</td>\n",
       "      <td>-99.521802</td>\n",
       "      <td>1420070400</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  TELEFONO                           DESTINO  \\\n",
       "5015223   DC1F8BC68A6B6D22A7CBD4C9787BD9DB  DC1F8BC68A6B6D22A7CBD4C9787BD9DB   \n",
       "6984754   CBF4C39BE4C0EAC246FCD5D206C5D2E4  CBF4C39BE4C0EAC246FCD5D206C5D2E4   \n",
       "10363183  E3595DB849B1CD0FC19187317ECA639F  E3595DB849B1CD0FC19187317ECA639F   \n",
       "9821410   76D12717E57C739DB1C2AE5ADA26BC92  76D12717E57C739DB1C2AE5ADA26BC92   \n",
       "6754731   501EF14B895B19BF0F6034C310EF85E0  501EF14B895B19BF0F6034C310EF85E0   \n",
       "\n",
       "                                    ORIGEN DIRECCION UBICACIONCIUDAD  \\\n",
       "5015223   F1BB45B86CC4540E6194D6A28F177825  SALIENTE    Tlalnepantla   \n",
       "6984754   9877CC267054BD7E5871D9D5627FD507  ENTRANTE             NaN   \n",
       "10363183  139AD14F044D03AEE227024E84A615C6  ENTRANTE            Apan   \n",
       "9821410   30A61DC885EDDEA18B8AB707E5A84321  ENTRANTE     Guadalajara   \n",
       "6754731   2843788532C31620AF795210D4E8D891  ENTRANTE      Xonacatlan   \n",
       "\n",
       "            LATITUD    LONGITUD  FECHA_LLAMADA_EPOCH  \n",
       "5015223   19.517500  -99.102500           1420070400  \n",
       "6984754   18.966750  -99.247667           1420070400  \n",
       "10363183  19.710194  -98.448611           1420070400  \n",
       "9821410   20.670161 -103.382536           1420070400  \n",
       "6754731   19.405165  -99.521802           1420070400  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tabla.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# *Obs* \n",
    "no veo nada porque aca arranca desde EPOCH... PERO mirando la documentacion del trac resulta que todo esta seteado para arrancar el 01/01/2012 a las 0 horas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": 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.1+"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}