FCM/code/expertsResClean.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "069844c7",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from pandas.core.common import SettingWithCopyWarning\n",
    "import re\n",
    "import numpy as np\n",
    "from pandas import ExcelWriter\n",
    "import openpyxl\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "821f7b5f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# define paths\n",
    "data_path = 'data'\n",
    "output_path = 'output'\n",
    "\n",
    "# set parent folder as working directory\n",
    "os.chdir('..')\n",
    "os.getcwd()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "25451afc",
   "metadata": {},
   "source": [
    "### Import survey responses and select relevant columns "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "0de7e049",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(os.path.join(data_path,'qualtrics_responses.csv'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "0de13ee5",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['StartDate', 'EndDate', 'Status', 'IPAddress', 'Progress', 'Duration (in seconds)', 'Finished', 'RecordedDate', 'ResponseId', 'RecipientLastName', 'RecipientFirstName', 'RecipientEmail', 'ExternalReference', 'LocationLatitude', 'LocationLongitude', 'DistributionChannel', 'UserLanguage', 'Q3', 'Q4_1', 'Q4_2', 'Q4_3', 'Q5_1', 'Q5_2', 'Q6_1', 'Q7_1', 'Q8_1', 'Q9_1', 'Q10_1', 'Q11_1', 'Q12_1', 'Q12_2', 'Q13_1', 'Q14_1', 'Q15_1', 'Q15_2', 'Q16_1', 'Q16_2', 'Q17_1', 'Q18_1', 'Q18_2', 'Q19_1', 'Q20_1', 'Q20_2', 'Q20_3', 'Q21_1', 'Q22_1', 'Q23_1', 'Q23_2', 'Q24_1', 'Q24_2', 'Q25_1', 'Q26_1', 'Q27_1', 'Q28_1', 'Q29_1', 'Q30_1', 'Q31_1', 'Q32_1', 'Q33_1', 'Q34_1', 'Q34_2', 'Q35_1', 'Q36_1', 'Q37_1', 'Q37_2', 'Q37_3', 'Q37_4', 'Q38_1', 'Q38_2', 'Q38_3', 'Q39', 'Q46', 'Q40']\n"
     ]
    }
   ],
   "source": [
    "print(df.columns.tolist())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "822801f9",
   "metadata": {},
   "outputs": [],
   "source": [
    "columns= ['Q4_1', 'Q4_2', 'Q4_3', 'Q5_1', 'Q5_2', 'Q6_1', 'Q7_1', 'Q8_1', 'Q9_1', 'Q10_1', 'Q11_1', 'Q12_1', 'Q12_2', 'Q13_1', 'Q14_1', 'Q15_1', 'Q15_2', 'Q16_1', 'Q16_2', 'Q17_1', 'Q18_1', 'Q18_2', 'Q19_1', 'Q20_1', 'Q20_2', 'Q20_3', 'Q21_1', 'Q22_1', 'Q23_1', 'Q23_2', 'Q24_1', 'Q24_2', 'Q25_1', 'Q26_1', 'Q27_1', 'Q28_1', 'Q29_1', 'Q30_1', 'Q31_1', 'Q32_1', 'Q33_1', 'Q34_1', 'Q34_2', 'Q35_1', 'Q36_1', 'Q37_1', 'Q37_2', 'Q37_3', 'Q37_4', 'Q38_1', 'Q38_2', 'Q38_3']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "49220aed",
   "metadata": {},
   "outputs": [],
   "source": [
    "answers = df[columns]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "9fccdafd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Q4_1</th>\n",
       "      <th>Q4_2</th>\n",
       "      <th>Q4_3</th>\n",
       "      <th>Q5_1</th>\n",
       "      <th>Q5_2</th>\n",
       "      <th>Q6_1</th>\n",
       "      <th>Q7_1</th>\n",
       "      <th>Q8_1</th>\n",
       "      <th>Q9_1</th>\n",
       "      <th>Q10_1</th>\n",
       "      <th>...</th>\n",
       "      <th>Q34_2</th>\n",
       "      <th>Q35_1</th>\n",
       "      <th>Q36_1</th>\n",
       "      <th>Q37_1</th>\n",
       "      <th>Q37_2</th>\n",
       "      <th>Q37_3</th>\n",
       "      <th>Q37_4</th>\n",
       "      <th>Q38_1</th>\n",
       "      <th>Q38_2</th>\n",
       "      <th>Q38_3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Si la regulación de manejo del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Innovación</td>\n",
       "      <td>Si la regulación de manejo del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Valorización del rastrojo</td>\n",
       "      <td>Si la regulación de manejo del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Sostenibilidad de la industria</td>\n",
       "      <td>Si la regulación de manejo del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Cantidad de mosca de establo</td>\n",
       "      <td>Si la regulación de manejo del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Uso de agroquimicos</td>\n",
       "      <td>Si la buena imagen de la industria aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Financiamiento</td>\n",
       "      <td>Si la colaboración/comunicación aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Innovación</td>\n",
       "      <td>Si la contaminación del suelo, aire y agua aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Salud/bienestar de la comu...</td>\n",
       "      <td>Si el costo de materiales basados en combustibles fósiles aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho).\\n\\n\\n\\nNota: produc...</td>\n",
       "      <td>Si el costo de materiales basados en combustibles fósiles aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Rentabilida...</td>\n",
       "      <td>...</td>\n",
       "      <td>Si el tamaño de la empresa aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Rentabilidad de las empresas piñeras</td>\n",
       "      <td>Si la transparencia/apertura de la industria aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Colaboración/comunicación</td>\n",
       "      <td>Si el uso de agroquimicos aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Contaminación del suelo, aire y agua</td>\n",
       "      <td>Si la valorización del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Extracción del campo</td>\n",
       "      <td>Si la valorización del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Disponibilidad de la tierra</td>\n",
       "      <td>Si la valorización del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Rentabilidad de las empresas piñeras</td>\n",
       "      <td>Si la valorización del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Sostenibilidad de la industria</td>\n",
       "      <td>Si el valorización del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Fertilidad del suelo</td>\n",
       "      <td>Si el valorización del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Cantidad de mosca de establo</td>\n",
       "      <td>Si el valorización del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Uso de agroquimicos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>{\"ImportId\":\"QID53_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID53_2\"}</td>\n",
       "      <td>{\"ImportId\":\"QID53_3\"}</td>\n",
       "      <td>{\"ImportId\":\"QID85_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID85_2\"}</td>\n",
       "      <td>{\"ImportId\":\"QID52_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID54_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID55_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID56_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID87_1\"}</td>\n",
       "      <td>...</td>\n",
       "      <td>{\"ImportId\":\"QID77_2\"}</td>\n",
       "      <td>{\"ImportId\":\"QID78_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID79_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID80_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID80_2\"}</td>\n",
       "      <td>{\"ImportId\":\"QID80_3\"}</td>\n",
       "      <td>{\"ImportId\":\"QID80_4\"}</td>\n",
       "      <td>{\"ImportId\":\"QID90_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID90_2\"}</td>\n",
       "      <td>{\"ImportId\":\"QID90_3\"}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>Sin efecto</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>Sin efecto</td>\n",
       "      <td>Sin efecto</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>Sin efecto</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Sin efecto</td>\n",
       "      <td>3</td>\n",
       "      <td>Sin efecto</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 52 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                                                                                                          Q4_1  \\\n",
       "0  Si la regulación de manejo del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Innovación   \n",
       "1                                                                                                                                                       {\"ImportId\":\"QID53_1\"}   \n",
       "2                                                                                                                                                                            3   \n",
       "3                                                                                                                                                                            4   \n",
       "4                                                                                                                                                                            5   \n",
       "\n",
       "                                                                                                                                                                                         Q4_2  \\\n",
       "0  Si la regulación de manejo del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Valorización del rastrojo   \n",
       "1                                                                                                                                                                      {\"ImportId\":\"QID53_2\"}   \n",
       "2                                                                                                                                                                                           3   \n",
       "3                                                                                                                                                                                           5   \n",
       "4                                                                                                                                                                                           5   \n",
       "\n",
       "                                                                                                                                                                                              Q4_3  \\\n",
       "0  Si la regulación de manejo del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Sostenibilidad de la industria   \n",
       "1                                                                                                                                                                           {\"ImportId\":\"QID53_3\"}   \n",
       "2                                                                                                                                                                                                3   \n",
       "3                                                                                                                                                                                                1   \n",
       "4                                                                                                                                                                                                3   \n",
       "\n",
       "                                                                                                                                                                                                  Q5_1  \\\n",
       "0  Si la regulación de manejo del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Cantidad de mosca de establo   \n",
       "1                                                                                                                                                                               {\"ImportId\":\"QID85_1\"}   \n",
       "2                                                                                                                                                                                                    4   \n",
       "3                                                                                                                                                                                                    4   \n",
       "4                                                                                                                                                                                                    4   \n",
       "\n",
       "                                                                                                                                                                                         Q5_2  \\\n",
       "0  Si la regulación de manejo del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Uso de agroquimicos   \n",
       "1                                                                                                                                                                      {\"ImportId\":\"QID85_2\"}   \n",
       "2                                                                                                                                                                                           2   \n",
       "3                                                                                                                                                                                  Sin efecto   \n",
       "4                                                                                                                                                                                           4   \n",
       "\n",
       "                                                                                                                                                                         Q6_1  \\\n",
       "0  Si la buena imagen de la industria aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Financiamiento   \n",
       "1                                                                                                                                                      {\"ImportId\":\"QID52_1\"}   \n",
       "2                                                                                                                                                                           3   \n",
       "3                                                                                                                                                                  Sin efecto   \n",
       "4                                                                                                                                                                           2   \n",
       "\n",
       "                                                                                                                                                                  Q7_1  \\\n",
       "0  Si la colaboración/comunicación aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Innovación   \n",
       "1                                                                                                                                               {\"ImportId\":\"QID54_1\"}   \n",
       "2                                                                                                                                                                    4   \n",
       "3                                                                                                                                                                    4   \n",
       "4                                                                                                                                                                    4   \n",
       "\n",
       "                                                                                                                                                                                                      Q8_1  \\\n",
       "0  Si la contaminación del suelo, aire y agua aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Salud/bienestar de la comu...   \n",
       "1                                                                                                                                                                                   {\"ImportId\":\"QID55_1\"}   \n",
       "2                                                                                                                                                                                                        5   \n",
       "3                                                                                                                                                                                                        5   \n",
       "4                                                                                                                                                                                                        5   \n",
       "\n",
       "                                                                                                                                                                                                      Q9_1  \\\n",
       "0  Si el costo de materiales basados en combustibles fósiles aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho).\\n\\n\\n\\nNota: produc...   \n",
       "1                                                                                                                                                                                   {\"ImportId\":\"QID56_1\"}   \n",
       "2                                                                                                                                                                                               Sin efecto   \n",
       "3                                                                                                                                                                                                        4   \n",
       "4                                                                                                                                                                                                        2   \n",
       "\n",
       "                                                                                                                                                                                                     Q10_1  \\\n",
       "0  Si el costo de materiales basados en combustibles fósiles aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Rentabilida...   \n",
       "1                                                                                                                                                                                   {\"ImportId\":\"QID87_1\"}   \n",
       "2                                                                                                                                                                                                        2   \n",
       "3                                                                                                                                                                                                        2   \n",
       "4                                                                                                                                                                                                        4   \n",
       "\n",
       "   ...  \\\n",
       "0  ...   \n",
       "1  ...   \n",
       "2  ...   \n",
       "3  ...   \n",
       "4  ...   \n",
       "\n",
       "                                                                                                                                                                                      Q34_2  \\\n",
       "0  Si el tamaño de la empresa aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Rentabilidad de las empresas piñeras   \n",
       "1                                                                                                                                                                    {\"ImportId\":\"QID77_2\"}   \n",
       "2                                                                                                                                                                                         4   \n",
       "3                                                                                                                                                                                Sin efecto   \n",
       "4                                                                                                                                                                                         3   \n",
       "\n",
       "                                                                                                                                                                                             Q35_1  \\\n",
       "0  Si la transparencia/apertura de la industria aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Colaboración/comunicación   \n",
       "1                                                                                                                                                                           {\"ImportId\":\"QID78_1\"}   \n",
       "2                                                                                                                                                                                                4   \n",
       "3                                                                                                                                                                                                3   \n",
       "4                                                                                                                                                                                                5   \n",
       "\n",
       "                                                                                                                                                                                     Q36_1  \\\n",
       "0  Si el uso de agroquimicos aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Contaminación del suelo, aire y agua   \n",
       "1                                                                                                                                                                   {\"ImportId\":\"QID79_1\"}   \n",
       "2                                                                                                                                                                                        4   \n",
       "3                                                                                                                                                                                        4   \n",
       "4                                                                                                                                                                                        4   \n",
       "\n",
       "                                                                                                                                                                           Q37_1  \\\n",
       "0  Si la valorización del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Extracción del campo   \n",
       "1                                                                                                                                                         {\"ImportId\":\"QID80_1\"}   \n",
       "2                                                                                                                                                                              5   \n",
       "3                                                                                                                                                                              4   \n",
       "4                                                                                                                                                                              4   \n",
       "\n",
       "                                                                                                                                                                                  Q37_2  \\\n",
       "0  Si la valorización del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Disponibilidad de la tierra   \n",
       "1                                                                                                                                                                {\"ImportId\":\"QID80_2\"}   \n",
       "2                                                                                                                                                                                     3   \n",
       "3                                                                                                                                                                                     3   \n",
       "4                                                                                                                                                                                     5   \n",
       "\n",
       "                                                                                                                                                                                           Q37_3  \\\n",
       "0  Si la valorización del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Rentabilidad de las empresas piñeras   \n",
       "1                                                                                                                                                                         {\"ImportId\":\"QID80_3\"}   \n",
       "2                                                                                                                                                                                              4   \n",
       "3                                                                                                                                                                                              2   \n",
       "4                                                                                                                                                                                              4   \n",
       "\n",
       "                                                                                                                                                                                     Q37_4  \\\n",
       "0  Si la valorización del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Sostenibilidad de la industria   \n",
       "1                                                                                                                                                                   {\"ImportId\":\"QID80_4\"}   \n",
       "2                                                                                                                                                                                        4   \n",
       "3                                                                                                                                                                                        3   \n",
       "4                                                                                                                                                                                        4   \n",
       "\n",
       "                                                                                                                                                                                 Q38_1  \\\n",
       "0  Si el valorización del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Fertilidad del suelo   \n",
       "1                                                                                                                                                               {\"ImportId\":\"QID90_1\"}   \n",
       "2                                                                                                                                                                                    2   \n",
       "3                                                                                                                                                                           Sin efecto   \n",
       "4                                                                                                                                                                                    3   \n",
       "\n",
       "                                                                                                                                                                                         Q38_2  \\\n",
       "0  Si el valorización del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Cantidad de mosca de establo   \n",
       "1                                                                                                                                                                       {\"ImportId\":\"QID90_2\"}   \n",
       "2                                                                                                                                                                                            4   \n",
       "3                                                                                                                                                                                            3   \n",
       "4                                                                                                                                                                                            5   \n",
       "\n",
       "                                                                                                                                                                                Q38_3  \n",
       "0  Si el valorización del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Uso de agroquimicos  \n",
       "1                                                                                                                                                              {\"ImportId\":\"QID90_3\"}  \n",
       "2                                                                                                                                                                                   2  \n",
       "3                                                                                                                                                                          Sin efecto  \n",
       "4                                                                                                                                                                                   5  \n",
       "\n",
       "[5 rows x 52 columns]"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.options.display.max_colwidth = 200\n",
    "answers.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "b66b554c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Q4_1</th>\n",
       "      <th>Q4_2</th>\n",
       "      <th>Q4_3</th>\n",
       "      <th>Q5_1</th>\n",
       "      <th>Q5_2</th>\n",
       "      <th>Q6_1</th>\n",
       "      <th>Q7_1</th>\n",
       "      <th>Q8_1</th>\n",
       "      <th>Q9_1</th>\n",
       "      <th>Q10_1</th>\n",
       "      <th>...</th>\n",
       "      <th>Q34_2</th>\n",
       "      <th>Q35_1</th>\n",
       "      <th>Q36_1</th>\n",
       "      <th>Q37_1</th>\n",
       "      <th>Q37_2</th>\n",
       "      <th>Q37_3</th>\n",
       "      <th>Q37_4</th>\n",
       "      <th>Q38_1</th>\n",
       "      <th>Q38_2</th>\n",
       "      <th>Q38_3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>Sin efecto</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 52 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Q4_1 Q4_2 Q4_3 Q5_1        Q5_2 Q6_1 Q7_1 Q8_1 Q9_1 Q10_1  ... Q34_2 Q35_1  \\\n",
       "6    1    5    5    4  Sin efecto    4    3    5    4     5  ...   NaN   NaN   \n",
       "8    4    4    5    4           4    5    5    5    5     3  ...     4     4   \n",
       "9    3    2    4    2           1    4    5    5    3     3  ...     5     4   \n",
       "\n",
       "  Q36_1 Q37_1 Q37_2 Q37_3 Q37_4 Q38_1 Q38_2 Q38_3  \n",
       "6   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "8     5     4     5     4     4   NaN   NaN   NaN  \n",
       "9     4     4     4     4     4     2     5     4  \n",
       "\n",
       "[3 rows x 52 columns]"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#check if any expert didn't complete the survey\n",
    "answers[answers.isna().any(axis=1)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "ee0d0e6d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Q4_1</th>\n",
       "      <th>Q4_2</th>\n",
       "      <th>Q4_3</th>\n",
       "      <th>Q5_1</th>\n",
       "      <th>Q5_2</th>\n",
       "      <th>Q6_1</th>\n",
       "      <th>Q7_1</th>\n",
       "      <th>Q8_1</th>\n",
       "      <th>Q9_1</th>\n",
       "      <th>Q10_1</th>\n",
       "      <th>...</th>\n",
       "      <th>Q34_2</th>\n",
       "      <th>Q35_1</th>\n",
       "      <th>Q36_1</th>\n",
       "      <th>Q37_1</th>\n",
       "      <th>Q37_2</th>\n",
       "      <th>Q37_3</th>\n",
       "      <th>Q37_4</th>\n",
       "      <th>Q38_1</th>\n",
       "      <th>Q38_2</th>\n",
       "      <th>Q38_3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Si la regulación de manejo del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Innovación</td>\n",
       "      <td>Si la regulación de manejo del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Valorización del rastrojo</td>\n",
       "      <td>Si la regulación de manejo del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Sostenibilidad de la industria</td>\n",
       "      <td>Si la regulación de manejo del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Cantidad de mosca de establo</td>\n",
       "      <td>Si la regulación de manejo del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Uso de agroquimicos</td>\n",
       "      <td>Si la buena imagen de la industria aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Financiamiento</td>\n",
       "      <td>Si la colaboración/comunicación aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Innovación</td>\n",
       "      <td>Si la contaminación del suelo, aire y agua aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Salud/bienestar de la comu...</td>\n",
       "      <td>Si el costo de materiales basados en combustibles fósiles aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho).\\n\\n\\n\\nNota: produc...</td>\n",
       "      <td>Si el costo de materiales basados en combustibles fósiles aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Rentabilida...</td>\n",
       "      <td>...</td>\n",
       "      <td>Si el tamaño de la empresa aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Rentabilidad de las empresas piñeras</td>\n",
       "      <td>Si la transparencia/apertura de la industria aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Colaboración/comunicación</td>\n",
       "      <td>Si el uso de agroquimicos aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Contaminación del suelo, aire y agua</td>\n",
       "      <td>Si la valorización del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Extracción del campo</td>\n",
       "      <td>Si la valorización del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Disponibilidad de la tierra</td>\n",
       "      <td>Si la valorización del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Rentabilidad de las empresas piñeras</td>\n",
       "      <td>Si la valorización del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Sostenibilidad de la industria</td>\n",
       "      <td>Si el valorización del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Fertilidad del suelo</td>\n",
       "      <td>Si el valorización del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Cantidad de mosca de establo</td>\n",
       "      <td>Si el valorización del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Uso de agroquimicos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>{\"ImportId\":\"QID53_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID53_2\"}</td>\n",
       "      <td>{\"ImportId\":\"QID53_3\"}</td>\n",
       "      <td>{\"ImportId\":\"QID85_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID85_2\"}</td>\n",
       "      <td>{\"ImportId\":\"QID52_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID54_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID55_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID56_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID87_1\"}</td>\n",
       "      <td>...</td>\n",
       "      <td>{\"ImportId\":\"QID77_2\"}</td>\n",
       "      <td>{\"ImportId\":\"QID78_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID79_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID80_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID80_2\"}</td>\n",
       "      <td>{\"ImportId\":\"QID80_3\"}</td>\n",
       "      <td>{\"ImportId\":\"QID80_4\"}</td>\n",
       "      <td>{\"ImportId\":\"QID90_1\"}</td>\n",
       "      <td>{\"ImportId\":\"QID90_2\"}</td>\n",
       "      <td>{\"ImportId\":\"QID90_3\"}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>Sin efecto</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>Sin efecto</td>\n",
       "      <td>Sin efecto</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>Sin efecto</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Sin efecto</td>\n",
       "      <td>3</td>\n",
       "      <td>Sin efecto</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>Sin efecto</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Sin efecto</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>Sin efecto</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 52 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                                                                                                          Q4_1  \\\n",
       "0  Si la regulación de manejo del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Innovación   \n",
       "1                                                                                                                                                       {\"ImportId\":\"QID53_1\"}   \n",
       "2                                                                                                                                                                            3   \n",
       "3                                                                                                                                                                            4   \n",
       "4                                                                                                                                                                            5   \n",
       "5                                                                                                                                                                            4   \n",
       "6                                                                                                                                                                            5   \n",
       "7                                                                                                                                                                            4   \n",
       "8                                                                                                                                                                            3   \n",
       "9                                                                                                                                                                            4   \n",
       "\n",
       "                                                                                                                                                                                         Q4_2  \\\n",
       "0  Si la regulación de manejo del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Valorización del rastrojo   \n",
       "1                                                                                                                                                                      {\"ImportId\":\"QID53_2\"}   \n",
       "2                                                                                                                                                                                           3   \n",
       "3                                                                                                                                                                                           5   \n",
       "4                                                                                                                                                                                           5   \n",
       "5                                                                                                                                                                                           4   \n",
       "6                                                                                                                                                                                           5   \n",
       "7                                                                                                                                                                                           4   \n",
       "8                                                                                                                                                                                           2   \n",
       "9                                                                                                                                                                                           5   \n",
       "\n",
       "                                                                                                                                                                                              Q4_3  \\\n",
       "0  Si la regulación de manejo del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Sostenibilidad de la industria   \n",
       "1                                                                                                                                                                           {\"ImportId\":\"QID53_3\"}   \n",
       "2                                                                                                                                                                                                3   \n",
       "3                                                                                                                                                                                                1   \n",
       "4                                                                                                                                                                                                3   \n",
       "5                                                                                                                                                                                                5   \n",
       "6                                                                                                                                                                                                5   \n",
       "7                                                                                                                                                                                                5   \n",
       "8                                                                                                                                                                                                4   \n",
       "9                                                                                                                                                                                                4   \n",
       "\n",
       "                                                                                                                                                                                                  Q5_1  \\\n",
       "0  Si la regulación de manejo del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Cantidad de mosca de establo   \n",
       "1                                                                                                                                                                               {\"ImportId\":\"QID85_1\"}   \n",
       "2                                                                                                                                                                                                    4   \n",
       "3                                                                                                                                                                                                    4   \n",
       "4                                                                                                                                                                                                    4   \n",
       "5                                                                                                                                                                                                    3   \n",
       "6                                                                                                                                                                                                    2   \n",
       "7                                                                                                                                                                                                    4   \n",
       "8                                                                                                                                                                                                    2   \n",
       "9                                                                                                                                                                                                    5   \n",
       "\n",
       "                                                                                                                                                                                         Q5_2  \\\n",
       "0  Si la regulación de manejo del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Uso de agroquimicos   \n",
       "1                                                                                                                                                                      {\"ImportId\":\"QID85_2\"}   \n",
       "2                                                                                                                                                                                           2   \n",
       "3                                                                                                                                                                                  Sin efecto   \n",
       "4                                                                                                                                                                                           4   \n",
       "5                                                                                                                                                                                           3   \n",
       "6                                                                                                                                                                                           2   \n",
       "7                                                                                                                                                                                           4   \n",
       "8                                                                                                                                                                                           1   \n",
       "9                                                                                                                                                                                           5   \n",
       "\n",
       "                                                                                                                                                                         Q6_1  \\\n",
       "0  Si la buena imagen de la industria aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Financiamiento   \n",
       "1                                                                                                                                                      {\"ImportId\":\"QID52_1\"}   \n",
       "2                                                                                                                                                                           3   \n",
       "3                                                                                                                                                                  Sin efecto   \n",
       "4                                                                                                                                                                           2   \n",
       "5                                                                                                                                                                           3   \n",
       "6                                                                                                                                                                           4   \n",
       "7                                                                                                                                                                           5   \n",
       "8                                                                                                                                                                           4   \n",
       "9                                                                                                                                                                           3   \n",
       "\n",
       "                                                                                                                                                                  Q7_1  \\\n",
       "0  Si la colaboración/comunicación aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Innovación   \n",
       "1                                                                                                                                               {\"ImportId\":\"QID54_1\"}   \n",
       "2                                                                                                                                                                    4   \n",
       "3                                                                                                                                                                    4   \n",
       "4                                                                                                                                                                    4   \n",
       "5                                                                                                                                                                    4   \n",
       "6                                                                                                                                                                    4   \n",
       "7                                                                                                                                                                    5   \n",
       "8                                                                                                                                                                    5   \n",
       "9                                                                                                                                                                    5   \n",
       "\n",
       "                                                                                                                                                                                                      Q8_1  \\\n",
       "0  Si la contaminación del suelo, aire y agua aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Salud/bienestar de la comu...   \n",
       "1                                                                                                                                                                                   {\"ImportId\":\"QID55_1\"}   \n",
       "2                                                                                                                                                                                                        5   \n",
       "3                                                                                                                                                                                                        5   \n",
       "4                                                                                                                                                                                                        5   \n",
       "5                                                                                                                                                                                               Sin efecto   \n",
       "6                                                                                                                                                                                                        1   \n",
       "7                                                                                                                                                                                                        5   \n",
       "8                                                                                                                                                                                                        5   \n",
       "9                                                                                                                                                                                                        5   \n",
       "\n",
       "                                                                                                                                                                                                      Q9_1  \\\n",
       "0  Si el costo de materiales basados en combustibles fósiles aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho).\\n\\n\\n\\nNota: produc...   \n",
       "1                                                                                                                                                                                   {\"ImportId\":\"QID56_1\"}   \n",
       "2                                                                                                                                                                                               Sin efecto   \n",
       "3                                                                                                                                                                                                        4   \n",
       "4                                                                                                                                                                                                        2   \n",
       "5                                                                                                                                                                                                        3   \n",
       "6                                                                                                                                                                                                        4   \n",
       "7                                                                                                                                                                                                        5   \n",
       "8                                                                                                                                                                                                        3   \n",
       "9                                                                                                                                                                                                        4   \n",
       "\n",
       "                                                                                                                                                                                                     Q10_1  \\\n",
       "0  Si el costo de materiales basados en combustibles fósiles aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Rentabilida...   \n",
       "1                                                                                                                                                                                   {\"ImportId\":\"QID87_1\"}   \n",
       "2                                                                                                                                                                                                        2   \n",
       "3                                                                                                                                                                                                        2   \n",
       "4                                                                                                                                                                                                        4   \n",
       "5                                                                                                                                                                                                        3   \n",
       "6                                                                                                                                                                                                        5   \n",
       "7                                                                                                                                                                                                        3   \n",
       "8                                                                                                                                                                                                        3   \n",
       "9                                                                                                                                                                                                        5   \n",
       "\n",
       "   ...  \\\n",
       "0  ...   \n",
       "1  ...   \n",
       "2  ...   \n",
       "3  ...   \n",
       "4  ...   \n",
       "5  ...   \n",
       "6  ...   \n",
       "7  ...   \n",
       "8  ...   \n",
       "9  ...   \n",
       "\n",
       "                                                                                                                                                                                      Q34_2  \\\n",
       "0  Si el tamaño de la empresa aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Rentabilidad de las empresas piñeras   \n",
       "1                                                                                                                                                                    {\"ImportId\":\"QID77_2\"}   \n",
       "2                                                                                                                                                                                         4   \n",
       "3                                                                                                                                                                                Sin efecto   \n",
       "4                                                                                                                                                                                         3   \n",
       "5                                                                                                                                                                                         3   \n",
       "6                                                                                                                                                                                         5   \n",
       "7                                                                                                                                                                                         4   \n",
       "8                                                                                                                                                                                         5   \n",
       "9                                                                                                                                                                                         5   \n",
       "\n",
       "                                                                                                                                                                                             Q35_1  \\\n",
       "0  Si la transparencia/apertura de la industria aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Colaboración/comunicación   \n",
       "1                                                                                                                                                                           {\"ImportId\":\"QID78_1\"}   \n",
       "2                                                                                                                                                                                                4   \n",
       "3                                                                                                                                                                                                3   \n",
       "4                                                                                                                                                                                                5   \n",
       "5                                                                                                                                                                                                3   \n",
       "6                                                                                                                                                                                                4   \n",
       "7                                                                                                                                                                                                4   \n",
       "8                                                                                                                                                                                                4   \n",
       "9                                                                                                                                                                                                2   \n",
       "\n",
       "                                                                                                                                                                                     Q36_1  \\\n",
       "0  Si el uso de agroquimicos aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Contaminación del suelo, aire y agua   \n",
       "1                                                                                                                                                                   {\"ImportId\":\"QID79_1\"}   \n",
       "2                                                                                                                                                                                        4   \n",
       "3                                                                                                                                                                                        4   \n",
       "4                                                                                                                                                                                        4   \n",
       "5                                                                                                                                                                               Sin efecto   \n",
       "6                                                                                                                                                                                        5   \n",
       "7                                                                                                                                                                                        5   \n",
       "8                                                                                                                                                                                        4   \n",
       "9                                                                                                                                                                                        5   \n",
       "\n",
       "                                                                                                                                                                           Q37_1  \\\n",
       "0  Si la valorización del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Extracción del campo   \n",
       "1                                                                                                                                                         {\"ImportId\":\"QID80_1\"}   \n",
       "2                                                                                                                                                                              5   \n",
       "3                                                                                                                                                                              4   \n",
       "4                                                                                                                                                                              4   \n",
       "5                                                                                                                                                                              3   \n",
       "6                                                                                                                                                                              5   \n",
       "7                                                                                                                                                                              4   \n",
       "8                                                                                                                                                                              4   \n",
       "9                                                                                                                                                                              5   \n",
       "\n",
       "                                                                                                                                                                                  Q37_2  \\\n",
       "0  Si la valorización del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Disponibilidad de la tierra   \n",
       "1                                                                                                                                                                {\"ImportId\":\"QID80_2\"}   \n",
       "2                                                                                                                                                                                     3   \n",
       "3                                                                                                                                                                                     3   \n",
       "4                                                                                                                                                                                     5   \n",
       "5                                                                                                                                                                                     3   \n",
       "6                                                                                                                                                                                     5   \n",
       "7                                                                                                                                                                                     5   \n",
       "8                                                                                                                                                                                     4   \n",
       "9                                                                                                                                                                                     4   \n",
       "\n",
       "                                                                                                                                                                                           Q37_3  \\\n",
       "0  Si la valorización del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Rentabilidad de las empresas piñeras   \n",
       "1                                                                                                                                                                         {\"ImportId\":\"QID80_3\"}   \n",
       "2                                                                                                                                                                                              4   \n",
       "3                                                                                                                                                                                              2   \n",
       "4                                                                                                                                                                                              4   \n",
       "5                                                                                                                                                                                              3   \n",
       "6                                                                                                                                                                                              5   \n",
       "7                                                                                                                                                                                              4   \n",
       "8                                                                                                                                                                                              4   \n",
       "9                                                                                                                                                                                              1   \n",
       "\n",
       "                                                                                                                                                                                     Q37_4  \\\n",
       "0  Si la valorización del rastrojo aumenta, ¿cuánto AUMENTAN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 aumenta poco y 5 aumenta mucho). - Sostenibilidad de la industria   \n",
       "1                                                                                                                                                                   {\"ImportId\":\"QID80_4\"}   \n",
       "2                                                                                                                                                                                        4   \n",
       "3                                                                                                                                                                                        3   \n",
       "4                                                                                                                                                                                        4   \n",
       "5                                                                                                                                                                                        3   \n",
       "6                                                                                                                                                                                        5   \n",
       "7                                                                                                                                                                                        4   \n",
       "8                                                                                                                                                                                        4   \n",
       "9                                                                                                                                                                                        5   \n",
       "\n",
       "                                                                                                                                                                                 Q38_1  \\\n",
       "0  Si el valorización del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Fertilidad del suelo   \n",
       "1                                                                                                                                                               {\"ImportId\":\"QID90_1\"}   \n",
       "2                                                                                                                                                                                    2   \n",
       "3                                                                                                                                                                           Sin efecto   \n",
       "4                                                                                                                                                                                    3   \n",
       "5                                                                                                                                                                                    3   \n",
       "6                                                                                                                                                                           Sin efecto   \n",
       "7                                                                                                                                                                                  NaN   \n",
       "8                                                                                                                                                                                    2   \n",
       "9                                                                                                                                                                                    3   \n",
       "\n",
       "                                                                                                                                                                                         Q38_2  \\\n",
       "0  Si el valorización del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Cantidad de mosca de establo   \n",
       "1                                                                                                                                                                       {\"ImportId\":\"QID90_2\"}   \n",
       "2                                                                                                                                                                                            4   \n",
       "3                                                                                                                                                                                            3   \n",
       "4                                                                                                                                                                                            5   \n",
       "5                                                                                                                                                                                            3   \n",
       "6                                                                                                                                                                                            1   \n",
       "7                                                                                                                                                                                          NaN   \n",
       "8                                                                                                                                                                                            5   \n",
       "9                                                                                                                                                                                            5   \n",
       "\n",
       "                                                                                                                                                                                Q38_3  \n",
       "0  Si el valorización del rastrojo aumenta, ¿cuánto DISMINUYEN los siguientes conceptos, en una escala de 1 a 5? (Siendo 1 disminuye poco y 5 disminuye mucho). - Uso de agroquimicos  \n",
       "1                                                                                                                                                              {\"ImportId\":\"QID90_3\"}  \n",
       "2                                                                                                                                                                                   2  \n",
       "3                                                                                                                                                                          Sin efecto  \n",
       "4                                                                                                                                                                                   5  \n",
       "5                                                                                                                                                                                   3  \n",
       "6                                                                                                                                                                                   5  \n",
       "7                                                                                                                                                                                 NaN  \n",
       "8                                                                                                                                                                                   4  \n",
       "9                                                                                                                                                                                   5  \n",
       "\n",
       "[10 rows x 52 columns]"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#answers.iloc[6]\n",
    "#checking answers, we see that expert 7 didn't answer more than half, so we drop it. The other two only missed a few answers.\n",
    "answers.drop([6], inplace = True)\n",
    "answers=answers.reset_index(drop=True)\n",
    "answers"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9b6c4377",
   "metadata": {},
   "source": [
    "### Create copy of dataframe, add + and - depending on connection between concepts "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "2ff9063c",
   "metadata": {},
   "outputs": [],
   "source": [
    "answers1=answers.copy() "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "7f7f30e6",
   "metadata": {},
   "outputs": [],
   "source": [
    "for c in answers.columns:\n",
    "    if answers[c].str.contains('AUMENTAN').any():\n",
    "        answers1[c] = '+' + answers[c] \n",
    "    else:\n",
    "        answers1[c] = '-' + answers[c]   \n",
    "# another way\n",
    "# for c in answers.columns:\n",
    "#     answers1[c] = np.where(answers[c].str.contains('AUMENTAN').any(), answers[c] , answers[c] + 't')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "c3ec5d62",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Q4_1</th>\n",
       "      <th>Q4_2</th>\n",
       "      <th>Q4_3</th>\n",
       "      <th>Q5_1</th>\n",
       "      <th>Q5_2</th>\n",
       "      <th>Q6_1</th>\n",
       "      <th>Q7_1</th>\n",
       "      <th>Q8_1</th>\n",
       "      <th>Q9_1</th>\n",
       "      <th>Q10_1</th>\n",
       "      <th>...</th>\n",
       "      <th>Q34_2</th>\n",
       "      <th>Q35_1</th>\n",
       "      <th>Q36_1</th>\n",
       "      <th>Q37_1</th>\n",
       "      <th>Q37_2</th>\n",
       "      <th>Q37_3</th>\n",
       "      <th>Q37_4</th>\n",
       "      <th>Q38_1</th>\n",
       "      <th>Q38_2</th>\n",
       "      <th>Q38_3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>+3</td>\n",
       "      <td>+3</td>\n",
       "      <td>+3</td>\n",
       "      <td>-4</td>\n",
       "      <td>-2</td>\n",
       "      <td>+3</td>\n",
       "      <td>+4</td>\n",
       "      <td>-5</td>\n",
       "      <td>+Sin efecto</td>\n",
       "      <td>-2</td>\n",
       "      <td>...</td>\n",
       "      <td>+4</td>\n",
       "      <td>+4</td>\n",
       "      <td>+4</td>\n",
       "      <td>+5</td>\n",
       "      <td>+3</td>\n",
       "      <td>+4</td>\n",
       "      <td>+4</td>\n",
       "      <td>-2</td>\n",
       "      <td>-4</td>\n",
       "      <td>-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>+4</td>\n",
       "      <td>+5</td>\n",
       "      <td>+1</td>\n",
       "      <td>-4</td>\n",
       "      <td>-Sin efecto</td>\n",
       "      <td>+Sin efecto</td>\n",
       "      <td>+4</td>\n",
       "      <td>-5</td>\n",
       "      <td>+4</td>\n",
       "      <td>-2</td>\n",
       "      <td>...</td>\n",
       "      <td>+Sin efecto</td>\n",
       "      <td>+3</td>\n",
       "      <td>+4</td>\n",
       "      <td>+4</td>\n",
       "      <td>+3</td>\n",
       "      <td>+2</td>\n",
       "      <td>+3</td>\n",
       "      <td>-Sin efecto</td>\n",
       "      <td>-3</td>\n",
       "      <td>-Sin efecto</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>+5</td>\n",
       "      <td>+5</td>\n",
       "      <td>+3</td>\n",
       "      <td>-4</td>\n",
       "      <td>-4</td>\n",
       "      <td>+2</td>\n",
       "      <td>+4</td>\n",
       "      <td>-5</td>\n",
       "      <td>+2</td>\n",
       "      <td>-4</td>\n",
       "      <td>...</td>\n",
       "      <td>+3</td>\n",
       "      <td>+5</td>\n",
       "      <td>+4</td>\n",
       "      <td>+4</td>\n",
       "      <td>+5</td>\n",
       "      <td>+4</td>\n",
       "      <td>+4</td>\n",
       "      <td>-3</td>\n",
       "      <td>-5</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>+4</td>\n",
       "      <td>+4</td>\n",
       "      <td>+5</td>\n",
       "      <td>-3</td>\n",
       "      <td>-3</td>\n",
       "      <td>+3</td>\n",
       "      <td>+4</td>\n",
       "      <td>-Sin efecto</td>\n",
       "      <td>+3</td>\n",
       "      <td>-3</td>\n",
       "      <td>...</td>\n",
       "      <td>+3</td>\n",
       "      <td>+3</td>\n",
       "      <td>+Sin efecto</td>\n",
       "      <td>+3</td>\n",
       "      <td>+3</td>\n",
       "      <td>+3</td>\n",
       "      <td>+3</td>\n",
       "      <td>-3</td>\n",
       "      <td>-3</td>\n",
       "      <td>-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>+5</td>\n",
       "      <td>+5</td>\n",
       "      <td>+5</td>\n",
       "      <td>-2</td>\n",
       "      <td>-2</td>\n",
       "      <td>+4</td>\n",
       "      <td>+4</td>\n",
       "      <td>-1</td>\n",
       "      <td>+4</td>\n",
       "      <td>-5</td>\n",
       "      <td>...</td>\n",
       "      <td>+5</td>\n",
       "      <td>+4</td>\n",
       "      <td>+5</td>\n",
       "      <td>+5</td>\n",
       "      <td>+5</td>\n",
       "      <td>+5</td>\n",
       "      <td>+5</td>\n",
       "      <td>-Sin efecto</td>\n",
       "      <td>-1</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 52 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Q4_1 Q4_2 Q4_3 Q5_1         Q5_2         Q6_1 Q7_1         Q8_1  \\\n",
       "2   +3   +3   +3   -4           -2           +3   +4           -5   \n",
       "3   +4   +5   +1   -4  -Sin efecto  +Sin efecto   +4           -5   \n",
       "4   +5   +5   +3   -4           -4           +2   +4           -5   \n",
       "5   +4   +4   +5   -3           -3           +3   +4  -Sin efecto   \n",
       "6   +5   +5   +5   -2           -2           +4   +4           -1   \n",
       "\n",
       "          Q9_1 Q10_1  ...        Q34_2 Q35_1        Q36_1 Q37_1 Q37_2 Q37_3  \\\n",
       "2  +Sin efecto    -2  ...           +4    +4           +4    +5    +3    +4   \n",
       "3           +4    -2  ...  +Sin efecto    +3           +4    +4    +3    +2   \n",
       "4           +2    -4  ...           +3    +5           +4    +4    +5    +4   \n",
       "5           +3    -3  ...           +3    +3  +Sin efecto    +3    +3    +3   \n",
       "6           +4    -5  ...           +5    +4           +5    +5    +5    +5   \n",
       "\n",
       "  Q37_4        Q38_1 Q38_2        Q38_3  \n",
       "2    +4           -2    -4           -2  \n",
       "3    +3  -Sin efecto    -3  -Sin efecto  \n",
       "4    +4           -3    -5           -5  \n",
       "5    +3           -3    -3           -3  \n",
       "6    +5  -Sin efecto    -1           -5  \n",
       "\n",
       "[5 rows x 52 columns]"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# drop first rows\n",
    "answers1=answers1.drop(answers1.index[[0,1]])\n",
    "answers1.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f3b0b6c0",
   "metadata": {},
   "source": [
    "### Extract concepts from questions and create lists: From and To"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "642e4c59",
   "metadata": {},
   "outputs": [],
   "source": [
    "lFrom=[]\n",
    "for column in answers.columns:\n",
    "    fromC=re.search(r'Si (.*?) aumenta', answers[str(column)][0]).group(1)\n",
    "    lFrom.append(fromC)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "ac156899",
   "metadata": {},
   "outputs": [],
   "source": [
    "lTo=[]\n",
    "for column in answers.columns:\n",
    "    ToC=re.search(r'(?<= - ).*', answers[str(column)][0]).group(0)    \n",
    "    lTo.append(ToC)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "id": "56cc8ff5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Q4_1</th>\n",
       "      <td>+3</td>\n",
       "      <td>+4</td>\n",
       "      <td>+5</td>\n",
       "      <td>+4</td>\n",
       "      <td>+5</td>\n",
       "      <td>+4</td>\n",
       "      <td>+3</td>\n",
       "      <td>+4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q4_2</th>\n",
       "      <td>+3</td>\n",
       "      <td>+5</td>\n",
       "      <td>+5</td>\n",
       "      <td>+4</td>\n",
       "      <td>+5</td>\n",
       "      <td>+4</td>\n",
       "      <td>+2</td>\n",
       "      <td>+5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q4_3</th>\n",
       "      <td>+3</td>\n",
       "      <td>+1</td>\n",
       "      <td>+3</td>\n",
       "      <td>+5</td>\n",
       "      <td>+5</td>\n",
       "      <td>+5</td>\n",
       "      <td>+4</td>\n",
       "      <td>+4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q5_1</th>\n",
       "      <td>-4</td>\n",
       "      <td>-4</td>\n",
       "      <td>-4</td>\n",
       "      <td>-3</td>\n",
       "      <td>-2</td>\n",
       "      <td>-4</td>\n",
       "      <td>-2</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q5_2</th>\n",
       "      <td>-2</td>\n",
       "      <td>-Sin efecto</td>\n",
       "      <td>-4</td>\n",
       "      <td>-3</td>\n",
       "      <td>-2</td>\n",
       "      <td>-4</td>\n",
       "      <td>-1</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       2            3   4   5   6   7   8   9\n",
       "Q4_1  +3           +4  +5  +4  +5  +4  +3  +4\n",
       "Q4_2  +3           +5  +5  +4  +5  +4  +2  +5\n",
       "Q4_3  +3           +1  +3  +5  +5  +5  +4  +4\n",
       "Q5_1  -4           -4  -4  -3  -2  -4  -2  -5\n",
       "Q5_2  -2  -Sin efecto  -4  -3  -2  -4  -1  -5"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#transpose answers rows to columns\n",
    "answersT=answers1.T\n",
    "answersT.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7183e308",
   "metadata": {},
   "source": [
    "###  Create list containing one dataframe with the answers for each expert"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "id": "4b826705",
   "metadata": {},
   "outputs": [],
   "source": [
    "alldfs = []\n",
    "for col in answersT.columns:\n",
    "    df_current = answersT[[col]]\n",
    "    alldfs.append(df_current)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "id": "38c224db",
   "metadata": {},
   "outputs": [],
   "source": [
    "# getting SettingWithCopyWarning, couldn't find solution so turning off for now. \n",
    "import warnings\n",
    "warnings.simplefilter(action=\"ignore\", category=SettingWithCopyWarning)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "id": "8a4f0379",
   "metadata": {},
   "outputs": [],
   "source": [
    "# add From To columns \n",
    "for i in range(len(alldfs)):\n",
    "    alldfs[i].is_copy = False   # TURNS OFF SettingWithCopyWarning\n",
    "    alldfs[i]['From'] = lFrom\n",
    "    alldfs[i]['To'] = lTo\n",
    "    alldfs[i].rename(columns={alldfs[i].columns[0]: \"answers\"}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "id": "4d1896f6",
   "metadata": {},
   "outputs": [],
   "source": [
    "# fill in FCM matrix conditional on values of answers column\n",
    "for i in range(len(alldfs)):\n",
    "    alldfs[i].loc[alldfs[i]['answers'] == '-5', '-VH'] = 1\n",
    "    alldfs[i].loc[alldfs[i]['answers'] == '-4', '-H'] = 1\n",
    "    alldfs[i].loc[alldfs[i]['answers'] == '-3', '-M'] = 1\n",
    "    alldfs[i].loc[alldfs[i]['answers'] == '-2', '-L'] = 1\n",
    "    alldfs[i].loc[alldfs[i]['answers'] == '-1', '-VL'] = 1\n",
    "    alldfs[i]['NA']=np.where(alldfs[i]['answers'].str.contains('Sin efecto'), 1 , 0)\n",
    "    alldfs[i].loc[alldfs[i]['answers'] == '+1', '+VL'] = 1\n",
    "    alldfs[i].loc[alldfs[i]['answers'] == '+2', '+L'] = 1\n",
    "    alldfs[i].loc[alldfs[i]['answers'] == '+3', '+M'] = 1\n",
    "    alldfs[i].loc[alldfs[i]['answers'] == '+4', '+H'] = 1\n",
    "    alldfs[i].loc[alldfs[i]['answers'] == '+5', '+VH'] = 1\n",
    "    alldfs[i].replace(np.nan,0, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "id": "7edf66a4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>answers</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>-VH</th>\n",
       "      <th>-H</th>\n",
       "      <th>-M</th>\n",
       "      <th>-L</th>\n",
       "      <th>-VL</th>\n",
       "      <th>NA</th>\n",
       "      <th>+VL</th>\n",
       "      <th>+L</th>\n",
       "      <th>+M</th>\n",
       "      <th>+H</th>\n",
       "      <th>+VH</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Q4_1</th>\n",
       "      <td>+3</td>\n",
       "      <td>la regulación de manejo del rastrojo</td>\n",
       "      <td>Innovación</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q4_2</th>\n",
       "      <td>+3</td>\n",
       "      <td>la regulación de manejo del rastrojo</td>\n",
       "      <td>Valorización del rastrojo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q4_3</th>\n",
       "      <td>+3</td>\n",
       "      <td>la regulación de manejo del rastrojo</td>\n",
       "      <td>Sostenibilidad de la industria</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q5_1</th>\n",
       "      <td>-4</td>\n",
       "      <td>la regulación de manejo del rastrojo</td>\n",
       "      <td>Cantidad de mosca de establo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q5_2</th>\n",
       "      <td>-2</td>\n",
       "      <td>la regulación de manejo del rastrojo</td>\n",
       "      <td>Uso de agroquimicos</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     answers                                  From  \\\n",
       "Q4_1      +3  la regulación de manejo del rastrojo   \n",
       "Q4_2      +3  la regulación de manejo del rastrojo   \n",
       "Q4_3      +3  la regulación de manejo del rastrojo   \n",
       "Q5_1      -4  la regulación de manejo del rastrojo   \n",
       "Q5_2      -2  la regulación de manejo del rastrojo   \n",
       "\n",
       "                                  To  -VH   -H   -M   -L  -VL  NA  +VL   +L  \\\n",
       "Q4_1                      Innovación  0.0  0.0  0.0  0.0  0.0   0  0.0  0.0   \n",
       "Q4_2       Valorización del rastrojo  0.0  0.0  0.0  0.0  0.0   0  0.0  0.0   \n",
       "Q4_3  Sostenibilidad de la industria  0.0  0.0  0.0  0.0  0.0   0  0.0  0.0   \n",
       "Q5_1    Cantidad de mosca de establo  0.0  1.0  0.0  0.0  0.0   0  0.0  0.0   \n",
       "Q5_2             Uso de agroquimicos  0.0  0.0  0.0  1.0  0.0   0  0.0  0.0   \n",
       "\n",
       "       +M   +H  +VH  \n",
       "Q4_1  1.0  0.0  0.0  \n",
       "Q4_2  1.0  0.0  0.0  \n",
       "Q4_3  1.0  0.0  0.0  \n",
       "Q5_1  0.0  0.0  0.0  \n",
       "Q5_2  0.0  0.0  0.0  "
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alldfs[0].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "id": "7ded0695",
   "metadata": {},
   "outputs": [],
   "source": [
    "#drop answer column\n",
    "for i in range(len(alldfs)):\n",
    "    alldfs[i]=alldfs[i].drop(columns='answers', axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "id": "fa527b1f-1ba9-4c86-9bee-e146d4e95b64",
   "metadata": {},
   "outputs": [],
   "source": [
    "# we want concepts to have the same name in From and To column for the sake of the FCM matrix\n",
    "for x in lTo:\n",
    "    for i in range(len(alldfs)):\n",
    "        alldfs[i].loc[alldfs[i]['From'].str.contains(x, case=False), \"From\"]= x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "id": "e15047b4-19a0-4bc7-814e-5a5e5cf25a29",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(len(alldfs)):\n",
    "        alldfs[i]['From'] = alldfs[i]['From'].str.replace(r'^las ', '',1, regex=True)\n",
    "        alldfs[i]['From'] = alldfs[i]['From'].str.replace(r'^la ', '',1, regex=True)\n",
    "        alldfs[i]['From'] = alldfs[i]['From'].str.replace(r'^el ', '',1, regex=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "id": "d7cfeffc-f5c3-42a3-bc5c-51c14d0ad6f2",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(len(alldfs)):\n",
    "    alldfs[i]['From'] = alldfs[i]['From'].str.replace(r'(\\w+)', lambda x: x.group().capitalize(), n=1, regex=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "id": "3a14cc49-1c71-4824-99c0-7f963db3ef9f",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>-VH</th>\n",
       "      <th>-H</th>\n",
       "      <th>-M</th>\n",
       "      <th>-L</th>\n",
       "      <th>-VL</th>\n",
       "      <th>NA</th>\n",
       "      <th>+VL</th>\n",
       "      <th>+L</th>\n",
       "      <th>+M</th>\n",
       "      <th>+H</th>\n",
       "      <th>+VH</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Q4_1</th>\n",
       "      <td>Regulación de manejo del rastrojo</td>\n",
       "      <td>Innovación</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q4_2</th>\n",
       "      <td>Regulación de manejo del rastrojo</td>\n",
       "      <td>Valorización del rastrojo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q4_3</th>\n",
       "      <td>Regulación de manejo del rastrojo</td>\n",
       "      <td>Sostenibilidad de la industria</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q5_1</th>\n",
       "      <td>Regulación de manejo del rastrojo</td>\n",
       "      <td>Cantidad de mosca de establo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q5_2</th>\n",
       "      <td>Regulación de manejo del rastrojo</td>\n",
       "      <td>Uso de agroquimicos</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q6_1</th>\n",
       "      <td>Buena imagen de la industria</td>\n",
       "      <td>Financiamiento</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q7_1</th>\n",
       "      <td>Colaboración/comunicación</td>\n",
       "      <td>Innovación</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q8_1</th>\n",
       "      <td>Contaminación del suelo, aire y agua</td>\n",
       "      <td>Salud/bienestar de la comunidad</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q9_1</th>\n",
       "      <td>Costo de materiales basados en combustibles fósiles</td>\n",
       "      <td>Demanda de productos PAL</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q10_1</th>\n",
       "      <td>Costo de materiales basados en combustibles fósiles</td>\n",
       "      <td>Rentabilidad de las empresas piñeras</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q11_1</th>\n",
       "      <td>Costumbres de la industria</td>\n",
       "      <td>Valorización del rastrojo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q12_1</th>\n",
       "      <td>Demanda de productos PAL</td>\n",
       "      <td>Innovación</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q12_2</th>\n",
       "      <td>Demanda de productos PAL</td>\n",
       "      <td>Valorización del rastrojo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q13_1</th>\n",
       "      <td>Desnivel del terreno</td>\n",
       "      <td>Extracción del campo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q14_1</th>\n",
       "      <td>Disponibilidad de la tierra</td>\n",
       "      <td>Productividad de la producción de piña</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q15_1</th>\n",
       "      <td>Empleo</td>\n",
       "      <td>Salud/bienestar de la comunidad</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q15_2</th>\n",
       "      <td>Empleo</td>\n",
       "      <td>Financiamiento</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q16_1</th>\n",
       "      <td>Extracción del campo</td>\n",
       "      <td>Innovación</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q16_2</th>\n",
       "      <td>Extracción del campo</td>\n",
       "      <td>Valorización del rastrojo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q17_1</th>\n",
       "      <td>Extracción del campo</td>\n",
       "      <td>Uso de agroquimicos</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q18_1</th>\n",
       "      <td>Financiamiento</td>\n",
       "      <td>Investigación académica</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q18_2</th>\n",
       "      <td>Financiamiento</td>\n",
       "      <td>Innovación</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q19_1</th>\n",
       "      <td>Inestabilidad internacional</td>\n",
       "      <td>Costo de materiales basados en combustibles fósiles</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q20_1</th>\n",
       "      <td>Innovación</td>\n",
       "      <td>Extracción del campo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q20_2</th>\n",
       "      <td>Innovación</td>\n",
       "      <td>Productividad laboral</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q20_3</th>\n",
       "      <td>Innovación</td>\n",
       "      <td>Valorización del rastrojo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q21_1</th>\n",
       "      <td>Investigación académica</td>\n",
       "      <td>Innovación</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q22_1</th>\n",
       "      <td>Lluvia</td>\n",
       "      <td>Extracción del campo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q23_1</th>\n",
       "      <td>Cantidad de mosca de establo</td>\n",
       "      <td>Salud/bienestar de la comunidad</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q23_2</th>\n",
       "      <td>Cantidad de mosca de establo</td>\n",
       "      <td>Productividad de los ganaderos</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q24_1</th>\n",
       "      <td>Participación del gobierno</td>\n",
       "      <td>Colaboración/comunicación</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q24_2</th>\n",
       "      <td>Participación del gobierno</td>\n",
       "      <td>Regulación de manejo del rastrojo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q25_1</th>\n",
       "      <td>Preferencia de los consumidores por productos sostenibles</td>\n",
       "      <td>Demanda de productos PAL</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q26_1</th>\n",
       "      <td>Preferencia de los consumidores por productos sostenibles</td>\n",
       "      <td>Uso de agroquimicos</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q27_1</th>\n",
       "      <td>Productividad de la producción de piña</td>\n",
       "      <td>Rentabilidad de las empresas piñeras</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q28_1</th>\n",
       "      <td>Productividad laboral</td>\n",
       "      <td>Extracción del campo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q29_1</th>\n",
       "      <td>Regulaciones y estándares de importación (de destino)</td>\n",
       "      <td>Uso de agroquimicos</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q30_1</th>\n",
       "      <td>Rentabilidad de las empresas piñeras</td>\n",
       "      <td>Sostenibilidad de la industria</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q31_1</th>\n",
       "      <td>Riesgo empresarial</td>\n",
       "      <td>Innovación</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q32_1</th>\n",
       "      <td>Salud/bienestar de la comunidad</td>\n",
       "      <td>Buena imagen de la industria</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q33_1</th>\n",
       "      <td>Sostenibilidad de la industria</td>\n",
       "      <td>Demanda de productos PAL</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q34_1</th>\n",
       "      <td>Tamaño de la empresa</td>\n",
       "      <td>Financiamiento</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q34_2</th>\n",
       "      <td>Tamaño de la empresa</td>\n",
       "      <td>Rentabilidad de las empresas piñeras</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q35_1</th>\n",
       "      <td>Transparencia/apertura de la industria</td>\n",
       "      <td>Colaboración/comunicación</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q36_1</th>\n",
       "      <td>Uso de agroquimicos</td>\n",
       "      <td>Contaminación del suelo, aire y agua</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q37_1</th>\n",
       "      <td>Valorización del rastrojo</td>\n",
       "      <td>Extracción del campo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q37_2</th>\n",
       "      <td>Valorización del rastrojo</td>\n",
       "      <td>Disponibilidad de la tierra</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q37_3</th>\n",
       "      <td>Valorización del rastrojo</td>\n",
       "      <td>Rentabilidad de las empresas piñeras</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q37_4</th>\n",
       "      <td>Valorización del rastrojo</td>\n",
       "      <td>Sostenibilidad de la industria</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q38_1</th>\n",
       "      <td>Valorización del rastrojo</td>\n",
       "      <td>Fertilidad del suelo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q38_2</th>\n",
       "      <td>Valorización del rastrojo</td>\n",
       "      <td>Cantidad de mosca de establo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q38_3</th>\n",
       "      <td>Valorización del rastrojo</td>\n",
       "      <td>Uso de agroquimicos</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                            From  \\\n",
       "Q4_1                           Regulación de manejo del rastrojo   \n",
       "Q4_2                           Regulación de manejo del rastrojo   \n",
       "Q4_3                           Regulación de manejo del rastrojo   \n",
       "Q5_1                           Regulación de manejo del rastrojo   \n",
       "Q5_2                           Regulación de manejo del rastrojo   \n",
       "Q6_1                                Buena imagen de la industria   \n",
       "Q7_1                                   Colaboración/comunicación   \n",
       "Q8_1                        Contaminación del suelo, aire y agua   \n",
       "Q9_1         Costo de materiales basados en combustibles fósiles   \n",
       "Q10_1        Costo de materiales basados en combustibles fósiles   \n",
       "Q11_1                                 Costumbres de la industria   \n",
       "Q12_1                                   Demanda de productos PAL   \n",
       "Q12_2                                   Demanda de productos PAL   \n",
       "Q13_1                                       Desnivel del terreno   \n",
       "Q14_1                                Disponibilidad de la tierra   \n",
       "Q15_1                                                     Empleo   \n",
       "Q15_2                                                     Empleo   \n",
       "Q16_1                                       Extracción del campo   \n",
       "Q16_2                                       Extracción del campo   \n",
       "Q17_1                                       Extracción del campo   \n",
       "Q18_1                                             Financiamiento   \n",
       "Q18_2                                             Financiamiento   \n",
       "Q19_1                               Inestabilidad internacional    \n",
       "Q20_1                                                 Innovación   \n",
       "Q20_2                                                 Innovación   \n",
       "Q20_3                                                 Innovación   \n",
       "Q21_1                                    Investigación académica   \n",
       "Q22_1                                                     Lluvia   \n",
       "Q23_1                               Cantidad de mosca de establo   \n",
       "Q23_2                               Cantidad de mosca de establo   \n",
       "Q24_1                                 Participación del gobierno   \n",
       "Q24_2                                 Participación del gobierno   \n",
       "Q25_1  Preferencia de los consumidores por productos sostenibles   \n",
       "Q26_1  Preferencia de los consumidores por productos sostenibles   \n",
       "Q27_1                     Productividad de la producción de piña   \n",
       "Q28_1                                      Productividad laboral   \n",
       "Q29_1      Regulaciones y estándares de importación (de destino)   \n",
       "Q30_1                       Rentabilidad de las empresas piñeras   \n",
       "Q31_1                                         Riesgo empresarial   \n",
       "Q32_1                            Salud/bienestar de la comunidad   \n",
       "Q33_1                             Sostenibilidad de la industria   \n",
       "Q34_1                                       Tamaño de la empresa   \n",
       "Q34_2                                       Tamaño de la empresa   \n",
       "Q35_1                     Transparencia/apertura de la industria   \n",
       "Q36_1                                        Uso de agroquimicos   \n",
       "Q37_1                                  Valorización del rastrojo   \n",
       "Q37_2                                  Valorización del rastrojo   \n",
       "Q37_3                                  Valorización del rastrojo   \n",
       "Q37_4                                  Valorización del rastrojo   \n",
       "Q38_1                                  Valorización del rastrojo   \n",
       "Q38_2                                  Valorización del rastrojo   \n",
       "Q38_3                                  Valorización del rastrojo   \n",
       "\n",
       "                                                        To  -VH   -H   -M  \\\n",
       "Q4_1                                            Innovación  0.0  0.0  0.0   \n",
       "Q4_2                             Valorización del rastrojo  0.0  0.0  0.0   \n",
       "Q4_3                        Sostenibilidad de la industria  0.0  0.0  0.0   \n",
       "Q5_1                          Cantidad de mosca de establo  0.0  1.0  0.0   \n",
       "Q5_2                                   Uso de agroquimicos  0.0  0.0  0.0   \n",
       "Q6_1                                        Financiamiento  0.0  0.0  0.0   \n",
       "Q7_1                                            Innovación  0.0  0.0  0.0   \n",
       "Q8_1                       Salud/bienestar de la comunidad  1.0  0.0  0.0   \n",
       "Q9_1                              Demanda de productos PAL  0.0  0.0  0.0   \n",
       "Q10_1                 Rentabilidad de las empresas piñeras  0.0  0.0  0.0   \n",
       "Q11_1                            Valorización del rastrojo  0.0  0.0  0.0   \n",
       "Q12_1                                           Innovación  0.0  0.0  0.0   \n",
       "Q12_2                            Valorización del rastrojo  0.0  0.0  0.0   \n",
       "Q13_1                                 Extracción del campo  0.0  0.0  1.0   \n",
       "Q14_1               Productividad de la producción de piña  0.0  0.0  0.0   \n",
       "Q15_1                      Salud/bienestar de la comunidad  0.0  0.0  0.0   \n",
       "Q15_2                                       Financiamiento  0.0  0.0  0.0   \n",
       "Q16_1                                           Innovación  0.0  0.0  0.0   \n",
       "Q16_2                            Valorización del rastrojo  0.0  0.0  0.0   \n",
       "Q17_1                                  Uso de agroquimicos  0.0  1.0  0.0   \n",
       "Q18_1                              Investigación académica  0.0  0.0  0.0   \n",
       "Q18_2                                           Innovación  0.0  0.0  0.0   \n",
       "Q19_1  Costo de materiales basados en combustibles fósiles  0.0  0.0  0.0   \n",
       "Q20_1                                 Extracción del campo  0.0  0.0  0.0   \n",
       "Q20_2                                Productividad laboral  0.0  0.0  0.0   \n",
       "Q20_3                            Valorización del rastrojo  0.0  0.0  0.0   \n",
       "Q21_1                                           Innovación  0.0  0.0  0.0   \n",
       "Q22_1                                 Extracción del campo  0.0  0.0  0.0   \n",
       "Q23_1                      Salud/bienestar de la comunidad  0.0  1.0  0.0   \n",
       "Q23_2                       Productividad de los ganaderos  0.0  0.0  1.0   \n",
       "Q24_1                            Colaboración/comunicación  0.0  0.0  0.0   \n",
       "Q24_2                    Regulación de manejo del rastrojo  0.0  0.0  0.0   \n",
       "Q25_1                             Demanda de productos PAL  0.0  0.0  0.0   \n",
       "Q26_1                                  Uso de agroquimicos  0.0  0.0  0.0   \n",
       "Q27_1                 Rentabilidad de las empresas piñeras  0.0  0.0  0.0   \n",
       "Q28_1                                 Extracción del campo  0.0  0.0  0.0   \n",
       "Q29_1                                  Uso de agroquimicos  0.0  1.0  0.0   \n",
       "Q30_1                       Sostenibilidad de la industria  0.0  0.0  0.0   \n",
       "Q31_1                                           Innovación  0.0  0.0  1.0   \n",
       "Q32_1                         Buena imagen de la industria  0.0  0.0  0.0   \n",
       "Q33_1                             Demanda de productos PAL  0.0  0.0  0.0   \n",
       "Q34_1                                       Financiamiento  0.0  0.0  0.0   \n",
       "Q34_2                 Rentabilidad de las empresas piñeras  0.0  0.0  0.0   \n",
       "Q35_1                            Colaboración/comunicación  0.0  0.0  0.0   \n",
       "Q36_1                 Contaminación del suelo, aire y agua  0.0  0.0  0.0   \n",
       "Q37_1                                 Extracción del campo  0.0  0.0  0.0   \n",
       "Q37_2                          Disponibilidad de la tierra  0.0  0.0  0.0   \n",
       "Q37_3                 Rentabilidad de las empresas piñeras  0.0  0.0  0.0   \n",
       "Q37_4                       Sostenibilidad de la industria  0.0  0.0  0.0   \n",
       "Q38_1                                 Fertilidad del suelo  0.0  0.0  0.0   \n",
       "Q38_2                         Cantidad de mosca de establo  0.0  1.0  0.0   \n",
       "Q38_3                                  Uso de agroquimicos  0.0  0.0  0.0   \n",
       "\n",
       "        -L  -VL  NA  +VL   +L   +M   +H  +VH  \n",
       "Q4_1   0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q4_2   0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q4_3   0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q5_1   0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q5_2   1.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q6_1   0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q7_1   0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q8_1   0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q9_1   0.0  0.0   1  0.0  0.0  0.0  0.0  0.0  \n",
       "Q10_1  1.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q11_1  0.0  1.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q12_1  0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q12_2  0.0  0.0   0  0.0  0.0  0.0  0.0  1.0  \n",
       "Q13_1  0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q14_1  0.0  0.0   1  0.0  0.0  0.0  0.0  0.0  \n",
       "Q15_1  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q15_2  0.0  0.0   1  0.0  0.0  0.0  0.0  0.0  \n",
       "Q16_1  0.0  0.0   0  0.0  1.0  0.0  0.0  0.0  \n",
       "Q16_2  0.0  0.0   0  0.0  1.0  0.0  0.0  0.0  \n",
       "Q17_1  0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q18_1  0.0  0.0   1  0.0  0.0  0.0  0.0  0.0  \n",
       "Q18_2  0.0  0.0   0  1.0  0.0  0.0  0.0  0.0  \n",
       "Q19_1  0.0  0.0   0  0.0  1.0  0.0  0.0  0.0  \n",
       "Q20_1  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q20_2  0.0  0.0   1  0.0  0.0  0.0  0.0  0.0  \n",
       "Q20_3  0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q21_1  0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q22_1  1.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q23_1  0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q23_2  0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q24_1  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q24_2  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q25_1  0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q26_1  1.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q27_1  0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q28_1  0.0  0.0   0  1.0  0.0  0.0  0.0  0.0  \n",
       "Q29_1  0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q30_1  0.0  0.0   1  0.0  0.0  0.0  0.0  0.0  \n",
       "Q31_1  0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q32_1  0.0  0.0   0  0.0  0.0  0.0  0.0  1.0  \n",
       "Q33_1  0.0  0.0   0  0.0  0.0  0.0  0.0  1.0  \n",
       "Q34_1  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q34_2  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q35_1  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q36_1  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q37_1  0.0  0.0   0  0.0  0.0  0.0  0.0  1.0  \n",
       "Q37_2  0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q37_3  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q37_4  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q38_1  1.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q38_2  0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q38_3  1.0  0.0   0  0.0  0.0  0.0  0.0  0.0  "
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alldfs[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "a74b22dd-4b73-465d-8a42-461683a299db",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Buena imagen de la industria', 'Cantidad de mosca de establo',\n",
       "       'Colaboración/comunicación',\n",
       "       'Contaminación del suelo, aire y agua',\n",
       "       'Costo de materiales basados en combustibles fósiles',\n",
       "       'Costumbres de la industria', 'Demanda de productos PAL',\n",
       "       'Desnivel del terreno', 'Disponibilidad de la tierra', 'Empleo',\n",
       "       'Extracción del campo', 'Fertilidad del suelo', 'Financiamiento',\n",
       "       'Inestabilidad internacional ', 'Innovación',\n",
       "       'Investigación académica', 'Lluvia', 'Participación del gobierno',\n",
       "       'Preferencia de los consumidores por productos sostenibles',\n",
       "       'Productividad de la producción de piña',\n",
       "       'Productividad de los ganaderos', 'Productividad laboral',\n",
       "       'Regulaciones y estándares de importación (de destino)',\n",
       "       'Regulación de manejo del rastrojo',\n",
       "       'Rentabilidad de las empresas piñeras', 'Riesgo empresarial',\n",
       "       'Salud/bienestar de la comunidad',\n",
       "       'Sostenibilidad de la industria', 'Tamaño de la empresa',\n",
       "       'Transparencia/apertura de la industria', 'Uso de agroquimicos',\n",
       "       'Valorización del rastrojo'], dtype=object)"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.unique(sorted(alldfs[0][['From', 'To']].values.ravel('K')))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "id": "7819942a-16fa-4526-8539-68b87887850a",
   "metadata": {},
   "outputs": [],
   "source": [
    "#actually, we should change to English...\n",
    "\n",
    "engDict={'Buena imagen de la industria': 'industryImage', 'Cantidad de mosca de establo': 'stableFly',\n",
    "       'Colaboración/comunicación': 'collabComms',\n",
    "       'Contaminación del suelo, aire y agua':'pollution',\n",
    "        'Costo de materiales basados en combustibles fósiles': 'costFFmaterials',\n",
    "        'Costumbres de la industria':'industryCustoms', 'Demanda de productos PAL':'palProductsDemand',\n",
    "    'Desnivel del terreno': 'unevenTerrain', 'Disponibilidad de la tierra': 'landAvailable', \n",
    "    'Empleo': 'employment', 'Extracción del campo': 'fieldExtraction', 'Fertilidad del suelo':'soilFertil',\n",
    "    'Financiamiento': 'funding','Inestabilidad internacional ': 'intInstability', 'Innovación': 'innovation',\n",
    "       'Investigación académica': 'academia', 'Lluvia': 'rain', 'Participación del gobierno': 'govtPresence',\n",
    "        'Preferencia de los consumidores por productos sostenibles': 'greenConsumers',\n",
    "        'Productividad de la producción de piña': 'pineappleProdProductivity',\n",
    "        'Productividad de los ganaderos': 'ranchersProductivity', 'Productividad laboral':'laborProductivity',\n",
    "        'Regulaciones y estándares de importación (de destino)': 'importRegulations',\n",
    "        'Regulación de manejo del rastrojo': 'stubbleMgmtRegulation',\n",
    "        'Rentabilidad de las empresas piñeras': 'pineappleProdProfitability', 'Riesgo empresarial': 'businessRisk',\n",
    "        'Salud/bienestar de la comunidad': 'communityHealth',\n",
    "        'Sostenibilidad de la industria': 'industrySustainability', 'Tamaño de la empresa': 'companySize',\n",
    "    'Transparencia/apertura de la industria': 'industryTransparency', 'Uso de agroquimicos': 'agrochemicalsUse',\n",
    "       'Valorización del rastrojo': 'palValorization'}\n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "id": "ddb68de3-c293-4645-a7b6-d23af831fd41",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(len(alldfs)):\n",
    "        alldfs[i] = alldfs[i].replace({\"From\": engDict})\n",
    "        alldfs[i] = alldfs[i].replace({\"To\": engDict})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "73d54ec9-8d67-4a33-a1db-3ddc0bbae279",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>-VH</th>\n",
       "      <th>-H</th>\n",
       "      <th>-M</th>\n",
       "      <th>-L</th>\n",
       "      <th>-VL</th>\n",
       "      <th>NA</th>\n",
       "      <th>+VL</th>\n",
       "      <th>+L</th>\n",
       "      <th>+M</th>\n",
       "      <th>+H</th>\n",
       "      <th>+VH</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Q4_1</th>\n",
       "      <td>stubbleMgmtRegulation</td>\n",
       "      <td>innovation</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q4_2</th>\n",
       "      <td>stubbleMgmtRegulation</td>\n",
       "      <td>palValorization</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q4_3</th>\n",
       "      <td>stubbleMgmtRegulation</td>\n",
       "      <td>industrySustainability</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q5_1</th>\n",
       "      <td>stubbleMgmtRegulation</td>\n",
       "      <td>stableFly</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q5_2</th>\n",
       "      <td>stubbleMgmtRegulation</td>\n",
       "      <td>agrochemicalsUse</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q6_1</th>\n",
       "      <td>industryImage</td>\n",
       "      <td>funding</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q7_1</th>\n",
       "      <td>collabComms</td>\n",
       "      <td>innovation</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q8_1</th>\n",
       "      <td>pollution</td>\n",
       "      <td>communityHealth</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q9_1</th>\n",
       "      <td>costFFmaterials</td>\n",
       "      <td>palProductsDemand</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q10_1</th>\n",
       "      <td>costFFmaterials</td>\n",
       "      <td>pineappleProdProfitability</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q11_1</th>\n",
       "      <td>industryCustoms</td>\n",
       "      <td>palValorization</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q12_1</th>\n",
       "      <td>palProductsDemand</td>\n",
       "      <td>innovation</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q12_2</th>\n",
       "      <td>palProductsDemand</td>\n",
       "      <td>palValorization</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q13_1</th>\n",
       "      <td>unevenTerrain</td>\n",
       "      <td>fieldExtraction</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q14_1</th>\n",
       "      <td>landAvailable</td>\n",
       "      <td>pineappleProdProductivity</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q15_1</th>\n",
       "      <td>employment</td>\n",
       "      <td>communityHealth</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q15_2</th>\n",
       "      <td>employment</td>\n",
       "      <td>funding</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q16_1</th>\n",
       "      <td>fieldExtraction</td>\n",
       "      <td>innovation</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q16_2</th>\n",
       "      <td>fieldExtraction</td>\n",
       "      <td>palValorization</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q17_1</th>\n",
       "      <td>fieldExtraction</td>\n",
       "      <td>agrochemicalsUse</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q18_1</th>\n",
       "      <td>funding</td>\n",
       "      <td>academia</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q18_2</th>\n",
       "      <td>funding</td>\n",
       "      <td>innovation</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q19_1</th>\n",
       "      <td>intInstability</td>\n",
       "      <td>costFFmaterials</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q20_1</th>\n",
       "      <td>innovation</td>\n",
       "      <td>fieldExtraction</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q20_2</th>\n",
       "      <td>innovation</td>\n",
       "      <td>laborProductivity</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q20_3</th>\n",
       "      <td>innovation</td>\n",
       "      <td>palValorization</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q21_1</th>\n",
       "      <td>academia</td>\n",
       "      <td>innovation</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q22_1</th>\n",
       "      <td>rain</td>\n",
       "      <td>fieldExtraction</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q23_1</th>\n",
       "      <td>stableFly</td>\n",
       "      <td>communityHealth</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q23_2</th>\n",
       "      <td>stableFly</td>\n",
       "      <td>ranchersProductivity</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q24_1</th>\n",
       "      <td>govtPresence</td>\n",
       "      <td>collabComms</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q24_2</th>\n",
       "      <td>govtPresence</td>\n",
       "      <td>stubbleMgmtRegulation</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q25_1</th>\n",
       "      <td>greenConsumers</td>\n",
       "      <td>palProductsDemand</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q26_1</th>\n",
       "      <td>greenConsumers</td>\n",
       "      <td>agrochemicalsUse</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q27_1</th>\n",
       "      <td>pineappleProdProductivity</td>\n",
       "      <td>pineappleProdProfitability</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q28_1</th>\n",
       "      <td>laborProductivity</td>\n",
       "      <td>fieldExtraction</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q29_1</th>\n",
       "      <td>importRegulations</td>\n",
       "      <td>agrochemicalsUse</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q30_1</th>\n",
       "      <td>pineappleProdProfitability</td>\n",
       "      <td>industrySustainability</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q31_1</th>\n",
       "      <td>businessRisk</td>\n",
       "      <td>innovation</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q32_1</th>\n",
       "      <td>communityHealth</td>\n",
       "      <td>industryImage</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q33_1</th>\n",
       "      <td>industrySustainability</td>\n",
       "      <td>palProductsDemand</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q34_1</th>\n",
       "      <td>companySize</td>\n",
       "      <td>funding</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q34_2</th>\n",
       "      <td>companySize</td>\n",
       "      <td>pineappleProdProfitability</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q35_1</th>\n",
       "      <td>industryTransparency</td>\n",
       "      <td>collabComms</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q36_1</th>\n",
       "      <td>agrochemicalsUse</td>\n",
       "      <td>pollution</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q37_1</th>\n",
       "      <td>palValorization</td>\n",
       "      <td>fieldExtraction</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q37_2</th>\n",
       "      <td>palValorization</td>\n",
       "      <td>landAvailable</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q37_3</th>\n",
       "      <td>palValorization</td>\n",
       "      <td>pineappleProdProfitability</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q37_4</th>\n",
       "      <td>palValorization</td>\n",
       "      <td>industrySustainability</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q38_1</th>\n",
       "      <td>palValorization</td>\n",
       "      <td>soilFertil</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q38_2</th>\n",
       "      <td>palValorization</td>\n",
       "      <td>stableFly</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q38_3</th>\n",
       "      <td>palValorization</td>\n",
       "      <td>agrochemicalsUse</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             From                          To  -VH   -H   -M  \\\n",
       "Q4_1        stubbleMgmtRegulation                  innovation  0.0  0.0  0.0   \n",
       "Q4_2        stubbleMgmtRegulation             palValorization  0.0  0.0  0.0   \n",
       "Q4_3        stubbleMgmtRegulation      industrySustainability  0.0  0.0  0.0   \n",
       "Q5_1        stubbleMgmtRegulation                   stableFly  0.0  1.0  0.0   \n",
       "Q5_2        stubbleMgmtRegulation            agrochemicalsUse  0.0  0.0  0.0   \n",
       "Q6_1                industryImage                     funding  0.0  0.0  0.0   \n",
       "Q7_1                  collabComms                  innovation  0.0  0.0  0.0   \n",
       "Q8_1                    pollution             communityHealth  1.0  0.0  0.0   \n",
       "Q9_1              costFFmaterials           palProductsDemand  0.0  0.0  0.0   \n",
       "Q10_1             costFFmaterials  pineappleProdProfitability  0.0  0.0  0.0   \n",
       "Q11_1             industryCustoms             palValorization  0.0  0.0  0.0   \n",
       "Q12_1           palProductsDemand                  innovation  0.0  0.0  0.0   \n",
       "Q12_2           palProductsDemand             palValorization  0.0  0.0  0.0   \n",
       "Q13_1               unevenTerrain             fieldExtraction  0.0  0.0  1.0   \n",
       "Q14_1               landAvailable   pineappleProdProductivity  0.0  0.0  0.0   \n",
       "Q15_1                  employment             communityHealth  0.0  0.0  0.0   \n",
       "Q15_2                  employment                     funding  0.0  0.0  0.0   \n",
       "Q16_1             fieldExtraction                  innovation  0.0  0.0  0.0   \n",
       "Q16_2             fieldExtraction             palValorization  0.0  0.0  0.0   \n",
       "Q17_1             fieldExtraction            agrochemicalsUse  0.0  1.0  0.0   \n",
       "Q18_1                     funding                    academia  0.0  0.0  0.0   \n",
       "Q18_2                     funding                  innovation  0.0  0.0  0.0   \n",
       "Q19_1              intInstability             costFFmaterials  0.0  0.0  0.0   \n",
       "Q20_1                  innovation             fieldExtraction  0.0  0.0  0.0   \n",
       "Q20_2                  innovation           laborProductivity  0.0  0.0  0.0   \n",
       "Q20_3                  innovation             palValorization  0.0  0.0  0.0   \n",
       "Q21_1                    academia                  innovation  0.0  0.0  0.0   \n",
       "Q22_1                        rain             fieldExtraction  0.0  0.0  0.0   \n",
       "Q23_1                   stableFly             communityHealth  0.0  1.0  0.0   \n",
       "Q23_2                   stableFly        ranchersProductivity  0.0  0.0  1.0   \n",
       "Q24_1                govtPresence                 collabComms  0.0  0.0  0.0   \n",
       "Q24_2                govtPresence       stubbleMgmtRegulation  0.0  0.0  0.0   \n",
       "Q25_1              greenConsumers           palProductsDemand  0.0  0.0  0.0   \n",
       "Q26_1              greenConsumers            agrochemicalsUse  0.0  0.0  0.0   \n",
       "Q27_1   pineappleProdProductivity  pineappleProdProfitability  0.0  0.0  0.0   \n",
       "Q28_1           laborProductivity             fieldExtraction  0.0  0.0  0.0   \n",
       "Q29_1           importRegulations            agrochemicalsUse  0.0  1.0  0.0   \n",
       "Q30_1  pineappleProdProfitability      industrySustainability  0.0  0.0  0.0   \n",
       "Q31_1                businessRisk                  innovation  0.0  0.0  1.0   \n",
       "Q32_1             communityHealth               industryImage  0.0  0.0  0.0   \n",
       "Q33_1      industrySustainability           palProductsDemand  0.0  0.0  0.0   \n",
       "Q34_1                 companySize                     funding  0.0  0.0  0.0   \n",
       "Q34_2                 companySize  pineappleProdProfitability  0.0  0.0  0.0   \n",
       "Q35_1        industryTransparency                 collabComms  0.0  0.0  0.0   \n",
       "Q36_1            agrochemicalsUse                   pollution  0.0  0.0  0.0   \n",
       "Q37_1             palValorization             fieldExtraction  0.0  0.0  0.0   \n",
       "Q37_2             palValorization               landAvailable  0.0  0.0  0.0   \n",
       "Q37_3             palValorization  pineappleProdProfitability  0.0  0.0  0.0   \n",
       "Q37_4             palValorization      industrySustainability  0.0  0.0  0.0   \n",
       "Q38_1             palValorization                  soilFertil  0.0  0.0  0.0   \n",
       "Q38_2             palValorization                   stableFly  0.0  1.0  0.0   \n",
       "Q38_3             palValorization            agrochemicalsUse  0.0  0.0  0.0   \n",
       "\n",
       "        -L  -VL  NA  +VL   +L   +M   +H  +VH  \n",
       "Q4_1   0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q4_2   0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q4_3   0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q5_1   0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q5_2   1.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q6_1   0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q7_1   0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q8_1   0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q9_1   0.0  0.0   1  0.0  0.0  0.0  0.0  0.0  \n",
       "Q10_1  1.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q11_1  0.0  1.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q12_1  0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q12_2  0.0  0.0   0  0.0  0.0  0.0  0.0  1.0  \n",
       "Q13_1  0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q14_1  0.0  0.0   1  0.0  0.0  0.0  0.0  0.0  \n",
       "Q15_1  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q15_2  0.0  0.0   1  0.0  0.0  0.0  0.0  0.0  \n",
       "Q16_1  0.0  0.0   0  0.0  1.0  0.0  0.0  0.0  \n",
       "Q16_2  0.0  0.0   0  0.0  1.0  0.0  0.0  0.0  \n",
       "Q17_1  0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q18_1  0.0  0.0   1  0.0  0.0  0.0  0.0  0.0  \n",
       "Q18_2  0.0  0.0   0  1.0  0.0  0.0  0.0  0.0  \n",
       "Q19_1  0.0  0.0   0  0.0  1.0  0.0  0.0  0.0  \n",
       "Q20_1  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q20_2  0.0  0.0   1  0.0  0.0  0.0  0.0  0.0  \n",
       "Q20_3  0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q21_1  0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q22_1  1.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q23_1  0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q23_2  0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q24_1  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q24_2  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q25_1  0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q26_1  1.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q27_1  0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q28_1  0.0  0.0   0  1.0  0.0  0.0  0.0  0.0  \n",
       "Q29_1  0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q30_1  0.0  0.0   1  0.0  0.0  0.0  0.0  0.0  \n",
       "Q31_1  0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q32_1  0.0  0.0   0  0.0  0.0  0.0  0.0  1.0  \n",
       "Q33_1  0.0  0.0   0  0.0  0.0  0.0  0.0  1.0  \n",
       "Q34_1  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q34_2  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q35_1  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q36_1  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q37_1  0.0  0.0   0  0.0  0.0  0.0  0.0  1.0  \n",
       "Q37_2  0.0  0.0   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q37_3  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q37_4  0.0  0.0   0  0.0  0.0  0.0  1.0  0.0  \n",
       "Q38_1  1.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q38_2  0.0  0.0   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q38_3  1.0  0.0   0  0.0  0.0  0.0  0.0  0.0  "
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alldfs[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1539cd7b",
   "metadata": {},
   "source": [
    "### Create dictionary wirth expert number as key"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "id": "bd81529a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['expert1', 'expert2', 'expert3', 'expert4', 'expert5', 'expert6', 'expert7', 'expert8', 'expert9']\n"
     ]
    }
   ],
   "source": [
    "experts=[f'expert{i}' for i in range(1, 10)]\n",
    "print(experts)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "id": "0a52dce9",
   "metadata": {},
   "outputs": [],
   "source": [
    "experDic = dict(zip(experts, alldfs))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "id": "d7b3fd81",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['expert1', 'expert2', 'expert3', 'expert4', 'expert5', 'expert6', 'expert7', 'expert8'])"
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "experDic.keys()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fa3a392a",
   "metadata": {},
   "source": [
    "### Now we have a dictionary containing one dataframe for each expert. This will be imported in the FCMpy script"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "id": "7ce0bf7d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>-VH</th>\n",
       "      <th>-H</th>\n",
       "      <th>-M</th>\n",
       "      <th>-L</th>\n",
       "      <th>-VL</th>\n",
       "      <th>NA</th>\n",
       "      <th>+VL</th>\n",
       "      <th>+L</th>\n",
       "      <th>+M</th>\n",
       "      <th>+H</th>\n",
       "      <th>+VH</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Q4_1</th>\n",
       "      <td>stubbleMgmtRegulation</td>\n",
       "      <td>innovation</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q4_2</th>\n",
       "      <td>stubbleMgmtRegulation</td>\n",
       "      <td>palValorization</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q4_3</th>\n",
       "      <td>stubbleMgmtRegulation</td>\n",
       "      <td>industrySustainability</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q5_1</th>\n",
       "      <td>stubbleMgmtRegulation</td>\n",
       "      <td>stableFly</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q5_2</th>\n",
       "      <td>stubbleMgmtRegulation</td>\n",
       "      <td>agrochemicalsUse</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       From                      To  -VH   -H   -M   -L  -VL  \\\n",
       "Q4_1  stubbleMgmtRegulation              innovation  0.0  0.0  0.0  0.0  0.0   \n",
       "Q4_2  stubbleMgmtRegulation         palValorization  0.0  0.0  0.0  0.0  0.0   \n",
       "Q4_3  stubbleMgmtRegulation  industrySustainability  0.0  0.0  0.0  0.0  0.0   \n",
       "Q5_1  stubbleMgmtRegulation               stableFly  0.0  1.0  0.0  0.0  0.0   \n",
       "Q5_2  stubbleMgmtRegulation        agrochemicalsUse  0.0  0.0  0.0  1.0  0.0   \n",
       "\n",
       "      NA  +VL   +L   +M   +H  +VH  \n",
       "Q4_1   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q4_2   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q4_3   0  0.0  0.0  1.0  0.0  0.0  \n",
       "Q5_1   0  0.0  0.0  0.0  0.0  0.0  \n",
       "Q5_2   0  0.0  0.0  0.0  0.0  0.0  "
      ]
     },
     "execution_count": 98,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "experDic['expert1'].head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "254f58a0",
   "metadata": {},
   "source": [
    "### Save to excel, each dataframe is one sheet "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "id": "78f701af",
   "metadata": {},
   "outputs": [],
   "source": [
    "def save_xls(dict_df, path):\n",
    "    \"\"\"\n",
    "    Save a dictionary of dataframes to an excel file, \n",
    "    with each dataframe as a separate sheet\n",
    "    \"\"\"\n",
    "\n",
    "    writer = ExcelWriter(path)\n",
    "    for key in dict_df.keys():\n",
    "        dict_df[key].to_excel(writer, sheet_name=key, index=False)\n",
    "\n",
    "    writer.save()\n",
    "    writer.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "id": "150c604f",
   "metadata": {},
   "outputs": [],
   "source": [
    "save_xls(experDic, os.path.join(output_path,\"expertsR.xlsx\"))"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}