sante_janette_frqs_20230125_13h53-ParDomaineEtParEtablissement.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "7e3fbd44",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "1dd81857",
   "metadata": {},
   "outputs": [],
   "source": [
    "## Obtenir les colonnes Établissement et Montants total dans le domaine de la santé\n",
    "sante = pd.read_csv('liste-financement-frqs-2018-2019.csv', usecols = ['Etablissement', 'Domaine_de_recherche', 'Montant_total', ])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "27104b90",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                          Etablissement  Montant_total  \\\n",
      "0       Centre hospitalier universitaire Sainte Justine      765000.00   \n",
      "1     Institut universitaire de cardiologie et de pn...      765000.00   \n",
      "2                  CIUSSS de l'Est-de-l'Île-de-Montréal      356000.00   \n",
      "3                                Université de Montréal      495000.00   \n",
      "4             CIUSSS du Centre-Sud-de-l'Île-de-Montréal      630000.00   \n",
      "...                                                 ...            ...   \n",
      "1663                                  Université McGill        1000.00   \n",
      "1664                                                NaN      179166.67   \n",
      "1665                                                NaN      107500.00   \n",
      "1666                                                NaN      198166.00   \n",
      "1667                                                NaN      336499.00   \n",
      "\n",
      "                              Domaine_de_recherche  \n",
      "0                                              NaN  \n",
      "1                                              NaN  \n",
      "2                                              NaN  \n",
      "3                                              NaN  \n",
      "4                                              NaN  \n",
      "...                                            ...  \n",
      "1663  Neurosciences, santé mentale et toxicomanies  \n",
      "1664                                         s. o.  \n",
      "1665                                         s. o.  \n",
      "1666                                         s. o.  \n",
      "1667                                         s. o.  \n",
      "\n",
      "[1668 rows x 3 columns]\n"
     ]
    }
   ],
   "source": [
    "print(sante)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "d9d289d1",
   "metadata": {},
   "outputs": [],
   "source": [
    "## Créer un dictionnaire de tous les établissements sans doublon\n",
    "dict_etablissements=set(sante['Etablissement'].tolist())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "07241bc8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Alliance santé Québec [AsQ]',\n",
       " 'Autre',\n",
       " 'BC Centre for Disease Control [BCCDC]',\n",
       " 'Boston University School of Medicine',\n",
       " \"Brigham and Women's Hospital\",\n",
       " 'Broad Institute',\n",
       " 'CHU de Québec - Université Laval',\n",
       " 'CISSS de Chaudière-Appalaches',\n",
       " 'CISSS de Laval',\n",
       " 'CISSS de la Côte-Nord',\n",
       " 'CISSS de la Montérégie-Centre',\n",
       " \"CIUSSS de l'Est-de-l'Île-de-Montréal\",\n",
       " \"CIUSSS de l'Estrie - CHUS\",\n",
       " \"CIUSSS de l'Ouest-de-l'Ile-de-Montréal\",\n",
       " 'CIUSSS de la Capitale-Nationale',\n",
       " \"CIUSSS du Centre-Ouest-de-l'Île-de-Montréal\",\n",
       " \"CIUSSS du Centre-Sud-de-l'Île-de-Montréal\",\n",
       " \"CIUSSS du Nord-de-l'Île-de-Montréal\",\n",
       " 'CIUSSS du Saguenay–Lac-Saint-Jean',\n",
       " 'Centre Hospitalier Universitaire de Strasbourg',\n",
       " \"Centre de recherche de l'Hôpital du Sacré-Coeur de Montréal\",\n",
       " \"Centre de recherche de l'IUSM Douglas\",\n",
       " \"Centre de recherche de l'Institut universitaire de gériatrie de Montréal\",\n",
       " 'Centre de recherche du CHU de Québec-Université Laval',\n",
       " 'Centre de recherche du Centre hospitalier université de Sherbrooke',\n",
       " 'Centre de recherche interdisciplinaire en réadaptation du Montréal métropolitain [CRIR]',\n",
       " \"Centre de recherche sur le vieillissement de l'IUGS\",\n",
       " \"Centre hospitalier de l'Université de Montréal [CHUM]\",\n",
       " 'Centre hospitalier universitaire Sainte Justine',\n",
       " 'Centre interdisciplinaire de recherche en réadaptation et intégration sociale [CIRRIS]',\n",
       " 'Centre universitaire de santé McGill [CUSM]',\n",
       " 'Collège Lionel-Groulx',\n",
       " 'Collège Montmorency',\n",
       " 'Columbia University',\n",
       " 'Cornell University',\n",
       " 'Cuban Neuroscience Center [CNEURO]',\n",
       " 'Cégep de Granby',\n",
       " 'Cégep de Jonquière',\n",
       " 'Cégep de Lévis-Lauzon',\n",
       " 'Evidence for Policy et Practice Information et Co-ordinating Centre',\n",
       " 'Friedrich-Alexander University of Erlangen-Nurnberg',\n",
       " 'Georg-August-Universitat Gottingen',\n",
       " 'Harvard T.H. Chan School of Public Health ',\n",
       " 'Harvard University',\n",
       " 'Hospital for sick children',\n",
       " 'Hôpitaux Shriners pour enfant',\n",
       " 'Hôpitaux Universitaires de Genève [HUG-GE]',\n",
       " 'Institut Philippe-Pinel de Montréal',\n",
       " 'Institut canadien de recherches avancées [ICRA]',\n",
       " 'Institut de cardiologie de Montréal',\n",
       " 'Institut de la statistique du Québec [ISQ]',\n",
       " 'Institut de recherche du Centre universitaire de santé McGill',\n",
       " 'Institut de recherches cliniques de Montréal [IRCM]',\n",
       " 'Institut du Nouveau Monde [INM]',\n",
       " 'Institut et hôpital neurologiques de Montréal',\n",
       " \"Institut national d'excellence en santé et services sociaux [INESSS]\",\n",
       " 'Institut national de la recherche scientifique [INRS]',\n",
       " 'Institut national de santé publique du Québec [INSPQ]',\n",
       " 'Institut sur la nutrition et les aliments fonctionnels [INAF]',\n",
       " 'Institut universitaire de cardiologie et de pneumologie de Québec - Université Laval [IUCPQ]',\n",
       " 'Institut universitaire en santé mentale Douglas',\n",
       " \"John's Hopkins Hospital\",\n",
       " 'Leiden University',\n",
       " 'Massachusetts General Hospital',\n",
       " 'Max Planck Institute of Molecular Cell Biology et Genetics',\n",
       " 'Mayo Clinic',\n",
       " 'McMaster University',\n",
       " 'National Institute of Health ',\n",
       " 'National Institutes of Health [NIH]',\n",
       " 'Network of Networks',\n",
       " 'New York Genome Center [NYGC]',\n",
       " 'New York State Psychiatric Institute',\n",
       " 'New York University [NYU]',\n",
       " 'Northeastern University ',\n",
       " 'Northwestern University',\n",
       " 'OSEntreprendre',\n",
       " 'Ontario Institute for Cancer Research',\n",
       " 'PROMPT-Québec',\n",
       " 'Penn Institute for Immunology',\n",
       " \"Queen's University\",\n",
       " 'Rockefeller University',\n",
       " 'Société de recherche sur le cancer [SRC]',\n",
       " 'Stanford University',\n",
       " 'Texas Tech University [TTU]',\n",
       " 'University of Alberta',\n",
       " 'University of Amsterdam [UVA]',\n",
       " 'University of Calgary',\n",
       " 'University of California - Los Angeles [UCLA]',\n",
       " 'University of California - San Francisco [UCSF]',\n",
       " 'University of Cambridge',\n",
       " 'University of Chicago',\n",
       " 'University of Colorado Health Sciences Center',\n",
       " 'University of London - University College London',\n",
       " 'University of North Carolina',\n",
       " 'University of Ontario Institute of Technology',\n",
       " 'University of Pennsylvania',\n",
       " 'University of Texas',\n",
       " 'University of Toronto Scarborough',\n",
       " 'University of Victoria',\n",
       " 'University of Vienna',\n",
       " 'University of Waterloo',\n",
       " 'Université Concordia',\n",
       " 'Université Laval',\n",
       " 'Université McGill',\n",
       " \"Université d'Ottawa\",\n",
       " \"Université d'Oxford\",\n",
       " 'Université de Genève [UNIGE]',\n",
       " 'Université de Montréal',\n",
       " 'Université de Sherbrooke',\n",
       " 'Université de Toronto',\n",
       " 'Université de la Colombie-Britannique [UBC]',\n",
       " 'Université du Québec en Abitibi-Témiscamingue [UQAT]',\n",
       " 'Université du Québec en Outaouais [UQO]',\n",
       " 'Université du Québec à Chicoutimi [UQAC]',\n",
       " 'Université du Québec à Montréal [UQAM]',\n",
       " 'Université du Québec à Trois-Rivières [UQTR]',\n",
       " 'Yale University',\n",
       " 'York University',\n",
       " nan,\n",
       " 's. o.',\n",
       " 'École Polytechnique de Montréal',\n",
       " \"École nationale d'administration publique [ENAP]\"}"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dict_etablissements"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "67cb8dfc",
   "metadata": {},
   "outputs": [],
   "source": [
    "## Créer une nouvelle liste avec un loop pour obtenir montant total à chaque établissement\n",
    "liste_montantsParEtablissements=[]\n",
    "for et in dict_etablissements:\n",
    "    montants=sante.loc[sante['Etablissement']== et]    \n",
    "    dict_etablissements = {'org': et, 'total': sum(montants['Montant_total'].tolist())}\n",
    "    liste_montantsParEtablissements.append(dict_etablissements)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "d59b8459",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'org': nan, 'total': 0},\n",
       " {'org': 'Harvard T.H. Chan School of Public Health ', 'total': 10000.0},\n",
       " {'org': 'Harvard University', 'total': 165000.0},\n",
       " {'org': 'Institut de cardiologie de Montréal', 'total': 1922135.0},\n",
       " {'org': 'Rockefeller University', 'total': 45000.0},\n",
       " {'org': 'Texas Tech University [TTU]', 'total': 10000.0},\n",
       " {'org': \"CIUSSS du Nord-de-l'Île-de-Montréal\", 'total': 1817924.0},\n",
       " {'org': 'Boston University School of Medicine', 'total': 10000.0},\n",
       " {'org': \"CIUSSS de l'Estrie - CHUS\", 'total': 4082903.0},\n",
       " {'org': 'Institut universitaire en santé mentale Douglas', 'total': 141000.0},\n",
       " {'org': 'BC Centre for Disease Control [BCCDC]', 'total': 5000.0},\n",
       " {'org': \"Centre de recherche sur le vieillissement de l'IUGS\",\n",
       "  'total': 20000.0},\n",
       " {'org': 'Centre de recherche du Centre hospitalier université de Sherbrooke',\n",
       "  'total': 70000.0},\n",
       " {'org': 'Université de Montréal', 'total': 15006158.0},\n",
       " {'org': 'University of Chicago', 'total': 55481.0},\n",
       " {'org': 'CISSS de Chaudière-Appalaches', 'total': 30000.0},\n",
       " {'org': 'Institut sur la nutrition et les aliments fonctionnels [INAF]',\n",
       "  'total': 30000.0},\n",
       " {'org': 'CIUSSS de la Capitale-Nationale', 'total': 2019450.0},\n",
       " {'org': 'Mayo Clinic', 'total': 55000.0},\n",
       " {'org': 'Autre', 'total': 30000.0},\n",
       " {'org': 'Université de Sherbrooke', 'total': 6822254.0},\n",
       " {'org': \"Université d'Ottawa\", 'total': 100000.0},\n",
       " {'org': 'Hôpitaux Universitaires de Genève [HUG-GE]', 'total': 53132.0},\n",
       " {'org': \"CIUSSS du Centre-Sud-de-l'Île-de-Montréal\", 'total': 2195271.0},\n",
       " {'org': 'CHU de Québec - Université Laval', 'total': 6775249.0},\n",
       " {'org': 'New York State Psychiatric Institute', 'total': 45000.0},\n",
       " {'org': 'University of Colorado Health Sciences Center', 'total': 45000.0},\n",
       " {'org': 'Max Planck Institute of Molecular Cell Biology et Genetics',\n",
       "  'total': 45000.0},\n",
       " {'org': 'Institut national de santé publique du Québec [INSPQ]',\n",
       "  'total': 70710.0},\n",
       " {'org': 'CISSS de la Montérégie-Centre', 'total': 319236.0},\n",
       " {'org': 'Centre interdisciplinaire de recherche en réadaptation et intégration sociale [CIRRIS]',\n",
       "  'total': 30000.0},\n",
       " {'org': \"Centre de recherche de l'IUSM Douglas\", 'total': 2221051.0},\n",
       " {'org': \"John's Hopkins Hospital\", 'total': 45000.0},\n",
       " {'org': \"Brigham and Women's Hospital\", 'total': 137500.0},\n",
       " {'org': 'Centre hospitalier universitaire Sainte Justine',\n",
       "  'total': 4659282.0},\n",
       " {'org': 'Ontario Institute for Cancer Research', 'total': 71250.0},\n",
       " {'org': 'Georg-August-Universitat Gottingen', 'total': 56000.0},\n",
       " {'org': 'University of Texas', 'total': 55000.0},\n",
       " {'org': 'Université du Québec à Montréal [UQAM]', 'total': 2062571.0},\n",
       " {'org': 'OSEntreprendre', 'total': 10000.0},\n",
       " {'org': 'Centre de recherche interdisciplinaire en réadaptation du Montréal métropolitain [CRIR]',\n",
       "  'total': 135000.0},\n",
       " {'org': 'University of California - Los Angeles [UCLA]', 'total': 45000.0},\n",
       " {'org': 'Penn Institute for Immunology', 'total': 55000.0},\n",
       " {'org': 'University of Amsterdam [UVA]', 'total': 34375.0},\n",
       " {'org': 'Institut national de la recherche scientifique [INRS]',\n",
       "  'total': 1092491.0},\n",
       " {'org': 'University of Cambridge', 'total': 17500.0},\n",
       " {'org': 'PROMPT-Québec', 'total': 125000.0},\n",
       " {'org': 'Hôpitaux Shriners pour enfant', 'total': 48333.0},\n",
       " {'org': 'Centre de recherche du CHU de Québec-Université Laval',\n",
       "  'total': 194128.0},\n",
       " {'org': 'Université du Québec à Chicoutimi [UQAC]', 'total': 66941.0},\n",
       " {'org': 'University of Alberta', 'total': 47127.0},\n",
       " {'org': 'Collège Lionel-Groulx', 'total': 93385.0},\n",
       " {'org': \"Centre de recherche de l'Hôpital du Sacré-Coeur de Montréal\",\n",
       "  'total': 46000.0},\n",
       " {'org': 'Yale University', 'total': 10000.0},\n",
       " {'org': 'Université du Québec en Abitibi-Témiscamingue [UQAT]',\n",
       "  'total': 72037.0},\n",
       " {'org': 'University of London - University College London', 'total': 38768.0},\n",
       " {'org': 'Université Concordia', 'total': 796311.0},\n",
       " {'org': 'University of North Carolina', 'total': 55000.0},\n",
       " {'org': 'University of Pennsylvania', 'total': 80000.0},\n",
       " {'org': 's. o.', 'total': 250324.0},\n",
       " {'org': 'Broad Institute', 'total': 55000.0},\n",
       " {'org': \"Université d'Oxford\", 'total': 62500.0},\n",
       " {'org': 'Cégep de Lévis-Lauzon', 'total': 46800.0},\n",
       " {'org': \"CIUSSS de l'Ouest-de-l'Ile-de-Montréal\", 'total': 1215710.0},\n",
       " {'org': 'Centre universitaire de santé McGill [CUSM]', 'total': 5254760.0},\n",
       " {'org': 'Leiden University', 'total': 55000.0},\n",
       " {'org': 'Université Laval', 'total': 10067607.0},\n",
       " {'org': 'Northwestern University', 'total': 45000.0},\n",
       " {'org': 'Institut du Nouveau Monde [INM]', 'total': 15000.0},\n",
       " {'org': 'Institut de recherches cliniques de Montréal [IRCM]',\n",
       "  'total': 1045161.0},\n",
       " {'org': 'CIUSSS du Saguenay–Lac-Saint-Jean', 'total': 318148.0},\n",
       " {'org': 'Cégep de Jonquière', 'total': 47000.0},\n",
       " {'org': 'University of Vienna', 'total': 20000.0},\n",
       " {'org': 'École Polytechnique de Montréal', 'total': 209300.0},\n",
       " {'org': 'Université de Genève [UNIGE]', 'total': 58608.0},\n",
       " {'org': 'Friedrich-Alexander University of Erlangen-Nurnberg',\n",
       "  'total': 10000.0},\n",
       " {'org': 'Centre Hospitalier Universitaire de Strasbourg', 'total': 45000.0},\n",
       " {'org': 'York University', 'total': 17500.0},\n",
       " {'org': \"CIUSSS du Centre-Ouest-de-l'Île-de-Montréal\", 'total': 2247101.0},\n",
       " {'org': 'Stanford University', 'total': 45000.0},\n",
       " {'org': 'CISSS de Laval', 'total': 660500.0},\n",
       " {'org': 'New York University [NYU]', 'total': 111345.0},\n",
       " {'org': 'Alliance santé Québec [AsQ]', 'total': 100000.0},\n",
       " {'org': 'Institut Philippe-Pinel de Montréal', 'total': 32635.0},\n",
       " {'org': \"Queen's University\", 'total': 15000.0},\n",
       " {'org': 'Cuban Neuroscience Center [CNEURO]', 'total': 25000.0},\n",
       " {'org': 'Cornell University', 'total': 5000.0},\n",
       " {'org': 'Université du Québec en Outaouais [UQO]', 'total': 267044.0},\n",
       " {'org': 'Network of Networks', 'total': 41000.0},\n",
       " {'org': 'Institut canadien de recherches avancées [ICRA]', 'total': 50000.0},\n",
       " {'org': 'Massachusetts General Hospital', 'total': 165700.0},\n",
       " {'org': 'Institut universitaire de cardiologie et de pneumologie de Québec - Université Laval [IUCPQ]',\n",
       "  'total': 2308930.0},\n",
       " {'org': 'Columbia University', 'total': 90000.0},\n",
       " {'org': 'Hospital for sick children', 'total': 27500.0},\n",
       " {'org': 'Evidence for Policy et Practice Information et Co-ordinating Centre',\n",
       "  'total': 55000.0},\n",
       " {'org': \"École nationale d'administration publique [ENAP]\",\n",
       "  'total': 100000.0},\n",
       " {'org': 'Université de Toronto', 'total': 184323.0},\n",
       " {'org': 'University of Ontario Institute of Technology', 'total': 45000.0},\n",
       " {'org': 'Université McGill', 'total': 16668922.0},\n",
       " {'org': 'Collège Montmorency', 'total': 47000.0},\n",
       " {'org': 'National Institute of Health ', 'total': 69850.0},\n",
       " {'org': 'Institut et hôpital neurologiques de Montréal', 'total': 91000.0},\n",
       " {'org': 'CISSS de la Côte-Nord', 'total': 315543.0},\n",
       " {'org': 'Société de recherche sur le cancer [SRC]', 'total': 97733.0},\n",
       " {'org': \"Centre hospitalier de l'Université de Montréal [CHUM]\",\n",
       "  'total': 9033018.0},\n",
       " {'org': 'University of Calgary', 'total': 7000.0},\n",
       " {'org': 'National Institutes of Health [NIH]', 'total': 95952.0},\n",
       " {'org': 'Université de la Colombie-Britannique [UBC]', 'total': 84323.0},\n",
       " {'org': 'University of Victoria', 'total': 21000.0},\n",
       " {'org': \"CIUSSS de l'Est-de-l'Île-de-Montréal\", 'total': 3124955.0},\n",
       " {'org': 'University of Waterloo', 'total': 39323.0},\n",
       " {'org': \"Institut national d'excellence en santé et services sociaux [INESSS]\",\n",
       "  'total': 30000.0},\n",
       " {'org': 'Institut de la statistique du Québec [ISQ]', 'total': 200000.0},\n",
       " {'org': 'Northeastern University ', 'total': 55000.0},\n",
       " {'org': 'Cégep de Granby', 'total': 34379.0},\n",
       " {'org': 'Université du Québec à Trois-Rivières [UQTR]', 'total': 687754.0},\n",
       " {'org': 'McMaster University', 'total': 59323.0},\n",
       " {'org': 'Institut de recherche du Centre universitaire de santé McGill',\n",
       "  'total': 1031754.0},\n",
       " {'org': \"Centre de recherche de l'Institut universitaire de gériatrie de Montréal\",\n",
       "  'total': 105000.0},\n",
       " {'org': 'University of Toronto Scarborough', 'total': 20000.0},\n",
       " {'org': 'New York Genome Center [NYGC]', 'total': 15000.0},\n",
       " {'org': 'University of California - San Francisco [UCSF]', 'total': 64323.0}]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "liste_montantsParEtablissements"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "7d19295b",
   "metadata": {},
   "outputs": [],
   "source": [
    "sortedByTotalByEtablissement = sorted(liste_montantsParEtablissements, key=lambda d: d['total'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "b8d04bbc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'org': nan, 'total': 0},\n",
       " {'org': 'BC Centre for Disease Control [BCCDC]', 'total': 5000.0},\n",
       " {'org': 'Cornell University', 'total': 5000.0},\n",
       " {'org': 'University of Calgary', 'total': 7000.0},\n",
       " {'org': 'Harvard T.H. Chan School of Public Health ', 'total': 10000.0},\n",
       " {'org': 'Texas Tech University [TTU]', 'total': 10000.0},\n",
       " {'org': 'Boston University School of Medicine', 'total': 10000.0},\n",
       " {'org': 'OSEntreprendre', 'total': 10000.0},\n",
       " {'org': 'Yale University', 'total': 10000.0},\n",
       " {'org': 'Friedrich-Alexander University of Erlangen-Nurnberg',\n",
       "  'total': 10000.0},\n",
       " {'org': 'Institut du Nouveau Monde [INM]', 'total': 15000.0},\n",
       " {'org': \"Queen's University\", 'total': 15000.0},\n",
       " {'org': 'New York Genome Center [NYGC]', 'total': 15000.0},\n",
       " {'org': 'University of Cambridge', 'total': 17500.0},\n",
       " {'org': 'York University', 'total': 17500.0},\n",
       " {'org': \"Centre de recherche sur le vieillissement de l'IUGS\",\n",
       "  'total': 20000.0},\n",
       " {'org': 'University of Vienna', 'total': 20000.0},\n",
       " {'org': 'University of Toronto Scarborough', 'total': 20000.0},\n",
       " {'org': 'University of Victoria', 'total': 21000.0},\n",
       " {'org': 'Cuban Neuroscience Center [CNEURO]', 'total': 25000.0},\n",
       " {'org': 'Hospital for sick children', 'total': 27500.0},\n",
       " {'org': 'CISSS de Chaudière-Appalaches', 'total': 30000.0},\n",
       " {'org': 'Institut sur la nutrition et les aliments fonctionnels [INAF]',\n",
       "  'total': 30000.0},\n",
       " {'org': 'Autre', 'total': 30000.0},\n",
       " {'org': 'Centre interdisciplinaire de recherche en réadaptation et intégration sociale [CIRRIS]',\n",
       "  'total': 30000.0},\n",
       " {'org': \"Institut national d'excellence en santé et services sociaux [INESSS]\",\n",
       "  'total': 30000.0},\n",
       " {'org': 'Institut Philippe-Pinel de Montréal', 'total': 32635.0},\n",
       " {'org': 'University of Amsterdam [UVA]', 'total': 34375.0},\n",
       " {'org': 'Cégep de Granby', 'total': 34379.0},\n",
       " {'org': 'University of London - University College London', 'total': 38768.0},\n",
       " {'org': 'University of Waterloo', 'total': 39323.0},\n",
       " {'org': 'Network of Networks', 'total': 41000.0},\n",
       " {'org': 'Rockefeller University', 'total': 45000.0},\n",
       " {'org': 'New York State Psychiatric Institute', 'total': 45000.0},\n",
       " {'org': 'University of Colorado Health Sciences Center', 'total': 45000.0},\n",
       " {'org': 'Max Planck Institute of Molecular Cell Biology et Genetics',\n",
       "  'total': 45000.0},\n",
       " {'org': \"John's Hopkins Hospital\", 'total': 45000.0},\n",
       " {'org': 'University of California - Los Angeles [UCLA]', 'total': 45000.0},\n",
       " {'org': 'Northwestern University', 'total': 45000.0},\n",
       " {'org': 'Centre Hospitalier Universitaire de Strasbourg', 'total': 45000.0},\n",
       " {'org': 'Stanford University', 'total': 45000.0},\n",
       " {'org': 'University of Ontario Institute of Technology', 'total': 45000.0},\n",
       " {'org': \"Centre de recherche de l'Hôpital du Sacré-Coeur de Montréal\",\n",
       "  'total': 46000.0},\n",
       " {'org': 'Cégep de Lévis-Lauzon', 'total': 46800.0},\n",
       " {'org': 'Cégep de Jonquière', 'total': 47000.0},\n",
       " {'org': 'Collège Montmorency', 'total': 47000.0},\n",
       " {'org': 'University of Alberta', 'total': 47127.0},\n",
       " {'org': 'Hôpitaux Shriners pour enfant', 'total': 48333.0},\n",
       " {'org': 'Institut canadien de recherches avancées [ICRA]', 'total': 50000.0},\n",
       " {'org': 'Hôpitaux Universitaires de Genève [HUG-GE]', 'total': 53132.0},\n",
       " {'org': 'Mayo Clinic', 'total': 55000.0},\n",
       " {'org': 'University of Texas', 'total': 55000.0},\n",
       " {'org': 'Penn Institute for Immunology', 'total': 55000.0},\n",
       " {'org': 'University of North Carolina', 'total': 55000.0},\n",
       " {'org': 'Broad Institute', 'total': 55000.0},\n",
       " {'org': 'Leiden University', 'total': 55000.0},\n",
       " {'org': 'Evidence for Policy et Practice Information et Co-ordinating Centre',\n",
       "  'total': 55000.0},\n",
       " {'org': 'Northeastern University ', 'total': 55000.0},\n",
       " {'org': 'University of Chicago', 'total': 55481.0},\n",
       " {'org': 'Georg-August-Universitat Gottingen', 'total': 56000.0},\n",
       " {'org': 'Université de Genève [UNIGE]', 'total': 58608.0},\n",
       " {'org': 'McMaster University', 'total': 59323.0},\n",
       " {'org': \"Université d'Oxford\", 'total': 62500.0},\n",
       " {'org': 'University of California - San Francisco [UCSF]', 'total': 64323.0},\n",
       " {'org': 'Université du Québec à Chicoutimi [UQAC]', 'total': 66941.0},\n",
       " {'org': 'National Institute of Health ', 'total': 69850.0},\n",
       " {'org': 'Centre de recherche du Centre hospitalier université de Sherbrooke',\n",
       "  'total': 70000.0},\n",
       " {'org': 'Institut national de santé publique du Québec [INSPQ]',\n",
       "  'total': 70710.0},\n",
       " {'org': 'Ontario Institute for Cancer Research', 'total': 71250.0},\n",
       " {'org': 'Université du Québec en Abitibi-Témiscamingue [UQAT]',\n",
       "  'total': 72037.0},\n",
       " {'org': 'University of Pennsylvania', 'total': 80000.0},\n",
       " {'org': 'Université de la Colombie-Britannique [UBC]', 'total': 84323.0},\n",
       " {'org': 'Columbia University', 'total': 90000.0},\n",
       " {'org': 'Institut et hôpital neurologiques de Montréal', 'total': 91000.0},\n",
       " {'org': 'Collège Lionel-Groulx', 'total': 93385.0},\n",
       " {'org': 'National Institutes of Health [NIH]', 'total': 95952.0},\n",
       " {'org': 'Société de recherche sur le cancer [SRC]', 'total': 97733.0},\n",
       " {'org': \"Université d'Ottawa\", 'total': 100000.0},\n",
       " {'org': 'Alliance santé Québec [AsQ]', 'total': 100000.0},\n",
       " {'org': \"École nationale d'administration publique [ENAP]\",\n",
       "  'total': 100000.0},\n",
       " {'org': \"Centre de recherche de l'Institut universitaire de gériatrie de Montréal\",\n",
       "  'total': 105000.0},\n",
       " {'org': 'New York University [NYU]', 'total': 111345.0},\n",
       " {'org': 'PROMPT-Québec', 'total': 125000.0},\n",
       " {'org': 'Centre de recherche interdisciplinaire en réadaptation du Montréal métropolitain [CRIR]',\n",
       "  'total': 135000.0},\n",
       " {'org': \"Brigham and Women's Hospital\", 'total': 137500.0},\n",
       " {'org': 'Institut universitaire en santé mentale Douglas', 'total': 141000.0},\n",
       " {'org': 'Harvard University', 'total': 165000.0},\n",
       " {'org': 'Massachusetts General Hospital', 'total': 165700.0},\n",
       " {'org': 'Université de Toronto', 'total': 184323.0},\n",
       " {'org': 'Centre de recherche du CHU de Québec-Université Laval',\n",
       "  'total': 194128.0},\n",
       " {'org': 'Institut de la statistique du Québec [ISQ]', 'total': 200000.0},\n",
       " {'org': 'École Polytechnique de Montréal', 'total': 209300.0},\n",
       " {'org': 's. o.', 'total': 250324.0},\n",
       " {'org': 'Université du Québec en Outaouais [UQO]', 'total': 267044.0},\n",
       " {'org': 'CISSS de la Côte-Nord', 'total': 315543.0},\n",
       " {'org': 'CIUSSS du Saguenay–Lac-Saint-Jean', 'total': 318148.0},\n",
       " {'org': 'CISSS de la Montérégie-Centre', 'total': 319236.0},\n",
       " {'org': 'CISSS de Laval', 'total': 660500.0},\n",
       " {'org': 'Université du Québec à Trois-Rivières [UQTR]', 'total': 687754.0},\n",
       " {'org': 'Université Concordia', 'total': 796311.0},\n",
       " {'org': 'Institut de recherche du Centre universitaire de santé McGill',\n",
       "  'total': 1031754.0},\n",
       " {'org': 'Institut de recherches cliniques de Montréal [IRCM]',\n",
       "  'total': 1045161.0},\n",
       " {'org': 'Institut national de la recherche scientifique [INRS]',\n",
       "  'total': 1092491.0},\n",
       " {'org': \"CIUSSS de l'Ouest-de-l'Ile-de-Montréal\", 'total': 1215710.0},\n",
       " {'org': \"CIUSSS du Nord-de-l'Île-de-Montréal\", 'total': 1817924.0},\n",
       " {'org': 'Institut de cardiologie de Montréal', 'total': 1922135.0},\n",
       " {'org': 'CIUSSS de la Capitale-Nationale', 'total': 2019450.0},\n",
       " {'org': 'Université du Québec à Montréal [UQAM]', 'total': 2062571.0},\n",
       " {'org': \"CIUSSS du Centre-Sud-de-l'Île-de-Montréal\", 'total': 2195271.0},\n",
       " {'org': \"Centre de recherche de l'IUSM Douglas\", 'total': 2221051.0},\n",
       " {'org': \"CIUSSS du Centre-Ouest-de-l'Île-de-Montréal\", 'total': 2247101.0},\n",
       " {'org': 'Institut universitaire de cardiologie et de pneumologie de Québec - Université Laval [IUCPQ]',\n",
       "  'total': 2308930.0},\n",
       " {'org': \"CIUSSS de l'Est-de-l'Île-de-Montréal\", 'total': 3124955.0},\n",
       " {'org': \"CIUSSS de l'Estrie - CHUS\", 'total': 4082903.0},\n",
       " {'org': 'Centre hospitalier universitaire Sainte Justine',\n",
       "  'total': 4659282.0},\n",
       " {'org': 'Centre universitaire de santé McGill [CUSM]', 'total': 5254760.0},\n",
       " {'org': 'CHU de Québec - Université Laval', 'total': 6775249.0},\n",
       " {'org': 'Université de Sherbrooke', 'total': 6822254.0},\n",
       " {'org': \"Centre hospitalier de l'Université de Montréal [CHUM]\",\n",
       "  'total': 9033018.0},\n",
       " {'org': 'Université Laval', 'total': 10067607.0},\n",
       " {'org': 'Université de Montréal', 'total': 15006158.0},\n",
       " {'org': 'Université McGill', 'total': 16668922.0}]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## du plus petit au plus grands montants par établissement\n",
    "sortedByTotalByEtablissement"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "ffa00ecd",
   "metadata": {},
   "outputs": [],
   "source": [
    "## Créer un dictionnaire de tous les domaines sans doublon\n",
    "dict_domaines=set(sante['Domaine_de_recherche'].tolist())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "44af8aaf",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Appareil locomoteur et arthrite',\n",
       " 'Arts, littérature et société',\n",
       " 'Cancer',\n",
       " 'Développement et fonctionnement des personnes et des communautés, et vie sociale',\n",
       " 'Enjeux fondamentaux et finalités de la vie humaine',\n",
       " 'Environnement',\n",
       " 'Gestion des organisations ',\n",
       " 'Génétique humaine',\n",
       " 'Langues et langage',\n",
       " 'Maladies infectieuses et immunitaires',\n",
       " 'Matériaux',\n",
       " \"Milieux de vie, aménagement et appropriation de l'espace humain\",\n",
       " 'Médias, communications et information',\n",
       " 'Nature et interactions de la matière',\n",
       " 'Neurosciences, santé mentale et toxicomanies',\n",
       " 'Nutrition et métabolisme',\n",
       " 'Organismes vivants ',\n",
       " 'Relations internationales et développement',\n",
       " 'Santé circulatoire et respiratoire',\n",
       " 'Santé de la mère, des enfants et des adolescents ',\n",
       " 'Santé des populations',\n",
       " 'Santé différentielle des sexes',\n",
       " 'Services de santé',\n",
       " 'Techniques, mesures et systèmes',\n",
       " \"Technologie de l'information et des communications \",\n",
       " 'Vieillissement',\n",
       " nan,\n",
       " 's. o.',\n",
       " 'Économie, emploi et marchés',\n",
       " 'Éducation, savoirs et compétences'}"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dict_domaines"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "c079832d",
   "metadata": {},
   "outputs": [],
   "source": [
    "## Créer une nouvelle liste avec un loop pour obtenir montant total à chaque établissement\n",
    "liste_montantsDomaine=[]\n",
    "for et in dict_domaines:\n",
    "    montants=sante.loc[sante['Domaine_de_recherche']== et]    \n",
    "    dict_domaines = {'domaine': et, 'total': sum(montants['Montant_total'].tolist())}\n",
    "    liste_montantsDomaine.append(dict_domaines)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "bc8b28df",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'domaine': nan, 'total': 0},\n",
       " {'domaine': 'Arts, littérature et société', 'total': 15000.0},\n",
       " {'domaine': 'Cancer', 'total': 11159544.0},\n",
       " {'domaine': 'Santé des populations', 'total': 6587846.0},\n",
       " {'domaine': 'Appareil locomoteur et arthrite', 'total': 2646587.0},\n",
       " {'domaine': 'Santé circulatoire et respiratoire', 'total': 3630263.0},\n",
       " {'domaine': 'Éducation, savoirs et compétences', 'total': 675405.0},\n",
       " {'domaine': 'Nature et interactions de la matière', 'total': 20000.0},\n",
       " {'domaine': 'Génétique humaine', 'total': 1947586.0},\n",
       " {'domaine': 'Médias, communications et information', 'total': 20000.0},\n",
       " {'domaine': 'Enjeux fondamentaux et finalités de la vie humaine',\n",
       "  'total': 68131.0},\n",
       " {'domaine': 'Relations internationales et développement', 'total': 60323.0},\n",
       " {'domaine': 'Techniques, mesures et systèmes', 'total': 359161.0},\n",
       " {'domaine': 'Santé différentielle des sexes', 'total': 253838.0},\n",
       " {'domaine': 'Gestion des organisations ', 'total': 201505.0},\n",
       " {'domaine': 'Organismes vivants ', 'total': 934318.0},\n",
       " {'domaine': 'Services de santé', 'total': 6634149.0},\n",
       " {'domaine': 'Économie, emploi et marchés', 'total': 250000.0},\n",
       " {'domaine': 'Vieillissement', 'total': 3539382.0},\n",
       " {'domaine': 'Langues et langage', 'total': 62000.0},\n",
       " {'domaine': 'Développement et fonctionnement des personnes et des communautés, et vie sociale',\n",
       "  'total': 914288.0},\n",
       " {'domaine': 'Nutrition et métabolisme', 'total': 1479088.0},\n",
       " {'domaine': \"Milieux de vie, aménagement et appropriation de l'espace humain\",\n",
       "  'total': 93289.0},\n",
       " {'domaine': 's. o.', 'total': 821331.67},\n",
       " {'domaine': 'Maladies infectieuses et immunitaires', 'total': 4190940.0},\n",
       " {'domaine': 'Neurosciences, santé mentale et toxicomanies',\n",
       "  'total': 13108849.0},\n",
       " {'domaine': 'Environnement', 'total': 187252.0},\n",
       " {'domaine': \"Technologie de l'information et des communications \",\n",
       "  'total': 284813.0},\n",
       " {'domaine': 'Matériaux', 'total': 196238.0},\n",
       " {'domaine': 'Santé de la mère, des enfants et des adolescents ',\n",
       "  'total': 3753186.0}]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "liste_montantsDomaine"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "0c229161",
   "metadata": {},
   "outputs": [],
   "source": [
    "sortedByTotalByDomaine = sorted(liste_montantsDomaine, key=lambda d: d['total'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "dd36ca11",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'domaine': nan, 'total': 0},\n",
       " {'domaine': 'Arts, littérature et société', 'total': 15000.0},\n",
       " {'domaine': 'Nature et interactions de la matière', 'total': 20000.0},\n",
       " {'domaine': 'Médias, communications et information', 'total': 20000.0},\n",
       " {'domaine': 'Relations internationales et développement', 'total': 60323.0},\n",
       " {'domaine': 'Langues et langage', 'total': 62000.0},\n",
       " {'domaine': 'Enjeux fondamentaux et finalités de la vie humaine',\n",
       "  'total': 68131.0},\n",
       " {'domaine': \"Milieux de vie, aménagement et appropriation de l'espace humain\",\n",
       "  'total': 93289.0},\n",
       " {'domaine': 'Environnement', 'total': 187252.0},\n",
       " {'domaine': 'Matériaux', 'total': 196238.0},\n",
       " {'domaine': 'Gestion des organisations ', 'total': 201505.0},\n",
       " {'domaine': 'Économie, emploi et marchés', 'total': 250000.0},\n",
       " {'domaine': 'Santé différentielle des sexes', 'total': 253838.0},\n",
       " {'domaine': \"Technologie de l'information et des communications \",\n",
       "  'total': 284813.0},\n",
       " {'domaine': 'Techniques, mesures et systèmes', 'total': 359161.0},\n",
       " {'domaine': 'Éducation, savoirs et compétences', 'total': 675405.0},\n",
       " {'domaine': 's. o.', 'total': 821331.67},\n",
       " {'domaine': 'Développement et fonctionnement des personnes et des communautés, et vie sociale',\n",
       "  'total': 914288.0},\n",
       " {'domaine': 'Organismes vivants ', 'total': 934318.0},\n",
       " {'domaine': 'Nutrition et métabolisme', 'total': 1479088.0},\n",
       " {'domaine': 'Génétique humaine', 'total': 1947586.0},\n",
       " {'domaine': 'Appareil locomoteur et arthrite', 'total': 2646587.0},\n",
       " {'domaine': 'Vieillissement', 'total': 3539382.0},\n",
       " {'domaine': 'Santé circulatoire et respiratoire', 'total': 3630263.0},\n",
       " {'domaine': 'Santé de la mère, des enfants et des adolescents ',\n",
       "  'total': 3753186.0},\n",
       " {'domaine': 'Maladies infectieuses et immunitaires', 'total': 4190940.0},\n",
       " {'domaine': 'Santé des populations', 'total': 6587846.0},\n",
       " {'domaine': 'Services de santé', 'total': 6634149.0},\n",
       " {'domaine': 'Cancer', 'total': 11159544.0},\n",
       " {'domaine': 'Neurosciences, santé mentale et toxicomanies',\n",
       "  'total': 13108849.0}]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## du plus petit au plus grands montants par domaine\n",
    "sortedByTotalByDomaine"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "221bf8b1",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "montantTotalSante = sum(item['total'] for item in liste_montantsParEtablissements)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "3461e0e1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "111808601.0"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "montantTotalSante"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d53ecbce",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}