test.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from pathlib import Path\n",
    "\n",
    "import pandas as pd\n",
    "import requests\n",
    "import numpy as np\n",
    "from slugify import slugify\n",
    "\n",
    "def download_and_format_image_path(url):\n",
    "    path = Path(url)\n",
    "    ref_path = f\"images/{slugify(path.stem)}{path.suffix}\"\n",
    "    output_path = f\"static/{ref_path}\"\n",
    "    r = requests.get(url)\n",
    "    with open(output_path, 'wb') as f:\n",
    "        f.write(r.content)\n",
    "    return ref_path"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"https://docs.google.com/spreadsheets/d/e/2PACX-1vR-BAUvNUjp2AeV_daeeqHReX0M3ew3ZpEL3nfkrz96uUd816mV_hV1uWMvbsACphEBGjqHJBswGwFz/pub?gid=614465369&single=true&output=csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# filter dataframe depending on the value of two columns\n",
    "df = df[(df['Curso Escolar'] == \"2022-23\") & (df['Convocatoria'] == \"1\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_status(curso, moodle_url, portada):\n",
    "    try:\n",
    "        # compare if the three parameters are nan and exit the function if they are\n",
    "        if pd.isna(curso) and pd.isna(moodle_url) and pd.isna(portada):\n",
    "            return\n",
    "        elif moodle_url.startswith(\"https\"):\n",
    "            r = requests.get(portada)\n",
    "            if r.status_code != 200:\n",
    "                print(f\"El curso [{curso}]({moodle_url}) no tiene portada\")\n",
    "        else:\n",
    "            print(f\"Faltan datos:\\nCurso: {curso}\\nMoodle: {moodle_url}\\nPortada: {portada}\")\n",
    "    except Exception:\n",
    "        print(f\"Con los siguientes datos, algo ha fallado:\\nCurso: {curso}\\nMoodle: {moodle_url}\\nPortada: {portada}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Faltan datos:\n",
      "Curso: TRABAJO FIN DE ITINERARIO IGUALDAD\n",
      "Moodle: 0\n",
      "Portada: https://moodle.catedu.es/pluginfile.php/134987/course/overviewfiles/aleksander-naug-zc4zlco207A-unsplash%20%282%29.jpg\n",
      "El curso [Microcontroladores vestibles y conectados a internet](https://moodle.catedu.es/course/view.php?id=1261) no tiene portada\n",
      "Con los siguientes datos, algo ha fallado:\n",
      "Curso: Arduino con ArduinoBlocks\n",
      "Moodle: nan\n",
      "Portada: nan\n",
      "Con los siguientes datos, algo ha fallado:\n",
      "Curso: ARDUINOBLOCKS EN EL AULA\n",
      "Moodle: nan\n",
      "Portada: nan\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "0      None\n",
       "1      None\n",
       "2      None\n",
       "3      None\n",
       "4      None\n",
       "       ... \n",
       "165    None\n",
       "166    None\n",
       "167    None\n",
       "168    None\n",
       "169    None\n",
       "Length: 170, dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# apply a funcion taking three arguments in pandas\n",
    "df.apply(lambda x: get_status(x['Curso'], x['Moodle_url'], x['Portada']), axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "# pandas replace nan values in a series with empty string\n",
    "df['Portada'] = df['Portada'].replace(np.nan, '', regex=True)\n",
    "\n",
    "#split the url and get the last element of the list and prepend a path\n",
    "df['Images'] = df['Portada'].apply(lambda x: download_and_format_image_path(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"webdata.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# function to reduce the size of the image\n",
    "def reduce_image_size(image_path):\n",
    "    img = Image.open(image_path)\n",
    "    img.save(image_path, optimize=True, quality=85)\n"
   ]
  },
  {
   "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>Portada</th>\n",
       "      <th>Curso</th>\n",
       "      <th>1.1</th>\n",
       "      <th>1.2</th>\n",
       "      <th>1.3</th>\n",
       "      <th>1.4</th>\n",
       "      <th>1.5</th>\n",
       "      <th>2.1</th>\n",
       "      <th>2.2</th>\n",
       "      <th>2.3</th>\n",
       "      <th>...</th>\n",
       "      <th>4.2</th>\n",
       "      <th>4.3</th>\n",
       "      <th>5.1</th>\n",
       "      <th>5.2</th>\n",
       "      <th>5.3</th>\n",
       "      <th>6.1</th>\n",
       "      <th>6.2</th>\n",
       "      <th>6.3</th>\n",
       "      <th>6.4</th>\n",
       "      <th>6.5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/5878/c...</td>\n",
       "      <td>ABP APRENDIZAJE BASADO EN PROYECTOS INFANTIL P...</td>\n",
       "      <td>B1</td>\n",
       "      <td>A2</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/5822/c...</td>\n",
       "      <td>ABP APRENDIZAJE BASADO EN PROYECTOS SECUNDARIA...</td>\n",
       "      <td>B1</td>\n",
       "      <td>A2</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/85386/...</td>\n",
       "      <td>AJEDREZ EN LA ESCUELA</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/5737/c...</td>\n",
       "      <td>ALIMENTACIÓN Y NUTRICIÓN PARA UNA VIDA SALUDABLE</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/1224/c...</td>\n",
       "      <td>APP INVENTOR</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>A1</td>\n",
       "      <td>B1</td>\n",
       "      <td>A2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A1</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>165</th>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/175090...</td>\n",
       "      <td>Diseña un Plan Digital de Centro</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>NaN</td>\n",
       "      <td>ARDUINOBLOCKS EN EL AULA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/154682...</td>\n",
       "      <td>Bases de datos relacionales y lenguaje SQL</td>\n",
       "      <td>A2</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B1</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>B1</td>\n",
       "      <td>A2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A1</td>\n",
       "      <td>A1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A1</td>\n",
       "      <td>A1</td>\n",
       "      <td>A1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>170 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               Portada  \\\n",
       "0    https://moodle.catedu.es/pluginfile.php/5878/c...   \n",
       "1    https://moodle.catedu.es/pluginfile.php/5822/c...   \n",
       "2    https://moodle.catedu.es/pluginfile.php/85386/...   \n",
       "3    https://moodle.catedu.es/pluginfile.php/5737/c...   \n",
       "4    https://moodle.catedu.es/pluginfile.php/1224/c...   \n",
       "..                                                 ...   \n",
       "165  https://moodle.catedu.es/pluginfile.php/175090...   \n",
       "166                                                NaN   \n",
       "167  https://moodle.catedu.es/pluginfile.php/154682...   \n",
       "168                                                NaN   \n",
       "169                                                NaN   \n",
       "\n",
       "                                                 Curso  1.1  1.2  1.3  1.4  \\\n",
       "0    ABP APRENDIZAJE BASADO EN PROYECTOS INFANTIL P...   B1   A2   B1   B1   \n",
       "1    ABP APRENDIZAJE BASADO EN PROYECTOS SECUNDARIA...   B1   A2   B1   B1   \n",
       "2                                AJEDREZ EN LA ESCUELA   A2   A2  NaN   A2   \n",
       "3     ALIMENTACIÓN Y NUTRICIÓN PARA UNA VIDA SALUDABLE   A2   A2  NaN   A2   \n",
       "4                                         APP INVENTOR   A2   A2   A1   B1   \n",
       "..                                                 ...  ...  ...  ...  ...   \n",
       "165                   Diseña un Plan Digital de Centro   B1   B1   B1   B1   \n",
       "166                           ARDUINOBLOCKS EN EL AULA  NaN  NaN  NaN  NaN   \n",
       "167         Bases de datos relacionales y lenguaje SQL   A2   B1  NaN   B1   \n",
       "168                                                NaN  NaN  NaN  NaN  NaN   \n",
       "169                                                NaN  NaN  NaN  NaN  NaN   \n",
       "\n",
       "     1.5  2.1  2.2  2.3  ...  4.2  4.3  5.1  5.2  5.3  6.1  6.2  6.3  6.4  6.5  \n",
       "0     B1  NaN   B1  NaN  ...  NaN  NaN  NaN   B1   B1  NaN  NaN  NaN  NaN   B1  \n",
       "1     B1  NaN   B1  NaN  ...  NaN  NaN  NaN   B1   B1  NaN  NaN  NaN  NaN   B1  \n",
       "2     A2  NaN  NaN  NaN  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "3     A2  NaN  NaN  NaN  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "4     A2  NaN   B1  NaN  ...  NaN  NaN  NaN  NaN   A1  NaN  NaN   A1  NaN   A1  \n",
       "..   ...  ...  ...  ...  ...  ...  ...  ...  ...  ...  ...  ...  ...  ...  ...  \n",
       "165   B1  NaN   B1   B1  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "166  NaN  NaN  NaN  NaN  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "167   A2   A2   B1   A2  ...  NaN  NaN   A1   A1  NaN   A1  NaN   A1   A1   A1  \n",
       "168  NaN  NaN  NaN  NaN  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "169  NaN  NaN  NaN  NaN  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "\n",
       "[170 rows x 25 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# pandas select specific columns and those whose title contains a string of one digit, a dot and another digit\n",
    "pd.concat([df[[\"Portada\", \"Curso\"]], df.filter(regex=\"\\d\\.\\d\")], axis=1)\n"
   ]
  },
  {
   "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>Portada</th>\n",
       "      <th>Curso</th>\n",
       "      <th>1.1</th>\n",
       "      <th>1.2</th>\n",
       "      <th>1.3</th>\n",
       "      <th>1.4</th>\n",
       "      <th>1.5</th>\n",
       "      <th>2.1</th>\n",
       "      <th>2.2</th>\n",
       "      <th>2.3</th>\n",
       "      <th>...</th>\n",
       "      <th>4.2</th>\n",
       "      <th>4.3</th>\n",
       "      <th>5.1</th>\n",
       "      <th>5.2</th>\n",
       "      <th>5.3</th>\n",
       "      <th>6.1</th>\n",
       "      <th>6.2</th>\n",
       "      <th>6.3</th>\n",
       "      <th>6.4</th>\n",
       "      <th>6.5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/5878/c...</td>\n",
       "      <td>ABP APRENDIZAJE BASADO EN PROYECTOS INFANTIL P...</td>\n",
       "      <td>B1</td>\n",
       "      <td>A2</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/5822/c...</td>\n",
       "      <td>ABP APRENDIZAJE BASADO EN PROYECTOS SECUNDARIA...</td>\n",
       "      <td>B1</td>\n",
       "      <td>A2</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/85386/...</td>\n",
       "      <td>AJEDREZ EN LA ESCUELA</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/5737/c...</td>\n",
       "      <td>ALIMENTACIÓN Y NUTRICIÓN PARA UNA VIDA SALUDABLE</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/1224/c...</td>\n",
       "      <td>APP INVENTOR</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>A1</td>\n",
       "      <td>B1</td>\n",
       "      <td>A2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A1</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>171</th>\n",
       "      <td>NaN</td>\n",
       "      <td>COMPETENCIA DIGITAL DOCENTE Nivel A2: Iniciaci...</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>B1</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>...</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/173985...</td>\n",
       "      <td>AULA DEL FUTURO</td>\n",
       "      <td>A2</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>A2</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>B1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/173916...</td>\n",
       "      <td>Del currículo a la práctica en el aula</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/173847...</td>\n",
       "      <td>Situaciones de aprendizaje para el desarrollo ...</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/173784...</td>\n",
       "      <td>Evaluación de competencias a través del desempeño</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A2</td>\n",
       "      <td>A2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>176 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               Portada  \\\n",
       "0    https://moodle.catedu.es/pluginfile.php/5878/c...   \n",
       "1    https://moodle.catedu.es/pluginfile.php/5822/c...   \n",
       "2    https://moodle.catedu.es/pluginfile.php/85386/...   \n",
       "3    https://moodle.catedu.es/pluginfile.php/5737/c...   \n",
       "4    https://moodle.catedu.es/pluginfile.php/1224/c...   \n",
       "..                                                 ...   \n",
       "171                                                NaN   \n",
       "172  https://moodle.catedu.es/pluginfile.php/173985...   \n",
       "173  https://moodle.catedu.es/pluginfile.php/173916...   \n",
       "174  https://moodle.catedu.es/pluginfile.php/173847...   \n",
       "175  https://moodle.catedu.es/pluginfile.php/173784...   \n",
       "\n",
       "                                                 Curso 1.1 1.2  1.3 1.4 1.5  \\\n",
       "0    ABP APRENDIZAJE BASADO EN PROYECTOS INFANTIL P...  B1  A2   B1  B1  B1   \n",
       "1    ABP APRENDIZAJE BASADO EN PROYECTOS SECUNDARIA...  B1  A2   B1  B1  B1   \n",
       "2                                AJEDREZ EN LA ESCUELA  A2  A2  NaN  A2  A2   \n",
       "3     ALIMENTACIÓN Y NUTRICIÓN PARA UNA VIDA SALUDABLE  A2  A2  NaN  A2  A2   \n",
       "4                                         APP INVENTOR  A2  A2   A1  B1  A2   \n",
       "..                                                 ...  ..  ..  ...  ..  ..   \n",
       "171  COMPETENCIA DIGITAL DOCENTE Nivel A2: Iniciaci...  A2  A2   A2  B1  A2   \n",
       "172                                    AULA DEL FUTURO  A2  B1   B1  B1  A2   \n",
       "173             Del currículo a la práctica en el aula  A2  A2  NaN  A2  A2   \n",
       "174  Situaciones de aprendizaje para el desarrollo ...  A2  A2  NaN  A2  A2   \n",
       "175  Evaluación de competencias a través del desempeño  A2  A2  NaN  A2  A2   \n",
       "\n",
       "     2.1  2.2  2.3  ...  4.2  4.3  5.1  5.2  5.3  6.1  6.2  6.3  6.4  6.5  \n",
       "0    NaN   B1  NaN  ...  NaN  NaN  NaN   B1   B1  NaN  NaN  NaN  NaN   B1  \n",
       "1    NaN   B1  NaN  ...  NaN  NaN  NaN   B1   B1  NaN  NaN  NaN  NaN   B1  \n",
       "2    NaN  NaN  NaN  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "3    NaN  NaN  NaN  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "4    NaN   B1  NaN  ...  NaN  NaN  NaN  NaN   A1  NaN  NaN   A1  NaN   A1  \n",
       "..   ...  ...  ...  ...  ...  ...  ...  ...  ...  ...  ...  ...  ...  ...  \n",
       "171   A2   A2   A2  ...   A2   A2   A2   A2   A2   A2   A2   A2   A2   A2  \n",
       "172   B1   B1   B1  ...  NaN  NaN  NaN  NaN   B1  NaN  NaN   A1  NaN  NaN  \n",
       "173  NaN  NaN  NaN  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "174  NaN  NaN  NaN  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "175  NaN  NaN  NaN  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "\n",
       "[176 rows x 25 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Select several columns and those whose title contains a string of one digit, a dot and another digit\n",
    "df[[\"Portada\", \"Curso\"]].join(df.filter(regex=\"\\d\\.\\d\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "161    arduinonano33iot.png\n",
       "162    les/Portadalibro.png\n",
       "163                     NaN\n",
       "164    -g19db1b297_1920.jpg\n",
       "165    O-BISEL-2048x853.png\n",
       "166                     NaN\n",
       "167    /cursobasesdatos.png\n",
       "168                     NaN\n",
       "169                     NaN\n",
       "Name: Portada, dtype: object"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"Portada\"][161:].str[-20:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Convocatoria anterior', 'Código de curso', 'Curso', 'Objetivos',\n",
       "       'Contenidos', 'Requisitos', 'Etiquetas', 'Libros', 'Moodle_url',\n",
       "       'Portada', 'Horas', 'Descripción', 'Convocatoria', 'Curso.1', '1.1',\n",
       "       '1.2', '1.3', '1.4', '1.5', '2.1', '2.2', '2.3', '3.1', '3.2', '3.3',\n",
       "       '3.4', '4.1', '4.2', '4.3', '5.1', '5.2', '5.3', '6.1', '6.2', '6.3',\n",
       "       '6.4', '6.5'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'float' object has no attribute 'split'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "Cell \u001b[0;32mIn [14], line 1\u001b[0m\n\u001b[0;32m----> 1\u001b[0m df[\u001b[39m'\u001b[39;49m\u001b[39mMoodle_url\u001b[39;49m\u001b[39m'\u001b[39;49m]\u001b[39m.\u001b[39;49mapply(\u001b[39mlambda\u001b[39;49;00m x: x\u001b[39m.\u001b[39;49msplit(\u001b[39m'\u001b[39;49m\u001b[39m/\u001b[39;49m\u001b[39m'\u001b[39;49m)[\u001b[39m-\u001b[39;49m\u001b[39m1\u001b[39;49m]\u001b[39m.\u001b[39;49msplit(\u001b[39m'\u001b[39;49m\u001b[39m=\u001b[39;49m\u001b[39m'\u001b[39;49m)[\u001b[39m-\u001b[39;49m\u001b[39m1\u001b[39;49m])\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.4/lib/python3.10/site-packages/pandas/core/series.py:4771\u001b[0m, in \u001b[0;36mSeries.apply\u001b[0;34m(self, func, convert_dtype, args, **kwargs)\u001b[0m\n\u001b[1;32m   4661\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39mapply\u001b[39m(\n\u001b[1;32m   4662\u001b[0m     \u001b[39mself\u001b[39m,\n\u001b[1;32m   4663\u001b[0m     func: AggFuncType,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m   4666\u001b[0m     \u001b[39m*\u001b[39m\u001b[39m*\u001b[39mkwargs,\n\u001b[1;32m   4667\u001b[0m ) \u001b[39m-\u001b[39m\u001b[39m>\u001b[39m DataFrame \u001b[39m|\u001b[39m Series:\n\u001b[1;32m   4668\u001b[0m     \u001b[39m\"\"\"\u001b[39;00m\n\u001b[1;32m   4669\u001b[0m \u001b[39m    Invoke function on values of Series.\u001b[39;00m\n\u001b[1;32m   4670\u001b[0m \n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m   4769\u001b[0m \u001b[39m    dtype: float64\u001b[39;00m\n\u001b[1;32m   4770\u001b[0m \u001b[39m    \"\"\"\u001b[39;00m\n\u001b[0;32m-> 4771\u001b[0m     \u001b[39mreturn\u001b[39;00m SeriesApply(\u001b[39mself\u001b[39;49m, func, convert_dtype, args, kwargs)\u001b[39m.\u001b[39;49mapply()\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.4/lib/python3.10/site-packages/pandas/core/apply.py:1105\u001b[0m, in \u001b[0;36mSeriesApply.apply\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m   1102\u001b[0m     \u001b[39mreturn\u001b[39;00m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mapply_str()\n\u001b[1;32m   1104\u001b[0m \u001b[39m# self.f is Callable\u001b[39;00m\n\u001b[0;32m-> 1105\u001b[0m \u001b[39mreturn\u001b[39;00m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mapply_standard()\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.4/lib/python3.10/site-packages/pandas/core/apply.py:1156\u001b[0m, in \u001b[0;36mSeriesApply.apply_standard\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m   1154\u001b[0m     \u001b[39melse\u001b[39;00m:\n\u001b[1;32m   1155\u001b[0m         values \u001b[39m=\u001b[39m obj\u001b[39m.\u001b[39mastype(\u001b[39mobject\u001b[39m)\u001b[39m.\u001b[39m_values\n\u001b[0;32m-> 1156\u001b[0m         mapped \u001b[39m=\u001b[39m lib\u001b[39m.\u001b[39;49mmap_infer(\n\u001b[1;32m   1157\u001b[0m             values,\n\u001b[1;32m   1158\u001b[0m             f,\n\u001b[1;32m   1159\u001b[0m             convert\u001b[39m=\u001b[39;49m\u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mconvert_dtype,\n\u001b[1;32m   1160\u001b[0m         )\n\u001b[1;32m   1162\u001b[0m \u001b[39mif\u001b[39;00m \u001b[39mlen\u001b[39m(mapped) \u001b[39mand\u001b[39;00m \u001b[39misinstance\u001b[39m(mapped[\u001b[39m0\u001b[39m], ABCSeries):\n\u001b[1;32m   1163\u001b[0m     \u001b[39m# GH#43986 Need to do list(mapped) in order to get treated as nested\u001b[39;00m\n\u001b[1;32m   1164\u001b[0m     \u001b[39m#  See also GH#25959 regarding EA support\u001b[39;00m\n\u001b[1;32m   1165\u001b[0m     \u001b[39mreturn\u001b[39;00m obj\u001b[39m.\u001b[39m_constructor_expanddim(\u001b[39mlist\u001b[39m(mapped), index\u001b[39m=\u001b[39mobj\u001b[39m.\u001b[39mindex)\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.4/lib/python3.10/site-packages/pandas/_libs/lib.pyx:2918\u001b[0m, in \u001b[0;36mpandas._libs.lib.map_infer\u001b[0;34m()\u001b[0m\n",
      "Cell \u001b[0;32mIn [14], line 1\u001b[0m, in \u001b[0;36m<lambda>\u001b[0;34m(x)\u001b[0m\n\u001b[0;32m----> 1\u001b[0m df[\u001b[39m'\u001b[39m\u001b[39mMoodle_url\u001b[39m\u001b[39m'\u001b[39m]\u001b[39m.\u001b[39mapply(\u001b[39mlambda\u001b[39;00m x: x\u001b[39m.\u001b[39;49msplit(\u001b[39m'\u001b[39m\u001b[39m/\u001b[39m\u001b[39m'\u001b[39m)[\u001b[39m-\u001b[39m\u001b[39m1\u001b[39m]\u001b[39m.\u001b[39msplit(\u001b[39m'\u001b[39m\u001b[39m=\u001b[39m\u001b[39m'\u001b[39m)[\u001b[39m-\u001b[39m\u001b[39m1\u001b[39m])\n",
      "\u001b[0;31mAttributeError\u001b[0m: 'float' object has no attribute 'split'"
     ]
    }
   ],
   "source": [
    "# pandas replace a string in a column under a condition\n",
    "df['Moodle_url'].apply(lambda x: x.split('/')[-1].split('=')[-1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[[\n",
    "    \"Curso\", \n",
    "    \"Descripción\", \n",
    "    \"Objetivos\", \n",
    "    \"Contenidos\", \n",
    "    \"Etiquetas\", \n",
    "    \"Libros\", \n",
    "    \"Moodle_url\", \n",
    "    \"Portada\", \n",
    "    \"Horas\"\n",
    "    ]].to_csv(\"webdata.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "df3= pd.read_csv(\"webdata.csv\")"
   ]
  },
  {
   "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>Unnamed: 0</th>\n",
       "      <th>Curso</th>\n",
       "      <th>Descripción</th>\n",
       "      <th>Objetivos</th>\n",
       "      <th>Contenidos</th>\n",
       "      <th>Etiquetas</th>\n",
       "      <th>Libros</th>\n",
       "      <th>Moodle_url</th>\n",
       "      <th>Portada</th>\n",
       "      <th>Horas</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>ABP APRENDIZAJE BASADO EN PROYECTOS INFANTIL P...</td>\n",
       "      <td>Frente a la enseñanza directa, la enseñanza ba...</td>\n",
       "      <td>* Analizar los principios de la enseñanza basa...</td>\n",
       "      <td>Definición de ABP. El ABP paso a paso. Apertur...</td>\n",
       "      <td>Metodologías</td>\n",
       "      <td>abp</td>\n",
       "      <td>https://moodle.catedu.es/course/view.php?id=79</td>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/5878/c...</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>ABP APRENDIZAJE BASADO EN PROYECTOS SECUNDARIA...</td>\n",
       "      <td>Frente a la enseñanza directa, la enseñanza ba...</td>\n",
       "      <td>* Analizar los principios de la enseñanza basa...</td>\n",
       "      <td>Definición de ABP. El ABP paso a paso. Apertur...</td>\n",
       "      <td>Metodologías</td>\n",
       "      <td>abp</td>\n",
       "      <td>https://moodle.catedu.es/course/view.php?id=78</td>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/5822/c...</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>AJEDREZ EN LA ESCUELA</td>\n",
       "      <td>Este curso está destinado a todos aquellos que...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>METODOLOGÍA Pensando por nosotros mismos Princ...</td>\n",
       "      <td>Otros</td>\n",
       "      <td>ajedrez-en-la-escuela</td>\n",
       "      <td>https://moodle.catedu.es/course/view.php?id=479</td>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/85386/...</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>ALIMENTACIÓN Y NUTRICIÓN PARA UNA VIDA SALUDABLE</td>\n",
       "      <td>La educación en nutrición, ha sido reconocida ...</td>\n",
       "      <td>* Contribuir a la prevención y control de los ...</td>\n",
       "      <td>Alimentos y nutrientes. El placer de comer y c...</td>\n",
       "      <td>Salud y bienestar</td>\n",
       "      <td>alimentacion</td>\n",
       "      <td>https://moodle.catedu.es/course/view.php?id=77</td>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/5737/c...</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>APP INVENTOR</td>\n",
       "      <td>Crea tus primeras apps en Android fácilmente u...</td>\n",
       "      <td>* Introducir al docente en el mundo de la prog...</td>\n",
       "      <td>Módulo 1. Primer contacto - un pequeño program...</td>\n",
       "      <td>STEAM/Programación</td>\n",
       "      <td>https://libros.catedu.es/books/app-inventor</td>\n",
       "      <td>https://moodle.catedu.es/course/view.php?id=38</td>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/1224/c...</td>\n",
       "      <td>10.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>171</td>\n",
       "      <td>COMPETENCIA DIGITAL DOCENTE Nivel A2: Iniciaci...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Acreditacion niveles CDD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>172</td>\n",
       "      <td>AULA DEL FUTURO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>• Fomentar la reflexión para crear una visión ...</td>\n",
       "      <td>• Módulo 1: Identificar las Partes Interesadas...</td>\n",
       "      <td>Metodologías</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://moodle.catedu.es/course/view.php?id=1260</td>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/173985...</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>173</td>\n",
       "      <td>Del currículo a la práctica en el aula</td>\n",
       "      <td>NaN</td>\n",
       "      <td>• Presentar y conocer los objetivos, principio...</td>\n",
       "      <td>• Bloque 1:  Contexto, fundamento y caracterís...</td>\n",
       "      <td>Normativa Educativa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://moodle.catedu.es/course/view.php?id=1259</td>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/173916...</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>174</td>\n",
       "      <td>Situaciones de aprendizaje para el desarrollo ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>• Alinear los retos educativos del siglo XXI c...</td>\n",
       "      <td>• Bloque 1. Las Competencias clave en el marco...</td>\n",
       "      <td>Normativa Educativa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://moodle.catedu.es/course/view.php?id=1258</td>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/173847...</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>175</td>\n",
       "      <td>Evaluación de competencias a través del desempeño</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>• Bloque 1. ¿Qué es evaluar? Conceptos básicos...</td>\n",
       "      <td>Normativa Educativa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://moodle.catedu.es/course/view.php?id=1257</td>\n",
       "      <td>https://moodle.catedu.es/pluginfile.php/173784...</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>176 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0                                              Curso  \\\n",
       "0             0  ABP APRENDIZAJE BASADO EN PROYECTOS INFANTIL P...   \n",
       "1             1  ABP APRENDIZAJE BASADO EN PROYECTOS SECUNDARIA...   \n",
       "2             2                              AJEDREZ EN LA ESCUELA   \n",
       "3             3   ALIMENTACIÓN Y NUTRICIÓN PARA UNA VIDA SALUDABLE   \n",
       "4             4                                       APP INVENTOR   \n",
       "..          ...                                                ...   \n",
       "171         171  COMPETENCIA DIGITAL DOCENTE Nivel A2: Iniciaci...   \n",
       "172         172                                    AULA DEL FUTURO   \n",
       "173         173             Del currículo a la práctica en el aula   \n",
       "174         174  Situaciones de aprendizaje para el desarrollo ...   \n",
       "175         175  Evaluación de competencias a través del desempeño   \n",
       "\n",
       "                                           Descripción  \\\n",
       "0    Frente a la enseñanza directa, la enseñanza ba...   \n",
       "1    Frente a la enseñanza directa, la enseñanza ba...   \n",
       "2    Este curso está destinado a todos aquellos que...   \n",
       "3    La educación en nutrición, ha sido reconocida ...   \n",
       "4    Crea tus primeras apps en Android fácilmente u...   \n",
       "..                                                 ...   \n",
       "171                                                NaN   \n",
       "172                                                NaN   \n",
       "173                                                NaN   \n",
       "174                                                NaN   \n",
       "175                                                NaN   \n",
       "\n",
       "                                             Objetivos  \\\n",
       "0    * Analizar los principios de la enseñanza basa...   \n",
       "1    * Analizar los principios de la enseñanza basa...   \n",
       "2                                                  NaN   \n",
       "3    * Contribuir a la prevención y control de los ...   \n",
       "4    * Introducir al docente en el mundo de la prog...   \n",
       "..                                                 ...   \n",
       "171                                                NaN   \n",
       "172  • Fomentar la reflexión para crear una visión ...   \n",
       "173  • Presentar y conocer los objetivos, principio...   \n",
       "174  • Alinear los retos educativos del siglo XXI c...   \n",
       "175                                                NaN   \n",
       "\n",
       "                                            Contenidos  \\\n",
       "0    Definición de ABP. El ABP paso a paso. Apertur...   \n",
       "1    Definición de ABP. El ABP paso a paso. Apertur...   \n",
       "2    METODOLOGÍA Pensando por nosotros mismos Princ...   \n",
       "3    Alimentos y nutrientes. El placer de comer y c...   \n",
       "4    Módulo 1. Primer contacto - un pequeño program...   \n",
       "..                                                 ...   \n",
       "171                                                NaN   \n",
       "172  • Módulo 1: Identificar las Partes Interesadas...   \n",
       "173  • Bloque 1:  Contexto, fundamento y caracterís...   \n",
       "174  • Bloque 1. Las Competencias clave en el marco...   \n",
       "175  • Bloque 1. ¿Qué es evaluar? Conceptos básicos...   \n",
       "\n",
       "                    Etiquetas                                       Libros  \\\n",
       "0                Metodologías                                          abp   \n",
       "1                Metodologías                                          abp   \n",
       "2                       Otros                        ajedrez-en-la-escuela   \n",
       "3           Salud y bienestar                                 alimentacion   \n",
       "4          STEAM/Programación  https://libros.catedu.es/books/app-inventor   \n",
       "..                        ...                                          ...   \n",
       "171  Acreditacion niveles CDD                                          NaN   \n",
       "172              Metodologías                                          NaN   \n",
       "173       Normativa Educativa                                          NaN   \n",
       "174       Normativa Educativa                                          NaN   \n",
       "175       Normativa Educativa                                          NaN   \n",
       "\n",
       "                                           Moodle_url  \\\n",
       "0      https://moodle.catedu.es/course/view.php?id=79   \n",
       "1      https://moodle.catedu.es/course/view.php?id=78   \n",
       "2     https://moodle.catedu.es/course/view.php?id=479   \n",
       "3      https://moodle.catedu.es/course/view.php?id=77   \n",
       "4      https://moodle.catedu.es/course/view.php?id=38   \n",
       "..                                                ...   \n",
       "171                                               NaN   \n",
       "172  https://moodle.catedu.es/course/view.php?id=1260   \n",
       "173  https://moodle.catedu.es/course/view.php?id=1259   \n",
       "174  https://moodle.catedu.es/course/view.php?id=1258   \n",
       "175  https://moodle.catedu.es/course/view.php?id=1257   \n",
       "\n",
       "                                               Portada  Horas  \n",
       "0    https://moodle.catedu.es/pluginfile.php/5878/c...   50.0  \n",
       "1    https://moodle.catedu.es/pluginfile.php/5822/c...   50.0  \n",
       "2    https://moodle.catedu.es/pluginfile.php/85386/...   20.0  \n",
       "3    https://moodle.catedu.es/pluginfile.php/5737/c...   50.0  \n",
       "4    https://moodle.catedu.es/pluginfile.php/1224/c...   10.0  \n",
       "..                                                 ...    ...  \n",
       "171                                                NaN   50.0  \n",
       "172  https://moodle.catedu.es/pluginfile.php/173985...   50.0  \n",
       "173  https://moodle.catedu.es/pluginfile.php/173916...   35.0  \n",
       "174  https://moodle.catedu.es/pluginfile.php/173847...   35.0  \n",
       "175  https://moodle.catedu.es/pluginfile.php/173784...   35.0  \n",
       "\n",
       "[176 rows x 10 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "# make an html table for every row in a pandas dataframe adding the column name\n",
    "df1 = df.astype(str)\n",
    "df1[\"tables\"] = df1.filter(regex=\"\\d\\.\\d\").apply(lambda x: f\"|{'|'.join(x.index)}|||{':---:|'*len(x.values)}|{'|'.join(x.values)}|\", axis=1).str.replace(\"nan\", \"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'|1.1|1.2|1.3|1.4|1.5|2.1|2.2|2.3|3.1|3.2|3.3|3.4|4.1|4.2|4.3|5.1|5.2|5.3|6.1|6.2|6.3|6.4|6.5|||:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:||B1|A2|B1|B1|B1||B1||B1||B1||||||B1|B1|||||B1|'"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1[\"tables\"][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.10.4 64-bit ('3.10.4')",
   "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.10.4"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "99c4d5859fdca3000443108d72cff8cf580070d2049d79c7c676512066dcea5e"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}