youtube_gpt_integration.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# GPT get the topic"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# imports\n",
    "import os\n",
    "import openai\n",
    "from dotenv import load_dotenv\n",
    "import json\n",
    "\n",
    "load_dotenv()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import google_auth_oauthlib.flow\n",
    "import googleapiclient.discovery\n",
    "import googleapiclient.errors\n",
    "from apiclient.discovery import build"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "class YtRec:\n",
    "    def __init__(self, transcript):\n",
    "        self.trascript = transcript\n",
    "        self.ytapi = os.getenv('YOUTUBE_API_KEY')\n",
    "        openai.api_key = os.getenv('OPENAI_API_KEY')\n",
    "        print(self.ytapi, openai.api_key )\n",
    "    \n",
    "    def gpt_keywords(self):\n",
    "        words = self.trascript\n",
    "        query = \"Extract keywords from this text: \"\n",
    "        prompt_ = query + words\n",
    "        response = openai.Completion.create(\n",
    "            model=\"text-davinci-002\",\n",
    "            prompt=prompt_,\n",
    "            temperature=0.3,\n",
    "            max_tokens=400,\n",
    "            top_p=.98,\n",
    "            frequency_penalty=0.7,\n",
    "            presence_penalty=0.0\n",
    "        )\n",
    "        x = response\n",
    "        text = x['choices'][0]['text']\n",
    "        text_new = text.replace('\\n-', ',')\n",
    "        return text_new\n",
    "\n",
    "    def gpt_topic(self):\n",
    "        words = self.trascript\n",
    "        query_new = \"Find the topic:\"\n",
    "        prompt_ = query_new + words\n",
    "\n",
    "        response_new = openai.Completion.create(\n",
    "            model=\"text-davinci-002\",\n",
    "            prompt=prompt_,\n",
    "            temperature=0.3,\n",
    "            max_tokens=400,\n",
    "            top_p=.98,\n",
    "            frequency_penalty=0.7,\n",
    "            presence_penalty=0.0\n",
    "        )\n",
    "        x_new = response_new\n",
    "        text = x_new['choices'][0]['text']\n",
    "        return text\n",
    "    \n",
    "    \n",
    "    def youtube_get_videos(self):\n",
    "        #Initializing the API\n",
    "        api_key = self.ytapi\n",
    "        youtube = build( 'youtube', 'V3', developerKey= api_key)\n",
    "        \n",
    "        text = self.gpt_topic()\n",
    "        #Searching for query with decreasing order as viewcount and result as video type\n",
    "        results = youtube. search().list(q=text, part=\"snippet\", type=\"video\", \n",
    "                                         order=\"viewCount\").execute( )\n",
    "        \n",
    "        return results\n",
    "    \n",
    "    # this next few fns can def be better\n",
    "    def get_title(self, item):\n",
    "        title = item['snippet']['title']\n",
    "        return title\n",
    "\n",
    "    def get_thumbnail(self, item):\n",
    "        video_id = item['id']['videoId']\n",
    "        video_thumbnail = \"https://www.youtube.com/watch?v=\" + video_id + \"/default.jpg\"\n",
    "        return video_thumbnail\n",
    "\n",
    "    def get_video_url(self, item):\n",
    "        video_id = item['id']['videoId']\n",
    "        video_url = \"https://img.youtube.com/vi/\" + video_id\n",
    "        return video_url\n",
    "\n",
    "    def get_viewcount(self, item, youtube):\n",
    "        video_id = item['id']['videoId']\n",
    "        video_statistics = youtube.videos().list(id=video_id,\n",
    "                                            part='statistics').execute()\n",
    "        viewcount = int(video_statistics['items'][0]['statistics']['viewCount'])\n",
    "        return viewcount\n",
    "\n",
    "    def get_likecount(self, item, youtube):\n",
    "        video_id = item['id']['videoId']\n",
    "        video_statistics = youtube.videos().list(id=video_id,\n",
    "                                            part='statistics').execute()\n",
    "        likecount = int(video_statistics['items'][0]['statistics']['likeCount'])\n",
    "        return likecount\n",
    "    \n",
    "    # refine this based on the feedback from the team \n",
    "    def custom_score(self, likecount, viewcount) :\n",
    "        score = ( (likecount **2 + viewcount) / (viewcount))\n",
    "        return score\n",
    "\n",
    "    def new_order(self, results, df, youtube):\n",
    "        i = 1\n",
    "        topics, keywords = self.gpt_topic(), self.gpt_keywords()\n",
    "        for item in results['items']:\n",
    "            title = self.get_title(item)\n",
    "            thumbnail = self.get_thumbnail(item)\n",
    "            viewcount = self.get_viewcount(item, youtube)\n",
    "            video_url = self.get_video_url(item)\n",
    "            likecount = self.get_likecount(item, youtube)\n",
    "            # dislikecount = get_dislikecount(item, youtube)\n",
    "            score = self.custom_score(likecount, viewcount)\n",
    "            df.loc[i] = [title, thumbnail,video_url, topics, keywords, score, viewcount, ]\n",
    "            i += 1\n",
    "        df = df.sort_values(['custom_score'], ascending=[0])\n",
    "        df = df.reset_index(drop=True)\n",
    "        return df\n",
    "    ##### back to okay code\n",
    "    \n",
    "    def final_df(self):\n",
    "        # Initialise results dataframe\n",
    "        df = pd.DataFrame(columns=('title', 'thumbnail', 'url', 'topics', \n",
    "                                   'keywords', 'custom_score', 'views'))\n",
    "        api_key = self.ytapi\n",
    "        print(api_key)\n",
    "        youtube = build( 'youtube', 'V3', developerKey= api_key)\n",
    "        \n",
    "        text = self.gpt_topic()\n",
    "        #Searching for query with decreasing order as viewcount and result as video type\n",
    "        results = youtube. search().list(q=text, part=\"snippet\", type=\"video\", \n",
    "                                         order=\"viewCount\").execute( )\n",
    "        \n",
    "        df_final = self.new_order(results, df, youtube)\n",
    "        return df_final\n",
    "    \n",
    "    def final_dict(self):\n",
    "        df_final = self.final_df()\n",
    "        df_final = df_final.drop(columns = ['custom_score','views'])\n",
    "        dict_final = df_final.to_dict('dict')\n",
    "        return dict_final\n",
    "    \n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "words = \"\"\"I'm now going to look at the columns of the matrix. I'm going to look at this part and this part.\n",
    "I'm going to say that the x part is really x times -- you see, I'm putting the two -- I'm kind of getting the two equations at once -- that part and then I have a y and in the first equation it's multiplying a minus one and in the second equation a two, and on the right-hand side, zero and three.\n",
    "You see, the columns of the matrix, the columns of A are here and the right-hand side b is there.\n",
    "And now what is the equation asking for? It's asking us to find -- somehow to combine that vector and this one in the right amounts to get that one. It's asking us to find the right linear combination -- this is called a linear combination.\n",
    "And it's the most fundamental operation in the whole course. It's a linear combination of the columns. That's what we're seeing on the left side.\n",
    "Again, I don't want to write down a big definition. You can see what it is. There's column one, there's column two. I multiply by some numbers and I add. That's a combination -- a linear combination and I want to make those numbers the right numbers to produce zero three.\"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "AIzaSyAr2qs8fzXhK8aQBikHqkJSpmX6gWkSw8o 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\n"
     ]
    }
   ],
   "source": [
    "check = YtRec(words)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "# check.gpt_keywords()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "# check.gpt_topic()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "AIzaSyAr2qs8fzXhK8aQBikHqkJSpmX6gWkSw8o\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{'title': {0: 'Linear combinations, span, and basis vectors | Chapter 2, Essence of linear algebra',\n",
       "  1: 'Linear combinations and span | Vectors and spaces | Linear Algebra | Khan Academy',\n",
       "  2: 'Using Euclidean algorithm to write gcd as linear combination',\n",
       "  3: 'Linear Algebra - Lecture 7 - Linear Combinations and Vector Equations',\n",
       "  4: 'Linear Algebra Example Problems - Linear Combination of Vectors #2'},\n",
       " 'thumbnail': {0: 'https://www.youtube.com/watch?v=k7RM-ot2NWY/default.jpg',\n",
       "  1: 'https://www.youtube.com/watch?v=Qm_OS-8COwU/default.jpg',\n",
       "  2: 'https://www.youtube.com/watch?v=qym5D5bhoQs/default.jpg',\n",
       "  3: 'https://www.youtube.com/watch?v=rfdVVxFbklM/default.jpg',\n",
       "  4: 'https://www.youtube.com/watch?v=AGSajg1m-FU/default.jpg'},\n",
       " 'url': {0: 'https://img.youtube.com/vi/k7RM-ot2NWY',\n",
       "  1: 'https://img.youtube.com/vi/Qm_OS-8COwU',\n",
       "  2: 'https://img.youtube.com/vi/qym5D5bhoQs',\n",
       "  3: 'https://img.youtube.com/vi/rfdVVxFbklM',\n",
       "  4: 'https://img.youtube.com/vi/AGSajg1m-FU'},\n",
       " 'topics': {0: '\\n\\nThe topic is solving linear equations using matrices.',\n",
       "  1: '\\n\\nThe topic is solving linear equations using matrices.',\n",
       "  2: '\\n\\nThe topic is solving linear equations using matrices.',\n",
       "  3: '\\n\\nThe topic is solving linear equations using matrices.',\n",
       "  4: '\\n\\nThe topic is solving linear equations using matrices.'},\n",
       " 'keywords': {0: '\\n,matrix,columns,equations,right-hand side,linear combination',\n",
       "  1: '\\n,matrix,columns,equations,right-hand side,linear combination',\n",
       "  2: '\\n,matrix,columns,equations,right-hand side,linear combination',\n",
       "  3: '\\n,matrix,columns,equations,right-hand side,linear combination',\n",
       "  4: '\\n,matrix,columns,equations,right-hand side,linear combination'}}"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "check.final_dict()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "# check.youtube_get_videos()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "AIzaSyAr2qs8fzXhK8aQBikHqkJSpmX6gWkSw8o\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>title</th>\n",
       "      <th>thumbnail</th>\n",
       "      <th>url</th>\n",
       "      <th>topics</th>\n",
       "      <th>keywords</th>\n",
       "      <th>custom_score</th>\n",
       "      <th>views</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gaussian Elimination &amp;amp; Row Echelon Form</td>\n",
       "      <td>https://www.youtube.com/watch?v=eDb6iugi6Uk/de...</td>\n",
       "      <td>https://img.youtube.com/vi/eDb6iugi6Uk</td>\n",
       "      <td>\\n\\nThe topic is solving linear equations.</td>\n",
       "      <td>\\n,matrix,columns,right-hand side,linear combi...</td>\n",
       "      <td>190.262880</td>\n",
       "      <td>1259753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Cramer&amp;#39;s Rule to Solve a System of 3 Linea...</td>\n",
       "      <td>https://www.youtube.com/watch?v=TtxVGMWXMSE/de...</td>\n",
       "      <td>https://img.youtube.com/vi/TtxVGMWXMSE</td>\n",
       "      <td>\\n\\nThe topic is solving linear equations.</td>\n",
       "      <td>\\n,matrix,columns,right-hand side,linear combi...</td>\n",
       "      <td>155.780947</td>\n",
       "      <td>1863203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gauss Jordan Elimination &amp;amp; Reduced Row Ech...</td>\n",
       "      <td>https://www.youtube.com/watch?v=eYSASx8_nyg/de...</td>\n",
       "      <td>https://img.youtube.com/vi/eYSASx8_nyg</td>\n",
       "      <td>\\n\\nThe topic is solving linear equations.</td>\n",
       "      <td>\\n,matrix,columns,right-hand side,linear combi...</td>\n",
       "      <td>139.521823</td>\n",
       "      <td>925724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>❖ Using Gauss-Jordan to Solve a System of Thre...</td>\n",
       "      <td>https://www.youtube.com/watch?v=CsTOUbeMPUo/de...</td>\n",
       "      <td>https://img.youtube.com/vi/CsTOUbeMPUo</td>\n",
       "      <td>\\n\\nThe topic is solving linear equations.</td>\n",
       "      <td>\\n,matrix,columns,right-hand side,linear combi...</td>\n",
       "      <td>49.209530</td>\n",
       "      <td>1696259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Matrices to solve a system of equations | Matr...</td>\n",
       "      <td>https://www.youtube.com/watch?v=AUqeb9Z3y3k/de...</td>\n",
       "      <td>https://img.youtube.com/vi/AUqeb9Z3y3k</td>\n",
       "      <td>\\n\\nThe topic is solving linear equations.</td>\n",
       "      <td>\\n,matrix,columns,right-hand side,linear combi...</td>\n",
       "      <td>21.673164</td>\n",
       "      <td>1449448</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               title  \\\n",
       "0        Gaussian Elimination &amp; Row Echelon Form   \n",
       "1  Cramer&#39;s Rule to Solve a System of 3 Linea...   \n",
       "2  Gauss Jordan Elimination &amp; Reduced Row Ech...   \n",
       "3  ❖ Using Gauss-Jordan to Solve a System of Thre...   \n",
       "4  Matrices to solve a system of equations | Matr...   \n",
       "\n",
       "                                           thumbnail  \\\n",
       "0  https://www.youtube.com/watch?v=eDb6iugi6Uk/de...   \n",
       "1  https://www.youtube.com/watch?v=TtxVGMWXMSE/de...   \n",
       "2  https://www.youtube.com/watch?v=eYSASx8_nyg/de...   \n",
       "3  https://www.youtube.com/watch?v=CsTOUbeMPUo/de...   \n",
       "4  https://www.youtube.com/watch?v=AUqeb9Z3y3k/de...   \n",
       "\n",
       "                                      url  \\\n",
       "0  https://img.youtube.com/vi/eDb6iugi6Uk   \n",
       "1  https://img.youtube.com/vi/TtxVGMWXMSE   \n",
       "2  https://img.youtube.com/vi/eYSASx8_nyg   \n",
       "3  https://img.youtube.com/vi/CsTOUbeMPUo   \n",
       "4  https://img.youtube.com/vi/AUqeb9Z3y3k   \n",
       "\n",
       "                                       topics  \\\n",
       "0  \\n\\nThe topic is solving linear equations.   \n",
       "1  \\n\\nThe topic is solving linear equations.   \n",
       "2  \\n\\nThe topic is solving linear equations.   \n",
       "3  \\n\\nThe topic is solving linear equations.   \n",
       "4  \\n\\nThe topic is solving linear equations.   \n",
       "\n",
       "                                            keywords  custom_score    views  \n",
       "0  \\n,matrix,columns,right-hand side,linear combi...    190.262880  1259753  \n",
       "1  \\n,matrix,columns,right-hand side,linear combi...    155.780947  1863203  \n",
       "2  \\n,matrix,columns,right-hand side,linear combi...    139.521823   925724  \n",
       "3  \\n,matrix,columns,right-hand side,linear combi...     49.209530  1696259  \n",
       "4  \\n,matrix,columns,right-hand side,linear combi...     21.673164  1449448  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "check.final_df()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "AIzaSyAr2qs8fzXhK8aQBikHqkJSpmX6gWkSw8o\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{'title': {0: 'Gaussian Elimination &amp; Row Echelon Form',\n",
       "  1: 'Cramer&#39;s Rule to Solve a System of 3 Linear Equations - Example 1',\n",
       "  2: 'Gauss Jordan Elimination &amp; Reduced Row Echelon Form',\n",
       "  3: '❖ Using Gauss-Jordan to Solve a System of Three Linear Equations - Example 1 ❖',\n",
       "  4: 'Matrices to solve a system of equations | Matrices | Precalculus | Khan Academy'},\n",
       " 'thumbnail': {0: 'https://www.youtube.com/watch?v=eDb6iugi6Uk/default.jpg',\n",
       "  1: 'https://www.youtube.com/watch?v=TtxVGMWXMSE/default.jpg',\n",
       "  2: 'https://www.youtube.com/watch?v=eYSASx8_nyg/default.jpg',\n",
       "  3: 'https://www.youtube.com/watch?v=CsTOUbeMPUo/default.jpg',\n",
       "  4: 'https://www.youtube.com/watch?v=AUqeb9Z3y3k/default.jpg'},\n",
       " 'url': {0: 'https://img.youtube.com/vi/eDb6iugi6Uk',\n",
       "  1: 'https://img.youtube.com/vi/TtxVGMWXMSE',\n",
       "  2: 'https://img.youtube.com/vi/eYSASx8_nyg',\n",
       "  3: 'https://img.youtube.com/vi/CsTOUbeMPUo',\n",
       "  4: 'https://img.youtube.com/vi/AUqeb9Z3y3k'},\n",
       " 'topics': {0: '\\n\\nThe topic is solving linear equations.',\n",
       "  1: '\\n\\nThe topic is solving linear equations.',\n",
       "  2: '\\n\\nThe topic is solving linear equations.',\n",
       "  3: '\\n\\nThe topic is solving linear equations.',\n",
       "  4: '\\n\\nThe topic is solving linear equations.'},\n",
       " 'keywords': {0: '\\n,matrix,columns,right-hand side,linear combination',\n",
       "  1: '\\n,matrix,columns,right-hand side,linear combination',\n",
       "  2: '\\n,matrix,columns,right-hand side,linear combination',\n",
       "  3: '\\n,matrix,columns,right-hand side,linear combination',\n",
       "  4: '\\n,matrix,columns,right-hand side,linear combination'},\n",
       " 'custom_score': {0: 190.26288010427442,\n",
       "  1: 155.78094657425947,\n",
       "  2: 139.5218229191422,\n",
       "  3: 49.20952991259,\n",
       "  4: 21.673163852721864},\n",
       " 'views': {0: 1259753, 1: 1863203, 2: 925724, 3: 1696259, 4: 1449448}}"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 217,
   "metadata": {},
   "outputs": [],
   "source": [
    "query = \"Extract keywords from this text: \"\n",
    "prompt_ = query + words"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 218,
   "metadata": {},
   "outputs": [],
   "source": [
    "response = openai.Completion.create(\n",
    "  model=\"text-davinci-002\",\n",
    "  prompt=prompt_,\n",
    "  temperature=0.3,\n",
    "  max_tokens=400,\n",
    "  top_p=.98,\n",
    "  frequency_penalty=0.7,\n",
    "  presence_penalty=0.0\n",
    ")\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 219,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<OpenAIObject text_completion id=cmpl-5woMWBvrB4yX68GxY37yelOvVVZtv at 0x7f7b107b7ad0> JSON: {\n",
       "  \"choices\": [\n",
       "    {\n",
       "      \"finish_reason\": \"stop\",\n",
       "      \"index\": 0,\n",
       "      \"logprobs\": null,\n",
       "      \"text\": \"\\n\\n-matrix\\n-columns\\n-right-hand side\\n-linear combination\"\n",
       "    }\n",
       "  ],\n",
       "  \"created\": 1664698300,\n",
       "  \"id\": \"cmpl-5woMWBvrB4yX68GxY37yelOvVVZtv\",\n",
       "  \"model\": \"text-davinci-002\",\n",
       "  \"object\": \"text_completion\",\n",
       "  \"usage\": {\n",
       "    \"completion_tokens\": 19,\n",
       "    \"prompt_tokens\": 280,\n",
       "    \"total_tokens\": 299\n",
       "  }\n",
       "}"
      ]
     },
     "execution_count": 219,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "response"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 220,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "\n",
      "-matrix\n",
      "-columns\n",
      "-right-hand side\n",
      "-linear combination\n"
     ]
    }
   ],
   "source": [
    "x = response\n",
    "text = x['choices'][0]['text']\n",
    "print(text)  # , everyone, and welcome to the first installment of the new opening"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 221,
   "metadata": {},
   "outputs": [],
   "source": [
    "query_new = \"Find the topic:\"\n",
    "prompt_ = query_new + words"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 222,
   "metadata": {},
   "outputs": [],
   "source": [
    "response_new = openai.Completion.create(\n",
    "  model=\"text-davinci-002\",\n",
    "  prompt=prompt_,\n",
    "  temperature=0.3,\n",
    "  max_tokens=400,\n",
    "  top_p=.98,\n",
    "  frequency_penalty=0.7,\n",
    "  presence_penalty=0.0\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 223,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<OpenAIObject text_completion id=cmpl-5woMrVxUQecjHeUzoppDUSIwJ7NYW at 0x7f7ac0a05b90> JSON: {\n",
       "  \"choices\": [\n",
       "    {\n",
       "      \"finish_reason\": \"stop\",\n",
       "      \"index\": 0,\n",
       "      \"logprobs\": null,\n",
       "      \"text\": \"\\n\\nThe topic is solving linear equations using matrices.\"\n",
       "    }\n",
       "  ],\n",
       "  \"created\": 1664698321,\n",
       "  \"id\": \"cmpl-5woMrVxUQecjHeUzoppDUSIwJ7NYW\",\n",
       "  \"model\": \"text-davinci-002\",\n",
       "  \"object\": \"text_completion\",\n",
       "  \"usage\": {\n",
       "    \"completion_tokens\": 12,\n",
       "    \"prompt_tokens\": 277,\n",
       "    \"total_tokens\": 289\n",
       "  }\n",
       "}"
      ]
     },
     "execution_count": 223,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "response_new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 227,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "\n",
      "The topic is solving linear equations using matrices.\n"
     ]
    }
   ],
   "source": [
    "x_new = response_new\n",
    "text = x_new['choices'][0]['text']\n",
    "print(text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 232,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'\\n\\nsolving linear equations using matrices.'"
      ]
     },
     "execution_count": 232,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "text.replace('The topic is ', '')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# YouTube Part"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 233,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import google_auth_oauthlib.flow\n",
    "import googleapiclient.discovery\n",
    "import googleapiclient.errors"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 234,
   "metadata": {},
   "outputs": [],
   "source": [
    "# See instructions for running these code samples locally:\n",
    "# https://developers.google.com/explorer-help/code-samples#python\n",
    "# scopes = [\"https://www.googleapis.com/auth/youtube.force-ssl\"]\n",
    "\n",
    "def get_videos(topic, api_key, n_results=5):\n",
    "    # Disable OAuthlib's HTTPS verification when running locally.\n",
    "    # *DO NOT* leave this option enabled in production.\n",
    "    # os.environ[\"OAUTHLIB_INSECURE_TRANSPORT\"] = \"1\"\n",
    "\n",
    "    # Get credentials and create an API client\n",
    "    youtube = build( 'youtube', 'V3', developerKey=api_key)\n",
    "\n",
    "    request = youtube.search().list(\n",
    "        q = topic,\n",
    "        part= 'snippet',\n",
    "        maxResults=n_results,\n",
    "        order=\"viewCount\"\n",
    "        )\n",
    "    response = request.execute()\n",
    "\n",
    "    print(response)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 235,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "AIzaSyAr2qs8fzXhK8aQBikHqkJSpmX6gWkSw8o\n"
     ]
    }
   ],
   "source": [
    "api_key = os.getenv('YOUTUBE_API_KEY')\n",
    "print(api_key)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 236,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'kind': 'youtube#searchListResponse', 'etag': 'NlcvQyNQN6KFNSK_tmL8bDBI3yc', 'nextPageToken': 'CAUQAA', 'regionCode': 'US', 'pageInfo': {'totalResults': 1000000, 'resultsPerPage': 5}, 'items': [{'kind': 'youtube#searchResult', 'etag': 'RXjJGl149u2Vsta4r7hcvxvJgIs', 'id': {'kind': 'youtube#video', 'videoId': 'TtxVGMWXMSE'}, 'snippet': {'publishedAt': '2010-07-26T00:24:52Z', 'channelId': 'UCFe6jenM1Bc54qtBsIJGRZQ', 'title': 'Cramer&#39;s Rule to Solve a System of 3 Linear Equations - Example 1', 'description': 'Thanks to all of you who support me on Patreon. You da real mvps! $1 per month helps!! :) https://www.patreon.com/patrickjmt !', 'thumbnails': {'default': {'url': 'https://i.ytimg.com/vi/TtxVGMWXMSE/default.jpg', 'width': 120, 'height': 90}, 'medium': {'url': 'https://i.ytimg.com/vi/TtxVGMWXMSE/mqdefault.jpg', 'width': 320, 'height': 180}, 'high': {'url': 'https://i.ytimg.com/vi/TtxVGMWXMSE/hqdefault.jpg', 'width': 480, 'height': 360}}, 'channelTitle': 'patrickJMT', 'liveBroadcastContent': 'none', 'publishTime': '2010-07-26T00:24:52Z'}}, {'kind': 'youtube#searchResult', 'etag': '7OpKBlR2suaUJJGcYj85quPMa8E', 'id': {'kind': 'youtube#video', 'videoId': 'CsTOUbeMPUo'}, 'snippet': {'publishedAt': '2010-07-25T23:51:50Z', 'channelId': 'UCFe6jenM1Bc54qtBsIJGRZQ', 'title': '❖ Using Gauss-Jordan to Solve a System of Three Linear Equations - Example 1 ❖', 'description': 'Thanks to all of you who support me on Patreon. You da real mvps! $1 per month helps!! :) https://www.patreon.com/patrickjmt !', 'thumbnails': {'default': {'url': 'https://i.ytimg.com/vi/CsTOUbeMPUo/default.jpg', 'width': 120, 'height': 90}, 'medium': {'url': 'https://i.ytimg.com/vi/CsTOUbeMPUo/mqdefault.jpg', 'width': 320, 'height': 180}, 'high': {'url': 'https://i.ytimg.com/vi/CsTOUbeMPUo/hqdefault.jpg', 'width': 480, 'height': 360}}, 'channelTitle': 'patrickJMT', 'liveBroadcastContent': 'none', 'publishTime': '2010-07-25T23:51:50Z'}}, {'kind': 'youtube#searchResult', 'etag': '2cDlRnSu4xhaB4kfwMl6yELsExs', 'id': {'kind': 'youtube#video', 'videoId': 'AUqeb9Z3y3k'}, 'snippet': {'publishedAt': '2008-06-14T17:42:53Z', 'channelId': 'UC4a-Gbdw7vOaccHmFo40b9g', 'title': 'Matrices to solve a system of equations | Matrices | Precalculus | Khan Academy', 'description': 'Using the inverse of a matrix to solve a system of equations. Practice this yourself on Khan Academy right now: ...', 'thumbnails': {'default': {'url': 'https://i.ytimg.com/vi/AUqeb9Z3y3k/default.jpg', 'width': 120, 'height': 90}, 'medium': {'url': 'https://i.ytimg.com/vi/AUqeb9Z3y3k/mqdefault.jpg', 'width': 320, 'height': 180}, 'high': {'url': 'https://i.ytimg.com/vi/AUqeb9Z3y3k/hqdefault.jpg', 'width': 480, 'height': 360}}, 'channelTitle': 'Khan Academy', 'liveBroadcastContent': 'none', 'publishTime': '2008-06-14T17:42:53Z'}}, {'kind': 'youtube#searchResult', 'etag': 'rY_ozZVh9XMOKXGXrgm6HEnmPWE', 'id': {'kind': 'youtube#video', 'videoId': 'eDb6iugi6Uk'}, 'snippet': {'publishedAt': '2018-02-18T03:00:03Z', 'channelId': 'UCEWpbFLzoYGPfuWUMFPSaoA', 'title': 'Gaussian Elimination &amp; Row Echelon Form', 'description': 'This precalculus video tutorial provides a basic introduction into the gaussian elimination - a process that involves elementary row ...', 'thumbnails': {'default': {'url': 'https://i.ytimg.com/vi/eDb6iugi6Uk/default.jpg', 'width': 120, 'height': 90}, 'medium': {'url': 'https://i.ytimg.com/vi/eDb6iugi6Uk/mqdefault.jpg', 'width': 320, 'height': 180}, 'high': {'url': 'https://i.ytimg.com/vi/eDb6iugi6Uk/hqdefault.jpg', 'width': 480, 'height': 360}}, 'channelTitle': 'The Organic Chemistry Tutor', 'liveBroadcastContent': 'none', 'publishTime': '2018-02-18T03:00:03Z'}}, {'kind': 'youtube#searchResult', 'etag': 'HtZHltqkhc72TZsl3-Qd_BBV3RI', 'id': {'kind': 'youtube#video', 'videoId': 'eYSASx8_nyg'}, 'snippet': {'publishedAt': '2018-02-18T17:00:06Z', 'channelId': 'UCEWpbFLzoYGPfuWUMFPSaoA', 'title': 'Gauss Jordan Elimination &amp; Reduced Row Echelon Form', 'description': 'This precalculus video tutorial provides a basic introduction into the gauss jordan elimination which is a process used to solve a ...', 'thumbnails': {'default': {'url': 'https://i.ytimg.com/vi/eYSASx8_nyg/default.jpg', 'width': 120, 'height': 90}, 'medium': {'url': 'https://i.ytimg.com/vi/eYSASx8_nyg/mqdefault.jpg', 'width': 320, 'height': 180}, 'high': {'url': 'https://i.ytimg.com/vi/eYSASx8_nyg/hqdefault.jpg', 'width': 480, 'height': 360}}, 'channelTitle': 'The Organic Chemistry Tutor', 'liveBroadcastContent': 'none', 'publishTime': '2018-02-18T17:00:06Z'}}]}\n"
     ]
    }
   ],
   "source": [
    "get_videos(text, api_key)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 237,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Initializing the API\n",
    "youtube = build( 'youtube', 'V3', developerKey=api_key)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 238,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Searching for query \"Twenty One Pilots\" with decreasing order as viewcount and result as video type\n",
    "results = youtube. search().list(q=text, part=\"snippet\", type=\"video\", order=\"viewCount\" ).execute( )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 239,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'kind': 'youtube#searchListResponse',\n",
       " 'etag': 'NlcvQyNQN6KFNSK_tmL8bDBI3yc',\n",
       " 'nextPageToken': 'CAUQAA',\n",
       " 'regionCode': 'US',\n",
       " 'pageInfo': {'totalResults': 1000000, 'resultsPerPage': 5},\n",
       " 'items': [{'kind': 'youtube#searchResult',\n",
       "   'etag': 'RXjJGl149u2Vsta4r7hcvxvJgIs',\n",
       "   'id': {'kind': 'youtube#video', 'videoId': 'TtxVGMWXMSE'},\n",
       "   'snippet': {'publishedAt': '2010-07-26T00:24:52Z',\n",
       "    'channelId': 'UCFe6jenM1Bc54qtBsIJGRZQ',\n",
       "    'title': 'Cramer&#39;s Rule to Solve a System of 3 Linear Equations - Example 1',\n",
       "    'description': 'Thanks to all of you who support me on Patreon. You da real mvps! $1 per month helps!! :) https://www.patreon.com/patrickjmt !',\n",
       "    'thumbnails': {'default': {'url': 'https://i.ytimg.com/vi/TtxVGMWXMSE/default.jpg',\n",
       "      'width': 120,\n",
       "      'height': 90},\n",
       "     'medium': {'url': 'https://i.ytimg.com/vi/TtxVGMWXMSE/mqdefault.jpg',\n",
       "      'width': 320,\n",
       "      'height': 180},\n",
       "     'high': {'url': 'https://i.ytimg.com/vi/TtxVGMWXMSE/hqdefault.jpg',\n",
       "      'width': 480,\n",
       "      'height': 360}},\n",
       "    'channelTitle': 'patrickJMT',\n",
       "    'liveBroadcastContent': 'none',\n",
       "    'publishTime': '2010-07-26T00:24:52Z'}},\n",
       "  {'kind': 'youtube#searchResult',\n",
       "   'etag': '7OpKBlR2suaUJJGcYj85quPMa8E',\n",
       "   'id': {'kind': 'youtube#video', 'videoId': 'CsTOUbeMPUo'},\n",
       "   'snippet': {'publishedAt': '2010-07-25T23:51:50Z',\n",
       "    'channelId': 'UCFe6jenM1Bc54qtBsIJGRZQ',\n",
       "    'title': '❖ Using Gauss-Jordan to Solve a System of Three Linear Equations - Example 1 ❖',\n",
       "    'description': 'Thanks to all of you who support me on Patreon. You da real mvps! $1 per month helps!! :) https://www.patreon.com/patrickjmt !',\n",
       "    'thumbnails': {'default': {'url': 'https://i.ytimg.com/vi/CsTOUbeMPUo/default.jpg',\n",
       "      'width': 120,\n",
       "      'height': 90},\n",
       "     'medium': {'url': 'https://i.ytimg.com/vi/CsTOUbeMPUo/mqdefault.jpg',\n",
       "      'width': 320,\n",
       "      'height': 180},\n",
       "     'high': {'url': 'https://i.ytimg.com/vi/CsTOUbeMPUo/hqdefault.jpg',\n",
       "      'width': 480,\n",
       "      'height': 360}},\n",
       "    'channelTitle': 'patrickJMT',\n",
       "    'liveBroadcastContent': 'none',\n",
       "    'publishTime': '2010-07-25T23:51:50Z'}},\n",
       "  {'kind': 'youtube#searchResult',\n",
       "   'etag': '2cDlRnSu4xhaB4kfwMl6yELsExs',\n",
       "   'id': {'kind': 'youtube#video', 'videoId': 'AUqeb9Z3y3k'},\n",
       "   'snippet': {'publishedAt': '2008-06-14T17:42:53Z',\n",
       "    'channelId': 'UC4a-Gbdw7vOaccHmFo40b9g',\n",
       "    'title': 'Matrices to solve a system of equations | Matrices | Precalculus | Khan Academy',\n",
       "    'description': 'Using the inverse of a matrix to solve a system of equations. Practice this yourself on Khan Academy right now: ...',\n",
       "    'thumbnails': {'default': {'url': 'https://i.ytimg.com/vi/AUqeb9Z3y3k/default.jpg',\n",
       "      'width': 120,\n",
       "      'height': 90},\n",
       "     'medium': {'url': 'https://i.ytimg.com/vi/AUqeb9Z3y3k/mqdefault.jpg',\n",
       "      'width': 320,\n",
       "      'height': 180},\n",
       "     'high': {'url': 'https://i.ytimg.com/vi/AUqeb9Z3y3k/hqdefault.jpg',\n",
       "      'width': 480,\n",
       "      'height': 360}},\n",
       "    'channelTitle': 'Khan Academy',\n",
       "    'liveBroadcastContent': 'none',\n",
       "    'publishTime': '2008-06-14T17:42:53Z'}},\n",
       "  {'kind': 'youtube#searchResult',\n",
       "   'etag': 'rY_ozZVh9XMOKXGXrgm6HEnmPWE',\n",
       "   'id': {'kind': 'youtube#video', 'videoId': 'eDb6iugi6Uk'},\n",
       "   'snippet': {'publishedAt': '2018-02-18T03:00:03Z',\n",
       "    'channelId': 'UCEWpbFLzoYGPfuWUMFPSaoA',\n",
       "    'title': 'Gaussian Elimination &amp; Row Echelon Form',\n",
       "    'description': 'This precalculus video tutorial provides a basic introduction into the gaussian elimination - a process that involves elementary row ...',\n",
       "    'thumbnails': {'default': {'url': 'https://i.ytimg.com/vi/eDb6iugi6Uk/default.jpg',\n",
       "      'width': 120,\n",
       "      'height': 90},\n",
       "     'medium': {'url': 'https://i.ytimg.com/vi/eDb6iugi6Uk/mqdefault.jpg',\n",
       "      'width': 320,\n",
       "      'height': 180},\n",
       "     'high': {'url': 'https://i.ytimg.com/vi/eDb6iugi6Uk/hqdefault.jpg',\n",
       "      'width': 480,\n",
       "      'height': 360}},\n",
       "    'channelTitle': 'The Organic Chemistry Tutor',\n",
       "    'liveBroadcastContent': 'none',\n",
       "    'publishTime': '2018-02-18T03:00:03Z'}},\n",
       "  {'kind': 'youtube#searchResult',\n",
       "   'etag': 'HtZHltqkhc72TZsl3-Qd_BBV3RI',\n",
       "   'id': {'kind': 'youtube#video', 'videoId': 'eYSASx8_nyg'},\n",
       "   'snippet': {'publishedAt': '2018-02-18T17:00:06Z',\n",
       "    'channelId': 'UCEWpbFLzoYGPfuWUMFPSaoA',\n",
       "    'title': 'Gauss Jordan Elimination &amp; Reduced Row Echelon Form',\n",
       "    'description': 'This precalculus video tutorial provides a basic introduction into the gauss jordan elimination which is a process used to solve a ...',\n",
       "    'thumbnails': {'default': {'url': 'https://i.ytimg.com/vi/eYSASx8_nyg/default.jpg',\n",
       "      'width': 120,\n",
       "      'height': 90},\n",
       "     'medium': {'url': 'https://i.ytimg.com/vi/eYSASx8_nyg/mqdefault.jpg',\n",
       "      'width': 320,\n",
       "      'height': 180},\n",
       "     'high': {'url': 'https://i.ytimg.com/vi/eYSASx8_nyg/hqdefault.jpg',\n",
       "      'width': 480,\n",
       "      'height': 360}},\n",
       "    'channelTitle': 'The Organic Chemistry Tutor',\n",
       "    'liveBroadcastContent': 'none',\n",
       "    'publishTime': '2018-02-18T17:00:06Z'}}]}"
      ]
     },
     "execution_count": 239,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 240,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Matrices to solve a system of equations | Matrices | Precalculus | Khan Academy 2008-06-14T17:42:53Z AUqeb9Z3y3k\n",
      "❖ Using Gauss-Jordan to Solve a System of Three Linear Equations - Example 1 ❖ 2010-07-25T23:51:50Z CsTOUbeMPUo\n",
      "Cramer&#39;s Rule to Solve a System of 3 Linear Equations - Example 1 2010-07-26T00:24:52Z TtxVGMWXMSE\n",
      "Gaussian Elimination &amp; Row Echelon Form 2018-02-18T03:00:03Z eDb6iugi6Uk\n",
      "Gauss Jordan Elimination &amp; Reduced Row Echelon Form 2018-02-18T17:00:06Z eYSASx8_nyg\n"
     ]
    }
   ],
   "source": [
    "#Printing just Title, time and videoID\n",
    "for item in sorted(results['items'], key=lambda x:x['snippet']['publishedAt']):\n",
    "    print(item['snippet']['title'], item['snippet']['publishedAt'], item['id']['videoId'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 241,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_title(item):\n",
    "    title = item['snippet']['title']\n",
    "    return title\n",
    "\n",
    "def get_thumbnail(item):\n",
    "    video_id = item['id']['videoId']\n",
    "    video_thumbnail = \"https://www.youtube.com/watch?v=\" + video_id + \"/default.jpg\"\n",
    "    return video_thumbnail\n",
    "\n",
    "def get_video_url(item):\n",
    "    video_id = item['id']['videoId']\n",
    "    video_url = \"https://img.youtube.com/vi/\" + video_id\n",
    "    return video_url\n",
    "\n",
    "def get_viewcount(item, youtube):\n",
    "    video_id = item['id']['videoId']\n",
    "    video_statistics = youtube.videos().list(id=video_id,\n",
    "                                        part='statistics').execute()\n",
    "    viewcount = int(video_statistics['items'][0]['statistics']['viewCount'])\n",
    "    return viewcount\n",
    "\n",
    "def get_likecount(item, youtube):\n",
    "    video_id = item['id']['videoId']\n",
    "    video_statistics = youtube.videos().list(id=video_id,\n",
    "                                        part='statistics').execute()\n",
    "    likecount = int(video_statistics['items'][0]['statistics']['likeCount'])\n",
    "    return likecount"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 242,
   "metadata": {},
   "outputs": [],
   "source": [
    "# refine this based on the feedback from the team \n",
    "def custom_score(likecount, viewcount) :\n",
    "    score = ( (likecount **2 + viewcount) / (viewcount))\n",
    "    return score"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 243,
   "metadata": {},
   "outputs": [],
   "source": [
    "def new_order(results, df, youtube_api):\n",
    "    i = 1\n",
    "    for item in results['items']:\n",
    "        title = get_title(item)\n",
    "        thumbnail = get_thumbnail(item)\n",
    "        viewcount = get_viewcount(item, youtube_api)\n",
    "        video_url = get_video_url(item)\n",
    "        likecount = get_likecount(item, youtube)\n",
    "        # dislikecount = get_dislikecount(item, youtube)\n",
    "        score = custom_score(likecount, viewcount)\n",
    "        \n",
    "        df.loc[i] = [title, thumbnail,video_url, 0, 0, score, viewcount, ]\n",
    "        i += 1\n",
    "    df = df.sort_values(['custom_score'], ascending=[0])\n",
    "    df = df.reset_index(drop=True)\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 244,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Initialise results dataframe\n",
    "df = pd.DataFrame(columns=('title', 'thumbnail', 'url', 'topics', 'keywords', 'custom_score', 'views'))\n",
    "\n",
    "youtube = build( 'youtube', 'V3', developerKey=api_key)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 245,
   "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>title</th>\n",
       "      <th>thumbnail</th>\n",
       "      <th>url</th>\n",
       "      <th>topics</th>\n",
       "      <th>keywords</th>\n",
       "      <th>custom_score</th>\n",
       "      <th>views</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gaussian Elimination &amp;amp; Row Echelon Form</td>\n",
       "      <td>https://www.youtube.com/watch?v=eDb6iugi6Uk/de...</td>\n",
       "      <td>https://img.youtube.com/vi/eDb6iugi6Uk</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>190.258198</td>\n",
       "      <td>1259621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Cramer&amp;#39;s Rule to Solve a System of 3 Linea...</td>\n",
       "      <td>https://www.youtube.com/watch?v=TtxVGMWXMSE/de...</td>\n",
       "      <td>https://img.youtube.com/vi/TtxVGMWXMSE</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>155.782691</td>\n",
       "      <td>1863182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gauss Jordan Elimination &amp;amp; Reduced Row Ech...</td>\n",
       "      <td>https://www.youtube.com/watch?v=eYSASx8_nyg/de...</td>\n",
       "      <td>https://img.youtube.com/vi/eYSASx8_nyg</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>139.540829</td>\n",
       "      <td>925597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>❖ Using Gauss-Jordan to Solve a System of Thre...</td>\n",
       "      <td>https://www.youtube.com/watch?v=CsTOUbeMPUo/de...</td>\n",
       "      <td>https://img.youtube.com/vi/CsTOUbeMPUo</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>49.210184</td>\n",
       "      <td>1696236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Matrices to solve a system of equations | Matr...</td>\n",
       "      <td>https://www.youtube.com/watch?v=AUqeb9Z3y3k/de...</td>\n",
       "      <td>https://img.youtube.com/vi/AUqeb9Z3y3k</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>21.673421</td>\n",
       "      <td>1449430</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               title  \\\n",
       "0        Gaussian Elimination &amp; Row Echelon Form   \n",
       "1  Cramer&#39;s Rule to Solve a System of 3 Linea...   \n",
       "2  Gauss Jordan Elimination &amp; Reduced Row Ech...   \n",
       "3  ❖ Using Gauss-Jordan to Solve a System of Thre...   \n",
       "4  Matrices to solve a system of equations | Matr...   \n",
       "\n",
       "                                           thumbnail  \\\n",
       "0  https://www.youtube.com/watch?v=eDb6iugi6Uk/de...   \n",
       "1  https://www.youtube.com/watch?v=TtxVGMWXMSE/de...   \n",
       "2  https://www.youtube.com/watch?v=eYSASx8_nyg/de...   \n",
       "3  https://www.youtube.com/watch?v=CsTOUbeMPUo/de...   \n",
       "4  https://www.youtube.com/watch?v=AUqeb9Z3y3k/de...   \n",
       "\n",
       "                                      url topics keywords  custom_score  \\\n",
       "0  https://img.youtube.com/vi/eDb6iugi6Uk      0        0    190.258198   \n",
       "1  https://img.youtube.com/vi/TtxVGMWXMSE      0        0    155.782691   \n",
       "2  https://img.youtube.com/vi/eYSASx8_nyg      0        0    139.540829   \n",
       "3  https://img.youtube.com/vi/CsTOUbeMPUo      0        0     49.210184   \n",
       "4  https://img.youtube.com/vi/AUqeb9Z3y3k      0        0     21.673421   \n",
       "\n",
       "     views  \n",
       "0  1259621  \n",
       "1  1863182  \n",
       "2   925597  \n",
       "3  1696236  \n",
       "4  1449430  "
      ]
     },
     "execution_count": 245,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_order(results, df, youtube)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.7.6 ('base')",
   "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"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "1da969944b67709d42dacef8c663e5092bbee8f367adb178b6f6b3d2cff99ba7"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}