demo/get_anr_research_project.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "c3c07384",
   "metadata": {},
   "source": [
    "# Récupérer les projets de recherche ANR portés par son établissememnt\n",
    "**A l'aide des identifiants RNSR**"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8c98b1ae",
   "metadata": {},
   "source": [
    "0. télécharger les jeux de données\n",
    "\n",
    "\n",
    "1. importer les données des partenaires, comprendre le schéma de données\n",
    "\n",
    "\n",
    "2. récupérer les RNSRs de son établissement via l'API de AureHAL Structure\n",
    "    - comprendre l'API AureHAL Structure\n",
    "    - quel champs utiliser pour identifier les sous structures de son étab. ? \n",
    "    - extraire un tableau de vos structures avec les donénes docid,name_s,type_s,valid_s,rnsr_s\n",
    "    - _à la main_ renseigner dans AureHAL les RNSRs manquants\n",
    "    - placer les RNSRs dans une liste\n",
    "    - nettoyer les données\n",
    "   \n",
    "   \n",
    "3. filtrer les données ANR des partenaires avec les RNSR récoltés\n",
    "    - exporter un csv"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "da8116a0",
   "metadata": {},
   "source": [
    "----\n",
    "\n",
    "\n",
    "## 0. télécharger les jeux de données\n",
    "[https://www.data.gouv.fr/en/datasets/anr-01-projets-anr-dos-detail-des-projets-et-des-partenaires/](https://www.data.gouv.fr/en/datasets/anr-01-projets-anr-dos-detail-des-projets-et-des-partenaires/)\n",
    "\n",
    "attention le schéma de données peut évoluer"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3b76c8d1",
   "metadata": {},
   "source": [
    "## 1. importer les données des partenaires"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "2fbb88e7",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "161848b9",
   "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>Projet.Code_Decision_ANR</th>\n",
       "      <th>Projet.Acronyme</th>\n",
       "      <th>Projet.Partenaire.Code_Decision_ANR</th>\n",
       "      <th>Projet.Partenaire.Est_coordinateur</th>\n",
       "      <th>Projet.Partenaire.Nom_organisme</th>\n",
       "      <th>Projet.Partenaire.Categorie_organisme</th>\n",
       "      <th>Projet.Partenaire.Code_RNSR</th>\n",
       "      <th>Projet.Partenaire.Responsable_scientifique.Nom</th>\n",
       "      <th>Projet.Partenaire.Responsable_scientifique.Prenom</th>\n",
       "      <th>Projet.Partenaire.Adresse.Ville</th>\n",
       "      <th>Projet.Partenaire.Adresse.Region</th>\n",
       "      <th>Projet.Partenaire.Adresse.Pays</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>25958</th>\n",
       "      <td>ANR-17-CE11-0024</td>\n",
       "      <td>H4translation</td>\n",
       "      <td>ANR-17-CE11-0024-01</td>\n",
       "      <td>True</td>\n",
       "      <td>Architecture et Réactivité de lARN</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>199317388K</td>\n",
       "      <td>ERIANI</td>\n",
       "      <td>Gilbert</td>\n",
       "      <td>Strasbourg</td>\n",
       "      <td>Grand Est</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2076</th>\n",
       "      <td>ANR-20-COVI-0034</td>\n",
       "      <td>CoCo</td>\n",
       "      <td>ANR-20-COVI-0034-01</td>\n",
       "      <td>True</td>\n",
       "      <td>Observatoire sociologique du changement</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>198821638B</td>\n",
       "      <td>RECCHI</td>\n",
       "      <td>Ettore</td>\n",
       "      <td>PARIS</td>\n",
       "      <td>Ile-de-France</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62072</th>\n",
       "      <td>ANR-10-BIOT-0006</td>\n",
       "      <td>DbaitTherap</td>\n",
       "      <td>ANR-10-BIOT-0006-04</td>\n",
       "      <td>False</td>\n",
       "      <td>UNIVERSITE DE VERSAILLES - SAINT-QUENTIN - EN ...</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SAIAG</td>\n",
       "      <td>Philippe</td>\n",
       "      <td>Boulogne-Billancourt</td>\n",
       "      <td>Île-de-France</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33311</th>\n",
       "      <td>ANR-15-CE38-0009</td>\n",
       "      <td>INVENTHEA</td>\n",
       "      <td>ANR-15-CE38-0009-02</td>\n",
       "      <td>False</td>\n",
       "      <td>Laboratoire de Mécanique et dAcoustique</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>199617659S</td>\n",
       "      <td>GUILLEMAIN</td>\n",
       "      <td>Philippe</td>\n",
       "      <td>Marseille</td>\n",
       "      <td>Provence-Alpes-Côte d'Azur</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34147</th>\n",
       "      <td>ANR-15-CE24-0028</td>\n",
       "      <td>OLOVIA</td>\n",
       "      <td>ANR-15-CE24-0028-04</td>\n",
       "      <td>False</td>\n",
       "      <td>UNITY SEMICONDUCTOR</td>\n",
       "      <td>PME</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALLIATA</td>\n",
       "      <td>Dario</td>\n",
       "      <td>Montbonnot-Saint-Martin</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49039</th>\n",
       "      <td>ANR-12-BSV5-0003</td>\n",
       "      <td>MAX4US</td>\n",
       "      <td>ANR-12-BSV5-0003-02</td>\n",
       "      <td>False</td>\n",
       "      <td>SPCSI</td>\n",
       "      <td>Divers public</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BERTHELOT</td>\n",
       "      <td>Thomas</td>\n",
       "      <td>Gif-sur-Yvette</td>\n",
       "      <td>Île-de-France</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15253</th>\n",
       "      <td>ANR-19-CE05-0032</td>\n",
       "      <td>UPGEO</td>\n",
       "      <td>ANR-19-CE05-0032-05</td>\n",
       "      <td>False</td>\n",
       "      <td>GEORESSOURCES &amp; ENVIRONNEMENT</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>201119423U</td>\n",
       "      <td>BOURILLOT</td>\n",
       "      <td>Raphaël</td>\n",
       "      <td>Pessac</td>\n",
       "      <td>Nouvelle-Aquitaine</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61049</th>\n",
       "      <td>ANR-10-BLAN-0946</td>\n",
       "      <td>FELINS</td>\n",
       "      <td>ANR-10-BLAN-0946-01</td>\n",
       "      <td>True</td>\n",
       "      <td>CENTRE NATIONAL DE LA RECHERCHE SCIENTIFIQUE -...</td>\n",
       "      <td>Divers public</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CANIONI</td>\n",
       "      <td>Lionel</td>\n",
       "      <td>Talence</td>\n",
       "      <td>Nouvelle-Aquitaine</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6939</th>\n",
       "      <td>ANR-20-CE13-0027</td>\n",
       "      <td>INFER-ANTH</td>\n",
       "      <td>ANR-20-CE13-0027-01</td>\n",
       "      <td>True</td>\n",
       "      <td>REPRODUCTION ET DEVELOPPEMENT DES PLANTES</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>200317442A</td>\n",
       "      <td>SCUTT</td>\n",
       "      <td>Charles</td>\n",
       "      <td>LYON CEDEX 07</td>\n",
       "      <td>Auvergne-Rhône-Alpes</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33225</th>\n",
       "      <td>ANR-15-CE39-0016</td>\n",
       "      <td>VIORAMIL</td>\n",
       "      <td>ANR-15-CE39-0016-02</td>\n",
       "      <td>False</td>\n",
       "      <td>Centre de Recherche sur les Médiations</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>200114752K</td>\n",
       "      <td>WALTER</td>\n",
       "      <td>Jacques</td>\n",
       "      <td>Metz</td>\n",
       "      <td>Grand Est</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Projet.Code_Decision_ANR Projet.Acronyme  \\\n",
       "25958         ANR-17-CE11-0024   H4translation   \n",
       "2076          ANR-20-COVI-0034            CoCo   \n",
       "62072         ANR-10-BIOT-0006     DbaitTherap   \n",
       "33311         ANR-15-CE38-0009       INVENTHEA   \n",
       "34147         ANR-15-CE24-0028          OLOVIA   \n",
       "49039         ANR-12-BSV5-0003          MAX4US   \n",
       "15253         ANR-19-CE05-0032           UPGEO   \n",
       "61049         ANR-10-BLAN-0946          FELINS   \n",
       "6939          ANR-20-CE13-0027      INFER-ANTH   \n",
       "33225         ANR-15-CE39-0016        VIORAMIL   \n",
       "\n",
       "      Projet.Partenaire.Code_Decision_ANR  Projet.Partenaire.Est_coordinateur  \\\n",
       "25958                 ANR-17-CE11-0024-01                                True   \n",
       "2076                  ANR-20-COVI-0034-01                                True   \n",
       "62072                 ANR-10-BIOT-0006-04                               False   \n",
       "33311                 ANR-15-CE38-0009-02                               False   \n",
       "34147                 ANR-15-CE24-0028-04                               False   \n",
       "49039                 ANR-12-BSV5-0003-02                               False   \n",
       "15253                 ANR-19-CE05-0032-05                               False   \n",
       "61049                 ANR-10-BLAN-0946-01                                True   \n",
       "6939                  ANR-20-CE13-0027-01                                True   \n",
       "33225                 ANR-15-CE39-0016-02                               False   \n",
       "\n",
       "                         Projet.Partenaire.Nom_organisme  \\\n",
       "25958                 Architecture et Réactivité de lARN   \n",
       "2076             Observatoire sociologique du changement   \n",
       "62072  UNIVERSITE DE VERSAILLES - SAINT-QUENTIN - EN ...   \n",
       "33311            Laboratoire de Mécanique et dAcoustique   \n",
       "34147                                UNITY SEMICONDUCTOR   \n",
       "49039                                              SPCSI   \n",
       "15253                      GEORESSOURCES & ENVIRONNEMENT   \n",
       "61049  CENTRE NATIONAL DE LA RECHERCHE SCIENTIFIQUE -...   \n",
       "6939           REPRODUCTION ET DEVELOPPEMENT DES PLANTES   \n",
       "33225             Centre de Recherche sur les Médiations   \n",
       "\n",
       "      Projet.Partenaire.Categorie_organisme Projet.Partenaire.Code_RNSR  \\\n",
       "25958                    Laboratoire public                  199317388K   \n",
       "2076                     Laboratoire public                  198821638B   \n",
       "62072                    Laboratoire public                         NaN   \n",
       "33311                    Laboratoire public                  199617659S   \n",
       "34147                                   PME                         NaN   \n",
       "49039                         Divers public                         NaN   \n",
       "15253                    Laboratoire public                  201119423U   \n",
       "61049                         Divers public                         NaN   \n",
       "6939                     Laboratoire public                  200317442A   \n",
       "33225                    Laboratoire public                  200114752K   \n",
       "\n",
       "      Projet.Partenaire.Responsable_scientifique.Nom  \\\n",
       "25958                                         ERIANI   \n",
       "2076                                          RECCHI   \n",
       "62072                                          SAIAG   \n",
       "33311                                     GUILLEMAIN   \n",
       "34147                                        ALLIATA   \n",
       "49039                                      BERTHELOT   \n",
       "15253                                      BOURILLOT   \n",
       "61049                                        CANIONI   \n",
       "6939                                           SCUTT   \n",
       "33225                                         WALTER   \n",
       "\n",
       "      Projet.Partenaire.Responsable_scientifique.Prenom  \\\n",
       "25958                                           Gilbert   \n",
       "2076                                             Ettore   \n",
       "62072                                          Philippe   \n",
       "33311                                          Philippe   \n",
       "34147                                             Dario   \n",
       "49039                                            Thomas   \n",
       "15253                                           Raphaël   \n",
       "61049                                            Lionel   \n",
       "6939                                            Charles   \n",
       "33225                                           Jacques   \n",
       "\n",
       "      Projet.Partenaire.Adresse.Ville Projet.Partenaire.Adresse.Region  \\\n",
       "25958                      Strasbourg                        Grand Est   \n",
       "2076                            PARIS                    Ile-de-France   \n",
       "62072            Boulogne-Billancourt                    Île-de-France   \n",
       "33311                       Marseille       Provence-Alpes-Côte d'Azur   \n",
       "34147         Montbonnot-Saint-Martin             Auvergne-Rhône-Alpes   \n",
       "49039                  Gif-sur-Yvette                    Île-de-France   \n",
       "15253                          Pessac               Nouvelle-Aquitaine   \n",
       "61049                         Talence               Nouvelle-Aquitaine   \n",
       "6939                    LYON CEDEX 07             Auvergne-Rhône-Alpes   \n",
       "33225                            Metz                        Grand Est   \n",
       "\n",
       "      Projet.Partenaire.Adresse.Pays  \n",
       "25958                         France  \n",
       "2076                          France  \n",
       "62072                         France  \n",
       "33311                         France  \n",
       "34147                         France  \n",
       "49039                         France  \n",
       "15253                         France  \n",
       "61049                         France  \n",
       "6939                          France  \n",
       "33225                         France  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"../data/anr-dos-depuis-2010-projets-finances-20210826-partenaires.csv\", sep = ';')\n",
    "df.sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "af1da232",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "nombre de partenaires 62320\n",
      "nombre rnsr manquants 31123\n"
     ]
    }
   ],
   "source": [
    "# aperçu taux de complétude des codes RNSR\n",
    "print(f\"nombre de partenaires {len(df)}\")\n",
    "print(f\"nombre rnsr manquants {len(df[ df['Projet.Partenaire.Code_RNSR'].isna()] )}\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f6bfa954",
   "metadata": {},
   "source": [
    "## 2. Récupérer les RNSRs de son établissement via l'API AureHAL Structure"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "dee73415",
   "metadata": {},
   "outputs": [],
   "source": [
    "# documentation https://api.archives-ouvertes.fr/docs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "d41c61e4",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests, json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "315181dd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'response': {'numFound': 152,\n",
       "  'start': 0,\n",
       "  'docs': [{},\n",
       "   {'rnsr_s': ['199213388S']},\n",
       "   {},\n",
       "   {},\n",
       "   {},\n",
       "   {},\n",
       "   {},\n",
       "   {'rnsr_s': ['199112390L']},\n",
       "   {},\n",
       "   {'rnsr_s': ['200615274F']},\n",
       "   {'rnsr_s': ['199213386P']},\n",
       "   {},\n",
       "   {'rnsr_s': ['201822709K']},\n",
       "   {'rnsr_s': ['200817616T']},\n",
       "   {}]}}"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# tester l'extraction de rnsr\n",
    "# u orleans : 300297\n",
    "ex = requests.get(\"https://api.archives-ouvertes.fr/ref/structure/?q=parentDocid_i:300297&fl=rnsr_s&rows=15\")\n",
    "ex.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "d99cc490",
   "metadata": {},
   "outputs": [],
   "source": [
    "struct_raw = requests.get(\"https://api.archives-ouvertes.fr/ref/structure/?q=parentDocid_i:300297&fq=valid_s:(VALID OR OLD)&fl=docid,name_s,type_s,valid_s,rnsr_s&rows=10000\")\n",
    "# degré de précision : réduire aux structures valides ou OLD ...\n",
    "all_struct = struct_raw.json()[\"response\"][\"docs\"]\n",
    "df_struct = pd.DataFrame(all_struct)\n",
    "# df_struct.to_csv pour extraire un csv ..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "0ff2c458",
   "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>docid</th>\n",
       "      <th>name_s</th>\n",
       "      <th>type_s</th>\n",
       "      <th>valid_s</th>\n",
       "      <th>rnsr_s</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1002450</td>\n",
       "      <td>Laboratoire de Biologie des Ligneux et des Gra...</td>\n",
       "      <td>laboratory</td>\n",
       "      <td>VALID</td>\n",
       "      <td>[199213387R]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>955</td>\n",
       "      <td>Groupe de recherches sur l'énergétique des mil...</td>\n",
       "      <td>laboratory</td>\n",
       "      <td>OLD</td>\n",
       "      <td>[199612379C]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>551843</td>\n",
       "      <td>Mathématiques appliquées et physique mathémati...</td>\n",
       "      <td>laboratory</td>\n",
       "      <td>OLD</td>\n",
       "      <td>[199412399H]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      docid                                             name_s      type_s  \\\n",
       "16  1002450  Laboratoire de Biologie des Ligneux et des Gra...  laboratory   \n",
       "51      955  Groupe de recherches sur l'énergétique des mil...  laboratory   \n",
       "33   551843  Mathématiques appliquées et physique mathémati...  laboratory   \n",
       "\n",
       "   valid_s        rnsr_s  \n",
       "16   VALID  [199213387R]  \n",
       "51     OLD  [199612379C]  \n",
       "33     OLD  [199412399H]  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# but :  recupérer tous les rnsr\n",
    "## a_ retirer tous les NaN\n",
    "df_rnsr = df_struct[ df_struct[\"rnsr_s\"].notna()]\n",
    "df_rnsr.sample(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "77092464",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['199213388S'], ['199112390L'], ['200615274F'], ['199213386P']]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## b_ les placer dans une liste\n",
    "my_rnsr = df_rnsr[\"rnsr_s\"].tolist()\n",
    "my_rnsr[:4]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "adbab587",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "nb rnsr recupéré 57\n"
     ]
    }
   ],
   "source": [
    "## c_ la nettoyer\n",
    "my_rnsr_clean = [item[0] for item in my_rnsr]\n",
    "print(f\"nb rnsr recupéré {len(my_rnsr_clean)}\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "13126f7c",
   "metadata": {},
   "source": [
    "## 3. Filtrer les données ANR des partenaires avec les RNSR récoltés"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "3abb6ffe",
   "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>Projet.Code_Decision_ANR</th>\n",
       "      <th>Projet.Acronyme</th>\n",
       "      <th>Projet.Partenaire.Code_Decision_ANR</th>\n",
       "      <th>Projet.Partenaire.Est_coordinateur</th>\n",
       "      <th>Projet.Partenaire.Nom_organisme</th>\n",
       "      <th>Projet.Partenaire.Categorie_organisme</th>\n",
       "      <th>Projet.Partenaire.Code_RNSR</th>\n",
       "      <th>Projet.Partenaire.Responsable_scientifique.Nom</th>\n",
       "      <th>Projet.Partenaire.Responsable_scientifique.Prenom</th>\n",
       "      <th>Projet.Partenaire.Adresse.Ville</th>\n",
       "      <th>Projet.Partenaire.Adresse.Region</th>\n",
       "      <th>Projet.Partenaire.Adresse.Pays</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>18492</th>\n",
       "      <td>ANR-18-CE34-0001</td>\n",
       "      <td>CREATIvE</td>\n",
       "      <td>ANR-18-CE34-0001-02</td>\n",
       "      <td>False</td>\n",
       "      <td>TOXICOLOGIE PHARMACOLOGIE ET SIGNALISATION CEL...</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>200616420B</td>\n",
       "      <td>COUMOUL</td>\n",
       "      <td>Xavier</td>\n",
       "      <td>Paris</td>\n",
       "      <td>Île-de-France</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3538</th>\n",
       "      <td>ANR-20-CE42-0003</td>\n",
       "      <td>3DPolariSR</td>\n",
       "      <td>ANR-20-CE42-0003-03</td>\n",
       "      <td>False</td>\n",
       "      <td>Laboratoire des biomolécules</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>200919226N</td>\n",
       "      <td>GAUTIER</td>\n",
       "      <td>Arnaud</td>\n",
       "      <td>PARIS</td>\n",
       "      <td>Ile-de-France</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18392</th>\n",
       "      <td>ANR-18-CE36-0003</td>\n",
       "      <td>DERVI</td>\n",
       "      <td>ANR-18-CE36-0003-02</td>\n",
       "      <td>False</td>\n",
       "      <td>PLEIADE</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>201420821A</td>\n",
       "      <td>DEMARTINI</td>\n",
       "      <td>Anne-Emmanuelle</td>\n",
       "      <td>Villetaneuse</td>\n",
       "      <td>Île-de-France</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41588</th>\n",
       "      <td>ANR-13-SAMA-0007</td>\n",
       "      <td>CANNADO</td>\n",
       "      <td>ANR-13-SAMA-0007-03</td>\n",
       "      <td>False</td>\n",
       "      <td>Institut de Neurobiologie de la Mediterranée</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>200819256A</td>\n",
       "      <td>ROBBE</td>\n",
       "      <td>David</td>\n",
       "      <td>Marseille</td>\n",
       "      <td>Provence-Alpes-Côte d'Azur</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57514</th>\n",
       "      <td>ANR-10-RFCS-0008</td>\n",
       "      <td>MobiNiCSH</td>\n",
       "      <td>ANR-10-RFCS-0008-01</td>\n",
       "      <td>True</td>\n",
       "      <td>COMMISSARIAT A LENERGIE ATOMIQUE ET AUX ENERGI...</td>\n",
       "      <td>Divers public</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ROMEO</td>\n",
       "      <td>Paul- Henri</td>\n",
       "      <td>Fontenay-aux-Roses</td>\n",
       "      <td>Ile-de-France</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Projet.Code_Decision_ANR Projet.Acronyme  \\\n",
       "18492         ANR-18-CE34-0001        CREATIvE   \n",
       "3538          ANR-20-CE42-0003      3DPolariSR   \n",
       "18392         ANR-18-CE36-0003           DERVI   \n",
       "41588         ANR-13-SAMA-0007         CANNADO   \n",
       "57514         ANR-10-RFCS-0008       MobiNiCSH   \n",
       "\n",
       "      Projet.Partenaire.Code_Decision_ANR  Projet.Partenaire.Est_coordinateur  \\\n",
       "18492                 ANR-18-CE34-0001-02                               False   \n",
       "3538                  ANR-20-CE42-0003-03                               False   \n",
       "18392                 ANR-18-CE36-0003-02                               False   \n",
       "41588                 ANR-13-SAMA-0007-03                               False   \n",
       "57514                 ANR-10-RFCS-0008-01                                True   \n",
       "\n",
       "                         Projet.Partenaire.Nom_organisme  \\\n",
       "18492  TOXICOLOGIE PHARMACOLOGIE ET SIGNALISATION CEL...   \n",
       "3538                        Laboratoire des biomolécules   \n",
       "18392                                            PLEIADE   \n",
       "41588       Institut de Neurobiologie de la Mediterranée   \n",
       "57514  COMMISSARIAT A LENERGIE ATOMIQUE ET AUX ENERGI...   \n",
       "\n",
       "      Projet.Partenaire.Categorie_organisme Projet.Partenaire.Code_RNSR  \\\n",
       "18492                    Laboratoire public                  200616420B   \n",
       "3538                     Laboratoire public                  200919226N   \n",
       "18392                    Laboratoire public                  201420821A   \n",
       "41588                    Laboratoire public                  200819256A   \n",
       "57514                         Divers public                         NaN   \n",
       "\n",
       "      Projet.Partenaire.Responsable_scientifique.Nom  \\\n",
       "18492                                        COUMOUL   \n",
       "3538                                         GAUTIER   \n",
       "18392                                      DEMARTINI   \n",
       "41588                                          ROBBE   \n",
       "57514                                          ROMEO   \n",
       "\n",
       "      Projet.Partenaire.Responsable_scientifique.Prenom  \\\n",
       "18492                                            Xavier   \n",
       "3538                                             Arnaud   \n",
       "18392                                   Anne-Emmanuelle   \n",
       "41588                                             David   \n",
       "57514                                       Paul- Henri   \n",
       "\n",
       "      Projet.Partenaire.Adresse.Ville Projet.Partenaire.Adresse.Region  \\\n",
       "18492                           Paris                    Île-de-France   \n",
       "3538                            PARIS                    Ile-de-France   \n",
       "18392                    Villetaneuse                    Île-de-France   \n",
       "41588                       Marseille       Provence-Alpes-Côte d'Azur   \n",
       "57514              Fontenay-aux-Roses                    Ile-de-France   \n",
       "\n",
       "      Projet.Partenaire.Adresse.Pays  \n",
       "18492                         France  \n",
       "3538                          France  \n",
       "18392                         France  \n",
       "41588                         France  \n",
       "57514                         France  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_part = pd.read_csv(\"anr-dos-depuis-2010-projets-finances-20210826-partenaires.csv\", sep = ';')\n",
    "df_part.sample(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "f98c7885",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " nb projets identifiés 211\n"
     ]
    }
   ],
   "source": [
    "my_project = df_part[ df_part[\"Projet.Partenaire.Code_RNSR\"].isin(my_rnsr_clean)]\n",
    "print(f\" nb projets identifiés {len(my_project)}\")\n",
    "# exporter en csv : my_project.to_csv(\"projets_anr_identifies.csv\", index = False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "02275664",
   "metadata": {},
   "source": [
    "----\n",
    "\n",
    "## Discussion\n",
    "\n",
    "Maintenant que vous avez identifié vos projets, que pouvez-faire pour développer la science ouverte ? \n",
    "\n",
    "(au moins 5 possibilités ai-je eu en tête)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fbc1aa2d",
   "metadata": {},
   "source": [
    "---\n",
    "\n",
    "## Extra : compléter par une recherche sur le nom de l'étab.\n",
    "- identifier les proejts de recherche avec le nom d'un étab.\n",
    "- ajouter les projets qui n'étaient pas déjà présents avec l'identification par RNSR"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "9b7f4269",
   "metadata": {},
   "outputs": [],
   "source": [
    "# réduire les données aux projets où des noms d'organisme sont présents\n",
    "org_name = df_part[ df_part[\"Projet.Partenaire.Nom_organisme\"].notna()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "f72d870b",
   "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>index</th>\n",
       "      <th>Projet.Code_Decision_ANR</th>\n",
       "      <th>Projet.Acronyme</th>\n",
       "      <th>Projet.Partenaire.Code_Decision_ANR</th>\n",
       "      <th>Projet.Partenaire.Est_coordinateur</th>\n",
       "      <th>Projet.Partenaire.Nom_organisme</th>\n",
       "      <th>Projet.Partenaire.Categorie_organisme</th>\n",
       "      <th>Projet.Partenaire.Code_RNSR</th>\n",
       "      <th>Projet.Partenaire.Responsable_scientifique.Nom</th>\n",
       "      <th>Projet.Partenaire.Responsable_scientifique.Prenom</th>\n",
       "      <th>Projet.Partenaire.Adresse.Ville</th>\n",
       "      <th>Projet.Partenaire.Adresse.Region</th>\n",
       "      <th>Projet.Partenaire.Adresse.Pays</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>53153</td>\n",
       "      <td>ANR-11-INSE-0006</td>\n",
       "      <td>MAGIC-SPS</td>\n",
       "      <td>ANR-11-INSE-0006-04</td>\n",
       "      <td>False</td>\n",
       "      <td>UNIVERSITE DORLEANS</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RAMDANI</td>\n",
       "      <td>Nacim</td>\n",
       "      <td>Bourges</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>773</td>\n",
       "      <td>ANR-20-THIA-0017</td>\n",
       "      <td>AI.i0 PhD Fellowship</td>\n",
       "      <td>ANR-20-THIA-0017-01</td>\n",
       "      <td>True</td>\n",
       "      <td>Université dOrléans</td>\n",
       "      <td>Divers public</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VRAIN</td>\n",
       "      <td>Christel</td>\n",
       "      <td>ORLEANS</td>\n",
       "      <td>Centre-Val de Loire</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>772</td>\n",
       "      <td>ANR-20-THIA-0017</td>\n",
       "      <td>AI.i0 PhD Fellowship</td>\n",
       "      <td>ANR-20-THIA-0017-01</td>\n",
       "      <td>True</td>\n",
       "      <td>Université dOrléans</td>\n",
       "      <td>Divers public</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VRAIN</td>\n",
       "      <td>Christel</td>\n",
       "      <td>ORLEANS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>33027</td>\n",
       "      <td>ANR-15-FRAL-0004</td>\n",
       "      <td>SegCor</td>\n",
       "      <td>ANR-15-FRAL-0004-02</td>\n",
       "      <td>False</td>\n",
       "      <td>Université dOrléans-CNRS, Laboratoire Ligérien...</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>201220244G</td>\n",
       "      <td>SKROVEC</td>\n",
       "      <td>Marie</td>\n",
       "      <td>Orléans</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>56665</td>\n",
       "      <td>ANR-10-VPTT-0002</td>\n",
       "      <td>ICAMDAC</td>\n",
       "      <td>ANR-10-VPTT-0002-03</td>\n",
       "      <td>False</td>\n",
       "      <td>UNIVERSITE DORLEANS</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FOUCHER</td>\n",
       "      <td>Fabrice</td>\n",
       "      <td>Orléans</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    index Projet.Code_Decision_ANR       Projet.Acronyme  \\\n",
       "9   53153         ANR-11-INSE-0006             MAGIC-SPS   \n",
       "1     773         ANR-20-THIA-0017  AI.i0 PhD Fellowship   \n",
       "0     772         ANR-20-THIA-0017  AI.i0 PhD Fellowship   \n",
       "3   33027         ANR-15-FRAL-0004                SegCor   \n",
       "16  56665         ANR-10-VPTT-0002               ICAMDAC   \n",
       "\n",
       "   Projet.Partenaire.Code_Decision_ANR  Projet.Partenaire.Est_coordinateur  \\\n",
       "9                  ANR-11-INSE-0006-04                               False   \n",
       "1                  ANR-20-THIA-0017-01                                True   \n",
       "0                  ANR-20-THIA-0017-01                                True   \n",
       "3                  ANR-15-FRAL-0004-02                               False   \n",
       "16                 ANR-10-VPTT-0002-03                               False   \n",
       "\n",
       "                      Projet.Partenaire.Nom_organisme  \\\n",
       "9                                 UNIVERSITE DORLEANS   \n",
       "1                                 Université dOrléans   \n",
       "0                                 Université dOrléans   \n",
       "3   Université dOrléans-CNRS, Laboratoire Ligérien...   \n",
       "16                                UNIVERSITE DORLEANS   \n",
       "\n",
       "   Projet.Partenaire.Categorie_organisme Projet.Partenaire.Code_RNSR  \\\n",
       "9                     Laboratoire public                         NaN   \n",
       "1                          Divers public                         NaN   \n",
       "0                          Divers public                         NaN   \n",
       "3                     Laboratoire public                  201220244G   \n",
       "16                    Laboratoire public                         NaN   \n",
       "\n",
       "   Projet.Partenaire.Responsable_scientifique.Nom  \\\n",
       "9                                         RAMDANI   \n",
       "1                                           VRAIN   \n",
       "0                                           VRAIN   \n",
       "3                                         SKROVEC   \n",
       "16                                        FOUCHER   \n",
       "\n",
       "   Projet.Partenaire.Responsable_scientifique.Prenom  \\\n",
       "9                                              Nacim   \n",
       "1                                           Christel   \n",
       "0                                           Christel   \n",
       "3                                              Marie   \n",
       "16                                           Fabrice   \n",
       "\n",
       "   Projet.Partenaire.Adresse.Ville Projet.Partenaire.Adresse.Region  \\\n",
       "9                          Bourges                              NaN   \n",
       "1                          ORLEANS              Centre-Val de Loire   \n",
       "0                          ORLEANS                              NaN   \n",
       "3                          Orléans                              NaN   \n",
       "16                         Orléans                              NaN   \n",
       "\n",
       "   Projet.Partenaire.Adresse.Pays  \n",
       "9                             NaN  \n",
       "1                          France  \n",
       "0                          France  \n",
       "3                             NaN  \n",
       "16                            NaN  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# faire une regex pour le nom de votre étab.\n",
    "name_filter = org_name[\"Projet.Partenaire.Nom_organisme\"].str.contains(\"universit. dorl.ans\", case = False, regex=True)\n",
    "my_project2 = org_name[name_filter].reset_index()\n",
    "my_project2.sample(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "16ab0b24",
   "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>index</th>\n",
       "      <th>Projet.Code_Decision_ANR</th>\n",
       "      <th>Projet.Acronyme</th>\n",
       "      <th>Projet.Partenaire.Code_Decision_ANR</th>\n",
       "      <th>Projet.Partenaire.Est_coordinateur</th>\n",
       "      <th>Projet.Partenaire.Nom_organisme</th>\n",
       "      <th>Projet.Partenaire.Categorie_organisme</th>\n",
       "      <th>Projet.Partenaire.Code_RNSR</th>\n",
       "      <th>Projet.Partenaire.Responsable_scientifique.Nom</th>\n",
       "      <th>Projet.Partenaire.Responsable_scientifique.Prenom</th>\n",
       "      <th>Projet.Partenaire.Adresse.Ville</th>\n",
       "      <th>Projet.Partenaire.Adresse.Region</th>\n",
       "      <th>Projet.Partenaire.Adresse.Pays</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>61100</td>\n",
       "      <td>ANR-10-BLAN-0930</td>\n",
       "      <td>PAMPA</td>\n",
       "      <td>ANR-10-BLAN-0930-03</td>\n",
       "      <td>False</td>\n",
       "      <td>UNIVERSITE DORLEANS</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ROBERT</td>\n",
       "      <td>Eric</td>\n",
       "      <td>Orléans</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>52691</td>\n",
       "      <td>ANR-11-JS09-0010</td>\n",
       "      <td>INDIGO</td>\n",
       "      <td>ANR-11-JS09-0010-01</td>\n",
       "      <td>True</td>\n",
       "      <td>UNIVERSITE DORLEANS</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MIKIKIAN</td>\n",
       "      <td>Maxime</td>\n",
       "      <td>Orléans</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>773</td>\n",
       "      <td>ANR-20-THIA-0017</td>\n",
       "      <td>AI.i0 PhD Fellowship</td>\n",
       "      <td>ANR-20-THIA-0017-01</td>\n",
       "      <td>True</td>\n",
       "      <td>Université dOrléans</td>\n",
       "      <td>Divers public</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VRAIN</td>\n",
       "      <td>Christel</td>\n",
       "      <td>ORLEANS</td>\n",
       "      <td>Centre-Val de Loire</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>55532</td>\n",
       "      <td>ANR-11-BS09-0029</td>\n",
       "      <td>PLASBorDDiAM</td>\n",
       "      <td>ANR-11-BS09-0029-02</td>\n",
       "      <td>False</td>\n",
       "      <td>UNIVERSITE DORLEANS</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BRAULT</td>\n",
       "      <td>Pascal</td>\n",
       "      <td>Orléans</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>59725</td>\n",
       "      <td>ANR-10-CESA-0007</td>\n",
       "      <td>Neuropest</td>\n",
       "      <td>ANR-10-CESA-0007-02</td>\n",
       "      <td>False</td>\n",
       "      <td>UNIVERSITE DORLEANS</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MONTÉCOT-DUBOURG</td>\n",
       "      <td>Céline</td>\n",
       "      <td>Orléans</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>56968</td>\n",
       "      <td>ANR-10-TECS-0004</td>\n",
       "      <td>CancerSensor</td>\n",
       "      <td>ANR-10-TECS-0004-01</td>\n",
       "      <td>True</td>\n",
       "      <td>UNIVERSITE DORLEANS</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AGROFOGLIO</td>\n",
       "      <td>Luigi</td>\n",
       "      <td>Orléans</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>58551</td>\n",
       "      <td>ANR-10-INTB-0205</td>\n",
       "      <td>PAPDAS</td>\n",
       "      <td>ANR-10-INTB-0205-01</td>\n",
       "      <td>True</td>\n",
       "      <td>UNIVERSITE DORLEANS</td>\n",
       "      <td>Laboratoire public</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DABROWSKI</td>\n",
       "      <td>Frédéric</td>\n",
       "      <td>Orléans</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    index Projet.Code_Decision_ANR       Projet.Acronyme  \\\n",
       "22  61100         ANR-10-BLAN-0930                 PAMPA   \n",
       "8   52691         ANR-11-JS09-0010                INDIGO   \n",
       "1     773         ANR-20-THIA-0017  AI.i0 PhD Fellowship   \n",
       "12  55532         ANR-11-BS09-0029          PLASBorDDiAM   \n",
       "20  59725         ANR-10-CESA-0007             Neuropest   \n",
       "17  56968         ANR-10-TECS-0004          CancerSensor   \n",
       "19  58551         ANR-10-INTB-0205                PAPDAS   \n",
       "\n",
       "   Projet.Partenaire.Code_Decision_ANR  Projet.Partenaire.Est_coordinateur  \\\n",
       "22                 ANR-10-BLAN-0930-03                               False   \n",
       "8                  ANR-11-JS09-0010-01                                True   \n",
       "1                  ANR-20-THIA-0017-01                                True   \n",
       "12                 ANR-11-BS09-0029-02                               False   \n",
       "20                 ANR-10-CESA-0007-02                               False   \n",
       "17                 ANR-10-TECS-0004-01                                True   \n",
       "19                 ANR-10-INTB-0205-01                                True   \n",
       "\n",
       "   Projet.Partenaire.Nom_organisme Projet.Partenaire.Categorie_organisme  \\\n",
       "22             UNIVERSITE DORLEANS                    Laboratoire public   \n",
       "8              UNIVERSITE DORLEANS                    Laboratoire public   \n",
       "1              Université dOrléans                         Divers public   \n",
       "12             UNIVERSITE DORLEANS                    Laboratoire public   \n",
       "20             UNIVERSITE DORLEANS                    Laboratoire public   \n",
       "17             UNIVERSITE DORLEANS                    Laboratoire public   \n",
       "19             UNIVERSITE DORLEANS                    Laboratoire public   \n",
       "\n",
       "   Projet.Partenaire.Code_RNSR Projet.Partenaire.Responsable_scientifique.Nom  \\\n",
       "22                         NaN                                         ROBERT   \n",
       "8                          NaN                                       MIKIKIAN   \n",
       "1                          NaN                                          VRAIN   \n",
       "12                         NaN                                         BRAULT   \n",
       "20                         NaN                               MONTÉCOT-DUBOURG   \n",
       "17                         NaN                                     AGROFOGLIO   \n",
       "19                         NaN                                      DABROWSKI   \n",
       "\n",
       "   Projet.Partenaire.Responsable_scientifique.Prenom  \\\n",
       "22                                              Eric   \n",
       "8                                             Maxime   \n",
       "1                                           Christel   \n",
       "12                                            Pascal   \n",
       "20                                            Céline   \n",
       "17                                             Luigi   \n",
       "19                                          Frédéric   \n",
       "\n",
       "   Projet.Partenaire.Adresse.Ville Projet.Partenaire.Adresse.Region  \\\n",
       "22                         Orléans                              NaN   \n",
       "8                          Orléans                              NaN   \n",
       "1                          ORLEANS              Centre-Val de Loire   \n",
       "12                         Orléans                              NaN   \n",
       "20                         Orléans                              NaN   \n",
       "17                         Orléans                              NaN   \n",
       "19                         Orléans                              NaN   \n",
       "\n",
       "   Projet.Partenaire.Adresse.Pays  \n",
       "22                            NaN  \n",
       "8                             NaN  \n",
       "1                          France  \n",
       "12                            NaN  \n",
       "20                            NaN  \n",
       "17                            NaN  \n",
       "19                            NaN  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## réduire aux projects qui n'ont pas déjà été trouvés par les RNSR\n",
    "project_by_orgname = my_project2[ ~my_project2[\"Projet.Code_Decision_ANR\"].isin(\n",
    "my_project[\"Projet.Code_Decision_ANR\"].tolist()) ]\n",
    "## nota : d'autres solutions existent pour réaliser ce procédé\n",
    "project_by_orgname.sample(7)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "c4651c03",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "nb de projet ANR total identifié 226\n"
     ]
    }
   ],
   "source": [
    "# concaténer les deux tableaux des projets de votre étab. \n",
    "all_my_project = pd.concat([my_project, project_by_orgname])\n",
    "print(\"nb de projet ANR total identifié\", len(all_my_project))"
   ]
  }
 ],
 "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
}