Plataformas_WL_Armado_tabla.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/ovapichi/biomecanica-datos/blob/main/Plataformas_WL_Armado_tabla.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# @title Texto de título predeterminado\n",
        "import pandas as pd\n",
        "from google.colab import drive\n",
        "#from fpdf import FPDF\n",
        "from datetime import datetime\n",
        "import numpy as np\n",
        "import os\n",
        "import matplotlib.pyplot as plt\n",
        "from google.colab import files\n",
        "drive.mount('/content/drive')\n",
        "\n",
        "abril_2023='/content/drive/Shareddrives/Ova/Vertiz/Evaluacion abril 2023/'\n",
        "septiembre_2023='/content/drive/Shareddrives/Ova/Vertiz/Saltos sep 2023/'\n",
        "\n",
        "direccion=septiembre_2023"
      ],
      "metadata": {
        "id": "qcwxrg8HZJ7V",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "00cad6c4-8ddf-4434-9560-992a9ddc0627",
        "cellView": "code"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Mounted at /content/drive\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Dirección de la carpeta de drive normaliza los nombres de los saltos por si estan en mayusculas, solo se hace una vez\n",
        "\n",
        "\n",
        "direccionCarpeta=direccion + \"Datos crudos\"\n",
        "for nombreArchivo in os.listdir(direccionCarpeta):\n",
        "    if nombreArchivo[-7:]==\"ABK.dat\":\n",
        "      nombreNuevo=nombreArchivo[:-7]+\"abk.dat\"\n",
        "      os.rename(direccionCarpeta+\"/\"+nombreArchivo,direccionCarpeta+\"/\"+nombreNuevo)\n",
        "    elif nombreArchivo[-8:]==\"CMJa.dat\":\n",
        "      nombreNuevo=nombreArchivo[:-8]+\"abk.dat\"\n",
        "      os.rename(direccionCarpeta+\"/\"+nombreArchivo,direccionCarpeta+\"/\"+nombreNuevo)\n",
        "    elif nombreArchivo[-8:]==\"Cabk.dat\":\n",
        "      nombreNuevo=nombreArchivo[:-8]+\"abk.dat\"\n",
        "      os.rename(direccionCarpeta+\"/\"+nombreArchivo,direccionCarpeta+\"/\"+nombreNuevo)\n",
        "    elif nombreArchivo[-7:]==\"CMJ.dat\":\n",
        "      nombreNuevo=nombreArchivo[:-7]+\"cmj.dat\"\n",
        "      os.rename(direccionCarpeta+\"/\"+nombreArchivo,direccionCarpeta+\"/\"+nombreNuevo)\n",
        "    elif nombreArchivo[-7:]==\" SJ.dat\":\n",
        "      nombreNuevo=nombreArchivo[:-7]+\" sj.dat\"\n",
        "      os.rename(direccionCarpeta+\"/\"+nombreArchivo,direccionCarpeta+\"/\"+nombreNuevo)\n",
        "    print(nombreArchivo)"
      ],
      "metadata": {
        "id": "mlKs8jeFZmDh"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "'''Limpiar cada uno de los archivos y unirlos por jugador en un archivo \"saltosJugador.csv\" con salto llamadas ['tiempo','cmjaDer','cmjaIzq','cmjDer','cmjIzq','sjDer','sjIzq'] y guardarlos un una nueva carpeta'''\n",
        "#Generar los .csv desde los .dat solo se hace una vez\n",
        "#def limpiar(archivo):\n",
        "tiempo=[]\n",
        "segundos=3\n",
        "frecuencia=1000\n",
        "datos=pd.DataFrame({'cmjaDer':[0],'cmjaIzq':[0],'cmjDer':[0],'cmjIzq':[0],'sjDer':[0],'sjIzq':[0]})\n",
        "datos.drop([0], axis=0, inplace=True)\n",
        "\n",
        "#arma el largo del df\n",
        "for i in range(segundos*frecuencia):\n",
        "  tiempo.append(-0.002+i/frecuencia)\n",
        "datos=datos.append(tiempo)\n",
        "datos=datos.fillna(0)\n",
        "\n",
        "def grabarDrive(nombre,dflisto):\n",
        "    #borra las 2 primeras lineas que WL pone al pp\n",
        "    dflisto=dflisto.drop([0,1], axis=0).reset_index(drop=True)\n",
        "    #elegir columnas que quiero sacar\n",
        "    dfFinal=dflisto[['cmjaDer','cmjaIzq','cmjDer','cmjIzq','sjDer','sjIzq']]\n",
        "    #dirección de carpeta que se va a grabar el .csv\n",
        "\n",
        "    rutaDestino=direccion + 'Procesado'+nombre+\".csv\"\n",
        "    with open(rutaDestino, 'w') as f:\n",
        "      dfFinal.to_csv(f, decimal=\",\")\n",
        "    return\n",
        "\n",
        "def armarArchivo(archivos):\n",
        "  for archivo in archivos:\n",
        "    df=pd.read_csv(archivo,on_bad_lines='skip',sep = \" \",header=None, encoding=\"utf-16\")\n",
        "    df=df[0].str.split(pat = ' ', expand = True)\n",
        "    df2=df[0].str.split(pat = \"\\t\", expand = True)\n",
        "    df3=df2[[0,3]]\n",
        "    punto=archivo.rfind(\".\")\n",
        "    punto=punto-3\n",
        "    barra=archivo.rfind(\"/\")\n",
        "    nombre=archivo[barra:punto]\n",
        "    #print(nombre)\n",
        "    #df3=df3.replace(\".\",\",\")\n",
        "\n",
        "    #dfFinal=df3.drop([0,1,2], axis=0, inplace=True)\n",
        "    salto=archivo[-7:-4]\n",
        "\n",
        "    if salto==\"abk\":\n",
        "      derecha=(df3[0]==\"Der.\")\n",
        "      izquierda=(df3[0]==\"Izq.\")\n",
        "      datos['cmjaDer']=df3[3][derecha].dropna().reset_index(drop=True)\n",
        "      datos['cmjaIzq']=df3[3][izquierda].dropna().reset_index(drop=True)\n",
        "    elif salto==\"cmj\":\n",
        "      derecha=(df3[0]==\"Der.\")\n",
        "      izquierda=(df3[0]==\"Izq.\")\n",
        "      datos['cmjDer']=df3[3][derecha].dropna().reset_index(drop=True)\n",
        "      datos['cmjIzq']=df3[3][izquierda].dropna().reset_index(drop=True)\n",
        "    elif salto==\" sj\":\n",
        "      derecha=(df3[0]==\"Der.\")\n",
        "      izquierda=(df3[0]==\"Izq.\")\n",
        "      datos['sjDer']=df3[3][derecha].dropna().reset_index(drop=True)\n",
        "      datos['sjIzq']=df3[3][izquierda].dropna().reset_index(drop=True)\n",
        "  grabarDrive(nombre,datos)\n",
        "  return\n",
        "#la dirección de la carpeta donde estan los .dat\n",
        "direccionCarpeta= direccion + 'Datos crudos/' + \"Juli Puz\"\n",
        "listaArchivo=[]\n",
        "listaDeTres=[]\n",
        "a=0\n",
        "for nombreArchivo in os.listdir(direccionCarpeta):\n",
        "  if nombreArchivo != '.ipynb_checkpoints':\n",
        "    listaArchivo.append(direccionCarpeta+\"/\"+nombreArchivo)\n",
        "  listaArchivo.sort()\n",
        "for i in listaArchivo:\n",
        "  a+=1\n",
        "  listaDeTres.append(i)\n",
        "  if a==3:\n",
        "    armarArchivo(listaDeTres)\n",
        "    #print(listaDeTres)\n",
        "    listaDeTres=[]\n",
        "    a=0\n"
      ],
      "metadata": {
        "id": "CnlW-rlVavtY",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "d4fb2553-5e51-406a-e73a-6bdb51816998"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "<ipython-input-16-702faad98bbf>:13: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
            "  datos=datos.append(tiempo)\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Procesar los .csv para armar el PDF final\n",
        "#1) Pico máximo de caída (<3.5 por lado, <7 total,Entrenar stiffness)\n",
        "#2) Indice CMJa/CMJ (Entrenar coord neuromuscular MMII y MMSS) 10crit/30ok\n",
        "#3) Indice CMJ/SJ (Entrenar Ciclo de estiramiento acortamiento, pliometría) 10crit/30ok\n",
        "#4) Pico doble en la subida presalto (Coordinación MMII)\n",
        "#5) Pico doble en la caída postsalto (Caídas + Drop Jump)\n",
        "def graficar(df,salto):\n",
        "  df.plot(\"Tiempo\",ls=\"dashed\",lw=1, marker=\"\")\n",
        "  plt.title(f\"Fuerza en función del tiempo del salto {salto}\")\n",
        "  plt.xlabel(\"Tiempo [s]\")\n",
        "  plt.ylabel(\"Fuerza [N]\")\n",
        "  plt.xlim(0,3)\n",
        "  plt.ylim(0,2000)\n",
        "  plt.grid()\n",
        "def tiempos(datos):\n",
        "  tiempoCmja=(datos['cmjaDer']<30) & (datos['cmjaIzq']<30)\n",
        "  tiempoCmj=(datos['cmjDer']<30) & (datos['cmjIzq']<30)\n",
        "  tiempoSj=(datos['sjDer']<30) & (datos['sjIzq']<30)\n",
        "  saltoCmja=(((tiempoCmja.sum()/1000)**2)*(9.81/8))\n",
        "  saltoCmj=(((tiempoCmj.sum()/1000)**2)*(9.81/8))\n",
        "  saltoSj=(((tiempoSj.sum()/1000)**2)*(9.81/8))\n",
        "  return saltoCmja,saltoCmj,saltoSj\n",
        "\n",
        "def indices(salto1,salto2):\n",
        "  indice=(salto1-salto2)/salto2\n",
        "  return indice\n",
        "\n",
        "dfBosco=pd.DataFrame(columns=['nombres'])\n",
        "direccionCsv=direccion + 'Procesado'\n",
        "nombres=[]\n",
        "masa=[]\n",
        "saltoCmja=[]\n",
        "saltoCmj=[]\n",
        "saltoSj=[]\n",
        "indiceBrazos=[]\n",
        "indiceElasticidad=[]\n",
        "riesgoCmjaDer=[]\n",
        "riesgoCmjaIzq=[]\n",
        "riesgoCmjDer=[]\n",
        "riesgoCmjIzq=[]\n",
        "riesgoSjDer=[]\n",
        "riesgoSjIzq=[]\n",
        "\n",
        "#Calcular con np.gradient las derivadas de cmja para ver si antes y despues del salto hay más de un 0 (puntos de inflexión)\n",
        "#ver los index del salto 0.3 antes del salto y 0.3 post salto\n",
        "\n",
        "doblePicoC=[] #trabajar fluidez en los saltos, saltos repetitivos\n",
        "doblePicoE=[] #trabajar stiffness\n",
        "for nombreArchivo in os.listdir(direccionCsv):\n",
        "  if nombreArchivo != '.ipynb_checkpoints':\n",
        "    punto=nombreArchivo.rfind('.')\n",
        "    datos= pd.read_csv(direccionCsv+'/'+nombreArchivo,decimal=\",\").dropna()\n",
        "    datos['cmjaDer']=datos['cmjaDer'].astype(float)\n",
        "    datos['cmjaIzq']=datos['cmjaIzq'].astype(float)\n",
        "    datos['cmjDer']=datos['cmjDer'].astype(float)\n",
        "    datos['cmjIzq']=datos['cmjIzq'].astype(float)\n",
        "    datos['sjDer']=datos['sjDer'].astype(float)\n",
        "    datos['sjIzq']=datos['sjIzq'].astype(float)\n",
        "\n",
        "    #datos=pd.read_csv('/content/drive/Shareddrives/Ova/Vertiz/Winlaborat/Ezequiel Ciamparella .csv',decimal=\",\").dropna()\n",
        "  #pasar estas 2 lineas a antes de grabarlos\n",
        "    datos=datos.rename(columns={'Unnamed: 0':'Tiempo'})\n",
        "    datos['Tiempo']=datos['Tiempo']/1000\n",
        "\n",
        "    salto1,salto2,salto3=tiempos(datos)\n",
        "\n",
        "\n",
        "    #(fza max caída * 0.07)/peso\n",
        "    peso=(datos['cmjaDer'][0]+datos['cmjaIzq'][0]+datos['cmjaDer'][1]+datos['cmjaIzq'][1])/2\n",
        "    riesgo1Der=100*(datos['cmjaDer'].max()*0.07)/peso\n",
        "    riesgo1Izq=100*(datos['cmjaIzq'].max()*0.07)/peso\n",
        "    riesgo2Der=100*(datos['cmjDer'].max()*0.07)/peso\n",
        "    riesgo2Izq=100*(datos['cmjIzq'].max()*0.07)/peso\n",
        "    riesgo3Der=100*(datos['sjDer'].max()*0.07)/peso\n",
        "    riesgo3Izq=100*(datos['sjIzq'].max()*0.07)/peso\n",
        "    nombres.append(nombreArchivo[0:punto])\n",
        "    saltoCmja.append(salto1*100)\n",
        "    saltoCmj.append(salto2*100)\n",
        "    saltoSj.append(salto3*100)\n",
        "    indiceB=indices(salto1,salto2)\n",
        "    indiceBrazos.append(indiceB*100)\n",
        "    indiceE=indices(salto2,salto3)\n",
        "    indiceElasticidad.append(indiceE*100)\n",
        "    riesgoCmjaDer.append(riesgo1Der)\n",
        "    riesgoCmjaIzq.append(riesgo1Izq)\n",
        "    riesgoCmjDer.append(riesgo2Der)\n",
        "    riesgoCmjIzq.append(riesgo2Izq)\n",
        "    riesgoSjDer.append(riesgo3Der)\n",
        "    riesgoSjIzq.append(riesgo3Izq)\n",
        "    masa.append(peso)\n",
        "\n",
        "\n",
        "dfBosco['nombres']=nombres\n",
        "dfBosco['peso']=masa\n",
        "dfBosco['riesgoCmjaDer']=riesgoCmjaDer\n",
        "dfBosco['riesgoCmjaIzq']=riesgoCmjaIzq\n",
        "dfBosco['riesgoCmjDer']=riesgoCmjDer\n",
        "dfBosco['riesgoCmjIzq']=riesgoCmjIzq\n",
        "dfBosco['riesgoSjDer']=riesgoSjDer\n",
        "dfBosco['riesgoSjIzq']=riesgoSjIzq\n",
        "dfBosco['saltoCmja']=saltoCmja\n",
        "dfBosco['saltoCmj']=saltoCmj\n",
        "dfBosco['saltoSj']=saltoSj\n",
        "dfBosco['indiceBrazos']=indiceBrazos\n",
        "dfBosco['indiceElasticidad']=indiceElasticidad\n",
        "#dfBosco=dfBosco.astype(int)\n",
        "#print(f\"{masa,riesgoCmjaDer,riesgoCmjaIzq,riesgoCmjDer,riesgoCmjIzq,riesgoSjDer,riesgoSjIzq,indiceBrazos,indiceElasticidad,saltoCmja,saltoCmj,saltoSj}\")\n",
        "#print(datos.max())\n",
        "#graficar(datos,\"Cmj\")\n",
        "\n",
        "\n",
        "\n",
        "dfBosco[['peso','riesgoCmjaDer','riesgoCmjaIzq','riesgoCmjDer','riesgoCmjIzq','riesgoSjDer','riesgoSjIzq','saltoCmja','saltoCmj','saltoSj','indiceBrazos','indiceElasticidad']]=dfBosco[['peso','riesgoCmjaDer','riesgoCmjaIzq','riesgoCmjDer','riesgoCmjIzq','riesgoSjDer','riesgoSjIzq','saltoCmja','saltoCmj','saltoSj','indiceBrazos','indiceElasticidad']].astype(int)\n",
        "#agregar manualmente un jugador manualmente\n",
        "dfBosco=dfBosco.append(pd.Series(['Bianca Romani',620,8,10,10,13,8,11,31,29,24,8,21],index=dfBosco.columns),ignore_index=True)\n",
        "dfBosco"
      ],
      "metadata": {
        "id": "AvSWVyhzaxmo",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1935
        },
        "outputId": "81e38765-ac1f-438e-b523-6fcbd0574fbd"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "<ipython-input-17-62e759e3770c>:115: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
            "  dfBosco=dfBosco.append(pd.Series(['Bianca Romani',620,8,10,10,13,8,11,31,29,24,8,21],index=dfBosco.columns),ignore_index=True)\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                 nombres  peso  riesgoCmjaDer  riesgoCmjaIzq  riesgoCmjDer  \\\n",
              "0          Alejo Fuentes   750             10              8             9   \n",
              "1         Franco Filippo   948              9              9             8   \n",
              "2   Guadalupe Garavaglia   552              7             10             9   \n",
              "3         Joaquin Ulicki   691             12             16            12   \n",
              "4            Gino Khoury   922              9             10             9   \n",
              "..                   ...   ...            ...            ...           ...   \n",
              "75         zara gonzalez   632              8              9            11   \n",
              "76      agustin massucco   868              9              9            20   \n",
              "77         ignacio sokei   609             10             12            13   \n",
              "78           julieta pus   731             12             12            12   \n",
              "79         Bianca Romani   620              8             10            10   \n",
              "\n",
              "    riesgoCmjIzq  riesgoSjDer  riesgoSjIzq  saltoCmja  saltoCmj  saltoSj  \\\n",
              "0              9            7           12         35        33       27   \n",
              "1              9            8            8         21        19       17   \n",
              "2              8            9            9         21        18       13   \n",
              "3             12           10           12         43        35       29   \n",
              "4              8            8            8         24        24       22   \n",
              "..           ...          ...          ...        ...       ...      ...   \n",
              "75             7            9            6         16        16       10   \n",
              "76            13           16           15         38        32       14   \n",
              "77            12           12           10         52        14       38   \n",
              "78            12           11           12         26        26       19   \n",
              "79            13            8           11         31        29       24   \n",
              "\n",
              "    indiceBrazos  indiceElasticidad  \n",
              "0              7                 21  \n",
              "1              9                 12  \n",
              "2             19                 36  \n",
              "3             24                 19  \n",
              "4              0                  9  \n",
              "..           ...                ...  \n",
              "75            -1                 55  \n",
              "76            18                128  \n",
              "77           276                -63  \n",
              "78             0                 33  \n",
              "79             8                 21  \n",
              "\n",
              "[80 rows x 13 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-211dfe80-aab0-4770-99f5-ff8b2c0a920a\" 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>nombres</th>\n",
              "      <th>peso</th>\n",
              "      <th>riesgoCmjaDer</th>\n",
              "      <th>riesgoCmjaIzq</th>\n",
              "      <th>riesgoCmjDer</th>\n",
              "      <th>riesgoCmjIzq</th>\n",
              "      <th>riesgoSjDer</th>\n",
              "      <th>riesgoSjIzq</th>\n",
              "      <th>saltoCmja</th>\n",
              "      <th>saltoCmj</th>\n",
              "      <th>saltoSj</th>\n",
              "      <th>indiceBrazos</th>\n",
              "      <th>indiceElasticidad</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Alejo Fuentes</td>\n",
              "      <td>750</td>\n",
              "      <td>10</td>\n",
              "      <td>8</td>\n",
              "      <td>9</td>\n",
              "      <td>9</td>\n",
              "      <td>7</td>\n",
              "      <td>12</td>\n",
              "      <td>35</td>\n",
              "      <td>33</td>\n",
              "      <td>27</td>\n",
              "      <td>7</td>\n",
              "      <td>21</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Franco Filippo</td>\n",
              "      <td>948</td>\n",
              "      <td>9</td>\n",
              "      <td>9</td>\n",
              "      <td>8</td>\n",
              "      <td>9</td>\n",
              "      <td>8</td>\n",
              "      <td>8</td>\n",
              "      <td>21</td>\n",
              "      <td>19</td>\n",
              "      <td>17</td>\n",
              "      <td>9</td>\n",
              "      <td>12</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Guadalupe Garavaglia</td>\n",
              "      <td>552</td>\n",
              "      <td>7</td>\n",
              "      <td>10</td>\n",
              "      <td>9</td>\n",
              "      <td>8</td>\n",
              "      <td>9</td>\n",
              "      <td>9</td>\n",
              "      <td>21</td>\n",
              "      <td>18</td>\n",
              "      <td>13</td>\n",
              "      <td>19</td>\n",
              "      <td>36</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Joaquin Ulicki</td>\n",
              "      <td>691</td>\n",
              "      <td>12</td>\n",
              "      <td>16</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>10</td>\n",
              "      <td>12</td>\n",
              "      <td>43</td>\n",
              "      <td>35</td>\n",
              "      <td>29</td>\n",
              "      <td>24</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Gino Khoury</td>\n",
              "      <td>922</td>\n",
              "      <td>9</td>\n",
              "      <td>10</td>\n",
              "      <td>9</td>\n",
              "      <td>8</td>\n",
              "      <td>8</td>\n",
              "      <td>8</td>\n",
              "      <td>24</td>\n",
              "      <td>24</td>\n",
              "      <td>22</td>\n",
              "      <td>0</td>\n",
              "      <td>9</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75</th>\n",
              "      <td>zara gonzalez</td>\n",
              "      <td>632</td>\n",
              "      <td>8</td>\n",
              "      <td>9</td>\n",
              "      <td>11</td>\n",
              "      <td>7</td>\n",
              "      <td>9</td>\n",
              "      <td>6</td>\n",
              "      <td>16</td>\n",
              "      <td>16</td>\n",
              "      <td>10</td>\n",
              "      <td>-1</td>\n",
              "      <td>55</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>76</th>\n",
              "      <td>agustin massucco</td>\n",
              "      <td>868</td>\n",
              "      <td>9</td>\n",
              "      <td>9</td>\n",
              "      <td>20</td>\n",
              "      <td>13</td>\n",
              "      <td>16</td>\n",
              "      <td>15</td>\n",
              "      <td>38</td>\n",
              "      <td>32</td>\n",
              "      <td>14</td>\n",
              "      <td>18</td>\n",
              "      <td>128</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>77</th>\n",
              "      <td>ignacio sokei</td>\n",
              "      <td>609</td>\n",
              "      <td>10</td>\n",
              "      <td>12</td>\n",
              "      <td>13</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>10</td>\n",
              "      <td>52</td>\n",
              "      <td>14</td>\n",
              "      <td>38</td>\n",
              "      <td>276</td>\n",
              "      <td>-63</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>78</th>\n",
              "      <td>julieta pus</td>\n",
              "      <td>731</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>11</td>\n",
              "      <td>12</td>\n",
              "      <td>26</td>\n",
              "      <td>26</td>\n",
              "      <td>19</td>\n",
              "      <td>0</td>\n",
              "      <td>33</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>79</th>\n",
              "      <td>Bianca Romani</td>\n",
              "      <td>620</td>\n",
              "      <td>8</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>13</td>\n",
              "      <td>8</td>\n",
              "      <td>11</td>\n",
              "      <td>31</td>\n",
              "      <td>29</td>\n",
              "      <td>24</td>\n",
              "      <td>8</td>\n",
              "      <td>21</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>80 rows × 13 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-211dfe80-aab0-4770-99f5-ff8b2c0a920a')\"\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-211dfe80-aab0-4770-99f5-ff8b2c0a920a 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-211dfe80-aab0-4770-99f5-ff8b2c0a920a');\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-7d51c5e0-7983-4014-a7f7-f4287e83a70f\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-7d51c5e0-7983-4014-a7f7-f4287e83a70f')\"\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-7d51c5e0-7983-4014-a7f7-f4287e83a70f button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Unir datasets\n"
      ],
      "metadata": {
        "id": "aQ1gK_wqEqMe"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df=dfBosco\n",
        "#df2=pd.read_csv(direccion+'datos mcgill abril.csv')\n",
        "'''Solo SEP 2023'''\n",
        "df2=pd.read_excel(direccion +'Evaluacion vertiz.xlsx')\n",
        "\n",
        "df['nombres']=df['nombres'].str.lower()\n",
        "\n",
        "df2['nombre']=df2['nombre'].str.lower()\n",
        "\n",
        "# SOLAMENTE PARA SEPTIEMBRE 2023\n",
        "df.nombres=df.nombres.replace({'santino t':'santino troglio','sofia urbant':'sofia urbandt','fiama rojas':'fiamma rojas','federico testei':'federico testai','alejandro betancurt':'alejandro betancourt',\n",
        "                               'ema de giorgi':'emma de giorgi','ezequien cufone':'ezequiel cufone','ova piccinini':'osvaldo garcia piccinini',\n",
        "                               'thiago covalan':'thiago corvalan','santino cataneo':'santino cattaneo','pollo':'nicolas argenti','arashiro':'matias arashiro',\n",
        "                               'federico li':'federico lee','maria pia orostizu':'pia gorostizu'})\n",
        "df2.nombre=df2.nombre.replace({'santino troglio ':'santino troglio','julieta puz':'julieta pus','sofia urbant':'sofia urbandt','fiama rojas':'fiamma rojas','federico testei':'federico testai','alejandro betancurt':'alejandro betancourt',\n",
        "                               'ema de giorgi':'emma de giorgi','ezequien cufone':'ezequiel cufone','ova piccinini':'osvaldo garcia piccinini',\n",
        "                               'thiago covalan':'thiago corvalan','santino cataneo':'santino cattaneo','pollo':'nicolas argenti','arashiro':'matias arashiro',\n",
        "                               'federico li':'federico lee','pia orostizu':'pia orostizu'})\n",
        "\n",
        "'''df.nombres=df.nombres.replace({'alejando betancuort':'alejandro betancourt','emma di giorgi':'emma de giorgi','matian mendoza':'matias mendoza',\n",
        "                               'juan cruz':'juan cruz trejo','maria pia':'maria pia gorostizu','nico pollo':'nicolas argenti',\n",
        "                               'maximiliano harley':'maximiliano herley','fede macias':'federico macias','issac morales':'isaac morales'})\n",
        "#df2.nombre=df2.nombre.replace({'agustina belén torres costa':'agustina torres','alanís marin':'alanis marin',\n",
        "                               'carlos leonardo fernández':'carlos leonardo fernandez','claudia alejandra romano':'claudia romano',\n",
        "                               'brandon david mamani sarzuri':'david mamani','francisco gonzalez laneve':'francisco gonzalez',\n",
        "                               'elias joel alderete':'elias alderete','ignacio hiroki sokei':'ignacio sokei',\n",
        "                               'matias ignacio mendoza':'matias mendoza','ema hernandez':'emma hernandez','ema muñoz':'emma munoz',\n",
        "                               'federico benjamin berdasco castillo':'fede berdasco','elisa giordano micheletto':'elisa giordano',\n",
        "                               'nicolás shaw':'nicolas shaw','nicole ayelen herley moreno':'nicole moreno','joaquin matias ulicki maceira':'joaquin ulicki',\n",
        "                               'mia müller':'mia muller','julieta belen fiumara':'julieta fiumara','julieta puz':'julieta pus','mica caputo':'micaela caputo'})\n",
        "'''\n",
        "df3=df.merge(df2, left_on='nombres', right_on='nombre', how=\"outer\")\n",
        "\n",
        "df4=df3.drop(columns=['nombres'])\n",
        "df5=df4.sort_values(by='nombre')\n",
        "\n",
        "df6=df5[['categoria', 'rama','nombre','peso', 'anterior', 'posterior', 'izquierda', 'derecha', 'saltoCmja', 'saltoCmj','saltoSj','riesgoCmjaDer', 'riesgoCmjaIzq', 'riesgoCmjDer','riesgoCmjIzq', 'riesgoSjDer', 'riesgoSjIzq', 'indiceBrazos', 'indiceElasticidad']]\n",
        "df6"
      ],
      "metadata": {
        "id": "p5m7AsZLeyLG",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1096
        },
        "outputId": "3433cc16-a342-438e-a397-5909ebaa4644"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   categoria rama                nombre  peso  anterior  posterior  izquierda  \\\n",
              "77   mayores    M      agustin massucco   868        25         23          5   \n",
              "15    sub 21    F       agustina torres   783        71         76         34   \n",
              "16    sub 18    M          alan servian   828        32         39         13   \n",
              "17   sub 21     F          alanis marin   731        35         16         28   \n",
              "18    sub 18    M  alejandro betancourt   794        32         47         28   \n",
              "..       ...  ...                   ...   ...       ...        ...        ...   \n",
              "14    Sub 18    M         tobias zabala   683        25          6          5   \n",
              "73    sub 16    M          tomas campos   589        45         38         16   \n",
              "74    sub 18    M         ulises oviedo   675        48         33         16   \n",
              "75    sub 18    F      valentina flores   616        43         78         32   \n",
              "76    sub 14    F         zara gonzalez   632        43         51         32   \n",
              "\n",
              "    derecha  saltoCmja  saltoCmj  saltoSj  riesgoCmjaDer  riesgoCmjaIzq  \\\n",
              "77       15         38        32       14              9              9   \n",
              "15       38         13        12        9              9              6   \n",
              "16       16         25        22       15             15             11   \n",
              "17       22         19        18       15              7             14   \n",
              "18       28         45        36       34             20             16   \n",
              "..      ...        ...       ...      ...            ...            ...   \n",
              "14        8         29        24       21             10              8   \n",
              "73        7         25        21       20             12             15   \n",
              "74       28         42        39       31             11              8   \n",
              "75       36         24        20       18              9              7   \n",
              "76       18         16        16       10              8              9   \n",
              "\n",
              "    riesgoCmjDer  riesgoCmjIzq  riesgoSjDer  riesgoSjIzq  indiceBrazos  \\\n",
              "77            20            13           16           15            18   \n",
              "15             8             7            8            7             4   \n",
              "16            15            11           15           14            14   \n",
              "17            11             8           10            7             3   \n",
              "18            13            14           17           14            23   \n",
              "..           ...           ...          ...          ...           ...   \n",
              "14            10             7           11            7            19   \n",
              "73            16            10           16           10            16   \n",
              "74            11             7            8           10             9   \n",
              "75             8             8            7           11            18   \n",
              "76            11             7            9            6            -1   \n",
              "\n",
              "    indiceElasticidad  \n",
              "77                128  \n",
              "15                 42  \n",
              "16                 40  \n",
              "17                 23  \n",
              "18                  5  \n",
              "..                ...  \n",
              "14                 11  \n",
              "73                  6  \n",
              "74                 23  \n",
              "75                 11  \n",
              "76                 55  \n",
              "\n",
              "[80 rows x 19 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-c580b63f-85a9-4d97-bf69-c56f179afd1e\" 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>categoria</th>\n",
              "      <th>rama</th>\n",
              "      <th>nombre</th>\n",
              "      <th>peso</th>\n",
              "      <th>anterior</th>\n",
              "      <th>posterior</th>\n",
              "      <th>izquierda</th>\n",
              "      <th>derecha</th>\n",
              "      <th>saltoCmja</th>\n",
              "      <th>saltoCmj</th>\n",
              "      <th>saltoSj</th>\n",
              "      <th>riesgoCmjaDer</th>\n",
              "      <th>riesgoCmjaIzq</th>\n",
              "      <th>riesgoCmjDer</th>\n",
              "      <th>riesgoCmjIzq</th>\n",
              "      <th>riesgoSjDer</th>\n",
              "      <th>riesgoSjIzq</th>\n",
              "      <th>indiceBrazos</th>\n",
              "      <th>indiceElasticidad</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>77</th>\n",
              "      <td>mayores</td>\n",
              "      <td>M</td>\n",
              "      <td>agustin massucco</td>\n",
              "      <td>868</td>\n",
              "      <td>25</td>\n",
              "      <td>23</td>\n",
              "      <td>5</td>\n",
              "      <td>15</td>\n",
              "      <td>38</td>\n",
              "      <td>32</td>\n",
              "      <td>14</td>\n",
              "      <td>9</td>\n",
              "      <td>9</td>\n",
              "      <td>20</td>\n",
              "      <td>13</td>\n",
              "      <td>16</td>\n",
              "      <td>15</td>\n",
              "      <td>18</td>\n",
              "      <td>128</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>sub 21</td>\n",
              "      <td>F</td>\n",
              "      <td>agustina torres</td>\n",
              "      <td>783</td>\n",
              "      <td>71</td>\n",
              "      <td>76</td>\n",
              "      <td>34</td>\n",
              "      <td>38</td>\n",
              "      <td>13</td>\n",
              "      <td>12</td>\n",
              "      <td>9</td>\n",
              "      <td>9</td>\n",
              "      <td>6</td>\n",
              "      <td>8</td>\n",
              "      <td>7</td>\n",
              "      <td>8</td>\n",
              "      <td>7</td>\n",
              "      <td>4</td>\n",
              "      <td>42</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>sub 18</td>\n",
              "      <td>M</td>\n",
              "      <td>alan servian</td>\n",
              "      <td>828</td>\n",
              "      <td>32</td>\n",
              "      <td>39</td>\n",
              "      <td>13</td>\n",
              "      <td>16</td>\n",
              "      <td>25</td>\n",
              "      <td>22</td>\n",
              "      <td>15</td>\n",
              "      <td>15</td>\n",
              "      <td>11</td>\n",
              "      <td>15</td>\n",
              "      <td>11</td>\n",
              "      <td>15</td>\n",
              "      <td>14</td>\n",
              "      <td>14</td>\n",
              "      <td>40</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>sub 21</td>\n",
              "      <td>F</td>\n",
              "      <td>alanis marin</td>\n",
              "      <td>731</td>\n",
              "      <td>35</td>\n",
              "      <td>16</td>\n",
              "      <td>28</td>\n",
              "      <td>22</td>\n",
              "      <td>19</td>\n",
              "      <td>18</td>\n",
              "      <td>15</td>\n",
              "      <td>7</td>\n",
              "      <td>14</td>\n",
              "      <td>11</td>\n",
              "      <td>8</td>\n",
              "      <td>10</td>\n",
              "      <td>7</td>\n",
              "      <td>3</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>sub 18</td>\n",
              "      <td>M</td>\n",
              "      <td>alejandro betancourt</td>\n",
              "      <td>794</td>\n",
              "      <td>32</td>\n",
              "      <td>47</td>\n",
              "      <td>28</td>\n",
              "      <td>28</td>\n",
              "      <td>45</td>\n",
              "      <td>36</td>\n",
              "      <td>34</td>\n",
              "      <td>20</td>\n",
              "      <td>16</td>\n",
              "      <td>13</td>\n",
              "      <td>14</td>\n",
              "      <td>17</td>\n",
              "      <td>14</td>\n",
              "      <td>23</td>\n",
              "      <td>5</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Sub 18</td>\n",
              "      <td>M</td>\n",
              "      <td>tobias zabala</td>\n",
              "      <td>683</td>\n",
              "      <td>25</td>\n",
              "      <td>6</td>\n",
              "      <td>5</td>\n",
              "      <td>8</td>\n",
              "      <td>29</td>\n",
              "      <td>24</td>\n",
              "      <td>21</td>\n",
              "      <td>10</td>\n",
              "      <td>8</td>\n",
              "      <td>10</td>\n",
              "      <td>7</td>\n",
              "      <td>11</td>\n",
              "      <td>7</td>\n",
              "      <td>19</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>73</th>\n",
              "      <td>sub 16</td>\n",
              "      <td>M</td>\n",
              "      <td>tomas campos</td>\n",
              "      <td>589</td>\n",
              "      <td>45</td>\n",
              "      <td>38</td>\n",
              "      <td>16</td>\n",
              "      <td>7</td>\n",
              "      <td>25</td>\n",
              "      <td>21</td>\n",
              "      <td>20</td>\n",
              "      <td>12</td>\n",
              "      <td>15</td>\n",
              "      <td>16</td>\n",
              "      <td>10</td>\n",
              "      <td>16</td>\n",
              "      <td>10</td>\n",
              "      <td>16</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>74</th>\n",
              "      <td>sub 18</td>\n",
              "      <td>M</td>\n",
              "      <td>ulises oviedo</td>\n",
              "      <td>675</td>\n",
              "      <td>48</td>\n",
              "      <td>33</td>\n",
              "      <td>16</td>\n",
              "      <td>28</td>\n",
              "      <td>42</td>\n",
              "      <td>39</td>\n",
              "      <td>31</td>\n",
              "      <td>11</td>\n",
              "      <td>8</td>\n",
              "      <td>11</td>\n",
              "      <td>7</td>\n",
              "      <td>8</td>\n",
              "      <td>10</td>\n",
              "      <td>9</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75</th>\n",
              "      <td>sub 18</td>\n",
              "      <td>F</td>\n",
              "      <td>valentina flores</td>\n",
              "      <td>616</td>\n",
              "      <td>43</td>\n",
              "      <td>78</td>\n",
              "      <td>32</td>\n",
              "      <td>36</td>\n",
              "      <td>24</td>\n",
              "      <td>20</td>\n",
              "      <td>18</td>\n",
              "      <td>9</td>\n",
              "      <td>7</td>\n",
              "      <td>8</td>\n",
              "      <td>8</td>\n",
              "      <td>7</td>\n",
              "      <td>11</td>\n",
              "      <td>18</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>76</th>\n",
              "      <td>sub 14</td>\n",
              "      <td>F</td>\n",
              "      <td>zara gonzalez</td>\n",
              "      <td>632</td>\n",
              "      <td>43</td>\n",
              "      <td>51</td>\n",
              "      <td>32</td>\n",
              "      <td>18</td>\n",
              "      <td>16</td>\n",
              "      <td>16</td>\n",
              "      <td>10</td>\n",
              "      <td>8</td>\n",
              "      <td>9</td>\n",
              "      <td>11</td>\n",
              "      <td>7</td>\n",
              "      <td>9</td>\n",
              "      <td>6</td>\n",
              "      <td>-1</td>\n",
              "      <td>55</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>80 rows × 19 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-c580b63f-85a9-4d97-bf69-c56f179afd1e')\"\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-c580b63f-85a9-4d97-bf69-c56f179afd1e 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-c580b63f-85a9-4d97-bf69-c56f179afd1e');\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-ef509f95-3e12-426e-81ac-75b31218a396\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-ef509f95-3e12-426e-81ac-75b31218a396')\"\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-ef509f95-3e12-426e-81ac-75b31218a396 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 20
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [],
      "metadata": {
        "id": "GSphxXLZEUaZ"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Exportar\n"
      ],
      "metadata": {
        "id": "2cGtds1REZx2"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "rutaFinal=direccion +\"datosBosco\"+\".csv\"\n",
        "with open(rutaFinal, 'w') as f:\n",
        "  df6.to_csv(f, decimal=\",\")"
      ],
      "metadata": {
        "id": "m9P2CNODk6U1"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "  '''funciones para matplotlib'''\n",
        "  #señalar puntos del gráfico \"texto\" \"xy=(ubicación x, ubicación y)\", xytext=(ubicación x y de lo que dice la anotación), shrink(distancia de la flecha del punto)\n",
        "  #ax.annotate('máximo local', xy=(2, 1), xytext=(3, 1.5),\n",
        "            #arrowprops=dict(facecolor='red', shrink=0.05))\n",
        "\n",
        "  #trazar barras verticales\n",
        "  #(ubicacion x, color, altrura de la linea inicio y fin)\n",
        "  #ax.vlines(1, color=\"red\", ymin=-1.5, ymax=1.2)\n",
        "  #ax.vlines(3, color=\"pink\", ymin=-0.5, ymax=0.5)\n",
        "\n",
        "  # # agregar rectangulos de colores VERTICALES\n",
        "  #axvspan = un span vertical en el eje X (an X vertical span)\n",
        "  # # por defecto toma todo el eje Y\n",
        "  #(inicio x, fin x, alpha=transparencia)\n",
        "  #ax.axvspan(0.5, 1.5, color=\"green\", alpha=0.1)\n",
        "\n",
        "  # # axhspan = un span horizontal en el eje X (an X horizontal span)\n",
        "  #RECTANGULOS HORIZONTALES\n",
        "  # # por defecto toma todo el eje X\n",
        "  #ax.axhspan(-1,1, color=\"brown\", alpha=0.1)"
      ],
      "metadata": {
        "id": "eK-oF6JNQU3o"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}