pandas_consultas/ejercicio_11.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Ejercicio 11\n",
    "\n",
    "Para todos los comentarios de revisión de contenido que tengan más de 20\n",
    "ocurrencias realice una matriz cuyas columnas sean esos comentarios y de índice\n",
    "los usuarios/ips con valores: True si ese usuario realizó ese comentario, sino False\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>title</th>\n",
       "      <th>id</th>\n",
       "      <th>namespace</th>\n",
       "      <th>revision_id</th>\n",
       "      <th>parent_revision</th>\n",
       "      <th>revision_timestamp</th>\n",
       "      <th>revisor_username</th>\n",
       "      <th>revisor_id</th>\n",
       "      <th>revisor_ip</th>\n",
       "      <th>revisor_comment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Wikipedia:Artículos solicitados</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>132533307</td>\n",
       "      <td>132516631.0</td>\n",
       "      <td>2021-01-19T18:40:34Z</td>\n",
       "      <td>Metrónomo</td>\n",
       "      <td>1708233.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Así esta mejor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Andorra</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>138035057</td>\n",
       "      <td>138027475.0</td>\n",
       "      <td>2021-08-31T18:27:01Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2800:CD0:FC1B:A900:C5A4:9E81:7175:2ED2</td>\n",
       "      <td>Añadir contenido</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>137966826</td>\n",
       "      <td>137825165.0</td>\n",
       "      <td>2021-08-28T17:17:54Z</td>\n",
       "      <td>Traitrich</td>\n",
       "      <td>4642283.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Reemplazos con [[Usuario:Benjavalero/Replacer|...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Geografía de Andorra</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>137986788</td>\n",
       "      <td>133666383.0</td>\n",
       "      <td>2021-08-29T17:16:00Z</td>\n",
       "      <td>Lojwe</td>\n",
       "      <td>5338508.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Reemplazos con [[Usuario:Benjavalero/Replacer|...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Demografía de Andorra</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>130869554</td>\n",
       "      <td>129413188.0</td>\n",
       "      <td>2020-11-12T19:56:15Z</td>\n",
       "      <td>Jialxv</td>\n",
       "      <td>3615366.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Correcciones ortográficas con [[Usuario:Benjav...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             title  id  namespace  revision_id  \\\n",
       "0  Wikipedia:Artículos solicitados   5          4    132533307   \n",
       "1                          Andorra   7          0    138035057   \n",
       "2                        Argentina  10          0    137966826   \n",
       "3             Geografía de Andorra  15          0    137986788   \n",
       "4            Demografía de Andorra  17          0    130869554   \n",
       "\n",
       "   parent_revision    revision_timestamp revisor_username  revisor_id  \\\n",
       "0      132516631.0  2021-01-19T18:40:34Z        Metrónomo   1708233.0   \n",
       "1      138027475.0  2021-08-31T18:27:01Z              NaN         NaN   \n",
       "2      137825165.0  2021-08-28T17:17:54Z        Traitrich   4642283.0   \n",
       "3      133666383.0  2021-08-29T17:16:00Z            Lojwe   5338508.0   \n",
       "4      129413188.0  2020-11-12T19:56:15Z           Jialxv   3615366.0   \n",
       "\n",
       "                               revisor_ip  \\\n",
       "0                                     NaN   \n",
       "1  2800:CD0:FC1B:A900:C5A4:9E81:7175:2ED2   \n",
       "2                                     NaN   \n",
       "3                                     NaN   \n",
       "4                                     NaN   \n",
       "\n",
       "                                     revisor_comment  \n",
       "0                                     Así esta mejor  \n",
       "1                                   Añadir contenido  \n",
       "2  Reemplazos con [[Usuario:Benjavalero/Replacer|...  \n",
       "3  Reemplazos con [[Usuario:Benjavalero/Replacer|...  \n",
       "4  Correcciones ortográficas con [[Usuario:Benjav...  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "contents = pd.read_csv('contents.csv')\n",
    "contents.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Para realizar el ejercicio, unifico las columnas de revisor_username y revisor ip dado que cuando una es NaN la otra contiene valores."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0                                       Metrónomo\n",
       "1          2800:CD0:FC1B:A900:C5A4:9E81:7175:2ED2\n",
       "2                                       Traitrich\n",
       "3                                           Lojwe\n",
       "4                                          Jialxv\n",
       "                            ...                  \n",
       "4132159                                  Copydays\n",
       "4132160                                  Crls9011\n",
       "4132161                              Gabriel Solo\n",
       "4132162                                  Términus\n",
       "4132163                                  Carlukas\n",
       "Name: revisor_username, Length: 4132164, dtype: object"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "unified_col = contents['revisor_username'].fillna(contents['revisor_ip'])\n",
    "unified_col"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Agrego la columna al final de mi dataframe original y solo conservo aquellas columnas que necesito para trabajar."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "contents['username/ips'] = unified_col"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>username/ips</th>\n",
       "      <th>revisor_comment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Metrónomo</td>\n",
       "      <td>Así esta mejor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2800:CD0:FC1B:A900:C5A4:9E81:7175:2ED2</td>\n",
       "      <td>Añadir contenido</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Traitrich</td>\n",
       "      <td>Reemplazos con [[Usuario:Benjavalero/Replacer|...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Lojwe</td>\n",
       "      <td>Reemplazos con [[Usuario:Benjavalero/Replacer|...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Jialxv</td>\n",
       "      <td>Correcciones ortográficas con [[Usuario:Benjav...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             username/ips  \\\n",
       "0                               Metrónomo   \n",
       "1  2800:CD0:FC1B:A900:C5A4:9E81:7175:2ED2   \n",
       "2                               Traitrich   \n",
       "3                                   Lojwe   \n",
       "4                                  Jialxv   \n",
       "\n",
       "                                     revisor_comment  \n",
       "0                                     Así esta mejor  \n",
       "1                                   Añadir contenido  \n",
       "2  Reemplazos con [[Usuario:Benjavalero/Replacer|...  \n",
       "3  Reemplazos con [[Usuario:Benjavalero/Replacer|...  \n",
       "4  Correcciones ortográficas con [[Usuario:Benjav...  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "contents_reduced = contents[['username/ips','revisor_comment']]\n",
    "contents_reduced.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Elimino mi archivo original para liberar la memoria\n",
    "del contents"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>username/ips</th>\n",
       "      <th>revisor_comment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2800:CD0:FC1B:A900:C5A4:9E81:7175:2ED2</td>\n",
       "      <td>Añadir contenido</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Jialxv</td>\n",
       "      <td>Correcciones ortográficas con [[Usuario:Benjav...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PatriHorrillo</td>\n",
       "      <td>Correcciones ortográficas con [[Usuario:Benjav...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>LOLAOMI</td>\n",
       "      <td>Correcciones ortográficas con [[Usuario:Benjav...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>InternetArchiveBot</td>\n",
       "      <td>Rescatando 1 referencia(s) y marcando 0 enlace...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              username/ips  \\\n",
       "1   2800:CD0:FC1B:A900:C5A4:9E81:7175:2ED2   \n",
       "4                                   Jialxv   \n",
       "5                            PatriHorrillo   \n",
       "8                                  LOLAOMI   \n",
       "11                      InternetArchiveBot   \n",
       "\n",
       "                                      revisor_comment  \n",
       "1                                    Añadir contenido  \n",
       "4   Correcciones ortográficas con [[Usuario:Benjav...  \n",
       "5   Correcciones ortográficas con [[Usuario:Benjav...  \n",
       "8   Correcciones ortográficas con [[Usuario:Benjav...  \n",
       "11  Rescatando 1 referencia(s) y marcando 0 enlace...  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Filtro aquellas filas que pertenecen a aquellos comentarios que poseen mas de 20 apariciones.\n",
    "comments = contents_reduced['revisor_comment'].value_counts()\n",
    "comments_needed = comments[comments > 20]\n",
    "contents_reduced_filtered = contents_reduced.loc[contents_reduced['revisor_comment'].isin(comments_needed.index)]\n",
    "contents_reduced_filtered.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Elimino contents_reduced para liberar memoria\n",
    "del contents_reduced"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "username/ips       1440595\n",
       "revisor_comment    1440596\n",
       "dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "contents_reduced_filtered.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "username/ips       1440595\n",
       "revisor_comment    1440595\n",
       "dtype: int64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Como vemos, tenemos un username/ips que posee NaN y dado que es uno solo lo droppeo.\n",
    "contents_reduced_filtered.dropna(inplace=True)\n",
    "contents_reduced_filtered.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"21\" halign=\"left\">username/ips</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>revisor_comment</th>\n",
       "      <th>#QuédateEnTuCasaYEditaWikipedia. Nuevo, localidad</th>\n",
       "      <th>#REDIRECCIÓN</th>\n",
       "      <th>#REDIRECT</th>\n",
       "      <th>#REDIRECT [[Anexo:Glosario de términos de sumo]]</th>\n",
       "      <th>#REDIRECT [[Echinopsis]]</th>\n",
       "      <th>#REDIRECT [[Wikipedia:Consultas de borrado/Lista de universidades por país]]</th>\n",
       "      <th>#REDIRECT [[]]</th>\n",
       "      <th>#WPWP</th>\n",
       "      <th>#WPWP #WPWPARK</th>\n",
       "      <th>#WPWP #WPWPSR</th>\n",
       "      <th>...</th>\n",
       "      <th>¿?</th>\n",
       "      <th>Última versión</th>\n",
       "      <th>—</th>\n",
       "      <th>− 2 categorías; + 2 categorías mediante [[Wikipedia:HotCat|HotCat]]</th>\n",
       "      <th>−[[Categoría:Distrito de Botoșani]]; ±[[Categoría:Localidades de Rumania]]→[[Categoría:Localidades del distrito de Botoșani]] mediante [[Wikipedia:HotCat|HotCat]]</th>\n",
       "      <th>−[[Categoría:Edificios y estructuras de Manhattan]]; ±[[Categoría:Casas de Nueva York]]→[[Categoría:Casas de Manhattan]] mediante [[Wikipedia:HotCat|HotCat]]</th>\n",
       "      <th>−[[Categoría:Provincia de Nordland]]; ±[[Categoría:Localidades de Noruega]]→[[Categoría:Localidades portuarias del condado de Nordland]] mediante [[Wikipedia:HotCat|HotCat]]</th>\n",
       "      <th>−[[Categoría:Provincia de Nordland]]; ±[[Categoría:Municipios de Noruega]]→[[Categoría:Municipios de Nordland]] mediante [[Wikipedia:HotCat|HotCat]]</th>\n",
       "      <th>−[[Categoría:Provincia de Trøndelag]]; ±[[Categoría:Localidades de Noruega]]→[[Categoría:Localidades de Trøndelag]] mediante [[Wikipedia:HotCat|HotCat]]</th>\n",
       "      <th>−[[Categoría:Santos católicos]]; −[[Categoría:Santos de la Iglesia ortodoxa]]; +[[Categoría:Santo católico y ortodoxo]] mediante [[Wikipedia:HotCat|HotCat]]</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>username/ips</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>\"BF CLUB\"</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\"CLUB BF\"</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>&amp;beer&amp;love</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(:Julien:)</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(KGC2) KosmoGelo II</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 6180 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                         username/ips  \\\n",
       "revisor_comment     #QuédateEnTuCasaYEditaWikipedia. Nuevo, localidad   \n",
       "username/ips                                                            \n",
       "\"BF CLUB\"                                                       False   \n",
       "\"CLUB BF\"                                                       False   \n",
       "&beer&love                                                      False   \n",
       "(:Julien:)                                                      False   \n",
       "(KGC2) KosmoGelo II                                             False   \n",
       "\n",
       "                                            \\\n",
       "revisor_comment     #REDIRECCIÓN #REDIRECT   \n",
       "username/ips                                 \n",
       "\"BF CLUB\"                  False     False   \n",
       "\"CLUB BF\"                  False     False   \n",
       "&beer&love                 False     False   \n",
       "(:Julien:)                 False     False   \n",
       "(KGC2) KosmoGelo II        False     False   \n",
       "\n",
       "                                                                      \\\n",
       "revisor_comment     #REDIRECT [[Anexo:Glosario de términos de sumo]]   \n",
       "username/ips                                                           \n",
       "\"BF CLUB\"                                                      False   \n",
       "\"CLUB BF\"                                                      False   \n",
       "&beer&love                                                     False   \n",
       "(:Julien:)                                                     False   \n",
       "(KGC2) KosmoGelo II                                            False   \n",
       "\n",
       "                                              \\\n",
       "revisor_comment     #REDIRECT [[Echinopsis]]   \n",
       "username/ips                                   \n",
       "\"BF CLUB\"                              False   \n",
       "\"CLUB BF\"                              False   \n",
       "&beer&love                             False   \n",
       "(:Julien:)                             False   \n",
       "(KGC2) KosmoGelo II                    False   \n",
       "\n",
       "                                                                                                  \\\n",
       "revisor_comment     #REDIRECT [[Wikipedia:Consultas de borrado/Lista de universidades por país]]   \n",
       "username/ips                                                                                       \n",
       "\"BF CLUB\"                                                        False                             \n",
       "\"CLUB BF\"                                                        False                             \n",
       "&beer&love                                                       False                             \n",
       "(:Julien:)                                                       False                             \n",
       "(KGC2) KosmoGelo II                                              False                             \n",
       "\n",
       "                                                                        ...  \\\n",
       "revisor_comment     #REDIRECT [[]]  #WPWP #WPWP #WPWPARK #WPWP #WPWPSR  ...   \n",
       "username/ips                                                            ...   \n",
       "\"BF CLUB\"                    False  False          False         False  ...   \n",
       "\"CLUB BF\"                    False  False          False         False  ...   \n",
       "&beer&love                   False  False          False         False  ...   \n",
       "(:Julien:)                   False  False          False         False  ...   \n",
       "(KGC2) KosmoGelo II          False  False          False         False  ...   \n",
       "\n",
       "                                                  \\\n",
       "revisor_comment         ¿? Última versión      —   \n",
       "username/ips                                       \n",
       "\"BF CLUB\"            False          False  False   \n",
       "\"CLUB BF\"            False          False  False   \n",
       "&beer&love           False          False  False   \n",
       "(:Julien:)           False          False  False   \n",
       "(KGC2) KosmoGelo II  False          False  False   \n",
       "\n",
       "                                                                                         \\\n",
       "revisor_comment     − 2 categorías; + 2 categorías mediante [[Wikipedia:HotCat|HotCat]]   \n",
       "username/ips                                                                              \n",
       "\"BF CLUB\"                                                        False                    \n",
       "\"CLUB BF\"                                                        False                    \n",
       "&beer&love                                                       False                    \n",
       "(:Julien:)                                                       False                    \n",
       "(KGC2) KosmoGelo II                                              False                    \n",
       "\n",
       "                                                                                                                                                                                        \\\n",
       "revisor_comment     −[[Categoría:Distrito de Botoșani]]; ±[[Categoría:Localidades de Rumania]]→[[Categoría:Localidades del distrito de Botoșani]] mediante [[Wikipedia:HotCat|HotCat]]   \n",
       "username/ips                                                                                                                                                                             \n",
       "\"BF CLUB\"                                                        False                                                                                                                   \n",
       "\"CLUB BF\"                                                        False                                                                                                                   \n",
       "&beer&love                                                       False                                                                                                                   \n",
       "(:Julien:)                                                       False                                                                                                                   \n",
       "(KGC2) KosmoGelo II                                              False                                                                                                                   \n",
       "\n",
       "                                                                                                                                                                                   \\\n",
       "revisor_comment     −[[Categoría:Edificios y estructuras de Manhattan]]; ±[[Categoría:Casas de Nueva York]]→[[Categoría:Casas de Manhattan]] mediante [[Wikipedia:HotCat|HotCat]]   \n",
       "username/ips                                                                                                                                                                        \n",
       "\"BF CLUB\"                                                        False                                                                                                              \n",
       "\"CLUB BF\"                                                        False                                                                                                              \n",
       "&beer&love                                                       False                                                                                                              \n",
       "(:Julien:)                                                       False                                                                                                              \n",
       "(KGC2) KosmoGelo II                                              False                                                                                                              \n",
       "\n",
       "                                                                                                                                                                                                   \\\n",
       "revisor_comment     −[[Categoría:Provincia de Nordland]]; ±[[Categoría:Localidades de Noruega]]→[[Categoría:Localidades portuarias del condado de Nordland]] mediante [[Wikipedia:HotCat|HotCat]]   \n",
       "username/ips                                                                                                                                                                                        \n",
       "\"BF CLUB\"                                                        False                                                                                                                              \n",
       "\"CLUB BF\"                                                        False                                                                                                                              \n",
       "&beer&love                                                       False                                                                                                                              \n",
       "(:Julien:)                                                       False                                                                                                                              \n",
       "(KGC2) KosmoGelo II                                              False                                                                                                                              \n",
       "\n",
       "                                                                                                                                                                          \\\n",
       "revisor_comment     −[[Categoría:Provincia de Nordland]]; ±[[Categoría:Municipios de Noruega]]→[[Categoría:Municipios de Nordland]] mediante [[Wikipedia:HotCat|HotCat]]   \n",
       "username/ips                                                                                                                                                               \n",
       "\"BF CLUB\"                                                        False                                                                                                     \n",
       "\"CLUB BF\"                                                        False                                                                                                     \n",
       "&beer&love                                                       False                                                                                                     \n",
       "(:Julien:)                                                       False                                                                                                     \n",
       "(KGC2) KosmoGelo II                                              False                                                                                                     \n",
       "\n",
       "                                                                                                                                                                              \\\n",
       "revisor_comment     −[[Categoría:Provincia de Trøndelag]]; ±[[Categoría:Localidades de Noruega]]→[[Categoría:Localidades de Trøndelag]] mediante [[Wikipedia:HotCat|HotCat]]   \n",
       "username/ips                                                                                                                                                                   \n",
       "\"BF CLUB\"                                                        False                                                                                                         \n",
       "\"CLUB BF\"                                                        False                                                                                                         \n",
       "&beer&love                                                       False                                                                                                         \n",
       "(:Julien:)                                                       False                                                                                                         \n",
       "(KGC2) KosmoGelo II                                              False                                                                                                         \n",
       "\n",
       "                                                                                                                                                                                  \n",
       "revisor_comment     −[[Categoría:Santos católicos]]; −[[Categoría:Santos de la Iglesia ortodoxa]]; +[[Categoría:Santo católico y ortodoxo]] mediante [[Wikipedia:HotCat|HotCat]]  \n",
       "username/ips                                                                                                                                                                      \n",
       "\"BF CLUB\"                                                        False                                                                                                            \n",
       "\"CLUB BF\"                                                        False                                                                                                            \n",
       "&beer&love                                                       False                                                                                                            \n",
       "(:Julien:)                                                       False                                                                                                            \n",
       "(KGC2) KosmoGelo II                                              False                                                                                                            \n",
       "\n",
       "[5 rows x 6180 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Genero un dataframe usando el pivot-table y lleno los valores con 0 y las apariciones de los usuarios.\n",
    "pivot_contents = contents_reduced_filtered.pivot_table(index='username/ips',columns=['revisor_comment'],aggfunc={'username/ips':'count'},fill_value=0)\n",
    "pivot_contents = pivot_contents > 0\n",
    "pivot_contents.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False    29863\n",
       "True        74\n",
       "Name: (username/ips, #REDIRECT), dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Por ejemplo la columna #REDIRECT\n",
    "pivot_contents[('username/ips','#REDIRECT')].value_counts()"
   ]
  }
 ],
 "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}