McGill_y_Celda_sinforniif.ipynb

{
  "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/McGill_y_Celda_sinforniif.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "SE8CiXU8Wmsr",
        "outputId": "f6504019-66ca-4a90-80ab-5d53821a3e83"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Collecting fpdf\n",
            "  Downloading fpdf-1.7.2.tar.gz (39 kB)\n",
            "  Preparing metadata (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "Building wheels for collected packages: fpdf\n",
            "  Building wheel for fpdf (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for fpdf: filename=fpdf-1.7.2-py2.py3-none-any.whl size=40704 sha256=8aa4480b9f73e9aff06bc3caf900d244ad7f1f89ab890e619fde1441da732ba1\n",
            "  Stored in directory: /root/.cache/pip/wheels/f9/95/ba/f418094659025eb9611f17cbcaf2334236bf39a0c3453ea455\n",
            "Successfully built fpdf\n",
            "Installing collected packages: fpdf\n",
            "Successfully installed fpdf-1.7.2\n"
          ]
        }
      ],
      "source": [
        "pip install fpdf\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "N12zbvf3W_rj",
        "outputId": "c1ab3628-f486-4e67-8566-8528a79c9ca9"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Drive already mounted at /content/drive; to attempt to forcibly remount, call drive.mount(\"/content/drive\", force_remount=True).\n"
          ]
        }
      ],
      "source": [
        "#setear todo lo necesario\n",
        "import fpdf as FPDF\n",
        "from datetime import datetime\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "from fpdf import FPDF\n",
        "from google.colab import drive, files\n",
        "import shutil\n",
        "drive.mount('/content/drive')\n",
        "direccion='/content/drive/Shareddrives/Ova/Vertiz/Saltos sep 2023/'"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "dumZKkdoaZtq"
      },
      "outputs": [],
      "source": [
        "#encabezado y pie de página del pdf\n",
        "class PDF (FPDF):\n",
        "  def header(self):\n",
        "    self.image(\"/content/drive/Shareddrives/Ova/Vertiz/Movement Science.png\",2,0.5,2.5) #Cambiar Logos\n",
        "    self.image(\"/content/drive/Shareddrives/Sociedad Hebraica Argentina/Imágenes/logo.png\",15,0.5,2.5)\n",
        "    self.set_font(\"arial\",\"B\",12)\n",
        "    self.set_text_color(50,175,175)\n",
        "    self.set_font(\"arial\",\"B\",10)\n",
        "    self.ln(12)\n",
        "  def footer(self):\n",
        "    self.set_y(-1)\n",
        "    self.set_font(\"arial\",\"\",12)\n",
        "    self.set_text_color(0,0,0)\n",
        "    self.cell(0,1,f'{self.page_no()}',align=\"R\")\n",
        "  def set_col(self, col):\n",
        "  # Set column position:\n",
        "    self.col = col\n",
        "    x = 0.50 + col * 2.5\n",
        "    self.set_left_margin(x)\n",
        "    self.set_x(x)\n",
        "#Carátula del pdf\n",
        "def caratula(nombre,protocolo):\n",
        "  now = datetime.now()\n",
        "  hoy=now.date()\n",
        "  profesionales= [\"Lic. Toscano, Ana Paula\",'Lic. García Piccinini, Osvaldo','Med. Hidalgo, Esteban']\n",
        "  pdf.set_y(4)\n",
        "  #pdf.set_text_color(50,175,175)\n",
        "  pdf.set_font(\"arial\",\"\",12)\n",
        "  pdf.image(\"/content/drive/Shareddrives/Sociedad Hebraica Argentina/Imágenes/informe.png\",12,5,10)\n",
        "  pdf.cell(0,5,f'Dirigido a: {nombre}' ,ln=2, align='l')\n",
        "  pdf.multi_cell(h=2, align='l', w=10, txt=f'Protocolo: {protocolo}\\n')\n",
        "  pdf.cell(0,5,f'{hoy}',ln=True, align='l')\n",
        "  pdf.add_page()\n",
        "  pdf.set_y(4)\n",
        "  pdf.set_text_color(0,0,0)\n",
        "  pdf.cell(2,2,f'Equipo profesional',ln=True, align='l')\n",
        "  for crack in profesionales:\n",
        "    pdf.cell(2,2,f'{crack}',ln=True, align='l')\n",
        "  pdf.image(\"/content/drive/Shareddrives/Sociedad Hebraica Argentina/Imágenes/firmas lab.jpg\",5.5,16,10)\n",
        "  pdf.set_font(\"arial\",\"\",10)\n",
        "  pdf.multi_cell(h=0.5, align='L', w=0, txt='El equipo responsable del Laboratorio de Biomecánica Análisis Funcional del Movimiento y Rendimiento Humano queda a su disposición para el análisis conjunto del caso, su interpretación, tanto como las eventuales consideraciones de las conclusiones. \\nAgradecemos la confianza al permitirnos realizar esta evaluación. \\nLo saludamos cordialmente.')\n",
        "  return\n",
        "  # =================================BLOQUE DE FUNCIONES=================================================\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "l-1YprK4j8v3"
      },
      "outputs": [],
      "source": [
        "#Leer csv con pandas\n",
        "#df=pd.read_csv('/content/drive/Shareddrives/Ova/sha grupal/Planilla de SHA marzo - data.csv')\n",
        "df=pd.read_csv(direccion +'datosBosco.csv')\n",
        "df.rename(columns = {'Unnamed: 0':'celda'}, inplace = True)#para convertir a dataframe\n",
        "data = pd.DataFrame(df)\n",
        "print(data)\n",
        "data=data.sort_values('nombres')\n",
        "#data=data.set_index('categoria')\n",
        "data=data.sort_index()\n",
        "#print(data)\n",
        "#cambio el tipo de dato a float\n",
        "data['celda']= data['celda'].astype(bool)\n",
        "data['isqIzq'] = data['isqIzq'].astype(float)*data['celda']\n",
        "data['isqDer'] = data['isqDer'].astype(float)*data['celda']\n",
        "data['cuadIzq'] = data['cuadIzq'].astype(float)*data['celda']\n",
        "data['cuadDer'] = data['cuadDer'].astype(float)*data['celda']\n",
        "#visualizo el tipo de dato de cada columna\n",
        "#print(data.dtypes)\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "RslqKi6MURpu"
      },
      "outputs": [],
      "source": [
        "pdf = PDF(\"p\",\"cm\",\"A4\")\n",
        "pdf.add_page()\n",
        "pdf.set_font(\"Arial\",size=10)\n",
        "\n",
        "caratula(\"Club Vertiz Voley\", \"Evaluación de la fuerza resistencia por protocolo McGill y evaluación de la fuerza isométrica de MMII con celda de cargas\")\n",
        "#ctrl+D (selecciona toda la palabra)  ctrl+shift+L  (Seleccionar la misma selección para cambiarla en todo el código)\n",
        "\n",
        "#calculo del indice de simetria\n",
        "data['simetriaLateral']=((data['derecho']/data['izquierdo'])*100-100)\n",
        "#tomo solo el 1er decimal del valor\n",
        "data['simetriaLateral']=data['simetriaLateral'].round(1)\n",
        "#selecciono los valores optimos al 5% leves <50%\n",
        "simetricoLat = (data['simetriaLateral'] <=5) & (data['simetriaLateral'] >=-5)\n",
        "izquierdoLat = (data['simetriaLateral'] <=-5) & (data['simetriaLateral']>=-50)\n",
        "derechoLat = (data['simetriaLateral'] >=5) & (data['simetriaLateral']<=50)\n",
        "\n",
        "pdf.add_page()\n",
        "pdf.set_font(\"Arial\",size=10, style=\"B\")\n",
        "pdf.set_col(2.5)\n",
        "pdf.set_y(2)\n",
        "pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"1) ZONA MEDIA\\n 1.1) SIMETRIA LATERAL\")\n",
        "\n",
        "pdf.set_col(0)\n",
        "pdf.set_y(2.5)\n",
        "pdf.cell(2,2,f'Valores simétricos \\n',ln=False, align='l')\n",
        "pdf.set_col(2.5)\n",
        "pdf.cell(2,2,f'Fortalecer lado derecho\\n',ln=False, align='l')\n",
        "pdf.set_col(5)\n",
        "pdf.cell(2,2,f'Fortalecer lado izquierdo \\n',ln=True, align='l')\n",
        "\n",
        "pdf.set_y(4)\n",
        "pdf.set_font(\"Arial\",size=8)\n",
        "pdf.set_col(0)\n",
        "if len(data['nombre'][simetricoLat])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\" {data['nombre'][simetricoLat]}\")\n",
        "pdf.set_y(4)\n",
        "pdf.set_col(2.5)\n",
        "if len(data['nombre'][izquierdoLat])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"  \\nAsimetría Leve +25%  \\n {data['nombre'][izquierdoLat]} \\n \")\n",
        "if len(data['nombre'][data['simetriaLateral']<-50])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"\\nAsimetría Acentuada +50%\\n  {data['nombre'][data['simetriaLateral']<-50]}\\n\")\n",
        "pdf.set_y(4)\n",
        "pdf.set_col(5)\n",
        "if len(data['nombre'][derechoLat])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"  \\nAsimetría Leve +25%  {data['nombre'][derechoLat]} \\n  \")\n",
        "if len(data['nombre'][data['simetriaLateral'] >50])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"\\nAsimetría Acentuada +50%\\n  {data['nombre'][data['simetriaLateral'] >50]}\\n\")\n",
        "\n",
        "data['simetriaAp']=(data['anterior']/data['posterior'])*100-72*data['ramaF']-84*data['ramaM']\n",
        "data['simetriaAp']=data['simetriaAp'].round(1)\n",
        "simetricoAp=(data['simetriaAp'] <=10) & (data['simetriaAp'] >=-10)\n",
        "asimetricoAnt=(data['simetriaAp'] <-10) & (data['simetriaAp'] >=-50)\n",
        "asimetricoPost=(data['simetriaAp'] > 10) & (data['simetriaAp'] <50)\n",
        "\n",
        "pdf.add_page()\n",
        "pdf.set_font(\"Arial\",size=10, style=\"B\")\n",
        "pdf.set_col(2.5)\n",
        "pdf.set_y(2)\n",
        "pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"1.2) SIMETRIA ANTEROPOSTERIOR\")\n",
        "\n",
        "pdf.set_col(0)\n",
        "pdf.set_y(2.5)\n",
        "pdf.cell(2,2,f'Valores simétricos \\n',ln=False, align='l')\n",
        "pdf.set_col(2.5)\n",
        "pdf.cell(2,2,f'Fortalecer lado anterior (Adelante)\\n',ln=False, align='l')\n",
        "pdf.set_col(5)\n",
        "pdf.cell(2,2,f'Fortalecer lado posterior (Atrás) \\n',ln=True, align='l')\n",
        "\n",
        "pdf.set_y(4)\n",
        "pdf.set_font(\"Arial\",size=8)\n",
        "pdf.set_col(0)\n",
        "if len(data['nombre'][simetricoAp])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\" {data['nombre'][simetricoAp]}\")\n",
        "pdf.set_y(4)\n",
        "pdf.set_col(2.5)\n",
        "if len(data['nombre'][asimetricoAnt])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"  \\nAsimetría Leve +25%  \\n {data['nombre'][asimetricoAnt]} \\n  \")\n",
        "if len(data['nombre'][data['simetriaAp']<-50])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"\\nAsimetría Acentuada +50%\\n  {data['nombre'][data['simetriaAp']<-50]}\\n\")\n",
        "\n",
        "pdf.set_y(4)\n",
        "pdf.set_col(5)\n",
        "if len(data['nombre'][asimetricoPost])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"  \\nAsimetría Leve +25%  {data['nombre'][asimetricoPost]}  \\n\")\n",
        "if len(data['nombre'][data['simetriaAp'] >50])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"\\nAsimetría Acentuada +50%\\n  {data['nombre'][data['simetriaAp'] >50]}\\n\")\n",
        "\n",
        "data['simetriaDe']=(data['derecho']/data['posterior'])*100-40*data['ramaF']-58*data['ramaM']\n",
        "data['simetriaDe']=data['simetriaDe'].round(1)\n",
        "simetricoDe=(data['simetriaDe'] <=10) & (data['simetriaDe'] >=-10)\n",
        "asimetricoDer=(data['simetriaDe'] <-10) & (data['simetriaDe'] >-50)\n",
        "asimetricoDPost=(data['simetriaDe'] >10) & (data['simetriaDe'] <50)\n",
        "\n",
        "pdf.add_page()\n",
        "pdf.set_font(\"Arial\",size=10, style=\"B\")\n",
        "pdf.set_col(2.5)\n",
        "pdf.set_y(2)\n",
        "pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"1.3) SIMETRIA POSTERODERECHA \")\n",
        "\n",
        "pdf.set_col(0)\n",
        "pdf.set_y(2.5)\n",
        "pdf.cell(2,2,f'Valores simétricos \\n',ln=False, align='l')\n",
        "pdf.set_col(2.5)\n",
        "pdf.cell(2,2,f'Fortalecer lado derecho \\n',ln=False, align='l')\n",
        "pdf.set_col(5)\n",
        "pdf.cell(2,2,f'Fortalecer lado posterior (Atrás) \\n',ln=True, align='l')\n",
        "\n",
        "pdf.set_y(4)\n",
        "pdf.set_font(\"Arial\",size=8)\n",
        "pdf.set_col(0)\n",
        "if len(data['nombre'][simetricoDe])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\" {data['nombre'][simetricoDe]}\")\n",
        "pdf.set_y(4)\n",
        "pdf.set_col(2.5)\n",
        "if len(data['nombre'][asimetricoDer])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"  \\nAsimetría Leve +25%  \\n {data['nombre'][asimetricoDer]} \\n  \")\n",
        "if len(data['nombre'][data['simetriaDe']<-50])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"\\nAsimetría Acentuada +50%\\n  {data['nombre'][data['simetriaDe']<-50]}\\n\")\n",
        "pdf.set_y(4)\n",
        "pdf.set_col(5)\n",
        "\n",
        "if len(data['nombre'][asimetricoDPost])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"  \\nAsimetría Leve +25%  {data['nombre'][asimetricoDPost]} \\n  \")\n",
        "if len(data['nombre'][data['simetriaDe'] >50])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"\\nAsimetría Acentuada +50%\\n  {data['nombre'][data['simetriaDe'] >50]}\\n\")\n",
        "\n",
        "data['simetriaIz']=(data['izquierdo']/data['posterior'])*100-42*data['ramaF']-61*data['ramaM']\n",
        "data['simetriaIz']=data['simetriaIz'].round(1)\n",
        "simetricoIz=(data['simetriaIz'] <=10) & (data['simetriaIz'] >=-10)\n",
        "asimetricoIzq=(data['simetriaIz'] <-10) & (data['simetriaIz'] >-50)\n",
        "asimetricoIPost=(data['simetriaIz'] >10) & (data['simetriaIz'] <50)\n",
        "\n",
        "pdf.add_page()\n",
        "pdf.set_font(\"Arial\",size=10, style=\"B\")\n",
        "pdf.set_col(2.5)\n",
        "pdf.set_y(2)\n",
        "pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"1.4) SIMETRIA POSTEROIZQUIERDA\\n  \")\n",
        "\n",
        "pdf.set_col(0)\n",
        "pdf.set_y(2.5)\n",
        "pdf.cell(2,2,f'Valores simétricos \\n',ln=False, align='l')\n",
        "pdf.set_col(2.5)\n",
        "pdf.cell(2,2,f'Fortalecer lado izquierdo \\n',ln=False, align='l')\n",
        "pdf.set_col(5)\n",
        "pdf.cell(2,2,f'Fortalecer lado posterior (Atrás) \\n',ln=True, align='l')\n",
        "\n",
        "\n",
        "pdf.set_y(4)\n",
        "pdf.set_font(\"Arial\",size=8)\n",
        "pdf.set_col(0)\n",
        "if len(data['nombre'][simetricoIz])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\" {data['nombre'][simetricoIz]}\")\n",
        "pdf.set_y(4)\n",
        "pdf.set_col(2.5)\n",
        "if len(data['nombre'][asimetricoIzq])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"  \\nAsimetría Leve +25%  \\n {data['nombre'][asimetricoIzq]} \\n  \")\n",
        "if len(data['nombre'][data['simetriaIz']<-50])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"\\nAsimetría Acentuada +50%\\n  {data['nombre'][data['simetriaIz']<-50]}\\n\")\n",
        "pdf.set_y(4)\n",
        "pdf.set_col(5)\n",
        "\n",
        "if len(data['nombre'][asimetricoIPost])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"  \\nAsimetría Leve +25%  {data['nombre'][asimetricoIPost]} \\n  \")\n",
        "if len(data['nombre'][data['simetriaIz'] >50])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"\\nAsimetría Acentuada +50%\\n  {data['nombre'][data['simetriaIz'] >50]}\\n\")\n",
        "\n",
        "#CELDA DE CARGAS\n",
        "#relacion flexores\n",
        "data['relacionFlex']=(data['isqDer']/data['isqIzq'])*100-100\n",
        "data['relacionFlex']=data['relacionFlex'].round(1)\n",
        "data['relacionFlex']=data['relacionFlex']* data['celda']\n",
        "#columnas=['nombre','relacionFlex']\n",
        "simetricoFlex=(data['relacionFlex'] <=10) & (data['relacionFlex'] >=-10) & data['celda']\n",
        "asimetricoDFlex=(data['relacionFlex'] <-10) & (data['relacionFlex'] >=-25) & data['celda']\n",
        "asimetricoIFlex=(data['relacionFlex'] >10) & (data['relacionFlex'] <25) & data['celda']\n",
        "\n",
        "pdf.add_page()\n",
        "pdf.set_font(\"Arial\",size=10, style=\"B\")\n",
        "pdf.set_col(2.5)\n",
        "pdf.set_y(2)\n",
        "pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"2) FUERZA DE MUSLOS\\n 2.1) RELACION FLEXORES \")\n",
        "\n",
        "pdf.set_col(0)\n",
        "pdf.set_y(2.5)\n",
        "pdf.cell(2,2,f'Óptimos en isquios \\n',ln=False, align='l')\n",
        "pdf.set_col(2.5)\n",
        "pdf.cell(2,2,f'Fortalecer isquios D \\n',ln=False, align='l')\n",
        "pdf.set_col(5)\n",
        "pdf.cell(2,2,f'Fortalecer isquios I \\n',ln=True, align='l')\n",
        "\n",
        "pdf.set_y(4)\n",
        "pdf.set_font(\"Arial\",size=8)\n",
        "pdf.set_col(0)\n",
        "if len(data['nombre'][simetricoFlex])!=0:\n",
        "  #pdf.multi_cell(h=0.35, align='L', w=0, txt=f\" {data['nombre'][simetricoFlex]}\")\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\" {data[['nombre','relacionFlex']][simetricoFlex]}\\n\")\n",
        "#if len()!=0:\n",
        "\n",
        "pdf.set_y(4)\n",
        "pdf.set_col(2.5)\n",
        "if len(data['nombre'][asimetricoDFlex])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"  \\nAsimetría Leve +10%  \\n {data[['nombre','relacionFlex']][asimetricoDFlex]}  \\n\")\n",
        "\n",
        "if len(data['nombre'][data['relacionFlex']<-25 *data['celda']])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"\\nAsimetría Grave +25% \\n  {data[['nombre','relacionFlex']][data['relacionFlex']<-25 *data['celda']]}\\n\")\n",
        "\n",
        "pdf.set_y(4)\n",
        "pdf.set_col(5)\n",
        "if len(data['nombre'][asimetricoIFlex])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"  \\nAsimetría Leve +10% \\n {data[['nombre','relacionFlex']][asimetricoIFlex]} \\n  \")\n",
        "\n",
        "if len(data['nombre'][data['relacionFlex'] >25 *data['celda']])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"\\nAsimetría Grave +25% \\n  {data[['nombre','relacionFlex']][data['relacionFlex'] >25 *data['celda']]}\\n\")\n",
        "\n",
        "#relacion extensores\n",
        "data['relacionExt']=(data['cuadDer']/data['cuadIzq'])*100-100\n",
        "data['relacionExt']=data['relacionExt'].round(1)\n",
        "data['relacionExt']=data['relacionExt']* data['celda']\n",
        "\n",
        "simetricoExt=(data['relacionExt'] <=10) & (data['relacionExt'] >=-10) & data['celda']\n",
        "asimetricoDExt=(data['relacionExt'] <-10) & (data['relacionExt'] >=-25) & data['celda']\n",
        "asimetricoIExt=(data['relacionExt'] >10) & (data['relacionExt'] <25) & data['celda']\n",
        "\n",
        "pdf.add_page()\n",
        "pdf.set_font(\"Arial\",size=10, style=\"B\")\n",
        "pdf.set_col(2.5)\n",
        "pdf.set_y(2)\n",
        "pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"2.2) RELACION EXTENSORES\")\n",
        "\n",
        "pdf.set_col(0)\n",
        "pdf.set_y(2.5)\n",
        "pdf.cell(2,2,f'Óptimos en cuádriceps \\n',ln=False, align='l')\n",
        "pdf.set_col(2.5)\n",
        "pdf.cell(2,2,f'Fortalecer cuádriceps D \\n',ln=False, align='l')\n",
        "pdf.set_col(5)\n",
        "pdf.cell(2,2,f'Fortalecer cuádriceps I \\n',ln=True, align='l')\n",
        "\n",
        "pdf.set_y(4)\n",
        "pdf.set_font(\"Arial\",size=8)\n",
        "pdf.set_col(0)\n",
        "if len(data['nombre'][simetricoExt])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\" {data[['nombre','relacionExt']][simetricoExt]}\")\n",
        "pdf.set_y(4)\n",
        "pdf.set_col(2.5)\n",
        "if len(data['nombre'][asimetricoDExt])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"  \\nAsimetría Leve +10%  \\n {data[['nombre','relacionExt']][asimetricoDExt]} \\n \")\n",
        "if len(data['nombre'][data['relacionExt']<-25 * data['celda']]) !=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"\\nAsimetría Grave +25% \\n  {data[['nombre','relacionExt']][data['relacionExt']<-25 * data['celda']]}\\n\")\n",
        "pdf.set_y(4)\n",
        "pdf.set_col(5)\n",
        "if len(data['nombre'][asimetricoIExt])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"  \\nAsimetría Leve +10% \\n {data[['nombre','relacionExt']][asimetricoIExt]} \\n \")\n",
        "if len(data['nombre'][data['relacionExt'] >25 *data['celda']])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"\\nAsimetría Grave +25% \\n  {data[['nombre','relacionExt']][data['relacionExt'] >25 *data['celda']]}\\n\")\n",
        "\n",
        "\n",
        "#relacion interpierna derecha\n",
        "data['criticoD']=(data['cuadDer']+data['isqDer'])*0.06\n",
        "data['sCriticoD']=(data['cuadDer']+data['isqDer'])*0.3\n",
        "data['relacionMd']=(data['cuadDer']+data['isqDer'])*0.7-data['cuadDer']\n",
        "data['relacionMd']=data['relacionMd'].round(1)\n",
        "data['relacionMd']=data['relacionMd']* data['celda']\n",
        "\n",
        "data['simetricoMd']=(data['relacionMd'] <=data['criticoD']) & (data['relacionMd'] >=data['criticoD']*-1) & data['celda']\n",
        "data['asimetricoDIsq']=(data['relacionMd'] <data['criticoD']*-1) & (data['relacionMd'] >=data['sCriticoD']*-1) & data['celda']\n",
        "data['asimetricoDCuad']=(data['relacionMd'] >data['criticoD']) & (data['relacionMd'] <data['sCriticoD']) & data['celda']\n",
        "data['sAsimetricoDIsq']=(data['relacionMd'] <=data['sCriticoD']*-1) * data['celda']\n",
        "data['sAsimetricoDCuad']=(data['relacionMd'] >= data['sCriticoD']) * data['celda']\n",
        "\n",
        "\n",
        "pdf.add_page()\n",
        "pdf.set_font(\"Arial\",size=10, style=\"B\")\n",
        "\n",
        "pdf.set_col(2.5)\n",
        "pdf.set_y(2)\n",
        "pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"2.3) RELACION MUSLO DERECHO\\n  \")\n",
        "\n",
        "\n",
        "pdf.set_col(0)\n",
        "pdf.set_y(2.5)\n",
        "pdf.cell(2,2,f'Óptimos inter pierna D \\n',ln=False, align='l')\n",
        "pdf.set_col(2.5)\n",
        "pdf.cell(2,2,f'Fortalecer Isquios D \\n',ln=False, align='l')\n",
        "pdf.set_col(5)\n",
        "pdf.cell(2,2,f'Fortalecer cuádriceps D \\n',ln=True, align='l')\n",
        "\n",
        "pdf.set_y(4)\n",
        "pdf.set_font(\"Arial\",size=8)\n",
        "pdf.set_col(0)\n",
        "if len(data['nombre'][data['simetricoMd']])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\" {data[['nombre','relacionMd']][data['simetricoMd']]}\\n\")\n",
        "#pdf.multi_cell(h=0.35, align='L', w=0, txt=f\" {data[['nombre','relacionMd','criticoD','sCriticoD']][data['celda']]}\")\n",
        "\n",
        "pdf.set_y(4)\n",
        "pdf.set_col(2.5)\n",
        "if len(data['nombre'][data['asimetricoDIsq']])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"  \\nAsimetría Leve +6%  \\n {data[['nombre','relacionMd']][data['asimetricoDIsq']]} \\n  \")\n",
        "if len(data['nombre'][data['sAsimetricoDIsq']])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"\\nAsimetría Grave +30% \\n {data[['nombre','relacionMd']][data['sAsimetricoDIsq']]}\\n\")\n",
        "\n",
        "pdf.set_y(4)\n",
        "pdf.set_col(5)\n",
        "if len(data['nombre'][data['asimetricoDCuad']])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"  \\nAsimetría Leve +6% \\n {data[['nombre','relacionMd']][data['asimetricoDCuad']]} \\n \")\n",
        "if len(data['nombre'][data['sAsimetricoDCuad']])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"\\nAsimetría Grave +30% \\n {data[['nombre','relacionMd']][data['sAsimetricoDCuad']]}\\n\")\n",
        "\n",
        "#relacion interpierna Izquierda\n",
        "criticoI=(data['cuadIzq']+data['isqIzq'])*0.06\n",
        "\n",
        "data['relacionMi']=(data['cuadIzq']+data['isqIzq'])*0.7-data['cuadIzq']\n",
        "data['relacionMi']=data['relacionMi'].round(1)\n",
        "data['relacionMi']=data['relacionMi']* data['celda']\n",
        "#columnas=['nombre','relacionMi']\n",
        "simetricoMi=(data['relacionMi'] <=criticoI) & (data['relacionMi'] >=criticoI*-1) & data['celda']\n",
        "asimetricoIIsq=(data['relacionMi'] <criticoI*-1) & (data['relacionMi'] >=criticoI*-5) & data['celda']\n",
        "asimetricoICuad=(data['relacionMi'] >criticoI) & (data['relacionMi'] <criticoI*5) & data['celda']\n",
        "sAsimetricoIIsq=(data['relacionMi'] <=criticoI*-5) * data['celda']\n",
        "sAsimetricoICuad=(data['relacionMi'] >= criticoI*5) * data['celda']\n",
        "\n",
        "pdf.add_page()\n",
        "pdf.set_font(\"Arial\",size=10, style=\"B\")\n",
        "pdf.set_col(2.5)\n",
        "pdf.set_y(2)\n",
        "pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"2.4) RELACION MUSLO IZQUIERDO\")\n",
        "\n",
        "pdf.set_col(0)\n",
        "pdf.set_y(2.5)\n",
        "pdf.cell(2,2,f'Óptimos en inter pierna I \\n',ln=False, align='l')\n",
        "pdf.set_col(2.5)\n",
        "pdf.cell(2,2,f'Fortalecer Isquios I \\n',ln=False, align='l')\n",
        "pdf.set_col(5)\n",
        "pdf.cell(2,2,f'Fortalecer cuádriceps I \\n',ln=True, align='l')\n",
        "\n",
        "\n",
        "\n",
        "pdf.set_y(4)\n",
        "pdf.set_font(\"Arial\",size=8)\n",
        "pdf.set_col(0)\n",
        "if len(data['nombre'][simetricoMi])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\" {data[['nombre','relacionMi']][simetricoMi]}\\n\")\n",
        "pdf.set_y(4)\n",
        "pdf.set_col(2.5)\n",
        "if len(data['nombre'][asimetricoIIsq])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"  \\nAsimetría Leve +6%  \\n {data[['nombre','relacionMi']][asimetricoIIsq]} \\n\")\n",
        "if len(data['nombre'][sAsimetricoIIsq])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"\\nAsimetría Grave +30% \\n {data[['nombre','relacionMi']][sAsimetricoIIsq]} \\n\")\n",
        "pdf.set_y(4)\n",
        "pdf.set_col(5)\n",
        "if len(data['nombre'][asimetricoICuad])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"  \\nAsimetría Leve +6% \\n {data[['nombre','relacionMi']][asimetricoICuad]} \\n  \")\n",
        "if len(data['nombre'][sAsimetricoICuad])!=0:\n",
        "  pdf.multi_cell(h=0.35, align='L', w=0, txt=f\"\\nAsimetría Grave +30% \\n {data[['nombre','relacionMi']][sAsimetricoICuad]} \\n\")\n",
        "\n",
        "\n",
        "pdfFileName = \"Vertiz sep 23 final\"+'.pdf'\n",
        "pdf.output(pdfFileName)\n",
        "shutil.copy(pdfFileName,\"/content/drive/Shareddrives/Ova/Vertiz\")"
      ]
    }
  ],
  "metadata": {
    "colab": {
      "provenance": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}