Youtube Scraper.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# WELCOME TO THE YOUTUBE SCRAPER USING BS4 "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Hello All, I will show you all how to scrape youtube and display the video in the Notebook itself. Also, we can store the details in the excel for further use.\n",
    "Before Scraping any website, go through their terms and conditional.\n",
    "\n",
    "You can find the code in github - https://github.com/JohnPravin97/Youtube_Scraper"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## To Import the Needed Library\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-07-23T21:15:51.478759Z",
     "start_time": "2020-07-23T21:15:48.138899Z"
    }
   },
   "outputs": [],
   "source": [
    "from bs4 import BeautifulSoup \n",
    "from urllib.request import urlopen, Request\n",
    "from selenium import webdriver\n",
    "import pandas as pd\n",
    "from IPython.display import IFrame, YouTubeVideo\n",
    "#from webdriver_manager.chrome import ChromeDriverManager\n",
    "import os"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Scraper Function"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-07-23T21:15:53.202895Z",
     "start_time": "2020-07-23T21:15:53.193877Z"
    }
   },
   "outputs": [],
   "source": [
    "def youtube_scraper(inp):\n",
    "    \n",
    "    Search = '+'.join(inp.split())\n",
    "    \n",
    "    driver = webdriver.Chrome(executable_path=r'C:\\Users\\jpravijo\\Desktop\\Anaconda\\chromedriver_win32 (2)\\chromedriver.exe')\n",
    "    driver.get('https://www.youtube.com/results?search_query='+Search)\n",
    "    html = driver.page_source\n",
    "    soup = BeautifulSoup(html)\n",
    "    search = soup.find('body', dir='ltr')\n",
    "    first_content = soup.find('div', id='content')\n",
    "        \n",
    "    link,name,channel=[],[],[]\n",
    "    \n",
    "    for i,second_content in enumerate (first_content.find_all('div', class_='text-wrapper style-scope ytd-video-renderer')):\n",
    "        try:\n",
    "\n",
    "            third_content=second_content.find('h3', class_='title-and-badge style-scope ytd-video-renderer')\n",
    "\n",
    "            # To get the link of the song\n",
    "            link.append(('https://www.youtube.com'+(third_content.a)['href']).strip())\n",
    "\n",
    "\n",
    "            # To get the name of the song\n",
    "            k=third_content.a.text.strip()\n",
    "            name.append(k)\n",
    "\n",
    "            # To get the channel details of the songs\n",
    "            channel.append(second_content.find('div', class_='hidden style-scope paper-tooltip').text.strip())\n",
    "            \n",
    "            if i>10:\n",
    "                    break\n",
    "\n",
    "        except:\n",
    "            pass\n",
    "    dic={'Name of the Songs': name, 'Channel': channel, 'Links':link}   \n",
    "    print ('\\n')\n",
    "    print ('\\033[1m' + 'These are the top 5 searches from youtube for your search'.center(50))\n",
    "    driver.close()\n",
    "    return dic"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-07-23T21:16:11.148673Z",
     "start_time": "2020-07-23T21:15:57.088437Z"
    },
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "enter the song to play from youtube - Scraping the data: faded\n",
      "\n",
      "\n",
      "\u001b[1mThese are the top 5 searches from youtube for your search\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name of the Songs</th>\n",
       "      <th>Channel</th>\n",
       "      <th>Links</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alan Walker - Faded</td>\n",
       "      <td>Alan Walker</td>\n",
       "      <td>https://www.youtube.com/watch?v=60ItHLz5WEA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alan Walker - Faded (Lyrics)</td>\n",
       "      <td>7clouds</td>\n",
       "      <td>https://www.youtube.com/watch?v=qdpXxGPqW-Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Alan Walker - Faded (Live Performance)</td>\n",
       "      <td>Alan Walker</td>\n",
       "      <td>https://www.youtube.com/watch?v=mIxlvVlOIS0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Faded - Alan Walker (Lyrics)</td>\n",
       "      <td>DopeLyrics</td>\n",
       "      <td>https://www.youtube.com/watch?v=reuYXbHOc1c</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ALAN WALKER – Faded / Different World feat. Ju...</td>\n",
       "      <td>KKBOX</td>\n",
       "      <td>https://www.youtube.com/watch?v=n03IDJcsy5g</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   Name of the Songs      Channel  \\\n",
       "0                                Alan Walker - Faded  Alan Walker   \n",
       "1                       Alan Walker - Faded (Lyrics)      7clouds   \n",
       "2             Alan Walker - Faded (Live Performance)  Alan Walker   \n",
       "3                       Faded - Alan Walker (Lyrics)   DopeLyrics   \n",
       "4  ALAN WALKER – Faded / Different World feat. Ju...        KKBOX   \n",
       "\n",
       "                                         Links  \n",
       "0  https://www.youtube.com/watch?v=60ItHLz5WEA  \n",
       "1  https://www.youtube.com/watch?v=qdpXxGPqW-Y  \n",
       "2  https://www.youtube.com/watch?v=mIxlvVlOIS0  \n",
       "3  https://www.youtube.com/watch?v=reuYXbHOc1c  \n",
       "4  https://www.youtube.com/watch?v=n03IDJcsy5g  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "inp=input('enter the song to play from youtube - Scraping the data: ')\n",
    "df= pd.DataFrame(youtube_scraper(inp))\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Choose the Scraped data to play the songs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-07-23T21:16:14.181285Z",
     "start_time": "2020-07-23T21:16:11.148673Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\u001b[1mplease select the songs by choosing the indexes (e.g) 0,1,2,3,4\n",
      "0\n"
     ]
    },
    {
     "data": {
      "image/jpeg": "/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAUDBAkHCAcHBwgIBwgHBwcHBwcHCAgHBwcHBwcHBwcHBwcIChwXBwgOCQcHDSENGhERHx8fBwsWJCISJBASHxIBBQUFCAcIBwgICBIIBwgSEhIeEhISEhISEhISEhISHhISEhISEhISEhIeEh4eEhISEh4eHh4eHh4SHhISEh4SHv/AABEIAWgB4AMBIgACEQEDEQH/xAAcAAACAwEBAQEAAAAAAAAAAAAAAgEDBAYFBwj/xABMEAACAAMDBwYJCwQBBAEFAQAAAgEDEhEiMgQTQlJiovAFIXKCktEUFSMxQVFTobIGBzNhcYGRwcLS4UOx4vLxCCRjc0SDk6OzwzT/xAAZAQEBAQEBAQAAAAAAAAAAAAAAAQIDBAX/xAAmEQEBAQADAAIBBAIDAQAAAAAAARECEhMDITEEQVFhIjJScYEU/9oADAMBAAIRAxEAPwD8ZAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAa/AJurvL3h4BN1d5e8uVO0ZANfgE3V3l7w8XzdXeXvGU7RkA1w5Pm6u8veHi+bq7y94ynaMgGuOQTdXeXvDxfN1d5e8ZTtGQDXDk+bq7y94Q5Pm6u8veMp2jIBr8XzdXeXvJ8XTfZ7y94ynaMYGzxdN1d5e8PFs3U3l7xlO0YwNni6bq7y94Q5Om6u8veMp2jGBs8WzdXeXvDxbN1N5e8ZTtGMDb4tm+z3l7w8WzfZ7y94ynaMQGzxbN1d5e8mPJc72cfxXvGU7RiA2eLZurvL3kw5Nm6m8veMp2jEBt8WzfZ7y95Piud7P3r3jKdowgbPFs3U3l7yY8mzfZ7y94ynaMQG2HJs32e8veHi2b7PeXvGU7RiA2+LZvs95e8jxbN1N5e8ZTtGMDb4tm+z3l7yIcnTdXeXvGU7RjA1+L5urvL3kw5Om6u8veMp2jGBr8XzdXeXvDxfN1d5e8ZTtGQDX4vm6u8veHgE3V3l7xlNn8sgGvwCbq7y94eATdXeXvGVdjIBr8Am6u8veHi+bq7y94ymxkA1+L5urvL3keATdXeXvGU2MoGvwCbq7y94vgUzV9694ymxmA0+Bvq+9e8PA31feveMqbGYDT4G+r717yPA39XvXvGU2M4GnwN9X3r3h4G+r717xlNjMBp8DfV9694eBvq+9e8ZTYzAafA31feveR4G/q9694ymxnA0eBv6veveHgj6vvXvGU2OgixMCIwJip1eYo9otAQgwDALYNYAtpNhMAsLgUeF0iECYEDMtRFmiwygymgmEdoEQhrBaBDQJqGjDqlbTF6XVAsjELGKozBqmYmiyMCbNbD0hIKTGJRMIjlVnWBxoeIPDW/cUKFTE0XwIKc51i5XLoIQBYDLDaq2R7Or1QFiut8QQ2SYhEBbCLSYqEFMiICxUelf9QWBoUsoyl2aFeXq3t4yKIk0jQQd4gUERGhAiIUsYEWDRUIKFKEIkwgTECCByukCHgI5aVTIAITEiECYhpAWEkQAAAACwiwIkgAQCwiAEgRYEQNVoQJqJaIcxEUa0IwALRoCrxeItLoYIwJUmJcCkFkSIGQQiNASMRquKi6B4aRS03VLHmVf7CKpArxZhR2IsDSUHVhEgWxgGUQbrAzkNdJgoDy4EOWWUlQEWBSWWisAsYEwgCxGArLFqJaIkYgWy5i6o5nHlTWUumL1UlpYLMq/aTBdkqKyYRLc2Tm+KgaoZesNCWXMykVcVAV5ikzMaW6W8VzIavxCqpgTOhhLFSkRjIpAZoERAWBJEYERDSYsRGIWhCIEFcwsjASZACuADQgAaKEQiEQICIQgTECAtCwAAiwkIgRaTYAAbIsLYTEmAcy2DRgAGhFoQJjAWEDImI6xFhEmkCR4QEHqAgriDRFjACYqRCA0IABBFhJEYBpKxLJZTGBdk0AyeEKiyEAsHhACp1Kol01uKSiMQCwZVIVCykBFhwo9IQh0SI9oCGgEEqGsHsASMsikeMVIpAhY0mmXlest7q9xlpCKl0a4zKtLs/8ABOb6XWDJp+tolkZ+qpUVRVh8x0hbeKSGhdNCKKWxcfgTCb0t0S6RZsmdEzY1bJnjA0R2lKpkCVVUVEsLYQFaJBVYFI4NACuAsR7CIhosYiuOLMASARiQSGkCkxCICkxALAAiwcUCAJsIjACLSSLCYAarRggTA05ohEGiS6hCAELEmBMUCETIKRYxpLoENABViLGJEcQWgBEYExYACBMQhAIwAWkmMBqQgjBdEuXUaZSqVSUNEYFiVXGJNvFRayishRmjSEIF8JahAmCFUWksjAIkFQ7R2RrBoQLgpaAKO0NUWECCbCWGgpYkTWDNVsjQgXwvYbvH2CwgwwQqFj3R0VtL9JXlETSEi4R6xdKZaSHdQKrOiNBNomMxtUraLGQ7IFIiq2sQ0NreGqqnQpvFUIF7IVTI6JkIsQJsIjEAjEUa0iwBYqJMLIwK5kA0rgTELCA0gCYwIAiIQJItALAiSRGAEEEhGABEi0IwADZBiYMMgPA05lbji0KlJpIipkTSPBCtS1TUCwgQzlipU1KrUzNSqrVeZtFSMpktLamYrS21WWluywopjALCykiEDIWwID2EqoCWErAeCkwXogRBAgSy7IRVQLMljsmqEOKTNk6mw1EqqENnjojTVus36aR4pxhFhqgY2BYFs1CqUZVakL2H3DvAhOOGJY0it4hBtUWZGoIQMqWEWLJUGbDe6o8qTpXTRLbq9E1IaTwfaWkloU4SJkBTSFjAZYU4ekRYFpkRCJEV0gj1SIxAgiDgykYTKpgzBWwwsDQhokcYRrCLDIViuYXRCwDPSIOwsYARYREewiMAEEmDxEmBohFpMCIhYgCYERCpeAsSYgBBFgxEQFsCJNgWAQBMIE0hlqZSIRGi3HEQVQymESwqGWJqBokRhqjLE18l8nvlc6Tk0hWmTZ8xZUtacTNdvaqw88Y+iCxNfk133zM/IxsvWdyjMurImZmQvtJlNUyZ90GWEPrt9R2HLXyZmLUs6XLob6SmmZVtMzQjT6vNzHdfJnkeVyZk0jIpFTJIWmqlVZplTNMmN6GZnZmPWzbM1N68uorLS2K8sT2ceEkyvl8/nt5crPw+C8q/N9KmLVJ/7RsVTTVmS2bal81K/ZGBwvLHIE/JPpFziL/Wl+Ul9ZtH7z9O8rchS515Zaq91fKKubZmqbDzQXnVfMeBl3I0yWubmVTGxZuXKXDpXlhGLLdb06Rz5fDL/Tp8f6mz8/b83LAiMD6v8qvm9WdVOyKWuTMq/Rs1Mmc2FlVbPINdtttjC9z2ec+a5Vk7S2aXOVpbS2pZWW9/r6o+k8/LheP5e3h8k5fhigPCA1lJZb0eyc21EYBSXWdHskRVuFNYGyZDbBbpTkMttXdqPSjJ1m3VXS2jUjNrE8W6JRWbcplro1GRk4YEVvGopmS7vWL7KiWS7Te6KqFZ8Kiy5g+UdErWBlToxY7FcqUWU7JYGRyQjAIlQWiwJ4wkrL4pAiLBAtlytYexQmqYwEgha8b3+JDx2WCqowFaG6WwURgF6IQVhoLq/CRFW0rpkJYxFO0WR6RW0QojAIx4qIjEKTIVymJfGBXSBXCJEYjMLYFhYiMWMI0QpYQIsGUiIEUBSPALAEoJsGsCKgRSLEe0h4AJYEYDCgRaQNEUDTpDwK4KNGFIZPABYNxUOprARU+rf9PXIGcnz+U5y3MmqkZNVV9LMl1Tpi9GWywt5/po+o+W5NKaZMlyZa1PMmLLlquJpkxlVVX7Ysp+qPkDyUvJ2RZNkUunycuqdMV2l5ydMvTpnb5oW+hYHf4eP3v8PL+r+Trxz+XuImzpVYacX4hGXLZmbSu4l2Vw087A9VVNNN5dOrdaHqKJ2VrLZZbVKzU0tXdwre9Oyet81fMam6uK7rU/R1fXH7rRp8lWWlqVZpklalVqlqnS1u7VjbxjyjLpUlZzZ6TLeWytear+nL+/zrumCPyuyZZbK06W01ZktmVXWqmXMVmX11WS/NGEDnfys41YkhJl7Ny2p0plV6lpi1dKymP4w9UTl/l98iJXKKtnGlyJ8tfJTFVtL+nO9MxIx74fX6E75aVZzMZHlE5lpqpSY12czMtOcsg2H0RjYdHyJPmZXJWfOVsmaZ/TmXZ0tsN6nma2pY80feZv39Nztw+/w/LXKfJ83JJ0yRlMtpTyWpZWwsujMXWWMOeEfUY4Q4Y/Qnzl/JWRynJZpLLMy7Jl8lm71V6ppEynCsb1kYxjZFrfNafB50jEsyqVS1LLhZWVqWqXzq0I+g83PhlfR+L5e8Y4wIaHHES6zabrNiXR9Ajw2tHWI7Lcg2V3qT1ISm2eyzGHk1eKtE9Zlqpus2tV/kXjHPlXnZVLVWM8dm8elPkNdWmnatX9PMUxydtkWErzmTikLKTVGVVpdn9RTNgq4mq6JG5VM2TUK0tf8QdqsKtSwqo2qxlTLSEYbJGTymar9TfwaoSqVvMvH3mi1UihCSO0unSYRIcVAWQkEMuHoszXuiNCHH+w69UMlSAVbO7/ACWQbVEt47Wj5wKHYSJY0Q7KhpWkahX4ujxQR4bQEJeGjLXSFhHaIaAEtLXREukQgpNqmVStIsYhaEIgRGJU5bGIswyKbBYqWwUrjECtoCtAdiLA0WECRqSYIwCWBYNFSYBkjRAtzXV6xPgzay9oCqESGLYSBoSNouDLELC6KEwlqMGeAQQ05tQiqlxdEAhAW0IMZRZYEFIUeBvB2XzP8nzJnKK5TLyeZlPgSrPpWlVz1VMlmZubWjD02rD1H3STyjypMqZcjlyavbTValbrK1NFmk0LLeamJzn/AE/8kZnkzPsq1ZblLTKmSpmlS/Iy1bZtWY0P/YfTFl7NV3Ub4fMe34uOcXyv1Hybzv8AX05tch5UnVNMyqXLw05uVdpaqq80cWH0Fcr5Ks1MydlU+Y93SVaVqVrtMYR8ytDn9DROqijLiw3tG7pNxbEeFOLFu/DG8bxy7X9ngzvkZIZWWcs6erYmnNU3RvWnocnfJ6VJqaTJlymmTM4zMtVTMzVVLzVc7Wnqwp1cWJaP1WlkXpu3W6rLvc5mxO1Y4ZLLWlrq6NKpLXZ9VtP1F3grUtialrtVLKpMyC9Hoym7i2al2lplWjhpq7PMQY3Wnq4ql+FrYVf8Hxj58PkusuYvK0u8s9ll5TLlphnYZc6ldJsMY+tV9LRPtuUy5eLrdFtqrm+o8rlfk9crkT8mnqubnyWksyozMtS/SLz4ljTGH1rAxy47Mb+Pn15a/KOUVYrq09beFmw6J6fKWQNk06dk069NkTJkmZd0pbUtTsx8/WgYHSqq6rU6x5rMfVlbuRMnZs3S26rfmdC3J9K5yZMbRXRXS2ukeZ8lsjaY0umWrU3mq/0jwp9Byfk2bm1ZZMm8uk0xuz5OzzfWd/j4bHn+TnlcbPyWW12pur0tkzNkcuq6rXV0l/S3Odm3JUxtGWtSqzXWam9tRhresWHIsy81Uu62o2repqj91hvox6OEbIWaqmWy4tFer6SvKOSpmJpdN3Sa8y0/edjHIs4rVTlXFqrhamq9hWH2meZkyszLMnU1U+zXFe62iZvxtz5HCtJmVaK09bVujvLanR1W0tm9znsz8iltO+k62zViamBknyZC1U1TKm1JmH8Dj0x17PO8GZW+kuthW72vvpImS1XS3v8Ag1qku95NlqZqbjNq/wCRRPlroy2u6VOJtH1DGtYXZav8qi1FUvRG9ni2V7y1JDaKsZNZEjTo6WqX9Vt1R4y2qwr1hmVtne/g1IazpFqmu7QrzG1bvS/guzbaNPZZuyVNLbhf5sJYapjBu0Qxbm9rq3SqhatmkjUpIqEEXhhoqusV0hUxlqJSo9igqrqgLYQiXifBtpi2XIXpAVTlEVSyMtdEIwXZASAWBdCpeF/kyKGKGU1tHV+EoZWxGVIqiWFqF0JNQFMuUwyym2i2UtJbGLGpDWSMll4UmElmNKyWq/SXKiqXqlrz83osMqLo9U1Ql1NVdZQSWqjqark3cV3rEzZVWErnNeU0qv8Aqagz+DEZg2QTin+BYr0eyXqzrz4wCyk1NLqvXeyMydUnVdYIKEVBBoGfpoIpu5E5PmZblMjJJNNeUzlkrVhVpjU1Nsw85khA+gfMLkCzuVlnNeXJJE2d/wDUamTL/wD2TI9U1w47eMY+Tn148r/D75yJyfLyTJpGSS6aZEmXKl371MtVW8ut6TdLbrdZuzS0CINpaXSXvjSPLb/xt2qejePoPiX7XJiur2X0aix4L2qb1Tdq7CwSjpL11Hp6XaX+KSNLIRTSvNs4eIDpxeZV2fQRXrN2qe4KFW9UzKu0vV9AA8V2dHE7dwyw1m6q1cMNKxaXa/i7/kO8adZezT1eYwpHW7otpXquOcyU4mql6uJvhbnN8IarN0bv6sRndaWurV0rtSq10xyHwn5+OS5cjL5OUy2WnK5CtMpZvpZHk2q9FWbzPNsxPmbpeu1YbzYf9tI/QPz7cnNM5OWayrVIymS1VWGXMzkllXmtZYvMl80fqPguWJTibSwrSuz9cTh8k+9fQ+DlvHi7D5u+Tc+ytm2anF5dpdS03qWrPqEjkW6tOTrSq/1MoZtXRZI/jz4fvOQ+aPI1aXVnmWqqqllVqaabrMlnNx6D6rKlKq//AOhqdlpOyuKi6sTtxskeb5+V7Y5XKeSlu05PJXWWvF2U9dMbdmPmsCPI7TFWmTJpZdeZTrXVZMeKB0s9Fw5yY2K8zyVxbNkLuLn5zLlEvyf00zVVs6rLTUrXs3Czm9fvOmuWuNynkpqWuyZdVWJZjYWb64Vc/q8x52VclOq3ZkmlaabjXrtK0rb6/hidNlUmr/5VN66udVmmYr1TJ7rbb0TzsvkyKVaZlEyqnFnqabt26sLuJvvtGSx1nKuFmZI0xrrKzMzVXcOkzee2n6ip+S3mM1TKrLLaZeS7m7zeu37O49zJ8nkTpecaZMzirepnMtKtiVlWykoaRIzlMydMWpafpWbSpq9Os0LO45ZLXfs5ebyXMWpmnLTh+ixe/wB4s3JGqvTLtK4VVW0vt1Tq+VuTMmWXMpmVUrUvlmvUquHmsqw8QOeyzJJWi2yzVTKcLN67NEzz443x56q8X3Vapqd7W0YQ9H5FErILuJryqzUtrKur0i9JMtafKVYqr+Ha88S6iRrLSuK9o3ePxJMXa8rJskZlqZsTMt5mxLUv2axc+SS6ejtNT1i90yZWXDTeZWqqWpaft88KgnRlKrNUvRpq6PoLMNecstVVbq1dGrrespmS12TVHNVKq4r2iDquyZVikrLpW8va+IiMV1lNM1pdLU0tdalbu6VtSYdGPKNHCVRY2RVdYphFb1RFlUQZdJt7+CWZdb4iyMFbV7Sg7KuqDWfNLMvVFy5Our8RVavDDy+l2Wb9QaJGSurvDJJX/UJsF1t7+Su7rb1X5jBbm1pwiwTZKoNtN2hYN0u0BbOQyNHEWzoYb3aaoRjNIpkxvf5GnJYYv3FEvEpfkeJhxWrIkLFqtHtGgZDeMaVeOLBnVWxaW1/A0IcVAaTS5hdG6Y8ogqsulevcfYa50+lqRYwlr1m4vaIsWVXlGTq2yXQUeEOMQ0IiRm1TGBVMiaoxKpylVknRGltUO6VCqlOEivOgg6wHhEIQMY3oh0T7R/05yFWTl8/C0ydJlYf6cuXV5NrfS8xuyfGFPs/zMRzEvJs40ynKVnMqqrU1M1SzGpxW0y1hbrHb4J/k836q/wCGPrKPi6OFqf1RNcmpsKr0aeOLSmQ21+6793HOWy1W9e3am0T2V8pel27Tuq1Xaw+8d3ZcKsuldSlafwulSMulm95d1oR9xfBlvLiXpXd2EDOBpTVYrvVq/L+B4JL0b1N7RYqhMVdJdKnhrIFqQbW3W3iVqBXXCq7VSp/Hu/uWRVur0Ozh6IlOrS3SVm1hlb/17NNS9r0mFWQZv3XdH+5VlC4brN1V0hox4vdwT0XFThW7ea91V485KVyvzmSM9yVl65trshZmD2MyXNq8+zafnHlOTTVdpXFV+o/Tfy1ZfF2XrTiyLKaas57BqWqttpt+8/M/LsqlWut1mmfEz2e44/I9n6W/XJ9n+Z2H/YLVMlreppovYsWOH9vUd+0JjaSteX+liXSp54xOP+aipsgkLSrLm6qs7UuyrS7MWL0+o7DLIy5Mtpk5ZcuWq1TJjeTlqq6TNbdX0nR5vk/25Kspg1TS7rVYqlvXr2GzDDiBmdZmcpZZf0bXmvYafqh54M33mXkXlvI8tzszIp0nKc3MpmtKdp2bbRV1WN3mXzxshGn6j0J0JbK12q7dpSZdVv59BdYsz8vJy2XNlqt2Tdzaq1LLUzNTSy2Rq5+f0HP8sLNZrqyMN1atVabtUPTE6SZKkNiVbq6rXdLiP2nNcsZNk30l7OZ9WX6RlzbT6bq/+v02F/Z04V4MmM2cyq2Srh1pbVM0ulfRav4fiWxR5DU5mmpWvK8mlc3+N61vV/Y1Jk8ipqmWXTU112XF17V51MsILM/qNMpaZTfZqVzjU4ox9CqJ9OzJLWZmZmcydWqVqbytdpppVbIXbaYfgYVTya0ycKrMWraWnFZGNX1fb9R6OUostlvN5ZZmGbMusq3qqYwKZHJ66LMqrSt1mw06PPHZ9xPu/Sy4x56llltk+JbrLSyqzK2lZda7vGLMteZpNV5rqsuFpjNpWeY6DJ+SKqWaZMutMVby6zKrU8/o4gVcocktJVmWdM8mrNTQrYWqbQ9Xq95en19neOcnSL12SyrSulL0aqmuvHz1KVzJbS/6dNTUq1S3WpZr3P6l+3zHuZbkMyWtSzqryreRWxNm8NnFJlnZE7fSTGusrXUXtcc3n85mzGpyeK0pmqaltVqcV3RvR9EW8xkny2XErUto3WvXvr45z2cqyaZKppaqqYsvBraV2N4R8kdmWpl7LLe2qo4fvM5W5XjZqlvo2vXdHERPjTeZWXq7x602SyriVqadZcX6jFlqMyst28rLi1rpm8WpXmzF2W7OJv5IjL/8czsGlYNs3alFSc15ruJlxarYvMZsb1kZNluxV8JQyLqt2TbGY16lVvbtOrtRvFM1m1dIliyssYU8aISnXZ3S13a9UvHR85nWetV5e1eJFWRp2eypSyLewljtLpwqUPm9neNBLuiRSOqqKyGLG0N0d0Rx3llcYCiuTi7Rbkb3sOISX+4v5P0icStEIcUliw4pFhEuhA6SMISAyoFlPDDWdHeKxrzstk3ixFVlvfCXz5SteCErD+4jXZVJSm7UO7ccRLrBHpxaprGdKsOKSuZHikIuzLdpu9Izz51S7QuNSLbCaSqReFdadIiscYhBuKqgJpMY2eRDOMqreZmpVdZmuqq/afc/k5yJlkmTIl5n6BZLKsvKF+kl0tepf1nyj5vcnzvKvJ0un/5MuZeWq7Jqnf8A8z9IMrLrNh0V0j0/Dx/2rw/q+eXjG7JJ+Gppitqs9Xea4ZRivYeivwwPNtZbtLLdu1L2m814eTM6K6NTdXjzf2O+vE9KXNqw0tpY1+Ju80QVsWHrLh/A8tIdHZpqu+/1miXPp1tbRbq02Q85LRul3sVLddfhsGi13Sbr/tT8zHCc2LFssqrd/C00S51V1ZfRalbvajaZo0IlXtLuG+vW4sHilLM1TbWcf/ioohFdKpdVqaV0bqtbYE9m1tHDQvxe/qmVXpVrdl1VezzjwbitdL7v7lMmerYd5bt3+SuZBqr2cXWw9wo8j5fTaeTOUabzeCTlpqqpqltTdU/NvKC1VM1Uym7TUzdnVP0T85FXinlFlvUyGvMmirLd+/zH5xy5mZlVmpW7nGZKaVqvN57OaHP+Zx+R7P0s+uT9CfN1IVcgybydLZtWZqpd6q9o8+l6TyPn+mN4lnNLmZllnyapdaquUq2clzJaq0bWZYNnLIWxslR+74VN5dn5NPWfydylMWZla5iZOrzeZlLOl5tZkvnhLSNKtpRhBY/Xb53LnyjyzLZ0tstypstaQzLLaY1UldFmlqtkKY+uy2MLLTN+Sfhvj+mvbtv9u1/6dOVpWSZflsufOWQ2V5IkJDM6y1nTZEyLZqpuZpsYTbYQ8/k29Z9P+SHyu8JZpcydUytS16XTMalcKrD11emB+Y3m1dXDTdppO5+a/lZZc/Nzr2cpZWpVmqXaYnx8/wBnT5/hnLeT9ETUZqqZlS0zFZW2qtWNrN7rxhy6bPVZebaXm2u/1Ga6tOHW/sV5O1Sq0tWZdJVS9iWpvJx9VXu9cDRlqrMppacuktNUultKqqNjf5feenXz5MrmOVlmzmmN5OZdVdJcLTGqqWMfPnLPNo/ceSitMW9k63pdSrXVSzXVutCHp4850UYvTipqWlas3St3a5zxJkqYsyWsuZVnFmVZxV0Wl3Vps1jN4u3GmZZbU/8Ab0szUy826s1S1No83PBW+5omdZCyWqzMxlZacWlnG0bbWs9dnN9Zqmwnyc3MZVZZbMzYtKWy3l+rOW2bP1mh5jMy3aaqmVaqdWpW5rPO33xWPqLP7V57NLVfKLOWmrC0662y3EDFNgsxaWyidThvTdGnDVMh/ayF2PMeuk/ErLOl/SNSqrMVr1TU0+r1Wc3oMGWTpbVfSLsslOz1vuNX8JGDKEaZV/3TUtTVU0mrFdbzYrTJkyTWpZsovdGX8Nh6+cl3VzlW1dq0d3D6P7mXK5EjNzGWmqXpKsumpryqze8z1/drf2Y8qlzbvlpbUssymjVa7Uqx9fq1fQZ3mT9aXhW8q4qqbvnib8qyKUytTT0VapruLC+1zmafkCrLZlqqZbt7VVe0ZtaYcsd6aVza1NrN2dkzQmNM1bt3Fx6VY2zMnXRznVbS60bCiZklOFmVdqnS1e1vGdajHNVqtFuztfV0TJGpartWk2HaumuMpqmWpmuriVdKrS0sJnnS5lOj2OIEtbiuMW9n0by0sZpjNV9G2628tpuarFvFCzW0lXi9d85LY1GWZGrWM7y9U9DKb15lpMjPL0TNaiqK8XSppag6trfCLGTMvXquqZaLmlGjJUiEqZst1SyCzNVeqWCh5XFX8lboaHlzKcPHHrM7QYlWES72WH5ObF2lEZcXWL8lTDdxLVUSLa2rEtXi8VIpciXqv0nSOVN1veLCA7Q2fhCGqaxnSU8VUiRTW+Its7XREjAppZjcVFcJd3/Ivfa+Ez5//alSVYx5dPppVete0jIsel2jZly5zDrGFkZTnXTislTqdYdsqMsYXrpohI4pXvH2uKKhgCMFMq7T5mJOc5WktdpkyJ869Vdu5vR/9x99g/R7DN+X9z4h8xyKuV5TOw05NTi9pOXRsvc8s+uQymXTVV2mZdr1wq0uY9vw/wCr5n6v75/+PVTpLq3f8sJoSX0aatVl6PohA8eRlqs11l0dPFe+2Pm9HSLo5esu9VVss3w93ObtebHp2LVStK01Xr1XR4hoj4Vws13FTMp3vzPJXLFaplZV1b16ltLpftGhlC7OGlmZ8X7Qr14PTdqXstSWM20vRpPJWet3D2+IqNI5QVaqaelXu+b0/UZo9lZirpXei13SxWwgXS6aarrdZuthPFXLbtV1usuteVeIFq8pVXcLXdP9K83nM0exL0qd1e1dtLLF0bzYryt+q08BuUlqxdZZt6r8LPq4sLUy27iW62FX0tq5e+4mGPN+dXlaVknJmV+EzpMlp0nNylmNenTGaW1MtV52axWjzQjzH5xkcnZdyxnJsjJ8obJZCtMnTlRmky1WqpquaExoUtzc9nOfcPlR8h+SMvnTMrny6Z86ppkyXOnK0xmWmpl5oc3o9B4uV/NzL8CXk7JOWMtl5NU0xsmmTZfg81pjVNMny5UqEZzXVhCPPCyXDmOfLjeT2/B8nDhP7/uPhnKTymZZchaVVaatKY2kzNpW/wBrDM0MLcYj7LyH80iSVm+H+D5XUy5mZLyvKskaWq1VKyy5cYNbd54+an6zVy582MrKWznlJb3VbM5RLppVVlrdbJvQirDqnPxten/6eG4+Gnp8kzGlssxWpaWysp9Df5o2xS8q2aZlMzZvZuEBYfNHlcv6PKsnbZqvNq089pny5f8AFb8/C/u6X5I/Kp2l01SestOr9tLWL54HcplrTJecXNs3Tqu01NS3m+vzHzLkj5CcoZNU3kZy6yzae1zepvtOt5NlvLXNz8nVlp0Xw4al+89XD+3j+Scbdj2HnZ76SXVe1Fa9S2q/5fcY83IW7TJVlzn0kpVZbv3elbYfiVy8rWXdZpkqWrUtTV/U1ZlkKrIsvP5vOPKyhWl5xZ2caXMZVXOrUy6zfbTvFYDyasMxab30b3b1S4Wtpb0d5mynI1Vrs5lpVVvXlutUvoh/P1WDJ5T+nLZv/ts1Uy7etj5vRzGOdLZVpmLMVm0lnVXdGnzQ5oej7QRE6U7LUsyXdaZeoaq61NNTRjd9FnvPOyuTNvNLzbaTVVLtdn7S6ZNZVpWZMu1YmvM15mbzRqW2q30eewh4teqnS9XyiqtVW01gajHCS2ezkyWrVKq1S3VqVVpjVMtkL14mZNlsv0cxlb/xXb3v5vRHZPRmxmYVzcxf/G/ab0wp+yJl8NzdKzFmLdVf6dN3Fx9ouxXjTZeR1UzlpfFLuTFVl1mWXzNi9NvpEnRyNVvTmXFV9Ne6p7MZ8umplZdplZabzXqrI3bft95iTKJTKys0unOTKVZsSqzMuKz0c9tmic63L/28bLJUqlWkzJjNnpa5uu6tVLaOlZ64lngulnGXepbVvQ/sbp0iVMpurs06N3R5ujH0nnTcml55parT5NWxNdZmnK3uVYGa1KzvJZWZlZWwreTVq+wy1zWqur5NqWxatV3WPQnZKy1Us3RutiX7tYoSRNl5zCzN5Rs5pVUr67POq85mxrWBpszSl1XtGqnpea0peLezxVbVLau8ejGM1sUtbu3s/eYZ+UMt7N3alXHpNV+XpFbitpzN/Tu3tLR6JndNndLpbNhZabzaV7FdvechkXWbtVfkRqM+YXVK8yvR/aaoo3tN3/gSYjaNLa2jT+Yw1UktdZu1/AsVbWYsqbDSvVa8KzbLN1l7wqmfFmXEZbeOImyZMWlrrVGaEzZ7RmrFU3WL5SN5Po4iqMP06R6EFVadWm6XjC1bLQtp4p/krVR4Q4qOkjlRCHFIR0bw7QFt4qwmkS69bqlUF1hotSLFuKgM+Vwb+mUpk+tiNkI8VBTxeJ11qVlaNN2mptbCCwu3qd4smybyhPW637iYusbwXEusO8Fpu0lcalVVw1bRdmv9iRp5VjFkKiLOKSTnG3b/ADXz8z4W2k2ZvaqrVd4+o7iXyvVUrZzdve7o9o+Z/I1qc83/AK9bDe0tE6RcvZWXF+ntW/mer47/AI8Xj+XhvKuxhysy3qpnWp6V3zfwWQ5WbaW9ea7VT0mjdOR8Ju4eld2tqMfwEeZTew9W72rMJvs5ecdpI5Ya7eZlq11Vtb64jz+Vr2Kq7eqpmN2rYROIk5c2lTqrequ6voLvDFbSXj8fMOyebtZPKDLixaNxfhaHeC8qt0l2Vur0aoXdL6vOcgnKTU+Tam9qzGq95MeUG1ary6H6bSdl83Y+HUtd1V+hpWlVW8t2zz3vNAmHK7LUrK2zdXOa2Kvo89n9zkky3jR/Pi0h8rZbyrur8K8eYanR1zcpVXlzisujdl6X2RF8ZNo1NVpVbNX2NpcxyHjFulTq3aeOPQE3LdltbS6vwk7L0dd4bManR1rq/phb7hcpy3RZsOK6vwt+ByfhzU7PW/eL4e1N1aup/PutJ2Xo6+HKjKuJmWnV6oseU2ZqVmb0tsLNiVngcomWquJd2n87Ajl9N69s1LT2ecdjo6mOWtrNtN5Pd1vt+0heUqaf1U/qw+/Ec5JyvjR6O0I03e2WHY6unblTW3s31S6Xy7m8PWXydNOtT9vut+7jGnrTVvUVf7FL5S2izdFU/dH8OYdl83eR5eVlwq3Rus3Zj3la8oS5lWcl1at6Xx5/TE4yOUbTdVZfwkxyqrSbj79oanm6+jJqmaXnJLXW8izS1qW6t1Y2N9lmkWzUl6OVNhVVqRW61VEI/fzd/FpldOFur0dm2ziA7ZYtOizbOLd/MadK6N+T5q3pMyXM9pdpbor6CjKkmM16SzLdpZWlt+drc7WHjJl68KOvKVOFtxV7WsXYvWtuUyFzkjycylVmVeSw/R01M1m1Hz833hBJc29Lzl2paa85LWmlm8m1sWt+3mpMkvlmYuk3w3QblFWxLLmdJam7TdLzebzjTK3QlMrKq6S6S06Oi0uMIr6/SZcv5OZrvkWvM1NTUtUrLTethpW/j6yuOVS20VVsN27dw3aYw9DEpOlYfKLtLe0dKq2rnYfR9sU7JZl5mlsqrpS822GpV+teemPo5jJPyRlVmXOKyy9Glruj6Y1evzaR7MILMVlzi+Uu+UVet6Ye+wrnIy6Mtv1dFrCWRqcnl1NStTNo1VKuLFx5zPPztN1la8t1dnR8+G7b1j0pt66y3tVUq3uf0UnlZbNlS2VZnk+klMtmar+o39jFalQ2WzP6kvs3dn6zz+U8ozlNKtrU6TNrVcxvmwlsutq01Ytbj6zzZqXmpbS1atUzW4qmzdG9VtcR+wzVzLt1Wqw9nV1TXRiqp7HEPcV1Lhb4eNYzjesqzGxZvRpxa1LeoWL7LaO0tVNPr9foNL08Xv8AYrjD4tXSIuqlnaN7S0dGr7Bq12d0bNapS8r4gsxM2N1jLZeXj8x58rSpu1aPwlUFpM1YakthFmZVpwqULH9RfKa8raOEsKvyeq83H5Fizb1P7RobxW0ym9+lTpjn+WiKA8SqTNVmbE2kt26WTI9XqmpEKxCtxdFi9Iy8bIAzN0ez2SXiEY8YhFbZNhimcpYsAZeKV3SWCiC4Syynj+QWXe0uyNGPFJMV4UIhCJFRMJnHEDzx2e58nI3ZlVOJdLV76j1ovtKuzVrHj8h1MrNV/Upp6NPZ+03zHbot0jtxv04cvy0N1f8AIslvSt7/ABMS1cU947VbRuVMeitNVWzh6X3dEXOqusurSzLvKefFm0al636SYM2s3au9KpsJNTGyOVXrtTays7XR4ZUq6vHS0jBBW1W6zr3jRXZ7TK35DTHpeG1aq7LM3DFMye1V5rvWM6I2i1PWq3WjaDTacTN+kmmNa5Qytdq6XHOpLZe2G9hp2jJLn6StvcUlbTGa83HuGmNsZ+G63bb4fMNCfTdWrrN/B50H6TbNX8k5zZVSauPTlZUy1Xl3rv8AYhcsarFh2W7zzEbVb4e4K9JmWre7Vg0x60MsXSZerVT2WCGWKul0aav0xPHzoK/S6rDTrHrPll6rF1v+RYT+KjymnbWLa/aLGZVpNx7idl6vYafrLVq1fp5hWmrpHkRf/a73j18VfpGnV6HhGqw3hW0x5lba1PH2ixdtZuyveNOr1YZTxUJDKWp62kefCZtfCRXtN+I0xvjlVWr0mYaGV7UvtMp5rwX/AGvELHhaR2Xq9KOV7W9V+Y3h13FvHm53R47QtutdYdk6vThlOli6382mmTlK6q7X+R4lW03aIzy6zdpfhGp1dRKy2m7UpE3KV1l2uG7jl6+txtRH8I6ReydHtTJkpmxdVcO7ArnZNKbCs7apb90LDyoZW+t2toaGVNrbxNi9bFroqturhq0dXCxU0laqrtLLe0tb+97zk+GtrMT4VLbFe6TD6a+1LZKuqI2TL0ei3wmmE+VtdVhWjtN1mVu4lNrI2TYmzn6t0VZTaymtlbpUr0SqZFtW9surDDWLK0pXDV1qlxbJkXi8bsrw3qla7i/cZYGLG4rppFi2Fah3iI5G1iTXWk2S8qVlvU1GOEaVxN2v4K0TWNSsWa9eTFcS7v8AwFO90jz5EKdJqelhLFnst3FTpK2I3OTGL3l8VCzql/xKoZZhu1VYS+EwumJSI6sY2nKszEa2frdZV4YsqWGs2hHjd/2BpnFWEWa3Z6RrULCJMYXv8vhKZuUKv+wyzNImtY8aIQJJged2eryRG70m1f5N8IM2jV8J5nJ8Gp62rUa4VazHWfhy5flfCDLo3dX9vMNW2z0abxnaLaTMRSul8TGmWqrikXOrrdK78JkZl2W3h1jqqvH6iaY0K+12f8QebhxdVW+HmKlfZ3RW6SkF8Zm0zL0f06JEI8UqZ4R6KhnNoLi55myLGbtMJYusI0F1iai2E3iklprGewaxdkjWGhM1vhHg3FJTFgsBi/O7LfgpKzDPnOOIDRi2zvdwF+cIt1aihelukwhtBpde4UhosuJmKowXhmJhBF0V7ID5wmLrwpWsxeP+Ai+qBar63w3f72ixmccWlecIi1RNFqxJhHinikqg3RCMQLYtxSLFukIvaJjDjiADpMUmrV3Sh26IlQGqLbJFuypnqFd9oamNNXFNRVMh0ipZlX+QVaw1cWwJhHV495TCPRBn6I0WszavaBZzaKlFpEWJpjTGa3CkVtrN8O7zGZXJhHiopjQr8Uks2t8Kmeohn4vDTFrKraKkQkL0ePvKYsFY0xc0hdFmKM0TFiKgpqOOIlcekNBuLxEYgJGDFlbaosGCoCt4aytxtDQipEWFzgaO0MV7Foiy2ZaVEusM0NoBml6xNnG0V1trdoiE3ogU2DQUqizERZjEpj08lmMqrSWwmtdvbxhyebdU0wivROkrNjRnekRBuKipY7vVGDOLrVJqXa7RSsRlBi3OcVKFXW6xXaRUExZb/rUCrxUK8eOIiwdgLrNkrjDioGfjELxogPbwzBnF4YSzikIxAZpmrULGY212gjHWGg3FNQaEJjf7f4i5yoZ+t2f3FfGEgZRhKm7JCzeKf4Bh1i3DExjvFdXFIQiwD206QucIjEhY8UgWQmbNXWIqbZ7QsSAHzjawM7a3H4Ff4kWhVte1vBXxaVW8XQt6X4E0Wq4NHV/aJV0hYx4ulMPGIrQIjAiDcUgCsTCIsWIAeMav9iIsVkRbpAWVEVFdXFgWmVw8W4qCMeKisiPGE0q+3i6FZRGIW9IymLotUKV1ERcGLbSVbiooZyYMaMOzcVEQiLVxSKzhVjREgwsYhaBZFhWjxUKRaBMeLxMYiWjGREQtIt4sCMQEiIx4HjGbrbq9weMZutur3HG846+de1beL5c453w+brbq9wQy+brbq9xfSL511UufxeLVnqch4fN1t1e4aHKU7X3V7i+zPlXXQm0kQnbJyfjSf7T3L3BHlSf7T3L3F9onjXXq/FLE27S/q7JyPjif7Tcl/tCPK8/2m5L/AGl9onjXW1bVXVb/AIJrOR8bz/abkvuGXlnKF/qbkv8AaT2i+NdbBqsOjiq/xgM1WKpeqrXet/ByHjrKfax7MvuDx1lHtP8A8cv9pfaJ43+nXKlWk3w/laEYU7Xa7zkfHWUe03Jf7SI8sz/abkv9o9uJ412UuldXokRipx3jnKPabkv9oeOZ/tNyX+0e0PGuvaK4SbOLxx3jif7Tcl/tJjyxP9pup3E9YvlXYXdkW1TkYcsz/abkv9pPjrKPabkv9o9YeNdbVsk1ccQOR8dZR7Tcl/tCHLGUe03U7h6w8a67jSIrOS8c5R7Tcl/tI8cT/abkv9o9YeNdbxpERjxUclDlef7Tcl/tJjyzP9puS+4esPKusWPFJMH4vHI+N5/tNyX3B44n+03Jf7SesPKuui3RFqOTjyvP9puS/wBpHjef7TdXuHrDyrrouRGYcn43n+03JfcHjef7Tcl9w9YeVdUz8cQIrOV8bT/abkvuDxtP9puy+4esXyrrIPwpFhynjaf7TdXuCHKs/wBpuS+4esPKurg5EWOV8bT/AGm5L7g8bT/abkvuHrDyrp2FqOZ8aT/abqdxPjWd7Tcl9w9YeVdNBiI8XTmfGk/2m6ncHjWf7TdXuHrDyrp6iInM+NZ/tN1e4jxnN9pur3E9IeVdPEiMFOa8aT/abq9weNJ/tN1e4vrDyroowJhE5vxlN191e4PGU3X3V7h6Q8q6UDmvGU3X3V7ghylN191e4esPKuktItOc8ZTdfdXuI8ZTdfdXuHrDzrpLQOchylN191e4PGU3X3V7iekPKuiCMeic54xm6+6vcT4ym6+6vcPSHlXQwiFpz3jKbr7q9xHjGbrbq9w9IeVYwADi7gAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA//2Q==\n",
      "text/html": [
       "\n",
       "        <iframe\n",
       "            width=\"800\"\n",
       "            height=\"600\"\n",
       "            src=\"https://www.youtube.com/embed/60ItHLz5WEA\"\n",
       "            frameborder=\"0\"\n",
       "            allowfullscreen\n",
       "        ></iframe>\n",
       "        "
      ],
      "text/plain": [
       "<IPython.lib.display.YouTubeVideo at 0x1f655641c48>"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print('\\033[1m'+\"please select the songs by choosing the indexes (e.g) 0,1,2,3,4\")\n",
    "song_input=int(input())\n",
    "YouTubeVideo(df.loc[song_input, 'Links'].split('=')[1], width=800, height=600)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## To save the dataframe into HDF Format and CSV format"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-07-23T21:16:19.192056Z",
     "start_time": "2020-07-23T21:16:16.878338Z"
    }
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\jpravijo\\Anaconda3\\lib\\site-packages\\tables\\path.py:155: NaturalNameWarning: object name is not a valid Python identifier: 'Name of the Songs'; it does not match the pattern ``^[a-zA-Z_][a-zA-Z0-9_]*$``; you will not be able to use natural naming to access this object; using ``getattr()`` will still work, though\n",
      "  check_attribute_name(name)\n",
      "C:\\Users\\jpravijo\\Anaconda3\\lib\\site-packages\\tables\\attributeset.py:464: NaturalNameWarning: object name is not a valid Python identifier: 'Name of the Songs_kind'; it does not match the pattern ``^[a-zA-Z_][a-zA-Z0-9_]*$``; you will not be able to use natural naming to access this object; using ``getattr()`` will still work, though\n",
      "  check_attribute_name(name)\n",
      "C:\\Users\\jpravijo\\Anaconda3\\lib\\site-packages\\tables\\attributeset.py:464: NaturalNameWarning: object name is not a valid Python identifier: 'Name of the Songs_meta'; it does not match the pattern ``^[a-zA-Z_][a-zA-Z0-9_]*$``; you will not be able to use natural naming to access this object; using ``getattr()`` will still work, though\n",
      "  check_attribute_name(name)\n",
      "C:\\Users\\jpravijo\\Anaconda3\\lib\\site-packages\\tables\\attributeset.py:464: NaturalNameWarning: object name is not a valid Python identifier: 'Name of the Songs_dtype'; it does not match the pattern ``^[a-zA-Z_][a-zA-Z0-9_]*$``; you will not be able to use natural naming to access this object; using ``getattr()`` will still work, though\n",
      "  check_attribute_name(name)\n"
     ]
    }
   ],
   "source": [
    "hdf=pd.HDFStore(r'C:\\Users\\jpravijo\\Desktop\\Anaconda\\youtube.h5');\n",
    "hdf.put(inp,df,format='table', data_columns=True);\n",
    "df.to_csv(r'C:\\Users\\jpravijo\\Desktop\\Anaconda\\youtube.csv',mode='a');"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## To open the CSV which contains the Dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-07-21T14:53:35.042235Z",
     "start_time": "2020-07-21T14:53:32.581798Z"
    }
   },
   "outputs": [],
   "source": [
    "os.startfile(r'C:\\Users\\jpravijo\\Desktop\\Anaconda\\youtube.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-07-05T07:23:17.242139Z",
     "start_time": "2020-07-05T07:23:00.927940Z"
    },
    "heading_collapsed": true
   },
   "source": [
    "## To open the HDF which contains the Dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-07-21T14:53:40.279973Z",
     "start_time": "2020-07-21T14:53:40.256470Z"
    },
    "hidden": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['/Alan Walker Faded',\n",
       " '/Alan Walker Faded song',\n",
       " '/dusk to dawn',\n",
       " '/dusk to dawn song',\n",
       " '/martin garrix ',\n",
       " '/martin garrix top 5 songs',\n",
       " '/martin garrix top songs',\n",
       " '/matin garrix animals songs',\n",
       " '/rowdy baby songs',\n",
       " '/sia cheap trills']"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hdf=pd.HDFStore(r'C:\\Users\\jpravijo\\Desktop\\Anaconda\\youtube.h5')\n",
    "hdf.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-07-21T14:55:02.679126Z",
     "start_time": "2020-07-21T14:55:02.646624Z"
    },
    "hidden": 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>Name of the Songs</th>\n",
       "      <th>Channel</th>\n",
       "      <th>Links</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alan Walker - Faded</td>\n",
       "      <td>Alan Walker</td>\n",
       "      <td>https://www.youtube.com/watch?v=60ItHLz5WEA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alan Walker - Faded (Live Performance)</td>\n",
       "      <td>Alan Walker</td>\n",
       "      <td>https://www.youtube.com/watch?v=mIxlvVlOIS0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Alan Walker - Faded (Lyrics)</td>\n",
       "      <td>7clouds</td>\n",
       "      <td>https://www.youtube.com/watch?v=qdpXxGPqW-Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Faded - Alan Walker (Lyrics)</td>\n",
       "      <td>DopeLyrics</td>\n",
       "      <td>https://www.youtube.com/watch?v=reuYXbHOc1c</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alan Walker - Faded (Where are you now) Lyrics</td>\n",
       "      <td>Best song lyrics</td>\n",
       "      <td>https://www.youtube.com/watch?v=dnZItt33cvI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Alan Walker - Faded (Reworks)</td>\n",
       "      <td>Hidden Book</td>\n",
       "      <td>https://www.youtube.com/watch?v=avytvFalI6o</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>ALAN WALKER – Faded / Different World feat. Ju...</td>\n",
       "      <td>KKBOX</td>\n",
       "      <td>https://www.youtube.com/watch?v=n03IDJcsy5g</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Alan Walker, Sabrina Carpenter &amp; Farruko  - On...</td>\n",
       "      <td>Alan Walker</td>\n",
       "      <td>https://www.youtube.com/watch?v=dhYOPzcsbGM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>New Songs Alan Walker 2019 - Top 20 Alan Walke...</td>\n",
       "      <td>Listen To Music</td>\n",
       "      <td>https://www.youtube.com/watch?v=WWCsGEarExg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Alan Walker - Faded</td>\n",
       "      <td>Conor Maynard</td>\n",
       "      <td>https://www.youtube.com/watch?v=IgCphQCkHSk</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Faded Alan Walker - Frozen Music Video</td>\n",
       "      <td>Disney Princess</td>\n",
       "      <td>https://www.youtube.com/watch?v=B6jsddn01Cs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Alan Walker feat. Iselin Solheim - faded Live</td>\n",
       "      <td>PERCY MUSIC</td>\n",
       "      <td>https://www.youtube.com/watch?v=T2DbC5DR7pU</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    Name of the Songs           Channel  \\\n",
       "0                                 Alan Walker - Faded       Alan Walker   \n",
       "1              Alan Walker - Faded (Live Performance)       Alan Walker   \n",
       "2                        Alan Walker - Faded (Lyrics)           7clouds   \n",
       "3                        Faded - Alan Walker (Lyrics)        DopeLyrics   \n",
       "4      Alan Walker - Faded (Where are you now) Lyrics  Best song lyrics   \n",
       "5                       Alan Walker - Faded (Reworks)       Hidden Book   \n",
       "6   ALAN WALKER – Faded / Different World feat. Ju...             KKBOX   \n",
       "7   Alan Walker, Sabrina Carpenter & Farruko  - On...       Alan Walker   \n",
       "8   New Songs Alan Walker 2019 - Top 20 Alan Walke...   Listen To Music   \n",
       "9                                 Alan Walker - Faded     Conor Maynard   \n",
       "10             Faded Alan Walker - Frozen Music Video   Disney Princess   \n",
       "11      Alan Walker feat. Iselin Solheim - faded Live       PERCY MUSIC   \n",
       "\n",
       "                                          Links  \n",
       "0   https://www.youtube.com/watch?v=60ItHLz5WEA  \n",
       "1   https://www.youtube.com/watch?v=mIxlvVlOIS0  \n",
       "2   https://www.youtube.com/watch?v=qdpXxGPqW-Y  \n",
       "3   https://www.youtube.com/watch?v=reuYXbHOc1c  \n",
       "4   https://www.youtube.com/watch?v=dnZItt33cvI  \n",
       "5   https://www.youtube.com/watch?v=avytvFalI6o  \n",
       "6   https://www.youtube.com/watch?v=n03IDJcsy5g  \n",
       "7   https://www.youtube.com/watch?v=dhYOPzcsbGM  \n",
       "8   https://www.youtube.com/watch?v=WWCsGEarExg  \n",
       "9   https://www.youtube.com/watch?v=IgCphQCkHSk  \n",
       "10  https://www.youtube.com/watch?v=B6jsddn01Cs  \n",
       "11  https://www.youtube.com/watch?v=T2DbC5DR7pU  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hdf.get('/Alan Walker Faded song')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "hidden": true
   },
   "source": [
    "THANK YOU "
   ]
  }
 ],
 "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.7.6"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}