youtube_api.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# import libraries\n",
    "import requests\n",
    "import pandas as pd\n",
    "import time \n",
    "#from googleapiclient.discovery import build"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# keys\n",
    "api_key = 'x'\n",
    "channel_id = 'UCqlthGjbLIci7i3x2gk8P4Q'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "api_service_name = \"youtube\"\n",
    "api_version = \"v3\"\n",
    "youtube = build(api_service_name, api_version, developerKey = api_key)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "# make api call\n",
    "pageToken = \"\"\n",
    "url = 'https://www.googleapis.com/youtube/v3/search?key='+api_key+'&channelId='+channel_id+'&part=snippet,id&order=date&maxResults=10000'+pageToken\n",
    "response = requests.get(url).json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'kind': 'youtube#searchListResponse',\n",
       " 'etag': 'Cy4t844_yc5axH0Nf6tFKyEVq10',\n",
       " 'nextPageToken': 'CAUQAA',\n",
       " 'regionCode': 'CA',\n",
       " 'pageInfo': {'totalResults': 150, 'resultsPerPage': 5},\n",
       " 'items': [{'kind': 'youtube#searchResult',\n",
       "   'etag': 'JfursRI1YoYhJ399wiAAFT-x2dY',\n",
       "   'id': {'kind': 'youtube#video', 'videoId': '_0oHMwk6IY8'},\n",
       "   'snippet': {'publishedAt': '2022-12-28T19:15:48Z',\n",
       "    'channelId': 'UCqlthGjbLIci7i3x2gk8P4Q',\n",
       "    'title': 'First Impressions of Podgorica, Montenegro 🇲🇪',\n",
       "    'description': 'First Impressions of Podgorica, Montenegro #montenegro #budva #podgorica #balkans Follow me on Instagram for real-time ...',\n",
       "    'thumbnails': {'default': {'url': 'https://i.ytimg.com/vi/_0oHMwk6IY8/default.jpg',\n",
       "      'width': 120,\n",
       "      'height': 90},\n",
       "     'medium': {'url': 'https://i.ytimg.com/vi/_0oHMwk6IY8/mqdefault.jpg',\n",
       "      'width': 320,\n",
       "      'height': 180},\n",
       "     'high': {'url': 'https://i.ytimg.com/vi/_0oHMwk6IY8/hqdefault.jpg',\n",
       "      'width': 480,\n",
       "      'height': 360}},\n",
       "    'channelTitle': 'Nadir On The Go',\n",
       "    'liveBroadcastContent': 'none',\n",
       "    'publishTime': '2022-12-28T19:15:48Z'}},\n",
       "  {'kind': 'youtube#searchResult',\n",
       "   'etag': 'N2spKsaMulXjf4I_jKvvAgfHhMk',\n",
       "   'id': {'kind': 'youtube#video', 'videoId': 'dew6UxYBl2o'},\n",
       "   'snippet': {'publishedAt': '2021-05-24T15:00:24Z',\n",
       "    'channelId': 'UCqlthGjbLIci7i3x2gk8P4Q',\n",
       "    'title': 'Ancient Greece&#39;s Most Stunning City?',\n",
       "    'description': 'Another adventure packed vlog from Turkey, this time from the western city of Pamukkale, a place host to ruins from Ancient Rome ...',\n",
       "    'thumbnails': {'default': {'url': 'https://i.ytimg.com/vi/dew6UxYBl2o/default.jpg',\n",
       "      'width': 120,\n",
       "      'height': 90},\n",
       "     'medium': {'url': 'https://i.ytimg.com/vi/dew6UxYBl2o/mqdefault.jpg',\n",
       "      'width': 320,\n",
       "      'height': 180},\n",
       "     'high': {'url': 'https://i.ytimg.com/vi/dew6UxYBl2o/hqdefault.jpg',\n",
       "      'width': 480,\n",
       "      'height': 360}},\n",
       "    'channelTitle': 'Nadir On The Go',\n",
       "    'liveBroadcastContent': 'none',\n",
       "    'publishTime': '2021-05-24T15:00:24Z'}},\n",
       "  {'kind': 'youtube#searchResult',\n",
       "   'etag': 'u6CB9sGBsTyQOdMazuWz2SPaXDc',\n",
       "   'id': {'kind': 'youtube#playlist',\n",
       "    'playlistId': 'PLMQNNpGZnyg5y9xmIrp4FCTaCYiSl8EMy'},\n",
       "   'snippet': {'publishedAt': '2022-02-05T12:25:36Z',\n",
       "    'channelId': 'UCqlthGjbLIci7i3x2gk8P4Q',\n",
       "    'title': 'India- Nadir On The Go - English',\n",
       "    'description': '',\n",
       "    'thumbnails': {'default': {'url': 'https://i.ytimg.com/vi/6qSgNL-3hbU/default.jpg',\n",
       "      'width': 120,\n",
       "      'height': 90},\n",
       "     'medium': {'url': 'https://i.ytimg.com/vi/6qSgNL-3hbU/mqdefault.jpg',\n",
       "      'width': 320,\n",
       "      'height': 180},\n",
       "     'high': {'url': 'https://i.ytimg.com/vi/6qSgNL-3hbU/hqdefault.jpg',\n",
       "      'width': 480,\n",
       "      'height': 360}},\n",
       "    'channelTitle': 'Nadir On The Go',\n",
       "    'liveBroadcastContent': 'none',\n",
       "    'publishTime': '2022-02-05T12:25:36Z'}},\n",
       "  {'kind': 'youtube#searchResult',\n",
       "   'etag': 'jhsP_yVLUJr5JMMfBm2UN2I9zu0',\n",
       "   'id': {'kind': 'youtube#playlist',\n",
       "    'playlistId': 'PLMQNNpGZnyg4kkyvxba7RCilN0oadr1LK'},\n",
       "   'snippet': {'publishedAt': '2017-03-10T00:07:07Z',\n",
       "    'channelId': 'UCqlthGjbLIci7i3x2gk8P4Q',\n",
       "    'title': 'Mexico - Nadir On The Go - English',\n",
       "    'description': 'Must-see videos for any backpacker visiting Mexico.',\n",
       "    'thumbnails': {'default': {'url': 'https://i.ytimg.com/vi/GSy_QtcyKXQ/default.jpg',\n",
       "      'width': 120,\n",
       "      'height': 90},\n",
       "     'medium': {'url': 'https://i.ytimg.com/vi/GSy_QtcyKXQ/mqdefault.jpg',\n",
       "      'width': 320,\n",
       "      'height': 180},\n",
       "     'high': {'url': 'https://i.ytimg.com/vi/GSy_QtcyKXQ/hqdefault.jpg',\n",
       "      'width': 480,\n",
       "      'height': 360}},\n",
       "    'channelTitle': 'Nadir On The Go',\n",
       "    'liveBroadcastContent': 'none',\n",
       "    'publishTime': '2017-03-10T00:07:07Z'}},\n",
       "  {'kind': 'youtube#searchResult',\n",
       "   'etag': 'KeymxizD2OnJ9e-K_a7ySPFlOpo',\n",
       "   'id': {'kind': 'youtube#playlist',\n",
       "    'playlistId': 'PLMQNNpGZnyg49nd6Rnh5Y-6b8GCvkbAo9'},\n",
       "   'snippet': {'publishedAt': '2022-08-17T08:51:04Z',\n",
       "    'channelId': 'UCqlthGjbLIci7i3x2gk8P4Q',\n",
       "    'title': 'Balkans - Nadir On The Go - English',\n",
       "    'description': '',\n",
       "    'thumbnails': {'default': {'url': 'https://i.ytimg.com/vi/BSQOVP_FU80/default.jpg',\n",
       "      'width': 120,\n",
       "      'height': 90},\n",
       "     'medium': {'url': 'https://i.ytimg.com/vi/BSQOVP_FU80/mqdefault.jpg',\n",
       "      'width': 320,\n",
       "      'height': 180},\n",
       "     'high': {'url': 'https://i.ytimg.com/vi/BSQOVP_FU80/hqdefault.jpg',\n",
       "      'width': 480,\n",
       "      'height': 360}},\n",
       "    'channelTitle': 'Nadir On The Go',\n",
       "    'liveBroadcastContent': 'none',\n",
       "    'publishTime': '2022-08-17T08:51:04Z'}}]}"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "response"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'kind': 'youtube#searchResult',\n",
       " 'etag': 'zG_5FPfOa3rJ6oAQrMrQy8LUJ4M',\n",
       " 'id': {'kind': 'youtube#video', 'videoId': 'hlldAJFX6ko'},\n",
       " 'snippet': {'publishedAt': '2022-12-30T10:00:19Z',\n",
       "  'channelId': 'UCqlthGjbLIci7i3x2gk8P4Q',\n",
       "  'title': 'David Beckham used to party on this Historic Island 🇲🇪',\n",
       "  'description': 'David Beckham used to party on this Historic Island #montenegro #balkans #svetistefan Follow me on Instagram for real-time ...',\n",
       "  'thumbnails': {'default': {'url': 'https://i.ytimg.com/vi/hlldAJFX6ko/default.jpg',\n",
       "    'width': 120,\n",
       "    'height': 90},\n",
       "   'medium': {'url': 'https://i.ytimg.com/vi/hlldAJFX6ko/mqdefault.jpg',\n",
       "    'width': 320,\n",
       "    'height': 180},\n",
       "   'high': {'url': 'https://i.ytimg.com/vi/hlldAJFX6ko/hqdefault.jpg',\n",
       "    'width': 480,\n",
       "    'height': 360}},\n",
       "  'channelTitle': 'Nadir On The Go',\n",
       "  'liveBroadcastContent': 'none',\n",
       "  'publishTime': '2022-12-30T10:00:19Z'}}"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "response['items'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "video_id = response['items'][0]['id']['videoId']\n",
    "video_title = response['items'][0]['snippet']['title']\n",
    "video_title = video_title.replace(\"&amp;\", \"\")\n",
    "upload_date = response['items'][0]['snippet']['publishTime']\n",
    "upload_date = upload_date.split(\"T\")[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "hlldAJFX6ko\n",
      "David Beckham used to party on this Historic Island 🇲🇪\n",
      "2022-12-30\n",
      "iejxvmCxpuY\n",
      "Journey to Budva from Podgorica 🇲🇪\n",
      "2022-12-28\n",
      "_0oHMwk6IY8\n",
      "First Impressions of Podgorica, Montenegro 🇲🇪\n",
      "2022-12-28\n",
      "zpMvN-QM87M\n",
      "Glacial Lake in Montenegro&#39;s mountains 🇲🇪\n",
      "2022-12-28\n",
      "tdReiQV2hNc\n",
      "Amazing view from top of Montenegro 🇲🇪\n",
      "2022-12-28\n",
      "DqvMUfWlP3o\n",
      "Treacherous Climb in Durmitor, Montenegro 🇲🇪\n",
      "2022-12-28\n",
      "OgZOa-34Y3I\n",
      "Furry Friends on Montenegro Hike 🇲🇪\n",
      "2022-12-27\n",
      "Bjd6ivDZi0Q\n",
      "Up Montenegro&#39;s Highest Mountain  🇲🇪\n",
      "2022-12-27\n",
      "XsCYFsqONWQ\n",
      "Journey To Bobotov Kuk ,Montenegro 🇲🇪\n",
      "2022-12-26\n",
      "AiFlnAwxl0Q\n",
      "Friendly Albanian knows Bollywood Classic 🇦🇱\n",
      "2022-12-26\n",
      "28s1t0j9mrw\n",
      "DON&#39;T Do This To Dogs in Albania 🇦🇱\n",
      "2022-12-25\n",
      "kxSHlcRc_Jw\n",
      "$0.90 Street Hot Dog in Durres, Albania 🇦🇱\n",
      "2022-12-25\n",
      "7T_Z801GNc0\n",
      "$3.50 Shave in Tirana, Albania 🇦🇱\n",
      "2022-12-24\n",
      "EZ2G369Gi7k\n",
      "Ottoman Relics in Skopje, Macedonia 🇲🇰\n",
      "2022-12-22\n",
      "KnO4jpAHHuM\n",
      "Cliff-diving in Montenegro 🇲🇪\n",
      "2022-12-21\n",
      "Na2AiW3hvAQ\n",
      "A Nuclear Bunker Bigger Than a Palace 🇦🇱\n",
      "2022-12-21\n",
      "nj7yoopmUy4\n",
      "Bus from Tirana, Albania to Skopje, Macedonia 🇦🇱 🇲🇰\n",
      "2022-12-20\n",
      "Zw_v1po-t5s\n",
      "First Day in North Macedonia - Skopje Vlog 🇲🇰\n",
      "2022-12-17\n",
      "PeW7vRTC2tE\n",
      "Tirana New Bazaar - Albania Market Hunt Vlog 🇦🇱\n",
      "2022-11-29\n",
      "ikdjrnVPPNY\n",
      "No One Entered Or Left This Country for 40 Years!\n",
      "2022-11-22\n",
      "HyiqzvOWf3k\n",
      "How did I end up on Albanian News?🇦🇱\n",
      "2022-11-11\n",
      "NCR2elB4NWs\n",
      "Dangerous Hike in Albanian Alps 🇦🇱\n",
      "2022-11-03\n",
      "gsN_g3UfYLc\n",
      "The Albanian Alps -  Theth to Valbona hike 🇦🇱\n",
      "2022-10-30\n",
      "cEYcsrN6c-g\n",
      "First Day in Albania - Tirana Vlog 🇦🇱\n",
      "2022-10-22\n",
      "CyxzEGHcLNc\n",
      "Prokletije Sunset in Montenegro 🇲🇪\n",
      "2022-10-19\n",
      "kzi5qq7LlVw\n",
      "I Hiked from Montenegro to Albania - Peaks of the Balkans 🇲🇪\n",
      "2022-10-06\n",
      "39wjZlnxuWM\n",
      "Dangerous Climb Up Bobotov Kuk - Durmitor, Montenegro 🇲🇪\n",
      "2022-09-22\n",
      "vOlxiLh8Xzg\n",
      "First Impressions of Budva, Montenegro 🇲🇪\n",
      "2022-09-13\n",
      "GDg3l0QPEBM\n",
      "The Future of Travel - eSim Holafly Review\n",
      "2022-08-18\n",
      "lBS04wo6E3k\n",
      "Kafanas Are Lit - Traditional Tavern in Serbia 🇷🇸\n",
      "2022-08-17\n",
      "TlNz8nq1i-o\n",
      "In Nepal&#39;s Dangerous Jungle - Chitwan National Park 🇳🇵\n",
      "2022-08-10\n",
      "oFcz_Vwba_I\n",
      "Fascinating Funeral Rituals in Kathmandu, Nepal 🇳🇵\n",
      "2022-08-09\n",
      "N0KNrk2YCnU\n",
      "Journey Into the Himalayas 🇳🇵 - The Annapurna Finale\n",
      "2022-08-02\n",
      "r8n_OqrK-Og\n",
      "Journey Into the Himalayas 🇳🇵 - Part 1 of 2\n",
      "2022-07-29\n",
      "Jw1i5ClXi60\n",
      "Visiting Nepal&#39;s Ancient Capital City - Bhaktapur Vlog 🇳🇵\n",
      "2022-07-21\n",
      "I6tBr9d-UmI\n",
      "Visiting Prophet Adam&#39;s First Footstep - Adam&#39;s Peak 🇱🇰\n",
      "2022-07-13\n",
      "89pCHrEtD6Y\n",
      "World-Famous Ella Train Ride - Sri Lanka 🇱🇰\n",
      "2022-07-11\n",
      "ksE5SflUgiU\n",
      "Face to Face with Wild Elephant Family - Udawalawe, Sri Lanka 🇱🇰\n",
      "2022-07-08\n",
      "awKWqzSPLa8\n",
      "Venomous Snakes  The Wildest Beaches - Sri Lanka  🇱🇰\n",
      "2022-07-03\n",
      "zvy3ZaVIfPY\n",
      "First Impressions of Nepal - Kathmandu Day 1 🇳🇵\n",
      "2022-06-29\n",
      "5zDr5HhBQi0\n",
      "Agra Vlog - The Mughal Empire&#39;s Story  🇮🇳\n",
      "2022-06-26\n",
      "dfH5c429gIk\n",
      "First Impressions of Jaipur, Rajasthan | Pink City Vlog 🇮🇳\n",
      "2022-06-09\n",
      "f2uo7rYE3-g\n",
      "Himalayas Sunrise - Annapurna Sanctuary 🇳🇵\n",
      "2022-05-20\n",
      "uk6PY3v3038\n",
      "Is it Safe to Travel Sri Lanka Now? 🇱🇰 - Shocking Reality of Tourist Life in the Crisis\n",
      "2022-05-09\n",
      "oHpLkdwBGEU\n",
      "First Impressions of Jaisalmer - Rajasthan Vlog 🇮🇳\n",
      "2022-04-20\n"
     ]
    }
   ],
   "source": [
    "for video in response['items']:\n",
    "    if video['id']['kind'] == 'youtube#video':\n",
    "        video_id = video['id']['videoId']\n",
    "        video_title = video['snippet']['title']\n",
    "        video_title = video_title.replace(\"&amp;\", \"\")\n",
    "        upload_date = video['snippet']['publishTime']\n",
    "        upload_date = upload_date.split(\"T\")[0]\n",
    "        \n",
    "        print(video_id)\n",
    "        print(video_title)\n",
    "        print(upload_date)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'kind': 'youtube#videoListResponse',\n",
       " 'etag': '3l3lL0uCKlMXaYFRlC0x5I2hJNc',\n",
       " 'items': [{'kind': 'youtube#video',\n",
       "   'etag': 'UcnDytt23-i76jFHwFRATsMR5rU',\n",
       "   'id': 'oHpLkdwBGEU',\n",
       "   'contentDetails': {'duration': 'PT13M1S',\n",
       "    'dimension': '2d',\n",
       "    'definition': 'hd',\n",
       "    'caption': 'true',\n",
       "    'licensedContent': True,\n",
       "    'contentRating': {},\n",
       "    'projection': 'rectangular'}}],\n",
       " 'pageInfo': {'totalResults': 1, 'resultsPerPage': 1}}"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# make api call for video duration\n",
    "url_video_dur = 'https://www.googleapis.com/youtube/v3/videos?id='+video_id+'&part=contentDetails&key='+api_key\n",
    "response_video_dur = requests.get(url_video_dur).json()\n",
    "response_video_dur"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'PT13M1S'"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "response_video_dur[\"items\"][0][\"contentDetails\"][\"duration\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'kind': 'youtube#videoListResponse',\n",
       " 'etag': 'yUGuOwH2NbA8hrdqhhDUnpL_31k',\n",
       " 'items': [{'kind': 'youtube#video',\n",
       "   'etag': 'FB11mqknCQqTIKcFq1POmk1OQzo',\n",
       "   'id': 'oHpLkdwBGEU',\n",
       "   'snippet': {'publishedAt': '2022-04-20T15:00:12Z',\n",
       "    'channelId': 'UCqlthGjbLIci7i3x2gk8P4Q',\n",
       "    'title': 'First Impressions of Jaisalmer - Rajasthan Vlog 🇮🇳',\n",
       "    'description': 'In this jam-packed Rajasthan vlog, I visited India\\'s golden city of Jaisalmer. First I went to India\\'s only living fort, the Jaisalmer fort, and explored the surroundings and viewpoints. Then we went out of town into the desert for some epic sand-dune adventures and a camel safari.\\n\\nFor more details on Classic Tour Packages & Desert Camp in Jaisalmer visit:\\nhttp://www.classicdesertsafaricamp.in/\\nor contact Mr Vikram: 7062014150/7296944150\\n\\nFollow me on Instagram for real-time travel updates:\\nhttps://www.instagram.com/nadironthego/\\n\\nMusic used is licensed from Epidemic Sound. Use this referral link for a discount: 🎵\\nhttps://www.epidemicsound.com/referral/s60tta/\\n\\n\\nIf you need an e-sim for your trip, check out e-sim packages from Holafly: 📱\\nhttps://bit.ly/3R8zjY7\\nUse the coupon code \"nadironthego\" to get a 5% DISCOUNT on your Purchase.\\n\\nGear:\\nCanon 80D\\nCanon 10-18 STM lens\\nCanon 18-120 STM lens\\nRode Videomicro\\nSamsung Galaxy S21 Ultra\\n\\n0:00 The Golden City\\n1:03 A Walk through town\\n1:33 Rich man\\'s crib\\n3:17 A \"living fort\"\\n5:37 Dusk Cinematics\\n6:50 ouch\\n7:20 in the real desert\\n8:15 Look at this guy!!!\\n10:26 Off-roading adventure',\n",
       "    'thumbnails': {'default': {'url': 'https://i.ytimg.com/vi/oHpLkdwBGEU/default.jpg',\n",
       "      'width': 120,\n",
       "      'height': 90},\n",
       "     'medium': {'url': 'https://i.ytimg.com/vi/oHpLkdwBGEU/mqdefault.jpg',\n",
       "      'width': 320,\n",
       "      'height': 180},\n",
       "     'high': {'url': 'https://i.ytimg.com/vi/oHpLkdwBGEU/hqdefault.jpg',\n",
       "      'width': 480,\n",
       "      'height': 360},\n",
       "     'standard': {'url': 'https://i.ytimg.com/vi/oHpLkdwBGEU/sddefault.jpg',\n",
       "      'width': 640,\n",
       "      'height': 480},\n",
       "     'maxres': {'url': 'https://i.ytimg.com/vi/oHpLkdwBGEU/maxresdefault.jpg',\n",
       "      'width': 1280,\n",
       "      'height': 720}},\n",
       "    'channelTitle': 'Nadir On The Go',\n",
       "    'tags': ['thar desert',\n",
       "     'jaisalmer vlog',\n",
       "     'thar desert pakistan',\n",
       "     'thar desert rajasthan',\n",
       "     'thar desert documentary',\n",
       "     'jaisalmer tourist places',\n",
       "     'jaisalmer tour',\n",
       "     'jaisalmer',\n",
       "     'rajasthan sand dunes',\n",
       "     'rajasthan camels',\n",
       "     'rajasthan safari',\n",
       "     'jaisalmer rajasthan',\n",
       "     'jaisalmer fort',\n",
       "     'first impresions of jaisalmer',\n",
       "     'jaisalmer fort drone view',\n",
       "     'jaisalmer fort tour',\n",
       "     'jaisalmer fort hotel',\n",
       "     'jaisalmer fort guided tour',\n",
       "     'jaisalmer fort inside',\n",
       "     'jaisalmer vlog in english',\n",
       "     'jaisalmer tour vlog'],\n",
       "    'categoryId': '19',\n",
       "    'liveBroadcastContent': 'none',\n",
       "    'defaultLanguage': 'en',\n",
       "    'localized': {'title': 'First Impressions of Jaisalmer - Rajasthan Vlog 🇮🇳',\n",
       "     'description': 'In this jam-packed Rajasthan vlog, I visited India\\'s golden city of Jaisalmer. First I went to India\\'s only living fort, the Jaisalmer fort, and explored the surroundings and viewpoints. Then we went out of town into the desert for some epic sand-dune adventures and a camel safari.\\n\\nFor more details on Classic Tour Packages & Desert Camp in Jaisalmer visit:\\nhttp://www.classicdesertsafaricamp.in/\\nor contact Mr Vikram: 7062014150/7296944150\\n\\nFollow me on Instagram for real-time travel updates:\\nhttps://www.instagram.com/nadironthego/\\n\\nMusic used is licensed from Epidemic Sound. Use this referral link for a discount: 🎵\\nhttps://www.epidemicsound.com/referral/s60tta/\\n\\n\\nIf you need an e-sim for your trip, check out e-sim packages from Holafly: 📱\\nhttps://bit.ly/3R8zjY7\\nUse the coupon code \"nadironthego\" to get a 5% DISCOUNT on your Purchase.\\n\\nGear:\\nCanon 80D\\nCanon 10-18 STM lens\\nCanon 18-120 STM lens\\nRode Videomicro\\nSamsung Galaxy S21 Ultra\\n\\n0:00 The Golden City\\n1:03 A Walk through town\\n1:33 Rich man\\'s crib\\n3:17 A \"living fort\"\\n5:37 Dusk Cinematics\\n6:50 ouch\\n7:20 in the real desert\\n8:15 Look at this guy!!!\\n10:26 Off-roading adventure'},\n",
       "    'defaultAudioLanguage': 'en'}}],\n",
       " 'pageInfo': {'totalResults': 1, 'resultsPerPage': 1}}"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url_video_tags = 'https://www.googleapis.com/youtube/v3/videos?id='+video_id+'&part=snippet&key='+api_key\n",
    "response_video_tags = requests.get(url_video_tags).json()\n",
    "response_video_tags"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['thar desert',\n",
       " 'jaisalmer vlog',\n",
       " 'thar desert pakistan',\n",
       " 'thar desert rajasthan',\n",
       " 'thar desert documentary',\n",
       " 'jaisalmer tourist places',\n",
       " 'jaisalmer tour',\n",
       " 'jaisalmer',\n",
       " 'rajasthan sand dunes',\n",
       " 'rajasthan camels',\n",
       " 'rajasthan safari',\n",
       " 'jaisalmer rajasthan',\n",
       " 'jaisalmer fort',\n",
       " 'first impresions of jaisalmer',\n",
       " 'jaisalmer fort drone view',\n",
       " 'jaisalmer fort tour',\n",
       " 'jaisalmer fort hotel',\n",
       " 'jaisalmer fort guided tour',\n",
       " 'jaisalmer fort inside',\n",
       " 'jaisalmer vlog in english',\n",
       " 'jaisalmer tour vlog']"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "response_video_tags[\"items\"][0][\"snippet\"][\"tags\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "url_video_stats = 'https://www.googleapis.com/youtube/v3/videos?id='+video_id+'&part=statistics&key='+api_key\n",
    "response_video_stats = requests.get(url_video_stats).json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'kind': 'youtube#videoListResponse',\n",
       " 'etag': 'kG8mHTuyRZjfpqbpEfn6I_-4omc',\n",
       " 'items': [{'kind': 'youtube#video',\n",
       "   'etag': 'jMygnlzjfVDy0Jq8nvhoUK0v2zc',\n",
       "   'id': 'i6Fy1l98mVQ',\n",
       "   'statistics': {'viewCount': '29327',\n",
       "    'likeCount': '1713',\n",
       "    'favoriteCount': '0',\n",
       "    'commentCount': '131'}}],\n",
       " 'pageInfo': {'totalResults': 1, 'resultsPerPage': 1}}"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "response_video_stats"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "if 'viewCount' in response_video_stats['items'][0]['statistics']:\n",
    "    view_count = response_video_stats['items'][0]['statistics']['viewCount']\n",
    "else:\n",
    "    view_count = 0\n",
    "if 'likeCount' in response_video_stats['items'][0]['statistics']:\n",
    "    like_count = response_video_stats['items'][0]['statistics']['likeCount']\n",
    "else:\n",
    "    like_count = 0\n",
    "if 'dislikeCount' in response_video_stats['items'][0]['statistics']:\n",
    "    dislike_count = response_video_stats['items'][0]['statistics']['dislikeCount']\n",
    "else:\n",
    "    dislike_count = 0\n",
    "if 'commentCount' in response_video_stats['items'][0]['statistics']:\n",
    "    comment_count = response_video_stats['items'][0]['statistics']['commentCount']\n",
    "else:\n",
    "    comment_count = 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame(columns=[\"video_id\", \"video_title\", \"upload_date\", \"view_count\", \"like_count\", \"dislike_count\", \"comment_count\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "for video in response['items']:\n",
    "    if video['id']['kind'] == 'youtube#video':\n",
    "        video_id = video['id']['videoId']\n",
    "        video_title = video['snippet']['title']\n",
    "        video_title = video_title.replace(\"&amp;\", \"\")\n",
    "        upload_date = video['snippet']['publishTime']\n",
    "        upload_date = upload_date.split(\"T\")[0]\n",
    "        \n",
    "        url_video_stats = 'https://www.googleapis.com/youtube/v3/videos?id='+video_id+'&part=statistics&key='+api_key\n",
    "        response_video_stats = requests.get(url_video_stats).json()\n",
    "        if 'viewCount' in response_video_stats['items'][0]['statistics']:\n",
    "            view_count = response_video_stats['items'][0]['statistics']['viewCount']\n",
    "        else:\n",
    "            view_count = None\n",
    "        if 'likeCount' in response_video_stats['items'][0]['statistics']:\n",
    "            like_count = response_video_stats['items'][0]['statistics']['likeCount']\n",
    "        else:\n",
    "            like_count = None\n",
    "        if 'dislikeCount' in response_video_stats['items'][0]['statistics']:\n",
    "            dislike_count = response_video_stats['items'][0]['statistics']['dislikeCount']\n",
    "        else:\n",
    "            dislike_count = None\n",
    "        if 'commentCount' in response_video_stats['items'][0]['statistics']:\n",
    "            comment_count = response_video_stats['items'][0]['statistics']['commentCount']\n",
    "        else:\n",
    "            comment_count = None\n",
    "        \"\"\"\n",
    "        print(video_id)\n",
    "        print(video_title)\n",
    "        print(upload_date)\n",
    "        print(view_count)\n",
    "        print(like_count)\n",
    "        print(dislike_count)\n",
    "        print(comment_count)\n",
    "        \"\"\"\n",
    "        #save data in pandas dataframe\n",
    "        df = df.append({'video_id':video_id, 'video_title':video_title,\n",
    "                        'upload_date':upload_date, 'view_count':view_count,\n",
    "                        'like_count':like_count, 'dislike_count':dislike_count,\n",
    "                        'comment_count':comment_count}, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>video_id</th>\n",
       "      <th>video_title</th>\n",
       "      <th>upload_date</th>\n",
       "      <th>view_count</th>\n",
       "      <th>like_count</th>\n",
       "      <th>dislike_count</th>\n",
       "      <th>comment_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>iejxvmCxpuY</td>\n",
       "      <td>Journey to Budva from Podgorica 🇲🇪</td>\n",
       "      <td>2022-12-28</td>\n",
       "      <td>228</td>\n",
       "      <td>19</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>_0oHMwk6IY8</td>\n",
       "      <td>First Impressions of Podgorica, Montenegro 🇲🇪</td>\n",
       "      <td>2022-12-28</td>\n",
       "      <td>1062</td>\n",
       "      <td>56</td>\n",
       "      <td>None</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>zpMvN-QM87M</td>\n",
       "      <td>Glacial Lake in Montenegro&amp;#39;s mountains 🇲🇪</td>\n",
       "      <td>2022-12-28</td>\n",
       "      <td>464</td>\n",
       "      <td>55</td>\n",
       "      <td>None</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>tdReiQV2hNc</td>\n",
       "      <td>Amazing view from top of Montenegro 🇲🇪</td>\n",
       "      <td>2022-12-28</td>\n",
       "      <td>386</td>\n",
       "      <td>52</td>\n",
       "      <td>None</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DqvMUfWlP3o</td>\n",
       "      <td>Treacherous Climb in Durmitor, Montenegro 🇲🇪</td>\n",
       "      <td>2022-12-28</td>\n",
       "      <td>550</td>\n",
       "      <td>50</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      video_id                                    video_title upload_date  \\\n",
       "0  iejxvmCxpuY             Journey to Budva from Podgorica 🇲🇪  2022-12-28   \n",
       "1  _0oHMwk6IY8  First Impressions of Podgorica, Montenegro 🇲🇪  2022-12-28   \n",
       "2  zpMvN-QM87M  Glacial Lake in Montenegro&#39;s mountains 🇲🇪  2022-12-28   \n",
       "3  tdReiQV2hNc         Amazing view from top of Montenegro 🇲🇪  2022-12-28   \n",
       "4  DqvMUfWlP3o   Treacherous Climb in Durmitor, Montenegro 🇲🇪  2022-12-28   \n",
       "\n",
       "  view_count like_count dislike_count comment_count  \n",
       "0        228         19          None             0  \n",
       "1       1062         56          None             4  \n",
       "2        464         55          None             2  \n",
       "3        386         52          None             4  \n",
       "4        550         50          None             1  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "def call_api(api_key, channel_id):\n",
    "    pageToken = \"\"\n",
    "    url = 'https://www.googleapis.com/youtube/v3/search?key='+api_key+'&channelId='+channel_id+'&part=snippet,id&order=date&maxResults=10000'+pageToken\n",
    "    response = requests.get(url).json()\n",
    "    return response"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_video_details(video_id):\n",
    "    url_video_stats = 'https://www.googleapis.com/youtube/v3/videos?id='+video_id+'&part=statistics&key='+api_key\n",
    "    response_video_stats = requests.get(url_video_stats).json()\n",
    "    if 'viewCount' in response_video_stats['items'][0]['statistics']:\n",
    "        view_count = response_video_stats['items'][0]['statistics']['viewCount']\n",
    "    else:\n",
    "        view_count = None\n",
    "    if 'likeCount' in response_video_stats['items'][0]['statistics']:\n",
    "        like_count = response_video_stats['items'][0]['statistics']['likeCount']\n",
    "    else:\n",
    "        like_count = None\n",
    "    if 'dislikeCount' in response_video_stats['items'][0]['statistics']:\n",
    "        dislike_count = response_video_stats['items'][0]['statistics']['dislikeCount']\n",
    "    else:\n",
    "        dislike_count = None\n",
    "    if 'commentCount' in response_video_stats['items'][0]['statistics']:\n",
    "        comment_count = response_video_stats['items'][0]['statistics']['commentCount']\n",
    "    else:\n",
    "        comment_count = None\n",
    "    \n",
    "    return view_count, like_count, dislike_count, comment_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_videos(response, df):\n",
    "    for video in response['items']:\n",
    "        if video['id']['kind'] == 'youtube#video':\n",
    "            video_id = video['id']['videoId']\n",
    "            video_title = video['snippet']['title']\n",
    "            video_title = video_title.replace(\"&amp;\", \"\")\n",
    "            upload_date = video['snippet']['publishTime']\n",
    "            upload_date = upload_date.split(\"T\")[0]\n",
    "            \n",
    "            view_count, like_count, dislike_count, comment_count = get_video_details(video_id)\n",
    "\n",
    "            #save data in pandas dataframe\n",
    "            df = df.append({'video_id':video_id, 'video_title':video_title,\n",
    "                            'upload_date':upload_date, 'view_count':view_count,\n",
    "                            'like_count':like_count, 'dislike_count':dislike_count,\n",
    "                            'comment_count':comment_count}, ignore_index=True)\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame(columns=[\"video_id\", \"video_title\", \"upload_date\", \"view_count\", \"like_count\", \"dislike_count\", \"comment_count\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "# keys\n",
    "api_key = 'x'\n",
    "channel_id = 'UCyV7cn5xPsPexvdY8Lig3-g'\n",
    "response = call_api(api_key, channel_id)\n",
    "df = get_videos(response, df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>video_id</th>\n",
       "      <th>video_title</th>\n",
       "      <th>upload_date</th>\n",
       "      <th>view_count</th>\n",
       "      <th>like_count</th>\n",
       "      <th>dislike_count</th>\n",
       "      <th>comment_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>kLkmGUTwG-s</td>\n",
       "      <td>Comment | Java for Beginners | Bangla Tutorial...</td>\n",
       "      <td>2021-01-05</td>\n",
       "      <td>67</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>baGEPw5XMog</td>\n",
       "      <td>How To Run A Java Program | Java for Beginners...</td>\n",
       "      <td>2020-10-18</td>\n",
       "      <td>155</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>47y_BeKHIPs</td>\n",
       "      <td>C++ vs Java | Java for Beginners | Bangla Tuto...</td>\n",
       "      <td>2020-09-28</td>\n",
       "      <td>123</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>sKUZAeyF_QU</td>\n",
       "      <td>Overview of Java | Java for Beginners | Bangla...</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>100</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>hl4eq1ToX3U</td>\n",
       "      <td>How To Add A Calendar To A Website | Bangla We...</td>\n",
       "      <td>2020-08-31</td>\n",
       "      <td>70</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      video_id                                        video_title upload_date  \\\n",
       "0  kLkmGUTwG-s  Comment | Java for Beginners | Bangla Tutorial...  2021-01-05   \n",
       "1  baGEPw5XMog  How To Run A Java Program | Java for Beginners...  2020-10-18   \n",
       "2  47y_BeKHIPs  C++ vs Java | Java for Beginners | Bangla Tuto...  2020-09-28   \n",
       "3  sKUZAeyF_QU  Overview of Java | Java for Beginners | Bangla...  2020-09-03   \n",
       "4  hl4eq1ToX3U  How To Add A Calendar To A Website | Bangla We...  2020-08-31   \n",
       "\n",
       "  view_count like_count  dislike_count comment_count  \n",
       "0         67          4              0             0  \n",
       "1        155          6              0             1  \n",
       "2        123          2              0             1  \n",
       "3        100          7              0             2  \n",
       "4         70         10              0             4  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['dislike_count'] = 0\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('data.csv')"
   ]
  }
 ],
 "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.9.6 (tags/v3.9.6:db3ff76, Jun 28 2021, 15:26:21) [MSC v.1929 64 bit (AMD64)]"
  },
  "vscode": {
   "interpreter": {
    "hash": "7459fc3de7a9cfbb16956cc8e27f933e0ea1512a8cf97ca2195aa9f74a47b2b0"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}