examples/DataConnector_Youtube.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Part of this file can't be rendered in GitHub. Refer to the following link for a properly rendered version of this file: https://nbviewer.jupyter.org/github/sfu-db/dataprep/blob/develop/examples/DataConnector_Youtube.ipynb"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Connector for YouTube \n",
    "\n",
    "In this example, we will be going over how to use Connector with YouTube."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Prerequisites\n",
    "\n",
    "Connector is a component in the DataPrep library that aims to simplify data access by providing a standard API set. The goal is to help users skip the complex API configuration. In this tutorial, we demonstrate how to use the connector component with YouTube.\n",
    "\n",
    "If you haven't installed DataPrep, run command `!pip install dataprep` or execute the following cell."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Run me if you'd like to install\n",
    "!pip install dataprep"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Download and store the configuration files in DataPrep. \n",
    "\n",
    "The configuration files are used to configure the parameters and initial setup for the API. The available configuration files can be manually downloaded here: [Configuration Files](https://github.com/sfu-db/DataConnectorConfigs) or automatically downloaded at usage. \n",
    "\n",
    "Store the configuration file in the dataprep folder. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "To get the YouTube API working, you need to have a [Google Account](https://accounts.google.com/signup/v2/webcreateaccount?continue=https%3A%2F%2Faccounts.google.com%2FManageAccount%3Fnc%3D1&flowName=GlifWebSignIn&flowEntry=SignUp).\n",
    "\n",
    "# Obtaining access token from YouTube\n",
    "\n",
    "Assuming you have a Google account, you can fetch an API token following these three simple steps:\n",
    "\n",
    "1. Login to [Google Cloud Platform](https://console.developers.google.com/) using your Google account. On your dashboard, click on **Select a Project** and choose an existing project if you have one. Or click on **New Project** - provide a project name and organization. \n",
    "\n",
    "2. Next, click **Enable APIs and Services** on the top left. Scroll down to find **YouTube Data API v3** and **Enable** the API service. Ensure the API service is enabled as shown in the image below.\n",
    "\n",
    "![title](images/youtube_enabled.png)\n",
    "\n",
    "3. Under **APIs & Services** on your project navigation menu, navigate to the **credentials** section. Click **Create Credentials** at the top and select **API Key**. This will generate an API key that can be used to search data from YouTube using Connector!\n",
    "\n",
    "![title](images/youtube_credentials.png)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Initialize connector\n",
    "\n",
    "Copy and paste your API key as the value for the **auth_token** variable. Ensure the **API name** argument is correct. This establishes a connection with Twitter and returns an object. Once you run the code you can use the built in functions available from connector."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from dataprep.connector import connect, info\n",
    "\n",
    "auth_token = '<insert API key>'\n",
    "dc = connect('youtube', _auth={'access_token':auth_token})\n",
    "\n",
    "dc"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Functionalities\n",
    "\n",
    "Connector has several functions you can perform to gain insight on the data downloaded from YouTube."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Connector.info\n",
    "The info method gives information and guidelines on using the connector. There are 4 sections in the response and they are table, parameters, example and schema.\n",
    "\n",
    ">1. Table - The table(s) being accessed.\n",
    ">2. Parameters - Identifies which parameters can be used to call the method.\n",
    ">3. Examples - Shows how you can call the methods in the Connector class.\n",
    ">4. Schema - Names and data types of attributes in the response."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<html>\n",
       "    <head>\n",
       "        <title> DataPrep.Connector Info </title>\n",
       "        <script>\n",
       "            function switchTab637(e) {\n",
       "                const selectedAreaSuffix = e.parentElement.parentElement.className.split('-')[1];\n",
       "                const selectedTabId = e.id.split('-')[2];\n",
       "                const selectedTabContent = document.querySelector(`.contents-${selectedAreaSuffix}>div:nth-of-type(${selectedTabId})`);\n",
       "                const contentArray = document.getElementsByClassName('info-637')\n",
       "                for (let i of contentArray) {\n",
       "                    i.style.display = 'none';\n",
       "                }\n",
       "                selectedTabContent.style.display = 'block';\n",
       "            }\n",
       "        </script>\n",
       "        <style>\n",
       "            .container-637 {\n",
       "            }\n",
       "            .container-637 input[type=radio] {\n",
       "            display: none;\n",
       "            }\n",
       "            .tabs-637 {\n",
       "            font-family: -apple-system, 'Helvetica Neue', 'Helvetica', 'Arial', 'Lucida Grande', sans-serif;\n",
       "            -webkit-font-smoothing: antialiased;\n",
       "            display: grid;\n",
       "            flex-wrap: wrap;\n",
       "            gap: 5px;\n",
       "            grid-template-columns: repeat(auto-fill, minmax(110px, 1fr));\n",
       "            justify-content: wrap;\n",
       "            }\n",
       "            .tabs-637 label {\n",
       "            word-wrap: break-word;\n",
       "            text-align: center;\n",
       "            font-size: 12px;\n",
       "            border-bottom: 2px solid #9edae5;\n",
       "            transition: border 0.3s ease;\n",
       "            }\n",
       "            .tabs-637 label:hover {\n",
       "            background: rgba(0, 0, 0, 0.1);\n",
       "            }\n",
       "            .tabs-637 input:checked+label {\n",
       "            border-bottom: 2px solid #1f77b4;\n",
       "            }\n",
       "            .contents-637>div:nth-of-type(n+2) {\n",
       "            display: none;\n",
       "            }\n",
       "            h4 {\n",
       "            font-size: 14px;\n",
       "            font-family: Arial;\n",
       "            }\n",
       "            p {\n",
       "            font-size: 13px;\n",
       "            }\n",
       "        </style>\n",
       "    </head>\n",
       "    <body>\n",
       "        <div class=\"container-637\">\n",
       "            <div class=\"tabs-637\">\n",
       "                <input type=\"radio\" name=\"select\" id='tab-637-1' checked onclick=\"switchTab637(this)\">\n",
       "                <label for=\"tab-637-1\">videos</label>\n",
       "                \n",
       "                \n",
       "                \n",
       "                    \t\t\n",
       "            </div>\n",
       "            <div class=\"contents-637\">\n",
       "                \n",
       "                <div class=\"info-637\">\n",
       "                    <div>\n",
       "                        <h4><u>Parameters</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>q (required)</code></p>\n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>part (required)</code></p>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>type</code></p>\n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>maxResults</code></p>\n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>pageToken</code></p>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                    </div>\n",
       "                    <div>\n",
       "                        <h4><u>Example</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p><code>dc = connect('youtube', _auth={'access_token':'cCMHU4M4t7rdt*********vp3whGzFjgIKIm0'}, _concurrency=3)<br>df = await dc.query('videos', q='animation', part='snippet', _count=20)</code></p>\n",
       "                    </div>\n",
       "                    <div>\n",
       "                    \t<h4><u>Schema</u></h4>\n",
       "                    \t<style  type=\"text/css\" >\n",
       "    #T_97cf38a0_35b1_11eb_95df_c82a14415709 th {\n",
       "          background: white;\n",
       "          font-weight: bold;\n",
       "          text-align: right;\n",
       "          font-family: arial;\n",
       "          font-size: 13;\n",
       "    }    #T_97cf38a0_35b1_11eb_95df_c82a14415709 td {\n",
       "          font-family: arial;\n",
       "    }    #T_97cf38a0_35b1_11eb_95df_c82a14415709 tr:nth-of-type(odd) {\n",
       "          background: #f5f5f5;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_97cf38a0_35b1_11eb_95df_c82a14415709 tr:nth-of-type(even) {\n",
       "          background: #white;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_97cf38a0_35b1_11eb_95df_c82a14415709 tr:hover {\n",
       "          background-color: e0f1ff;\n",
       "    }</style><table id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >column_name</th>        <th class=\"col_heading level0 col1\" >data_type</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709row0_col0\" class=\"data row0 col0\" >etag</td>\n",
       "                        <td id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709row0_col1\" class=\"data row0 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709row1_col0\" class=\"data row1 col0\" >videoId</td>\n",
       "                        <td id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709row1_col1\" class=\"data row1 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709row2_col0\" class=\"data row2 col0\" >publishedAt</td>\n",
       "                        <td id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709row2_col1\" class=\"data row2 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709row3_col0\" class=\"data row3 col0\" >channelId</td>\n",
       "                        <td id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709row3_col1\" class=\"data row3 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709row4_col0\" class=\"data row4 col0\" >title</td>\n",
       "                        <td id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709row4_col1\" class=\"data row4 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709row5_col0\" class=\"data row5 col0\" >description</td>\n",
       "                        <td id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709row5_col1\" class=\"data row5 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "                        <td id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709row6_col0\" class=\"data row6 col0\" >channelTitle</td>\n",
       "                        <td id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709row6_col1\" class=\"data row6 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "                        <td id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709row7_col0\" class=\"data row7 col0\" >publishTime</td>\n",
       "                        <td id=\"T_97cf38a0_35b1_11eb_95df_c82a14415709row7_col1\" class=\"data row7 col1\" >string</td>\n",
       "            </tr>\n",
       "    </tbody></table>\n",
       "                    </div>\n",
       "                </div>\n",
       "                \n",
       "            </div>\n",
       "        </div>\n",
       "    </body>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "info('youtube')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Connector.query\n",
    "The query method downloads the website data and displays it in a Dataframe. The parameters must meet the requirements as indicated in connector.info for the operation to run. You can use the **_count** parameter to specify the number of vidoes/channels/playlists to be fetched. Each request can currently fetch a maximum of 50 items.\n",
    "\n",
    "When the data is received from the server, it will either be in a JSON or XML format. The connector reformats the data in pandas Dataframe for the convenience of downstream operations.\n",
    "\n",
    "As an example, let's try to fetch **40 videos** related to **Data Science** from YouTube."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Searching for Videos related to Data Science"
   ]
  },
  {
   "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>etag</th>\n",
       "      <th>videoId</th>\n",
       "      <th>publishedAt</th>\n",
       "      <th>channelId</th>\n",
       "      <th>title</th>\n",
       "      <th>description</th>\n",
       "      <th>channelTitle</th>\n",
       "      <th>publishTime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6znlxNDEq3exijy84F6TBYh_Voc</td>\n",
       "      <td>xC-c7E5PK0Y</td>\n",
       "      <td>2018-06-23T01:51:50Z</td>\n",
       "      <td>UCV0qA-eDDICsRR9rPcnG7tw</td>\n",
       "      <td>What REALLY is Data Science? Told by a Data Sc...</td>\n",
       "      <td>Resume Template and Cover letter I used for ap...</td>\n",
       "      <td>Joma Tech</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BHk3ZOf85w_GJwg3WuR76i-q7nU</td>\n",
       "      <td>ua-CiDNNj30</td>\n",
       "      <td>2019-05-30T12:48:19Z</td>\n",
       "      <td>UC8butISFwT-Wl7EV0hUK0BQ</td>\n",
       "      <td>Learn Data Science Tutorial - Full Course for ...</td>\n",
       "      <td>Learn Data Science is this full tutorial cours...</td>\n",
       "      <td>freeCodeCamp.org</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>xYtx3nTrU44ji_QqH_c5vo7UymM</td>\n",
       "      <td>4OZip0cgOho</td>\n",
       "      <td>2020-05-08T13:00:03Z</td>\n",
       "      <td>UCiT9RITQ9PW6BhXK0y2jaeg</td>\n",
       "      <td>How I Would Learn Data Science (If I Had to St...</td>\n",
       "      <td>In this video, I talk about how I would learn ...</td>\n",
       "      <td>Ken Jee</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>FE_xTTsNKnXGVu9BTpKldUsYrCM</td>\n",
       "      <td>X3paOmcrTjQ</td>\n",
       "      <td>2018-12-04T14:30:01Z</td>\n",
       "      <td>UCsvqVGtbbyHaMoevxPAq9Fg</td>\n",
       "      <td>Data Science In 5 Minutes | Data Science For B...</td>\n",
       "      <td>This Data Science tutorial video will give you...</td>\n",
       "      <td>Simplilearn</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NsdHjZvCjLF_8mkwcbf5JuNbuBY</td>\n",
       "      <td>-ETQ97mXXF0</td>\n",
       "      <td>2019-08-18T08:30:02Z</td>\n",
       "      <td>UCkw4JCwteGrDHIsyIIKo4tQ</td>\n",
       "      <td>Data Science Full Course - Learn Data Science ...</td>\n",
       "      <td>Data Science Master Program: https://www.edure...</td>\n",
       "      <td>edureka!</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>gjuObVjaLkAKukHym389_YrHNpw</td>\n",
       "      <td>m5pwx3hgtzM</td>\n",
       "      <td>2019-12-16T18:46:58Z</td>\n",
       "      <td>UCiT9RITQ9PW6BhXK0y2jaeg</td>\n",
       "      <td>3 Reasons You Should NOT Become a Data Scientist</td>\n",
       "      <td>In this video I talk about 3 reasons that you ...</td>\n",
       "      <td>Ken Jee</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>bSpzDqJtfgC2QCpCKqTngxsbHfs</td>\n",
       "      <td>iJUzouXg5kY</td>\n",
       "      <td>2019-07-23T21:28:41Z</td>\n",
       "      <td>UCsT0YIqwnpJCM-mx7-gSA4Q</td>\n",
       "      <td>Demystifying Data Science | Mr.Asitang Mishra ...</td>\n",
       "      <td>In this talk Mr.Asitang Mishra relates his exp...</td>\n",
       "      <td>TEDx Talks</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>faKapvwZjBip4FT75gEOhXDXKtA</td>\n",
       "      <td>tQYCd8tg56U</td>\n",
       "      <td>2019-08-08T10:46:27Z</td>\n",
       "      <td>UCeObZv89Stb2xLtjLJ0De3Q</td>\n",
       "      <td>Big data, дополненная реальность и компьютерно...</td>\n",
       "      <td>В сегодняшнем выпуске у меня в гостях Data Sci...</td>\n",
       "      <td>АйТиБорода</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>rjNxmufFnhJR_gCJATtUojNzF4E</td>\n",
       "      <td>PXLVLS1vJHY</td>\n",
       "      <td>2020-01-15T16:15:01Z</td>\n",
       "      <td>UCEBpSZhI1X8WaP-kY_2LLcg</td>\n",
       "      <td>Is Data Science Really a Rising Career in 2020...</td>\n",
       "      <td>Download Our Free Data Science Career Guide:✅h...</td>\n",
       "      <td>365 Data Science</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>pWjhYaLQQ9_DeEZ3V13ZXKDWOB0</td>\n",
       "      <td>UXi8Ml2UoYk</td>\n",
       "      <td>2019-03-08T08:05:41Z</td>\n",
       "      <td>UCEBpSZhI1X8WaP-kY_2LLcg</td>\n",
       "      <td>What Do You Need to Become a Data Scientist in...</td>\n",
       "      <td>Download Our Free Data Science Career Guide:✅h...</td>\n",
       "      <td>365 Data Science</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>vzCPFIrrk_jd8IT2zVe5zCn-eTw</td>\n",
       "      <td>dYZJxhYjBE8</td>\n",
       "      <td>2018-12-20T17:27:44Z</td>\n",
       "      <td>UCqd6TofKNjqagInm5Waeu7w</td>\n",
       "      <td>Real Talk with Instagram Data Scientist</td>\n",
       "      <td>Talking data science with Mansha, a data scien...</td>\n",
       "      <td>Springboard</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>iXpgl0CDZW0VNTrLZznaLtcgPCU</td>\n",
       "      <td>tJPURyKJAR4</td>\n",
       "      <td>2020-02-12T17:07:09Z</td>\n",
       "      <td>UCEBpSZhI1X8WaP-kY_2LLcg</td>\n",
       "      <td>How to Get an Entry-Level Data Scientist Job?</td>\n",
       "      <td>Download Our Free Data Science Career Guide:✅h...</td>\n",
       "      <td>365 Data Science</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>oSzOwrWhTYDhSfdN8_WPNsRXNfs</td>\n",
       "      <td>5b9Z8toVaAU</td>\n",
       "      <td>2019-04-03T14:00:01Z</td>\n",
       "      <td>UCo7EHzKF2zDFWszw7Dg4mPw</td>\n",
       "      <td>O que é Data Science? #HipstersPontoTube</td>\n",
       "      <td>Python é o novo Excel? Para que serve o R, Pan...</td>\n",
       "      <td>Alura Cursos Online</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>KUbUDDjl7WYSOcN2lO8C1X0vHDw</td>\n",
       "      <td>-OcumqFbu0U</td>\n",
       "      <td>2017-07-06T11:57:13Z</td>\n",
       "      <td>UCV2uXPzJSCiOHwEdTiLHPiA</td>\n",
       "      <td>Сколько зарабатывают в Data Science и что это ...</td>\n",
       "      <td>Мы побывали на конференции Data Science UA, чт...</td>\n",
       "      <td>Take IT Easy</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>04lhJ4Z2r2YslVfGc-7O6-4Bj-U</td>\n",
       "      <td>DvGOq9WPsDg</td>\n",
       "      <td>2019-10-05T04:15:13Z</td>\n",
       "      <td>UChj0w0duKtp7SDd_X9CNptw</td>\n",
       "      <td>Data Scientist vs Data Analyst: What&amp;#39;s the...</td>\n",
       "      <td>The average salary in Data Science is $120000,...</td>\n",
       "      <td>Matt Tran</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>VEut2RetvLG_RTeZ3q5f4iuq8sw</td>\n",
       "      <td>HDVZKT7eKiU</td>\n",
       "      <td>2019-09-03T13:59:59Z</td>\n",
       "      <td>UCpNdaZYUS4OiIIBXLnggbCw</td>\n",
       "      <td>Como Empezar en DataScience</td>\n",
       "      <td>Como Empezar en Data Science Curso GRATIS de M...</td>\n",
       "      <td>DataScience ForBusiness</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>3Mh5fDtTIej5Av9gz69G0ufblXw</td>\n",
       "      <td>None</td>\n",
       "      <td>2014-08-06T21:12:46Z</td>\n",
       "      <td>UCzL_0nIe8B4-7ShhVPfJkgw</td>\n",
       "      <td>Data Science Dojo</td>\n",
       "      <td>At Data Science Dojo, we believe data science ...</td>\n",
       "      <td>Data Science Dojo</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>VYmlvGKQPNW5HbTdbmkCbakNdPI</td>\n",
       "      <td>jMvhFNGGT_0</td>\n",
       "      <td>2018-05-31T14:30:01Z</td>\n",
       "      <td>UC68KSmHePPePCjW4v57VPQg</td>\n",
       "      <td>How to Become a Data Scientist</td>\n",
       "      <td>How to Become a Data Scientist Do you want to ...</td>\n",
       "      <td>Python Programmer</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>MUFT8y5TRzqHJ7_Vqa0hjdtgb2g</td>\n",
       "      <td>2G-fS9Q6Z4M</td>\n",
       "      <td>2020-02-26T17:16:41Z</td>\n",
       "      <td>UCEBpSZhI1X8WaP-kY_2LLcg</td>\n",
       "      <td>Best Data Science Degrees to Get Hired in 2020</td>\n",
       "      <td>What are the best data science degrees to get ...</td>\n",
       "      <td>365 Data Science</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>NoLKjdTnVSTYCxutU1_DyIUKUwQ</td>\n",
       "      <td>CiqG7RNflLM</td>\n",
       "      <td>2020-01-30T16:57:25Z</td>\n",
       "      <td>UCHJZFCpwlXV7Sie1dV6pQLw</td>\n",
       "      <td>Data science: с чего начать?</td>\n",
       "      <td>Распродажа программ с гарантией трудоустройств...</td>\n",
       "      <td>Skillbox - Программирование</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>W8wGYt7_W9FGb5j2rdepkHp2n3E</td>\n",
       "      <td>mcy2dQ3v6R4</td>\n",
       "      <td>2019-01-31T15:04:35Z</td>\n",
       "      <td>UCwXJEwaFT5i3MKKMGdneYUA</td>\n",
       "      <td>Data Scientist vs Data Analyst: What&amp;#39;s the...</td>\n",
       "      <td>DATA SCIENTIST VS DATA ANALYST: WHAT'S THE DIF...</td>\n",
       "      <td>The Career Force</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>XWTnbpTQiLZ3XNpKWFdxyHu16kg</td>\n",
       "      <td>DEur2TOEN9c</td>\n",
       "      <td>2020-04-28T06:24:21Z</td>\n",
       "      <td>UCyZFmN_6IYWmpsVFqLVOASg</td>\n",
       "      <td>Data Science | ماهو علم البيانات؟ وماهي أهميته؟</td>\n",
       "      <td>ماهو علم البيانات؟ What is Data Science ماهي أ...</td>\n",
       "      <td>زاوية عثمان - مقاطع يومية في مجالات متنوعة</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>IiJ8TQbmdEGgDbDt6wJvAIa8I08</td>\n",
       "      <td>MpLHMKTolVw</td>\n",
       "      <td>2019-05-17T18:43:49Z</td>\n",
       "      <td>UCUMZ7gohGI9HcU9VNsr2FJQ</td>\n",
       "      <td>The NBA Data Scientist</td>\n",
       "      <td>With her PhD in math, Ivana Seric had expected...</td>\n",
       "      <td>Bloomberg QuickTake Originals</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>5DD2ktLOROErNl5DNV0atFrh5Uk</td>\n",
       "      <td>4kdaUIR_HBg</td>\n",
       "      <td>2020-04-29T01:30:02Z</td>\n",
       "      <td>UCtx9Shkn4vXxCjtUJ0tx3Og</td>\n",
       "      <td>เรียน Data Science ด้วยตัวเอง - Part I</td>\n",
       "      <td>ถ้าเราอยากเรียน Data Science ด้วยตัวเอง เราจะเ...</td>\n",
       "      <td>Check Ritbumroong</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>153P9Q0X8e-gvPQdmokMvV18W-c</td>\n",
       "      <td>None</td>\n",
       "      <td>2017-08-07T15:17:05Z</td>\n",
       "      <td>UCEBpSZhI1X8WaP-kY_2LLcg</td>\n",
       "      <td>365 Data Science</td>\n",
       "      <td>At 365 Data Science, we all come to work every...</td>\n",
       "      <td>365 Data Science</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0TbVxK3gcbQBkmb4utUVg8D24-g</td>\n",
       "      <td>Ck0ozfJV9-g</td>\n",
       "      <td>2018-07-26T16:00:04Z</td>\n",
       "      <td>UCV0qA-eDDICsRR9rPcnG7tw</td>\n",
       "      <td>A Day In The Life Of A Data Scientist</td>\n",
       "      <td>Resume Template and Cover letter I used for ap...</td>\n",
       "      <td>Joma Tech</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>BGOaVKgiU_RtObeEz189webWv0E</td>\n",
       "      <td>jgLWVHHUIYE</td>\n",
       "      <td>2019-09-01T07:00:19Z</td>\n",
       "      <td>UCKCUvcAFFR4UxI9XWVERSkA</td>\n",
       "      <td>Что такое Data Science (наука о данных) просты...</td>\n",
       "      <td>Записывайся на годовой курс по Data Science шк...</td>\n",
       "      <td>CODE BLOG - Программирование и C#</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>5eh7VwGZSVB6uucIINYvILHi5xI</td>\n",
       "      <td>gGce2JDbJAQ</td>\n",
       "      <td>2018-11-19T19:03:17Z</td>\n",
       "      <td>UCKFojzto0n4Ab3CRQRZ2zYA</td>\n",
       "      <td>075. Карьера в data science: типичные ошибки н...</td>\n",
       "      <td>Как найти работу в Data Science, если у тебя е...</td>\n",
       "      <td>Компьютерные науки</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>xHNjrgxvq8e9kBP_rVnqwy7oeqo</td>\n",
       "      <td>bRohws1bo1U</td>\n",
       "      <td>2020-05-24T14:45:00Z</td>\n",
       "      <td>UC8ofcOdHNINiPrBA9D59Vaw</td>\n",
       "      <td>Is Data Science The Right Choice For You?</td>\n",
       "      <td>Are you looking forward to become a Data Scien...</td>\n",
       "      <td>Bhavesh Bhatt</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>QofX4w2rzT2oEKrMpUtZyuwcSMA</td>\n",
       "      <td>n3vw0M5RrPU</td>\n",
       "      <td>2020-01-27T14:41:18Z</td>\n",
       "      <td>UCiT9RITQ9PW6BhXK0y2jaeg</td>\n",
       "      <td>How I Learned Data Science</td>\n",
       "      <td>In this video I talk about my journey to learn...</td>\n",
       "      <td>Ken Jee</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>4SjW_VTtaz_wbpEkIRzmDcj0b78</td>\n",
       "      <td>-PPDeqe1eTA</td>\n",
       "      <td>2018-09-20T18:30:41Z</td>\n",
       "      <td>UCIyfaiKil5oomY64XIRJEAA</td>\n",
       "      <td>Введение в Data Science и Machine Learning</td>\n",
       "      <td>Компьютерная Школа Hillel site: https://ithill...</td>\n",
       "      <td>Компьютерная школа Hillel</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Rf1ik91BywFizTdu_pFPjJ45RDo</td>\n",
       "      <td>OTTWeTd3Ekk</td>\n",
       "      <td>2017-05-15T13:00:02Z</td>\n",
       "      <td>UCFgK4tB6ybxG0-oJKlsKQlQ</td>\n",
       "      <td>ВСЕ, ЧТО ВЫ ХОТЕЛИ ЗНАТЬ: ПРОФЕССИЯ, ЗАРПЛАТА,...</td>\n",
       "      <td>Кто такие data scientists? Что они делают, как...</td>\n",
       "      <td>Masha oNashemoGlavnom</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>NNQlsqWiH880NQqEh55zxUfJkwY</td>\n",
       "      <td>nx489B78ZJ4</td>\n",
       "      <td>2020-04-26T21:00:21Z</td>\n",
       "      <td>UCITfscBBm40O9MgtqiQC00w</td>\n",
       "      <td>يعني إيه علم البيانات Data Science | #إسأل_مصطفى</td>\n",
       "      <td>تابعوا قناة م. مصطفى عثمان المختصة بتعلم علوم ...</td>\n",
       "      <td>Mustafa Othman - Digital Marketing</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>YYjBZL-bwtHNiRkb--jN31yaK2U</td>\n",
       "      <td>17S8wGuK7d0</td>\n",
       "      <td>2018-12-30T10:00:00Z</td>\n",
       "      <td>UCBgTLZHAaIdaErfsgmeObCw</td>\n",
       "      <td>Data Scientist - Il mio lavoro in Canada</td>\n",
       "      <td>datascientist #toronto #datascience #lavorarei...</td>\n",
       "      <td>eXtremegenerationIT</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>8I5ITbJuWtkTUU1J79je21dh-wI</td>\n",
       "      <td>NIlL15aq-eg</td>\n",
       "      <td>2020-07-03T11:43:21Z</td>\n",
       "      <td>UCObs0kLIrDjX2LLSybqNaEA</td>\n",
       "      <td>Journey Into The World Of Data Science and AI ...</td>\n",
       "      <td>\"The Journey into the world of Data Science an...</td>\n",
       "      <td>Great Learning</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>85F1xm6cWJju7n6YUG_yoVX5E2c</td>\n",
       "      <td>ah6-h6nAmcM</td>\n",
       "      <td>2020-06-29T13:00:12Z</td>\n",
       "      <td>UCh9nVJoWXmFb7sLApWGcLPQ</td>\n",
       "      <td>Is data science a hype? | Is data science a bu...</td>\n",
       "      <td>Realistic take on if a data science field or d...</td>\n",
       "      <td>codebasics</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>gfqrW_nKj-HpEuM0lWz9wYvU8OA</td>\n",
       "      <td>oXT8luCbuQ4</td>\n",
       "      <td>2018-02-08T10:34:38Z</td>\n",
       "      <td>UCi9DV7ai7a8-XgRt5iH9d7Q</td>\n",
       "      <td>ايه الفرق بين ال Big Data و ال Data Science و ...</td>\n",
       "      <td>مساء الخير ازيكم زي ما وعدتكم المرة اللي فاتت ...</td>\n",
       "      <td>Mohamed Elsherif</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>nVae6R5WMRiZCSpWSxsNPlGw2qI</td>\n",
       "      <td>I0FcAPcjwGA</td>\n",
       "      <td>2019-04-24T13:07:59Z</td>\n",
       "      <td>UCIIt69f5D44s2cdb9vXQNzA</td>\n",
       "      <td>Программист Python: Data-Science специалист</td>\n",
       "      <td>Продолжаем наше знакомство со спикерами конфер...</td>\n",
       "      <td>loftblog</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>0XYIHDXqE6aYOBigVG5irIJ4G_M</td>\n",
       "      <td>AqPquogHwq0</td>\n",
       "      <td>2020-07-03T16:00:04Z</td>\n",
       "      <td>UCiT9RITQ9PW6BhXK0y2jaeg</td>\n",
       "      <td>Where to Start Learning Data Science</td>\n",
       "      <td>In this video I talk about where exactly to st...</td>\n",
       "      <td>Ken Jee</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>_K_i9NQ0tzaD9cXxLzd6Wqh9sY8</td>\n",
       "      <td>de7ZUb1fH3s</td>\n",
       "      <td>2019-11-22T14:24:54Z</td>\n",
       "      <td>UCO3pT4ZI8x2RVqYWxxcrZsw</td>\n",
       "      <td>A Day in The Life of a Data Scientist 👨🏻‍💻| up...</td>\n",
       "      <td>Hi, I'm Prashant Kathuria, a data scientist, p...</td>\n",
       "      <td>upGrad</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           etag      videoId           publishedAt  \\\n",
       "0   6znlxNDEq3exijy84F6TBYh_Voc  xC-c7E5PK0Y  2018-06-23T01:51:50Z   \n",
       "1   BHk3ZOf85w_GJwg3WuR76i-q7nU  ua-CiDNNj30  2019-05-30T12:48:19Z   \n",
       "2   xYtx3nTrU44ji_QqH_c5vo7UymM  4OZip0cgOho  2020-05-08T13:00:03Z   \n",
       "3   FE_xTTsNKnXGVu9BTpKldUsYrCM  X3paOmcrTjQ  2018-12-04T14:30:01Z   \n",
       "4   NsdHjZvCjLF_8mkwcbf5JuNbuBY  -ETQ97mXXF0  2019-08-18T08:30:02Z   \n",
       "5   gjuObVjaLkAKukHym389_YrHNpw  m5pwx3hgtzM  2019-12-16T18:46:58Z   \n",
       "6   bSpzDqJtfgC2QCpCKqTngxsbHfs  iJUzouXg5kY  2019-07-23T21:28:41Z   \n",
       "7   faKapvwZjBip4FT75gEOhXDXKtA  tQYCd8tg56U  2019-08-08T10:46:27Z   \n",
       "8   rjNxmufFnhJR_gCJATtUojNzF4E  PXLVLS1vJHY  2020-01-15T16:15:01Z   \n",
       "9   pWjhYaLQQ9_DeEZ3V13ZXKDWOB0  UXi8Ml2UoYk  2019-03-08T08:05:41Z   \n",
       "10  vzCPFIrrk_jd8IT2zVe5zCn-eTw  dYZJxhYjBE8  2018-12-20T17:27:44Z   \n",
       "11  iXpgl0CDZW0VNTrLZznaLtcgPCU  tJPURyKJAR4  2020-02-12T17:07:09Z   \n",
       "12  oSzOwrWhTYDhSfdN8_WPNsRXNfs  5b9Z8toVaAU  2019-04-03T14:00:01Z   \n",
       "13  KUbUDDjl7WYSOcN2lO8C1X0vHDw  -OcumqFbu0U  2017-07-06T11:57:13Z   \n",
       "14  04lhJ4Z2r2YslVfGc-7O6-4Bj-U  DvGOq9WPsDg  2019-10-05T04:15:13Z   \n",
       "15  VEut2RetvLG_RTeZ3q5f4iuq8sw  HDVZKT7eKiU  2019-09-03T13:59:59Z   \n",
       "16  3Mh5fDtTIej5Av9gz69G0ufblXw         None  2014-08-06T21:12:46Z   \n",
       "17  VYmlvGKQPNW5HbTdbmkCbakNdPI  jMvhFNGGT_0  2018-05-31T14:30:01Z   \n",
       "18  MUFT8y5TRzqHJ7_Vqa0hjdtgb2g  2G-fS9Q6Z4M  2020-02-26T17:16:41Z   \n",
       "19  NoLKjdTnVSTYCxutU1_DyIUKUwQ  CiqG7RNflLM  2020-01-30T16:57:25Z   \n",
       "20  W8wGYt7_W9FGb5j2rdepkHp2n3E  mcy2dQ3v6R4  2019-01-31T15:04:35Z   \n",
       "21  XWTnbpTQiLZ3XNpKWFdxyHu16kg  DEur2TOEN9c  2020-04-28T06:24:21Z   \n",
       "22  IiJ8TQbmdEGgDbDt6wJvAIa8I08  MpLHMKTolVw  2019-05-17T18:43:49Z   \n",
       "23  5DD2ktLOROErNl5DNV0atFrh5Uk  4kdaUIR_HBg  2020-04-29T01:30:02Z   \n",
       "24  153P9Q0X8e-gvPQdmokMvV18W-c         None  2017-08-07T15:17:05Z   \n",
       "25  0TbVxK3gcbQBkmb4utUVg8D24-g  Ck0ozfJV9-g  2018-07-26T16:00:04Z   \n",
       "26  BGOaVKgiU_RtObeEz189webWv0E  jgLWVHHUIYE  2019-09-01T07:00:19Z   \n",
       "27  5eh7VwGZSVB6uucIINYvILHi5xI  gGce2JDbJAQ  2018-11-19T19:03:17Z   \n",
       "28  xHNjrgxvq8e9kBP_rVnqwy7oeqo  bRohws1bo1U  2020-05-24T14:45:00Z   \n",
       "29  QofX4w2rzT2oEKrMpUtZyuwcSMA  n3vw0M5RrPU  2020-01-27T14:41:18Z   \n",
       "30  4SjW_VTtaz_wbpEkIRzmDcj0b78  -PPDeqe1eTA  2018-09-20T18:30:41Z   \n",
       "31  Rf1ik91BywFizTdu_pFPjJ45RDo  OTTWeTd3Ekk  2017-05-15T13:00:02Z   \n",
       "32  NNQlsqWiH880NQqEh55zxUfJkwY  nx489B78ZJ4  2020-04-26T21:00:21Z   \n",
       "33  YYjBZL-bwtHNiRkb--jN31yaK2U  17S8wGuK7d0  2018-12-30T10:00:00Z   \n",
       "34  8I5ITbJuWtkTUU1J79je21dh-wI  NIlL15aq-eg  2020-07-03T11:43:21Z   \n",
       "35  85F1xm6cWJju7n6YUG_yoVX5E2c  ah6-h6nAmcM  2020-06-29T13:00:12Z   \n",
       "36  gfqrW_nKj-HpEuM0lWz9wYvU8OA  oXT8luCbuQ4  2018-02-08T10:34:38Z   \n",
       "37  nVae6R5WMRiZCSpWSxsNPlGw2qI  I0FcAPcjwGA  2019-04-24T13:07:59Z   \n",
       "38  0XYIHDXqE6aYOBigVG5irIJ4G_M  AqPquogHwq0  2020-07-03T16:00:04Z   \n",
       "39  _K_i9NQ0tzaD9cXxLzd6Wqh9sY8  de7ZUb1fH3s  2019-11-22T14:24:54Z   \n",
       "\n",
       "                   channelId  \\\n",
       "0   UCV0qA-eDDICsRR9rPcnG7tw   \n",
       "1   UC8butISFwT-Wl7EV0hUK0BQ   \n",
       "2   UCiT9RITQ9PW6BhXK0y2jaeg   \n",
       "3   UCsvqVGtbbyHaMoevxPAq9Fg   \n",
       "4   UCkw4JCwteGrDHIsyIIKo4tQ   \n",
       "5   UCiT9RITQ9PW6BhXK0y2jaeg   \n",
       "6   UCsT0YIqwnpJCM-mx7-gSA4Q   \n",
       "7   UCeObZv89Stb2xLtjLJ0De3Q   \n",
       "8   UCEBpSZhI1X8WaP-kY_2LLcg   \n",
       "9   UCEBpSZhI1X8WaP-kY_2LLcg   \n",
       "10  UCqd6TofKNjqagInm5Waeu7w   \n",
       "11  UCEBpSZhI1X8WaP-kY_2LLcg   \n",
       "12  UCo7EHzKF2zDFWszw7Dg4mPw   \n",
       "13  UCV2uXPzJSCiOHwEdTiLHPiA   \n",
       "14  UChj0w0duKtp7SDd_X9CNptw   \n",
       "15  UCpNdaZYUS4OiIIBXLnggbCw   \n",
       "16  UCzL_0nIe8B4-7ShhVPfJkgw   \n",
       "17  UC68KSmHePPePCjW4v57VPQg   \n",
       "18  UCEBpSZhI1X8WaP-kY_2LLcg   \n",
       "19  UCHJZFCpwlXV7Sie1dV6pQLw   \n",
       "20  UCwXJEwaFT5i3MKKMGdneYUA   \n",
       "21  UCyZFmN_6IYWmpsVFqLVOASg   \n",
       "22  UCUMZ7gohGI9HcU9VNsr2FJQ   \n",
       "23  UCtx9Shkn4vXxCjtUJ0tx3Og   \n",
       "24  UCEBpSZhI1X8WaP-kY_2LLcg   \n",
       "25  UCV0qA-eDDICsRR9rPcnG7tw   \n",
       "26  UCKCUvcAFFR4UxI9XWVERSkA   \n",
       "27  UCKFojzto0n4Ab3CRQRZ2zYA   \n",
       "28  UC8ofcOdHNINiPrBA9D59Vaw   \n",
       "29  UCiT9RITQ9PW6BhXK0y2jaeg   \n",
       "30  UCIyfaiKil5oomY64XIRJEAA   \n",
       "31  UCFgK4tB6ybxG0-oJKlsKQlQ   \n",
       "32  UCITfscBBm40O9MgtqiQC00w   \n",
       "33  UCBgTLZHAaIdaErfsgmeObCw   \n",
       "34  UCObs0kLIrDjX2LLSybqNaEA   \n",
       "35  UCh9nVJoWXmFb7sLApWGcLPQ   \n",
       "36  UCi9DV7ai7a8-XgRt5iH9d7Q   \n",
       "37  UCIIt69f5D44s2cdb9vXQNzA   \n",
       "38  UCiT9RITQ9PW6BhXK0y2jaeg   \n",
       "39  UCO3pT4ZI8x2RVqYWxxcrZsw   \n",
       "\n",
       "                                                title  \\\n",
       "0   What REALLY is Data Science? Told by a Data Sc...   \n",
       "1   Learn Data Science Tutorial - Full Course for ...   \n",
       "2   How I Would Learn Data Science (If I Had to St...   \n",
       "3   Data Science In 5 Minutes | Data Science For B...   \n",
       "4   Data Science Full Course - Learn Data Science ...   \n",
       "5    3 Reasons You Should NOT Become a Data Scientist   \n",
       "6   Demystifying Data Science | Mr.Asitang Mishra ...   \n",
       "7   Big data, дополненная реальность и компьютерно...   \n",
       "8   Is Data Science Really a Rising Career in 2020...   \n",
       "9   What Do You Need to Become a Data Scientist in...   \n",
       "10            Real Talk with Instagram Data Scientist   \n",
       "11      How to Get an Entry-Level Data Scientist Job?   \n",
       "12           O que é Data Science? #HipstersPontoTube   \n",
       "13  Сколько зарабатывают в Data Science и что это ...   \n",
       "14  Data Scientist vs Data Analyst: What&#39;s the...   \n",
       "15                        Como Empezar en DataScience   \n",
       "16                                  Data Science Dojo   \n",
       "17                     How to Become a Data Scientist   \n",
       "18     Best Data Science Degrees to Get Hired in 2020   \n",
       "19                       Data science: с чего начать?   \n",
       "20  Data Scientist vs Data Analyst: What&#39;s the...   \n",
       "21    Data Science | ماهو علم البيانات؟ وماهي أهميته؟   \n",
       "22                             The NBA Data Scientist   \n",
       "23             เรียน Data Science ด้วยตัวเอง - Part I   \n",
       "24                                   365 Data Science   \n",
       "25              A Day In The Life Of A Data Scientist   \n",
       "26  Что такое Data Science (наука о данных) просты...   \n",
       "27  075. Карьера в data science: типичные ошибки н...   \n",
       "28          Is Data Science The Right Choice For You?   \n",
       "29                         How I Learned Data Science   \n",
       "30         Введение в Data Science и Machine Learning   \n",
       "31  ВСЕ, ЧТО ВЫ ХОТЕЛИ ЗНАТЬ: ПРОФЕССИЯ, ЗАРПЛАТА,...   \n",
       "32   يعني إيه علم البيانات Data Science | #إسأل_مصطفى   \n",
       "33           Data Scientist - Il mio lavoro in Canada   \n",
       "34  Journey Into The World Of Data Science and AI ...   \n",
       "35  Is data science a hype? | Is data science a bu...   \n",
       "36  ايه الفرق بين ال Big Data و ال Data Science و ...   \n",
       "37        Программист Python: Data-Science специалист   \n",
       "38               Where to Start Learning Data Science   \n",
       "39  A Day in The Life of a Data Scientist 👨🏻‍💻| up...   \n",
       "\n",
       "                                          description  \\\n",
       "0   Resume Template and Cover letter I used for ap...   \n",
       "1   Learn Data Science is this full tutorial cours...   \n",
       "2   In this video, I talk about how I would learn ...   \n",
       "3   This Data Science tutorial video will give you...   \n",
       "4   Data Science Master Program: https://www.edure...   \n",
       "5   In this video I talk about 3 reasons that you ...   \n",
       "6   In this talk Mr.Asitang Mishra relates his exp...   \n",
       "7   В сегодняшнем выпуске у меня в гостях Data Sci...   \n",
       "8   Download Our Free Data Science Career Guide:✅h...   \n",
       "9   Download Our Free Data Science Career Guide:✅h...   \n",
       "10  Talking data science with Mansha, a data scien...   \n",
       "11  Download Our Free Data Science Career Guide:✅h...   \n",
       "12  Python é o novo Excel? Para que serve o R, Pan...   \n",
       "13  Мы побывали на конференции Data Science UA, чт...   \n",
       "14  The average salary in Data Science is $120000,...   \n",
       "15  Como Empezar en Data Science Curso GRATIS de M...   \n",
       "16  At Data Science Dojo, we believe data science ...   \n",
       "17  How to Become a Data Scientist Do you want to ...   \n",
       "18  What are the best data science degrees to get ...   \n",
       "19  Распродажа программ с гарантией трудоустройств...   \n",
       "20  DATA SCIENTIST VS DATA ANALYST: WHAT'S THE DIF...   \n",
       "21  ماهو علم البيانات؟ What is Data Science ماهي أ...   \n",
       "22  With her PhD in math, Ivana Seric had expected...   \n",
       "23  ถ้าเราอยากเรียน Data Science ด้วยตัวเอง เราจะเ...   \n",
       "24  At 365 Data Science, we all come to work every...   \n",
       "25  Resume Template and Cover letter I used for ap...   \n",
       "26  Записывайся на годовой курс по Data Science шк...   \n",
       "27  Как найти работу в Data Science, если у тебя е...   \n",
       "28  Are you looking forward to become a Data Scien...   \n",
       "29  In this video I talk about my journey to learn...   \n",
       "30  Компьютерная Школа Hillel site: https://ithill...   \n",
       "31  Кто такие data scientists? Что они делают, как...   \n",
       "32  تابعوا قناة م. مصطفى عثمان المختصة بتعلم علوم ...   \n",
       "33  datascientist #toronto #datascience #lavorarei...   \n",
       "34  \"The Journey into the world of Data Science an...   \n",
       "35  Realistic take on if a data science field or d...   \n",
       "36  مساء الخير ازيكم زي ما وعدتكم المرة اللي فاتت ...   \n",
       "37  Продолжаем наше знакомство со спикерами конфер...   \n",
       "38  In this video I talk about where exactly to st...   \n",
       "39  Hi, I'm Prashant Kathuria, a data scientist, p...   \n",
       "\n",
       "                                  channelTitle publishTime  \n",
       "0                                    Joma Tech        None  \n",
       "1                             freeCodeCamp.org        None  \n",
       "2                                      Ken Jee        None  \n",
       "3                                  Simplilearn        None  \n",
       "4                                     edureka!        None  \n",
       "5                                      Ken Jee        None  \n",
       "6                                   TEDx Talks        None  \n",
       "7                                   АйТиБорода        None  \n",
       "8                             365 Data Science        None  \n",
       "9                             365 Data Science        None  \n",
       "10                                 Springboard        None  \n",
       "11                            365 Data Science        None  \n",
       "12                         Alura Cursos Online        None  \n",
       "13                                Take IT Easy        None  \n",
       "14                                   Matt Tran        None  \n",
       "15                     DataScience ForBusiness        None  \n",
       "16                           Data Science Dojo        None  \n",
       "17                           Python Programmer        None  \n",
       "18                            365 Data Science        None  \n",
       "19                 Skillbox - Программирование        None  \n",
       "20                            The Career Force        None  \n",
       "21  زاوية عثمان - مقاطع يومية في مجالات متنوعة        None  \n",
       "22               Bloomberg QuickTake Originals        None  \n",
       "23                           Check Ritbumroong        None  \n",
       "24                            365 Data Science        None  \n",
       "25                                   Joma Tech        None  \n",
       "26           CODE BLOG - Программирование и C#        None  \n",
       "27                          Компьютерные науки        None  \n",
       "28                               Bhavesh Bhatt        None  \n",
       "29                                     Ken Jee        None  \n",
       "30                   Компьютерная школа Hillel        None  \n",
       "31                       Masha oNashemoGlavnom        None  \n",
       "32          Mustafa Othman - Digital Marketing        None  \n",
       "33                         eXtremegenerationIT        None  \n",
       "34                              Great Learning        None  \n",
       "35                                  codebasics        None  \n",
       "36                            Mohamed Elsherif        None  \n",
       "37                                    loftblog        None  \n",
       "38                                     Ken Jee        None  \n",
       "39                                      upGrad        None  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = await dc.query(\"videos\", _q=\"Data Science\", part=\"snippet\", type=\"videos\", _count=40)\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# That's all for now. \n",
    "If you are interested in writing your own configuration file or modify an existing one, refer to the [Configuration Files](https://github.com/sfu-db/DataConnectorConfigs>)."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}