TED_Talk_Analsis_2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>title</th>\n",
       "      <th>author</th>\n",
       "      <th>date</th>\n",
       "      <th>views</th>\n",
       "      <th>likes</th>\n",
       "      <th>link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Climate action needs new frontline leadership</td>\n",
       "      <td>Ozawa Bineshi Albert</td>\n",
       "      <td>December 2021</td>\n",
       "      <td>404000</td>\n",
       "      <td>12000</td>\n",
       "      <td>https://ted.com/talks/ozawa_bineshi_albert_cli...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The dark history of the overthrow of Hawaii</td>\n",
       "      <td>Sydney Iaukea</td>\n",
       "      <td>February 2022</td>\n",
       "      <td>214000</td>\n",
       "      <td>6400</td>\n",
       "      <td>https://ted.com/talks/sydney_iaukea_the_dark_h...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>How play can spark new ideas for your business</td>\n",
       "      <td>Martin Reeves</td>\n",
       "      <td>September 2021</td>\n",
       "      <td>412000</td>\n",
       "      <td>12000</td>\n",
       "      <td>https://ted.com/talks/martin_reeves_how_play_c...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Why is China appointing judges to combat clima...</td>\n",
       "      <td>James K. Thornton</td>\n",
       "      <td>October 2021</td>\n",
       "      <td>427000</td>\n",
       "      <td>12000</td>\n",
       "      <td>https://ted.com/talks/james_k_thornton_why_is_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Cement's carbon problem — and 2 ways to fix it</td>\n",
       "      <td>Mahendra Singhi</td>\n",
       "      <td>October 2021</td>\n",
       "      <td>2400</td>\n",
       "      <td>72</td>\n",
       "      <td>https://ted.com/talks/mahendra_singhi_cement_s...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               title                author  \\\n",
       "0      Climate action needs new frontline leadership  Ozawa Bineshi Albert   \n",
       "1        The dark history of the overthrow of Hawaii         Sydney Iaukea   \n",
       "2     How play can spark new ideas for your business         Martin Reeves   \n",
       "3  Why is China appointing judges to combat clima...     James K. Thornton   \n",
       "4     Cement's carbon problem — and 2 ways to fix it       Mahendra Singhi   \n",
       "\n",
       "             date   views  likes  \\\n",
       "0   December 2021  404000  12000   \n",
       "1   February 2022  214000   6400   \n",
       "2  September 2021  412000  12000   \n",
       "3    October 2021  427000  12000   \n",
       "4    October 2021    2400     72   \n",
       "\n",
       "                                                link  \n",
       "0  https://ted.com/talks/ozawa_bineshi_albert_cli...  \n",
       "1  https://ted.com/talks/sydney_iaukea_the_dark_h...  \n",
       "2  https://ted.com/talks/martin_reeves_how_play_c...  \n",
       "3  https://ted.com/talks/james_k_thornton_why_is_...  \n",
       "4  https://ted.com/talks/mahendra_singhi_cement_s...  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Top TED Talks Based on views"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>title</th>\n",
       "      <th>author</th>\n",
       "      <th>date</th>\n",
       "      <th>views</th>\n",
       "      <th>likes</th>\n",
       "      <th>link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5436</th>\n",
       "      <td>Do schools kill creativity?</td>\n",
       "      <td>Sir Ken Robinson</td>\n",
       "      <td>February 2006</td>\n",
       "      <td>72000000</td>\n",
       "      <td>2100000</td>\n",
       "      <td>https://ted.com/talks/sir_ken_robinson_do_scho...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4084</th>\n",
       "      <td>Your body language may shape who you are</td>\n",
       "      <td>Amy Cuddy</td>\n",
       "      <td>June 2012</td>\n",
       "      <td>64000000</td>\n",
       "      <td>1900000</td>\n",
       "      <td>https://ted.com/talks/amy_cuddy_your_body_lang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2958</th>\n",
       "      <td>Inside the mind of a master procrastinator</td>\n",
       "      <td>Tim Urban</td>\n",
       "      <td>February 2016</td>\n",
       "      <td>60000000</td>\n",
       "      <td>1800000</td>\n",
       "      <td>https://ted.com/talks/tim_urban_inside_the_min...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4765</th>\n",
       "      <td>How great leaders inspire action</td>\n",
       "      <td>Simon Sinek</td>\n",
       "      <td>September 2009</td>\n",
       "      <td>57000000</td>\n",
       "      <td>1700000</td>\n",
       "      <td>https://ted.com/talks/simon_sinek_how_great_le...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4605</th>\n",
       "      <td>The power of vulnerability</td>\n",
       "      <td>Brené Brown</td>\n",
       "      <td>June 2010</td>\n",
       "      <td>56000000</td>\n",
       "      <td>1700000</td>\n",
       "      <td>https://ted.com/talks/brene_brown_the_power_of...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>The case for public media</td>\n",
       "      <td>Qi Wu 吴琪</td>\n",
       "      <td>November 2020</td>\n",
       "      <td>1500</td>\n",
       "      <td>47</td>\n",
       "      <td>https://ted.com/talks/qi_wu_the_case_for_publi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1692</th>\n",
       "      <td>\"Part II. The Journey Through Time\" / \"Ruslan ...</td>\n",
       "      <td>Deutsche Philharmonie Merck</td>\n",
       "      <td>November 2018</td>\n",
       "      <td>1300</td>\n",
       "      <td>40</td>\n",
       "      <td>https://ted.com/talks/deutsche_philharmonie_me...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1064</th>\n",
       "      <td>\"Jamie Raeburn\" / \"Baloo Baleerie\" / \"Twa recr...</td>\n",
       "      <td>Findlay Napier and Gillian Frame</td>\n",
       "      <td>July 2019</td>\n",
       "      <td>1300</td>\n",
       "      <td>40</td>\n",
       "      <td>https://ted.com/talks/findlay_napier_and_gilli...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552</th>\n",
       "      <td>Virtual Worlds</td>\n",
       "      <td>Far Flung</td>\n",
       "      <td>November 2020</td>\n",
       "      <td>1300</td>\n",
       "      <td>39</td>\n",
       "      <td>https://ted.com/talks/far_flung_virtual_worlds</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>613</th>\n",
       "      <td>Post-Pandemic Paradise in Rapa Nui</td>\n",
       "      <td>Far Flung</td>\n",
       "      <td>October 2020</td>\n",
       "      <td>1200</td>\n",
       "      <td>37</td>\n",
       "      <td>https://ted.com/talks/far_flung_post_pandemic_...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5439 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  title  \\\n",
       "5436                        Do schools kill creativity?   \n",
       "4084           Your body language may shape who you are   \n",
       "2958         Inside the mind of a master procrastinator   \n",
       "4765                   How great leaders inspire action   \n",
       "4605                         The power of vulnerability   \n",
       "...                                                 ...   \n",
       "478                           The case for public media   \n",
       "1692  \"Part II. The Journey Through Time\" / \"Ruslan ...   \n",
       "1064  \"Jamie Raeburn\" / \"Baloo Baleerie\" / \"Twa recr...   \n",
       "552                                      Virtual Worlds   \n",
       "613                  Post-Pandemic Paradise in Rapa Nui   \n",
       "\n",
       "                                author            date     views    likes  \\\n",
       "5436                  Sir Ken Robinson   February 2006  72000000  2100000   \n",
       "4084                         Amy Cuddy       June 2012  64000000  1900000   \n",
       "2958                         Tim Urban   February 2016  60000000  1800000   \n",
       "4765                       Simon Sinek  September 2009  57000000  1700000   \n",
       "4605                       Brené Brown       June 2010  56000000  1700000   \n",
       "...                                ...             ...       ...      ...   \n",
       "478                           Qi Wu 吴琪   November 2020      1500       47   \n",
       "1692       Deutsche Philharmonie Merck   November 2018      1300       40   \n",
       "1064  Findlay Napier and Gillian Frame       July 2019      1300       40   \n",
       "552                          Far Flung   November 2020      1300       39   \n",
       "613                          Far Flung    October 2020      1200       37   \n",
       "\n",
       "                                                   link  \n",
       "5436  https://ted.com/talks/sir_ken_robinson_do_scho...  \n",
       "4084  https://ted.com/talks/amy_cuddy_your_body_lang...  \n",
       "2958  https://ted.com/talks/tim_urban_inside_the_min...  \n",
       "4765  https://ted.com/talks/simon_sinek_how_great_le...  \n",
       "4605  https://ted.com/talks/brene_brown_the_power_of...  \n",
       "...                                                 ...  \n",
       "478   https://ted.com/talks/qi_wu_the_case_for_publi...  \n",
       "1692  https://ted.com/talks/deutsche_philharmonie_me...  \n",
       "1064  https://ted.com/talks/findlay_napier_and_gilli...  \n",
       "552      https://ted.com/talks/far_flung_virtual_worlds  \n",
       "613   https://ted.com/talks/far_flung_post_pandemic_...  \n",
       "\n",
       "[5439 rows x 6 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values(by='views',ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>title</th>\n",
       "      <th>author</th>\n",
       "      <th>date</th>\n",
       "      <th>views</th>\n",
       "      <th>likes</th>\n",
       "      <th>link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5436</th>\n",
       "      <td>Do schools kill creativity?</td>\n",
       "      <td>Sir Ken Robinson</td>\n",
       "      <td>February 2006</td>\n",
       "      <td>72000000</td>\n",
       "      <td>2100000</td>\n",
       "      <td>https://ted.com/talks/sir_ken_robinson_do_scho...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4084</th>\n",
       "      <td>Your body language may shape who you are</td>\n",
       "      <td>Amy Cuddy</td>\n",
       "      <td>June 2012</td>\n",
       "      <td>64000000</td>\n",
       "      <td>1900000</td>\n",
       "      <td>https://ted.com/talks/amy_cuddy_your_body_lang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2958</th>\n",
       "      <td>Inside the mind of a master procrastinator</td>\n",
       "      <td>Tim Urban</td>\n",
       "      <td>February 2016</td>\n",
       "      <td>60000000</td>\n",
       "      <td>1800000</td>\n",
       "      <td>https://ted.com/talks/tim_urban_inside_the_min...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4765</th>\n",
       "      <td>How great leaders inspire action</td>\n",
       "      <td>Simon Sinek</td>\n",
       "      <td>September 2009</td>\n",
       "      <td>57000000</td>\n",
       "      <td>1700000</td>\n",
       "      <td>https://ted.com/talks/simon_sinek_how_great_le...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4605</th>\n",
       "      <td>The power of vulnerability</td>\n",
       "      <td>Brené Brown</td>\n",
       "      <td>June 2010</td>\n",
       "      <td>56000000</td>\n",
       "      <td>1700000</td>\n",
       "      <td>https://ted.com/talks/brene_brown_the_power_of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3504</th>\n",
       "      <td>How to speak so that people want to listen</td>\n",
       "      <td>Julian Treasure</td>\n",
       "      <td>June 2013</td>\n",
       "      <td>49000000</td>\n",
       "      <td>1400000</td>\n",
       "      <td>https://ted.com/talks/julian_treasure_how_to_s...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2168</th>\n",
       "      <td>My philosophy for a happy life</td>\n",
       "      <td>Sam Berns</td>\n",
       "      <td>October 2013</td>\n",
       "      <td>43000000</td>\n",
       "      <td>1300000</td>\n",
       "      <td>https://ted.com/talks/sam_berns_my_philosophy_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3251</th>\n",
       "      <td>The next outbreak? We're not ready</td>\n",
       "      <td>Bill Gates</td>\n",
       "      <td>March 2015</td>\n",
       "      <td>43000000</td>\n",
       "      <td>1300000</td>\n",
       "      <td>https://ted.com/talks/bill_gates_the_next_outb...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3017</th>\n",
       "      <td>What makes a good life? Lessons from the longe...</td>\n",
       "      <td>Robert Waldinger</td>\n",
       "      <td>November 2015</td>\n",
       "      <td>41000000</td>\n",
       "      <td>1200000</td>\n",
       "      <td>https://ted.com/talks/robert_waldinger_what_ma...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3994</th>\n",
       "      <td>Looks aren't everything. Believe me, I'm a model.</td>\n",
       "      <td>Cameron Russell</td>\n",
       "      <td>October 2012</td>\n",
       "      <td>38000000</td>\n",
       "      <td>1100000</td>\n",
       "      <td>https://ted.com/talks/cameron_russell_looks_ar...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  title            author  \\\n",
       "5436                        Do schools kill creativity?  Sir Ken Robinson   \n",
       "4084           Your body language may shape who you are         Amy Cuddy   \n",
       "2958         Inside the mind of a master procrastinator         Tim Urban   \n",
       "4765                   How great leaders inspire action       Simon Sinek   \n",
       "4605                         The power of vulnerability       Brené Brown   \n",
       "3504         How to speak so that people want to listen   Julian Treasure   \n",
       "2168                     My philosophy for a happy life         Sam Berns   \n",
       "3251                 The next outbreak? We're not ready        Bill Gates   \n",
       "3017  What makes a good life? Lessons from the longe...  Robert Waldinger   \n",
       "3994  Looks aren't everything. Believe me, I'm a model.   Cameron Russell   \n",
       "\n",
       "                date     views    likes  \\\n",
       "5436   February 2006  72000000  2100000   \n",
       "4084       June 2012  64000000  1900000   \n",
       "2958   February 2016  60000000  1800000   \n",
       "4765  September 2009  57000000  1700000   \n",
       "4605       June 2010  56000000  1700000   \n",
       "3504       June 2013  49000000  1400000   \n",
       "2168    October 2013  43000000  1300000   \n",
       "3251      March 2015  43000000  1300000   \n",
       "3017   November 2015  41000000  1200000   \n",
       "3994    October 2012  38000000  1100000   \n",
       "\n",
       "                                                   link  \n",
       "5436  https://ted.com/talks/sir_ken_robinson_do_scho...  \n",
       "4084  https://ted.com/talks/amy_cuddy_your_body_lang...  \n",
       "2958  https://ted.com/talks/tim_urban_inside_the_min...  \n",
       "4765  https://ted.com/talks/simon_sinek_how_great_le...  \n",
       "4605  https://ted.com/talks/brene_brown_the_power_of...  \n",
       "3504  https://ted.com/talks/julian_treasure_how_to_s...  \n",
       "2168  https://ted.com/talks/sam_berns_my_philosophy_...  \n",
       "3251  https://ted.com/talks/bill_gates_the_next_outb...  \n",
       "3017  https://ted.com/talks/robert_waldinger_what_ma...  \n",
       "3994  https://ted.com/talks/cameron_russell_looks_ar...  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values(by='views',ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "So you should definitely watch those top 10 TED talks as they are having lot's of views."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now we find the top TED talks based on No. of Likes they got."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>title</th>\n",
       "      <th>author</th>\n",
       "      <th>date</th>\n",
       "      <th>views</th>\n",
       "      <th>likes</th>\n",
       "      <th>link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5436</th>\n",
       "      <td>Do schools kill creativity?</td>\n",
       "      <td>Sir Ken Robinson</td>\n",
       "      <td>February 2006</td>\n",
       "      <td>72000000</td>\n",
       "      <td>2100000</td>\n",
       "      <td>https://ted.com/talks/sir_ken_robinson_do_scho...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4084</th>\n",
       "      <td>Your body language may shape who you are</td>\n",
       "      <td>Amy Cuddy</td>\n",
       "      <td>June 2012</td>\n",
       "      <td>64000000</td>\n",
       "      <td>1900000</td>\n",
       "      <td>https://ted.com/talks/amy_cuddy_your_body_lang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2958</th>\n",
       "      <td>Inside the mind of a master procrastinator</td>\n",
       "      <td>Tim Urban</td>\n",
       "      <td>February 2016</td>\n",
       "      <td>60000000</td>\n",
       "      <td>1800000</td>\n",
       "      <td>https://ted.com/talks/tim_urban_inside_the_min...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4765</th>\n",
       "      <td>How great leaders inspire action</td>\n",
       "      <td>Simon Sinek</td>\n",
       "      <td>September 2009</td>\n",
       "      <td>57000000</td>\n",
       "      <td>1700000</td>\n",
       "      <td>https://ted.com/talks/simon_sinek_how_great_le...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4605</th>\n",
       "      <td>The power of vulnerability</td>\n",
       "      <td>Brené Brown</td>\n",
       "      <td>June 2010</td>\n",
       "      <td>56000000</td>\n",
       "      <td>1700000</td>\n",
       "      <td>https://ted.com/talks/brene_brown_the_power_of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3504</th>\n",
       "      <td>How to speak so that people want to listen</td>\n",
       "      <td>Julian Treasure</td>\n",
       "      <td>June 2013</td>\n",
       "      <td>49000000</td>\n",
       "      <td>1400000</td>\n",
       "      <td>https://ted.com/talks/julian_treasure_how_to_s...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2168</th>\n",
       "      <td>My philosophy for a happy life</td>\n",
       "      <td>Sam Berns</td>\n",
       "      <td>October 2013</td>\n",
       "      <td>43000000</td>\n",
       "      <td>1300000</td>\n",
       "      <td>https://ted.com/talks/sam_berns_my_philosophy_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3251</th>\n",
       "      <td>The next outbreak? We're not ready</td>\n",
       "      <td>Bill Gates</td>\n",
       "      <td>March 2015</td>\n",
       "      <td>43000000</td>\n",
       "      <td>1300000</td>\n",
       "      <td>https://ted.com/talks/bill_gates_the_next_outb...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3017</th>\n",
       "      <td>What makes a good life? Lessons from the longe...</td>\n",
       "      <td>Robert Waldinger</td>\n",
       "      <td>November 2015</td>\n",
       "      <td>41000000</td>\n",
       "      <td>1200000</td>\n",
       "      <td>https://ted.com/talks/robert_waldinger_what_ma...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3994</th>\n",
       "      <td>Looks aren't everything. Believe me, I'm a model.</td>\n",
       "      <td>Cameron Russell</td>\n",
       "      <td>October 2012</td>\n",
       "      <td>38000000</td>\n",
       "      <td>1100000</td>\n",
       "      <td>https://ted.com/talks/cameron_russell_looks_ar...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  title            author  \\\n",
       "5436                        Do schools kill creativity?  Sir Ken Robinson   \n",
       "4084           Your body language may shape who you are         Amy Cuddy   \n",
       "2958         Inside the mind of a master procrastinator         Tim Urban   \n",
       "4765                   How great leaders inspire action       Simon Sinek   \n",
       "4605                         The power of vulnerability       Brené Brown   \n",
       "3504         How to speak so that people want to listen   Julian Treasure   \n",
       "2168                     My philosophy for a happy life         Sam Berns   \n",
       "3251                 The next outbreak? We're not ready        Bill Gates   \n",
       "3017  What makes a good life? Lessons from the longe...  Robert Waldinger   \n",
       "3994  Looks aren't everything. Believe me, I'm a model.   Cameron Russell   \n",
       "\n",
       "                date     views    likes  \\\n",
       "5436   February 2006  72000000  2100000   \n",
       "4084       June 2012  64000000  1900000   \n",
       "2958   February 2016  60000000  1800000   \n",
       "4765  September 2009  57000000  1700000   \n",
       "4605       June 2010  56000000  1700000   \n",
       "3504       June 2013  49000000  1400000   \n",
       "2168    October 2013  43000000  1300000   \n",
       "3251      March 2015  43000000  1300000   \n",
       "3017   November 2015  41000000  1200000   \n",
       "3994    October 2012  38000000  1100000   \n",
       "\n",
       "                                                   link  \n",
       "5436  https://ted.com/talks/sir_ken_robinson_do_scho...  \n",
       "4084  https://ted.com/talks/amy_cuddy_your_body_lang...  \n",
       "2958  https://ted.com/talks/tim_urban_inside_the_min...  \n",
       "4765  https://ted.com/talks/simon_sinek_how_great_le...  \n",
       "4605  https://ted.com/talks/brene_brown_the_power_of...  \n",
       "3504  https://ted.com/talks/julian_treasure_how_to_s...  \n",
       "2168  https://ted.com/talks/sam_berns_my_philosophy_...  \n",
       "3251  https://ted.com/talks/bill_gates_the_next_outb...  \n",
       "3017  https://ted.com/talks/robert_waldinger_what_ma...  \n",
       "3994  https://ted.com/talks/cameron_russell_looks_ar...  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values(by='likes',ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "View to Like Ratio"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "view_to_like = []\n",
    "\n",
    "data = df.values\n",
    "for i in range(len(data)): \n",
    "    view_to_like.append(round(data[i][3]/data[i][4],2))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['VTL_Ratio'] = view_to_like"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>title</th>\n",
       "      <th>author</th>\n",
       "      <th>date</th>\n",
       "      <th>views</th>\n",
       "      <th>likes</th>\n",
       "      <th>link</th>\n",
       "      <th>VTL_Ratio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>955</th>\n",
       "      <td>A camera that can see around corners</td>\n",
       "      <td>David Lindell</td>\n",
       "      <td>November 2019</td>\n",
       "      <td>364000</td>\n",
       "      <td>10000</td>\n",
       "      <td>https://ted.com/talks/david_lindell_a_camera_t...</td>\n",
       "      <td>36.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>905</th>\n",
       "      <td>What's the point(e) of ballet?</td>\n",
       "      <td>Ming Luke</td>\n",
       "      <td>April 2020</td>\n",
       "      <td>364000</td>\n",
       "      <td>10000</td>\n",
       "      <td>https://ted.com/talks/ming_luke_what_s_the_poi...</td>\n",
       "      <td>36.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>837</th>\n",
       "      <td>How to see more and care less: The art of Geor...</td>\n",
       "      <td>Iseult Gillespie</td>\n",
       "      <td>June 2020</td>\n",
       "      <td>364000</td>\n",
       "      <td>10000</td>\n",
       "      <td>https://ted.com/talks/iseult_gillespie_how_to_...</td>\n",
       "      <td>36.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Can you outsmart the fallacy that divided a na...</td>\n",
       "      <td>Elizabeth Cox</td>\n",
       "      <td>February 2022</td>\n",
       "      <td>363000</td>\n",
       "      <td>10000</td>\n",
       "      <td>https://ted.com/talks/elizabeth_cox_can_you_ou...</td>\n",
       "      <td>36.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1016</th>\n",
       "      <td>The function and fashion of eyeglasses</td>\n",
       "      <td>Debbie Millman</td>\n",
       "      <td>January 2020</td>\n",
       "      <td>363000</td>\n",
       "      <td>10000</td>\n",
       "      <td>https://ted.com/talks/debbie_millman_the_funct...</td>\n",
       "      <td>36.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3089</th>\n",
       "      <td>How computers translate human language</td>\n",
       "      <td>Ioannis Papachimonas</td>\n",
       "      <td>October 2015</td>\n",
       "      <td>398000</td>\n",
       "      <td>11000</td>\n",
       "      <td>https://ted.com/talks/ioannis_papachimonas_how...</td>\n",
       "      <td>36.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4389</th>\n",
       "      <td>The right to understand</td>\n",
       "      <td>Sandra Fisher-Martins</td>\n",
       "      <td>March 2011</td>\n",
       "      <td>361000</td>\n",
       "      <td>10000</td>\n",
       "      <td>https://ted.com/talks/sandra_fisher_martins_th...</td>\n",
       "      <td>36.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4362</th>\n",
       "      <td>How to topple a dictator</td>\n",
       "      <td>Srdja Popovic</td>\n",
       "      <td>November 2011</td>\n",
       "      <td>397000</td>\n",
       "      <td>11000</td>\n",
       "      <td>https://ted.com/talks/srdja_popovic_how_to_top...</td>\n",
       "      <td>36.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5129</th>\n",
       "      <td>On glamour</td>\n",
       "      <td>Virginia Postrel</td>\n",
       "      <td>February 2004</td>\n",
       "      <td>433000</td>\n",
       "      <td>12000</td>\n",
       "      <td>https://ted.com/talks/virginia_postrel_on_glamour</td>\n",
       "      <td>36.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3335</th>\n",
       "      <td>Your strategy needs a strategy</td>\n",
       "      <td>Martin Reeves</td>\n",
       "      <td>October 2014</td>\n",
       "      <td>360000</td>\n",
       "      <td>10000</td>\n",
       "      <td>https://ted.com/talks/martin_reeves_your_strat...</td>\n",
       "      <td>36.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  title  \\\n",
       "955                A camera that can see around corners   \n",
       "905                      What's the point(e) of ballet?   \n",
       "837   How to see more and care less: The art of Geor...   \n",
       "26    Can you outsmart the fallacy that divided a na...   \n",
       "1016             The function and fashion of eyeglasses   \n",
       "3089             How computers translate human language   \n",
       "4389                            The right to understand   \n",
       "4362                           How to topple a dictator   \n",
       "5129                                         On glamour   \n",
       "3335                     Your strategy needs a strategy   \n",
       "\n",
       "                     author           date   views  likes  \\\n",
       "955           David Lindell  November 2019  364000  10000   \n",
       "905               Ming Luke     April 2020  364000  10000   \n",
       "837        Iseult Gillespie      June 2020  364000  10000   \n",
       "26            Elizabeth Cox  February 2022  363000  10000   \n",
       "1016         Debbie Millman   January 2020  363000  10000   \n",
       "3089   Ioannis Papachimonas   October 2015  398000  11000   \n",
       "4389  Sandra Fisher-Martins     March 2011  361000  10000   \n",
       "4362          Srdja Popovic  November 2011  397000  11000   \n",
       "5129       Virginia Postrel  February 2004  433000  12000   \n",
       "3335          Martin Reeves   October 2014  360000  10000   \n",
       "\n",
       "                                                   link  VTL_Ratio  \n",
       "955   https://ted.com/talks/david_lindell_a_camera_t...      36.40  \n",
       "905   https://ted.com/talks/ming_luke_what_s_the_poi...      36.40  \n",
       "837   https://ted.com/talks/iseult_gillespie_how_to_...      36.40  \n",
       "26    https://ted.com/talks/elizabeth_cox_can_you_ou...      36.30  \n",
       "1016  https://ted.com/talks/debbie_millman_the_funct...      36.30  \n",
       "3089  https://ted.com/talks/ioannis_papachimonas_how...      36.18  \n",
       "4389  https://ted.com/talks/sandra_fisher_martins_th...      36.10  \n",
       "4362  https://ted.com/talks/srdja_popovic_how_to_top...      36.09  \n",
       "5129  https://ted.com/talks/virginia_postrel_on_glamour      36.08  \n",
       "3335  https://ted.com/talks/martin_reeves_your_strat...      36.00  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values(by='VTL_Ratio',ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Top 10 Authors with most numberof TED Talks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>title</th>\n",
       "      <th>author</th>\n",
       "      <th>date</th>\n",
       "      <th>views</th>\n",
       "      <th>likes</th>\n",
       "      <th>link</th>\n",
       "      <th>VTL_Ratio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Climate action needs new frontline leadership</td>\n",
       "      <td>Ozawa Bineshi Albert</td>\n",
       "      <td>December 2021</td>\n",
       "      <td>404000</td>\n",
       "      <td>12000</td>\n",
       "      <td>https://ted.com/talks/ozawa_bineshi_albert_cli...</td>\n",
       "      <td>33.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The dark history of the overthrow of Hawaii</td>\n",
       "      <td>Sydney Iaukea</td>\n",
       "      <td>February 2022</td>\n",
       "      <td>214000</td>\n",
       "      <td>6400</td>\n",
       "      <td>https://ted.com/talks/sydney_iaukea_the_dark_h...</td>\n",
       "      <td>33.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>How play can spark new ideas for your business</td>\n",
       "      <td>Martin Reeves</td>\n",
       "      <td>September 2021</td>\n",
       "      <td>412000</td>\n",
       "      <td>12000</td>\n",
       "      <td>https://ted.com/talks/martin_reeves_how_play_c...</td>\n",
       "      <td>34.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Why is China appointing judges to combat clima...</td>\n",
       "      <td>James K. Thornton</td>\n",
       "      <td>October 2021</td>\n",
       "      <td>427000</td>\n",
       "      <td>12000</td>\n",
       "      <td>https://ted.com/talks/james_k_thornton_why_is_...</td>\n",
       "      <td>35.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Cement's carbon problem — and 2 ways to fix it</td>\n",
       "      <td>Mahendra Singhi</td>\n",
       "      <td>October 2021</td>\n",
       "      <td>2400</td>\n",
       "      <td>72</td>\n",
       "      <td>https://ted.com/talks/mahendra_singhi_cement_s...</td>\n",
       "      <td>33.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>The tragedy of air pollution — and an urgent d...</td>\n",
       "      <td>Rosamund Adoo-Kissi-Debrah</td>\n",
       "      <td>October 2021</td>\n",
       "      <td>422000</td>\n",
       "      <td>12000</td>\n",
       "      <td>https://ted.com/talks/rosamund_adoo_kissi_debr...</td>\n",
       "      <td>35.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>The myth of Narcissus and Echo</td>\n",
       "      <td>Iseult Gillespie</td>\n",
       "      <td>February 2022</td>\n",
       "      <td>412000</td>\n",
       "      <td>12000</td>\n",
       "      <td>https://ted.com/talks/iseult_gillespie_the_myt...</td>\n",
       "      <td>34.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>You deserve the right to repair your stuff</td>\n",
       "      <td>Gay Gordon-Byrne</td>\n",
       "      <td>August 2021</td>\n",
       "      <td>455000</td>\n",
       "      <td>13000</td>\n",
       "      <td>https://ted.com/talks/gay_gordon_byrne_you_des...</td>\n",
       "      <td>35.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>What nature can teach us about sustainable bus...</td>\n",
       "      <td>Erin Meezan</td>\n",
       "      <td>February 2022</td>\n",
       "      <td>66000</td>\n",
       "      <td>1900</td>\n",
       "      <td>https://ted.com/talks/erin_meezan_what_nature_...</td>\n",
       "      <td>34.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>The origins of blackface and Black stereotypes</td>\n",
       "      <td>Dwan Reece</td>\n",
       "      <td>March 2019</td>\n",
       "      <td>584000</td>\n",
       "      <td>17000</td>\n",
       "      <td>https://ted.com/talks/dwan_reece_the_origins_o...</td>\n",
       "      <td>34.35</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               title  \\\n",
       "0      Climate action needs new frontline leadership   \n",
       "1        The dark history of the overthrow of Hawaii   \n",
       "2     How play can spark new ideas for your business   \n",
       "3  Why is China appointing judges to combat clima...   \n",
       "4     Cement's carbon problem — and 2 ways to fix it   \n",
       "5  The tragedy of air pollution — and an urgent d...   \n",
       "6                     The myth of Narcissus and Echo   \n",
       "7         You deserve the right to repair your stuff   \n",
       "8  What nature can teach us about sustainable bus...   \n",
       "9     The origins of blackface and Black stereotypes   \n",
       "\n",
       "                       author            date   views  likes  \\\n",
       "0        Ozawa Bineshi Albert   December 2021  404000  12000   \n",
       "1               Sydney Iaukea   February 2022  214000   6400   \n",
       "2               Martin Reeves  September 2021  412000  12000   \n",
       "3           James K. Thornton    October 2021  427000  12000   \n",
       "4             Mahendra Singhi    October 2021    2400     72   \n",
       "5  Rosamund Adoo-Kissi-Debrah    October 2021  422000  12000   \n",
       "6            Iseult Gillespie   February 2022  412000  12000   \n",
       "7            Gay Gordon-Byrne     August 2021  455000  13000   \n",
       "8                 Erin Meezan   February 2022   66000   1900   \n",
       "9                  Dwan Reece      March 2019  584000  17000   \n",
       "\n",
       "                                                link  VTL_Ratio  \n",
       "0  https://ted.com/talks/ozawa_bineshi_albert_cli...      33.67  \n",
       "1  https://ted.com/talks/sydney_iaukea_the_dark_h...      33.44  \n",
       "2  https://ted.com/talks/martin_reeves_how_play_c...      34.33  \n",
       "3  https://ted.com/talks/james_k_thornton_why_is_...      35.58  \n",
       "4  https://ted.com/talks/mahendra_singhi_cement_s...      33.33  \n",
       "5  https://ted.com/talks/rosamund_adoo_kissi_debr...      35.17  \n",
       "6  https://ted.com/talks/iseult_gillespie_the_myt...      34.33  \n",
       "7  https://ted.com/talks/gay_gordon_byrne_you_des...      35.00  \n",
       "8  https://ted.com/talks/erin_meezan_what_nature_...      34.74  \n",
       "9  https://ted.com/talks/dwan_reece_the_origins_o...      34.35  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "author\n",
       "Alex Gendler        45\n",
       "Iseult Gillespie    33\n",
       "Matt Walker         18\n",
       "Alex Rosenthal      15\n",
       "Elizabeth Cox       13\n",
       "Emma Bryce          12\n",
       "Juan Enriquez       11\n",
       "Daniel Finkel       11\n",
       "Mona Chalabi         9\n",
       "Dan Finkel           9\n",
       "dtype: int64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby('author').size().sort_values(ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Hpw many TED talks are given in 2020"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = df.values\n",
    "\n",
    "month = []\n",
    "year = []\n",
    "\n",
    "for i in range(len(data)):\n",
    "    month.append(data[i][2].split(' ')[0])\n",
    "    year.append(data[i][2].split(' ')[1])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['year'] = year\n",
    "df['month'] = month"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>title</th>\n",
       "      <th>author</th>\n",
       "      <th>date</th>\n",
       "      <th>views</th>\n",
       "      <th>likes</th>\n",
       "      <th>link</th>\n",
       "      <th>VTL_Ratio</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Climate action needs new frontline leadership</td>\n",
       "      <td>Ozawa Bineshi Albert</td>\n",
       "      <td>December 2021</td>\n",
       "      <td>404000</td>\n",
       "      <td>12000</td>\n",
       "      <td>https://ted.com/talks/ozawa_bineshi_albert_cli...</td>\n",
       "      <td>33.67</td>\n",
       "      <td>2021</td>\n",
       "      <td>December</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The dark history of the overthrow of Hawaii</td>\n",
       "      <td>Sydney Iaukea</td>\n",
       "      <td>February 2022</td>\n",
       "      <td>214000</td>\n",
       "      <td>6400</td>\n",
       "      <td>https://ted.com/talks/sydney_iaukea_the_dark_h...</td>\n",
       "      <td>33.44</td>\n",
       "      <td>2022</td>\n",
       "      <td>February</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>How play can spark new ideas for your business</td>\n",
       "      <td>Martin Reeves</td>\n",
       "      <td>September 2021</td>\n",
       "      <td>412000</td>\n",
       "      <td>12000</td>\n",
       "      <td>https://ted.com/talks/martin_reeves_how_play_c...</td>\n",
       "      <td>34.33</td>\n",
       "      <td>2021</td>\n",
       "      <td>September</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Why is China appointing judges to combat clima...</td>\n",
       "      <td>James K. Thornton</td>\n",
       "      <td>October 2021</td>\n",
       "      <td>427000</td>\n",
       "      <td>12000</td>\n",
       "      <td>https://ted.com/talks/james_k_thornton_why_is_...</td>\n",
       "      <td>35.58</td>\n",
       "      <td>2021</td>\n",
       "      <td>October</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Cement's carbon problem — and 2 ways to fix it</td>\n",
       "      <td>Mahendra Singhi</td>\n",
       "      <td>October 2021</td>\n",
       "      <td>2400</td>\n",
       "      <td>72</td>\n",
       "      <td>https://ted.com/talks/mahendra_singhi_cement_s...</td>\n",
       "      <td>33.33</td>\n",
       "      <td>2021</td>\n",
       "      <td>October</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               title                author  \\\n",
       "0      Climate action needs new frontline leadership  Ozawa Bineshi Albert   \n",
       "1        The dark history of the overthrow of Hawaii         Sydney Iaukea   \n",
       "2     How play can spark new ideas for your business         Martin Reeves   \n",
       "3  Why is China appointing judges to combat clima...     James K. Thornton   \n",
       "4     Cement's carbon problem — and 2 ways to fix it       Mahendra Singhi   \n",
       "\n",
       "             date   views  likes  \\\n",
       "0   December 2021  404000  12000   \n",
       "1   February 2022  214000   6400   \n",
       "2  September 2021  412000  12000   \n",
       "3    October 2021  427000  12000   \n",
       "4    October 2021    2400     72   \n",
       "\n",
       "                                                link  VTL_Ratio  year  \\\n",
       "0  https://ted.com/talks/ozawa_bineshi_albert_cli...      33.67  2021   \n",
       "1  https://ted.com/talks/sydney_iaukea_the_dark_h...      33.44  2022   \n",
       "2  https://ted.com/talks/martin_reeves_how_play_c...      34.33  2021   \n",
       "3  https://ted.com/talks/james_k_thornton_why_is_...      35.58  2021   \n",
       "4  https://ted.com/talks/mahendra_singhi_cement_s...      33.33  2021   \n",
       "\n",
       "       month  \n",
       "0   December  \n",
       "1   February  \n",
       "2  September  \n",
       "3    October  \n",
       "4    October  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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>title</th>\n",
       "      <th>author</th>\n",
       "      <th>date</th>\n",
       "      <th>views</th>\n",
       "      <th>likes</th>\n",
       "      <th>link</th>\n",
       "      <th>VTL_Ratio</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>How music can help you find peace after loss</td>\n",
       "      <td>Steven Sharp Nelson</td>\n",
       "      <td>September 2020</td>\n",
       "      <td>1500000</td>\n",
       "      <td>47000</td>\n",
       "      <td>https://ted.com/talks/steven_sharp_nelson_how_...</td>\n",
       "      <td>31.91</td>\n",
       "      <td>2020</td>\n",
       "      <td>September</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>The informal settlements reshaping the world</td>\n",
       "      <td>Jota Samper</td>\n",
       "      <td>September 2020</td>\n",
       "      <td>1600000</td>\n",
       "      <td>49000</td>\n",
       "      <td>https://ted.com/talks/jota_samper_the_informal...</td>\n",
       "      <td>32.65</td>\n",
       "      <td>2020</td>\n",
       "      <td>September</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263</th>\n",
       "      <td>The (de)colonizing of beauty</td>\n",
       "      <td>Sasha Sarago</td>\n",
       "      <td>November 2020</td>\n",
       "      <td>1600000</td>\n",
       "      <td>48000</td>\n",
       "      <td>https://ted.com/talks/sasha_sarago_the_de_colo...</td>\n",
       "      <td>33.33</td>\n",
       "      <td>2020</td>\n",
       "      <td>November</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>3 myths about racism that keep the US from pro...</td>\n",
       "      <td>Candis Watts Smith</td>\n",
       "      <td>February 2020</td>\n",
       "      <td>1800000</td>\n",
       "      <td>55000</td>\n",
       "      <td>https://ted.com/talks/candis_watts_smith_3_myt...</td>\n",
       "      <td>32.73</td>\n",
       "      <td>2020</td>\n",
       "      <td>February</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>Why aren't there more Native American restaura...</td>\n",
       "      <td>Sean Sherman</td>\n",
       "      <td>August 2020</td>\n",
       "      <td>1900000</td>\n",
       "      <td>58000</td>\n",
       "      <td>https://ted.com/talks/sean_sherman_why_aren_t_...</td>\n",
       "      <td>32.76</td>\n",
       "      <td>2020</td>\n",
       "      <td>August</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1090</th>\n",
       "      <td>The Artists | Think Like A Coder, Ep 5</td>\n",
       "      <td>Alex Rosenthal</td>\n",
       "      <td>January 2020</td>\n",
       "      <td>408000</td>\n",
       "      <td>12000</td>\n",
       "      <td>https://ted.com/talks/alex_rosenthal_the_artis...</td>\n",
       "      <td>34.00</td>\n",
       "      <td>2020</td>\n",
       "      <td>January</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1093</th>\n",
       "      <td>Can you solve the dragon jousting riddle?</td>\n",
       "      <td>Alex Gendler</td>\n",
       "      <td>January 2020</td>\n",
       "      <td>2200000</td>\n",
       "      <td>66000</td>\n",
       "      <td>https://ted.com/talks/alex_gendler_can_you_sol...</td>\n",
       "      <td>33.33</td>\n",
       "      <td>2020</td>\n",
       "      <td>January</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1096</th>\n",
       "      <td>The mysterious life and death of Rasputin</td>\n",
       "      <td>Eden Girma</td>\n",
       "      <td>January 2020</td>\n",
       "      <td>3000000</td>\n",
       "      <td>92000</td>\n",
       "      <td>https://ted.com/talks/eden_girma_the_mysteriou...</td>\n",
       "      <td>32.61</td>\n",
       "      <td>2020</td>\n",
       "      <td>January</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1099</th>\n",
       "      <td>Could a breathalyzer detect cancer?</td>\n",
       "      <td>Julian Burschka</td>\n",
       "      <td>January 2020</td>\n",
       "      <td>228000</td>\n",
       "      <td>6800</td>\n",
       "      <td>https://ted.com/talks/julian_burschka_could_a_...</td>\n",
       "      <td>33.53</td>\n",
       "      <td>2020</td>\n",
       "      <td>January</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1104</th>\n",
       "      <td>A brief history of alcohol</td>\n",
       "      <td>Rod Phillips</td>\n",
       "      <td>January 2020</td>\n",
       "      <td>4700000</td>\n",
       "      <td>141000</td>\n",
       "      <td>https://ted.com/talks/rod_phillips_a_brief_his...</td>\n",
       "      <td>33.33</td>\n",
       "      <td>2020</td>\n",
       "      <td>January</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>501 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  title               author  \\\n",
       "234        How music can help you find peace after loss  Steven Sharp Nelson   \n",
       "253       The informal settlements reshaping the world           Jota Samper   \n",
       "263                        The (de)colonizing of beauty         Sasha Sarago   \n",
       "265   3 myths about racism that keep the US from pro...   Candis Watts Smith   \n",
       "275   Why aren't there more Native American restaura...         Sean Sherman   \n",
       "...                                                 ...                  ...   \n",
       "1090             The Artists | Think Like A Coder, Ep 5       Alex Rosenthal   \n",
       "1093          Can you solve the dragon jousting riddle?         Alex Gendler   \n",
       "1096          The mysterious life and death of Rasputin           Eden Girma   \n",
       "1099                Could a breathalyzer detect cancer?      Julian Burschka   \n",
       "1104                         A brief history of alcohol         Rod Phillips   \n",
       "\n",
       "                date    views   likes  \\\n",
       "234   September 2020  1500000   47000   \n",
       "253   September 2020  1600000   49000   \n",
       "263    November 2020  1600000   48000   \n",
       "265    February 2020  1800000   55000   \n",
       "275      August 2020  1900000   58000   \n",
       "...              ...      ...     ...   \n",
       "1090    January 2020   408000   12000   \n",
       "1093    January 2020  2200000   66000   \n",
       "1096    January 2020  3000000   92000   \n",
       "1099    January 2020   228000    6800   \n",
       "1104    January 2020  4700000  141000   \n",
       "\n",
       "                                                   link  VTL_Ratio  year  \\\n",
       "234   https://ted.com/talks/steven_sharp_nelson_how_...      31.91  2020   \n",
       "253   https://ted.com/talks/jota_samper_the_informal...      32.65  2020   \n",
       "263   https://ted.com/talks/sasha_sarago_the_de_colo...      33.33  2020   \n",
       "265   https://ted.com/talks/candis_watts_smith_3_myt...      32.73  2020   \n",
       "275   https://ted.com/talks/sean_sherman_why_aren_t_...      32.76  2020   \n",
       "...                                                 ...        ...   ...   \n",
       "1090  https://ted.com/talks/alex_rosenthal_the_artis...      34.00  2020   \n",
       "1093  https://ted.com/talks/alex_gendler_can_you_sol...      33.33  2020   \n",
       "1096  https://ted.com/talks/eden_girma_the_mysteriou...      32.61  2020   \n",
       "1099  https://ted.com/talks/julian_burschka_could_a_...      33.53  2020   \n",
       "1104  https://ted.com/talks/rod_phillips_a_brief_his...      33.33  2020   \n",
       "\n",
       "          month  \n",
       "234   September  \n",
       "253   September  \n",
       "263    November  \n",
       "265    February  \n",
       "275      August  \n",
       "...         ...  \n",
       "1090    January  \n",
       "1093    January  \n",
       "1096    January  \n",
       "1099    January  \n",
       "1104    January  \n",
       "\n",
       "[501 rows x 9 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['year'] == '2020']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Total No. of TED Talks given in 2020"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "501"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df[df['year'] == '2020'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Trend of TED Talks frequency by years"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "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>title</th>\n",
       "      <th>author</th>\n",
       "      <th>date</th>\n",
       "      <th>views</th>\n",
       "      <th>likes</th>\n",
       "      <th>link</th>\n",
       "      <th>VTL_Ratio</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Climate action needs new frontline leadership</td>\n",
       "      <td>Ozawa Bineshi Albert</td>\n",
       "      <td>December 2021</td>\n",
       "      <td>404000</td>\n",
       "      <td>12000</td>\n",
       "      <td>https://ted.com/talks/ozawa_bineshi_albert_cli...</td>\n",
       "      <td>33.67</td>\n",
       "      <td>2021</td>\n",
       "      <td>December</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The dark history of the overthrow of Hawaii</td>\n",
       "      <td>Sydney Iaukea</td>\n",
       "      <td>February 2022</td>\n",
       "      <td>214000</td>\n",
       "      <td>6400</td>\n",
       "      <td>https://ted.com/talks/sydney_iaukea_the_dark_h...</td>\n",
       "      <td>33.44</td>\n",
       "      <td>2022</td>\n",
       "      <td>February</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>How play can spark new ideas for your business</td>\n",
       "      <td>Martin Reeves</td>\n",
       "      <td>September 2021</td>\n",
       "      <td>412000</td>\n",
       "      <td>12000</td>\n",
       "      <td>https://ted.com/talks/martin_reeves_how_play_c...</td>\n",
       "      <td>34.33</td>\n",
       "      <td>2021</td>\n",
       "      <td>September</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Why is China appointing judges to combat clima...</td>\n",
       "      <td>James K. Thornton</td>\n",
       "      <td>October 2021</td>\n",
       "      <td>427000</td>\n",
       "      <td>12000</td>\n",
       "      <td>https://ted.com/talks/james_k_thornton_why_is_...</td>\n",
       "      <td>35.58</td>\n",
       "      <td>2021</td>\n",
       "      <td>October</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Cement's carbon problem — and 2 ways to fix it</td>\n",
       "      <td>Mahendra Singhi</td>\n",
       "      <td>October 2021</td>\n",
       "      <td>2400</td>\n",
       "      <td>72</td>\n",
       "      <td>https://ted.com/talks/mahendra_singhi_cement_s...</td>\n",
       "      <td>33.33</td>\n",
       "      <td>2021</td>\n",
       "      <td>October</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               title                author  \\\n",
       "0      Climate action needs new frontline leadership  Ozawa Bineshi Albert   \n",
       "1        The dark history of the overthrow of Hawaii         Sydney Iaukea   \n",
       "2     How play can spark new ideas for your business         Martin Reeves   \n",
       "3  Why is China appointing judges to combat clima...     James K. Thornton   \n",
       "4     Cement's carbon problem — and 2 ways to fix it       Mahendra Singhi   \n",
       "\n",
       "             date   views  likes  \\\n",
       "0   December 2021  404000  12000   \n",
       "1   February 2022  214000   6400   \n",
       "2  September 2021  412000  12000   \n",
       "3    October 2021  427000  12000   \n",
       "4    October 2021    2400     72   \n",
       "\n",
       "                                                link  VTL_Ratio  year  \\\n",
       "0  https://ted.com/talks/ozawa_bineshi_albert_cli...      33.67  2021   \n",
       "1  https://ted.com/talks/sydney_iaukea_the_dark_h...      33.44  2022   \n",
       "2  https://ted.com/talks/martin_reeves_how_play_c...      34.33  2021   \n",
       "3  https://ted.com/talks/james_k_thornton_why_is_...      35.58  2021   \n",
       "4  https://ted.com/talks/mahendra_singhi_cement_s...      33.33  2021   \n",
       "\n",
       "       month  \n",
       "0   December  \n",
       "1   February  \n",
       "2  September  \n",
       "3    October  \n",
       "4    October  "
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x261eb446e48>"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAEWCAYAAACdaNcBAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAadklEQVR4nO3dfbQkdXng8e8zAygwyuvlJTMMw9FJkBwFZTJgMIqALsgG0IBRszoicUwWAyurkTUncXWjwm4iirq6rLDAJmp8iTIqgmYQjWtABkbeBMNIEEZYGGXAF+IL+Owf9btrU7f73r53bt9b85vv55w6XfWrp6uf7up+6tfVVdWRmUiS6rJgvhOQJM0+i7skVcjiLkkVsrhLUoUs7pJUIYu7JFVou/lOAGDPPffMZcuWzXcakrRVuf7667+fmWP95nWiuC9btox169bNdxqStFWJiO8OmuduGUmqkMVdkipkcZekClncJalCFndJqpDFXZIqZHGXpApZ3CWpQp04iUmSumTZ2Z/v237XOcfPcSYzZ89dkipkcZekClncJalCFndJqpDFXZIqZHGXpApZ3CWpQhZ3SaqQxV2SKmRxl6QKWdwlqUIWd0mq0FDFPSLuioibI+KbEbGutO0eEV+KiDvK7W6lPSLi/IjYEBE3RcSzRvkEJEkTTafn/vzMPCQzV5Tps4G1mbkcWFumAY4DlpdhNfDB2UpWkjScLdktcyJwSRm/BDipp/3SbFwD7BoR+27B40iSpmnY4p7AFyPi+ohYXdr2zsz7AMrtXqV9MXBPz303ljZJ0hwZ9s86jsjMeyNiL+BLEXH7JLHRpy0nBDUbidUAS5cuHTINSeqWrv6xx1A998y8t9w+AHwaWAncP767pdw+UMI3Avv13H0JcG+fZV6QmSsyc8XY2NjMn4EkaYIpe+4RsTOwIDN/VMZfCLwdWAOsAs4pt5eVu6wBXh8RHwMOAx4e330jSbOpX695vnvMXTHMbpm9gU9HxHj8RzLzioi4Dvh4RJwG3A2cUuIvB14EbAAeAU6d9awlSZOasrhn5p3AwX3afwAc3ac9gdNnJTtJ0ox4hqokVcjiLkkVsrhLUoUs7pJUIYu7JFVo2DNUJWmrtq0dE2/PXZIqZHGXpApZ3CWpQhZ3SaqQxV2SKmRxl6QKWdwlqUIWd0mqkMVdkipkcZekClncJalCFndJqpDFXZIqZHGXpApZ3CWpQhZ3SaqQxV2SKmRxl6QKWdwlqUIWd0mqkMVdkipkcZekClncJalCQxf3iFgYEesj4nNl+oCIuDYi7oiIv4uIHUr7E8r0hjJ/2WhSlyQNMp2e+5nAbT3T5wLnZeZyYDNwWmk/DdicmU8FzitxkqQ5NFRxj4glwPHAh8t0AEcBnywhlwAnlfETyzRl/tElXpI0R4btub8H+FPgl2V6D+ChzHy0TG8EFpfxxcA9AGX+wyVekjRHtpsqICL+LfBAZl4fEUeON/cJzSHm9S53NbAaYOnSpUMlK6l+y87+/IS2u845fh4y2boN03M/AjghIu4CPkazO+Y9wK4RMb5xWALcW8Y3AvsBlPm7AA+2F5qZF2TmisxcMTY2tkVPQpL0eFMW98z8T5m5JDOXAS8DrsrMPwC+DJxcwlYBl5XxNWWaMv+qzJzQc5ckjc6WHOf+ZuCsiNhAs0/9wtJ+IbBHaT8LOHvLUpQkTdeU+9x7ZebVwNVl/E5gZZ+YnwKnzEJuklSVfr8nwGh+U5hWcZdUr7ksPBo9Lz8gSRWyuEtShSzuklQh97lLGin35c8Pe+6SVCGLuyRVyOIuSRWyuEtShSzuklQhi7skVchDISVNm4c3dp89d0mqkMVdkipkcZekClncJalCFndJqpDFXZIqZHGXpApZ3CWpQhZ3SaqQxV2SKmRxl6QKWdwlqUIWd0mqkMVdkipkcZekClncJalCFndJqtCUxT0inhgR34iIGyPi1oh4W2k/ICKujYg7IuLvImKH0v6EMr2hzF822qcgSWobpuf+M+CozDwYOAQ4NiIOB84FzsvM5cBm4LQSfxqwOTOfCpxX4iRJc2jK4p6NH5fJ7cuQwFHAJ0v7JcBJZfzEMk2Zf3RExKxlLEma0lB/kB0RC4HrgacCHwC+AzyUmY+WkI3A4jK+GLgHIDMfjYiHgT2A789i3pKG0O+PrP0T623DUD+oZuZjmXkIsARYCTytX1i57ddLz3ZDRKyOiHURsW7Tpk3D5itJGsK0jpbJzIeAq4HDgV0jYrznvwS4t4xvBPYDKPN3AR7ss6wLMnNFZq4YGxubWfaSpL6GOVpmLCJ2LeM7AscAtwFfBk4uYauAy8r4mjJNmX9VZk7ouUuSRmeYfe77ApeU/e4LgI9n5uci4lvAxyLiL4H1wIUl/kLgf0fEBpoe+8tGkLckaRJTFvfMvAl4Zp/2O2n2v7fbfwqcMivZSZJmxDNUJalCFndJqpDFXZIqZHGXpApZ3CWpQhZ3SarQUNeWkdQdXi9Gw7DnLkkVsucudYC9cc02e+6SVCGLuyRVyOIuSRWyuEtShSzuklQhi7skVcjiLkkVsrhLUoUs7pJUIYu7JFXI4i5JFbK4S1KFvHCYNAL9LgQGXgxMc8eeuyRVyOIuSRWyuEtShSzuklQhi7skVcjiLkkVsrhLUoUs7pJUoSmLe0TsFxFfjojbIuLWiDiztO8eEV+KiDvK7W6lPSLi/IjYEBE3RcSzRv0kJEmPN0zP/VHgP2bm04DDgdMj4iDgbGBtZi4H1pZpgOOA5WVYDXxw1rOWJE1qyuKemfdl5g1l/EfAbcBi4ETgkhJ2CXBSGT8RuDQb1wC7RsS+s565JGmgae1zj4hlwDOBa4G9M/M+aDYAwF4lbDFwT8/dNpa29rJWR8S6iFi3adOm6WcuSRpo6OIeEYuATwH/ITN/OFlon7ac0JB5QWauyMwVY2Njw6YhSRrCUMU9IranKex/m5l/X5rvH9/dUm4fKO0bgf167r4EuHd20pUkDWOYo2UCuBC4LTPf3TNrDbCqjK8CLutpf1U5auZw4OHx3TeSpLkxzPXcjwBeCdwcEd8sbW8BzgE+HhGnAXcDp5R5lwMvAjYAjwCnzmrGkqQpTVncM/Nr9N+PDnB0n/gETt/CvCRJW8AzVCWpQhZ3SaqQxV2SKmRxl6QKWdwlqUIWd0mqkMVdkipkcZekClncJalCFndJqpDFXZIqZHGXpApZ3CWpQhZ3SaqQxV2SKmRxl6QKWdwlqUIWd0mqkMVdkipkcZekClncJalCFndJqpDFXZIqZHGXpApZ3CWpQhZ3SaqQxV2SKrTdfCcgzadlZ3++b/td5xw/x5lIs8ueuyRVaMriHhEXRcQDEXFLT9vuEfGliLij3O5W2iMizo+IDRFxU0Q8a5TJS5L6G6bnfjFwbKvtbGBtZi4H1pZpgOOA5WVYDXxwdtKUJE3HlMU9M78KPNhqPhG4pIxfApzU035pNq4Bdo2IfWcrWUnScGa6z33vzLwPoNzuVdoXA/f0xG0sbRNExOqIWBcR6zZt2jTDNCRJ/cz2D6rRpy37BWbmBZm5IjNXjI2NzXIakrRtm2lxv398d0u5faC0bwT264lbAtw78/QkSTMx0+K+BlhVxlcBl/W0v6ocNXM48PD47htJ0tyZ8iSmiPgocCSwZ0RsBN4KnAN8PCJOA+4GTinhlwMvAjYAjwCnjiBnSdIUpizumfnyAbOO7hObwOlbmpQkact4+QFpSF6qQFsTLz8gSRWyuEtShSzuklQhi7skVcjiLkkVsrhLUoUs7pJUIY9z11ah3zHmHl8uDWbPXZIqZHGXpApZ3CWpQhZ3SaqQxV2SKuTRMqqOV2+U7LlLUpUs7pJUIYu7JFXI4i5JFfIHVc0af8iUusPirnnj9WKk0XG3jCRVyJ67JuWuFmnrZM9dkipkcZekCrlbRpI6aksOOrDnLkkVsrhLUoUs7pJUoZEU94g4NiK+HREbIuLsUTyGJGmwWf9BNSIWAh8AXgBsBK6LiDWZ+a3Zfiz9ynSOR/fYdal+o+i5rwQ2ZOadmflz4GPAiSN4HEnSAJGZs7vAiJOBYzPzD8v0K4HDMvP1rbjVwOoy+RvAt/ssbk/g+0M+dM2xXcmjC7FdyaMLsV3JY2uL7UoesxG7f2aO9b1HZs7qAJwCfLhn+pXA+2a4rHXGdiePLsR2JY8uxHYlj60ttit5jPL5ZeZIdstsBPbrmV4C3DuCx5EkDTCK4n4dsDwiDoiIHYCXAWtG8DiSpAFm/WiZzHw0Il4PXAksBC7KzFtnuLgLjO1UHl2I7UoeXYjtSh5bW2xX8hjl85v9H1QlSfPPM1QlqUIWd0mqkMVdkipkcZekClncBUBEvKBP25Mj4il92p/Rp22fiNinjI9FxEsi4jeHfOx3Dhl3QFnugX3mLY2IJ5bxiIhTI+J9EfHHETHhqLCIOGE8fsjHfm5E/EYZf05EvDEi+l6MJyIWRcTJEfGGiPiTciG9vp+1iDgwIt4cEedHxHvL+NOGzass49QByz06Iha12o8dsIyVEfFbZfygiDgrIl405ONfOmTcc8pyX9hn3mER8eQyvmNEvC0iPhsR50bELq3YMyJiv/YyBjzmDhHxqog4pky/IiLeHxGnR8T2A+7zlLJ+3xsRfx0Rf9TOoSe2E+uv73K7dLRMRPwb4CRgMZA0Jz9dlplXDIhdAqzNzLt62l+TmRe1YlcCmZnXRcRBwLHA7Zl5+RA5XZqZr9rSfKd4jL/IzLdPEXNVZh7Vp3134PXlsS8E3gI8G7gNeGdmbh4yh7szc2nP9EuB9wAPANsDr87M68q8GzLzWT2xrwPOBgI4F3g1cCtwBPBfM/PCntjz2w9NcxbzpQCZeUZP7Gcy86QyfmLJ52rgt4F3ZebFPbG3ACsz85GIOBd4CvAZ4Kiy3Ne0nu+/Aj8BvgB8FLgyMx8b8Nq8h+aaSdvRHOJ7dLnf84D1mfmm1uv2JuBG4PnA12k6UU8H/iAzb+6JfTPwcprrL20szUtozg35WGae0y+fPvm1190ZwOk074FDgDMz87Iy73HrrrS9FTiuPL8vAYfRvM7HlNflHT2x7XNWojzPqwAy84Se2G9k5soy/tqS06eBFwKf7X1+EXErcHA5lPoC4BHgkzSv9cGZ+ZKe2Idp1t13aNbdJzJz04DX5m/L89oJeAhYBPx9WW5k5qpW/BnA7wJfAV4EfBPYDLwY+PeZeXVPbCfW30DTPaV1VAPNB/fy8sI8pwwvK23vbcW+E/hquc93gD/pmXdDK/atwDXAOuBdNG/Cvyj3/7NW7JrW8Fngx+PTM813iOd+d2v6ptZwM/Cz8elW7OU0BfWDNB/I9wG/A7ydZkMz2fPrfZ4/acV+E9i3jK8EbgdeUqbXt2Jvpvnw7FFer31K+27AN1uxG4G/AV4FrCrDpvHxVuz6nvGvAweU8T2BG1ux3+oZvx5Y0DP9uNjxZZf8XgusBe4HPgQ8r0/srTRFbCeaD/pOpX174JY+626nnjyvLOPPAL7eiv1nYPs+j7cDcMcU74nHvTf6rI9FZXwZzXv/zH7rrid+YXl+PwSeXNp37PN+u6GsvyNpNm5HAveV8ee1YnvX33XAWBnfGbi5FXvbJJ/h9ntoPc0G84U0HZpNwBXlPfSk9utWbrcr63hhmY72c+t9Lcr4TsDVZXxp+7XryvobWFeGDRz1APzzgPbo80LdDGxXxnelKXDn9XvyI3zjDp1vaf/hgOFHwKOt2DUljwOB/csKvqeM79/vjV8e93tTfCg2A8ePP5+e4Ujg/vbr1prel6ZonsHED98NPePtotteH0+i2TB+BFhc2u4c8Fr2LvcbUyz3SuCoMv6p8deJZoPTr7i3n8M+5bn9E3BPa94t5faJ5TXcsUwvpGej0vN+G/9GvCOPL3DtDcHt7fVZ2vcHvt1qu5+mF7d/a1gG3NuKbee0iKb4vbv9nmi/ln1e1/Z7aAHwBpoe/iFTrL8baTage9C6Nkqfx/kEcGoZ/1/AijL+68B1U6y77YETaHrxm9rrjqbY7kbzWdu9Z13e1ifnm4EnlPHdgOu7vv4GDTMuxrM90GzFVvZpX8kkW/kyvZBmC/4J4NY5euMOnW9pvxvYe8Cy7unT9mKabxcnDJHHbjQ9i4eBZaV9jz5vki8Azx+wnK+2pr8OPKXV9iSaXm67p7GO0oMBlvS0P5E+hbXMOxT4MvBG4K4BMY/xqw3gz/nVN4IdmLhh3q8s76s030Q203xLWw8c3WfZA3tA7Q8szTejf6Tpff63svw/A74IfKhP7JU0u8f+EXhLad+9z3vzWGBDWS8XlOGK0nZsK/ZC4DkD8v1Ia/qq8fdvT9t2NLu+Hutz/2v51beN3m88u9AqpD3zltB83t5P65tnT8xdwJ3Av5Tb8fW3iImfvV2Ai2m+iV8L/KLc5ys0u2WGXXc7tqbfUJbzXZqN91rgf9IU8bf2uf+ZNJ+pC2iK9/gGZ4yJn5FOrL+Br8WwgaMeaD7s1wLfKh+aL9Lsc7oWOLQV+zn6f33+S+CXc/TGfdaw+fbkNmFjUOadO6B9Z5qt9Rpg44CYl9P0Cu4Hfg/4B5qN0/eA1VuwPg4Glvdp355m33Fv21L6fz1dDBwzyWMEzb7Fv5lmbrsCzx4w72k0/x/wezT7jhcMiDtymo/5bODwMv4Umo3SS/stn2Zf7RuBF/S0LaD0CFuxC4DDS74nl/GFM11vPe/ffQbMO6JP24S8SvuewNOneKzjaX7bmU5+O1F2sfWZ96Ty3juUwZ2hX5/m4/0a8Gs9752TB30WS8xvlpgDh1j2vK+/QUOnflCF5qgLmqIQNAXt//aJ2REgM/+1z7zFmfm9nuknZObP+sTtSbNP+eb2vJ6Y42lezLdsSb5bKiIOpilmHxowfyHNroBHy5Ehh9DsorlvQPze9PwInJn3T/LY1cZ2KY8+91+UmT+ez9iu5NGF2JnEz7fOFPeIeEZm3jTbsSV+KfDDzHwoIpYBK2iOlrllS2JL/AqaXQKP0uxrv32KXIaOn+3YiHgmzQ+vu9D07KHpJTxEcyTADT2xh9D8wNgv9o8zc/0IYts5TJbvjJc7gzxGEjuZ9hEU8xHblTy6ENsvPppDgi+g2Yh/AXhzlqPTeo8UmkHs02l2HU0ZO5lZvyrkFlgfEf9C86PIR3Py/1wdOjaaP+h+HfCziPgrmq/L/wd4W0RcmJnvnmHs84C/pvnQHlridouIXwCvzMx7WnkMHT+qWJofql6Xmde2cju8zDu4p/niSWIvHlFsO4fJ8t2S5U43fiSxEXEW/QXNfmlGHduVPLoQO4P4/w78Z5qj8f4Q+FpEnJCZ36HZfTnT2A9OI3agLp3EdBPNMeMLgDURcWNEnF16z1sS+0rgIJpjrs8DficzT6P54fM1WxD7HuC4zDyGZv/7LzLzCOAdND+etE0nflSxO7eLDkBmXkOzf39bie1KHu+k+TH8Sa1hERM/m6OK7UoeXYidbvyizLwiMx/KzL+iOd/kirIhb+8SGVXsYP12xM/HwMTDm1bS/Jh4DxOPD55O7PhxrgtpTsjp/VF1wjHK043tie89bO/WPs9v6PgRxp4PfB74fZoTgX67jH8eeP+2EtuVPGiOSJrw43uZ1z4ccySxXcmjC7EzWPaNwC6ttmcAdwA/mIvYyYYu7XNfn5nP7NMewHMz8yszjL2Y5tC5nWnOenuU5nClo2hOeHjpDGMvotmKrqU5OuN7mXlWROxEU2Afd4r8dOJHFVvijytx//9HYJoTtCacrVtzbBfyiOZyBg9mn7MrI2Lv7PkRdlSxXcmjC7EzWPYraA5RvqYVtxT488x87ahjJ9Ol4v6KzPzICGK3o/nT7qQ5nfkwmsMH7wY+kJk/mWHs9jRnNx5Es6W9KDMfi+ZInr0y87utPIaOH1WspG3IsF18h61/oDmC4xya4/F/UIbbStuu20psV/Loib19vmK7kkcXYruSx3RzHjR05gfVaK6k9/aIuDUiHo6ITRFxTUS8ekSxq2Yp9papcphu/KhigY/TnLn5/MzcIzP3oLno00M0J21tK7FdyWM89shW7OY5jO1KHl2I7Uoe0825v2G3AqMegMtoria4BDgL+HNgOXAJrTPgtrbYruRB63oXk82rObYreXQhtit5dCG2K3lMN+eBscMGjnpg4gWnriu3C2hOItpqY7uSB80lEv6UntO6gb2BNwP/sK3EdiWPLsR2JY8uxHYlj+nmPGjozG4Z4CcR8RyAiPhd4EGAzPwlzREHW3NsV/L4fZoLin0lIjZHxIM0lwneneY6KdtKbFfy6EJsV/LoQmxX8phuzv0NuxUY9UBzHOc3aPZNfo1ycSCaq7GdsTXHdiyPA2n+hGFRq/3YbSm2K3l0IbYreXQhtit5TDfnvs9j2MD5HCiX3awxdi7zoLnk6bdp/qHoLuDEnnntE8Oqje1KHl2I7UoeXYjtSh7TzXng53/YwPkcGHDZ3Rpi5zIPpvEPLzXHdiWPLsR2JY8uxHYlj+nmPGjozIXDImLQVR6D5seErTa2Q3kszHLJ0sy8KyKOBD4ZEfszcf98zbFdyaMLsV3JowuxXcljujn3N+xWYNQD0/sbqq0qtit5MI1/eKk5tit5dCG2K3l0IbYreUw350HDjArxKAam9zdUW1VsV/JgGv/wUnNsV/LoQmxX8uhCbFfymG7Og4bOXFtGkjR7unScuyRplljcJalCFndJqpDFXZolEbFwvnOQxlnctU2KiP8SEWf2TL8jIs6IiDdFxHURcVNEvK1n/mci4vpoLge9uqf9x9Fccvla4Nlz/DSkgSzu2lZdCKwCiIgFwMtozhlYTvOfvIcAh0bEc0v8azLzUGAFcEZE7FHad6b5f93DMvNrc/kEpMl05gxVaS5lc+bfDyLimTRn8q4Hfgt4YRmH5h/vlwNfpSnoLy7t+5X2HwCPAZ+ay9ylYVjctS37MM0fnewDXAQcDbwrM/9Hb1A5/fsY4NmZ+UhEXA08scz+aWY+NlcJS8Nyt4y2ZZ8GjqXpsV9ZhtdExCKAiFgcEXvR/Kfl5lLYDwQOn6+EpWHZc9c2KzN/HhFfBh4qve8vRsTTgH+KCIAfA/8OuAL4o3KRtm8D18xXztKwvPyAtlnlh9QbgFMy8475zkeaTe6W0TYpIg4CNgBrLeyqkT13SaqQPXdJqpDFXZIqZHGXpApZ3CWpQhZ3SaqQxV2SKvT/AIbeoepwlyN2AAAAAElFTkSuQmCC",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df.groupby('year').size().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Trend of TED Talks frequency by Month"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x261ebe40e88>"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAEzCAYAAADKCUOEAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAgAElEQVR4nO3debhddX3v8fcnAWRQCMOBIoNBDQ5VJoOCcFsF9QFpgVapoJU8ym24VxSpHUy1z5W2Pi3OLd4WSUUaLNVGlBLFKY2AogKGwTDfRAYTQRKQqaBY4HP/WL9Ddk72ydk5WWsd9uLzep79nL1+e+39/Z1z1v7utX/rN8g2ERHRLdOmugIREVG/JPeIiA5Kco+I6KAk94iIDkpyj4jooCT3iIgO2myqKwCw0047eebMmVNdjYiIoXL11Vffa3uk32NPi+Q+c+ZMli5dOtXViIgYKpLuHO+xNMtERHRQkntERAcluUdEdFCSe0REByW5R0R0UJJ7REQHJblHRHRQkntERAc9LQYxbcjMeRdP6nl3nHFUzTWJiBgeOXOPiOigJPeIiA5Kco+I6KAJk7ukF0m6ruf2kKTTJO0gabGk5eXn9mV/STpT0gpJyyQd0PyvERERvSZM7rZvtb2f7f2AVwCPAhcC84AltmcBS8o2wJHArHKbC5zVRMUjImJ8G9ssczjwE9t3AscAC0r5AuDYcv8Y4DxXrgBmSNq1ltpGRMRANja5Hw98odzfxfbdAOXnzqV8N2Blz3NWlbJ1SJoraamkpWvWrNnIakRExIYMnNwlbQEcDXxpol37lHm9Anu+7dm2Z4+M9F1IJCIiJmljztyPBK6xfU/Zvme0uaX8XF3KVwF79Dxvd+CuTa1oREQMbmOS+wmsbZIBWATMKffnABf1lJ9Yes0cBDw42nwTERHtGGj6AUlbA68HTu4pPgNYKOkk4KfAcaX868AbgRVUPWveUVttIyJiIAMld9uPAjuOKbuPqvfM2H0NnFJL7aZA5rKJiC7ICNWIiA5Kco+I6KAk94iIDkpyj4jooCT3iIgOSnKPiOigJPeIiA5Kco+I6KAk94iIDkpyj4jooCT3iIgOSnKPiOigJPeIiA5Kco+I6KAk94iIDkpyj4jooCT3iIgOSnKPiOigJPeIiA4aKLlLmiHpAkm3SLpZ0sGSdpC0WNLy8nP7sq8knSlphaRlkg5o9leIiIixBj1z/wfgm7ZfDOwL3AzMA5bYngUsKdsARwKzym0ucFatNY6IiAlNmNwlbQv8FnAOgO1f234AOAZYUHZbABxb7h8DnOfKFcAMSbvWXvOIiBjXIGfuzwfWAOdKulbSZyVtA+xi+26A8nPnsv9uwMqe568qZRER0ZJBkvtmwAHAWbb3Bx5hbRNMP+pT5vV2kuZKWipp6Zo1awaqbEREDGaQ5L4KWGX7yrJ9AVWyv2e0uaX8XN2z/x49z98duGvsi9qeb3u27dkjIyOTrX9ERPQxYXK3/XNgpaQXlaLDgZuARcCcUjYHuKjcXwScWHrNHAQ8ONp8ExER7dhswP3eA5wvaQvgNuAdVB8MCyWdBPwUOK7s+3XgjcAK4NGyb0REtGig5G77OmB2n4cO77OvgVM2sV7PGDPnXTyp591xxlE11yQiumTQM/foiHyYRDwzZPqBiIgOypl7NCrfFCKmRs7cIyI6KMk9IqKDktwjIjooyT0iooOS3CMiOijJPSKig5LcIyI6KMk9IqKDktwjIjooyT0iooOS3CMiOijJPSKig5LcIyI6KMk9IqKDktwjIjooyT0iooOS3CMiOmig5C7pDknXS7pO0tJStoOkxZKWl5/bl3JJOlPSCknLJB3Q5C8QERHr25gz99fa3s/27LI9D1hiexawpGwDHAnMKre5wFl1VTYiIgazKc0yxwALyv0FwLE95ee5cgUwQ9KumxAnIiI20qDJ3cC3JV0taW4p28X23QDl586lfDdgZc9zV5WydUiaK2mppKVr1qyZXO0jIqKvzQbc7xDbd0naGVgs6ZYN7Ks+ZV6vwJ4PzAeYPXv2eo9HRMTkDZTcbd9Vfq6WdCHwSuAeSbvavrs0u6wuu68C9uh5+u7AXTXWOWJcM+ddPKnn3XHGUTXXJGJqTdgsI2kbSc8ZvQ+8AbgBWATMKbvNAS4q9xcBJ5ZeMwcBD44230RERDsGOXPfBbhQ0uj+/2b7m5J+BCyUdBLwU+C4sv/XgTcCK4BHgXfUXuuIiNigCZO77duAffuU3wcc3qfcwCm11C4iIiYlI1QjIjooyT0iooOS3CMiOijJPSKig5LcIyI6KMk9IqKDktwjIjooyT0iooOS3CMiOijJPSKigwad8jcixsgMlPF0ljP3iIgOSnKPiOigJPeIiA5Kco+I6KAk94iIDkpyj4jooCT3iIgOSnKPiOiggZO7pOmSrpX0tbK9l6QrJS2X9O+StijlzyrbK8rjM5upekREjGdjztzfC9zcs/0R4FO2ZwH3AyeV8pOA+22/EPhU2S8iIlo0UHKXtDtwFPDZsi3gMOCCsssC4Nhy/5iyTXn88LJ/RES0ZNAz978H/hx4smzvCDxg+/GyvQrYrdzfDVgJUB5/sOwfEREtmTC5S/odYLXtq3uL++zqAR7rfd25kpZKWrpmzZqBKhsREYMZ5Mz9EOBoSXcAX6Rqjvl7YIak0VkldwfuKvdXAXsAlMe3A34x9kVtz7c92/bskZGRTfolIiJiXRMmd9t/YXt32zOB44Hv2H4bcAnw5rLbHOCicn9R2aY8/h3b6525R0REczaln/v7gfdJWkHVpn5OKT8H2LGUvw+Yt2lVjIiIjbVRi3XYvhS4tNy/DXhln31+BRxXQ90iImKSMkI1IqKDktwjIjooyT0iooOS3CMiOijJPSKig5LcIyI6KMk9IqKDktwjIjooyT0iooM2aoRqREydmfMuntTz7jjjqJprEsMgZ+4RER2U5B4R0UFJ7hERHZTkHhHRQbmgGhF95QLucMuZe0REByW5R0R0UJplIuJpIc1A9cqZe0REByW5R0R00ITJXdKWkq6S9GNJN0r6q1K+l6QrJS2X9O+StijlzyrbK8rjM5v9FSIiYqxBztwfAw6zvS+wH3CEpIOAjwCfsj0LuB84qex/EnC/7RcCnyr7RUREiyZM7q78V9ncvNwMHAZcUMoXAMeW+8eUbcrjh0tSbTWOiIgJDdTmLmm6pOuA1cBi4CfAA7YfL7usAnYr93cDVgKUxx8EduzzmnMlLZW0dM2aNZv2W0RExDoGSu62n7C9H7A78ErgJf12Kz/7naV7vQJ7vu3ZtmePjIwMWt+IiBjARvWWsf0AcClwEDBD0mg/+d2Bu8r9VcAeAOXx7YBf1FHZiIgYzCC9ZUYkzSj3twJeB9wMXAK8uew2B7io3F9UtimPf8f2emfuERHRnEFGqO4KLJA0nerDYKHtr0m6CfiipA8D1wLnlP3PAT4vaQXVGfvxDdQ7IiI2YMLkbnsZsH+f8tuo2t/Hlv8KOK6W2kVExKRkhGpERAcluUdEdFCSe0REByW5R0R0UJJ7REQHJblHRHRQkntERAcluUdEdFCSe0REByW5R0R0UJJ7REQHJblHRHRQkntERAcluUdEdFCSe0REByW5R0R0UJJ7REQHJblHRHRQkntERAcluUdEdNCEyV3SHpIukXSzpBslvbeU7yBpsaTl5ef2pVySzpS0QtIySQc0/UtERMS6Bjlzfxz4E9svAQ4CTpH0UmAesMT2LGBJ2QY4EphVbnOBs2qvdUREbNCEyd323bavKfcfBm4GdgOOARaU3RYAx5b7xwDnuXIFMEPSrrXXPCIixrXZxuwsaSawP3AlsIvtu6H6AJC0c9ltN2Blz9NWlbK7x7zWXKoze/bcc89JVD0iYvJmzrt4Us+744yjaq5JMwa+oCrp2cCXgdNsP7ShXfuUeb0Ce77t2bZnj4yMDFqNiIgYwEDJXdLmVIn9fNtfKcX3jDa3lJ+rS/kqYI+ep+8O3FVPdSMiYhCD9JYRcA5ws+1P9jy0CJhT7s8BLuopP7H0mjkIeHC0+SYiItoxSJv7IcDbgeslXVfKPgCcASyUdBLwU+C48tjXgTcCK4BHgXfUWuOIiJjQhMnd9uX0b0cHOLzP/gZO2cR6RUTEJsgI1YiIDkpyj4jooCT3iIgOSnKPiOigJPeIiA5Kco+I6KAk94iIDkpyj4jooCT3iIgO2qgpfyMiYnLanmI4Z+4RER2U5B4R0UFJ7hERHZTkHhHRQUnuEREdlOQeEdFBSe4RER2U5B4R0UFJ7hERHTRhcpf0OUmrJd3QU7aDpMWSlpef25dySTpT0gpJyyQd0GTlIyKiv0HO3P8FOGJM2Txgie1ZwJKyDXAkMKvc5gJn1VPNiIjYGBMmd9vfBX4xpvgYYEG5vwA4tqf8PFeuAGZI2rWuykZExGAm2+a+i+27AcrPnUv5bsDKnv1WlbL1SJoraamkpWvWrJlkNSIiop+6L6iqT5n77Wh7vu3ZtmePjIzUXI2IiGe2ySb3e0abW8rP1aV8FbBHz367A3dNvnoRETEZk03ui4A55f4c4KKe8hNLr5mDgAdHm28iIqI9Ey7WIekLwGuAnSStAj4EnAEslHQS8FPguLL714E3AiuAR4F3NFDniIiYwITJ3fYJ4zx0eJ99DZyyqZWKiIhNkxGqEREdlOQeEdFBSe4RER2U5B4R0UFJ7hERHZTkHhHRQUnuEREdlOQeEdFBSe4RER2U5B4R0UFJ7hERHZTkHhHRQUnuEREdlOQeEdFBSe4RER2U5B4R0UFJ7hERHZTkHhHRQUnuEREdlOQeEdFBjSR3SUdIulXSCknzmogRERHjqz25S5oO/CNwJPBS4ARJL607TkREjK+JM/dXAits32b718AXgWMaiBMREeOQ7XpfUHozcITt/1m23w68yva7x+w3F5hbNl8E3DqJcDsB925CdRMv8boQK/GeufGeZ3uk3wObbVp9+lKfsvU+QWzPB+ZvUiBpqe3Zm/IaiZd4wx4r8RKvnyaaZVYBe/Rs7w7c1UCciIgYRxPJ/UfALEl7SdoCOB5Y1ECciIgYR+3NMrYfl/Ru4FvAdOBztm+sO06xSc06iZd4HYmVeIm3ntovqEZExNTLCNWIiA5Kco+I6KAk9+gsSVtJetFU1yNiKgxdcpf0O5Jaqbek6ZI+1rVYzwSSfhe4Dvhm2d5PUmO9tiR9XNJvNvX6feJNl/SvLcdr9fiU9LI247VF0rslbd90nKFL7lRdK5dL+qiklzQZyPYTwCsk9RuYNbSxekk6RNJiSf9P0m2Sbpd0W80xdtjQrc5YPU6nmgrjAQDb1wEzG4oFcAswX9KVkv6XpO0ajDV6vIyU7saNm6Lj8zOSrpL0LkkzmgwkackgZTX5DeBHkhaWSRYb+ZsOZW8ZSdsCJwDvoBr9ei7wBdsPNxDrE8As4EvAI6Pltr8yzLF6Yt4C/DFwNfBET8z7aoxxO9X/qe/oZdvPrytWT8wrbb9K0rW29y9ly2zvU3esMXFfRHVcngB8H/hn25c0FOts4ACqcSS9x8snG4o3FcfnLOCdwHHAVcC5thfX+PpbAlsDlwCvYe0xui3wDduNnECWhP4GqmNlNrAQOMf2T+qK0cT0A42z/ZCkLwNbAacBvwf8maQzbX+65nA7APcBh/VWAWjigG4z1qgHbX+jwdfH9l5Nvv44bpD0VmB6SRCnAj9oMmCZEfXF5XYv8GPgfZJOtn18AyHvKrdpwHMaeP2xWj8+bS+X9JfAUuBMYP+SGD9Q04fKyVQ55LlUJzijyf0hqtltG2Hbkn4O/Bx4HNgeuEDSYtt/XkeMoTtzl3Q01afdC4DPAwtsr5a0NXCz7edNaQWHhKQDyt0/oBps9hXgsdHHbV9TY6wX276lJ+Y66ozVE3Nr4INUZ0eiGlT3N7Z/VXesEu+TwNHAEqozsKt6HrvVdmMXdiVtY/uRifccLpL2oXqvHwUspvq7XiPpucAP63yvS3pPAyeG48U6FZhDdQLwWeA/bP93uZa43PYLaokzhMl9AdU/+bt9Hjvcdq3tZJL2Bs4CdrH9snLAHW37w3XGmYJYG2oqsO3DNvD4xsaab3vuODFrjTVVJL0T+KLtR/s8tp3tBxuIeTBwDvBs23tK2hc42fa76o5V4rV2fJZ43wX+GbjA9i/HPPZ225+vMdZxwDdtP1y+KRwAfLihE4+/ohq5f2efx15i++Za4gxTci9fe79l+3UtxrwM+DPg7J622xts134lv81YbStnJQfb/n5L8fYG/pTqIupTzY91f5CM922kJ17tyaEn9pXAm4FFbRwvHT8+l9neR9KhwN8BH6dq+nlVzXGmAcva+JsNVZu77SckPdrUmdA4trZ91ZgL2o93IBYAkv4W+KjtB8r29sCf2P7LOuPYflLSx4GD63zdDfgS8Bmqr71PTLDvpvjEBh4z67ZP1872yjHHS5O/a6vHZ7lW8ndUK7ptOVrexAV41v7djgLOsn2RpNPrDlLeBz+WtKftn9b9+r2GKrkXvwKul7SYda/Yn9pQvHslvYAyJ72qxUju7kCsUUfa/sDohu37Jb0RqDW5F9+W9CbgK27+K+Pjts9qOAa2X9t0jA1YKenVgEuXyFOBWr7Sj6Pt4/Nc4EPAp4DXUrW/N9UV82el99HrgI9IehbNdRXfFbhR0lWsm8OOrjPIUDXLAEia06/c9oKG4j2fasa2VwP3A7cDb+vXXjZMsXpiLgMOtP1Y2d4KWGq79gE5kh4GtqE6S/ol1RvVtrdtINbpwGrgQta9UPyLumOVeCf2K7d9XhPxSsydgH+gSkjTqC4av7fObqxj4rV6fEq62vYrJF1v++Wl7Hu2/0cDsbYGjgCuLz10dgVebvvbDcT67X7lti+rNc6wJfepImkbYFoTfemnONafU/XyOJfqjOydVG24H206dpNK3/qxGulTX+L19rTYEjgcuMb2m5uIN5XaOj4lfR/4H8AFwHeAnwFnNNHzSNKe/cqbbjpp0tAl95bb4ZC0I9VXw0Opkt/lwF83cXbUZqwxcY+gOvsT8G3b32ow1u+z9vf7nu3/aCrWVFI1QvXzdX/VHhPj+VRn7gdR/T1/CPyx7VpHGPfEa/X4lHQgVTPTDOBvgO2org9d0UCs61k70G5LYC/g1oa+wR4EfBp4CbAFVVfkR+r+BjuMyf1y1rbD/S6lHc72hxqKtxj4LjA6j8fbgNc00WOnzVglXqu9jyT9E/BC4Aul6C3AT2yf0kCs1ptJxsTfnKpXRGNTZEi6gmqgzejf83jgPXX38OiJ1+rxOZVKL6iTbZ/cwGsvpfpffYlqdOqJwKzea1+1xBnC5N5aO1xvvDFljSye22asntdfBLy9jd5Hkm4EXjZ6MbV0C7u+obOjVptJJH2VtQvBT6f6ZrnQ9vubiFdiXjk2kUu6wvZBDcVr5fjUBBO8NfltaEw9rrG9wa6uk3zdpbZnq2c6DEk/sP3qOuMMZW+ZkhSWq1rO72fAzg3Gu0TS8VRzP0DVr/jiDsQa1Wbvo1uBPYHRC3B7AMsaiIPt9/RujzaTNBGr+Dhrk/vjwJ22f9ZEIK2dbO0SSfOAL5bYb6HZ46Wt4/NgYCXVN5Iraa6HzFMkva9ncxrVIKY1DYV7tPRuuk7SR6l6HG1Td5BhPHNvpR2u9OwYbYPbBniyPDQN+K8628fajNUndmu9j8ogmAOpJoCi3P8h8GiJ2WT7dCPNJGP+d71M1UvnJ8AHXePIabU8EVvbx2dpLnw91eRr+1B9gHzBza3FjKTeZt3HgTuAL7uB6SokPY+qJ9fmVJP2bQf8k+0VtcYZtuQew2tMFzBRXZg7AXgX1NsVbCqaSfrUYTrwMuD8LozinAqlv/kJwMeoLt62Mv9LFwxdclc1P8l6la57WPmYmPuw/jD2RmbCUzUx2m+VzUttf62JOD3x2u59tB/wVqoJy26nGtBU+xu2fJC00kwyQF1Otn12A687nWpE5UzWPTYbmfK3xGzlvVCS+lFUiX0m1bTGn2uwqatfO/+DVLNRnl3nGXzPN6911P2eG8Y29z/tub8l8CaaHQL9Oaqvhjey9utoI9OcSjqDqqni/FL0XkmH2p5Xd6wejY8CVDXPy/FUb9T7gH+nOrGofXTnhppJJDXSTDKRJhJ78VXKNRPWHpuNaeu9oGpywJcB3wD+yvYNdb7+OG4HRli3J9c9wN5Uk5e9vcZYvRegt6Saq772RWuG7sy9H0mX2e476quG177J9kubeO0+sZYB+9l+smxPB651gwtMtNH7SNKTwPeAk0bbFSXd1tS3gw3Uo1PNJGph8ZEx8Vp5L5TjZfTifm+CanJE83dt/1a/Mkk3NtGja0ysy20fWudrDt2Zu9Zdlm0a8AqqZaua8kNJL7V9U4Mxes0ARofIN7pUW9FG76M3UZ25XyLpm1S9O1pdThCeWirux2O6SQ6zb0h6QxND5MfRynvB9lQs/zminsm8yojVncpjv64zkNadSXQa1Zl87YutDF1yp1otZfRr9+NUX6dOajDeAqqD+udUvR9Gzx6aOGP6O+Dacl1BVG3vtQ5s6OM0qmXGTqXqfXQY1UICtbF9IXBhGbZ+LFUPgV0knQVc2GJyGq1PU80kbbuC6u86DfhvGjyzLdp8L7TtT4DLJf2E6vfaC3hXOWbr7jnWO5PoaM+cP6g5xnA1y6jlOcFLzBXA+xjTrunmJkvalardXcCVtn/eRJypVr6BHQe8pcmL4V2maiHzY6kGgjX+Rm77vdC2chH3xVTvvVua6AbZpqFK7gCSfmi7rTnBkfSdtpKPpCW2D5+orKZYT4tRgDF5kr5FNWVz4xdTS7zW3gtta3O6ivIh8ibW73X013XGGcZmmTbnBAe4RdK/UfVM6J06trYeAlq7AvtOqhbL6F2B/bl1xRmj9VGAUbu7gUslfYN1j82mukI2/l6YQgf23H9qugqgibmILqLqZnk1PX/Hug1jcn8fZU5wSY3OCV5sRfUPeENPWd3dv6ZiBfbfYO0owLfSwijAqN3t5bZFuTWtjffClGh5uordbR/R0Gs/ZeiaZbpMLa7APiZuRgEOMUnb2H5k4j1jUGW6iuttv7iB154PfNr29XW/dq+p6HK0yST9vqRPSvqEpGMbjrW3pCWSbijb+6haHb0JT0qa0RN7e0mNrGRfXv9ZquZX/1fgFOBMOnAW9kwh6WBJN1GW1pO0r6pplZuK1+Z7oVWSvippUbldTDXJXVNrDRwKXC3pVknLJF1fxrjUaujO3NXinOAlXmsrvku6zvZ+Y8quHY1bc6zeUYBfbGkUYNRI0pVUMzMuavrYLK/d2nuhbVp33qPHqZpGT2gir6iaOGw9dfc6GsY2999m3TnBF1B1zWpKmyu+T5Oknt9tOs21pb6dahTg3sCpPb9f09cwoka2V445Np9oMFyb74VW2b5M68979OWGYt0JIGlneuZzqtswJvfW5gQv2lzx/dvAQkmfKfH+N/DNJgJN0SjAqNdKSa+mmjdnC6qBaDc3GK/N90Ir1OK8Rz0xj6YayPRcqql/n0f1f6t1ioOhaZbR2ilct2PtnOAGXgX8wM0tRdfaiu+StgL+iGpRYFEl+3PKsPmIdUjaiWoN1afWvwVOtf2LDT5x8vH6vRf+0PYdTcRrw1TMeyTpx1Qjwf/T9v6SXkvVBDS3zjjDdOb+8SmKe6ft16nBFd8lbQb8LdWMjCup3qh7UL15ptHsV+0YXi+y/bbeAkmHAI2M4Ha18Haj74UpMBXzHv237fskTZM0zfYlkj5Sd5Ch+Wpu+7LRG9VcDJuX+1dRDTZoyu2l69JBwH81FONjVFN+Pt/2AeVi1V5U31Km6kMtnv76dVltrBurpL+VNMP2I7YfLr25PtxUvDbYvtD2W6imHbiUnnmPJL1hg0+evAckPZvqG8P5kv6BBq5dDE2zzChJfwTMBXaw/QJVi018pokh+iXeVsDvUn26HwB8jap3yeU1xlgO7D12xG25oHqL7Vl1xYrhJ+lgqqaR06jm4R+1LfB7tvdtKO56PbfU0CLSU6npeY8kbU01D7+AP6T6v51fd3Pa0Jy59zgFOIRq9Ca2l9PgAtm2f2l7oe3fB/an+kfUthzc2jDrf8qWtvbh+vSNNmwBPJuqWfU5PbeHqLpGNmV6GfAGPHXi86wN7D+UbP/C9tl1J3ZJD0t6CPg58ADVdYv/S9Uke6ukKyTVdpI6TG3uox6z/evR7lilvbrRBFj6wL4FOBL4EfVPz3mTpBPHTlIk6Q+BW2qOFUOuNEdeJulfbN8paduquPE28H8Flkg6l+o9907qnw63s2yPO2e7ehaSKT832TA2y3yU6lPvROA9VIsr32T7gw3Fux24DlhINVik9mHeknajGhn6S9bOV38g1Vwev+cpWvsznt4kzaZaJnE0aTwIvNP21Q3GPIKe3jm2v9VUrGci1bje7jAm92lUi3O8geoA+xbw2aZmiJS0re2HmnjtPrEOo+rrKuBGt7jOZwyfMmT9FNvfK9uHAv/kZpdlfB4wy/Z/lrbj6R3pNdM5Q5Pc1bMEVstxd6fqgXAI1Rn15cB7ba9quy4RvSR93/YhE5XVGK/VzgyxaYbpgupTk/hIamRY8DjOBRZRjSbbjWou63NbjB8xnqsknS3pNZJ+u8y7dKmkA7TuOp11abUzQ2yaYbqg2juwoLHRY32M2O5N5v8i6bQW40eMZ3SSuQ+NKX811bfMurvxtd6ZISZvmJK7x7nftHtLr5XRWShH56CImFJNzn8yjsskfQDYStLrqTozfLXlOsSAhqnN/QmqWQxF1Yvk0dGHaHAWQ0l7UvVFPZjqQ+UHVG3unVgUOIaXpF2o+kg/1/aRkl5KtYD8OQ3Fa7UzQ2yaoUnuEbEuVWunngt80Pa+pZnkWtsvbzDmCIDtNU3FiHoMU7NMqyT9nw08bNt/01plIvrbyfZCSX8BYPvx8g23Vqoa2T8EvJvqjF0lzqdt/3Xd8aIew9Rbpm2P9LlB9bX0/VNVqYgej0jakbXzqx9ENZCpbqdR9ZI50PaOtnegmmr7EEl/3EC8qEGaZQYg6TnAe6kS+0LgE7ZXT22t4pmudHf8NNVw9RuAEeDNtmtdvFV/lSkAAAKQSURBVEbStcDrbd87pnyEapRq7ctAxqbLmfsGSNqhTGm6jKoJ6wDb709ij6kk6UBJv2H7GqplJz8APEa1WEcTg+s2H5vY4al2980biBc1SHIfh6SPUU0S9jDwctun275/iqsVAXA28Oty/9XAB4F/pJplcH4D8X49ycdiCqVZZhxl+a3HqCbR7/0jZQHpmFKSfjw6Z7ukfwTW2D69bF9ne78NPX8S8Ua7Ia/3ELCl7Zy9Pw2lt8w4soB0PI1Nl7SZ7ceBw6nmexlV+3va9vS6XzOal+QeMXy+QDVa9F6qaaJHZ4V8Ic30lokhlGaZiCFUuj3uStVb5ZFStjfw7HKhNZ7hktwjIjoo7coRER2U5B4R0UFJ7hGTIGmGpHf1bL9G0temsk4RvZLcIyZnBtV85hFPS0nu0XmSZkq6RdJnJd0g6XxJr5P0fUnLJb2yTDXxH5KWSbpC0j7luadL+pykSyXdJunU8rJnAC+QdF0ZzQzwbEkXlFjna3TJoogpkH7u8UzxQuA4qgE/PwLeChwKHE01N8tKqrnQj5V0GHAea5exezHwWuA5wK2SzgLmAS8bHQ0q6TXA/sBvAncB36eaSfHyNn65iLFy5h7PFLfbvt72k8CNwJKygtD1wEyqRP95ANvfAXaUtF157sW2HyuTZ60GdhknxlW2V5UY15XXjZgSSe7xTPFYz/0ne7afpPoG268JZXQQSO9zn2D8b7yD7hfRuCT3iMp3gbfBU00s99p+aAP7P0zVTBPxtJQzi4jK6cC5kpZRLb4+Z0M7276vXJC9AfgGcHHzVYwYXKYfiIjooDTLRER0UJJ7REQHJblHRHRQkntERAcluUdEdFCSe0REByW5R0R0UJJ7REQH/X8skOipc0lDlAAAAABJRU5ErkJggg==",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df.groupby('month').size().sort_values(ascending = False ).plot(kind='bar')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Trend of TED Talks frequency by Month in 2020"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_pr=df[df['year'] == '2020']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "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>title</th>\n",
       "      <th>author</th>\n",
       "      <th>date</th>\n",
       "      <th>views</th>\n",
       "      <th>likes</th>\n",
       "      <th>link</th>\n",
       "      <th>VTL_Ratio</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>How music can help you find peace after loss</td>\n",
       "      <td>Steven Sharp Nelson</td>\n",
       "      <td>September 2020</td>\n",
       "      <td>1500000</td>\n",
       "      <td>47000</td>\n",
       "      <td>https://ted.com/talks/steven_sharp_nelson_how_...</td>\n",
       "      <td>31.91</td>\n",
       "      <td>2020</td>\n",
       "      <td>September</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>The informal settlements reshaping the world</td>\n",
       "      <td>Jota Samper</td>\n",
       "      <td>September 2020</td>\n",
       "      <td>1600000</td>\n",
       "      <td>49000</td>\n",
       "      <td>https://ted.com/talks/jota_samper_the_informal...</td>\n",
       "      <td>32.65</td>\n",
       "      <td>2020</td>\n",
       "      <td>September</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263</th>\n",
       "      <td>The (de)colonizing of beauty</td>\n",
       "      <td>Sasha Sarago</td>\n",
       "      <td>November 2020</td>\n",
       "      <td>1600000</td>\n",
       "      <td>48000</td>\n",
       "      <td>https://ted.com/talks/sasha_sarago_the_de_colo...</td>\n",
       "      <td>33.33</td>\n",
       "      <td>2020</td>\n",
       "      <td>November</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>3 myths about racism that keep the US from pro...</td>\n",
       "      <td>Candis Watts Smith</td>\n",
       "      <td>February 2020</td>\n",
       "      <td>1800000</td>\n",
       "      <td>55000</td>\n",
       "      <td>https://ted.com/talks/candis_watts_smith_3_myt...</td>\n",
       "      <td>32.73</td>\n",
       "      <td>2020</td>\n",
       "      <td>February</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>Why aren't there more Native American restaura...</td>\n",
       "      <td>Sean Sherman</td>\n",
       "      <td>August 2020</td>\n",
       "      <td>1900000</td>\n",
       "      <td>58000</td>\n",
       "      <td>https://ted.com/talks/sean_sherman_why_aren_t_...</td>\n",
       "      <td>32.76</td>\n",
       "      <td>2020</td>\n",
       "      <td>August</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1090</th>\n",
       "      <td>The Artists | Think Like A Coder, Ep 5</td>\n",
       "      <td>Alex Rosenthal</td>\n",
       "      <td>January 2020</td>\n",
       "      <td>408000</td>\n",
       "      <td>12000</td>\n",
       "      <td>https://ted.com/talks/alex_rosenthal_the_artis...</td>\n",
       "      <td>34.00</td>\n",
       "      <td>2020</td>\n",
       "      <td>January</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1093</th>\n",
       "      <td>Can you solve the dragon jousting riddle?</td>\n",
       "      <td>Alex Gendler</td>\n",
       "      <td>January 2020</td>\n",
       "      <td>2200000</td>\n",
       "      <td>66000</td>\n",
       "      <td>https://ted.com/talks/alex_gendler_can_you_sol...</td>\n",
       "      <td>33.33</td>\n",
       "      <td>2020</td>\n",
       "      <td>January</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1096</th>\n",
       "      <td>The mysterious life and death of Rasputin</td>\n",
       "      <td>Eden Girma</td>\n",
       "      <td>January 2020</td>\n",
       "      <td>3000000</td>\n",
       "      <td>92000</td>\n",
       "      <td>https://ted.com/talks/eden_girma_the_mysteriou...</td>\n",
       "      <td>32.61</td>\n",
       "      <td>2020</td>\n",
       "      <td>January</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1099</th>\n",
       "      <td>Could a breathalyzer detect cancer?</td>\n",
       "      <td>Julian Burschka</td>\n",
       "      <td>January 2020</td>\n",
       "      <td>228000</td>\n",
       "      <td>6800</td>\n",
       "      <td>https://ted.com/talks/julian_burschka_could_a_...</td>\n",
       "      <td>33.53</td>\n",
       "      <td>2020</td>\n",
       "      <td>January</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1104</th>\n",
       "      <td>A brief history of alcohol</td>\n",
       "      <td>Rod Phillips</td>\n",
       "      <td>January 2020</td>\n",
       "      <td>4700000</td>\n",
       "      <td>141000</td>\n",
       "      <td>https://ted.com/talks/rod_phillips_a_brief_his...</td>\n",
       "      <td>33.33</td>\n",
       "      <td>2020</td>\n",
       "      <td>January</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>501 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  title               author  \\\n",
       "234        How music can help you find peace after loss  Steven Sharp Nelson   \n",
       "253       The informal settlements reshaping the world           Jota Samper   \n",
       "263                        The (de)colonizing of beauty         Sasha Sarago   \n",
       "265   3 myths about racism that keep the US from pro...   Candis Watts Smith   \n",
       "275   Why aren't there more Native American restaura...         Sean Sherman   \n",
       "...                                                 ...                  ...   \n",
       "1090             The Artists | Think Like A Coder, Ep 5       Alex Rosenthal   \n",
       "1093          Can you solve the dragon jousting riddle?         Alex Gendler   \n",
       "1096          The mysterious life and death of Rasputin           Eden Girma   \n",
       "1099                Could a breathalyzer detect cancer?      Julian Burschka   \n",
       "1104                         A brief history of alcohol         Rod Phillips   \n",
       "\n",
       "                date    views   likes  \\\n",
       "234   September 2020  1500000   47000   \n",
       "253   September 2020  1600000   49000   \n",
       "263    November 2020  1600000   48000   \n",
       "265    February 2020  1800000   55000   \n",
       "275      August 2020  1900000   58000   \n",
       "...              ...      ...     ...   \n",
       "1090    January 2020   408000   12000   \n",
       "1093    January 2020  2200000   66000   \n",
       "1096    January 2020  3000000   92000   \n",
       "1099    January 2020   228000    6800   \n",
       "1104    January 2020  4700000  141000   \n",
       "\n",
       "                                                   link  VTL_Ratio  year  \\\n",
       "234   https://ted.com/talks/steven_sharp_nelson_how_...      31.91  2020   \n",
       "253   https://ted.com/talks/jota_samper_the_informal...      32.65  2020   \n",
       "263   https://ted.com/talks/sasha_sarago_the_de_colo...      33.33  2020   \n",
       "265   https://ted.com/talks/candis_watts_smith_3_myt...      32.73  2020   \n",
       "275   https://ted.com/talks/sean_sherman_why_aren_t_...      32.76  2020   \n",
       "...                                                 ...        ...   ...   \n",
       "1090  https://ted.com/talks/alex_rosenthal_the_artis...      34.00  2020   \n",
       "1093  https://ted.com/talks/alex_gendler_can_you_sol...      33.33  2020   \n",
       "1096  https://ted.com/talks/eden_girma_the_mysteriou...      32.61  2020   \n",
       "1099  https://ted.com/talks/julian_burschka_could_a_...      33.53  2020   \n",
       "1104  https://ted.com/talks/rod_phillips_a_brief_his...      33.33  2020   \n",
       "\n",
       "          month  \n",
       "234   September  \n",
       "253   September  \n",
       "263    November  \n",
       "265    February  \n",
       "275      August  \n",
       "...         ...  \n",
       "1090    January  \n",
       "1093    January  \n",
       "1096    January  \n",
       "1099    January  \n",
       "1104    January  \n",
       "\n",
       "[501 rows x 9 columns]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_pr"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x261ecea9048>"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAEzCAYAAADKCUOEAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAfP0lEQVR4nO3debhkVX3u8e/bDIIok7QEQW00qDE4gI0yJSoYHw1RSSIKGiWRG7zXAYcMdDTPhSQ+BsfEGEWIiK3hqgQHUK4DQUBRAbsBmbkgoKAojYoQNGjDe/9Y+9DVh+rhnNqrqmv1+3me85xTu6r2b+1zav/O2muvQbaJiIi2LJh0ASIion9J7hERDUpyj4hoUJJ7RESDktwjIhqU5B4R0aBN1/UCSR8B/gC4zfbu3bbtgU8Bi4CbgJfY/pkkAe8Dfh/4BfCnti9eV4wddtjBixYtmuchRERsnJYvX3677YXDnltncgc+Cvwr8LGBbUuAs20fJ2lJ9/ho4PnAbt3XM4Dju+9rtWjRIpYtW7YeRYmIiBmSvrem59bZLGP7a8BPZ21+EbC0+3kpcPDA9o+5uADYVtJOcy9yRESMYr5t7jvavhWg+/7wbvvOwM0Dr7ul2xYREWPU9w1VDdk2dH4DSUdKWiZp2YoVK3ouRkTExm2+yf3HM80t3ffbuu23AI8ceN0uwA+H7cD2ibYX2168cOHQ+wERETFP803uZwCHdz8fDpw+sP2VKvYGfj7TfBMREeOzPl0hPwE8C9hB0i3AMcBxwKmSjgC+DxzSvfz/UrpBXk/pCvlnFcocERHrsM7kbvuwNTx14JDXGnjtqIWKiIjRZIRqRESD1mcQ00QtWnLmvN5303EH9VySiIjpkZp7RESDktwjIhqU5B4R0aAk94iIBiW5R0Q0KMk9IqJBSe4REQ1Kco+IaFCSe0REg5LcIyIalOQeEdGgJPeIiAYluUdENCjJPSKiQUnuERENSnKPiGhQkntERIOS3CMiGpTkHhHRoCT3iIgGJblHRDQoyT0iokFJ7hERDUpyj4hoUJJ7RESDktwjIhqU5B4R0aAk94iIBiW5R0Q0KMk9IqJBSe4REQ1Kco+IaNBIyV3SmyRdKekKSZ+QtIWkXSVdKOk6SZ+StHlfhY2IiPUz7+QuaWfgKGCx7d2BTYBDgXcA/2R7N+BnwBF9FDQiItbfqM0ymwJbStoUeDBwK3AAcFr3/FLg4BFjRETEHM07udv+AfBu4PuUpP5zYDlwh+2V3ctuAXYe9n5JR0paJmnZihUr5luMiIgYYpRmme2AFwG7Ao8AtgKeP+SlHvZ+2yfaXmx78cKFC+dbjIiIGGKUZpnnADfaXmH718BngH2BbbtmGoBdgB+OWMaIiJijUZL794G9JT1YkoADgauAc4AXd685HDh9tCJGRMRcjdLmfiHlxunFwOXdvk4EjgbeLOl64GHAST2UMyIi5mDTdb9kzWwfAxwza/MNwNNH2W9ERIwmI1QjIhqU5B4R0aAk94iIBiW5R0Q0KMk9IqJBSe4REQ1Kco+IaFCSe0REg5LcIyIalOQeEdGgJPeIiAYluUdENCjJPSKiQUnuERENSnKPiGhQkntERIOS3CMiGpTkHhHRoCT3iIgGJblHRDQoyT0iokFJ7hERDdp00gXY0Cxacua83nfTcQf1XJKIiPlLzT0iokFJ7hERDUpyj4hoUJJ7RESDktwjIhqU5B4R0aAk94iIBiW5R0Q0KMk9IqJBSe4REQ1Kco+IaNBIyV3StpJOk3SNpKsl7SNpe0lnSbqu+75dX4WNiIj1M2rN/X3Al2w/AXgKcDWwBDjb9m7A2d3jiIgYo3knd0lbA78LnARg+1e27wBeBCztXrYUOHjUQkZExNyMUnN/DLACOFnSJZI+LGkrYEfbtwJ03x8+7M2SjpS0TNKyFStWjFCMiIiYbZTkvimwJ3C87T2Au5lDE4ztE20vtr144cKFIxQjIiJmGyW53wLcYvvC7vFplGT/Y0k7AXTfbxutiBERMVfzTu62fwTcLOnx3aYDgauAM4DDu22HA6ePVMKIiJizUZfZez1wiqTNgRuAP6P8wzhV0hHA94FDRowRERFzNFJyt30psHjIUweOst+IiBhNRqhGRDQoyT0iokFJ7hERDUpyj4hoUJJ7RESDktwjIhqU5B4R0aAk94iIBiW5R0Q0KMk9IqJBSe4REQ1Kco+IaFCSe0REg5LcIyIalOQeEdGgJPeIiAYluUdENCjJPSKiQUnuERENSnKPiGjQSAtkx+gWLTlzXu+76biDei5JRLQkNfeIiAYluUdENCjJPSKiQWlz38ikjT9i45Cae0REg5LcIyIalOQeEdGgtLlHVWnjj5iM1NwjIhqUmns0JVcKEUVq7hERDUpyj4ho0MjJXdImki6R9IXu8a6SLpR0naRPSdp89GJGRMRc9FFzfwNw9cDjdwD/ZHs34GfAET3EiIiIORgpuUvaBTgI+HD3WMABwGndS5YCB48SIyIi5m7Umvs/A38N3Nc9fhhwh+2V3eNbgJ1HjBEREXM07+Qu6Q+A22wvH9w85KVew/uPlLRM0rIVK1bMtxgRETHEKDX3/YAXSroJ+CSlOeafgW0lzfSf3wX44bA32z7R9mLbixcuXDhCMSIiYrZ5J3fbf2N7F9uLgEOBr9p+OXAO8OLuZYcDp49cyoiImJMa/dyPBt4s6XpKG/xJFWJERMRa9DL9gO1zgXO7n28Ant7HfiMiYn4yQjUiokFJ7hERDUpyj4hoUJJ7RESDktwjIhqU5B4R0aAk94iIBiW5R0Q0KMk9IqJBSe4REQ3qZfqBiI3RoiVnzut9Nx13UM8liXig1NwjIhqUmnvElMiVQsxFau4REQ1Kco+IaFCSe0REg5LcIyIalOQeEdGgJPeIiAYluUdENCjJPSKiQUnuERENygjViBgqI2KnW2ruERENSnKPiGhQkntERIOS3CMiGpTkHhHRoCT3iIgGpStkRGwQ0vWyX6m5R0Q0KMk9IqJBSe4REQ1Kco+IaNC8k7ukR0o6R9LVkq6U9IZu+/aSzpJ0Xfd9u/6KGxER62OU3jIrgb+wfbGkhwLLJZ0F/Clwtu3jJC0BlgBHj17UiIj+tN47Z941d9u32r64+/ku4GpgZ+BFwNLuZUuBg0ctZEREzE0vbe6SFgF7ABcCO9q+Fco/AODha3jPkZKWSVq2YsWKPooRERGdkZO7pIcAnwbeaPvO9X2f7RNtL7a9eOHChaMWIyIiBow0QlXSZpTEfortz3SbfyxpJ9u3StoJuG3UQkZETLtxt/GP0ltGwEnA1bbfO/DUGcDh3c+HA6fPN0ZERMzPKDX3/YBXAJdLurTb9hbgOOBUSUcA3wcOGa2IERExV/NO7rbPB7SGpw+c734jImJ0GaEaEdGgJPeIiAYluUdENCjJPSKiQUnuERENSnKPiGhQkntERIOS3CMiGpTkHhHRoCT3iIgGJblHRDQoyT0iokFJ7hERDUpyj4hoUJJ7RESDktwjIhqU5B4R0aAk94iIBiW5R0Q0KMk9IqJBSe4REQ1Kco+IaFCSe0REg5LcIyIalOQeEdGgJPeIiAYluUdENCjJPSKiQUnuERENSnKPiGhQkntERIOS3CMiGpTkHhHRoCT3iIgGVUnukp4n6VpJ10taUiNGRESsWe/JXdImwAeA5wNPBA6T9MS+40RExJrVqLk/Hbje9g22fwV8EnhRhTgREbEGst3vDqUXA8+z/T+6x68AnmH7dbNedyRwZPfw8cC18wi3A3D7CMVNvMRrIVbibbzxHm174bAnNh2tPENpyLYH/AexfSJw4kiBpGW2F4+yj8RLvGmPlXiJN0yNZplbgEcOPN4F+GGFOBERsQY1kvu3gd0k7Sppc+BQ4IwKcSIiYg16b5axvVLS64AvA5sAH7F9Zd9xOiM16yRe4jUSK/ES7wF6v6EaERGTlxGqERENSnKPiGhQkvtaSNpS0uMnXY6IiLmaquQuaRNJ7xpTrBcAlwJf6h4/VVLVXj/jPL6BmLuPM964SfoDSdU/55LeLem3a8eZlO6z+e+TLkctkl4nabsxxqt+rk9Vcrd9L/A0ScMGSvXtWMpUCnd0sS8FFtUMOObjm/EhSRdJeo2kbWsHk7SfpLMk/T9JN0i6UdINFUMeClwn6Z2SfqtinGuAEyVdKOl/StqmRhBJ26/tq0ZMuP+zubDr3lydpLPXZ1uPfgP4tqRTu4kPq56D4zjXp663jKT3ALsB/wHcPbPd9md6jnOh7WdIusT2Ht22y2w/uc84Q+KO5fhmxdwNeBVwCHARcLLtsyrFugZ4E7AcuHdmu+2f1IjXxdwaOAz4M8po6ZOBT9i+q0Ksx3dxDgO+Afyb7XN63P+NlGMYOhLc9mP6ijUk9gnAnpRxK4Ofzff2GGML4MHAOcCzWHWcWwNftF3tH3SXaJ9L+fstBk4FTrL93Urxqp7rNaYfqG174CfAAQPbDPSd/K6Q9DJgky75HQV8s+cYw4zr+Fbt3L5O0t8Cy4B/AfboPuhvqfBP5ee2v9jzPtfK9p2SPg1sCbwR+EPgryT9i+339xWnmxH1Cd3X7cB3gDdLerXtQ/uIYXvXPvYzTz/svhYAD60U49WUv9EjKBWAmeR+J2W22WpsW9KPgB8BK4HtgNMknWX7ryuErHquT13NfVwkPRh4K+U/uSiDsv7B9n9PtGA9k/RkSk3lIOAsSk3lYkmPAL5l+9E9xdmz+/EllMFtnwHumXne9sV9xBkS94WU43ss8HFgqe3bur/v1T0e33uBFwJnU36HFw08d63tXm7MS3qC7WsGfp+rqfV7nFWGrWzfve5XjhTj9X3+412PeEcBh1P+KX8Y+JztX3f3a66z/dhxlaUvU5fcJT0OOB7Y0fbuXXJ6oe23TbhovRj38Un6GvBvwGm2fznruVfY/nhPcdbWNGHbB6zl+VHiLqUk268Nee5A272040p6FfBJ278Y8tw2tn/eU5wTbR+5ht9ntd9jF3sf4CTgIbYfJekpwKttv6ZCrEOAL9m+q7uq3BN4W8VKwN9RRtN/b8hzv2X76goxq57r05jczwP+CjhhoC38Ctu99vrofvF/SbmJen/zVc2Tp4s7luPbGHTNJF+2/ZyKMYbWoGfUSEZdbXIf29/oe9/riHsh8GLgjNqfzZn7W5L2B/4ReDelmfAZFWItAC4b9zlW+1yfxjb3B9u+aNZN5pUV4vwH8CHKJdq963htn8Z1fMD9N1P/kbJq1hYz22vdmJP0duCdtu/oHm8H/IXtv+07lu17Jf2iz5rzEO9ZWxFYvT21F7bvk/RuYJ++970esW+e9dmsdW7M7Pcg4Hjbp0s6tkag7vf5HUmPsv39GjHWoOq5Po3J/XZJj6WbI15lcZBbK8RZafv4Cvtdl3Ed34yTgWOAfwKeTWmfrtkN7Pm23zLzwPbPJP0+0Hty7/w3cLmks1i9R8JRfezc9rP72M88fEXSHwOf8fguv2+WtC/grkvkUUDvzRWdH3S9c54DvEPSg6jbdXsn4EpJF7H65+SFFWNWPdensVnmMZQZ1PYFfgbcCLx8WFvZiHGOBW4DPsvqN/5+2mecIXHHcnwD8Zbbfpqky20/qdv2ddu/UyneZcBetu/pHm8JLLNdZQCQpMOHbbe9tOc4r1xDnI/1GWcg3l3AVpQa7i8p/5Bte+sa8bqYOwDvoyTcBZROBm+o0Y21u+H9PODyrjfXTsCTbH+l71hdvGcO2277vBrxuphVz/WpS+4zJG0FLKjRV7nb/41DNlftRzwrftXjG4jzDeB3gNOArwI/AI7rq3fHkHh/TelVcjKlxvIqShvuO2vEGxdJgz07tgAOBC62/eIJFWmqSXrUsO1jbjYZi1rn+tQld0kPozQj7E9JDucDf19zEMw4jfv4JO1FubTeFvgHYBtKm/gFNeJ1MZ9Hqf0J+IrtL1eMNdZ7CgNxtwE+XvOyXtIfsepz8nXbn6sVq4v3GErNfe8u5reAN9nufYSxpMtZNVhrC2BX4NqKV3h7A+8HfgvYnNJd9+7KV0JVz/VpTO5nAV8DZua5eDnwrL57RIz7Mnsg7liObxLG0XtlSMzzWXVP4QV09xRsH1M57maUHhhVRlRK+iDwm8Anuk0vBb5r+7U14nUxL6AMJJqJeSjw+ho9WIbE3pPS7fLVlfa/jHI8/0EZnfpKYLfB+0MVYlY916cxuS+3/bRZ23pfXHZSl9ljPL61ToJWq8bZxX1Fxd4rs+ON5Z6CpM+zaiH4TShXCqfaPrrPOAPxrgR2n7mZ2nXnu7xWzbaLceHsRC7pAtt714o5K9bFttfa9XSEfS+zvVgDU4xI+qbtfWvE6/Zf9Vyfxt4y50g6lDLvA5R+t2f2HcT26wcfz1xm9x1niLEcH6Ub3c2UWtiF1O0hM6hq75Vh8brEd53K8o8/AB5eIc67WZXcVwLfs/2DCnFmXAs8Cpi5+fZI4LIagbRqQrJzJC0BPkk51pdS57OJpDcPPFxAGcS0okaszi+6HkCXSnonpdfKVhXjQeVzfWpq7l3vgJk2uK2A+7qnFgD/VbNtrItf+zJ7rMfXNZH8HmWCqydTPlSfcL31bmfijqX3ykC8qvcUZv3dBpnSy+q7wFvd00jYgbjnAXtRJnqj+/lbwC+g3ysvTWCyMkmDzWYrgZuAT7vS9B+SHk3pHbcZZWK7bYAP2r6+QqyxnOtTk9zHbdyX2ZPU9SE+DHgX5YbO2Ob0aFn3D3R34JS+Rz/O6ronyk25w4DXQN0ufDEdpjK5q0wG9bvdw3Ntf6FCjGcy3svswdhP5oHTHvQ+K2SX1A+iJIVFlKlcP1LzOCcwIvYcVv0d7+fK00jMKsOrbZ9QYb9PBV5GmYztRsqApmr/mLt/VgfxwM9mb1P+DsQadk/o55SZS0/ouwY/cHWymjH0qqp2rk9dm7uk4yiXoKd0m94gaX/bS3ra/xovsyVVu8weiP8RSjPJlay6XOt9yl+VCbV2B74I/J3tK/rc/1qMe0TsXw78vAXwx1SczmGYPhO7ypxHh1L+If8E+BSlkjaOkbKfp7tnwqrPZi03AgtZvTfQj4HHUSa6e0XP8QZvYm5BWdug2uInUP9cn7qaezfC8am27+sebwJc4sqLaAzEqnKZPRDjKttPrLHvWXHuY9UNzcEPQdWRjuMeEbuGMpxne+iIxA1d93f7OnDETHuwpBvGMbhOY1isZiDW12z/7rBtkq6s2StoIN75tvevuP+q5/rU1dw72wIz0wBUWc5sGJelsb4zq5tk374l6Ym2r6oYA9uTWmJxXL1XgNV6ekC5YfU0ypJq0+qPKTX3cyR9idJzZVw9nb4o6bm1pgCYZaEGJvLqRqzu0D33q76DafXZPRdQavK1FiSZUfVcn8bk/o/AJV1bqiht79UGGgxTo/10wFLKH/1HlN4WMzXpsdSYxuCNlGXUjqL0XjmAskhCLctZ1cy2knK5f0TFeFXZ/izw2W7I+sGUnh07Sjoe+GzlxHtBF3sB8GvqXuX9BXC+pO92cXYFXtMdd42eVYOze870znlJhTiDqp7rU9csA6AyidBelF/GhbZ/NOEi9UbS9cCbmdWu6UoTh7VME5r3fNy6q5NDgJfWvFGsspD5wZTBUtUTR3fD/wmU8/yaWt0gJ6X2uT51yV3S2bYPXNe2aSXpq+PsyTEuExwR+y3bY5/3vEWSvkyZsrn2zdRJzLL5IEqT1yJW77ny9zXidTGrnutT0yyjVaui76CywMPgquiPmFjB+neNpP9D6ZkwONVwtQWyx2RSI2InMe95q24FzpX0RVb/bPbeFZJyZT7j/uk/gFpzO51O6Wq5nIFjq6zquT41yZ0Jroo+ZltS/tDPHdjWe1fICfgNVo2IfRljGhFLuezdCrhX0ljmPW/Yjd3X5t1XNROY/mMX28+ruP9hqp7r09gsM9ZV0aN/GRE73SRtZfvudb+y15ibUdr6n1Bp/ycC77d9eY39T8KkusON4j5J2848kLSdpN5XX58USY+TdLakK7rHT1ZZ/X3qSXqQyhzk/w68FvgXxnBFIumPJL1X0nskHVw7Xqsk7SPpKrql9SQ9RWXq4RqxPi/pjO7rTMpEaTXnq98fWC7pWkmXSbq8G1NTTe1zfRpr7pfafuqsbZe4Wz182qnyiuiTMmtE7CfHNSJWE5j3vFWSLqTMXHhG7c/mrLlzVlKa0w6r9XdTmTjsAWr2Uqt9rk9Tm/uMBZI0c3OsGzVatf1vzKquiD5Br6CMiH0ccNTA8dVuA38mq897vpTS9SzmwfbNsz6b91aKc54eOHfOp2vE6uJ9D0DSwxmY86iyquf6NCb3rwCnSvoQ5ebD/wK+NNki9arqiuiTMsERsWOb93wjcLOkfSnzLG1OGYh2dZ8BJjV3jspkhO+hdNi4DXg05dhqTnNQ9VyfxmaZLYE/pyzqLEqyP6mbGmDqqfKK6BsLrZqyeRtWzXtu4BnAN93AsoXjJmkHyhqq969/Cxxl+6drfePcYkxk7hxJ36GMlv5P23tIejalGejIijGHnet/YvumPvY/NTV3SZsCb6fMIngz5cP1SMovZAGVLg8n4Hu2n6NKK6JvRN496QI06PG2Xz64QdJ+QJ8jgCc1d86vbf9E0gJJC2yfI+kdNQO6LCxe7Vyfpt4y76JMwfkY23t2NyB2pdTMWjqRb+y6Ze0N/NekCzOtbJ8380WZJ2Sz7ueLKINhYu6GdVnttRur7c/afill2oFzGZg7R9Jz1/rm0dwh6SGUq4ZTJL2Pyve6JL1d0ra277Z9V9fz72297X9ammUkXQc8bvYow+6G6jW2d5tMyfrVNTu9gFJ72RP4AqV3yfkTLdiUkvTnwJHA9rYfq7JYyIdama5iHCTtQ2k6eCNlHv4ZWwN/aPspleNXnztH0oMpc9UL+BPKsZ3SZ5PTkJgP6OWnHhcBn6aau4cNH+/a2qfjP9R6sP1L26fa/iNgD8qHLEumzd9rgf0oI5mxfR0Vpxhu1ObAQyjNuA8d+LqT0jWyKts/tX1CjcQu6S5JdwI/Au6gtH3/K6UJ+FpJF0iqVRHYpBvQN1OWLYEHreX1czI1be7AVZJeOXviIEl/AlwzoTJV0fXxfSnwfODb1J96tGX32P7VTHez7t5NM5WBceias86T9FHb35O0ddk8/feDbK9xznYNLM7Tfe/bvwNnSzqZ8pl8FT1OZzxNzTI7U0Yz/pJVc3TvRZmf4Q89pvVNa1NZy/FS4FTKYJGxDvNujaR3UmpkrwReT1lA+irbb51owaaQpMWUZRJnEuLPgVfZXj65UtWnSmvgdvt+HgO9j2x/ubd9T0tynyHpAErfUwFXutJappMiaWvbd066HK1QmdP9CMrkTAK+DHw4M0TOXTcc/7W2v9493h/4oNtZSGbsupGxu9n+z67df5O+roimLrm3TtIulB4I+1GuTs4H3mD7lokWbMpoYIm26Iekb9jeb13bYv3Uvtk/TTdUNxYnA2dQRsrtTJnr+eSJlmg63T/JlKRqw9Y3MhdJOkHSsyQ9s5u351xJe2r1NUhj/VS92T9NN1Q3FgttDybzj0p648RKM70GB75UHd24EZmZsO+YWdv3pVxlNreCWGVVb/YnuW94bu96AM3MYjgzx0bMjdfwc8xT7fldNkLnSXoLsKWk36Pc7P98XztPm/sGRtKjKP1s96EkpW9S2twzt8wcSLqXMgulKD2qfjHzFFmJaV4k7Ujp//0I28+X9ETKAuQnTbhoU6n2zf4k94hYLyprp54MvNX2U7pmhEtsP2nCRZtakhYC2F7R977TLLOBkPS/1/K0bf/D2AoTMdwOtk+V9DcAtld2V0gxByqN7McAr6PU2NX9Ht9v++/7ipPeMhuOu4d8QblsO3pShYoYcLekh7Fq/vG9KQOZYm7eSOkls5fth9nenjIV9X6S3tRXkDTLbIAkPRR4AyWxnwq8x/Ztky1VbOy67o7vpwzFvwJYCLzYdhY/mQNJlwC/Z/v2WdsXUkap9rJkaGruGxBJ23dTfl5GaTLb0/bRSewxSZL2kvQbti+mLFv4FuAeymIdGVw3d5vNTuxwf7v7Zn0FSXLfQEh6F2WSsLuAJ9k+1vbPJlysCIATgF91P+8LvBX4AGUGxRMnVagp9qt5PjcnaZbZQHTLi91DWSBg8I+SrnsxUZK+MzNnu6QPACtsH9s9vtT2U9f2/ljdQDfdBzwFbGG7l9p7estsICa4gHTEumwiaVPbK4EDKfOhzEgOmSPbm4wjTv4wEbEun6CMprydMuX2zKyQv0l6y2yw0iwTEevUdXvcidKb4+5u2+OAh3Q3WmMDk+QeEdGgtPNGRDQoyT0iokFJ7hHzIGlbSa8ZePwsSV+YZJkiBiW5R8zPtpT5tyM2SEnu0TxJiyRdI+nDkq6QdIqk50j6hqTrJD29m/rhc5Iuk3SBpCd37z1W0kcknSvpBklHdbs9DnispEu70cUAD5F0WhfrFM0ssRMxAennHhuL3wQOoQzA+TbwMmB/4IWUuVJupsxNfrCkA4CPsWpZuScAzwYeClwr6XhgCbD7zOhMSc8C9gB+G/gh8A3KzH/nj+PgImZLzT02Fjfavtz2fcCVwNndijeXA4soif7jALa/CjxM0jbde8+0fU832dNtwI5riHGR7Vu6GJd2+42YiCT32FjcM/DzfQOP76NcwQ5rQpkZBDL43ntZ8xXv+r4uorok94jia8DL4f4mlttt37mW199FaaaJ2CClZhFRHAucLOkyymLah6/txbZ/0t2QvQL4InBm/SJGrL9MPxAR0aA0y0RENCjJPSKiQUnuERENSnKPiGhQkntERIOS3CMiGpTkHhHRoCT3iIgG/X+8a5XpiG+lOwAAAABJRU5ErkJggg==",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_pr.groupby('month').size().sort_values(ascending = False ).plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x261ecf3b2c8>"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXAAAAEzCAYAAAAo1Vj9AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAgAElEQVR4nO3de7RdZX3u8e+TAILIVTYURQxaRK0XwKAitCqIA0uLtEoFreZUTuM5XpDai6l2HLF1tNRbL54WSUWaWqoiSkEZqGkEFC9gAsidEwVUBEmgIggWG3jOH+9cZGVnZe+VnTnnWnPl+Yyxx15zrsvv3XOu/Vvveud7kW0iIqJ75o26ABERMTdJ4BERHZUEHhHRUUngEREdlQQeEdFRSeARER21TZvB9thjDy9YsKDNkBERnbdq1aq7bU9N399qAl+wYAErV65sM2REROdJ+v6g/WlCiYjoqCTwiIiOSgKPiOioJPCIiI5KAo+I6Kgk8IiIjkoCj4joqCTwiIiOanUgz0wWLLlwTs+77bRjai5JREQ3pAYeEdFRsyZwSQdIurrv5z5Jp0jaXdJySaur37u1UeCIiChmTeC2b7Z9oO0DgecBDwLnAUuAFbb3B1ZU2xER0ZLNbUI5Evie7e8DrwSWVfuXAcfVWbCIiJjZ5ibwE4BPVrf3sn0nQPV7zzoLFhERMxs6gUvaDjgW+MzmBJC0WNJKSSvXrl27ueWLiIhN2Jwa+CuAK23fVW3fJWlvgOr3mkFPsr3U9kLbC6emNpqPPCIi5mhzEviJrG8+AbgAWFTdXgScX1ehIiJidkMlcEmPBY4CPte3+zTgKEmrq/tOq794ERGxKUONxLT9IPD4afvuofRKiYiIEchIzIiIjkoCj4joqCTwiIiOSgKPiOioJPCIiI5KAo+I6Kgk8IiIjkoCj4joqCTwiIiOSgKPiOioJPCIiI5KAo+I6Kgk8IiIjkoCj4joqCTwiIiOSgKPiOioJPCIiI5KAo+I6Kgk8IiIjkoCj4joqGFXpd9V0rmSbpJ0o6RDJe0uabmk1dXv3ZoubERErDdsDfzvgC/afjrwXOBGYAmwwvb+wIpqOyIiWjJrApe0M/BrwJkAtn9h+17glcCy6mHLgOOaKmRERGxsmBr4U4C1wFmSrpL0MUk7AnvZvhOg+r3noCdLWixppaSVa9eura3gERFbu2ES+DbAwcDptg8CHmAzmktsL7W90PbCqampORYzIiKmGyaB3w7cbvvyavtcSkK/S9LeANXvNc0UMSIiBpk1gdv+MfBDSQdUu44EbgAuABZV+xYB5zdSwoiIGGibIR/3NuBsSdsBtwC/R0n+50g6CfgBcHwzRYyIiEGGSuC2rwYWDrjryHqLExERw8pIzIiIjkoCj4joqCTwiIiOSgKPiOioJPCIiI5KAo+I6Kgk8IiIjkoCj4joqCTwiIiOGnYo/cRZsOTCOT3vttOOqbkkERFzkxp4RERHJYFHRHRUEnhEREclgUdEdFQSeERERyWBR0R0VBJ4RERHJYFHRHRUEnhEREclgUdEdNRQQ+kl3QbcDzwMrLO9UNLuwKeBBcBtwO/Y/kkzxYyIiOk2pwb+UtsH2u6tTr8EWGF7f2BFtR0RES3ZkiaUVwLLqtvLgOO2vDgRETGsYRO4gS9LWiVpcbVvL9t3AlS/9xz0REmLJa2UtHLt2rVbXuKIiACGn072MNt3SNoTWC7ppmED2F4KLAVYuHCh51DGiIgYYKgauO07qt9rgPOA5wN3SdoboPq9pqlCRkTExmZN4JJ2lLRT7zbwcuA64AJgUfWwRcD5TRUyIiI2NkwTyl7AeZJ6j/8321+U9G3gHEknAT8Ajm+umBERMd2sCdz2LcBzB+y/BziyiUJFRMTsMhIzIqKjksAjIjoqCTwioqOSwCMiOioJPCKio5LAIyI6Kgk8IqKjksAjIjoqCTwioqOSwCMiOioJPCKio5LAIyI6Kgk8IqKjksAjIjoqCTwioqOSwCMiOioJPCKio5LAIyI6Kgk8IqKjksAjIjpq6AQuab6kqyR9odreT9LlklZL+rSk7ZorZkRETLc5NfC3Azf2bf818De29wd+ApxUZ8EiImJmQyVwSfsAxwAfq7YFHAGcWz1kGXBcEwWMiIjBthnycX8L/AmwU7X9eOBe2+uq7duBJw56oqTFwGKAfffdd+4l7bgFSy6c0/NuO+2YmksSEZNi1hq4pN8A1the1b97wEM96Pm2l9peaHvh1NTUHIsZERHTDVMDPww4VtKvA9sDO1Nq5LtK2qaqhe8D3NFcMSMiYrpZa+C2/9T2PrYXACcAX7H9OuBi4NXVwxYB5zdWyoiI2MiW9AN/J/AOSd+ltImfWU+RIiJiGMNexATA9iXAJdXtW4Dn11+kiIgYRkZiRkR0VBJ4RERHJYFHRHRUEnhEREclgUdEdFQSeERERyWBR0R0VBJ4RERHJYFHRHRUEnhEREclgUdEdFQSeERERyWBR0R0VBJ4RERHJYFHRHRUEnhEREclgUdEdFQSeERERyWBR0R01KwJXNL2kq6Q9B1J10t6b7V/P0mXS1ot6dOStmu+uBER0TPMosYPAUfY/pmkbYHLJF0EvAP4G9ufkvRR4CTg9AbLGpthwZILN/s5t512TAMliYimzFoDd/GzanPb6sfAEcC51f5lwHGNlDAiIgYaqg1c0nxJVwNrgOXA94B7ba+rHnI78MRmihgREYMM04SC7YeBAyXtCpwHPGPQwwY9V9JiYDHAvvvuO8dixjibS3MNpMkmYkttVi8U2/cClwAvBHaV1PsA2Ae4YxPPWWp7oe2FU1NTW1LWiIjoM0wvlKmq5o2kHYCXATcCFwOvrh62CDi/qUJGRMTGhmlC2RtYJmk+JeGfY/sLkm4APiXpfcBVwJkNljPiUWmyiShmTeC2rwEOGrD/FuD5TRQqIiJml5GYEREdlQQeEdFRSeARER01VD/wiK1ZLprGuEoNPCKio5LAIyI6Kgk8IqKjksAjIjoqCTwioqPSCyVizKTXSwwrNfCIiI5KAo+I6Kgk8IiIjkoCj4joqCTwiIiOSi+UiK1cer10V2rgEREdlQQeEdFRaUKJiFalyaY+qYFHRHTUrAlc0pMkXSzpRknXS3p7tX93Scslra5+79Z8cSMiomeYJpR1wB/avlLSTsAqScuB/wGssH2apCXAEuCdzRU1ImLzTXKTzaw1cNt32r6yun0/cCPwROCVwLLqYcuA45oqZEREbGyz2sAlLQAOAi4H9rJ9J5QkD+xZd+EiImLThk7gkh4HfBY4xfZ9m/G8xZJWSlq5du3auZQxIiIGGCqBS9qWkrzPtv25avddkvau7t8bWDPoubaX2l5oe+HU1FQdZY6ICIbrhSLgTOBG2x/uu+sCYFF1exFwfv3Fi4iITRmmF8phwOuBayVdXe17F3AacI6kk4AfAMc3U8SIiBhk1gRu+zJAm7j7yHqLExERw8pIzIiIjkoCj4joqCTwiIiOSgKPiOioJPCIiI5KAo+I6Kgk8IiIjkoCj4joqCTwiIiOypqYERE1anMBidTAIyI6Kgk8IqKjksAjIjoqCTwioqOSwCMiOioJPCKio5LAIyI6Kgk8IqKjksAjIjoqCTwioqNmTeCSPi5pjaTr+vbtLmm5pNXV792aLWZEREw3TA38n4Gjp+1bAqywvT+wotqOiIgWzZrAbX8V+M9pu18JLKtuLwOOq7lcERExi7m2ge9l+06A6veem3qgpMWSVkpauXbt2jmGi4iI6Rq/iGl7qe2FthdOTU01HS4iYqsx1wR+l6S9Aarfa+orUkREDGOuCfwCYFF1exFwfj3FiYiIYQ3TjfCTwDeBAyTdLukk4DTgKEmrgaOq7YiIaNGsS6rZPnETdx1Zc1kiImIzZCRmRERHJYFHRHRUEnhEREclgUdEdFQSeERERyWBR0R0VBJ4RERHJYFHRHRUEnhEREclgUdEdFQSeERERyWBR0R0VBJ4RERHJYFHRHRUEnhEREclgUdEdFQSeERERyWBR0R0VBJ4RERHJYFHRHTUFiVwSUdLulnSdyUtqatQERExuzkncEnzgX8AXgE8EzhR0jPrKlhERMxsS2rgzwe+a/sW278APgW8sp5iRUTEbGR7bk+UXg0cbft/VtuvB15g+63THrcYWFxtHgDcPIdwewB3z6mgczPJ8Sb5b0u8xJvUeE+2PTV95zZbUBAN2LfRp4HtpcDSLYiDpJW2F27JayRe+7ESL/ESr9l4W9KEcjvwpL7tfYA7tqw4ERExrC1J4N8G9pe0n6TtgBOAC+opVkREzGbOTSi210l6K/AlYD7wcdvX11ayDW1RE0zijSxW4iVe4jUYb84XMSMiYrQyEjMioqOSwCMiOioJPCK2GpJ2kHTAqMtRl7FL4JLmS/rAqMvRNEnPainOVnE821Idz39tOV6r50/Sb0hqPDdI+qCkX2k6Tl+83wSuBr5YbR8oqbGec5LeKmm3pl4fxjCB234YeJ6kQQOFGiFpxTD7avZRSVdIerOkXZsKMqLjeZik5ZL+n6RbJN0q6ZaaY+w+00+dsfpVx3Oq6jrbuFGcP0qX4NWS3i/pGQ3GuQlYKulySf9L0i4NxgI4lTIFyL0Atq8GFjQY75eAb0s6p5r4r/ZzOJa9UCR9CNgf+AzwQG+/7c/VHGd74LHAxcBLWD+6dGfgIttNvnmRtD/wRuB44ArgLNvLG4jTyvHsi3cT8AfAKuDhvnj31BjjVsrI34Ejgm0/pa5YA2KfARxMGffQfzw/3FC8Vs9fFXNn4ETg9yjH+Szgk7bvbyDWAVWcE4GvA/9k++IG4lxu+wWSrrJ9ULXvGtvPqTtWX0wBL6f8fQuBc4AzbX+vjtffkqH0TdoduAc4om+fgbrfsG8CTgGeQEk2vWRwH2WmxUbZXi3pz4CVwN8DB1Un/F01/3O2dTx7fmr7ooZeGwDb+zX5+rO4o/qZB+zUQry2zx+275P0WWAHyv/IbwF/LOnvbX+krjjVrKZPr37uBr4DvEPSm2yfUFecynWSXgvMrypPJwPfqDnGBmxb0o+BHwPrgN2AcyUtt/0nW/r6Y1kDb5ukt9X5phwy5nMon8rHAMspn8pXSnoC8E3bT26zPHWQdHB183cog7s+BzzUu9/2lTXGerrtm/pibqDOWDOUYUfbD8z+yG6RdCzlvflU4BPAMttrJD0WuLGu96akDwPHAiso7/8r+u672XatFxur8r+bUiMWZRDiX9j+rzrj9MU7GVhE+WD6GPDvtv+7ur6w2vZTtzjGOCZwSU8DTgf2sv2sKtkda/t9DcU7Hvii7furGvHBwPuaTAKSvgr8E3Cu7Z9Pu+/1tj9RY6xWjqekmb722vYRM9y/ubGW2l68iZi1xhoQ+1DgTOBxtveV9FzgTbbf3FC8tv8fllES6lcH3Hek7VquD0l6I/Ap2w8OuG8X2z+tI86oSHovZYT69wfc9wzbN25xjDFN4JcCfwyc0ddWdZ3tRnpu9NrBJB0O/BXwQUozxguaiNe2to9nW6qazKG2v95y3MuBVwMXtPT+bO38VU0aX7L9srpfuy/GwG9NPU1VnKoPwj+iXLh8tPm4iQ/76r15TdP/Y+PaBv5Y21dMu2i7rsF4vQttxwCn2z5f0qkNxutdwPwrympG2/f2N3TxrdXjKekvgffbvrfa3g34Q9t/Vmcc249I+iBwaJ2vO2TsH047ng9v6rE1aO382X5Y0oMN14A/NFMR2LCtv06fAT5Kac5o8nz13pvfkbSv7R80FWdcE/jdkp5KNb+4yuIRdzYY70dVz4KXAX8t6TE038XyLOA9wN8AL6W0OTbVVazt4/kK2+/qbdj+iaRfB2pN4JUvS3oV8Dm393Xyh5JeBLjqTngysMVfh2fQ9vn7L+BaScvZsNfLyXW8uO2X1vE6c7DO9uktxtsbuF7SFWx4HI+tK8C4NqE8hTJr14uAnwC3Aq8b1JZUU7zHAkcD11Y9Q/YGnm37y03Eq2Kusv08Sdfafna172u2f7WBWG0fz2uAQ2w/VG3vAKy0XfugDUn3AztSalQ/p3wI2vbOdcfqi7kH8HeUD/x5lIthb6+zm+S0eG2fv0WD9tteVnOcN2wizr/UGacv3qnAGuA8Nry4/p8NxXvxoP22L60txjgm8B5JOwLzmuh7Oi3OvoP2N/nVR9LXgV8FzgW+AvwIOK3uK+/TYrZ1PP+E0rvgLEqt8Y2U9uL3Nxl30rV1/toiqb/n1/bAkcCVtl/dULxbB+xudMxA08YygUt6PKV54XBKArgM+PMGazjXsn5QyPbAfsDNTdQY+2IeQvnavSvwF8AulHbjbzUQq9XjWcU8mlJDFfBl219qMNZvs/5v+5rtf28qVhXvKZQa+AurmN8E/sB2raNN++K1/f/Q5vWZ/ri7AJ+os4lhlCS9EPgI8AxgO0rX2gfq/HY4rgl8OfBVoDfnxOuAlzR5ZXxa/IMp3cLe1Ea8prV5PNvoxTAt3j8Cvwx8str1GuB7tt/SYMxvUQZ69WKeALytqV5Lbf8/SLqM9ddnfpPq+ozt9zQRry/utpSeG42MgB5Bk81KynvjM5RRmG8A9u+/PrTFMcY0ga+y/bxp+9pefPRK2zN2d5rj6844eU4TtY+2j2f1N76+jX68kq4HntW7gFl137q24W9Pl09P1pK+ZfuFDcVr+/y1cn1G0udZvxD6fEqN/xzb76wzTl+8tptsVtpeqL7h+pK+YftFdcUY114oF0s6gTJvAJQ+txc2FUzSO/o251EG8qxtKNyhwA8ptbfLaa7nSb9WjycN92KY5mZgX6B3Qe9JwDUNxEHrJ8m6WNIS4FOUBPQamj2erZ+/6oNwtcqyiT8C9mwgzgdZn8DXAd+3/aMG4gBg+239270mm6biAQ9WvZSulvR+Ss+hHesMMFY18KpHQa8tekfgkequecDPmupZIKn/q+E64Dbgs25giG3VxHAUZeKe51D+ET/pBtYTHeHxbKUXQxXrUuAQymRgVLe/CTxYxayvy1bLE2iN8Pw1en1m2t/Vz5TeId8D3u2aRnzOUI6mm2yeTOn1si1lcrddgH+0/d3aYoxTAt/aVP3NTwQ+QLko1ep8LJNgWlctUS70nQi8GertshXNqyo4zwLOrnsUY9tNNm0Y2wSuMqHOr1Wbl9j+QoOxBrVL/5QyS+AZddfEq8R9DCXRLKBMS/rxJr8+qsyfsYANhxA3NZ1sq70YJB0IvJYyidatlEE9jX0YVknmGDY+no1MJ1vFbPP8Xcz6RPcoNzi/zIAyvMn2GTW/5otpscmm7xvbBur8PxjLNnBJp1G+Cp9d7Xq7pMNtL2ko5K3AFBv2ZLgLeBplwqnX1xVIZaKgZwEXAe+1fV1drz1DzI9TmmuuZ/3X8CanI218lKnKvBYnUD4E7wE+TamQtDHK7/NU7fysP56NGcH5+6O+29sDr6LZqSw2UmfynqnJRlKTTTb9F5m3p8z7X+tiI2NZA69G8h1o+5Fqez5wlRuaeF3SV23/2qB9kq6vs0eDpEdYf2Gv/+A3NoJQ0g22n1n3684Qr/FeDNVx/BpwUq9NUdItbQzKUMOLAAyI1+r520QZLrU9cGRhlzXZZLOJeJfZPryu1xvLGnhlV6A3xLXppZam1DfpTDUyc4/qvl/UGcj2KJax+6akZ9q+oaV4bfRieBWlBn6xpC9SeoS0tezYRZJe7ganWpim1fOnDZekmwc8j7I82MRxWbLuO9O6GNZCG866OI9SI691AZBxTeB/BVxVtcWJ0hZeW+f3Af4QuEzS96p4+wFvroYu195zYgSWUZLAjylX+Xu1/aZqkadQlqo7mdKL4QjKxPa1sX0ecF51jo6jXOXfS9LpwHkNJ9dvVbHnAf9Ng9+eKm2fv1Wsb3JYR2liPKmhWGOh7vb2Sv+si73ebb9TZ4CxbEIBUJlQ6hDKm+hy2z9uON5jKMs6CbipiS6EoyLpu8A7mNZm64YmQxqVquZ4PPCaJi+4qSzQfBxlwFDj/0Btnj+NaI71mJuxTOCSVtg+crZ9NcZrdYht2yR9pY0eBKMYZToKkr5EmTK38QuYVbxWzl9fvG/abn2O9UlTVQpfxca9h/68rhhj1YSi9avE76GyCED/KvFPaDD0IX23Hx1iC0xEAgdukvRvlN4T/dNo1t2LYRSjTEfhTuASSRex4fFsqhthW+evZxRzrE+i8yndkVfRd97qNFYJnBGtEj+CIbZt24HyBnp5374muqH9EutHmb6WBkeZjtit1c921U/T2jp/Pe+gmmNdUitzrE+ofWwf3WSAcW1CaX2V+Gnxt6W0bz59VGXouq1hlKkmdFX6qIekpcBHbF/bVIxRdGkbxiOSdu1tSNpNUiMrflev/3lJF1Q/F1ImSGp0Tuk2SXqapBWSrqu2nyOpieXNkPQYlfm5/xV4C/D3NFdTHAlJh0q6gWoZNUnPVZnWtql4rZ2/vpi/LenDkj4k6bgmY02ww4FVkm6WdI2ka6sxLrUZ1xr41bYPnLbvKlcrcjcQr3+AwjrKV8YT3eCc0m1SS6uaTxtl+qk2RpmOgiZ4VfrqtVufY30SqUxmtZE6ew+NWxt4zzxJ6l1AqUZLNdbWaPvSAfNpfLapeCPQ1qrmr6eMMn0acHJfvIlrQ/WErkpfeTEbzrG+jNKFMTZDL1FL2pO+OYHqNK4J/MvAOZI+SrlY87+BL9YdZMTzabSplVXNRzTKdBQmfVX61uZYn2QqE/J9iNIpYw3wZMr7pL6pOca0CWUH4Pcpi/6KktDPrIa91hlnZPNptEmDVzX/Xdu3jbJcXaUNV6XvvT9PdnOrm7eyKr3WT7e6C+vnWDfwAuAbbmmZvEkh6TuUUcj/YfsgSS+lNM0urivGWNXAJW0D/CVl9rofUv45nkR5w86j/q+po5xPozUui+2+TBO2qvkIHWD7df07JB0GNDV68fu22zh/H2zodbdW/237HknzJM2zfbGkv64zwLh95f0AZbrFp9g+uLpgsx+lRlD7m8v2ebZfQxlCfwl982lIevmMT+4QSX8paVfbD9i+v+rV875Rl6vDBnWJbLKb5K1Vl7QXAj9rKojtS3s/lHk7tq1uX0EZ2Bab515Jj6N8yz9b0t9R87WLsWpCkbQaeNr00V/VRcybbO/fQhlamU+jTYN68KihRZsnmaRDKc0Yp1DmOu/ZGfgt289tKO4OlNXhT6Cs1/oFSi+fyxqK9/vAYmB3209VWaDjo01NZTGpJD2WMm+8gN+lvE/OrrOpbdxq4B40dLdq+27lk8b2f9o+Y1KSd2V+NbAGeDQhPGaGx8dg2wGPozQ97tT3cx+lW2EjbP/c9jm2fxs4iJIImlwq7i3AYZS/C9uraWZR44kk6X5J9wE/Bu6lXLf4v5Tm4ZslfUtSLR+GY9UGDtwg6Q3TJ5GS9LvATSMq0yT4V2CFpLMoH4RvZDKmyW1V1ZxwqaR/tv19STuX3c1fU6jGKrwGeAXwbWqelnSah2z/otdtsbo2NT5f1cec7U3O+a2+BSSq31tk3JpQnkgZtfdz1s9JfAhlLojfcoPr1006SUfT12vC9pdGXKTOkrSQsmxc7x/1p8Abba9qKN6twNXAOZTBQ40O35f0fkrN8Q3A2ygLRN9g+91Nxt2aqKY1P8cqgfdIOoLSV1LA9a5/rbqtTjUqbH/b/1G1zc1Pb5S5qYZDv8X216rtw4F/dHNL/u1s+74mXnsT8eZRFnB4OeV/8EvAxzIz4fgZywQe9cpFqXpJ+rrtw2bbV2O8fSi9XA6jfCu9DHi77dtrjvPosoLRDeN2ETOakYtS9bpC0hmSXiLpxdXcIZdIOlgbroNYl7OACygj+p5ImRf8rAbiPDqBm6RJmkpiYo3bRcxoRi5K1as30dp7pu1/EeW41t2Dacp2f8L+Z0mn1BwDNhzENlGjkSdVEvjW4VJJ7wJ2kHQU5aLU50dcps4awVw5d1c9sXqzA/bm7qmbN3E7xlTawLcCuShVL0l7Ufr0PsH2KyQ9k7IQ8JkNxduX0o/4UEpi/QalDbzuuVAepswmKUrPrwd7dzFhs0lOiiTwrYSkKQDba0ddlq5TWQvzLODdtp9bNUldZfvZIy5abGXShDLBVBq93wO8lVKLUlXL+ohrXBl7K7SH7XMk/SmA7XXVca2VpP8zw922/Rd1x4xuSS+UyXYKpffJIbYfb3t3ytSgh0n6g9EWrdMekPR41s/P/ULKYJ7a4wz4gdIc9s4G4kXHpAllgkm6CjjK9t3T9k9RRmM2skTdpKu6Cn6EMhT6OmAKeLXtxhY9kLQT8HZK8j4H+JDtNU3Fi25IDXyybTs9ecOj7eDbjqA8nSbpEEm/ZPtKyrJj7wIeoizoUOugmr6Yu1dT/15DafI82PY7k7wDksAn3S/meF8Mdgbrj9uLgHcD/0CZbW5p3cEkfYAycdX9wLNtn2r7J3XHie5KE8oE6+sWttFdwPa2UwvfDJK+05vzW9I/AGttn1ptX237wJmeP4d4j1Bq+OvYsF92uvUFkF4oE832/FGXYcLMl7SN7XXAkZT5ZXpq/1/aihaJjjlKAo8Y3icpo1rvpkx53JuN8JdpphdKxIzShBKxGaoug3tTevE8UO17GvC46uJmRGuSwCMiOiptbBERHZUEHhHRUUngETOQtKukN/dtv0TSF0ZZpoieJPCIme1KmT89YuwkgcfEkLRA0k2SPibpOklnS3qZpK9LWi3p+dXQ9H+XdI2kb0l6TvXcUyV9XNIlkm6RdHL1sqcBT5V0dTUyEuBxks6tYp2t3lJHES1LP/CYNL8MHE8ZZPNt4LXA4cCxlLlLfkiZu/s4SUcA/8L6JdKeDrwU2Am4WdLpwBLgWb1RlpJeAhwE/ApwB/B1yoyPl7Xxx0X0Sw08Js2ttq+1/QhwPbCiWnnoWmABJZl/AsD2V4DHS9qleu6Fth+qJgBbA+y1iRhX2L69inF19boRrUsCj0nzUN/tR/q2H6F84xzU3NEbDNH/3IfZ9DfUYR8X0agk8NjafBV4HTzaHHK37ftmePz9lCaViLGTmkNsbU4FzpJ0DWXR3kUzPdj2PdVF0OuAi4ALmy9ixHAylD4ioqPShBIR0VFJ4BERHZUEHhHRUUngEYO1e5kAAAAfSURBVBEdlQQeEdFRSeARER2VBB4R0VFJ4BERHfX/Af9nC8U9SZomAAAAAElFTkSuQmCC",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_pr=df[df['year'] == '2021']\n",
    "\n",
    "df_pr.groupby('month').size().sort_values(ascending = False ).plot(kind='bar')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x261ecfc9448>"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAEzCAYAAADKCUOEAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAfxklEQVR4nO3debRkZX3u8e/TjYzKJEdEUBu1HRBRsFEGk6CoF8UgMaLgxFJuMBcUp0RRsy4kZsA56lWkI2JruCjiAMpFJcggKmAz2MwBQaUFpVERAgZteO4f7y66+lA9ndp7n3Nens9aZ/WpXcNvV5+qp3a9+x1km4iIqMuc6d6BiIhoX8I9IqJCCfeIiAol3CMiKpRwj4ioUMI9IqJC6033DgBstdVWnjdv3nTvRkTErHLxxRffZnti1HUzItznzZvH4sWLp3s3IiJmFUk/W9V1aZaJiKhQwj0iokIJ94iICiXcIyIqlHCPiKhQwj0iokIJ94iICiXcIyIqNCMGMa3OvCNPn9L9fnrMvi3vSUTE7JEj94iICiXcIyIqtMZwl/RZSbdKumJo2wclXSNpiaSvSdp86Lp3S7pe0rWS/kdXOx4REau2NkfunwP2mbTtTGBH2zsB/wm8G0DSDsCBwFOb+3xK0tzW9jYiItbKGsPd9nnAbyZt+47t5c3FC4Dtmt9fCnzR9j22bwSuB57V4v5GRMRaaKPN/Q3AGc3v2wI3DV23tNkWERE9GivcJb0XWA6cONg04mZexX0PlbRY0uJly5aNsxsRETHJlMNd0sHAS4BX2x4E+FLg0UM32w64edT9bS+0vcD2gomJkQuJRETEFE0p3CXtA7wL2M/23UNXnQYcKGkDSdsD84GLxt/NiIhYF2scoSrpJGAvYCtJS4GjKL1jNgDOlARwge2/tn2lpJOBqyjNNYfbvrernY+IiNHWGO62Dxqx+fjV3P6fgH8aZ6ciImI8GaEaEVGhhHtERIUS7hERFUq4R0RUKOEeEVGhhHtERIUS7hERFUq4R0RUKOEeEVGhhHtERIUS7hERFUq4R0RUKOEeEVGhhHtERIUS7hERFUq4R0RUKOEeEVGhhHtERIUS7hERFUq4R0RUKOEeEVGhhHtERIUS7hERFUq4R0RUKOEeEVGhNYa7pM9KulXSFUPbtpR0pqTrmn+3aLZL0sclXS9piaRdutz5iIgYbW2O3D8H7DNp25HAWbbnA2c1lwFeBMxvfg4Fjm1nNyMiYl2sMdxtnwf8ZtLmlwKLmt8XAfsPbf+8iwuAzSVt09bORkTE2plqm/vWtm8BaP59RLN9W+CmodstbbY9gKRDJS2WtHjZsmVT3I2IiBil7ROqGrHNo25oe6HtBbYXTExMtLwbEREPblMN918Nmluaf29tti8FHj10u+2Am6e+exERMRVTDffTgIOb3w8GTh3a/rqm18xuwO8GzTcREdGf9dZ0A0knAXsBW0laChwFHAOcLOkQ4OfAAc3N/x/wYuB64G7g9R3sc0RErMEaw932Qau4au8RtzVw+Lg7FRER48kI1YiICiXcIyIqlHCPiKhQwj0iokIJ94iICiXcIyIqlHCPiKhQwj0iokIJ94iICiXcIyIqlHCPiKhQwj0iokIJ94iICiXcIyIqlHCPiKhQwj0iokIJ94iICiXcIyIqlHCPiKhQwj0iokIJ94iICiXcIyIqlHCPiKhQwj0iokJjhbukt0m6UtIVkk6StKGk7SVdKOk6SV+StH5bOxsREWtnyuEuaVvgCGCB7R2BucCBwPuBj9qeD/wWOKSNHY2IiLU3brPMesBGktYDNgZuAZ4HnNJcvwjYf8waERGxjqYc7rZ/AXwI+Dkl1H8HXAzcbnt5c7OlwLaj7i/pUEmLJS1etmzZVHcjIiJGGKdZZgvgpcD2wKOATYAXjbipR93f9kLbC2wvmJiYmOpuRETECOM0yzwfuNH2Mtt/BL4K7AFs3jTTAGwH3DzmPkZExDoaJ9x/DuwmaWNJAvYGrgLOBl7e3OZg4NTxdjEiItbVOG3uF1JOnF4CXN481kLgXcDbJV0PPBw4voX9jIiIdbDemm+yaraPAo6atPkG4FnjPG5ERIwnI1QjIiqUcI+IqFDCPSKiQgn3iIgKJdwjIiqUcI+IqFDCPSKiQgn3iIgKJdwjIiqUcI+IqFDCPSKiQgn3iIgKJdwjIiqUcI+IqFDCPSKiQgn3iIgKJdwjIiqUcI+IqFDCPSKiQgn3iIgKJdwjIiqUcI+IqFDCPSKiQgn3iIgKjRXukjaXdIqkayRdLWl3SVtKOlPSdc2/W7S1sxERsXbGPXL/GPAt208Gng5cDRwJnGV7PnBWczkiIno05XCXtCnwp8DxALb/YPt24KXAouZmi4D9x93JiIhYN+McuT8OWAacIOlSSZ+RtAmwte1bAJp/H9HCfkZExDoYJ9zXA3YBjrW9M3AX69AEI+lQSYslLV62bNkYuxEREZONE+5LgaW2L2wun0IJ+19J2gag+ffWUXe2vdD2AtsLJiYmxtiNiIiYbMrhbvuXwE2SntRs2hu4CjgNOLjZdjBw6lh7GBER62y9Me//ZuBESesDNwCvp3xgnCzpEODnwAFj1ujVvCNPn9L9fnrMvi3vSUTE1I0V7rYvAxaMuGrvcR43IiLGkxGqEREVSrhHRFRo3Db3GFPa+COiCzlyj4ioUMI9IqJCaZZ5kEkzUMSDQ47cIyIqlHCPiKhQmmWiU2kGipgeOXKPiKhQwj0iokIJ94iICiXcIyIqlHCPiKhQwj0iokIJ94iICiXcIyIqlHCPiKhQRqhGVTIiNqLIkXtERIUS7hERFUq4R0RUKOEeEVGhhHtERIUS7hERFRo73CXNlXSppG82l7eXdKGk6yR9SdL64+9mRESsizaO3N8CXD10+f3AR23PB34LHNJCjYiIWAdjhbuk7YB9gc80lwU8DziluckiYP9xakRExLob98j9X4F3Avc1lx8O3G57eXN5KbDtqDtKOlTSYkmLly1bNuZuRETEsCmHu6SXALfavnh484ibetT9bS+0vcD2gomJianuRkREjDDO3DJ7AvtJejGwIbAp5Uh+c0nrNUfv2wE3j7+bERGxLqZ85G773ba3sz0POBD4ru1XA2cDL29udjBw6th7GRER66SLfu7vAt4u6XpKG/zxHdSIiIjVaGXKX9vnAOc0v98APKuNx42IiKnJCNWIiAol3CMiKpRwj4ioUMI9IqJCCfeIiAol3CMiKtRKV8iIB6t5R54+pfv99Jh9W96TiJXlyD0iokI5co+YJfItIdZFjtwjIiqUcI+IqFDCPSKiQgn3iIgKJdwjIiqU3jIRMVJ658xuOXKPiKhQwj0iokIJ94iICiXcIyIqlHCPiKhQwj0iokLpChkRM0K6XrYrR+4RERVKuEdEVGjKzTKSHg18HngkcB+w0PbHJG0JfAmYB/wUeIXt346/qxER7am9GWicI/flwDtsPwXYDThc0g7AkcBZtucDZzWXIyKiR1MOd9u32L6k+f1O4GpgW+ClwKLmZouA/cfdyYiIWDettLlLmgfsDFwIbG37FigfAMAj2qgRERFrb+xwl/RQ4CvAW23fsQ73O1TSYkmLly1bNu5uRETEkLHCXdJDKMF+ou2vNpt/JWmb5vptgFtH3df2QtsLbC+YmJgYZzciImKSKYe7JAHHA1fb/sjQVacBBze/HwycOvXdi4iIqRhnhOqewGuByyVd1mx7D3AMcLKkQ4CfAweMt4sREbGuphzuts8HtIqr957q40ZExPgyQjUiokIJ94iICiXcIyIqlCl/IyJ60PdcNjlyj4ioUMI9IqJCCfeIiAol3CMiKpRwj4ioUMI9IqJCCfeIiAol3CMiKpRwj4ioUMI9IqJCCfeIiAol3CMiKpRwj4ioUMI9IqJCCfeIiAol3CMiKpRwj4ioUMI9IqJCCfeIiAol3CMiKpRwj4ioUGfhLmkfSddKul7SkV3ViYiIB+ok3CXNBT4JvAjYAThI0g5d1IqIiAfq6sj9WcD1tm+w/Qfgi8BLO6oVERGTyHb7Dyq9HNjH9v9sLr8WeLbtNw3d5lDg0Obik4Brp1BqK+C2MXc39VKvhno1P7fUW7XH2p4YdcV64+3PKmnEtpU+RWwvBBaOVURabHvBOI+ReqlXQ72an1vqTU1XzTJLgUcPXd4OuLmjWhERMUlX4f4jYL6k7SWtDxwInNZRrYiImKSTZhnbyyW9Cfg2MBf4rO0rOyg1VrNO6qVeRfVqfm6pNwWdnFCNiIjplRGqEREVSrhHRFQo4R7REkkbSXrSdO9HBCTcV0vShyQ9tcd6cyV9sMZ6Ta1/76PWpLo79lTnz4HLgG81l58hqZoeYpLeJGmLHuv1+l5oar5EUjWZOCueiKQtV/fTYelrgIWSLpT015I267AWtu8Fnilp1CCwWV2vqTXRdI3t06clXSTpMEmbd1jnaMq0G7cD2L4MmNdhPSTtKelMSf8p6QZJN0q6oaNyjwR+JOnkZlLATl8zfb8XGgcC10n6gKSndFlI0llrs22sGrOht4ykGykjXEeOfLX9uI7rPwl4PXAQ8H3g32yf3VGtDwPzgS8Ddw222/7qbK8n6ThgF8qYh+FaH2m71qS684E3AAcAFwEn2D6z5RoX2n62pEtt79xsW2J7pzbrTKp5DfA24GLg3sF227/uqJ6AF1LeCwuAk4Hjbf+ko3q9vheamptS3uevp2TOCcBJtu9s6fE3BDYGzgb2YkWmbQqcYbu1D5Wuph9ole3tp6t2M8Plk5uf24AfA2+X9EbbB3ZQckvg18DzhrYZ6OoF3We9m5ufOcDDOnj8kWxfJ+nvgMXAx4Gdm6B6T4tBcYWkVwFzmw+TI4AftPTYq/I722d0XON+ti3pl8AvgeXAFsApks60/c4OSvb9XsD2HZK+AmwEvBX4C+BvJX3c9idaKPHG5nEfRflQHoT7HZSZdFszW47cn2z7Gkm7jLre9iUd1f0IsB9wFuUI5aKh6661nZNnUyBpE9t3rfmWrdTaiXIUti9wJuXveImkRwE/tP3YlupsDLyXcmQrygC+99n+7zYef1KtwfvgFZRBgl8F7hlc38X7QdIRwMGUA5zPAF+3/cemjfo6249vu2bfJO1Hea08HvgCsMj2rc3f9uq2XitNrTe39GGx6hqzJNwX2j5U0qimENt+3ojtbdR9A/BF23ePuG4z27/roOYTgWOBrW3v2ITTfrb/se1afdeTtDtwPPBQ24+R9HTgjbYPa7vWUM3zgH8DTrH9+0nXvdb2F7qq3ZVVvA8GOnk/SPp7ykjzn4247im2r+6gZt/vhUWUD//zRly3t+3W2sQlHQB8y/adzbfKXYB/bPODeVaEO0BzhLC77e/3UGvkN4SBrr4pNLXPBf4WOG6o7fYK2530+uiznqQLgZcDp/Xx3PrUBNHfUE6i3t/c2dWBR5+a996Svv9OPb825wLftv38th97FfWW2N5J0nOAfwE+RGkmfHZbNWZFmzuA7fskfQjYvYdyH17drrByG2DbNrZ90aROAstrqWf7pkm17l3VbdvQtH//C2VFsA2H9qPtk/BfBj5NabLo9DkNSPpn4AO2b28ubwG8w/bftVmnee/9WNJjbP+8zcdeg95em7bvlXR3V9/IRxi8RvYFjrV9qqSj2ywwa8K98R1Jfwl81R1+5bD93K4eey3cJunxNPPfqyx8cksl9W6StAfgpkvkEUDrX+cnOQE4Cvgo8FxKm2oX3euW2z62g8ddnRfZfs/ggu3fSnox0Gq4N7YBrpR0ESv3XNmvg1oDfb8X/hu4XNKZrPwcj+ig1i+a3mPPB94vaQNa7po+a5plACTdCWxC+dT7PeVNatubdlTvdaO22/58F/Wamo+jzBC3B/Bb4Ebg1aPaOmdbPUlbAR+jvKDnUE46vqWrrntNzYttP1PS5baf1mz7nu0/abnO0cCtwNdY+eTmb9qsM6nmEmBX2/c0lzcCFttufeCdpD8btd32uW3XGqrZ93vh4FHbbS/qoNbGwD7A5U1vrm2Ap9n+Tms1ZlO4903S8NnsDYG9gUtsv7yH2psAc9rqXzvT6vVF0veBPwFOAb4L/AI4pu2eTs1YjMk6HYMh6Z2U3lwnUI5u30A5n/GBrmpOhxpfm5IeM2p7m81esy7cJb0MeA7lxfw921/vsfZmwBe6/Coq6eGUZoTBczwf+IcOB6b0Vq85EvsYsFtT64fA22x3NaoSSbtSmn42B94HbEZpp76gq5p9krQP5ZuQgO/Y/nZHdXYDPgE8BVif0gXzrq6+NTc1+34v9HV+BkmXs2Jg5obA9sC1bX7rmlXhLulTwBOAk5pNrwR+Yvvwnuo/hNJroLOhyU1733nAYB6WVwN7dXUWv896ki6gDNQY/P0OBN7cZg+B6dJ3E9409O5YTPl7fZkyOvV1wPzhNv8Oavb9XjifFedn/pzm/Izto7qoN6n2LpRuwW9s7TFnWbhfCew4OJnadNG6vIs2xubxv8GKhb3nUj7RT7b9ri7qNTUvtv3MSds6W6y3z3pqhuhP2naB7d06qLXaSbva/vY1HU14zXN8bR+9OwavCQ1NqSDpB7b36LDmtLwXuj4/s5r6l9hebTfsdTHbestcCzwGGJxQeTSwpMN6H2JFuC8Hfmb7Fx3WAzhb0oGUeTug9As/fTbX04rJ3c6WdCTwRcr/6yvbrjVkd+AmyreEC+mmh8z9bL95+PKgCa/LmvTbu+PupofTZZI+QOm1skkHdYb1/V747+aA8TqVZUJ/ATyii0KS3j50cQ5lENOyVmvMsiP3c4FdKZM/0fz+Q+BuaO9orOmVM2qiMlN6QvwEeG/LI9aGa24C3NdcNQf4r7bbNvusp2mY+K1ptngBZRKonSihcJK7Wct3VP0+mvD67N3xWEpvoIdQJivbDPiU7es7qNXre2Gobm/nZyQNN/UsB34KfMUtTlcx28J9uDuWKCdaDgIOg267ZQ3tw1xgR+DEGkZWPhg0fYgPAj5IOSHX+pwe09GEF7E6syrcASQ9A3gVZdKkGykDmjqdgGcV+/FG28d19Ng78cBh7F1Oc9pLveaDcd8RtTqZ8rcJ9X0pwT6PMtXwZ7toWmsOPHptwuu5d8fg29dKuuzq2dTdD/jT5uI5tr/ZYa2zGf0cu5irZ9Q5od9RZi49ro0j+FnR5q4yb8eBlDfpr4EvUT6Ypm0kaYfB/llKM8KVrPg62tk0pz3X+wZNO/FQrU6oTAK1I3AG8Pe2r+ioziqb8CR10oQ3pK/Rt1B6yAxsSJkbv8uFcpB0DKXp9cRm01skPcf2kR2V/Juh3zcE/pLupuK4EZhg5Z5/vwKeSJno7rXjFpgVR+6S7gO+BxwyaOOTdEPXRw3TQdJVtneosZ46XrxiUq37WHGScfhF3umo5kn70GkT3gzo3XG+7ed0+PhLgGfYvq+5PBe4tK/XUFPzXNsjR+eO+bjn2f7TUdskXdlGD8BZceRO+QQ9kHL2/FuU3hZ9Lr/Vpx9K2sH2VRXWO0PSC9scYr0qtqd9CUmXpeJ+PKmbZJv67N0x3EVvDuVIvo8FVzYHBlM4dLrMpVZesnMO8EzK8oJdmNDQRGzNiNWtmuv+0EaBWRHutr8GfK0Zhrw/5Wz91pKOBb7WR1j0aBElcH9J6ZkzONLs6milz3oXUP6Oc4A/0uNR9HTqqgmPsqLPxpQJ2N5Hma10ZA+aFgzPlDro3fGKjmoN/AtwadMWLkrbe2eDpigrIw2a2JZTmk4O6ajWO4DzJf2kqbc9cFiTca30dpoVzTKjNJ+yBwCv7OKEx3SRdD3wdia1S7u7yZJ6q6eyePP+lIFns/OFF71SmVBrV0oAXmj7lx3V6W29iKGaG1CW7xRwTZvdIGEWh3utJH23zw+rPutJ+jZlmtpOT6bWru/Rt03NDSjNo/NYuafTP7Rda6jmWbb3XtO2Fuv90HYf60X0Ml3FrGiWeZC5RtL/pfQsGZ46tquukH3WuwU4R9IZk2p10hWyYr2Ovm2cSumqdzFDf7suSNqQ0ty0lcoCJIPntyllYemu9LJeRGPXod/vn64CSLhXbCPKm+eFQ9u6XPG9z3o3Nj/rNz8xNY9kxejbV9HP6NvtbO/T4eMPeyPlfMKjKB8mg3C/gzLxXFfeTrNehKRO14voY7qKNMtE7yRtYvuuNd8y1qSP0bdNnYXAJ2xf3sXjr6Lmm6djgOJ0aKaruNz2k9t6zGnvLhYrk/RESWdJuqK5vJPK6uizvp6k3SVdRbO0nqSnq0zjHOtI0gYqaxv8O3A48HG6+3YHZaqPiyVdK2mJpMubfuhduk/S5oMLkraQdFiXBSW9TNJHJH1Y0v4d1vmGpNOan9MpkyK2ujZFjtxnGPW44nvf9SRdSJnZ77Q+nlutJo2+/WJXo28n1XzsqO1d9eJqal5m+xmTtl06eO10UK+39SK08jxZyylNQAe1WStt7jNPbyu+T0c92zdNqnXvqm4bq/RayujbJwJHDP1/dtlG/DMASY9gaB6bjs2RpMHJzWaEapfnav6MldeLWETpItw62+fqgfNkfaXNGgn3mafvFd/7rHeTpD0o866sTxl8c3VHtao1HaNvVSbw+jDlJOetwGMpf7tOFsppfAc4WdKnKa/P/wV8q8N6na8XoR7nyUqzzAyj0Su+v8b2T3us18kK85K2oqyhev+an8ARtn+z2jvGtJP0Y8oI2P+wvbOk51KaEQ7tsOZGwF9RFjgfvF6Ob6Z1aLPOYLrmzVixXoSBZwM/cIvL+qnHebJy5D7DuCwW/Xz1t+L7z2z3Ve9Jtl89vEHSnkBvowJjyv5o+9eS5kiaY/tsSe/vopCk9YB/psxyeRMl2B9NOfCYQ/tNeR9q+fFWp7d5stJbZoaR9M+SNrd9l+07mx4C/9hhyRubbm67Af/VYR2AUd3aHhRd3Spwu6SHUo46T5T0Mbo7N/NBynTCj7O9S3MCdXvKkXXrQWz73MEPZc6chzS/X0QZWNRmra/ZfiVl2oFzGJonS9ILV3vndZRmmRlmVG8Atbxw7qTH3oiy0vuBlHUcv0npgXF+izV2pzT7vJUy9/jApsBf2H56W7WiG5I2pszFL+A1lL/diV00qUm6Dnji5FGizQnVa2zPb7tm8/h/BRwKbGn78SqLoXy6q+kOhup2Mk9WjtxnnrnNwBTg/vDdYDW3H4vt39s+2fbLgJ0pb9q2lytcH3gopRnwYUM/d1C6RsYMJelOSXcAvwRup5yX+T+UZpNrJV0gqe3w86jh/01be5dHo4cDe1Jel9i+jo6mUB5m+ze2j2t7jqe0uc88/w6cJekEygv5DbQ0BeiqNH1uXwm8CPgRLU/l2nzFPVfS52z/TNKmZXPn5xNiTLZXOWe7hhYjaf5ty1WSXjd5Ei1JrwGuabHOZPfY/sOga2nT9j9rmzbSLDMDSdqHoR4ltr/dYa0bgcuAkymDizqbFkDSAsrScIPA+B3wBtsXd1UzuqeW1xOWtC1ltO3vWTHH+q6UeZD+wh2tTSvpA5RvJ68D3gwcBlxl+71d1Otawn0GakYDzrf9H01b59yujnIlbWr7ji4ee0StJcDhtr/XXH4O8Cn3uGxazB6SnkfpRy/gSnezDu1wvTmUxTle2NT8NvCZ2br2QMJ9hun7pI6k7Sg9VvakHCGdD7zF9tIOan3f9p5r2hbRJw0td1eTnFCdefo+qXMCcBpl5OG2lHndT+io1kWSjpO0l6Q/a+byOEfSLlp5jc6IPt0/YZekVqcAmE45oTrz9H1SZ8L2cJh/TtJbO6o1mATqqEnb96A8x2qWS4xZZXgQUesjRadLwn3mOVfSe4CNJL2AclLnGx3Wu63phTCYCW8w50Xrupg/I6IFXsXvs1ra3GeYvk/qSHoMpd/y7pQX9g8obe5dzC2zNaV/9KNsv0jSDpRFiY9vu1bE2pJ0L2WWTVF65Nw9uIqOZtnsQ8J9BpI0AWB72XTvS5tU1k49AXiv7ac3TU6X2n7aNO9aRHXSLDNDqDSyHwW8iXLEoOaI4hPuYIV5Sf97NVfb9vvarglsZftkSe9uiixvnmNEtCy9ZWaOt1J6yexq++G2t6RMObqnpLd1UO+uET9QmoTe1UE9gLskPZwVc8fvRhnIFBEtS7PMDCHpUuAFtm+btH2CMkq1k6XFmhoPA95CCfaTgQ/bvrWDOrtQ+tTvCFwBTAAvt931WpwRDzo5cp85HjI52OH+dveHdFFQ0pbNdMJLKE10u9h+V9vBLmlXSY+0fQllKbP3APdQFl9ofbBURCTcZ5I/TPG6KZH0QcokYXcCT7N9tO3ftl2ncRwrnsMewHuBT1JmGFzYUc2IB7U0y8wQQ92xHnAVsKHtVo/em+W+7qEsuDD8Imi9+5ekHw/mbJf0SWCZ7aObyw9Y4T4ixpfeMjOE7bk91+vzW9tcSevZXg7sTZk7ZyCvwYgO5I0VfTiJMvL2Nso0roNZIZ9AestEdCLNMtGLptvjNpSeP3c1254IPLQ50RoRLUq4R0RUKL1lIiIqlHCPiKhQwj1iCiRtLumwoct7SfrmdO5TxLCEe8TUbE6Zaz9iRkq4R/UkzZN0jaTPSLpC0omSni/p+5Kuk/SsZiqGr0taIukCSTs19z1a0mclnSPpBklHNA97DPB4SZc1o30BHirplKbWiRospxUxDdLPPR4sngAcQBlA9SPgVcBzgP0oc93cRJlbfn9JzwM+z4plAZ8MPBd4GHCtpGOBI4EdB6NrJe0F7Aw8FbgZ+D5lls/z+3hyEZPlyD0eLG60fbnt+4ArgbOa1a0uB+ZRgv4LALa/Czxc0mbNfU+3fU8zsdutwNarqHGR7aVNjcuax42YFgn3eLC4Z+j3+4Yu30f5BjuqCWUwCGT4vvey6m+8a3u7iM4l3COK84BXw/1NLLfZvmM1t7+T0kwTMSPlyCKiOBo4QdISygLJB6/uxrZ/3ZyQvQI4Azi9+12MWHuZfiAiokJplomIqFDCPSKiQgn3iIgKJdwjIiqUcI+IqFDCPSKiQgn3iIgKJdwjIir0/wErWvLHVLifKQAAAABJRU5ErkJggg==",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_pr=df[df['year'] == '2019']\n",
    "\n",
    "df_pr.groupby('month').size().sort_values(ascending = False ).plot(kind='bar')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "After seeing the above three plots we can infer that in a particular year, their is a month which have a large amout of TED talks. This may be beacause some global event might be hosted by the TED Community in that particular month."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Finding the top 10 authors with by views. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "author\n",
       "Alex Gendler        187196000\n",
       "Sir Ken Robinson     95654000\n",
       "Bill Gates           77800000\n",
       "Simon Sinek          74800000\n",
       "Brené Brown          72000000\n",
       "Julian Treasure      64300000\n",
       "Amy Cuddy            64000000\n",
       "Tim Urban            60000000\n",
       "Iseult Gillespie     54998000\n",
       "Mia Nacamulli        44174000\n",
       "Name: views, dtype: int64"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby('author').sum()['views'].sort_values(ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "author\n",
       "Amy Cuddy           64000000.0\n",
       "Tim Urban           60000000.0\n",
       "Sam Berns           43000000.0\n",
       "Robert Waldinger    41000000.0\n",
       "Cameron Russell     38000000.0\n",
       "Mary Roach          37000000.0\n",
       "Graham Shaw         37000000.0\n",
       "Brené Brown         36000000.0\n",
       "Tom Thum            34000000.0\n",
       "Apollo Robbins      31000000.0\n",
       "Name: views, dtype: float64"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby('author').mean()['views'].sort_values(ascending=False).head(10)"
   ]
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "1e915f0a29dc84041eaeb02b7b1a21c440e37a87b61d44d5e84a515737dc82bc"
  },
  "kernelspec": {
   "display_name": "Python 3.7.6 ('base')",
   "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.7.6"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}