FB_CanFranco_parMois_pourGithub.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "0274961c",
   "metadata": {},
   "outputs": [],
   "source": [
    "import glob, os, numpy\n",
    "import pandas as pan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "689fe02a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['FB_Canada_Franco_2022-08.csv', 'FB_Canada_Franco_2022-09.csv', 'FB_Canada_Franco_2021-12.csv', 'FB_Canada_Franco_2021-06.csv', 'FB_Canada_Franco_2023-03.csv', 'FB_Canada_Franco_2023-02.csv', 'FB_Canada_Franco_2021-07.csv', 'FB_Canada_Franco_2021-05.csv', 'FB_Canada_Franco_2021-11.csv', 'FB_Canada_Franco_2023-01.csv', 'FB_Canada_Franco_2021-10.csv', 'FB_Canada_Franco_2021-04.csv', 'FB_Canada_Franco_2023-05.csv', 'FB_Canada_Franco_2023-04.csv', 'FB_Canada_Franco_2021-01.csv', 'FB_Canada_Franco_2021-03.csv', 'FB_Canada_Franco_2021-02.csv', 'FB_Canada_Franco_2021-09.csv', 'FB_Canada_Franco_2021-08.csv', 'FB_Canada_Franco_2022-01.csv', 'FB_Canada_Franco_2022-02.csv', 'FB_Canada_Franco_2022-03.csv', 'FB_Canada_Franco_2022-07.csv', 'FB_Canada_Franco_2022-06.csv', 'FB_Canada_Franco_2022-12.csv', 'FB_Canada_Franco_2022-04.csv', 'FB_Canada_Franco_2022-10.csv', 'FB_Canada_Franco_2022-11.csv', 'FB_Canada_Franco_2022-05.csv']\n"
     ]
    }
   ],
   "source": [
    "tousfich = glob.glob(os.path.join(\"\", \"FB*.csv\"))\n",
    "print(tousfich)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "c5f84e8d",
   "metadata": {},
   "outputs": [],
   "source": [
    "chq_fich = (pan.read_csv(f, low_memory=False) for f in tousfich)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "27b59033",
   "metadata": {},
   "outputs": [],
   "source": [
    "fich = pan.concat(chq_fich, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "1abf11da",
   "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>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>Total Interactions (weighted  —  Likes 1x Shares 1x Comments 1x Love 1x Wow 1x Haha 1x Sad 1x Angry 1x Care 1x )</th>\n",
       "      <th>Overperforming Score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Boni Richard Ouorou</td>\n",
       "      <td>Ouorourichard</td>\n",
       "      <td>100044592902599</td>\n",
       "      <td>POLITICIAN</td>\n",
       "      <td>CA</td>\n",
       "      <td>A chaque Génération sa lutte et sa responsabil...</td>\n",
       "      <td>2014-06-25 21:30:48</td>\n",
       "      <td>25530.0</td>\n",
       "      <td>29063.0</td>\n",
       "      <td>2022-08-30 18:49:34 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.facebook.com/photo.php?fbid=642880...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LA CAPACITÉ DE PARLER PLUSIEURS LANGUES EST UN...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>263 678</td>\n",
       "      <td>768,74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Steve Wulfrand</td>\n",
       "      <td>Stevewulfrand0</td>\n",
       "      <td>100083296573498</td>\n",
       "      <td>ACTOR</td>\n",
       "      <td>CA</td>\n",
       "      <td>Créateur vidéo</td>\n",
       "      <td>2022-05-06 23:15:30</td>\n",
       "      <td>10744.0</td>\n",
       "      <td>266251.0</td>\n",
       "      <td>2022-08-29 05:00:03 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.facebook.com/Stevewulfrand0/videos...</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>250 276</td>\n",
       "      <td>69,66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Piranha Club</td>\n",
       "      <td>Piranha.Club</td>\n",
       "      <td>100081333356954</td>\n",
       "      <td>ENTERTAINMENT_SITE</td>\n",
       "      <td>CA</td>\n",
       "      <td>Piranha Club est une grande famille de passion...</td>\n",
       "      <td>2019-12-11 03:05:32</td>\n",
       "      <td>237143.0</td>\n",
       "      <td>272429.0</td>\n",
       "      <td>2022-08-05 00:00:02 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.facebook.com/Piranha.Club/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>247 171</td>\n",
       "      <td>31,98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bara pro</td>\n",
       "      <td>barakoudalogie</td>\n",
       "      <td>100063863163987</td>\n",
       "      <td>COMEDIAN</td>\n",
       "      <td>CA</td>\n",
       "      <td>Bienvenue sur ma page 😊où vous trouverez des v...</td>\n",
       "      <td>2020-02-09 12:22:00</td>\n",
       "      <td>88216.0</td>\n",
       "      <td>782076.0</td>\n",
       "      <td>2022-08-23 10:00:01 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.facebook.com/barakoudalogie/videos...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tu veux tu veux pas tu vas rire 😂😂.  Bara pro 🐒</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>186 715</td>\n",
       "      <td>6,15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Moe L'enjailleur</td>\n",
       "      <td>moelenjailleurcomedie</td>\n",
       "      <td>100077936434268</td>\n",
       "      <td>PERSON</td>\n",
       "      <td>CA</td>\n",
       "      <td>Vous voulez rire ? C'est chez Moe L'enjailleur...</td>\n",
       "      <td>2021-10-19 18:33:24</td>\n",
       "      <td>100945.0</td>\n",
       "      <td>574592.0</td>\n",
       "      <td>2022-08-23 18:39:19 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.facebook.com/moelenjailleurcomedie...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>❌ Début de l'histoire très tendu entre Tenor e...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>186 477</td>\n",
       "      <td>18,28</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>8168706</th>\n",
       "      <td>Le Rose Pingouin</td>\n",
       "      <td>RosePingouin</td>\n",
       "      <td>327937210552822</td>\n",
       "      <td>ENTERTAINMENT_SITE</td>\n",
       "      <td>CA</td>\n",
       "      <td>Le Rose Pingouin vous informe, vous fait rire,...</td>\n",
       "      <td>2011-12-15 12:25:34</td>\n",
       "      <td>1323981.0</td>\n",
       "      <td>1101855.0</td>\n",
       "      <td>2022-05-14 22:15:03 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>https://buff.ly/3Mny7hy</td>\n",
       "      <td>https://www.rosepingouin.com/Alicia-Moffet-par...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alicia Moffet partage des photos de ses nouvea...</td>\n",
       "      <td>La chanteuse Alicia Moffet s'est faite tatouée...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>-156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8168707</th>\n",
       "      <td>IDRC / CRDI</td>\n",
       "      <td>IDRC.CRDI</td>\n",
       "      <td>100064605017187</td>\n",
       "      <td>GOVERNMENT_ORGANIZATION</td>\n",
       "      <td>CA</td>\n",
       "      <td>International Development Research Centre | Ce...</td>\n",
       "      <td>2010-01-15 17:04:10</td>\n",
       "      <td>29329.0</td>\n",
       "      <td>31110.0</td>\n",
       "      <td>2022-05-30 13:05:03 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.facebook.com/photo.php?fbid=388763...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>YF TT ML EK PS z SR SP MF</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8168708</th>\n",
       "      <td>IDRC / CRDI</td>\n",
       "      <td>IDRC.CRDI</td>\n",
       "      <td>100064605017187</td>\n",
       "      <td>GOVERNMENT_ORGANIZATION</td>\n",
       "      <td>CA</td>\n",
       "      <td>International Development Research Centre | Ce...</td>\n",
       "      <td>2010-01-15 17:04:10</td>\n",
       "      <td>29323.0</td>\n",
       "      <td>31090.0</td>\n",
       "      <td>2022-05-09 14:20:02 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.facebook.com/photo.php?fbid=375009...</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>0</td>\n",
       "      <td>-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8168709</th>\n",
       "      <td>IDRC / CRDI</td>\n",
       "      <td>IDRC.CRDI</td>\n",
       "      <td>100064605017187</td>\n",
       "      <td>GOVERNMENT_ORGANIZATION</td>\n",
       "      <td>CA</td>\n",
       "      <td>International Development Research Centre | Ce...</td>\n",
       "      <td>2010-01-15 17:04:10</td>\n",
       "      <td>29309.0</td>\n",
       "      <td>31079.0</td>\n",
       "      <td>2022-05-05 15:15:01 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.facebook.com/photo.php?fbid=372405...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SYSTÈMES ALIMENTAIRES ET COVID-19: LES LEÇONS ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8168710</th>\n",
       "      <td>IDRC / CRDI</td>\n",
       "      <td>IDRC.CRDI</td>\n",
       "      <td>100064605017187</td>\n",
       "      <td>GOVERNMENT_ORGANIZATION</td>\n",
       "      <td>CA</td>\n",
       "      <td>International Development Research Centre | Ce...</td>\n",
       "      <td>2010-01-15 17:04:10</td>\n",
       "      <td>29305.0</td>\n",
       "      <td>31075.0</td>\n",
       "      <td>2022-05-03 13:39:01 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.facebook.com/photo.php?fbid=370997...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FASTOMPANY W MADE D M A THE LIST! WORLD CHANGI...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>-16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8168711 rows × 41 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Page Name              User Name      Facebook Id  \\\n",
       "0        Boni Richard Ouorou          Ouorourichard  100044592902599   \n",
       "1             Steve Wulfrand         Stevewulfrand0  100083296573498   \n",
       "2               Piranha Club           Piranha.Club  100081333356954   \n",
       "3                   Bara pro         barakoudalogie  100063863163987   \n",
       "4           Moe L'enjailleur  moelenjailleurcomedie  100077936434268   \n",
       "...                      ...                    ...              ...   \n",
       "8168706     Le Rose Pingouin           RosePingouin  327937210552822   \n",
       "8168707          IDRC / CRDI              IDRC.CRDI  100064605017187   \n",
       "8168708          IDRC / CRDI              IDRC.CRDI  100064605017187   \n",
       "8168709          IDRC / CRDI              IDRC.CRDI  100064605017187   \n",
       "8168710          IDRC / CRDI              IDRC.CRDI  100064605017187   \n",
       "\n",
       "                   Page Category Page Admin Top Country  \\\n",
       "0                     POLITICIAN                     CA   \n",
       "1                          ACTOR                     CA   \n",
       "2             ENTERTAINMENT_SITE                     CA   \n",
       "3                       COMEDIAN                     CA   \n",
       "4                         PERSON                     CA   \n",
       "...                          ...                    ...   \n",
       "8168706       ENTERTAINMENT_SITE                     CA   \n",
       "8168707  GOVERNMENT_ORGANIZATION                     CA   \n",
       "8168708  GOVERNMENT_ORGANIZATION                     CA   \n",
       "8168709  GOVERNMENT_ORGANIZATION                     CA   \n",
       "8168710  GOVERNMENT_ORGANIZATION                     CA   \n",
       "\n",
       "                                          Page Description  \\\n",
       "0        A chaque Génération sa lutte et sa responsabil...   \n",
       "1                                          Créateur vidéo    \n",
       "2        Piranha Club est une grande famille de passion...   \n",
       "3        Bienvenue sur ma page 😊où vous trouverez des v...   \n",
       "4        Vous voulez rire ? C'est chez Moe L'enjailleur...   \n",
       "...                                                    ...   \n",
       "8168706  Le Rose Pingouin vous informe, vous fait rire,...   \n",
       "8168707  International Development Research Centre | Ce...   \n",
       "8168708  International Development Research Centre | Ce...   \n",
       "8168709  International Development Research Centre | Ce...   \n",
       "8168710  International Development Research Centre | Ce...   \n",
       "\n",
       "                Page Created  Likes at Posting  Followers at Posting  \\\n",
       "0        2014-06-25 21:30:48           25530.0               29063.0   \n",
       "1        2022-05-06 23:15:30           10744.0              266251.0   \n",
       "2        2019-12-11 03:05:32          237143.0              272429.0   \n",
       "3        2020-02-09 12:22:00           88216.0              782076.0   \n",
       "4        2021-10-19 18:33:24          100945.0              574592.0   \n",
       "...                      ...               ...                   ...   \n",
       "8168706  2011-12-15 12:25:34         1323981.0             1101855.0   \n",
       "8168707  2010-01-15 17:04:10           29329.0               31110.0   \n",
       "8168708  2010-01-15 17:04:10           29323.0               31090.0   \n",
       "8168709  2010-01-15 17:04:10           29309.0               31079.0   \n",
       "8168710  2010-01-15 17:04:10           29305.0               31075.0   \n",
       "\n",
       "                    Post Created  ...  \\\n",
       "0        2022-08-30 18:49:34 EDT  ...   \n",
       "1        2022-08-29 05:00:03 EDT  ...   \n",
       "2        2022-08-05 00:00:02 EDT  ...   \n",
       "3        2022-08-23 10:00:01 EDT  ...   \n",
       "4        2022-08-23 18:39:19 EDT  ...   \n",
       "...                          ...  ...   \n",
       "8168706  2022-05-14 22:15:03 EDT  ...   \n",
       "8168707  2022-05-30 13:05:03 EDT  ...   \n",
       "8168708  2022-05-09 14:20:02 EDT  ...   \n",
       "8168709  2022-05-05 15:15:01 EDT  ...   \n",
       "8168710  2022-05-03 13:39:01 EDT  ...   \n",
       "\n",
       "                                                      Link  \\\n",
       "0        https://www.facebook.com/photo.php?fbid=642880...   \n",
       "1        https://www.facebook.com/Stevewulfrand0/videos...   \n",
       "2        https://www.facebook.com/Piranha.Club/photos/a...   \n",
       "3        https://www.facebook.com/barakoudalogie/videos...   \n",
       "4        https://www.facebook.com/moelenjailleurcomedie...   \n",
       "...                                                    ...   \n",
       "8168706                            https://buff.ly/3Mny7hy   \n",
       "8168707  https://www.facebook.com/photo.php?fbid=388763...   \n",
       "8168708  https://www.facebook.com/photo.php?fbid=375009...   \n",
       "8168709  https://www.facebook.com/photo.php?fbid=372405...   \n",
       "8168710  https://www.facebook.com/photo.php?fbid=370997...   \n",
       "\n",
       "                                                Final Link  \\\n",
       "0                                                      NaN   \n",
       "1                                                      NaN   \n",
       "2                                                      NaN   \n",
       "3                                                      NaN   \n",
       "4                                                      NaN   \n",
       "...                                                    ...   \n",
       "8168706  https://www.rosepingouin.com/Alicia-Moffet-par...   \n",
       "8168707                                                NaN   \n",
       "8168708                                                NaN   \n",
       "8168709                                                NaN   \n",
       "8168710                                                NaN   \n",
       "\n",
       "                                                Image Text  \\\n",
       "0        LA CAPACITÉ DE PARLER PLUSIEURS LANGUES EST UN...   \n",
       "1                                                      NaN   \n",
       "2                                                      NaN   \n",
       "3                                                      NaN   \n",
       "4                                                      NaN   \n",
       "...                                                    ...   \n",
       "8168706                                                NaN   \n",
       "8168707                          YF TT ML EK PS z SR SP MF   \n",
       "8168708                                                NaN   \n",
       "8168709  SYSTÈMES ALIMENTAIRES ET COVID-19: LES LEÇONS ...   \n",
       "8168710  FASTOMPANY W MADE D M A THE LIST! WORLD CHANGI...   \n",
       "\n",
       "                                                 Link Text  \\\n",
       "0                                                      NaN   \n",
       "1                                                      NaN   \n",
       "2                                                      NaN   \n",
       "3          Tu veux tu veux pas tu vas rire 😂😂.  Bara pro 🐒   \n",
       "4        ❌ Début de l'histoire très tendu entre Tenor e...   \n",
       "...                                                    ...   \n",
       "8168706  Alicia Moffet partage des photos de ses nouvea...   \n",
       "8168707                                                NaN   \n",
       "8168708                                                NaN   \n",
       "8168709                                                NaN   \n",
       "8168710                                                NaN   \n",
       "\n",
       "                                               Description  Sponsor Id  \\\n",
       "0                                                      NaN         NaN   \n",
       "1                                                      NaN         NaN   \n",
       "2                                                      NaN         NaN   \n",
       "3                                                      NaN         NaN   \n",
       "4                                                      NaN         NaN   \n",
       "...                                                    ...         ...   \n",
       "8168706  La chanteuse Alicia Moffet s'est faite tatouée...         NaN   \n",
       "8168707                                                NaN         NaN   \n",
       "8168708                                                NaN         NaN   \n",
       "8168709                                                NaN         NaN   \n",
       "8168710                                                NaN         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",
       "8168706           NaN               NaN   \n",
       "8168707           NaN               NaN   \n",
       "8168708           NaN               NaN   \n",
       "8168709           NaN               NaN   \n",
       "8168710           NaN               NaN   \n",
       "\n",
       "         Total Interactions (weighted  —  Likes 1x Shares 1x Comments 1x Love 1x Wow 1x Haha 1x Sad 1x Angry 1x Care 1x )  \\\n",
       "0                                                  263 678                                                                  \n",
       "1                                                  250 276                                                                  \n",
       "2                                                  247 171                                                                  \n",
       "3                                                  186 715                                                                  \n",
       "4                                                  186 477                                                                  \n",
       "...                                                    ...                                                                  \n",
       "8168706                                                  0                                                                  \n",
       "8168707                                                  0                                                                  \n",
       "8168708                                                  0                                                                  \n",
       "8168709                                                  0                                                                  \n",
       "8168710                                                  0                                                                  \n",
       "\n",
       "         Overperforming Score  \n",
       "0                      768,74  \n",
       "1                       69,66  \n",
       "2                       31,98  \n",
       "3                        6,15  \n",
       "4                       18,28  \n",
       "...                       ...  \n",
       "8168706                  -156  \n",
       "8168707                   -14  \n",
       "8168708                   -16  \n",
       "8168709                   -16  \n",
       "8168710                   -16  \n",
       "\n",
       "[8168711 rows x 41 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "ffa5cdef",
   "metadata": {},
   "outputs": [],
   "source": [
    "idMedias = [100064629642245,\n",
    "100064702091893,\n",
    "100064469930497,\n",
    "100057677935882,\n",
    "100064750746253,\n",
    "100055228675506,\n",
    "100063641827245,\n",
    "100063709793429,\n",
    "100064854125890,\n",
    "100064851813351,\n",
    "100063772922658,\n",
    "131191820259167,\n",
    "100063546551184,\n",
    "100063740523358,\n",
    "100064010050671,\n",
    "100064833755433,\n",
    "100064403815260,\n",
    "100063566864207,\n",
    "100064823193433,\n",
    "100063623140529,\n",
    "423596921055456,\n",
    "254768477928383,\n",
    "271036236431606,\n",
    "128015371297,\n",
    "196774760345640,\n",
    "100063980265361,\n",
    "100064359562713,\n",
    "100063781831508,\n",
    "100063546582140,\n",
    "100064349397262,\n",
    "100064898493568,\n",
    "100064435129941,\n",
    "213820898747207,\n",
    "211536155525838,\n",
    "275069289242598,\n",
    "471020985450,\n",
    "100064731343439,\n",
    "100064243942560,\n",
    "152856822182,\n",
    "100063474016000,\n",
    "100050556595710,\n",
    "100053947105104,\n",
    "100063495163209,\n",
    "100046352926785,\n",
    "100064973430656,\n",
    "100063589332484,\n",
    "100064916282950,\n",
    "100063772441457,\n",
    "100063655299339,\n",
    "134483853321456,\n",
    "100063658401546,\n",
    "243777932386097,\n",
    "165824360177331,\n",
    "100034425527608,\n",
    "100038572578353,\n",
    "100063454546318,\n",
    "100063576610966,\n",
    "100063935592270,\n",
    "100063612339182,\n",
    "100064421300312,\n",
    "100063635679709,\n",
    "100063457423528,\n",
    "226135530782200,\n",
    "100063753092649,\n",
    "1244324122290544,\n",
    "100063838761554,\n",
    "100063759871440,\n",
    "100063737882788,\n",
    "100063585819454,\n",
    "100028835366712,\n",
    "100040747883115,\n",
    "100063644407298,\n",
    "100063574718917,\n",
    "100046590501152,\n",
    "100063744245399,\n",
    "100063759482177,\n",
    "100063585190730,\n",
    "509839125694576,\n",
    "100037960883315,\n",
    "100063672125874,\n",
    "100063142123515,\n",
    "100063620350246,\n",
    "100063565902064,\n",
    "100063725572412,\n",
    "2215333488686146,\n",
    "100063641346866,\n",
    "100063679265576,\n",
    "100063672755188,\n",
    "100064662494741,\n",
    "100046496694859,\n",
    "100044346379383,\n",
    "100063574541180,\n",
    "134592973261866,\n",
    "100063952057309,\n",
    "100063527635390,\n",
    "351524758377662,\n",
    "100064088911067,\n",
    "175788645805484,\n",
    "100039534405709,\n",
    "100064725337571,\n",
    "100063721505760,\n",
    "100062495515650,\n",
    "154703251237678,\n",
    "100060284385246,\n",
    "208658131206,\n",
    "114149325352789,\n",
    "100063696246038,\n",
    "100063706583111,\n",
    "138124172901448,\n",
    "100063500232987,\n",
    "127981430568524,\n",
    "100063533621737,\n",
    "100063576520336,\n",
    "100063577390307,\n",
    "100063549313728,\n",
    "167332933286664,\n",
    "100046316481092,\n",
    "1387489814797612,\n",
    "107549134544919,\n",
    "100047356160473,\n",
    "100042993437653,\n",
    "100063736951495,\n",
    "113366336708571,\n",
    "135232993187108,\n",
    "134811643264666,\n",
    "100063679835560,\n",
    "100063529393567,\n",
    "230043493688612,\n",
    "100063725453806,\n",
    "170331766319237,\n",
    "100063672875572,\n",
    "100063505933044,\n",
    "100063713943041,\n",
    "100064316334204,\n",
    "100062131158086,\n",
    "100063896890083,\n",
    "100063597818096,\n",
    "100052679719113,\n",
    "100034354368883,\n",
    "100069829520614,\n",
    "100063740492835,\n",
    "100064785753977,\n",
    "100063626977337,\n",
    "100063798390286,\n",
    "100063490903558,\n",
    "100063777723037,\n",
    "100063670955241,\n",
    "440606566689266,\n",
    "100044278217722,\n",
    "100041611249498,\n",
    "100063512383147,\n",
    "100047124620966,\n",
    "100031252726037,\n",
    "100063597849724,\n",
    "100063692883997,\n",
    "100057349214195,\n",
    "100063454697742,\n",
    "100063732455112,\n",
    "100045589174903,\n",
    "100063797340575,\n",
    "100063479983560,\n",
    "124394004277741,\n",
    "100039257273379,\n",
    "100063694446127,\n",
    "100051626713459,\n",
    "147359678635384,\n",
    "100064514807156,\n",
    "100063604569623,\n",
    "100063538874611,\n",
    "479014518785327,\n",
    "100039388034890,\n",
    "309189509172401,\n",
    "100063693481322,\n",
    "100062870184192,\n",
    "100063579997190,\n",
    "100063626889420,\n",
    "774231592664252,\n",
    "100032758067918,\n",
    "100063550539083,\n",
    "100063573552403,\n",
    "100050500839215,\n",
    "100063769201574,\n",
    "100040041255887,\n",
    "100063494473068,\n",
    "100064060472577,\n",
    "100063696123233,\n",
    "100063686918285,\n",
    "100028989116634,\n",
    "100024731539177,\n",
    "100063615996988,\n",
    "100063722342748,\n",
    "100063593260198,\n",
    "100063584318339,\n",
    "100064081568360,\n",
    "100063786150351,\n",
    "100063279799877,\n",
    "100063746523080,\n",
    "100030412011635,\n",
    "100063798540469,\n",
    "100063647617442,\n",
    "100063763924313,\n",
    "100063568660370,\n",
    "100063492463736,\n",
    "100063997392719,\n",
    "100063736202918,\n",
    "100056465603419,\n",
    "100063631025338,\n",
    "100063654036114,\n",
    "575698229519777,\n",
    "682636768432850,\n",
    "100035437763292,\n",
    "100063631208224,\n",
    "100063755671963,\n",
    "100050684370528,\n",
    "100063578529314,\n",
    "100064455979479,\n",
    "100063522862860,\n",
    "100047370049252,\n",
    "100048591372686,\n",
    "100049182683325,\n",
    "921232881238617,\n",
    "100043956235742,\n",
    "100063764191409,\n",
    "100063594132652,\n",
    "100051460194112,\n",
    "100067745783435,\n",
    "100063660305338,\n",
    "100067328052718,\n",
    "100063755161990,\n",
    "100063591131316,\n",
    "100064563524801,\n",
    "100042169882937,\n",
    "100064084267099,\n",
    "100046369423801,\n",
    "100063556060646,\n",
    "100031908416924,\n",
    "100063633065493,\n",
    "100044373761872,\n",
    "100052099275257,\n",
    "100063754443858,\n",
    "100038006095413,\n",
    "100063775620564,\n",
    "100068391280155,\n",
    "100071363568926,\n",
    "100063815640094,\n",
    "211496422242320,\n",
    "100049901726916,\n",
    "1551898518191408,\n",
    "100045496166019,\n",
    "100063767011404,\n",
    "100060918554710,\n",
    "100064499569748,\n",
    "100063450597345,\n",
    "100063745654565,\n",
    "100063700504915,\n",
    "100068596472306,\n",
    "100063570520374,\n",
    "100063544155408,\n",
    "100032460022756,\n",
    "100063458743110,\n",
    "100054336025043,\n",
    "100063505810970,\n",
    "100063709022561,\n",
    "100064911841442,\n",
    "100052602765113,\n",
    "100063573488449,\n",
    "100063511843498,\n",
    "100063551261544,\n",
    "100063478334106,\n",
    "100063649146357,\n",
    "100045218839045,\n",
    "100063573396019,\n",
    "100064414463045,\n",
    "100063489424900,\n",
    "100067786043676,\n",
    "100041318425885,\n",
    "100064331186546,\n",
    "100064539768477,\n",
    "100063079336391,\n",
    "100046423946097,\n",
    "100070732694157,\n",
    "1568411916822268,\n",
    "468517777286271,\n",
    "100064955703081,\n",
    "100058705311861,\n",
    "107477141151490,\n",
    "100076581331516,\n",
    "100064641671677,\n",
    "100071327771558,\n",
    "100063547841524,\n",
    "100063651653741,\n",
    "100063463361214,\n",
    "100064480158321,\n",
    "100040926144946,\n",
    "100066781795023,\n",
    "100063457236729,\n",
    "100050442861803,\n",
    "100081960135292,\n",
    "100063634145177,\n",
    "112385513782846,\n",
    "100063624337637,\n",
    "100059981777535,\n",
    "100064702715241,\n",
    "100063667715164,\n",
    "109513637357837,\n",
    "100038387810839,\n",
    "100042407152770,\n",
    "100032450577149,\n",
    "100071202192678]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "e7bfc7e7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "309"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(idMedias) #ID Facebook "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "3aa149b1",
   "metadata": {},
   "outputs": [],
   "source": [
    "fich[\"média\"] = fich[\"Facebook Id\"].isin(idMedias)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "dc73c9b2",
   "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>Total Interactions (weighted  —  Likes 1x Shares 1x Comments 1x Love 1x Wow 1x Haha 1x Sad 1x Angry 1x Care 1x )</th>\n",
       "      <th>Overperforming Score</th>\n",
       "      <th>média</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Boni Richard Ouorou</td>\n",
       "      <td>Ouorourichard</td>\n",
       "      <td>100044592902599</td>\n",
       "      <td>POLITICIAN</td>\n",
       "      <td>CA</td>\n",
       "      <td>A chaque Génération sa lutte et sa responsabil...</td>\n",
       "      <td>2014-06-25 21:30:48</td>\n",
       "      <td>25530.0</td>\n",
       "      <td>29063.0</td>\n",
       "      <td>2022-08-30 18:49:34 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LA CAPACITÉ DE PARLER PLUSIEURS LANGUES EST UN...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>263 678</td>\n",
       "      <td>768,74</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Steve Wulfrand</td>\n",
       "      <td>Stevewulfrand0</td>\n",
       "      <td>100083296573498</td>\n",
       "      <td>ACTOR</td>\n",
       "      <td>CA</td>\n",
       "      <td>Créateur vidéo</td>\n",
       "      <td>2022-05-06 23:15:30</td>\n",
       "      <td>10744.0</td>\n",
       "      <td>266251.0</td>\n",
       "      <td>2022-08-29 05:00:03 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>250 276</td>\n",
       "      <td>69,66</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Piranha Club</td>\n",
       "      <td>Piranha.Club</td>\n",
       "      <td>100081333356954</td>\n",
       "      <td>ENTERTAINMENT_SITE</td>\n",
       "      <td>CA</td>\n",
       "      <td>Piranha Club est une grande famille de passion...</td>\n",
       "      <td>2019-12-11 03:05:32</td>\n",
       "      <td>237143.0</td>\n",
       "      <td>272429.0</td>\n",
       "      <td>2022-08-05 00:00: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>247 171</td>\n",
       "      <td>31,98</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bara pro</td>\n",
       "      <td>barakoudalogie</td>\n",
       "      <td>100063863163987</td>\n",
       "      <td>COMEDIAN</td>\n",
       "      <td>CA</td>\n",
       "      <td>Bienvenue sur ma page 😊où vous trouverez des v...</td>\n",
       "      <td>2020-02-09 12:22:00</td>\n",
       "      <td>88216.0</td>\n",
       "      <td>782076.0</td>\n",
       "      <td>2022-08-23 10:00:01 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tu veux tu veux pas tu vas rire 😂😂.  Bara pro 🐒</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>186 715</td>\n",
       "      <td>6,15</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Moe L'enjailleur</td>\n",
       "      <td>moelenjailleurcomedie</td>\n",
       "      <td>100077936434268</td>\n",
       "      <td>PERSON</td>\n",
       "      <td>CA</td>\n",
       "      <td>Vous voulez rire ? C'est chez Moe L'enjailleur...</td>\n",
       "      <td>2021-10-19 18:33:24</td>\n",
       "      <td>100945.0</td>\n",
       "      <td>574592.0</td>\n",
       "      <td>2022-08-23 18:39:19 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>❌ Début de l'histoire très tendu entre Tenor e...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>186 477</td>\n",
       "      <td>18,28</td>\n",
       "      <td>False</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>8168706</th>\n",
       "      <td>Le Rose Pingouin</td>\n",
       "      <td>RosePingouin</td>\n",
       "      <td>327937210552822</td>\n",
       "      <td>ENTERTAINMENT_SITE</td>\n",
       "      <td>CA</td>\n",
       "      <td>Le Rose Pingouin vous informe, vous fait rire,...</td>\n",
       "      <td>2011-12-15 12:25:34</td>\n",
       "      <td>1323981.0</td>\n",
       "      <td>1101855.0</td>\n",
       "      <td>2022-05-14 22:15:03 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.rosepingouin.com/Alicia-Moffet-par...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alicia Moffet partage des photos de ses nouvea...</td>\n",
       "      <td>La chanteuse Alicia Moffet s'est faite tatouée...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>-156</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8168707</th>\n",
       "      <td>IDRC / CRDI</td>\n",
       "      <td>IDRC.CRDI</td>\n",
       "      <td>100064605017187</td>\n",
       "      <td>GOVERNMENT_ORGANIZATION</td>\n",
       "      <td>CA</td>\n",
       "      <td>International Development Research Centre | Ce...</td>\n",
       "      <td>2010-01-15 17:04:10</td>\n",
       "      <td>29329.0</td>\n",
       "      <td>31110.0</td>\n",
       "      <td>2022-05-30 13:05:03 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>YF TT ML EK PS z SR SP MF</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>-14</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8168708</th>\n",
       "      <td>IDRC / CRDI</td>\n",
       "      <td>IDRC.CRDI</td>\n",
       "      <td>100064605017187</td>\n",
       "      <td>GOVERNMENT_ORGANIZATION</td>\n",
       "      <td>CA</td>\n",
       "      <td>International Development Research Centre | Ce...</td>\n",
       "      <td>2010-01-15 17:04:10</td>\n",
       "      <td>29323.0</td>\n",
       "      <td>31090.0</td>\n",
       "      <td>2022-05-09 14:20: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>0</td>\n",
       "      <td>-16</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8168709</th>\n",
       "      <td>IDRC / CRDI</td>\n",
       "      <td>IDRC.CRDI</td>\n",
       "      <td>100064605017187</td>\n",
       "      <td>GOVERNMENT_ORGANIZATION</td>\n",
       "      <td>CA</td>\n",
       "      <td>International Development Research Centre | Ce...</td>\n",
       "      <td>2010-01-15 17:04:10</td>\n",
       "      <td>29309.0</td>\n",
       "      <td>31079.0</td>\n",
       "      <td>2022-05-05 15:15:01 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SYSTÈMES ALIMENTAIRES ET COVID-19: LES LEÇONS ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>-16</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8168710</th>\n",
       "      <td>IDRC / CRDI</td>\n",
       "      <td>IDRC.CRDI</td>\n",
       "      <td>100064605017187</td>\n",
       "      <td>GOVERNMENT_ORGANIZATION</td>\n",
       "      <td>CA</td>\n",
       "      <td>International Development Research Centre | Ce...</td>\n",
       "      <td>2010-01-15 17:04:10</td>\n",
       "      <td>29305.0</td>\n",
       "      <td>31075.0</td>\n",
       "      <td>2022-05-03 13:39:01 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FASTOMPANY W MADE D M A THE LIST! WORLD CHANGI...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>-16</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8168711 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Page Name              User Name      Facebook Id  \\\n",
       "0        Boni Richard Ouorou          Ouorourichard  100044592902599   \n",
       "1             Steve Wulfrand         Stevewulfrand0  100083296573498   \n",
       "2               Piranha Club           Piranha.Club  100081333356954   \n",
       "3                   Bara pro         barakoudalogie  100063863163987   \n",
       "4           Moe L'enjailleur  moelenjailleurcomedie  100077936434268   \n",
       "...                      ...                    ...              ...   \n",
       "8168706     Le Rose Pingouin           RosePingouin  327937210552822   \n",
       "8168707          IDRC / CRDI              IDRC.CRDI  100064605017187   \n",
       "8168708          IDRC / CRDI              IDRC.CRDI  100064605017187   \n",
       "8168709          IDRC / CRDI              IDRC.CRDI  100064605017187   \n",
       "8168710          IDRC / CRDI              IDRC.CRDI  100064605017187   \n",
       "\n",
       "                   Page Category Page Admin Top Country  \\\n",
       "0                     POLITICIAN                     CA   \n",
       "1                          ACTOR                     CA   \n",
       "2             ENTERTAINMENT_SITE                     CA   \n",
       "3                       COMEDIAN                     CA   \n",
       "4                         PERSON                     CA   \n",
       "...                          ...                    ...   \n",
       "8168706       ENTERTAINMENT_SITE                     CA   \n",
       "8168707  GOVERNMENT_ORGANIZATION                     CA   \n",
       "8168708  GOVERNMENT_ORGANIZATION                     CA   \n",
       "8168709  GOVERNMENT_ORGANIZATION                     CA   \n",
       "8168710  GOVERNMENT_ORGANIZATION                     CA   \n",
       "\n",
       "                                          Page Description  \\\n",
       "0        A chaque Génération sa lutte et sa responsabil...   \n",
       "1                                          Créateur vidéo    \n",
       "2        Piranha Club est une grande famille de passion...   \n",
       "3        Bienvenue sur ma page 😊où vous trouverez des v...   \n",
       "4        Vous voulez rire ? C'est chez Moe L'enjailleur...   \n",
       "...                                                    ...   \n",
       "8168706  Le Rose Pingouin vous informe, vous fait rire,...   \n",
       "8168707  International Development Research Centre | Ce...   \n",
       "8168708  International Development Research Centre | Ce...   \n",
       "8168709  International Development Research Centre | Ce...   \n",
       "8168710  International Development Research Centre | Ce...   \n",
       "\n",
       "                Page Created  Likes at Posting  Followers at Posting  \\\n",
       "0        2014-06-25 21:30:48           25530.0               29063.0   \n",
       "1        2022-05-06 23:15:30           10744.0              266251.0   \n",
       "2        2019-12-11 03:05:32          237143.0              272429.0   \n",
       "3        2020-02-09 12:22:00           88216.0              782076.0   \n",
       "4        2021-10-19 18:33:24          100945.0              574592.0   \n",
       "...                      ...               ...                   ...   \n",
       "8168706  2011-12-15 12:25:34         1323981.0             1101855.0   \n",
       "8168707  2010-01-15 17:04:10           29329.0               31110.0   \n",
       "8168708  2010-01-15 17:04:10           29323.0               31090.0   \n",
       "8168709  2010-01-15 17:04:10           29309.0               31079.0   \n",
       "8168710  2010-01-15 17:04:10           29305.0               31075.0   \n",
       "\n",
       "                    Post Created  ...  \\\n",
       "0        2022-08-30 18:49:34 EDT  ...   \n",
       "1        2022-08-29 05:00:03 EDT  ...   \n",
       "2        2022-08-05 00:00:02 EDT  ...   \n",
       "3        2022-08-23 10:00:01 EDT  ...   \n",
       "4        2022-08-23 18:39:19 EDT  ...   \n",
       "...                          ...  ...   \n",
       "8168706  2022-05-14 22:15:03 EDT  ...   \n",
       "8168707  2022-05-30 13:05:03 EDT  ...   \n",
       "8168708  2022-05-09 14:20:02 EDT  ...   \n",
       "8168709  2022-05-05 15:15:01 EDT  ...   \n",
       "8168710  2022-05-03 13:39:01 EDT  ...   \n",
       "\n",
       "                                                Final Link  \\\n",
       "0                                                      NaN   \n",
       "1                                                      NaN   \n",
       "2                                                      NaN   \n",
       "3                                                      NaN   \n",
       "4                                                      NaN   \n",
       "...                                                    ...   \n",
       "8168706  https://www.rosepingouin.com/Alicia-Moffet-par...   \n",
       "8168707                                                NaN   \n",
       "8168708                                                NaN   \n",
       "8168709                                                NaN   \n",
       "8168710                                                NaN   \n",
       "\n",
       "                                                Image Text  \\\n",
       "0        LA CAPACITÉ DE PARLER PLUSIEURS LANGUES EST UN...   \n",
       "1                                                      NaN   \n",
       "2                                                      NaN   \n",
       "3                                                      NaN   \n",
       "4                                                      NaN   \n",
       "...                                                    ...   \n",
       "8168706                                                NaN   \n",
       "8168707                          YF TT ML EK PS z SR SP MF   \n",
       "8168708                                                NaN   \n",
       "8168709  SYSTÈMES ALIMENTAIRES ET COVID-19: LES LEÇONS ...   \n",
       "8168710  FASTOMPANY W MADE D M A THE LIST! WORLD CHANGI...   \n",
       "\n",
       "                                                 Link Text  \\\n",
       "0                                                      NaN   \n",
       "1                                                      NaN   \n",
       "2                                                      NaN   \n",
       "3          Tu veux tu veux pas tu vas rire 😂😂.  Bara pro 🐒   \n",
       "4        ❌ Début de l'histoire très tendu entre Tenor e...   \n",
       "...                                                    ...   \n",
       "8168706  Alicia Moffet partage des photos de ses nouvea...   \n",
       "8168707                                                NaN   \n",
       "8168708                                                NaN   \n",
       "8168709                                                NaN   \n",
       "8168710                                                NaN   \n",
       "\n",
       "                                               Description  Sponsor Id  \\\n",
       "0                                                      NaN         NaN   \n",
       "1                                                      NaN         NaN   \n",
       "2                                                      NaN         NaN   \n",
       "3                                                      NaN         NaN   \n",
       "4                                                      NaN         NaN   \n",
       "...                                                    ...         ...   \n",
       "8168706  La chanteuse Alicia Moffet s'est faite tatouée...         NaN   \n",
       "8168707                                                NaN         NaN   \n",
       "8168708                                                NaN         NaN   \n",
       "8168709                                                NaN         NaN   \n",
       "8168710                                                NaN         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",
       "8168706           NaN               NaN   \n",
       "8168707           NaN               NaN   \n",
       "8168708           NaN               NaN   \n",
       "8168709           NaN               NaN   \n",
       "8168710           NaN               NaN   \n",
       "\n",
       "         Total Interactions (weighted  —  Likes 1x Shares 1x Comments 1x Love 1x Wow 1x Haha 1x Sad 1x Angry 1x Care 1x )  \\\n",
       "0                                                  263 678                                                                  \n",
       "1                                                  250 276                                                                  \n",
       "2                                                  247 171                                                                  \n",
       "3                                                  186 715                                                                  \n",
       "4                                                  186 477                                                                  \n",
       "...                                                    ...                                                                  \n",
       "8168706                                                  0                                                                  \n",
       "8168707                                                  0                                                                  \n",
       "8168708                                                  0                                                                  \n",
       "8168709                                                  0                                                                  \n",
       "8168710                                                  0                                                                  \n",
       "\n",
       "         Overperforming Score  média  \n",
       "0                      768,74  False  \n",
       "1                       69,66  False  \n",
       "2                       31,98  False  \n",
       "3                        6,15  False  \n",
       "4                       18,28  False  \n",
       "...                       ...    ...  \n",
       "8168706                  -156  False  \n",
       "8168707                   -14  False  \n",
       "8168708                   -16  False  \n",
       "8168709                   -16  False  \n",
       "8168710                   -16  False  \n",
       "\n",
       "[8168711 rows x 42 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "2d7fb867",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False    7141018\n",
       "True     1027693\n",
       "Name: média, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich.média.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "f7bfdd68",
   "metadata": {},
   "outputs": [],
   "source": [
    "medias = fich.média == True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "3f332c41",
   "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>Total Interactions (weighted  —  Likes 1x Shares 1x Comments 1x Love 1x Wow 1x Haha 1x Sad 1x Angry 1x Care 1x )</th>\n",
       "      <th>Overperforming Score</th>\n",
       "      <th>média</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>244</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>63818.0</td>\n",
       "      <td>84853.0</td>\n",
       "      <td>2022-08-01 19:00:43 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>23 051</td>\n",
       "      <td>101,55</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341</th>\n",
       "      <td>Le Journal de Montréal</td>\n",
       "      <td>jdemontreal</td>\n",
       "      <td>100064702091893</td>\n",
       "      <td>MEDIA_NEWS_COMPANY</td>\n",
       "      <td>CA</td>\n",
       "      <td>Des nouvelles accessibles et complètes: sports...</td>\n",
       "      <td>2011-06-09 20:52:08</td>\n",
       "      <td>724908.0</td>\n",
       "      <td>734082.0</td>\n",
       "      <td>2022-08-24 08:40:02 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Entendu des kilomètres à la ronde, le spectacl...</td>\n",
       "      <td>Le concert du groupe allemand, dimanche au par...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18 745</td>\n",
       "      <td>122,52</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</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>417858.0</td>\n",
       "      <td>508121.0</td>\n",
       "      <td>2022-08-11 18:25:26 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>14 517</td>\n",
       "      <td>16,63</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>581</th>\n",
       "      <td>Narcity Québec</td>\n",
       "      <td>NarcityQuebec</td>\n",
       "      <td>271036236431606</td>\n",
       "      <td>ENTERTAINMENT_SITE</td>\n",
       "      <td>CA</td>\n",
       "      <td>Narcity c'est le coeur de ta ville. Découvre t...</td>\n",
       "      <td>2014-08-19 00:51:32</td>\n",
       "      <td>404990.0</td>\n",
       "      <td>428396.0</td>\n",
       "      <td>2022-08-17 11:14:34 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.narcity.com/fr/zellers-revient-au-...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Zellers revient au Canada en 2023 et ça va te ...</td>\n",
       "      <td>Mode nostalgie : Activé! 😍</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12 362</td>\n",
       "      <td>41,07</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>589</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>418065.0</td>\n",
       "      <td>510502.0</td>\n",
       "      <td>2022-08-18 18:14:38 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DERNIÈRE HEURE CAREY PRICE SERA PLACÉ SUR LA L...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12 299</td>\n",
       "      <td>13,61</td>\n",
       "      <td>True</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>8168619</th>\n",
       "      <td>L'info du Nord Mont-Tremblant</td>\n",
       "      <td>linfodunordmt</td>\n",
       "      <td>100063565902064</td>\n",
       "      <td>TOPIC_NEWSPAPER</td>\n",
       "      <td>CA</td>\n",
       "      <td>L’info du Nord Mont-Tremblant est un journal l...</td>\n",
       "      <td>2011-02-17 19:40:57</td>\n",
       "      <td>10457.0</td>\n",
       "      <td>11485.0</td>\n",
       "      <td>2022-05-19 22:00:02 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>https://infodunordtremblant.ca/actualites/2022...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Échos du conseil municipal de Mont-Tremblant</td>\n",
       "      <td>Le 9 mai se tenait les séances du conseil muni...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>-104</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8168620</th>\n",
       "      <td>L'info du Nord Mont-Tremblant</td>\n",
       "      <td>linfodunordmt</td>\n",
       "      <td>100063565902064</td>\n",
       "      <td>TOPIC_NEWSPAPER</td>\n",
       "      <td>CA</td>\n",
       "      <td>L’info du Nord Mont-Tremblant est un journal l...</td>\n",
       "      <td>2011-02-17 19:40:57</td>\n",
       "      <td>10448.0</td>\n",
       "      <td>11474.0</td>\n",
       "      <td>2022-05-18 14:00:03 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canadian Tire Mont-Tremblant | Les Jobins</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>-104</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8168621</th>\n",
       "      <td>L'info du Nord Mont-Tremblant</td>\n",
       "      <td>linfodunordmt</td>\n",
       "      <td>100063565902064</td>\n",
       "      <td>TOPIC_NEWSPAPER</td>\n",
       "      <td>CA</td>\n",
       "      <td>L’info du Nord Mont-Tremblant est un journal l...</td>\n",
       "      <td>2011-02-17 19:40:57</td>\n",
       "      <td>10449.0</td>\n",
       "      <td>11475.0</td>\n",
       "      <td>2022-05-17 12:00:05 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Les Marchés Tradition Lac Carré | Les Jobins</td>\n",
       "      <td>Épicerie</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>-104</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8168622</th>\n",
       "      <td>L'info du Nord Mont-Tremblant</td>\n",
       "      <td>linfodunordmt</td>\n",
       "      <td>100063565902064</td>\n",
       "      <td>TOPIC_NEWSPAPER</td>\n",
       "      <td>CA</td>\n",
       "      <td>L’info du Nord Mont-Tremblant est un journal l...</td>\n",
       "      <td>2011-02-17 19:40:57</td>\n",
       "      <td>10437.0</td>\n",
       "      <td>11463.0</td>\n",
       "      <td>2022-05-12 11:00:03 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Les jobins</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>-104</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8168628</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>687043.0</td>\n",
       "      <td>713977.0</td>\n",
       "      <td>2022-05-20 16:30:13 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.lapresse.ca/cinema/critiques/2022-...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Men | Peur primale ★★★</td>\n",
       "      <td>Fragilisée par la mort de son ex-mari, une fem...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>-218</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1027693 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Page Name      User Name      Facebook Id  \\\n",
       "244                         ICI Estrie      iciestrie  211536155525838   \n",
       "341             Le Journal de Montréal    jdemontreal  100064702091893   \n",
       "478                                RDS            RDS  100064854125890   \n",
       "581                     Narcity Québec  NarcityQuebec  271036236431606   \n",
       "589                                RDS            RDS  100064854125890   \n",
       "...                                ...            ...              ...   \n",
       "8168619  L'info du Nord Mont-Tremblant  linfodunordmt  100063565902064   \n",
       "8168620  L'info du Nord Mont-Tremblant  linfodunordmt  100063565902064   \n",
       "8168621  L'info du Nord Mont-Tremblant  linfodunordmt  100063565902064   \n",
       "8168622  L'info du Nord Mont-Tremblant  linfodunordmt  100063565902064   \n",
       "8168628                      La Presse     LaPresseFB  100064750746253   \n",
       "\n",
       "                         Page Category Page Admin Top Country  \\\n",
       "244      BROADCASTING_MEDIA_PRODUCTION                     CA   \n",
       "341                 MEDIA_NEWS_COMPANY                     CA   \n",
       "478                         TV_NETWORK                     CA   \n",
       "581                 ENTERTAINMENT_SITE                     CA   \n",
       "589                         TV_NETWORK                     CA   \n",
       "...                                ...                    ...   \n",
       "8168619                TOPIC_NEWSPAPER                     CA   \n",
       "8168620                TOPIC_NEWSPAPER                     CA   \n",
       "8168621                TOPIC_NEWSPAPER                     CA   \n",
       "8168622                TOPIC_NEWSPAPER                     CA   \n",
       "8168628                      NEWS_SITE                     CA   \n",
       "\n",
       "                                          Page Description  \\\n",
       "244      Radio-Canada Estrie, ce sont vos nouvelles à l...   \n",
       "341      Des nouvelles accessibles et complètes: sports...   \n",
       "478      La page Facebook de RDS. Le sport sans limites...   \n",
       "581      Narcity c'est le coeur de ta ville. Découvre t...   \n",
       "589      La page Facebook de RDS. Le sport sans limites...   \n",
       "...                                                    ...   \n",
       "8168619  L’info du Nord Mont-Tremblant est un journal l...   \n",
       "8168620  L’info du Nord Mont-Tremblant est un journal l...   \n",
       "8168621  L’info du Nord Mont-Tremblant est un journal l...   \n",
       "8168622  L’info du Nord Mont-Tremblant est un journal l...   \n",
       "8168628  Média d’information qui regroupe la plus grand...   \n",
       "\n",
       "                Page Created  Likes at Posting  Followers at Posting  \\\n",
       "244      2011-03-29 17:57:10           63818.0               84853.0   \n",
       "341      2011-06-09 20:52:08          724908.0              734082.0   \n",
       "478      2009-08-10 17:38:31          417858.0              508121.0   \n",
       "581      2014-08-19 00:51:32          404990.0              428396.0   \n",
       "589      2009-08-10 17:38:31          418065.0              510502.0   \n",
       "...                      ...               ...                   ...   \n",
       "8168619  2011-02-17 19:40:57           10457.0               11485.0   \n",
       "8168620  2011-02-17 19:40:57           10448.0               11474.0   \n",
       "8168621  2011-02-17 19:40:57           10449.0               11475.0   \n",
       "8168622  2011-02-17 19:40:57           10437.0               11463.0   \n",
       "8168628  2009-04-02 03:00:46          687043.0              713977.0   \n",
       "\n",
       "                    Post Created  ...  \\\n",
       "244      2022-08-01 19:00:43 EDT  ...   \n",
       "341      2022-08-24 08:40:02 EDT  ...   \n",
       "478      2022-08-11 18:25:26 EDT  ...   \n",
       "581      2022-08-17 11:14:34 EDT  ...   \n",
       "589      2022-08-18 18:14:38 EDT  ...   \n",
       "...                          ...  ...   \n",
       "8168619  2022-05-19 22:00:02 EDT  ...   \n",
       "8168620  2022-05-18 14:00:03 EDT  ...   \n",
       "8168621  2022-05-17 12:00:05 EDT  ...   \n",
       "8168622  2022-05-12 11:00:03 EDT  ...   \n",
       "8168628  2022-05-20 16:30:13 EDT  ...   \n",
       "\n",
       "                                                Final Link  \\\n",
       "244                                                    NaN   \n",
       "341                                                    NaN   \n",
       "478                                                    NaN   \n",
       "581      https://www.narcity.com/fr/zellers-revient-au-...   \n",
       "589                                                    NaN   \n",
       "...                                                    ...   \n",
       "8168619  https://infodunordtremblant.ca/actualites/2022...   \n",
       "8168620                                                NaN   \n",
       "8168621                                                NaN   \n",
       "8168622                                                NaN   \n",
       "8168628  https://www.lapresse.ca/cinema/critiques/2022-...   \n",
       "\n",
       "                                                Image Text  \\\n",
       "244                                                    NaN   \n",
       "341                                                    NaN   \n",
       "478                                                    NaN   \n",
       "581                                                    NaN   \n",
       "589      DERNIÈRE HEURE CAREY PRICE SERA PLACÉ SUR LA L...   \n",
       "...                                                    ...   \n",
       "8168619                                                NaN   \n",
       "8168620                                                NaN   \n",
       "8168621                                                NaN   \n",
       "8168622                                                NaN   \n",
       "8168628                                                NaN   \n",
       "\n",
       "                                                 Link Text  \\\n",
       "244                                                    NaN   \n",
       "341      Entendu des kilomètres à la ronde, le spectacl...   \n",
       "478                                                    NaN   \n",
       "581      Zellers revient au Canada en 2023 et ça va te ...   \n",
       "589                                                    NaN   \n",
       "...                                                    ...   \n",
       "8168619       Échos du conseil municipal de Mont-Tremblant   \n",
       "8168620          Canadian Tire Mont-Tremblant | Les Jobins   \n",
       "8168621       Les Marchés Tradition Lac Carré | Les Jobins   \n",
       "8168622                                         Les jobins   \n",
       "8168628                             Men | Peur primale ★★★   \n",
       "\n",
       "                                               Description  Sponsor Id  \\\n",
       "244                                                    NaN         NaN   \n",
       "341      Le concert du groupe allemand, dimanche au par...         NaN   \n",
       "478                                                    NaN         NaN   \n",
       "581                             Mode nostalgie : Activé! 😍         NaN   \n",
       "589                                                    NaN         NaN   \n",
       "...                                                    ...         ...   \n",
       "8168619  Le 9 mai se tenait les séances du conseil muni...         NaN   \n",
       "8168620                                                NaN         NaN   \n",
       "8168621                                           Épicerie         NaN   \n",
       "8168622                                                NaN         NaN   \n",
       "8168628  Fragilisée par la mort de son ex-mari, une fem...         NaN   \n",
       "\n",
       "         Sponsor Name  Sponsor Category  \\\n",
       "244               NaN               NaN   \n",
       "341               NaN               NaN   \n",
       "478               NaN               NaN   \n",
       "581               NaN               NaN   \n",
       "589               NaN               NaN   \n",
       "...               ...               ...   \n",
       "8168619           NaN               NaN   \n",
       "8168620           NaN               NaN   \n",
       "8168621           NaN               NaN   \n",
       "8168622           NaN               NaN   \n",
       "8168628           NaN               NaN   \n",
       "\n",
       "         Total Interactions (weighted  —  Likes 1x Shares 1x Comments 1x Love 1x Wow 1x Haha 1x Sad 1x Angry 1x Care 1x )  \\\n",
       "244                                                 23 051                                                                  \n",
       "341                                                 18 745                                                                  \n",
       "478                                                 14 517                                                                  \n",
       "581                                                 12 362                                                                  \n",
       "589                                                 12 299                                                                  \n",
       "...                                                    ...                                                                  \n",
       "8168619                                                  0                                                                  \n",
       "8168620                                                  0                                                                  \n",
       "8168621                                                  0                                                                  \n",
       "8168622                                                  0                                                                  \n",
       "8168628                                                  0                                                                  \n",
       "\n",
       "         Overperforming Score  média  \n",
       "244                    101,55   True  \n",
       "341                    122,52   True  \n",
       "478                     16,63   True  \n",
       "581                     41,07   True  \n",
       "589                     13,61   True  \n",
       "...                       ...    ...  \n",
       "8168619                  -104   True  \n",
       "8168620                  -104   True  \n",
       "8168621                  -104   True  \n",
       "8168622                  -104   True  \n",
       "8168628                  -218   True  \n",
       "\n",
       "[1027693 rows x 42 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich[medias]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "e10f6a38",
   "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>Total Interactions (weighted  —  Likes 1x Shares 1x Comments 1x Love 1x Wow 1x Haha 1x Sad 1x Angry 1x Care 1x )</th>\n",
       "      <th>Overperforming Score</th>\n",
       "      <th>média</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Boni Richard Ouorou</td>\n",
       "      <td>Ouorourichard</td>\n",
       "      <td>100044592902599</td>\n",
       "      <td>POLITICIAN</td>\n",
       "      <td>CA</td>\n",
       "      <td>A chaque Génération sa lutte et sa responsabil...</td>\n",
       "      <td>2014-06-25 21:30:48</td>\n",
       "      <td>25530.0</td>\n",
       "      <td>29063.0</td>\n",
       "      <td>2022-08-30 18:49:34 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LA CAPACITÉ DE PARLER PLUSIEURS LANGUES EST UN...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>263 678</td>\n",
       "      <td>768,74</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Steve Wulfrand</td>\n",
       "      <td>Stevewulfrand0</td>\n",
       "      <td>100083296573498</td>\n",
       "      <td>ACTOR</td>\n",
       "      <td>CA</td>\n",
       "      <td>Créateur vidéo</td>\n",
       "      <td>2022-05-06 23:15:30</td>\n",
       "      <td>10744.0</td>\n",
       "      <td>266251.0</td>\n",
       "      <td>2022-08-29 05:00:03 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>250 276</td>\n",
       "      <td>69,66</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Piranha Club</td>\n",
       "      <td>Piranha.Club</td>\n",
       "      <td>100081333356954</td>\n",
       "      <td>ENTERTAINMENT_SITE</td>\n",
       "      <td>CA</td>\n",
       "      <td>Piranha Club est une grande famille de passion...</td>\n",
       "      <td>2019-12-11 03:05:32</td>\n",
       "      <td>237143.0</td>\n",
       "      <td>272429.0</td>\n",
       "      <td>2022-08-05 00:00: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>247 171</td>\n",
       "      <td>31,98</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bara pro</td>\n",
       "      <td>barakoudalogie</td>\n",
       "      <td>100063863163987</td>\n",
       "      <td>COMEDIAN</td>\n",
       "      <td>CA</td>\n",
       "      <td>Bienvenue sur ma page 😊où vous trouverez des v...</td>\n",
       "      <td>2020-02-09 12:22:00</td>\n",
       "      <td>88216.0</td>\n",
       "      <td>782076.0</td>\n",
       "      <td>2022-08-23 10:00:01 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tu veux tu veux pas tu vas rire 😂😂.  Bara pro 🐒</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>186 715</td>\n",
       "      <td>6,15</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Moe L'enjailleur</td>\n",
       "      <td>moelenjailleurcomedie</td>\n",
       "      <td>100077936434268</td>\n",
       "      <td>PERSON</td>\n",
       "      <td>CA</td>\n",
       "      <td>Vous voulez rire ? C'est chez Moe L'enjailleur...</td>\n",
       "      <td>2021-10-19 18:33:24</td>\n",
       "      <td>100945.0</td>\n",
       "      <td>574592.0</td>\n",
       "      <td>2022-08-23 18:39:19 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>❌ Début de l'histoire très tendu entre Tenor e...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>186 477</td>\n",
       "      <td>18,28</td>\n",
       "      <td>False</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>8168706</th>\n",
       "      <td>Le Rose Pingouin</td>\n",
       "      <td>RosePingouin</td>\n",
       "      <td>327937210552822</td>\n",
       "      <td>ENTERTAINMENT_SITE</td>\n",
       "      <td>CA</td>\n",
       "      <td>Le Rose Pingouin vous informe, vous fait rire,...</td>\n",
       "      <td>2011-12-15 12:25:34</td>\n",
       "      <td>1323981.0</td>\n",
       "      <td>1101855.0</td>\n",
       "      <td>2022-05-14 22:15:03 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.rosepingouin.com/Alicia-Moffet-par...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alicia Moffet partage des photos de ses nouvea...</td>\n",
       "      <td>La chanteuse Alicia Moffet s'est faite tatouée...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>-156</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8168707</th>\n",
       "      <td>IDRC / CRDI</td>\n",
       "      <td>IDRC.CRDI</td>\n",
       "      <td>100064605017187</td>\n",
       "      <td>GOVERNMENT_ORGANIZATION</td>\n",
       "      <td>CA</td>\n",
       "      <td>International Development Research Centre | Ce...</td>\n",
       "      <td>2010-01-15 17:04:10</td>\n",
       "      <td>29329.0</td>\n",
       "      <td>31110.0</td>\n",
       "      <td>2022-05-30 13:05:03 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>YF TT ML EK PS z SR SP MF</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>-14</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8168708</th>\n",
       "      <td>IDRC / CRDI</td>\n",
       "      <td>IDRC.CRDI</td>\n",
       "      <td>100064605017187</td>\n",
       "      <td>GOVERNMENT_ORGANIZATION</td>\n",
       "      <td>CA</td>\n",
       "      <td>International Development Research Centre | Ce...</td>\n",
       "      <td>2010-01-15 17:04:10</td>\n",
       "      <td>29323.0</td>\n",
       "      <td>31090.0</td>\n",
       "      <td>2022-05-09 14:20: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>0</td>\n",
       "      <td>-16</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8168709</th>\n",
       "      <td>IDRC / CRDI</td>\n",
       "      <td>IDRC.CRDI</td>\n",
       "      <td>100064605017187</td>\n",
       "      <td>GOVERNMENT_ORGANIZATION</td>\n",
       "      <td>CA</td>\n",
       "      <td>International Development Research Centre | Ce...</td>\n",
       "      <td>2010-01-15 17:04:10</td>\n",
       "      <td>29309.0</td>\n",
       "      <td>31079.0</td>\n",
       "      <td>2022-05-05 15:15:01 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SYSTÈMES ALIMENTAIRES ET COVID-19: LES LEÇONS ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>-16</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8168710</th>\n",
       "      <td>IDRC / CRDI</td>\n",
       "      <td>IDRC.CRDI</td>\n",
       "      <td>100064605017187</td>\n",
       "      <td>GOVERNMENT_ORGANIZATION</td>\n",
       "      <td>CA</td>\n",
       "      <td>International Development Research Centre | Ce...</td>\n",
       "      <td>2010-01-15 17:04:10</td>\n",
       "      <td>29305.0</td>\n",
       "      <td>31075.0</td>\n",
       "      <td>2022-05-03 13:39:01 EDT</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FASTOMPANY W MADE D M A THE LIST! WORLD CHANGI...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>-16</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7141018 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Page Name              User Name      Facebook Id  \\\n",
       "0        Boni Richard Ouorou          Ouorourichard  100044592902599   \n",
       "1             Steve Wulfrand         Stevewulfrand0  100083296573498   \n",
       "2               Piranha Club           Piranha.Club  100081333356954   \n",
       "3                   Bara pro         barakoudalogie  100063863163987   \n",
       "4           Moe L'enjailleur  moelenjailleurcomedie  100077936434268   \n",
       "...                      ...                    ...              ...   \n",
       "8168706     Le Rose Pingouin           RosePingouin  327937210552822   \n",
       "8168707          IDRC / CRDI              IDRC.CRDI  100064605017187   \n",
       "8168708          IDRC / CRDI              IDRC.CRDI  100064605017187   \n",
       "8168709          IDRC / CRDI              IDRC.CRDI  100064605017187   \n",
       "8168710          IDRC / CRDI              IDRC.CRDI  100064605017187   \n",
       "\n",
       "                   Page Category Page Admin Top Country  \\\n",
       "0                     POLITICIAN                     CA   \n",
       "1                          ACTOR                     CA   \n",
       "2             ENTERTAINMENT_SITE                     CA   \n",
       "3                       COMEDIAN                     CA   \n",
       "4                         PERSON                     CA   \n",
       "...                          ...                    ...   \n",
       "8168706       ENTERTAINMENT_SITE                     CA   \n",
       "8168707  GOVERNMENT_ORGANIZATION                     CA   \n",
       "8168708  GOVERNMENT_ORGANIZATION                     CA   \n",
       "8168709  GOVERNMENT_ORGANIZATION                     CA   \n",
       "8168710  GOVERNMENT_ORGANIZATION                     CA   \n",
       "\n",
       "                                          Page Description  \\\n",
       "0        A chaque Génération sa lutte et sa responsabil...   \n",
       "1                                          Créateur vidéo    \n",
       "2        Piranha Club est une grande famille de passion...   \n",
       "3        Bienvenue sur ma page 😊où vous trouverez des v...   \n",
       "4        Vous voulez rire ? C'est chez Moe L'enjailleur...   \n",
       "...                                                    ...   \n",
       "8168706  Le Rose Pingouin vous informe, vous fait rire,...   \n",
       "8168707  International Development Research Centre | Ce...   \n",
       "8168708  International Development Research Centre | Ce...   \n",
       "8168709  International Development Research Centre | Ce...   \n",
       "8168710  International Development Research Centre | Ce...   \n",
       "\n",
       "                Page Created  Likes at Posting  Followers at Posting  \\\n",
       "0        2014-06-25 21:30:48           25530.0               29063.0   \n",
       "1        2022-05-06 23:15:30           10744.0              266251.0   \n",
       "2        2019-12-11 03:05:32          237143.0              272429.0   \n",
       "3        2020-02-09 12:22:00           88216.0              782076.0   \n",
       "4        2021-10-19 18:33:24          100945.0              574592.0   \n",
       "...                      ...               ...                   ...   \n",
       "8168706  2011-12-15 12:25:34         1323981.0             1101855.0   \n",
       "8168707  2010-01-15 17:04:10           29329.0               31110.0   \n",
       "8168708  2010-01-15 17:04:10           29323.0               31090.0   \n",
       "8168709  2010-01-15 17:04:10           29309.0               31079.0   \n",
       "8168710  2010-01-15 17:04:10           29305.0               31075.0   \n",
       "\n",
       "                    Post Created  ...  \\\n",
       "0        2022-08-30 18:49:34 EDT  ...   \n",
       "1        2022-08-29 05:00:03 EDT  ...   \n",
       "2        2022-08-05 00:00:02 EDT  ...   \n",
       "3        2022-08-23 10:00:01 EDT  ...   \n",
       "4        2022-08-23 18:39:19 EDT  ...   \n",
       "...                          ...  ...   \n",
       "8168706  2022-05-14 22:15:03 EDT  ...   \n",
       "8168707  2022-05-30 13:05:03 EDT  ...   \n",
       "8168708  2022-05-09 14:20:02 EDT  ...   \n",
       "8168709  2022-05-05 15:15:01 EDT  ...   \n",
       "8168710  2022-05-03 13:39:01 EDT  ...   \n",
       "\n",
       "                                                Final Link  \\\n",
       "0                                                      NaN   \n",
       "1                                                      NaN   \n",
       "2                                                      NaN   \n",
       "3                                                      NaN   \n",
       "4                                                      NaN   \n",
       "...                                                    ...   \n",
       "8168706  https://www.rosepingouin.com/Alicia-Moffet-par...   \n",
       "8168707                                                NaN   \n",
       "8168708                                                NaN   \n",
       "8168709                                                NaN   \n",
       "8168710                                                NaN   \n",
       "\n",
       "                                                Image Text  \\\n",
       "0        LA CAPACITÉ DE PARLER PLUSIEURS LANGUES EST UN...   \n",
       "1                                                      NaN   \n",
       "2                                                      NaN   \n",
       "3                                                      NaN   \n",
       "4                                                      NaN   \n",
       "...                                                    ...   \n",
       "8168706                                                NaN   \n",
       "8168707                          YF TT ML EK PS z SR SP MF   \n",
       "8168708                                                NaN   \n",
       "8168709  SYSTÈMES ALIMENTAIRES ET COVID-19: LES LEÇONS ...   \n",
       "8168710  FASTOMPANY W MADE D M A THE LIST! WORLD CHANGI...   \n",
       "\n",
       "                                                 Link Text  \\\n",
       "0                                                      NaN   \n",
       "1                                                      NaN   \n",
       "2                                                      NaN   \n",
       "3          Tu veux tu veux pas tu vas rire 😂😂.  Bara pro 🐒   \n",
       "4        ❌ Début de l'histoire très tendu entre Tenor e...   \n",
       "...                                                    ...   \n",
       "8168706  Alicia Moffet partage des photos de ses nouvea...   \n",
       "8168707                                                NaN   \n",
       "8168708                                                NaN   \n",
       "8168709                                                NaN   \n",
       "8168710                                                NaN   \n",
       "\n",
       "                                               Description  Sponsor Id  \\\n",
       "0                                                      NaN         NaN   \n",
       "1                                                      NaN         NaN   \n",
       "2                                                      NaN         NaN   \n",
       "3                                                      NaN         NaN   \n",
       "4                                                      NaN         NaN   \n",
       "...                                                    ...         ...   \n",
       "8168706  La chanteuse Alicia Moffet s'est faite tatouée...         NaN   \n",
       "8168707                                                NaN         NaN   \n",
       "8168708                                                NaN         NaN   \n",
       "8168709                                                NaN         NaN   \n",
       "8168710                                                NaN         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",
       "8168706           NaN               NaN   \n",
       "8168707           NaN               NaN   \n",
       "8168708           NaN               NaN   \n",
       "8168709           NaN               NaN   \n",
       "8168710           NaN               NaN   \n",
       "\n",
       "         Total Interactions (weighted  —  Likes 1x Shares 1x Comments 1x Love 1x Wow 1x Haha 1x Sad 1x Angry 1x Care 1x )  \\\n",
       "0                                                  263 678                                                                  \n",
       "1                                                  250 276                                                                  \n",
       "2                                                  247 171                                                                  \n",
       "3                                                  186 715                                                                  \n",
       "4                                                  186 477                                                                  \n",
       "...                                                    ...                                                                  \n",
       "8168706                                                  0                                                                  \n",
       "8168707                                                  0                                                                  \n",
       "8168708                                                  0                                                                  \n",
       "8168709                                                  0                                                                  \n",
       "8168710                                                  0                                                                  \n",
       "\n",
       "         Overperforming Score  média  \n",
       "0                      768,74  False  \n",
       "1                       69,66  False  \n",
       "2                       31,98  False  \n",
       "3                        6,15  False  \n",
       "4                       18,28  False  \n",
       "...                       ...    ...  \n",
       "8168706                  -156  False  \n",
       "8168707                   -14  False  \n",
       "8168708                   -16  False  \n",
       "8168709                   -16  False  \n",
       "8168710                   -16  False  \n",
       "\n",
       "[7141018 rows x 42 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich[~medias]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "fcfdf366",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Le Journal de Québec                  37786\n",
       "Le Journal de Montréal                36761\n",
       "La Voix de l'Est                      35113\n",
       "Le Nouvelliste                        33854\n",
       "La Presse                             30818\n",
       "TVA Nouvelles                         29064\n",
       "Le Soleil                             27886\n",
       "Le Droit                              25079\n",
       "RDS                                   23167\n",
       "Le Devoir                             21635\n",
       "Le Quotidien                          20891\n",
       "La Tribune                            20646\n",
       "Radio-Canada Information              20557\n",
       "Narcity Québec                        15832\n",
       "www.lanouvelle.net                    14702\n",
       "Journal Métro                         13462\n",
       "Les Affaires                          13414\n",
       "ICI Québec                            11127\n",
       "EnBeauce.com                          10524\n",
       "Journal Le Soir                       10111\n",
       "FM 103,3 - La radio allumée            9321\n",
       "ICI Mauricie Centre-du-Québec          9292\n",
       "104,7 Outaouais                        9073\n",
       "Néomédia Vaudreuil-Soulanges           8952\n",
       "Noovo Info                             8403\n",
       "Journal Le Reflet                      8324\n",
       "Radio-Canada Sports                    8312\n",
       "TVA Sports                             8296\n",
       "98,5 FM                                7791\n",
       "ICI Saguenay–Lac-Saint-Jean            7718\n",
       "CIMT Nouvelles                         7640\n",
       "TVA Gatineau-Ottawa                    7271\n",
       "ICI Estrie                             7099\n",
       "Métro Québec                           6768\n",
       "Le Courrier du Sud                     6466\n",
       "ICI Abitibi-Témiscamingue              6413\n",
       "Journal Saint-François                 6383\n",
       "Le Journal de Lévis                    6143\n",
       "ICI Ottawa Gatineau                    6092\n",
       "Espaces autochtones                    6000\n",
       "FM Charlevoix - CIHO 96,3              5876\n",
       "Courrier Laval                         5860\n",
       "Néomédia Valleyfield                   5795\n",
       "TVA Québec                             5744\n",
       "Le Soleil de Châteauguay               5687\n",
       "Info Dimanche                          5665\n",
       "QUB radio                              5601\n",
       "Journal Le Citoyen Val-d'Or - Amos     5406\n",
       "24 heures                              5332\n",
       "Le Citoyen Rouyn - La Sarre            5232\n",
       "Name: Page Name, dtype: int64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich[medias][\"Page Name\"].value_counts().head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "c395c40e",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Votemeyo                                             60276\n",
       "Spotted: Jeunes mamans                               57877\n",
       "Drive Good                                           57042\n",
       "Hockey30.com                                         23134\n",
       "Spotted st-jérome                                    22847\n",
       "Truck Stop Quebec                                    20811\n",
       "La Ligue des DEALS                                   20797\n",
       "Spotted Valleyfield                                  17940\n",
       "Boucherie Tendre Gourmet inc                         16942\n",
       "Monsieur Deals                                       16810\n",
       "Spotted Terrebonne - Mascouche                       15993\n",
       "Les p'tits Deals                                     15477\n",
       "Ayoye                                                15151\n",
       "Grands Titres                                        14864\n",
       "QC Lifestyle                                         14858\n",
       "Veux-Tu Rire?                                        14857\n",
       "Ayoye OMG QC                                         14792\n",
       "Ayoye - QC                                           14784\n",
       "Ayoye QC                                             14758\n",
       "TROP CUTE [Fan-O-web]                                14726\n",
       "Fanoweb                                              14576\n",
       "Desjardins                                           14369\n",
       "Spotted Shawinigan                                   14366\n",
       "Barcelone FCB                                        14209\n",
       "Emplois transport                                    14173\n",
       "Spotted: Blainville                                  14068\n",
       "Spotted: Levis                                       13836\n",
       "La Parole Vivante                                    13455\n",
       "Recette de Maman                                     13434\n",
       "WorldTop le meilleur du web                          13405\n",
       "Gagnez GROS                                          13340\n",
       "Concours & Buzz Québec                               13236\n",
       "Actualités, trucs et astuces                         13115\n",
       "HABSolumentFan                                       13016\n",
       "Parlonsbuzz                                          12917\n",
       "Intellivoire.net                                     12915\n",
       "Circulaires                                          12678\n",
       "Spotted Chicoutimi                                   12543\n",
       "Spotted : Saint-Georges de beauce                    12463\n",
       "Mr Motivateur                                        12407\n",
       "Spotted : La Baie                                    12335\n",
       "VIE De Prières (On ne peut les séparer)              12333\n",
       "KoalaQuiz Français                                   12070\n",
       "Ayoye OMG                                            11786\n",
       "DansLesCoulisses.com                                 11414\n",
       "Le spotted de Saint Jean sur Richelieu & environs    11294\n",
       "Fanadiens.com                                        11103\n",
       "Hearst News link & Area                              11089\n",
       "spotted: Varennes                                    11034\n",
       "Monde de Stars                                       11013\n",
       "Name: Page Name, dtype: int64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich[~medias][\"Page Name\"].value_counts().head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "e0d90bf0",
   "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": "code",
   "execution_count": 19,
   "id": "d09cde7a",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Page Name\n",
       "TVA Nouvelles                         26995850\n",
       "Le Journal de Montréal                16742400\n",
       "RDS                                   16369283\n",
       "Radio-Canada Information              10363908\n",
       "Le Journal de Québec                   8348108\n",
       "La Presse                              7622784\n",
       "Narcity Québec                         7520944\n",
       "Le Devoir                              7381130\n",
       "TVA Sports                             6216226\n",
       "Le Soleil                              3816824\n",
       "ICI Québec                             2525658\n",
       "Radio-Canada Sports                    2500095\n",
       "Le Nouvelliste                         2481513\n",
       "Radio-Canada Science                   2082819\n",
       "ICI Estrie                             1686238\n",
       "ICI Saguenay–Lac-Saint-Jean            1623999\n",
       "Le Téléjournal 18 h                    1430860\n",
       "Le Quotidien                           1362091\n",
       "La Tribune                             1254818\n",
       "Journal Métro                          1153067\n",
       "La Voix de l'Est                       1147060\n",
       "Les Affaires                           1130560\n",
       "98,5 FM                                1127450\n",
       "ICI Abitibi-Témiscamingue              1125885\n",
       "104,7 Outaouais                        1002313\n",
       "TVA Gatineau-Ottawa                     955076\n",
       "Le Droit                                911370\n",
       "ICI Mauricie Centre-du-Québec           887969\n",
       "Espaces autochtones                     852883\n",
       "www.zone911.com                         795842\n",
       "BPM Sports                              762070\n",
       "Noovo Info                              717545\n",
       "TVA Québec                              705149\n",
       "Journal L'Express de Drummondville      663918\n",
       "www.lanouvelle.net                      596897\n",
       "Zone économie                           578343\n",
       "Radio-Canada Techno                     542984\n",
       "Radio X - CHOI 98,1                     541661\n",
       "EnBeauce.com                            512952\n",
       "ICI Bas-Saint-Laurent                   505307\n",
       "ICI Gaspésie-Les-Îles                   505268\n",
       "TVA Abitibi-Témiscamingue               485000\n",
       "QUB radio                               456826\n",
       "24 heures                               452698\n",
       "La Terre de chez nous                   446909\n",
       "ICI Côte-Nord                           392401\n",
       "ICI Ottawa Gatineau                     390576\n",
       "URBANIA                                 390409\n",
       "Journal Le Reflet                       375320\n",
       "VINGT 55                                359928\n",
       "Name: inter, dtype: int64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich[medias].groupby(by=[\"Page Name\"]).inter.sum().sort_values(ascending=False).head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "694f5b04",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Page Name\n",
       "45 minutes fois deux                       31943304\n",
       "Les annonces du foot                       28455266\n",
       "Piranha Club                               27986984\n",
       "Deli Cuisine                               27571548\n",
       "Sarra Messan                               23716068\n",
       "Barcelone FCB                              22897169\n",
       "Delucrece E                                16541791\n",
       "Mansour le Guisen                          13439395\n",
       "Mimiche Diabaté officiel                   12560730\n",
       "La Parole Vivante                          12312336\n",
       "Éric Duhaime                               11766890\n",
       "Justin Trudeau                             11684977\n",
       "Hayek Hassan                               11406103\n",
       "Le Magnific                                10772995\n",
       "Bara pro                                   10501533\n",
       "Commandant international224                 9692115\n",
       "Juste pour rire Les Gags                    9083482\n",
       "La parfaite maman cinglante                 8765370\n",
       "Les buzz de Flora                           8497283\n",
       "African Heroes                              8159681\n",
       "Real Maroc                                  7768650\n",
       "Moe L'enjailleur                            7497062\n",
       "Québec FIER                                 6636902\n",
       "Trésors du Monde                            6623708\n",
       "Segano                                      6540363\n",
       "LETICIA NDJASSI                             6435860\n",
       "Anata fooly                                 6425846\n",
       "Les candidats du paradis firdaws            6415196\n",
       "MC Freshh                                   6213751\n",
       "François Legault                            6179313\n",
       "Paikoun Saré Officiel                       5852533\n",
       "FOOT 24/24h                                 5338128\n",
       "Cuisine de Chez Nous                        5277622\n",
       "Gédéon TV                                   5190676\n",
       "K2R Welcome PROD                            5014360\n",
       "Jeune visionnaire Fama                      4871777\n",
       "Spotted Moment bizarre                      4853330\n",
       "Dr Modestine Carole Tchatchouang Yonzou     4749493\n",
       "What If Français                            4657895\n",
       "Les News De Stars Congolaise                4640036\n",
       "Régis Carlo                                 4481234\n",
       "Académie SGS / Arts martiaux Sherbrooke     4346407\n",
       "La vie est belle                            4300923\n",
       "ConneriesQc                                 4158282\n",
       "Mes Jolies Fleurs                           4142572\n",
       "Pantcho le gatair                           4110966\n",
       "Ndock Bidi                                  4090547\n",
       "Djanii Alfa                                 3998304\n",
       "AGI TV Officiel                             3990753\n",
       "HABSolumentFan                              3923176\n",
       "Name: inter, dtype: int64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fich[~medias].groupby(by=[\"Page Name\"]).inter.sum().sort_values(ascending=False).head(50)"
   ]
  }
 ],
 "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
}