00 Inicios en Python.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"provenance":[{"file_id":"1D4VLSGJkIBVEVffXOb448ios_4u_wmFR","timestamp":1680786934392},{"file_id":"1bChseZSrdGJSXfa-D2_lS0dx98wplQtD","timestamp":1647959291704}]},"kernelspec":{"name":"python3","display_name":"Python 3"}},"cells":[{"cell_type":"markdown","metadata":{"id":"LYvAOR2VzHmW"},"source":["\n","#**Diplomatura en Ciencia de Datos, Aprendizaje Automático y sus Aplicaciones**\n","\n","**Edición 2024**\n","\n","---\n","# Aplicaciones en Python\n","\n","La idea de esta notebook es poder introducir algunos conceptos básicos de estadistica descriptiva y sus aplicaciones en Python. Intentaremos familiarizarnos con algunos\n","conceptos (librerias, paquetes y funciones) que nos facilitaran el camino hacia la manipulacion y procesamiento de los datos."]},{"cell_type":"markdown","source":["## Herramientas de trabajo\n","En esta oportunidad vamos a utilizar el lenguaje de programación Python junto con Google Colab para realizar nuestro primer analisis de la encuesta de sueldos. Recorda que Colab es un servicio cloud basado en los Notebooks de Jupyter, por lo tanto no es necesario descargar nada. A su vez, nos iniciaremos en un primer uso de herramientas de software libre, es decir no necesitas una licencia para porder utilizarlas.\n","\n","<center>\n","<img src=\"https://i.imgur.com/Cq52LcH.png\" height=\"150\" />\n","</center>\n","\n"],"metadata":{"id":"mScAXU4Fd9re"}},{"cell_type":"markdown","source":["## Pero primero: ¡Hola mundo!\n","Si es tu primer experiencia con Python, usá la celda de acá abajo para probar tu primer línea de código. Para imprimirlo en pantalla escribimos print(\"Hola mundo!\")"],"metadata":{"id":"uB9-nvVAeLRC"}},{"cell_type":"code","source":["print(\"hola mundo! bienvenidos a la Diplo!!\") # Probá acá"],"metadata":{"id":"j5svoTz2eRkW","executionInfo":{"status":"ok","timestamp":1712171330284,"user_tz":180,"elapsed":6,"user":{"displayName":"Karim Alejandra Nemer Pelliza","userId":"06397025533487730945"}},"colab":{"base_uri":"https://localhost:8080/"},"outputId":"2f5932ca-84c9-48eb-e708-8c59e9899dcd"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["hola mundo! bienvenidos a la Diplo!!\n"]}]},{"cell_type":"markdown","source":["## ¿Que es \"EDA\"?\n","\n","En sus siglas en inglés hace referencia al **Análisis Exploratorio de Datos**. Este es el primer paso que debemos realizar como Data Scientists y consta de una primera revisión del estado de los datos y los consecuentes pasos necesarios para una correcta transformación.\n","\n","La ciencia de datos es una disciplina que te permite convertir datos crudos en entendimiento, comprensión y conocimiento.\n","\n","<center>\n","<img src=\"https://i.imgur.com/jclXnDS.png\" height=\"230\" />\n","</center>\n","\n","\n","En este sentido, el primer objetivo radica en preguntarnos **¿De qué se trata este dataset?**"],"metadata":{"id":"MwB8UHuie9Qh"}},{"cell_type":"markdown","source":["## Importación de librerías\n","\n","El concepto correcto en español es \"biblioteca\". Una biblioteca es básicamente un componente de software que nos brinda acceso a distintas funcionalidades.\n","Existen librerías con funciones para leer un archivo excel o csv y trabajar los datos como tablas (librería Pandas, por ejemplo), otras con funciones para graficar nuestros datos (como Seaborn), para trabajar con cálculo numérico (como Numpy).\n","Cualquiera sea el lenguaje con el que se decida programar, será útil conocer mediante la página oficial del lenguaje cuáles son las librerías disponibles, que nos facilitarán, en éste caso, el análisis de datos."],"metadata":{"id":"tqGTauDXerBG"}},{"cell_type":"code","source":["import matplotlib\n","import matplotlib.pyplot as plt\n","import numpy as np\n","import pandas as pd\n","import seaborn as sns\n","\n","sns.set(rc={'figure.figsize':(10,6)})"],"metadata":{"id":"mlMM0JkSeqkw"},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":["# Leer dataset Encuesta Sysarmy en formato csv\n","\n","En esta primera notebook, aprendemos cómo cargar un conjunto de datos utilizando pandas y cómo ver su contenido.\n","\n","Durante la materia, se trabajará con la Encuesta Sysarmy del año 2023 versión 2. Se trata de una encuesta personal y voluntaria que busca relevar información sobre salarios y condiciones de trabajo de programadores, que se realiza anualmente.\n","\n","Se analizarán sólo los datos provenientes de Argentina\n","\n","\n","[Link a los datos](https://sysarmy.com/blog/posts/resultados-de-la-encuesta-de-sueldos-2023-2/)"],"metadata":{"id":"szPK4onQdemj"}},{"cell_type":"markdown","metadata":{"id":"XY2Hl-Ma07Nn"},"source":["## ¿Cómo leer datos desde un archivo utilizando pandas?\n"]},{"cell_type":"code","metadata":{"id":"Xwdfo7z20TUK"},"source":["import io\n","import pandas as pd\n","\n","pd.set_option('display.max_rows', 4) # cambiar el número de filas que se mostrarán usando display.max_rows."],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"2K03a1xA1Jfv"},"source":["### Subiendo el archivo al entorno de Colaboratory\n","\n","Colaboratory no tiene acceso a nuestro sistema de archivos local (¡menos mal!). Por ello, para poder leer un archivo, primero debemos subirlo a la nube. Eso se logra con:"]},{"cell_type":"code","metadata":{"id":"GjE6NSRdx9d4","colab":{"base_uri":"https://localhost:8080/","height":73},"executionInfo":{"status":"ok","timestamp":1712321677954,"user_tz":180,"elapsed":73055,"user":{"displayName":"ANA GEORGINA FLESIA","userId":"06600501239941405182"}},"outputId":"b1f3235e-f710-494c-a5c8-11f6937beefd"},"source":["from google.colab import files\n","uploaded = files.upload()"],"execution_count":null,"outputs":[{"output_type":"display_data","data":{"text/plain":["<IPython.core.display.HTML object>"],"text/html":["\n","     <input type=\"file\" id=\"files-84e196c2-870e-4439-931d-73f3e442ba7c\" name=\"files[]\" multiple disabled\n","        style=\"border:none\" />\n","     <output id=\"result-84e196c2-870e-4439-931d-73f3e442ba7c\">\n","      Upload widget is only available when the cell has been executed in the\n","      current browser session. Please rerun this cell to enable.\n","      </output>\n","      <script>// Copyright 2017 Google LLC\n","//\n","// Licensed under the Apache License, Version 2.0 (the \"License\");\n","// you may not use this file except in compliance with the License.\n","// You may obtain a copy of the License at\n","//\n","//      http://www.apache.org/licenses/LICENSE-2.0\n","//\n","// Unless required by applicable law or agreed to in writing, software\n","// distributed under the License is distributed on an \"AS IS\" BASIS,\n","// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\n","// See the License for the specific language governing permissions and\n","// limitations under the License.\n","\n","/**\n"," * @fileoverview Helpers for google.colab Python module.\n"," */\n","(function(scope) {\n","function span(text, styleAttributes = {}) {\n","  const element = document.createElement('span');\n","  element.textContent = text;\n","  for (const key of Object.keys(styleAttributes)) {\n","    element.style[key] = styleAttributes[key];\n","  }\n","  return element;\n","}\n","\n","// Max number of bytes which will be uploaded at a time.\n","const MAX_PAYLOAD_SIZE = 100 * 1024;\n","\n","function _uploadFiles(inputId, outputId) {\n","  const steps = uploadFilesStep(inputId, outputId);\n","  const outputElement = document.getElementById(outputId);\n","  // Cache steps on the outputElement to make it available for the next call\n","  // to uploadFilesContinue from Python.\n","  outputElement.steps = steps;\n","\n","  return _uploadFilesContinue(outputId);\n","}\n","\n","// This is roughly an async generator (not supported in the browser yet),\n","// where there are multiple asynchronous steps and the Python side is going\n","// to poll for completion of each step.\n","// This uses a Promise to block the python side on completion of each step,\n","// then passes the result of the previous step as the input to the next step.\n","function _uploadFilesContinue(outputId) {\n","  const outputElement = document.getElementById(outputId);\n","  const steps = outputElement.steps;\n","\n","  const next = steps.next(outputElement.lastPromiseValue);\n","  return Promise.resolve(next.value.promise).then((value) => {\n","    // Cache the last promise value to make it available to the next\n","    // step of the generator.\n","    outputElement.lastPromiseValue = value;\n","    return next.value.response;\n","  });\n","}\n","\n","/**\n"," * Generator function which is called between each async step of the upload\n"," * process.\n"," * @param {string} inputId Element ID of the input file picker element.\n"," * @param {string} outputId Element ID of the output display.\n"," * @return {!Iterable<!Object>} Iterable of next steps.\n"," */\n","function* uploadFilesStep(inputId, outputId) {\n","  const inputElement = document.getElementById(inputId);\n","  inputElement.disabled = false;\n","\n","  const outputElement = document.getElementById(outputId);\n","  outputElement.innerHTML = '';\n","\n","  const pickedPromise = new Promise((resolve) => {\n","    inputElement.addEventListener('change', (e) => {\n","      resolve(e.target.files);\n","    });\n","  });\n","\n","  const cancel = document.createElement('button');\n","  inputElement.parentElement.appendChild(cancel);\n","  cancel.textContent = 'Cancel upload';\n","  const cancelPromise = new Promise((resolve) => {\n","    cancel.onclick = () => {\n","      resolve(null);\n","    };\n","  });\n","\n","  // Wait for the user to pick the files.\n","  const files = yield {\n","    promise: Promise.race([pickedPromise, cancelPromise]),\n","    response: {\n","      action: 'starting',\n","    }\n","  };\n","\n","  cancel.remove();\n","\n","  // Disable the input element since further picks are not allowed.\n","  inputElement.disabled = true;\n","\n","  if (!files) {\n","    return {\n","      response: {\n","        action: 'complete',\n","      }\n","    };\n","  }\n","\n","  for (const file of files) {\n","    const li = document.createElement('li');\n","    li.append(span(file.name, {fontWeight: 'bold'}));\n","    li.append(span(\n","        `(${file.type || 'n/a'}) - ${file.size} bytes, ` +\n","        `last modified: ${\n","            file.lastModifiedDate ? file.lastModifiedDate.toLocaleDateString() :\n","                                    'n/a'} - `));\n","    const percent = span('0% done');\n","    li.appendChild(percent);\n","\n","    outputElement.appendChild(li);\n","\n","    const fileDataPromise = new Promise((resolve) => {\n","      const reader = new FileReader();\n","      reader.onload = (e) => {\n","        resolve(e.target.result);\n","      };\n","      reader.readAsArrayBuffer(file);\n","    });\n","    // Wait for the data to be ready.\n","    let fileData = yield {\n","      promise: fileDataPromise,\n","      response: {\n","        action: 'continue',\n","      }\n","    };\n","\n","    // Use a chunked sending to avoid message size limits. See b/62115660.\n","    let position = 0;\n","    do {\n","      const length = Math.min(fileData.byteLength - position, MAX_PAYLOAD_SIZE);\n","      const chunk = new Uint8Array(fileData, position, length);\n","      position += length;\n","\n","      const base64 = btoa(String.fromCharCode.apply(null, chunk));\n","      yield {\n","        response: {\n","          action: 'append',\n","          file: file.name,\n","          data: base64,\n","        },\n","      };\n","\n","      let percentDone = fileData.byteLength === 0 ?\n","          100 :\n","          Math.round((position / fileData.byteLength) * 100);\n","      percent.textContent = `${percentDone}% done`;\n","\n","    } while (position < fileData.byteLength);\n","  }\n","\n","  // All done.\n","  yield {\n","    response: {\n","      action: 'complete',\n","    }\n","  };\n","}\n","\n","scope.google = scope.google || {};\n","scope.google.colab = scope.google.colab || {};\n","scope.google.colab._files = {\n","  _uploadFiles,\n","  _uploadFilesContinue,\n","};\n","})(self);\n","</script> "]},"metadata":{}},{"output_type":"stream","name":"stdout","text":["Saving 2023.2 - Sysarmy - Encuesta de remuneración salarial Argentina - Dataset raw.csv to 2023.2 - Sysarmy - Encuesta de remuneración salarial Argentina - Dataset raw.csv\n"]}]},{"cell_type":"markdown","metadata":{"id":"NX17LoUA1ViC"},"source":["En la salida de la celda anterior, verán el texto\n","\n","```\n","Saving 2023.2 - Sysarmy - Encuesta de remuneración salarial Argentina - Dataset raw.csv to XXX\n","```\n","El texto XXX será la clave del archivo, que se utiliza para identificarlo entre todos los archivos subidos. Tener en cuenta que esta clave no necesariamente es el nombre del archivo.\n"]},{"cell_type":"code","metadata":{"id":"__ECd-9myy6k"},"source":["file_key = '2023.2 - Sysarmy - Encuesta de remuneración salarial Argentina - Dataset raw.csv'  # Replace for corresponding key\n","df = pd.read_csv(io.StringIO(uploaded[file_key].decode('utf-8')))"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"vo0-WxeI16h3"},"source":["Con esta operación, hemos creado un DataFrame de pandas en base al archivo de respuestas. Un DataFrame no es más que una tabla sobre la cual podemos aplicar un montón de operaciones similares a las de Excel o a las SQL. En esta notebook no pretendemos hacer un tutorial de pandas, el Internet está lleno de ellos, pero sí iremos explicando cómo implementar determinadas operaciones necesarias para el análisis de este conjunto de datos.\n","\n","Veamos qué valor tiene la variable `df`."]},{"cell_type":"code","metadata":{"id":"V5k7IUmG0ptW","colab":{"base_uri":"https://localhost:8080/","height":568},"executionInfo":{"status":"ok","timestamp":1712321728138,"user_tz":180,"elapsed":3,"user":{"displayName":"ANA GEORGINA FLESIA","userId":"06600501239941405182"}},"outputId":"7f47469c-ca1f-4d4c-84ba-f504b0837dda"},"source":["df[:10]"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["   Para analizar los resultados podés bajar el .csv (Archivo > Descargar como)  \\\n","0                                                 NaN                            \n","1   Recordá calificar a la empresa donde estás tra...                            \n","..                                                ...                            \n","8                                           Argentina                            \n","9                                           Argentina                            \n","\n","   Unnamed: 1 Unnamed: 2                 Unnamed: 3 Unnamed: 4 Unnamed: 5  \\\n","0         NaN        NaN                        NaN        NaN        NaN   \n","1         NaN        NaN                        NaN        NaN        NaN   \n","..        ...        ...                        ...        ...        ...   \n","8   Catamarca  Full-Time  Staff (planta permanente)     650000     520000   \n","9   Catamarca  Full-Time  Staff (planta permanente)     125000     104000   \n","\n","   Unnamed: 6 Unnamed: 7 Unnamed: 8      Unnamed: 9  ... Unnamed: 33  \\\n","0         NaN        NaN        NaN             NaN  ...         NaN   \n","1         NaN        NaN        NaN             NaN  ...         NaN   \n","..        ...        ...        ...             ...  ...         ...   \n","8         NaN        NaN         No  No recibo bono  ...    Completo   \n","9         NaN        NaN         No  No recibo bono  ...         NaN   \n","\n","                                Unnamed: 34           Unnamed: 35  \\\n","0                                       NaN                   NaN   \n","1                                       NaN                   NaN   \n","..                                      ...                   ...   \n","8   Licenciatura en Sistemas de Información  Universidad Siglo 21   \n","9                                       NaN                   NaN   \n","\n","          Unnamed: 36 Unnamed: 37 Unnamed: 38 Unnamed: 39 Unnamed: 40  \\\n","0                 NaN         NaN         NaN         NaN         NaN   \n","1                 NaN         NaN         NaN         NaN         NaN   \n","..                ...         ...         ...         ...         ...   \n","8   Terminar encuesta         NaN         NaN         NaN         NaN   \n","9                 NaN         NaN         NaN         NaN         NaN   \n","\n","   Unnamed: 41 Unnamed: 42  \n","0          NaN         NaN  \n","1          NaN         NaN  \n","..         ...         ...  \n","8           45   Varón Cis  \n","9           29   Mujer Cis  \n","\n","[10 rows x 43 columns]"],"text/html":["\n","  <div id=\"df-e6cb0128-438b-4fdd-a63f-7838b49e477a\" class=\"colab-df-container\">\n","    <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>Para analizar los resultados podés bajar el .csv (Archivo &gt; Descargar como)</th>\n","      <th>Unnamed: 1</th>\n","      <th>Unnamed: 2</th>\n","      <th>Unnamed: 3</th>\n","      <th>Unnamed: 4</th>\n","      <th>Unnamed: 5</th>\n","      <th>Unnamed: 6</th>\n","      <th>Unnamed: 7</th>\n","      <th>Unnamed: 8</th>\n","      <th>Unnamed: 9</th>\n","      <th>...</th>\n","      <th>Unnamed: 33</th>\n","      <th>Unnamed: 34</th>\n","      <th>Unnamed: 35</th>\n","      <th>Unnamed: 36</th>\n","      <th>Unnamed: 37</th>\n","      <th>Unnamed: 38</th>\n","      <th>Unnamed: 39</th>\n","      <th>Unnamed: 40</th>\n","      <th>Unnamed: 41</th>\n","      <th>Unnamed: 42</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Recordá calificar a la empresa donde estás tra...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <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>8</th>\n","      <td>Argentina</td>\n","      <td>Catamarca</td>\n","      <td>Full-Time</td>\n","      <td>Staff (planta permanente)</td>\n","      <td>650000</td>\n","      <td>520000</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>No</td>\n","      <td>No recibo bono</td>\n","      <td>...</td>\n","      <td>Completo</td>\n","      <td>Licenciatura en Sistemas de Información</td>\n","      <td>Universidad Siglo 21</td>\n","      <td>Terminar encuesta</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>45</td>\n","      <td>Varón Cis</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>Argentina</td>\n","      <td>Catamarca</td>\n","      <td>Full-Time</td>\n","      <td>Staff (planta permanente)</td>\n","      <td>125000</td>\n","      <td>104000</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>No</td>\n","      <td>No recibo bono</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>29</td>\n","      <td>Mujer Cis</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>10 rows × 43 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-e6cb0128-438b-4fdd-a63f-7838b49e477a')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-e6cb0128-438b-4fdd-a63f-7838b49e477a button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-e6cb0128-438b-4fdd-a63f-7838b49e477a');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-3e84baa0-fee6-47d3-a0d0-7e99c1b6ff3c\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-3e84baa0-fee6-47d3-a0d0-7e99c1b6ff3c')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-3e84baa0-fee6-47d3-a0d0-7e99c1b6ff3c button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe"}},"metadata":{},"execution_count":23}]},{"cell_type":"markdown","metadata":{"id":"LE_XEAA02Fro"},"source":["## Selección de filas\n","\n","¡No es lo que esperamos! Si vemos el conjunto de datos, efectivamente tiene celdas en blanco en la parte superior, y el nombre de las columnas aparece en la fila 7. Con Pandas podemos manejar estas situaciones pasando argumentos específicos a la función `pd.read_csv`"]},{"cell_type":"code","metadata":{"id":"qlUQleaS2cYL"},"source":["df_fixed = pd.read_csv(\n","    io.StringIO(uploaded[file_key].decode('utf-8')),\n","    skiprows=range(6), header=1)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"mxS1Zwnn3uC4","colab":{"base_uri":"https://localhost:8080/","height":470},"executionInfo":{"status":"ok","timestamp":1712321736086,"user_tz":180,"elapsed":351,"user":{"displayName":"ANA GEORGINA FLESIA","userId":"06600501239941405182"}},"outputId":"c77348ff-8709-4ca7-85af-a2064df2b00d"},"source":["df_fixed[:3]"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["  Estoy trabajando en Dónde estás trabajando Dedicación  \\\n","0           Argentina              Catamarca  Full-Time   \n","1           Argentina              Catamarca  Full-Time   \n","2           Argentina              Catamarca  Full-Time   \n","\n","            Tipo de contrato  \\\n","0  Staff (planta permanente)   \n","1  Staff (planta permanente)   \n","2  Staff (planta permanente)   \n","\n","   Último salario mensual  o retiro BRUTO (en tu moneda local)  \\\n","0                                           680000.0             \n","1                                           650000.0             \n","2                                           125000.0             \n","\n","   Último salario mensual o retiro NETO (en tu moneda local) Pagos en dólares  \\\n","0                                           520000.0                      NaN   \n","1                                           520000.0                      NaN   \n","2                                           104000.0                      NaN   \n","\n","  Si tu sueldo está dolarizado ¿Cuál fue el último valor del dólar que tomaron?  \\\n","0                                                NaN                              \n","1                                                NaN                              \n","2                                                NaN                              \n","\n","  Recibís algún tipo de bono A qué está atado el bono  ...    Estado  \\\n","0                         No           No recibo bono  ...       NaN   \n","1                         No           No recibo bono  ...  Completo   \n","2                         No           No recibo bono  ...       NaN   \n","\n","                                   Carrera Institución educativa  \\\n","0                                      NaN                   NaN   \n","1  Licenciatura en Sistemas de Información  Universidad Siglo 21   \n","2                                      NaN                   NaN   \n","\n","   ¿Salir o seguir contestando sobre las guardias? ¿Tenés guardias?  \\\n","0                                              NaN              NaN   \n","1                                Terminar encuesta              NaN   \n","2                                              NaN              NaN   \n","\n","   Cuánto cobrás por guardia  \\\n","0                        NaN   \n","1                        NaN   \n","2                        NaN   \n","\n","  Aclará el número que ingresaste en el campo anterior  \\\n","0                                                NaN     \n","1                                                NaN     \n","2                                                NaN     \n","\n","   ¿Salir o seguir contestando sobre estudios?  Tengo (edad)  \\\n","0                                          NaN            36   \n","1                                          NaN            45   \n","2                                          NaN            29   \n","\n","   Me identifico (género)  \n","0               Varón Cis  \n","1               Varón Cis  \n","2               Mujer Cis  \n","\n","[3 rows x 43 columns]"],"text/html":["\n","  <div id=\"df-436439b5-5538-4fde-8ce6-ef4b432769e7\" class=\"colab-df-container\">\n","    <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>Estoy trabajando en</th>\n","      <th>Dónde estás trabajando</th>\n","      <th>Dedicación</th>\n","      <th>Tipo de contrato</th>\n","      <th>Último salario mensual  o retiro BRUTO (en tu moneda local)</th>\n","      <th>Último salario mensual o retiro NETO (en tu moneda local)</th>\n","      <th>Pagos en dólares</th>\n","      <th>Si tu sueldo está dolarizado ¿Cuál fue el último valor del dólar que tomaron?</th>\n","      <th>Recibís algún tipo de bono</th>\n","      <th>A qué está atado el bono</th>\n","      <th>...</th>\n","      <th>Estado</th>\n","      <th>Carrera</th>\n","      <th>Institución educativa</th>\n","      <th>¿Salir o seguir contestando sobre las guardias?</th>\n","      <th>¿Tenés guardias?</th>\n","      <th>Cuánto cobrás por guardia</th>\n","      <th>Aclará el número que ingresaste en el campo anterior</th>\n","      <th>¿Salir o seguir contestando sobre estudios?</th>\n","      <th>Tengo (edad)</th>\n","      <th>Me identifico (género)</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Argentina</td>\n","      <td>Catamarca</td>\n","      <td>Full-Time</td>\n","      <td>Staff (planta permanente)</td>\n","      <td>680000.0</td>\n","      <td>520000.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>No</td>\n","      <td>No recibo bono</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>36</td>\n","      <td>Varón Cis</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Argentina</td>\n","      <td>Catamarca</td>\n","      <td>Full-Time</td>\n","      <td>Staff (planta permanente)</td>\n","      <td>650000.0</td>\n","      <td>520000.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>No</td>\n","      <td>No recibo bono</td>\n","      <td>...</td>\n","      <td>Completo</td>\n","      <td>Licenciatura en Sistemas de Información</td>\n","      <td>Universidad Siglo 21</td>\n","      <td>Terminar encuesta</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>45</td>\n","      <td>Varón Cis</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>Argentina</td>\n","      <td>Catamarca</td>\n","      <td>Full-Time</td>\n","      <td>Staff (planta permanente)</td>\n","      <td>125000.0</td>\n","      <td>104000.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>No</td>\n","      <td>No recibo bono</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>29</td>\n","      <td>Mujer Cis</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>3 rows × 43 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-436439b5-5538-4fde-8ce6-ef4b432769e7')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-436439b5-5538-4fde-8ce6-ef4b432769e7 button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-436439b5-5538-4fde-8ce6-ef4b432769e7');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-b6c6da50-357b-42dd-a691-b1791c625958\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-b6c6da50-357b-42dd-a691-b1791c625958')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-b6c6da50-357b-42dd-a691-b1791c625958 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe"}},"metadata":{},"execution_count":25}]},{"cell_type":"markdown","metadata":{"id":"7hPqJAun2h5A"},"source":["## Renombrar columnas"]},{"cell_type":"markdown","metadata":{"id":"sO9wLpYI0l64"},"source":["Para trabajar más cómodamente, renombraremos las columnas de DataFrame. Tengan cuidado de que el orden de los nombres nuevos se corresponda con el contenido de cada columna.\n"]},{"cell_type":"code","metadata":{"id":"K_G1sEljywQ3","colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"status":"ok","timestamp":1712321773927,"user_tz":180,"elapsed":316,"user":{"displayName":"ANA GEORGINA FLESIA","userId":"06600501239941405182"}},"outputId":"ba9a22ab-3f27-446c-f5fc-c5e4a96773ed"},"source":["df_fixed.columns"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["Index(['Estoy trabajando en', 'Dónde estás trabajando', 'Dedicación',\n","       'Tipo de contrato',\n","       'Último salario mensual  o retiro BRUTO (en tu moneda local)',\n","       'Último salario mensual o retiro NETO (en tu moneda local)',\n","       'Pagos en dólares',\n","       'Si tu sueldo está dolarizado ¿Cuál fue el último valor del dólar que tomaron?',\n","       'Recibís algún tipo de bono', 'A qué está atado el bono',\n","       '¿Tuviste actualizaciones de tus ingresos laborales durante 2023?',\n","       '¿De qué % fue el ajuste total acumulado?',\n","       '¿En qué mes fue el último ajuste?',\n","       'Cómo considerás que están tus ingresos laborales comparados con el semestre anterior',\n","       '¿Contás con beneficios adicionales?',\n","       '¿Qué tan conforme estás con tus ingresos laborales?', 'Trabajo de',\n","       'Años de experiencia', 'Antigüedad en la empresa actual',\n","       'Tiempo en el puesto actual', '¿Cuántas personas a cargo tenés?',\n","       'Plataformas que utilizas en tu puesto actual',\n","       'Lenguajes de programación o tecnologías que utilices en tu puesto actual',\n","       'Frameworks, herramientas y librerías que utilices en tu puesto actual',\n","       'Bases de datos', 'QA / Testing',\n","       'Cantidad de personas en tu organización', 'Modalidad de trabajo',\n","       'Si trabajás bajo un esquema híbrido ¿Cuántos días a la semana vas a la oficina?',\n","       '¿La recomendás como un buen lugar para trabajar?',\n","       '¿Qué tanto estás usando Copilot, ChatGPT u otras herramientas de IA para tu trabajo?',\n","       '¿Salir o seguir contestando?', 'Máximo nivel de estudios', 'Estado',\n","       'Carrera', 'Institución educativa',\n","       '¿Salir o seguir contestando sobre las guardias?', '¿Tenés guardias?',\n","       'Cuánto cobrás por guardia',\n","       'Aclará el número que ingresaste en el campo anterior',\n","       '¿Salir o seguir contestando sobre estudios?', 'Tengo (edad)',\n","       'Me identifico (género)'],\n","      dtype='object')"]},"metadata":{},"execution_count":26}]},{"cell_type":"code","metadata":{"id":"mhhPGu3L6N75"},"source":["new_columns = {\n","    'profile': {\n","      'Me identifico (género)': 'gender', 'Tengo (edad)': 'age', 'Años de experiencia': 'years_experience',\n","      'Máximo nivel de estudios': 'studies_level',\n","      'Estado': 'studies_level_state', 'Carrera': 'career', 'Universidad': 'university',\n","      '¿Participaste de algún Boot Camp?': 'boot_camp',\n","      'Si participaste de un Boot Camp, ¿qué carrera estudiaste?': 'boot_camp_carrer',\n","      '¿Programás como hobbie?': 'programming_as_hobby',\n","      'Orientación sexual': 'sexual_orientation',\n","      '¿Tenés algún tipo de discapacidad?': 'has_disabilities',\n","      '¿Sentís que alguna vez los prejuicios culturales/sociales sobre tu orientación, género, etnia o discapacidad pudieron obstaculizar el que consigas un trabajo?': 'has_disabilities_hiring_difficulties',\n","  },\n","  'work' : {\n","      'Estoy trabajando en': 'country',\n","      'Dónde estás trabajando': 'province', 'Antigüedad en la empresa actual': 'years_in_company',\n","      'Tiempo en el puesto actual': 'years_in_current_position', '¿Cuántas personas a cargo tenés?': 'people_in_charge_of',\n","      '¿Tenés guardias?': 'on_call_duty',\n","      '¿Porcentaje, bruto o neto?': 'on_call_duty_charge_type', 'Modalidad de trabajo':'work_modality', 'Tipo de contrato':'contract_type', 'Dedicación': 'dedication',\n","      'Sufriste o presenciaste situaciones de violencia y/o acoso por motivo de': 'has_violence_situations',\n","      '¿Considerás que tenés oportunidades de crecimiento siendo quien sos dentro de tu organización?':'listen_more_men',\n","      '¿Sentís que podés ser vos en tu trabajo?': 'yourself_in_your_work',\n","      'En el último año, en tu trabajo ¿recibiste o escuchaste comentarios que considerás inapropiados, subidos de tono y/o discriminatorios?':'lastyear_discrimination',\n","  },\n","  'tools': {\n","      'Plataformas que utilizas en tu puesto actual': 'platform', 'Lenguajes de programación o tecnologías que utilices en tu puesto actual': 'programming_languages',\n","      'Frameworks, herramientas y librerías que utilices en tu puesto actual': 'frameworks', 'Bases de datos': 'data_bases',\n","      'QA / Testing': 'qa_testing', 'IDEs': 'IDEs',\n","      '¿Qué SO usás en tu laptop/PC para trabajar?': 'work_pc_os', '¿Y en tu celular?': 'cellphone_os'\n","  },\n","  'salary': {\n","      'Cuánto cobrás por guardia': 'on_call_duty_charge',\n","      'Último salario mensual  o retiro BRUTO (en tu moneda local)': 'monthly_BRUTO',\n","      'Último salario mensual o retiro NETO (en tu moneda local)': 'monthly_NETO',\n","      'Pagos en dólares': 'in_usd', 'Si tu sueldo está dolarizado ¿Cuál fue el último valor del dólar que tomaron?':'last_dollar_value','¿Qué tan conforme estás con tus ingresos laborales?': 'satisfaction',\n","      'Cómo considerás que están tus ingresos laborales comparados con el semestre anterior': 'comparison_last_semester',\n","      'Recibís algún tipo de bono': 'has_bonus', 'A qué está atado el bono': 'bonus_tied_to',\n","      'Pagos en criptomonedas':'pay_cripto','¿Qué porcentaje o monto recibís en criptomonedas?':'%_cripto',\n","      '¿Tuviste actualizaciones de tus ingresos laborales durante 2023?': 'inflation_adjustment',\n","      '¿De qué % fue el ajuste total acumulado?': 'percentage_inflation_adjustment',\n","      '¿En qué mes fue el último ajuste? *': 'month_last_inflation_adjustment','Con qué beneficios contas':'benefit'\n","  },\n","  'company' : {\n","      'Cantidad de personas en tu organización': 'employee_number', 'Actividad principal': 'main_activity',\n","      '¿La recomendás como un buen lugar para trabajar?': 'recommended',\n","      '¿Cuál es el compromiso que tiene tu empresa con la diversidad, la equidad y la inclusión?': 'diversity_policies',\n","      'Beneficios extra': 'extra_benefits', '¿Instauraron algún beneficio nuevo?': 'new_benefits',\n","      '¿Qué tanto sentís que te está apoyando tu empresa/organización durante la pandemia?': 'pandemic_support',\n","      '¿Cuántas veces a la semana vas a trabajar a la oficina?':'days_in_the_office',\n","  }\n","}\n"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"r0xlsKaBk0RL"},"source":["def replace_columns(df, new_columns):\n","  new_col_names = {\n","    original_name: category + '_' + new_name\n","    for category, cols in new_columns.items()\n","    for original_name, new_name in cols.items()\n","  }\n","  return df.rename(columns=new_col_names)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"Vviv_sqXdR5W","colab":{"base_uri":"https://localhost:8080/","height":481},"executionInfo":{"status":"ok","timestamp":1712321889185,"user_tz":180,"elapsed":312,"user":{"displayName":"ANA GEORGINA FLESIA","userId":"06600501239941405182"}},"outputId":"ca048437-8704-4d86-b599-7118b980af9f"},"source":["df_renamed = replace_columns(df_fixed, new_columns)\n","df_renamed[:6]"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["   work_country work_province work_dedication  \\\n","0     Argentina     Catamarca       Full-Time   \n","1     Argentina     Catamarca       Full-Time   \n","..          ...           ...             ...   \n","4     Argentina         Chaco       Full-Time   \n","5     Argentina         Chaco       Full-Time   \n","\n","                                   work_contract_type  salary_monthly_BRUTO  \\\n","0                           Staff (planta permanente)              680000.0   \n","1                           Staff (planta permanente)              650000.0   \n","..                                                ...                   ...   \n","4   Tercerizado (trabajo a través de consultora o ...              250000.0   \n","5                           Staff (planta permanente)              276000.0   \n","\n","    salary_monthly_NETO salary_in_usd salary_last_dollar_value  \\\n","0              520000.0           NaN                      NaN   \n","1              520000.0           NaN                      NaN   \n","..                  ...           ...                      ...   \n","4              207000.0           NaN                      NaN   \n","5              229000.0           NaN                      NaN   \n","\n","   salary_has_bonus salary_bonus_tied_to  ... profile_studies_level_state  \\\n","0                No       No recibo bono  ...                         NaN   \n","1                No       No recibo bono  ...                    Completo   \n","..              ...                  ...  ...                         ...   \n","4                No       No recibo bono  ...                         NaN   \n","5                No       No recibo bono  ...                    Completo   \n","\n","                             profile_career  \\\n","0                                       NaN   \n","1   Licenciatura en Sistemas de Información   \n","..                                      ...   \n","4                                       NaN   \n","5        Analista Universitario de Sistemas   \n","\n","                     Institución educativa  \\\n","0                                      NaN   \n","1                     Universidad Siglo 21   \n","..                                     ...   \n","4                                      NaN   \n","5   UTN - Universidad Tecnológica Nacional   \n","\n","    ¿Salir o seguir contestando sobre las guardias? work_on_call_duty  \\\n","0                                               NaN               NaN   \n","1                                 Terminar encuesta               NaN   \n","..                                              ...               ...   \n","4                                               NaN               NaN   \n","5                          Responder sobre guardias        Sí, pasiva   \n","\n","    salary_on_call_duty_charge  \\\n","0                          NaN   \n","1                          NaN   \n","..                         ...   \n","4                          NaN   \n","5                          0.0   \n","\n","   Aclará el número que ingresaste en el campo anterior  \\\n","0                                                 NaN     \n","1                                                 NaN     \n","..                                                ...     \n","4                                                 NaN     \n","5                       Porcentaje de mi sueldo bruto     \n","\n","    ¿Salir o seguir contestando sobre estudios?  profile_age  profile_gender  \n","0                                           NaN           36       Varón Cis  \n","1                                           NaN           45       Varón Cis  \n","..                                          ...          ...             ...  \n","4                                           NaN           32       Varón Cis  \n","5                             Terminar encuesta           28       Varón Cis  \n","\n","[6 rows x 43 columns]"],"text/html":["\n","  <div id=\"df-f7d4d344-4706-43bc-9a35-13671be80bd3\" class=\"colab-df-container\">\n","    <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>work_country</th>\n","      <th>work_province</th>\n","      <th>work_dedication</th>\n","      <th>work_contract_type</th>\n","      <th>salary_monthly_BRUTO</th>\n","      <th>salary_monthly_NETO</th>\n","      <th>salary_in_usd</th>\n","      <th>salary_last_dollar_value</th>\n","      <th>salary_has_bonus</th>\n","      <th>salary_bonus_tied_to</th>\n","      <th>...</th>\n","      <th>profile_studies_level_state</th>\n","      <th>profile_career</th>\n","      <th>Institución educativa</th>\n","      <th>¿Salir o seguir contestando sobre las guardias?</th>\n","      <th>work_on_call_duty</th>\n","      <th>salary_on_call_duty_charge</th>\n","      <th>Aclará el número que ingresaste en el campo anterior</th>\n","      <th>¿Salir o seguir contestando sobre estudios?</th>\n","      <th>profile_age</th>\n","      <th>profile_gender</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Argentina</td>\n","      <td>Catamarca</td>\n","      <td>Full-Time</td>\n","      <td>Staff (planta permanente)</td>\n","      <td>680000.0</td>\n","      <td>520000.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>No</td>\n","      <td>No recibo bono</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>36</td>\n","      <td>Varón Cis</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Argentina</td>\n","      <td>Catamarca</td>\n","      <td>Full-Time</td>\n","      <td>Staff (planta permanente)</td>\n","      <td>650000.0</td>\n","      <td>520000.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>No</td>\n","      <td>No recibo bono</td>\n","      <td>...</td>\n","      <td>Completo</td>\n","      <td>Licenciatura en Sistemas de Información</td>\n","      <td>Universidad Siglo 21</td>\n","      <td>Terminar encuesta</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>45</td>\n","      <td>Varón Cis</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Argentina</td>\n","      <td>Chaco</td>\n","      <td>Full-Time</td>\n","      <td>Tercerizado (trabajo a través de consultora o ...</td>\n","      <td>250000.0</td>\n","      <td>207000.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>No</td>\n","      <td>No recibo bono</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>32</td>\n","      <td>Varón Cis</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>Argentina</td>\n","      <td>Chaco</td>\n","      <td>Full-Time</td>\n","      <td>Staff (planta permanente)</td>\n","      <td>276000.0</td>\n","      <td>229000.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>No</td>\n","      <td>No recibo bono</td>\n","      <td>...</td>\n","      <td>Completo</td>\n","      <td>Analista Universitario de Sistemas</td>\n","      <td>UTN - Universidad Tecnológica Nacional</td>\n","      <td>Responder sobre guardias</td>\n","      <td>Sí, pasiva</td>\n","      <td>0.0</td>\n","      <td>Porcentaje de mi sueldo bruto</td>\n","      <td>Terminar encuesta</td>\n","      <td>28</td>\n","      <td>Varón Cis</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>6 rows × 43 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f7d4d344-4706-43bc-9a35-13671be80bd3')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-f7d4d344-4706-43bc-9a35-13671be80bd3 button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-f7d4d344-4706-43bc-9a35-13671be80bd3');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-aaea9837-b79e-4f16-858e-2a1627031b00\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-aaea9837-b79e-4f16-858e-2a1627031b00')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-aaea9837-b79e-4f16-858e-2a1627031b00 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe"}},"metadata":{},"execution_count":34}]},{"cell_type":"markdown","metadata":{"id":"uSDnDiHArKx6"},"source":["### Leer archivo desde URL\n","\n","Como realizar estas operaciones es un poco tedioso y requiere intervención manual, hemos subido el dataset a un servidor local de FaMAF para poder accederlos directamente a través de consultas HTTP (por ejemplo, desde un navegador).\n","\n","Otra forma de disponibilizar un conjunto de datos pequeño es creando un archivo en un repositorio de github o un gist."]},{"cell_type":"markdown","metadata":{"id":"y-Zx4i-o51jh"},"source":["Primero, es necesario descargar el archivo ya procesado. El procedimiento es similar a leer el archivo.\n","1. Se guarda el DataFrame en un archivo en el servidor remoto.\n","2. Se descarga ese archivo."]},{"cell_type":"code","metadata":{"id":"3ou7t-TN6Sk2"},"source":["df_renamed.to_csv(\"sysarmy_survey_2023_processed.csv\", index=False)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":17},"id":"EYZxGzTo6QA9","executionInfo":{"status":"ok","timestamp":1712321842905,"user_tz":180,"elapsed":312,"user":{"displayName":"ANA GEORGINA FLESIA","userId":"06600501239941405182"}},"outputId":"9258cf4e-6197-4242-c7a3-de5cafe7224b"},"source":["from google.colab import files\n","files.download(\"sysarmy_survey_2023_processed.csv\")"],"execution_count":null,"outputs":[{"output_type":"display_data","data":{"text/plain":["<IPython.core.display.Javascript object>"],"application/javascript":["\n","    async function download(id, filename, size) {\n","      if (!google.colab.kernel.accessAllowed) {\n","        return;\n","      }\n","      const div = document.createElement('div');\n","      const label = document.createElement('label');\n","      label.textContent = `Downloading \"${filename}\": `;\n","      div.appendChild(label);\n","      const progress = document.createElement('progress');\n","      progress.max = size;\n","      div.appendChild(progress);\n","      document.body.appendChild(div);\n","\n","      const buffers = [];\n","      let downloaded = 0;\n","\n","      const channel = await google.colab.kernel.comms.open(id);\n","      // Send a message to notify the kernel that we're ready.\n","      channel.send({})\n","\n","      for await (const message of channel.messages) {\n","        // Send a message to notify the kernel that we're ready.\n","        channel.send({})\n","        if (message.buffers) {\n","          for (const buffer of message.buffers) {\n","            buffers.push(buffer);\n","            downloaded += buffer.byteLength;\n","            progress.value = downloaded;\n","          }\n","        }\n","      }\n","      const blob = new Blob(buffers, {type: 'application/binary'});\n","      const a = document.createElement('a');\n","      a.href = window.URL.createObjectURL(blob);\n","      a.download = filename;\n","      div.appendChild(a);\n","      a.click();\n","      div.remove();\n","    }\n","  "]},"metadata":{}},{"output_type":"display_data","data":{"text/plain":["<IPython.core.display.Javascript object>"],"application/javascript":["download(\"download_be2a7906-c107-4976-92d8-0a97dcfe8469\", \"sysarmy_survey_2023_processed.csv\", 3435769)"]},"metadata":{}}]},{"cell_type":"markdown","metadata":{"id":"Ug7JEpuV6vkv"},"source":["Subiremos este archivo con el dataset procesado a un servidor de la universidad.\n","\n","Pandas permite leer archivos `.csv` desde una URL, sin necesidad de descargarlos en el sistema de archivos local. La siguiente celda funcionará tanto en Colaboratory como en Jupyter, y será el método por defecto de acceder a los datos en las notebooks siguientes."]},{"cell_type":"code","metadata":{"id":"UR_7-Sm_r3Oa"},"source":["url = 'https://raw.githubusercontent.com/DiploDatos/AnalisisyVisualizacion/master/sysarmy_survey_2023_processed.csv'\n","df2 = pd.read_csv(url)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"gckNHXXLktJ4","colab":{"base_uri":"https://localhost:8080/","height":481},"executionInfo":{"status":"ok","timestamp":1712322250962,"user_tz":180,"elapsed":376,"user":{"displayName":"ANA GEORGINA FLESIA","userId":"06600501239941405182"}},"outputId":"6438173d-0845-493d-da35-7b9184c285bb"},"source":["df2[:6]"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["   work_country work_province work_dedication  \\\n","0     Argentina     Catamarca       Full-Time   \n","1     Argentina     Catamarca       Full-Time   \n","..          ...           ...             ...   \n","4     Argentina         Chaco       Full-Time   \n","5     Argentina         Chaco       Full-Time   \n","\n","                                   work_contract_type  salary_monthly_BRUTO  \\\n","0                           Staff (planta permanente)              680000.0   \n","1                           Staff (planta permanente)              650000.0   \n","..                                                ...                   ...   \n","4   Tercerizado (trabajo a través de consultora o ...              250000.0   \n","5                           Staff (planta permanente)              276000.0   \n","\n","    salary_monthly_NETO salary_in_usd salary_last_dollar_value  \\\n","0              520000.0           NaN                      NaN   \n","1              520000.0           NaN                      NaN   \n","..                  ...           ...                      ...   \n","4              207000.0           NaN                      NaN   \n","5              229000.0           NaN                      NaN   \n","\n","   salary_has_bonus salary_bonus_tied_to  ... profile_studies_level_state  \\\n","0                No       No recibo bono  ...                         NaN   \n","1                No       No recibo bono  ...                    Completo   \n","..              ...                  ...  ...                         ...   \n","4                No       No recibo bono  ...                         NaN   \n","5                No       No recibo bono  ...                    Completo   \n","\n","                             profile_career  \\\n","0                                       NaN   \n","1   Licenciatura en Sistemas de Información   \n","..                                      ...   \n","4                                       NaN   \n","5        Analista Universitario de Sistemas   \n","\n","                     Institución educativa  \\\n","0                                      NaN   \n","1                     Universidad Siglo 21   \n","..                                     ...   \n","4                                      NaN   \n","5   UTN - Universidad Tecnológica Nacional   \n","\n","    ¿Salir o seguir contestando sobre las guardias? work_on_call_duty  \\\n","0                                               NaN               NaN   \n","1                                 Terminar encuesta               NaN   \n","..                                              ...               ...   \n","4                                               NaN               NaN   \n","5                          Responder sobre guardias        Sí, pasiva   \n","\n","    salary_on_call_duty_charge  \\\n","0                          NaN   \n","1                          NaN   \n","..                         ...   \n","4                          NaN   \n","5                          0.0   \n","\n","   Aclará el número que ingresaste en el campo anterior  \\\n","0                                                 NaN     \n","1                                                 NaN     \n","..                                                ...     \n","4                                                 NaN     \n","5                       Porcentaje de mi sueldo bruto     \n","\n","    ¿Salir o seguir contestando sobre estudios?  profile_age  profile_gender  \n","0                                           NaN           36       Varón Cis  \n","1                                           NaN           45       Varón Cis  \n","..                                          ...          ...             ...  \n","4                                           NaN           32       Varón Cis  \n","5                             Terminar encuesta           28       Varón Cis  \n","\n","[6 rows x 43 columns]"],"text/html":["\n","  <div id=\"df-783b4eff-e061-4543-9f7b-951b0167a3f7\" class=\"colab-df-container\">\n","    <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>work_country</th>\n","      <th>work_province</th>\n","      <th>work_dedication</th>\n","      <th>work_contract_type</th>\n","      <th>salary_monthly_BRUTO</th>\n","      <th>salary_monthly_NETO</th>\n","      <th>salary_in_usd</th>\n","      <th>salary_last_dollar_value</th>\n","      <th>salary_has_bonus</th>\n","      <th>salary_bonus_tied_to</th>\n","      <th>...</th>\n","      <th>profile_studies_level_state</th>\n","      <th>profile_career</th>\n","      <th>Institución educativa</th>\n","      <th>¿Salir o seguir contestando sobre las guardias?</th>\n","      <th>work_on_call_duty</th>\n","      <th>salary_on_call_duty_charge</th>\n","      <th>Aclará el número que ingresaste en el campo anterior</th>\n","      <th>¿Salir o seguir contestando sobre estudios?</th>\n","      <th>profile_age</th>\n","      <th>profile_gender</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Argentina</td>\n","      <td>Catamarca</td>\n","      <td>Full-Time</td>\n","      <td>Staff (planta permanente)</td>\n","      <td>680000.0</td>\n","      <td>520000.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>No</td>\n","      <td>No recibo bono</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>36</td>\n","      <td>Varón Cis</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Argentina</td>\n","      <td>Catamarca</td>\n","      <td>Full-Time</td>\n","      <td>Staff (planta permanente)</td>\n","      <td>650000.0</td>\n","      <td>520000.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>No</td>\n","      <td>No recibo bono</td>\n","      <td>...</td>\n","      <td>Completo</td>\n","      <td>Licenciatura en Sistemas de Información</td>\n","      <td>Universidad Siglo 21</td>\n","      <td>Terminar encuesta</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>45</td>\n","      <td>Varón Cis</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Argentina</td>\n","      <td>Chaco</td>\n","      <td>Full-Time</td>\n","      <td>Tercerizado (trabajo a través de consultora o ...</td>\n","      <td>250000.0</td>\n","      <td>207000.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>No</td>\n","      <td>No recibo bono</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>32</td>\n","      <td>Varón Cis</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>Argentina</td>\n","      <td>Chaco</td>\n","      <td>Full-Time</td>\n","      <td>Staff (planta permanente)</td>\n","      <td>276000.0</td>\n","      <td>229000.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>No</td>\n","      <td>No recibo bono</td>\n","      <td>...</td>\n","      <td>Completo</td>\n","      <td>Analista Universitario de Sistemas</td>\n","      <td>UTN - Universidad Tecnológica Nacional</td>\n","      <td>Responder sobre guardias</td>\n","      <td>Sí, pasiva</td>\n","      <td>0.0</td>\n","      <td>Porcentaje de mi sueldo bruto</td>\n","      <td>Terminar encuesta</td>\n","      <td>28</td>\n","      <td>Varón Cis</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>6 rows × 43 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-783b4eff-e061-4543-9f7b-951b0167a3f7')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-783b4eff-e061-4543-9f7b-951b0167a3f7 button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-783b4eff-e061-4543-9f7b-951b0167a3f7');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-f119d3fd-f214-4c83-8eeb-ab52f9c1fb01\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-f119d3fd-f214-4c83-8eeb-ab52f9c1fb01')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-f119d3fd-f214-4c83-8eeb-ab52f9c1fb01 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe"}},"metadata":{},"execution_count":37}]},{"cell_type":"code","metadata":{"id":"gWNM-P_y7PbR","colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"status":"ok","timestamp":1712322253644,"user_tz":180,"elapsed":369,"user":{"displayName":"ANA GEORGINA FLESIA","userId":"06600501239941405182"}},"outputId":"6a2a1dd7-c88d-40c6-951b-b0ff52047731"},"source":["print(df2.columns)"],"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Index(['work_country', 'work_province', 'work_dedication',\n","       'work_contract_type', 'salary_monthly_BRUTO', 'salary_monthly_NETO',\n","       'salary_in_usd', 'salary_last_dollar_value', 'salary_has_bonus',\n","       'salary_bonus_tied_to',\n","       '¿Tuviste actualizaciones de tus ingresos laborales durante 2023?',\n","       'salary_percentage_inflation_adjustment',\n","       '¿En qué mes fue el último ajuste?', 'salary_comparison_last_semester',\n","       '¿Contás con beneficios adicionales?', 'salary_satisfaction',\n","       'Trabajo de', 'profile_years_experience', 'work_years_in_company',\n","       'work_years_in_current_position', 'work_people_in_charge_of',\n","       'tools_platform', 'tools_programming_languages', 'tools_frameworks',\n","       'tools_data_bases', 'tools_qa_testing', 'company_employee_number',\n","       'work_work_modality',\n","       'Si trabajás bajo un esquema híbrido ¿Cuántos días a la semana vas a la oficina?',\n","       'company_recommended',\n","       '¿Qué tanto estás usando Copilot, ChatGPT u otras herramientas de IA para tu trabajo?',\n","       '¿Salir o seguir contestando?', 'profile_studies_level',\n","       'profile_studies_level_state', 'profile_career',\n","       'Institución educativa',\n","       '¿Salir o seguir contestando sobre las guardias?', 'work_on_call_duty',\n","       'salary_on_call_duty_charge',\n","       'Aclará el número que ingresaste en el campo anterior',\n","       '¿Salir o seguir contestando sobre estudios?', 'profile_age',\n","       'profile_gender'],\n","      dtype='object')\n"]}]},{"cell_type":"markdown","source":["Hay algunas preguntas sin codificar. Como ejercicio, encuentren las columnas no codificadas, agreguenlas a los factores diseñados anteriormente con algun código que las identifique, por ejemplo '¿Qué tanto estás usando Copilot, ChatGPT u otras herramientas de IA para tu trabajo?' codificada como 'tools_IA'\n"],"metadata":{"id":"fo2wIpMfXCq_"}},{"cell_type":"markdown","source":[],"metadata":{"id":"dBjFuPo8X-qk"}}]}