demo/aurehal_struct_noise_per_institution.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "1d73a672",
   "metadata": {},
   "source": [
    "# Niveau de bruit des établissements dans le référentiel des structures de HAL"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9df34ed8",
   "metadata": {},
   "source": [
    "objectif : produire un tableau avec les colonnes suivantes : nom de portail, nb structure, % de bruit\n",
    "\n",
    "1. obtenir un tableau de tous les portails\n",
    "\n",
    "\n",
    "2. réduire aux portails institutionnels\n",
    "\n",
    "\n",
    "3. trouver les structId des portails identifiés\n",
    "    - explorer l'API AureHal Structure pour avoir l'id des établissements à partir d'une requête par nom\n",
    "    - créer une fonction qui donne à partir du nom de l'établissement leur id\n",
    "    - ajouter au tableau des établissements une colonne avec leur id\n",
    "\n",
    "\n",
    "4. pour chaque portail identifié extraire nb structure valide, non valide, % bruit \n",
    "    - créer une fonction qui donne : nb structure valide et non valide à partir d'un structId\n",
    "    - ajouter les champs nb_struct_valid et nb_struct_no_valid au tableau des établissements\n",
    "\n",
    "\n",
    "5. calculer le pourcetange de bruit et l'intégrer au tableau\n",
    "\n",
    "\n",
    "6. retirer les etab où nous n'avons pas de structure valide, trier par noise en décroissant"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "37d7723a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd, json, requests"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "afe59a66",
   "metadata": {},
   "source": [
    "## 1. Obtenir la liste des portails HAL"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "94da9854",
   "metadata": {},
   "source": [
    "charger la liste des portails  https://api.archives-ouvertes.fr/docs/ref/resource/instance"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "846d4876",
   "metadata": {},
   "outputs": [],
   "source": [
    "# récupérer les infos de tous les portails\n",
    "raw = requests.get(\"https://api.archives-ouvertes.fr/ref/instance\").json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "bd61bcea",
   "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>id</th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>40</td>\n",
       "      <td>unilim</td>\n",
       "      <td>Université de Limoges</td>\n",
       "      <td>https://hal-unilim.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>15</td>\n",
       "      <td>lirmm</td>\n",
       "      <td>LIRMM - Laboratoire d’Informatique, de Robotiq...</td>\n",
       "      <td>https://hal-lirmm.ccsd.cnrs.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>27</td>\n",
       "      <td>insu</td>\n",
       "      <td>INSU - Institut national des sciences de l'Uni...</td>\n",
       "      <td>https://hal-insu.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    id    code                                               name  \\\n",
       "37  40  unilim                              Université de Limoges   \n",
       "13  15   lirmm  LIRMM - Laboratoire d’Informatique, de Robotiq...   \n",
       "24  27    insu  INSU - Institut national des sciences de l'Uni...   \n",
       "\n",
       "                                        url  \n",
       "37  https://hal-unilim.archives-ouvertes.fr  \n",
       "13           https://hal-lirmm.ccsd.cnrs.fr  \n",
       "24    https://hal-insu.archives-ouvertes.fr  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# les placer dans une dataframe\n",
    "portails = pd.DataFrame(raw['response']['docs'])\n",
    "portails.sample(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "694714b7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "nb de portails 187\n"
     ]
    }
   ],
   "source": [
    "print(f\"nb de portails {len(portails)}\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "245e02a2",
   "metadata": {},
   "source": [
    "## 2. Réduire aux protails institutionnels"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4935f35e",
   "metadata": {},
   "source": [
    "étape semi automatique qui se fait cycliquement en constatant ce qui est pris ou non par le filtre"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "1a265a2f",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# une option pour afficher toutes les rows de la dataframe\n",
    "pd.set_option('display.max_rows', None) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "e9b63ea1",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " nb de portails institutionnels repérés 157\n"
     ]
    }
   ],
   "source": [
    "# filtrer sur les portails des institutions\n",
    "filtre_name = portails[\"name\"].str.contains(\n",
    "    \"univ|ecole|école|inst|inria|inserm|cea|supelec|agro|cnam|enssib|ENS|CIrad|Observatoire|\\\n",
    "    |INSA|MNHN|inshea|lyon|MINES|HEC|rouen|Sciences Po|BRGM|ESSEC|ESPCI|Chimie ParisTech|nationale de France|Audencia|CSTB|\\\n",
    "    |onera|PSE|Rennes Business School|CentraleSupélec|NEOMA|EDF|IMT Atlantique|Télécom Paris|\\\n",
    "    |Centre national de la recherche scientifique|CHU|Collège de France|Kedge|isara|Météo\",\n",
    "case = False, regex=True)\n",
    "\n",
    "portail_etab = portails[filtre_name].sort_values(by = \"name\")\n",
    "\n",
    "print(f\" nb de portails institutionnels repérés {len(portail_etab)}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "fff7600b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " nb de portails institutionnels repérés 152\n"
     ]
    }
   ],
   "source": [
    "# retirer les faux positifs récupérés par le filtre : afrique, dumas, hceres, jeannicod, riip\n",
    "faux_positif = portail_etab[ portail_etab[\"code\"].isin([\"afrique\", \"dumas\", \"hceres\", \"jeannicod\", \"riip\"])].index\n",
    "portail_etab.drop(faux_positif, inplace = True)\n",
    "print(f\" nb de portails institutionnels repérés {len(portail_etab)}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "6874396f",
   "metadata": {
    "scrolled": true
   },
   "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>id</th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9</td>\n",
       "      <td>tel</td>\n",
       "      <td>TEL - Thèses en ligne</td>\n",
       "      <td>https://tel.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>hal</td>\n",
       "      <td>Archive ouverte HAL</td>\n",
       "      <td>https://hal.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>13</td>\n",
       "      <td>archivesic</td>\n",
       "      <td>@rchiveSIC</td>\n",
       "      <td>https://archivesic.ccsd.cnrs.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10</td>\n",
       "      <td>jeannicod</td>\n",
       "      <td>Institut | Nicod</td>\n",
       "      <td>https://jeannicod.ccsd.cnrs.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>tematice</td>\n",
       "      <td>archive-EduTice - Education et technologies de...</td>\n",
       "      <td>https://edutice.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>44</td>\n",
       "      <td>memsic</td>\n",
       "      <td>memSIC -  mémoires de master en Sciences de l'...</td>\n",
       "      <td>https://memsic.ccsd.cnrs.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>7</td>\n",
       "      <td>halshs</td>\n",
       "      <td>HAL-SHS - Sciences de l'Homme et de la Société</td>\n",
       "      <td>https://halshs.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>8</td>\n",
       "      <td>artxiker</td>\n",
       "      <td>Artxiker</td>\n",
       "      <td>https://artxiker.ccsd.cnrs.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>15</td>\n",
       "      <td>lirmm</td>\n",
       "      <td>LIRMM - Laboratoire d’Informatique, de Robotiq...</td>\n",
       "      <td>https://hal-lirmm.ccsd.cnrs.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>16</td>\n",
       "      <td>cel</td>\n",
       "      <td>CEL - Cours en ligne</td>\n",
       "      <td>https://cel.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>23</td>\n",
       "      <td>bioemco</td>\n",
       "      <td>Bioemco</td>\n",
       "      <td>https://hal-bioemco.ccsd.cnrs.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>24</td>\n",
       "      <td>haledd</td>\n",
       "      <td>HAL-SDE - Sciences de l'environnement</td>\n",
       "      <td>https://hal-sde.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>28</td>\n",
       "      <td>ssa</td>\n",
       "      <td>SSA - Service de santé des armées</td>\n",
       "      <td>https://hal-ssa.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>36</td>\n",
       "      <td>hprints</td>\n",
       "      <td>hprints.org</td>\n",
       "      <td>https://hal-hprints.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>37</td>\n",
       "      <td>sfo</td>\n",
       "      <td>SFO - La Société Française d'Optique</td>\n",
       "      <td>https://hal-sfo.ccsd.cnrs.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>39</td>\n",
       "      <td>dumas</td>\n",
       "      <td>DUMAS - Dépôt Universitaire de Mémoires Après ...</td>\n",
       "      <td>https://dumas.ccsd.cnrs.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>42</td>\n",
       "      <td>afssa</td>\n",
       "      <td>ANSES</td>\n",
       "      <td>https://hal-anses.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>52</td>\n",
       "      <td>confremo</td>\n",
       "      <td>CONFREMO - Conférence des Recteurs et Présiden...</td>\n",
       "      <td>https://hal-confremo.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>54</td>\n",
       "      <td>riip</td>\n",
       "      <td>RIIP - Réseau International des Instituts Pasteur</td>\n",
       "      <td>https://hal-riip.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>57</td>\n",
       "      <td>medihal</td>\n",
       "      <td>MédiHAL</td>\n",
       "      <td>https://medihal.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>68</td>\n",
       "      <td>pastel</td>\n",
       "      <td>PASTEL - Thèses en ligne de ParisTech</td>\n",
       "      <td>https://pastel.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>72</td>\n",
       "      <td>telearn</td>\n",
       "      <td>TeLearn</td>\n",
       "      <td>https://telearn.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>75</td>\n",
       "      <td>pjse</td>\n",
       "      <td>Paris-Jourdan Sciences Économiques</td>\n",
       "      <td>https://hal-pjse.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>87</td>\n",
       "      <td>ifp</td>\n",
       "      <td>IFP Energies nouvelles</td>\n",
       "      <td>https://hal-ifp.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>92</td>\n",
       "      <td>afrique</td>\n",
       "      <td>Agence universitaire de la Francophonie</td>\n",
       "      <td>https://hal-auf.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>4204</td>\n",
       "      <td>lara</td>\n",
       "      <td>LARA - Libre accès aux rapports scientifiques ...</td>\n",
       "      <td>https://hal-lara.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>4602</td>\n",
       "      <td>laas</td>\n",
       "      <td>LAAS - Laboratoire d'Analyse et d'Architecture...</td>\n",
       "      <td>https://hal.laas.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>4604</td>\n",
       "      <td>campusaar</td>\n",
       "      <td>Campus AAR</td>\n",
       "      <td>https://hal.campus-aar.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>5044</td>\n",
       "      <td>aurehal</td>\n",
       "      <td>aurehal</td>\n",
       "      <td>https://aurehal.archives-ouvertes.fr/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>5408</td>\n",
       "      <td>hceres</td>\n",
       "      <td>Haut Conseil de l’évaluation de la recherche e...</td>\n",
       "      <td>https://hal-hceres.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>6225</td>\n",
       "      <td>rnmsh</td>\n",
       "      <td>Réseau National des Maisons des Sciences de l'...</td>\n",
       "      <td>https://hal-rnmsh.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>7313</td>\n",
       "      <td>ciheam-iamm</td>\n",
       "      <td>CIHEAM Montpellier</td>\n",
       "      <td>https://hal-ciheam.iamm.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>8327</td>\n",
       "      <td>cv</td>\n",
       "      <td>CV</td>\n",
       "      <td>https://cv.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>8449</td>\n",
       "      <td>anr</td>\n",
       "      <td>Portail HAL-ANR</td>\n",
       "      <td>https://hal-anr.archives-ouvertes.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>9801</td>\n",
       "      <td>ifip</td>\n",
       "      <td>IFIP Open Digital Library</td>\n",
       "      <td>https://ifip.hal.science</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       id         code                                               name  \\\n",
       "0       9          tel                              TEL - Thèses en ligne   \n",
       "1       1          hal                                Archive ouverte HAL   \n",
       "2      13   archivesic                                         @rchiveSIC   \n",
       "3      10    jeannicod                                   Institut | Nicod   \n",
       "4       5     tematice  archive-EduTice - Education et technologies de...   \n",
       "5      44       memsic  memSIC -  mémoires de master en Sciences de l'...   \n",
       "8       7       halshs     HAL-SHS - Sciences de l'Homme et de la Société   \n",
       "9       8     artxiker                                           Artxiker   \n",
       "13     15        lirmm  LIRMM - Laboratoire d’Informatique, de Robotiq...   \n",
       "14     16          cel                               CEL - Cours en ligne   \n",
       "20     23      bioemco                                            Bioemco   \n",
       "21     24       haledd              HAL-SDE - Sciences de l'environnement   \n",
       "25     28          ssa                  SSA - Service de santé des armées   \n",
       "33     36      hprints                                        hprints.org   \n",
       "34     37          sfo               SFO - La Société Française d'Optique   \n",
       "36     39        dumas  DUMAS - Dépôt Universitaire de Mémoires Après ...   \n",
       "38     42        afssa                                              ANSES   \n",
       "46     52     confremo  CONFREMO - Conférence des Recteurs et Présiden...   \n",
       "48     54         riip  RIIP - Réseau International des Instituts Pasteur   \n",
       "51     57      medihal                                            MédiHAL   \n",
       "60     68       pastel              PASTEL - Thèses en ligne de ParisTech   \n",
       "65     72      telearn                                            TeLearn   \n",
       "68     75         pjse                 Paris-Jourdan Sciences Économiques   \n",
       "80     87          ifp                             IFP Energies nouvelles   \n",
       "89     92      afrique            Agence universitaire de la Francophonie   \n",
       "117  4204         lara  LARA - Libre accès aux rapports scientifiques ...   \n",
       "119  4602         laas  LAAS - Laboratoire d'Analyse et d'Architecture...   \n",
       "120  4604    campusaar                                         Campus AAR   \n",
       "126  5044      aurehal                                            aurehal   \n",
       "131  5408       hceres  Haut Conseil de l’évaluation de la recherche e...   \n",
       "145  6225        rnmsh  Réseau National des Maisons des Sciences de l'...   \n",
       "158  7313  ciheam-iamm                                 CIHEAM Montpellier   \n",
       "173  8327           cv                                                 CV   \n",
       "176  8449          anr                                    Portail HAL-ANR   \n",
       "184  9801         ifip                          IFIP Open Digital Library   \n",
       "\n",
       "                                           url  \n",
       "0             https://tel.archives-ouvertes.fr  \n",
       "1             https://hal.archives-ouvertes.fr  \n",
       "2              https://archivesic.ccsd.cnrs.fr  \n",
       "3               https://jeannicod.ccsd.cnrs.fr  \n",
       "4         https://edutice.archives-ouvertes.fr  \n",
       "5                  https://memsic.ccsd.cnrs.fr  \n",
       "8          https://halshs.archives-ouvertes.fr  \n",
       "9                https://artxiker.ccsd.cnrs.fr  \n",
       "13              https://hal-lirmm.ccsd.cnrs.fr  \n",
       "14            https://cel.archives-ouvertes.fr  \n",
       "20            https://hal-bioemco.ccsd.cnrs.fr  \n",
       "21        https://hal-sde.archives-ouvertes.fr  \n",
       "25        https://hal-ssa.archives-ouvertes.fr  \n",
       "33    https://hal-hprints.archives-ouvertes.fr  \n",
       "34                https://hal-sfo.ccsd.cnrs.fr  \n",
       "36                  https://dumas.ccsd.cnrs.fr  \n",
       "38      https://hal-anses.archives-ouvertes.fr  \n",
       "46   https://hal-confremo.archives-ouvertes.fr  \n",
       "48       https://hal-riip.archives-ouvertes.fr  \n",
       "51        https://medihal.archives-ouvertes.fr  \n",
       "60         https://pastel.archives-ouvertes.fr  \n",
       "65        https://telearn.archives-ouvertes.fr  \n",
       "68       https://hal-pjse.archives-ouvertes.fr  \n",
       "80        https://hal-ifp.archives-ouvertes.fr  \n",
       "89        https://hal-auf.archives-ouvertes.fr  \n",
       "117      https://hal-lara.archives-ouvertes.fr  \n",
       "119                        https://hal.laas.fr  \n",
       "120                  https://hal.campus-aar.fr  \n",
       "126      https://aurehal.archives-ouvertes.fr/  \n",
       "131    https://hal-hceres.archives-ouvertes.fr  \n",
       "145     https://hal-rnmsh.archives-ouvertes.fr  \n",
       "158                 https://hal-ciheam.iamm.fr  \n",
       "173            https://cv.archives-ouvertes.fr  \n",
       "176       https://hal-anr.archives-ouvertes.fr  \n",
       "184                   https://ifip.hal.science  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## verifier la selection effectuée\n",
    "\n",
    "# ce qui n'est pas retenu\n",
    "portails[ ~portails[\"id\"].isin(portail_etab[\"id\"].tolist())]\n",
    "\n",
    "# ce qui est retenu\n",
    "#portail_etab\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3ef40e11",
   "metadata": {},
   "source": [
    "## 3. Trouver les `structId` des portails identifiés"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "527705e8",
   "metadata": {},
   "source": [
    "mémo documentation référentiel structure https://api.archives-ouvertes.fr/docs/ref/?resource=structure&schema=fields#fields"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "fd900fcf",
   "metadata": {},
   "outputs": [],
   "source": [
    "def find_portail_structId(name) : \n",
    "    \"\"\"\n",
    "    a partir du nom du portail retrouver le structId de l'établissement\n",
    "    ne pas recherche par sigle car ça engendre bcp de faux positif (eg CEA)\n",
    "    si aucun sutrcutId trouvé impression \"pb\" suivi du nom\n",
    "    \"\"\"\n",
    "    # utiliser name_t car insensible à la casse et accents\n",
    "    # memo : https://api.archives-ouvertes.fr/ref/structure/?fq=type_s:institution&q=(name_t:Institut Catholique de Paris)\n",
    "    # certains noms contiennent le sigle de l'établissement avant - (ICP - Institut Catholique de Paris)\n",
    "    \n",
    "    pre_url = \"https://api.archives-ouvertes.fr/ref/structure/?fq=type_s:institution&fq=valid_s:VALID\"\n",
    "        \n",
    "    req = requests.get( f\"{pre_url}&fq=name_t:\\\"{name}\\\"\" )\n",
    "    res = req.json()\n",
    "    try : \n",
    "        # retourner le docid et le label\n",
    "        return [ res[\"response\"][\"docs\"][0][\"docid\"], res[\"response\"][\"docs\"][0][\"label_s\"]]\n",
    "    except : \n",
    "        print(\"pb\", name)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "d433c490",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[300016,\n",
       " \"Commissariat à l'énergie atomique et aux énergies alternatives [CEA]\"]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# tester la fonction\n",
    "## non optimal on releve des pb, eg \"Université de Paris\", rattrapé à la main par la suite\n",
    "# pb aussi pour HEC qui va d'abord récupérer le HEC de montréal\n",
    "# pb sur les old new eg avec l'univ de Tours\n",
    "find_portail_structId(\"Commissariat à l’énergie atomique\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "7596d8b0",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "pb AgroSup Dijon\n",
      "pb Agrocampus Ouest\n",
      "pb BRGM - Bureau de Recherches Géologiques et Minières\n",
      "pb CEA - Commissariat à l’énergie atomique\n",
      "pb CHU de Clermont-Ferrand\n",
      "pb CSTB - Centre Scientifique et Technique du Bâtiment\n",
      "pb Cirad\n",
      "pb Cnam - Conservatoire national des arts et métiers\n",
      "pb EM-LYON Business School\n",
      "pb ENAC - Ecole Nationale de l'Aviation Civile\n",
      "pb ENS de Lyon\n",
      "pb ENSSIB\n",
      "pb ENSTA Bretagne\n",
      "pb ENSTA Paris\n",
      "pb EPHE - École pratique des hautes études\n",
      "pb ESPCI Paris\n",
      "pb ESSEC BusinessSchool\n",
      "pb Ecole Centrale Paris\n",
      "pb Groupe des Écoles Nationales d'Économie et Statistiques\n",
      "pb Hal Lumière Lyon2\n",
      "pb ICP - Institut Catholique de Paris\n",
      "pb IN2P3 - Institut national de physique nucléaire et de physique des particules\n",
      "pb INERIS - Institut National de l’EnviRonnement Industriel et des RisqueS\n",
      "pb INSA Lyon\n",
      "pb INSA Rennes\n",
      "pb INSA-Toulouse\n",
      "pb INSHEA\n",
      "pb INSU - Institut national des sciences de l'Univers\n",
      "pb IRD - Institut de recherche pour le développement\n",
      "pb IRSN - Institut de Radioprotection et de Sûreté Nucléaire\n",
      "pb Inalco - Institut National des Langues et Civilisations Orientales\n",
      "pb Inrap - Institut national de recherches archéologiques préventives\n",
      "pb Insep - Institut national du sport, de l'expertise et de la performance\n",
      "pb Institut National de Recherche en Agriculture, Alimentation et Environnement\n",
      "pb Institut Polytechnique de Paris\n",
      "pb MNHN - Muséum national d'Histoire naturelle\n",
      "pb Montpellier SupAgro\n",
      "pb Normandie Université\n",
      "pb ONERA - Office National d'Études et de Recherches Aérospatiales\n",
      "pb PSE - Paris School of Economics\n",
      "pb Rennes Business School\n",
      "pb Rouen Business School\n",
      "pb Sorbonne Université\n",
      "pb UFC - Université de Franche-Comté\n",
      "pb UJM - Université Jean Monnet\n",
      "pb USJ - Université Saint-Joseph de Beyrouth\n",
      "pb Université Bretagne Sud\n",
      "pb Université Clermont Auvergne\n",
      "pb Université Cote d'Azur\n",
      "pb Université Evry Val d’Essonne\n",
      "pb Université Francois Rabelais - Tours\n",
      "pb Université Grenoble Alpes\n",
      "pb Université Jean Moulin Lyon 3\n",
      "pb Université Lille 3 - Sciences Humaines et Sociales\n",
      "pb Université Paris Dauphine - Paris IX\n",
      "pb Université Paris Descartes\n",
      "pb Université Paris Diderot-Paris 7\n",
      "pb Université Paris Lumières\n",
      "pb Université Paris, Sciences & Lettres - PSL\n",
      "pb Université Paris-Est Marne-la-Vallée\n",
      "pb Université Paul Valéry Montpellier 3\n",
      "pb Université Polytechnique des Hauts-de-France\n",
      "pb Université Rennes 2\n",
      "pb Université d'Avignon et des Pays de Vaucluse\n",
      "pb Université de Bretagne Occidentale\n",
      "pb Université de Corse Pascal Paoli\n",
      "pb Université de La Rochelle\n",
      "pb Université de Lyon\n",
      "pb Université du Maine\n",
      "pb École Nationale vétérinaire d'Alfort\n",
      "pb École des Mines d'Alès\n",
      "pb École des Mines de Nantes\n",
      "pb École des Mines de Saint-Étienne\n"
     ]
    }
   ],
   "source": [
    "# appliquer la fonction sur tous les établissements\n",
    "portail_etab[[\"structId\", \"structId_name\"]] = portail_etab.apply(\n",
    "    lambda row : find_portail_structId(row[\"name\"]), axis = 1, result_type=\"expand\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "c12c83a2",
   "metadata": {},
   "outputs": [],
   "source": [
    "## extraire le tableau pour analyser le matching automatique\n",
    "portail_etab.sort_values(\"structId\", inplace = True)\n",
    "portail_etab.to_csv(\"verif-portail-list-match-structId.csv\", index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "2840f676",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Avec la fonction find_portail_structId\n",
      "structId trouvés pour 51.7 % des étab.\n"
     ]
    }
   ],
   "source": [
    "# calculer taux de détection de structId de porail\n",
    "print( f\"Avec la fonction find_portail_structId\\nstructId trouvés pour { round(len( portail_etab[ portail_etab['structId'].notna()] ) / len(portail_etab) * 100, 1) } % des étab.\") "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "6825b237",
   "metadata": {},
   "outputs": [],
   "source": [
    "## charger le matching manuel\n",
    "matching_manu = json.load(open(\"../data/2022-06-manually-match-portail-to-structId.json\", encoding='utf-8'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "1ee6e3f7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "nombre de mathcing effectués manuellement 94\n"
     ]
    }
   ],
   "source": [
    "# le matching manuel contient deux listes dont les clés sont les suivantes\n",
    "# portail_full_name_match_error & portail_full_name_no_match\n",
    "\n",
    "portail2structId = matching_manu[\"portail_full_name_match_error\"] \n",
    "portail2structId.update(matching_manu[\"portail_full_name_no_match\"])\n",
    "print(\"nombre de mathcing effectués manuellement\", len(portail2structId))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "86d32de2",
   "metadata": {},
   "outputs": [],
   "source": [
    "# ajouter/rectifier les données avec le matching manuel\n",
    "# si le nom de l'étab est dans le json alors écraser le structId sinon le conserver\n",
    "\n",
    "portail_etab[\"structId\"] = portail_etab.apply(\n",
    "lambda x : portail2structId[x[\"name\"]] if x[\"name\"] in portail2structId.keys() else x[\"structId\"], axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "51601a48",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Apres matching manuel\n",
      "structId trouvés pour 100.0  % des étab.\n"
     ]
    }
   ],
   "source": [
    "# calculer taux de détection de structId de porail\n",
    "print( f\"Apres matching manuel\\nstructId trouvés pour { round(len( portail_etab[ portail_etab['structId'].notna()] ) *100 / len(portail_etab), 0) }  % des étab.\") "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "8bfe41d3",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "nombre etablissement sans structId restant 0 \n",
      "\n",
      "nb etablissement total 151\n"
     ]
    }
   ],
   "source": [
    "print(f\"nombre etablissement sans structId restant {len( portail_etab[portail_etab['structId'].isna()]) }\", f\"\\n\\nnb etablissement total {len(portail_etab)}\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f7dd6cd1",
   "metadata": {},
   "source": [
    "## 4. Obtenir le nombre de structure par établissement"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "24bc9029",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_struct_nb(structId, valid):\n",
    "    \"\"\"\n",
    "    nombre de sous structures attachées à la structure parente\n",
    "    structId : l'id de la struct parente\n",
    "    valid si besoin  de filtrer par état (* pour tout inclure)\n",
    "    \"\"\"\n",
    "    # si l'établissement n'a pas de structId alors on ne le traite pas\n",
    "    if not pd.isna(structId) :  \n",
    "        url = \"https://api.archives-ouvertes.fr/ref/structure/?\"\n",
    "        req = requests.get(url+ f\"&q=parentDocid_i:{int(structId)}&fq=valid_s:{valid}&rows=0\")\n",
    "        req = req.json()\n",
    "        return req[\"response\"][\"numFound\"]    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "20bca4d6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "29"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# test de la foncion\n",
    "get_struct_nb(172265,\"VALID\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ccb980f0",
   "metadata": {},
   "source": [
    "* Ajouter nb structure total de l'établissement et nb structure incoming"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "cec0e371",
   "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>id</th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>url</th>\n",
       "      <th>structId</th>\n",
       "      <th>structId_name</th>\n",
       "      <th>nb_struct</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>99</td>\n",
       "      <td>icp</td>\n",
       "      <td>ICP - Institut Catholique de Paris</td>\n",
       "      <td>https://hal-icp.archives-ouvertes.fr</td>\n",
       "      <td>301937.0</td>\n",
       "      <td>None</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>33</td>\n",
       "      <td>paris1</td>\n",
       "      <td>Université Paris 1 Panthéon-Sorbonne</td>\n",
       "      <td>https://hal-paris1.archives-ouvertes.fr</td>\n",
       "      <td>7550.0</td>\n",
       "      <td>Université Paris 1 Panthéon-Sorbonne [UP1]</td>\n",
       "      <td>228</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    id    code                                  name  \\\n",
       "92  99     icp    ICP - Institut Catholique de Paris   \n",
       "30  33  paris1  Université Paris 1 Panthéon-Sorbonne   \n",
       "\n",
       "                                        url  structId  \\\n",
       "92     https://hal-icp.archives-ouvertes.fr  301937.0   \n",
       "30  https://hal-paris1.archives-ouvertes.fr    7550.0   \n",
       "\n",
       "                                 structId_name  nb_struct  \n",
       "92                                        None          8  \n",
       "30  Université Paris 1 Panthéon-Sorbonne [UP1]        228  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "portail_etab[\"nb_struct\"] = portail_etab.apply(lambda row : get_struct_nb(row['structId'], \"*\"), axis = 1)\n",
    "portail_etab.sample(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "62cf4d53",
   "metadata": {},
   "outputs": [],
   "source": [
    "portail_etab[\"nb_struct_incoming\"] = portail_etab.apply(lambda row : get_struct_nb(row['structId'], \"INCOMING\"), axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "4835f158",
   "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>id</th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>url</th>\n",
       "      <th>structId</th>\n",
       "      <th>structId_name</th>\n",
       "      <th>nb_struct</th>\n",
       "      <th>nb_struct_incoming</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>5385</td>\n",
       "      <td>ehesp</td>\n",
       "      <td>Ecole des hautes études en santé publique</td>\n",
       "      <td>https://hal.ehesp.fr</td>\n",
       "      <td>301986.0</td>\n",
       "      <td>École des Hautes Études en Santé Publique [EHE...</td>\n",
       "      <td>36</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>7802</td>\n",
       "      <td>ip-paris</td>\n",
       "      <td>Institut Polytechnique de Paris</td>\n",
       "      <td>https://hal-ip-paris.archives-ouvertes.fr</td>\n",
       "      <td>563936.0</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       id      code                                       name  \\\n",
       "130  5385     ehesp  Ecole des hautes études en santé publique   \n",
       "167  7802  ip-paris            Institut Polytechnique de Paris   \n",
       "\n",
       "                                           url  structId  \\\n",
       "130                       https://hal.ehesp.fr  301986.0   \n",
       "167  https://hal-ip-paris.archives-ouvertes.fr  563936.0   \n",
       "\n",
       "                                         structId_name  nb_struct  \\\n",
       "130  École des Hautes Études en Santé Publique [EHE...         36   \n",
       "167                                               None          0   \n",
       "\n",
       "     nb_struct_incoming  \n",
       "130                  14  \n",
       "167                   0  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "portail_etab.sample(2)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "61261db6",
   "metadata": {},
   "source": [
    "* Calculer le pourcentage de bruit et l'intégrer au tableau"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "ab130fdb",
   "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>id</th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>url</th>\n",
       "      <th>structId</th>\n",
       "      <th>structId_name</th>\n",
       "      <th>nb_struct</th>\n",
       "      <th>nb_struct_incoming</th>\n",
       "      <th>noise</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>5241</td>\n",
       "      <td>univ-rennes2</td>\n",
       "      <td>Université Rennes 2</td>\n",
       "      <td>https://hal.univ-rennes2.fr</td>\n",
       "      <td>406201.0</td>\n",
       "      <td>None</td>\n",
       "      <td>132</td>\n",
       "      <td>14</td>\n",
       "      <td>0.106061</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       id          code                 name                          url  \\\n",
       "127  5241  univ-rennes2  Université Rennes 2  https://hal.univ-rennes2.fr   \n",
       "\n",
       "     structId structId_name  nb_struct  nb_struct_incoming     noise  \n",
       "127  406201.0          None        132                  14  0.106061  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "portail_etab[\"noise\"] = portail_etab[\"nb_struct_incoming\"] / portail_etab[\"nb_struct\"]\n",
    "portail_etab.sample(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "4cec4f03",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "nb d'établissement 151\n"
     ]
    }
   ],
   "source": [
    "print(\"nb d'établissement\", len(portail_etab))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b109ab66",
   "metadata": {},
   "source": [
    "* Nettoyer le tableau et afficher le classement"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "8b32718c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Après nettoyage nb d'établissement 151\n"
     ]
    }
   ],
   "source": [
    "# retrait des lignes sans données pour nb_struct et noise\n",
    "portail_noise = portail_etab[ \n",
    "    (portail_etab[\"nb_struct\"].notna()) & \n",
    "    (portail_etab[\"noise\"].notna()) \n",
    "]\n",
    "print(\"Après nettoyage nb d'établissement\", len(portail_etab))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "db2d296e",
   "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>id</th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>url</th>\n",
       "      <th>structId</th>\n",
       "      <th>structId_name</th>\n",
       "      <th>nb_struct</th>\n",
       "      <th>nb_struct_incoming</th>\n",
       "      <th>noise</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>29</td>\n",
       "      <td>irsn</td>\n",
       "      <td>IRSN - Institut de Radioprotection et de Sûret...</td>\n",
       "      <td>https://hal-irsn.archives-ouvertes.fr</td>\n",
       "      <td>300040.0</td>\n",
       "      <td>None</td>\n",
       "      <td>280</td>\n",
       "      <td>249</td>\n",
       "      <td>0.889286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>71</td>\n",
       "      <td>hcl</td>\n",
       "      <td>Hospices Civils de Lyon</td>\n",
       "      <td>https://hal-hcl.archives-ouvertes.fr</td>\n",
       "      <td>300074.0</td>\n",
       "      <td>Hospices Civils de Lyon, Departement de Neurol...</td>\n",
       "      <td>478</td>\n",
       "      <td>421</td>\n",
       "      <td>0.880753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>25</td>\n",
       "      <td>ineris</td>\n",
       "      <td>INERIS - Institut National de l’EnviRonnement ...</td>\n",
       "      <td>https://hal-ineris.archives-ouvertes.fr</td>\n",
       "      <td>3186.0</td>\n",
       "      <td>None</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>0.857143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>5836</td>\n",
       "      <td>edf</td>\n",
       "      <td>EDF</td>\n",
       "      <td>https://hal-edf.archives-ouvertes.fr</td>\n",
       "      <td>302313.0</td>\n",
       "      <td>EDF [EDF]</td>\n",
       "      <td>74</td>\n",
       "      <td>56</td>\n",
       "      <td>0.756757</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>6616</td>\n",
       "      <td>em-lyon</td>\n",
       "      <td>EM-LYON Business School</td>\n",
       "      <td>https://hal.em-lyon.com</td>\n",
       "      <td>301362.0</td>\n",
       "      <td>None</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>99</td>\n",
       "      <td>icp</td>\n",
       "      <td>ICP - Institut Catholique de Paris</td>\n",
       "      <td>https://hal-icp.archives-ouvertes.fr</td>\n",
       "      <td>301937.0</td>\n",
       "      <td>None</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>0.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>7468</td>\n",
       "      <td>enva</td>\n",
       "      <td>École Nationale vétérinaire d'Alfort</td>\n",
       "      <td>https://hal-enva.archives-ouvertes.fr</td>\n",
       "      <td>34256.0</td>\n",
       "      <td>None</td>\n",
       "      <td>104</td>\n",
       "      <td>76</td>\n",
       "      <td>0.730769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>104</td>\n",
       "      <td>pse</td>\n",
       "      <td>PSE - Paris School of Economics</td>\n",
       "      <td>https://hal-pse.archives-ouvertes.fr</td>\n",
       "      <td>301309.0</td>\n",
       "      <td>None</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>0.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>74</td>\n",
       "      <td>essec</td>\n",
       "      <td>ESSEC BusinessSchool</td>\n",
       "      <td>https://hal-essec.archives-ouvertes.fr</td>\n",
       "      <td>301020.0</td>\n",
       "      <td>None</td>\n",
       "      <td>24</td>\n",
       "      <td>16</td>\n",
       "      <td>0.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>88</td>\n",
       "      <td>univ-corse</td>\n",
       "      <td>Université de Corse Pascal Paoli</td>\n",
       "      <td>https://hal-univ-corse.archives-ouvertes.fr</td>\n",
       "      <td>508779.0</td>\n",
       "      <td>None</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>18</td>\n",
       "      <td>emse</td>\n",
       "      <td>École des Mines de Saint-Étienne</td>\n",
       "      <td>https://hal-emse.ccsd.cnrs.fr</td>\n",
       "      <td>359750.0</td>\n",
       "      <td>None</td>\n",
       "      <td>14</td>\n",
       "      <td>9</td>\n",
       "      <td>0.642857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>4025</td>\n",
       "      <td>univ-paris-dauphine</td>\n",
       "      <td>Université Paris Dauphine - Paris IX</td>\n",
       "      <td>https://hal-univ-paris-dauphine.archives-ouver...</td>\n",
       "      <td>300302.0</td>\n",
       "      <td>None</td>\n",
       "      <td>55</td>\n",
       "      <td>35</td>\n",
       "      <td>0.636364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>58</td>\n",
       "      <td>hec</td>\n",
       "      <td>HEC</td>\n",
       "      <td>https://hal-hec.archives-ouvertes.fr</td>\n",
       "      <td>105633.0</td>\n",
       "      <td>Faculté des Hautes Etudes Commerciales (HEC La...</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>0.625000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>3776</td>\n",
       "      <td>usj</td>\n",
       "      <td>USJ - Université Saint-Joseph de Beyrouth</td>\n",
       "      <td>https://hal-usj.archives-ouvertes.fr</td>\n",
       "      <td>301405.0</td>\n",
       "      <td>None</td>\n",
       "      <td>97</td>\n",
       "      <td>59</td>\n",
       "      <td>0.608247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>32</td>\n",
       "      <td>descartes</td>\n",
       "      <td>Université Paris Descartes</td>\n",
       "      <td>https://hal-descartes.archives-ouvertes.fr</td>\n",
       "      <td>301664.0</td>\n",
       "      <td>None</td>\n",
       "      <td>704</td>\n",
       "      <td>411</td>\n",
       "      <td>0.583807</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>49</td>\n",
       "      <td>univ-nantes</td>\n",
       "      <td>Université de Nantes</td>\n",
       "      <td>http://hal.univ-nantes.fr</td>\n",
       "      <td>93263.0</td>\n",
       "      <td>Institut de Recherche en Santé de l'Université...</td>\n",
       "      <td>263</td>\n",
       "      <td>148</td>\n",
       "      <td>0.562738</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>90</td>\n",
       "      <td>agrocampus-ouest</td>\n",
       "      <td>Agrocampus Ouest</td>\n",
       "      <td>https://hal-agrocampus-ouest.archives-ouvertes.fr</td>\n",
       "      <td>108028.0</td>\n",
       "      <td>None</td>\n",
       "      <td>94</td>\n",
       "      <td>52</td>\n",
       "      <td>0.553191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>45</td>\n",
       "      <td>univ-diderot</td>\n",
       "      <td>Université Paris Diderot-Paris 7</td>\n",
       "      <td>https://hal-univ-diderot.archives-ouvertes.fr</td>\n",
       "      <td>300301.0</td>\n",
       "      <td>None</td>\n",
       "      <td>869</td>\n",
       "      <td>476</td>\n",
       "      <td>0.547756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>5303</td>\n",
       "      <td>udl</td>\n",
       "      <td>Université de Lyon</td>\n",
       "      <td>https://hal-udl.archives-ouvertes.fr</td>\n",
       "      <td>301088.0</td>\n",
       "      <td>None</td>\n",
       "      <td>107</td>\n",
       "      <td>57</td>\n",
       "      <td>0.532710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>7264</td>\n",
       "      <td>univ-angers</td>\n",
       "      <td>Université d'Angers</td>\n",
       "      <td>https://hal.univ-angers.fr</td>\n",
       "      <td>74911.0</td>\n",
       "      <td>Université d'Angers [UA]</td>\n",
       "      <td>233</td>\n",
       "      <td>117</td>\n",
       "      <td>0.502146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>84</td>\n",
       "      <td>em-normandie</td>\n",
       "      <td>Ecole de Management de Normandie</td>\n",
       "      <td>https://hal-em-normandie.archives-ouvertes.fr</td>\n",
       "      <td>301735.0</td>\n",
       "      <td>École de Management de Normandie [EM Normandie]</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>91</td>\n",
       "      <td>univ-rennes1</td>\n",
       "      <td>Université de Rennes 1</td>\n",
       "      <td>https://hal-univ-rennes1.archives-ouvertes.fr</td>\n",
       "      <td>105160.0</td>\n",
       "      <td>Université de Rennes 1 [UR1]</td>\n",
       "      <td>396</td>\n",
       "      <td>187</td>\n",
       "      <td>0.472222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>19</td>\n",
       "      <td>ird</td>\n",
       "      <td>IRD - Institut de recherche pour le développement</td>\n",
       "      <td>https://hal.ird.fr</td>\n",
       "      <td>67872.0</td>\n",
       "      <td>None</td>\n",
       "      <td>240</td>\n",
       "      <td>112</td>\n",
       "      <td>0.466667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>26</td>\n",
       "      <td>cea</td>\n",
       "      <td>CEA - Commissariat à l’énergie atomique</td>\n",
       "      <td>https://hal-cea.archives-ouvertes.fr</td>\n",
       "      <td>300016.0</td>\n",
       "      <td>None</td>\n",
       "      <td>830</td>\n",
       "      <td>381</td>\n",
       "      <td>0.459036</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>7580</td>\n",
       "      <td>u-pec</td>\n",
       "      <td>Université Paris-Est Créteil Val-de-Marne</td>\n",
       "      <td>https://hal.u-pec.fr/</td>\n",
       "      <td>420786.0</td>\n",
       "      <td>Université Paris-Est Créteil Val-de-Marne - Pa...</td>\n",
       "      <td>313</td>\n",
       "      <td>143</td>\n",
       "      <td>0.456869</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>80</td>\n",
       "      <td>univ-mlv</td>\n",
       "      <td>Université Paris-Est Marne-la-Vallée</td>\n",
       "      <td>https://hal-upec-upem.archives-ouvertes.fr</td>\n",
       "      <td>301243.0</td>\n",
       "      <td>None</td>\n",
       "      <td>63</td>\n",
       "      <td>28</td>\n",
       "      <td>0.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>38</td>\n",
       "      <td>univ-brest</td>\n",
       "      <td>Université de Bretagne Occidentale</td>\n",
       "      <td>https://hal.univ-brest.fr</td>\n",
       "      <td>300314.0</td>\n",
       "      <td>None</td>\n",
       "      <td>259</td>\n",
       "      <td>114</td>\n",
       "      <td>0.440154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>55</td>\n",
       "      <td>univ-paris13</td>\n",
       "      <td>Université Paris 13</td>\n",
       "      <td>https://hal-univ-paris13.archives-ouvertes.fr</td>\n",
       "      <td>15786.0</td>\n",
       "      <td>Université Paris 13 [UP13]</td>\n",
       "      <td>172</td>\n",
       "      <td>70</td>\n",
       "      <td>0.406977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>65</td>\n",
       "      <td>brgm</td>\n",
       "      <td>BRGM - Bureau de Recherches Géologiques et Min...</td>\n",
       "      <td>https://hal-brgm.archives-ouvertes.fr</td>\n",
       "      <td>18404.0</td>\n",
       "      <td>None</td>\n",
       "      <td>25</td>\n",
       "      <td>10</td>\n",
       "      <td>0.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>103</td>\n",
       "      <td>univ-tours</td>\n",
       "      <td>Université Francois Rabelais - Tours</td>\n",
       "      <td>https://hal-univ-tours.archives-ouvertes.fr</td>\n",
       "      <td>300298.0</td>\n",
       "      <td>None</td>\n",
       "      <td>164</td>\n",
       "      <td>64</td>\n",
       "      <td>0.390244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>5385</td>\n",
       "      <td>ehesp</td>\n",
       "      <td>Ecole des hautes études en santé publique</td>\n",
       "      <td>https://hal.ehesp.fr</td>\n",
       "      <td>301986.0</td>\n",
       "      <td>École des Hautes Études en Santé Publique [EHE...</td>\n",
       "      <td>36</td>\n",
       "      <td>14</td>\n",
       "      <td>0.388889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>3681</td>\n",
       "      <td>univ-fcomte</td>\n",
       "      <td>UFC - Université de Franche-Comté</td>\n",
       "      <td>https://hal-univ-fcomte.archives-ouvertes.fr</td>\n",
       "      <td>458810.0</td>\n",
       "      <td>None</td>\n",
       "      <td>204</td>\n",
       "      <td>79</td>\n",
       "      <td>0.387255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>ujm</td>\n",
       "      <td>UJM - Université Jean Monnet</td>\n",
       "      <td>https://hal-ujm.archives-ouvertes.fr</td>\n",
       "      <td>300284.0</td>\n",
       "      <td>None</td>\n",
       "      <td>165</td>\n",
       "      <td>62</td>\n",
       "      <td>0.375758</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>102</td>\n",
       "      <td>emn</td>\n",
       "      <td>École des Mines de Nantes</td>\n",
       "      <td>https://hal-mines-nantes.archives-ouvertes.fr</td>\n",
       "      <td>84538.0</td>\n",
       "      <td>None</td>\n",
       "      <td>16</td>\n",
       "      <td>6</td>\n",
       "      <td>0.375000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>3680</td>\n",
       "      <td>univ-bsud</td>\n",
       "      <td>Université Bretagne Sud</td>\n",
       "      <td>https://hal-univ-ubs.archives-ouvertes.fr</td>\n",
       "      <td>172265.0</td>\n",
       "      <td>None</td>\n",
       "      <td>80</td>\n",
       "      <td>29</td>\n",
       "      <td>0.362500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>60</td>\n",
       "      <td>sciencespo</td>\n",
       "      <td>Sciences Po</td>\n",
       "      <td>https://hal-sciencespo.archives-ouvertes.fr</td>\n",
       "      <td>301587.0</td>\n",
       "      <td>Sciences Po Lyon - Institut d'études politique...</td>\n",
       "      <td>29</td>\n",
       "      <td>10</td>\n",
       "      <td>0.344828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>109</td>\n",
       "      <td>insa-rennes</td>\n",
       "      <td>INSA Rennes</td>\n",
       "      <td>https://hal-insa-rennes.archives-ouvertes.fr</td>\n",
       "      <td>117606.0</td>\n",
       "      <td>None</td>\n",
       "      <td>29</td>\n",
       "      <td>10</td>\n",
       "      <td>0.344828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>76</td>\n",
       "      <td>espci</td>\n",
       "      <td>ESPCI Paris</td>\n",
       "      <td>https://hal-espci.archives-ouvertes.fr</td>\n",
       "      <td>301585.0</td>\n",
       "      <td>None</td>\n",
       "      <td>91</td>\n",
       "      <td>31</td>\n",
       "      <td>0.340659</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>7267</td>\n",
       "      <td>enssib</td>\n",
       "      <td>ENSSIB</td>\n",
       "      <td>https://hal-enssib.archives-ouvertes.fr</td>\n",
       "      <td>43938.0</td>\n",
       "      <td>None</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>0.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>96</td>\n",
       "      <td>cstb</td>\n",
       "      <td>CSTB - Centre Scientifique et Technique du Bât...</td>\n",
       "      <td>https://hal-cstb.archives-ouvertes.fr</td>\n",
       "      <td>300021.0</td>\n",
       "      <td>None</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>0.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>33</td>\n",
       "      <td>paris1</td>\n",
       "      <td>Université Paris 1 Panthéon-Sorbonne</td>\n",
       "      <td>https://hal-paris1.archives-ouvertes.fr</td>\n",
       "      <td>7550.0</td>\n",
       "      <td>Université Paris 1 Panthéon-Sorbonne [UP1]</td>\n",
       "      <td>228</td>\n",
       "      <td>76</td>\n",
       "      <td>0.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>82</td>\n",
       "      <td>univ-tlse2</td>\n",
       "      <td>Université Toulouse - Jean Jaurès</td>\n",
       "      <td>https://hal-univ-tlse2.archives-ouvertes.fr</td>\n",
       "      <td>116256.0</td>\n",
       "      <td>Université Toulouse - Jean Jaurès [UT2J]</td>\n",
       "      <td>113</td>\n",
       "      <td>37</td>\n",
       "      <td>0.327434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>8199</td>\n",
       "      <td>psl</td>\n",
       "      <td>Université Paris, Sciences &amp; Lettres - PSL</td>\n",
       "      <td>https://hal-psl.archives-ouvertes.fr</td>\n",
       "      <td>564132.0</td>\n",
       "      <td>None</td>\n",
       "      <td>37</td>\n",
       "      <td>12</td>\n",
       "      <td>0.324324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>83</td>\n",
       "      <td>ups-tlse</td>\n",
       "      <td>Université Toulouse III - Paul Sabatier</td>\n",
       "      <td>https://hal-univ-tlse3.archives-ouvertes.fr</td>\n",
       "      <td>217752.0</td>\n",
       "      <td>Université Toulouse III - Paul Sabatier [UT3]</td>\n",
       "      <td>346</td>\n",
       "      <td>109</td>\n",
       "      <td>0.315029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>81</td>\n",
       "      <td>enscp</td>\n",
       "      <td>Chimie ParisTech</td>\n",
       "      <td>https://hal-enscp.archives-ouvertes.fr</td>\n",
       "      <td>300372.0</td>\n",
       "      <td>Ecole Nationale Supérieure de Chimie de Paris ...</td>\n",
       "      <td>42</td>\n",
       "      <td>13</td>\n",
       "      <td>0.309524</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>inserm</td>\n",
       "      <td>Inserm</td>\n",
       "      <td>https://www.hal.inserm.fr</td>\n",
       "      <td>303623.0</td>\n",
       "      <td>Pôle des Cardiopathies Congénitales du Nouveau...</td>\n",
       "      <td>2607</td>\n",
       "      <td>790</td>\n",
       "      <td>0.303030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>3894</td>\n",
       "      <td>univ-perp</td>\n",
       "      <td>Université de Perpignan</td>\n",
       "      <td>https://hal-univ-perp.archives-ouvertes.fr</td>\n",
       "      <td>101475.0</td>\n",
       "      <td>Université de Perpignan Via Domitia [UPVD]</td>\n",
       "      <td>86</td>\n",
       "      <td>26</td>\n",
       "      <td>0.302326</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>61</td>\n",
       "      <td>univ-avignon</td>\n",
       "      <td>Université d'Avignon et des Pays de Vaucluse</td>\n",
       "      <td>https://hal-univ-avignon.archives-ouvertes.fr</td>\n",
       "      <td>195507.0</td>\n",
       "      <td>None</td>\n",
       "      <td>70</td>\n",
       "      <td>21</td>\n",
       "      <td>0.300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>46</td>\n",
       "      <td>grenoble-em</td>\n",
       "      <td>Grenoble Ecole de Management</td>\n",
       "      <td>http://hal.grenoble-em.com</td>\n",
       "      <td>220014.0</td>\n",
       "      <td>Grenoble Ecole de Management</td>\n",
       "      <td>28</td>\n",
       "      <td>8</td>\n",
       "      <td>0.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>4105</td>\n",
       "      <td>univ-orleans</td>\n",
       "      <td>Université d'Orléans</td>\n",
       "      <td>https://hal-univ-orleans.archives-ouvertes.fr</td>\n",
       "      <td>300297.0</td>\n",
       "      <td>Université d'Orléans [UO]</td>\n",
       "      <td>154</td>\n",
       "      <td>44</td>\n",
       "      <td>0.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>4793</td>\n",
       "      <td>univ-evry</td>\n",
       "      <td>Université Evry Val d’Essonne</td>\n",
       "      <td>https://hal-univ-evry.archives-ouvertes.fr</td>\n",
       "      <td>300306.0</td>\n",
       "      <td>None</td>\n",
       "      <td>104</td>\n",
       "      <td>28</td>\n",
       "      <td>0.269231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>94</td>\n",
       "      <td>bnf</td>\n",
       "      <td>Bibliothèque nationale de France</td>\n",
       "      <td>https://hal-bnf.archives-ouvertes.fr</td>\n",
       "      <td>302209.0</td>\n",
       "      <td>Bibliothèque Nationale de France</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>6617</td>\n",
       "      <td>utc</td>\n",
       "      <td>Université de Technologie de Compiègne</td>\n",
       "      <td>https://hal.utc.fr</td>\n",
       "      <td>93027.0</td>\n",
       "      <td>Université de Technologie de Compiègne [UTC]</td>\n",
       "      <td>24</td>\n",
       "      <td>6</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>79</td>\n",
       "      <td>ephe</td>\n",
       "      <td>EPHE - École pratique des hautes études</td>\n",
       "      <td>https://hal-ephe.archives-ouvertes.fr</td>\n",
       "      <td>110691.0</td>\n",
       "      <td>None</td>\n",
       "      <td>134</td>\n",
       "      <td>33</td>\n",
       "      <td>0.246269</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>22</td>\n",
       "      <td>obspm</td>\n",
       "      <td>Observatoire de Paris</td>\n",
       "      <td>https://hal-obspm.ccsd.cnrs.fr</td>\n",
       "      <td>300055.0</td>\n",
       "      <td>Observatoire de Paris</td>\n",
       "      <td>52</td>\n",
       "      <td>12</td>\n",
       "      <td>0.230769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>48</td>\n",
       "      <td>polytechnique</td>\n",
       "      <td>Ecole polytechnique</td>\n",
       "      <td>https://hal-polytechnique.archives-ouvertes.fr</td>\n",
       "      <td>300340.0</td>\n",
       "      <td>École Polytechnique de Montréal [EPM]</td>\n",
       "      <td>96</td>\n",
       "      <td>21</td>\n",
       "      <td>0.218750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>5242</td>\n",
       "      <td>univ-lemans</td>\n",
       "      <td>Université du Maine</td>\n",
       "      <td>https://hal-univ-lemans.archives-ouvertes.fr</td>\n",
       "      <td>7566.0</td>\n",
       "      <td>None</td>\n",
       "      <td>60</td>\n",
       "      <td>13</td>\n",
       "      <td>0.216667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>5761</td>\n",
       "      <td>insa-toulouse</td>\n",
       "      <td>INSA-Toulouse</td>\n",
       "      <td>https://hal.insa-toulouse.fr</td>\n",
       "      <td>116255.0</td>\n",
       "      <td>None</td>\n",
       "      <td>43</td>\n",
       "      <td>9</td>\n",
       "      <td>0.209302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>3778</td>\n",
       "      <td>univ-reunion</td>\n",
       "      <td>Université de la Réunion</td>\n",
       "      <td>https://hal.univ-reunion.fr</td>\n",
       "      <td>300316.0</td>\n",
       "      <td>Université de La Réunion [UR]</td>\n",
       "      <td>106</td>\n",
       "      <td>22</td>\n",
       "      <td>0.207547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>98</td>\n",
       "      <td>enac</td>\n",
       "      <td>ENAC - Ecole Nationale de l'Aviation Civile</td>\n",
       "      <td>https://hal-enac.archives-ouvertes.fr</td>\n",
       "      <td>380071.0</td>\n",
       "      <td>None</td>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>7636</td>\n",
       "      <td>chu-clermontferrand</td>\n",
       "      <td>CHU de Clermont-Ferrand</td>\n",
       "      <td>https://hal-chu-clermontferrand.archives-ouver...</td>\n",
       "      <td>1082719.0</td>\n",
       "      <td>None</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>7464</td>\n",
       "      <td>enc</td>\n",
       "      <td>Ecole Nationale des Chartes</td>\n",
       "      <td>https://hal-enc.archives-ouvertes.fr</td>\n",
       "      <td>307249.0</td>\n",
       "      <td>École nationale des chartes [ENC]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>6599</td>\n",
       "      <td>univ-lille</td>\n",
       "      <td>Université de Lille</td>\n",
       "      <td>https://hal.univ-lille.fr</td>\n",
       "      <td>374570.0</td>\n",
       "      <td>Faculté de Médecine Henri Warembourg - Univers...</td>\n",
       "      <td>133</td>\n",
       "      <td>25</td>\n",
       "      <td>0.187970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>8821</td>\n",
       "      <td>u-picardie</td>\n",
       "      <td>Université de Picardie Jules Verne</td>\n",
       "      <td>https://hal-u-picardie.archives-ouvertes.fr</td>\n",
       "      <td>300258.0</td>\n",
       "      <td>Université de Picardie Jules Verne [UPJV]</td>\n",
       "      <td>102</td>\n",
       "      <td>19</td>\n",
       "      <td>0.186275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>101</td>\n",
       "      <td>univ-tln</td>\n",
       "      <td>Université de Toulon</td>\n",
       "      <td>https://hal-univ-tln.archives-ouvertes.fr</td>\n",
       "      <td>303091.0</td>\n",
       "      <td>Université de Toulon [UTLN]</td>\n",
       "      <td>65</td>\n",
       "      <td>12</td>\n",
       "      <td>0.184615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>85</td>\n",
       "      <td>uag</td>\n",
       "      <td>Université des Antilles</td>\n",
       "      <td>https://hal.univ-antilles.fr</td>\n",
       "      <td>466882.0</td>\n",
       "      <td>Université des Antilles (Pôle Martinique)</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>0.181818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>7259</td>\n",
       "      <td>cnrs</td>\n",
       "      <td>Centre national de la recherche scientifique</td>\n",
       "      <td>https://hal-cnrs.archives-ouvertes.fr</td>\n",
       "      <td>441569.0</td>\n",
       "      <td>Centre National de la Recherche Scientifique e...</td>\n",
       "      <td>5561</td>\n",
       "      <td>999</td>\n",
       "      <td>0.179644</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>4217</td>\n",
       "      <td>inalco</td>\n",
       "      <td>Inalco - Institut National des Langues et Civi...</td>\n",
       "      <td>https://hal-inalco.archives-ouvertes.fr</td>\n",
       "      <td>300064.0</td>\n",
       "      <td>None</td>\n",
       "      <td>52</td>\n",
       "      <td>8</td>\n",
       "      <td>0.153846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>6139</td>\n",
       "      <td>univ-lyon1</td>\n",
       "      <td>Université Claude Bernard Lyon 1</td>\n",
       "      <td>https://hal-univ-lyon1.archives-ouvertes.fr</td>\n",
       "      <td>194495.0</td>\n",
       "      <td>Université Claude Bernard Lyon 1 [UCBL]</td>\n",
       "      <td>352</td>\n",
       "      <td>51</td>\n",
       "      <td>0.144886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>4808</td>\n",
       "      <td>univ-guyane</td>\n",
       "      <td>Université de Guyane</td>\n",
       "      <td>https://hal.univ-guyane.fr</td>\n",
       "      <td>424370.0</td>\n",
       "      <td>Université de Guyane [UG]</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>0.142857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>7030</td>\n",
       "      <td>vetagro-sup</td>\n",
       "      <td>VetAgro Sup</td>\n",
       "      <td>https://hal-vetagro-sup.archives-ouvertes.fr</td>\n",
       "      <td>301767.0</td>\n",
       "      <td>VetAgro Sup - Institut national d'enseignement...</td>\n",
       "      <td>50</td>\n",
       "      <td>7</td>\n",
       "      <td>0.140000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>8935</td>\n",
       "      <td>ulco</td>\n",
       "      <td>Université du Littoral Côte d'Opale</td>\n",
       "      <td>https://hal-ulco.archives-ouvertes.fr</td>\n",
       "      <td>301404.0</td>\n",
       "      <td>Université du Littoral Côte d'Opale [ULCO]</td>\n",
       "      <td>43</td>\n",
       "      <td>6</td>\n",
       "      <td>0.139535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>democrite</td>\n",
       "      <td>IN2P3 - Institut national de physique nucléair...</td>\n",
       "      <td>http://hal.in2p3.fr</td>\n",
       "      <td>300046.0</td>\n",
       "      <td>None</td>\n",
       "      <td>60</td>\n",
       "      <td>8</td>\n",
       "      <td>0.133333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>40</td>\n",
       "      <td>unilim</td>\n",
       "      <td>Université de Limoges</td>\n",
       "      <td>https://hal-unilim.archives-ouvertes.fr</td>\n",
       "      <td>5928.0</td>\n",
       "      <td>Université de Limoges [UNILIM]</td>\n",
       "      <td>61</td>\n",
       "      <td>8</td>\n",
       "      <td>0.131148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>8358</td>\n",
       "      <td>universite-paris-saclay</td>\n",
       "      <td>Université Paris-Saclay</td>\n",
       "      <td>https://hal-universite-paris-saclay.archives-o...</td>\n",
       "      <td>419361.0</td>\n",
       "      <td>AP-HP. Université Paris Saclay</td>\n",
       "      <td>243</td>\n",
       "      <td>31</td>\n",
       "      <td>0.127572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>5241</td>\n",
       "      <td>univ-rennes2</td>\n",
       "      <td>Université Rennes 2</td>\n",
       "      <td>https://hal.univ-rennes2.fr</td>\n",
       "      <td>406201.0</td>\n",
       "      <td>None</td>\n",
       "      <td>132</td>\n",
       "      <td>14</td>\n",
       "      <td>0.106061</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>77</td>\n",
       "      <td>ensta</td>\n",
       "      <td>ENSTA Paris</td>\n",
       "      <td>https://hal-ensta-paris.archives-ouvertes.fr/</td>\n",
       "      <td>300065.0</td>\n",
       "      <td>None</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>0.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>78</td>\n",
       "      <td>rbs</td>\n",
       "      <td>Rouen Business School</td>\n",
       "      <td>https://hal-rbs.archives-ouvertes.fr</td>\n",
       "      <td>301663.0</td>\n",
       "      <td>None</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>0.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>5436</td>\n",
       "      <td>univ-montpellier</td>\n",
       "      <td>Université de Montpellier</td>\n",
       "      <td>https://hal.umontpellier.fr</td>\n",
       "      <td>410122.0</td>\n",
       "      <td>Université de Montpellier [UM]</td>\n",
       "      <td>192</td>\n",
       "      <td>19</td>\n",
       "      <td>0.098958</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>5817</td>\n",
       "      <td>urca</td>\n",
       "      <td>Université de Reims Champagne-Ardenne</td>\n",
       "      <td>https://hal.univ-reims.fr</td>\n",
       "      <td>7569.0</td>\n",
       "      <td>Université de Reims Champagne-Ardenne [URCA]</td>\n",
       "      <td>132</td>\n",
       "      <td>13</td>\n",
       "      <td>0.098485</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>106</td>\n",
       "      <td>onera</td>\n",
       "      <td>ONERA - Office National d'Études et de Recherc...</td>\n",
       "      <td>https://hal-onera.archives-ouvertes.fr</td>\n",
       "      <td>300024.0</td>\n",
       "      <td>None</td>\n",
       "      <td>75</td>\n",
       "      <td>7</td>\n",
       "      <td>0.093333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>4090</td>\n",
       "      <td>univ-lorraine</td>\n",
       "      <td>Université de Lorraine</td>\n",
       "      <td>https://hal.univ-lorraine.fr</td>\n",
       "      <td>413289.0</td>\n",
       "      <td>Université de Lorraine [UL]</td>\n",
       "      <td>152</td>\n",
       "      <td>14</td>\n",
       "      <td>0.092105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>5853</td>\n",
       "      <td>upf</td>\n",
       "      <td>Université de la Polynésie française</td>\n",
       "      <td>https://hal-upf.archives-ouvertes.fr</td>\n",
       "      <td>300327.0</td>\n",
       "      <td>Université de la Polynésie Française [UPF]</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>0.083333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>6911</td>\n",
       "      <td>cnam</td>\n",
       "      <td>Cnam - Conservatoire national des arts et métiers</td>\n",
       "      <td>https://hal-cnam.archives-ouvertes.fr</td>\n",
       "      <td>300351.0</td>\n",
       "      <td>None</td>\n",
       "      <td>166</td>\n",
       "      <td>13</td>\n",
       "      <td>0.078313</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>7706</td>\n",
       "      <td>mines-ales</td>\n",
       "      <td>École des Mines d'Alès</td>\n",
       "      <td>https://hal.mines-ales.fr</td>\n",
       "      <td>6279.0</td>\n",
       "      <td>None</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0.076923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>51</td>\n",
       "      <td>univ-savoie</td>\n",
       "      <td>Université Savoie Mont Blanc</td>\n",
       "      <td>http://hal.univ-smb.fr</td>\n",
       "      <td>432896.0</td>\n",
       "      <td>Université Savoie Mont Blanc [USMB [Université...</td>\n",
       "      <td>59</td>\n",
       "      <td>4</td>\n",
       "      <td>0.067797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>59</td>\n",
       "      <td>inrap</td>\n",
       "      <td>Inrap - Institut national de recherches archéo...</td>\n",
       "      <td>https://hal-inrap.archives-ouvertes.fr</td>\n",
       "      <td>301475.0</td>\n",
       "      <td>None</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>0.066667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>4639</td>\n",
       "      <td>univ-paris10</td>\n",
       "      <td>Université Paris Nanterre</td>\n",
       "      <td>https://hal.parisnanterre.fr/</td>\n",
       "      <td>116205.0</td>\n",
       "      <td>Université Paris Nanterre [UPN]</td>\n",
       "      <td>137</td>\n",
       "      <td>9</td>\n",
       "      <td>0.065693</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>27</td>\n",
       "      <td>insu</td>\n",
       "      <td>INSU - Institut national des sciences de l'Uni...</td>\n",
       "      <td>https://hal-insu.archives-ouvertes.fr</td>\n",
       "      <td>300045.0</td>\n",
       "      <td>None</td>\n",
       "      <td>199</td>\n",
       "      <td>13</td>\n",
       "      <td>0.065327</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>110</td>\n",
       "      <td>amu</td>\n",
       "      <td>Aix-Marseille Université</td>\n",
       "      <td>https://hal-amu.archives-ouvertes.fr</td>\n",
       "      <td>198056.0</td>\n",
       "      <td>Aix Marseille Université [AMU]</td>\n",
       "      <td>252</td>\n",
       "      <td>16</td>\n",
       "      <td>0.063492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>97</td>\n",
       "      <td>univ-lille3</td>\n",
       "      <td>Université Lille 3 - Sciences Humaines et Soci...</td>\n",
       "      <td>https://hal.univ-lille3.fr</td>\n",
       "      <td>301700.0</td>\n",
       "      <td>None</td>\n",
       "      <td>32</td>\n",
       "      <td>2</td>\n",
       "      <td>0.062500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>7463</td>\n",
       "      <td>u-bordeaux-montaigne</td>\n",
       "      <td>Université Bordeaux Montaigne</td>\n",
       "      <td>https://hal-u-bordeaux-montaigne.archives-ouve...</td>\n",
       "      <td>412629.0</td>\n",
       "      <td>Université Bordeaux Montaigne</td>\n",
       "      <td>66</td>\n",
       "      <td>4</td>\n",
       "      <td>0.060606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>53</td>\n",
       "      <td>ensmp</td>\n",
       "      <td>MINES ParisTech</td>\n",
       "      <td>https://hal-mines-paristech.archives-ouvertes.fr</td>\n",
       "      <td>301492.0</td>\n",
       "      <td>Fondation MINES ParisTech</td>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>0.060000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>7658</td>\n",
       "      <td>unc</td>\n",
       "      <td>Université de la Nouvelle Calédonie</td>\n",
       "      <td>https://hal-unc.archives-ouvertes.fr</td>\n",
       "      <td>300328.0</td>\n",
       "      <td>Université de la Nouvelle-Calédonie [UNC]</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>0.058824</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>5760</td>\n",
       "      <td>univ-poitiers</td>\n",
       "      <td>Université de Poitiers</td>\n",
       "      <td>https://hal-univ-poitiers.archives-ouvertes.fr</td>\n",
       "      <td>54493.0</td>\n",
       "      <td>Université de Poitiers</td>\n",
       "      <td>191</td>\n",
       "      <td>11</td>\n",
       "      <td>0.057592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>7921</td>\n",
       "      <td>univ-paris</td>\n",
       "      <td>Université de Paris</td>\n",
       "      <td>https://hal-univ-paris.archives-ouvertes.fr</td>\n",
       "      <td>557826.0</td>\n",
       "      <td>Unité de Gynécologie Médicale, AP-HP, Hôpital ...</td>\n",
       "      <td>535</td>\n",
       "      <td>27</td>\n",
       "      <td>0.050467</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>70</td>\n",
       "      <td>sorbonne-universite</td>\n",
       "      <td>Sorbonne Université</td>\n",
       "      <td>https://hal.sorbonne-universite.fr</td>\n",
       "      <td>413221.0</td>\n",
       "      <td>None</td>\n",
       "      <td>392</td>\n",
       "      <td>18</td>\n",
       "      <td>0.045918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>7808</td>\n",
       "      <td>inrae</td>\n",
       "      <td>Institut National de Recherche en Agriculture,...</td>\n",
       "      <td>https://hal.inrae.fr</td>\n",
       "      <td>577435.0</td>\n",
       "      <td>None</td>\n",
       "      <td>505</td>\n",
       "      <td>21</td>\n",
       "      <td>0.041584</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>5511</td>\n",
       "      <td>univ-rochelle</td>\n",
       "      <td>Université de La Rochelle</td>\n",
       "      <td>https://hal-univ-rochelle.archives-ouvertes.fr</td>\n",
       "      <td>300311.0</td>\n",
       "      <td>None</td>\n",
       "      <td>51</td>\n",
       "      <td>2</td>\n",
       "      <td>0.039216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>4079</td>\n",
       "      <td>univ-paris3</td>\n",
       "      <td>Université Sorbonne Nouvelle - Paris 3</td>\n",
       "      <td>https://hal-univ-paris3.archives-ouvertes.fr</td>\n",
       "      <td>52995.0</td>\n",
       "      <td>Université Sorbonne Nouvelle - Paris 3</td>\n",
       "      <td>63</td>\n",
       "      <td>2</td>\n",
       "      <td>0.031746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>6717</td>\n",
       "      <td>univ-lyon2</td>\n",
       "      <td>Hal Lumière Lyon2</td>\n",
       "      <td>https://hal.univ-lyon2.fr</td>\n",
       "      <td>33804.0</td>\n",
       "      <td>None</td>\n",
       "      <td>115</td>\n",
       "      <td>3</td>\n",
       "      <td>0.026087</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>8822</td>\n",
       "      <td>insa-lyon</td>\n",
       "      <td>INSA Lyon</td>\n",
       "      <td>https://hal-insa-lyon.archives-ouvertes.fr</td>\n",
       "      <td>219748.0</td>\n",
       "      <td>None</td>\n",
       "      <td>95</td>\n",
       "      <td>2</td>\n",
       "      <td>0.021053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>67</td>\n",
       "      <td>agroparistech</td>\n",
       "      <td>AgroParisTech</td>\n",
       "      <td>https://hal-agroparistech.archives-ouvertes.fr</td>\n",
       "      <td>148117.0</td>\n",
       "      <td>AgroParisTech</td>\n",
       "      <td>97</td>\n",
       "      <td>2</td>\n",
       "      <td>0.020619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>93</td>\n",
       "      <td>univ-paris8</td>\n",
       "      <td>Université Paris 8</td>\n",
       "      <td>https://hal-univ-paris8.archives-ouvertes.fr</td>\n",
       "      <td>11141.0</td>\n",
       "      <td>Université Paris 8 Vincennes-Saint-Denis [UP8]</td>\n",
       "      <td>107</td>\n",
       "      <td>2</td>\n",
       "      <td>0.018692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>56</td>\n",
       "      <td>ens</td>\n",
       "      <td>Ecole Normale Supérieure</td>\n",
       "      <td>https://hal-ens.archives-ouvertes.fr</td>\n",
       "      <td>59704.0</td>\n",
       "      <td>École normale supérieure - Constantine [ENS Co...</td>\n",
       "      <td>108</td>\n",
       "      <td>2</td>\n",
       "      <td>0.018519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>31</td>\n",
       "      <td>univ-cotedazur</td>\n",
       "      <td>Université Cote d'Azur</td>\n",
       "      <td>https://hal.univ-cotedazur.fr</td>\n",
       "      <td>1039632.0</td>\n",
       "      <td>None</td>\n",
       "      <td>112</td>\n",
       "      <td>2</td>\n",
       "      <td>0.017857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>8046</td>\n",
       "      <td>college-de-france</td>\n",
       "      <td>Collège de France</td>\n",
       "      <td>https://hal-college-de-france.archives-ouverte...</td>\n",
       "      <td>300026.0</td>\n",
       "      <td>Collège de France [CdF (institution)]</td>\n",
       "      <td>113</td>\n",
       "      <td>2</td>\n",
       "      <td>0.017699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>6183</td>\n",
       "      <td>univ-pau-pays-adour</td>\n",
       "      <td>Université de Pau et des Pays de l'Adour</td>\n",
       "      <td>https://hal-univ-pau.archives-ouvertes.fr</td>\n",
       "      <td>301085.0</td>\n",
       "      <td>Université de Pau et des Pays de l'Adour [UPPA]</td>\n",
       "      <td>58</td>\n",
       "      <td>1</td>\n",
       "      <td>0.017241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>63</td>\n",
       "      <td>univ-bourgogne</td>\n",
       "      <td>Université de Bourgogne</td>\n",
       "      <td>https://hal-univ-bourgogne.archives-ouvertes.fr</td>\n",
       "      <td>300270.0</td>\n",
       "      <td>Université de Bourgogne [UB]</td>\n",
       "      <td>181</td>\n",
       "      <td>3</td>\n",
       "      <td>0.016575</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>50</td>\n",
       "      <td>institut-telecom</td>\n",
       "      <td>Institut Mines-Télécom</td>\n",
       "      <td>https://hal-imt.archives-ouvertes.fr</td>\n",
       "      <td>302102.0</td>\n",
       "      <td>Institut Mines-Télécom Business School [IMT-BS]</td>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>0.016393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>9613</td>\n",
       "      <td>univ-eiffel</td>\n",
       "      <td>Université Gustave Eiffel</td>\n",
       "      <td>https://hal-univ-eiffel.archives-ouvertes.fr</td>\n",
       "      <td>580722.0</td>\n",
       "      <td>Université Gustave Eiffel</td>\n",
       "      <td>76</td>\n",
       "      <td>1</td>\n",
       "      <td>0.013158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>100</td>\n",
       "      <td>saga</td>\n",
       "      <td>Université Grenoble Alpes</td>\n",
       "      <td>https://hal.univ-grenoble-alpes.fr</td>\n",
       "      <td>1042703.0</td>\n",
       "      <td>None</td>\n",
       "      <td>137</td>\n",
       "      <td>1</td>\n",
       "      <td>0.007299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>20</td>\n",
       "      <td>cirad</td>\n",
       "      <td>Cirad</td>\n",
       "      <td>http://hal.cirad.fr</td>\n",
       "      <td>11574.0</td>\n",
       "      <td>None</td>\n",
       "      <td>203</td>\n",
       "      <td>1</td>\n",
       "      <td>0.004926</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>21</td>\n",
       "      <td>pasteur</td>\n",
       "      <td>Institut Pasteur</td>\n",
       "      <td>https://hal-pasteur.archives-ouvertes.fr</td>\n",
       "      <td>300027.0</td>\n",
       "      <td>Institut Pasteur de Madagascar</td>\n",
       "      <td>1003</td>\n",
       "      <td>2</td>\n",
       "      <td>0.001994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>6477</td>\n",
       "      <td>u-paris-seine</td>\n",
       "      <td>CY Cergy Paris Université</td>\n",
       "      <td>https://hal-cyu.archives-ouvertes.fr/</td>\n",
       "      <td>1003413.0</td>\n",
       "      <td>CY Cergy Paris Université [CY]</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>5512</td>\n",
       "      <td>univ-paris-lumieres</td>\n",
       "      <td>Université Paris Lumières</td>\n",
       "      <td>https://hal-univ-paris-lumieres.archives-ouver...</td>\n",
       "      <td>475360.0</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>7092</td>\n",
       "      <td>telecom-paristech</td>\n",
       "      <td>Télécom Paris</td>\n",
       "      <td>https://hal.telecom-paris.fr</td>\n",
       "      <td>1048346.0</td>\n",
       "      <td>Télécom Paris</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>47</td>\n",
       "      <td>univ-artois</td>\n",
       "      <td>Université d'Artois</td>\n",
       "      <td>https://hal-univ-artois.archives-ouvertes.fr</td>\n",
       "      <td>56711.0</td>\n",
       "      <td>Université d'Artois [UA]</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>8393</td>\n",
       "      <td>univ-montpellier3-paul-valery</td>\n",
       "      <td>Université Paul Valéry Montpellier 3</td>\n",
       "      <td>https://hal-univ-montpellier3-paul-valery.arch...</td>\n",
       "      <td>42812.0</td>\n",
       "      <td>None</td>\n",
       "      <td>84</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>6442</td>\n",
       "      <td>uphf</td>\n",
       "      <td>Université Polytechnique des Hauts-de-France</td>\n",
       "      <td>https://hal-uphf.archives-ouvertes.fr</td>\n",
       "      <td>1001263.0</td>\n",
       "      <td>None</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>4638</td>\n",
       "      <td>insep</td>\n",
       "      <td>Insep - Institut national du sport, de l'exper...</td>\n",
       "      <td>https://hal-insep.archives-ouvertes.fr</td>\n",
       "      <td>441096.0</td>\n",
       "      <td>None</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>9676</td>\n",
       "      <td>isara</td>\n",
       "      <td>Isara</td>\n",
       "      <td>https://hal-isara.archives-ouvertes.fr</td>\n",
       "      <td>1081289.0</td>\n",
       "      <td>ISARA Corporation</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>5939</td>\n",
       "      <td>imt-atlantique</td>\n",
       "      <td>IMT Atlantique</td>\n",
       "      <td>https://hal-imt-atlantique.archives-ouvertes.fr</td>\n",
       "      <td>481355.0</td>\n",
       "      <td>IMT Atlantique Bretagne-Pays de la Loire [IMT ...</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>107</td>\n",
       "      <td>ema</td>\n",
       "      <td>École nationale supérieure des mines d'Albi-Ca...</td>\n",
       "      <td>https://hal-mines-albi.archives-ouvertes.fr</td>\n",
       "      <td>469216.0</td>\n",
       "      <td>IMT École nationale supérieure des Mines d'Alb...</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>95</td>\n",
       "      <td>audencia</td>\n",
       "      <td>Audencia Business School</td>\n",
       "      <td>https://hal-audencia.archives-ouvertes.fr</td>\n",
       "      <td>456031.0</td>\n",
       "      <td>Audencia Business School</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>69</td>\n",
       "      <td>enpc</td>\n",
       "      <td>Ecole des Ponts ParisTech</td>\n",
       "      <td>https://hal-enpc.archives-ouvertes.fr</td>\n",
       "      <td>301545.0</td>\n",
       "      <td>École des Ponts ParisTech [ENPC]</td>\n",
       "      <td>62</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>35</td>\n",
       "      <td>supelec</td>\n",
       "      <td>Supelec</td>\n",
       "      <td>https://hal-supelec.archives-ouvertes.fr</td>\n",
       "      <td>303397.0</td>\n",
       "      <td>Ecole Supérieure d'Electricité - SUPELEC (FRANCE)</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>4024</td>\n",
       "      <td>uvsq</td>\n",
       "      <td>Université de Versailles Saint-Quentin-en-Yvel...</td>\n",
       "      <td>https://hal.uvsq.fr</td>\n",
       "      <td>81173.0</td>\n",
       "      <td>Université de Versailles Saint-Quentin-en-Yvel...</td>\n",
       "      <td>82</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>9844</td>\n",
       "      <td>nantes-universite</td>\n",
       "      <td>Nantes Université</td>\n",
       "      <td>https://hal-nantes-universite.archives-ouverte...</td>\n",
       "      <td>1083366.0</td>\n",
       "      <td>Nantes Université - pôle Santé</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>30</td>\n",
       "      <td>meteo</td>\n",
       "      <td>Météo-France</td>\n",
       "      <td>https://hal-meteofrance.archives-ouvertes.fr</td>\n",
       "      <td>1079823.0</td>\n",
       "      <td>Météo-France</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>73</td>\n",
       "      <td>ecp</td>\n",
       "      <td>Ecole Centrale Paris</td>\n",
       "      <td>https://hal-ecp.archives-ouvertes.fr</td>\n",
       "      <td>300342.0</td>\n",
       "      <td>None</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>4926</td>\n",
       "      <td>montpellier-supagro</td>\n",
       "      <td>Montpellier SupAgro</td>\n",
       "      <td>https://hal-montpellier-supagro.archives-ouver...</td>\n",
       "      <td>1090073.0</td>\n",
       "      <td>None</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>3895</td>\n",
       "      <td>normandie-univ</td>\n",
       "      <td>Normandie Université</td>\n",
       "      <td>https://hal-normandie-univ.archives-ouvertes.fr</td>\n",
       "      <td>455934.0</td>\n",
       "      <td>None</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>5815</td>\n",
       "      <td>inshea</td>\n",
       "      <td>INSHEA</td>\n",
       "      <td>https://hal-inshea.archives-ouvertes.fr</td>\n",
       "      <td>308431.0</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>3775</td>\n",
       "      <td>neoma</td>\n",
       "      <td>NEOMA Business School</td>\n",
       "      <td>https://hal-neoma-bs.archives-ouvertes.fr</td>\n",
       "      <td>232915.0</td>\n",
       "      <td>Neoma Business School [NEOMA]</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>108</td>\n",
       "      <td>esc-rennes</td>\n",
       "      <td>Rennes Business School</td>\n",
       "      <td>https://hal-rennes-sb.archives-ouvertes.fr</td>\n",
       "      <td>301752.0</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>66</td>\n",
       "      <td>iogs</td>\n",
       "      <td>Institut d'Optique Graduate School</td>\n",
       "      <td>https://hal-iogs.archives-ouvertes.fr</td>\n",
       "      <td>300036.0</td>\n",
       "      <td>Institut d'Optique Graduate School [IOGS]</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>64</td>\n",
       "      <td>ensieta</td>\n",
       "      <td>ENSTA Bretagne</td>\n",
       "      <td>https://hal-ensta-bretagne.archives-ouvertes.fr</td>\n",
       "      <td>301846.0</td>\n",
       "      <td>None</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>34</td>\n",
       "      <td>mnhn</td>\n",
       "      <td>MNHN - Muséum national d'Histoire naturelle</td>\n",
       "      <td>https://hal-mnhn.archives-ouvertes.fr</td>\n",
       "      <td>7512.0</td>\n",
       "      <td>None</td>\n",
       "      <td>141</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>9610</td>\n",
       "      <td>ec-lyon</td>\n",
       "      <td>École Centrale de Lyon</td>\n",
       "      <td>https://hal-ec-lyon.archives-ouvertes.fr</td>\n",
       "      <td>126765.0</td>\n",
       "      <td>École Centrale de Lyon [ECL]</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>105</td>\n",
       "      <td>clermont-univ</td>\n",
       "      <td>Université Clermont Auvergne</td>\n",
       "      <td>https://hal.uca.fr</td>\n",
       "      <td>1063463.0</td>\n",
       "      <td>None</td>\n",
       "      <td>63</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>8897</td>\n",
       "      <td>uco</td>\n",
       "      <td>Université Catholique de l'Ouest</td>\n",
       "      <td>https://hal-uco.archives-ouvertes.fr</td>\n",
       "      <td>300844.0</td>\n",
       "      <td>Université Catholique de l'Ouest [UCO]</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>5852</td>\n",
       "      <td>agrosup-dijon</td>\n",
       "      <td>AgroSup Dijon</td>\n",
       "      <td>https://hal-agrosup-dijon.archives-ouvertes.fr</td>\n",
       "      <td>415469.0</td>\n",
       "      <td>None</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>7314</td>\n",
       "      <td>utt</td>\n",
       "      <td>Université de technologie de Troyes</td>\n",
       "      <td>https://hal-utt.archives-ouvertes.fr</td>\n",
       "      <td>93484.0</td>\n",
       "      <td>Université de Technologie de Troyes [UTT]</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>43</td>\n",
       "      <td>univ-lyon3</td>\n",
       "      <td>Université Jean Moulin Lyon 3</td>\n",
       "      <td>https://hal-univ-lyon3.archives-ouvertes.fr</td>\n",
       "      <td>118744.0</td>\n",
       "      <td>None</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2</td>\n",
       "      <td>inria</td>\n",
       "      <td>Inria</td>\n",
       "      <td>https://hal.inria.fr</td>\n",
       "      <td>300009.0</td>\n",
       "      <td>Unknown Labs [Inria]</td>\n",
       "      <td>93</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       id                           code  \\\n",
       "26     29                           irsn   \n",
       "64     71                            hcl   \n",
       "22     25                         ineris   \n",
       "139  5836                            edf   \n",
       "149  6616                        em-lyon   \n",
       "92     99                            icp   \n",
       "162  7468                           enva   \n",
       "97    104                            pse   \n",
       "67     74                          essec   \n",
       "81     88                     univ-corse   \n",
       "15     18                           emse   \n",
       "113  4025            univ-paris-dauphine   \n",
       "53     58                            hec   \n",
       "107  3776                            usj   \n",
       "29     32                      descartes   \n",
       "43     49                    univ-nantes   \n",
       "83     90               agrocampus-ouest   \n",
       "79     45                   univ-diderot   \n",
       "129  5303                            udl   \n",
       "156  7264                    univ-angers   \n",
       "77     84                   em-normandie   \n",
       "88     91                   univ-rennes1   \n",
       "16     19                            ird   \n",
       "23     26                            cea   \n",
       "163  7580                          u-pec   \n",
       "73     80                       univ-mlv   \n",
       "35     38                     univ-brest   \n",
       "50     55                   univ-paris13   \n",
       "58     65                           brgm   \n",
       "96    103                     univ-tours   \n",
       "130  5385                          ehesp   \n",
       "105  3681                    univ-fcomte   \n",
       "11     12                            ujm   \n",
       "95    102                            emn   \n",
       "104  3680                      univ-bsud   \n",
       "54     60                     sciencespo   \n",
       "103   109                    insa-rennes   \n",
       "69     76                          espci   \n",
       "157  7267                         enssib   \n",
       "87     96                           cstb   \n",
       "30     33                         paris1   \n",
       "75     82                     univ-tlse2   \n",
       "172  8199                            psl   \n",
       "76     83                       ups-tlse   \n",
       "74     81                          enscp   \n",
       "10     11                         inserm   \n",
       "110  3894                      univ-perp   \n",
       "55     61                   univ-avignon   \n",
       "40     46                    grenoble-em   \n",
       "116  4105                   univ-orleans   \n",
       "123  4793                      univ-evry   \n",
       "85     94                            bnf   \n",
       "150  6617                            utc   \n",
       "72     79                           ephe   \n",
       "19     22                          obspm   \n",
       "42     48                  polytechnique   \n",
       "128  5242                    univ-lemans   \n",
       "136  5761                  insa-toulouse   \n",
       "109  3778                   univ-reunion   \n",
       "91     98                           enac   \n",
       "164  7636            chu-clermontferrand   \n",
       "160  7464                            enc   \n",
       "148  6599                     univ-lille   \n",
       "177  8821                     u-picardie   \n",
       "94    101                       univ-tln   \n",
       "78     85                            uag   \n",
       "155  7259                           cnrs   \n",
       "118  4217                         inalco   \n",
       "143  6139                     univ-lyon1   \n",
       "124  4808                    univ-guyane   \n",
       "153  7030                    vetagro-sup   \n",
       "180  8935                           ulco   \n",
       "6       6                      democrite   \n",
       "37     40                         unilim   \n",
       "174  8358        universite-paris-saclay   \n",
       "127  5241                   univ-rennes2   \n",
       "70     77                          ensta   \n",
       "71     78                            rbs   \n",
       "132  5436               univ-montpellier   \n",
       "138  5817                           urca   \n",
       "99    106                          onera   \n",
       "115  4090                  univ-lorraine   \n",
       "141  5853                            upf   \n",
       "152  6911                           cnam   \n",
       "166  7706                     mines-ales   \n",
       "45     51                    univ-savoie   \n",
       "52     59                          inrap   \n",
       "122  4639                   univ-paris10   \n",
       "24     27                           insu   \n",
       "101   110                            amu   \n",
       "90     97                    univ-lille3   \n",
       "161  7463           u-bordeaux-montaigne   \n",
       "47     53                          ensmp   \n",
       "165  7658                            unc   \n",
       "135  5760                  univ-poitiers   \n",
       "169  7921                     univ-paris   \n",
       "63     70            sorbonne-universite   \n",
       "168  7808                          inrae   \n",
       "133  5511                  univ-rochelle   \n",
       "114  4079                    univ-paris3   \n",
       "151  6717                     univ-lyon2   \n",
       "178  8822                      insa-lyon   \n",
       "61     67                  agroparistech   \n",
       "84     93                    univ-paris8   \n",
       "49     56                            ens   \n",
       "28     31                 univ-cotedazur   \n",
       "170  8046              college-de-france   \n",
       "144  6183            univ-pau-pays-adour   \n",
       "56     63                 univ-bourgogne   \n",
       "44     50               institut-telecom   \n",
       "182  9613                    univ-eiffel   \n",
       "93    100                           saga   \n",
       "17     20                          cirad   \n",
       "18     21                        pasteur   \n",
       "147  6477                  u-paris-seine   \n",
       "134  5512            univ-paris-lumieres   \n",
       "154  7092              telecom-paristech   \n",
       "41     47                    univ-artois   \n",
       "175  8393  univ-montpellier3-paul-valery   \n",
       "146  6442                           uphf   \n",
       "121  4638                          insep   \n",
       "183  9676                          isara   \n",
       "142  5939                 imt-atlantique   \n",
       "100   107                            ema   \n",
       "86     95                       audencia   \n",
       "62     69                           enpc   \n",
       "32     35                        supelec   \n",
       "112  4024                           uvsq   \n",
       "185  9844              nantes-universite   \n",
       "27     30                          meteo   \n",
       "66     73                            ecp   \n",
       "125  4926            montpellier-supagro   \n",
       "111  3895                 normandie-univ   \n",
       "137  5815                         inshea   \n",
       "106  3775                          neoma   \n",
       "102   108                     esc-rennes   \n",
       "59     66                           iogs   \n",
       "57     64                        ensieta   \n",
       "31     34                           mnhn   \n",
       "181  9610                        ec-lyon   \n",
       "98    105                  clermont-univ   \n",
       "179  8897                            uco   \n",
       "140  5852                  agrosup-dijon   \n",
       "159  7314                            utt   \n",
       "39     43                     univ-lyon3   \n",
       "7       2                          inria   \n",
       "\n",
       "                                                  name  \\\n",
       "26   IRSN - Institut de Radioprotection et de Sûret...   \n",
       "64                             Hospices Civils de Lyon   \n",
       "22   INERIS - Institut National de l’EnviRonnement ...   \n",
       "139                                                EDF   \n",
       "149                            EM-LYON Business School   \n",
       "92                  ICP - Institut Catholique de Paris   \n",
       "162               École Nationale vétérinaire d'Alfort   \n",
       "97                     PSE - Paris School of Economics   \n",
       "67                                ESSEC BusinessSchool   \n",
       "81                    Université de Corse Pascal Paoli   \n",
       "15                    École des Mines de Saint-Étienne   \n",
       "113               Université Paris Dauphine - Paris IX   \n",
       "53                                                 HEC   \n",
       "107          USJ - Université Saint-Joseph de Beyrouth   \n",
       "29                          Université Paris Descartes   \n",
       "43                                Université de Nantes   \n",
       "83                                    Agrocampus Ouest   \n",
       "79                    Université Paris Diderot-Paris 7   \n",
       "129                                 Université de Lyon   \n",
       "156                                Université d'Angers   \n",
       "77                    Ecole de Management de Normandie   \n",
       "88                              Université de Rennes 1   \n",
       "16   IRD - Institut de recherche pour le développement   \n",
       "23             CEA - Commissariat à l’énergie atomique   \n",
       "163          Université Paris-Est Créteil Val-de-Marne   \n",
       "73                Université Paris-Est Marne-la-Vallée   \n",
       "35                  Université de Bretagne Occidentale   \n",
       "50                                 Université Paris 13   \n",
       "58   BRGM - Bureau de Recherches Géologiques et Min...   \n",
       "96                Université Francois Rabelais - Tours   \n",
       "130          Ecole des hautes études en santé publique   \n",
       "105                  UFC - Université de Franche-Comté   \n",
       "11                        UJM - Université Jean Monnet   \n",
       "95                           École des Mines de Nantes   \n",
       "104                            Université Bretagne Sud   \n",
       "54                                         Sciences Po   \n",
       "103                                        INSA Rennes   \n",
       "69                                         ESPCI Paris   \n",
       "157                                             ENSSIB   \n",
       "87   CSTB - Centre Scientifique et Technique du Bât...   \n",
       "30                Université Paris 1 Panthéon-Sorbonne   \n",
       "75                   Université Toulouse - Jean Jaurès   \n",
       "172         Université Paris, Sciences & Lettres - PSL   \n",
       "76             Université Toulouse III - Paul Sabatier   \n",
       "74                                    Chimie ParisTech   \n",
       "10                                              Inserm   \n",
       "110                            Université de Perpignan   \n",
       "55        Université d'Avignon et des Pays de Vaucluse   \n",
       "40                        Grenoble Ecole de Management   \n",
       "116                               Université d'Orléans   \n",
       "123                      Université Evry Val d’Essonne   \n",
       "85                    Bibliothèque nationale de France   \n",
       "150             Université de Technologie de Compiègne   \n",
       "72             EPHE - École pratique des hautes études   \n",
       "19                               Observatoire de Paris   \n",
       "42                                 Ecole polytechnique   \n",
       "128                                Université du Maine   \n",
       "136                                      INSA-Toulouse   \n",
       "109                           Université de la Réunion   \n",
       "91         ENAC - Ecole Nationale de l'Aviation Civile   \n",
       "164                            CHU de Clermont-Ferrand   \n",
       "160                        Ecole Nationale des Chartes   \n",
       "148                                Université de Lille   \n",
       "177                 Université de Picardie Jules Verne   \n",
       "94                                Université de Toulon   \n",
       "78                             Université des Antilles   \n",
       "155       Centre national de la recherche scientifique   \n",
       "118  Inalco - Institut National des Langues et Civi...   \n",
       "143                   Université Claude Bernard Lyon 1   \n",
       "124                               Université de Guyane   \n",
       "153                                        VetAgro Sup   \n",
       "180                Université du Littoral Côte d'Opale   \n",
       "6    IN2P3 - Institut national de physique nucléair...   \n",
       "37                               Université de Limoges   \n",
       "174                            Université Paris-Saclay   \n",
       "127                                Université Rennes 2   \n",
       "70                                         ENSTA Paris   \n",
       "71                               Rouen Business School   \n",
       "132                          Université de Montpellier   \n",
       "138              Université de Reims Champagne-Ardenne   \n",
       "99   ONERA - Office National d'Études et de Recherc...   \n",
       "115                             Université de Lorraine   \n",
       "141               Université de la Polynésie française   \n",
       "152  Cnam - Conservatoire national des arts et métiers   \n",
       "166                             École des Mines d'Alès   \n",
       "45                        Université Savoie Mont Blanc   \n",
       "52   Inrap - Institut national de recherches archéo...   \n",
       "122                          Université Paris Nanterre   \n",
       "24   INSU - Institut national des sciences de l'Uni...   \n",
       "101                           Aix-Marseille Université   \n",
       "90   Université Lille 3 - Sciences Humaines et Soci...   \n",
       "161                      Université Bordeaux Montaigne   \n",
       "47                                     MINES ParisTech   \n",
       "165                Université de la Nouvelle Calédonie   \n",
       "135                             Université de Poitiers   \n",
       "169                                Université de Paris   \n",
       "63                                 Sorbonne Université   \n",
       "168  Institut National de Recherche en Agriculture,...   \n",
       "133                          Université de La Rochelle   \n",
       "114             Université Sorbonne Nouvelle - Paris 3   \n",
       "151                                  Hal Lumière Lyon2   \n",
       "178                                          INSA Lyon   \n",
       "61                                       AgroParisTech   \n",
       "84                                  Université Paris 8   \n",
       "49                            Ecole Normale Supérieure   \n",
       "28                              Université Cote d'Azur   \n",
       "170                                  Collège de France   \n",
       "144           Université de Pau et des Pays de l'Adour   \n",
       "56                             Université de Bourgogne   \n",
       "44                              Institut Mines-Télécom   \n",
       "182                          Université Gustave Eiffel   \n",
       "93                           Université Grenoble Alpes   \n",
       "17                                               Cirad   \n",
       "18                                    Institut Pasteur   \n",
       "147                          CY Cergy Paris Université   \n",
       "134                          Université Paris Lumières   \n",
       "154                                      Télécom Paris   \n",
       "41                                 Université d'Artois   \n",
       "175               Université Paul Valéry Montpellier 3   \n",
       "146       Université Polytechnique des Hauts-de-France   \n",
       "121  Insep - Institut national du sport, de l'exper...   \n",
       "183                                              Isara   \n",
       "142                                     IMT Atlantique   \n",
       "100  École nationale supérieure des mines d'Albi-Ca...   \n",
       "86                            Audencia Business School   \n",
       "62                           Ecole des Ponts ParisTech   \n",
       "32                                             Supelec   \n",
       "112  Université de Versailles Saint-Quentin-en-Yvel...   \n",
       "185                                  Nantes Université   \n",
       "27                                        Météo-France   \n",
       "66                                Ecole Centrale Paris   \n",
       "125                                Montpellier SupAgro   \n",
       "111                               Normandie Université   \n",
       "137                                             INSHEA   \n",
       "106                              NEOMA Business School   \n",
       "102                             Rennes Business School   \n",
       "59                  Institut d'Optique Graduate School   \n",
       "57                                      ENSTA Bretagne   \n",
       "31         MNHN - Muséum national d'Histoire naturelle   \n",
       "181                             École Centrale de Lyon   \n",
       "98                        Université Clermont Auvergne   \n",
       "179                   Université Catholique de l'Ouest   \n",
       "140                                      AgroSup Dijon   \n",
       "159                Université de technologie de Troyes   \n",
       "39                       Université Jean Moulin Lyon 3   \n",
       "7                                                Inria   \n",
       "\n",
       "                                                   url   structId  \\\n",
       "26               https://hal-irsn.archives-ouvertes.fr   300040.0   \n",
       "64                https://hal-hcl.archives-ouvertes.fr   300074.0   \n",
       "22             https://hal-ineris.archives-ouvertes.fr     3186.0   \n",
       "139               https://hal-edf.archives-ouvertes.fr   302313.0   \n",
       "149                            https://hal.em-lyon.com   301362.0   \n",
       "92                https://hal-icp.archives-ouvertes.fr   301937.0   \n",
       "162              https://hal-enva.archives-ouvertes.fr    34256.0   \n",
       "97                https://hal-pse.archives-ouvertes.fr   301309.0   \n",
       "67              https://hal-essec.archives-ouvertes.fr   301020.0   \n",
       "81         https://hal-univ-corse.archives-ouvertes.fr   508779.0   \n",
       "15                       https://hal-emse.ccsd.cnrs.fr   359750.0   \n",
       "113  https://hal-univ-paris-dauphine.archives-ouver...   300302.0   \n",
       "53                https://hal-hec.archives-ouvertes.fr   105633.0   \n",
       "107               https://hal-usj.archives-ouvertes.fr   301405.0   \n",
       "29          https://hal-descartes.archives-ouvertes.fr   301664.0   \n",
       "43                           http://hal.univ-nantes.fr    93263.0   \n",
       "83   https://hal-agrocampus-ouest.archives-ouvertes.fr   108028.0   \n",
       "79       https://hal-univ-diderot.archives-ouvertes.fr   300301.0   \n",
       "129               https://hal-udl.archives-ouvertes.fr   301088.0   \n",
       "156                         https://hal.univ-angers.fr    74911.0   \n",
       "77       https://hal-em-normandie.archives-ouvertes.fr   301735.0   \n",
       "88       https://hal-univ-rennes1.archives-ouvertes.fr   105160.0   \n",
       "16                                  https://hal.ird.fr    67872.0   \n",
       "23                https://hal-cea.archives-ouvertes.fr   300016.0   \n",
       "163                              https://hal.u-pec.fr/   420786.0   \n",
       "73          https://hal-upec-upem.archives-ouvertes.fr   301243.0   \n",
       "35                           https://hal.univ-brest.fr   300314.0   \n",
       "50       https://hal-univ-paris13.archives-ouvertes.fr    15786.0   \n",
       "58               https://hal-brgm.archives-ouvertes.fr    18404.0   \n",
       "96         https://hal-univ-tours.archives-ouvertes.fr   300298.0   \n",
       "130                               https://hal.ehesp.fr   301986.0   \n",
       "105       https://hal-univ-fcomte.archives-ouvertes.fr   458810.0   \n",
       "11                https://hal-ujm.archives-ouvertes.fr   300284.0   \n",
       "95       https://hal-mines-nantes.archives-ouvertes.fr    84538.0   \n",
       "104          https://hal-univ-ubs.archives-ouvertes.fr   172265.0   \n",
       "54         https://hal-sciencespo.archives-ouvertes.fr   301587.0   \n",
       "103       https://hal-insa-rennes.archives-ouvertes.fr   117606.0   \n",
       "69              https://hal-espci.archives-ouvertes.fr   301585.0   \n",
       "157            https://hal-enssib.archives-ouvertes.fr    43938.0   \n",
       "87               https://hal-cstb.archives-ouvertes.fr   300021.0   \n",
       "30             https://hal-paris1.archives-ouvertes.fr     7550.0   \n",
       "75         https://hal-univ-tlse2.archives-ouvertes.fr   116256.0   \n",
       "172               https://hal-psl.archives-ouvertes.fr   564132.0   \n",
       "76         https://hal-univ-tlse3.archives-ouvertes.fr   217752.0   \n",
       "74              https://hal-enscp.archives-ouvertes.fr   300372.0   \n",
       "10                           https://www.hal.inserm.fr   303623.0   \n",
       "110         https://hal-univ-perp.archives-ouvertes.fr   101475.0   \n",
       "55       https://hal-univ-avignon.archives-ouvertes.fr   195507.0   \n",
       "40                          http://hal.grenoble-em.com   220014.0   \n",
       "116      https://hal-univ-orleans.archives-ouvertes.fr   300297.0   \n",
       "123         https://hal-univ-evry.archives-ouvertes.fr   300306.0   \n",
       "85                https://hal-bnf.archives-ouvertes.fr   302209.0   \n",
       "150                                 https://hal.utc.fr    93027.0   \n",
       "72               https://hal-ephe.archives-ouvertes.fr   110691.0   \n",
       "19                      https://hal-obspm.ccsd.cnrs.fr   300055.0   \n",
       "42      https://hal-polytechnique.archives-ouvertes.fr   300340.0   \n",
       "128       https://hal-univ-lemans.archives-ouvertes.fr     7566.0   \n",
       "136                       https://hal.insa-toulouse.fr   116255.0   \n",
       "109                        https://hal.univ-reunion.fr   300316.0   \n",
       "91               https://hal-enac.archives-ouvertes.fr   380071.0   \n",
       "164  https://hal-chu-clermontferrand.archives-ouver...  1082719.0   \n",
       "160               https://hal-enc.archives-ouvertes.fr   307249.0   \n",
       "148                          https://hal.univ-lille.fr   374570.0   \n",
       "177        https://hal-u-picardie.archives-ouvertes.fr   300258.0   \n",
       "94           https://hal-univ-tln.archives-ouvertes.fr   303091.0   \n",
       "78                        https://hal.univ-antilles.fr   466882.0   \n",
       "155              https://hal-cnrs.archives-ouvertes.fr   441569.0   \n",
       "118            https://hal-inalco.archives-ouvertes.fr   300064.0   \n",
       "143        https://hal-univ-lyon1.archives-ouvertes.fr   194495.0   \n",
       "124                         https://hal.univ-guyane.fr   424370.0   \n",
       "153       https://hal-vetagro-sup.archives-ouvertes.fr   301767.0   \n",
       "180              https://hal-ulco.archives-ouvertes.fr   301404.0   \n",
       "6                                  http://hal.in2p3.fr   300046.0   \n",
       "37             https://hal-unilim.archives-ouvertes.fr     5928.0   \n",
       "174  https://hal-universite-paris-saclay.archives-o...   419361.0   \n",
       "127                        https://hal.univ-rennes2.fr   406201.0   \n",
       "70       https://hal-ensta-paris.archives-ouvertes.fr/   300065.0   \n",
       "71                https://hal-rbs.archives-ouvertes.fr   301663.0   \n",
       "132                        https://hal.umontpellier.fr   410122.0   \n",
       "138                          https://hal.univ-reims.fr     7569.0   \n",
       "99              https://hal-onera.archives-ouvertes.fr   300024.0   \n",
       "115                       https://hal.univ-lorraine.fr   413289.0   \n",
       "141               https://hal-upf.archives-ouvertes.fr   300327.0   \n",
       "152              https://hal-cnam.archives-ouvertes.fr   300351.0   \n",
       "166                          https://hal.mines-ales.fr     6279.0   \n",
       "45                              http://hal.univ-smb.fr   432896.0   \n",
       "52              https://hal-inrap.archives-ouvertes.fr   301475.0   \n",
       "122                      https://hal.parisnanterre.fr/   116205.0   \n",
       "24               https://hal-insu.archives-ouvertes.fr   300045.0   \n",
       "101               https://hal-amu.archives-ouvertes.fr   198056.0   \n",
       "90                          https://hal.univ-lille3.fr   301700.0   \n",
       "161  https://hal-u-bordeaux-montaigne.archives-ouve...   412629.0   \n",
       "47    https://hal-mines-paristech.archives-ouvertes.fr   301492.0   \n",
       "165               https://hal-unc.archives-ouvertes.fr   300328.0   \n",
       "135     https://hal-univ-poitiers.archives-ouvertes.fr    54493.0   \n",
       "169        https://hal-univ-paris.archives-ouvertes.fr   557826.0   \n",
       "63                  https://hal.sorbonne-universite.fr   413221.0   \n",
       "168                               https://hal.inrae.fr   577435.0   \n",
       "133     https://hal-univ-rochelle.archives-ouvertes.fr   300311.0   \n",
       "114       https://hal-univ-paris3.archives-ouvertes.fr    52995.0   \n",
       "151                          https://hal.univ-lyon2.fr    33804.0   \n",
       "178         https://hal-insa-lyon.archives-ouvertes.fr   219748.0   \n",
       "61      https://hal-agroparistech.archives-ouvertes.fr   148117.0   \n",
       "84        https://hal-univ-paris8.archives-ouvertes.fr    11141.0   \n",
       "49                https://hal-ens.archives-ouvertes.fr    59704.0   \n",
       "28                       https://hal.univ-cotedazur.fr  1039632.0   \n",
       "170  https://hal-college-de-france.archives-ouverte...   300026.0   \n",
       "144          https://hal-univ-pau.archives-ouvertes.fr   301085.0   \n",
       "56     https://hal-univ-bourgogne.archives-ouvertes.fr   300270.0   \n",
       "44                https://hal-imt.archives-ouvertes.fr   302102.0   \n",
       "182       https://hal-univ-eiffel.archives-ouvertes.fr   580722.0   \n",
       "93                  https://hal.univ-grenoble-alpes.fr  1042703.0   \n",
       "17                                 http://hal.cirad.fr    11574.0   \n",
       "18            https://hal-pasteur.archives-ouvertes.fr   300027.0   \n",
       "147              https://hal-cyu.archives-ouvertes.fr/  1003413.0   \n",
       "134  https://hal-univ-paris-lumieres.archives-ouver...   475360.0   \n",
       "154                       https://hal.telecom-paris.fr  1048346.0   \n",
       "41        https://hal-univ-artois.archives-ouvertes.fr    56711.0   \n",
       "175  https://hal-univ-montpellier3-paul-valery.arch...    42812.0   \n",
       "146              https://hal-uphf.archives-ouvertes.fr  1001263.0   \n",
       "121             https://hal-insep.archives-ouvertes.fr   441096.0   \n",
       "183             https://hal-isara.archives-ouvertes.fr  1081289.0   \n",
       "142    https://hal-imt-atlantique.archives-ouvertes.fr   481355.0   \n",
       "100        https://hal-mines-albi.archives-ouvertes.fr   469216.0   \n",
       "86           https://hal-audencia.archives-ouvertes.fr   456031.0   \n",
       "62               https://hal-enpc.archives-ouvertes.fr   301545.0   \n",
       "32            https://hal-supelec.archives-ouvertes.fr   303397.0   \n",
       "112                                https://hal.uvsq.fr    81173.0   \n",
       "185  https://hal-nantes-universite.archives-ouverte...  1083366.0   \n",
       "27        https://hal-meteofrance.archives-ouvertes.fr  1079823.0   \n",
       "66                https://hal-ecp.archives-ouvertes.fr   300342.0   \n",
       "125  https://hal-montpellier-supagro.archives-ouver...  1090073.0   \n",
       "111    https://hal-normandie-univ.archives-ouvertes.fr   455934.0   \n",
       "137            https://hal-inshea.archives-ouvertes.fr   308431.0   \n",
       "106          https://hal-neoma-bs.archives-ouvertes.fr   232915.0   \n",
       "102         https://hal-rennes-sb.archives-ouvertes.fr   301752.0   \n",
       "59               https://hal-iogs.archives-ouvertes.fr   300036.0   \n",
       "57     https://hal-ensta-bretagne.archives-ouvertes.fr   301846.0   \n",
       "31               https://hal-mnhn.archives-ouvertes.fr     7512.0   \n",
       "181           https://hal-ec-lyon.archives-ouvertes.fr   126765.0   \n",
       "98                                  https://hal.uca.fr  1063463.0   \n",
       "179               https://hal-uco.archives-ouvertes.fr   300844.0   \n",
       "140     https://hal-agrosup-dijon.archives-ouvertes.fr   415469.0   \n",
       "159               https://hal-utt.archives-ouvertes.fr    93484.0   \n",
       "39         https://hal-univ-lyon3.archives-ouvertes.fr   118744.0   \n",
       "7                                 https://hal.inria.fr   300009.0   \n",
       "\n",
       "                                         structId_name  nb_struct  \\\n",
       "26                                                None        280   \n",
       "64   Hospices Civils de Lyon, Departement de Neurol...        478   \n",
       "22                                                None         14   \n",
       "139                                          EDF [EDF]         74   \n",
       "149                                               None          4   \n",
       "92                                                None          8   \n",
       "162                                               None        104   \n",
       "97                                                None          6   \n",
       "67                                                None         24   \n",
       "81                                                None          3   \n",
       "15                                                None         14   \n",
       "113                                               None         55   \n",
       "53   Faculté des Hautes Etudes Commerciales (HEC La...          8   \n",
       "107                                               None         97   \n",
       "29                                                None        704   \n",
       "43   Institut de Recherche en Santé de l'Université...        263   \n",
       "83                                                None         94   \n",
       "79                                                None        869   \n",
       "129                                               None        107   \n",
       "156                           Université d'Angers [UA]        233   \n",
       "77     École de Management de Normandie [EM Normandie]          2   \n",
       "88                        Université de Rennes 1 [UR1]        396   \n",
       "16                                                None        240   \n",
       "23                                                None        830   \n",
       "163  Université Paris-Est Créteil Val-de-Marne - Pa...        313   \n",
       "73                                                None         63   \n",
       "35                                                None        259   \n",
       "50                          Université Paris 13 [UP13]        172   \n",
       "58                                                None         25   \n",
       "96                                                None        164   \n",
       "130  École des Hautes Études en Santé Publique [EHE...         36   \n",
       "105                                               None        204   \n",
       "11                                                None        165   \n",
       "95                                                None         16   \n",
       "104                                               None         80   \n",
       "54   Sciences Po Lyon - Institut d'études politique...         29   \n",
       "103                                               None         29   \n",
       "69                                                None         91   \n",
       "157                                               None          6   \n",
       "87                                                None          6   \n",
       "30          Université Paris 1 Panthéon-Sorbonne [UP1]        228   \n",
       "75            Université Toulouse - Jean Jaurès [UT2J]        113   \n",
       "172                                               None         37   \n",
       "76       Université Toulouse III - Paul Sabatier [UT3]        346   \n",
       "74   Ecole Nationale Supérieure de Chimie de Paris ...         42   \n",
       "10   Pôle des Cardiopathies Congénitales du Nouveau...       2607   \n",
       "110         Université de Perpignan Via Domitia [UPVD]         86   \n",
       "55                                                None         70   \n",
       "40                        Grenoble Ecole de Management         28   \n",
       "116                          Université d'Orléans [UO]        154   \n",
       "123                                               None        104   \n",
       "85                    Bibliothèque Nationale de France          4   \n",
       "150       Université de Technologie de Compiègne [UTC]         24   \n",
       "72                                                None        134   \n",
       "19                               Observatoire de Paris         52   \n",
       "42               École Polytechnique de Montréal [EPM]         96   \n",
       "128                                               None         60   \n",
       "136                                               None         43   \n",
       "109                      Université de La Réunion [UR]        106   \n",
       "91                                                None         15   \n",
       "164                                               None          5   \n",
       "160                  École nationale des chartes [ENC]          5   \n",
       "148  Faculté de Médecine Henri Warembourg - Univers...        133   \n",
       "177          Université de Picardie Jules Verne [UPJV]        102   \n",
       "94                         Université de Toulon [UTLN]         65   \n",
       "78           Université des Antilles (Pôle Martinique)         11   \n",
       "155  Centre National de la Recherche Scientifique e...       5561   \n",
       "118                                               None         52   \n",
       "143            Université Claude Bernard Lyon 1 [UCBL]        352   \n",
       "124                          Université de Guyane [UG]         14   \n",
       "153  VetAgro Sup - Institut national d'enseignement...         50   \n",
       "180         Université du Littoral Côte d'Opale [ULCO]         43   \n",
       "6                                                 None         60   \n",
       "37                      Université de Limoges [UNILIM]         61   \n",
       "174                     AP-HP. Université Paris Saclay        243   \n",
       "127                                               None        132   \n",
       "70                                                None         10   \n",
       "71                                                None         10   \n",
       "132                     Université de Montpellier [UM]        192   \n",
       "138       Université de Reims Champagne-Ardenne [URCA]        132   \n",
       "99                                                None         75   \n",
       "115                        Université de Lorraine [UL]        152   \n",
       "141         Université de la Polynésie Française [UPF]         12   \n",
       "152                                               None        166   \n",
       "166                                               None         13   \n",
       "45   Université Savoie Mont Blanc [USMB [Université...         59   \n",
       "52                                                None         15   \n",
       "122                    Université Paris Nanterre [UPN]        137   \n",
       "24                                                None        199   \n",
       "101                     Aix Marseille Université [AMU]        252   \n",
       "90                                                None         32   \n",
       "161                      Université Bordeaux Montaigne         66   \n",
       "47                           Fondation MINES ParisTech         50   \n",
       "165          Université de la Nouvelle-Calédonie [UNC]         17   \n",
       "135                             Université de Poitiers        191   \n",
       "169  Unité de Gynécologie Médicale, AP-HP, Hôpital ...        535   \n",
       "63                                                None        392   \n",
       "168                                               None        505   \n",
       "133                                               None         51   \n",
       "114             Université Sorbonne Nouvelle - Paris 3         63   \n",
       "151                                               None        115   \n",
       "178                                               None         95   \n",
       "61                                       AgroParisTech         97   \n",
       "84      Université Paris 8 Vincennes-Saint-Denis [UP8]        107   \n",
       "49   École normale supérieure - Constantine [ENS Co...        108   \n",
       "28                                                None        112   \n",
       "170              Collège de France [CdF (institution)]        113   \n",
       "144    Université de Pau et des Pays de l'Adour [UPPA]         58   \n",
       "56                        Université de Bourgogne [UB]        181   \n",
       "44     Institut Mines-Télécom Business School [IMT-BS]         61   \n",
       "182                          Université Gustave Eiffel         76   \n",
       "93                                                None        137   \n",
       "17                                                None        203   \n",
       "18                      Institut Pasteur de Madagascar       1003   \n",
       "147                     CY Cergy Paris Université [CY]         37   \n",
       "134                                               None          1   \n",
       "154                                      Télécom Paris          3   \n",
       "41                            Université d'Artois [UA]         40   \n",
       "175                                               None         84   \n",
       "146                                               None         21   \n",
       "121                                               None          5   \n",
       "183                                  ISARA Corporation          1   \n",
       "142  IMT Atlantique Bretagne-Pays de la Loire [IMT ...         44   \n",
       "100  IMT École nationale supérieure des Mines d'Alb...          7   \n",
       "86                            Audencia Business School          1   \n",
       "62                    École des Ponts ParisTech [ENPC]         62   \n",
       "32   Ecole Supérieure d'Electricité - SUPELEC (FRANCE)         11   \n",
       "112  Université de Versailles Saint-Quentin-en-Yvel...         82   \n",
       "185                     Nantes Université - pôle Santé         22   \n",
       "27                                        Météo-France         21   \n",
       "66                                                None         13   \n",
       "125                                               None         25   \n",
       "111                                               None          9   \n",
       "137                                               None          1   \n",
       "106                      Neoma Business School [NEOMA]          1   \n",
       "102                                               None          1   \n",
       "59           Institut d'Optique Graduate School [IOGS]          7   \n",
       "57                                                None         18   \n",
       "31                                                None        141   \n",
       "181                       École Centrale de Lyon [ECL]         25   \n",
       "98                                                None         63   \n",
       "179             Université Catholique de l'Ouest [UCO]         22   \n",
       "140                                               None         31   \n",
       "159          Université de Technologie de Troyes [UTT]          8   \n",
       "39                                                None         56   \n",
       "7                                 Unknown Labs [Inria]         93   \n",
       "\n",
       "     nb_struct_incoming     noise  \n",
       "26                  249  0.889286  \n",
       "64                  421  0.880753  \n",
       "22                   12  0.857143  \n",
       "139                  56  0.756757  \n",
       "149                   3  0.750000  \n",
       "92                    6  0.750000  \n",
       "162                  76  0.730769  \n",
       "97                    4  0.666667  \n",
       "67                   16  0.666667  \n",
       "81                    2  0.666667  \n",
       "15                    9  0.642857  \n",
       "113                  35  0.636364  \n",
       "53                    5  0.625000  \n",
       "107                  59  0.608247  \n",
       "29                  411  0.583807  \n",
       "43                  148  0.562738  \n",
       "83                   52  0.553191  \n",
       "79                  476  0.547756  \n",
       "129                  57  0.532710  \n",
       "156                 117  0.502146  \n",
       "77                    1  0.500000  \n",
       "88                  187  0.472222  \n",
       "16                  112  0.466667  \n",
       "23                  381  0.459036  \n",
       "163                 143  0.456869  \n",
       "73                   28  0.444444  \n",
       "35                  114  0.440154  \n",
       "50                   70  0.406977  \n",
       "58                   10  0.400000  \n",
       "96                   64  0.390244  \n",
       "130                  14  0.388889  \n",
       "105                  79  0.387255  \n",
       "11                   62  0.375758  \n",
       "95                    6  0.375000  \n",
       "104                  29  0.362500  \n",
       "54                   10  0.344828  \n",
       "103                  10  0.344828  \n",
       "69                   31  0.340659  \n",
       "157                   2  0.333333  \n",
       "87                    2  0.333333  \n",
       "30                   76  0.333333  \n",
       "75                   37  0.327434  \n",
       "172                  12  0.324324  \n",
       "76                  109  0.315029  \n",
       "74                   13  0.309524  \n",
       "10                  790  0.303030  \n",
       "110                  26  0.302326  \n",
       "55                   21  0.300000  \n",
       "40                    8  0.285714  \n",
       "116                  44  0.285714  \n",
       "123                  28  0.269231  \n",
       "85                    1  0.250000  \n",
       "150                   6  0.250000  \n",
       "72                   33  0.246269  \n",
       "19                   12  0.230769  \n",
       "42                   21  0.218750  \n",
       "128                  13  0.216667  \n",
       "136                   9  0.209302  \n",
       "109                  22  0.207547  \n",
       "91                    3  0.200000  \n",
       "164                   1  0.200000  \n",
       "160                   1  0.200000  \n",
       "148                  25  0.187970  \n",
       "177                  19  0.186275  \n",
       "94                   12  0.184615  \n",
       "78                    2  0.181818  \n",
       "155                 999  0.179644  \n",
       "118                   8  0.153846  \n",
       "143                  51  0.144886  \n",
       "124                   2  0.142857  \n",
       "153                   7  0.140000  \n",
       "180                   6  0.139535  \n",
       "6                     8  0.133333  \n",
       "37                    8  0.131148  \n",
       "174                  31  0.127572  \n",
       "127                  14  0.106061  \n",
       "70                    1  0.100000  \n",
       "71                    1  0.100000  \n",
       "132                  19  0.098958  \n",
       "138                  13  0.098485  \n",
       "99                    7  0.093333  \n",
       "115                  14  0.092105  \n",
       "141                   1  0.083333  \n",
       "152                  13  0.078313  \n",
       "166                   1  0.076923  \n",
       "45                    4  0.067797  \n",
       "52                    1  0.066667  \n",
       "122                   9  0.065693  \n",
       "24                   13  0.065327  \n",
       "101                  16  0.063492  \n",
       "90                    2  0.062500  \n",
       "161                   4  0.060606  \n",
       "47                    3  0.060000  \n",
       "165                   1  0.058824  \n",
       "135                  11  0.057592  \n",
       "169                  27  0.050467  \n",
       "63                   18  0.045918  \n",
       "168                  21  0.041584  \n",
       "133                   2  0.039216  \n",
       "114                   2  0.031746  \n",
       "151                   3  0.026087  \n",
       "178                   2  0.021053  \n",
       "61                    2  0.020619  \n",
       "84                    2  0.018692  \n",
       "49                    2  0.018519  \n",
       "28                    2  0.017857  \n",
       "170                   2  0.017699  \n",
       "144                   1  0.017241  \n",
       "56                    3  0.016575  \n",
       "44                    1  0.016393  \n",
       "182                   1  0.013158  \n",
       "93                    1  0.007299  \n",
       "17                    1  0.004926  \n",
       "18                    2  0.001994  \n",
       "147                   0  0.000000  \n",
       "134                   0  0.000000  \n",
       "154                   0  0.000000  \n",
       "41                    0  0.000000  \n",
       "175                   0  0.000000  \n",
       "146                   0  0.000000  \n",
       "121                   0  0.000000  \n",
       "183                   0  0.000000  \n",
       "142                   0  0.000000  \n",
       "100                   0  0.000000  \n",
       "86                    0  0.000000  \n",
       "62                    0  0.000000  \n",
       "32                    0  0.000000  \n",
       "112                   0  0.000000  \n",
       "185                   0  0.000000  \n",
       "27                    0  0.000000  \n",
       "66                    0  0.000000  \n",
       "125                   0  0.000000  \n",
       "111                   0  0.000000  \n",
       "137                   0  0.000000  \n",
       "106                   0  0.000000  \n",
       "102                   0  0.000000  \n",
       "59                    0  0.000000  \n",
       "57                    0  0.000000  \n",
       "31                    0  0.000000  \n",
       "181                   0  0.000000  \n",
       "98                    0  0.000000  \n",
       "179                   0  0.000000  \n",
       "140                   0  0.000000  \n",
       "159                   0  0.000000  \n",
       "39                    0  0.000000  \n",
       "7                     0  0.000000  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# imprimer les résultats pour les étab où il y au moins une structure\n",
    "portail_etab.sort_values(\"noise\", ascending = False, inplace = True)\n",
    "portail_etab[ portail_etab[\"nb_struct\"] > 0 ]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "47fb147f",
   "metadata": {},
   "source": [
    "* extraire les données "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "eed7b2b4",
   "metadata": {},
   "outputs": [],
   "source": [
    "# preciser la date dans le nom du fichier extrait\n",
    "csv_file_name = \"2022-06-aurehal-struct-noise-level-per-institution\"\n",
    "portail_noise.to_csv(f\"../data/{csv_file_name}.csv\", index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "68fca6c9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    146.000000\n",
       "mean       0.213932\n",
       "std        0.232897\n",
       "min        0.000000\n",
       "25%        0.016439\n",
       "50%        0.132240\n",
       "75%        0.343786\n",
       "max        0.889286\n",
       "Name: noise, dtype: float64"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#imprimer les stats sur l'indicateur\n",
    "portail_noise[\"noise\"].describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "799dc0e3",
   "metadata": {},
   "source": [
    "---\n",
    "Allez plus loin \n",
    "    \n",
    "\n",
    "* récursif : comptes les \"incoming\" au sein des structures filles de la struct de l'établissement #attention couteut en temps de requête"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}