03_Procesamiento_Escenario_Actual_GLOBIO_2010.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# ESCENARIO PRESENTE (2010)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# PAQUETES"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import rasterio\n",
    "import geopandas as gpd\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "from rasterio.mask import mask\n",
    "from shapely.geometry import box\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# CARGAR DATOS"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ET_ID</th>\n",
       "      <th>COUNTRY</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>280</td>\n",
       "      <td>Malta</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>363</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>412</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((23.95653 35.05738, 23.41935 35.13773...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>413</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((24.49271 34.97391, 23.95653 35.05738...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3101</th>\n",
       "      <td>9369</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((26.92771 70.58708, 25.63446 70.69412...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3102</th>\n",
       "      <td>9370</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((28.20775 70.47181, 26.92771 70.58708...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3103</th>\n",
       "      <td>9371</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((29.47384 70.34844, 28.20775 70.47181...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3104</th>\n",
       "      <td>9372</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((30.72534 70.21713, 29.47384 70.34844...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3105</th>\n",
       "      <td>9485</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((28.60702 70.90647, 27.30206 71.02446...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3106 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      ET_ID COUNTRY                                           geometry\n",
       "0       249   Spain  POLYGON ((-2.18083 34.85145, -2.71695 34.77839...\n",
       "1       280   Malta  POLYGON ((14.68659 35.53849, 14.14122 35.56449...\n",
       "2       363   Spain  POLYGON ((-2.79499 35.22702, -3.33331 35.15029...\n",
       "3       412  Greece  POLYGON ((23.95653 35.05738, 23.41935 35.13773...\n",
       "4       413  Greece  POLYGON ((24.49271 34.97391, 23.95653 35.05738...\n",
       "...     ...     ...                                                ...\n",
       "3101   9369  Norway  POLYGON ((26.92771 70.58708, 25.63446 70.69412...\n",
       "3102   9370  Norway  POLYGON ((28.20775 70.47181, 26.92771 70.58708...\n",
       "3103   9371  Norway  POLYGON ((29.47384 70.34844, 28.20775 70.47181...\n",
       "3104   9372  Norway  POLYGON ((30.72534 70.21713, 29.47384 70.34844...\n",
       "3105   9485  Norway  POLYGON ((28.60702 70.90647, 27.30206 71.02446...\n",
       "\n",
       "[3106 rows x 3 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Cargar el grid\n",
    "Grid_50 = gpd.read_file(r'Data/Grid50/Grid_50Km_Europe_WGS84.shp')\n",
    "Grid_50"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Abrir el raster y leer los datos fuera del bucle\n",
    "src = rasterio.open(r'Data/GLOBIO/2010/Globio4_GBW_LU_2010_10sec.tif')\n",
    "\n",
    "# Obtener la transformación y el sistema de referencia del raster\n",
    "raster_transform = src.transform\n",
    "raster_crs = src.crs\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Reproyectar la malla al sistema de coordenadas del raster si es necesario\n",
    "if Grid_50.crs != raster_crs:\n",
    "    Grid_50 = Grid_50.to_crs(raster_crs)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# PROCESAMIENTO DATOS DE HABITAT"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Con los datos descargados de GLOBIO para los usos del suelo del año 2010 (periodo coincidente con los datos de temperatura) se procede a extraer la información asociada a cada categoría de hábitat definida por GLOBIO que sea de interés para el modelo de distribución de especies. Para el SDM se ha establecido 4 tipologías de habitas, las cuales están constituidas por distintas categorías de GLOBIO.\n",
    "\n",
    "- Habitat 1 - Zonas acuáticas\n",
    "- Habitat 2 - Vegetación Arbórea Perenne\n",
    "- Habitat 3 - Vegetación Arbórea Caduca\n",
    "- Habitat 4 - Matorrales y Pastizales\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Habitat 1 - Zonas acuáticas\n",
    "\n",
    "El habitat 1, corresponderá con ambientes acuaticos, por lo que se incluyen las siguiente tipologias disponible en GLOBIO:\n",
    " - 160: Cubierta arbórea inundada con agua dulce o salobre\n",
    " - 170: Cubierta arbórea inundada con agua salina\n",
    " - 180: Cobertura de arbustos o herbácea inundada con agua dulce/salina/salobre\n",
    " - 210: Cuerpos de agua"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extraccion_calculo_area(code):\n",
    "    # Crear una columna para almacenar el área del código específico por celda\n",
    "    column_name = f'area_{code}'\n",
    "    Grid_50[column_name] = 0.0\n",
    "    \n",
    "    # Iterar sobre cada celda en la malla\n",
    "    for idx, cell in Grid_50.iterrows():\n",
    "        # Crear una máscara para la celda actual\n",
    "        geom = [cell.geometry]\n",
    "        out_image, out_transform = mask(src, geom, crop=True, filled=False)\n",
    "        \n",
    "        # Extraer el código específico\n",
    "        code_mask = (out_image == code).astype(np.uint8)\n",
    "        \n",
    "        # Calcular el área\n",
    "        area_code = np.sum(code_mask) * (raster_transform[0] ** 2)  # Área en m²\n",
    "        \n",
    "        # Almacenar el resultado en la celda correspondiente\n",
    "        Grid_50.at[idx, column_name] = area_code"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "extraccion_calculo_area(160)\n",
    "extraccion_calculo_area(170)\n",
    "extraccion_calculo_area(180)\n",
    "extraccion_calculo_area(210)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ET_ID</th>\n",
       "      <th>COUNTRY</th>\n",
       "      <th>geometry</th>\n",
       "      <th>area_160</th>\n",
       "      <th>area_170</th>\n",
       "      <th>area_180</th>\n",
       "      <th>area_210</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.087106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>280</td>\n",
       "      <td>Malta</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.224745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>363</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.207083</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>412</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((23.95653 35.05738, 23.41935 35.13773...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000054</td>\n",
       "      <td>0.113789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>413</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((24.49271 34.97391, 23.95653 35.05738...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.123387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3101</th>\n",
       "      <td>9369</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((26.92771 70.58708, 25.63446 70.69412...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.004437</td>\n",
       "      <td>0.441667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3102</th>\n",
       "      <td>9370</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((28.20775 70.47181, 26.92771 70.58708...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.012261</td>\n",
       "      <td>0.180910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3103</th>\n",
       "      <td>9371</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((29.47384 70.34844, 28.20775 70.47181...</td>\n",
       "      <td>0.000054</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.006613</td>\n",
       "      <td>0.129668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3104</th>\n",
       "      <td>9372</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((30.72534 70.21713, 29.47384 70.34844...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.003565</td>\n",
       "      <td>0.214846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3105</th>\n",
       "      <td>9485</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((28.60702 70.90647, 27.30206 71.02446...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.002114</td>\n",
       "      <td>0.528511</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3106 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      ET_ID COUNTRY                                           geometry  \\\n",
       "0       249   Spain  POLYGON ((-2.18083 34.85145, -2.71695 34.77839...   \n",
       "1       280   Malta  POLYGON ((14.68659 35.53849, 14.14122 35.56449...   \n",
       "2       363   Spain  POLYGON ((-2.79499 35.22702, -3.33331 35.15029...   \n",
       "3       412  Greece  POLYGON ((23.95653 35.05738, 23.41935 35.13773...   \n",
       "4       413  Greece  POLYGON ((24.49271 34.97391, 23.95653 35.05738...   \n",
       "...     ...     ...                                                ...   \n",
       "3101   9369  Norway  POLYGON ((26.92771 70.58708, 25.63446 70.69412...   \n",
       "3102   9370  Norway  POLYGON ((28.20775 70.47181, 26.92771 70.58708...   \n",
       "3103   9371  Norway  POLYGON ((29.47384 70.34844, 28.20775 70.47181...   \n",
       "3104   9372  Norway  POLYGON ((30.72534 70.21713, 29.47384 70.34844...   \n",
       "3105   9485  Norway  POLYGON ((28.60702 70.90647, 27.30206 71.02446...   \n",
       "\n",
       "      area_160  area_170  area_180  area_210  \n",
       "0     0.000000       0.0  0.000000  0.087106  \n",
       "1     0.000000       0.0  0.000000  0.224745  \n",
       "2     0.000000       0.0  0.000000  0.207083  \n",
       "3     0.000000       0.0  0.000054  0.113789  \n",
       "4     0.000000       0.0  0.000000  0.123387  \n",
       "...        ...       ...       ...       ...  \n",
       "3101  0.000000       0.0  0.004437  0.441667  \n",
       "3102  0.000000       0.0  0.012261  0.180910  \n",
       "3103  0.000054       0.0  0.006613  0.129668  \n",
       "3104  0.000000       0.0  0.003565  0.214846  \n",
       "3105  0.000000       0.0  0.002114  0.528511  \n",
       "\n",
       "[3106 rows x 7 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Grid_50"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Seleccionar las columnas\n",
    "area_columns = [col for col in Grid_50.columns if col.startswith('area_')]\n",
    "# sumatorio de las distintas columnas con el area de cada tipología\n",
    "Grid_50['Area_H_1'] = Grid_50[area_columns].sum(axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>ET_ID</th>\n",
       "      <th>COUNTRY</th>\n",
       "      <th>geometry</th>\n",
       "      <th>area_160</th>\n",
       "      <th>area_170</th>\n",
       "      <th>area_180</th>\n",
       "      <th>area_210</th>\n",
       "      <th>Area_H_1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.087106</td>\n",
       "      <td>0.087106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>280</td>\n",
       "      <td>Malta</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.224745</td>\n",
       "      <td>0.224745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>363</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.207083</td>\n",
       "      <td>0.207083</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>412</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((23.95653 35.05738, 23.41935 35.13773...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000054</td>\n",
       "      <td>0.113789</td>\n",
       "      <td>0.113843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>413</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((24.49271 34.97391, 23.95653 35.05738...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.123387</td>\n",
       "      <td>0.123387</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ET_ID COUNTRY                                           geometry  area_160  \\\n",
       "0    249   Spain  POLYGON ((-2.18083 34.85145, -2.71695 34.77839...       0.0   \n",
       "1    280   Malta  POLYGON ((14.68659 35.53849, 14.14122 35.56449...       0.0   \n",
       "2    363   Spain  POLYGON ((-2.79499 35.22702, -3.33331 35.15029...       0.0   \n",
       "3    412  Greece  POLYGON ((23.95653 35.05738, 23.41935 35.13773...       0.0   \n",
       "4    413  Greece  POLYGON ((24.49271 34.97391, 23.95653 35.05738...       0.0   \n",
       "\n",
       "   area_170  area_180  area_210  Area_H_1  \n",
       "0       0.0  0.000000  0.087106  0.087106  \n",
       "1       0.0  0.000000  0.224745  0.224745  \n",
       "2       0.0  0.000000  0.207083  0.207083  \n",
       "3       0.0  0.000054  0.113789  0.113843  \n",
       "4       0.0  0.000000  0.123387  0.123387  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Grid_50.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Guardar el resultado en un nuevo shapefile\n",
    "# Grid_50.to_file('Data/GLOBIO/2010/Grids_Habitats/Grid_H_1.shp')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['ET_ID', 'COUNTRY', 'geometry', 'area_160', 'area_170', 'area_180',\n",
       "       'area_210', 'Area_H_1'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Grid_50.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead 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>ET_ID</th>\n",
       "      <th>COUNTRY</th>\n",
       "      <th>geometry</th>\n",
       "      <th>Area_H_1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>0.087106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>280</td>\n",
       "      <td>Malta</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "      <td>0.224745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>363</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "      <td>0.207083</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>412</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((23.95653 35.05738, 23.41935 35.13773...</td>\n",
       "      <td>0.113843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>413</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((24.49271 34.97391, 23.95653 35.05738...</td>\n",
       "      <td>0.123387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3101</th>\n",
       "      <td>9369</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((26.92771 70.58708, 25.63446 70.69412...</td>\n",
       "      <td>0.446103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3102</th>\n",
       "      <td>9370</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((28.20775 70.47181, 26.92771 70.58708...</td>\n",
       "      <td>0.193171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3103</th>\n",
       "      <td>9371</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((29.47384 70.34844, 28.20775 70.47181...</td>\n",
       "      <td>0.136335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3104</th>\n",
       "      <td>9372</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((30.72534 70.21713, 29.47384 70.34844...</td>\n",
       "      <td>0.218410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3105</th>\n",
       "      <td>9485</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((28.60702 70.90647, 27.30206 71.02446...</td>\n",
       "      <td>0.530625</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3106 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      ET_ID COUNTRY                                           geometry  \\\n",
       "0       249   Spain  POLYGON ((-2.18083 34.85145, -2.71695 34.77839...   \n",
       "1       280   Malta  POLYGON ((14.68659 35.53849, 14.14122 35.56449...   \n",
       "2       363   Spain  POLYGON ((-2.79499 35.22702, -3.33331 35.15029...   \n",
       "3       412  Greece  POLYGON ((23.95653 35.05738, 23.41935 35.13773...   \n",
       "4       413  Greece  POLYGON ((24.49271 34.97391, 23.95653 35.05738...   \n",
       "...     ...     ...                                                ...   \n",
       "3101   9369  Norway  POLYGON ((26.92771 70.58708, 25.63446 70.69412...   \n",
       "3102   9370  Norway  POLYGON ((28.20775 70.47181, 26.92771 70.58708...   \n",
       "3103   9371  Norway  POLYGON ((29.47384 70.34844, 28.20775 70.47181...   \n",
       "3104   9372  Norway  POLYGON ((30.72534 70.21713, 29.47384 70.34844...   \n",
       "3105   9485  Norway  POLYGON ((28.60702 70.90647, 27.30206 71.02446...   \n",
       "\n",
       "      Area_H_1  \n",
       "0     0.087106  \n",
       "1     0.224745  \n",
       "2     0.207083  \n",
       "3     0.113843  \n",
       "4     0.123387  \n",
       "...        ...  \n",
       "3101  0.446103  \n",
       "3102  0.193171  \n",
       "3103  0.136335  \n",
       "3104  0.218410  \n",
       "3105  0.530625  \n",
       "\n",
       "[3106 rows x 4 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "columns_select = ['ET_ID', 'COUNTRY', 'geometry',\n",
    "                  'Area_H_1'\n",
    "                  ]\n",
    "\n",
    "Grid_Habitats = Grid_50[columns_select]\n",
    "Grid_Habitats"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Habitat 2 - Vegetación Arbórea Perenne\n",
    "\n",
    "El habitat 2, corresponde con vegetación arbórea perenne, por lo que se incluyen las siguiente tipologias disponible en GLOBIO:\n",
    "\n",
    " - 50: Cubierta arbórea de hoja ancha perenne cerrada a abierta (>15%)\n",
    " - 70: Cubierta arbórea de hoja acicular perenne cerrada a abierta (>15%)\n",
    " - 71: Cubierta arbórea de hoja acicular perenne cerrada (>40%)\n",
    " - 72: Cubierta arbórea de hoja acicular perenne abierta (15-40%)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Cargar el grid nuevamente\n",
    "Grid_50 = gpd.read_file(r'Grid50/Grid_50Km_Europe_WGS84.shp')\n",
    "# Reproyectar la malla al sistema de coordenadas del raster si es necesario\n",
    "if Grid_50.crs != raster_crs:\n",
    "    Grid_50 = Grid_50.to_crs(raster_crs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "extraccion_calculo_area(50)\n",
    "extraccion_calculo_area(70)\n",
    "extraccion_calculo_area(71)\n",
    "extraccion_calculo_area(72)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "area_columns = [col for col in Grid_50.columns if col.startswith('area_')]\n",
    "\n",
    "Grid_50['Area_H_2'] = Grid_50[area_columns].sum(axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>ET_ID</th>\n",
       "      <th>COUNTRY</th>\n",
       "      <th>geometry</th>\n",
       "      <th>area_50</th>\n",
       "      <th>area_70</th>\n",
       "      <th>area_71</th>\n",
       "      <th>area_72</th>\n",
       "      <th>Area_H_2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>280</td>\n",
       "      <td>Malta</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>363</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>412</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((23.95653 35.05738, 23.41935 35.13773...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.004977</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.004977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>413</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((24.49271 34.97391, 23.95653 35.05738...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000378</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000378</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ET_ID COUNTRY                                           geometry  area_50  \\\n",
       "0    249   Spain  POLYGON ((-2.18083 34.85145, -2.71695 34.77839...      0.0   \n",
       "1    280   Malta  POLYGON ((14.68659 35.53849, 14.14122 35.56449...      0.0   \n",
       "2    363   Spain  POLYGON ((-2.79499 35.22702, -3.33331 35.15029...      0.0   \n",
       "3    412  Greece  POLYGON ((23.95653 35.05738, 23.41935 35.13773...      0.0   \n",
       "4    413  Greece  POLYGON ((24.49271 34.97391, 23.95653 35.05738...      0.0   \n",
       "\n",
       "    area_70  area_71  area_72  Area_H_2  \n",
       "0  0.000000      0.0      0.0  0.000000  \n",
       "1  0.000000      0.0      0.0  0.000000  \n",
       "2  0.000000      0.0      0.0  0.000000  \n",
       "3  0.004977      0.0      0.0  0.004977  \n",
       "4  0.000378      0.0      0.0  0.000378  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Grid_50.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Guardar el resultado en un nuevo shapefile\n",
    "#Grid_50.to_file('Data/GLOBIO/2010/Grid_H_2.shp')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Columnas de interes\n",
    "Grid_50_s = Grid_50[['ET_ID', 'Area_H_2']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>ET_ID</th>\n",
       "      <th>COUNTRY</th>\n",
       "      <th>geometry</th>\n",
       "      <th>Area_H_1</th>\n",
       "      <th>Area_H_2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>0.087106</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>280</td>\n",
       "      <td>Malta</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "      <td>0.224745</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>363</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "      <td>0.207083</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>412</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((23.95653 35.05738, 23.41935 35.13773...</td>\n",
       "      <td>0.113843</td>\n",
       "      <td>0.004977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>413</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((24.49271 34.97391, 23.95653 35.05738...</td>\n",
       "      <td>0.123387</td>\n",
       "      <td>0.000378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3101</th>\n",
       "      <td>9369</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((26.92771 70.58708, 25.63446 70.69412...</td>\n",
       "      <td>0.446103</td>\n",
       "      <td>0.003866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3102</th>\n",
       "      <td>9370</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((28.20775 70.47181, 26.92771 70.58708...</td>\n",
       "      <td>0.193171</td>\n",
       "      <td>0.018920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3103</th>\n",
       "      <td>9371</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((29.47384 70.34844, 28.20775 70.47181...</td>\n",
       "      <td>0.136335</td>\n",
       "      <td>0.008858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3104</th>\n",
       "      <td>9372</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((30.72534 70.21713, 29.47384 70.34844...</td>\n",
       "      <td>0.218410</td>\n",
       "      <td>0.003511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3105</th>\n",
       "      <td>9485</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((28.60702 70.90647, 27.30206 71.02446...</td>\n",
       "      <td>0.530625</td>\n",
       "      <td>0.002639</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3106 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      ET_ID COUNTRY                                           geometry  \\\n",
       "0       249   Spain  POLYGON ((-2.18083 34.85145, -2.71695 34.77839...   \n",
       "1       280   Malta  POLYGON ((14.68659 35.53849, 14.14122 35.56449...   \n",
       "2       363   Spain  POLYGON ((-2.79499 35.22702, -3.33331 35.15029...   \n",
       "3       412  Greece  POLYGON ((23.95653 35.05738, 23.41935 35.13773...   \n",
       "4       413  Greece  POLYGON ((24.49271 34.97391, 23.95653 35.05738...   \n",
       "...     ...     ...                                                ...   \n",
       "3101   9369  Norway  POLYGON ((26.92771 70.58708, 25.63446 70.69412...   \n",
       "3102   9370  Norway  POLYGON ((28.20775 70.47181, 26.92771 70.58708...   \n",
       "3103   9371  Norway  POLYGON ((29.47384 70.34844, 28.20775 70.47181...   \n",
       "3104   9372  Norway  POLYGON ((30.72534 70.21713, 29.47384 70.34844...   \n",
       "3105   9485  Norway  POLYGON ((28.60702 70.90647, 27.30206 71.02446...   \n",
       "\n",
       "      Area_H_1  Area_H_2  \n",
       "0     0.087106  0.000000  \n",
       "1     0.224745  0.000000  \n",
       "2     0.207083  0.000000  \n",
       "3     0.113843  0.004977  \n",
       "4     0.123387  0.000378  \n",
       "...        ...       ...  \n",
       "3101  0.446103  0.003866  \n",
       "3102  0.193171  0.018920  \n",
       "3103  0.136335  0.008858  \n",
       "3104  0.218410  0.003511  \n",
       "3105  0.530625  0.002639  \n",
       "\n",
       "[3106 rows x 5 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#  Unir los DataFrames usando el campo ET_ID como clave\n",
    "Grid_Habitats = pd.merge(Grid_Habitats, Grid_50_s, on='ET_ID', how='left')\n",
    "Grid_Habitats"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Habitat 3 - Vegetación Arbórea Caduca\n",
    "\n",
    "El habitat 3, corresponde con vegetación arbórea caduca, por lo que se incluyen las siguiente tipologias disponible en GLOBIO:\n",
    "\n",
    " - 60: Cubierta arbórea de hoja ancha caduca cerrada a abierta (>15%)\n",
    " - 61: Cubierta arbórea de hoja ancha caduca cerrada (>40%)\n",
    " - 62: Cubierta arbórea de hoja ancha caduca cerrada (>40%)\n",
    " - 80: Cubierta arbórea de hoja acicular caduca cerrada a abierta (>15%)\n",
    " - 81: Cubierta arbórea de hoja acicular caduca cerrada (>40%)\n",
    " - 82: Cubierta arbórea de hoja acicular caduca abierta (15-40%)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>ET_ID</th>\n",
       "      <th>COUNTRY</th>\n",
       "      <th>geometry</th>\n",
       "      <th>area_60</th>\n",
       "      <th>area_61</th>\n",
       "      <th>area_62</th>\n",
       "      <th>area_80</th>\n",
       "      <th>area_81</th>\n",
       "      <th>area_82</th>\n",
       "      <th>Area_H_3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>0.000000</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.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>280</td>\n",
       "      <td>Malta</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "      <td>0.000000</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.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>363</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "      <td>0.000000</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.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>412</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((23.95653 35.05738, 23.41935 35.13773...</td>\n",
       "      <td>0.000093</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.000093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>413</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((24.49271 34.97391, 23.95653 35.05738...</td>\n",
       "      <td>0.000000</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.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ET_ID COUNTRY                                           geometry   area_60  \\\n",
       "0    249   Spain  POLYGON ((-2.18083 34.85145, -2.71695 34.77839...  0.000000   \n",
       "1    280   Malta  POLYGON ((14.68659 35.53849, 14.14122 35.56449...  0.000000   \n",
       "2    363   Spain  POLYGON ((-2.79499 35.22702, -3.33331 35.15029...  0.000000   \n",
       "3    412  Greece  POLYGON ((23.95653 35.05738, 23.41935 35.13773...  0.000093   \n",
       "4    413  Greece  POLYGON ((24.49271 34.97391, 23.95653 35.05738...  0.000000   \n",
       "\n",
       "   area_61  area_62  area_80  area_81  area_82  Area_H_3  \n",
       "0      0.0      0.0      0.0      0.0      0.0  0.000000  \n",
       "1      0.0      0.0      0.0      0.0      0.0  0.000000  \n",
       "2      0.0      0.0      0.0      0.0      0.0  0.000000  \n",
       "3      0.0      0.0      0.0      0.0      0.0  0.000093  \n",
       "4      0.0      0.0      0.0      0.0      0.0  0.000000  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Cargar el grid nuevamente\n",
    "Grid_50 = gpd.read_file(r'Grid50/Grid_50Km_Europe_WGS84.shp')\n",
    "\n",
    "\n",
    "if Grid_50.crs != raster_crs:\n",
    "    Grid_50 = Grid_50.to_crs(raster_crs)\n",
    "\n",
    "extraccion_calculo_area(60)\n",
    "extraccion_calculo_area(61)\n",
    "extraccion_calculo_area(62)\n",
    "extraccion_calculo_area(80)\n",
    "extraccion_calculo_area(81)\n",
    "extraccion_calculo_area(82)\n",
    "\n",
    "area_columns = [col for col in Grid_50.columns if col.startswith('area_')]\n",
    "\n",
    "Grid_50['Area_H_3'] = Grid_50[area_columns].sum(axis=1)\n",
    "\n",
    "Grid_50.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Guardar el resultado en un nuevo shapefile\n",
    "#Grid_50.to_file('Data/GLOBIO/2010/Grid_H_3.shp')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>ET_ID</th>\n",
       "      <th>COUNTRY</th>\n",
       "      <th>geometry</th>\n",
       "      <th>Area_H_1</th>\n",
       "      <th>Area_H_2</th>\n",
       "      <th>Area_H_3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>0.087106</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>280</td>\n",
       "      <td>Malta</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "      <td>0.224745</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>363</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "      <td>0.207083</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>412</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((23.95653 35.05738, 23.41935 35.13773...</td>\n",
       "      <td>0.113843</td>\n",
       "      <td>0.004977</td>\n",
       "      <td>0.000093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>413</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((24.49271 34.97391, 23.95653 35.05738...</td>\n",
       "      <td>0.123387</td>\n",
       "      <td>0.000378</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3101</th>\n",
       "      <td>9369</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((26.92771 70.58708, 25.63446 70.69412...</td>\n",
       "      <td>0.446103</td>\n",
       "      <td>0.003866</td>\n",
       "      <td>0.005046</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3102</th>\n",
       "      <td>9370</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((28.20775 70.47181, 26.92771 70.58708...</td>\n",
       "      <td>0.193171</td>\n",
       "      <td>0.018920</td>\n",
       "      <td>0.017955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3103</th>\n",
       "      <td>9371</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((29.47384 70.34844, 28.20775 70.47181...</td>\n",
       "      <td>0.136335</td>\n",
       "      <td>0.008858</td>\n",
       "      <td>0.013248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3104</th>\n",
       "      <td>9372</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((30.72534 70.21713, 29.47384 70.34844...</td>\n",
       "      <td>0.218410</td>\n",
       "      <td>0.003511</td>\n",
       "      <td>0.003403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3105</th>\n",
       "      <td>9485</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((28.60702 70.90647, 27.30206 71.02446...</td>\n",
       "      <td>0.530625</td>\n",
       "      <td>0.002639</td>\n",
       "      <td>0.000602</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3106 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      ET_ID COUNTRY                                           geometry  \\\n",
       "0       249   Spain  POLYGON ((-2.18083 34.85145, -2.71695 34.77839...   \n",
       "1       280   Malta  POLYGON ((14.68659 35.53849, 14.14122 35.56449...   \n",
       "2       363   Spain  POLYGON ((-2.79499 35.22702, -3.33331 35.15029...   \n",
       "3       412  Greece  POLYGON ((23.95653 35.05738, 23.41935 35.13773...   \n",
       "4       413  Greece  POLYGON ((24.49271 34.97391, 23.95653 35.05738...   \n",
       "...     ...     ...                                                ...   \n",
       "3101   9369  Norway  POLYGON ((26.92771 70.58708, 25.63446 70.69412...   \n",
       "3102   9370  Norway  POLYGON ((28.20775 70.47181, 26.92771 70.58708...   \n",
       "3103   9371  Norway  POLYGON ((29.47384 70.34844, 28.20775 70.47181...   \n",
       "3104   9372  Norway  POLYGON ((30.72534 70.21713, 29.47384 70.34844...   \n",
       "3105   9485  Norway  POLYGON ((28.60702 70.90647, 27.30206 71.02446...   \n",
       "\n",
       "      Area_H_1  Area_H_2  Area_H_3  \n",
       "0     0.087106  0.000000  0.000000  \n",
       "1     0.224745  0.000000  0.000000  \n",
       "2     0.207083  0.000000  0.000000  \n",
       "3     0.113843  0.004977  0.000093  \n",
       "4     0.123387  0.000378  0.000000  \n",
       "...        ...       ...       ...  \n",
       "3101  0.446103  0.003866  0.005046  \n",
       "3102  0.193171  0.018920  0.017955  \n",
       "3103  0.136335  0.008858  0.013248  \n",
       "3104  0.218410  0.003511  0.003403  \n",
       "3105  0.530625  0.002639  0.000602  \n",
       "\n",
       "[3106 rows x 6 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Columnas de interes\n",
    "Grid_50_s = Grid_50[['ET_ID', 'Area_H_3']]\n",
    "\n",
    "#  Unir los DataFrames usando el campo ET_ID como clave\n",
    "Grid_Habitats = pd.merge(Grid_Habitats, Grid_50_s, on='ET_ID', how='left')\n",
    "Grid_Habitats"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Habitat 4 - Matorrales y Pastizales\n",
    "\n",
    "El habitat 4, corresponde con matorrales y pastizales, por lo que se incluyen las siguiente tipologias disponible en GLOBIO:\n",
    "\n",
    " - 10: Tierras de cultivo\n",
    " - 13: Mosaico de tierras de cultivo (>50%) / vegetación natural (cubierta herbácea arbustiva) (<50%)\n",
    " - 14: Vegetación natural en mosaico (cubierta herbácea arbustiva)\n",
    " - 120: Matorrales\n",
    " - 121: Matorrales perennes\n",
    " - 122: Matorrales caducifolios\n",
    " - 130: Pastizales\n",
    " - 150: Vegetación dispersa (árboles, arbustos, cobertura herbácea) (<15%)\n",
    " - 152: Arbustos dispersos (<15%)\n",
    " - 153: Cobertura herbácea dispersa (<15%)\n",
    " - 110: Mosaico de cobertura herbácea (>50%) / árboles y arbustos (<50%)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>ET_ID</th>\n",
       "      <th>COUNTRY</th>\n",
       "      <th>geometry</th>\n",
       "      <th>area_10</th>\n",
       "      <th>area_13</th>\n",
       "      <th>area_14</th>\n",
       "      <th>area_120</th>\n",
       "      <th>area_121</th>\n",
       "      <th>area_122</th>\n",
       "      <th>area_130</th>\n",
       "      <th>area_150</th>\n",
       "      <th>area_152</th>\n",
       "      <th>area_153</th>\n",
       "      <th>area_110</th>\n",
       "      <th>Area_H_4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>0.083796</td>\n",
       "      <td>0.005972</td>\n",
       "      <td>0.003295</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.093063</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>280</td>\n",
       "      <td>Malta</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "      <td>0.010069</td>\n",
       "      <td>0.002755</td>\n",
       "      <td>0.000571</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000008</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000347</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.013850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>363</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "      <td>0.009568</td>\n",
       "      <td>0.005957</td>\n",
       "      <td>0.009769</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.025293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>412</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((23.95653 35.05738, 23.41935 35.13773...</td>\n",
       "      <td>0.038958</td>\n",
       "      <td>0.000525</td>\n",
       "      <td>0.001736</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.041219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>413</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((24.49271 34.97391, 23.95653 35.05738...</td>\n",
       "      <td>0.046821</td>\n",
       "      <td>0.001559</td>\n",
       "      <td>0.002554</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000015</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.050949</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ET_ID COUNTRY                                           geometry   area_10  \\\n",
       "0    249   Spain  POLYGON ((-2.18083 34.85145, -2.71695 34.77839...  0.083796   \n",
       "1    280   Malta  POLYGON ((14.68659 35.53849, 14.14122 35.56449...  0.010069   \n",
       "2    363   Spain  POLYGON ((-2.79499 35.22702, -3.33331 35.15029...  0.009568   \n",
       "3    412  Greece  POLYGON ((23.95653 35.05738, 23.41935 35.13773...  0.038958   \n",
       "4    413  Greece  POLYGON ((24.49271 34.97391, 23.95653 35.05738...  0.046821   \n",
       "\n",
       "    area_13   area_14  area_120  area_121  area_122  area_130  area_150  \\\n",
       "0  0.005972  0.003295    0.0000       0.0  0.000000       0.0  0.000000   \n",
       "1  0.002755  0.000571    0.0001       0.0  0.000008       0.0  0.000347   \n",
       "2  0.005957  0.009769    0.0000       0.0  0.000000       0.0  0.000000   \n",
       "3  0.000525  0.001736    0.0000       0.0  0.000000       0.0  0.000000   \n",
       "4  0.001559  0.002554    0.0000       0.0  0.000000       0.0  0.000015   \n",
       "\n",
       "   area_152  area_153  area_110  Area_H_4  \n",
       "0       0.0       0.0       0.0  0.093063  \n",
       "1       0.0       0.0       0.0  0.013850  \n",
       "2       0.0       0.0       0.0  0.025293  \n",
       "3       0.0       0.0       0.0  0.041219  \n",
       "4       0.0       0.0       0.0  0.050949  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Grid_50 = gpd.read_file(r'Grid50/Grid_50Km_Europe_WGS84.shp')\n",
    "\n",
    "if Grid_50.crs != raster_crs:\n",
    "    Grid_50 = Grid_50.to_crs(raster_crs)\n",
    "\n",
    "extraccion_calculo_area(10)\n",
    "extraccion_calculo_area(13)\n",
    "extraccion_calculo_area(14)\n",
    "extraccion_calculo_area(120)\n",
    "extraccion_calculo_area(121)\n",
    "extraccion_calculo_area(122)\n",
    "extraccion_calculo_area(130)\n",
    "extraccion_calculo_area(150)\n",
    "extraccion_calculo_area(152)\n",
    "extraccion_calculo_area(153)\n",
    "extraccion_calculo_area(110)\n",
    "\n",
    "area_columns = [col for col in Grid_50.columns if col.startswith('area_')]\n",
    "\n",
    "Grid_50['Area_H_4'] = Grid_50[area_columns].sum(axis=1)\n",
    "\n",
    "Grid_50.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Guardar el resultado en un nuevo shapefile\n",
    "#Grid_50.to_file('Data/GLOBIO/2010/Grid_H_4.shp')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>ET_ID</th>\n",
       "      <th>COUNTRY</th>\n",
       "      <th>geometry</th>\n",
       "      <th>Area_H_1</th>\n",
       "      <th>Area_H_2</th>\n",
       "      <th>Area_H_3</th>\n",
       "      <th>Area_H_4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>0.087106</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.093063</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>280</td>\n",
       "      <td>Malta</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "      <td>0.224745</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.013850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>363</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "      <td>0.207083</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.025293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>412</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((23.95653 35.05738, 23.41935 35.13773...</td>\n",
       "      <td>0.113843</td>\n",
       "      <td>0.004977</td>\n",
       "      <td>0.000093</td>\n",
       "      <td>0.041219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>413</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((24.49271 34.97391, 23.95653 35.05738...</td>\n",
       "      <td>0.123387</td>\n",
       "      <td>0.000378</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3101</th>\n",
       "      <td>9369</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((26.92771 70.58708, 25.63446 70.69412...</td>\n",
       "      <td>0.446103</td>\n",
       "      <td>0.003866</td>\n",
       "      <td>0.005046</td>\n",
       "      <td>0.116489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3102</th>\n",
       "      <td>9370</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((28.20775 70.47181, 26.92771 70.58708...</td>\n",
       "      <td>0.193171</td>\n",
       "      <td>0.018920</td>\n",
       "      <td>0.017955</td>\n",
       "      <td>0.273264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3103</th>\n",
       "      <td>9371</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((29.47384 70.34844, 28.20775 70.47181...</td>\n",
       "      <td>0.136335</td>\n",
       "      <td>0.008858</td>\n",
       "      <td>0.013248</td>\n",
       "      <td>0.275471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3104</th>\n",
       "      <td>9372</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((30.72534 70.21713, 29.47384 70.34844...</td>\n",
       "      <td>0.218410</td>\n",
       "      <td>0.003511</td>\n",
       "      <td>0.003403</td>\n",
       "      <td>0.234113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3105</th>\n",
       "      <td>9485</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((28.60702 70.90647, 27.30206 71.02446...</td>\n",
       "      <td>0.530625</td>\n",
       "      <td>0.002639</td>\n",
       "      <td>0.000602</td>\n",
       "      <td>0.053326</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3106 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      ET_ID COUNTRY                                           geometry  \\\n",
       "0       249   Spain  POLYGON ((-2.18083 34.85145, -2.71695 34.77839...   \n",
       "1       280   Malta  POLYGON ((14.68659 35.53849, 14.14122 35.56449...   \n",
       "2       363   Spain  POLYGON ((-2.79499 35.22702, -3.33331 35.15029...   \n",
       "3       412  Greece  POLYGON ((23.95653 35.05738, 23.41935 35.13773...   \n",
       "4       413  Greece  POLYGON ((24.49271 34.97391, 23.95653 35.05738...   \n",
       "...     ...     ...                                                ...   \n",
       "3101   9369  Norway  POLYGON ((26.92771 70.58708, 25.63446 70.69412...   \n",
       "3102   9370  Norway  POLYGON ((28.20775 70.47181, 26.92771 70.58708...   \n",
       "3103   9371  Norway  POLYGON ((29.47384 70.34844, 28.20775 70.47181...   \n",
       "3104   9372  Norway  POLYGON ((30.72534 70.21713, 29.47384 70.34844...   \n",
       "3105   9485  Norway  POLYGON ((28.60702 70.90647, 27.30206 71.02446...   \n",
       "\n",
       "      Area_H_1  Area_H_2  Area_H_3  Area_H_4  \n",
       "0     0.087106  0.000000  0.000000  0.093063  \n",
       "1     0.224745  0.000000  0.000000  0.013850  \n",
       "2     0.207083  0.000000  0.000000  0.025293  \n",
       "3     0.113843  0.004977  0.000093  0.041219  \n",
       "4     0.123387  0.000378  0.000000  0.050949  \n",
       "...        ...       ...       ...       ...  \n",
       "3101  0.446103  0.003866  0.005046  0.116489  \n",
       "3102  0.193171  0.018920  0.017955  0.273264  \n",
       "3103  0.136335  0.008858  0.013248  0.275471  \n",
       "3104  0.218410  0.003511  0.003403  0.234113  \n",
       "3105  0.530625  0.002639  0.000602  0.053326  \n",
       "\n",
       "[3106 rows x 7 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Columnas de interes\n",
    "Grid_50_s = Grid_50[['ET_ID', 'Area_H_4']]\n",
    "\n",
    "#  Unir los DataFrames usando el campo ET_ID como clave\n",
    "Grid_Habitats = pd.merge(Grid_Habitats, Grid_50_s, on='ET_ID', how='left')\n",
    "Grid_Habitats"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Guardar el resultado en un nuevo shapefile\n",
    "#Grid_Habitats.to_file('Data/GLOBIO/2010/Grid_Habitats.shp')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Cerrar el dataset raster\n",
    "src.close()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# % DE ÁREA DISPONIBLE POR CUADRÍCULA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\molic\\AppData\\Local\\Temp\\ipykernel_22232\\850118656.py:2: UserWarning: Geometry is in a geographic CRS. Results from 'area' are likely incorrect. Use 'GeoSeries.to_crs()' to re-project geometries to a projected CRS before this operation.\n",
      "\n",
      "  Grid_Habitats['Area_grid'] = Grid_Habitats.geometry.area #en m2\n"
     ]
    },
    {
     "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>ET_ID</th>\n",
       "      <th>COUNTRY</th>\n",
       "      <th>geometry</th>\n",
       "      <th>Area_H_1</th>\n",
       "      <th>Area_H_2</th>\n",
       "      <th>Area_H_3</th>\n",
       "      <th>Area_H_4</th>\n",
       "      <th>Area_grid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>0.087106</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.093063</td>\n",
       "      <td>0.246970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>280</td>\n",
       "      <td>Malta</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "      <td>0.224745</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.013850</td>\n",
       "      <td>0.249205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>363</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "      <td>0.207083</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.025293</td>\n",
       "      <td>0.248088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>412</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((23.95653 35.05738, 23.41935 35.13773...</td>\n",
       "      <td>0.113843</td>\n",
       "      <td>0.004977</td>\n",
       "      <td>0.000093</td>\n",
       "      <td>0.041219</td>\n",
       "      <td>0.247813</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>413</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((24.49271 34.97391, 23.95653 35.05738...</td>\n",
       "      <td>0.123387</td>\n",
       "      <td>0.000378</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050949</td>\n",
       "      <td>0.247566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3101</th>\n",
       "      <td>9369</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((26.92771 70.58708, 25.63446 70.69412...</td>\n",
       "      <td>0.446103</td>\n",
       "      <td>0.003866</td>\n",
       "      <td>0.005046</td>\n",
       "      <td>0.116489</td>\n",
       "      <td>0.612105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3102</th>\n",
       "      <td>9370</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((28.20775 70.47181, 26.92771 70.58708...</td>\n",
       "      <td>0.193171</td>\n",
       "      <td>0.018920</td>\n",
       "      <td>0.017955</td>\n",
       "      <td>0.273264</td>\n",
       "      <td>0.608670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3103</th>\n",
       "      <td>9371</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((29.47384 70.34844, 28.20775 70.47181...</td>\n",
       "      <td>0.136335</td>\n",
       "      <td>0.008858</td>\n",
       "      <td>0.013248</td>\n",
       "      <td>0.275471</td>\n",
       "      <td>0.605030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3104</th>\n",
       "      <td>9372</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((30.72534 70.21713, 29.47384 70.34844...</td>\n",
       "      <td>0.218410</td>\n",
       "      <td>0.003511</td>\n",
       "      <td>0.003403</td>\n",
       "      <td>0.234113</td>\n",
       "      <td>0.601196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3105</th>\n",
       "      <td>9485</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((28.60702 70.90647, 27.30206 71.02446...</td>\n",
       "      <td>0.530625</td>\n",
       "      <td>0.002639</td>\n",
       "      <td>0.000602</td>\n",
       "      <td>0.053326</td>\n",
       "      <td>0.622198</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3106 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      ET_ID COUNTRY                                           geometry  \\\n",
       "0       249   Spain  POLYGON ((-2.18083 34.85145, -2.71695 34.77839...   \n",
       "1       280   Malta  POLYGON ((14.68659 35.53849, 14.14122 35.56449...   \n",
       "2       363   Spain  POLYGON ((-2.79499 35.22702, -3.33331 35.15029...   \n",
       "3       412  Greece  POLYGON ((23.95653 35.05738, 23.41935 35.13773...   \n",
       "4       413  Greece  POLYGON ((24.49271 34.97391, 23.95653 35.05738...   \n",
       "...     ...     ...                                                ...   \n",
       "3101   9369  Norway  POLYGON ((26.92771 70.58708, 25.63446 70.69412...   \n",
       "3102   9370  Norway  POLYGON ((28.20775 70.47181, 26.92771 70.58708...   \n",
       "3103   9371  Norway  POLYGON ((29.47384 70.34844, 28.20775 70.47181...   \n",
       "3104   9372  Norway  POLYGON ((30.72534 70.21713, 29.47384 70.34844...   \n",
       "3105   9485  Norway  POLYGON ((28.60702 70.90647, 27.30206 71.02446...   \n",
       "\n",
       "      Area_H_1  Area_H_2  Area_H_3  Area_H_4  Area_grid  \n",
       "0     0.087106  0.000000  0.000000  0.093063   0.246970  \n",
       "1     0.224745  0.000000  0.000000  0.013850   0.249205  \n",
       "2     0.207083  0.000000  0.000000  0.025293   0.248088  \n",
       "3     0.113843  0.004977  0.000093  0.041219   0.247813  \n",
       "4     0.123387  0.000378  0.000000  0.050949   0.247566  \n",
       "...        ...       ...       ...       ...        ...  \n",
       "3101  0.446103  0.003866  0.005046  0.116489   0.612105  \n",
       "3102  0.193171  0.018920  0.017955  0.273264   0.608670  \n",
       "3103  0.136335  0.008858  0.013248  0.275471   0.605030  \n",
       "3104  0.218410  0.003511  0.003403  0.234113   0.601196  \n",
       "3105  0.530625  0.002639  0.000602  0.053326   0.622198  \n",
       "\n",
       "[3106 rows x 8 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Calculo del area para cada cuadrícula en km²\n",
    "Grid_Habitats['Area_grid'] = Grid_Habitats.geometry.area #en m2\n",
    "Grid_Habitats"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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>ET_ID</th>\n",
       "      <th>COUNTRY</th>\n",
       "      <th>geometry</th>\n",
       "      <th>Area_H_1</th>\n",
       "      <th>Area_H_2</th>\n",
       "      <th>Area_H_3</th>\n",
       "      <th>Area_H_4</th>\n",
       "      <th>Area_grid</th>\n",
       "      <th>%_H_1</th>\n",
       "      <th>%_H_2</th>\n",
       "      <th>%_H_3</th>\n",
       "      <th>%_H_4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>0.087106</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.093063</td>\n",
       "      <td>0.246970</td>\n",
       "      <td>35.270045</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>37.681992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>280</td>\n",
       "      <td>Malta</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "      <td>0.224745</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.013850</td>\n",
       "      <td>0.249205</td>\n",
       "      <td>90.184792</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.557788</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>363</td>\n",
       "      <td>Spain</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "      <td>0.207083</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.025293</td>\n",
       "      <td>0.248088</td>\n",
       "      <td>83.471585</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.195240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>412</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((23.95653 35.05738, 23.41935 35.13773...</td>\n",
       "      <td>0.113843</td>\n",
       "      <td>0.004977</td>\n",
       "      <td>0.000093</td>\n",
       "      <td>0.041219</td>\n",
       "      <td>0.247813</td>\n",
       "      <td>45.938994</td>\n",
       "      <td>2.008313</td>\n",
       "      <td>0.037364</td>\n",
       "      <td>16.633191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>413</td>\n",
       "      <td>Greece</td>\n",
       "      <td>POLYGON ((24.49271 34.97391, 23.95653 35.05738...</td>\n",
       "      <td>0.123387</td>\n",
       "      <td>0.000378</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050949</td>\n",
       "      <td>0.247566</td>\n",
       "      <td>49.840265</td>\n",
       "      <td>0.152722</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>20.580031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3101</th>\n",
       "      <td>9369</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((26.92771 70.58708, 25.63446 70.69412...</td>\n",
       "      <td>0.446103</td>\n",
       "      <td>0.003866</td>\n",
       "      <td>0.005046</td>\n",
       "      <td>0.116489</td>\n",
       "      <td>0.612105</td>\n",
       "      <td>72.880249</td>\n",
       "      <td>0.631549</td>\n",
       "      <td>0.824417</td>\n",
       "      <td>19.030928</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3102</th>\n",
       "      <td>9370</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((28.20775 70.47181, 26.92771 70.58708...</td>\n",
       "      <td>0.193171</td>\n",
       "      <td>0.018920</td>\n",
       "      <td>0.017955</td>\n",
       "      <td>0.273264</td>\n",
       "      <td>0.608670</td>\n",
       "      <td>31.736606</td>\n",
       "      <td>3.108375</td>\n",
       "      <td>2.949913</td>\n",
       "      <td>44.895223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3103</th>\n",
       "      <td>9371</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((29.47384 70.34844, 28.20775 70.47181...</td>\n",
       "      <td>0.136335</td>\n",
       "      <td>0.008858</td>\n",
       "      <td>0.013248</td>\n",
       "      <td>0.275471</td>\n",
       "      <td>0.605030</td>\n",
       "      <td>22.533577</td>\n",
       "      <td>1.464064</td>\n",
       "      <td>2.189719</td>\n",
       "      <td>45.530093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3104</th>\n",
       "      <td>9372</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((30.72534 70.21713, 29.47384 70.34844...</td>\n",
       "      <td>0.218410</td>\n",
       "      <td>0.003511</td>\n",
       "      <td>0.003403</td>\n",
       "      <td>0.234113</td>\n",
       "      <td>0.601196</td>\n",
       "      <td>36.329307</td>\n",
       "      <td>0.583969</td>\n",
       "      <td>0.566001</td>\n",
       "      <td>38.941126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3105</th>\n",
       "      <td>9485</td>\n",
       "      <td>Norway</td>\n",
       "      <td>POLYGON ((28.60702 70.90647, 27.30206 71.02446...</td>\n",
       "      <td>0.530625</td>\n",
       "      <td>0.002639</td>\n",
       "      <td>0.000602</td>\n",
       "      <td>0.053326</td>\n",
       "      <td>0.622198</td>\n",
       "      <td>85.282380</td>\n",
       "      <td>0.424124</td>\n",
       "      <td>0.096730</td>\n",
       "      <td>8.570526</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3106 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      ET_ID COUNTRY                                           geometry  \\\n",
       "0       249   Spain  POLYGON ((-2.18083 34.85145, -2.71695 34.77839...   \n",
       "1       280   Malta  POLYGON ((14.68659 35.53849, 14.14122 35.56449...   \n",
       "2       363   Spain  POLYGON ((-2.79499 35.22702, -3.33331 35.15029...   \n",
       "3       412  Greece  POLYGON ((23.95653 35.05738, 23.41935 35.13773...   \n",
       "4       413  Greece  POLYGON ((24.49271 34.97391, 23.95653 35.05738...   \n",
       "...     ...     ...                                                ...   \n",
       "3101   9369  Norway  POLYGON ((26.92771 70.58708, 25.63446 70.69412...   \n",
       "3102   9370  Norway  POLYGON ((28.20775 70.47181, 26.92771 70.58708...   \n",
       "3103   9371  Norway  POLYGON ((29.47384 70.34844, 28.20775 70.47181...   \n",
       "3104   9372  Norway  POLYGON ((30.72534 70.21713, 29.47384 70.34844...   \n",
       "3105   9485  Norway  POLYGON ((28.60702 70.90647, 27.30206 71.02446...   \n",
       "\n",
       "      Area_H_1  Area_H_2  Area_H_3  Area_H_4  Area_grid      %_H_1     %_H_2  \\\n",
       "0     0.087106  0.000000  0.000000  0.093063   0.246970  35.270045  0.000000   \n",
       "1     0.224745  0.000000  0.000000  0.013850   0.249205  90.184792  0.000000   \n",
       "2     0.207083  0.000000  0.000000  0.025293   0.248088  83.471585  0.000000   \n",
       "3     0.113843  0.004977  0.000093  0.041219   0.247813  45.938994  2.008313   \n",
       "4     0.123387  0.000378  0.000000  0.050949   0.247566  49.840265  0.152722   \n",
       "...        ...       ...       ...       ...        ...        ...       ...   \n",
       "3101  0.446103  0.003866  0.005046  0.116489   0.612105  72.880249  0.631549   \n",
       "3102  0.193171  0.018920  0.017955  0.273264   0.608670  31.736606  3.108375   \n",
       "3103  0.136335  0.008858  0.013248  0.275471   0.605030  22.533577  1.464064   \n",
       "3104  0.218410  0.003511  0.003403  0.234113   0.601196  36.329307  0.583969   \n",
       "3105  0.530625  0.002639  0.000602  0.053326   0.622198  85.282380  0.424124   \n",
       "\n",
       "         %_H_3      %_H_4  \n",
       "0     0.000000  37.681992  \n",
       "1     0.000000   5.557788  \n",
       "2     0.000000  10.195240  \n",
       "3     0.037364  16.633191  \n",
       "4     0.000000  20.580031  \n",
       "...        ...        ...  \n",
       "3101  0.824417  19.030928  \n",
       "3102  2.949913  44.895223  \n",
       "3103  2.189719  45.530093  \n",
       "3104  0.566001  38.941126  \n",
       "3105  0.096730   8.570526  \n",
       "\n",
       "[3106 rows x 12 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Calculo del porcentaje de habitat\n",
    "Grid_Habitats['%_H_1'] = (Grid_Habitats['Area_H_1']*100)/Grid_Habitats['Area_grid']\n",
    "Grid_Habitats['%_H_2'] = (Grid_Habitats['Area_H_2']*100)/Grid_Habitats['Area_grid']\n",
    "Grid_Habitats['%_H_3'] = (Grid_Habitats['Area_H_3']*100)/Grid_Habitats['Area_grid']\n",
    "Grid_Habitats['%_H_4'] = (Grid_Habitats['Area_H_4']*100)/Grid_Habitats['Area_grid']\n",
    "\n",
    "Grid_Habitats"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "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>ET_ID</th>\n",
       "      <th>geometry</th>\n",
       "      <th>%_H_1</th>\n",
       "      <th>%_H_2</th>\n",
       "      <th>%_H_3</th>\n",
       "      <th>%_H_4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>35.270045</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>37.681992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>280</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "      <td>90.184792</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.557788</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>363</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "      <td>83.471585</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.195240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>412</td>\n",
       "      <td>POLYGON ((23.95653 35.05738, 23.41935 35.13773...</td>\n",
       "      <td>45.938994</td>\n",
       "      <td>2.008313</td>\n",
       "      <td>0.037364</td>\n",
       "      <td>16.633191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>413</td>\n",
       "      <td>POLYGON ((24.49271 34.97391, 23.95653 35.05738...</td>\n",
       "      <td>49.840265</td>\n",
       "      <td>0.152722</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>20.580031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3101</th>\n",
       "      <td>9369</td>\n",
       "      <td>POLYGON ((26.92771 70.58708, 25.63446 70.69412...</td>\n",
       "      <td>72.880249</td>\n",
       "      <td>0.631549</td>\n",
       "      <td>0.824417</td>\n",
       "      <td>19.030928</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3102</th>\n",
       "      <td>9370</td>\n",
       "      <td>POLYGON ((28.20775 70.47181, 26.92771 70.58708...</td>\n",
       "      <td>31.736606</td>\n",
       "      <td>3.108375</td>\n",
       "      <td>2.949913</td>\n",
       "      <td>44.895223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3103</th>\n",
       "      <td>9371</td>\n",
       "      <td>POLYGON ((29.47384 70.34844, 28.20775 70.47181...</td>\n",
       "      <td>22.533577</td>\n",
       "      <td>1.464064</td>\n",
       "      <td>2.189719</td>\n",
       "      <td>45.530093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3104</th>\n",
       "      <td>9372</td>\n",
       "      <td>POLYGON ((30.72534 70.21713, 29.47384 70.34844...</td>\n",
       "      <td>36.329307</td>\n",
       "      <td>0.583969</td>\n",
       "      <td>0.566001</td>\n",
       "      <td>38.941126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3105</th>\n",
       "      <td>9485</td>\n",
       "      <td>POLYGON ((28.60702 70.90647, 27.30206 71.02446...</td>\n",
       "      <td>85.282380</td>\n",
       "      <td>0.424124</td>\n",
       "      <td>0.096730</td>\n",
       "      <td>8.570526</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3106 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      ET_ID                                           geometry      %_H_1  \\\n",
       "0       249  POLYGON ((-2.18083 34.85145, -2.71695 34.77839...  35.270045   \n",
       "1       280  POLYGON ((14.68659 35.53849, 14.14122 35.56449...  90.184792   \n",
       "2       363  POLYGON ((-2.79499 35.22702, -3.33331 35.15029...  83.471585   \n",
       "3       412  POLYGON ((23.95653 35.05738, 23.41935 35.13773...  45.938994   \n",
       "4       413  POLYGON ((24.49271 34.97391, 23.95653 35.05738...  49.840265   \n",
       "...     ...                                                ...        ...   \n",
       "3101   9369  POLYGON ((26.92771 70.58708, 25.63446 70.69412...  72.880249   \n",
       "3102   9370  POLYGON ((28.20775 70.47181, 26.92771 70.58708...  31.736606   \n",
       "3103   9371  POLYGON ((29.47384 70.34844, 28.20775 70.47181...  22.533577   \n",
       "3104   9372  POLYGON ((30.72534 70.21713, 29.47384 70.34844...  36.329307   \n",
       "3105   9485  POLYGON ((28.60702 70.90647, 27.30206 71.02446...  85.282380   \n",
       "\n",
       "         %_H_2     %_H_3      %_H_4  \n",
       "0     0.000000  0.000000  37.681992  \n",
       "1     0.000000  0.000000   5.557788  \n",
       "2     0.000000  0.000000  10.195240  \n",
       "3     2.008313  0.037364  16.633191  \n",
       "4     0.152722  0.000000  20.580031  \n",
       "...        ...       ...        ...  \n",
       "3101  0.631549  0.824417  19.030928  \n",
       "3102  3.108375  2.949913  44.895223  \n",
       "3103  1.464064  2.189719  45.530093  \n",
       "3104  0.583969  0.566001  38.941126  \n",
       "3105  0.424124  0.096730   8.570526  \n",
       "\n",
       "[3106 rows x 6 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Grid_Habitats_Variables = Grid_Habitats[['ET_ID', 'geometry', '%_H_1', '%_H_2', '%_H_3', '%_H_4']]\n",
    "Grid_Habitats_Variables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Guardar el resultado en un nuevo shapefile\n",
    "#Grid_Habitats_Variables.to_file('Data/GLOBIO/2010/Grid_Habitats_Variables.shp')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# UNION CON VARIABLES CLIMÁTICAS"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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>ET_ID</th>\n",
       "      <th>%_H_1</th>\n",
       "      <th>%_H_2</th>\n",
       "      <th>%_H_3</th>\n",
       "      <th>%_H_4</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>35.270045</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>37.681992</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>280</td>\n",
       "      <td>90.184792</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.557788</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>363</td>\n",
       "      <td>83.471585</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.195240</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>412</td>\n",
       "      <td>45.938994</td>\n",
       "      <td>2.008313</td>\n",
       "      <td>0.037364</td>\n",
       "      <td>16.633191</td>\n",
       "      <td>POLYGON ((23.95653 35.05738, 23.41935 35.13773...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>413</td>\n",
       "      <td>49.840265</td>\n",
       "      <td>0.152722</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>20.580031</td>\n",
       "      <td>POLYGON ((24.49271 34.97391, 23.95653 35.05738...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3101</th>\n",
       "      <td>9369</td>\n",
       "      <td>72.880249</td>\n",
       "      <td>0.631549</td>\n",
       "      <td>0.824417</td>\n",
       "      <td>19.030928</td>\n",
       "      <td>POLYGON ((26.92771 70.58708, 25.63446 70.69412...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3102</th>\n",
       "      <td>9370</td>\n",
       "      <td>31.736606</td>\n",
       "      <td>3.108375</td>\n",
       "      <td>2.949913</td>\n",
       "      <td>44.895223</td>\n",
       "      <td>POLYGON ((28.20775 70.47181, 26.92771 70.58708...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3103</th>\n",
       "      <td>9371</td>\n",
       "      <td>22.533577</td>\n",
       "      <td>1.464064</td>\n",
       "      <td>2.189719</td>\n",
       "      <td>45.530093</td>\n",
       "      <td>POLYGON ((29.47384 70.34844, 28.20775 70.47181...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3104</th>\n",
       "      <td>9372</td>\n",
       "      <td>36.329307</td>\n",
       "      <td>0.583969</td>\n",
       "      <td>0.566001</td>\n",
       "      <td>38.941126</td>\n",
       "      <td>POLYGON ((30.72534 70.21713, 29.47384 70.34844...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3105</th>\n",
       "      <td>9485</td>\n",
       "      <td>85.282380</td>\n",
       "      <td>0.424124</td>\n",
       "      <td>0.096730</td>\n",
       "      <td>8.570526</td>\n",
       "      <td>POLYGON ((28.60702 70.90647, 27.30206 71.02446...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3106 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      ET_ID      %_H_1     %_H_2     %_H_3      %_H_4  \\\n",
       "0       249  35.270045  0.000000  0.000000  37.681992   \n",
       "1       280  90.184792  0.000000  0.000000   5.557788   \n",
       "2       363  83.471585  0.000000  0.000000  10.195240   \n",
       "3       412  45.938994  2.008313  0.037364  16.633191   \n",
       "4       413  49.840265  0.152722  0.000000  20.580031   \n",
       "...     ...        ...       ...       ...        ...   \n",
       "3101   9369  72.880249  0.631549  0.824417  19.030928   \n",
       "3102   9370  31.736606  3.108375  2.949913  44.895223   \n",
       "3103   9371  22.533577  1.464064  2.189719  45.530093   \n",
       "3104   9372  36.329307  0.583969  0.566001  38.941126   \n",
       "3105   9485  85.282380  0.424124  0.096730   8.570526   \n",
       "\n",
       "                                               geometry  \n",
       "0     POLYGON ((-2.18083 34.85145, -2.71695 34.77839...  \n",
       "1     POLYGON ((14.68659 35.53849, 14.14122 35.56449...  \n",
       "2     POLYGON ((-2.79499 35.22702, -3.33331 35.15029...  \n",
       "3     POLYGON ((23.95653 35.05738, 23.41935 35.13773...  \n",
       "4     POLYGON ((24.49271 34.97391, 23.95653 35.05738...  \n",
       "...                                                 ...  \n",
       "3101  POLYGON ((26.92771 70.58708, 25.63446 70.69412...  \n",
       "3102  POLYGON ((28.20775 70.47181, 26.92771 70.58708...  \n",
       "3103  POLYGON ((29.47384 70.34844, 28.20775 70.47181...  \n",
       "3104  POLYGON ((30.72534 70.21713, 29.47384 70.34844...  \n",
       "3105  POLYGON ((28.60702 70.90647, 27.30206 71.02446...  \n",
       "\n",
       "[3106 rows x 6 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Cargar el grid\n",
    "#Grid_Habitats_Variables = gpd.read_file(r'Data/GLOBIO/2010/Grid_Habitats_Variables.shp')\n",
    "Grid_Habitats_Variables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_01.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_02.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_03.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_04.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_05.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_06.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_07.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_08.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_09.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_10.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_11.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_12.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_13.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_14.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_15.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_16.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_17.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_18.shp',\n",
       " 'C:/Users/molic/Desktop/TFM_V1/Chelsa_bio/Estadistica_Zona\\\\Bio_19.shp']"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import glob\n",
    "import os\n",
    "\n",
    "directorio = 'Data/CHELSA/Estadistica_Zona' \n",
    "archivos_shp = glob.glob(directorio + '/Bio_*.shp') \n",
    "archivos_shp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Cargar cada archivo shapefile y asignarlo a una variable con el nombre del archivo\n",
    "for shp in archivos_shp:\n",
    "    # Obtener el nombre base del archivo sin la extensión\n",
    "    file_name = os.path.splitext(os.path.basename(shp))[0]\n",
    "    \n",
    "    # Cargar el shapefile en un GeoDataFrame\n",
    "    gdf = gpd.read_file(shp)\n",
    "    \n",
    "    # Asignar el GeoDataFrame a una variable con el nombre del archivo\n",
    "    globals()[file_name] = gdf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "       ET_ID  Bio_14_mea                                           geometry\n",
      "0      249.0      1.8524  POLYGON ((-2.18083 34.85145, -2.71695 34.77839...\n",
      "1      280.0      0.2310  POLYGON ((14.68659 35.53849, 14.14122 35.56449...\n",
      "2      363.0      1.0697  POLYGON ((-2.79499 35.22702, -3.33331 35.15029...\n",
      "3      412.0      0.9438  POLYGON ((23.95653 35.05738, 23.41935 35.13773...\n",
      "4      413.0      1.3217  POLYGON ((24.49271 34.97391, 23.95653 35.05738...\n",
      "...      ...         ...                                                ...\n",
      "3101  9369.0     47.8207  POLYGON ((26.92771 70.58708, 25.63446 70.69412...\n",
      "3102  9370.0     56.8986  POLYGON ((28.20775 70.47181, 26.92771 70.58708...\n",
      "3103  9371.0     54.4348  POLYGON ((29.47384 70.34844, 28.20775 70.47181...\n",
      "3104  9372.0     50.6536  POLYGON ((30.72534 70.21713, 29.47384 70.34844...\n",
      "3105  9485.0     45.2222  POLYGON ((28.60702 70.90647, 27.30206 71.02446...\n",
      "\n",
      "[3106 rows x 3 columns]\n"
     ]
    }
   ],
   "source": [
    "print(Bio_14)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Guardar el resultado en un nuevo shapefile\n",
    "Bio_01 = Bio_01[['ET_ID', 'Bio_01_mea']]\n",
    "Bio_02 = Bio_02[['ET_ID', 'Bio_02_mea']]\n",
    "Bio_03 = Bio_03[['ET_ID', 'Bio_03_mea']]\n",
    "Bio_04 = Bio_04[['ET_ID', 'Bio_04_mea']]\n",
    "Bio_05 = Bio_05[['ET_ID', 'Bio_05_mea']]\n",
    "Bio_06 = Bio_06[['ET_ID', 'Bio_06_mea']]\n",
    "Bio_07 = Bio_07[['ET_ID', 'Bio_07_mea']]\n",
    "Bio_08 = Bio_08[['ET_ID', 'Bio_08_mea']]\n",
    "Bio_09 = Bio_09[['ET_ID', 'Bio_09_mea']]\n",
    "Bio_10 = Bio_10[['ET_ID', 'Bio_10_mea']]\n",
    "Bio_11 = Bio_11[['ET_ID', 'Bio_11_mea']]\n",
    "Bio_12 = Bio_12[['ET_ID', 'Bio_12_mea']]\n",
    "Bio_13 = Bio_13[['ET_ID', 'Bio_13_mea']]\n",
    "Bio_14 = Bio_14[['ET_ID', 'Bio_14_mea']]\n",
    "Bio_15 = Bio_15[['ET_ID', 'Bio_15_mea']]\n",
    "Bio_16 = Bio_16[['ET_ID', 'Bio_16_mea']]\n",
    "Bio_17 = Bio_17[['ET_ID', 'Bio_17_mea']]\n",
    "Bio_18 = Bio_18[['ET_ID', 'Bio_18_mea']]\n",
    "Bio_19 = Bio_19[['ET_ID', 'Bio_19_mea']]\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_names = ['Bio_01', 'Bio_02', 'Bio_03', 'Bio_04', 'Bio_05', 'Bio_06', 'Bio_07', 'Bio_08', 'Bio_09', 'Bio_10', 'Bio_11', 'Bio_12', 'Bio_13', 'Bio_14', 'Bio_15', 'Bio_16', 'Bio_17', 'Bio_18', 'Bio_19']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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>ET_ID</th>\n",
       "      <th>%_H_1</th>\n",
       "      <th>%_H_2</th>\n",
       "      <th>%_H_3</th>\n",
       "      <th>%_H_4</th>\n",
       "      <th>geometry</th>\n",
       "      <th>Bio_01_mea</th>\n",
       "      <th>Bio_02_mea</th>\n",
       "      <th>Bio_03_mea</th>\n",
       "      <th>Bio_04_mea</th>\n",
       "      <th>...</th>\n",
       "      <th>Bio_10_mea</th>\n",
       "      <th>Bio_11_mea</th>\n",
       "      <th>Bio_12_mea</th>\n",
       "      <th>Bio_13_mea</th>\n",
       "      <th>Bio_14_mea</th>\n",
       "      <th>Bio_15_mea</th>\n",
       "      <th>Bio_16_mea</th>\n",
       "      <th>Bio_17_mea</th>\n",
       "      <th>Bio_18_mea</th>\n",
       "      <th>Bio_19_mea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>35.270045</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>37.681992</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>18.254976</td>\n",
       "      <td>8.495586</td>\n",
       "      <td>0.368012</td>\n",
       "      <td>462.715716</td>\n",
       "      <td>...</td>\n",
       "      <td>24.509797</td>\n",
       "      <td>12.678282</td>\n",
       "      <td>345.210093</td>\n",
       "      <td>47.583666</td>\n",
       "      <td>1.8524</td>\n",
       "      <td>57.250155</td>\n",
       "      <td>135.057773</td>\n",
       "      <td>13.583357</td>\n",
       "      <td>22.131150</td>\n",
       "      <td>126.752235</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>249</td>\n",
       "      <td>35.270045</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>37.681992</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>18.254976</td>\n",
       "      <td>8.495586</td>\n",
       "      <td>0.368012</td>\n",
       "      <td>462.715716</td>\n",
       "      <td>...</td>\n",
       "      <td>24.509797</td>\n",
       "      <td>12.678282</td>\n",
       "      <td>345.210093</td>\n",
       "      <td>47.583666</td>\n",
       "      <td>1.8524</td>\n",
       "      <td>57.250155</td>\n",
       "      <td>135.057773</td>\n",
       "      <td>13.583357</td>\n",
       "      <td>22.131150</td>\n",
       "      <td>126.752235</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>280</td>\n",
       "      <td>90.184792</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.557788</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "      <td>19.165826</td>\n",
       "      <td>1.528587</td>\n",
       "      <td>0.110094</td>\n",
       "      <td>436.010840</td>\n",
       "      <td>...</td>\n",
       "      <td>25.079757</td>\n",
       "      <td>13.986250</td>\n",
       "      <td>510.006213</td>\n",
       "      <td>98.965952</td>\n",
       "      <td>0.2310</td>\n",
       "      <td>83.750042</td>\n",
       "      <td>278.948983</td>\n",
       "      <td>7.215380</td>\n",
       "      <td>52.409418</td>\n",
       "      <td>173.755754</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>363</td>\n",
       "      <td>83.471585</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.195240</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "      <td>18.462150</td>\n",
       "      <td>3.756775</td>\n",
       "      <td>0.238924</td>\n",
       "      <td>374.399104</td>\n",
       "      <td>...</td>\n",
       "      <td>23.658651</td>\n",
       "      <td>14.126988</td>\n",
       "      <td>379.820661</td>\n",
       "      <td>55.684323</td>\n",
       "      <td>1.0697</td>\n",
       "      <td>62.789642</td>\n",
       "      <td>159.041741</td>\n",
       "      <td>12.041937</td>\n",
       "      <td>20.850420</td>\n",
       "      <td>152.538774</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>363</td>\n",
       "      <td>83.471585</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.195240</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "      <td>18.462150</td>\n",
       "      <td>3.756775</td>\n",
       "      <td>0.238924</td>\n",
       "      <td>374.399104</td>\n",
       "      <td>...</td>\n",
       "      <td>23.658651</td>\n",
       "      <td>14.126988</td>\n",
       "      <td>379.820661</td>\n",
       "      <td>55.684323</td>\n",
       "      <td>1.0697</td>\n",
       "      <td>62.789642</td>\n",
       "      <td>159.041741</td>\n",
       "      <td>12.041937</td>\n",
       "      <td>20.850420</td>\n",
       "      <td>152.538774</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25703</th>\n",
       "      <td>9372</td>\n",
       "      <td>36.329307</td>\n",
       "      <td>0.583969</td>\n",
       "      <td>0.566001</td>\n",
       "      <td>38.941126</td>\n",
       "      <td>POLYGON ((30.72534 70.21713, 29.47384 70.34844...</td>\n",
       "      <td>0.627255</td>\n",
       "      <td>3.821428</td>\n",
       "      <td>0.183020</td>\n",
       "      <td>591.614208</td>\n",
       "      <td>...</td>\n",
       "      <td>8.576487</td>\n",
       "      <td>-6.381050</td>\n",
       "      <td>867.108894</td>\n",
       "      <td>100.286265</td>\n",
       "      <td>50.6536</td>\n",
       "      <td>21.261742</td>\n",
       "      <td>269.148897</td>\n",
       "      <td>164.141273</td>\n",
       "      <td>259.901421</td>\n",
       "      <td>205.447719</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25704</th>\n",
       "      <td>9485</td>\n",
       "      <td>85.282380</td>\n",
       "      <td>0.424124</td>\n",
       "      <td>0.096730</td>\n",
       "      <td>8.570526</td>\n",
       "      <td>POLYGON ((28.60702 70.90647, 27.30206 71.02446...</td>\n",
       "      <td>2.420992</td>\n",
       "      <td>2.626016</td>\n",
       "      <td>0.170077</td>\n",
       "      <td>442.528004</td>\n",
       "      <td>...</td>\n",
       "      <td>8.532202</td>\n",
       "      <td>-2.675670</td>\n",
       "      <td>820.016682</td>\n",
       "      <td>98.181465</td>\n",
       "      <td>45.2222</td>\n",
       "      <td>23.091894</td>\n",
       "      <td>255.333051</td>\n",
       "      <td>147.027669</td>\n",
       "      <td>186.234926</td>\n",
       "      <td>233.672052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25705</th>\n",
       "      <td>9485</td>\n",
       "      <td>85.282380</td>\n",
       "      <td>0.424124</td>\n",
       "      <td>0.096730</td>\n",
       "      <td>8.570526</td>\n",
       "      <td>POLYGON ((28.60702 70.90647, 27.30206 71.02446...</td>\n",
       "      <td>2.420992</td>\n",
       "      <td>2.626016</td>\n",
       "      <td>0.170077</td>\n",
       "      <td>442.528004</td>\n",
       "      <td>...</td>\n",
       "      <td>8.532202</td>\n",
       "      <td>-2.675670</td>\n",
       "      <td>820.016682</td>\n",
       "      <td>98.181465</td>\n",
       "      <td>45.2222</td>\n",
       "      <td>23.091894</td>\n",
       "      <td>255.333051</td>\n",
       "      <td>147.027669</td>\n",
       "      <td>186.234926</td>\n",
       "      <td>233.672052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25706</th>\n",
       "      <td>9485</td>\n",
       "      <td>85.282380</td>\n",
       "      <td>0.424124</td>\n",
       "      <td>0.096730</td>\n",
       "      <td>8.570526</td>\n",
       "      <td>POLYGON ((28.60702 70.90647, 27.30206 71.02446...</td>\n",
       "      <td>2.420992</td>\n",
       "      <td>2.626016</td>\n",
       "      <td>0.170077</td>\n",
       "      <td>442.528004</td>\n",
       "      <td>...</td>\n",
       "      <td>8.532202</td>\n",
       "      <td>-2.675670</td>\n",
       "      <td>820.016682</td>\n",
       "      <td>98.181465</td>\n",
       "      <td>45.2222</td>\n",
       "      <td>23.091894</td>\n",
       "      <td>255.333051</td>\n",
       "      <td>147.027669</td>\n",
       "      <td>186.234926</td>\n",
       "      <td>233.672052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25707</th>\n",
       "      <td>9485</td>\n",
       "      <td>85.282380</td>\n",
       "      <td>0.424124</td>\n",
       "      <td>0.096730</td>\n",
       "      <td>8.570526</td>\n",
       "      <td>POLYGON ((28.60702 70.90647, 27.30206 71.02446...</td>\n",
       "      <td>2.420992</td>\n",
       "      <td>2.626016</td>\n",
       "      <td>0.170077</td>\n",
       "      <td>442.528004</td>\n",
       "      <td>...</td>\n",
       "      <td>8.532202</td>\n",
       "      <td>-2.675670</td>\n",
       "      <td>820.016682</td>\n",
       "      <td>98.181465</td>\n",
       "      <td>45.2222</td>\n",
       "      <td>23.091894</td>\n",
       "      <td>255.333051</td>\n",
       "      <td>147.027669</td>\n",
       "      <td>186.234926</td>\n",
       "      <td>233.672052</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25708 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       ET_ID      %_H_1     %_H_2     %_H_3      %_H_4  \\\n",
       "0        249  35.270045  0.000000  0.000000  37.681992   \n",
       "1        249  35.270045  0.000000  0.000000  37.681992   \n",
       "2        280  90.184792  0.000000  0.000000   5.557788   \n",
       "3        363  83.471585  0.000000  0.000000  10.195240   \n",
       "4        363  83.471585  0.000000  0.000000  10.195240   \n",
       "...      ...        ...       ...       ...        ...   \n",
       "25703   9372  36.329307  0.583969  0.566001  38.941126   \n",
       "25704   9485  85.282380  0.424124  0.096730   8.570526   \n",
       "25705   9485  85.282380  0.424124  0.096730   8.570526   \n",
       "25706   9485  85.282380  0.424124  0.096730   8.570526   \n",
       "25707   9485  85.282380  0.424124  0.096730   8.570526   \n",
       "\n",
       "                                                geometry  Bio_01_mea  \\\n",
       "0      POLYGON ((-2.18083 34.85145, -2.71695 34.77839...   18.254976   \n",
       "1      POLYGON ((-2.18083 34.85145, -2.71695 34.77839...   18.254976   \n",
       "2      POLYGON ((14.68659 35.53849, 14.14122 35.56449...   19.165826   \n",
       "3      POLYGON ((-2.79499 35.22702, -3.33331 35.15029...   18.462150   \n",
       "4      POLYGON ((-2.79499 35.22702, -3.33331 35.15029...   18.462150   \n",
       "...                                                  ...         ...   \n",
       "25703  POLYGON ((30.72534 70.21713, 29.47384 70.34844...    0.627255   \n",
       "25704  POLYGON ((28.60702 70.90647, 27.30206 71.02446...    2.420992   \n",
       "25705  POLYGON ((28.60702 70.90647, 27.30206 71.02446...    2.420992   \n",
       "25706  POLYGON ((28.60702 70.90647, 27.30206 71.02446...    2.420992   \n",
       "25707  POLYGON ((28.60702 70.90647, 27.30206 71.02446...    2.420992   \n",
       "\n",
       "       Bio_02_mea  Bio_03_mea  Bio_04_mea  ...  Bio_10_mea  Bio_11_mea  \\\n",
       "0        8.495586    0.368012  462.715716  ...   24.509797   12.678282   \n",
       "1        8.495586    0.368012  462.715716  ...   24.509797   12.678282   \n",
       "2        1.528587    0.110094  436.010840  ...   25.079757   13.986250   \n",
       "3        3.756775    0.238924  374.399104  ...   23.658651   14.126988   \n",
       "4        3.756775    0.238924  374.399104  ...   23.658651   14.126988   \n",
       "...           ...         ...         ...  ...         ...         ...   \n",
       "25703    3.821428    0.183020  591.614208  ...    8.576487   -6.381050   \n",
       "25704    2.626016    0.170077  442.528004  ...    8.532202   -2.675670   \n",
       "25705    2.626016    0.170077  442.528004  ...    8.532202   -2.675670   \n",
       "25706    2.626016    0.170077  442.528004  ...    8.532202   -2.675670   \n",
       "25707    2.626016    0.170077  442.528004  ...    8.532202   -2.675670   \n",
       "\n",
       "       Bio_12_mea  Bio_13_mea  Bio_14_mea  Bio_15_mea  Bio_16_mea  Bio_17_mea  \\\n",
       "0      345.210093   47.583666      1.8524   57.250155  135.057773   13.583357   \n",
       "1      345.210093   47.583666      1.8524   57.250155  135.057773   13.583357   \n",
       "2      510.006213   98.965952      0.2310   83.750042  278.948983    7.215380   \n",
       "3      379.820661   55.684323      1.0697   62.789642  159.041741   12.041937   \n",
       "4      379.820661   55.684323      1.0697   62.789642  159.041741   12.041937   \n",
       "...           ...         ...         ...         ...         ...         ...   \n",
       "25703  867.108894  100.286265     50.6536   21.261742  269.148897  164.141273   \n",
       "25704  820.016682   98.181465     45.2222   23.091894  255.333051  147.027669   \n",
       "25705  820.016682   98.181465     45.2222   23.091894  255.333051  147.027669   \n",
       "25706  820.016682   98.181465     45.2222   23.091894  255.333051  147.027669   \n",
       "25707  820.016682   98.181465     45.2222   23.091894  255.333051  147.027669   \n",
       "\n",
       "       Bio_18_mea  Bio_19_mea  \n",
       "0       22.131150  126.752235  \n",
       "1       22.131150  126.752235  \n",
       "2       52.409418  173.755754  \n",
       "3       20.850420  152.538774  \n",
       "4       20.850420  152.538774  \n",
       "...           ...         ...  \n",
       "25703  259.901421  205.447719  \n",
       "25704  186.234926  233.672052  \n",
       "25705  186.234926  233.672052  \n",
       "25706  186.234926  233.672052  \n",
       "25707  186.234926  233.672052  \n",
       "\n",
       "[25708 rows x 25 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for df_name in df_names:\n",
    "    df = globals()[df_name] \n",
    "    Grid_Habitats_Variables = pd.merge(Grid_Habitats_Variables, df, on='ET_ID', how='left')\n",
    "\n",
    "Grid_Habitats_Variables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>ET_ID</th>\n",
       "      <th>%_H_1</th>\n",
       "      <th>%_H_2</th>\n",
       "      <th>%_H_3</th>\n",
       "      <th>%_H_4</th>\n",
       "      <th>geometry</th>\n",
       "      <th>Bio_01_mea</th>\n",
       "      <th>Bio_02_mea</th>\n",
       "      <th>Bio_03_mea</th>\n",
       "      <th>Bio_04_mea</th>\n",
       "      <th>...</th>\n",
       "      <th>Bio_10_mea</th>\n",
       "      <th>Bio_11_mea</th>\n",
       "      <th>Bio_12_mea</th>\n",
       "      <th>Bio_13_mea</th>\n",
       "      <th>Bio_14_mea</th>\n",
       "      <th>Bio_15_mea</th>\n",
       "      <th>Bio_16_mea</th>\n",
       "      <th>Bio_17_mea</th>\n",
       "      <th>Bio_18_mea</th>\n",
       "      <th>Bio_19_mea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>35.2700</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>37.6820</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>18.2550</td>\n",
       "      <td>8.4956</td>\n",
       "      <td>0.3680</td>\n",
       "      <td>462.7157</td>\n",
       "      <td>...</td>\n",
       "      <td>24.5098</td>\n",
       "      <td>12.6783</td>\n",
       "      <td>345.2101</td>\n",
       "      <td>47.5837</td>\n",
       "      <td>1.8524</td>\n",
       "      <td>57.2502</td>\n",
       "      <td>135.0578</td>\n",
       "      <td>13.5834</td>\n",
       "      <td>22.1311</td>\n",
       "      <td>126.7522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>249</td>\n",
       "      <td>35.2700</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>37.6820</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>18.2550</td>\n",
       "      <td>8.4956</td>\n",
       "      <td>0.3680</td>\n",
       "      <td>462.7157</td>\n",
       "      <td>...</td>\n",
       "      <td>24.5098</td>\n",
       "      <td>12.6783</td>\n",
       "      <td>345.2101</td>\n",
       "      <td>47.5837</td>\n",
       "      <td>1.8524</td>\n",
       "      <td>57.2502</td>\n",
       "      <td>135.0578</td>\n",
       "      <td>13.5834</td>\n",
       "      <td>22.1311</td>\n",
       "      <td>126.7522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>280</td>\n",
       "      <td>90.1848</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.5578</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "      <td>19.1658</td>\n",
       "      <td>1.5286</td>\n",
       "      <td>0.1101</td>\n",
       "      <td>436.0108</td>\n",
       "      <td>...</td>\n",
       "      <td>25.0798</td>\n",
       "      <td>13.9862</td>\n",
       "      <td>510.0062</td>\n",
       "      <td>98.9660</td>\n",
       "      <td>0.2310</td>\n",
       "      <td>83.7500</td>\n",
       "      <td>278.9490</td>\n",
       "      <td>7.2154</td>\n",
       "      <td>52.4094</td>\n",
       "      <td>173.7558</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   ET_ID    %_H_1  %_H_2  %_H_3    %_H_4  \\\n",
       "0    249  35.2700    0.0    0.0  37.6820   \n",
       "1    249  35.2700    0.0    0.0  37.6820   \n",
       "2    280  90.1848    0.0    0.0   5.5578   \n",
       "\n",
       "                                            geometry  Bio_01_mea  Bio_02_mea  \\\n",
       "0  POLYGON ((-2.18083 34.85145, -2.71695 34.77839...     18.2550      8.4956   \n",
       "1  POLYGON ((-2.18083 34.85145, -2.71695 34.77839...     18.2550      8.4956   \n",
       "2  POLYGON ((14.68659 35.53849, 14.14122 35.56449...     19.1658      1.5286   \n",
       "\n",
       "   Bio_03_mea  Bio_04_mea  ...  Bio_10_mea  Bio_11_mea  Bio_12_mea  \\\n",
       "0      0.3680    462.7157  ...     24.5098     12.6783    345.2101   \n",
       "1      0.3680    462.7157  ...     24.5098     12.6783    345.2101   \n",
       "2      0.1101    436.0108  ...     25.0798     13.9862    510.0062   \n",
       "\n",
       "   Bio_13_mea  Bio_14_mea  Bio_15_mea  Bio_16_mea  Bio_17_mea  Bio_18_mea  \\\n",
       "0     47.5837      1.8524     57.2502    135.0578     13.5834     22.1311   \n",
       "1     47.5837      1.8524     57.2502    135.0578     13.5834     22.1311   \n",
       "2     98.9660      0.2310     83.7500    278.9490      7.2154     52.4094   \n",
       "\n",
       "   Bio_19_mea  \n",
       "0    126.7522  \n",
       "1    126.7522  \n",
       "2    173.7558  \n",
       "\n",
       "[3 rows x 25 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Redondear todas las columnas float64 a 4 decimales\n",
    "Grid_Habitats_Variables = Grid_Habitats_Variables.round(4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "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>ET_ID</th>\n",
       "      <th>%_H_1</th>\n",
       "      <th>%_H_2</th>\n",
       "      <th>%_H_3</th>\n",
       "      <th>%_H_4</th>\n",
       "      <th>geometry</th>\n",
       "      <th>Bio_01_mea</th>\n",
       "      <th>Bio_02_mea</th>\n",
       "      <th>Bio_03_mea</th>\n",
       "      <th>Bio_04_mea</th>\n",
       "      <th>...</th>\n",
       "      <th>Bio_10_mea</th>\n",
       "      <th>Bio_11_mea</th>\n",
       "      <th>Bio_12_mea</th>\n",
       "      <th>Bio_13_mea</th>\n",
       "      <th>Bio_14_mea</th>\n",
       "      <th>Bio_15_mea</th>\n",
       "      <th>Bio_16_mea</th>\n",
       "      <th>Bio_17_mea</th>\n",
       "      <th>Bio_18_mea</th>\n",
       "      <th>Bio_19_mea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>35.270045</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>37.681992</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>18.254976</td>\n",
       "      <td>8.495586</td>\n",
       "      <td>0.368012</td>\n",
       "      <td>462.715716</td>\n",
       "      <td>...</td>\n",
       "      <td>24.509797</td>\n",
       "      <td>12.678282</td>\n",
       "      <td>345.210093</td>\n",
       "      <td>47.583666</td>\n",
       "      <td>1.8524</td>\n",
       "      <td>57.250155</td>\n",
       "      <td>135.057773</td>\n",
       "      <td>13.583357</td>\n",
       "      <td>22.131150</td>\n",
       "      <td>126.752235</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>280</td>\n",
       "      <td>90.184792</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.557788</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "      <td>19.165826</td>\n",
       "      <td>1.528587</td>\n",
       "      <td>0.110094</td>\n",
       "      <td>436.010840</td>\n",
       "      <td>...</td>\n",
       "      <td>25.079757</td>\n",
       "      <td>13.986250</td>\n",
       "      <td>510.006213</td>\n",
       "      <td>98.965952</td>\n",
       "      <td>0.2310</td>\n",
       "      <td>83.750042</td>\n",
       "      <td>278.948983</td>\n",
       "      <td>7.215380</td>\n",
       "      <td>52.409418</td>\n",
       "      <td>173.755754</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>363</td>\n",
       "      <td>83.471585</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.195240</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "      <td>18.462150</td>\n",
       "      <td>3.756775</td>\n",
       "      <td>0.238924</td>\n",
       "      <td>374.399104</td>\n",
       "      <td>...</td>\n",
       "      <td>23.658651</td>\n",
       "      <td>14.126988</td>\n",
       "      <td>379.820661</td>\n",
       "      <td>55.684323</td>\n",
       "      <td>1.0697</td>\n",
       "      <td>62.789642</td>\n",
       "      <td>159.041741</td>\n",
       "      <td>12.041937</td>\n",
       "      <td>20.850420</td>\n",
       "      <td>152.538774</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>412</td>\n",
       "      <td>45.938994</td>\n",
       "      <td>2.008313</td>\n",
       "      <td>0.037364</td>\n",
       "      <td>16.633191</td>\n",
       "      <td>POLYGON ((23.95653 35.05738, 23.41935 35.13773...</td>\n",
       "      <td>17.727971</td>\n",
       "      <td>4.337668</td>\n",
       "      <td>0.225087</td>\n",
       "      <td>507.017180</td>\n",
       "      <td>...</td>\n",
       "      <td>24.354709</td>\n",
       "      <td>11.601990</td>\n",
       "      <td>802.802130</td>\n",
       "      <td>166.771665</td>\n",
       "      <td>0.9438</td>\n",
       "      <td>93.524103</td>\n",
       "      <td>465.878952</td>\n",
       "      <td>5.476485</td>\n",
       "      <td>17.501850</td>\n",
       "      <td>370.952439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>413</td>\n",
       "      <td>49.840265</td>\n",
       "      <td>0.152722</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>20.580031</td>\n",
       "      <td>POLYGON ((24.49271 34.97391, 23.95653 35.05738...</td>\n",
       "      <td>17.632936</td>\n",
       "      <td>3.921218</td>\n",
       "      <td>0.207843</td>\n",
       "      <td>509.289924</td>\n",
       "      <td>...</td>\n",
       "      <td>24.264651</td>\n",
       "      <td>11.499705</td>\n",
       "      <td>734.030732</td>\n",
       "      <td>147.560539</td>\n",
       "      <td>1.3217</td>\n",
       "      <td>90.566040</td>\n",
       "      <td>412.471176</td>\n",
       "      <td>5.717345</td>\n",
       "      <td>15.655768</td>\n",
       "      <td>337.289896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25678</th>\n",
       "      <td>9369</td>\n",
       "      <td>72.880249</td>\n",
       "      <td>0.631549</td>\n",
       "      <td>0.824417</td>\n",
       "      <td>19.030928</td>\n",
       "      <td>POLYGON ((26.92771 70.58708, 25.63446 70.69412...</td>\n",
       "      <td>1.797804</td>\n",
       "      <td>3.621791</td>\n",
       "      <td>0.179989</td>\n",
       "      <td>568.053206</td>\n",
       "      <td>...</td>\n",
       "      <td>9.498814</td>\n",
       "      <td>-4.828538</td>\n",
       "      <td>883.689309</td>\n",
       "      <td>104.235966</td>\n",
       "      <td>47.8207</td>\n",
       "      <td>23.038690</td>\n",
       "      <td>277.268834</td>\n",
       "      <td>156.062921</td>\n",
       "      <td>208.810237</td>\n",
       "      <td>253.850528</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25685</th>\n",
       "      <td>9370</td>\n",
       "      <td>31.736606</td>\n",
       "      <td>3.108375</td>\n",
       "      <td>2.949913</td>\n",
       "      <td>44.895223</td>\n",
       "      <td>POLYGON ((28.20775 70.47181, 26.92771 70.58708...</td>\n",
       "      <td>0.008627</td>\n",
       "      <td>4.658969</td>\n",
       "      <td>0.187124</td>\n",
       "      <td>700.483670</td>\n",
       "      <td>...</td>\n",
       "      <td>9.401169</td>\n",
       "      <td>-8.395216</td>\n",
       "      <td>1006.391733</td>\n",
       "      <td>117.775208</td>\n",
       "      <td>56.8986</td>\n",
       "      <td>21.223914</td>\n",
       "      <td>309.381800</td>\n",
       "      <td>183.582187</td>\n",
       "      <td>266.479314</td>\n",
       "      <td>259.674011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25692</th>\n",
       "      <td>9371</td>\n",
       "      <td>22.533577</td>\n",
       "      <td>1.464064</td>\n",
       "      <td>2.189719</td>\n",
       "      <td>45.530093</td>\n",
       "      <td>POLYGON ((29.47384 70.34844, 28.20775 70.47181...</td>\n",
       "      <td>-0.399243</td>\n",
       "      <td>4.666984</td>\n",
       "      <td>0.187774</td>\n",
       "      <td>700.773789</td>\n",
       "      <td>...</td>\n",
       "      <td>8.995605</td>\n",
       "      <td>-8.801159</td>\n",
       "      <td>961.856564</td>\n",
       "      <td>113.000975</td>\n",
       "      <td>54.4348</td>\n",
       "      <td>21.979814</td>\n",
       "      <td>298.051595</td>\n",
       "      <td>175.460374</td>\n",
       "      <td>274.657953</td>\n",
       "      <td>237.605405</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25699</th>\n",
       "      <td>9372</td>\n",
       "      <td>36.329307</td>\n",
       "      <td>0.583969</td>\n",
       "      <td>0.566001</td>\n",
       "      <td>38.941126</td>\n",
       "      <td>POLYGON ((30.72534 70.21713, 29.47384 70.34844...</td>\n",
       "      <td>0.627255</td>\n",
       "      <td>3.821428</td>\n",
       "      <td>0.183020</td>\n",
       "      <td>591.614208</td>\n",
       "      <td>...</td>\n",
       "      <td>8.576487</td>\n",
       "      <td>-6.381050</td>\n",
       "      <td>867.108894</td>\n",
       "      <td>100.286265</td>\n",
       "      <td>50.6536</td>\n",
       "      <td>21.261742</td>\n",
       "      <td>269.148897</td>\n",
       "      <td>164.141273</td>\n",
       "      <td>259.901421</td>\n",
       "      <td>205.447719</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25704</th>\n",
       "      <td>9485</td>\n",
       "      <td>85.282380</td>\n",
       "      <td>0.424124</td>\n",
       "      <td>0.096730</td>\n",
       "      <td>8.570526</td>\n",
       "      <td>POLYGON ((28.60702 70.90647, 27.30206 71.02446...</td>\n",
       "      <td>2.420992</td>\n",
       "      <td>2.626016</td>\n",
       "      <td>0.170077</td>\n",
       "      <td>442.528004</td>\n",
       "      <td>...</td>\n",
       "      <td>8.532202</td>\n",
       "      <td>-2.675670</td>\n",
       "      <td>820.016682</td>\n",
       "      <td>98.181465</td>\n",
       "      <td>45.2222</td>\n",
       "      <td>23.091894</td>\n",
       "      <td>255.333051</td>\n",
       "      <td>147.027669</td>\n",
       "      <td>186.234926</td>\n",
       "      <td>233.672052</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3106 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       ET_ID      %_H_1     %_H_2     %_H_3      %_H_4  \\\n",
       "0        249  35.270045  0.000000  0.000000  37.681992   \n",
       "2        280  90.184792  0.000000  0.000000   5.557788   \n",
       "3        363  83.471585  0.000000  0.000000  10.195240   \n",
       "5        412  45.938994  2.008313  0.037364  16.633191   \n",
       "7        413  49.840265  0.152722  0.000000  20.580031   \n",
       "...      ...        ...       ...       ...        ...   \n",
       "25678   9369  72.880249  0.631549  0.824417  19.030928   \n",
       "25685   9370  31.736606  3.108375  2.949913  44.895223   \n",
       "25692   9371  22.533577  1.464064  2.189719  45.530093   \n",
       "25699   9372  36.329307  0.583969  0.566001  38.941126   \n",
       "25704   9485  85.282380  0.424124  0.096730   8.570526   \n",
       "\n",
       "                                                geometry  Bio_01_mea  \\\n",
       "0      POLYGON ((-2.18083 34.85145, -2.71695 34.77839...   18.254976   \n",
       "2      POLYGON ((14.68659 35.53849, 14.14122 35.56449...   19.165826   \n",
       "3      POLYGON ((-2.79499 35.22702, -3.33331 35.15029...   18.462150   \n",
       "5      POLYGON ((23.95653 35.05738, 23.41935 35.13773...   17.727971   \n",
       "7      POLYGON ((24.49271 34.97391, 23.95653 35.05738...   17.632936   \n",
       "...                                                  ...         ...   \n",
       "25678  POLYGON ((26.92771 70.58708, 25.63446 70.69412...    1.797804   \n",
       "25685  POLYGON ((28.20775 70.47181, 26.92771 70.58708...    0.008627   \n",
       "25692  POLYGON ((29.47384 70.34844, 28.20775 70.47181...   -0.399243   \n",
       "25699  POLYGON ((30.72534 70.21713, 29.47384 70.34844...    0.627255   \n",
       "25704  POLYGON ((28.60702 70.90647, 27.30206 71.02446...    2.420992   \n",
       "\n",
       "       Bio_02_mea  Bio_03_mea  Bio_04_mea  ...  Bio_10_mea  Bio_11_mea  \\\n",
       "0        8.495586    0.368012  462.715716  ...   24.509797   12.678282   \n",
       "2        1.528587    0.110094  436.010840  ...   25.079757   13.986250   \n",
       "3        3.756775    0.238924  374.399104  ...   23.658651   14.126988   \n",
       "5        4.337668    0.225087  507.017180  ...   24.354709   11.601990   \n",
       "7        3.921218    0.207843  509.289924  ...   24.264651   11.499705   \n",
       "...           ...         ...         ...  ...         ...         ...   \n",
       "25678    3.621791    0.179989  568.053206  ...    9.498814   -4.828538   \n",
       "25685    4.658969    0.187124  700.483670  ...    9.401169   -8.395216   \n",
       "25692    4.666984    0.187774  700.773789  ...    8.995605   -8.801159   \n",
       "25699    3.821428    0.183020  591.614208  ...    8.576487   -6.381050   \n",
       "25704    2.626016    0.170077  442.528004  ...    8.532202   -2.675670   \n",
       "\n",
       "        Bio_12_mea  Bio_13_mea  Bio_14_mea  Bio_15_mea  Bio_16_mea  \\\n",
       "0       345.210093   47.583666      1.8524   57.250155  135.057773   \n",
       "2       510.006213   98.965952      0.2310   83.750042  278.948983   \n",
       "3       379.820661   55.684323      1.0697   62.789642  159.041741   \n",
       "5       802.802130  166.771665      0.9438   93.524103  465.878952   \n",
       "7       734.030732  147.560539      1.3217   90.566040  412.471176   \n",
       "...            ...         ...         ...         ...         ...   \n",
       "25678   883.689309  104.235966     47.8207   23.038690  277.268834   \n",
       "25685  1006.391733  117.775208     56.8986   21.223914  309.381800   \n",
       "25692   961.856564  113.000975     54.4348   21.979814  298.051595   \n",
       "25699   867.108894  100.286265     50.6536   21.261742  269.148897   \n",
       "25704   820.016682   98.181465     45.2222   23.091894  255.333051   \n",
       "\n",
       "       Bio_17_mea  Bio_18_mea  Bio_19_mea  \n",
       "0       13.583357   22.131150  126.752235  \n",
       "2        7.215380   52.409418  173.755754  \n",
       "3       12.041937   20.850420  152.538774  \n",
       "5        5.476485   17.501850  370.952439  \n",
       "7        5.717345   15.655768  337.289896  \n",
       "...           ...         ...         ...  \n",
       "25678  156.062921  208.810237  253.850528  \n",
       "25685  183.582187  266.479314  259.674011  \n",
       "25692  175.460374  274.657953  237.605405  \n",
       "25699  164.141273  259.901421  205.447719  \n",
       "25704  147.027669  186.234926  233.672052  \n",
       "\n",
       "[3106 rows x 25 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Grid_Habitats_Variables = Grid_Habitats_Variables.drop_duplicates(subset=['ET_ID'])\n",
    "Grid_Habitats_Variables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "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>ET_ID</th>\n",
       "      <th>%_H_1</th>\n",
       "      <th>%_H_2</th>\n",
       "      <th>%_H_3</th>\n",
       "      <th>%_H_4</th>\n",
       "      <th>geometry</th>\n",
       "      <th>Bio_01_mea</th>\n",
       "      <th>Bio_02_mea</th>\n",
       "      <th>Bio_03_mea</th>\n",
       "      <th>Bio_04_mea</th>\n",
       "      <th>...</th>\n",
       "      <th>Bio_10_mea</th>\n",
       "      <th>Bio_11_mea</th>\n",
       "      <th>Bio_12_mea</th>\n",
       "      <th>Bio_13_mea</th>\n",
       "      <th>Bio_14_mea</th>\n",
       "      <th>Bio_15_mea</th>\n",
       "      <th>Bio_16_mea</th>\n",
       "      <th>Bio_17_mea</th>\n",
       "      <th>Bio_18_mea</th>\n",
       "      <th>Bio_19_mea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>249</td>\n",
       "      <td>35.2700</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>37.6820</td>\n",
       "      <td>POLYGON ((-2.18083 34.85145, -2.71695 34.77839...</td>\n",
       "      <td>18.2550</td>\n",
       "      <td>8.4956</td>\n",
       "      <td>0.3680</td>\n",
       "      <td>462.7157</td>\n",
       "      <td>...</td>\n",
       "      <td>24.5098</td>\n",
       "      <td>12.6783</td>\n",
       "      <td>345.2101</td>\n",
       "      <td>47.5837</td>\n",
       "      <td>1.8524</td>\n",
       "      <td>57.2502</td>\n",
       "      <td>135.0578</td>\n",
       "      <td>13.5834</td>\n",
       "      <td>22.1311</td>\n",
       "      <td>126.7522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>280</td>\n",
       "      <td>90.1848</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.5578</td>\n",
       "      <td>POLYGON ((14.68659 35.53849, 14.14122 35.56449...</td>\n",
       "      <td>19.1658</td>\n",
       "      <td>1.5286</td>\n",
       "      <td>0.1101</td>\n",
       "      <td>436.0108</td>\n",
       "      <td>...</td>\n",
       "      <td>25.0798</td>\n",
       "      <td>13.9862</td>\n",
       "      <td>510.0062</td>\n",
       "      <td>98.9660</td>\n",
       "      <td>0.2310</td>\n",
       "      <td>83.7500</td>\n",
       "      <td>278.9490</td>\n",
       "      <td>7.2154</td>\n",
       "      <td>52.4094</td>\n",
       "      <td>173.7558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>363</td>\n",
       "      <td>83.4716</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.1952</td>\n",
       "      <td>POLYGON ((-2.79499 35.22702, -3.33331 35.15029...</td>\n",
       "      <td>18.4622</td>\n",
       "      <td>3.7568</td>\n",
       "      <td>0.2389</td>\n",
       "      <td>374.3991</td>\n",
       "      <td>...</td>\n",
       "      <td>23.6587</td>\n",
       "      <td>14.1270</td>\n",
       "      <td>379.8207</td>\n",
       "      <td>55.6843</td>\n",
       "      <td>1.0697</td>\n",
       "      <td>62.7896</td>\n",
       "      <td>159.0417</td>\n",
       "      <td>12.0419</td>\n",
       "      <td>20.8504</td>\n",
       "      <td>152.5388</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   ET_ID    %_H_1  %_H_2  %_H_3    %_H_4  \\\n",
       "0    249  35.2700    0.0    0.0  37.6820   \n",
       "2    280  90.1848    0.0    0.0   5.5578   \n",
       "3    363  83.4716    0.0    0.0  10.1952   \n",
       "\n",
       "                                            geometry  Bio_01_mea  Bio_02_mea  \\\n",
       "0  POLYGON ((-2.18083 34.85145, -2.71695 34.77839...     18.2550      8.4956   \n",
       "2  POLYGON ((14.68659 35.53849, 14.14122 35.56449...     19.1658      1.5286   \n",
       "3  POLYGON ((-2.79499 35.22702, -3.33331 35.15029...     18.4622      3.7568   \n",
       "\n",
       "   Bio_03_mea  Bio_04_mea  ...  Bio_10_mea  Bio_11_mea  Bio_12_mea  \\\n",
       "0      0.3680    462.7157  ...     24.5098     12.6783    345.2101   \n",
       "2      0.1101    436.0108  ...     25.0798     13.9862    510.0062   \n",
       "3      0.2389    374.3991  ...     23.6587     14.1270    379.8207   \n",
       "\n",
       "   Bio_13_mea  Bio_14_mea  Bio_15_mea  Bio_16_mea  Bio_17_mea  Bio_18_mea  \\\n",
       "0     47.5837      1.8524     57.2502    135.0578     13.5834     22.1311   \n",
       "2     98.9660      0.2310     83.7500    278.9490      7.2154     52.4094   \n",
       "3     55.6843      1.0697     62.7896    159.0417     12.0419     20.8504   \n",
       "\n",
       "   Bio_19_mea  \n",
       "0    126.7522  \n",
       "2    173.7558  \n",
       "3    152.5388  \n",
       "\n",
       "[3 rows x 25 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Redondear todas las columnas float64 a 4 decimales\n",
    "Grid_Habitats_Variables = Grid_Habitats_Variables.round(4)\n",
    "Grid_Habitats_Variables.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Exportar el resultado\n",
    "Grid_Habitats_Variables.to_csv('Data/Variables/Grid_Variables.csv', index=False, decimal='.')\n",
    "Grid_Habitats_Variables.to_file('Data/Variables/Grid_Variables.shp', decimal='.')\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "anura",
   "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.12.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}