Music_Lover.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "source": [
        "**Channel_details**\n",
        "\n",
        "\n",
        "\n"
      ],
      "metadata": {
        "id": "KUTp1YkqR6T8"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "import pandas as pd\n",
        "from googleapiclient.discovery import build\n",
        "from googleapiclient.errors import HttpError\n",
        "import os\n",
        "\n",
        "# Replace with your actual YouTube Data API key\n",
        "developer_key = os.environ.get('youtube_api_key', 'AIzaSyAOCs7as0LN3HIXGTpCZR4Oj1ivLw93eek')\n",
        "youtube = build('youtube', 'v3', developerKey=developer_key)\n",
        "\n",
        "# List of music channels' IDs\n",
        "music_channels = [\n",
        "    'UCq-Fj5jknLsUf-MWSy4_brA', 'UCbTLwN10NoCU4WDzLf1JMOA', 'UCFFbwnve3yF62-tVXkTyHqg',\n",
        "    'UCX52tYZiEh_mHoFja3Veciw', 'UCJrDMFOdv1I2k8n9oK_V21w', 'UC56gTxNs4f9xZ7Pa2i5xNzg',\n",
        "    'UC3MLnJtqc_phABBriLRhtgQ', 'UC_A7K2dXFsTMAciGmnNxy-Q', 'UCnrG75VRwdlp2wtwfpOCBRQ',\n",
        "    'UCUQg_UBQfVjptn7Wqcgzz-w', 'UCOsyDsO5tIt-VZ1iwjdQmew', 'UCjuV-yJ3ceiHI4ixglXxksA',\n",
        "    'UC783dnzJqf2ghHp_pFLYbGA', 'UCsaXTlOmt0o9aGeC_n_r8VQ', 'UCtGbExCzlwmsyWKpxLnyEww',\n",
        "    'UCcvNYxWXR_5TjVK7cSCdW-g', 'UColNRmGBE3dNzJ89zZZOh2Q', 'UClZF7OsrECe3t_ADrjZEh_Q',\n",
        "    'UCopY0NAzASqmD6eVaRj2TFQ', 'UCF8Ar7alYrtOI5SF6b7T0xA', 'UCQjHoPr0kqN83Mmihy7nsWw'\n",
        "]\n",
        "\n",
        "# Function to get channel details by ID (selecting desired fields)\n",
        "def get_channel_details(youtube, channel_ids):\n",
        "    all_data = []\n",
        "    for channel_id in channel_ids:\n",
        "        try:\n",
        "            request = youtube.channels().list(\n",
        "                part='snippet,statistics,contentDetails',  # Include contentDetails for relatedPlaylists\n",
        "                id=channel_id\n",
        "            )\n",
        "            response = request.execute()\n",
        "\n",
        "            # Check if response contains 'items' and is not empty\n",
        "            if 'items' in response and response['items']:\n",
        "                items = response['items'][0]  # Only considering the first item\n",
        "                data = {\n",
        "                    'Channel_name': items['snippet']['title'],\n",
        "                    'Subscribers': items['statistics']['subscriberCount'],\n",
        "                    'Views': items['statistics']['viewCount'],\n",
        "                    'Total_videos': items['statistics']['videoCount'],\n",
        "                    'playlist_id': items['contentDetails']['relatedPlaylists']['uploads']\n",
        "                }\n",
        "                all_data.append(data)\n",
        "            else:\n",
        "                print(f\"No data found for channel ID: {channel_id}\")\n",
        "\n",
        "        except HttpError as e:\n",
        "            print(f\"Error fetching details for channel ID {channel_id}. HttpError: {e.content}\")\n",
        "        except Exception as ex:\n",
        "            print(f\"An unexpected error occurred for channel ID {channel_id}. Error: {ex}\")\n",
        "\n",
        "    return all_data\n",
        "\n",
        "# Get channel details\n",
        "channel_details = get_channel_details(youtube, music_channels)\n",
        "\n",
        "# Create DataFrame and save to CSV\n",
        "if channel_details:\n",
        "    channel_data = pd.DataFrame(channel_details)\n",
        "    channel_data.to_csv('combined_channel_details.csv', index=False)  # Save to CSV\n",
        "    print(\"Channel details saved to combined_channel_details.csv\")\n",
        "else:\n",
        "    print(\"No channel details to save.\")\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "6KOyoTYfa7j9",
        "outputId": "2557237f-a27b-48fb-fa80-c4f191533d25"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Channel details saved to combined_channel_details.csv\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.read_csv('/content/combined_channel_details.csv')\n",
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 728
        },
        "id": "wiiAtrmWcFHx",
        "outputId": "9e7686b8-c8a0-4ba5-e782-7761e192e49a"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "            Channel_name  Subscribers         Views  Total_videos  \\\n",
              "0               T-Series    258000000  239561470142         20140   \n",
              "1                    YRF     58100000   38898683628          3937   \n",
              "2      Zee Music Company    104000000   63470338879          9916   \n",
              "3         Eros Now Music     33500000   18569919485          9848   \n",
              "4          Tips Official     63300000   36469998453          5392   \n",
              "5       Sony Music India     59100000   30614006095          4328   \n",
              "6     SonyMusicIndiaVEVO     48900000   29450484514          3641   \n",
              "7         Saregama Music     39000000   18245886131          8329   \n",
              "8                  Sanam     11100000    2628109515           148   \n",
              "9                Badshah      7330000    2405966921           187   \n",
              "10         Speed Records     43300000   27908287702         11231   \n",
              "11         Crown Records      5560000    1996261754           231   \n",
              "12    DM - Desi Melodies     18800000    6499887401           102   \n",
              "13        RUN-UP RECORDS      2980000    1789476233            49   \n",
              "14                 SHUBH      4300000    1524219603            26   \n",
              "15  T-Series Apna Punjab     35800000   22637476206          8116   \n",
              "16      Brown Town Music      3010000    1852399293           138   \n",
              "17              Geet MP3     34900000   13294532433           702   \n",
              "18        Ishtar Punjabi     23500000   11500551646          6345   \n",
              "19          Tips Punjabi      3550000    1711671946           929   \n",
              "20   Fresh Media Records      7150000    3262476857           266   \n",
              "\n",
              "                 playlist_id  \n",
              "0   UUq-Fj5jknLsUf-MWSy4_brA  \n",
              "1   UUbTLwN10NoCU4WDzLf1JMOA  \n",
              "2   UUFFbwnve3yF62-tVXkTyHqg  \n",
              "3   UUX52tYZiEh_mHoFja3Veciw  \n",
              "4   UUJrDMFOdv1I2k8n9oK_V21w  \n",
              "5   UU56gTxNs4f9xZ7Pa2i5xNzg  \n",
              "6   UU3MLnJtqc_phABBriLRhtgQ  \n",
              "7   UU_A7K2dXFsTMAciGmnNxy-Q  \n",
              "8   UUnrG75VRwdlp2wtwfpOCBRQ  \n",
              "9   UUUQg_UBQfVjptn7Wqcgzz-w  \n",
              "10  UUOsyDsO5tIt-VZ1iwjdQmew  \n",
              "11  UUjuV-yJ3ceiHI4ixglXxksA  \n",
              "12  UU783dnzJqf2ghHp_pFLYbGA  \n",
              "13  UUsaXTlOmt0o9aGeC_n_r8VQ  \n",
              "14  UUtGbExCzlwmsyWKpxLnyEww  \n",
              "15  UUcvNYxWXR_5TjVK7cSCdW-g  \n",
              "16  UUolNRmGBE3dNzJ89zZZOh2Q  \n",
              "17  UUlZF7OsrECe3t_ADrjZEh_Q  \n",
              "18  UUopY0NAzASqmD6eVaRj2TFQ  \n",
              "19  UUF8Ar7alYrtOI5SF6b7T0xA  \n",
              "20  UUQjHoPr0kqN83Mmihy7nsWw  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-5a65cf92-30a1-4d3d-a233-f98bded5ed66\" class=\"colab-df-container\">\n",
              "    <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>Channel_name</th>\n",
              "      <th>Subscribers</th>\n",
              "      <th>Views</th>\n",
              "      <th>Total_videos</th>\n",
              "      <th>playlist_id</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>T-Series</td>\n",
              "      <td>258000000</td>\n",
              "      <td>239561470142</td>\n",
              "      <td>20140</td>\n",
              "      <td>UUq-Fj5jknLsUf-MWSy4_brA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>YRF</td>\n",
              "      <td>58100000</td>\n",
              "      <td>38898683628</td>\n",
              "      <td>3937</td>\n",
              "      <td>UUbTLwN10NoCU4WDzLf1JMOA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Zee Music Company</td>\n",
              "      <td>104000000</td>\n",
              "      <td>63470338879</td>\n",
              "      <td>9916</td>\n",
              "      <td>UUFFbwnve3yF62-tVXkTyHqg</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Eros Now Music</td>\n",
              "      <td>33500000</td>\n",
              "      <td>18569919485</td>\n",
              "      <td>9848</td>\n",
              "      <td>UUX52tYZiEh_mHoFja3Veciw</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Tips Official</td>\n",
              "      <td>63300000</td>\n",
              "      <td>36469998453</td>\n",
              "      <td>5392</td>\n",
              "      <td>UUJrDMFOdv1I2k8n9oK_V21w</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Sony Music India</td>\n",
              "      <td>59100000</td>\n",
              "      <td>30614006095</td>\n",
              "      <td>4328</td>\n",
              "      <td>UU56gTxNs4f9xZ7Pa2i5xNzg</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>SonyMusicIndiaVEVO</td>\n",
              "      <td>48900000</td>\n",
              "      <td>29450484514</td>\n",
              "      <td>3641</td>\n",
              "      <td>UU3MLnJtqc_phABBriLRhtgQ</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Saregama Music</td>\n",
              "      <td>39000000</td>\n",
              "      <td>18245886131</td>\n",
              "      <td>8329</td>\n",
              "      <td>UU_A7K2dXFsTMAciGmnNxy-Q</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Sanam</td>\n",
              "      <td>11100000</td>\n",
              "      <td>2628109515</td>\n",
              "      <td>148</td>\n",
              "      <td>UUnrG75VRwdlp2wtwfpOCBRQ</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Badshah</td>\n",
              "      <td>7330000</td>\n",
              "      <td>2405966921</td>\n",
              "      <td>187</td>\n",
              "      <td>UUUQg_UBQfVjptn7Wqcgzz-w</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Speed Records</td>\n",
              "      <td>43300000</td>\n",
              "      <td>27908287702</td>\n",
              "      <td>11231</td>\n",
              "      <td>UUOsyDsO5tIt-VZ1iwjdQmew</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Crown Records</td>\n",
              "      <td>5560000</td>\n",
              "      <td>1996261754</td>\n",
              "      <td>231</td>\n",
              "      <td>UUjuV-yJ3ceiHI4ixglXxksA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>DM - Desi Melodies</td>\n",
              "      <td>18800000</td>\n",
              "      <td>6499887401</td>\n",
              "      <td>102</td>\n",
              "      <td>UU783dnzJqf2ghHp_pFLYbGA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>RUN-UP RECORDS</td>\n",
              "      <td>2980000</td>\n",
              "      <td>1789476233</td>\n",
              "      <td>49</td>\n",
              "      <td>UUsaXTlOmt0o9aGeC_n_r8VQ</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>SHUBH</td>\n",
              "      <td>4300000</td>\n",
              "      <td>1524219603</td>\n",
              "      <td>26</td>\n",
              "      <td>UUtGbExCzlwmsyWKpxLnyEww</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>T-Series Apna Punjab</td>\n",
              "      <td>35800000</td>\n",
              "      <td>22637476206</td>\n",
              "      <td>8116</td>\n",
              "      <td>UUcvNYxWXR_5TjVK7cSCdW-g</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Brown Town Music</td>\n",
              "      <td>3010000</td>\n",
              "      <td>1852399293</td>\n",
              "      <td>138</td>\n",
              "      <td>UUolNRmGBE3dNzJ89zZZOh2Q</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Geet MP3</td>\n",
              "      <td>34900000</td>\n",
              "      <td>13294532433</td>\n",
              "      <td>702</td>\n",
              "      <td>UUlZF7OsrECe3t_ADrjZEh_Q</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Ishtar Punjabi</td>\n",
              "      <td>23500000</td>\n",
              "      <td>11500551646</td>\n",
              "      <td>6345</td>\n",
              "      <td>UUopY0NAzASqmD6eVaRj2TFQ</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Tips Punjabi</td>\n",
              "      <td>3550000</td>\n",
              "      <td>1711671946</td>\n",
              "      <td>929</td>\n",
              "      <td>UUF8Ar7alYrtOI5SF6b7T0xA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Fresh Media Records</td>\n",
              "      <td>7150000</td>\n",
              "      <td>3262476857</td>\n",
              "      <td>266</td>\n",
              "      <td>UUQjHoPr0kqN83Mmihy7nsWw</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5a65cf92-30a1-4d3d-a233-f98bded5ed66')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-5a65cf92-30a1-4d3d-a233-f98bded5ed66 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-5a65cf92-30a1-4d3d-a233-f98bded5ed66');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-7bdd0454-fb67-4c84-a57b-816019b0b3a4\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-7bdd0454-fb67-4c84-a57b-816019b0b3a4')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-7bdd0454-fb67-4c84-a57b-816019b0b3a4 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_eccafaf4-dff3-4bb3-92f4-6a57626cd1bb\">\n",
              "    <style>\n",
              "      .colab-df-generate {\n",
              "        background-color: #E8F0FE;\n",
              "        border: none;\n",
              "        border-radius: 50%;\n",
              "        cursor: pointer;\n",
              "        display: none;\n",
              "        fill: #1967D2;\n",
              "        height: 32px;\n",
              "        padding: 0 0 0 0;\n",
              "        width: 32px;\n",
              "      }\n",
              "\n",
              "      .colab-df-generate:hover {\n",
              "        background-color: #E2EBFA;\n",
              "        box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "        fill: #174EA6;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate:hover {\n",
              "        background-color: #434B5C;\n",
              "        box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "        filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "        fill: #FFFFFF;\n",
              "      }\n",
              "    </style>\n",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('df')\"\n",
              "            title=\"Generate code using this dataframe.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_eccafaf4-dff3-4bb3-92f4-6a57626cd1bb button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('df');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "****"
      ],
      "metadata": {
        "id": "KLaT9cFfwfyD"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "**Generate_CSV**"
      ],
      "metadata": {
        "id": "7gLeuFn3whMX"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "import pandas as pd\n",
        "from googleapiclient.discovery import build\n",
        "from googleapiclient.errors import HttpError\n",
        "import time\n",
        "\n",
        "# Replace with your actual YouTube Data API key\n",
        "developer_key = 'AIzaSyAOCs7as0LN3HIXGTpCZR4Oj1ivLw93eek'\n",
        "youtube = build('youtube', 'v3', developerKey=developer_key)\n",
        "\n",
        "# List of music channels' IDs\n",
        "music_channels = [\n",
        "    'UCq-Fj5jknLsUf-MWSy4_brA', 'UCbTLwN10NoCU4WDzLf1JMOA', 'UCFFbwnve3yF62-tVXkTyHqg',\n",
        "    'UCX52tYZiEh_mHoFja3Veciw', 'UCJrDMFOdv1I2k8n9oK_V21w', 'UC56gTxNs4f9xZ7Pa2i5xNzg',\n",
        "    'UC3MLnJtqc_phABBriLRhtgQ', 'UC_A7K2dXFsTMAciGmnNxy-Q', 'UCnrG75VRwdlp2wtwfpOCBRQ',\n",
        "    'UCUQg_UBQfVjptn7Wqcgzz-w', 'UCOsyDsO5tIt-VZ1iwjdQmew', 'UCjuV-yJ3ceiHI4ixglXxksA',\n",
        "    'UC783dnzJqf2ghHp_pFLYbGA', 'UCsaXTlOmt0o9aGeC_n_r8VQ', 'UCtGbExCzlwmsyWKpxLnyEww',\n",
        "    'UCcvNYxWXR_5TjVK7cSCdW-g', 'UColNRmGBE3dNzJ89zZZOh2Q', 'UClZF7OsrECe3t_ADrjZEh_Q',\n",
        "    'UCopY0NAzASqmD6eVaRj2TFQ', 'UCF8Ar7alYrtOI5SF6b7T0xA', 'UCQjHoPr0kqN83Mmihy7nsWw'\n",
        "]\n",
        "\n",
        "def get_channel_videos(youtube, channel_id):\n",
        "    video_ids = []\n",
        "    playlist_id = get_channel_playlist_id(youtube, channel_id)\n",
        "\n",
        "    next_page_token = None\n",
        "    while True:\n",
        "        try:\n",
        "            response = youtube.playlistItems().list(\n",
        "                part='contentDetails',\n",
        "                playlistId=playlist_id,\n",
        "                maxResults=50,\n",
        "                pageToken=next_page_token\n",
        "            ).execute()\n",
        "\n",
        "            video_ids.extend([item['contentDetails']['videoId'] for item in response.get('items', [])])\n",
        "            next_page_token = response.get('nextPageToken')\n",
        "            if not next_page_token:\n",
        "                break\n",
        "\n",
        "        except HttpError as e:\n",
        "            if e.resp.status == 403 and 'quotaExceeded' in str(e):\n",
        "                print(\"Quota exceeded. Waiting for a minute before retrying...\")\n",
        "                time.sleep(60)\n",
        "                continue\n",
        "            else:\n",
        "                print(f\"An HTTP error occurred: {e}\")\n",
        "                break  # Handle other HTTP errors gracefully or retry\n",
        "\n",
        "    video_details = []\n",
        "    for i in range(0, len(video_ids), 50):\n",
        "        response = youtube.videos().list(\n",
        "            part='snippet,statistics',\n",
        "            id=','.join(video_ids[i:i + 50])\n",
        "        ).execute()\n",
        "\n",
        "        video_details.extend([\n",
        "            {\n",
        "                'Title': video['snippet']['title'],\n",
        "                'Video_URL': f'https://www.youtube.com/watch?v={video[\"id\"]}',\n",
        "                'Views': video['statistics'].get('viewCount', 0)\n",
        "            } for video in response.get('items', [])\n",
        "        ])\n",
        "\n",
        "    return video_details\n",
        "\n",
        "def get_channel_playlist_id(youtube, channel_id):\n",
        "    channel_response = youtube.channels().list(\n",
        "        part='contentDetails',\n",
        "        id=channel_id\n",
        "    ).execute()\n",
        "    return channel_response['items'][0]['contentDetails']['relatedPlaylists']['uploads']\n",
        "\n",
        "# Main code for top songs\n",
        "all_top_videos = []\n",
        "\n",
        "for channel_id in music_channels:\n",
        "    channel_videos = get_channel_videos(youtube, channel_id)\n",
        "    time.sleep(1)  # Sleep to avoid reaching API quota limits\n",
        "    top_videos = [video for video in channel_videos if int(video['Views']) > 100000000]\n",
        "    all_top_videos.extend(top_videos)\n",
        "\n",
        "# Create a pandas DataFrame and save as a CSV file\n",
        "if all_top_videos:\n",
        "    pd.DataFrame(all_top_videos).to_csv('top_songs.csv', index=False)\n",
        "    print(\"Top songs details saved to top_songs.csv\")\n",
        "else:\n",
        "    print(\"No top songs details to save.\")\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "IqVk35FrrSFY",
        "outputId": "9634c693-0a75-42bc-d0a9-2f4fc2e074be"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Top songs details saved to top_songs.csv\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import pandas as pd\n",
        "\n",
        "# Read the CSV file\n",
        "df = pd.read_csv('/content/top_songs.csv')\n",
        "\n",
        "# Sort the DataFrame by 'Views' in descending order\n",
        "df_sorted = df.sort_values(by='Views', ascending=False)\n",
        "\n",
        "# Reset the index to start from 1\n",
        "df_sorted.reset_index(drop=True, inplace=True)\n",
        "\n",
        "# Save the sorted DataFrame back to the CSV file\n",
        "df_sorted.to_csv('/content/top_songs_sorted.csv', index=False)\n",
        "\n",
        "# Display the sorted DataFrame\n",
        "df_sorted\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "TgIDaPQIrq7p",
        "outputId": "7b81dec1-3746-473d-e2ac-965734bd3928"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                                  Title  \\\n",
              "0     Lehanga : Jass Manak (Official Video) Satti Dh...   \n",
              "1     Vaaste Song: Dhvani Bhanushali, Tanishk Bagchi...   \n",
              "2     Laung Laachi Title Song | Mannat Noor | Ammy V...   \n",
              "3     Lut Gaye (Full Song) Emraan Hashmi, Yukti | Ju...   \n",
              "4     Mile Ho Tum - Reprise Version | Neha Kakkar | ...   \n",
              "...                                                 ...   \n",
              "1216  Deva Deva - Brahmāstra | Amitabh B | Ranbir Ka...   \n",
              "1217  'Tu Jo Mila' VIDEO Song - K.K. Pritam | Salman...   \n",
              "1218  Gippy Grewal Feat Bohemia: Car Nachdi Official...   \n",
              "1219  Makhna : Bade Miyan Chote Miyan | Madhuri, Ami...   \n",
              "1220  Love You Zindagi Full Video - Dear Zindagi|Ali...   \n",
              "\n",
              "                                        Video_URL       Views  \n",
              "0     https://www.youtube.com/watch?v=RKioDWlajvo  1666731087  \n",
              "1     https://www.youtube.com/watch?v=BBAyRBTfsOU  1563801806  \n",
              "2     https://www.youtube.com/watch?v=YpkJO_GrCo0  1511792128  \n",
              "3     https://www.youtube.com/watch?v=sCbbMZ-q4-I  1363999468  \n",
              "4     https://www.youtube.com/watch?v=N2-HsIYd0Go  1307986422  \n",
              "...                                           ...         ...  \n",
              "1216  https://www.youtube.com/watch?v=WjAPDofGg28   100268413  \n",
              "1217  https://www.youtube.com/watch?v=6DCOjq0omBc   100242502  \n",
              "1218  https://www.youtube.com/watch?v=aIeTcUBTd04   100158213  \n",
              "1219  https://www.youtube.com/watch?v=YfQ-3d5cFeo   100148967  \n",
              "1220  https://www.youtube.com/watch?v=bw7bVpI5VcM   100141555  \n",
              "\n",
              "[1221 rows x 3 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-28abdff8-563d-4e36-b89f-30827269261b\" class=\"colab-df-container\">\n",
              "    <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>Video_URL</th>\n",
              "      <th>Views</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Lehanga : Jass Manak (Official Video) Satti Dh...</td>\n",
              "      <td>https://www.youtube.com/watch?v=RKioDWlajvo</td>\n",
              "      <td>1666731087</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Vaaste Song: Dhvani Bhanushali, Tanishk Bagchi...</td>\n",
              "      <td>https://www.youtube.com/watch?v=BBAyRBTfsOU</td>\n",
              "      <td>1563801806</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Laung Laachi Title Song | Mannat Noor | Ammy V...</td>\n",
              "      <td>https://www.youtube.com/watch?v=YpkJO_GrCo0</td>\n",
              "      <td>1511792128</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Lut Gaye (Full Song) Emraan Hashmi, Yukti | Ju...</td>\n",
              "      <td>https://www.youtube.com/watch?v=sCbbMZ-q4-I</td>\n",
              "      <td>1363999468</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Mile Ho Tum - Reprise Version | Neha Kakkar | ...</td>\n",
              "      <td>https://www.youtube.com/watch?v=N2-HsIYd0Go</td>\n",
              "      <td>1307986422</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1216</th>\n",
              "      <td>Deva Deva - Brahmāstra | Amitabh B | Ranbir Ka...</td>\n",
              "      <td>https://www.youtube.com/watch?v=WjAPDofGg28</td>\n",
              "      <td>100268413</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1217</th>\n",
              "      <td>'Tu Jo Mila' VIDEO Song - K.K. Pritam | Salman...</td>\n",
              "      <td>https://www.youtube.com/watch?v=6DCOjq0omBc</td>\n",
              "      <td>100242502</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1218</th>\n",
              "      <td>Gippy Grewal Feat Bohemia: Car Nachdi Official...</td>\n",
              "      <td>https://www.youtube.com/watch?v=aIeTcUBTd04</td>\n",
              "      <td>100158213</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1219</th>\n",
              "      <td>Makhna : Bade Miyan Chote Miyan | Madhuri, Ami...</td>\n",
              "      <td>https://www.youtube.com/watch?v=YfQ-3d5cFeo</td>\n",
              "      <td>100148967</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1220</th>\n",
              "      <td>Love You Zindagi Full Video - Dear Zindagi|Ali...</td>\n",
              "      <td>https://www.youtube.com/watch?v=bw7bVpI5VcM</td>\n",
              "      <td>100141555</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1221 rows × 3 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-28abdff8-563d-4e36-b89f-30827269261b')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-28abdff8-563d-4e36-b89f-30827269261b button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-28abdff8-563d-4e36-b89f-30827269261b');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-885f88f4-2bd9-434d-aaf9-34907a11c8d4\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-885f88f4-2bd9-434d-aaf9-34907a11c8d4')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-885f88f4-2bd9-434d-aaf9-34907a11c8d4 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_25ed1daf-0077-4a00-8f83-d396c4cd50df\">\n",
              "    <style>\n",
              "      .colab-df-generate {\n",
              "        background-color: #E8F0FE;\n",
              "        border: none;\n",
              "        border-radius: 50%;\n",
              "        cursor: pointer;\n",
              "        display: none;\n",
              "        fill: #1967D2;\n",
              "        height: 32px;\n",
              "        padding: 0 0 0 0;\n",
              "        width: 32px;\n",
              "      }\n",
              "\n",
              "      .colab-df-generate:hover {\n",
              "        background-color: #E2EBFA;\n",
              "        box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "        fill: #174EA6;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate:hover {\n",
              "        background-color: #434B5C;\n",
              "        box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "        filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "        fill: #FFFFFF;\n",
              "      }\n",
              "    </style>\n",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('df_sorted')\"\n",
              "            title=\"Generate code using this dataframe.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_25ed1daf-0077-4a00-8f83-d396c4cd50df button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('df_sorted');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "LhAGuzz6tgbC"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}