IG_85_médias_parMois.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "585ae7ca",
   "metadata": {},
   "source": [
    "# Analyse des publications Instagram de 85 médias du Québec (2011-2023)\n",
    "Les étapes de ce carnet sont essentiellement les mêmes que celles présentées dans le [carnet équivalent consacré à Facebook](FB_300médias_parMois.ipynb)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "c51693fe",
   "metadata": {},
   "outputs": [],
   "source": [
    "import glob, os\n",
    "import pandas as pan"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c813e168",
   "metadata": {},
   "source": [
    "On a 15 fichiers de départ que CrowdTangle me fournit à partir d'une liste appelée `MediasQC`.\n",
    "\n",
    "Les mois couverts sont indiqués à la fin des noms de fichiers (`2017-01-01--2018-01-01` pour les 12 mois de l'année 2017, par exemple)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "6a866ab8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['2023-03-28-03-22-29-UTC-Historical-Report-MediasQC-2017-01-01--2018-01-01.csv', '2023-03-28-03-15-44-UTC-Historical-Report-MediasQC-2023-01-01--2023-03-01.csv', '2023-03-28-03-24-42-UTC-Historical-Report-MediasQC-2013-01-01--2014-01-01.csv', '2023-06-03-17-38-02-UTC-Historical-Report-MediasQC-2023-04-01--2023-06-01.csv', '2023-03-28-03-22-34-UTC-Historical-Report-MediasQC-2019-01-01--2020-01-01.csv', '2023-03-28-03-24-41-UTC-Historical-Report-MediasQC-2011-01-01--2012-01-01.csv', '2023-03-28-03-22-30-UTC-Historical-Report-MediasQC-2018-01-01--2019-01-01.csv', '2023-03-28-03-23-16-UTC-Historical-Report-MediasQC-2021-01-01--2022-01-01.csv', '2023-03-28-03-24-36-UTC-Historical-Report-MediasQC-2012-01-01--2013-01-01.csv', '2023-03-28-03-24-24-UTC-Historical-Report-MediasQC-2016-01-01--2017-01-01.csv', '2023-04-24-14-49-24-UTC-Historical-Report-MediasQC-2023-03-01--2023-04-01.csv', '2023-03-28-03-23-03-UTC-Historical-Report-MediasQC-2020-01-01--2021-01-01.csv', '2023-03-28-03-24-23-UTC-Historical-Report-MediasQC-2014-01-01--2015-01-01.csv', '2023-03-28-03-24-30-UTC-Historical-Report-MediasQC-2015-01-01--2016-01-01.csv', '2023-03-28-03-22-00-UTC-Historical-Report-MediasQC-2022-01-01--2023-01-01.csv']\n"
     ]
    }
   ],
   "source": [
    "tousfich = glob.glob(os.path.join(\"\", \"2023*.csv\"))\n",
    "print(tousfich)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "8ee051e8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "15"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(tousfich)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "7fde0cc0",
   "metadata": {},
   "outputs": [],
   "source": [
    "chq_fich = (pan.read_csv(f, low_memory=False) for f in tousfich)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "31d7d775",
   "metadata": {},
   "outputs": [],
   "source": [
    "fich = pan.concat(chq_fich, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "50f701de",
   "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>Account</th>\n",
       "      <th>User Name</th>\n",
       "      <th>Followers at Posting</th>\n",
       "      <th>Post Created</th>\n",
       "      <th>Post Created Date</th>\n",
       "      <th>Post Created Time</th>\n",
       "      <th>Type</th>\n",
       "      <th>Total Interactions</th>\n",
       "      <th>Likes</th>\n",
       "      <th>Comments</th>\n",
       "      <th>...</th>\n",
       "      <th>Link</th>\n",
       "      <th>Photo</th>\n",
       "      <th>Title</th>\n",
       "      <th>Description</th>\n",
       "      <th>Image Text</th>\n",
       "      <th>Sponsor Id</th>\n",
       "      <th>Sponsor Name</th>\n",
       "      <th>Overperforming Score (weighted  —  Likes 1x Comments 1x )</th>\n",
       "      <th>Total Interactions (weighted  —  Likes 1x Comments 1x )</th>\n",
       "      <th>Overperforming Score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ICI Grand Montréal</td>\n",
       "      <td>icigrandmontreal</td>\n",
       "      <td>1776.0</td>\n",
       "      <td>2017-12-31 23:28:03 UTC</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>23:28:03</td>\n",
       "      <td>Photo</td>\n",
       "      <td>80</td>\n",
       "      <td>79</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.instagram.com/p/BdYpJ2cnbMz/</td>\n",
       "      <td>https://scontent-sea1-1.cdninstagram.com/v/t51...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Le métro sera exceptionnellement en service to...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1,8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CBC Montreal</td>\n",
       "      <td>cbcmontreal</td>\n",
       "      <td>8456.0</td>\n",
       "      <td>2017-12-31 23:23:24 UTC</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>23:23:24</td>\n",
       "      <td>Photo</td>\n",
       "      <td>299</td>\n",
       "      <td>298</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.instagram.com/p/BdYonvEjzob/</td>\n",
       "      <td>https://scontent-sea1-1.cdninstagram.com/v/t51...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Happy New Year Montreal 🥂Tag your photos with ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2,27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Le Devoir</td>\n",
       "      <td>ledevoir</td>\n",
       "      <td>19794.0</td>\n",
       "      <td>2017-12-31 22:43:39 UTC</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>22:43:39</td>\n",
       "      <td>Photo</td>\n",
       "      <td>95</td>\n",
       "      <td>92</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.instagram.com/p/BdYkEniFupM/</td>\n",
       "      <td>https://scontent-sea1-1.cdninstagram.com/v/t51...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Froid polaire pour les célébrations du Nouvel ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-4,34</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Radio-Canada Information</td>\n",
       "      <td>radiocanadainfo</td>\n",
       "      <td>44536.0</td>\n",
       "      <td>2017-12-31 22:42:02 UTC</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>22:42:02</td>\n",
       "      <td>Video</td>\n",
       "      <td>65</td>\n",
       "      <td>61</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.instagram.com/p/BdYjdJ1FGFZ/</td>\n",
       "      <td>https://scontent-sea1-1.cdninstagram.com/v/t51...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>L’Iran a décidé de bloquer l’accès à Instagram...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2,34</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>URBANIA</td>\n",
       "      <td>_urbania</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-31 22:06:15 UTC</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>22:06:15</td>\n",
       "      <td>Album</td>\n",
       "      <td>261</td>\n",
       "      <td>259</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.instagram.com/p/BdYfytTlkeb/</td>\n",
       "      <td>https://scontent-sea1-1.cdninstagram.com/v/t51...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bonne et heureuse année 2018, gang! Amusez-vou...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1,6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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>140537</th>\n",
       "      <td>Le Devoir</td>\n",
       "      <td>ledevoir</td>\n",
       "      <td>114619.0</td>\n",
       "      <td>2022-01-01 02:00:48 UTC</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>02:00:48</td>\n",
       "      <td>Album</td>\n",
       "      <td>558</td>\n",
       "      <td>551</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.instagram.com/p/CYK4A92Ngp6/</td>\n",
       "      <td>https://scontent-sea1-1.cdninstagram.com/v/t51...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alors que défilent les dernières heures de 202...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140538</th>\n",
       "      <td>CityNews Montreal</td>\n",
       "      <td>citynewsmtl</td>\n",
       "      <td>15945.0</td>\n",
       "      <td>2022-01-01 01:15:38 UTC</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>01:15:38</td>\n",
       "      <td>Video</td>\n",
       "      <td>21</td>\n",
       "      <td>19</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.instagram.com/tv/CYKyg6BBbW_/</td>\n",
       "      <td>https://scontent-sjc3-1.cdninstagram.com/v/t51...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>From embarrassing Zoom slip-ups to dancing sen...</td>\n",
       "      <td>T.M City News FEEL-GOOD MOMENTS OF 2021 FRI 6:...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140539</th>\n",
       "      <td>104,7 Outaouais</td>\n",
       "      <td>1047outaouais</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-01-01 01:08:49 UTC</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>01:08:49</td>\n",
       "      <td>Photo</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.instagram.com/p/CYKyEM6FwKQ/</td>\n",
       "      <td>https://scontent-sea1-1.cdninstagram.com/v/t51...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1,81</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140540</th>\n",
       "      <td>Radio-Canada Sports</td>\n",
       "      <td>rcsports</td>\n",
       "      <td>16140.0</td>\n",
       "      <td>2022-01-01 00:30:12 UTC</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>00:30:12</td>\n",
       "      <td>Video</td>\n",
       "      <td>103</td>\n",
       "      <td>103</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.instagram.com/p/CYKtn5ztMIl/</td>\n",
       "      <td>https://scontent-sea1-1.cdninstagram.com/v/t51...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>On se sauve de 2021 et on saute pleinement ver...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140541</th>\n",
       "      <td>Radio-Canada Information</td>\n",
       "      <td>radiocanadainfo</td>\n",
       "      <td>190680.0</td>\n",
       "      <td>2022-01-01 00:13:10 UTC</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>00:13:10</td>\n",
       "      <td>Video</td>\n",
       "      <td>93</td>\n",
       "      <td>88</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.instagram.com/tv/CYKrqovsNCg/</td>\n",
       "      <td>https://scontent-sea1-1.cdninstagram.com/v/t51...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nombre de personnalités, intellectuels, sporti...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1,63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>140542 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Account         User Name  Followers at Posting  \\\n",
       "0             ICI Grand Montréal  icigrandmontreal                1776.0   \n",
       "1                   CBC Montreal       cbcmontreal                8456.0   \n",
       "2                      Le Devoir          ledevoir               19794.0   \n",
       "3       Radio-Canada Information   radiocanadainfo               44536.0   \n",
       "4                        URBANIA          _urbania                   NaN   \n",
       "...                          ...               ...                   ...   \n",
       "140537                 Le Devoir          ledevoir              114619.0   \n",
       "140538         CityNews Montreal       citynewsmtl               15945.0   \n",
       "140539           104,7 Outaouais     1047outaouais                   NaN   \n",
       "140540       Radio-Canada Sports          rcsports               16140.0   \n",
       "140541  Radio-Canada Information   radiocanadainfo              190680.0   \n",
       "\n",
       "                   Post Created Post Created Date Post Created Time   Type  \\\n",
       "0       2017-12-31 23:28:03 UTC        2017-12-31          23:28:03  Photo   \n",
       "1       2017-12-31 23:23:24 UTC        2017-12-31          23:23:24  Photo   \n",
       "2       2017-12-31 22:43:39 UTC        2017-12-31          22:43:39  Photo   \n",
       "3       2017-12-31 22:42:02 UTC        2017-12-31          22:42:02  Video   \n",
       "4       2017-12-31 22:06:15 UTC        2017-12-31          22:06:15  Album   \n",
       "...                         ...               ...               ...    ...   \n",
       "140537  2022-01-01 02:00:48 UTC        2022-01-01          02:00:48  Album   \n",
       "140538  2022-01-01 01:15:38 UTC        2022-01-01          01:15:38  Video   \n",
       "140539  2022-01-01 01:08:49 UTC        2022-01-01          01:08:49  Photo   \n",
       "140540  2022-01-01 00:30:12 UTC        2022-01-01          00:30:12  Video   \n",
       "140541  2022-01-01 00:13:10 UTC        2022-01-01          00:13:10  Video   \n",
       "\n",
       "       Total Interactions  Likes  Comments  ...  \\\n",
       "0                      80     79         1  ...   \n",
       "1                     299    298         1  ...   \n",
       "2                      95     92         3  ...   \n",
       "3                      65     61         4  ...   \n",
       "4                     261    259         2  ...   \n",
       "...                   ...    ...       ...  ...   \n",
       "140537                558    551         7  ...   \n",
       "140538                 21     19         2  ...   \n",
       "140539                 21     21         0  ...   \n",
       "140540                103    103         0  ...   \n",
       "140541                 93     88         5  ...   \n",
       "\n",
       "                                             Link  \\\n",
       "0        https://www.instagram.com/p/BdYpJ2cnbMz/   \n",
       "1        https://www.instagram.com/p/BdYonvEjzob/   \n",
       "2        https://www.instagram.com/p/BdYkEniFupM/   \n",
       "3        https://www.instagram.com/p/BdYjdJ1FGFZ/   \n",
       "4        https://www.instagram.com/p/BdYfytTlkeb/   \n",
       "...                                           ...   \n",
       "140537   https://www.instagram.com/p/CYK4A92Ngp6/   \n",
       "140538  https://www.instagram.com/tv/CYKyg6BBbW_/   \n",
       "140539   https://www.instagram.com/p/CYKyEM6FwKQ/   \n",
       "140540   https://www.instagram.com/p/CYKtn5ztMIl/   \n",
       "140541  https://www.instagram.com/tv/CYKrqovsNCg/   \n",
       "\n",
       "                                                    Photo Title  \\\n",
       "0       https://scontent-sea1-1.cdninstagram.com/v/t51...   NaN   \n",
       "1       https://scontent-sea1-1.cdninstagram.com/v/t51...   NaN   \n",
       "2       https://scontent-sea1-1.cdninstagram.com/v/t51...   NaN   \n",
       "3       https://scontent-sea1-1.cdninstagram.com/v/t51...   NaN   \n",
       "4       https://scontent-sea1-1.cdninstagram.com/v/t51...   NaN   \n",
       "...                                                   ...   ...   \n",
       "140537  https://scontent-sea1-1.cdninstagram.com/v/t51...   NaN   \n",
       "140538  https://scontent-sjc3-1.cdninstagram.com/v/t51...   NaN   \n",
       "140539  https://scontent-sea1-1.cdninstagram.com/v/t51...   NaN   \n",
       "140540  https://scontent-sea1-1.cdninstagram.com/v/t51...   NaN   \n",
       "140541  https://scontent-sea1-1.cdninstagram.com/v/t51...   NaN   \n",
       "\n",
       "                                              Description  \\\n",
       "0       Le métro sera exceptionnellement en service to...   \n",
       "1       Happy New Year Montreal 🥂Tag your photos with ...   \n",
       "2       Froid polaire pour les célébrations du Nouvel ...   \n",
       "3       L’Iran a décidé de bloquer l’accès à Instagram...   \n",
       "4       Bonne et heureuse année 2018, gang! Amusez-vou...   \n",
       "...                                                   ...   \n",
       "140537  Alors que défilent les dernières heures de 202...   \n",
       "140538  From embarrassing Zoom slip-ups to dancing sen...   \n",
       "140539                                                NaN   \n",
       "140540  On se sauve de 2021 et on saute pleinement ver...   \n",
       "140541  Nombre de personnalités, intellectuels, sporti...   \n",
       "\n",
       "                                               Image Text  Sponsor Id  \\\n",
       "0                                                     NaN         NaN   \n",
       "1                                                     NaN         NaN   \n",
       "2                                                     NaN         NaN   \n",
       "3                                                     NaN         NaN   \n",
       "4                                                     NaN         NaN   \n",
       "...                                                   ...         ...   \n",
       "140537                                                NaN         NaN   \n",
       "140538  T.M City News FEEL-GOOD MOMENTS OF 2021 FRI 6:...         NaN   \n",
       "140539                                                NaN         NaN   \n",
       "140540                                                NaN         NaN   \n",
       "140541                                                NaN         NaN   \n",
       "\n",
       "       Sponsor Name Overperforming Score (weighted  —  Likes 1x Comments 1x )  \\\n",
       "0               NaN                                               -1,8          \n",
       "1               NaN                                               2,27          \n",
       "2               NaN                                              -4,34          \n",
       "3               NaN                                              -2,34          \n",
       "4               NaN                                               -1,6          \n",
       "...             ...                                                ...          \n",
       "140537          NaN                                               1,31          \n",
       "140538          NaN                                               1,05          \n",
       "140539          NaN                                              -1,81          \n",
       "140540          NaN                                               1,18          \n",
       "140541          NaN                                              -1,63          \n",
       "\n",
       "        Total Interactions (weighted  —  Likes 1x Comments 1x )  \\\n",
       "0                                                     NaN         \n",
       "1                                                     NaN         \n",
       "2                                                     NaN         \n",
       "3                                                     NaN         \n",
       "4                                                     NaN         \n",
       "...                                                   ...         \n",
       "140537                                                NaN         \n",
       "140538                                                NaN         \n",
       "140539                                                NaN         \n",
       "140540                                                NaN         \n",
       "140541                                                NaN         \n",
       "\n",
       "       Overperforming Score  \n",
       "0                       NaN  \n",
       "1                       NaN  \n",
       "2                       NaN  \n",
       "3                       NaN  \n",
       "4                       NaN  \n",
       "...                     ...  \n",
       "140537                  NaN  \n",
       "140538                  NaN  \n",
       "140539                  NaN  \n",
       "140540                  NaN  \n",
       "140541                  NaN  \n",
       "\n",
       "[140542 rows x 23 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "dc45e322",
   "metadata": {},
   "outputs": [],
   "source": [
    "fich[\"année\"] = fich[\"Post Created\"].str[:4]\n",
    "fich[\"mois\"] = fich[\"Post Created\"].str[:7]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "1b227116",
   "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>Account</th>\n",
       "      <th>User Name</th>\n",
       "      <th>Followers at Posting</th>\n",
       "      <th>Post Created</th>\n",
       "      <th>Post Created Date</th>\n",
       "      <th>Post Created Time</th>\n",
       "      <th>Type</th>\n",
       "      <th>Total Interactions</th>\n",
       "      <th>Likes</th>\n",
       "      <th>Comments</th>\n",
       "      <th>...</th>\n",
       "      <th>Title</th>\n",
       "      <th>Description</th>\n",
       "      <th>Image Text</th>\n",
       "      <th>Sponsor Id</th>\n",
       "      <th>Sponsor Name</th>\n",
       "      <th>Overperforming Score (weighted  —  Likes 1x Comments 1x )</th>\n",
       "      <th>Total Interactions (weighted  —  Likes 1x Comments 1x )</th>\n",
       "      <th>Overperforming Score</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 Grand Montréal</td>\n",
       "      <td>icigrandmontreal</td>\n",
       "      <td>1776.0</td>\n",
       "      <td>2017-12-31 23:28:03 UTC</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>23:28:03</td>\n",
       "      <td>Photo</td>\n",
       "      <td>80</td>\n",
       "      <td>79</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Le métro sera exceptionnellement en service to...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1,8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017</td>\n",
       "      <td>2017-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CBC Montreal</td>\n",
       "      <td>cbcmontreal</td>\n",
       "      <td>8456.0</td>\n",
       "      <td>2017-12-31 23:23:24 UTC</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>23:23:24</td>\n",
       "      <td>Photo</td>\n",
       "      <td>299</td>\n",
       "      <td>298</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Happy New Year Montreal 🥂Tag your photos with ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2,27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017</td>\n",
       "      <td>2017-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Le Devoir</td>\n",
       "      <td>ledevoir</td>\n",
       "      <td>19794.0</td>\n",
       "      <td>2017-12-31 22:43:39 UTC</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>22:43:39</td>\n",
       "      <td>Photo</td>\n",
       "      <td>95</td>\n",
       "      <td>92</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Froid polaire pour les célébrations du Nouvel ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-4,34</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017</td>\n",
       "      <td>2017-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Radio-Canada Information</td>\n",
       "      <td>radiocanadainfo</td>\n",
       "      <td>44536.0</td>\n",
       "      <td>2017-12-31 22:42:02 UTC</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>22:42:02</td>\n",
       "      <td>Video</td>\n",
       "      <td>65</td>\n",
       "      <td>61</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>L’Iran a décidé de bloquer l’accès à Instagram...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2,34</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017</td>\n",
       "      <td>2017-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>URBANIA</td>\n",
       "      <td>_urbania</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-31 22:06:15 UTC</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>22:06:15</td>\n",
       "      <td>Album</td>\n",
       "      <td>261</td>\n",
       "      <td>259</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bonne et heureuse année 2018, gang! Amusez-vou...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1,6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017</td>\n",
       "      <td>2017-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>140537</th>\n",
       "      <td>Le Devoir</td>\n",
       "      <td>ledevoir</td>\n",
       "      <td>114619.0</td>\n",
       "      <td>2022-01-01 02:00:48 UTC</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>02:00:48</td>\n",
       "      <td>Album</td>\n",
       "      <td>558</td>\n",
       "      <td>551</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alors que défilent les dernières heures de 202...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140538</th>\n",
       "      <td>CityNews Montreal</td>\n",
       "      <td>citynewsmtl</td>\n",
       "      <td>15945.0</td>\n",
       "      <td>2022-01-01 01:15:38 UTC</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>01:15:38</td>\n",
       "      <td>Video</td>\n",
       "      <td>21</td>\n",
       "      <td>19</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>From embarrassing Zoom slip-ups to dancing sen...</td>\n",
       "      <td>T.M City News FEEL-GOOD MOMENTS OF 2021 FRI 6:...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140539</th>\n",
       "      <td>104,7 Outaouais</td>\n",
       "      <td>1047outaouais</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-01-01 01:08:49 UTC</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>01:08:49</td>\n",
       "      <td>Photo</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>0</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>-1,81</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140540</th>\n",
       "      <td>Radio-Canada Sports</td>\n",
       "      <td>rcsports</td>\n",
       "      <td>16140.0</td>\n",
       "      <td>2022-01-01 00:30:12 UTC</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>00:30:12</td>\n",
       "      <td>Video</td>\n",
       "      <td>103</td>\n",
       "      <td>103</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>On se sauve de 2021 et on saute pleinement ver...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140541</th>\n",
       "      <td>Radio-Canada Information</td>\n",
       "      <td>radiocanadainfo</td>\n",
       "      <td>190680.0</td>\n",
       "      <td>2022-01-01 00:13:10 UTC</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>00:13:10</td>\n",
       "      <td>Video</td>\n",
       "      <td>93</td>\n",
       "      <td>88</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nombre de personnalités, intellectuels, sporti...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1,63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022-01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>140542 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Account         User Name  Followers at Posting  \\\n",
       "0             ICI Grand Montréal  icigrandmontreal                1776.0   \n",
       "1                   CBC Montreal       cbcmontreal                8456.0   \n",
       "2                      Le Devoir          ledevoir               19794.0   \n",
       "3       Radio-Canada Information   radiocanadainfo               44536.0   \n",
       "4                        URBANIA          _urbania                   NaN   \n",
       "...                          ...               ...                   ...   \n",
       "140537                 Le Devoir          ledevoir              114619.0   \n",
       "140538         CityNews Montreal       citynewsmtl               15945.0   \n",
       "140539           104,7 Outaouais     1047outaouais                   NaN   \n",
       "140540       Radio-Canada Sports          rcsports               16140.0   \n",
       "140541  Radio-Canada Information   radiocanadainfo              190680.0   \n",
       "\n",
       "                   Post Created Post Created Date Post Created Time   Type  \\\n",
       "0       2017-12-31 23:28:03 UTC        2017-12-31          23:28:03  Photo   \n",
       "1       2017-12-31 23:23:24 UTC        2017-12-31          23:23:24  Photo   \n",
       "2       2017-12-31 22:43:39 UTC        2017-12-31          22:43:39  Photo   \n",
       "3       2017-12-31 22:42:02 UTC        2017-12-31          22:42:02  Video   \n",
       "4       2017-12-31 22:06:15 UTC        2017-12-31          22:06:15  Album   \n",
       "...                         ...               ...               ...    ...   \n",
       "140537  2022-01-01 02:00:48 UTC        2022-01-01          02:00:48  Album   \n",
       "140538  2022-01-01 01:15:38 UTC        2022-01-01          01:15:38  Video   \n",
       "140539  2022-01-01 01:08:49 UTC        2022-01-01          01:08:49  Photo   \n",
       "140540  2022-01-01 00:30:12 UTC        2022-01-01          00:30:12  Video   \n",
       "140541  2022-01-01 00:13:10 UTC        2022-01-01          00:13:10  Video   \n",
       "\n",
       "       Total Interactions  Likes  Comments  ...  Title  \\\n",
       "0                      80     79         1  ...    NaN   \n",
       "1                     299    298         1  ...    NaN   \n",
       "2                      95     92         3  ...    NaN   \n",
       "3                      65     61         4  ...    NaN   \n",
       "4                     261    259         2  ...    NaN   \n",
       "...                   ...    ...       ...  ...    ...   \n",
       "140537                558    551         7  ...    NaN   \n",
       "140538                 21     19         2  ...    NaN   \n",
       "140539                 21     21         0  ...    NaN   \n",
       "140540                103    103         0  ...    NaN   \n",
       "140541                 93     88         5  ...    NaN   \n",
       "\n",
       "                                              Description  \\\n",
       "0       Le métro sera exceptionnellement en service to...   \n",
       "1       Happy New Year Montreal 🥂Tag your photos with ...   \n",
       "2       Froid polaire pour les célébrations du Nouvel ...   \n",
       "3       L’Iran a décidé de bloquer l’accès à Instagram...   \n",
       "4       Bonne et heureuse année 2018, gang! Amusez-vou...   \n",
       "...                                                   ...   \n",
       "140537  Alors que défilent les dernières heures de 202...   \n",
       "140538  From embarrassing Zoom slip-ups to dancing sen...   \n",
       "140539                                                NaN   \n",
       "140540  On se sauve de 2021 et on saute pleinement ver...   \n",
       "140541  Nombre de personnalités, intellectuels, sporti...   \n",
       "\n",
       "                                               Image Text Sponsor Id  \\\n",
       "0                                                     NaN        NaN   \n",
       "1                                                     NaN        NaN   \n",
       "2                                                     NaN        NaN   \n",
       "3                                                     NaN        NaN   \n",
       "4                                                     NaN        NaN   \n",
       "...                                                   ...        ...   \n",
       "140537                                                NaN        NaN   \n",
       "140538  T.M City News FEEL-GOOD MOMENTS OF 2021 FRI 6:...        NaN   \n",
       "140539                                                NaN        NaN   \n",
       "140540                                                NaN        NaN   \n",
       "140541                                                NaN        NaN   \n",
       "\n",
       "       Sponsor Name  \\\n",
       "0               NaN   \n",
       "1               NaN   \n",
       "2               NaN   \n",
       "3               NaN   \n",
       "4               NaN   \n",
       "...             ...   \n",
       "140537          NaN   \n",
       "140538          NaN   \n",
       "140539          NaN   \n",
       "140540          NaN   \n",
       "140541          NaN   \n",
       "\n",
       "        Overperforming Score (weighted  —  Likes 1x Comments 1x )  \\\n",
       "0                                                    -1,8           \n",
       "1                                                    2,27           \n",
       "2                                                   -4,34           \n",
       "3                                                   -2,34           \n",
       "4                                                    -1,6           \n",
       "...                                                   ...           \n",
       "140537                                               1,31           \n",
       "140538                                               1,05           \n",
       "140539                                              -1,81           \n",
       "140540                                               1,18           \n",
       "140541                                              -1,63           \n",
       "\n",
       "       Total Interactions (weighted  —  Likes 1x Comments 1x )  \\\n",
       "0                                                     NaN        \n",
       "1                                                     NaN        \n",
       "2                                                     NaN        \n",
       "3                                                     NaN        \n",
       "4                                                     NaN        \n",
       "...                                                   ...        \n",
       "140537                                                NaN        \n",
       "140538                                                NaN        \n",
       "140539                                                NaN        \n",
       "140540                                                NaN        \n",
       "140541                                                NaN        \n",
       "\n",
       "       Overperforming Score  année     mois  \n",
       "0                       NaN   2017  2017-12  \n",
       "1                       NaN   2017  2017-12  \n",
       "2                       NaN   2017  2017-12  \n",
       "3                       NaN   2017  2017-12  \n",
       "4                       NaN   2017  2017-12  \n",
       "...                     ...    ...      ...  \n",
       "140537                  NaN   2022  2022-01  \n",
       "140538                  NaN   2022  2022-01  \n",
       "140539                  NaN   2022  2022-01  \n",
       "140540                  NaN   2022  2022-01  \n",
       "140541                  NaN   2022  2022-01  \n",
       "\n",
       "[140542 rows x 25 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "6905c5ef",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2022    29322\n",
       "2021    23603\n",
       "2020    20181\n",
       "2019    14128\n",
       "2023    12734\n",
       "2018    10452\n",
       "2017     9887\n",
       "2016     8663\n",
       "2015     5302\n",
       "2014     3219\n",
       "2013     2053\n",
       "2012      789\n",
       "2011      209\n",
       "Name: année, dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich.année.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "ba1fded6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2023-05    2843\n",
       "2023-03    2673\n",
       "2022-03    2664\n",
       "2022-10    2614\n",
       "2022-06    2537\n",
       "           ... \n",
       "2011-01      14\n",
       "2011-12      11\n",
       "2011-05       9\n",
       "2011-02       4\n",
       "2011-03       3\n",
       "Name: mois, Length: 148, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich.mois.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "d3314fa3",
   "metadata": {},
   "outputs": [],
   "source": [
    "fich.mois.value_counts().to_csv(\"parMois.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "000c2d80",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Account                                                       object\n",
       "User Name                                                     object\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",
       "Views                                                          int64\n",
       "Like and View Counts Disabled                                   bool\n",
       "URL                                                           object\n",
       "Link                                                          object\n",
       "Photo                                                         object\n",
       "Title                                                        float64\n",
       "Description                                                   object\n",
       "Image Text                                                    object\n",
       "Sponsor Id                                                   float64\n",
       "Sponsor Name                                                  object\n",
       "Overperforming Score (weighted  —  Likes 1x Comments 1x )     object\n",
       "Total Interactions (weighted  —  Likes 1x Comments 1x )       object\n",
       "Overperforming Score                                          object\n",
       "année                                                         object\n",
       "mois                                                          object\n",
       "dtype: object"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "5570afa0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        118606\n",
       "2            44\n",
       "1            37\n",
       "287          26\n",
       "213          24\n",
       "          ...  \n",
       "1178          1\n",
       "2692          1\n",
       "36381         1\n",
       "21368         1\n",
       "2317          1\n",
       "Name: Views, Length: 7759, dtype: int64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich.Views.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "963445e9",
   "metadata": {},
   "outputs": [],
   "source": [
    "fich[\"inter\"] = fich.Likes + fich.Comments"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "d7730e9f",
   "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>Account</th>\n",
       "      <th>User Name</th>\n",
       "      <th>Followers at Posting</th>\n",
       "      <th>Post Created</th>\n",
       "      <th>Post Created Date</th>\n",
       "      <th>Post Created Time</th>\n",
       "      <th>Type</th>\n",
       "      <th>Total Interactions</th>\n",
       "      <th>Likes</th>\n",
       "      <th>Comments</th>\n",
       "      <th>...</th>\n",
       "      <th>Description</th>\n",
       "      <th>Image Text</th>\n",
       "      <th>Sponsor Id</th>\n",
       "      <th>Sponsor Name</th>\n",
       "      <th>Overperforming Score (weighted  —  Likes 1x Comments 1x )</th>\n",
       "      <th>Total Interactions (weighted  —  Likes 1x Comments 1x )</th>\n",
       "      <th>Overperforming Score</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 Grand Montréal</td>\n",
       "      <td>icigrandmontreal</td>\n",
       "      <td>1776.0</td>\n",
       "      <td>2017-12-31 23:28:03 UTC</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>23:28:03</td>\n",
       "      <td>Photo</td>\n",
       "      <td>80</td>\n",
       "      <td>79</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>Le métro sera exceptionnellement en service to...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1,8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017</td>\n",
       "      <td>2017-12</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CBC Montreal</td>\n",
       "      <td>cbcmontreal</td>\n",
       "      <td>8456.0</td>\n",
       "      <td>2017-12-31 23:23:24 UTC</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>23:23:24</td>\n",
       "      <td>Photo</td>\n",
       "      <td>299</td>\n",
       "      <td>298</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>Happy New Year Montreal 🥂Tag your photos with ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2,27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017</td>\n",
       "      <td>2017-12</td>\n",
       "      <td>299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Le Devoir</td>\n",
       "      <td>ledevoir</td>\n",
       "      <td>19794.0</td>\n",
       "      <td>2017-12-31 22:43:39 UTC</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>22:43:39</td>\n",
       "      <td>Photo</td>\n",
       "      <td>95</td>\n",
       "      <td>92</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>Froid polaire pour les célébrations du Nouvel ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-4,34</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017</td>\n",
       "      <td>2017-12</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Radio-Canada Information</td>\n",
       "      <td>radiocanadainfo</td>\n",
       "      <td>44536.0</td>\n",
       "      <td>2017-12-31 22:42:02 UTC</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>22:42:02</td>\n",
       "      <td>Video</td>\n",
       "      <td>65</td>\n",
       "      <td>61</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>L’Iran a décidé de bloquer l’accès à Instagram...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2,34</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017</td>\n",
       "      <td>2017-12</td>\n",
       "      <td>65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>URBANIA</td>\n",
       "      <td>_urbania</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-31 22:06:15 UTC</td>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>22:06:15</td>\n",
       "      <td>Album</td>\n",
       "      <td>261</td>\n",
       "      <td>259</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>Bonne et heureuse année 2018, gang! Amusez-vou...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1,6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017</td>\n",
       "      <td>2017-12</td>\n",
       "      <td>261</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>140537</th>\n",
       "      <td>Le Devoir</td>\n",
       "      <td>ledevoir</td>\n",
       "      <td>114619.0</td>\n",
       "      <td>2022-01-01 02:00:48 UTC</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>02:00:48</td>\n",
       "      <td>Album</td>\n",
       "      <td>558</td>\n",
       "      <td>551</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>Alors que défilent les dernières heures de 202...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022-01</td>\n",
       "      <td>558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140538</th>\n",
       "      <td>CityNews Montreal</td>\n",
       "      <td>citynewsmtl</td>\n",
       "      <td>15945.0</td>\n",
       "      <td>2022-01-01 01:15:38 UTC</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>01:15:38</td>\n",
       "      <td>Video</td>\n",
       "      <td>21</td>\n",
       "      <td>19</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>From embarrassing Zoom slip-ups to dancing sen...</td>\n",
       "      <td>T.M City News FEEL-GOOD MOMENTS OF 2021 FRI 6:...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022-01</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140539</th>\n",
       "      <td>104,7 Outaouais</td>\n",
       "      <td>1047outaouais</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-01-01 01:08:49 UTC</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>01:08:49</td>\n",
       "      <td>Photo</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1,81</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022-01</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140540</th>\n",
       "      <td>Radio-Canada Sports</td>\n",
       "      <td>rcsports</td>\n",
       "      <td>16140.0</td>\n",
       "      <td>2022-01-01 00:30:12 UTC</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>00:30:12</td>\n",
       "      <td>Video</td>\n",
       "      <td>103</td>\n",
       "      <td>103</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>On se sauve de 2021 et on saute pleinement ver...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1,18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022-01</td>\n",
       "      <td>103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140541</th>\n",
       "      <td>Radio-Canada Information</td>\n",
       "      <td>radiocanadainfo</td>\n",
       "      <td>190680.0</td>\n",
       "      <td>2022-01-01 00:13:10 UTC</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>00:13:10</td>\n",
       "      <td>Video</td>\n",
       "      <td>93</td>\n",
       "      <td>88</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>Nombre de personnalités, intellectuels, sporti...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1,63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022</td>\n",
       "      <td>2022-01</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>140542 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Account         User Name  Followers at Posting  \\\n",
       "0             ICI Grand Montréal  icigrandmontreal                1776.0   \n",
       "1                   CBC Montreal       cbcmontreal                8456.0   \n",
       "2                      Le Devoir          ledevoir               19794.0   \n",
       "3       Radio-Canada Information   radiocanadainfo               44536.0   \n",
       "4                        URBANIA          _urbania                   NaN   \n",
       "...                          ...               ...                   ...   \n",
       "140537                 Le Devoir          ledevoir              114619.0   \n",
       "140538         CityNews Montreal       citynewsmtl               15945.0   \n",
       "140539           104,7 Outaouais     1047outaouais                   NaN   \n",
       "140540       Radio-Canada Sports          rcsports               16140.0   \n",
       "140541  Radio-Canada Information   radiocanadainfo              190680.0   \n",
       "\n",
       "                   Post Created Post Created Date Post Created Time   Type  \\\n",
       "0       2017-12-31 23:28:03 UTC        2017-12-31          23:28:03  Photo   \n",
       "1       2017-12-31 23:23:24 UTC        2017-12-31          23:23:24  Photo   \n",
       "2       2017-12-31 22:43:39 UTC        2017-12-31          22:43:39  Photo   \n",
       "3       2017-12-31 22:42:02 UTC        2017-12-31          22:42:02  Video   \n",
       "4       2017-12-31 22:06:15 UTC        2017-12-31          22:06:15  Album   \n",
       "...                         ...               ...               ...    ...   \n",
       "140537  2022-01-01 02:00:48 UTC        2022-01-01          02:00:48  Album   \n",
       "140538  2022-01-01 01:15:38 UTC        2022-01-01          01:15:38  Video   \n",
       "140539  2022-01-01 01:08:49 UTC        2022-01-01          01:08:49  Photo   \n",
       "140540  2022-01-01 00:30:12 UTC        2022-01-01          00:30:12  Video   \n",
       "140541  2022-01-01 00:13:10 UTC        2022-01-01          00:13:10  Video   \n",
       "\n",
       "       Total Interactions  Likes  Comments  ...  \\\n",
       "0                      80     79         1  ...   \n",
       "1                     299    298         1  ...   \n",
       "2                      95     92         3  ...   \n",
       "3                      65     61         4  ...   \n",
       "4                     261    259         2  ...   \n",
       "...                   ...    ...       ...  ...   \n",
       "140537                558    551         7  ...   \n",
       "140538                 21     19         2  ...   \n",
       "140539                 21     21         0  ...   \n",
       "140540                103    103         0  ...   \n",
       "140541                 93     88         5  ...   \n",
       "\n",
       "                                              Description  \\\n",
       "0       Le métro sera exceptionnellement en service to...   \n",
       "1       Happy New Year Montreal 🥂Tag your photos with ...   \n",
       "2       Froid polaire pour les célébrations du Nouvel ...   \n",
       "3       L’Iran a décidé de bloquer l’accès à Instagram...   \n",
       "4       Bonne et heureuse année 2018, gang! Amusez-vou...   \n",
       "...                                                   ...   \n",
       "140537  Alors que défilent les dernières heures de 202...   \n",
       "140538  From embarrassing Zoom slip-ups to dancing sen...   \n",
       "140539                                                NaN   \n",
       "140540  On se sauve de 2021 et on saute pleinement ver...   \n",
       "140541  Nombre de personnalités, intellectuels, sporti...   \n",
       "\n",
       "                                               Image Text Sponsor Id  \\\n",
       "0                                                     NaN        NaN   \n",
       "1                                                     NaN        NaN   \n",
       "2                                                     NaN        NaN   \n",
       "3                                                     NaN        NaN   \n",
       "4                                                     NaN        NaN   \n",
       "...                                                   ...        ...   \n",
       "140537                                                NaN        NaN   \n",
       "140538  T.M City News FEEL-GOOD MOMENTS OF 2021 FRI 6:...        NaN   \n",
       "140539                                                NaN        NaN   \n",
       "140540                                                NaN        NaN   \n",
       "140541                                                NaN        NaN   \n",
       "\n",
       "       Sponsor Name Overperforming Score (weighted  —  Likes 1x Comments 1x )  \\\n",
       "0               NaN                                               -1,8          \n",
       "1               NaN                                               2,27          \n",
       "2               NaN                                              -4,34          \n",
       "3               NaN                                              -2,34          \n",
       "4               NaN                                               -1,6          \n",
       "...             ...                                                ...          \n",
       "140537          NaN                                               1,31          \n",
       "140538          NaN                                               1,05          \n",
       "140539          NaN                                              -1,81          \n",
       "140540          NaN                                               1,18          \n",
       "140541          NaN                                              -1,63          \n",
       "\n",
       "        Total Interactions (weighted  —  Likes 1x Comments 1x )  \\\n",
       "0                                                     NaN         \n",
       "1                                                     NaN         \n",
       "2                                                     NaN         \n",
       "3                                                     NaN         \n",
       "4                                                     NaN         \n",
       "...                                                   ...         \n",
       "140537                                                NaN         \n",
       "140538                                                NaN         \n",
       "140539                                                NaN         \n",
       "140540                                                NaN         \n",
       "140541                                                NaN         \n",
       "\n",
       "       Overperforming Score année     mois inter  \n",
       "0                       NaN  2017  2017-12    80  \n",
       "1                       NaN  2017  2017-12   299  \n",
       "2                       NaN  2017  2017-12    95  \n",
       "3                       NaN  2017  2017-12    65  \n",
       "4                       NaN  2017  2017-12   261  \n",
       "...                     ...   ...      ...   ...  \n",
       "140537                  NaN  2022  2022-01   558  \n",
       "140538                  NaN  2022  2022-01    21  \n",
       "140539                  NaN  2022  2022-01    21  \n",
       "140540                  NaN  2022  2022-01   103  \n",
       "140541                  NaN  2022  2022-01    93  \n",
       "\n",
       "[140542 rows x 26 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "17839458",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "mois\n",
       "2011-01         40\n",
       "2011-02          5\n",
       "2011-03          6\n",
       "2011-05         33\n",
       "2011-06        235\n",
       "            ...   \n",
       "2023-01    1184584\n",
       "2023-02    1126736\n",
       "2023-03    1241685\n",
       "2023-04    1274712\n",
       "2023-05    1665025\n",
       "Name: inter, Length: 148, dtype: int64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich.groupby(by=\"mois\").inter.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "5cceaf89",
   "metadata": {},
   "outputs": [],
   "source": [
    "fich.groupby(by=\"mois\").inter.sum().to_csv(\"interactionsParMois.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "97fcbba1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "narcityquebec              25330\n",
       "ledevoir                    9668\n",
       "radiocanadainfo             9108\n",
       "rds                         7846\n",
       "citynewsmtl                 7440\n",
       "                           ...  \n",
       "journallecanadafrancais       53\n",
       "tva.quebec                    27\n",
       "tvaqc                         21\n",
       "journal_lemanic               14\n",
       "iciestduquebec                 8\n",
       "Name: User Name, Length: 85, dtype: int64"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich[\"User Name\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "735f9543",
   "metadata": {},
   "outputs": [],
   "source": [
    "fich[\"User Name\"].value_counts().to_csv(\"pseudos.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "e99c3ca3",
   "metadata": {},
   "outputs": [],
   "source": [
    "recents = (fich.année == \"2022\") | (fich.année == \"2023\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "940d1b77",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2022    29322\n",
       "2023    12734\n",
       "Name: année, dtype: int64"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich[recents].année.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "09a45409",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2023-05    2843\n",
       "2023-03    2673\n",
       "2022-03    2664\n",
       "2022-10    2614\n",
       "2022-06    2537\n",
       "2023-04    2529\n",
       "2022-11    2529\n",
       "2022-05    2499\n",
       "2022-09    2495\n",
       "2022-07    2453\n",
       "2022-04    2437\n",
       "2023-01    2391\n",
       "2022-02    2345\n",
       "2022-08    2321\n",
       "2023-02    2298\n",
       "2022-12    2294\n",
       "2022-01    2134\n",
       "Name: mois, dtype: int64"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich[recents].mois.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "7da1bfc3",
   "metadata": {},
   "outputs": [],
   "source": [
    "fich[recents].to_csv(\"IG_22_23.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4417512d",
   "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.10.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}