busqueda_users_twitter.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "4d3ca668",
   "metadata": {},
   "outputs": [],
   "source": [
    "!pip install google #si les sale error sobre la libreria googlesearch, deben intalarla"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "40abd6bc",
   "metadata": {},
   "outputs": [],
   "source": [
    "from googlesearch import search\n",
    "from urllib.parse import urlparse\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "fcf2dddf",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Esta es la función que Laura creó para buscar el usuario de Twitter de alguien en google\n",
    "\n",
    "def identify_twitter (nombre):\n",
    "    \n",
    "\n",
    "    query= nombre +\" twitter\"\n",
    "    #print(query)\n",
    "    count=0\n",
    "    username=None\n",
    "    while username is None:\n",
    "        response = search(query, tld=\"co.in\", num=1, stop=1, pause=2)\n",
    "        count+=1\n",
    "        for result in response:\n",
    "            parsed_url=urlparse(result)\n",
    "            if \"twitter\" in parsed_url.hostname:\n",
    "                if \"status\" not in parsed_url.path:\n",
    "                    username=parsed_url.path\n",
    "        if count>=10:\n",
    "            break\n",
    "    return username\n",
    "    print(username,count)\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "20c784b6",
   "metadata": {},
   "source": [
    "Un ejemplo para que sean creativos con la búsqueda"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "36232af3",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Juan Pablo Camacho twitter\n",
      "Juan Pablo Camacho Esperanza twitter\n",
      "/juanpcamachos /jpcamacho79\n"
     ]
    }
   ],
   "source": [
    "\n",
    "\n",
    "solo_nombre=identify_twitter(\"Juan Pablo Camacho\")\n",
    "nombre_partido=identify_twitter(\"Juan Pablo Camacho Esperanza\")\n",
    "\n",
    "print(solo_nombre, nombre_partido)\n",
    "\n",
    "#"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "052884bd",
   "metadata": {},
   "source": [
    "En este caso el usuario de Juan Pablo Camacho (cámara de bogotá) es el segundo. Sin embargo el primero está mejor posicionado"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "f671fb24",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_excel(\"20220131_candidatos-congreso_18012022.xlsx\", sheet_name=\"Candidatos\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "caf8f007",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Semillero</th>\n",
       "      <th>empezar</th>\n",
       "      <th>terminar</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Andrés Martínez Silva</td>\n",
       "      <td>1</td>\n",
       "      <td>157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Juan Felipe Patiño Sanclemente</td>\n",
       "      <td>158</td>\n",
       "      <td>314</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Juan David Díaz Cristancho</td>\n",
       "      <td>315</td>\n",
       "      <td>471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ronald Yesid Diaz Pardo</td>\n",
       "      <td>472</td>\n",
       "      <td>628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Luis Adrián Lima Cáceres</td>\n",
       "      <td>629</td>\n",
       "      <td>785</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Andres Felipe Pinzon Orjuela</td>\n",
       "      <td>786</td>\n",
       "      <td>942</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Edwin Daniel Aguirre</td>\n",
       "      <td>943</td>\n",
       "      <td>1099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Mario Felipe Velásquez Semanate</td>\n",
       "      <td>1100</td>\n",
       "      <td>1256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Alejandro Jaramillo Castellanos</td>\n",
       "      <td>1257</td>\n",
       "      <td>1413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Fernando Andrés Avalos López</td>\n",
       "      <td>1414</td>\n",
       "      <td>1570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Jorge Esteban Gomez Carmona</td>\n",
       "      <td>1571</td>\n",
       "      <td>1727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Esteban Leiva</td>\n",
       "      <td>1728</td>\n",
       "      <td>1884</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Harold Nicolás Coca Peña</td>\n",
       "      <td>1885</td>\n",
       "      <td>2041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Valentina Suárez Torres</td>\n",
       "      <td>2042</td>\n",
       "      <td>2198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Sara Juliana Torres Benavides</td>\n",
       "      <td>2199</td>\n",
       "      <td>2355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>David Santiago Ortiz Almanza</td>\n",
       "      <td>2356</td>\n",
       "      <td>2512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Ángela Liliana Jiménez Flechas</td>\n",
       "      <td>2513</td>\n",
       "      <td>2669</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Natalia Márquez Reyes</td>\n",
       "      <td>2670</td>\n",
       "      <td>2820</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Semillero   empezar  terminar\n",
       "0             Andrés Martínez Silva        1       157\n",
       "1    Juan Felipe Patiño Sanclemente      158       314\n",
       "2        Juan David Díaz Cristancho      315       471\n",
       "3           Ronald Yesid Diaz Pardo      472       628\n",
       "4          Luis Adrián Lima Cáceres      629       785\n",
       "5      Andres Felipe Pinzon Orjuela      786       942\n",
       "6              Edwin Daniel Aguirre      943      1099\n",
       "7   Mario Felipe Velásquez Semanate     1100      1256\n",
       "8   Alejandro Jaramillo Castellanos     1257      1413\n",
       "9      Fernando Andrés Avalos López     1414      1570\n",
       "10      Jorge Esteban Gomez Carmona     1571      1727\n",
       "11                    Esteban Leiva     1728      1884\n",
       "12         Harold Nicolás Coca Peña     1885      2041\n",
       "13          Valentina Suárez Torres     2042      2198\n",
       "14   Sara Juliana Torres Benavides      2199      2355\n",
       "15     David Santiago Ortiz Almanza     2356      2512\n",
       "16   Ángela Liliana Jiménez Flechas     2513      2669\n",
       "17            Natalia Márquez Reyes     2670      2820"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#acá está como se dividió la base, ojo la numeración no empieza en 0\n",
    "division=pd.read_excel(\"20220131_candidatos-congreso_18012022.xlsx\", sheet_name=\"Sheet1\")\n",
    "division "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0db1ed31",
   "metadata": {},
   "source": [
    "Para partir la base lo pueden hacer así"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "2db465f6",
   "metadata": {},
   "outputs": [],
   "source": [
    "## del 5 al 15 sería:\n",
    "\n",
    "df5_15=df[df[\"Consecutivo\"].gt(4) & df[\"Consecutivo\"].lt(16)]\n",
    "#df5_15 "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cdeda4e5",
   "metadata": {},
   "source": [
    "La idea es que mejoren el código de abajo. Pueden pensar mejores estrategias que esta o cambiar la función\n",
    "\n",
    "La estrategia también puede variar dependiendo del set de candidatos que les tocó. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "11a32116",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'EDGAR ALBERTO VIDAL CAMARA': '/albertovidal1',\n",
       " 'FRANKLIN JAIR MARTINEZ CAMARA': '/franklinjair_ma',\n",
       " 'ARGENIS  MONTENEGRO CAMARA': '/alcmontenegro',\n",
       " 'GENER ALEXANDER USUGA SENADO': '/gener_usuga',\n",
       " 'ENRIQUE  CABRALES SENADO': '/kikecabralescd',\n",
       " 'VICTOR HUGO JOHNSON CAMARA': '/ind_animacion',\n",
       " 'CARLOS ENRIQUE FORERO SENADO': None,\n",
       " 'JAVIER ENRIQUE SOCARRAS CAMARA': '/javiersocarras_',\n",
       " 'YOLANDA  PEREA SENADO': '/yolaperea',\n",
       " 'DIANA CATHERINE SARMIENTO CAMARA': '/Diana31144022',\n",
       " 'GERMAN ALBERTO BOJACA SENADO': '/senadogovco',\n",
       " 'LUVI KATHERINE MIRANDA CAMARA': '/mirandabogota',\n",
       " 'CARLOS VICENTE BOLAÑO CAMARA': '/hashtag/silohace',\n",
       " 'LUIS REINALDO TEJADA CAMARA': '/luistejadafran1',\n",
       " 'YULIZA  VALOYES CAMARA': '/andresteologia'}"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# una base aleatoria\n",
    "ejemplo=df.sample(n=15)\n",
    "#creo la columna nombre_completo combinando nombre1 nombre2 y apellido1 + la corporación a la que se lanzan\n",
    "ejemplo[\"nombre_completo_corporacion\"]=ejemplo[\"NOMBRE1\"].fillna('')+\" \"+ejemplo[\"NOMBRE2\"].fillna('')+\" \"+ejemplo[\"APELLIDO1\"].fillna('')+ \" \"+ ejemplo[\"DESC_CORP\"].fillna('')\n",
    "\n",
    "# se crea un diccionario de los usuarios encontrados y el nombre \n",
    "diccionario={i:identify_twitter(i) for i in list(ejemplo[\"nombre_completo_corporacion\"])}\n",
    "diccionario"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "54530310",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DESC_CORP</th>\n",
       "      <th>DESC_CIRC</th>\n",
       "      <th>DESC_DPTO</th>\n",
       "      <th>TIPO DE AGRUPACIÓN POLÍTICA</th>\n",
       "      <th>AGRUPACIÓN POLITICA</th>\n",
       "      <th>ID_RENGLON</th>\n",
       "      <th>CEDULA</th>\n",
       "      <th>NOMBRE1</th>\n",
       "      <th>NOMBRE2</th>\n",
       "      <th>APELLIDO1</th>\n",
       "      <th>APELLIDO2</th>\n",
       "      <th>GENERO</th>\n",
       "      <th>DESC_OPCION</th>\n",
       "      <th>Consecutivo</th>\n",
       "      <th>nombre_completo_corporacion</th>\n",
       "      <th>user</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2733</th>\n",
       "      <td>CAMARA</td>\n",
       "      <td>CITREP</td>\n",
       "      <td>NARIÑO</td>\n",
       "      <td>ORGANIZACIONES SOCIALES</td>\n",
       "      <td>ASOCIACION DE DESPLAZADOS FUTUROS DEL MAÑANA</td>\n",
       "      <td>502</td>\n",
       "      <td>1061437713</td>\n",
       "      <td>EDGAR</td>\n",
       "      <td>ALBERTO</td>\n",
       "      <td>VIDAL</td>\n",
       "      <td>MINA</td>\n",
       "      <td>M</td>\n",
       "      <td>PREFERENTE</td>\n",
       "      <td>2734</td>\n",
       "      <td>EDGAR ALBERTO VIDAL CAMARA</td>\n",
       "      <td>/albertovidal1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2129</th>\n",
       "      <td>CAMARA</td>\n",
       "      <td>TERRITORIAL</td>\n",
       "      <td>GUAINIA</td>\n",
       "      <td>PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...</td>\n",
       "      <td>MOVIMIENTO AUTORIDADES INDÍGENAS DE COLOMBIA \"...</td>\n",
       "      <td>102</td>\n",
       "      <td>1006792921</td>\n",
       "      <td>FRANKLIN</td>\n",
       "      <td>JAIR</td>\n",
       "      <td>MARTINEZ</td>\n",
       "      <td>ACOSTA</td>\n",
       "      <td>M</td>\n",
       "      <td>PREFERENTE</td>\n",
       "      <td>2130</td>\n",
       "      <td>FRANKLIN JAIR MARTINEZ CAMARA</td>\n",
       "      <td>/franklinjair_ma</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2508</th>\n",
       "      <td>CAMARA</td>\n",
       "      <td>CITREP</td>\n",
       "      <td>PUTUMAYO</td>\n",
       "      <td>ORGANIZACIONES SOCIALES</td>\n",
       "      <td>AFRO CIMARRÓN PUTUMAYO</td>\n",
       "      <td>501</td>\n",
       "      <td>69028297</td>\n",
       "      <td>ARGENIS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MONTENEGRO</td>\n",
       "      <td>CUCHIMBA</td>\n",
       "      <td>F</td>\n",
       "      <td>PREFERENTE</td>\n",
       "      <td>2509</td>\n",
       "      <td>ARGENIS  MONTENEGRO CAMARA</td>\n",
       "      <td>/alcmontenegro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>869</th>\n",
       "      <td>SENADO</td>\n",
       "      <td>NACIONAL</td>\n",
       "      <td>COLOMBIA</td>\n",
       "      <td>COALICIONES</td>\n",
       "      <td>PACTO HISTÓRICO</td>\n",
       "      <td>40</td>\n",
       "      <td>98668596</td>\n",
       "      <td>GENER</td>\n",
       "      <td>ALEXANDER</td>\n",
       "      <td>USUGA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M</td>\n",
       "      <td>NO PREFERENTE</td>\n",
       "      <td>870</td>\n",
       "      <td>GENER ALEXANDER USUGA SENADO</td>\n",
       "      <td>/gener_usuga</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>580</th>\n",
       "      <td>SENADO</td>\n",
       "      <td>NACIONAL</td>\n",
       "      <td>COLOMBIA</td>\n",
       "      <td>PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...</td>\n",
       "      <td>PARTIDO CENTRO DEMOCRÁTICO</td>\n",
       "      <td>4</td>\n",
       "      <td>1002241155</td>\n",
       "      <td>ENRIQUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CABRALES</td>\n",
       "      <td>BAQUERO</td>\n",
       "      <td>M</td>\n",
       "      <td>PREFERENTE</td>\n",
       "      <td>581</td>\n",
       "      <td>ENRIQUE  CABRALES SENADO</td>\n",
       "      <td>/kikecabralescd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2027</th>\n",
       "      <td>CAMARA</td>\n",
       "      <td>TERRITORIAL</td>\n",
       "      <td>VALLE</td>\n",
       "      <td>PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...</td>\n",
       "      <td>PARTIDO CAMBIO RADICAL</td>\n",
       "      <td>111</td>\n",
       "      <td>94535502</td>\n",
       "      <td>VICTOR</td>\n",
       "      <td>HUGO</td>\n",
       "      <td>JOHNSON</td>\n",
       "      <td>CORPUS</td>\n",
       "      <td>M</td>\n",
       "      <td>PREFERENTE</td>\n",
       "      <td>2028</td>\n",
       "      <td>VICTOR HUGO JOHNSON CAMARA</td>\n",
       "      <td>/ind_animacion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>SENADO</td>\n",
       "      <td>NACIONAL</td>\n",
       "      <td>COLOMBIA</td>\n",
       "      <td>COALICIONES</td>\n",
       "      <td>COALICIÓN MIRA -  COLOMBIA JUSTA LIBRES</td>\n",
       "      <td>39</td>\n",
       "      <td>5992754</td>\n",
       "      <td>CARLOS</td>\n",
       "      <td>ENRIQUE</td>\n",
       "      <td>FORERO</td>\n",
       "      <td>SANCHEZ</td>\n",
       "      <td>M</td>\n",
       "      <td>PREFERENTE</td>\n",
       "      <td>416</td>\n",
       "      <td>CARLOS ENRIQUE FORERO SENADO</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2346</th>\n",
       "      <td>CAMARA</td>\n",
       "      <td>AFRODESCENDIENTES</td>\n",
       "      <td>COLOMBIA</td>\n",
       "      <td>ORGANIZACIONES AFRODESCENDIENTES</td>\n",
       "      <td>CONMOGUZ</td>\n",
       "      <td>301</td>\n",
       "      <td>17973696</td>\n",
       "      <td>JAVIER</td>\n",
       "      <td>ENRIQUE</td>\n",
       "      <td>SOCARRAS</td>\n",
       "      <td>AMAYA</td>\n",
       "      <td>M</td>\n",
       "      <td>NO PREFERENTE</td>\n",
       "      <td>2347</td>\n",
       "      <td>JAVIER ENRIQUE SOCARRAS CAMARA</td>\n",
       "      <td>/javiersocarras_</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328</th>\n",
       "      <td>SENADO</td>\n",
       "      <td>NACIONAL</td>\n",
       "      <td>COLOMBIA</td>\n",
       "      <td>PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...</td>\n",
       "      <td>PARTIDO NUEVO LIBERALISMO</td>\n",
       "      <td>5</td>\n",
       "      <td>39427115</td>\n",
       "      <td>YOLANDA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PEREA</td>\n",
       "      <td>MOSQUERA</td>\n",
       "      <td>F</td>\n",
       "      <td>NO PREFERENTE</td>\n",
       "      <td>329</td>\n",
       "      <td>YOLANDA  PEREA SENADO</td>\n",
       "      <td>/yolaperea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1562</th>\n",
       "      <td>CAMARA</td>\n",
       "      <td>TERRITORIAL</td>\n",
       "      <td>BOGOTA D.C.</td>\n",
       "      <td>PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...</td>\n",
       "      <td>PARTIDO CAMBIO RADICAL</td>\n",
       "      <td>111</td>\n",
       "      <td>1018426693</td>\n",
       "      <td>DIANA</td>\n",
       "      <td>CATHERINE</td>\n",
       "      <td>SARMIENTO</td>\n",
       "      <td>TORO</td>\n",
       "      <td>F</td>\n",
       "      <td>PREFERENTE</td>\n",
       "      <td>1563</td>\n",
       "      <td>DIANA CATHERINE SARMIENTO CAMARA</td>\n",
       "      <td>/Diana31144022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290</th>\n",
       "      <td>SENADO</td>\n",
       "      <td>NACIONAL</td>\n",
       "      <td>COLOMBIA</td>\n",
       "      <td>PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...</td>\n",
       "      <td>PARTIDO CAMBIO RADICAL</td>\n",
       "      <td>91</td>\n",
       "      <td>1074414877</td>\n",
       "      <td>GERMAN</td>\n",
       "      <td>ALBERTO</td>\n",
       "      <td>BOJACA</td>\n",
       "      <td>GARAVITO</td>\n",
       "      <td>M</td>\n",
       "      <td>PREFERENTE</td>\n",
       "      <td>291</td>\n",
       "      <td>GERMAN ALBERTO BOJACA SENADO</td>\n",
       "      <td>/senadogovco</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1463</th>\n",
       "      <td>CAMARA</td>\n",
       "      <td>TERRITORIAL</td>\n",
       "      <td>BOGOTA D.C.</td>\n",
       "      <td>PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...</td>\n",
       "      <td>PARTIDO ALIANZA VERDE</td>\n",
       "      <td>101</td>\n",
       "      <td>1030522325</td>\n",
       "      <td>LUVI</td>\n",
       "      <td>KATHERINE</td>\n",
       "      <td>MIRANDA</td>\n",
       "      <td>PEÑA</td>\n",
       "      <td>F</td>\n",
       "      <td>PREFERENTE</td>\n",
       "      <td>1464</td>\n",
       "      <td>LUVI KATHERINE MIRANDA CAMARA</td>\n",
       "      <td>/mirandabogota</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1663</th>\n",
       "      <td>CAMARA</td>\n",
       "      <td>TERRITORIAL</td>\n",
       "      <td>MAGDALENA</td>\n",
       "      <td>PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...</td>\n",
       "      <td>PARTIDO CAMBIO RADICAL</td>\n",
       "      <td>102</td>\n",
       "      <td>7144915</td>\n",
       "      <td>CARLOS</td>\n",
       "      <td>VICENTE</td>\n",
       "      <td>BOLAÑO</td>\n",
       "      <td>GOMEZ</td>\n",
       "      <td>M</td>\n",
       "      <td>PREFERENTE</td>\n",
       "      <td>1664</td>\n",
       "      <td>CARLOS VICENTE BOLAÑO CAMARA</td>\n",
       "      <td>/hashtag/silohace</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>925</th>\n",
       "      <td>CAMARA</td>\n",
       "      <td>TERRITORIAL</td>\n",
       "      <td>ANTIOQUIA</td>\n",
       "      <td>PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...</td>\n",
       "      <td>MOVIMIENTO DE SALVACIÓN NACIONAL</td>\n",
       "      <td>101</td>\n",
       "      <td>8394576</td>\n",
       "      <td>LUIS</td>\n",
       "      <td>REINALDO</td>\n",
       "      <td>TEJADA</td>\n",
       "      <td>FRANCO</td>\n",
       "      <td>M</td>\n",
       "      <td>NO PREFERENTE</td>\n",
       "      <td>926</td>\n",
       "      <td>LUIS REINALDO TEJADA CAMARA</td>\n",
       "      <td>/luistejadafran1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2300</th>\n",
       "      <td>CAMARA</td>\n",
       "      <td>AFRODESCENDIENTES</td>\n",
       "      <td>COLOMBIA</td>\n",
       "      <td>ORGANIZACIONES AFRODESCENDIENTES</td>\n",
       "      <td>CONSEJO COMUNIT. RECUERDO DE NUESTROS ANCESTRO...</td>\n",
       "      <td>302</td>\n",
       "      <td>1020432977</td>\n",
       "      <td>YULIZA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VALOYES</td>\n",
       "      <td>CABRERA</td>\n",
       "      <td>F</td>\n",
       "      <td>NO PREFERENTE</td>\n",
       "      <td>2301</td>\n",
       "      <td>YULIZA  VALOYES CAMARA</td>\n",
       "      <td>/andresteologia</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     DESC_CORP          DESC_CIRC    DESC_DPTO  \\\n",
       "2733    CAMARA             CITREP       NARIÑO   \n",
       "2129    CAMARA        TERRITORIAL      GUAINIA   \n",
       "2508    CAMARA             CITREP     PUTUMAYO   \n",
       "869     SENADO           NACIONAL     COLOMBIA   \n",
       "580     SENADO           NACIONAL     COLOMBIA   \n",
       "2027    CAMARA        TERRITORIAL        VALLE   \n",
       "415     SENADO           NACIONAL     COLOMBIA   \n",
       "2346    CAMARA  AFRODESCENDIENTES     COLOMBIA   \n",
       "328     SENADO           NACIONAL     COLOMBIA   \n",
       "1562    CAMARA        TERRITORIAL  BOGOTA D.C.   \n",
       "290     SENADO           NACIONAL     COLOMBIA   \n",
       "1463    CAMARA        TERRITORIAL  BOGOTA D.C.   \n",
       "1663    CAMARA        TERRITORIAL    MAGDALENA   \n",
       "925     CAMARA        TERRITORIAL    ANTIOQUIA   \n",
       "2300    CAMARA  AFRODESCENDIENTES     COLOMBIA   \n",
       "\n",
       "                            TIPO DE AGRUPACIÓN POLÍTICA  \\\n",
       "2733                            ORGANIZACIONES SOCIALES   \n",
       "2129  PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...   \n",
       "2508                            ORGANIZACIONES SOCIALES   \n",
       "869                                         COALICIONES   \n",
       "580   PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...   \n",
       "2027  PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...   \n",
       "415                                         COALICIONES   \n",
       "2346                   ORGANIZACIONES AFRODESCENDIENTES   \n",
       "328   PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...   \n",
       "1562  PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...   \n",
       "290   PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...   \n",
       "1463  PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...   \n",
       "1663  PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...   \n",
       "925   PARTIDO O MOVIMIENTO POLITICO CON PERSONERIA J...   \n",
       "2300                   ORGANIZACIONES AFRODESCENDIENTES   \n",
       "\n",
       "                                    AGRUPACIÓN POLITICA  ID_RENGLON  \\\n",
       "2733       ASOCIACION DE DESPLAZADOS FUTUROS DEL MAÑANA         502   \n",
       "2129  MOVIMIENTO AUTORIDADES INDÍGENAS DE COLOMBIA \"...         102   \n",
       "2508                             AFRO CIMARRÓN PUTUMAYO         501   \n",
       "869                                     PACTO HISTÓRICO          40   \n",
       "580                          PARTIDO CENTRO DEMOCRÁTICO           4   \n",
       "2027                             PARTIDO CAMBIO RADICAL         111   \n",
       "415             COALICIÓN MIRA -  COLOMBIA JUSTA LIBRES          39   \n",
       "2346                                           CONMOGUZ         301   \n",
       "328                           PARTIDO NUEVO LIBERALISMO           5   \n",
       "1562                             PARTIDO CAMBIO RADICAL         111   \n",
       "290                              PARTIDO CAMBIO RADICAL          91   \n",
       "1463                              PARTIDO ALIANZA VERDE         101   \n",
       "1663                             PARTIDO CAMBIO RADICAL         102   \n",
       "925                    MOVIMIENTO DE SALVACIÓN NACIONAL         101   \n",
       "2300  CONSEJO COMUNIT. RECUERDO DE NUESTROS ANCESTRO...         302   \n",
       "\n",
       "          CEDULA   NOMBRE1    NOMBRE2   APELLIDO1 APELLIDO2 GENERO  \\\n",
       "2733  1061437713     EDGAR    ALBERTO       VIDAL      MINA      M   \n",
       "2129  1006792921  FRANKLIN       JAIR    MARTINEZ    ACOSTA      M   \n",
       "2508    69028297   ARGENIS        NaN  MONTENEGRO  CUCHIMBA      F   \n",
       "869     98668596     GENER  ALEXANDER       USUGA       NaN      M   \n",
       "580   1002241155   ENRIQUE        NaN    CABRALES   BAQUERO      M   \n",
       "2027    94535502    VICTOR       HUGO     JOHNSON    CORPUS      M   \n",
       "415      5992754    CARLOS    ENRIQUE      FORERO   SANCHEZ      M   \n",
       "2346    17973696    JAVIER    ENRIQUE    SOCARRAS     AMAYA      M   \n",
       "328     39427115   YOLANDA        NaN       PEREA  MOSQUERA      F   \n",
       "1562  1018426693     DIANA  CATHERINE   SARMIENTO      TORO      F   \n",
       "290   1074414877    GERMAN    ALBERTO      BOJACA  GARAVITO      M   \n",
       "1463  1030522325      LUVI  KATHERINE     MIRANDA      PEÑA      F   \n",
       "1663     7144915    CARLOS    VICENTE      BOLAÑO     GOMEZ      M   \n",
       "925      8394576      LUIS   REINALDO      TEJADA    FRANCO      M   \n",
       "2300  1020432977    YULIZA        NaN     VALOYES   CABRERA      F   \n",
       "\n",
       "        DESC_OPCION  Consecutivo       nombre_completo_corporacion  \\\n",
       "2733     PREFERENTE         2734        EDGAR ALBERTO VIDAL CAMARA   \n",
       "2129     PREFERENTE         2130     FRANKLIN JAIR MARTINEZ CAMARA   \n",
       "2508     PREFERENTE         2509        ARGENIS  MONTENEGRO CAMARA   \n",
       "869   NO PREFERENTE          870      GENER ALEXANDER USUGA SENADO   \n",
       "580      PREFERENTE          581          ENRIQUE  CABRALES SENADO   \n",
       "2027     PREFERENTE         2028        VICTOR HUGO JOHNSON CAMARA   \n",
       "415      PREFERENTE          416      CARLOS ENRIQUE FORERO SENADO   \n",
       "2346  NO PREFERENTE         2347    JAVIER ENRIQUE SOCARRAS CAMARA   \n",
       "328   NO PREFERENTE          329             YOLANDA  PEREA SENADO   \n",
       "1562     PREFERENTE         1563  DIANA CATHERINE SARMIENTO CAMARA   \n",
       "290      PREFERENTE          291      GERMAN ALBERTO BOJACA SENADO   \n",
       "1463     PREFERENTE         1464     LUVI KATHERINE MIRANDA CAMARA   \n",
       "1663     PREFERENTE         1664      CARLOS VICENTE BOLAÑO CAMARA   \n",
       "925   NO PREFERENTE          926       LUIS REINALDO TEJADA CAMARA   \n",
       "2300  NO PREFERENTE         2301            YULIZA  VALOYES CAMARA   \n",
       "\n",
       "                   user  \n",
       "2733     /albertovidal1  \n",
       "2129   /franklinjair_ma  \n",
       "2508     /alcmontenegro  \n",
       "869        /gener_usuga  \n",
       "580     /kikecabralescd  \n",
       "2027     /ind_animacion  \n",
       "415                None  \n",
       "2346   /javiersocarras_  \n",
       "328          /yolaperea  \n",
       "1562     /Diana31144022  \n",
       "290        /senadogovco  \n",
       "1463     /mirandabogota  \n",
       "1663  /hashtag/silohace  \n",
       "925    /luistejadafran1  \n",
       "2300    /andresteologia  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ejemplo[\"user\"]=ejemplo[\"nombre_completo_corporacion\"].map(diccionario)\n",
    "ejemplo"
   ]
  }
 ],
 "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}