data_playround.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 125,
   "id": "0d725540-b132-4281-9719-b18153046174",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from datetime import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "id": "e67a987b-830c-48ea-ae73-8087ec99c7f1",
   "metadata": {},
   "outputs": [],
   "source": [
    "# import data\n",
    "videos = pd.read_csv('Table data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "id": "1b24f766-1a9e-4076-8510-4f2dd004edab",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Content</th>\n",
       "      <th>Video title</th>\n",
       "      <th>Video publish time</th>\n",
       "      <th>Views</th>\n",
       "      <th>Watch time (hours)</th>\n",
       "      <th>Subscribers</th>\n",
       "      <th>Estimated revenue (GBP)</th>\n",
       "      <th>Average view duration</th>\n",
       "      <th>Impressions</th>\n",
       "      <th>Impressions click-through rate (%)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Total</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>797233.0</td>\n",
       "      <td>57287.8835</td>\n",
       "      <td>10863.0</td>\n",
       "      <td>2256.725</td>\n",
       "      <td>0:04:18</td>\n",
       "      <td>9867924</td>\n",
       "      <td>3.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Y5atyJbVsAU</td>\n",
       "      <td>Build Your Own AI Assistant Part 1 - Creating ...</td>\n",
       "      <td>Apr 19, 2021</td>\n",
       "      <td>38177.0</td>\n",
       "      <td>2660.5312</td>\n",
       "      <td>830.0</td>\n",
       "      <td>128.991</td>\n",
       "      <td>0:04:10</td>\n",
       "      <td>358964</td>\n",
       "      <td>3.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>KPfBOGjJdqE</td>\n",
       "      <td>Control Arduino with  Python using Firmata / P...</td>\n",
       "      <td>Aug 2, 2021</td>\n",
       "      <td>31730.0</td>\n",
       "      <td>1865.7467</td>\n",
       "      <td>340.0</td>\n",
       "      <td>70.869</td>\n",
       "      <td>0:03:31</td>\n",
       "      <td>328781</td>\n",
       "      <td>6.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0sPPxIq4hg8</td>\n",
       "      <td>Build your own web server using a Raspberry Pi...</td>\n",
       "      <td>Aug 29, 2022</td>\n",
       "      <td>31337.0</td>\n",
       "      <td>4469.2779</td>\n",
       "      <td>451.0</td>\n",
       "      <td>128.964</td>\n",
       "      <td>0:08:33</td>\n",
       "      <td>467561</td>\n",
       "      <td>3.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>hiVcgUdjy0A</td>\n",
       "      <td>Node-Red Automation, MQTT, NodeMCU &amp; MicroPython</td>\n",
       "      <td>Mar 29, 2021</td>\n",
       "      <td>23557.0</td>\n",
       "      <td>3441.1976</td>\n",
       "      <td>375.0</td>\n",
       "      <td>88.065</td>\n",
       "      <td>0:08:45</td>\n",
       "      <td>394481</td>\n",
       "      <td>3.43</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Content                                        Video title   \n",
       "0        Total                                                NaN  \\\n",
       "1  Y5atyJbVsAU  Build Your Own AI Assistant Part 1 - Creating ...   \n",
       "2  KPfBOGjJdqE  Control Arduino with  Python using Firmata / P...   \n",
       "3  0sPPxIq4hg8  Build your own web server using a Raspberry Pi...   \n",
       "4  hiVcgUdjy0A   Node-Red Automation, MQTT, NodeMCU & MicroPython   \n",
       "\n",
       "  Video publish time     Views  Watch time (hours)  Subscribers   \n",
       "0                NaN  797233.0          57287.8835      10863.0  \\\n",
       "1       Apr 19, 2021   38177.0           2660.5312        830.0   \n",
       "2        Aug 2, 2021   31730.0           1865.7467        340.0   \n",
       "3       Aug 29, 2022   31337.0           4469.2779        451.0   \n",
       "4       Mar 29, 2021   23557.0           3441.1976        375.0   \n",
       "\n",
       "   Estimated revenue (GBP) Average view duration  Impressions   \n",
       "0                 2256.725               0:04:18      9867924  \\\n",
       "1                  128.991               0:04:10       358964   \n",
       "2                   70.869               0:03:31       328781   \n",
       "3                  128.964               0:08:33       467561   \n",
       "4                   88.065               0:08:45       394481   \n",
       "\n",
       "   Impressions click-through rate (%)  \n",
       "0                                3.70  \n",
       "1                                3.64  \n",
       "2                                6.18  \n",
       "3                                3.38  \n",
       "4                                3.43  "
      ]
     },
     "execution_count": 127,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "videos.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 128,
   "id": "1a632f24-be5c-4b31-aa5a-5c3fed308d1d",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "# remove first row\n",
    "videos = videos.drop([0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "id": "629dcc71-5c6d-4438-b56b-796a900db600",
   "metadata": {},
   "outputs": [],
   "source": [
    "videos = videos.rename(columns={\"Impressions click-through rate (%)\":\"ctr\",\"Estimated revenue (GBP)\":\"revenue\",\"Video publish time\":\"published\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "id": "08e95b06-992a-4a2c-9279-e5728cbd9426",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Calculate the 90th percentile of views\n",
    "percentile_90 = videos['ctr'].quantile(0.9)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "id": "d9be9233-dde6-4ef5-9245-ca3dbbad8936",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Calculate the 90th percentile of views\n",
    "percentile_90_views = videos['Views'].quantile(0.9)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "id": "e5e864e9-a594-429a-887b-d16453b40080",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Calculate top earners\n",
    "earners_90 = videos['revenue'].quantile(0.9)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "id": "e5803a09-7c92-46c7-900f-7c5c71b48779",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Add a new column for the top earners\n",
    "videos['top_earners'] = videos['revenue'].apply(lambda x: True if x >= earners_90 else False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "id": "404eab72-996d-4426-aeaa-34e99d61b7c9",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Add age\n",
    "# Convert the 'published_date' column to datetime\n",
    "videos['published'] = pd.to_datetime(videos['published'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "id": "854f9bf0-9adb-4a47-9e36-5f17f5d290cf",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Calculate the age of the video as the difference between now and the publication date\n",
    "current_date = datetime.now()\n",
    "videos['age'] = current_date - videos['published']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "id": "042c29fe-35d1-42b9-aa80-67589c9f49ed",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "          Content                                        Video title   \n",
      "1     Y5atyJbVsAU  Build Your Own AI Assistant Part 1 - Creating ...  \\\n",
      "2     KPfBOGjJdqE  Control Arduino with  Python using Firmata / P...   \n",
      "3     0sPPxIq4hg8  Build your own web server using a Raspberry Pi...   \n",
      "4     hiVcgUdjy0A   Node-Red Automation, MQTT, NodeMCU & MicroPython   \n",
      "5     -BObt8inVs8  How to Map with LiDAR - using a Raspberry Pi Z...   \n",
      "..            ...                                                ...   \n",
      "370   2JIjBZblNb4                      What is she thinking? #shorts   \n",
      "371   ChsyMt2xhP4                                 The Cheese Monster   \n",
      "372   xedc6jf4C6E         Will Elon Musks robot take over the world?   \n",
      "373   U0RBSIjFIJo                          Kevin McAleer Live Stream   \n",
      "374   wzLHPst7FSs  SMARS Quad robot build-along - Overview and 3d...   \n",
      "\n",
      "     published    Views  Watch time (hours)  Subscribers  revenue   \n",
      "1   2021-04-19  38177.0           2660.5312        830.0  128.991  \\\n",
      "2   2021-08-02  31730.0           1865.7467        340.0   70.869   \n",
      "3   2022-08-29  31337.0           4469.2779        451.0  128.964   \n",
      "4   2021-03-29  23557.0           3441.1976        375.0   88.065   \n",
      "5   2022-03-14  21594.0           1150.6273        292.0   52.944   \n",
      "..         ...      ...                 ...          ...      ...   \n",
      "370 2022-10-18      1.0              0.0032          0.0      NaN   \n",
      "371 2011-02-13      1.0              0.0244          0.0    0.000   \n",
      "372 2022-10-19      1.0              0.0003          0.0      NaN   \n",
      "373 2020-08-11      NaN                 NaN          NaN      NaN   \n",
      "374 2020-10-18      NaN                 NaN          NaN      NaN   \n",
      "\n",
      "    Average view duration  Impressions   ctr  top_earners   \n",
      "1                 0:04:10       358964  3.64         True  \\\n",
      "2                 0:03:31       328781  6.18         True   \n",
      "3                 0:08:33       467561  3.38         True   \n",
      "4                 0:08:45       394481  3.43         True   \n",
      "5                 0:03:11       167539  5.84         True   \n",
      "..                    ...          ...   ...          ...   \n",
      "370               0:00:11            2  0.00        False   \n",
      "371               0:01:27            0   NaN        False   \n",
      "372               0:00:01            2  0.00        False   \n",
      "373                   NaN            1  0.00        False   \n",
      "374                   NaN           91  0.00        False   \n",
      "\n",
      "                          age  age_days  \n",
      "1    979 days 09:41:19.067682     979.0  \n",
      "2    874 days 09:41:19.067682     874.0  \n",
      "3    482 days 09:41:19.067682     482.0  \n",
      "4   1000 days 09:41:19.067682    1000.0  \n",
      "5    650 days 09:41:19.067682     650.0  \n",
      "..                        ...       ...  \n",
      "370  432 days 09:41:19.067682     432.0  \n",
      "371 4697 days 09:41:19.067682    4697.0  \n",
      "372  431 days 09:41:19.067682     431.0  \n",
      "373 1230 days 09:41:19.067682    1230.0  \n",
      "374 1162 days 09:41:19.067682    1162.0  \n",
      "\n",
      "[374 rows x 13 columns]\n"
     ]
    }
   ],
   "source": [
    "# Convert age to a more readable format (like number of days)\n",
    "videos['age_days'] = videos['age'].dt.days\n",
    "\n",
    "# Display the DataFrame\n",
    "print(videos)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "id": "56ccc101-6332-464a-a087-50b548922b9d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "37"
      ]
     },
     "execution_count": 142,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_earners = videos[videos['top_earners'] == True]\n",
    "len(top_earners)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "id": "82bd0310-fc3f-42a0-8052-edef88bd4780",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Add a new column for the top 10% flag\n",
    "videos['best_ctr'] = videos['ctr'].apply(lambda x: True if x >= percentile_90 else False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "id": "50664911-2fa1-42b9-b132-3efc16130b3c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "38"
      ]
     },
     "execution_count": 144,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "best_ctr = videos[videos['best_ctr'] == True]\n",
    "len(best_ctr)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "id": "31e0485d-2572-48d1-993e-fc093a8e9570",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Add a new column for the top 10% most popular (highest views)\n",
    "videos['popular'] = videos['Views'].apply(lambda x: True if x >= percentile_90_views else False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "id": "b9ca75a0-8af7-45fb-8bb3-0478b205c552",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "38"
      ]
     },
     "execution_count": 146,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "popular = videos[videos['popular'] == True]\n",
    "len(popular)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "id": "71ba5feb-5ef8-435a-abbc-1ccf7198c511",
   "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>Content</th>\n",
       "      <th>Video title</th>\n",
       "      <th>published</th>\n",
       "      <th>Views</th>\n",
       "      <th>Watch time (hours)</th>\n",
       "      <th>Subscribers</th>\n",
       "      <th>revenue</th>\n",
       "      <th>Average view duration</th>\n",
       "      <th>Impressions</th>\n",
       "      <th>ctr</th>\n",
       "      <th>top_earners</th>\n",
       "      <th>age</th>\n",
       "      <th>age_days</th>\n",
       "      <th>best_ctr</th>\n",
       "      <th>popular</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Y5atyJbVsAU</td>\n",
       "      <td>Build Your Own AI Assistant Part 1 - Creating ...</td>\n",
       "      <td>2021-04-19</td>\n",
       "      <td>38177.0</td>\n",
       "      <td>2660.5312</td>\n",
       "      <td>830.0</td>\n",
       "      <td>128.991</td>\n",
       "      <td>0:04:10</td>\n",
       "      <td>358964</td>\n",
       "      <td>3.64</td>\n",
       "      <td>True</td>\n",
       "      <td>979 days 09:41:19.067682</td>\n",
       "      <td>979.0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>KPfBOGjJdqE</td>\n",
       "      <td>Control Arduino with  Python using Firmata / P...</td>\n",
       "      <td>2021-08-02</td>\n",
       "      <td>31730.0</td>\n",
       "      <td>1865.7467</td>\n",
       "      <td>340.0</td>\n",
       "      <td>70.869</td>\n",
       "      <td>0:03:31</td>\n",
       "      <td>328781</td>\n",
       "      <td>6.18</td>\n",
       "      <td>True</td>\n",
       "      <td>874 days 09:41:19.067682</td>\n",
       "      <td>874.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0sPPxIq4hg8</td>\n",
       "      <td>Build your own web server using a Raspberry Pi...</td>\n",
       "      <td>2022-08-29</td>\n",
       "      <td>31337.0</td>\n",
       "      <td>4469.2779</td>\n",
       "      <td>451.0</td>\n",
       "      <td>128.964</td>\n",
       "      <td>0:08:33</td>\n",
       "      <td>467561</td>\n",
       "      <td>3.38</td>\n",
       "      <td>True</td>\n",
       "      <td>482 days 09:41:19.067682</td>\n",
       "      <td>482.0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>hiVcgUdjy0A</td>\n",
       "      <td>Node-Red Automation, MQTT, NodeMCU &amp; MicroPython</td>\n",
       "      <td>2021-03-29</td>\n",
       "      <td>23557.0</td>\n",
       "      <td>3441.1976</td>\n",
       "      <td>375.0</td>\n",
       "      <td>88.065</td>\n",
       "      <td>0:08:45</td>\n",
       "      <td>394481</td>\n",
       "      <td>3.43</td>\n",
       "      <td>True</td>\n",
       "      <td>1000 days 09:41:19.067682</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>-BObt8inVs8</td>\n",
       "      <td>How to Map with LiDAR - using a Raspberry Pi Z...</td>\n",
       "      <td>2022-03-14</td>\n",
       "      <td>21594.0</td>\n",
       "      <td>1150.6273</td>\n",
       "      <td>292.0</td>\n",
       "      <td>52.944</td>\n",
       "      <td>0:03:11</td>\n",
       "      <td>167539</td>\n",
       "      <td>5.84</td>\n",
       "      <td>True</td>\n",
       "      <td>650 days 09:41:19.067682</td>\n",
       "      <td>650.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>370</th>\n",
       "      <td>2JIjBZblNb4</td>\n",
       "      <td>What is she thinking? #shorts</td>\n",
       "      <td>2022-10-18</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0032</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0:00:11</td>\n",
       "      <td>2</td>\n",
       "      <td>0.00</td>\n",
       "      <td>False</td>\n",
       "      <td>432 days 09:41:19.067682</td>\n",
       "      <td>432.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371</th>\n",
       "      <td>ChsyMt2xhP4</td>\n",
       "      <td>The Cheese Monster</td>\n",
       "      <td>2011-02-13</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0244</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0:01:27</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>4697 days 09:41:19.067682</td>\n",
       "      <td>4697.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>372</th>\n",
       "      <td>xedc6jf4C6E</td>\n",
       "      <td>Will Elon Musks robot take over the world?</td>\n",
       "      <td>2022-10-19</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0:00:01</td>\n",
       "      <td>2</td>\n",
       "      <td>0.00</td>\n",
       "      <td>False</td>\n",
       "      <td>431 days 09:41:19.067682</td>\n",
       "      <td>431.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>373</th>\n",
       "      <td>U0RBSIjFIJo</td>\n",
       "      <td>Kevin McAleer Live Stream</td>\n",
       "      <td>2020-08-11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>False</td>\n",
       "      <td>1230 days 09:41:19.067682</td>\n",
       "      <td>1230.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374</th>\n",
       "      <td>wzLHPst7FSs</td>\n",
       "      <td>SMARS Quad robot build-along - Overview and 3d...</td>\n",
       "      <td>2020-10-18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>91</td>\n",
       "      <td>0.00</td>\n",
       "      <td>False</td>\n",
       "      <td>1162 days 09:41:19.067682</td>\n",
       "      <td>1162.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>374 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Content                                        Video title   \n",
       "1     Y5atyJbVsAU  Build Your Own AI Assistant Part 1 - Creating ...  \\\n",
       "2     KPfBOGjJdqE  Control Arduino with  Python using Firmata / P...   \n",
       "3     0sPPxIq4hg8  Build your own web server using a Raspberry Pi...   \n",
       "4     hiVcgUdjy0A   Node-Red Automation, MQTT, NodeMCU & MicroPython   \n",
       "5     -BObt8inVs8  How to Map with LiDAR - using a Raspberry Pi Z...   \n",
       "..            ...                                                ...   \n",
       "370   2JIjBZblNb4                      What is she thinking? #shorts   \n",
       "371   ChsyMt2xhP4                                 The Cheese Monster   \n",
       "372   xedc6jf4C6E         Will Elon Musks robot take over the world?   \n",
       "373   U0RBSIjFIJo                          Kevin McAleer Live Stream   \n",
       "374   wzLHPst7FSs  SMARS Quad robot build-along - Overview and 3d...   \n",
       "\n",
       "     published    Views  Watch time (hours)  Subscribers  revenue   \n",
       "1   2021-04-19  38177.0           2660.5312        830.0  128.991  \\\n",
       "2   2021-08-02  31730.0           1865.7467        340.0   70.869   \n",
       "3   2022-08-29  31337.0           4469.2779        451.0  128.964   \n",
       "4   2021-03-29  23557.0           3441.1976        375.0   88.065   \n",
       "5   2022-03-14  21594.0           1150.6273        292.0   52.944   \n",
       "..         ...      ...                 ...          ...      ...   \n",
       "370 2022-10-18      1.0              0.0032          0.0      NaN   \n",
       "371 2011-02-13      1.0              0.0244          0.0    0.000   \n",
       "372 2022-10-19      1.0              0.0003          0.0      NaN   \n",
       "373 2020-08-11      NaN                 NaN          NaN      NaN   \n",
       "374 2020-10-18      NaN                 NaN          NaN      NaN   \n",
       "\n",
       "    Average view duration  Impressions   ctr  top_earners   \n",
       "1                 0:04:10       358964  3.64         True  \\\n",
       "2                 0:03:31       328781  6.18         True   \n",
       "3                 0:08:33       467561  3.38         True   \n",
       "4                 0:08:45       394481  3.43         True   \n",
       "5                 0:03:11       167539  5.84         True   \n",
       "..                    ...          ...   ...          ...   \n",
       "370               0:00:11            2  0.00        False   \n",
       "371               0:01:27            0   NaN        False   \n",
       "372               0:00:01            2  0.00        False   \n",
       "373                   NaN            1  0.00        False   \n",
       "374                   NaN           91  0.00        False   \n",
       "\n",
       "                          age  age_days  best_ctr  popular  \n",
       "1    979 days 09:41:19.067682     979.0     False     True  \n",
       "2    874 days 09:41:19.067682     874.0      True     True  \n",
       "3    482 days 09:41:19.067682     482.0     False     True  \n",
       "4   1000 days 09:41:19.067682    1000.0     False     True  \n",
       "5    650 days 09:41:19.067682     650.0      True     True  \n",
       "..                        ...       ...       ...      ...  \n",
       "370  432 days 09:41:19.067682     432.0     False    False  \n",
       "371 4697 days 09:41:19.067682    4697.0     False    False  \n",
       "372  431 days 09:41:19.067682     431.0     False    False  \n",
       "373 1230 days 09:41:19.067682    1230.0     False    False  \n",
       "374 1162 days 09:41:19.067682    1162.0     False    False  \n",
       "\n",
       "[374 rows x 15 columns]"
      ]
     },
     "execution_count": 147,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "videos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "id": "021d04b6-261a-4c9f-83d6-03854a50828d",
   "metadata": {},
   "outputs": [],
   "source": [
    "filtered_df = videos[videos[['top_earners','best_ctr','popular']].any(axis=1) == True]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "id": "e1f2a8c0-bf05-4f4c-9a5c-8021233eaa25",
   "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>Content</th>\n",
       "      <th>Video title</th>\n",
       "      <th>published</th>\n",
       "      <th>Views</th>\n",
       "      <th>Watch time (hours)</th>\n",
       "      <th>Subscribers</th>\n",
       "      <th>revenue</th>\n",
       "      <th>Average view duration</th>\n",
       "      <th>Impressions</th>\n",
       "      <th>ctr</th>\n",
       "      <th>top_earners</th>\n",
       "      <th>age</th>\n",
       "      <th>age_days</th>\n",
       "      <th>best_ctr</th>\n",
       "      <th>popular</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>KPfBOGjJdqE</td>\n",
       "      <td>Control Arduino with  Python using Firmata / P...</td>\n",
       "      <td>2021-08-02</td>\n",
       "      <td>31730.0</td>\n",
       "      <td>1865.7467</td>\n",
       "      <td>340.0</td>\n",
       "      <td>70.869</td>\n",
       "      <td>0:03:31</td>\n",
       "      <td>328781</td>\n",
       "      <td>6.18</td>\n",
       "      <td>True</td>\n",
       "      <td>874 days 09:41:19.067682</td>\n",
       "      <td>874.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>-BObt8inVs8</td>\n",
       "      <td>How to Map with LiDAR - using a Raspberry Pi Z...</td>\n",
       "      <td>2022-03-14</td>\n",
       "      <td>21594.0</td>\n",
       "      <td>1150.6273</td>\n",
       "      <td>292.0</td>\n",
       "      <td>52.944</td>\n",
       "      <td>0:03:11</td>\n",
       "      <td>167539</td>\n",
       "      <td>5.84</td>\n",
       "      <td>True</td>\n",
       "      <td>650 days 09:41:19.067682</td>\n",
       "      <td>650.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>fmgQ8Dcg9uM</td>\n",
       "      <td>Install MicroPython on ESP8266 &amp; ESP32</td>\n",
       "      <td>2021-05-26</td>\n",
       "      <td>16917.0</td>\n",
       "      <td>465.9031</td>\n",
       "      <td>95.0</td>\n",
       "      <td>21.425</td>\n",
       "      <td>0:01:39</td>\n",
       "      <td>110373</td>\n",
       "      <td>9.08</td>\n",
       "      <td>True</td>\n",
       "      <td>942 days 09:41:19.067682</td>\n",
       "      <td>942.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>N3jwEVbZyXY</td>\n",
       "      <td>LEARNING PYTHON - INTRODUCTION - for Raspberry...</td>\n",
       "      <td>2020-07-27</td>\n",
       "      <td>12055.0</td>\n",
       "      <td>859.3600</td>\n",
       "      <td>222.0</td>\n",
       "      <td>25.498</td>\n",
       "      <td>0:04:16</td>\n",
       "      <td>39826</td>\n",
       "      <td>8.94</td>\n",
       "      <td>True</td>\n",
       "      <td>1245 days 09:41:19.067682</td>\n",
       "      <td>1245.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>tDDkz3Xdhuo</td>\n",
       "      <td>The new Raspberry Pi Debug Probe</td>\n",
       "      <td>2023-02-20</td>\n",
       "      <td>11910.0</td>\n",
       "      <td>432.9598</td>\n",
       "      <td>71.0</td>\n",
       "      <td>28.755</td>\n",
       "      <td>0:02:10</td>\n",
       "      <td>81624</td>\n",
       "      <td>7.12</td>\n",
       "      <td>True</td>\n",
       "      <td>307 days 09:41:19.067682</td>\n",
       "      <td>307.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>F5Bq7HVJkX0</td>\n",
       "      <td>How to use an Xbox Controller with your Robot</td>\n",
       "      <td>2022-03-21</td>\n",
       "      <td>11131.0</td>\n",
       "      <td>436.5615</td>\n",
       "      <td>71.0</td>\n",
       "      <td>26.223</td>\n",
       "      <td>0:02:21</td>\n",
       "      <td>63692</td>\n",
       "      <td>8.80</td>\n",
       "      <td>True</td>\n",
       "      <td>643 days 09:41:19.067682</td>\n",
       "      <td>643.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>dfquulcbD7M</td>\n",
       "      <td>Raspberry Pi 5 Projects, you have to make</td>\n",
       "      <td>2023-10-16</td>\n",
       "      <td>9805.0</td>\n",
       "      <td>934.8867</td>\n",
       "      <td>116.0</td>\n",
       "      <td>35.156</td>\n",
       "      <td>0:05:43</td>\n",
       "      <td>100847</td>\n",
       "      <td>6.20</td>\n",
       "      <td>True</td>\n",
       "      <td>69 days 09:41:19.067682</td>\n",
       "      <td>69.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>PdYxop5aa2E</td>\n",
       "      <td>Raspberry Pi Pico and the nRF24L01 radio modul...</td>\n",
       "      <td>2021-08-26</td>\n",
       "      <td>8687.0</td>\n",
       "      <td>340.6341</td>\n",
       "      <td>60.0</td>\n",
       "      <td>28.795</td>\n",
       "      <td>0:02:21</td>\n",
       "      <td>47641</td>\n",
       "      <td>7.26</td>\n",
       "      <td>True</td>\n",
       "      <td>850 days 09:41:19.067682</td>\n",
       "      <td>850.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>A7ZJ5TC-zUk</td>\n",
       "      <td>Moving from Arduino to MicroPython - 10 Things...</td>\n",
       "      <td>2021-06-24</td>\n",
       "      <td>8464.0</td>\n",
       "      <td>656.6417</td>\n",
       "      <td>78.0</td>\n",
       "      <td>24.375</td>\n",
       "      <td>0:04:39</td>\n",
       "      <td>107949</td>\n",
       "      <td>5.50</td>\n",
       "      <td>True</td>\n",
       "      <td>913 days 09:41:19.067682</td>\n",
       "      <td>913.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>iIdoXzcuV2Q</td>\n",
       "      <td>Home Automation with Python and Home Assistant</td>\n",
       "      <td>2022-06-27</td>\n",
       "      <td>7664.0</td>\n",
       "      <td>600.1335</td>\n",
       "      <td>69.0</td>\n",
       "      <td>18.023</td>\n",
       "      <td>0:04:41</td>\n",
       "      <td>37371</td>\n",
       "      <td>8.17</td>\n",
       "      <td>True</td>\n",
       "      <td>545 days 09:41:19.067682</td>\n",
       "      <td>545.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>LwKOvT7rCiU</td>\n",
       "      <td>Raspberry Pi Zero Thermal Printer fun project</td>\n",
       "      <td>2021-07-29</td>\n",
       "      <td>6076.0</td>\n",
       "      <td>214.2176</td>\n",
       "      <td>23.0</td>\n",
       "      <td>14.550</td>\n",
       "      <td>0:02:06</td>\n",
       "      <td>37540</td>\n",
       "      <td>7.30</td>\n",
       "      <td>True</td>\n",
       "      <td>878 days 09:41:19.067682</td>\n",
       "      <td>878.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Content                                        Video title   \n",
       "2    KPfBOGjJdqE  Control Arduino with  Python using Firmata / P...  \\\n",
       "5    -BObt8inVs8  How to Map with LiDAR - using a Raspberry Pi Z...   \n",
       "6    fmgQ8Dcg9uM             Install MicroPython on ESP8266 & ESP32   \n",
       "7    N3jwEVbZyXY  LEARNING PYTHON - INTRODUCTION - for Raspberry...   \n",
       "9    tDDkz3Xdhuo                   The new Raspberry Pi Debug Probe   \n",
       "11   F5Bq7HVJkX0      How to use an Xbox Controller with your Robot   \n",
       "13   dfquulcbD7M          Raspberry Pi 5 Projects, you have to make   \n",
       "14   PdYxop5aa2E  Raspberry Pi Pico and the nRF24L01 radio modul...   \n",
       "17   A7ZJ5TC-zUk  Moving from Arduino to MicroPython - 10 Things...   \n",
       "21   iIdoXzcuV2Q     Home Automation with Python and Home Assistant   \n",
       "31   LwKOvT7rCiU      Raspberry Pi Zero Thermal Printer fun project   \n",
       "\n",
       "    published    Views  Watch time (hours)  Subscribers  revenue   \n",
       "2  2021-08-02  31730.0           1865.7467        340.0   70.869  \\\n",
       "5  2022-03-14  21594.0           1150.6273        292.0   52.944   \n",
       "6  2021-05-26  16917.0            465.9031         95.0   21.425   \n",
       "7  2020-07-27  12055.0            859.3600        222.0   25.498   \n",
       "9  2023-02-20  11910.0            432.9598         71.0   28.755   \n",
       "11 2022-03-21  11131.0            436.5615         71.0   26.223   \n",
       "13 2023-10-16   9805.0            934.8867        116.0   35.156   \n",
       "14 2021-08-26   8687.0            340.6341         60.0   28.795   \n",
       "17 2021-06-24   8464.0            656.6417         78.0   24.375   \n",
       "21 2022-06-27   7664.0            600.1335         69.0   18.023   \n",
       "31 2021-07-29   6076.0            214.2176         23.0   14.550   \n",
       "\n",
       "   Average view duration  Impressions   ctr  top_earners   \n",
       "2                0:03:31       328781  6.18         True  \\\n",
       "5                0:03:11       167539  5.84         True   \n",
       "6                0:01:39       110373  9.08         True   \n",
       "7                0:04:16        39826  8.94         True   \n",
       "9                0:02:10        81624  7.12         True   \n",
       "11               0:02:21        63692  8.80         True   \n",
       "13               0:05:43       100847  6.20         True   \n",
       "14               0:02:21        47641  7.26         True   \n",
       "17               0:04:39       107949  5.50         True   \n",
       "21               0:04:41        37371  8.17         True   \n",
       "31               0:02:06        37540  7.30         True   \n",
       "\n",
       "                         age  age_days  best_ctr  popular  \n",
       "2   874 days 09:41:19.067682     874.0      True     True  \n",
       "5   650 days 09:41:19.067682     650.0      True     True  \n",
       "6   942 days 09:41:19.067682     942.0      True     True  \n",
       "7  1245 days 09:41:19.067682    1245.0      True     True  \n",
       "9   307 days 09:41:19.067682     307.0      True     True  \n",
       "11  643 days 09:41:19.067682     643.0      True     True  \n",
       "13   69 days 09:41:19.067682      69.0      True     True  \n",
       "14  850 days 09:41:19.067682     850.0      True     True  \n",
       "17  913 days 09:41:19.067682     913.0      True     True  \n",
       "21  545 days 09:41:19.067682     545.0      True     True  \n",
       "31  878 days 09:41:19.067682     878.0      True     True  "
      ]
     },
     "execution_count": 152,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ultimate = filtered_df = videos[videos[['top_earners', 'best_ctr', 'popular']].all(axis=1)]\n",
    "len(ultimate)\n",
    "ultimate"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "id": "cd193396-8f5e-4a14-a67c-fc6b16d0fcc4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "68"
      ]
     },
     "execution_count": 149,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(filtered_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "id": "22efe8e2-ebd1-4ccd-ae66-e4b4369ef4ea",
   "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>Content</th>\n",
       "      <th>Video title</th>\n",
       "      <th>published</th>\n",
       "      <th>Views</th>\n",
       "      <th>Watch time (hours)</th>\n",
       "      <th>Subscribers</th>\n",
       "      <th>revenue</th>\n",
       "      <th>Average view duration</th>\n",
       "      <th>Impressions</th>\n",
       "      <th>ctr</th>\n",
       "      <th>top_earners</th>\n",
       "      <th>age</th>\n",
       "      <th>age_days</th>\n",
       "      <th>best_ctr</th>\n",
       "      <th>popular</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Y5atyJbVsAU</td>\n",
       "      <td>Build Your Own AI Assistant Part 1 - Creating ...</td>\n",
       "      <td>2021-04-19</td>\n",
       "      <td>38177.0</td>\n",
       "      <td>2660.5312</td>\n",
       "      <td>830.0</td>\n",
       "      <td>128.991</td>\n",
       "      <td>0:04:10</td>\n",
       "      <td>358964</td>\n",
       "      <td>3.64</td>\n",
       "      <td>True</td>\n",
       "      <td>979 days 09:41:19.067682</td>\n",
       "      <td>979.0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>KPfBOGjJdqE</td>\n",
       "      <td>Control Arduino with  Python using Firmata / P...</td>\n",
       "      <td>2021-08-02</td>\n",
       "      <td>31730.0</td>\n",
       "      <td>1865.7467</td>\n",
       "      <td>340.0</td>\n",
       "      <td>70.869</td>\n",
       "      <td>0:03:31</td>\n",
       "      <td>328781</td>\n",
       "      <td>6.18</td>\n",
       "      <td>True</td>\n",
       "      <td>874 days 09:41:19.067682</td>\n",
       "      <td>874.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0sPPxIq4hg8</td>\n",
       "      <td>Build your own web server using a Raspberry Pi...</td>\n",
       "      <td>2022-08-29</td>\n",
       "      <td>31337.0</td>\n",
       "      <td>4469.2779</td>\n",
       "      <td>451.0</td>\n",
       "      <td>128.964</td>\n",
       "      <td>0:08:33</td>\n",
       "      <td>467561</td>\n",
       "      <td>3.38</td>\n",
       "      <td>True</td>\n",
       "      <td>482 days 09:41:19.067682</td>\n",
       "      <td>482.0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>hiVcgUdjy0A</td>\n",
       "      <td>Node-Red Automation, MQTT, NodeMCU &amp; MicroPython</td>\n",
       "      <td>2021-03-29</td>\n",
       "      <td>23557.0</td>\n",
       "      <td>3441.1976</td>\n",
       "      <td>375.0</td>\n",
       "      <td>88.065</td>\n",
       "      <td>0:08:45</td>\n",
       "      <td>394481</td>\n",
       "      <td>3.43</td>\n",
       "      <td>True</td>\n",
       "      <td>1000 days 09:41:19.067682</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>-BObt8inVs8</td>\n",
       "      <td>How to Map with LiDAR - using a Raspberry Pi Z...</td>\n",
       "      <td>2022-03-14</td>\n",
       "      <td>21594.0</td>\n",
       "      <td>1150.6273</td>\n",
       "      <td>292.0</td>\n",
       "      <td>52.944</td>\n",
       "      <td>0:03:11</td>\n",
       "      <td>167539</td>\n",
       "      <td>5.84</td>\n",
       "      <td>True</td>\n",
       "      <td>650 days 09:41:19.067682</td>\n",
       "      <td>650.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>XeRW6tWKyxI</td>\n",
       "      <td>Hewenden Viaduct</td>\n",
       "      <td>2017-08-10</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0.1462</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.008</td>\n",
       "      <td>0:00:30</td>\n",
       "      <td>50</td>\n",
       "      <td>8.00</td>\n",
       "      <td>False</td>\n",
       "      <td>2327 days 09:41:19.067682</td>\n",
       "      <td>2327.0</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>st42a948T8U</td>\n",
       "      <td>Make your own Arduino Trailer</td>\n",
       "      <td>NaT</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0763</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.018</td>\n",
       "      <td>0:00:19</td>\n",
       "      <td>11</td>\n",
       "      <td>72.73</td>\n",
       "      <td>False</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>367</th>\n",
       "      <td>79Xl4Ivty0Y</td>\n",
       "      <td>The Boatyard Inn</td>\n",
       "      <td>2017-08-09</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0289</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0:00:26</td>\n",
       "      <td>49</td>\n",
       "      <td>8.16</td>\n",
       "      <td>False</td>\n",
       "      <td>2328 days 09:41:19.067682</td>\n",
       "      <td>2328.0</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>fLnfpUxI4B8</td>\n",
       "      <td>Scout Road 2017</td>\n",
       "      <td>2017-08-10</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0281</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0:00:33</td>\n",
       "      <td>50</td>\n",
       "      <td>6.00</td>\n",
       "      <td>False</td>\n",
       "      <td>2327 days 09:41:19.067682</td>\n",
       "      <td>2327.0</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>369</th>\n",
       "      <td>RWTlcOIwyP0</td>\n",
       "      <td>Epic Selfie</td>\n",
       "      <td>2017-08-12</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0178</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.004</td>\n",
       "      <td>0:00:31</td>\n",
       "      <td>4</td>\n",
       "      <td>50.00</td>\n",
       "      <td>False</td>\n",
       "      <td>2325 days 09:41:19.067682</td>\n",
       "      <td>2325.0</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>68 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Content                                        Video title   \n",
       "1     Y5atyJbVsAU  Build Your Own AI Assistant Part 1 - Creating ...  \\\n",
       "2     KPfBOGjJdqE  Control Arduino with  Python using Firmata / P...   \n",
       "3     0sPPxIq4hg8  Build your own web server using a Raspberry Pi...   \n",
       "4     hiVcgUdjy0A   Node-Red Automation, MQTT, NodeMCU & MicroPython   \n",
       "5     -BObt8inVs8  How to Map with LiDAR - using a Raspberry Pi Z...   \n",
       "..            ...                                                ...   \n",
       "357   XeRW6tWKyxI                                   Hewenden Viaduct   \n",
       "358   st42a948T8U                      Make your own Arduino Trailer   \n",
       "367   79Xl4Ivty0Y                                   The Boatyard Inn   \n",
       "368   fLnfpUxI4B8                                    Scout Road 2017   \n",
       "369   RWTlcOIwyP0                                        Epic Selfie   \n",
       "\n",
       "     published    Views  Watch time (hours)  Subscribers  revenue   \n",
       "1   2021-04-19  38177.0           2660.5312        830.0  128.991  \\\n",
       "2   2021-08-02  31730.0           1865.7467        340.0   70.869   \n",
       "3   2022-08-29  31337.0           4469.2779        451.0  128.964   \n",
       "4   2021-03-29  23557.0           3441.1976        375.0   88.065   \n",
       "5   2022-03-14  21594.0           1150.6273        292.0   52.944   \n",
       "..         ...      ...                 ...          ...      ...   \n",
       "357 2017-08-10     17.0              0.1462          0.0    0.008   \n",
       "358        NaT     14.0              0.0763          0.0    0.018   \n",
       "367 2017-08-09      4.0              0.0289          0.0      NaN   \n",
       "368 2017-08-10      3.0              0.0281          0.0      NaN   \n",
       "369 2017-08-12      2.0              0.0178          0.0    0.004   \n",
       "\n",
       "    Average view duration  Impressions    ctr  top_earners   \n",
       "1                 0:04:10       358964   3.64         True  \\\n",
       "2                 0:03:31       328781   6.18         True   \n",
       "3                 0:08:33       467561   3.38         True   \n",
       "4                 0:08:45       394481   3.43         True   \n",
       "5                 0:03:11       167539   5.84         True   \n",
       "..                    ...          ...    ...          ...   \n",
       "357               0:00:30           50   8.00        False   \n",
       "358               0:00:19           11  72.73        False   \n",
       "367               0:00:26           49   8.16        False   \n",
       "368               0:00:33           50   6.00        False   \n",
       "369               0:00:31            4  50.00        False   \n",
       "\n",
       "                          age  age_days  best_ctr  popular  \n",
       "1    979 days 09:41:19.067682     979.0     False     True  \n",
       "2    874 days 09:41:19.067682     874.0      True     True  \n",
       "3    482 days 09:41:19.067682     482.0     False     True  \n",
       "4   1000 days 09:41:19.067682    1000.0     False     True  \n",
       "5    650 days 09:41:19.067682     650.0      True     True  \n",
       "..                        ...       ...       ...      ...  \n",
       "357 2327 days 09:41:19.067682    2327.0      True    False  \n",
       "358                       NaT       NaN      True    False  \n",
       "367 2328 days 09:41:19.067682    2328.0      True    False  \n",
       "368 2327 days 09:41:19.067682    2327.0      True    False  \n",
       "369 2325 days 09:41:19.067682    2325.0      True    False  \n",
       "\n",
       "[68 rows x 15 columns]"
      ]
     },
     "execution_count": 150,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filtered_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "id": "5bb92845-69d4-43c1-95e2-2ce68980c958",
   "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>Content</th>\n",
       "      <th>Video title</th>\n",
       "      <th>published</th>\n",
       "      <th>Views</th>\n",
       "      <th>Watch time (hours)</th>\n",
       "      <th>Subscribers</th>\n",
       "      <th>revenue</th>\n",
       "      <th>Average view duration</th>\n",
       "      <th>Impressions</th>\n",
       "      <th>ctr</th>\n",
       "      <th>top_earners</th>\n",
       "      <th>age</th>\n",
       "      <th>age_days</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Y5atyJbVsAU</td>\n",
       "      <td>Build Your Own AI Assistant Part 1 - Creating ...</td>\n",
       "      <td>2021-04-19</td>\n",
       "      <td>38177.0</td>\n",
       "      <td>2660.5312</td>\n",
       "      <td>830.0</td>\n",
       "      <td>128.991</td>\n",
       "      <td>0:04:10</td>\n",
       "      <td>358964</td>\n",
       "      <td>3.64</td>\n",
       "      <td>True</td>\n",
       "      <td>979 days 09:41:19.067682</td>\n",
       "      <td>979.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>KPfBOGjJdqE</td>\n",
       "      <td>Control Arduino with  Python using Firmata / P...</td>\n",
       "      <td>2021-08-02</td>\n",
       "      <td>31730.0</td>\n",
       "      <td>1865.7467</td>\n",
       "      <td>340.0</td>\n",
       "      <td>70.869</td>\n",
       "      <td>0:03:31</td>\n",
       "      <td>328781</td>\n",
       "      <td>6.18</td>\n",
       "      <td>True</td>\n",
       "      <td>874 days 09:41:19.067682</td>\n",
       "      <td>874.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0sPPxIq4hg8</td>\n",
       "      <td>Build your own web server using a Raspberry Pi...</td>\n",
       "      <td>2022-08-29</td>\n",
       "      <td>31337.0</td>\n",
       "      <td>4469.2779</td>\n",
       "      <td>451.0</td>\n",
       "      <td>128.964</td>\n",
       "      <td>0:08:33</td>\n",
       "      <td>467561</td>\n",
       "      <td>3.38</td>\n",
       "      <td>True</td>\n",
       "      <td>482 days 09:41:19.067682</td>\n",
       "      <td>482.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>hiVcgUdjy0A</td>\n",
       "      <td>Node-Red Automation, MQTT, NodeMCU &amp; MicroPython</td>\n",
       "      <td>2021-03-29</td>\n",
       "      <td>23557.0</td>\n",
       "      <td>3441.1976</td>\n",
       "      <td>375.0</td>\n",
       "      <td>88.065</td>\n",
       "      <td>0:08:45</td>\n",
       "      <td>394481</td>\n",
       "      <td>3.43</td>\n",
       "      <td>True</td>\n",
       "      <td>1000 days 09:41:19.067682</td>\n",
       "      <td>1000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>-BObt8inVs8</td>\n",
       "      <td>How to Map with LiDAR - using a Raspberry Pi Z...</td>\n",
       "      <td>2022-03-14</td>\n",
       "      <td>21594.0</td>\n",
       "      <td>1150.6273</td>\n",
       "      <td>292.0</td>\n",
       "      <td>52.944</td>\n",
       "      <td>0:03:11</td>\n",
       "      <td>167539</td>\n",
       "      <td>5.84</td>\n",
       "      <td>True</td>\n",
       "      <td>650 days 09:41:19.067682</td>\n",
       "      <td>650.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>fmgQ8Dcg9uM</td>\n",
       "      <td>Install MicroPython on ESP8266 &amp; ESP32</td>\n",
       "      <td>2021-05-26</td>\n",
       "      <td>16917.0</td>\n",
       "      <td>465.9031</td>\n",
       "      <td>95.0</td>\n",
       "      <td>21.425</td>\n",
       "      <td>0:01:39</td>\n",
       "      <td>110373</td>\n",
       "      <td>9.08</td>\n",
       "      <td>True</td>\n",
       "      <td>942 days 09:41:19.067682</td>\n",
       "      <td>942.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>N3jwEVbZyXY</td>\n",
       "      <td>LEARNING PYTHON - INTRODUCTION - for Raspberry...</td>\n",
       "      <td>2020-07-27</td>\n",
       "      <td>12055.0</td>\n",
       "      <td>859.3600</td>\n",
       "      <td>222.0</td>\n",
       "      <td>25.498</td>\n",
       "      <td>0:04:16</td>\n",
       "      <td>39826</td>\n",
       "      <td>8.94</td>\n",
       "      <td>True</td>\n",
       "      <td>1245 days 09:41:19.067682</td>\n",
       "      <td>1245.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>-0wCtKz1l78</td>\n",
       "      <td>How to make a Bluetooth remote using a Raspber...</td>\n",
       "      <td>2023-07-02</td>\n",
       "      <td>11957.0</td>\n",
       "      <td>1227.2527</td>\n",
       "      <td>188.0</td>\n",
       "      <td>64.720</td>\n",
       "      <td>0:06:09</td>\n",
       "      <td>119209</td>\n",
       "      <td>3.61</td>\n",
       "      <td>True</td>\n",
       "      <td>175 days 09:41:19.067682</td>\n",
       "      <td>175.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>tDDkz3Xdhuo</td>\n",
       "      <td>The new Raspberry Pi Debug Probe</td>\n",
       "      <td>2023-02-20</td>\n",
       "      <td>11910.0</td>\n",
       "      <td>432.9598</td>\n",
       "      <td>71.0</td>\n",
       "      <td>28.755</td>\n",
       "      <td>0:02:10</td>\n",
       "      <td>81624</td>\n",
       "      <td>7.12</td>\n",
       "      <td>True</td>\n",
       "      <td>307 days 09:41:19.067682</td>\n",
       "      <td>307.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>vXYzJ1os4NA</td>\n",
       "      <td>Eben Upton on the new Raspberry Pi 5</td>\n",
       "      <td>2023-09-28</td>\n",
       "      <td>11318.0</td>\n",
       "      <td>2366.6999</td>\n",
       "      <td>104.0</td>\n",
       "      <td>46.708</td>\n",
       "      <td>0:12:32</td>\n",
       "      <td>243486</td>\n",
       "      <td>2.52</td>\n",
       "      <td>True</td>\n",
       "      <td>87 days 09:41:19.067682</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>F5Bq7HVJkX0</td>\n",
       "      <td>How to use an Xbox Controller with your Robot</td>\n",
       "      <td>2022-03-21</td>\n",
       "      <td>11131.0</td>\n",
       "      <td>436.5615</td>\n",
       "      <td>71.0</td>\n",
       "      <td>26.223</td>\n",
       "      <td>0:02:21</td>\n",
       "      <td>63692</td>\n",
       "      <td>8.80</td>\n",
       "      <td>True</td>\n",
       "      <td>643 days 09:41:19.067682</td>\n",
       "      <td>643.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>dfquulcbD7M</td>\n",
       "      <td>Raspberry Pi 5 Projects, you have to make</td>\n",
       "      <td>2023-10-16</td>\n",
       "      <td>9805.0</td>\n",
       "      <td>934.8867</td>\n",
       "      <td>116.0</td>\n",
       "      <td>35.156</td>\n",
       "      <td>0:05:43</td>\n",
       "      <td>100847</td>\n",
       "      <td>6.20</td>\n",
       "      <td>True</td>\n",
       "      <td>69 days 09:41:19.067682</td>\n",
       "      <td>69.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>PdYxop5aa2E</td>\n",
       "      <td>Raspberry Pi Pico and the nRF24L01 radio modul...</td>\n",
       "      <td>2021-08-26</td>\n",
       "      <td>8687.0</td>\n",
       "      <td>340.6341</td>\n",
       "      <td>60.0</td>\n",
       "      <td>28.795</td>\n",
       "      <td>0:02:21</td>\n",
       "      <td>47641</td>\n",
       "      <td>7.26</td>\n",
       "      <td>True</td>\n",
       "      <td>850 days 09:41:19.067682</td>\n",
       "      <td>850.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>03wKo-riJlA</td>\n",
       "      <td>Learn ROS with me - Setting up the Raspberry Pi</td>\n",
       "      <td>2023-01-09</td>\n",
       "      <td>8678.0</td>\n",
       "      <td>792.2609</td>\n",
       "      <td>164.0</td>\n",
       "      <td>33.696</td>\n",
       "      <td>0:05:28</td>\n",
       "      <td>95002</td>\n",
       "      <td>5.00</td>\n",
       "      <td>True</td>\n",
       "      <td>349 days 09:41:19.067682</td>\n",
       "      <td>349.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>QeDnjcdGrpY</td>\n",
       "      <td>Micropython Threads - Use Both Cores, on Raspb...</td>\n",
       "      <td>2021-12-13</td>\n",
       "      <td>8647.0</td>\n",
       "      <td>1203.2239</td>\n",
       "      <td>127.0</td>\n",
       "      <td>24.919</td>\n",
       "      <td>0:08:20</td>\n",
       "      <td>147467</td>\n",
       "      <td>2.77</td>\n",
       "      <td>True</td>\n",
       "      <td>741 days 09:41:19.067682</td>\n",
       "      <td>741.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>A7ZJ5TC-zUk</td>\n",
       "      <td>Moving from Arduino to MicroPython - 10 Things...</td>\n",
       "      <td>2021-06-24</td>\n",
       "      <td>8464.0</td>\n",
       "      <td>656.6417</td>\n",
       "      <td>78.0</td>\n",
       "      <td>24.375</td>\n",
       "      <td>0:04:39</td>\n",
       "      <td>107949</td>\n",
       "      <td>5.50</td>\n",
       "      <td>True</td>\n",
       "      <td>913 days 09:41:19.067682</td>\n",
       "      <td>913.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>ysNTEy1lUKo</td>\n",
       "      <td>Chris Barnatt on the new Raspberry Pi 5</td>\n",
       "      <td>2023-09-28</td>\n",
       "      <td>8198.0</td>\n",
       "      <td>856.5541</td>\n",
       "      <td>74.0</td>\n",
       "      <td>14.561</td>\n",
       "      <td>0:06:16</td>\n",
       "      <td>119663</td>\n",
       "      <td>4.81</td>\n",
       "      <td>True</td>\n",
       "      <td>87 days 09:41:19.067682</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>J_CkQ36tVA4</td>\n",
       "      <td>Raspberry Pi Camera Module V3 - new for Januar...</td>\n",
       "      <td>2023-01-09</td>\n",
       "      <td>7698.0</td>\n",
       "      <td>322.2920</td>\n",
       "      <td>70.0</td>\n",
       "      <td>17.381</td>\n",
       "      <td>0:02:30</td>\n",
       "      <td>94370</td>\n",
       "      <td>4.41</td>\n",
       "      <td>True</td>\n",
       "      <td>349 days 09:41:19.067682</td>\n",
       "      <td>349.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>x4dZafO5FNg</td>\n",
       "      <td>DO THIS to connect two Picos together - to Pic...</td>\n",
       "      <td>2022-08-26</td>\n",
       "      <td>7667.0</td>\n",
       "      <td>324.4264</td>\n",
       "      <td>41.0</td>\n",
       "      <td>15.266</td>\n",
       "      <td>0:02:32</td>\n",
       "      <td>53266</td>\n",
       "      <td>5.43</td>\n",
       "      <td>True</td>\n",
       "      <td>485 days 09:41:19.067682</td>\n",
       "      <td>485.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>iIdoXzcuV2Q</td>\n",
       "      <td>Home Automation with Python and Home Assistant</td>\n",
       "      <td>2022-06-27</td>\n",
       "      <td>7664.0</td>\n",
       "      <td>600.1335</td>\n",
       "      <td>69.0</td>\n",
       "      <td>18.023</td>\n",
       "      <td>0:04:41</td>\n",
       "      <td>37371</td>\n",
       "      <td>8.17</td>\n",
       "      <td>True</td>\n",
       "      <td>545 days 09:41:19.067682</td>\n",
       "      <td>545.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>nW5FUVzYCKM</td>\n",
       "      <td>Inverse Kinematics in Python and MicroPython</td>\n",
       "      <td>2021-09-20</td>\n",
       "      <td>7619.0</td>\n",
       "      <td>594.9604</td>\n",
       "      <td>164.0</td>\n",
       "      <td>14.345</td>\n",
       "      <td>0:04:41</td>\n",
       "      <td>74470</td>\n",
       "      <td>4.85</td>\n",
       "      <td>True</td>\n",
       "      <td>825 days 09:41:19.067682</td>\n",
       "      <td>825.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>TkuDQ-SzXwU</td>\n",
       "      <td>Learn MicroPython - Part 1 Controlling the flow</td>\n",
       "      <td>2022-11-20</td>\n",
       "      <td>7447.0</td>\n",
       "      <td>671.5952</td>\n",
       "      <td>186.0</td>\n",
       "      <td>23.153</td>\n",
       "      <td>0:05:24</td>\n",
       "      <td>109298</td>\n",
       "      <td>3.60</td>\n",
       "      <td>True</td>\n",
       "      <td>399 days 09:41:19.067682</td>\n",
       "      <td>399.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>_cTJhCRv858</td>\n",
       "      <td>Build a ROS robot - Learn ROS with me Part 1</td>\n",
       "      <td>2023-01-02</td>\n",
       "      <td>6520.0</td>\n",
       "      <td>552.7759</td>\n",
       "      <td>185.0</td>\n",
       "      <td>27.588</td>\n",
       "      <td>0:05:05</td>\n",
       "      <td>67100</td>\n",
       "      <td>5.26</td>\n",
       "      <td>True</td>\n",
       "      <td>356 days 09:41:19.067682</td>\n",
       "      <td>356.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2Y42DSZpR0w</td>\n",
       "      <td>How to build a captive portal with MicroPython...</td>\n",
       "      <td>2022-09-05</td>\n",
       "      <td>6310.0</td>\n",
       "      <td>798.6819</td>\n",
       "      <td>113.0</td>\n",
       "      <td>19.623</td>\n",
       "      <td>0:07:35</td>\n",
       "      <td>84431</td>\n",
       "      <td>3.55</td>\n",
       "      <td>True</td>\n",
       "      <td>475 days 09:41:19.067682</td>\n",
       "      <td>475.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>q5lML34Noio</td>\n",
       "      <td>Build a ChatGPT-Like language model in Python ...</td>\n",
       "      <td>2023-03-20</td>\n",
       "      <td>6255.0</td>\n",
       "      <td>478.5236</td>\n",
       "      <td>95.0</td>\n",
       "      <td>20.472</td>\n",
       "      <td>0:04:35</td>\n",
       "      <td>64683</td>\n",
       "      <td>3.91</td>\n",
       "      <td>True</td>\n",
       "      <td>279 days 09:41:19.067682</td>\n",
       "      <td>279.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>LwKOvT7rCiU</td>\n",
       "      <td>Raspberry Pi Zero Thermal Printer fun project</td>\n",
       "      <td>2021-07-29</td>\n",
       "      <td>6076.0</td>\n",
       "      <td>214.2176</td>\n",
       "      <td>23.0</td>\n",
       "      <td>14.550</td>\n",
       "      <td>0:02:06</td>\n",
       "      <td>37540</td>\n",
       "      <td>7.30</td>\n",
       "      <td>True</td>\n",
       "      <td>878 days 09:41:19.067682</td>\n",
       "      <td>878.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>kJpLMBqNcIQ</td>\n",
       "      <td>Jetson Nano Custom Object Detection - how to t...</td>\n",
       "      <td>2021-08-23</td>\n",
       "      <td>5846.0</td>\n",
       "      <td>433.2480</td>\n",
       "      <td>62.0</td>\n",
       "      <td>18.925</td>\n",
       "      <td>0:04:26</td>\n",
       "      <td>69156</td>\n",
       "      <td>4.19</td>\n",
       "      <td>True</td>\n",
       "      <td>853 days 09:41:19.067682</td>\n",
       "      <td>853.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>hV9GTqXLMpg</td>\n",
       "      <td>Raspberry Pi Pico &amp; RFID</td>\n",
       "      <td>2021-11-22</td>\n",
       "      <td>5797.0</td>\n",
       "      <td>540.2537</td>\n",
       "      <td>58.0</td>\n",
       "      <td>18.057</td>\n",
       "      <td>0:05:35</td>\n",
       "      <td>62951</td>\n",
       "      <td>4.78</td>\n",
       "      <td>True</td>\n",
       "      <td>762 days 09:41:19.067682</td>\n",
       "      <td>762.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>FrLHFZZIozk</td>\n",
       "      <td>Raspberry Pi 5 - How fast is OpenCV Face detec...</td>\n",
       "      <td>2023-10-09</td>\n",
       "      <td>4814.0</td>\n",
       "      <td>458.7310</td>\n",
       "      <td>83.0</td>\n",
       "      <td>14.982</td>\n",
       "      <td>0:05:43</td>\n",
       "      <td>72917</td>\n",
       "      <td>4.00</td>\n",
       "      <td>True</td>\n",
       "      <td>76 days 09:41:19.067682</td>\n",
       "      <td>76.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>ph10GSO8pDk</td>\n",
       "      <td>Raspberry Pi Pico &amp; MPU9250 with MicroPython</td>\n",
       "      <td>2021-05-03</td>\n",
       "      <td>4665.0</td>\n",
       "      <td>576.5904</td>\n",
       "      <td>41.0</td>\n",
       "      <td>17.062</td>\n",
       "      <td>0:07:24</td>\n",
       "      <td>41853</td>\n",
       "      <td>4.19</td>\n",
       "      <td>True</td>\n",
       "      <td>965 days 09:41:19.067682</td>\n",
       "      <td>965.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>8BCsBgt-5zY</td>\n",
       "      <td>How to create Databases in Python with SQLite</td>\n",
       "      <td>2023-07-17</td>\n",
       "      <td>4615.0</td>\n",
       "      <td>536.5228</td>\n",
       "      <td>102.0</td>\n",
       "      <td>17.094</td>\n",
       "      <td>0:06:58</td>\n",
       "      <td>141755</td>\n",
       "      <td>2.08</td>\n",
       "      <td>True</td>\n",
       "      <td>160 days 09:41:19.067682</td>\n",
       "      <td>160.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>QlOZAuy6DsU</td>\n",
       "      <td>Make your own GhostBox - using a Raspberry Pi ...</td>\n",
       "      <td>2022-10-17</td>\n",
       "      <td>4473.0</td>\n",
       "      <td>253.8184</td>\n",
       "      <td>67.0</td>\n",
       "      <td>15.356</td>\n",
       "      <td>0:03:24</td>\n",
       "      <td>32112</td>\n",
       "      <td>6.53</td>\n",
       "      <td>True</td>\n",
       "      <td>433 days 09:41:19.067682</td>\n",
       "      <td>433.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>SJo5hVNk0BQ</td>\n",
       "      <td>Raspberry Pi 5 - Hands on Livestream</td>\n",
       "      <td>2023-10-01</td>\n",
       "      <td>4006.0</td>\n",
       "      <td>943.1220</td>\n",
       "      <td>59.0</td>\n",
       "      <td>17.830</td>\n",
       "      <td>0:14:07</td>\n",
       "      <td>88730</td>\n",
       "      <td>2.62</td>\n",
       "      <td>True</td>\n",
       "      <td>84 days 09:41:19.067682</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>oqUUc-mqdak</td>\n",
       "      <td>How to Draw Graphics with MicroPython, and Pic...</td>\n",
       "      <td>2023-07-10</td>\n",
       "      <td>3775.0</td>\n",
       "      <td>595.7592</td>\n",
       "      <td>44.0</td>\n",
       "      <td>32.017</td>\n",
       "      <td>0:09:28</td>\n",
       "      <td>88066</td>\n",
       "      <td>2.27</td>\n",
       "      <td>True</td>\n",
       "      <td>167 days 09:41:19.067682</td>\n",
       "      <td>167.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>M-0P6ipVwNU</td>\n",
       "      <td>Master GPIO with Raspberry Pi Pico &amp; MicroPyth...</td>\n",
       "      <td>2023-04-16</td>\n",
       "      <td>3524.0</td>\n",
       "      <td>210.4910</td>\n",
       "      <td>49.0</td>\n",
       "      <td>28.962</td>\n",
       "      <td>0:03:35</td>\n",
       "      <td>60164</td>\n",
       "      <td>3.27</td>\n",
       "      <td>True</td>\n",
       "      <td>252 days 09:41:19.067682</td>\n",
       "      <td>252.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>H6CNmnT6kGo</td>\n",
       "      <td>How to Design PCBs with Fusion 360 in less tha...</td>\n",
       "      <td>2023-08-07</td>\n",
       "      <td>2666.0</td>\n",
       "      <td>511.8256</td>\n",
       "      <td>23.0</td>\n",
       "      <td>15.335</td>\n",
       "      <td>0:11:31</td>\n",
       "      <td>54997</td>\n",
       "      <td>2.57</td>\n",
       "      <td>True</td>\n",
       "      <td>139 days 09:41:19.067682</td>\n",
       "      <td>139.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>AgOpz3ttPgc</td>\n",
       "      <td>Pico Starter Kit Unboxing and Review</td>\n",
       "      <td>2021-07-26</td>\n",
       "      <td>591.0</td>\n",
       "      <td>73.8059</td>\n",
       "      <td>7.0</td>\n",
       "      <td>29.791</td>\n",
       "      <td>0:07:29</td>\n",
       "      <td>9766</td>\n",
       "      <td>3.70</td>\n",
       "      <td>True</td>\n",
       "      <td>881 days 09:41:19.067682</td>\n",
       "      <td>881.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Content                                        Video title   \n",
       "1     Y5atyJbVsAU  Build Your Own AI Assistant Part 1 - Creating ...  \\\n",
       "2     KPfBOGjJdqE  Control Arduino with  Python using Firmata / P...   \n",
       "3     0sPPxIq4hg8  Build your own web server using a Raspberry Pi...   \n",
       "4     hiVcgUdjy0A   Node-Red Automation, MQTT, NodeMCU & MicroPython   \n",
       "5     -BObt8inVs8  How to Map with LiDAR - using a Raspberry Pi Z...   \n",
       "6     fmgQ8Dcg9uM             Install MicroPython on ESP8266 & ESP32   \n",
       "7     N3jwEVbZyXY  LEARNING PYTHON - INTRODUCTION - for Raspberry...   \n",
       "8     -0wCtKz1l78  How to make a Bluetooth remote using a Raspber...   \n",
       "9     tDDkz3Xdhuo                   The new Raspberry Pi Debug Probe   \n",
       "10    vXYzJ1os4NA               Eben Upton on the new Raspberry Pi 5   \n",
       "11    F5Bq7HVJkX0      How to use an Xbox Controller with your Robot   \n",
       "13    dfquulcbD7M          Raspberry Pi 5 Projects, you have to make   \n",
       "14    PdYxop5aa2E  Raspberry Pi Pico and the nRF24L01 radio modul...   \n",
       "15    03wKo-riJlA    Learn ROS with me - Setting up the Raspberry Pi   \n",
       "16    QeDnjcdGrpY  Micropython Threads - Use Both Cores, on Raspb...   \n",
       "17    A7ZJ5TC-zUk  Moving from Arduino to MicroPython - 10 Things...   \n",
       "18    ysNTEy1lUKo            Chris Barnatt on the new Raspberry Pi 5   \n",
       "19    J_CkQ36tVA4  Raspberry Pi Camera Module V3 - new for Januar...   \n",
       "20    x4dZafO5FNg  DO THIS to connect two Picos together - to Pic...   \n",
       "21    iIdoXzcuV2Q     Home Automation with Python and Home Assistant   \n",
       "22    nW5FUVzYCKM       Inverse Kinematics in Python and MicroPython   \n",
       "23    TkuDQ-SzXwU    Learn MicroPython - Part 1 Controlling the flow   \n",
       "26    _cTJhCRv858       Build a ROS robot - Learn ROS with me Part 1   \n",
       "29    2Y42DSZpR0w  How to build a captive portal with MicroPython...   \n",
       "30    q5lML34Noio  Build a ChatGPT-Like language model in Python ...   \n",
       "31    LwKOvT7rCiU      Raspberry Pi Zero Thermal Printer fun project   \n",
       "32    kJpLMBqNcIQ  Jetson Nano Custom Object Detection - how to t...   \n",
       "34    hV9GTqXLMpg                           Raspberry Pi Pico & RFID   \n",
       "43    FrLHFZZIozk  Raspberry Pi 5 - How fast is OpenCV Face detec...   \n",
       "45    ph10GSO8pDk       Raspberry Pi Pico & MPU9250 with MicroPython   \n",
       "47    8BCsBgt-5zY      How to create Databases in Python with SQLite   \n",
       "50    QlOZAuy6DsU  Make your own GhostBox - using a Raspberry Pi ...   \n",
       "55    SJo5hVNk0BQ               Raspberry Pi 5 - Hands on Livestream   \n",
       "57    oqUUc-mqdak  How to Draw Graphics with MicroPython, and Pic...   \n",
       "62    M-0P6ipVwNU  Master GPIO with Raspberry Pi Pico & MicroPyth...   \n",
       "75    H6CNmnT6kGo  How to Design PCBs with Fusion 360 in less tha...   \n",
       "232   AgOpz3ttPgc               Pico Starter Kit Unboxing and Review   \n",
       "\n",
       "     published    Views  Watch time (hours)  Subscribers  revenue   \n",
       "1   2021-04-19  38177.0           2660.5312        830.0  128.991  \\\n",
       "2   2021-08-02  31730.0           1865.7467        340.0   70.869   \n",
       "3   2022-08-29  31337.0           4469.2779        451.0  128.964   \n",
       "4   2021-03-29  23557.0           3441.1976        375.0   88.065   \n",
       "5   2022-03-14  21594.0           1150.6273        292.0   52.944   \n",
       "6   2021-05-26  16917.0            465.9031         95.0   21.425   \n",
       "7   2020-07-27  12055.0            859.3600        222.0   25.498   \n",
       "8   2023-07-02  11957.0           1227.2527        188.0   64.720   \n",
       "9   2023-02-20  11910.0            432.9598         71.0   28.755   \n",
       "10  2023-09-28  11318.0           2366.6999        104.0   46.708   \n",
       "11  2022-03-21  11131.0            436.5615         71.0   26.223   \n",
       "13  2023-10-16   9805.0            934.8867        116.0   35.156   \n",
       "14  2021-08-26   8687.0            340.6341         60.0   28.795   \n",
       "15  2023-01-09   8678.0            792.2609        164.0   33.696   \n",
       "16  2021-12-13   8647.0           1203.2239        127.0   24.919   \n",
       "17  2021-06-24   8464.0            656.6417         78.0   24.375   \n",
       "18  2023-09-28   8198.0            856.5541         74.0   14.561   \n",
       "19  2023-01-09   7698.0            322.2920         70.0   17.381   \n",
       "20  2022-08-26   7667.0            324.4264         41.0   15.266   \n",
       "21  2022-06-27   7664.0            600.1335         69.0   18.023   \n",
       "22  2021-09-20   7619.0            594.9604        164.0   14.345   \n",
       "23  2022-11-20   7447.0            671.5952        186.0   23.153   \n",
       "26  2023-01-02   6520.0            552.7759        185.0   27.588   \n",
       "29  2022-09-05   6310.0            798.6819        113.0   19.623   \n",
       "30  2023-03-20   6255.0            478.5236         95.0   20.472   \n",
       "31  2021-07-29   6076.0            214.2176         23.0   14.550   \n",
       "32  2021-08-23   5846.0            433.2480         62.0   18.925   \n",
       "34  2021-11-22   5797.0            540.2537         58.0   18.057   \n",
       "43  2023-10-09   4814.0            458.7310         83.0   14.982   \n",
       "45  2021-05-03   4665.0            576.5904         41.0   17.062   \n",
       "47  2023-07-17   4615.0            536.5228        102.0   17.094   \n",
       "50  2022-10-17   4473.0            253.8184         67.0   15.356   \n",
       "55  2023-10-01   4006.0            943.1220         59.0   17.830   \n",
       "57  2023-07-10   3775.0            595.7592         44.0   32.017   \n",
       "62  2023-04-16   3524.0            210.4910         49.0   28.962   \n",
       "75  2023-08-07   2666.0            511.8256         23.0   15.335   \n",
       "232 2021-07-26    591.0             73.8059          7.0   29.791   \n",
       "\n",
       "    Average view duration  Impressions   ctr  top_earners   \n",
       "1                 0:04:10       358964  3.64         True  \\\n",
       "2                 0:03:31       328781  6.18         True   \n",
       "3                 0:08:33       467561  3.38         True   \n",
       "4                 0:08:45       394481  3.43         True   \n",
       "5                 0:03:11       167539  5.84         True   \n",
       "6                 0:01:39       110373  9.08         True   \n",
       "7                 0:04:16        39826  8.94         True   \n",
       "8                 0:06:09       119209  3.61         True   \n",
       "9                 0:02:10        81624  7.12         True   \n",
       "10                0:12:32       243486  2.52         True   \n",
       "11                0:02:21        63692  8.80         True   \n",
       "13                0:05:43       100847  6.20         True   \n",
       "14                0:02:21        47641  7.26         True   \n",
       "15                0:05:28        95002  5.00         True   \n",
       "16                0:08:20       147467  2.77         True   \n",
       "17                0:04:39       107949  5.50         True   \n",
       "18                0:06:16       119663  4.81         True   \n",
       "19                0:02:30        94370  4.41         True   \n",
       "20                0:02:32        53266  5.43         True   \n",
       "21                0:04:41        37371  8.17         True   \n",
       "22                0:04:41        74470  4.85         True   \n",
       "23                0:05:24       109298  3.60         True   \n",
       "26                0:05:05        67100  5.26         True   \n",
       "29                0:07:35        84431  3.55         True   \n",
       "30                0:04:35        64683  3.91         True   \n",
       "31                0:02:06        37540  7.30         True   \n",
       "32                0:04:26        69156  4.19         True   \n",
       "34                0:05:35        62951  4.78         True   \n",
       "43                0:05:43        72917  4.00         True   \n",
       "45                0:07:24        41853  4.19         True   \n",
       "47                0:06:58       141755  2.08         True   \n",
       "50                0:03:24        32112  6.53         True   \n",
       "55                0:14:07        88730  2.62         True   \n",
       "57                0:09:28        88066  2.27         True   \n",
       "62                0:03:35        60164  3.27         True   \n",
       "75                0:11:31        54997  2.57         True   \n",
       "232               0:07:29         9766  3.70         True   \n",
       "\n",
       "                          age  age_days  \n",
       "1    979 days 09:41:19.067682     979.0  \n",
       "2    874 days 09:41:19.067682     874.0  \n",
       "3    482 days 09:41:19.067682     482.0  \n",
       "4   1000 days 09:41:19.067682    1000.0  \n",
       "5    650 days 09:41:19.067682     650.0  \n",
       "6    942 days 09:41:19.067682     942.0  \n",
       "7   1245 days 09:41:19.067682    1245.0  \n",
       "8    175 days 09:41:19.067682     175.0  \n",
       "9    307 days 09:41:19.067682     307.0  \n",
       "10    87 days 09:41:19.067682      87.0  \n",
       "11   643 days 09:41:19.067682     643.0  \n",
       "13    69 days 09:41:19.067682      69.0  \n",
       "14   850 days 09:41:19.067682     850.0  \n",
       "15   349 days 09:41:19.067682     349.0  \n",
       "16   741 days 09:41:19.067682     741.0  \n",
       "17   913 days 09:41:19.067682     913.0  \n",
       "18    87 days 09:41:19.067682      87.0  \n",
       "19   349 days 09:41:19.067682     349.0  \n",
       "20   485 days 09:41:19.067682     485.0  \n",
       "21   545 days 09:41:19.067682     545.0  \n",
       "22   825 days 09:41:19.067682     825.0  \n",
       "23   399 days 09:41:19.067682     399.0  \n",
       "26   356 days 09:41:19.067682     356.0  \n",
       "29   475 days 09:41:19.067682     475.0  \n",
       "30   279 days 09:41:19.067682     279.0  \n",
       "31   878 days 09:41:19.067682     878.0  \n",
       "32   853 days 09:41:19.067682     853.0  \n",
       "34   762 days 09:41:19.067682     762.0  \n",
       "43    76 days 09:41:19.067682      76.0  \n",
       "45   965 days 09:41:19.067682     965.0  \n",
       "47   160 days 09:41:19.067682     160.0  \n",
       "50   433 days 09:41:19.067682     433.0  \n",
       "55    84 days 09:41:19.067682      84.0  \n",
       "57   167 days 09:41:19.067682     167.0  \n",
       "62   252 days 09:41:19.067682     252.0  \n",
       "75   139 days 09:41:19.067682     139.0  \n",
       "232  881 days 09:41:19.067682     881.0  "
      ]
     },
     "execution_count": 151,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_earners"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}