Exploratory Data Analysis on YouTube data..ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "62031fa6",
   "metadata": {},
   "source": [
    "# Exploratory Data Analysis on YouTube data."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d1fed71a",
   "metadata": {},
   "source": [
    "# Domain: Social media"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "e00d5b69",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "6026c193",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>video_id</th>\n",
       "      <th>title</th>\n",
       "      <th>channel_id</th>\n",
       "      <th>channel_title</th>\n",
       "      <th>published_at</th>\n",
       "      <th>view_count</th>\n",
       "      <th>likes</th>\n",
       "      <th>dislikes</th>\n",
       "      <th>comment_count</th>\n",
       "      <th>tags</th>\n",
       "      <th>description</th>\n",
       "      <th>comments</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>--0bCF-iK2E</td>\n",
       "      <td>Jadon Sancho  Magical Skills &amp; Goals</td>\n",
       "      <td>UC6UL29enLNe4mqwTfAyeNuw</td>\n",
       "      <td>Bundesliga</td>\n",
       "      <td>2021-07-01 10:00:00</td>\n",
       "      <td>1048888</td>\n",
       "      <td>19515</td>\n",
       "      <td>226</td>\n",
       "      <td>1319</td>\n",
       "      <td>football soccer ftbol alemn Bundesliga season ...</td>\n",
       "      <td>Enjoy the best skills and goals from Jadon San...</td>\n",
       "      <td>Respect to Dortmund fans,must be sad losing hi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>--14w5SOEUs</td>\n",
       "      <td>Migos - Avalanche (Official Video)</td>\n",
       "      <td>UCGIelM2Dj3zza3xyV3pL3WQ</td>\n",
       "      <td>MigosVEVO</td>\n",
       "      <td>2021-06-10 16:00:00</td>\n",
       "      <td>15352638</td>\n",
       "      <td>359277</td>\n",
       "      <td>7479</td>\n",
       "      <td>18729</td>\n",
       "      <td>Migos Avalanche Quality Control Music/Motown R...</td>\n",
       "      <td>Watch the the official video for Migos - \"Aval...</td>\n",
       "      <td>Migos just makes me want to live my live to th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>--40TEbZ9Is</td>\n",
       "      <td>Supporting Actress in a Comedy: 73rd Emmys</td>\n",
       "      <td>UClBKH8yZRcM4AsRjDVEdjMg</td>\n",
       "      <td>Television Academy</td>\n",
       "      <td>2021-09-20 01:03:32</td>\n",
       "      <td>925281</td>\n",
       "      <td>11212</td>\n",
       "      <td>401</td>\n",
       "      <td>831</td>\n",
       "      <td></td>\n",
       "      <td>Hannah Waddingham wins the Emmy for Supporting...</td>\n",
       "      <td>Hannah's energy bursts through any screen. Wel...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>--4tfbSyYDE</td>\n",
       "      <td>JO1'YOUNG (JO1 ver.)' PERFORMANCE VIDEO</td>\n",
       "      <td>UCsmXiDP8S40uBeJYxvyulmA</td>\n",
       "      <td>JO1</td>\n",
       "      <td>2021-03-03 10:00:17</td>\n",
       "      <td>2641597</td>\n",
       "      <td>39131</td>\n",
       "      <td>441</td>\n",
       "      <td>3745</td>\n",
       "      <td>PRODUCE101JAPAN              JO1   TheSTAR STA...</td>\n",
       "      <td>JO1'YOUNG (JO1 ver.)' PERFORMANCE VIDEO\\n\\n---...</td>\n",
       "      <td>youngVer&gt;&lt;  REN is really PERFECT. It's not ju...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>--DKkzWVh-E</td>\n",
       "      <td>Why Retaining Walls Collapse</td>\n",
       "      <td>UCMOqf8ab-42UUQIdVoKwjlQ</td>\n",
       "      <td>Practical Engineering</td>\n",
       "      <td>2021-12-07 13:00:00</td>\n",
       "      <td>715724</td>\n",
       "      <td>32887</td>\n",
       "      <td>367</td>\n",
       "      <td>1067</td>\n",
       "      <td>retaining wall New Jersey highway Direct Conne...</td>\n",
       "      <td>One of the most important (and innocuous) part...</td>\n",
       "      <td>Keep up with all my projects here: https://pr...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      video_id                                       title  \\\n",
       "0  --0bCF-iK2E        Jadon Sancho  Magical Skills & Goals   \n",
       "1  --14w5SOEUs          Migos - Avalanche (Official Video)   \n",
       "2  --40TEbZ9Is  Supporting Actress in a Comedy: 73rd Emmys   \n",
       "3  --4tfbSyYDE     JO1'YOUNG (JO1 ver.)' PERFORMANCE VIDEO   \n",
       "4  --DKkzWVh-E                Why Retaining Walls Collapse   \n",
       "\n",
       "                 channel_id          channel_title         published_at  \\\n",
       "0  UC6UL29enLNe4mqwTfAyeNuw             Bundesliga  2021-07-01 10:00:00   \n",
       "1  UCGIelM2Dj3zza3xyV3pL3WQ              MigosVEVO  2021-06-10 16:00:00   \n",
       "2  UClBKH8yZRcM4AsRjDVEdjMg     Television Academy  2021-09-20 01:03:32   \n",
       "3  UCsmXiDP8S40uBeJYxvyulmA                    JO1  2021-03-03 10:00:17   \n",
       "4  UCMOqf8ab-42UUQIdVoKwjlQ  Practical Engineering  2021-12-07 13:00:00   \n",
       "\n",
       "   view_count   likes  dislikes  comment_count  \\\n",
       "0     1048888   19515       226           1319   \n",
       "1    15352638  359277      7479          18729   \n",
       "2      925281   11212       401            831   \n",
       "3     2641597   39131       441           3745   \n",
       "4      715724   32887       367           1067   \n",
       "\n",
       "                                                tags  \\\n",
       "0  football soccer ftbol alemn Bundesliga season ...   \n",
       "1  Migos Avalanche Quality Control Music/Motown R...   \n",
       "2                                                      \n",
       "3  PRODUCE101JAPAN              JO1   TheSTAR STA...   \n",
       "4  retaining wall New Jersey highway Direct Conne...   \n",
       "\n",
       "                                         description  \\\n",
       "0  Enjoy the best skills and goals from Jadon San...   \n",
       "1  Watch the the official video for Migos - \"Aval...   \n",
       "2  Hannah Waddingham wins the Emmy for Supporting...   \n",
       "3  JO1'YOUNG (JO1 ver.)' PERFORMANCE VIDEO\\n\\n---...   \n",
       "4  One of the most important (and innocuous) part...   \n",
       "\n",
       "                                            comments  \n",
       "0  Respect to Dortmund fans,must be sad losing hi...  \n",
       "1  Migos just makes me want to live my live to th...  \n",
       "2  Hannah's energy bursts through any screen. Wel...  \n",
       "3  youngVer><  REN is really PERFECT. It's not ju...  \n",
       "4   Keep up with all my projects here: https://pr...  "
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data=pd.read_csv(r\"C:\\Users\\shank\\Downloads\\youtube_dislike_dataset.csv\")\n",
    "df=data.copy()\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "30721879",
   "metadata": {},
   "source": [
    "# Q1.Import required libraries and read the provided dataset (youtube_dislike_dataset.csv) and retrieve top 5 and bottom 5 records."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "a9176062",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>video_id</th>\n",
       "      <th>title</th>\n",
       "      <th>channel_id</th>\n",
       "      <th>channel_title</th>\n",
       "      <th>published_at</th>\n",
       "      <th>view_count</th>\n",
       "      <th>likes</th>\n",
       "      <th>dislikes</th>\n",
       "      <th>comment_count</th>\n",
       "      <th>tags</th>\n",
       "      <th>description</th>\n",
       "      <th>comments</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>--0bCF-iK2E</td>\n",
       "      <td>Jadon Sancho  Magical Skills &amp; Goals</td>\n",
       "      <td>UC6UL29enLNe4mqwTfAyeNuw</td>\n",
       "      <td>Bundesliga</td>\n",
       "      <td>2021-07-01 10:00:00</td>\n",
       "      <td>1048888</td>\n",
       "      <td>19515</td>\n",
       "      <td>226</td>\n",
       "      <td>1319</td>\n",
       "      <td>football soccer ftbol alemn Bundesliga season ...</td>\n",
       "      <td>Enjoy the best skills and goals from Jadon San...</td>\n",
       "      <td>Respect to Dortmund fans,must be sad losing hi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>--14w5SOEUs</td>\n",
       "      <td>Migos - Avalanche (Official Video)</td>\n",
       "      <td>UCGIelM2Dj3zza3xyV3pL3WQ</td>\n",
       "      <td>MigosVEVO</td>\n",
       "      <td>2021-06-10 16:00:00</td>\n",
       "      <td>15352638</td>\n",
       "      <td>359277</td>\n",
       "      <td>7479</td>\n",
       "      <td>18729</td>\n",
       "      <td>Migos Avalanche Quality Control Music/Motown R...</td>\n",
       "      <td>Watch the the official video for Migos - \"Aval...</td>\n",
       "      <td>Migos just makes me want to live my live to th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>--40TEbZ9Is</td>\n",
       "      <td>Supporting Actress in a Comedy: 73rd Emmys</td>\n",
       "      <td>UClBKH8yZRcM4AsRjDVEdjMg</td>\n",
       "      <td>Television Academy</td>\n",
       "      <td>2021-09-20 01:03:32</td>\n",
       "      <td>925281</td>\n",
       "      <td>11212</td>\n",
       "      <td>401</td>\n",
       "      <td>831</td>\n",
       "      <td></td>\n",
       "      <td>Hannah Waddingham wins the Emmy for Supporting...</td>\n",
       "      <td>Hannah's energy bursts through any screen. Wel...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>--4tfbSyYDE</td>\n",
       "      <td>JO1'YOUNG (JO1 ver.)' PERFORMANCE VIDEO</td>\n",
       "      <td>UCsmXiDP8S40uBeJYxvyulmA</td>\n",
       "      <td>JO1</td>\n",
       "      <td>2021-03-03 10:00:17</td>\n",
       "      <td>2641597</td>\n",
       "      <td>39131</td>\n",
       "      <td>441</td>\n",
       "      <td>3745</td>\n",
       "      <td>PRODUCE101JAPAN              JO1   TheSTAR STA...</td>\n",
       "      <td>JO1'YOUNG (JO1 ver.)' PERFORMANCE VIDEO\\n\\n---...</td>\n",
       "      <td>youngVer&gt;&lt;  REN is really PERFECT. It's not ju...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>--DKkzWVh-E</td>\n",
       "      <td>Why Retaining Walls Collapse</td>\n",
       "      <td>UCMOqf8ab-42UUQIdVoKwjlQ</td>\n",
       "      <td>Practical Engineering</td>\n",
       "      <td>2021-12-07 13:00:00</td>\n",
       "      <td>715724</td>\n",
       "      <td>32887</td>\n",
       "      <td>367</td>\n",
       "      <td>1067</td>\n",
       "      <td>retaining wall New Jersey highway Direct Conne...</td>\n",
       "      <td>One of the most important (and innocuous) part...</td>\n",
       "      <td>Keep up with all my projects here: https://pr...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      video_id                                       title  \\\n",
       "0  --0bCF-iK2E        Jadon Sancho  Magical Skills & Goals   \n",
       "1  --14w5SOEUs          Migos - Avalanche (Official Video)   \n",
       "2  --40TEbZ9Is  Supporting Actress in a Comedy: 73rd Emmys   \n",
       "3  --4tfbSyYDE     JO1'YOUNG (JO1 ver.)' PERFORMANCE VIDEO   \n",
       "4  --DKkzWVh-E                Why Retaining Walls Collapse   \n",
       "\n",
       "                 channel_id          channel_title         published_at  \\\n",
       "0  UC6UL29enLNe4mqwTfAyeNuw             Bundesliga  2021-07-01 10:00:00   \n",
       "1  UCGIelM2Dj3zza3xyV3pL3WQ              MigosVEVO  2021-06-10 16:00:00   \n",
       "2  UClBKH8yZRcM4AsRjDVEdjMg     Television Academy  2021-09-20 01:03:32   \n",
       "3  UCsmXiDP8S40uBeJYxvyulmA                    JO1  2021-03-03 10:00:17   \n",
       "4  UCMOqf8ab-42UUQIdVoKwjlQ  Practical Engineering  2021-12-07 13:00:00   \n",
       "\n",
       "   view_count   likes  dislikes  comment_count  \\\n",
       "0     1048888   19515       226           1319   \n",
       "1    15352638  359277      7479          18729   \n",
       "2      925281   11212       401            831   \n",
       "3     2641597   39131       441           3745   \n",
       "4      715724   32887       367           1067   \n",
       "\n",
       "                                                tags  \\\n",
       "0  football soccer ftbol alemn Bundesliga season ...   \n",
       "1  Migos Avalanche Quality Control Music/Motown R...   \n",
       "2                                                      \n",
       "3  PRODUCE101JAPAN              JO1   TheSTAR STA...   \n",
       "4  retaining wall New Jersey highway Direct Conne...   \n",
       "\n",
       "                                         description  \\\n",
       "0  Enjoy the best skills and goals from Jadon San...   \n",
       "1  Watch the the official video for Migos - \"Aval...   \n",
       "2  Hannah Waddingham wins the Emmy for Supporting...   \n",
       "3  JO1'YOUNG (JO1 ver.)' PERFORMANCE VIDEO\\n\\n---...   \n",
       "4  One of the most important (and innocuous) part...   \n",
       "\n",
       "                                            comments  \n",
       "0  Respect to Dortmund fans,must be sad losing hi...  \n",
       "1  Migos just makes me want to live my live to th...  \n",
       "2  Hannah's energy bursts through any screen. Wel...  \n",
       "3  youngVer><  REN is really PERFECT. It's not ju...  \n",
       "4   Keep up with all my projects here: https://pr...  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "911f9b55",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>video_id</th>\n",
       "      <th>title</th>\n",
       "      <th>channel_id</th>\n",
       "      <th>channel_title</th>\n",
       "      <th>published_at</th>\n",
       "      <th>view_count</th>\n",
       "      <th>likes</th>\n",
       "      <th>dislikes</th>\n",
       "      <th>comment_count</th>\n",
       "      <th>tags</th>\n",
       "      <th>description</th>\n",
       "      <th>comments</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>37417</th>\n",
       "      <td>zzd4ydafGR0</td>\n",
       "      <td>Lil Tjay - Calling My Phone (feat. 6LACK) [Off...</td>\n",
       "      <td>UCEB4a5o_6KfjxHwNMnmj54Q</td>\n",
       "      <td>Lil Tjay</td>\n",
       "      <td>2021-02-12 05:03:49</td>\n",
       "      <td>120408275</td>\n",
       "      <td>2180780</td>\n",
       "      <td>35871</td>\n",
       "      <td>81360</td>\n",
       "      <td>Lil Tjay Steady Calling My Phone Calling My Ph...</td>\n",
       "      <td>Official video for \"Calling My Phone\" by Lil T...</td>\n",
       "      <td>'DESTINED 2 WIN' OUT NOW !! https://liltjay.ln...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37418</th>\n",
       "      <td>zziBybeSAtw</td>\n",
       "      <td>PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...</td>\n",
       "      <td>UCWJ2lWNubArHWmf3FIHbfcQ</td>\n",
       "      <td>NBA</td>\n",
       "      <td>2021-01-16 05:39:05</td>\n",
       "      <td>2841917</td>\n",
       "      <td>20759</td>\n",
       "      <td>1049</td>\n",
       "      <td>2624</td>\n",
       "      <td>NBA G League Basketball game-0022000187 Lakers...</td>\n",
       "      <td>PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...</td>\n",
       "      <td>Montrezl Harrell is going crazy with the rebou...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37419</th>\n",
       "      <td>zzk09ESX7e0</td>\n",
       "      <td>[MV]  (MAMAMOO) - Where Are We Now</td>\n",
       "      <td>UCuhAUMLzJxlP1W7mEk0_6lA</td>\n",
       "      <td>MAMAMOO</td>\n",
       "      <td>2021-06-02 09:00:10</td>\n",
       "      <td>13346678</td>\n",
       "      <td>720854</td>\n",
       "      <td>4426</td>\n",
       "      <td>90616</td>\n",
       "      <td>MAMAMOO  WAW  WAW MAMAMOO WAW Where Are We Now...</td>\n",
       "      <td>[MV]  (MAMAMOO) - Where Are We Now\\n\\nInstagra...</td>\n",
       "      <td>I honestly do not know why this song hit so ha...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37420</th>\n",
       "      <td>zzmQEb0Em5I</td>\n",
       "      <td>FELLIPE ESCUDERO- Master Podcast  #12</td>\n",
       "      <td>UC8NjnNWMsRqq11NYvHAQb1g</td>\n",
       "      <td>Master Podcast</td>\n",
       "      <td>2020-10-20 20:59:30</td>\n",
       "      <td>252057</td>\n",
       "      <td>19198</td>\n",
       "      <td>1234</td>\n",
       "      <td>1471</td>\n",
       "      <td>master masterpodcast lord lord vinheteiro z z ...</td>\n",
       "      <td>DOCTOR HAIR\\nhttps://www.thedoctorhair.com/?fb...</td>\n",
       "      <td>Foi um prazer passar esta tarde com vocs debat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37421</th>\n",
       "      <td>zzxPZwaA-8w</td>\n",
       "      <td>Gareth Bale brace secures dramatic comeback on...</td>\n",
       "      <td>UCEg25rdRZXg32iwai6N6l0w</td>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>2021-05-23 21:00:31</td>\n",
       "      <td>2252090</td>\n",
       "      <td>34063</td>\n",
       "      <td>868</td>\n",
       "      <td>2004</td>\n",
       "      <td>Spurs Tottenham Hotspur   Tottenham Leicester ...</td>\n",
       "      <td>Two minute highlights from Tottenham Hotspur's...</td>\n",
       "      <td>Thank you Kane for everything you have given t...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          video_id                                              title  \\\n",
       "37417  zzd4ydafGR0  Lil Tjay - Calling My Phone (feat. 6LACK) [Off...   \n",
       "37418  zziBybeSAtw  PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...   \n",
       "37419  zzk09ESX7e0                 [MV]  (MAMAMOO) - Where Are We Now   \n",
       "37420  zzmQEb0Em5I              FELLIPE ESCUDERO- Master Podcast  #12   \n",
       "37421  zzxPZwaA-8w  Gareth Bale brace secures dramatic comeback on...   \n",
       "\n",
       "                     channel_id      channel_title         published_at  \\\n",
       "37417  UCEB4a5o_6KfjxHwNMnmj54Q           Lil Tjay  2021-02-12 05:03:49   \n",
       "37418  UCWJ2lWNubArHWmf3FIHbfcQ                NBA  2021-01-16 05:39:05   \n",
       "37419  UCuhAUMLzJxlP1W7mEk0_6lA            MAMAMOO  2021-06-02 09:00:10   \n",
       "37420  UC8NjnNWMsRqq11NYvHAQb1g     Master Podcast  2020-10-20 20:59:30   \n",
       "37421  UCEg25rdRZXg32iwai6N6l0w  Tottenham Hotspur  2021-05-23 21:00:31   \n",
       "\n",
       "       view_count    likes  dislikes  comment_count  \\\n",
       "37417   120408275  2180780     35871          81360   \n",
       "37418     2841917    20759      1049           2624   \n",
       "37419    13346678   720854      4426          90616   \n",
       "37420      252057    19198      1234           1471   \n",
       "37421     2252090    34063       868           2004   \n",
       "\n",
       "                                                    tags  \\\n",
       "37417  Lil Tjay Steady Calling My Phone Calling My Ph...   \n",
       "37418  NBA G League Basketball game-0022000187 Lakers...   \n",
       "37419  MAMAMOO  WAW  WAW MAMAMOO WAW Where Are We Now...   \n",
       "37420  master masterpodcast lord lord vinheteiro z z ...   \n",
       "37421  Spurs Tottenham Hotspur   Tottenham Leicester ...   \n",
       "\n",
       "                                             description  \\\n",
       "37417  Official video for \"Calling My Phone\" by Lil T...   \n",
       "37418  PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...   \n",
       "37419  [MV]  (MAMAMOO) - Where Are We Now\\n\\nInstagra...   \n",
       "37420  DOCTOR HAIR\\nhttps://www.thedoctorhair.com/?fb...   \n",
       "37421  Two minute highlights from Tottenham Hotspur's...   \n",
       "\n",
       "                                                comments  \n",
       "37417  'DESTINED 2 WIN' OUT NOW !! https://liltjay.ln...  \n",
       "37418  Montrezl Harrell is going crazy with the rebou...  \n",
       "37419  I honestly do not know why this song hit so ha...  \n",
       "37420  Foi um prazer passar esta tarde com vocs debat...  \n",
       "37421  Thank you Kane for everything you have given t...  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bd451c11",
   "metadata": {},
   "source": [
    "# Q2.Check the info of the dataframe and write your inferences on data types and shape of the dataset."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "58220426",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 37422 entries, 0 to 37421\n",
      "Data columns (total 12 columns):\n",
      " #   Column         Non-Null Count  Dtype \n",
      "---  ------         --------------  ----- \n",
      " 0   video_id       37422 non-null  object\n",
      " 1   title          37422 non-null  object\n",
      " 2   channel_id     37422 non-null  object\n",
      " 3   channel_title  37422 non-null  object\n",
      " 4   published_at   37422 non-null  object\n",
      " 5   view_count     37422 non-null  int64 \n",
      " 6   likes          37422 non-null  int64 \n",
      " 7   dislikes       37422 non-null  int64 \n",
      " 8   comment_count  37422 non-null  int64 \n",
      " 9   tags           37422 non-null  object\n",
      " 10  description    37422 non-null  object\n",
      " 11  comments       37264 non-null  object\n",
      "dtypes: int64(4), object(8)\n",
      "memory usage: 3.4+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d989bf1d",
   "metadata": {},
   "source": [
    "In this dataset here I have seen there have two types of datatypes object,int64 and have rows(37422) and columns(12). "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5fe3af4f",
   "metadata": {},
   "source": [
    "# Q3.Check for the Percentage of the missing values and drop or impute them."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "eda9282d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "video_id         0.00\n",
      "title            0.00\n",
      "channel_id       0.00\n",
      "channel_title    0.00\n",
      "published_at     0.00\n",
      "view_count       0.00\n",
      "likes            0.00\n",
      "dislikes         0.00\n",
      "comment_count    0.00\n",
      "tags             0.00\n",
      "description      0.00\n",
      "comments         0.42\n",
      "dtype: float64\n"
     ]
    },
    {
     "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>video_id</th>\n",
       "      <th>title</th>\n",
       "      <th>channel_id</th>\n",
       "      <th>channel_title</th>\n",
       "      <th>published_at</th>\n",
       "      <th>view_count</th>\n",
       "      <th>likes</th>\n",
       "      <th>dislikes</th>\n",
       "      <th>comment_count</th>\n",
       "      <th>tags</th>\n",
       "      <th>description</th>\n",
       "      <th>comments</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>--0bCF-iK2E</td>\n",
       "      <td>Jadon Sancho  Magical Skills &amp; Goals</td>\n",
       "      <td>UC6UL29enLNe4mqwTfAyeNuw</td>\n",
       "      <td>Bundesliga</td>\n",
       "      <td>2021-07-01 10:00:00</td>\n",
       "      <td>1048888</td>\n",
       "      <td>19515</td>\n",
       "      <td>226</td>\n",
       "      <td>1319</td>\n",
       "      <td>football soccer ftbol alemn Bundesliga season ...</td>\n",
       "      <td>Enjoy the best skills and goals from Jadon San...</td>\n",
       "      <td>Respect to Dortmund fans,must be sad losing hi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>--14w5SOEUs</td>\n",
       "      <td>Migos - Avalanche (Official Video)</td>\n",
       "      <td>UCGIelM2Dj3zza3xyV3pL3WQ</td>\n",
       "      <td>MigosVEVO</td>\n",
       "      <td>2021-06-10 16:00:00</td>\n",
       "      <td>15352638</td>\n",
       "      <td>359277</td>\n",
       "      <td>7479</td>\n",
       "      <td>18729</td>\n",
       "      <td>Migos Avalanche Quality Control Music/Motown R...</td>\n",
       "      <td>Watch the the official video for Migos - \"Aval...</td>\n",
       "      <td>Migos just makes me want to live my live to th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>--40TEbZ9Is</td>\n",
       "      <td>Supporting Actress in a Comedy: 73rd Emmys</td>\n",
       "      <td>UClBKH8yZRcM4AsRjDVEdjMg</td>\n",
       "      <td>Television Academy</td>\n",
       "      <td>2021-09-20 01:03:32</td>\n",
       "      <td>925281</td>\n",
       "      <td>11212</td>\n",
       "      <td>401</td>\n",
       "      <td>831</td>\n",
       "      <td></td>\n",
       "      <td>Hannah Waddingham wins the Emmy for Supporting...</td>\n",
       "      <td>Hannah's energy bursts through any screen. Wel...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>--4tfbSyYDE</td>\n",
       "      <td>JO1'YOUNG (JO1 ver.)' PERFORMANCE VIDEO</td>\n",
       "      <td>UCsmXiDP8S40uBeJYxvyulmA</td>\n",
       "      <td>JO1</td>\n",
       "      <td>2021-03-03 10:00:17</td>\n",
       "      <td>2641597</td>\n",
       "      <td>39131</td>\n",
       "      <td>441</td>\n",
       "      <td>3745</td>\n",
       "      <td>PRODUCE101JAPAN              JO1   TheSTAR STA...</td>\n",
       "      <td>JO1'YOUNG (JO1 ver.)' PERFORMANCE VIDEO\\n\\n---...</td>\n",
       "      <td>youngVer&gt;&lt;  REN is really PERFECT. It's not ju...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>--DKkzWVh-E</td>\n",
       "      <td>Why Retaining Walls Collapse</td>\n",
       "      <td>UCMOqf8ab-42UUQIdVoKwjlQ</td>\n",
       "      <td>Practical Engineering</td>\n",
       "      <td>2021-12-07 13:00:00</td>\n",
       "      <td>715724</td>\n",
       "      <td>32887</td>\n",
       "      <td>367</td>\n",
       "      <td>1067</td>\n",
       "      <td>retaining wall New Jersey highway Direct Conne...</td>\n",
       "      <td>One of the most important (and innocuous) part...</td>\n",
       "      <td>Keep up with all my projects here: https://pr...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37417</th>\n",
       "      <td>zzd4ydafGR0</td>\n",
       "      <td>Lil Tjay - Calling My Phone (feat. 6LACK) [Off...</td>\n",
       "      <td>UCEB4a5o_6KfjxHwNMnmj54Q</td>\n",
       "      <td>Lil Tjay</td>\n",
       "      <td>2021-02-12 05:03:49</td>\n",
       "      <td>120408275</td>\n",
       "      <td>2180780</td>\n",
       "      <td>35871</td>\n",
       "      <td>81360</td>\n",
       "      <td>Lil Tjay Steady Calling My Phone Calling My Ph...</td>\n",
       "      <td>Official video for \"Calling My Phone\" by Lil T...</td>\n",
       "      <td>'DESTINED 2 WIN' OUT NOW !! https://liltjay.ln...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37418</th>\n",
       "      <td>zziBybeSAtw</td>\n",
       "      <td>PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...</td>\n",
       "      <td>UCWJ2lWNubArHWmf3FIHbfcQ</td>\n",
       "      <td>NBA</td>\n",
       "      <td>2021-01-16 05:39:05</td>\n",
       "      <td>2841917</td>\n",
       "      <td>20759</td>\n",
       "      <td>1049</td>\n",
       "      <td>2624</td>\n",
       "      <td>NBA G League Basketball game-0022000187 Lakers...</td>\n",
       "      <td>PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...</td>\n",
       "      <td>Montrezl Harrell is going crazy with the rebou...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37419</th>\n",
       "      <td>zzk09ESX7e0</td>\n",
       "      <td>[MV]  (MAMAMOO) - Where Are We Now</td>\n",
       "      <td>UCuhAUMLzJxlP1W7mEk0_6lA</td>\n",
       "      <td>MAMAMOO</td>\n",
       "      <td>2021-06-02 09:00:10</td>\n",
       "      <td>13346678</td>\n",
       "      <td>720854</td>\n",
       "      <td>4426</td>\n",
       "      <td>90616</td>\n",
       "      <td>MAMAMOO  WAW  WAW MAMAMOO WAW Where Are We Now...</td>\n",
       "      <td>[MV]  (MAMAMOO) - Where Are We Now\\n\\nInstagra...</td>\n",
       "      <td>I honestly do not know why this song hit so ha...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37420</th>\n",
       "      <td>zzmQEb0Em5I</td>\n",
       "      <td>FELLIPE ESCUDERO- Master Podcast  #12</td>\n",
       "      <td>UC8NjnNWMsRqq11NYvHAQb1g</td>\n",
       "      <td>Master Podcast</td>\n",
       "      <td>2020-10-20 20:59:30</td>\n",
       "      <td>252057</td>\n",
       "      <td>19198</td>\n",
       "      <td>1234</td>\n",
       "      <td>1471</td>\n",
       "      <td>master masterpodcast lord lord vinheteiro z z ...</td>\n",
       "      <td>DOCTOR HAIR\\nhttps://www.thedoctorhair.com/?fb...</td>\n",
       "      <td>Foi um prazer passar esta tarde com vocs debat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37421</th>\n",
       "      <td>zzxPZwaA-8w</td>\n",
       "      <td>Gareth Bale brace secures dramatic comeback on...</td>\n",
       "      <td>UCEg25rdRZXg32iwai6N6l0w</td>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>2021-05-23 21:00:31</td>\n",
       "      <td>2252090</td>\n",
       "      <td>34063</td>\n",
       "      <td>868</td>\n",
       "      <td>2004</td>\n",
       "      <td>Spurs Tottenham Hotspur   Tottenham Leicester ...</td>\n",
       "      <td>Two minute highlights from Tottenham Hotspur's...</td>\n",
       "      <td>Thank you Kane for everything you have given t...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>37264 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          video_id                                              title  \\\n",
       "0      --0bCF-iK2E               Jadon Sancho  Magical Skills & Goals   \n",
       "1      --14w5SOEUs                 Migos - Avalanche (Official Video)   \n",
       "2      --40TEbZ9Is         Supporting Actress in a Comedy: 73rd Emmys   \n",
       "3      --4tfbSyYDE            JO1'YOUNG (JO1 ver.)' PERFORMANCE VIDEO   \n",
       "4      --DKkzWVh-E                       Why Retaining Walls Collapse   \n",
       "...            ...                                                ...   \n",
       "37417  zzd4ydafGR0  Lil Tjay - Calling My Phone (feat. 6LACK) [Off...   \n",
       "37418  zziBybeSAtw  PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...   \n",
       "37419  zzk09ESX7e0                 [MV]  (MAMAMOO) - Where Are We Now   \n",
       "37420  zzmQEb0Em5I              FELLIPE ESCUDERO- Master Podcast  #12   \n",
       "37421  zzxPZwaA-8w  Gareth Bale brace secures dramatic comeback on...   \n",
       "\n",
       "                     channel_id          channel_title         published_at  \\\n",
       "0      UC6UL29enLNe4mqwTfAyeNuw             Bundesliga  2021-07-01 10:00:00   \n",
       "1      UCGIelM2Dj3zza3xyV3pL3WQ              MigosVEVO  2021-06-10 16:00:00   \n",
       "2      UClBKH8yZRcM4AsRjDVEdjMg     Television Academy  2021-09-20 01:03:32   \n",
       "3      UCsmXiDP8S40uBeJYxvyulmA                    JO1  2021-03-03 10:00:17   \n",
       "4      UCMOqf8ab-42UUQIdVoKwjlQ  Practical Engineering  2021-12-07 13:00:00   \n",
       "...                         ...                    ...                  ...   \n",
       "37417  UCEB4a5o_6KfjxHwNMnmj54Q               Lil Tjay  2021-02-12 05:03:49   \n",
       "37418  UCWJ2lWNubArHWmf3FIHbfcQ                    NBA  2021-01-16 05:39:05   \n",
       "37419  UCuhAUMLzJxlP1W7mEk0_6lA                MAMAMOO  2021-06-02 09:00:10   \n",
       "37420  UC8NjnNWMsRqq11NYvHAQb1g         Master Podcast  2020-10-20 20:59:30   \n",
       "37421  UCEg25rdRZXg32iwai6N6l0w      Tottenham Hotspur  2021-05-23 21:00:31   \n",
       "\n",
       "       view_count    likes  dislikes  comment_count  \\\n",
       "0         1048888    19515       226           1319   \n",
       "1        15352638   359277      7479          18729   \n",
       "2          925281    11212       401            831   \n",
       "3         2641597    39131       441           3745   \n",
       "4          715724    32887       367           1067   \n",
       "...           ...      ...       ...            ...   \n",
       "37417   120408275  2180780     35871          81360   \n",
       "37418     2841917    20759      1049           2624   \n",
       "37419    13346678   720854      4426          90616   \n",
       "37420      252057    19198      1234           1471   \n",
       "37421     2252090    34063       868           2004   \n",
       "\n",
       "                                                    tags  \\\n",
       "0      football soccer ftbol alemn Bundesliga season ...   \n",
       "1      Migos Avalanche Quality Control Music/Motown R...   \n",
       "2                                                          \n",
       "3      PRODUCE101JAPAN              JO1   TheSTAR STA...   \n",
       "4      retaining wall New Jersey highway Direct Conne...   \n",
       "...                                                  ...   \n",
       "37417  Lil Tjay Steady Calling My Phone Calling My Ph...   \n",
       "37418  NBA G League Basketball game-0022000187 Lakers...   \n",
       "37419  MAMAMOO  WAW  WAW MAMAMOO WAW Where Are We Now...   \n",
       "37420  master masterpodcast lord lord vinheteiro z z ...   \n",
       "37421  Spurs Tottenham Hotspur   Tottenham Leicester ...   \n",
       "\n",
       "                                             description  \\\n",
       "0      Enjoy the best skills and goals from Jadon San...   \n",
       "1      Watch the the official video for Migos - \"Aval...   \n",
       "2      Hannah Waddingham wins the Emmy for Supporting...   \n",
       "3      JO1'YOUNG (JO1 ver.)' PERFORMANCE VIDEO\\n\\n---...   \n",
       "4      One of the most important (and innocuous) part...   \n",
       "...                                                  ...   \n",
       "37417  Official video for \"Calling My Phone\" by Lil T...   \n",
       "37418  PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...   \n",
       "37419  [MV]  (MAMAMOO) - Where Are We Now\\n\\nInstagra...   \n",
       "37420  DOCTOR HAIR\\nhttps://www.thedoctorhair.com/?fb...   \n",
       "37421  Two minute highlights from Tottenham Hotspur's...   \n",
       "\n",
       "                                                comments  \n",
       "0      Respect to Dortmund fans,must be sad losing hi...  \n",
       "1      Migos just makes me want to live my live to th...  \n",
       "2      Hannah's energy bursts through any screen. Wel...  \n",
       "3      youngVer><  REN is really PERFECT. It's not ju...  \n",
       "4       Keep up with all my projects here: https://pr...  \n",
       "...                                                  ...  \n",
       "37417  'DESTINED 2 WIN' OUT NOW !! https://liltjay.ln...  \n",
       "37418  Montrezl Harrell is going crazy with the rebou...  \n",
       "37419  I honestly do not know why this song hit so ha...  \n",
       "37420  Foi um prazer passar esta tarde com vocs debat...  \n",
       "37421  Thank you Kane for everything you have given t...  \n",
       "\n",
       "[37264 rows x 12 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "percent_missing=df.isna().mean().round(4)*100\n",
    "print(percent_missing)\n",
    "drop_na=df.dropna()\n",
    "drop_na"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "90efa428",
   "metadata": {},
   "source": [
    "# Q4.Check the statistical summary of both numerical and categorical columns and write your inferences."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "f1fd8dda",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>view_count</th>\n",
       "      <th>likes</th>\n",
       "      <th>dislikes</th>\n",
       "      <th>comment_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>3.742200e+04</td>\n",
       "      <td>3.742200e+04</td>\n",
       "      <td>3.742200e+04</td>\n",
       "      <td>3.742200e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>5.697838e+06</td>\n",
       "      <td>1.668147e+05</td>\n",
       "      <td>4.989862e+03</td>\n",
       "      <td>9.924930e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>2.426622e+07</td>\n",
       "      <td>5.375670e+05</td>\n",
       "      <td>3.070824e+04</td>\n",
       "      <td>1.171003e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>2.036800e+04</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>5.122970e+05</td>\n",
       "      <td>1.323350e+04</td>\n",
       "      <td>2.810000e+02</td>\n",
       "      <td>9.000000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>1.319078e+06</td>\n",
       "      <td>4.233050e+04</td>\n",
       "      <td>7.960000e+02</td>\n",
       "      <td>2.328000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>3.670231e+06</td>\n",
       "      <td>1.304698e+05</td>\n",
       "      <td>2.461750e+03</td>\n",
       "      <td>6.184000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1.322797e+09</td>\n",
       "      <td>3.183768e+07</td>\n",
       "      <td>2.397733e+06</td>\n",
       "      <td>1.607103e+07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         view_count         likes      dislikes  comment_count\n",
       "count  3.742200e+04  3.742200e+04  3.742200e+04   3.742200e+04\n",
       "mean   5.697838e+06  1.668147e+05  4.989862e+03   9.924930e+03\n",
       "std    2.426622e+07  5.375670e+05  3.070824e+04   1.171003e+05\n",
       "min    2.036800e+04  0.000000e+00  0.000000e+00   0.000000e+00\n",
       "25%    5.122970e+05  1.323350e+04  2.810000e+02   9.000000e+02\n",
       "50%    1.319078e+06  4.233050e+04  7.960000e+02   2.328000e+03\n",
       "75%    3.670231e+06  1.304698e+05  2.461750e+03   6.184000e+03\n",
       "max    1.322797e+09  3.183768e+07  2.397733e+06   1.607103e+07"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#statistical summary of numerical variables\n",
    "df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "03f17a17",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>video_id</th>\n",
       "      <th>title</th>\n",
       "      <th>channel_id</th>\n",
       "      <th>channel_title</th>\n",
       "      <th>published_at</th>\n",
       "      <th>tags</th>\n",
       "      <th>description</th>\n",
       "      <th>comments</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>37422</td>\n",
       "      <td>37422</td>\n",
       "      <td>37422</td>\n",
       "      <td>37422</td>\n",
       "      <td>37422</td>\n",
       "      <td>37422</td>\n",
       "      <td>37422</td>\n",
       "      <td>37264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>37422</td>\n",
       "      <td>37113</td>\n",
       "      <td>10961</td>\n",
       "      <td>10883</td>\n",
       "      <td>36772</td>\n",
       "      <td>28799</td>\n",
       "      <td>35630</td>\n",
       "      <td>37264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>--0bCF-iK2E</td>\n",
       "      <td>www</td>\n",
       "      <td>UCNAf1k0yIjyGu3k9BwAg3lg</td>\n",
       "      <td>Sky Sports Football</td>\n",
       "      <td>2020-10-16 04:00:10</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Respect to Dortmund fans,must be sad losing hi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>533</td>\n",
       "      <td>533</td>\n",
       "      <td>6</td>\n",
       "      <td>3817</td>\n",
       "      <td>589</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           video_id  title                channel_id        channel_title  \\\n",
       "count         37422  37422                     37422                37422   \n",
       "unique        37422  37113                     10961                10883   \n",
       "top     --0bCF-iK2E    www  UCNAf1k0yIjyGu3k9BwAg3lg  Sky Sports Football   \n",
       "freq              1     21                       533                  533   \n",
       "\n",
       "               published_at   tags description  \\\n",
       "count                 37422  37422       37422   \n",
       "unique                36772  28799       35630   \n",
       "top     2020-10-16 04:00:10                      \n",
       "freq                      6   3817         589   \n",
       "\n",
       "                                                 comments  \n",
       "count                                               37264  \n",
       "unique                                              37264  \n",
       "top     Respect to Dortmund fans,must be sad losing hi...  \n",
       "freq                                                    1  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#statistical summary of categorical variables\n",
    "df.describe(include=[object])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4322a8d1",
   "metadata": {},
   "source": [
    "above the numerical variables there highest mean value have comment_count column and like columns have highest std values\n",
    "highest max value have dislike column, likes and dislikes columns have strong correlation because their height std values\n",
    "and in categorical variables video_id column have most unique values better then others columns."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1ad222bc",
   "metadata": {},
   "source": [
    "# Q5.Convert datatype of column published_at from object to pandas datetime."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "9aa42958",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "datetime64[ns]\n"
     ]
    }
   ],
   "source": [
    "df['published_at']=pd.to_datetime(df['published_at'])\n",
    "print(df['published_at'].dtypes)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6c690b22",
   "metadata": {},
   "source": [
    "# Q6.Create a new column as 'published_month' using the column published_at (display the months only)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "4fbdbd86",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>video_id</th>\n",
       "      <th>title</th>\n",
       "      <th>channel_id</th>\n",
       "      <th>channel_title</th>\n",
       "      <th>published_at</th>\n",
       "      <th>view_count</th>\n",
       "      <th>likes</th>\n",
       "      <th>dislikes</th>\n",
       "      <th>comment_count</th>\n",
       "      <th>tags</th>\n",
       "      <th>description</th>\n",
       "      <th>comments</th>\n",
       "      <th>published_month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>--0bCF-iK2E</td>\n",
       "      <td>Jadon Sancho  Magical Skills &amp; Goals</td>\n",
       "      <td>UC6UL29enLNe4mqwTfAyeNuw</td>\n",
       "      <td>Bundesliga</td>\n",
       "      <td>2021-07-01 10:00:00</td>\n",
       "      <td>1048888</td>\n",
       "      <td>19515</td>\n",
       "      <td>226</td>\n",
       "      <td>1319</td>\n",
       "      <td>football soccer ftbol alemn Bundesliga season ...</td>\n",
       "      <td>Enjoy the best skills and goals from Jadon San...</td>\n",
       "      <td>Respect to Dortmund fans,must be sad losing hi...</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>--14w5SOEUs</td>\n",
       "      <td>Migos - Avalanche (Official Video)</td>\n",
       "      <td>UCGIelM2Dj3zza3xyV3pL3WQ</td>\n",
       "      <td>MigosVEVO</td>\n",
       "      <td>2021-06-10 16:00:00</td>\n",
       "      <td>15352638</td>\n",
       "      <td>359277</td>\n",
       "      <td>7479</td>\n",
       "      <td>18729</td>\n",
       "      <td>Migos Avalanche Quality Control Music/Motown R...</td>\n",
       "      <td>Watch the the official video for Migos - \"Aval...</td>\n",
       "      <td>Migos just makes me want to live my live to th...</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>--40TEbZ9Is</td>\n",
       "      <td>Supporting Actress in a Comedy: 73rd Emmys</td>\n",
       "      <td>UClBKH8yZRcM4AsRjDVEdjMg</td>\n",
       "      <td>Television Academy</td>\n",
       "      <td>2021-09-20 01:03:32</td>\n",
       "      <td>925281</td>\n",
       "      <td>11212</td>\n",
       "      <td>401</td>\n",
       "      <td>831</td>\n",
       "      <td></td>\n",
       "      <td>Hannah Waddingham wins the Emmy for Supporting...</td>\n",
       "      <td>Hannah's energy bursts through any screen. Wel...</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>--4tfbSyYDE</td>\n",
       "      <td>JO1'YOUNG (JO1 ver.)' PERFORMANCE VIDEO</td>\n",
       "      <td>UCsmXiDP8S40uBeJYxvyulmA</td>\n",
       "      <td>JO1</td>\n",
       "      <td>2021-03-03 10:00:17</td>\n",
       "      <td>2641597</td>\n",
       "      <td>39131</td>\n",
       "      <td>441</td>\n",
       "      <td>3745</td>\n",
       "      <td>PRODUCE101JAPAN              JO1   TheSTAR STA...</td>\n",
       "      <td>JO1'YOUNG (JO1 ver.)' PERFORMANCE VIDEO\\n\\n---...</td>\n",
       "      <td>youngVer&gt;&lt;  REN is really PERFECT. It's not ju...</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>--DKkzWVh-E</td>\n",
       "      <td>Why Retaining Walls Collapse</td>\n",
       "      <td>UCMOqf8ab-42UUQIdVoKwjlQ</td>\n",
       "      <td>Practical Engineering</td>\n",
       "      <td>2021-12-07 13:00:00</td>\n",
       "      <td>715724</td>\n",
       "      <td>32887</td>\n",
       "      <td>367</td>\n",
       "      <td>1067</td>\n",
       "      <td>retaining wall New Jersey highway Direct Conne...</td>\n",
       "      <td>One of the most important (and innocuous) part...</td>\n",
       "      <td>Keep up with all my projects here: https://pr...</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37417</th>\n",
       "      <td>zzd4ydafGR0</td>\n",
       "      <td>Lil Tjay - Calling My Phone (feat. 6LACK) [Off...</td>\n",
       "      <td>UCEB4a5o_6KfjxHwNMnmj54Q</td>\n",
       "      <td>Lil Tjay</td>\n",
       "      <td>2021-02-12 05:03:49</td>\n",
       "      <td>120408275</td>\n",
       "      <td>2180780</td>\n",
       "      <td>35871</td>\n",
       "      <td>81360</td>\n",
       "      <td>Lil Tjay Steady Calling My Phone Calling My Ph...</td>\n",
       "      <td>Official video for \"Calling My Phone\" by Lil T...</td>\n",
       "      <td>'DESTINED 2 WIN' OUT NOW !! https://liltjay.ln...</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37418</th>\n",
       "      <td>zziBybeSAtw</td>\n",
       "      <td>PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...</td>\n",
       "      <td>UCWJ2lWNubArHWmf3FIHbfcQ</td>\n",
       "      <td>NBA</td>\n",
       "      <td>2021-01-16 05:39:05</td>\n",
       "      <td>2841917</td>\n",
       "      <td>20759</td>\n",
       "      <td>1049</td>\n",
       "      <td>2624</td>\n",
       "      <td>NBA G League Basketball game-0022000187 Lakers...</td>\n",
       "      <td>PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...</td>\n",
       "      <td>Montrezl Harrell is going crazy with the rebou...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37419</th>\n",
       "      <td>zzk09ESX7e0</td>\n",
       "      <td>[MV]  (MAMAMOO) - Where Are We Now</td>\n",
       "      <td>UCuhAUMLzJxlP1W7mEk0_6lA</td>\n",
       "      <td>MAMAMOO</td>\n",
       "      <td>2021-06-02 09:00:10</td>\n",
       "      <td>13346678</td>\n",
       "      <td>720854</td>\n",
       "      <td>4426</td>\n",
       "      <td>90616</td>\n",
       "      <td>MAMAMOO  WAW  WAW MAMAMOO WAW Where Are We Now...</td>\n",
       "      <td>[MV]  (MAMAMOO) - Where Are We Now\\n\\nInstagra...</td>\n",
       "      <td>I honestly do not know why this song hit so ha...</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37420</th>\n",
       "      <td>zzmQEb0Em5I</td>\n",
       "      <td>FELLIPE ESCUDERO- Master Podcast  #12</td>\n",
       "      <td>UC8NjnNWMsRqq11NYvHAQb1g</td>\n",
       "      <td>Master Podcast</td>\n",
       "      <td>2020-10-20 20:59:30</td>\n",
       "      <td>252057</td>\n",
       "      <td>19198</td>\n",
       "      <td>1234</td>\n",
       "      <td>1471</td>\n",
       "      <td>master masterpodcast lord lord vinheteiro z z ...</td>\n",
       "      <td>DOCTOR HAIR\\nhttps://www.thedoctorhair.com/?fb...</td>\n",
       "      <td>Foi um prazer passar esta tarde com vocs debat...</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37421</th>\n",
       "      <td>zzxPZwaA-8w</td>\n",
       "      <td>Gareth Bale brace secures dramatic comeback on...</td>\n",
       "      <td>UCEg25rdRZXg32iwai6N6l0w</td>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>2021-05-23 21:00:31</td>\n",
       "      <td>2252090</td>\n",
       "      <td>34063</td>\n",
       "      <td>868</td>\n",
       "      <td>2004</td>\n",
       "      <td>Spurs Tottenham Hotspur   Tottenham Leicester ...</td>\n",
       "      <td>Two minute highlights from Tottenham Hotspur's...</td>\n",
       "      <td>Thank you Kane for everything you have given t...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>37422 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          video_id                                              title  \\\n",
       "0      --0bCF-iK2E               Jadon Sancho  Magical Skills & Goals   \n",
       "1      --14w5SOEUs                 Migos - Avalanche (Official Video)   \n",
       "2      --40TEbZ9Is         Supporting Actress in a Comedy: 73rd Emmys   \n",
       "3      --4tfbSyYDE            JO1'YOUNG (JO1 ver.)' PERFORMANCE VIDEO   \n",
       "4      --DKkzWVh-E                       Why Retaining Walls Collapse   \n",
       "...            ...                                                ...   \n",
       "37417  zzd4ydafGR0  Lil Tjay - Calling My Phone (feat. 6LACK) [Off...   \n",
       "37418  zziBybeSAtw  PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...   \n",
       "37419  zzk09ESX7e0                 [MV]  (MAMAMOO) - Where Are We Now   \n",
       "37420  zzmQEb0Em5I              FELLIPE ESCUDERO- Master Podcast  #12   \n",
       "37421  zzxPZwaA-8w  Gareth Bale brace secures dramatic comeback on...   \n",
       "\n",
       "                     channel_id          channel_title        published_at  \\\n",
       "0      UC6UL29enLNe4mqwTfAyeNuw             Bundesliga 2021-07-01 10:00:00   \n",
       "1      UCGIelM2Dj3zza3xyV3pL3WQ              MigosVEVO 2021-06-10 16:00:00   \n",
       "2      UClBKH8yZRcM4AsRjDVEdjMg     Television Academy 2021-09-20 01:03:32   \n",
       "3      UCsmXiDP8S40uBeJYxvyulmA                    JO1 2021-03-03 10:00:17   \n",
       "4      UCMOqf8ab-42UUQIdVoKwjlQ  Practical Engineering 2021-12-07 13:00:00   \n",
       "...                         ...                    ...                 ...   \n",
       "37417  UCEB4a5o_6KfjxHwNMnmj54Q               Lil Tjay 2021-02-12 05:03:49   \n",
       "37418  UCWJ2lWNubArHWmf3FIHbfcQ                    NBA 2021-01-16 05:39:05   \n",
       "37419  UCuhAUMLzJxlP1W7mEk0_6lA                MAMAMOO 2021-06-02 09:00:10   \n",
       "37420  UC8NjnNWMsRqq11NYvHAQb1g         Master Podcast 2020-10-20 20:59:30   \n",
       "37421  UCEg25rdRZXg32iwai6N6l0w      Tottenham Hotspur 2021-05-23 21:00:31   \n",
       "\n",
       "       view_count    likes  dislikes  comment_count  \\\n",
       "0         1048888    19515       226           1319   \n",
       "1        15352638   359277      7479          18729   \n",
       "2          925281    11212       401            831   \n",
       "3         2641597    39131       441           3745   \n",
       "4          715724    32887       367           1067   \n",
       "...           ...      ...       ...            ...   \n",
       "37417   120408275  2180780     35871          81360   \n",
       "37418     2841917    20759      1049           2624   \n",
       "37419    13346678   720854      4426          90616   \n",
       "37420      252057    19198      1234           1471   \n",
       "37421     2252090    34063       868           2004   \n",
       "\n",
       "                                                    tags  \\\n",
       "0      football soccer ftbol alemn Bundesliga season ...   \n",
       "1      Migos Avalanche Quality Control Music/Motown R...   \n",
       "2                                                          \n",
       "3      PRODUCE101JAPAN              JO1   TheSTAR STA...   \n",
       "4      retaining wall New Jersey highway Direct Conne...   \n",
       "...                                                  ...   \n",
       "37417  Lil Tjay Steady Calling My Phone Calling My Ph...   \n",
       "37418  NBA G League Basketball game-0022000187 Lakers...   \n",
       "37419  MAMAMOO  WAW  WAW MAMAMOO WAW Where Are We Now...   \n",
       "37420  master masterpodcast lord lord vinheteiro z z ...   \n",
       "37421  Spurs Tottenham Hotspur   Tottenham Leicester ...   \n",
       "\n",
       "                                             description  \\\n",
       "0      Enjoy the best skills and goals from Jadon San...   \n",
       "1      Watch the the official video for Migos - \"Aval...   \n",
       "2      Hannah Waddingham wins the Emmy for Supporting...   \n",
       "3      JO1'YOUNG (JO1 ver.)' PERFORMANCE VIDEO\\n\\n---...   \n",
       "4      One of the most important (and innocuous) part...   \n",
       "...                                                  ...   \n",
       "37417  Official video for \"Calling My Phone\" by Lil T...   \n",
       "37418  PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...   \n",
       "37419  [MV]  (MAMAMOO) - Where Are We Now\\n\\nInstagra...   \n",
       "37420  DOCTOR HAIR\\nhttps://www.thedoctorhair.com/?fb...   \n",
       "37421  Two minute highlights from Tottenham Hotspur's...   \n",
       "\n",
       "                                                comments  published_month  \n",
       "0      Respect to Dortmund fans,must be sad losing hi...                7  \n",
       "1      Migos just makes me want to live my live to th...                6  \n",
       "2      Hannah's energy bursts through any screen. Wel...                9  \n",
       "3      youngVer><  REN is really PERFECT. It's not ju...                3  \n",
       "4       Keep up with all my projects here: https://pr...               12  \n",
       "...                                                  ...              ...  \n",
       "37417  'DESTINED 2 WIN' OUT NOW !! https://liltjay.ln...                2  \n",
       "37418  Montrezl Harrell is going crazy with the rebou...                1  \n",
       "37419  I honestly do not know why this song hit so ha...                6  \n",
       "37420  Foi um prazer passar esta tarde com vocs debat...               10  \n",
       "37421  Thank you Kane for everything you have given t...                5  \n",
       "\n",
       "[37422 rows x 13 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['published_month']=df['published_at'].dt.month\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e20531ce",
   "metadata": {},
   "source": [
    "# Q7.Replace the numbers in the column published_month as names of the months i,e., 1 as 'Jan', 2 as 'Feb'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "d7066448",
   "metadata": {},
   "outputs": [],
   "source": [
    "import calendar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "9fa525a9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        Jul\n",
       "1        Jun\n",
       "2        Sep\n",
       "3        Mar\n",
       "4        Dec\n",
       "        ... \n",
       "37417    Feb\n",
       "37418    Jan\n",
       "37419    Jun\n",
       "37420    Oct\n",
       "37421    May\n",
       "Name: published_month2, Length: 37422, dtype: object"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['published_month2']=df.published_month.apply(lambda x:calendar.month_abbr[int(x)])\n",
    "df['published_month2'].columns=['value','month']\n",
    "df['published_month2']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f79dec3d",
   "metadata": {},
   "source": [
    "# Q8.Find the number of videos published each month and arrange the months in a decreasing order based on video count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "3e5ef8b7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>published_month2</th>\n",
       "      <th>video_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Oct</td>\n",
       "      <td>4991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Sep</td>\n",
       "      <td>4880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Nov</td>\n",
       "      <td>4851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Aug</td>\n",
       "      <td>4262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Dec</td>\n",
       "      <td>3072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Jul</td>\n",
       "      <td>2340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Jun</td>\n",
       "      <td>2316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Mar</td>\n",
       "      <td>2258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Feb</td>\n",
       "      <td>2137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Apr</td>\n",
       "      <td>2126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Jan</td>\n",
       "      <td>2108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>May</td>\n",
       "      <td>2081</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   published_month2  video_id\n",
       "0               Oct      4991\n",
       "1               Sep      4880\n",
       "2               Nov      4851\n",
       "3               Aug      4262\n",
       "4               Dec      3072\n",
       "5               Jul      2340\n",
       "6               Jun      2316\n",
       "7               Mar      2258\n",
       "8               Feb      2137\n",
       "9               Apr      2126\n",
       "10              Jan      2108\n",
       "11              May      2081"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby('published_month2')['video_id'].count().sort_values(ascending=False).to_frame().reset_index()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8c87882f",
   "metadata": {},
   "source": [
    "# Q9.Find the count of unique video_id, channel_id and channel_title."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "5478e0c9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "unique video_id: 37422\n",
      "unique channel_id: 10961\n",
      "unique channel_title: 10883\n"
     ]
    }
   ],
   "source": [
    "unique_values1=df['video_id'].nunique()\n",
    "unique_values2=df['channel_id'].nunique()\n",
    "unique_values3=df['channel_title'].nunique()\n",
    "print('unique video_id:', unique_values1)\n",
    "print('unique channel_id:', unique_values2)\n",
    "print('unique channel_title:', unique_values3)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e1ea2ed8",
   "metadata": {},
   "source": [
    "# Q10.Find the top10 channel names having the highest number of videos in the dataset and the bottom10 having lowest number of videos."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "8faedcab",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>video_id</th>\n",
       "      <th>title</th>\n",
       "      <th>channel_id</th>\n",
       "      <th>channel_title</th>\n",
       "      <th>published_at</th>\n",
       "      <th>view_count</th>\n",
       "      <th>likes</th>\n",
       "      <th>dislikes</th>\n",
       "      <th>comment_count</th>\n",
       "      <th>tags</th>\n",
       "      <th>description</th>\n",
       "      <th>comments</th>\n",
       "      <th>published_month</th>\n",
       "      <th>published_month2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>37421</th>\n",
       "      <td>zzxPZwaA-8w</td>\n",
       "      <td>Gareth Bale brace secures dramatic comeback on...</td>\n",
       "      <td>UCEg25rdRZXg32iwai6N6l0w</td>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>2021-05-23 21:00:31</td>\n",
       "      <td>2252090</td>\n",
       "      <td>34063</td>\n",
       "      <td>868</td>\n",
       "      <td>2004</td>\n",
       "      <td>Spurs Tottenham Hotspur   Tottenham Leicester ...</td>\n",
       "      <td>Two minute highlights from Tottenham Hotspur's...</td>\n",
       "      <td>Thank you Kane for everything you have given t...</td>\n",
       "      <td>5</td>\n",
       "      <td>May</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37420</th>\n",
       "      <td>zzmQEb0Em5I</td>\n",
       "      <td>FELLIPE ESCUDERO- Master Podcast  #12</td>\n",
       "      <td>UC8NjnNWMsRqq11NYvHAQb1g</td>\n",
       "      <td>Master Podcast</td>\n",
       "      <td>2020-10-20 20:59:30</td>\n",
       "      <td>252057</td>\n",
       "      <td>19198</td>\n",
       "      <td>1234</td>\n",
       "      <td>1471</td>\n",
       "      <td>master masterpodcast lord lord vinheteiro z z ...</td>\n",
       "      <td>DOCTOR HAIR\\nhttps://www.thedoctorhair.com/?fb...</td>\n",
       "      <td>Foi um prazer passar esta tarde com vocs debat...</td>\n",
       "      <td>10</td>\n",
       "      <td>Oct</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37419</th>\n",
       "      <td>zzk09ESX7e0</td>\n",
       "      <td>[MV]  (MAMAMOO) - Where Are We Now</td>\n",
       "      <td>UCuhAUMLzJxlP1W7mEk0_6lA</td>\n",
       "      <td>MAMAMOO</td>\n",
       "      <td>2021-06-02 09:00:10</td>\n",
       "      <td>13346678</td>\n",
       "      <td>720854</td>\n",
       "      <td>4426</td>\n",
       "      <td>90616</td>\n",
       "      <td>MAMAMOO  WAW  WAW MAMAMOO WAW Where Are We Now...</td>\n",
       "      <td>[MV]  (MAMAMOO) - Where Are We Now\\n\\nInstagra...</td>\n",
       "      <td>I honestly do not know why this song hit so ha...</td>\n",
       "      <td>6</td>\n",
       "      <td>Jun</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37418</th>\n",
       "      <td>zziBybeSAtw</td>\n",
       "      <td>PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...</td>\n",
       "      <td>UCWJ2lWNubArHWmf3FIHbfcQ</td>\n",
       "      <td>NBA</td>\n",
       "      <td>2021-01-16 05:39:05</td>\n",
       "      <td>2841917</td>\n",
       "      <td>20759</td>\n",
       "      <td>1049</td>\n",
       "      <td>2624</td>\n",
       "      <td>NBA G League Basketball game-0022000187 Lakers...</td>\n",
       "      <td>PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...</td>\n",
       "      <td>Montrezl Harrell is going crazy with the rebou...</td>\n",
       "      <td>1</td>\n",
       "      <td>Jan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37417</th>\n",
       "      <td>zzd4ydafGR0</td>\n",
       "      <td>Lil Tjay - Calling My Phone (feat. 6LACK) [Off...</td>\n",
       "      <td>UCEB4a5o_6KfjxHwNMnmj54Q</td>\n",
       "      <td>Lil Tjay</td>\n",
       "      <td>2021-02-12 05:03:49</td>\n",
       "      <td>120408275</td>\n",
       "      <td>2180780</td>\n",
       "      <td>35871</td>\n",
       "      <td>81360</td>\n",
       "      <td>Lil Tjay Steady Calling My Phone Calling My Ph...</td>\n",
       "      <td>Official video for \"Calling My Phone\" by Lil T...</td>\n",
       "      <td>'DESTINED 2 WIN' OUT NOW !! https://liltjay.ln...</td>\n",
       "      <td>2</td>\n",
       "      <td>Feb</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37416</th>\n",
       "      <td>zzYaFc8nzQM</td>\n",
       "      <td>The Champions: Season 4, Episode 4</td>\n",
       "      <td>UClvow1RFSyeh5CRwRB_m5sA</td>\n",
       "      <td>B/R Football</td>\n",
       "      <td>2020-11-30 22:00:10</td>\n",
       "      <td>1523729</td>\n",
       "      <td>70375</td>\n",
       "      <td>1317</td>\n",
       "      <td>2166</td>\n",
       "      <td>br football bleacher report soccer football go...</td>\n",
       "      <td>Dejan Lovren is convinced Virgil van Dijk is h...</td>\n",
       "      <td>The synchronized you never walk alone is actua...</td>\n",
       "      <td>11</td>\n",
       "      <td>Nov</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37415</th>\n",
       "      <td>zzEblS1lEvU</td>\n",
       "      <td>Highlights: Leeds United 1-0 Burnley | Bamford...</td>\n",
       "      <td>UCyQcJHDN4uYfPa1DHzKVSnw</td>\n",
       "      <td>Leeds United Official</td>\n",
       "      <td>2020-12-27 22:00:19</td>\n",
       "      <td>182440</td>\n",
       "      <td>2681</td>\n",
       "      <td>73</td>\n",
       "      <td>217</td>\n",
       "      <td>Leeds United LUFC LUTV marcelo bielsa highlights</td>\n",
       "      <td>Premier League highlights from our 1-0 win ove...</td>\n",
       "      <td>What A Striker This Patrick Bamford is!\\n10 go...</td>\n",
       "      <td>12</td>\n",
       "      <td>Dec</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37414</th>\n",
       "      <td>zyrJ0j7x9-4</td>\n",
       "      <td>FlightReacts Plays NBA 2K21 For The FIRST Time...</td>\n",
       "      <td>UCoGIPQ7M4NWai7LRgRhaSOg</td>\n",
       "      <td>NotYourAverageFlight</td>\n",
       "      <td>2020-08-25 03:45:13</td>\n",
       "      <td>1405603</td>\n",
       "      <td>44261</td>\n",
       "      <td>1522</td>\n",
       "      <td>4419</td>\n",
       "      <td>NBA 2K20 2K NBA NBA 2K20 NBA 2K20 BEST BUILD B...</td>\n",
       "      <td>SMUSH THAT LIKE IF YOU ENJOYED! \\n\\nLETS GET 3...</td>\n",
       "      <td>I like how flight is being considerate of othe...</td>\n",
       "      <td>8</td>\n",
       "      <td>Aug</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37413</th>\n",
       "      <td>zyg837Y0PHA</td>\n",
       "      <td>Guessing Cheap vs Expensive Items Challenge ft...</td>\n",
       "      <td>UCDMHyBFbyJIKFiEwHty-u5Q</td>\n",
       "      <td>Aj Shabeel</td>\n",
       "      <td>2021-08-14 17:00:04</td>\n",
       "      <td>484793</td>\n",
       "      <td>21746</td>\n",
       "      <td>181</td>\n",
       "      <td>660</td>\n",
       "      <td>guessing cheap vs expensive items challenge gu...</td>\n",
       "      <td>I Challenged @Beta Squad  members @Chunkz  and...</td>\n",
       "      <td>AJ face when he clocks man just kept swiping t...</td>\n",
       "      <td>8</td>\n",
       "      <td>Aug</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37412</th>\n",
       "      <td>zyebS_kRoEc</td>\n",
       "      <td>Girl: \"I Play Guitar, Drums, and Bass\" #shorts</td>\n",
       "      <td>UCb5jIJ27Ds32YE6xX3eIO3g</td>\n",
       "      <td>Collaboration Nation</td>\n",
       "      <td>2021-08-18 18:18:39</td>\n",
       "      <td>9062103</td>\n",
       "      <td>682897</td>\n",
       "      <td>8035</td>\n",
       "      <td>6871</td>\n",
       "      <td>ome tv ometv omegle arctic monkeys arctic monk...</td>\n",
       "      <td>Welcome to my loop station/studio! Live loopin...</td>\n",
       "      <td>\"Do you like the Arctic Monkeys?\"\\n\\n\"No\"\\n\\n*...</td>\n",
       "      <td>8</td>\n",
       "      <td>Aug</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          video_id                                              title  \\\n",
       "37421  zzxPZwaA-8w  Gareth Bale brace secures dramatic comeback on...   \n",
       "37420  zzmQEb0Em5I              FELLIPE ESCUDERO- Master Podcast  #12   \n",
       "37419  zzk09ESX7e0                 [MV]  (MAMAMOO) - Where Are We Now   \n",
       "37418  zziBybeSAtw  PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...   \n",
       "37417  zzd4ydafGR0  Lil Tjay - Calling My Phone (feat. 6LACK) [Off...   \n",
       "37416  zzYaFc8nzQM                 The Champions: Season 4, Episode 4   \n",
       "37415  zzEblS1lEvU  Highlights: Leeds United 1-0 Burnley | Bamford...   \n",
       "37414  zyrJ0j7x9-4  FlightReacts Plays NBA 2K21 For The FIRST Time...   \n",
       "37413  zyg837Y0PHA  Guessing Cheap vs Expensive Items Challenge ft...   \n",
       "37412  zyebS_kRoEc     Girl: \"I Play Guitar, Drums, and Bass\" #shorts   \n",
       "\n",
       "                     channel_id          channel_title        published_at  \\\n",
       "37421  UCEg25rdRZXg32iwai6N6l0w      Tottenham Hotspur 2021-05-23 21:00:31   \n",
       "37420  UC8NjnNWMsRqq11NYvHAQb1g         Master Podcast 2020-10-20 20:59:30   \n",
       "37419  UCuhAUMLzJxlP1W7mEk0_6lA                MAMAMOO 2021-06-02 09:00:10   \n",
       "37418  UCWJ2lWNubArHWmf3FIHbfcQ                    NBA 2021-01-16 05:39:05   \n",
       "37417  UCEB4a5o_6KfjxHwNMnmj54Q               Lil Tjay 2021-02-12 05:03:49   \n",
       "37416  UClvow1RFSyeh5CRwRB_m5sA           B/R Football 2020-11-30 22:00:10   \n",
       "37415  UCyQcJHDN4uYfPa1DHzKVSnw  Leeds United Official 2020-12-27 22:00:19   \n",
       "37414  UCoGIPQ7M4NWai7LRgRhaSOg   NotYourAverageFlight 2020-08-25 03:45:13   \n",
       "37413  UCDMHyBFbyJIKFiEwHty-u5Q             Aj Shabeel 2021-08-14 17:00:04   \n",
       "37412  UCb5jIJ27Ds32YE6xX3eIO3g   Collaboration Nation 2021-08-18 18:18:39   \n",
       "\n",
       "       view_count    likes  dislikes  comment_count  \\\n",
       "37421     2252090    34063       868           2004   \n",
       "37420      252057    19198      1234           1471   \n",
       "37419    13346678   720854      4426          90616   \n",
       "37418     2841917    20759      1049           2624   \n",
       "37417   120408275  2180780     35871          81360   \n",
       "37416     1523729    70375      1317           2166   \n",
       "37415      182440     2681        73            217   \n",
       "37414     1405603    44261      1522           4419   \n",
       "37413      484793    21746       181            660   \n",
       "37412     9062103   682897      8035           6871   \n",
       "\n",
       "                                                    tags  \\\n",
       "37421  Spurs Tottenham Hotspur   Tottenham Leicester ...   \n",
       "37420  master masterpodcast lord lord vinheteiro z z ...   \n",
       "37419  MAMAMOO  WAW  WAW MAMAMOO WAW Where Are We Now...   \n",
       "37418  NBA G League Basketball game-0022000187 Lakers...   \n",
       "37417  Lil Tjay Steady Calling My Phone Calling My Ph...   \n",
       "37416  br football bleacher report soccer football go...   \n",
       "37415   Leeds United LUFC LUTV marcelo bielsa highlights   \n",
       "37414  NBA 2K20 2K NBA NBA 2K20 NBA 2K20 BEST BUILD B...   \n",
       "37413  guessing cheap vs expensive items challenge gu...   \n",
       "37412  ome tv ometv omegle arctic monkeys arctic monk...   \n",
       "\n",
       "                                             description  \\\n",
       "37421  Two minute highlights from Tottenham Hotspur's...   \n",
       "37420  DOCTOR HAIR\\nhttps://www.thedoctorhair.com/?fb...   \n",
       "37419  [MV]  (MAMAMOO) - Where Are We Now\\n\\nInstagra...   \n",
       "37418  PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...   \n",
       "37417  Official video for \"Calling My Phone\" by Lil T...   \n",
       "37416  Dejan Lovren is convinced Virgil van Dijk is h...   \n",
       "37415  Premier League highlights from our 1-0 win ove...   \n",
       "37414  SMUSH THAT LIKE IF YOU ENJOYED! \\n\\nLETS GET 3...   \n",
       "37413  I Challenged @Beta Squad  members @Chunkz  and...   \n",
       "37412  Welcome to my loop station/studio! Live loopin...   \n",
       "\n",
       "                                                comments  published_month  \\\n",
       "37421  Thank you Kane for everything you have given t...                5   \n",
       "37420  Foi um prazer passar esta tarde com vocs debat...               10   \n",
       "37419  I honestly do not know why this song hit so ha...                6   \n",
       "37418  Montrezl Harrell is going crazy with the rebou...                1   \n",
       "37417  'DESTINED 2 WIN' OUT NOW !! https://liltjay.ln...                2   \n",
       "37416  The synchronized you never walk alone is actua...               11   \n",
       "37415  What A Striker This Patrick Bamford is!\\n10 go...               12   \n",
       "37414  I like how flight is being considerate of othe...                8   \n",
       "37413  AJ face when he clocks man just kept swiping t...                8   \n",
       "37412  \"Do you like the Arctic Monkeys?\"\\n\\n\"No\"\\n\\n*...                8   \n",
       "\n",
       "      published_month2  \n",
       "37421              May  \n",
       "37420              Oct  \n",
       "37419              Jun  \n",
       "37418              Jan  \n",
       "37417              Feb  \n",
       "37416              Nov  \n",
       "37415              Dec  \n",
       "37414              Aug  \n",
       "37413              Aug  \n",
       "37412              Aug  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values(['video_id','channel_title'],ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7dd43c96",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "55efdee5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>video_id</th>\n",
       "      <th>title</th>\n",
       "      <th>channel_id</th>\n",
       "      <th>channel_title</th>\n",
       "      <th>published_at</th>\n",
       "      <th>view_count</th>\n",
       "      <th>likes</th>\n",
       "      <th>dislikes</th>\n",
       "      <th>comment_count</th>\n",
       "      <th>tags</th>\n",
       "      <th>description</th>\n",
       "      <th>comments</th>\n",
       "      <th>published_month</th>\n",
       "      <th>published_month2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>37412</th>\n",
       "      <td>zyebS_kRoEc</td>\n",
       "      <td>Girl: \"I Play Guitar, Drums, and Bass\" #shorts</td>\n",
       "      <td>UCb5jIJ27Ds32YE6xX3eIO3g</td>\n",
       "      <td>Collaboration Nation</td>\n",
       "      <td>2021-08-18 18:18:39</td>\n",
       "      <td>9062103</td>\n",
       "      <td>682897</td>\n",
       "      <td>8035</td>\n",
       "      <td>6871</td>\n",
       "      <td>ome tv ometv omegle arctic monkeys arctic monk...</td>\n",
       "      <td>Welcome to my loop station/studio! Live loopin...</td>\n",
       "      <td>\"Do you like the Arctic Monkeys?\"\\n\\n\"No\"\\n\\n*...</td>\n",
       "      <td>8</td>\n",
       "      <td>Aug</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37413</th>\n",
       "      <td>zyg837Y0PHA</td>\n",
       "      <td>Guessing Cheap vs Expensive Items Challenge ft...</td>\n",
       "      <td>UCDMHyBFbyJIKFiEwHty-u5Q</td>\n",
       "      <td>Aj Shabeel</td>\n",
       "      <td>2021-08-14 17:00:04</td>\n",
       "      <td>484793</td>\n",
       "      <td>21746</td>\n",
       "      <td>181</td>\n",
       "      <td>660</td>\n",
       "      <td>guessing cheap vs expensive items challenge gu...</td>\n",
       "      <td>I Challenged @Beta Squad  members @Chunkz  and...</td>\n",
       "      <td>AJ face when he clocks man just kept swiping t...</td>\n",
       "      <td>8</td>\n",
       "      <td>Aug</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37414</th>\n",
       "      <td>zyrJ0j7x9-4</td>\n",
       "      <td>FlightReacts Plays NBA 2K21 For The FIRST Time...</td>\n",
       "      <td>UCoGIPQ7M4NWai7LRgRhaSOg</td>\n",
       "      <td>NotYourAverageFlight</td>\n",
       "      <td>2020-08-25 03:45:13</td>\n",
       "      <td>1405603</td>\n",
       "      <td>44261</td>\n",
       "      <td>1522</td>\n",
       "      <td>4419</td>\n",
       "      <td>NBA 2K20 2K NBA NBA 2K20 NBA 2K20 BEST BUILD B...</td>\n",
       "      <td>SMUSH THAT LIKE IF YOU ENJOYED! \\n\\nLETS GET 3...</td>\n",
       "      <td>I like how flight is being considerate of othe...</td>\n",
       "      <td>8</td>\n",
       "      <td>Aug</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37415</th>\n",
       "      <td>zzEblS1lEvU</td>\n",
       "      <td>Highlights: Leeds United 1-0 Burnley | Bamford...</td>\n",
       "      <td>UCyQcJHDN4uYfPa1DHzKVSnw</td>\n",
       "      <td>Leeds United Official</td>\n",
       "      <td>2020-12-27 22:00:19</td>\n",
       "      <td>182440</td>\n",
       "      <td>2681</td>\n",
       "      <td>73</td>\n",
       "      <td>217</td>\n",
       "      <td>Leeds United LUFC LUTV marcelo bielsa highlights</td>\n",
       "      <td>Premier League highlights from our 1-0 win ove...</td>\n",
       "      <td>What A Striker This Patrick Bamford is!\\n10 go...</td>\n",
       "      <td>12</td>\n",
       "      <td>Dec</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37416</th>\n",
       "      <td>zzYaFc8nzQM</td>\n",
       "      <td>The Champions: Season 4, Episode 4</td>\n",
       "      <td>UClvow1RFSyeh5CRwRB_m5sA</td>\n",
       "      <td>B/R Football</td>\n",
       "      <td>2020-11-30 22:00:10</td>\n",
       "      <td>1523729</td>\n",
       "      <td>70375</td>\n",
       "      <td>1317</td>\n",
       "      <td>2166</td>\n",
       "      <td>br football bleacher report soccer football go...</td>\n",
       "      <td>Dejan Lovren is convinced Virgil van Dijk is h...</td>\n",
       "      <td>The synchronized you never walk alone is actua...</td>\n",
       "      <td>11</td>\n",
       "      <td>Nov</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37417</th>\n",
       "      <td>zzd4ydafGR0</td>\n",
       "      <td>Lil Tjay - Calling My Phone (feat. 6LACK) [Off...</td>\n",
       "      <td>UCEB4a5o_6KfjxHwNMnmj54Q</td>\n",
       "      <td>Lil Tjay</td>\n",
       "      <td>2021-02-12 05:03:49</td>\n",
       "      <td>120408275</td>\n",
       "      <td>2180780</td>\n",
       "      <td>35871</td>\n",
       "      <td>81360</td>\n",
       "      <td>Lil Tjay Steady Calling My Phone Calling My Ph...</td>\n",
       "      <td>Official video for \"Calling My Phone\" by Lil T...</td>\n",
       "      <td>'DESTINED 2 WIN' OUT NOW !! https://liltjay.ln...</td>\n",
       "      <td>2</td>\n",
       "      <td>Feb</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37418</th>\n",
       "      <td>zziBybeSAtw</td>\n",
       "      <td>PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...</td>\n",
       "      <td>UCWJ2lWNubArHWmf3FIHbfcQ</td>\n",
       "      <td>NBA</td>\n",
       "      <td>2021-01-16 05:39:05</td>\n",
       "      <td>2841917</td>\n",
       "      <td>20759</td>\n",
       "      <td>1049</td>\n",
       "      <td>2624</td>\n",
       "      <td>NBA G League Basketball game-0022000187 Lakers...</td>\n",
       "      <td>PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...</td>\n",
       "      <td>Montrezl Harrell is going crazy with the rebou...</td>\n",
       "      <td>1</td>\n",
       "      <td>Jan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37419</th>\n",
       "      <td>zzk09ESX7e0</td>\n",
       "      <td>[MV]  (MAMAMOO) - Where Are We Now</td>\n",
       "      <td>UCuhAUMLzJxlP1W7mEk0_6lA</td>\n",
       "      <td>MAMAMOO</td>\n",
       "      <td>2021-06-02 09:00:10</td>\n",
       "      <td>13346678</td>\n",
       "      <td>720854</td>\n",
       "      <td>4426</td>\n",
       "      <td>90616</td>\n",
       "      <td>MAMAMOO  WAW  WAW MAMAMOO WAW Where Are We Now...</td>\n",
       "      <td>[MV]  (MAMAMOO) - Where Are We Now\\n\\nInstagra...</td>\n",
       "      <td>I honestly do not know why this song hit so ha...</td>\n",
       "      <td>6</td>\n",
       "      <td>Jun</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37420</th>\n",
       "      <td>zzmQEb0Em5I</td>\n",
       "      <td>FELLIPE ESCUDERO- Master Podcast  #12</td>\n",
       "      <td>UC8NjnNWMsRqq11NYvHAQb1g</td>\n",
       "      <td>Master Podcast</td>\n",
       "      <td>2020-10-20 20:59:30</td>\n",
       "      <td>252057</td>\n",
       "      <td>19198</td>\n",
       "      <td>1234</td>\n",
       "      <td>1471</td>\n",
       "      <td>master masterpodcast lord lord vinheteiro z z ...</td>\n",
       "      <td>DOCTOR HAIR\\nhttps://www.thedoctorhair.com/?fb...</td>\n",
       "      <td>Foi um prazer passar esta tarde com vocs debat...</td>\n",
       "      <td>10</td>\n",
       "      <td>Oct</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37421</th>\n",
       "      <td>zzxPZwaA-8w</td>\n",
       "      <td>Gareth Bale brace secures dramatic comeback on...</td>\n",
       "      <td>UCEg25rdRZXg32iwai6N6l0w</td>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>2021-05-23 21:00:31</td>\n",
       "      <td>2252090</td>\n",
       "      <td>34063</td>\n",
       "      <td>868</td>\n",
       "      <td>2004</td>\n",
       "      <td>Spurs Tottenham Hotspur   Tottenham Leicester ...</td>\n",
       "      <td>Two minute highlights from Tottenham Hotspur's...</td>\n",
       "      <td>Thank you Kane for everything you have given t...</td>\n",
       "      <td>5</td>\n",
       "      <td>May</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          video_id                                              title  \\\n",
       "37412  zyebS_kRoEc     Girl: \"I Play Guitar, Drums, and Bass\" #shorts   \n",
       "37413  zyg837Y0PHA  Guessing Cheap vs Expensive Items Challenge ft...   \n",
       "37414  zyrJ0j7x9-4  FlightReacts Plays NBA 2K21 For The FIRST Time...   \n",
       "37415  zzEblS1lEvU  Highlights: Leeds United 1-0 Burnley | Bamford...   \n",
       "37416  zzYaFc8nzQM                 The Champions: Season 4, Episode 4   \n",
       "37417  zzd4ydafGR0  Lil Tjay - Calling My Phone (feat. 6LACK) [Off...   \n",
       "37418  zziBybeSAtw  PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...   \n",
       "37419  zzk09ESX7e0                 [MV]  (MAMAMOO) - Where Are We Now   \n",
       "37420  zzmQEb0Em5I              FELLIPE ESCUDERO- Master Podcast  #12   \n",
       "37421  zzxPZwaA-8w  Gareth Bale brace secures dramatic comeback on...   \n",
       "\n",
       "                     channel_id          channel_title        published_at  \\\n",
       "37412  UCb5jIJ27Ds32YE6xX3eIO3g   Collaboration Nation 2021-08-18 18:18:39   \n",
       "37413  UCDMHyBFbyJIKFiEwHty-u5Q             Aj Shabeel 2021-08-14 17:00:04   \n",
       "37414  UCoGIPQ7M4NWai7LRgRhaSOg   NotYourAverageFlight 2020-08-25 03:45:13   \n",
       "37415  UCyQcJHDN4uYfPa1DHzKVSnw  Leeds United Official 2020-12-27 22:00:19   \n",
       "37416  UClvow1RFSyeh5CRwRB_m5sA           B/R Football 2020-11-30 22:00:10   \n",
       "37417  UCEB4a5o_6KfjxHwNMnmj54Q               Lil Tjay 2021-02-12 05:03:49   \n",
       "37418  UCWJ2lWNubArHWmf3FIHbfcQ                    NBA 2021-01-16 05:39:05   \n",
       "37419  UCuhAUMLzJxlP1W7mEk0_6lA                MAMAMOO 2021-06-02 09:00:10   \n",
       "37420  UC8NjnNWMsRqq11NYvHAQb1g         Master Podcast 2020-10-20 20:59:30   \n",
       "37421  UCEg25rdRZXg32iwai6N6l0w      Tottenham Hotspur 2021-05-23 21:00:31   \n",
       "\n",
       "       view_count    likes  dislikes  comment_count  \\\n",
       "37412     9062103   682897      8035           6871   \n",
       "37413      484793    21746       181            660   \n",
       "37414     1405603    44261      1522           4419   \n",
       "37415      182440     2681        73            217   \n",
       "37416     1523729    70375      1317           2166   \n",
       "37417   120408275  2180780     35871          81360   \n",
       "37418     2841917    20759      1049           2624   \n",
       "37419    13346678   720854      4426          90616   \n",
       "37420      252057    19198      1234           1471   \n",
       "37421     2252090    34063       868           2004   \n",
       "\n",
       "                                                    tags  \\\n",
       "37412  ome tv ometv omegle arctic monkeys arctic monk...   \n",
       "37413  guessing cheap vs expensive items challenge gu...   \n",
       "37414  NBA 2K20 2K NBA NBA 2K20 NBA 2K20 BEST BUILD B...   \n",
       "37415   Leeds United LUFC LUTV marcelo bielsa highlights   \n",
       "37416  br football bleacher report soccer football go...   \n",
       "37417  Lil Tjay Steady Calling My Phone Calling My Ph...   \n",
       "37418  NBA G League Basketball game-0022000187 Lakers...   \n",
       "37419  MAMAMOO  WAW  WAW MAMAMOO WAW Where Are We Now...   \n",
       "37420  master masterpodcast lord lord vinheteiro z z ...   \n",
       "37421  Spurs Tottenham Hotspur   Tottenham Leicester ...   \n",
       "\n",
       "                                             description  \\\n",
       "37412  Welcome to my loop station/studio! Live loopin...   \n",
       "37413  I Challenged @Beta Squad  members @Chunkz  and...   \n",
       "37414  SMUSH THAT LIKE IF YOU ENJOYED! \\n\\nLETS GET 3...   \n",
       "37415  Premier League highlights from our 1-0 win ove...   \n",
       "37416  Dejan Lovren is convinced Virgil van Dijk is h...   \n",
       "37417  Official video for \"Calling My Phone\" by Lil T...   \n",
       "37418  PELICANS at LAKERS | FULL GAME HIGHLIGHTS | Ja...   \n",
       "37419  [MV]  (MAMAMOO) - Where Are We Now\\n\\nInstagra...   \n",
       "37420  DOCTOR HAIR\\nhttps://www.thedoctorhair.com/?fb...   \n",
       "37421  Two minute highlights from Tottenham Hotspur's...   \n",
       "\n",
       "                                                comments  published_month  \\\n",
       "37412  \"Do you like the Arctic Monkeys?\"\\n\\n\"No\"\\n\\n*...                8   \n",
       "37413  AJ face when he clocks man just kept swiping t...                8   \n",
       "37414  I like how flight is being considerate of othe...                8   \n",
       "37415  What A Striker This Patrick Bamford is!\\n10 go...               12   \n",
       "37416  The synchronized you never walk alone is actua...               11   \n",
       "37417  'DESTINED 2 WIN' OUT NOW !! https://liltjay.ln...                2   \n",
       "37418  Montrezl Harrell is going crazy with the rebou...                1   \n",
       "37419  I honestly do not know why this song hit so ha...                6   \n",
       "37420  Foi um prazer passar esta tarde com vocs debat...               10   \n",
       "37421  Thank you Kane for everything you have given t...                5   \n",
       "\n",
       "      published_month2  \n",
       "37412              Aug  \n",
       "37413              Aug  \n",
       "37414              Aug  \n",
       "37415              Dec  \n",
       "37416              Nov  \n",
       "37417              Feb  \n",
       "37418              Jan  \n",
       "37419              Jun  \n",
       "37420              Oct  \n",
       "37421              May  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values(['video_id','channel_title'],ascending=True).tail(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4254a68d",
   "metadata": {},
   "source": [
    "# Q11.Find the title of the video which has the maximum number of likes and the title of the video having minimum likes and write your inferences."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "983dffb0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "title\n",
       "BTS () 'Dynamite' Official MV    31837675\n",
       "Name: likes, dtype: int64"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby('title')['likes'].max().sort_values(ascending=False).head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "34a6ca6f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "title\n",
       "Kim Kardashian's Must-See Moments on \"Saturday Night Live\" | E! News    0\n",
       "Name: likes, dtype: int64"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby('title')['likes'].min().sort_values(ascending=True).head(1)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b71644df",
   "metadata": {},
   "source": [
    "used groupby function max(),and sort_values() in dataframe I have got max and min number of title of the video chennel\n",
    "whose have max and min no.of likes name in this dataframe 'Dynamite' Official MV' channel have 31837675 likes and 'Kim Kardashian's Must-See Moments \n",
    "on \"Saturday Night Live\" | E! News' have minimum number of likes 0.So I realized that peoples are likes follows\n",
    "'Dynamite' Official MV' channel."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2803330f",
   "metadata": {},
   "source": [
    "# Q12.Find the title of the video which has the maximum number of dislikes and the title of the video having minimum dislikes and write your inferences."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "2a774ebe",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "title\n",
       "Cuties | Official Trailer | Netflix    2397733\n",
       "Name: dislikes, dtype: int64"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby('title')['dislikes'].max().sort_values(ascending=False).head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "5975c2d9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "title\n",
       "Kim Kardashian's Must-See Moments on \"Saturday Night Live\" | E! News    0\n",
       "Name: dislikes, dtype: int64"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby('title')['dislikes'].min().sort_values(ascending=True).head(1)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fa9594bf",
   "metadata": {},
   "source": [
    "After used groupby,max() and sort_values() in dataframe I got max and min number of title of the video channels name whose \n",
    "have mix and min number of dislike.In this dataframe I got maximun no.of dislike and video title name is Cuties | Official Trailer | Netflix\n",
    "whose have 2397733 dislikes.And other handside 'Kim Kardashian's Must-See Moments on \"Saturday Night Live\" | E! News'\n",
    "whose have minimum of 0 dislike."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bd82da36",
   "metadata": {},
   "source": [
    "# Q13.Does the number of views have any effect on how many people disliked the video? Support your answer with a metric and a plot."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "c0fbc924",
   "metadata": {},
   "outputs": [],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "bf616e5c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Text(0.5, 1.0, 'scatter plot no.of view vs dislikes')"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAjcAAAHFCAYAAAAOmtghAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjcuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/bCgiHAAAACXBIWXMAAA9hAAAPYQGoP6dpAABZ70lEQVR4nO3deVhUZf8/8PdhWEUgQTYBQc0t96UUC8VwNyMRza3M0h5bDDRbTAt5Mr0sNbQyH81ccklFNFMftwSipNIeTUs0c4lFUNEU3FCG+/eHv5kvAzPD7MMc3q8urqs55z5nPnMYz/lwr5IQQoCIiIhIJpzsHQARERGRJTG5ISIiIllhckNERESywuSGiIiIZIXJDREREckKkxsiIiKSFSY3REREJCtMboiIiEhWmNwQERGRrDC5IdLjxIkTmDVrFs6fP19t3/r165GSkmLzmAwlSRJmzZpl9HEXLlzArFmzcPToUYvHZCuffPIJHnzwQbi6ukKSJFy7ds2s882aNQuSJFkmOAcUERGB5557Tv06IyMDkiQhIyPDqPNER0cjOjpaY1vV7+mqVasgSRIOHz5sesBU5zG5IdLjxIkTSE5OdsjkxlQXLlxAcnKywyY3R48exWuvvYbevXvjwIEDyM7OhpeXl1nnnDBhArKzsy0UoePr3LkzsrOz0blzZ7PPlZ2djQkTJlggKqL/42zvAIhI0+3bt+Hh4WHvMBzWH3/8AQCYOHEiHnnkEYucMzQ0FKGhoRY5lxx4e3uje/fuFjmXpc5DVBlrbsihXL58GS+++CLCwsLg5uYGf39/PProo9i/f79Gud27dyMmJgY+Pj6oV68eWrdujblz56r3Hz58GCNHjkRERAQ8PDwQERGBUaNG4e+//1aXWbVqFYYPHw4A6N27NyRJgiRJWLVqFaKjo7Fz5078/fff6u2Vmy3u3r2L2bNno1WrVuo4x48fj8uXL2vEGRERgSeeeAJpaWno1KkT3N3dkZycrPPzR0dHo23btsjKykL37t3h4eGBkJAQvPvuu1AqlTVev99//x2xsbFo0KAB3N3d0bFjR6xevVq9PyMjAw8//DAAYPz48erPpa95S9WMkJ6ejpdeegkNGzaEn58f4uLicOHCBY2yFRUV+PDDD9XXJSAgAM8++yzy8/NrjB0AvvzyS3To0AHu7u7w9fXF0KFDkZOTo3F9xo4dCwDo1q0bJEnSaE6pbNu2bZAkCd999121fZ9//jkkScKxY8cA6G6W2rhxIyIjI+Hp6Yn69eujf//+OHLkiHr/zp07IUkSDh06pN62ZcsWSJKEwYMHa5yrffv2GDZsmM7PnpiYCE9PT5SUlFTb9/TTTyMwMBD37t0DABw4cADR0dHw8/ODh4cHGjdujGHDhuHWrVs6zw8A9+7dw5tvvomgoCDUq1cPjz32GH755Zdq5bQ1S509exYjR45Eo0aN4ObmhsDAQMTExNRYA2hI82lhYSG6dOmC5s2b4/Tp0wCAkpISTJs2DU2aNIGrqytCQkKQmJiImzdvahy7efNmdOvWTX0vaNq0KZ5//nm970cyIIgcSP/+/YW/v79YtmyZyMjIENu2bRPvvfee+Prrr9VlvvjiCyFJkoiOjhbr168X+/fvF0uWLBEvv/yyuszmzZvFe++9J7Zu3SoyMzPF119/LXr16iX8/f3F5cuXhRBCXLp0ScyZM0cAEJ999pnIzs4W2dnZ4tKlS+KPP/4Qjz76qAgKClJvz87OFkIIoVQqxYABA4Snp6dITk4W+/btE1988YUICQkRDz30kLh165Y6jvDwcBEcHCyaNm0qvvzyS5Geni5++eUXnZ+/V69ews/PTzRq1EgsXrxY7NmzR7z22msCgHjllVc0ygIQSUlJ6tcnT54UXl5eolmzZmLNmjVi586dYtSoUQKAmDdvnhBCiOvXr4uVK1cKAGLmzJnqz5WXl6czJlX5pk2bismTJ4s9e/aIL774QjRo0ED07t1bo+yLL74oAIhXX31V7N69WyxdulT4+/uLsLAw9XXXRfW7GDVqlNi5c6dYs2aNaNq0qfDx8RF//vmnEEKIP/74Q8ycOVMAECtXrhTZ2dnir7/+0nq+e/fuiYCAADFmzJhq+x555BHRuXNn9eukpCRR9Xb5wQcfCEmSxPPPPy927Ngh0tLSRGRkpPD09BR//PGHEEKI0tJS4eLiIubMmaM+btKkScLDw0N4enqKu3fvCiGEuHjxopAkSSxZskTn5//tt98EALF8+XKN7f/8849wc3MTU6dOFUIIce7cOeHu7i769u0rtm3bJjIyMsS6devEM888I/755x+d5xdCiHHjxglJksQbb7wh9u7dKxYuXChCQkKEt7e3GDdunLpcenq6ACDS09PV21q2bCkefPBB8dVXX4nMzEyxZcsW8frrr2uU6dWrl+jVq5fGe1b9nqq+T4cOHRJCCHH8+HERFhYmIiMj1d+Rmzdvio4dO4qGDRuKhQsXiv3794tFixYJHx8f8fjjj4uKigohhBAHDx4UkiSJkSNHil27dokDBw6IlStXimeeeUbvdSDHx+SGHEr9+vVFYmKizv2lpaXC29tbPPbYY+obnCHKy8vFjRs3hKenp1i0aJF6++bNm6vdxFUGDx4swsPDq23fsGGDACC2bNmisf3QoUMCgMYDLDw8XCgUCnHq1CmD4uzVq5cAIL755huN7RMnThROTk7i77//Vm+r+tAYOXKkcHNzE7m5uRrHDhw4UNSrV09cu3ZNI86VK1caFJPqYVQ5eRRCiA8//FAAEIWFhUIIIXJycrSW+/nnnwUA8c477+h8j3/++Ud4eHiIQYMGaWzPzc0Vbm5uYvTo0dXiUT0c9Zk6darw8PBQf3YhhDhx4oQAID755BP1tqrJTW5urnB2dhaTJ0/WOF9paakICgoSI0aMUG977LHHxOOPP65+/eCDD4o33nhDODk5iczMTCGEEOvWrRMA1EmaLp07dxY9evTQ2LZkyRIBQBw/flwIIURqaqoAII4ePVrj569M9fuZMmWKxnZVbPqSm+LiYgFApKSk6H0PY5Obffv2CW9vbxEfHy9u376tLjN37lzh5ORU7Xes+uy7du0SQggxf/58AUDj90t1Q51ulvr+++8xZMgQNGrUCJIkYdu2bUafQwiB+fPno0WLFnBzc0NYWBjmzJlj+WAJAPDII49g1apVmD17Nn766Sd1NbzKwYMHUVJSgpdfflnv6JYbN27grbfewoMPPghnZ2c4Ozujfv36uHnzpkYzhyl27NiBBx54AEOGDEF5ebn6p2PHjggKCqo2wqR9+/Zo0aKFwef38vLCk08+qbFt9OjRqKiowPfff6/zuAMHDiAmJgZhYWEa25977jncunXL7A6zVWNq3749AKib+tLT09XvV9kjjzyC1q1ba20eUsnOzsbt27erHRsWFobHH39c77H6PP/887h9+zY2btyo3rZy5Uq4ublh9OjROo/bs2cPysvL8eyzz2r8jt3d3dGrVy+N33FMTAx+/PFH3L59G3///Tf++usvjBw5Eh07dsS+ffsAAPv370fjxo3RvHlzvfGOHz8eBw8exKlTpzTiffjhh9G2bVsAQMeOHeHq6ooXX3wRq1evxtmzZw26Fqrfz5gxYzS2jxgxAs7O+rtn+vr6olmzZvjoo4+wcOFCHDlyBBUVFQa9ry6rV6/GoEGDMGHCBGzatAnu7u7qfTt27EDbtm3RsWNHjevfv39/jeYyVRPriBEjsGnTJhQUFJgVEzmOOp3c3Lx5Ex06dMCnn35q8jkSEhLwxRdfYP78+Th58iS+/fZbi3VipOo2btyIcePG4YsvvkBkZCR8fX3x7LPPoqioCADUfVpq6vw5evRofPrpp5gwYQL27NmDX375BYcOHYK/vz9u375tVowXL17EtWvX4OrqChcXF42foqIiFBcXa5QPDg426vyBgYHVtgUFBQEArly5ovO4K1euaH2vRo0a1XisIfz8/DReu7m5AYD6eqrOryuGmmI39Vh92rRpg4cffhgrV64EACiVSqxduxaxsbHw9fXVedzFixcB3H94Vv0db9y4UeN33KdPH5SVleGHH37Avn370LBhQ3Tq1Al9+vRR9xX77rvv0KdPnxrjHTNmDNzc3LBq1SoA90fzHTp0COPHj1eXadasGfbv34+AgAC88soraNasGZo1a4ZFixbpPbfqGqq+SyrOzs7VfrdVqfou9e/fHx9++CE6d+4Mf39/vPbaaygtLa3xc2nz9ddfw8PDAxMmTKj2h8rFixdx7Nixatfey8sLQgj19e/Zsye2bdumTkRDQ0PRtm1bbNiwwaSYyHHU6dFSAwcOxMCBA3Xuv3v3LmbOnIl169bh2rVraNu2LebNm6eepyEnJweff/45fv/9d7Rs2dJGUddtDRs2REpKClJSUpCbm4vt27fj7bffxqVLl7B79274+/sDgN4OqtevX8eOHTuQlJSEt99+W729rKwMV69etUiMfn5+2L17t9b9VYclGzt/iurBWpkqudP3EPLz80NhYWG17apOvw0bNjQqDmOpYissLKyWfF64cEHv+1c+tqqajq3J+PHj8fLLLyMnJwdnz55FYWGhRrKgjer9UlNTER4errdst27dUL9+fezfvx/nz59HTEwMJElCTEwMFixYgEOHDiE3N9eg5KZBgwaIjY3FmjVrMHv2bKxcuRLu7u4YNWqURrmoqChERUVBqVTi8OHD+OSTT5CYmIjAwECMHDlS67lV17ioqAghISHq7eXl5QYlj+Hh4VixYgUA4M8//8SmTZswa9Ys3L17F0uXLq3x+KrWrVuHd999F7169cLevXvRsWNH9b6GDRvCw8MDX375pdZjK38fYmNjERsbi7KyMvz000+YO3cuRo8ejYiICERGRhodFzmGOl1zU5Px48fjxx9/xNdff41jx45h+PDhGDBggLq3/rfffoumTZtix44daNKkCSIiIjBhwgSLPCCpZo0bN8arr76Kvn374n//+x8AoEePHvDx8cHSpUshhNB6nCRJEEKoaxZUvvjii2ojjqrWPlTdp237E088gStXrkCpVKJr167VfsxNhEtLS7F9+3aNbevXr4eTkxN69uyp87iYmBgcOHCg2gimNWvWoF69euohufo+szkef/xxAMDatWs1th86dAg5OTmIiYnReWxkZCQ8PDyqHZufn69ubjPVqFGj4O7ujlWrVmHVqlUICQlBv3799B7Tv39/ODs748yZM1p/x127dlWXdXFxQc+ePbFv3z4cOHAAffv2BXA/AXF2dsbMmTPVyY4hxo8fjwsXLmDXrl1Yu3Ythg4digceeEBrWYVCgW7duuGzzz4DAPW/E21Uf7StW7dOY/umTZtQXl5uUGwqLVq0wMyZM9GuXTu976mPr68v9u/fj9atW6N379746aef1PueeOIJnDlzBn5+flqvfURERLXzubm5oVevXpg3bx4AaIxqI/mp0zU3+pw5cwYbNmxAfn6+utp+2rRp2L17N1auXIk5c+bg7Nmz+Pvvv7F582asWbMGSqUSU6ZMQXx8PA4cOGDnTyA/169fR+/evTF69Gi0atUKXl5eOHToEHbv3o24uDgAQP369bFgwQJMmDABffr0wcSJExEYGIi//voLv/32Gz799FN4e3ujZ8+e+Oijj9CwYUNEREQgMzMTK1asqPaQUPVjWLZsGby8vODu7o4mTZrAz88P7dq1Q1paGj7//HN06dIFTk5O6Nq1K0aOHIl169Zh0KBBSEhIwCOPPAIXFxfk5+cjPT0dsbGxGDp0qMnXwc/PDy+99BJyc3PRokUL7Nq1C8uXL8dLL72Exo0b6zwuKSkJO3bsQO/evfHee+/B19cX69atw86dO/Hhhx/Cx8cHwP1mDQ8PD6xbtw6tW7dG/fr10ahRI/W/A1O1bNkSL774Ij755BM4OTlh4MCBOH/+PN59912EhYVhypQp6rIxMTHIzMxUP1QfeOABvPvuu3jnnXfw7LPPYtSoUbhy5QqSk5Ph7u6OpKQkk+N64IEHMHToUKxatQrXrl3DtGnT4OSk/+++iIgI/Pvf/8aMGTNw9uxZDBgwAA0aNMDFixfxyy+/wNPTU2NIf0xMDF5//XUAUNfQeHh4oEePHti7dy/at2+PgIAAg+Lt168fQkND8fLLL6OoqKhaLdPSpUtx4MABDB48GI0bN8adO3fUNRz6aodat26NsWPHIiUlBS4uLujTpw9+//13zJ8/H97e3npjOnbsGF599VUMHz4czZs3h6urKw4cOIBjx45p1I4ay8vLS/3vu2/fvti+fTt69+6NxMREbNmyBT179sSUKVPQvn17VFRUIDc3F3v37sXrr7+Obt264b333kN+fj5iYmIQGhqKa9euYdGiRXBxcUGvXr1MjoscgH37M9ceAMTWrVvVrzdt2iQACE9PT40fZ2dn9UiIiRMnCgAaI11+/fVXAUCcPHnS1h9B9u7cuSMmTZok2rdvL7y9vYWHh4do2bKlSEpKEjdv3tQou2vXLtGrVy/h6ekp6tWrJx566CH1cGchhMjPzxfDhg0TDRo0EF5eXmLAgAHi999/F+Hh4RqjQoQQIiUlRTRp0kQoFAqNUURXr14V8fHx4oEHHhCSJGmMprl3756YP3++6NChg3B3dxf169cXrVq1Ev/617/E6dOn1eXCw8PF4MGDDb4GvXr1Em3atBEZGRmia9euws3NTQQHB4t33nlH3Lt3T6MsqoxCEeL+sNohQ4YIHx8f4erqKjp06KB1VNSGDRtEq1athIuLi9bzVKZrdJK24cJKpVLMmzdPtGjRQri4uIiGDRuKsWPHVhtqrhoVVtUXX3wh2rdvL1xdXYWPj4+IjY1VD7uuKR599u7dKwDoHLGkbSi4EEJs27ZN9O7dW3h7ews3NzcRHh4u4uPjxf79+zXKqYZxN2/eXGP7Bx98IACoh3Eb6p133hEARFhYmFAqlRr7srOzxdChQ0V4eLhwc3MTfn5+olevXmL79u01nresrEy8/vrrIiAgQLi7u4vu3buL7Ozsav8uqv5uL168KJ577jnRqlUr4enpKerXry/at28vPv74Y1FeXq4+zpSh4Kq4hg0bJtzd3cXOnTuFEELcuHFDzJw5U7Rs2VL9fWjXrp2YMmWKKCoqEkIIsWPHDjFw4EAREhIiXF1dRUBAgBg0aJDIysoy5DKTA5OE0FF3X8dIkoStW7fiqaeeAnC/4+qYMWPwxx9/QKFQaJStX78+goKCkJSUhDlz5miM2Ll9+zbq1auHvXv3qqufiSwlOjoaxcXF+P333+0dChFRrcVmKR06deoEpVKJS5cuISoqSmuZRx99FOXl5Thz5gyaNWsG4H5HOgA1djIkIiIi66jTyc2NGzfw119/qV+fO3cOR48eha+vL1q0aIExY8bg2WefxYIFC9CpUycUFxfjwIEDaNeuHQYNGoQ+ffqgc+fOeP7555GSkoKKigq88sor6Nu3r1HzlhAREZHl1OlmqYyMDPTu3bva9nHjxmHVqlW4d+8eZs+ejTVr1qCgoAB+fn6IjIxEcnIy2rVrB+D+MNTJkydj79698PT0xMCBA7FgwQK9c2QQERGR9dTp5IaIiIjkh/PcEBERkazYNbmZO3cuHn74YXh5eSEgIABPPfWUxpop2mRkZECSpGo/J0+etFHUREREVJvZtUNxZmYmXnnlFTz88MMoLy/HjBkz0K9fP5w4cQKenp56jz116pTGxFKqafdrUlFRgQsXLsDLy8voae+JiIjIPoQQKC0tRaNGjWqcaLNW9bm5fPkyAgICkJmZqXMaeVUn4H/++UfnlOP65OfnV1sVmYiIiBxDXl5ejYsj16qh4NevXwcAg0YaderUCXfu3MFDDz2EmTNnah31BNxfDLGsrEz9WpXL5eXl1TilOBEREdUOJSUlCAsLq7b4sDa1JrkRQmDq1Kl47LHH1Ov5aBMcHIxly5ahS5cuKCsrw1dffYWYmBhkZGRore2ZO3euxhovKt7e3kxuiIiIHIwhXUpqTbPUK6+8gp07d+KHH36osbqpqiFDhkCSpGorJQPVa25Umd/169eZ3BARETmIkpIS+Pj4GPT8rhVDwSdPnozt27cjPT3d6MQGALp3747Tp09r3efm5qaupWFtDRERkfzZtVlKCIHJkydj69atyMjIQJMmTUw6z5EjRxAcHGzh6IiIiMgR2TW5eeWVV7B+/Xp888038PLyQlFREQDAx8cHHh4eAIDp06ejoKAAa9asAQCkpKQgIiICbdq0wd27d7F27Vps2bIFW7ZssdvnICIiotrDrsnN559/DgCIjo7W2L5y5Uo899xzAIDCwkLk5uaq9929exfTpk1DQUEBPDw80KZNG+zcuRODBg2yVdhERERUi9WaDsW2YkyHJCIiIqodHK5DMREREZGlMLkhIiIiWWFyQ0RERLJSa2YolitlhRJZuVkoLC1EsFcwohpHQeGksHdYREREssXkxorSctKQsDsB+SX56m2h3qFYNGAR4lrH2TEyIiIi+WKzlJWk5aQhflO8RmIDAAUlBYjfFI+0nDQ7RUZERCRvTG6sQFmhRMLuBAhUH2Wv2pa4OxHKCqWtQyMiIpI9JjdWkJWbVa3GpjIBgbySPGTlZtkwKiIiorqByY0VFJYWWrQcERERGY7JjRUEexm2iKeh5YiIiMhwTG6sIKpxFEK9QyFB0rpfgoQw7zBENY6ycWRERETyx+TGChROCiwasAgAqiU4qtcpA1I43w0REZEVMLmxkrjWcUgdkYoQ7xCN7aHeoUgdkcp5boiIiKyEq4JbGWcoJiIiMp8xz2/OUGxlCicFoiOi7R0GERFRncFmKSIiIpIVJjdEREQkK0xuiIiISFaY3BAREZGsMLkhIiIiWWFyQ0RERLLC5IaIiIhkhckNERERyQqTGyIiIpIVJjdEREQkK0xuiIiISFaY3BAREZGsMLkhIiIiWWFyQ0RERLLC5IaIiIhkhckNERERyQqTGyIiIpIVJjdEREQkK0xuiIiISFaY3BAREZGsMLkhIiIiWWFyQ0RERLLC5IaIiIhkhckNERERyQqTGyIiIpIVJjdEREQkK0xuiIiISFaY3BAREZGsMLkhIiIiWWFyQ0RERLLC5IaIiIhkhckNERERyQqTGyIiIpIVJjdEREQkK0xuiIiISFaY3BAREZGsMLkhIiIiWWFyQ0RERLLC5IaIiIhkhckNERERyQqTGyIiIpIVJjdEREQkK0xuiIiISFaY3BAREZGs2DW5mTt3Lh5++GF4eXkhICAATz31FE6dOlXjcZmZmejSpQvc3d3RtGlTLF261AbREhERkSOwa3KTmZmJV155BT/99BP27duH8vJy9OvXDzdv3tR5zLlz5zBo0CBERUXhyJEjeOedd/Daa69hy5YtNoyciIiIaitJCCHsHYTK5cuXERAQgMzMTPTs2VNrmbfeegvbt29HTk6OetukSZPw22+/ITs7u8b3KCkpgY+PD65fvw5vb2+LxU5ERETWY8zzu1b1ubl+/ToAwNfXV2eZ7Oxs9OvXT2Nb//79cfjwYdy7d8+q8REREVHt52zvAFSEEJg6dSoee+wxtG3bVme5oqIiBAYGamwLDAxEeXk5iouLERwcrLGvrKwMZWVl6tclJSWWDZyIiIhqlVpTc/Pqq6/i2LFj2LBhQ41lJUnSeK1qWau6HbjfadnHx0f9ExYWZpmAiYiIqFaqFcnN5MmTsX37dqSnpyM0NFRv2aCgIBQVFWlsu3TpEpydneHn51et/PTp03H9+nX1T15enkVjJyIiotrFrs1SQghMnjwZW7duRUZGBpo0aVLjMZGRkfj22281tu3duxddu3aFi4tLtfJubm5wc3OzWMxERERUu9m15uaVV17B2rVrsX79enh5eaGoqAhFRUW4ffu2usz06dPx7LPPql9PmjQJf//9N6ZOnYqcnBx8+eWXWLFiBaZNm2aPj0BERES1jF2Tm88//xzXr19HdHQ0goOD1T8bN25UlyksLERubq76dZMmTbBr1y5kZGSgY8eOeP/997F48WIMGzbMHh+BiIiIaplaNc+NLXCeGyIiIsfjsPPcEBEREZmLyQ0RERHJCpMbIiIikhUmN0RERCQrTG6IiIhIVpjcEBERkawwuSEiIiJZYXJDREREssLkhoiIiGSFyQ0RERHJCpMbIiIikhUmN0RERCQrTG6IiIhIVpjcEBERkawwuSEiIiJZcbZ3AERERCQPygolsnKzUFhaiGCvYEQ1joLCSWHzOJjcEBERkdnSctKQsDsB+SX56m2h3qFYNGAR4lrH2TQWNksRERGRWdJy0hC/KV4jsQGAgpICxG+KR1pOmk3jYXJDREREJlNWKJGwOwECoto+1bbE3YlQVihtFhOTGyIiIjJZVm5WtRqbygQE8krykJWbZbOYmNwQERGRyQpLCy1azhKY3BAREZHJgr2CLVrOEpjcEBERkcmiGkch1DsUEiSt+yVICPMOQ1TjKJvFxOSGiIiITKZwUmDRgEUAUC3BUb1OGZBi0/lumNwQERGRWeJaxyF1RCpCvEM0tod6hyJ1RKrN57mRhBDVx27JWElJCXx8fHD9+nV4e3vbOxwiIiLZsOYMxcY8vzlDMREREVmEwkmB6Ihoe4fBZikiIiKSFyY3REREJCtMboiIiEhWmNwQERGRrDC5ISIiIllhckNERESywuSGiIiIZIXJDREREckKkxsiIiKSFSY3REREJCtMboiIiEhWmNwQERGRrDC5ISIiIllhckNERESywuSGiIiIZIXJDREREckKkxsiIiKSFSY3REREJCtMboiIiEhWmNwQERGRrDC5ISIiIllhckNERESywuSGiIiIZIXJDREREckKkxsiIiKSFSY3REREJCtMboiIiEhWmNwQERGRrDC5ISIiIllhckNERESywuSGiIiIZIXJDREREcmKXZOb77//HkOGDEGjRo0gSRK2bdumt3xGRgYkSar2c/LkSdsETERERLWesz3f/ObNm+jQoQPGjx+PYcOGGXzcqVOn4O3trX7t7+9vjfCIiIjIAdk1uRk4cCAGDhxo9HEBAQF44IEHLB8QEREROTyH7HPTqVMnBAcHIyYmBunp6fYOh4iIiGoRu9bcGCs4OBjLli1Dly5dUFZWhq+++goxMTHIyMhAz549tR5TVlaGsrIy9euSkhJbhUtERER24FDJTcuWLdGyZUv168jISOTl5WH+/Pk6k5u5c+ciOTnZViESERGRnTlks1Rl3bt3x+nTp3Xunz59Oq5fv67+ycvLs2F0REREZGsOVXOjzZEjRxAcHKxzv5ubG9zc3GwYEREREdmTXZObGzdu4K+//lK/PnfuHI4ePQpfX180btwY06dPR0FBAdasWQMASElJQUREBNq0aYO7d+9i7dq12LJlC7Zs2WKvj0BERES1jF2Tm8OHD6N3797q11OnTgUAjBs3DqtWrUJhYSFyc3PV++/evYtp06ahoKAAHh4eaNOmDXbu3IlBgwbZPHYiIiKqnSQhhLB3ELZUUlICHx8fXL9+XWMiQCIiIqq9jHl+O3yHYiIiIqLKmNwQERGRrDC5ISIiIllhckNERESywuSGiIiIZIXJDREREckKkxsiIiKSFSY3REREJCtMboiIiEhWmNwQERGRrDC5ISIiIllhckNERESyYtdVwYmoOmWFElm5WSgsLUSwVzCiGkdB4aSwd1hERA7DIsmNUqnE8ePHER4ejgYNGljilER1UlpOGhJ2JyC/JF+9LdQ7FIsGLEJc6zg7RkZE5DhMapZKTEzEihUrANxPbHr16oXOnTsjLCwMGRkZloyPqM5Iy0lD/KZ4jcQGAApKChC/KR5pOWl2ioyIyLGYlNykpqaiQ4cOAIBvv/0W586dw8mTJ5GYmIgZM2ZYNECiukBZoUTC7gQIiGr7VNsSdydCWaG0dWhERA7HpOSmuLgYQUFBAIBdu3Zh+PDhaNGiBV544QUcP37cogES1QVZuVnVamwqExDIK8lDVm6WDaMiInJMJiU3gYGBOHHiBJRKJXbv3o0+ffoAAG7dugWFgh0fiYxVWFpo0XJERHWZSR2Kx48fjxEjRiA4OBiSJKFv374AgJ9//hmtWrWyaIBEdUGwV7BFyxER1WUmJTezZs1C27ZtkZeXh+HDh8PNzQ0AoFAo8Pbbb1s0QKK6IKpxFEK9Q1FQUqC1340ECaHeoYhqHGWH6IiIHIskhKh+JzXCnTt34O7ubql4rK6kpAQ+Pj64fv06vL297R0OkZpqtBQAjQRHggQASB2RyuHgRFRnGfP8NqnPjVKpxPvvv4+QkBDUr18fZ8+eBQC8++676iHiRGScuNZxSB2RihDvEI3tod6hTGyIiIxgUrPUBx98gNWrV+PDDz/ExIkT1dvbtWuHjz/+GC+88ILFAiSqS+JaxyG2ZSxnKCYim5LbzOgmJTdr1qzBsmXLEBMTg0mTJqm3t2/fHidPnrRYcER1kcJJgeiIaHuH4fDkdrMmshY5zoxuUnJTUFCABx98sNr2iooK3Lt3z+ygiIjMIcebNZE1qPr6VR3IoJoZ3VGbxE3qc9OmTRtkZVWfTGzz5s3o1KmT2UEREZmKy1gQGUbOM6ObVHOTlJSEZ555BgUFBaioqEBaWhpOnTqFNWvWYMeOHZaOkYjIIDXdrCVISNydiNiWsWyiojrPmJnRHa2p3KSamyFDhmDjxo3YtWsXJEnCe++9h5ycHHz77bfqCf2IqDplhRIZ5zOw4fgGZJzPcMi/iGozLmNBZDg5z4xuUs1NXl4e+vfvj/79+1fb99NPP6F79+5mB0YkN+wHYn1yvlkTWZqcZ0Y3qeamb9++uHLlSrXtP/74IwYMGGB2UERyw34gtiHnmzWRpalmRldNFFqVBAlh3mEOOTO6SclNVFQU+vXrh9LSUvW277//HoMGDUJSUpLFgiOSAzl32qtt5HyzJrI0hZMCiwYsAoBq/2ZUr1MGpDhk/zSTkptly5ahSZMmGDx4MO7cuYP09HQMHjwY//73vzFlyhRLx0jk0NgPxHbkfLMmsga5zoxuUp8bSZKwYcMGDB48GDExMTh27Bjmzp2LV1991dLxETk89gOxLdXNWlv/ppQBKQ57syayFjnOjG5wcnPs2LFq25KSkjBq1CiMHTsWPXv2VJdp37695SIkcnDsB2J7crxZE1mT3GZGN3hVcCcnJ0iShMrFK79W/b8kSVAqa2/fAa4KTramrFAiYlEECkoKtPa7kSAh1DsU5xLO8eFLRKSDMc9vg2tuzp07Z3ZgRHWRqh9I/KZ4SJA0Ehz2AyEisjyDk5vw8HBrxkEka+wHQkRkOwY3S23fvh0DBw6Ei4sLtm/frrfsk08+aZHgrIHNUmRPXKmaiMg0xjy/jepzU1RUhICAADg56R5Bzj43REREZGlW6XNTUVGh9f+JiIiIahOTJvEjIiIiqq0MrrlZvHixwSd97bXXTAqGiIiIyFwG97lp0qSJYSeUJJw9e9asoKyJfW6IiIgcD+e5ISIiojrLIn1ulEoljh49in/++ccSpyMiIiIymUnJTWJiIlasWAHgfmLTs2dPdO7cGWFhYcjIyLBkfERERERGMSm5SU1NRYcOHQAA3377Lc6fP4+TJ08iMTERM2bMsGiARERERMYwKbkpLi5GUFAQAGDXrl0YPnw4WrRogRdeeAHHjx+3aIBERERExjApuQkMDMSJEyegVCqxe/du9OnTBwBw69YtKBScSp6IiIjsx+DRUpWNHz8eI0aMQHBwMCRJQt++fQEAP//8M1q1amXRAImIiIiMYVJyM2vWLLRt2xZ5eXkYPnw43NzcAAAKhQJvv/22RQMkIiIiMobBk/jJBSfxIyIicjxWmcRv8eLFePHFF+Hu7l7jUgxcfoGIiIjsxajlFw4fPgw/Pz+9SzFw+QUiIiKyNKsvv8ClGIiIiKi2Mji5mTp1qkHlJEnCggULTA6IiIiIyBwGJzdHjhzReP3rr79CqVSiZcuWAIA///wTCoUCXbp0sWyEREREREYwOLlJT09X///ChQvh5eWF1atXo0GDBgCAf/75B+PHj0dUVJTloyQiIiIykElDwUNCQrB37160adNGY/vvv/+Ofv364cKFCxYL0NLYoZiIiMjxGPP8Nmn5hZKSEly8eLHa9kuXLqG0tNSUUxIRERFZhEnJzdChQzF+/HikpqYiPz8f+fn5SE1NxQsvvIC4uDiDz/P9999jyJAhaNSoESRJwrZt22o8JjMzE126dIG7uzuaNm2KpUuXmvIRiIiISKZMSm6WLl2KwYMHY+zYsQgPD0d4eDjGjBmDgQMHYsmSJQaf5+bNm+jQoQM+/fRTg8qfO3cOgwYNQlRUFI4cOYJ33nkHr732GrZs2WLKxyAiIiIZMmv5hZs3b+LMmTMQQuDBBx+Ep6en6YFIErZu3YqnnnpKZ5m33noL27dvR05OjnrbpEmT8NtvvyE7O9ug92GfGyIiIsdjlUn8tPH09ET79u3NOYVRsrOz0a9fP41t/fv3x4oVK3Dv3j24uLhUO6asrAxlZWXq1yUlJVaPk4iIiOzHpGYpeykqKkJgYKDGtsDAQJSXl6O4uFjrMXPnzoWPj4/6JywszBahEhERkZ04VHID3G++qkzVqlZ1u8r06dNx/fp19U9eXp7VYyQiIiL7MatZytaCgoJQVFSkse3SpUtwdnaGn5+f1mPc3Nzg5uZmi/CIiIioFnCompvIyEjs27dPY9vevXvRtWtXrf1tiIiIqO6xa3Jz48YNHD16FEePHgVwf6j30aNHkZubC+B+k9Kzzz6rLj9p0iT8/fffmDp1KnJycvDll19ixYoVmDZtmj3CJyIiolrIrs1Shw8fRu/evdWvVSuPjxs3DqtWrUJhYaE60QGAJk2aYNeuXZgyZQo+++wzNGrUCIsXL8awYcNsHjsRERHVTmbNc+OIOM8NERGR47H62lJEREREtRWTGyIiIpIVJjdEREQkK0xuiIiISFaY3BAREZGsMLkhIiIiWWFyQ0RERLLC5IaIiIhkhckNERERyQqTGyIiIpIVJjdEREQkK0xuiIiISFaY3BAREZGsMLkhIiIiWWFyQ0RERLLibO8AiGozZYUSWblZKCwtRLBXMKIaR0HhpLB3WEREpAeTGyId0nLSkLA7Afkl+eptod6hWDRgEeJax9kxMiIi0ofNUkRapOWkIX5TvEZiAwAFJQWI3xSPtJw0O0VGREQ1YXJDVIWyQomE3QkQENX2qbYl7k6EskJp69CIiMgATG6IqsjKzapWY1OZgEBeSR6ycrNsGBURERmKyQ1RFYWlhRYtR0REtsXkhqiKYK9gi5YjIiLbYnJDVEVU4yiEeodCgqR1vwQJYd5hiGocZePIiIjIEExuiKpQOCmwaMAiAKiW4KhepwxI4Xw3RES1FJMbIi3iWschdUQqQrxDNLaHeocidUQq57khIqrFJCFE9fGuMlZSUgIfHx9cv34d3t7e9g6HajnOUExEVDsY8/zmDMVUJ5iapCicFIiOiLZ+gEREZDFMbkj2uIwCEVHdwj43JGtcRoGIqO5hckOyxWUUiIjqJiY3JFtcRoGIqG5ickOyxWUUiIjqJiY3JFtcRoGIqG5ickOyxWUUiIjqJiY3JFtcRoGIqG5ickOyxmUUiIjqHi6/QHUCl1EgInJsXH6BqAouo0BEVHcwuSGLYy0JERHZE5Mbsiiu40RERPbGDsVkMVzHiYiIagPW3JBF1LSOkwQJibsTEdsyVmsTVW1qyqpNsRARkfGY3JDZlBVKfPLLJwav41S1Y29tasqqTbEQEZFp2CxFZknLSUPEoghM2TPFoPJV13GqTU1ZtSkWIiIyHZMbMpmuZECf01dPq/+/pqYsAEjcnQhlhdL8YGtQm2IhIiLzsFmKTKIvGdDnk58/QbMGzRDiHQJlhdLkpixLy8rNqjWxEBGReZjckElqSgZ0Kb5djLFbxwIAfD18DTqmalOWNRj6HraIhYiIzMNmKTKJJR7yV29fNahcsFew2e9lqfewRSxERGQeJjdkEls85CVICPMOQ1TjKKu/V1TjKIR6h1ZbPdwesRARkXmY3NQBygolMs5nYMPxDcg4n2GRTrE1JQPmUp13Qb8FyMrNsmjs2iicFFg0YJHGe1eNJWVACue7ISJyAFwVXOasOW+LarQUAKM7Flfl6+Gr0UwV5h2GkW1HYsPvG2w654y26xXmHYaUASmc54aIyI6MeX4zuZExVfJRNfFQ1USkjkg1+IGta9ZebcmAn4cfAODK7SsGx7r/mf1QOCnU5y++WYwRqSMsEruxOEMxEVHtw+RGj7qS3CgrlIhYFKFzRJMECaHeoTiXcA4KJ4XeB3pNtT/ajgXuj6jKu56H5755DhWiQmesCkmBW+/cgquzq0mxExGR/Bnz/OZQcJkyZt6Wq7ev6kxeAGit/VHN2quqQdE290t0RDQyzmfoTWwAQCmUOJh/UH0OzjlDRETmYHIjU4YO1f7m1DdY9NMincmLr4evyYthGhNH5XKcc4aIiMzB0VIyZehQ7bXH1upMXgSE3n4zlWtQzI2jcjnOOSMf1hipR0RUEyY3MmXIvC3+9fxRfKvY7PfSV4NiyJBx/3r+KCgpUD/8DIk91DsUygolH5q1mGpR1d6re2N02mj0Xt0bEYsiuAApEVkdkxuZMmTeljHtxljkvfTVoOiLQ+XyrcsYu3Ws+uH3zalv9MYuIHD73m30+aoPH5q1FFdYJyJ7YnIjY3Gt45A6IhUh3iEa20O9Q5E6IhWxrWLNOr+uWXurNkXEtozVGoc2qocfAK3HqNajqtpcxodm7cEV1onI3uw+FHzJkiX46KOPUFhYiDZt2iAlJQVRUdqnuM/IyEDv3r2rbc/JyUGrVq0Mer+6MhS8Ml3DvFVDrgtKCrQ+iCRI8PXwxZXbV9Q1JpX3AdXnm9E3bDy2ZSyycrNQUFKAKXum4PKty1rjrTzUG4A69gDPAIzbNg4FpQU1Hsch4vaTcT4DvVdX/3daVfq4dI52cxCc+4lqA4cZCr5x40YkJiZiyZIlePTRR/Gf//wHAwcOxIkTJ9C4cWOdx506dUrjg/n7+9siXIelcFJofYiomoziN8XrTF6WDVkGAFoTlqqz9uqaNLDqsPGM8xk6Exug+lBvVewZ5zN0JjbajiP74Gg3ebHmLOdE1mLXZqmFCxfihRdewIQJE9C6dWukpKQgLCwMn3/+ud7jAgICEBQUpP5RKPgXhKlqarqKax2HuNZxOJ9wHunj0rE+bj3Sx6XjXMI5jRubMU0Rpj78+NB0DBztJh/sO0WOym41N3fv3sWvv/6Kt99+W2N7v379cPDgQb3HdurUCXfu3MFDDz2EmTNnam2qUikrK0NZWZn6dUlJiXmBy1Bc6zh1k5GuamddtT8qxky8Z+rDjw9Nx6Aa7aavuTPUO9SkFdbZPGI7Nf3BYsg8V0T2Yrfkpri4GEqlEoGBgRrbAwMDUVRUpPWY4OBgLFu2DF26dEFZWRm++uorxMTEICMjAz179tR6zNy5c5GcnGzx+LVx5BtvTclLTYypVRnRZoRJDz9rPjTJcgxp7jRlhXU2j9gWZwonR2b30VKSpDnUVwhRbZtKy5YtMXHiRHTu3BmRkZFYsmQJBg8ejPnz5+s8//Tp03H9+nX1T15enkXjV6nrc3oYU6tiyDB1bQ8/U48j2zOkudMYbB6xPTYDkyOzW3LTsGFDKBSKarU0ly5dqlabo0/37t1x+vRpnfvd3Nzg7e2t8WNpjnzjtdQMsoZMvFd52LipDz9LPzTJegzpq2UIDi23DzYDkyOzW7OUq6srunTpgn379mHo0KHq7fv27UNsrOHzrxw5cgTBwfb7x1Wb2qWNbRazZDW/oU0RwP1RT6oYz0w+g4P5B41qyjOkj5C5HLmJsTYxt7kTYPOIvbAZmByZXYeCT506Fc888wy6du2KyMhILFu2DLm5uZg0aRKA+01KBQUFWLNmDQAgJSUFERERaNOmDe7evYu1a9diy5Yt2LJli90+Q2258RqbqBg6bNsYsS1jMSt6Fhb9vAhXb1/ViEOV2EQsitAa46h2o4x6L0s8NHVh347ahc0j9mGtvlNEtmDXPjdPP/00UlJS8O9//xsdO3bE999/j127diE8PBwAUFhYiNzcXHX5u3fvYtq0aWjfvj2ioqLwww8/YOfOnYiLs98DpzbceI1tFrNGNb+qz1FSRpI6sfH18EVydLJ6Mj5HaLpz5CZGuWLziP2wGZgcld1nKLY1S89QbO/ZWFWzDOuqPdI2a68pMetrptFVC6T6625j/Ea8tPMlnSuM15aZhU25lmR9hsykzd+LdbGZlmoDh5mhWA7s3S5tSrOYsbVN2pppfD18kdAtAW8/+naNfY4mbJ+Akru65xfSFqM9bqa1pYmRNLF5xP6s2QxMZA12Hwru6AwdngzAIqOSqjKlWcyYan5dzTRXb19FUkYS/Of715gQ6EtstMVor2H1taGJkbRj8wgRGYM1NxaguvHqWn8J0N2R1tybsin9EWqqbQIAhaTAxRsXMW3fNJ1lAKCkzHIzPldOpizZ0dmY9zfEicsnkHE+g1XzNmaLUXJEJA/sc2NBlZtSAjwDAAA7/tyBlJ9TqpXVtaq2Ke9pSn8EXUmEvfh6+KJwaiGafdLMbn1earqWVXEEFRGR7Rjz/GazlAWp2qXdnN3w3DfPoc9XfbQmNoDlJh8zpFlsQucJ2PTHJo3msLjWcdgUvwkKqXb81RvbMhYH8w8a3OfFGvRdS204goqIqHZicmNhuvqoaGOph7Wu/gi+Hr7w9fBFUkaS1r4rDT0bQimsN6urIQmCSkyTmFrR50XXtdSGs+MSEdVOTG4sSN/8MfpY4mFddar75OhkXLl9pdrw68q1DZZOEhrWa6jxOtQ7FMnRhi1aGuIdUmvmM6l8LWdGzdRb1tq1SUREZDx2KLagmoYS62Kph7WqWUzVd0SbyktCrIxdaZH3BQA/Dz8UTCmotpQCACz/33K916XymlPGDqu31pBx1bWsDbVJRERkHNbcWJCxD7iqi0laiqHztQAwaLHLr4d9DScDviqqhGBUu1GIjoiGwkmh7sci/f//qp5fgqSeo8TYVb9tMWS8ttQmERGR4ZjcWJAxDzhrTj5maJJVdKMIEztP1FlLooovsH4gKlCh91xXbl/R2TRjzBwlhpa11TIJxq52TkRE9sdmKQsyZP4YFdUcONYYRnz66mmDyk3ZMwWXb13Wuq9yfBuObzDofPqSKmPmKKmprLErsZvTdMXZcYmIHA+TGwvS9yBUSex+/6FrrcnH0nLSkJSRZFBZXYlNcnQyZkTNUMdnaI2Uam4fXYyZwl1fWWOWSbh6+6rZK3zXNEkj57mpfbgWElHdxkn8rEDbWkxh3mFWfxDWtPCjIbRNlGfo5HYhXiFYPHCx1R/2G45vwOi00TWWS+yeiEU/LdK5oKexEyjK/YEpl8+n7d8fJ1wkcnzGPL+Z3FiJPR4Uhq72bYiqq5gbMqOxObMuG3O9DP2cDes1RPGtYp2xciXp/yOXhKCmFeq5DhWR4+IMxbWAtpFD1qKsUOK7s99h0U+LLHZObf1nfD189R4j/v9/Cf9NMGpSO2NHPRnSyde/nr/OxEYVK+enuc9WnbOtraa+WAAnXCSqK5jc2IiyQmmVVcHTctIQOD8Qfb7qg22ntlnknIBmPxvVw6/qhIC65Jfm44OsDwwqa8qD1ZAh42PajTHo/ev6/DRySgiM6YtFRPLG5MYGrDUfS1pOGoZtGmZw0gEAoV6hCPUyfGizqbMuJ2Uk1fj5zHmw1jRkPLZVrEFx1vX5aeSUEHDCRSJS4WgpK9PVB0BVM6GvD4C+fijKCiUS/ptgdDyj2o1C99DuiN8Ur7NM5aHNps66DEBjOLY2xjxYtY2c0jdkXFmhNHq249rI2n235JQQcMJFxyKXDuxUOzG5sSJj52OpTFsHT18PXyR0S8CMqBn3E4NS45OOjw5+hM3xmzGtxzQszF6osXCmQlJgauRUjWTLnIdaXkkeMs5nQOGk0HoDs8SDVdeQcUeYn6amm7stOvnKKSGoaZ4pR0lo6wK5dGCn2oujpazI0FE9qpFJqofdNye/QcrPKTrL+3n4ITIsEjv+3GFSXLrm4NE2osTcEVi+Hr64evuq+nXlG5ix18cU9hqWr6Irganp5m6rUT/KCiUC5wfqbdr08/DDxWkXHeKvatV1A6A1oeVoKfvjiDYyFYeC62HL5MbQ+VjWx62Hm7NbtYedPVQeIg3cT25GpI7QSFDMPT9w/wYW2zJW7/w5lhquba/qb10JzKi2ozD/4HydN/eN8Rsxde9Und8FSw5jl1tyA9g/oSXdapqLi1M0kD5MbvSojTU3ydHJmJUxy+hOu9aUHJ1c42repqp8A/vm1Dey/Etb31+nNc0V1LBeQ52zR1dmTo2Wii1qz+yB/TlqJ7l+38g2jHl+s8+NFRnSByDEKwTLf11eqxIbAAYt4eDn4Ycrt6/U+MCuqnJHYUdf2kDbQxRAjaPAdBEQBiU2gGU6+cqpQ3Flxiz1QbYj1+8b1T5MbixI24Nu0YBFGLZpmNbyAgITu0w0eC2o2sLXwxeb4jchOiIa35z6xuTmNNUNzJhFNe1F2+9W22cP9Q7FxM4TbdK8aIlOvnLqUEy1H79vZCtMbixEV/+Kp9s8rfe4g3kHrR2axV29fRUKJwUUTgrEtY7DE82fQOjHoQbXOKhUvoHV5r+0tf1uVbVWVRWUFFgkWVXNsGztUT8cYUS2xO8b2Qon8bMAXbPs5pfkY0H2Ar3H7jmzx5qhWc03J79R///B/INGJTZVJwqszXT9bnV1wDW3eVF1bZYMWqJ+XXU/YLlh7IbM9mzvIfMkH/y+ka0wuTGTqTP4OrqUn1PUMxAb0z7uSDcwW/9uK1+b+DbxemdgtmRfpJpme67t/Z7IsfD7RrbA0VJmsuRK3I4m1DsU5xPOIys3y+BrYMyQXHuPeLHE71bXBILTekzDht831Dhc2ZbXwN7Xm+oWft/IWBwtZUOO3Kvfv54/RrUdhcW/LDbp+PySfGTlZtXYjq7SsF5DLOy30KDEpjbMYGru71bbcPrKo8Dmxsyt8eZuy75ItbnfE8kPv29kTay5MZOj19x4unji5r2bJh+/Pm49RrUbpXNel8oMnbumtsxgaurvtupEiPzrlIjIfMY8v9nnxkxRjaMQ6hVq7zBMZk5iA/zfiKe41nGY1mManCTdX6maVvoGzFsp3NJUNVK6VlDXpmqfItVfp6PajUJ0RLRsExtlhRIZ5zOw4fgGZJzPsMnvh4hIFyY3ZlI4KTCxy0R7h2EXfh5+6hFPaTlpmH9wPipEhd5jKk/gp40xK4Ubq6YHcNX9AGoc2eHn4aex3ZROkfriMiRpsHdikZaThohFEei9ujdGp41G79W9EbEoQt3hnIjI1tjnxgKa+za3dwh2ceX2FXxz6hvEtoxFwn+NG1Wkqz+LtWYwNWShSl379c2gbO7kg/reF0CN/Y7s3TdJVxNiQUkB4jfFc/QLEdkF+9xYgKP3uzGHn4cfXn34VSR/n2zUcbrWjklOT8as72eZfLw2NfXhmdZjmtaFLFVlVIt8WrrvjCnrT1XudwTArn2TrLUIIkfREJE2XDhTD2skN6qbfE2jhUj/A+/NfW/io4MfGXSer4d9jafb6p/9GTDsAewkOUEpdDflhHmHWXyV4pri0keChBDvEAghUFBaoLOMtVdXtsYiiPauiSKi2osdim1M36ybVJ2qs23lviKz0mcZnNgAwOT/Tjaob4khfXj0JTYArNLHp6a49BEQyC/J15nYqMqYGrc22j6LpZsQdc0GrWriYh8eIjIU+9xYSFzrOGyM34iXd72M4lvFestKkNDAvQGu3rlqo+hqh1CvUCwaqLuPizEu37qMrNysGmsELDUPUUGJ7kRCm5pqIGw1P5Il3kfXZ5nY2bCO9IYsgljTKDkJEhJ3JyK2ZSybqIioRqy5sZC0nDRM2TPFoMQGABK6J9girFrj6TZP43zieXVio+0vdGNVXt9KF0utLmzM2lmG1ECcvnraInHVxNzPr++zzMqYBT8PP521lcasIWbNUXJEVPcwubGAtJw0DNs0TG8zgYpqqPCMqBkI9Xbc+XGMpVr9XFmhNHpklS7rjq+rsWnKlLlqtPGv529QOX2fT7UtYXcC/nP4PybHoupPE+IVYpHEQhdD5hxS/b+5iyBaa5QcEdVNTG7MpKxQ4sVvX9RbxtvVG2uHrkX6uHScSziHuNZxUDgpsLDfQhtFaX+qv7o/yPoA+aXm1dioqJqm9LFUf6jKi/zp60tT0+dT9Ze5cOOCSXGoPsOiAYuweOBijW1Vy5i7OKkhtSlXbl9BcnSy2YsgGlrDZKmaOCKSN/a5MVPG+QxcuX1Fb5mSuyUIqh+k0T8kLScNU/dOtXJ0tcs3p75Byk8pFj2nIX/Jq1YhNrWPT6h3KJQVSmw4vgGnr57Gsl+XadTSqfrSKCuUSMpIMvr8xvD18MWyIcvUSYO+OXjMHV1kaC1Jc9/m6gVUTR2+XdP6ZKraKnNqooio7mByYybVTLaGlItpGgNlhRLJGcl4P+t96wZmIfomlDPW2mNrLRWWmqF/yce1jkNsy1h88ssnmLJnikHHqOabuX3vNvp81UdnuYKSAgzbNMwmI+UkSIhtGat+rfpc1pgXxpjaFHMXQVTVsMVvite5krq5NVFEVHcwubGhtJw0PLv1WbPXc7KlVbGrENM0BgDUD9EtJ7bg00OfGnUebzfvGjtbG8OUv+QVTgoEegYaXN7XwxdXbl+psWZO9SA2tB9RqHcohBC4UHrB6L5HxbeLq40Ss9bqyrauTdFVw2apmigiqjvY58ZMhj5UMs9nYtimYQ6V2ADApZuX1P+veogOe2iY0ed5qOFDlgwLAsKkv+QNrY2Y1GVSjetkmUrVX8bUTtW26lSrr7+StWpT4lrH4XzCeaSPS8f6uPUa/dSIiAzF5MZMV28bNldNVp5jDmE9cflEtU6zl25c0nOEdj8X/GzJsODn4afRPGMoQ0ZPKSQFlv66FP/c+cecELVKjk5WNyVVXXTTUNp+J9aiqk0xt8OwMerKSupEZD1cfsEM5kyh72ga1muIse3H4onmT2DklpEWbWIy1f5n9qubzIyhmrsFMLwpyRJCvUJxPvE8FE4Ki6xHZstlCbjeExHZG9eW0sOSyU1dXjDTGpzghAoY3hTk6+GL5UOWm/Rw1zbrrkJS1LgUgzm2jNiijnXD8Q0YnTbarPPZaoFMIqLagGtL2QgnFLOcN3q8gdd7vG7UMVdvXzV5zaGqfTs+7v+x1RIbJ8kJm+I3aSQglpivRfz//xJ3J9qkiYqIyFEwuTEDJxSznFVHV2F279l4o8cbcDLiaykgMGnHJKw7ts7ofiiV+3YYM4rKWBviNmB4m+Ea2wzp++Nfzx/vPPZOjefnsgRERJqY3JghqnEUXCQXe4chC5dvXUbox6HoHtodq55aZfSxY7eORe/VvRGxKMKkmhxTE9Wn2zytN0F5o8cbGNF2RLXtNY1EkiBh6RNL0TagrUFxGLLOFhFRXcHkxgwKJwWC6gfZOwzZuHzrMuI3xePctXMmn6Py4pTGMHYNqjDvMGwZsQVfx3+N1BGp1dYJ86/nj03xm/Bh3w91nsOQkUiGJl2GrLNFRFRXsEOxGZQVSri97wYl+FCxpAfcHsA95T3cLDdtTiDV5HLnEs4ZNaJH1ygq1Yy5ydHJaO7bXOtoIXNGE+k7VlmhRNCCIINGp6WPS7fKZH5ERLWBMc9vzlBshozzGUxsrOBa2TWzjhcQ6n4oxjzszZkh15xZgvUdq3BSYGz7sQatycUO7kRE9zG5McOBcwfsHQLpYcrD3pprNZkqtmWsQckNO7gTEd3H5MYM56+dt3cIpIepD3trrdVkKq6YTURkHHYoNoMtZ7clw0mQEOYdJpuHvT3WeCIicmRMbsxQUWGdhRVJPwmSel2muvKwt8caT0REjorNUmY4cfmEvUNwGE80fwIH8w7i6h3DFhrVRZW8LBuyDABM6vzrqGpjfyAiotqIQ8HNICUbNicK3Z8X5q/Jf+HxNY/jx7wfzTpP5eSFCzoSEdUNDrW21JIlS9CkSRO4u7ujS5cuyMrSP418ZmYmunTpAnd3dzRt2hRLly61UaRkjrySPBzMP4gfnv8BsS1jTTrHx/0/xrmEcxq1MpWXUIiOiGZiQ0RE9k1uNm7ciMTERMyYMQNHjhxBVFQUBg4ciNzcXK3lz507h0GDBiEqKgpHjhzBO++8g9deew1btmyxceRkCtXQ7G0jt+HW9Ft45eFX0K9pP/Rr2g9Okv6vYph3GCY/MpnJCxER1ciuzVLdunVD586d8fnnn6u3tW7dGk899RTmzp1brfxbb72F7du3IycnR71t0qRJ+O2335CdnW3Qe7JZyn70zaCb+kcqhqcOr7Zd1ceGnWaJiOo2h2iWunv3Ln799Vf069dPY3u/fv1w8OBBrcdkZ2dXK9+/f38cPnwY9+7d03pMWVkZSkpKNH7IcpzghPqu9fWWMWRodnybeGwZsaXaGk0cDURERMay22ip4uJiKJVKBAYGamwPDAxEUVGR1mOKioq0li8vL0dxcTGCg6tP2jZ37lwkJydbLvA6ws/DD0IIjdFNoV6hmN9vPgpvFOLM1TNo5tsML3d9GQonBT7I+gBJGUnVzmPM0GyOBiIiIkuw+1BwSdJs2hFCVNtWU3lt21WmT5+OqVOnql+XlJQgLCzM1HBlKeGRBAxpOQQAcOnmJXVSAcDgROO9Xu+hbUBbs4dm17bZgYmIyPHYLblp2LAhFApFtVqaS5cuVaudUQkKCtJa3tnZGX5+flqPcXNzg5ubm2WCdnCq1a1Vqg6r1sbYhSdZ80JERPZmt+TG1dUVXbp0wb59+zB06FD19n379iE2VvtQ4cjISHz77bca2/bu3YuuXbvCxcXFqvFqI5KEXToVV01SDCkPABvjN8Lf09+qiQdrXoiIyN7s2iw1depUPPPMM+jatSsiIyOxbNky5ObmYtKkSQDuNykVFBRgzZo1AO6PjPr0008xdepUTJw4EdnZ2VixYgU2bNhgt89g7QSnnnM99GvWD20D2iI6IlqdOLyf+T4W/rQQpXdLqx2jkBRQCqX6tZxn7SUiIqrK7jMUL1myBB9++CEKCwvRtm1bfPzxx+jZsycA4LnnnsP58+eRkZGhLp+ZmYkpU6bgjz/+QKNGjfDWW2+pkyFDWHIoeGXGJDhB9YLwWPhjcFG4QIKEiAci8HiTx9WJi6HNOqrZeQtKCnD51mX41/NHiHcIeoT2wMH8g2waIiIi2TDm+W335MbWrJXcEBERkfU4xDw3RERERNbA5IaIiIhkhckNERERyQqTGyIiIpIVJjdEREQkK0xuiIiISFaY3BAREZGsMLkhIiIiWWFyQ0RERLJi17Wl7EE1IXNJSYmdIyEiIiJDqZ7bhiysUOeSm9LS+wtNhoWF2TkSIiIiMlZpaSl8fHz0lqlza0tVVFTgwoUL8PLygiRZdjXvkpIShIWFIS8vj+tWgdejKl4PTbwe1fGaaOL10FTXr4cQAqWlpWjUqBGcnPT3qqlzNTdOTk4IDQ216nt4e3vXyS+eLrwemng9NPF6VMdroonXQ1Ndvh411diosEMxERERyQqTGyIiIpIVJjcW5ObmhqSkJLi5udk7lFqB10MTr4cmXo/qeE008Xpo4vUwXJ3rUExERETyxpobIiIikhUmN0RERCQrTG6IiIhIVpjcEBERkawwuTHSkiVL0KRJE7i7u6NLly7IysrSWz4zMxNdunSBu7s7mjZtiqVLl9ooUtsw5nqkpaWhb9++8Pf3h7e3NyIjI7Fnzx4bRmt9xn4/VH788Uc4OzujY8eO1g3Qxoy9HmVlZZgxYwbCw8Ph5uaGZs2a4csvv7RRtNZn7PVYt24dOnTogHr16iE4OBjjx4/HlStXbBStdX3//fcYMmQIGjVqBEmSsG3bthqPkfP91NjrURfup2YRZLCvv/5auLi4iOXLl4sTJ06IhIQE4enpKf7++2+t5c+ePSvq1asnEhISxIkTJ8Ty5cuFi4uLSE1NtXHk1mHs9UhISBDz5s0Tv/zyi/jzzz/F9OnThYuLi/jf//5n48itw9jroXLt2jXRtGlT0a9fP9GhQwfbBGsDplyPJ598UnTr1k3s27dPnDt3Tvz888/ixx9/tGHU1mPs9cjKyhJOTk5i0aJF4uzZsyIrK0u0adNGPPXUUzaO3Dp27dolZsyYIbZs2SIAiK1bt+otL/f7qbHXQ+73U3MxuTHCI488IiZNmqSxrVWrVuLtt9/WWv7NN98UrVq10tj2r3/9S3Tv3t1qMdqSsddDm4ceekgkJydbOjS7MPV6PP3002LmzJkiKSlJVsmNsdfjv//9r/Dx8RFXrlyxRXg2Z+z1+Oijj0TTpk01ti1evFiEhoZaLUZ7MeRhLvf7aWWGXA9t5HQ/NRebpQx09+5d/Prrr+jXr5/G9n79+uHgwYNaj8nOzq5Wvn///jh8+DDu3btntVhtwZTrUVVFRQVKS0vh6+trjRBtytTrsXLlSpw5cwZJSUnWDtGmTLke27dvR9euXfHhhx8iJCQELVq0wLRp03D79m1bhGxVplyPHj16ID8/H7t27YIQAhcvXkRqaioGDx5si5BrHTnfTy1BTvdTS6hzC2eaqri4GEqlEoGBgRrbAwMDUVRUpPWYoqIireXLy8tRXFyM4OBgq8VrbaZcj6oWLFiAmzdvYsSIEdYI0aZMuR6nT5/G22+/jaysLDg7y+ufoinX4+zZs/jhhx/g7u6OrVu3ori4GC+//DKuXr3q8P1uTLkePXr0wLp16/D000/jzp07KC8vx5NPPolPPvnEFiHXOnK+n1qCnO6nlsCaGyNJkqTxWghRbVtN5bVtd1TGXg+VDRs2YNasWdi4cSMCAgKsFZ7NGXo9lEolRo8ejeTkZLRo0cJW4dmcMd+PiooKSJKEdevW4ZFHHsGgQYOwcOFCrFq1Sha1N4Bx1+PEiRN47bXX8N577+HXX3/F7t27ce7cOUyaNMkWodZKcr+fmkqu91NzyOvPRStq2LAhFApFtb+yLl26VO2vCZWgoCCt5Z2dneHn52e1WG3BlOuhsnHjRrzwwgvYvHkz+vTpY80wbcbY61FaWorDhw/jyJEjePXVVwHcf7gLIeDs7Iy9e/fi8ccft0ns1mDK9yM4OBghISHw8fFRb2vdujWEEMjPz0fz5s2tGrM1mXI95s6di0cffRRvvPEGAKB9+/bw9PREVFQUZs+eXedqKuR8PzWHHO+nlsCaGwO5urqiS5cu2Ldvn8b2ffv2oUePHlqPiYyMrFZ+79696Nq1K1xcXKwWqy2Ycj2A+39hPPfcc1i/fr2s+g4Yez28vb1x/PhxHD16VP0zadIktGzZEkePHkW3bt1sFbpVmPL9ePTRR3HhwgXcuHFDve3PP/+Ek5MTQkNDrRqvtZlyPW7dugUnJ81btEKhAPB/NRZ1iZzvp6aS6/3UIuzUkdkhqYZyrlixQpw4cUIkJiYKT09Pcf78eSGEEG+//bZ45pln1OVVQxenTJkiTpw4IVasWCGroYvGXo/169cLZ2dn8dlnn4nCwkL1z7Vr1+z1ESzK2OtRldxGSxl7PUpLS0VoaKiIj48Xf/zxh8jMzBTNmzcXEyZMsNdHsChjr8fKlSuFs7OzWLJkiThz5oz44YcfRNeuXcUjjzxir49gUaWlpeLIkSPiyJEjAoBYuHChOHLkiHpofF27nxp7PeR+PzUXkxsjffbZZyI8PFy4urqKzp07i8zMTPW+cePGiV69emmUz8jIEJ06dRKurq4iIiJCfP755zaO2LqMuR69evUSAKr9jBs3zvaBW4mx34/K5JbcCGH89cjJyRF9+vQRHh4eIjQ0VEydOlXcunXLxlFbj7HXY/HixeKhhx4SHh4eIjg4WIwZM0bk5+fbOGrrSE9P13s/qGv3U2OvR124n5pDEqIO1m8SERGRbLHPDREREckKkxsiIiKSFSY3REREJCtMboiIiEhWmNwQERGRrDC5ISIiIllhckNERESywuSGiKxi1qxZ6Nixo73DICIb+v777zFkyBA0atQIkiRh27ZtRp9j06ZN6NixI+rVq4fw8HB89NFHRp+DyQ0RWcW0adPw3Xff2TsMuzl//jwkScLRo0ftHQqRzdy8eRMdOnTAp59+atLx//3vfzFmzBhMmjQJv//+O5YsWYKFCxcafT4mN0RkFfXr16/TqzUT1UUDBw7E7NmzERcXp3X/3bt38eabbyIkJASenp7o1q0bMjIy1Pu/+uorPPXUU5g0aRKaNm2KwYMH46233sK8efOMWjCWyQ0RmeQ///kPQkJCUFFRobH9ySefxLhx47Q2S61cuRKtW7eGu7s7WrVqhSVLlqj3DRs2DJMnT1a/TkxMhCRJ+OOPPwAA5eXl8PLywp49e2qMraKiAvPmzcODDz4INzc3NG7cGB988IF6//Hjx/H444/Dw8MDfn5+ePHFFzVWI4+OjkZiYqLGOZ966ik899xz6tcRERGYM2cOnn/+eXh5eaFx48ZYtmyZen+TJk0AAJ06dYIkSYiOjq4xbiK5Gz9+PH788Ud8/fXXOHbsGIYPH44BAwbg9OnTAICysjK4u7trHOPh4YH8/Hz8/fffBr8PkxsiMsnw4cNRXFyM9PR09bZ//vkHe/bswZgxY6qVX758OWbMmIEPPvgAOTk5mDNnDt59912sXr0awP2EovJfcJmZmWjYsCEyMzMBAIcOHcKdO3fw6KOP1hjb9OnTMW/ePLz77rs4ceIE1q9fj8DAQADArVu3MGDAADRo0ACHDh3C5s2bsX//frz66qtGX4MFCxaga9euOHLkCF5++WW89NJLOHnyJADgl19+AQDs378fhYWFSEtLM/r8RHJy5swZbNiwAZs3b0ZUVBSaNWuGadOm4bHHHsPKlSsBAP3790daWhq+++47VFRU4M8//0RKSgoAoLCw0PA3s/PCnUTkwJ588knx/PPPq1//5z//EUFBQaK8vLzaKudhYWFi/fr1Gse///77IjIyUgghxLFjx4QkSeLy5cvi6tWrwsXFRcyePVsMHz5cCCHEnDlzRLdu3WqMqaSkRLi5uYnly5dr3b9s2TLRoEEDcePGDfW2nTt3CicnJ1FUVCSEuL/ickJCgsZxsbGxGisuh4eHi7Fjx6pfV1RUiICAAPVK1efOnRMAxJEjR2qMmUiOAIitW7eqX2/atEkAEJ6enho/zs7OYsSIEUKI+/+O3nzzTeHu7i4UCoVo0KCBmDVrlgAgfv75Z4Pf29nCiRkR1SFjxozBiy++iCVLlsDNzQ3r1q3DyJEjoVAoNMpdvnwZeXl5eOGFFzBx4kT19vLycvj4+AAA2rZtCz8/P2RmZsLFxQUdOnTAk08+icWLFwMAMjIy0KtXrxpjysnJQVlZGWJiYnTu79ChAzw9PdXbHn30UVRUVODUqVPqGh5DtG/fXv3/kiQhKCgIly5dMvh4orqkoqICCoUCv/76a7V7RP369QHc/3c0b948zJkzB0VFRfD391cPTIiIiDD4vZjcEJHJhgwZgoqKCuzcuRMPP/wwsrKysHDhwmrlVP1yli9fjm7dumnsU93kJElCz549kZGRAVdXV0RHR6Nt27ZQKpU4fvw4Dh48WK0fjDYeHh569wshIEmS1n2q7U5OTtU6L967d69aeRcXl2rHV+2DRET3derUCUqlEpcuXUJUVJTesgqFAiEhIQCADRs2IDIyEgEBAQa/F5MbIjKZh4cH4uLisG7dOvz1119o0aIFunTpUq1cYGAgQkJCcPbsWa39cVSio6OxbNkyuLq64t///jckSUJUVBTmz5+P27dvG9Tfpnnz5vDw8MB3332HCRMmVNv/0EMPYfXq1bh586a69ubHH3+Ek5MTWrRoAQDw9/fXaN9XKpX4/fff0bt37xrfX8XV1VV9LFFdcePGDfz111/q1+fOncPRo0fh6+uLFi1aYMyYMXj22WexYMECdOrUCcXFxThw4ADatWuHQYMGobi4GKmpqYiOjsadO3ewcuVKbN68Wd33zmCWbWEjorpm7969ws3NTbRs2VK8//776u1V+9wsX75ceHh4iJSUFHHq1Clx7Ngx8eWXX4oFCxaoy6j63bi4uIjr168LIYRISUkRCoVCPPzwwwbHNGvWLNGgQQOxevVq8ddff4ns7GzxxRdfCCGEuHnzpggODhbDhg0Tx48fFwcOHBBNmzbV6E+zdOlSUa9ePbFjxw6Rk5MjXnzxReHt7V2tz83HH3+s8b4dOnQQSUlJQggh7t27Jzw8PMTs2bNFUVGRuHbtmsHxEzmq9PR0AaDaj+rfzt27d8V7770nIiIihIuLiwgKChJDhw4Vx44dE0IIcfnyZdG9e3fh6ekp6tWrJ2JiYsRPP/1kdBxMbojILOXl5SI4OFgAEGfOnFFvr5rcCCHEunXrRMeOHYWrq6to0KCB6Nmzp0hLS1Pvr6ioEP7+/qJr167qbUeOHBEAxLRp0wyOSalUitmzZ4vw8HDh4uIiGjduLObMmaPef+zYMdG7d2/h7u4ufH19xcSJE0Vpaal6/927d8VLL70kfH19RUBAgJg7d67WDsX6khsh7id0YWFhwsnJSfTq1cvg+InIPJIQRsyKQ0RERFTLcZ4bIiIikhUmN0TkUHJzc1G/fn2dP7m5ufYOkYjsjM1SRORQysvLcf78eZ37IyIi4OzMgaBEdRmTGyIiIpIVNksRERGRrDC5ISIiIllhckNERESywuSGiIiIZIXJDREREckKkxsiIiKSFSY3REREJCtMboiIiEhW/h9eSJZ1hba+cQAAAABJRU5ErkJggg==",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "fig,(a1)=plt.subplots(1)\n",
    "a1.scatter(df['view_count'],df['dislikes'],color=\"green\")\n",
    "a1.set_ylabel('dislikes')\n",
    "a1.set_xlabel('view_count')\n",
    "a1.set_title('scatter plot no.of view vs dislikes')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8f1182f1",
   "metadata": {},
   "source": [
    "In this plot x axis column 'view_count' and y axis column 'dislike' both are positively correlated and have a same direction."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "458c5cd7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.6844687753905547\n",
      "There is a positive correlation between view and dislikes\n"
     ]
    }
   ],
   "source": [
    "correlation=df['view_count'].corr(df['dislikes'])\n",
    "print(correlation)\n",
    "if correlation > 0:\n",
    "    print('There is a positive correlation between view and dislikes')\n",
    "elif correlation < 0:\n",
    "    print('There is a negative correlation between view and dislikes')\n",
    "else:\n",
    "    print(\"There is no significent correlation between view and dislikes\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6c861550",
   "metadata": {},
   "source": [
    "On the above scatter plot I see that dislikes point is increase as well as numbers of view counts all increases and \n",
    "there is positive correlationship between view_count and dislikes.And the correlation value is 0.68 so we can say 68%\n",
    "of people are disliked video.No its does not make any effects in this correlation. "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8da91553",
   "metadata": {},
   "source": [
    "# Q14.Display all the information about the videos that were published in January, and mention the count of videos that were published in January."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "6bc3ba7c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>video_id</th>\n",
       "      <th>title</th>\n",
       "      <th>channel_id</th>\n",
       "      <th>channel_title</th>\n",
       "      <th>published_at</th>\n",
       "      <th>view_count</th>\n",
       "      <th>likes</th>\n",
       "      <th>dislikes</th>\n",
       "      <th>comment_count</th>\n",
       "      <th>tags</th>\n",
       "      <th>description</th>\n",
       "      <th>comments</th>\n",
       "      <th>published_month</th>\n",
       "      <th>published_month2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>-2Gwm7QfBnE</td>\n",
       "      <td>Q&amp;A With Naisha</td>\n",
       "      <td>UCYwNMbogQFzMccPSuy-pPWg</td>\n",
       "      <td>MianTwins</td>\n",
       "      <td>2021-01-21 00:05:47</td>\n",
       "      <td>872372</td>\n",
       "      <td>38626</td>\n",
       "      <td>239</td>\n",
       "      <td>621</td>\n",
       "      <td></td>\n",
       "      <td>Hey Guys!!! this has been the most requested v...</td>\n",
       "      <td>I feel like Nate and Aishas personality match ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Jan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>-4sfXSHSxzA</td>\n",
       "      <td>SURPRISING BRENT WITH HIS TIKTOK CRUSH!!</td>\n",
       "      <td>UCPpATKqmMV-CNRNWYaDUwiA</td>\n",
       "      <td>Alexa Rivera</td>\n",
       "      <td>2021-01-16 21:40:04</td>\n",
       "      <td>6504784</td>\n",
       "      <td>262477</td>\n",
       "      <td>5779</td>\n",
       "      <td>7907</td>\n",
       "      <td></td>\n",
       "      <td>He had no idea! Thank you guys so much for wat...</td>\n",
       "      <td>Thank you guys for watching and don't forget t...</td>\n",
       "      <td>1</td>\n",
       "      <td>Jan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>-AJD1Fc5rpQ</td>\n",
       "      <td>WE ARE HAVING A BABY! | finding out i'm pregna...</td>\n",
       "      <td>UCVsTboAhpnuL6j-tDePvNwQ</td>\n",
       "      <td>Tess Christine</td>\n",
       "      <td>2021-01-03 21:53:48</td>\n",
       "      <td>533084</td>\n",
       "      <td>38965</td>\n",
       "      <td>119</td>\n",
       "      <td>1650</td>\n",
       "      <td></td>\n",
       "      <td>I am so happy to tell you that I am pregnant!!...</td>\n",
       "      <td>Okay I needed a moment to collect my thoughts ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Jan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>-AuJiwjsmWk</td>\n",
       "      <td>Do Ugly Foods Taste Worse? Taste Test</td>\n",
       "      <td>UCzpCc5n9hqiVC7HhPwcIKEg</td>\n",
       "      <td>Good Mythical MORE</td>\n",
       "      <td>2021-01-19 11:00:01</td>\n",
       "      <td>1057077</td>\n",
       "      <td>22526</td>\n",
       "      <td>531</td>\n",
       "      <td>773</td>\n",
       "      <td>gmm good mythical morning rhettandlink rhett a...</td>\n",
       "      <td>Today, we're doing a blind taste test to deter...</td>\n",
       "      <td>\"there's nothing wrong with it being bent\"\\nI ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Jan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>-JhqO2KWr5U</td>\n",
       "      <td>Schlatt gets fit</td>\n",
       "      <td>UCWZp4y1jqBuvLtiyxSs_ZBw</td>\n",
       "      <td>Big guy</td>\n",
       "      <td>2021-01-24 22:50:57</td>\n",
       "      <td>1724965</td>\n",
       "      <td>119431</td>\n",
       "      <td>325</td>\n",
       "      <td>1578</td>\n",
       "      <td>jschlatt big guy jschlatt highlights schlatt j...</td>\n",
       "      <td>#jschlatt #schlatt #bigguy #short</td>\n",
       "      <td>Schlatt is single handedly wiping out all the ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Jan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        video_id                                              title  \\\n",
       "27   -2Gwm7QfBnE                                    Q&A With Naisha   \n",
       "48   -4sfXSHSxzA           SURPRISING BRENT WITH HIS TIKTOK CRUSH!!   \n",
       "95   -AJD1Fc5rpQ  WE ARE HAVING A BABY! | finding out i'm pregna...   \n",
       "103  -AuJiwjsmWk              Do Ugly Foods Taste Worse? Taste Test   \n",
       "182  -JhqO2KWr5U                                   Schlatt gets fit   \n",
       "\n",
       "                   channel_id       channel_title        published_at  \\\n",
       "27   UCYwNMbogQFzMccPSuy-pPWg           MianTwins 2021-01-21 00:05:47   \n",
       "48   UCPpATKqmMV-CNRNWYaDUwiA        Alexa Rivera 2021-01-16 21:40:04   \n",
       "95   UCVsTboAhpnuL6j-tDePvNwQ      Tess Christine 2021-01-03 21:53:48   \n",
       "103  UCzpCc5n9hqiVC7HhPwcIKEg  Good Mythical MORE 2021-01-19 11:00:01   \n",
       "182  UCWZp4y1jqBuvLtiyxSs_ZBw             Big guy 2021-01-24 22:50:57   \n",
       "\n",
       "     view_count   likes  dislikes  comment_count  \\\n",
       "27       872372   38626       239            621   \n",
       "48      6504784  262477      5779           7907   \n",
       "95       533084   38965       119           1650   \n",
       "103     1057077   22526       531            773   \n",
       "182     1724965  119431       325           1578   \n",
       "\n",
       "                                                  tags  \\\n",
       "27                                                       \n",
       "48                                                       \n",
       "95                                                       \n",
       "103  gmm good mythical morning rhettandlink rhett a...   \n",
       "182  jschlatt big guy jschlatt highlights schlatt j...   \n",
       "\n",
       "                                           description  \\\n",
       "27   Hey Guys!!! this has been the most requested v...   \n",
       "48   He had no idea! Thank you guys so much for wat...   \n",
       "95   I am so happy to tell you that I am pregnant!!...   \n",
       "103  Today, we're doing a blind taste test to deter...   \n",
       "182                  #jschlatt #schlatt #bigguy #short   \n",
       "\n",
       "                                              comments  published_month  \\\n",
       "27   I feel like Nate and Aishas personality match ...                1   \n",
       "48   Thank you guys for watching and don't forget t...                1   \n",
       "95   Okay I needed a moment to collect my thoughts ...                1   \n",
       "103  \"there's nothing wrong with it being bent\"\\nI ...                1   \n",
       "182  Schlatt is single handedly wiping out all the ...                1   \n",
       "\n",
       "    published_month2  \n",
       "27               Jan  \n",
       "48               Jan  \n",
       "95               Jan  \n",
       "103              Jan  \n",
       "182              Jan  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "january_video=df[df.published_month2.isin(['Jan'])]\n",
    "january_video.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "e71690fb",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2108"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "january_count=df.groupby('published_month2')['video_id'].count()\n",
    "january_count['Jan']\n"
   ]
  }
 ],
 "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.11.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}