010 scrapování youtube.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "c996785b",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import requests\n",
    "import pandas as pd\n",
    "from bs4 import BeautifulSoup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "0fa827db",
   "metadata": {},
   "outputs": [],
   "source": [
    "youtube = pd.read_csv(os.path.join(\"data\",\"youtube_linky.csv\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "cb44cdc9",
   "metadata": {},
   "outputs": [],
   "source": [
    "youtube = youtube.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "252d8df2",
   "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>Unnamed: 0</th>\n",
       "      <th>interpret_hlavni</th>\n",
       "      <th>track</th>\n",
       "      <th>youtube</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1984</th>\n",
       "      <td>79293</td>\n",
       "      <td>Corinne Bailey Rae</td>\n",
       "      <td>Put Your Records On</td>\n",
       "      <td>https://www.youtube.com/watch?v=oWQl00LWEwE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2558</th>\n",
       "      <td>85748</td>\n",
       "      <td>Wham!</td>\n",
       "      <td>Last Christmas</td>\n",
       "      <td>https://www.youtube.com/watch?v=E8gmARGvPlI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3417</th>\n",
       "      <td>104104</td>\n",
       "      <td>Adele</td>\n",
       "      <td>Set Fire To The Rain</td>\n",
       "      <td>http://www.youtube.com/watch?v=FlsBObg-1BQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3469</th>\n",
       "      <td>105301</td>\n",
       "      <td>Václav Neckář</td>\n",
       "      <td>Půlnoční</td>\n",
       "      <td>https://www.youtube.com/watch?v=45mbYID0ec4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3514</th>\n",
       "      <td>106048</td>\n",
       "      <td>Janek Ledecký</td>\n",
       "      <td>Sliby se maj plnit o Vánocích</td>\n",
       "      <td>https://www.youtube.com/watch?v=YLbgajaQ_U8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13839</th>\n",
       "      <td>444919</td>\n",
       "      <td>Momo</td>\n",
       "      <td>Nehaj tak</td>\n",
       "      <td>https://www.youtube.com/playlist?list=OLAK5uy_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13842</th>\n",
       "      <td>446424</td>\n",
       "      <td>Shimmi</td>\n",
       "      <td>BERLIN FREESTYLE</td>\n",
       "      <td>https://www.youtube.com/watch?v=Z7Ant_nWzHg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13845</th>\n",
       "      <td>446525</td>\n",
       "      <td>Saul</td>\n",
       "      <td>Chaos, teraz</td>\n",
       "      <td>https://www.youtube.com/playlist?list=OLAK5uy_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13846</th>\n",
       "      <td>446571</td>\n",
       "      <td>Radikal Chef</td>\n",
       "      <td>Marocchino</td>\n",
       "      <td>https://www.youtube.com/playlist?list=OLAK5uy_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13847</th>\n",
       "      <td>446574</td>\n",
       "      <td>Radikal Chef</td>\n",
       "      <td>Deja Vu</td>\n",
       "      <td>https://www.youtube.com/playlist?list=OLAK5uy_...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4235 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0    interpret_hlavni                          track  \\\n",
       "1984        79293  Corinne Bailey Rae            Put Your Records On   \n",
       "2558        85748               Wham!                 Last Christmas   \n",
       "3417       104104               Adele           Set Fire To The Rain   \n",
       "3469       105301       Václav Neckář                       Půlnoční   \n",
       "3514       106048       Janek Ledecký  Sliby se maj plnit o Vánocích   \n",
       "...           ...                 ...                            ...   \n",
       "13839      444919                Momo                      Nehaj tak   \n",
       "13842      446424              Shimmi               BERLIN FREESTYLE   \n",
       "13845      446525                Saul                   Chaos, teraz   \n",
       "13846      446571        Radikal Chef                     Marocchino   \n",
       "13847      446574        Radikal Chef                        Deja Vu   \n",
       "\n",
       "                                                 youtube  \n",
       "1984         https://www.youtube.com/watch?v=oWQl00LWEwE  \n",
       "2558         https://www.youtube.com/watch?v=E8gmARGvPlI  \n",
       "3417          http://www.youtube.com/watch?v=FlsBObg-1BQ  \n",
       "3469         https://www.youtube.com/watch?v=45mbYID0ec4  \n",
       "3514         https://www.youtube.com/watch?v=YLbgajaQ_U8  \n",
       "...                                                  ...  \n",
       "13839  https://www.youtube.com/playlist?list=OLAK5uy_...  \n",
       "13842        https://www.youtube.com/watch?v=Z7Ant_nWzHg  \n",
       "13845  https://www.youtube.com/playlist?list=OLAK5uy_...  \n",
       "13846  https://www.youtube.com/playlist?list=OLAK5uy_...  \n",
       "13847  https://www.youtube.com/playlist?list=OLAK5uy_...  \n",
       "\n",
       "[4235 rows x 4 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "youtube"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "46e99801",
   "metadata": {},
   "outputs": [],
   "source": [
    "def delka_videa(url):\n",
    "    # lol to je hnusná funkce, ale spěchal jsem\n",
    "    if \"watch\" in url:\n",
    "        \n",
    "        url = url.split(\"&\")[0]\n",
    "        \n",
    "        if url[0:3] == \"www\":\n",
    "            url = \"https://\" + url\n",
    "        if url[0:5] == \"http:\":\n",
    "            url = url.replace(\"http:\",\"https:\")\n",
    "        \n",
    "        try:\n",
    "            response = requests.get(url)\n",
    "            soup = BeautifulSoup(response.text, 'html.parser')\n",
    "            soup = str(soup)\n",
    "            if \"chapterRenderer\" in soup:\n",
    "                return None\n",
    "            if \"approxDurationMs\" in soup:\n",
    "                return int(soup.split(\"approxDurationMs\")[1].split(\"\\\"\")[2]) / 1000\n",
    "            else:\n",
    "                print(url)\n",
    "                return None\n",
    "        except:\n",
    "            print(url)\n",
    "            return None\n",
    "    else:\n",
    "        return None"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "868f8a81",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://www.youtube.com/watch?v=FlsBObg-1BQ\n",
      "https://www.youtube.com/watch?v=lJqbaGloVxg\n",
      "https://www.youtube.com/watch?v=pX1eKLsmDmw\n",
      "https://www.youtube.com/watch?v=c_CWL8gNQTg\n",
      "https://www.youtube.com/watch?v=yV3os0MoXIo\n",
      "https://www.youtube.com/watch?v=6MH9qWemtPo\n",
      "https://www.youtube.com/watch?v=MgTw_aYbIpQ\n",
      "https://www.youtube.com/watch?v=rCUosA2boyo\n",
      "https://www.youtube.com/watch?v=lQORzS65b_o\n",
      "https://www.youtube.com/watch?v=r_qITmZjzPU\n",
      "https://www.youtube.com/watch?v=RIXRe0l7QF4\n",
      "https://www.youtube.com/watch?v=XKmZ1SqzRwY\n",
      "https://www.youtube.com/watch?v=-P6hZzospWo\n",
      "https://www.youtube.com/watch?v=hXI9uqh-hNA\n",
      "https://www.youtube.com/watch?v=pYu8ZZYWneQ\n",
      "https://www.youtube.com/watch?v=SNkq-9iA938\n",
      "https://www.youtube.com/watch?v=hMbr3KQHpnU\n",
      "https://www.youtube.com/watch?v=XqFJ8_u-M38\n",
      "https://www.youtube.com/watch?v=9ycBvqm9LFQ\n",
      "https://www.youtube.com/watch?v=DU4Rph1JTCE\n",
      "https://www.youtube.com/watch?v=84rxoIqVJo0\n",
      "https://www.youtube.com/watch?v=gXCO5iGDmvs\n",
      "https://www.youtube.com/watch?v=p_DVZucfa8U\n",
      "https://www.youtube.com/watch?v=Fggfo6R5YbY\n",
      "https://www.youtube.com/watch?v=14H8OzTzne4\n",
      "https://www.youtube.com/watch?v=GgkSvnYGsEo\n",
      "https://www.youtube.com/watch?v=ixYFypXiEig\n",
      "https://www.youtube.com/watch?v=qgfv5x4vnjY\n",
      "https://www.youtube.com/watch?v=N4ePSLnMzHg\n",
      "https://www.youtube.com/watch?v=50jzKk6V070\n",
      "https://www.youtube.com/watch?v=LcJuYuVeF4E\n",
      "https://www.youtube.com/watch?v=YKS1xjqEv8o\n",
      "https://www.youtube.com/watch?v=wtfrLr0BXzI\n",
      "https://www.youtube.com/watch?v=Zf5_R95dLmU\n",
      "https://www.youtube.com/watch?v=YYc9NPiVw7c\n",
      "https://www.youtube.com/watch?v=ms-jyuQtca4\n",
      "https://www.youtube.com/watch?v=5gk_hf_AtA0\n",
      "https://www.youtube.com/watch?v=vxeontdHObU\n",
      "https://www.youtube.com/watch?v=3hglNNwZJw8\n",
      "https://www.youtube.com/watch?v=hq935KorD88\n",
      "https://www.youtube.com/watch?v=c6oyMDucUyo\n",
      "https://www.youtube.com/watch?v=Yy13uuGDRME\n",
      "https://www.youtube.com/watch?v=6vgs7gIeMis\n",
      "https://www.youtube.com/watch?v=0DaInuaZz08\n",
      "https://www.youtube.com/watch?v=LI5joq2KFEM\n",
      "https://www.youtube.com/watch?v=t3JYwhodL5w\n",
      "https://www.youtube.com/watch?v=PEC92DcDMcw\n",
      "https://www.youtube.com/watch?v=FAkAefNhsus\n",
      "https://www.youtube.com/watch?v=KNxICn6xurw\n",
      "https://www.youtube.com/watch?v=9X9weuJMj38\n",
      "https://www.youtube.com/watch?v=FUgmQ_UVoHY\n",
      "https://www.youtube.com/watch?v=6vgs7gIeMis\n",
      "https://www.youtube.com/watch?v=FYI65DwKk1c\n",
      "https://www.youtube.com/watch?v=2ebfSItB0oM\n",
      "https://www.youtube.com/watch?v=tjRobxs6z24\n",
      "https://www.youtube.com/watch?v=Mu3Ds45og4g\n",
      "https://www.youtube.com/watch?v=Hy6-0Pkoklc\n",
      "https://www.youtube.com/watch?v=bc7LROe0fVQ\n",
      "https://www.youtube.com/watch?v=QYXtPCgcmYY\n",
      "https://www.youtube.com/watch?v=zpo6uJB1Gyk\n",
      "https://www.youtube.com/watch?v=DjWcwMsm-3M\n",
      "https://www.youtube.com/watch?v=3e0ZX7y-uaM\n",
      "https://www.youtube.com/watch?v=6lHzySwhUac\n",
      "https://www.youtube.com/watch?v=1NYTei70aL4\n",
      "https://www.youtube.com/watch?v=pUcREla9gzY\n",
      "https://www.youtube.com/watch?v=ykTs-0IpsL0\n",
      "https://www.youtube.com/watch?v=QKqP36nymV4\n",
      "https://www.youtube.com/watch?v=5QQ0ebVrLQw\n",
      "https://www.youtube.com/watch?v=4PYQ6G7BTEs\n",
      "https://www.youtube.com/watch?v=prLCSRP0aCc\n",
      "https://www.youtube.com/watch?v=FNHWu4uEa_c\n",
      "https://www.youtube.com/watch?v=37Z_bIqIWpg\n",
      "https://www.youtube.com/watch?v=LBcVI9T5CQQ\n",
      "https://www.youtube.com/watch?v=KrJVzqP7Kgw\n",
      "https://www.youtube.com/watch?v=lFIIMEe2Ht0\n",
      "https://www.youtube.com/watch?v=2YUA7FxKuEA\n",
      "https://www.youtube.com/watch?v=AxU9jvAa_Xg\n",
      "https://www.youtube.com/watch?v=3MfqsR2hEoY\n",
      "https://www.youtube.com/watch?v=hIjNqd8_Fag\n",
      "https://www.youtube.com/watch?v=chhhgA8mofI\n",
      "https://www.youtube.com/watch?v=NYhxaZXXwsg\n",
      "https://www.youtube.com/watch?v=MGaEf0CZfbQ\n",
      "https://www.youtube.com/watch?v=O8mSwKoKC_A\n",
      "https://www.youtube.com/watch?v=eFbdKVeNXmM\n",
      "https://www.youtube.com/watch?v=o032WQMzUcI\n",
      "https://www.youtube.com/watch?v=RPbrgabOZkg\n",
      "https://www.youtube.com/watch?v=TXRCGKFCH-0\n",
      "https://www.youtube.com/watch?v=ug0A0uuSpDE\n",
      "https://www.youtube.com/watch?v=5YDpc87Jx_s\n",
      "https://www.youtube.com/watch?v=H_IfNMP50lw\n",
      "https://www.youtube.com/watch?v=oZNHKNPqsO8\n",
      "https://www.youtube.com/watch?v=3HiCFeotRLU\n",
      "https://www.youtube.com/watch?v=Sw1AnHwqacY\n",
      "https://www.youtube.com/watch?v=WFQqAZBOwfQ\n",
      "https://www.youtube.com/watch?v=mPIm_ZZ0yVw\n",
      "https://www.youtube.com/watch?v=826kv4IQSd4\n",
      "https://www.youtube.com/watch?v=vLR-7njt5TA\n",
      "https://www.youtube.com/watch?v=4NC9ILB-VD8\n",
      "https://www.youtube.com/watch?v=A7xzXDStQnk\n",
      "https://www.youtube.com/watch?v=vT4-ApOUpMc\n",
      "https://www.youtube.com/watch?v=dTXEWqQ8fzM\n",
      "https://www.youtube.com/watch?v=e6SXD3CALWo\n",
      "https://www.youtube.com/watch?v=x45lYe6ahl8\n",
      "https://www.youtube.com/watch?v=d2UZlwTDGbY\n",
      "https://www.youtube.com/watch?v=f9Gi_5n_9u0\n",
      "https://www.youtube.com/watch?v=orLSrcURz5k\n",
      "https://www.youtube.com/watch?v=1Z4cPBpJiWc\n",
      "https://www.youtube.com/watch?v=QjHKdww2UMg\n",
      "https://www.youtube.com/watch?v=zB7knJ_aALU\n",
      "https://www.youtube.com/watch?v=jOQ8EZbAinA\n",
      "https://www.youtube.com/watch?v=anl9udH6Jbg\n",
      "https://www.youtube.com/watch?v=HUv9usu4HRA\n",
      "https://www.youtube.com/watch?v=9lYVzTpiM6Q\n",
      "https://www.youtube.com/watch?v=kdCT4HDOuHo\n",
      "https://www.youtube.com/watch?v=mwFo8lOnPy8\n",
      "https://www.youtube.com/watch?v=-W8UizbMJbc\n",
      "https://www.youtube.com/watch?v=-_3mNCaJgNM\n",
      "https://www.youtube.com/watch?v=U10ftE4XQvo\n",
      "https://www.youtube.com/watch?v=4rUrYN4cnGs\n",
      "https://www.youtube.com/watch?v=yI9pirG_Lx0\n",
      "https://www.youtube.com/watch?v=qF_pm7mLqXs\n",
      "https://www.youtube.com/watch?v=QWE_M0CX9So\n",
      "https://www.youtube.com/watch?v=wxJE9GNv0EE\n",
      "https://www.youtube.com/watch?v=WcGAH9-JhV8\n",
      "https://www.youtube.com/watch?v=8GRH0_cZUEs\n",
      "https://www.youtube.com/watch?v=5QNoNbcrNlM\n",
      "https://www.youtube.com/watch?v=STzVhyLEf44\n",
      "https://www.youtube.com/watch?v=QG8Mkmy_FaE\n",
      "https://www.youtube.com/watch?v=scfP6Zx-fVQ\n",
      "https://www.youtube.com/watch?v=CRV51e753f8\n",
      "https://www.youtube.com/watch?v=f3lvbeASeUo\n",
      "https://www.youtube.com/watch?v=NrEVYQ4zQAA\n",
      "https://www.youtube.com/watch?v=hwl1BH1KHd4\n",
      "https://www.youtube.com/watch?v=SK05mIPMsF0\n",
      "https://www.youtube.com/watch?v=pnDpXLQ16L8\n",
      "https://www.youtube.com/watch?v=ZDyDpdFZHBo\n",
      "https://www.youtube.com/watch?v=sOfzbYW55B8\n",
      "https://www.youtube.com/watch?v=qGOTVf1eLvQ\n",
      "https://www.youtube.com/watch?v=jmIoAzVBxr0\n",
      "https://www.youtube.com/watch?v=Dzb8QnxPzEI\n",
      "https://www.youtube.com/watch?v=Ta2l8H7AK8M\n",
      "https://www.youtube.com/watch?v=Ta2l8H7AK8M\n",
      "https://www.youtube.com/watch?v=P4T9AYZX7-k\n",
      "https://www.youtube.com/watch?v=yfgXUA3tnAw\n",
      "https://www.youtube.com/watch?v=-8Ipi_YUbik\n",
      "https://www.youtube.com/watch?v=4fktjAlczv8\n",
      "https://www.youtube.com/watch?v=1mv1jz6lp90\n",
      "https://www.youtube.com/watch?v=EIFJB4GAF6o\n",
      "https://www.youtube.com/watch?v=35AIgZ8myOQ\n",
      "https://www.youtube.com/watch?v=rBe6fFejsPU\n",
      "https://www.youtube.com/watch?v=M5S6szOrUYQ\n",
      "https://www.youtube.com/watch?v=mfl6BCn1kYQ\n",
      "https://www.youtube.com/watch?v=5yogzdba170\n",
      "https://www.youtube.com/watch?v=iUMOQct042g\n",
      "https://www.youtube.com/watch?v=6FLAfgF2PHU\n",
      "https://www.youtube.com/watch?v=at061CLqqQA\n",
      "https://www.youtube.com/watch?v=gddkja4paLM\n",
      "https://www.youtube.com/watch?v=_V_xEw4WNHk\n",
      "https://www.youtube.com/watch?v=sWYm98TSTrk\n",
      "https://www.youtube.com/watch?v=ITZUukagkMc\n",
      "https://www.youtube.com/watch?v=iatpCYNfbHg\n",
      "https://www.youtube.com/watch?v=G2CVd2Yqnfg\n",
      "https://www.youtube.com/watch?v=bNppHOYIgRE\n",
      "https://www.youtube.com/watch?v=aqgZDhhksa4\n",
      "https://www.youtube.com/watch?v=1ba82Btig3g\n",
      "https://www.youtube.com/watch?v=CikSkFUDIlI\n",
      "https://www.youtube.com/watch?v=vIjGqphFVkU\n",
      "https://www.youtube.com/watch?v=oh53RI5Mk3U\n",
      "https://www.youtube.com/watch?v=mEfkTjmcyLw\n",
      "https://www.youtube.com/watch?v=_UnkNCYHWVA\n",
      "https://www.youtube.com/watch?v=BOMWNgejuPc\n",
      "https://www.youtube.com/watch?v=GI6pzcXbXJI\n",
      "https://www.youtube.com/watch?v=iGtpyZpfGnQ\n",
      "https://www.youtube.com/watch?v=jwo9VmddVeI\n",
      "https://www.youtube.com/watch?v=rFJ2Cnp4KvM\n",
      "https://www.youtube.com/watch?v=6Ei0A7i0n1Q\n",
      "https://www.youtube.com/watch?v=dq-dIT-1nQY\n",
      "https://www.youtube.com/watch?v=JpMWhTEZj9s\n",
      "https://www.youtube.com/watch?v=-o1cJWhb_Vk\n",
      "https://www.youtube.com/watch?v=oiGJPWFkCmk\n",
      "https://www.youtube.com/watch?v=ivRTtbv7mEE\n",
      "https://www.youtube.com/watch?v=k8fEOfFHVmA\n",
      "https://www.youtube.com/watch?v=R1eZjVQltVM\n",
      "https://www.youtube.com/watch?v=89SHOqW3lfU\n",
      "https://www.youtube.com/watch?v=yYdeQbimYwE\n",
      "https://www.youtube.com/watch?v=PaFhTYPFG1Y\n",
      "https://www.youtube.com/watch?v=0iTqwiuIVvI\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://www.youtube.com/watch?v=IrqDcMbh7DQ\n",
      "https://www.youtube.com/watch?v=U2eYyPQARnI\n",
      "https://www.youtube.com/watch?v=1G6_29eQAvQ\n",
      "https://www.youtube.com/watch?v=EfbJrgB2uqw\n",
      "https://www.youtube.com/watch?v=Aaxv0QyHPAc\n",
      "https://www.youtube.com/watch?v=hHGsHPzrfE4\n",
      "https://www.youtube.com/watch?v=yCwemCaUmZU\n",
      "https://www.youtube.com/watch?v=FwPy-VXvBqY\n",
      "https://www.youtube.com/watch?v=tbF3kTJaPE0\n",
      "https://www.youtube.com/watch?v=_c08BrTvtRE\n",
      "https://www.youtube.com/watch?v=bE_LHHOJsL4\n",
      "https://www.youtube.com/watch?v=YgeKi_JbUUQ\n",
      "https://www.youtube.com/watch?v=S9c9TI3f-Cg\n",
      "https://www.youtube.com/watch?v=e_EAE-_Y6LQ\n",
      "https://www.youtube.com/watch?v=o4AqQ7kaEOs\n",
      "https://www.youtube.com/watch?v=wu573Cd6rds\n",
      "https://www.youtube.com/watch?v=6Ys_5u84hw8\n",
      "https://www.youtube.com/watch?v=DPQ-RoWr37E\n",
      "https://www.youtube.com/watch?v=XukXPWzSrSo\n",
      "https://www.youtube.com/watch?v=BoStKybkFp4\n",
      "https://www.youtube.com/watch?v=-EkB_xlnuGo\n",
      "https://www.youtube.com/watch?v=_ZUwpwnl_CU\n",
      "https://www.youtube.com/watch?v=k4D3Xq6Ncpg\n",
      "https://www.youtube.com/watch?v=KNtNy_s1-t4\n",
      "https://www.youtube.com/watch?v=Cm29IRFf6aU\n",
      "https://www.youtube.com/watch?v=jBuwC4VJi50\n",
      "https://www.youtube.com/watch?v=03GN-duIY2A\n",
      "https://www.youtube.com/watch?v=N4d7Wp9kKjA\n",
      "https://www.youtube.com/watch?v=v--IqqusnNQ\n",
      "https://www.youtube.com/watch?v=fTUIT-E3oYQ\n",
      "https://www.youtube.com/watch?v=Z-Q4Yi_szJs\n",
      "https://www.youtube.com/watch?v=8cQ1Ne-AIOQ\n",
      "https://www.youtube.com/watch?v=RlOhPMYNr1k\n",
      "https://www.youtube.com/watch?v=IdymkbLAuAk\n",
      "https://www.youtube.com/watch?v=ZCrADfYPYpA\n",
      "https://www.youtube.com/watch?v=tBqVDPNq19U\n",
      "https://www.youtube.com/watch?v=bEclBjMsDpc\n",
      "https://www.youtube.com/watch?v=dCheZ_Tswto\n",
      "https://www.youtube.com/watch?v=Jh32cCEdYnw\n",
      "https://www.youtube.com/watch?v=1GIpOGYSleE\n",
      "https://www.youtube.com/watch?v=ugExG3xrI4o\n",
      "https://www.youtube.com/watch?v=02LculAH8ro\n",
      "https://www.youtube.com/watch?v=zq0m3YM0lYQ\n",
      "https://www.youtube.com/watch?v=Rt5taRNhZOM\n",
      "https://www.youtube.com/watch?v=DJN-JC9G6CA\n",
      "https://www.youtube.com/watch?v=C3-SupAvd9k\n",
      "https://www.youtube.com/watch?v=vX1jZNMfV4I\n",
      "https://www.youtube.com/watch?v=s_T5bpmBrwI\n",
      "https://www.youtube.com/watch?v=5YDpc87Jx_s\n",
      "https://www.youtube.com/watch?v=5YDpc87Jx_s\n",
      "https://www.youtube.com/watch?v=5YDpc87Jx_s\n",
      "https://www.youtube.com/watch?v=4KfnU1VI9SE\n",
      "https://www.youtube.com/watch?v=5YDpc87Jx_s\n",
      "https://www.youtube.com/watch?v=5YDpc87Jx_s\n",
      "https://www.youtube.com/watch?v=4KfnU1VI9SE\n",
      "https://www.youtube.com/watch?v=NvWk_qJjpRA\n",
      "https://www.youtube.com/watch?v=TWJcg5owc0g\n",
      "https://www.youtube.com/watch?v=9WNxDRJb5ow\n",
      "https://www.youtube.com/watch?v=SwQG-MDz2QQ\n",
      "https://www.youtube.com/watch?v=e8JUIQS7OgA\n",
      "https://www.youtube.com/watch?v=T04UWqGPiq0\n",
      "https://www.youtube.com/watch?v=4XbhXThxJL8\n",
      "https://www.youtube.com/watch?v=b8X8RB9tvPc\n",
      "https://www.youtube.com/watch?v=G_-8EnRLHso\n",
      "https://www.youtube.com/watch?v=1NYTei70aL4\n",
      "https://www.youtube.com/watch?v=xKpGtDBp5qQ\n",
      "https://www.youtube.com/watch?v=ytuV9HLuLgE\n",
      "https://www.youtube.com/watch?v=1NYTei70aL4\n",
      "https://www.youtube.com/watch?v=1NYTei70aL4\n",
      "https://www.youtube.com/watch?v=1NYTei70aL4\n",
      "https://www.youtube.com/watch?v=5CGblxcWOK4\n",
      "https://www.youtube.com/watch?v=bSjk8DL37HQ\n",
      "https://www.youtube.com/watch?v=1p2ZO0DiiRs\n",
      "https://www.youtube.com/watch?v=NxV-rpS4qeY\n",
      "https://www.youtube.com/watch?v=wKMjYxt0V_4\n",
      "https://www.youtube.com/watch?v=UgHPKHr0kDw\n",
      "https://www.youtube.com/watch?v=C9vooUIPGmA\n",
      "https://www.youtube.com/watch?v=ikuqddxNPs0\n",
      "https://www.youtube.com/watch?v=yOQ21JsPiV0\n",
      "https://www.youtube.com/watch?v=VzzYZB7uF7M\n",
      "https://www.youtube.com/watch?v=Mzyjqc-yh34\n",
      "https://www.youtube.com/watch?v=LiTkSNN9egQ\n",
      "https://www.youtube.com/watch?v=LFrVKgzAJBQ\n",
      "https://www.youtube.com/watch?v=1ZEen-NgXaM\n",
      "https://www.youtube.com/watch?v=1ZEen-NgXaM\n",
      "https://www.youtube.com/watch?v=1ZEen-NgXaM\n",
      "https://www.youtube.com/watch?v=FYm5Su-hhg8\n",
      "https://www.youtube.com/watch?v=1ZEen-NgXaM\n",
      "https://www.youtube.com/watch?v=1ZEen-NgXaM\n",
      "https://www.youtube.com/watch?v=-PW29S-2sTQ\n",
      "https://www.youtube.com/watch?v=1ZEen-NgXaM\n",
      "https://www.youtube.com/watch?v=-PW29S-2sTQ\n",
      "https://www.youtube.com/watch?v=Rq3GhlgduCE\n",
      "https://www.youtube.com/watch?v=cQWgKG5k5Xk\n",
      "https://www.youtube.com/watch?v=aWzFFpfNxMo\n",
      "https://www.youtube.com/watch?v=aWzFFpfNxMo\n",
      "https://www.youtube.com/watch?v=aWzFFpfNxMo\n",
      "https://www.youtube.com/watch?v=BSg7NZNAAWw\n",
      "https://www.youtube.com/watch?v=JEnEnUQ7130\n",
      "https://www.youtube.com/watch?v=JEnEnUQ7130\n",
      "https://www.youtube.com/watch?v=waAlgFq9Xq8\n",
      "https://www.youtube.com/watch?v=iRDg6xeJms4\n",
      "https://www.youtube.com/watch?v=SO12zEA75SE\n",
      "https://www.youtube.com/watch?v=JEnEnUQ7130\n",
      "https://www.youtube.com/watch?v=JEnEnUQ7130\n",
      "https://www.youtube.com/watch?v=JEnEnUQ7130\n",
      "https://www.youtube.com/watch?v=JEnEnUQ7130\n",
      "https://www.youtube.com/watch?v=JEnEnUQ7130\n",
      "https://www.youtube.com/watch?v=JEnEnUQ7130\n",
      "https://www.youtube.com/watch?v=JEnEnUQ7130\n",
      "https://www.youtube.com/watch?v=JEnEnUQ7130\n",
      "https://www.youtube.com/watch?v=u2bU-Rlbkiw\n",
      "https://www.youtube.com/watch?v=77uak6cLUiI\n",
      "https://www.youtube.com/watch?v=YYE2sN4mbqY\n",
      "https://www.youtube.com/watch?v=_IuxYlqs-LA\n",
      "https://www.youtube.com/watch?v=W4LQENM2B90\n",
      "https://www.youtube.com/watch?v=63Ww16m09Ks\n",
      "https://www.youtube.com/watch?v=cSnyF-91OA4\n",
      "https://www.youtube.com/watch?v=GQ0X7_rv38s\n",
      "https://www.youtube.com/watch?v=yE8DfId9XOE\n",
      "https://www.youtube.com/watch?v=xwEo4f46dyE\n",
      "https://www.youtube.com/watch?v=hmEgfF47TM0\n",
      "https://www.youtube.com/watch?v=hmEgfF47TM0\n",
      "https://www.youtube.com/watch?v=6ggxtK5Dg7Q\n",
      "https://www.youtube.com/watch?v=63__KaIYGoA\n",
      "https://www.youtube.com/watch?v=ijcbK1Aj-JE\n",
      "https://www.youtube.com/watch?v=p0fLmJP7nhk\n",
      "https://www.youtube.com/watch?v=GfJIMcQi1YE\n",
      "https://www.youtube.com/watch?v=_AIBIIMVJro\n",
      "https://www.youtube.com/watch?v=hmEgfF47TM0\n",
      "https://www.youtube.com/watch?v=er3uivvfVvU\n",
      "https://www.youtube.com/watch?v=hmEgfF47TM0\n",
      "https://www.youtube.com/watch?v=hmEgfF47TM0\n",
      "https://www.youtube.com/watch?v=hmEgfF47TM0\n",
      "https://www.youtube.com/watch?v=hmEgfF47TM0\n",
      "https://www.youtube.com/watch?v=g5866JK6yYY\n",
      "https://www.youtube.com/watch?v=hmEgfF47TM0\n",
      "https://www.youtube.com/watch?v=hmEgfF47TM0\n",
      "https://www.youtube.com/watch?v=PuGvwV-P2LU\n",
      "https://www.youtube.com/watch?v=YMGIGtCG-RI\n",
      "https://www.youtube.com/watch?v=rEQ5yQaxK_A\n",
      "https://www.youtube.com/watch?v=druo1EYgSxY\n",
      "https://www.youtube.com/watch?v=hmEgfF47TM0\n",
      "https://www.youtube.com/watch?v=EPkfe2of2kc\n",
      "https://www.youtube.com/watch?v=VIJCYBlz0AA\n",
      "https://www.youtube.com/watch?v=hmEgfF47TM0\n",
      "https://www.youtube.com/watch?v=WRzlq6tWNWU\n",
      "https://www.youtube.com/watch?v=sMlUB_n0UgQ\n",
      "https://www.youtube.com/watch?v=ik7Q84CTnxk\n",
      "https://www.youtube.com/watch?v=AwSOZ0dV6OU\n",
      "https://www.youtube.com/watch?v=aIBL2vFUMcE\n",
      "https://www.youtube.com/watch?v=1ZEen-NgXaM\n",
      "https://www.youtube.com/watch?v=acUbnQXVWtA\n",
      "https://www.youtube.com/watch?v=d-Y4Qo12mbU\n",
      "https://www.youtube.com/watch?v=Mny5EtQmGdg\n",
      "https://www.youtube.com/watch?v=LVoqdWQ5cMI\n",
      "https://www.youtube.com/watch?v=aWzFFpfNxMo\n",
      "https://www.youtube.com/watch?v=aWzFFpfNxMo\n",
      "https://www.youtube.com/watch?v=aWzFFpfNxMo\n",
      "https://www.youtube.com/watch?v=aWzFFpfNxMo\n",
      "https://www.youtube.com/watch?v=aWzFFpfNxMo\n",
      "https://www.youtube.com/watch?v=aWzFFpfNxMo\n",
      "https://www.youtube.com/watch?v=aWzFFpfNxMo\n",
      "https://www.youtube.com/watch?v=mSUIjDFBezY\n",
      "https://www.youtube.com/watch?v=i_DrvvmuSZs\n",
      "https://www.youtube.com/watch?v=LhR57w3nwcI\n",
      "https://www.youtube.com/watch?v=qEioVs_wWRo\n",
      "https://www.youtube.com/watch?v=KNxtK7j8Z8g\n",
      "https://www.youtube.com/watch?v=hmEgfF47TM0\n"
     ]
    }
   ],
   "source": [
    "youtube['delka'] = youtube['youtube'].apply(lambda x: delka_videa(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "bf763458",
   "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>Unnamed: 0</th>\n",
       "      <th>interpret_hlavni</th>\n",
       "      <th>track</th>\n",
       "      <th>youtube</th>\n",
       "      <th>delka</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1984</th>\n",
       "      <td>79293</td>\n",
       "      <td>Corinne Bailey Rae</td>\n",
       "      <td>Put Your Records On</td>\n",
       "      <td>https://www.youtube.com/watch?v=oWQl00LWEwE</td>\n",
       "      <td>244.784</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2558</th>\n",
       "      <td>85748</td>\n",
       "      <td>Wham!</td>\n",
       "      <td>Last Christmas</td>\n",
       "      <td>https://www.youtube.com/watch?v=E8gmARGvPlI</td>\n",
       "      <td>278.430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3417</th>\n",
       "      <td>104104</td>\n",
       "      <td>Adele</td>\n",
       "      <td>Set Fire To The Rain</td>\n",
       "      <td>http://www.youtube.com/watch?v=FlsBObg-1BQ</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3469</th>\n",
       "      <td>105301</td>\n",
       "      <td>Václav Neckář</td>\n",
       "      <td>Půlnoční</td>\n",
       "      <td>https://www.youtube.com/watch?v=45mbYID0ec4</td>\n",
       "      <td>245.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3514</th>\n",
       "      <td>106048</td>\n",
       "      <td>Janek Ledecký</td>\n",
       "      <td>Sliby se maj plnit o Vánocích</td>\n",
       "      <td>https://www.youtube.com/watch?v=YLbgajaQ_U8</td>\n",
       "      <td>246.131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13839</th>\n",
       "      <td>444919</td>\n",
       "      <td>Momo</td>\n",
       "      <td>Nehaj tak</td>\n",
       "      <td>https://www.youtube.com/playlist?list=OLAK5uy_...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13842</th>\n",
       "      <td>446424</td>\n",
       "      <td>Shimmi</td>\n",
       "      <td>BERLIN FREESTYLE</td>\n",
       "      <td>https://www.youtube.com/watch?v=Z7Ant_nWzHg</td>\n",
       "      <td>118.003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13845</th>\n",
       "      <td>446525</td>\n",
       "      <td>Saul</td>\n",
       "      <td>Chaos, teraz</td>\n",
       "      <td>https://www.youtube.com/playlist?list=OLAK5uy_...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13846</th>\n",
       "      <td>446571</td>\n",
       "      <td>Radikal Chef</td>\n",
       "      <td>Marocchino</td>\n",
       "      <td>https://www.youtube.com/playlist?list=OLAK5uy_...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13847</th>\n",
       "      <td>446574</td>\n",
       "      <td>Radikal Chef</td>\n",
       "      <td>Deja Vu</td>\n",
       "      <td>https://www.youtube.com/playlist?list=OLAK5uy_...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4235 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0    interpret_hlavni                          track  \\\n",
       "1984        79293  Corinne Bailey Rae            Put Your Records On   \n",
       "2558        85748               Wham!                 Last Christmas   \n",
       "3417       104104               Adele           Set Fire To The Rain   \n",
       "3469       105301       Václav Neckář                       Půlnoční   \n",
       "3514       106048       Janek Ledecký  Sliby se maj plnit o Vánocích   \n",
       "...           ...                 ...                            ...   \n",
       "13839      444919                Momo                      Nehaj tak   \n",
       "13842      446424              Shimmi               BERLIN FREESTYLE   \n",
       "13845      446525                Saul                   Chaos, teraz   \n",
       "13846      446571        Radikal Chef                     Marocchino   \n",
       "13847      446574        Radikal Chef                        Deja Vu   \n",
       "\n",
       "                                                 youtube    delka  \n",
       "1984         https://www.youtube.com/watch?v=oWQl00LWEwE  244.784  \n",
       "2558         https://www.youtube.com/watch?v=E8gmARGvPlI  278.430  \n",
       "3417          http://www.youtube.com/watch?v=FlsBObg-1BQ      NaN  \n",
       "3469         https://www.youtube.com/watch?v=45mbYID0ec4  245.133  \n",
       "3514         https://www.youtube.com/watch?v=YLbgajaQ_U8  246.131  \n",
       "...                                                  ...      ...  \n",
       "13839  https://www.youtube.com/playlist?list=OLAK5uy_...      NaN  \n",
       "13842        https://www.youtube.com/watch?v=Z7Ant_nWzHg  118.003  \n",
       "13845  https://www.youtube.com/playlist?list=OLAK5uy_...      NaN  \n",
       "13846  https://www.youtube.com/playlist?list=OLAK5uy_...      NaN  \n",
       "13847  https://www.youtube.com/playlist?list=OLAK5uy_...      NaN  \n",
       "\n",
       "[4235 rows x 5 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "youtube"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "af48aeaf",
   "metadata": {},
   "outputs": [],
   "source": [
    "youtube.to_csv(os.path.join(\"data\",\"youtube_delka.csv\"), index=False)"
   ]
  }
 ],
 "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.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}