FB_300médias_parMois.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "b4fad905",
   "metadata": {},
   "source": [
    "# Analyse des *posts* Facebook de 309 médias du Québec (2011-2023)\n",
    "On commence par importer les modules nécessaires"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "9f3af368",
   "metadata": {},
   "outputs": [],
   "source": [
    "import glob, os\n",
    "import pandas as pan"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "79e9ae84",
   "metadata": {},
   "source": [
    "On importe tous les fichiers extraits de [CrowdTangle](https://www.crowdtangle.com/).\n",
    "\n",
    "Le nom de chacun a la même structure.\n",
    "\n",
    "`Historical-Report-MediasQuebec-2013-07-08-09-10-11-12.csv` signifie que c'est un rapport historique d'une liste que j'ai créée dans CrowdTangle et que j'ai baptisée `MediasQuebec`. Ici, le fichier couvre les mois 07 (juillet) à 12 (décembre) de l'année 2013.\n",
    "\n",
    "Quand on fait une exportation historique, chaque fichier doit contenir moins de 100k publications, d'où le grand nombre de fichiers."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "76ce1ac9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Historical-Report-MediasQuebec-2013-07-08-09-10-11-12.csv', 'Historical-Report-MediasQuebec-2023-05.csv', 'Historical-Report-MediasQuebec-2011.csv', 'Historical-Report-MediasQuebec-2023-04.csv', 'Historical-Report-MediasQuebec-2022-01-02.csv', 'Historical-Report-MediasQuebec-2015-01-02-03.csv', 'Historical-Report-MediasQuebec-2022-11-12.csv', 'Historical-Report-MediasQuebec-2023-01.csv', 'Historical-Report-MediasQuebec-2023-03.csv', 'Historical-Report-MediasQuebec-2015-04-05-06.csv', 'Historical-Report-MediasQuebec-2022-03-04.csv', 'Historical-Report-MediasQuebec-2018-07-08.csv', 'Historical-Report-MediasQuebec-2023-02.csv', 'Historical-Report-MediasQuebec-2020-08.csv', 'Historical-Report-MediasQuebec-2016-07-08-09.csv', 'Historical-Report-MediasQuebec-2020-09.csv', 'Historical-Report-MediasQuebec-2014-01-02-03-04-05-06.csv', 'Historical-Report-MediasQuebec-2017-07-08-09.csv', 'Historical-Report-MediasQuebec-2021-07-08.csv', 'Historical-Report-MediasQuebec-2022-09-10.csv', 'Historical-Report-MediasQuebec-2015-10-11-12.csv', 'Historical-Report-MediasQuebec-2022-05-06.csv', 'Historical-Report-MediasQuebec-2012-03--12.csv', 'Historical-Report-MediasQuebec-2019-07-08.csv', 'Historical-Report-MediasQuebec-2020-01.csv', 'Historical-Report-MediasQuebec-2015-07-08-09.csv', 'Historical-Report-MediasQuebec-2017-10-11-12.csv', 'Historical-Report-MediasQuebec-2020-02.csv', 'Historical-Report-MediasQuebec-2020-03.csv', 'Historical-Report-MediasQuebec-2016-10-11-12.csv', 'Historical-Report-MediasQuebec-2020-07.csv', 'Historical-Report-MediasQuebec-2019-05-06.csv', 'Historical-Report-MediasQuebec-2018-03-04.csv', 'Historical-Report-MediasQuebec-2021-09-10.csv', 'Historical-Report-MediasQuebec-2022-07-08.csv', 'Historical-Report-MediasQuebec-2020-12.csv', 'Historical-Report-MediasQuebec-2020-06.csv', 'Historical-Report-MediasQuebec-2018-01-02.csv', 'Historical-Report-MediasQuebec-2020-10.csv', 'Historical-Report-MediasQuebec-2020-04.csv', 'Historical-Report-MediasQuebec-2020-05.csv', 'Historical-Report-MediasQuebec-2020-11.csv', 'Historical-Report-MediasQuebec-2019-09-10.csv', 'Historical-Report-MediasQuebec-2021-05-06.csv', 'Historical-Report-MediasQuebec-2013-01-02-03-04-05-06.csv', 'Historical-Report-MediasQuebec-2018-11-12.csv', 'Historical-Report-MediasQuebec-2017-01-02-03.csv', 'Historical-Report-MediasQuebec-2012-01-02.csv', 'Historical-Report-MediasQuebec-2017-04-05-06.csv', 'Historical-Report-MediasQuebec-2019-03-04.csv', 'Historical-Report-MediasQuebec-2018-05-06.csv', 'Historical-Report-MediasQuebec-2021-11-12.csv', 'Historical-Report-MediasQuebec-2014-07-08-09-10-11-12.csv', 'Historical-Report-MediasQuebec-2021-01-02.csv', 'Historical-Report-MediasQuebec-2016-01-02-03.csv', 'Historical-Report-MediasQuebec-2019-01-02.csv', 'Historical-Report-MediasQuebec-2016-04-05-06.csv', 'Historical-Report-MediasQuebec-2018-09-10.csv', 'Historical-Report-MediasQuebec-2021-03-04.csv', 'Historical-Report-MediasQuebec-2019-11-12.csv']\n"
     ]
    }
   ],
   "source": [
    "tousfich = glob.glob(os.path.join(\"\", \"Historical*.csv\"))\n",
    "print(tousfich)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "11bc1a9a",
   "metadata": {},
   "source": [
    "Nous avons importé 60 fichiers en tout."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "10e8c4d8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "60"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(tousfich)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ebb2b728",
   "metadata": {},
   "source": [
    "Les deux lignes de code ci-dessous vont d'abord lire tous les fichiers et les placer dans la variable `chq_fich`, puis les concaténer avec la méthode `.concat` et placer le tableau de données (*dataframe*) résultant dans la variable `fich`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "e3ffc2bf",
   "metadata": {},
   "outputs": [],
   "source": [
    "chq_fich = (pan.read_csv(f, low_memory=False) for f in tousfich)\n",
    "fich = pan.concat(chq_fich, ignore_index=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0c7be2b5",
   "metadata": {},
   "source": [
    "En faisant s'afficher le tableau `fich`, on constate qu'il contient plus de 4,5 millions d'enregistrements. Chacun est une publication d'un média dans Facebook depuis le 1er janvier 2011 jusqu'au 31 mai 2023."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "bb3dace2",
   "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>Page Name</th>\n",
       "      <th>User Name</th>\n",
       "      <th>Facebook Id</th>\n",
       "      <th>Page Category</th>\n",
       "      <th>Page Admin Top Country</th>\n",
       "      <th>Page Description</th>\n",
       "      <th>Page Created</th>\n",
       "      <th>Likes at Posting</th>\n",
       "      <th>Followers at Posting</th>\n",
       "      <th>Post Created</th>\n",
       "      <th>...</th>\n",
       "      <th>Message</th>\n",
       "      <th>Link</th>\n",
       "      <th>Final Link</th>\n",
       "      <th>Image Text</th>\n",
       "      <th>Link Text</th>\n",
       "      <th>Description</th>\n",
       "      <th>Sponsor Id</th>\n",
       "      <th>Sponsor Name</th>\n",
       "      <th>Sponsor Category</th>\n",
       "      <th>Overperforming Score (weighted  —  Likes 1x Shares 1x Comments 1x Love 1x Wow 1x Haha 1x Sad 1x Angry 1x Care 1x )</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ICI Estrie</td>\n",
       "      <td>iciestrie</td>\n",
       "      <td>211536155525838</td>\n",
       "      <td>BROADCASTING_MEDIA_PRODUCTION</td>\n",
       "      <td>CA</td>\n",
       "      <td>Radio-Canada Estrie, ce sont vos nouvelles à l...</td>\n",
       "      <td>2011-03-29 17:57:10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-31 23:50:00 EST</td>\n",
       "      <td>...</td>\n",
       "      <td>Bonne et heureuse année à toutes et tous de la...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2,52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TVA Sports</td>\n",
       "      <td>TVASports</td>\n",
       "      <td>100064823193433</td>\n",
       "      <td>TV_NETWORK</td>\n",
       "      <td>CA</td>\n",
       "      <td>La page Facebook officielle de la chaîne TVA S...</td>\n",
       "      <td>2011-05-31 09:20:32</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-31 22:50:51 EST</td>\n",
       "      <td>...</td>\n",
       "      <td>Les Islanders de New York ont marqué quatre bu...</td>\n",
       "      <td>http://tvasports.ca/hockey/lnh/ryder-termine-l...</td>\n",
       "      <td>http://www.tvasports.ca/2013/12/31/les-islande...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Les Islanders en embuscade</td>\n",
       "      <td>Kyle Okposo et Frans Nielsen, deux fois, ont é...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5,79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CIBM FM 107</td>\n",
       "      <td>CIBM107</td>\n",
       "      <td>100063576520336</td>\n",
       "      <td>BROADCASTING_MEDIA_PRODUCTION</td>\n",
       "      <td>CA</td>\n",
       "      <td>FM 107 - La Radio des Hits</td>\n",
       "      <td>2009-08-25 12:02:04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-31 22:27:20 EST</td>\n",
       "      <td>...</td>\n",
       "      <td>(Christian) En ondes jusqu'à 2 h a.m pour le p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CIEL FM 103,7</td>\n",
       "      <td>CIEL103</td>\n",
       "      <td>208658131206</td>\n",
       "      <td>BROADCASTING_MEDIA_PRODUCTION</td>\n",
       "      <td>CA</td>\n",
       "      <td>CIEL FM 103,7 Rivière-du-Loup: La fréquence bl...</td>\n",
       "      <td>2009-12-15 15:23:22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-31 22:20:40 EST</td>\n",
       "      <td>...</td>\n",
       "      <td>Valérie Deschamps avec vous de 22h à 2h pour l...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-10,6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>TVA Sports</td>\n",
       "      <td>TVASports</td>\n",
       "      <td>100064823193433</td>\n",
       "      <td>TV_NETWORK</td>\n",
       "      <td>CA</td>\n",
       "      <td>La page Facebook officielle de la chaîne TVA S...</td>\n",
       "      <td>2011-05-31 09:20:32</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-31 22:11:10 EST</td>\n",
       "      <td>...</td>\n",
       "      <td>Le Canadien s’est effondré en 3e période pour ...</td>\n",
       "      <td>https://bit.ly/1kZEdmv</td>\n",
       "      <td>https://www.tvasports.ca/hockey/canadiens/brie...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Effondrement avant le nouvel an</td>\n",
       "      <td>Le Canadien de Montréal tentait de finir en be...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5,54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4549554</th>\n",
       "      <td>RDS</td>\n",
       "      <td>RDS</td>\n",
       "      <td>100064854125890</td>\n",
       "      <td>TV_NETWORK</td>\n",
       "      <td>CA</td>\n",
       "      <td>La page Facebook de RDS. Le sport sans limites...</td>\n",
       "      <td>2009-08-10 17:38:31</td>\n",
       "      <td>385381.0</td>\n",
       "      <td>372338.0</td>\n",
       "      <td>2019-11-01 00:18:02 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>Max Pacioretty participe au 4e but des Golden ...</td>\n",
       "      <td>https://www.facebook.com/RDS/photos/a.35015323...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2,16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4549555</th>\n",
       "      <td>La Presse</td>\n",
       "      <td>LaPresseFB</td>\n",
       "      <td>100064750746253</td>\n",
       "      <td>NEWS_SITE</td>\n",
       "      <td>CA</td>\n",
       "      <td>Média d’information qui regroupe la plus grand...</td>\n",
       "      <td>2009-04-02 03:00:46</td>\n",
       "      <td>612742.0</td>\n",
       "      <td>611819.0</td>\n",
       "      <td>2019-11-01 00:14:34 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>Le département américain de l'Intérieur a inte...</td>\n",
       "      <td>https://bit.ly/2N5MniA</td>\n",
       "      <td>https://www.lapresse.ca/international/etats-un...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>É.-U: le département de l'Intérieur cloue au s...</td>\n",
       "      <td>(Washington) Le département américain de l’Int...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5,43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4549556</th>\n",
       "      <td>La Presse</td>\n",
       "      <td>LaPresseFB</td>\n",
       "      <td>100064750746253</td>\n",
       "      <td>NEWS_SITE</td>\n",
       "      <td>CA</td>\n",
       "      <td>Média d’information qui regroupe la plus grand...</td>\n",
       "      <td>2009-04-02 03:00:46</td>\n",
       "      <td>612742.0</td>\n",
       "      <td>611819.0</td>\n",
       "      <td>2019-11-01 00:08:03 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>La rougeole est 10 fois plus mortelle que prév...</td>\n",
       "      <td>https://bit.ly/2JHtsZs</td>\n",
       "      <td>https://www.lapresse.ca/actualites/sciences/20...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>La rougeole 10 fois plus mortelle que prévu, s...</td>\n",
       "      <td>La rougeole est 10 fois plus mortelle que prév...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6,11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4549557</th>\n",
       "      <td>Info Dimanche</td>\n",
       "      <td>infodimanche</td>\n",
       "      <td>100063759871440</td>\n",
       "      <td>ACTIVITY_GENERAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>Bienvenue sur notre page Facebook! Vous voulez...</td>\n",
       "      <td>2009-11-13 21:31:15</td>\n",
       "      <td>21093.0</td>\n",
       "      <td>21435.0</td>\n",
       "      <td>2019-11-01 00:02:13 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>Maintenant disponible, nos indices de la semai...</td>\n",
       "      <td>https://www.facebook.com/infodimanche/photos/a...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4549558</th>\n",
       "      <td>Le Journal de Québec</td>\n",
       "      <td>JdeQuebec</td>\n",
       "      <td>100064629642245</td>\n",
       "      <td>MEDIA_NEWS_COMPANY</td>\n",
       "      <td>CA</td>\n",
       "      <td>Des nouvelles accessibles et complètes: sports...</td>\n",
       "      <td>2010-10-05 19:04:37</td>\n",
       "      <td>410294.0</td>\n",
       "      <td>402948.0</td>\n",
       "      <td>2019-11-01 00:00:03 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>Ils étaient déguisés et agenouillés pour resse...</td>\n",
       "      <td>https://www.journaldequebec.com/2019/10/31/son...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Son père tué à l'Halloween il y a 40 ans</td>\n",
       "      <td>Le soir de l’Halloween 1979, il y a 40 ans, so...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1,07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4549559 rows × 40 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Page Name     User Name      Facebook Id  \\\n",
       "0                  ICI Estrie     iciestrie  211536155525838   \n",
       "1                  TVA Sports     TVASports  100064823193433   \n",
       "2                 CIBM FM 107       CIBM107  100063576520336   \n",
       "3               CIEL FM 103,7       CIEL103     208658131206   \n",
       "4                  TVA Sports     TVASports  100064823193433   \n",
       "...                       ...           ...              ...   \n",
       "4549554                   RDS           RDS  100064854125890   \n",
       "4549555             La Presse    LaPresseFB  100064750746253   \n",
       "4549556             La Presse    LaPresseFB  100064750746253   \n",
       "4549557         Info Dimanche  infodimanche  100063759871440   \n",
       "4549558  Le Journal de Québec     JdeQuebec  100064629642245   \n",
       "\n",
       "                         Page Category Page Admin Top Country  \\\n",
       "0        BROADCASTING_MEDIA_PRODUCTION                     CA   \n",
       "1                           TV_NETWORK                     CA   \n",
       "2        BROADCASTING_MEDIA_PRODUCTION                     CA   \n",
       "3        BROADCASTING_MEDIA_PRODUCTION                     CA   \n",
       "4                           TV_NETWORK                     CA   \n",
       "...                                ...                    ...   \n",
       "4549554                     TV_NETWORK                     CA   \n",
       "4549555                      NEWS_SITE                     CA   \n",
       "4549556                      NEWS_SITE                     CA   \n",
       "4549557               ACTIVITY_GENERAL                     CA   \n",
       "4549558             MEDIA_NEWS_COMPANY                     CA   \n",
       "\n",
       "                                          Page Description  \\\n",
       "0        Radio-Canada Estrie, ce sont vos nouvelles à l...   \n",
       "1        La page Facebook officielle de la chaîne TVA S...   \n",
       "2                               FM 107 - La Radio des Hits   \n",
       "3        CIEL FM 103,7 Rivière-du-Loup: La fréquence bl...   \n",
       "4        La page Facebook officielle de la chaîne TVA S...   \n",
       "...                                                    ...   \n",
       "4549554  La page Facebook de RDS. Le sport sans limites...   \n",
       "4549555  Média d’information qui regroupe la plus grand...   \n",
       "4549556  Média d’information qui regroupe la plus grand...   \n",
       "4549557  Bienvenue sur notre page Facebook! Vous voulez...   \n",
       "4549558  Des nouvelles accessibles et complètes: sports...   \n",
       "\n",
       "                Page Created  Likes at Posting  Followers at Posting  \\\n",
       "0        2011-03-29 17:57:10               NaN                   NaN   \n",
       "1        2011-05-31 09:20:32               NaN                   NaN   \n",
       "2        2009-08-25 12:02:04               NaN                   NaN   \n",
       "3        2009-12-15 15:23:22               NaN                   NaN   \n",
       "4        2011-05-31 09:20:32               NaN                   NaN   \n",
       "...                      ...               ...                   ...   \n",
       "4549554  2009-08-10 17:38:31          385381.0              372338.0   \n",
       "4549555  2009-04-02 03:00:46          612742.0              611819.0   \n",
       "4549556  2009-04-02 03:00:46          612742.0              611819.0   \n",
       "4549557  2009-11-13 21:31:15           21093.0               21435.0   \n",
       "4549558  2010-10-05 19:04:37          410294.0              402948.0   \n",
       "\n",
       "                    Post Created  ...  \\\n",
       "0        2013-12-31 23:50:00 EST  ...   \n",
       "1        2013-12-31 22:50:51 EST  ...   \n",
       "2        2013-12-31 22:27:20 EST  ...   \n",
       "3        2013-12-31 22:20:40 EST  ...   \n",
       "4        2013-12-31 22:11:10 EST  ...   \n",
       "...                          ...  ...   \n",
       "4549554  2019-11-01 00:18:02 EDT  ...   \n",
       "4549555  2019-11-01 00:14:34 EDT  ...   \n",
       "4549556  2019-11-01 00:08:03 EDT  ...   \n",
       "4549557  2019-11-01 00:02:13 EDT  ...   \n",
       "4549558  2019-11-01 00:00:03 EDT  ...   \n",
       "\n",
       "                                                   Message  \\\n",
       "0        Bonne et heureuse année à toutes et tous de la...   \n",
       "1        Les Islanders de New York ont marqué quatre bu...   \n",
       "2        (Christian) En ondes jusqu'à 2 h a.m pour le p...   \n",
       "3        Valérie Deschamps avec vous de 22h à 2h pour l...   \n",
       "4        Le Canadien s’est effondré en 3e période pour ...   \n",
       "...                                                    ...   \n",
       "4549554  Max Pacioretty participe au 4e but des Golden ...   \n",
       "4549555  Le département américain de l'Intérieur a inte...   \n",
       "4549556  La rougeole est 10 fois plus mortelle que prév...   \n",
       "4549557  Maintenant disponible, nos indices de la semai...   \n",
       "4549558  Ils étaient déguisés et agenouillés pour resse...   \n",
       "\n",
       "                                                      Link  \\\n",
       "0                                                      NaN   \n",
       "1        http://tvasports.ca/hockey/lnh/ryder-termine-l...   \n",
       "2                                                      NaN   \n",
       "3                                                      NaN   \n",
       "4                                   https://bit.ly/1kZEdmv   \n",
       "...                                                    ...   \n",
       "4549554  https://www.facebook.com/RDS/photos/a.35015323...   \n",
       "4549555                             https://bit.ly/2N5MniA   \n",
       "4549556                             https://bit.ly/2JHtsZs   \n",
       "4549557  https://www.facebook.com/infodimanche/photos/a...   \n",
       "4549558  https://www.journaldequebec.com/2019/10/31/son...   \n",
       "\n",
       "                                                Final Link Image Text  \\\n",
       "0                                                      NaN        NaN   \n",
       "1        http://www.tvasports.ca/2013/12/31/les-islande...        NaN   \n",
       "2                                                      NaN        NaN   \n",
       "3                                                      NaN        NaN   \n",
       "4        https://www.tvasports.ca/hockey/canadiens/brie...        NaN   \n",
       "...                                                    ...        ...   \n",
       "4549554                                                NaN        NaN   \n",
       "4549555  https://www.lapresse.ca/international/etats-un...        NaN   \n",
       "4549556  https://www.lapresse.ca/actualites/sciences/20...        NaN   \n",
       "4549557                                                NaN        NaN   \n",
       "4549558                                                NaN        NaN   \n",
       "\n",
       "                                                 Link Text  \\\n",
       "0                                                      NaN   \n",
       "1                               Les Islanders en embuscade   \n",
       "2                                                      NaN   \n",
       "3                                                      NaN   \n",
       "4                          Effondrement avant le nouvel an   \n",
       "...                                                    ...   \n",
       "4549554                                                NaN   \n",
       "4549555  É.-U: le département de l'Intérieur cloue au s...   \n",
       "4549556  La rougeole 10 fois plus mortelle que prévu, s...   \n",
       "4549557                                                NaN   \n",
       "4549558           Son père tué à l'Halloween il y a 40 ans   \n",
       "\n",
       "                                               Description  Sponsor Id  \\\n",
       "0                                                      NaN         NaN   \n",
       "1        Kyle Okposo et Frans Nielsen, deux fois, ont é...         NaN   \n",
       "2                                                      NaN         NaN   \n",
       "3                                                      NaN         NaN   \n",
       "4        Le Canadien de Montréal tentait de finir en be...         NaN   \n",
       "...                                                    ...         ...   \n",
       "4549554                                                NaN         NaN   \n",
       "4549555  (Washington) Le département américain de l’Int...         NaN   \n",
       "4549556  La rougeole est 10 fois plus mortelle que prév...         NaN   \n",
       "4549557                                                NaN         NaN   \n",
       "4549558  Le soir de l’Halloween 1979, il y a 40 ans, so...         NaN   \n",
       "\n",
       "         Sponsor Name  Sponsor Category  \\\n",
       "0                 NaN               NaN   \n",
       "1                 NaN               NaN   \n",
       "2                 NaN               NaN   \n",
       "3                 NaN               NaN   \n",
       "4                 NaN               NaN   \n",
       "...               ...               ...   \n",
       "4549554           NaN               NaN   \n",
       "4549555           NaN               NaN   \n",
       "4549556           NaN               NaN   \n",
       "4549557           NaN               NaN   \n",
       "4549558           NaN               NaN   \n",
       "\n",
       "         Overperforming Score (weighted  —  Likes 1x Shares 1x Comments 1x Love 1x Wow 1x Haha 1x Sad 1x Angry 1x Care 1x )  \n",
       "0                                                    -2,52                                                                   \n",
       "1                                                    -5,79                                                                   \n",
       "2                                                     -5,7                                                                   \n",
       "3                                                    -10,6                                                                   \n",
       "4                                                    -5,54                                                                   \n",
       "...                                                    ...                                                                   \n",
       "4549554                                              -2,16                                                                   \n",
       "4549555                                              -5,43                                                                   \n",
       "4549556                                               6,11                                                                   \n",
       "4549557                                                -47                                                                   \n",
       "4549558                                              -1,07                                                                   \n",
       "\n",
       "[4549559 rows x 40 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b2f90c42",
   "metadata": {},
   "source": [
    "Pour faciliter l'analyse, on crée deux nouvelles colonnes pour indiquer à quelle année et au cours de quel mois (paire année-mois, en fait) a été publié chaque *post*."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "7475eecb",
   "metadata": {},
   "outputs": [],
   "source": [
    "fich[\"année\"] = fich[\"Post Created\"].str[:4]\n",
    "fich[\"mois\"] = fich[\"Post Created\"].str[:7]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b1f57b04",
   "metadata": {},
   "source": [
    "Simple vérification pour voir si nos variables ont bel et bien été créées."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "d4d4d464",
   "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>Page Name</th>\n",
       "      <th>User Name</th>\n",
       "      <th>Facebook Id</th>\n",
       "      <th>Page Category</th>\n",
       "      <th>Page Admin Top Country</th>\n",
       "      <th>Page Description</th>\n",
       "      <th>Page Created</th>\n",
       "      <th>Likes at Posting</th>\n",
       "      <th>Followers at Posting</th>\n",
       "      <th>Post Created</th>\n",
       "      <th>...</th>\n",
       "      <th>Final Link</th>\n",
       "      <th>Image Text</th>\n",
       "      <th>Link Text</th>\n",
       "      <th>Description</th>\n",
       "      <th>Sponsor Id</th>\n",
       "      <th>Sponsor Name</th>\n",
       "      <th>Sponsor Category</th>\n",
       "      <th>Overperforming Score (weighted  —  Likes 1x Shares 1x Comments 1x Love 1x Wow 1x Haha 1x Sad 1x Angry 1x Care 1x )</th>\n",
       "      <th>année</th>\n",
       "      <th>mois</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ICI Estrie</td>\n",
       "      <td>iciestrie</td>\n",
       "      <td>211536155525838</td>\n",
       "      <td>BROADCASTING_MEDIA_PRODUCTION</td>\n",
       "      <td>CA</td>\n",
       "      <td>Radio-Canada Estrie, ce sont vos nouvelles à l...</td>\n",
       "      <td>2011-03-29 17:57:10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-31 23:50:00 EST</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2,52</td>\n",
       "      <td>2013</td>\n",
       "      <td>2013-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TVA Sports</td>\n",
       "      <td>TVASports</td>\n",
       "      <td>100064823193433</td>\n",
       "      <td>TV_NETWORK</td>\n",
       "      <td>CA</td>\n",
       "      <td>La page Facebook officielle de la chaîne TVA S...</td>\n",
       "      <td>2011-05-31 09:20:32</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-31 22:50:51 EST</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.tvasports.ca/2013/12/31/les-islande...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Les Islanders en embuscade</td>\n",
       "      <td>Kyle Okposo et Frans Nielsen, deux fois, ont é...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5,79</td>\n",
       "      <td>2013</td>\n",
       "      <td>2013-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CIBM FM 107</td>\n",
       "      <td>CIBM107</td>\n",
       "      <td>100063576520336</td>\n",
       "      <td>BROADCASTING_MEDIA_PRODUCTION</td>\n",
       "      <td>CA</td>\n",
       "      <td>FM 107 - La Radio des Hits</td>\n",
       "      <td>2009-08-25 12:02:04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-31 22:27:20 EST</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5,7</td>\n",
       "      <td>2013</td>\n",
       "      <td>2013-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CIEL FM 103,7</td>\n",
       "      <td>CIEL103</td>\n",
       "      <td>208658131206</td>\n",
       "      <td>BROADCASTING_MEDIA_PRODUCTION</td>\n",
       "      <td>CA</td>\n",
       "      <td>CIEL FM 103,7 Rivière-du-Loup: La fréquence bl...</td>\n",
       "      <td>2009-12-15 15:23:22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-31 22:20:40 EST</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-10,6</td>\n",
       "      <td>2013</td>\n",
       "      <td>2013-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>TVA Sports</td>\n",
       "      <td>TVASports</td>\n",
       "      <td>100064823193433</td>\n",
       "      <td>TV_NETWORK</td>\n",
       "      <td>CA</td>\n",
       "      <td>La page Facebook officielle de la chaîne TVA S...</td>\n",
       "      <td>2011-05-31 09:20:32</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-31 22:11:10 EST</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.tvasports.ca/hockey/canadiens/brie...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Effondrement avant le nouvel an</td>\n",
       "      <td>Le Canadien de Montréal tentait de finir en be...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5,54</td>\n",
       "      <td>2013</td>\n",
       "      <td>2013-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4549554</th>\n",
       "      <td>RDS</td>\n",
       "      <td>RDS</td>\n",
       "      <td>100064854125890</td>\n",
       "      <td>TV_NETWORK</td>\n",
       "      <td>CA</td>\n",
       "      <td>La page Facebook de RDS. Le sport sans limites...</td>\n",
       "      <td>2009-08-10 17:38:31</td>\n",
       "      <td>385381.0</td>\n",
       "      <td>372338.0</td>\n",
       "      <td>2019-11-01 00:18:02 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2,16</td>\n",
       "      <td>2019</td>\n",
       "      <td>2019-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4549555</th>\n",
       "      <td>La Presse</td>\n",
       "      <td>LaPresseFB</td>\n",
       "      <td>100064750746253</td>\n",
       "      <td>NEWS_SITE</td>\n",
       "      <td>CA</td>\n",
       "      <td>Média d’information qui regroupe la plus grand...</td>\n",
       "      <td>2009-04-02 03:00:46</td>\n",
       "      <td>612742.0</td>\n",
       "      <td>611819.0</td>\n",
       "      <td>2019-11-01 00:14:34 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.lapresse.ca/international/etats-un...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>É.-U: le département de l'Intérieur cloue au s...</td>\n",
       "      <td>(Washington) Le département américain de l’Int...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5,43</td>\n",
       "      <td>2019</td>\n",
       "      <td>2019-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4549556</th>\n",
       "      <td>La Presse</td>\n",
       "      <td>LaPresseFB</td>\n",
       "      <td>100064750746253</td>\n",
       "      <td>NEWS_SITE</td>\n",
       "      <td>CA</td>\n",
       "      <td>Média d’information qui regroupe la plus grand...</td>\n",
       "      <td>2009-04-02 03:00:46</td>\n",
       "      <td>612742.0</td>\n",
       "      <td>611819.0</td>\n",
       "      <td>2019-11-01 00:08:03 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.lapresse.ca/actualites/sciences/20...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>La rougeole 10 fois plus mortelle que prévu, s...</td>\n",
       "      <td>La rougeole est 10 fois plus mortelle que prév...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6,11</td>\n",
       "      <td>2019</td>\n",
       "      <td>2019-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4549557</th>\n",
       "      <td>Info Dimanche</td>\n",
       "      <td>infodimanche</td>\n",
       "      <td>100063759871440</td>\n",
       "      <td>ACTIVITY_GENERAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>Bienvenue sur notre page Facebook! Vous voulez...</td>\n",
       "      <td>2009-11-13 21:31:15</td>\n",
       "      <td>21093.0</td>\n",
       "      <td>21435.0</td>\n",
       "      <td>2019-11-01 00:02:13 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-47</td>\n",
       "      <td>2019</td>\n",
       "      <td>2019-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4549558</th>\n",
       "      <td>Le Journal de Québec</td>\n",
       "      <td>JdeQuebec</td>\n",
       "      <td>100064629642245</td>\n",
       "      <td>MEDIA_NEWS_COMPANY</td>\n",
       "      <td>CA</td>\n",
       "      <td>Des nouvelles accessibles et complètes: sports...</td>\n",
       "      <td>2010-10-05 19:04:37</td>\n",
       "      <td>410294.0</td>\n",
       "      <td>402948.0</td>\n",
       "      <td>2019-11-01 00:00:03 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Son père tué à l'Halloween il y a 40 ans</td>\n",
       "      <td>Le soir de l’Halloween 1979, il y a 40 ans, so...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1,07</td>\n",
       "      <td>2019</td>\n",
       "      <td>2019-11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4549559 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Page Name     User Name      Facebook Id  \\\n",
       "0                  ICI Estrie     iciestrie  211536155525838   \n",
       "1                  TVA Sports     TVASports  100064823193433   \n",
       "2                 CIBM FM 107       CIBM107  100063576520336   \n",
       "3               CIEL FM 103,7       CIEL103     208658131206   \n",
       "4                  TVA Sports     TVASports  100064823193433   \n",
       "...                       ...           ...              ...   \n",
       "4549554                   RDS           RDS  100064854125890   \n",
       "4549555             La Presse    LaPresseFB  100064750746253   \n",
       "4549556             La Presse    LaPresseFB  100064750746253   \n",
       "4549557         Info Dimanche  infodimanche  100063759871440   \n",
       "4549558  Le Journal de Québec     JdeQuebec  100064629642245   \n",
       "\n",
       "                         Page Category Page Admin Top Country  \\\n",
       "0        BROADCASTING_MEDIA_PRODUCTION                     CA   \n",
       "1                           TV_NETWORK                     CA   \n",
       "2        BROADCASTING_MEDIA_PRODUCTION                     CA   \n",
       "3        BROADCASTING_MEDIA_PRODUCTION                     CA   \n",
       "4                           TV_NETWORK                     CA   \n",
       "...                                ...                    ...   \n",
       "4549554                     TV_NETWORK                     CA   \n",
       "4549555                      NEWS_SITE                     CA   \n",
       "4549556                      NEWS_SITE                     CA   \n",
       "4549557               ACTIVITY_GENERAL                     CA   \n",
       "4549558             MEDIA_NEWS_COMPANY                     CA   \n",
       "\n",
       "                                          Page Description  \\\n",
       "0        Radio-Canada Estrie, ce sont vos nouvelles à l...   \n",
       "1        La page Facebook officielle de la chaîne TVA S...   \n",
       "2                               FM 107 - La Radio des Hits   \n",
       "3        CIEL FM 103,7 Rivière-du-Loup: La fréquence bl...   \n",
       "4        La page Facebook officielle de la chaîne TVA S...   \n",
       "...                                                    ...   \n",
       "4549554  La page Facebook de RDS. Le sport sans limites...   \n",
       "4549555  Média d’information qui regroupe la plus grand...   \n",
       "4549556  Média d’information qui regroupe la plus grand...   \n",
       "4549557  Bienvenue sur notre page Facebook! Vous voulez...   \n",
       "4549558  Des nouvelles accessibles et complètes: sports...   \n",
       "\n",
       "                Page Created  Likes at Posting  Followers at Posting  \\\n",
       "0        2011-03-29 17:57:10               NaN                   NaN   \n",
       "1        2011-05-31 09:20:32               NaN                   NaN   \n",
       "2        2009-08-25 12:02:04               NaN                   NaN   \n",
       "3        2009-12-15 15:23:22               NaN                   NaN   \n",
       "4        2011-05-31 09:20:32               NaN                   NaN   \n",
       "...                      ...               ...                   ...   \n",
       "4549554  2009-08-10 17:38:31          385381.0              372338.0   \n",
       "4549555  2009-04-02 03:00:46          612742.0              611819.0   \n",
       "4549556  2009-04-02 03:00:46          612742.0              611819.0   \n",
       "4549557  2009-11-13 21:31:15           21093.0               21435.0   \n",
       "4549558  2010-10-05 19:04:37          410294.0              402948.0   \n",
       "\n",
       "                    Post Created  ...  \\\n",
       "0        2013-12-31 23:50:00 EST  ...   \n",
       "1        2013-12-31 22:50:51 EST  ...   \n",
       "2        2013-12-31 22:27:20 EST  ...   \n",
       "3        2013-12-31 22:20:40 EST  ...   \n",
       "4        2013-12-31 22:11:10 EST  ...   \n",
       "...                          ...  ...   \n",
       "4549554  2019-11-01 00:18:02 EDT  ...   \n",
       "4549555  2019-11-01 00:14:34 EDT  ...   \n",
       "4549556  2019-11-01 00:08:03 EDT  ...   \n",
       "4549557  2019-11-01 00:02:13 EDT  ...   \n",
       "4549558  2019-11-01 00:00:03 EDT  ...   \n",
       "\n",
       "                                                Final Link Image Text  \\\n",
       "0                                                      NaN        NaN   \n",
       "1        http://www.tvasports.ca/2013/12/31/les-islande...        NaN   \n",
       "2                                                      NaN        NaN   \n",
       "3                                                      NaN        NaN   \n",
       "4        https://www.tvasports.ca/hockey/canadiens/brie...        NaN   \n",
       "...                                                    ...        ...   \n",
       "4549554                                                NaN        NaN   \n",
       "4549555  https://www.lapresse.ca/international/etats-un...        NaN   \n",
       "4549556  https://www.lapresse.ca/actualites/sciences/20...        NaN   \n",
       "4549557                                                NaN        NaN   \n",
       "4549558                                                NaN        NaN   \n",
       "\n",
       "                                                 Link Text  \\\n",
       "0                                                      NaN   \n",
       "1                               Les Islanders en embuscade   \n",
       "2                                                      NaN   \n",
       "3                                                      NaN   \n",
       "4                          Effondrement avant le nouvel an   \n",
       "...                                                    ...   \n",
       "4549554                                                NaN   \n",
       "4549555  É.-U: le département de l'Intérieur cloue au s...   \n",
       "4549556  La rougeole 10 fois plus mortelle que prévu, s...   \n",
       "4549557                                                NaN   \n",
       "4549558           Son père tué à l'Halloween il y a 40 ans   \n",
       "\n",
       "                                               Description  Sponsor Id  \\\n",
       "0                                                      NaN         NaN   \n",
       "1        Kyle Okposo et Frans Nielsen, deux fois, ont é...         NaN   \n",
       "2                                                      NaN         NaN   \n",
       "3                                                      NaN         NaN   \n",
       "4        Le Canadien de Montréal tentait de finir en be...         NaN   \n",
       "...                                                    ...         ...   \n",
       "4549554                                                NaN         NaN   \n",
       "4549555  (Washington) Le département américain de l’Int...         NaN   \n",
       "4549556  La rougeole est 10 fois plus mortelle que prév...         NaN   \n",
       "4549557                                                NaN         NaN   \n",
       "4549558  Le soir de l’Halloween 1979, il y a 40 ans, so...         NaN   \n",
       "\n",
       "         Sponsor Name  Sponsor Category  \\\n",
       "0                 NaN               NaN   \n",
       "1                 NaN               NaN   \n",
       "2                 NaN               NaN   \n",
       "3                 NaN               NaN   \n",
       "4                 NaN               NaN   \n",
       "...               ...               ...   \n",
       "4549554           NaN               NaN   \n",
       "4549555           NaN               NaN   \n",
       "4549556           NaN               NaN   \n",
       "4549557           NaN               NaN   \n",
       "4549558           NaN               NaN   \n",
       "\n",
       "         Overperforming Score (weighted  —  Likes 1x Shares 1x Comments 1x Love 1x Wow 1x Haha 1x Sad 1x Angry 1x Care 1x )  \\\n",
       "0                                                    -2,52                                                                    \n",
       "1                                                    -5,79                                                                    \n",
       "2                                                     -5,7                                                                    \n",
       "3                                                    -10,6                                                                    \n",
       "4                                                    -5,54                                                                    \n",
       "...                                                    ...                                                                    \n",
       "4549554                                              -2,16                                                                    \n",
       "4549555                                              -5,43                                                                    \n",
       "4549556                                               6,11                                                                    \n",
       "4549557                                                -47                                                                    \n",
       "4549558                                              -1,07                                                                    \n",
       "\n",
       "         année     mois  \n",
       "0         2013  2013-12  \n",
       "1         2013  2013-12  \n",
       "2         2013  2013-12  \n",
       "3         2013  2013-12  \n",
       "4         2013  2013-12  \n",
       "...        ...      ...  \n",
       "4549554   2019  2019-11  \n",
       "4549555   2019  2019-11  \n",
       "4549556   2019  2019-11  \n",
       "4549557   2019  2019-11  \n",
       "4549558   2019  2019-11  \n",
       "\n",
       "[4549559 rows x 42 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bddb5ae7",
   "metadata": {},
   "source": [
    "Combien de publications avons-nous à chaque année?\n",
    "\n",
    "On voit que 2020 (l'année de la COVID) a été celle où les médias ont le plus mobilisé Facebook pour rejoindre les Québécoises et les Québécois. Les années 2022 et 2021 suivent de près, ce qui indique que les médias se servent encore énormément de ce réseau social."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "c88ae1b1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2020    637136\n",
       "2022    558991\n",
       "2021    554179\n",
       "2019    541659\n",
       "2018    452209\n",
       "2016    390404\n",
       "2017    384451\n",
       "2015    315191\n",
       "2023    221953\n",
       "2014    175102\n",
       "2013    137008\n",
       "2012    112553\n",
       "2011     68723\n",
       "Name: année, dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich.année.value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "086084cf",
   "metadata": {},
   "source": [
    "Même vérification pour les mois.\n",
    "\n",
    "On voit que les trois premiers mois de la pandémie sont sur le podium."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "06fb8efa",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2020-03    61810\n",
       "2020-04    61680\n",
       "2020-05    58960\n",
       "2020-10    56170\n",
       "2020-11    53689\n",
       "           ...  \n",
       "2011-03     5240\n",
       "2011-05     5169\n",
       "2011-04     4825\n",
       "2011-02     4249\n",
       "2011-01     3507\n",
       "Name: mois, Length: 149, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich.mois.value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3209e2cf",
   "metadata": {},
   "source": [
    "On exporte cette répartition du nombre de *posts* par mois dans un petit fichier CSV."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "131709a9",
   "metadata": {},
   "outputs": [],
   "source": [
    "fich.mois.value_counts().to_csv(\"parMois.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3b1237c4",
   "metadata": {},
   "source": [
    "On examine le type des variables de notre tableau.\n",
    "\n",
    "La variable `Total Interactions` est un `object`, ce qui signifie qu'elle n'est pas un nombre et qu'on ne pourra pas l'utiliser pour faire des sommes des interactions par mois ou par média."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "2a6edc16",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Page Name                                                                                                              object\n",
       "User Name                                                                                                              object\n",
       "Facebook Id                                                                                                             int64\n",
       "Page Category                                                                                                          object\n",
       "Page Admin Top Country                                                                                                 object\n",
       "Page Description                                                                                                       object\n",
       "Page Created                                                                                                           object\n",
       "Likes at Posting                                                                                                      float64\n",
       "Followers at Posting                                                                                                  float64\n",
       "Post Created                                                                                                           object\n",
       "Post Created Date                                                                                                      object\n",
       "Post Created Time                                                                                                      object\n",
       "Type                                                                                                                   object\n",
       "Total Interactions                                                                                                     object\n",
       "Likes                                                                                                                   int64\n",
       "Comments                                                                                                                int64\n",
       "Shares                                                                                                                  int64\n",
       "Love                                                                                                                    int64\n",
       "Wow                                                                                                                     int64\n",
       "Haha                                                                                                                    int64\n",
       "Sad                                                                                                                     int64\n",
       "Angry                                                                                                                   int64\n",
       "Care                                                                                                                    int64\n",
       "Video Share Status                                                                                                     object\n",
       "Is Video Owner?                                                                                                        object\n",
       "Post Views                                                                                                              int64\n",
       "Total Views                                                                                                             int64\n",
       "Total Views For All Crossposts                                                                                          int64\n",
       "Video Length                                                                                                           object\n",
       "URL                                                                                                                    object\n",
       "Message                                                                                                                object\n",
       "Link                                                                                                                   object\n",
       "Final Link                                                                                                             object\n",
       "Image Text                                                                                                             object\n",
       "Link Text                                                                                                              object\n",
       "Description                                                                                                            object\n",
       "Sponsor Id                                                                                                             object\n",
       "Sponsor Name                                                                                                           object\n",
       "Sponsor Category                                                                                                       object\n",
       "Overperforming Score (weighted  —  Likes 1x Shares 1x Comments 1x Love 1x Wow 1x Haha 1x Sad 1x Angry 1x Care 1x )     object\n",
       "année                                                                                                                  object\n",
       "mois                                                                                                                   object\n",
       "dtype: object"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "58e7982c",
   "metadata": {},
   "source": [
    "On va donc créer une nouvelle colonne appelée `inter` qui sera le résultat de la somme des neuf types d'interactions enregistrées par Facebook (commentaires, partages, *likes* et autres réactions)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "ac765b0b",
   "metadata": {},
   "outputs": [],
   "source": [
    "fich[\"inter\"] = fich.Likes + fich.Comments + fich.Shares + fich.Love + fich.Wow + fich.Haha + fich.Sad + fich.Angry + fich.Care"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "39f918db",
   "metadata": {},
   "source": [
    "Tout semble bien se passer 👇"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "5bff6b03",
   "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>Page Name</th>\n",
       "      <th>User Name</th>\n",
       "      <th>Facebook Id</th>\n",
       "      <th>Page Category</th>\n",
       "      <th>Page Admin Top Country</th>\n",
       "      <th>Page Description</th>\n",
       "      <th>Page Created</th>\n",
       "      <th>Likes at Posting</th>\n",
       "      <th>Followers at Posting</th>\n",
       "      <th>Post Created</th>\n",
       "      <th>...</th>\n",
       "      <th>Image Text</th>\n",
       "      <th>Link Text</th>\n",
       "      <th>Description</th>\n",
       "      <th>Sponsor Id</th>\n",
       "      <th>Sponsor Name</th>\n",
       "      <th>Sponsor Category</th>\n",
       "      <th>Overperforming Score (weighted  —  Likes 1x Shares 1x Comments 1x Love 1x Wow 1x Haha 1x Sad 1x Angry 1x Care 1x )</th>\n",
       "      <th>année</th>\n",
       "      <th>mois</th>\n",
       "      <th>inter</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ICI Estrie</td>\n",
       "      <td>iciestrie</td>\n",
       "      <td>211536155525838</td>\n",
       "      <td>BROADCASTING_MEDIA_PRODUCTION</td>\n",
       "      <td>CA</td>\n",
       "      <td>Radio-Canada Estrie, ce sont vos nouvelles à l...</td>\n",
       "      <td>2011-03-29 17:57:10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-31 23:50:00 EST</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2,52</td>\n",
       "      <td>2013</td>\n",
       "      <td>2013-12</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TVA Sports</td>\n",
       "      <td>TVASports</td>\n",
       "      <td>100064823193433</td>\n",
       "      <td>TV_NETWORK</td>\n",
       "      <td>CA</td>\n",
       "      <td>La page Facebook officielle de la chaîne TVA S...</td>\n",
       "      <td>2011-05-31 09:20:32</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-31 22:50:51 EST</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Les Islanders en embuscade</td>\n",
       "      <td>Kyle Okposo et Frans Nielsen, deux fois, ont é...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5,79</td>\n",
       "      <td>2013</td>\n",
       "      <td>2013-12</td>\n",
       "      <td>109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CIBM FM 107</td>\n",
       "      <td>CIBM107</td>\n",
       "      <td>100063576520336</td>\n",
       "      <td>BROADCASTING_MEDIA_PRODUCTION</td>\n",
       "      <td>CA</td>\n",
       "      <td>FM 107 - La Radio des Hits</td>\n",
       "      <td>2009-08-25 12:02:04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-31 22:27:20 EST</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5,7</td>\n",
       "      <td>2013</td>\n",
       "      <td>2013-12</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CIEL FM 103,7</td>\n",
       "      <td>CIEL103</td>\n",
       "      <td>208658131206</td>\n",
       "      <td>BROADCASTING_MEDIA_PRODUCTION</td>\n",
       "      <td>CA</td>\n",
       "      <td>CIEL FM 103,7 Rivière-du-Loup: La fréquence bl...</td>\n",
       "      <td>2009-12-15 15:23:22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-31 22:20:40 EST</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-10,6</td>\n",
       "      <td>2013</td>\n",
       "      <td>2013-12</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>TVA Sports</td>\n",
       "      <td>TVASports</td>\n",
       "      <td>100064823193433</td>\n",
       "      <td>TV_NETWORK</td>\n",
       "      <td>CA</td>\n",
       "      <td>La page Facebook officielle de la chaîne TVA S...</td>\n",
       "      <td>2011-05-31 09:20:32</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-31 22:11:10 EST</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Effondrement avant le nouvel an</td>\n",
       "      <td>Le Canadien de Montréal tentait de finir en be...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5,54</td>\n",
       "      <td>2013</td>\n",
       "      <td>2013-12</td>\n",
       "      <td>114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4549554</th>\n",
       "      <td>RDS</td>\n",
       "      <td>RDS</td>\n",
       "      <td>100064854125890</td>\n",
       "      <td>TV_NETWORK</td>\n",
       "      <td>CA</td>\n",
       "      <td>La page Facebook de RDS. Le sport sans limites...</td>\n",
       "      <td>2009-08-10 17:38:31</td>\n",
       "      <td>385381.0</td>\n",
       "      <td>372338.0</td>\n",
       "      <td>2019-11-01 00:18:02 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2,16</td>\n",
       "      <td>2019</td>\n",
       "      <td>2019-11</td>\n",
       "      <td>551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4549555</th>\n",
       "      <td>La Presse</td>\n",
       "      <td>LaPresseFB</td>\n",
       "      <td>100064750746253</td>\n",
       "      <td>NEWS_SITE</td>\n",
       "      <td>CA</td>\n",
       "      <td>Média d’information qui regroupe la plus grand...</td>\n",
       "      <td>2009-04-02 03:00:46</td>\n",
       "      <td>612742.0</td>\n",
       "      <td>611819.0</td>\n",
       "      <td>2019-11-01 00:14:34 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>É.-U: le département de l'Intérieur cloue au s...</td>\n",
       "      <td>(Washington) Le département américain de l’Int...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-5,43</td>\n",
       "      <td>2019</td>\n",
       "      <td>2019-11</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4549556</th>\n",
       "      <td>La Presse</td>\n",
       "      <td>LaPresseFB</td>\n",
       "      <td>100064750746253</td>\n",
       "      <td>NEWS_SITE</td>\n",
       "      <td>CA</td>\n",
       "      <td>Média d’information qui regroupe la plus grand...</td>\n",
       "      <td>2009-04-02 03:00:46</td>\n",
       "      <td>612742.0</td>\n",
       "      <td>611819.0</td>\n",
       "      <td>2019-11-01 00:08:03 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>La rougeole 10 fois plus mortelle que prévu, s...</td>\n",
       "      <td>La rougeole est 10 fois plus mortelle que prév...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6,11</td>\n",
       "      <td>2019</td>\n",
       "      <td>2019-11</td>\n",
       "      <td>1160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4549557</th>\n",
       "      <td>Info Dimanche</td>\n",
       "      <td>infodimanche</td>\n",
       "      <td>100063759871440</td>\n",
       "      <td>ACTIVITY_GENERAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>Bienvenue sur notre page Facebook! Vous voulez...</td>\n",
       "      <td>2009-11-13 21:31:15</td>\n",
       "      <td>21093.0</td>\n",
       "      <td>21435.0</td>\n",
       "      <td>2019-11-01 00:02:13 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-47</td>\n",
       "      <td>2019</td>\n",
       "      <td>2019-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4549558</th>\n",
       "      <td>Le Journal de Québec</td>\n",
       "      <td>JdeQuebec</td>\n",
       "      <td>100064629642245</td>\n",
       "      <td>MEDIA_NEWS_COMPANY</td>\n",
       "      <td>CA</td>\n",
       "      <td>Des nouvelles accessibles et complètes: sports...</td>\n",
       "      <td>2010-10-05 19:04:37</td>\n",
       "      <td>410294.0</td>\n",
       "      <td>402948.0</td>\n",
       "      <td>2019-11-01 00:00:03 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Son père tué à l'Halloween il y a 40 ans</td>\n",
       "      <td>Le soir de l’Halloween 1979, il y a 40 ans, so...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1,07</td>\n",
       "      <td>2019</td>\n",
       "      <td>2019-11</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4549559 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Page Name     User Name      Facebook Id  \\\n",
       "0                  ICI Estrie     iciestrie  211536155525838   \n",
       "1                  TVA Sports     TVASports  100064823193433   \n",
       "2                 CIBM FM 107       CIBM107  100063576520336   \n",
       "3               CIEL FM 103,7       CIEL103     208658131206   \n",
       "4                  TVA Sports     TVASports  100064823193433   \n",
       "...                       ...           ...              ...   \n",
       "4549554                   RDS           RDS  100064854125890   \n",
       "4549555             La Presse    LaPresseFB  100064750746253   \n",
       "4549556             La Presse    LaPresseFB  100064750746253   \n",
       "4549557         Info Dimanche  infodimanche  100063759871440   \n",
       "4549558  Le Journal de Québec     JdeQuebec  100064629642245   \n",
       "\n",
       "                         Page Category Page Admin Top Country  \\\n",
       "0        BROADCASTING_MEDIA_PRODUCTION                     CA   \n",
       "1                           TV_NETWORK                     CA   \n",
       "2        BROADCASTING_MEDIA_PRODUCTION                     CA   \n",
       "3        BROADCASTING_MEDIA_PRODUCTION                     CA   \n",
       "4                           TV_NETWORK                     CA   \n",
       "...                                ...                    ...   \n",
       "4549554                     TV_NETWORK                     CA   \n",
       "4549555                      NEWS_SITE                     CA   \n",
       "4549556                      NEWS_SITE                     CA   \n",
       "4549557               ACTIVITY_GENERAL                     CA   \n",
       "4549558             MEDIA_NEWS_COMPANY                     CA   \n",
       "\n",
       "                                          Page Description  \\\n",
       "0        Radio-Canada Estrie, ce sont vos nouvelles à l...   \n",
       "1        La page Facebook officielle de la chaîne TVA S...   \n",
       "2                               FM 107 - La Radio des Hits   \n",
       "3        CIEL FM 103,7 Rivière-du-Loup: La fréquence bl...   \n",
       "4        La page Facebook officielle de la chaîne TVA S...   \n",
       "...                                                    ...   \n",
       "4549554  La page Facebook de RDS. Le sport sans limites...   \n",
       "4549555  Média d’information qui regroupe la plus grand...   \n",
       "4549556  Média d’information qui regroupe la plus grand...   \n",
       "4549557  Bienvenue sur notre page Facebook! Vous voulez...   \n",
       "4549558  Des nouvelles accessibles et complètes: sports...   \n",
       "\n",
       "                Page Created  Likes at Posting  Followers at Posting  \\\n",
       "0        2011-03-29 17:57:10               NaN                   NaN   \n",
       "1        2011-05-31 09:20:32               NaN                   NaN   \n",
       "2        2009-08-25 12:02:04               NaN                   NaN   \n",
       "3        2009-12-15 15:23:22               NaN                   NaN   \n",
       "4        2011-05-31 09:20:32               NaN                   NaN   \n",
       "...                      ...               ...                   ...   \n",
       "4549554  2009-08-10 17:38:31          385381.0              372338.0   \n",
       "4549555  2009-04-02 03:00:46          612742.0              611819.0   \n",
       "4549556  2009-04-02 03:00:46          612742.0              611819.0   \n",
       "4549557  2009-11-13 21:31:15           21093.0               21435.0   \n",
       "4549558  2010-10-05 19:04:37          410294.0              402948.0   \n",
       "\n",
       "                    Post Created  ... Image Text  \\\n",
       "0        2013-12-31 23:50:00 EST  ...        NaN   \n",
       "1        2013-12-31 22:50:51 EST  ...        NaN   \n",
       "2        2013-12-31 22:27:20 EST  ...        NaN   \n",
       "3        2013-12-31 22:20:40 EST  ...        NaN   \n",
       "4        2013-12-31 22:11:10 EST  ...        NaN   \n",
       "...                          ...  ...        ...   \n",
       "4549554  2019-11-01 00:18:02 EDT  ...        NaN   \n",
       "4549555  2019-11-01 00:14:34 EDT  ...        NaN   \n",
       "4549556  2019-11-01 00:08:03 EDT  ...        NaN   \n",
       "4549557  2019-11-01 00:02:13 EDT  ...        NaN   \n",
       "4549558  2019-11-01 00:00:03 EDT  ...        NaN   \n",
       "\n",
       "                                                 Link Text  \\\n",
       "0                                                      NaN   \n",
       "1                               Les Islanders en embuscade   \n",
       "2                                                      NaN   \n",
       "3                                                      NaN   \n",
       "4                          Effondrement avant le nouvel an   \n",
       "...                                                    ...   \n",
       "4549554                                                NaN   \n",
       "4549555  É.-U: le département de l'Intérieur cloue au s...   \n",
       "4549556  La rougeole 10 fois plus mortelle que prévu, s...   \n",
       "4549557                                                NaN   \n",
       "4549558           Son père tué à l'Halloween il y a 40 ans   \n",
       "\n",
       "                                               Description Sponsor Id  \\\n",
       "0                                                      NaN        NaN   \n",
       "1        Kyle Okposo et Frans Nielsen, deux fois, ont é...        NaN   \n",
       "2                                                      NaN        NaN   \n",
       "3                                                      NaN        NaN   \n",
       "4        Le Canadien de Montréal tentait de finir en be...        NaN   \n",
       "...                                                    ...        ...   \n",
       "4549554                                                NaN        NaN   \n",
       "4549555  (Washington) Le département américain de l’Int...        NaN   \n",
       "4549556  La rougeole est 10 fois plus mortelle que prév...        NaN   \n",
       "4549557                                                NaN        NaN   \n",
       "4549558  Le soir de l’Halloween 1979, il y a 40 ans, so...        NaN   \n",
       "\n",
       "         Sponsor Name  Sponsor Category  \\\n",
       "0                 NaN               NaN   \n",
       "1                 NaN               NaN   \n",
       "2                 NaN               NaN   \n",
       "3                 NaN               NaN   \n",
       "4                 NaN               NaN   \n",
       "...               ...               ...   \n",
       "4549554           NaN               NaN   \n",
       "4549555           NaN               NaN   \n",
       "4549556           NaN               NaN   \n",
       "4549557           NaN               NaN   \n",
       "4549558           NaN               NaN   \n",
       "\n",
       "         Overperforming Score (weighted  —  Likes 1x Shares 1x Comments 1x Love 1x Wow 1x Haha 1x Sad 1x Angry 1x Care 1x )  \\\n",
       "0                                                    -2,52                                                                    \n",
       "1                                                    -5,79                                                                    \n",
       "2                                                     -5,7                                                                    \n",
       "3                                                    -10,6                                                                    \n",
       "4                                                    -5,54                                                                    \n",
       "...                                                    ...                                                                    \n",
       "4549554                                              -2,16                                                                    \n",
       "4549555                                              -5,43                                                                    \n",
       "4549556                                               6,11                                                                    \n",
       "4549557                                                -47                                                                    \n",
       "4549558                                              -1,07                                                                    \n",
       "\n",
       "         année     mois  inter  \n",
       "0         2013  2013-12     42  \n",
       "1         2013  2013-12    109  \n",
       "2         2013  2013-12     23  \n",
       "3         2013  2013-12      5  \n",
       "4         2013  2013-12    114  \n",
       "...        ...      ...    ...  \n",
       "4549554   2019  2019-11    551  \n",
       "4549555   2019  2019-11     35  \n",
       "4549556   2019  2019-11   1160  \n",
       "4549557   2019  2019-11      1  \n",
       "4549558   2019  2019-11    145  \n",
       "\n",
       "[4549559 rows x 43 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "223bd7cd",
   "metadata": {},
   "source": [
    "On peut désormais faire une somme des interactions suscitées par les contenus journalistiques québécois dans Facebook à chaque mois entre janvier 2011 et mai 2023."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "4d592e1d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "mois\n",
       "2011-01      34633\n",
       "2011-02      37220\n",
       "2011-03      49501\n",
       "2011-04      62349\n",
       "2011-05      66331\n",
       "            ...   \n",
       "2023-01    5316994\n",
       "2023-02    5533456\n",
       "2023-03    5380836\n",
       "2023-04    4957939\n",
       "2023-05    4243663\n",
       "Name: inter, Length: 149, dtype: int64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich.groupby(by=\"mois\").inter.sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ad193ec5",
   "metadata": {},
   "source": [
    "Résultat qu'on exporte dans un autre fichier (`interactionsParMois.csv`) qu'on combinera ultérieurement (dans LibreOffice) avec le fichier créé ci-dessus, `parMois.csv`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "6e889782",
   "metadata": {},
   "outputs": [],
   "source": [
    "fich.groupby(by=\"mois\").inter.sum().to_csv(\"interactionsParMois.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1101b010",
   "metadata": {},
   "source": [
    "Ici, je crée une liste des identifiants de chaque page médiatique (il y en a 309 au total) et je l'exporte dans le fichier `fbID.csv`. Cette liste servira à exclure les médias d'une autre analyse effectuée sur un corpus contrôle des publications Facebook ayant recueilli le plus d'interactions par mois."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "8d1e8809",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "100064629642245    201046\n",
       "100064702091893    187722\n",
       "100064469930497    150997\n",
       "100057677935882    133035\n",
       "100064750746253    109624\n",
       "                    ...  \n",
       "109513637357837       131\n",
       "100038387810839       130\n",
       "100042407152770       118\n",
       "100032450577149        98\n",
       "100071202192678        97\n",
       "Name: Facebook Id, Length: 309, dtype: int64"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich[\"Facebook Id\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "60688f9b",
   "metadata": {},
   "outputs": [],
   "source": [
    "fich[\"Facebook Id\"].value_counts().to_csv(\"fbID.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4da695e9",
   "metadata": {},
   "source": [
    "Afin de réaliser une analyse plus fine, je calcule, avec le code ci-dessous et grâce à la méthode `.nunique()`, le nombre de médias qui, chaque mois, ont publié du matériel dans Facebook. Si j'ai 309 pages médiatiques dans mon échantillon, ce ne sont pas tous ces médias qui publient chaque mois.\n",
    "\n",
    "On constate, par exemple, qu'en avril 2023, 295 pages ont publié du contenu, mais qu'en mai 2023, il n'y en avait plus que 278. Est-ce le début d'une désaffection de Facebook par les médias du Québec? Il faudra attendre l'année prochaine pour le savoir.\n",
    "\n",
    "J'exporte ensuite le résultat dans le fichier `NbMediasParMois.csv`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "6bdcd8d2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "mois\n",
       "2011-01     97\n",
       "2011-02    103\n",
       "2011-03    109\n",
       "2011-04    110\n",
       "2011-05    112\n",
       "          ... \n",
       "2023-01    292\n",
       "2023-02    291\n",
       "2023-03    294\n",
       "2023-04    295\n",
       "2023-05    278\n",
       "Name: Page Name, Length: 149, dtype: int64"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich.groupby(by=\"mois\")[\"Page Name\"].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "13edc36f",
   "metadata": {},
   "outputs": [],
   "source": [
    "fich.groupby(by=\"mois\")[\"Page Name\"].nunique().to_csv(\"NbMediasParMois.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "abfa5184",
   "metadata": {},
   "source": [
    "Enfin, je crée un sous-ensemble constitué par les *posts* publiés au cours des années 2022 (toute l'année) et 2023 (janvier à mai) pour une [analyse ultérieure](FB_Analyse 2022-23.ipynb).\n",
    "\n",
    "J'exporte le résultat dans un fichier appelé `FB_22_23.csv`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "b9077ff2",
   "metadata": {},
   "outputs": [],
   "source": [
    "recents = (fich.année == \"2022\") | (fich.année == \"2023\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "2379357d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2022    558991\n",
       "2023    221953\n",
       "Name: année, dtype: int64"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich[recents].année.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "5886e344",
   "metadata": {},
   "outputs": [],
   "source": [
    "fich[recents].to_csv(\"FB_22_23.csv\")"
   ]
  }
 ],
 "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.10.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}