pandas_in_act_hw12.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyNXpJAVBd7Gm9PCCxH0Tbs6",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Sinrez/PythonProjects/blob/main/pandas_in_act_hw12.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 143
        },
        "id": "qfrC9I-ZfEjY",
        "outputId": "f1e9c094-8992-4e92-8c7a-5db74c543117"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                               shows\n",
              "0  {'show': 'The X-Files', 'runtime': 60, 'networ...\n",
              "1  {'show': 'Lost', 'runtime': 60, 'network': 'AB...\n",
              "2  {'show': 'Buffy the Vampire Slayer', 'runtime'..."
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-8dacda7a-bcf9-4366-a592-8512f0d847a4\">\n",
              "    <div 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>shows</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>{'show': 'The X-Files', 'runtime': 60, 'networ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>{'show': 'Lost', 'runtime': 60, 'network': 'AB...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>{'show': 'Buffy the Vampire Slayer', 'runtime'...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8dacda7a-bcf9-4366-a592-8512f0d847a4')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-404929f6-bac4-4f24-b665-60a1e758b1e7\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-404929f6-bac4-4f24-b665-60a1e758b1e7')\"\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",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\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-quickchart: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-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart: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",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-404929f6-bac4-4f24-b665-60a1e758b1e7 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-8dacda7a-bcf9-4366-a592-8512f0d847a4 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-8dacda7a-bcf9-4366-a592-8512f0d847a4');\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",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 1
        }
      ],
      "source": [
        "import pandas as pd\n",
        "tv_shows_json = pd.read_json(\"tv_shows.json\")\n",
        "tv_shows_json"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "tv_shows_json.loc[0, \"shows\"]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "b1JGjC7sfZX6",
        "outputId": "9b5f71fc-9464-4141-89e1-cb74b89058b6"
      },
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'show': 'The X-Files',\n",
              " 'runtime': 60,\n",
              " 'network': 'FOX',\n",
              " 'episodes': [{'season': 1,\n",
              "   'episode': 1,\n",
              "   'name': 'Pilot',\n",
              "   'air_date': '1993-09-11 01:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 2,\n",
              "   'name': 'Deep Throat',\n",
              "   'air_date': '1993-09-18 01:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 3,\n",
              "   'name': 'Squeeze',\n",
              "   'air_date': '1993-09-25 01:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 4,\n",
              "   'name': 'Conduit',\n",
              "   'air_date': '1993-10-02 01:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 5,\n",
              "   'name': 'The Jersey Devil',\n",
              "   'air_date': '1993-10-09 01:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 6,\n",
              "   'name': 'Shadows',\n",
              "   'air_date': '1993-10-23 01:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 7,\n",
              "   'name': 'Ghost in the Machine',\n",
              "   'air_date': '1993-10-30 01:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 8,\n",
              "   'name': 'Ice',\n",
              "   'air_date': '1993-11-06 02:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 9,\n",
              "   'name': 'Space',\n",
              "   'air_date': '1993-11-13 02:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 10,\n",
              "   'name': 'Fallen Angel',\n",
              "   'air_date': '1993-11-20 02:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 11,\n",
              "   'name': 'Eve',\n",
              "   'air_date': '1993-12-11 02:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 12,\n",
              "   'name': 'Fire',\n",
              "   'air_date': '1993-12-18 02:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 13,\n",
              "   'name': 'Beyond the Sea',\n",
              "   'air_date': '1994-01-08 02:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 14,\n",
              "   'name': 'Gender Bender',\n",
              "   'air_date': '1994-01-22 02:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 15,\n",
              "   'name': 'Lazarus',\n",
              "   'air_date': '1994-02-05 02:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 16,\n",
              "   'name': 'Young at Heart',\n",
              "   'air_date': '1994-02-12 02:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 17,\n",
              "   'name': 'E.B.E.',\n",
              "   'air_date': '1994-02-19 02:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 18,\n",
              "   'name': 'Miracle Man',\n",
              "   'air_date': '1994-03-19 02:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 19,\n",
              "   'name': 'Shapes',\n",
              "   'air_date': '1994-04-02 02:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 20,\n",
              "   'name': 'Darkness Falls',\n",
              "   'air_date': '1994-04-16 01:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 21,\n",
              "   'name': 'Tooms',\n",
              "   'air_date': '1994-04-23 01:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 22,\n",
              "   'name': 'Born Again',\n",
              "   'air_date': '1994-04-30 01:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 23,\n",
              "   'name': 'Roland',\n",
              "   'air_date': '1994-05-07 01:00:00'},\n",
              "  {'season': 1,\n",
              "   'episode': 24,\n",
              "   'name': 'The Erlenmeyer Flask',\n",
              "   'air_date': '1994-05-14 01:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 1,\n",
              "   'name': 'Little Green Men',\n",
              "   'air_date': '1994-09-17 01:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 2,\n",
              "   'name': 'The Host',\n",
              "   'air_date': '1994-09-24 01:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 3,\n",
              "   'name': 'Blood',\n",
              "   'air_date': '1994-10-01 01:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 4,\n",
              "   'name': 'Sleepless',\n",
              "   'air_date': '1994-10-08 01:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 5,\n",
              "   'name': 'Duane Barry (1)',\n",
              "   'air_date': '1994-10-15 01:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 6,\n",
              "   'name': 'Ascension (2)',\n",
              "   'air_date': '1994-10-22 01:00:00'},\n",
              "  {'season': 2, 'episode': 7, 'name': '3', 'air_date': '1994-11-05 02:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 8,\n",
              "   'name': 'One Breath',\n",
              "   'air_date': '1994-11-12 02:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 9,\n",
              "   'name': 'Firewalker',\n",
              "   'air_date': '1994-11-19 02:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 10,\n",
              "   'name': 'Red Museum',\n",
              "   'air_date': '1994-12-10 02:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 11,\n",
              "   'name': 'Excelsis Dei',\n",
              "   'air_date': '1994-12-17 02:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 12,\n",
              "   'name': 'Aubrey',\n",
              "   'air_date': '1995-01-07 02:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 13,\n",
              "   'name': 'Irresistible',\n",
              "   'air_date': '1995-01-14 02:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 14,\n",
              "   'name': 'Die Hand die Verletzt',\n",
              "   'air_date': '1995-01-28 02:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 15,\n",
              "   'name': 'Fresh Bones',\n",
              "   'air_date': '1995-02-04 02:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 16,\n",
              "   'name': 'Colony (1)',\n",
              "   'air_date': '1995-02-11 02:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 17,\n",
              "   'name': 'End Game (2)',\n",
              "   'air_date': '1995-02-18 02:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 18,\n",
              "   'name': 'Fearful Symmetry',\n",
              "   'air_date': '1995-02-25 02:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 19,\n",
              "   'name': 'Død Kalm',\n",
              "   'air_date': '1995-03-11 02:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 20,\n",
              "   'name': 'Humbug',\n",
              "   'air_date': '1995-04-01 02:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 21,\n",
              "   'name': 'The Calusari',\n",
              "   'air_date': '1995-04-15 01:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 22,\n",
              "   'name': 'F. Emasculata',\n",
              "   'air_date': '1995-04-29 01:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 23,\n",
              "   'name': 'Soft Light',\n",
              "   'air_date': '1995-05-06 01:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 24,\n",
              "   'name': 'Our Town',\n",
              "   'air_date': '1995-05-13 01:00:00'},\n",
              "  {'season': 2,\n",
              "   'episode': 25,\n",
              "   'name': 'Anasazi',\n",
              "   'air_date': '1995-05-20 01:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 1,\n",
              "   'name': 'The Blessing Way',\n",
              "   'air_date': '1995-09-23 01:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 2,\n",
              "   'name': 'Paper Clip',\n",
              "   'air_date': '1995-09-30 01:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 3,\n",
              "   'name': 'D.P.O.',\n",
              "   'air_date': '1995-10-07 01:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 4,\n",
              "   'name': \"Clyde Bruckman's Final Repose\",\n",
              "   'air_date': '1995-10-14 01:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 5,\n",
              "   'name': 'The List',\n",
              "   'air_date': '1995-10-21 01:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 6,\n",
              "   'name': '2Shy',\n",
              "   'air_date': '1995-11-04 02:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 7,\n",
              "   'name': 'The Walk',\n",
              "   'air_date': '1995-11-11 02:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 8,\n",
              "   'name': 'Oubliette',\n",
              "   'air_date': '1995-11-18 02:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 9,\n",
              "   'name': 'Nisei (1)',\n",
              "   'air_date': '1995-11-25 02:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 10,\n",
              "   'name': '731 (2)',\n",
              "   'air_date': '1995-12-02 02:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 11,\n",
              "   'name': 'Revelations',\n",
              "   'air_date': '1995-12-16 02:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 12,\n",
              "   'name': 'War of the Coprophages',\n",
              "   'air_date': '1996-01-06 02:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 13,\n",
              "   'name': 'Syzygy',\n",
              "   'air_date': '1996-01-27 02:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 14,\n",
              "   'name': 'Grotesque',\n",
              "   'air_date': '1996-02-03 02:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 15,\n",
              "   'name': 'Piper Maru (1)',\n",
              "   'air_date': '1996-02-10 02:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 16,\n",
              "   'name': 'Apocrypha (2)',\n",
              "   'air_date': '1996-02-17 02:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 17,\n",
              "   'name': 'Pusher',\n",
              "   'air_date': '1996-02-24 02:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 18,\n",
              "   'name': 'Teso dos Bichos',\n",
              "   'air_date': '1996-03-09 02:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 19,\n",
              "   'name': 'Hell Money',\n",
              "   'air_date': '1996-03-30 02:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 20,\n",
              "   'name': \"Jose Chung's 'From Outer Space'\",\n",
              "   'air_date': '1996-04-13 01:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 21,\n",
              "   'name': 'Avatar',\n",
              "   'air_date': '1996-04-27 01:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 22,\n",
              "   'name': 'Quagmire',\n",
              "   'air_date': '1996-05-04 01:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 23,\n",
              "   'name': 'Wetwired',\n",
              "   'air_date': '1996-05-11 01:00:00'},\n",
              "  {'season': 3,\n",
              "   'episode': 24,\n",
              "   'name': 'Talitha Cumi (1)',\n",
              "   'air_date': '1996-05-18 01:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 1,\n",
              "   'name': 'Herrenvolk (2)',\n",
              "   'air_date': '1996-10-05 01:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 2,\n",
              "   'name': 'Home',\n",
              "   'air_date': '1996-10-12 01:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 3,\n",
              "   'name': 'Teliko',\n",
              "   'air_date': '1996-10-19 01:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 4,\n",
              "   'name': 'Unruhe',\n",
              "   'air_date': '1996-10-28 02:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 5,\n",
              "   'name': 'The Field Where I Died',\n",
              "   'air_date': '1996-11-04 02:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 6,\n",
              "   'name': 'Sanguinarium',\n",
              "   'air_date': '1996-11-11 02:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 7,\n",
              "   'name': 'Musings of a Cigarette-Smoking Man',\n",
              "   'air_date': '1996-11-18 02:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 8,\n",
              "   'name': 'Tunguska (1)',\n",
              "   'air_date': '1996-11-25 02:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 9,\n",
              "   'name': 'Terma (2)',\n",
              "   'air_date': '1996-12-02 02:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 10,\n",
              "   'name': 'Paper Hearts',\n",
              "   'air_date': '1996-12-16 02:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 11,\n",
              "   'name': 'El Mundo Gira',\n",
              "   'air_date': '1997-01-13 02:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 12,\n",
              "   'name': 'Leonard Betts',\n",
              "   'air_date': '1997-01-27 02:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 13,\n",
              "   'name': 'Never Again',\n",
              "   'air_date': '1997-02-03 02:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 14,\n",
              "   'name': 'Memento Mori',\n",
              "   'air_date': '1997-02-10 02:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 15,\n",
              "   'name': 'Kaddish',\n",
              "   'air_date': '1997-02-17 02:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 16,\n",
              "   'name': 'Unrequited',\n",
              "   'air_date': '1997-02-24 02:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 17,\n",
              "   'name': 'Tempus Fugit (1)',\n",
              "   'air_date': '1997-03-17 02:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 18,\n",
              "   'name': 'Max (2)',\n",
              "   'air_date': '1997-03-24 02:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 19,\n",
              "   'name': 'Synchrony',\n",
              "   'air_date': '1997-04-14 01:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 20,\n",
              "   'name': 'Small Potatoes',\n",
              "   'air_date': '1997-04-21 01:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 21,\n",
              "   'name': 'Zero Sum',\n",
              "   'air_date': '1997-04-28 01:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 22,\n",
              "   'name': 'Elegy',\n",
              "   'air_date': '1997-05-05 01:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 23,\n",
              "   'name': 'Demons',\n",
              "   'air_date': '1997-05-12 01:00:00'},\n",
              "  {'season': 4,\n",
              "   'episode': 24,\n",
              "   'name': 'Gethsemane',\n",
              "   'air_date': '1997-05-19 01:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 1,\n",
              "   'name': 'Redux (1)',\n",
              "   'air_date': '1997-11-03 02:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 2,\n",
              "   'name': 'Redux (2)',\n",
              "   'air_date': '1997-11-10 02:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 3,\n",
              "   'name': 'Unusual Suspects',\n",
              "   'air_date': '1997-11-17 02:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 4,\n",
              "   'name': 'Detour',\n",
              "   'air_date': '1997-11-24 02:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 5,\n",
              "   'name': 'The Post-Modern Prometheus',\n",
              "   'air_date': '1997-12-01 02:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 6,\n",
              "   'name': 'Christmas Carol (1)',\n",
              "   'air_date': '1997-12-08 02:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 7,\n",
              "   'name': 'Emily (2)',\n",
              "   'air_date': '1997-12-15 02:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 8,\n",
              "   'name': 'Kitsunegari',\n",
              "   'air_date': '1998-01-05 02:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 9,\n",
              "   'name': 'Schizogeny',\n",
              "   'air_date': '1998-01-12 02:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 10,\n",
              "   'name': 'Chinga',\n",
              "   'air_date': '1998-02-09 02:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 11,\n",
              "   'name': 'Kill Switch',\n",
              "   'air_date': '1998-02-16 02:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 12,\n",
              "   'name': 'Bad Blood',\n",
              "   'air_date': '1998-02-23 02:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 13,\n",
              "   'name': 'Patient X (1)',\n",
              "   'air_date': '1998-03-02 02:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 14,\n",
              "   'name': 'The Red and the Black (2)',\n",
              "   'air_date': '1998-03-09 02:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 15,\n",
              "   'name': 'Travelers',\n",
              "   'air_date': '1998-03-30 02:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 16,\n",
              "   'name': \"Mind's Eye\",\n",
              "   'air_date': '1998-04-20 01:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 17,\n",
              "   'name': 'All Souls',\n",
              "   'air_date': '1998-04-27 01:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 18,\n",
              "   'name': 'The Pine Bluff Variant',\n",
              "   'air_date': '1998-05-04 01:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 19,\n",
              "   'name': 'Folie a Deux',\n",
              "   'air_date': '1998-05-11 01:00:00'},\n",
              "  {'season': 5,\n",
              "   'episode': 20,\n",
              "   'name': 'The End',\n",
              "   'air_date': '1998-05-18 01:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 1,\n",
              "   'name': 'The Beginning',\n",
              "   'air_date': '1998-11-09 02:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 2,\n",
              "   'name': 'Drive',\n",
              "   'air_date': '1998-11-16 02:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 3,\n",
              "   'name': 'Triangle',\n",
              "   'air_date': '1998-11-23 02:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 4,\n",
              "   'name': 'Dreamland (1)',\n",
              "   'air_date': '1998-11-30 02:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 5,\n",
              "   'name': 'Dreamland (2)',\n",
              "   'air_date': '1998-12-07 02:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 6,\n",
              "   'name': 'How the Ghosts Stole Christmas',\n",
              "   'air_date': '1998-12-14 02:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 7,\n",
              "   'name': 'Terms of Endearment',\n",
              "   'air_date': '1999-01-04 02:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 8,\n",
              "   'name': 'The Rain King',\n",
              "   'air_date': '1999-01-11 02:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 9,\n",
              "   'name': 'S.R. 819',\n",
              "   'air_date': '1999-01-18 02:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 10,\n",
              "   'name': 'Tithonus',\n",
              "   'air_date': '1999-01-25 02:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 11,\n",
              "   'name': 'Two Fathers (1)',\n",
              "   'air_date': '1999-02-08 02:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 12,\n",
              "   'name': 'One Son (2)',\n",
              "   'air_date': '1999-02-15 02:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 13,\n",
              "   'name': 'Agua Mala',\n",
              "   'air_date': '1999-02-22 02:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 14,\n",
              "   'name': 'Monday',\n",
              "   'air_date': '1999-03-01 02:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 15,\n",
              "   'name': 'Arcadia',\n",
              "   'air_date': '1999-03-08 02:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 16,\n",
              "   'name': 'Alpha',\n",
              "   'air_date': '1999-03-29 02:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 17,\n",
              "   'name': 'Trevor',\n",
              "   'air_date': '1999-04-12 01:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 18,\n",
              "   'name': 'Milagro',\n",
              "   'air_date': '1999-04-19 01:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 19,\n",
              "   'name': 'The Unnatural',\n",
              "   'air_date': '1999-04-26 01:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 20,\n",
              "   'name': 'Three of a Kind',\n",
              "   'air_date': '1999-05-03 01:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 21,\n",
              "   'name': 'Field Trip',\n",
              "   'air_date': '1999-05-10 01:00:00'},\n",
              "  {'season': 6,\n",
              "   'episode': 22,\n",
              "   'name': 'Biogenesis',\n",
              "   'air_date': '1999-05-17 01:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 1,\n",
              "   'name': 'The Sixth Extinction (1)',\n",
              "   'air_date': '1999-11-08 02:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 2,\n",
              "   'name': 'The Sixth Extinction (2): Amor Fati',\n",
              "   'air_date': '1999-11-15 02:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 3,\n",
              "   'name': 'Hungry',\n",
              "   'air_date': '1999-11-22 02:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 4,\n",
              "   'name': 'Millennium',\n",
              "   'air_date': '1999-11-29 02:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 5,\n",
              "   'name': 'Rush',\n",
              "   'air_date': '1999-12-06 02:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 6,\n",
              "   'name': 'The Goldberg Variation',\n",
              "   'air_date': '1999-12-13 02:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 7,\n",
              "   'name': 'Orison',\n",
              "   'air_date': '2000-01-10 02:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 8,\n",
              "   'name': 'The Amazing Maleeni',\n",
              "   'air_date': '2000-01-17 02:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 9,\n",
              "   'name': 'Signs and Wonders',\n",
              "   'air_date': '2000-01-24 02:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 10,\n",
              "   'name': 'Sein und Zeit (1)',\n",
              "   'air_date': '2000-02-07 02:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 11,\n",
              "   'name': 'Closure (2)',\n",
              "   'air_date': '2000-02-14 02:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 12,\n",
              "   'name': 'X-Cops',\n",
              "   'air_date': '2000-02-21 02:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 13,\n",
              "   'name': 'First Person Shooter',\n",
              "   'air_date': '2000-02-28 02:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 14,\n",
              "   'name': 'Theef',\n",
              "   'air_date': '2000-03-13 02:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 15,\n",
              "   'name': 'En Ami',\n",
              "   'air_date': '2000-03-20 02:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 16,\n",
              "   'name': 'Chimera',\n",
              "   'air_date': '2000-04-03 01:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 17,\n",
              "   'name': 'all things',\n",
              "   'air_date': '2000-04-10 01:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 18,\n",
              "   'name': 'Brand X',\n",
              "   'air_date': '2000-04-17 01:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 19,\n",
              "   'name': 'Hollywood A.D.',\n",
              "   'air_date': '2000-05-01 01:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 20,\n",
              "   'name': 'Fight Club',\n",
              "   'air_date': '2000-05-08 01:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 21,\n",
              "   'name': 'Je Souhaite',\n",
              "   'air_date': '2000-05-15 01:00:00'},\n",
              "  {'season': 7,\n",
              "   'episode': 22,\n",
              "   'name': 'Requiem',\n",
              "   'air_date': '2000-05-22 01:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 1,\n",
              "   'name': 'Within (1)',\n",
              "   'air_date': '2000-11-06 02:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 2,\n",
              "   'name': 'Without (2)',\n",
              "   'air_date': '2000-11-13 02:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 3,\n",
              "   'name': 'Patience',\n",
              "   'air_date': '2000-11-20 02:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 4,\n",
              "   'name': 'Roadrunners',\n",
              "   'air_date': '2000-11-27 02:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 5,\n",
              "   'name': 'Invocation',\n",
              "   'air_date': '2000-12-04 02:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 6,\n",
              "   'name': 'Redrum',\n",
              "   'air_date': '2000-12-11 02:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 7,\n",
              "   'name': 'Via Negativa',\n",
              "   'air_date': '2000-12-18 02:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 8,\n",
              "   'name': 'Surekill',\n",
              "   'air_date': '2001-01-08 02:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 9,\n",
              "   'name': 'Salvage',\n",
              "   'air_date': '2001-01-15 02:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 10,\n",
              "   'name': 'Badlaa',\n",
              "   'air_date': '2001-01-22 02:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 11,\n",
              "   'name': 'The Gift',\n",
              "   'air_date': '2001-02-05 02:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 12,\n",
              "   'name': 'Medusa',\n",
              "   'air_date': '2001-02-12 02:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 13,\n",
              "   'name': 'Per Manum',\n",
              "   'air_date': '2001-02-19 02:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 14,\n",
              "   'name': 'This is Not Happening (1)',\n",
              "   'air_date': '2001-02-26 02:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 15,\n",
              "   'name': 'DeadAlive (2)',\n",
              "   'air_date': '2001-04-02 01:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 16,\n",
              "   'name': 'Three Words',\n",
              "   'air_date': '2001-04-09 01:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 17,\n",
              "   'name': 'Empedocles',\n",
              "   'air_date': '2001-04-16 01:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 18,\n",
              "   'name': 'Vienen',\n",
              "   'air_date': '2001-04-23 01:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 19,\n",
              "   'name': 'Alone',\n",
              "   'air_date': '2001-05-07 01:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 20,\n",
              "   'name': 'Essence (1)',\n",
              "   'air_date': '2001-05-14 01:00:00'},\n",
              "  {'season': 8,\n",
              "   'episode': 21,\n",
              "   'name': 'Existence (2)',\n",
              "   'air_date': '2001-05-21 01:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 1,\n",
              "   'name': 'Nothing Important Happened Today (1)',\n",
              "   'air_date': '2001-11-12 02:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 2,\n",
              "   'name': 'Nothing Important Happened Today (2)',\n",
              "   'air_date': '2001-11-19 02:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 3,\n",
              "   'name': 'Dæmonicus',\n",
              "   'air_date': '2001-12-03 02:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 4,\n",
              "   'name': '4-D',\n",
              "   'air_date': '2001-12-10 02:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 5,\n",
              "   'name': 'Lord of the Flies',\n",
              "   'air_date': '2001-12-17 02:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 6,\n",
              "   'name': 'Trust No 1',\n",
              "   'air_date': '2002-01-07 02:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 7,\n",
              "   'name': 'John Doe',\n",
              "   'air_date': '2002-01-14 02:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 8,\n",
              "   'name': 'Hellbound',\n",
              "   'air_date': '2002-01-28 02:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 9,\n",
              "   'name': 'Provenance (1)',\n",
              "   'air_date': '2002-03-04 02:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 10,\n",
              "   'name': 'Providence (2)',\n",
              "   'air_date': '2002-03-11 02:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 11,\n",
              "   'name': 'Audrey Pauley',\n",
              "   'air_date': '2002-03-18 02:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 12,\n",
              "   'name': 'Underneath',\n",
              "   'air_date': '2002-04-01 02:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 13,\n",
              "   'name': 'Improbable',\n",
              "   'air_date': '2002-04-08 01:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 14,\n",
              "   'name': 'Scary Monsters',\n",
              "   'air_date': '2002-04-15 01:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 15,\n",
              "   'name': 'Jump the Shark',\n",
              "   'air_date': '2002-04-22 01:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 16,\n",
              "   'name': 'William',\n",
              "   'air_date': '2002-04-29 01:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 17,\n",
              "   'name': 'Release',\n",
              "   'air_date': '2002-05-06 01:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 18,\n",
              "   'name': 'Sunshine Days',\n",
              "   'air_date': '2002-05-13 01:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 19,\n",
              "   'name': 'The Truth (1)',\n",
              "   'air_date': '2002-05-20 01:00:00'},\n",
              "  {'season': 9,\n",
              "   'episode': 20,\n",
              "   'name': 'The Truth (2)',\n",
              "   'air_date': '2002-05-20 01:00:00'},\n",
              "  {'season': 10,\n",
              "   'episode': 1,\n",
              "   'name': 'My Struggle',\n",
              "   'air_date': '2016-01-25 03:00:00'},\n",
              "  {'season': 10,\n",
              "   'episode': 2,\n",
              "   'name': \"Founder's Mutation\",\n",
              "   'air_date': '2016-01-26 01:00:00'},\n",
              "  {'season': 10,\n",
              "   'episode': 3,\n",
              "   'name': 'Mulder and Scully Meet the Were-Monster',\n",
              "   'air_date': '2016-02-02 01:00:00'},\n",
              "  {'season': 10,\n",
              "   'episode': 4,\n",
              "   'name': 'Home Again',\n",
              "   'air_date': '2016-02-09 01:00:00'},\n",
              "  {'season': 10,\n",
              "   'episode': 5,\n",
              "   'name': 'Babylon',\n",
              "   'air_date': '2016-02-16 01:00:00'},\n",
              "  {'season': 10,\n",
              "   'episode': 6,\n",
              "   'name': 'My Struggle II',\n",
              "   'air_date': '2016-02-23 01:00:00'},\n",
              "  {'season': 11,\n",
              "   'episode': 1,\n",
              "   'name': 'My Struggle III',\n",
              "   'air_date': '2018-01-04 01:00:00'},\n",
              "  {'season': 11,\n",
              "   'episode': 2,\n",
              "   'name': 'This',\n",
              "   'air_date': '2018-01-11 01:00:00'},\n",
              "  {'season': 11,\n",
              "   'episode': 3,\n",
              "   'name': 'Plus One',\n",
              "   'air_date': '2018-01-18 01:00:00'},\n",
              "  {'season': 11,\n",
              "   'episode': 4,\n",
              "   'name': 'The Lost Art of Forehead Sweat',\n",
              "   'air_date': '2018-01-25 01:00:00'},\n",
              "  {'season': 11,\n",
              "   'episode': 5,\n",
              "   'name': 'Ghouli',\n",
              "   'air_date': '2018-02-01 01:00:00'},\n",
              "  {'season': 11,\n",
              "   'episode': 6,\n",
              "   'name': 'Kitten',\n",
              "   'air_date': '2018-02-08 01:00:00'},\n",
              "  {'season': 11,\n",
              "   'episode': 7,\n",
              "   'name': 'Rm9sbG93ZXJz',\n",
              "   'air_date': '2018-03-01 01:00:00'},\n",
              "  {'season': 11,\n",
              "   'episode': 8,\n",
              "   'name': 'Familiar',\n",
              "   'air_date': '2018-03-08 01:00:00'},\n",
              "  {'season': 11,\n",
              "   'episode': 9,\n",
              "   'name': 'Nothing Lasts Forever',\n",
              "   'air_date': '2018-03-15 00:00:00'},\n",
              "  {'season': 11,\n",
              "   'episode': 10,\n",
              "   'name': 'My Struggle IV',\n",
              "   'air_date': '2018-03-22 00:00:00'}]}"
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Нормализуйте данные в каждом словаре в столбце \"shows\" В результате должен получиться DataFrame, в котором каждая серия хранится в отдельной записи Каждаязаписьдолжнавключатьсоответствующиеметаданныесерии (season, episode, name и air_date), а также информацию верхнего уровня о сериале (show, runtime и network)"
      ],
      "metadata": {
        "id": "kfTcsICwftg-"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# {'show': 'The X-Files',\n",
        "#  'runtime': 60,\n",
        "#  'network': 'FOX',\n",
        "#  'episodes': [{'season': 1,\n",
        "\n",
        "tv_shows_df = pd.json_normalize(\n",
        "    data = tv_shows_json['shows'],\n",
        "    meta = ['show', 'runtime','network'],\n",
        "    record_path = 'episodes'\n",
        ")\n",
        "tv_shows_df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "B_vIpjMPfgnN",
        "outputId": "7dd184e0-de3d-4733-e90a-b960b09a2b62"
      },
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   season  episode              name             air_date         show  \\\n",
              "0       1        1             Pilot  1993-09-11 01:00:00  The X-Files   \n",
              "1       1        2       Deep Throat  1993-09-18 01:00:00  The X-Files   \n",
              "2       1        3           Squeeze  1993-09-25 01:00:00  The X-Files   \n",
              "3       1        4           Conduit  1993-10-02 01:00:00  The X-Files   \n",
              "4       1        5  The Jersey Devil  1993-10-09 01:00:00  The X-Files   \n",
              "\n",
              "  runtime network  \n",
              "0      60     FOX  \n",
              "1      60     FOX  \n",
              "2      60     FOX  \n",
              "3      60     FOX  \n",
              "4      60     FOX  "
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-a942f4a6-1b9e-482f-a00d-421a02add2ba\">\n",
              "    <div 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>season</th>\n",
              "      <th>episode</th>\n",
              "      <th>name</th>\n",
              "      <th>air_date</th>\n",
              "      <th>show</th>\n",
              "      <th>runtime</th>\n",
              "      <th>network</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>Pilot</td>\n",
              "      <td>1993-09-11 01:00:00</td>\n",
              "      <td>The X-Files</td>\n",
              "      <td>60</td>\n",
              "      <td>FOX</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>Deep Throat</td>\n",
              "      <td>1993-09-18 01:00:00</td>\n",
              "      <td>The X-Files</td>\n",
              "      <td>60</td>\n",
              "      <td>FOX</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>Squeeze</td>\n",
              "      <td>1993-09-25 01:00:00</td>\n",
              "      <td>The X-Files</td>\n",
              "      <td>60</td>\n",
              "      <td>FOX</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>Conduit</td>\n",
              "      <td>1993-10-02 01:00:00</td>\n",
              "      <td>The X-Files</td>\n",
              "      <td>60</td>\n",
              "      <td>FOX</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>The Jersey Devil</td>\n",
              "      <td>1993-10-09 01:00:00</td>\n",
              "      <td>The X-Files</td>\n",
              "      <td>60</td>\n",
              "      <td>FOX</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a942f4a6-1b9e-482f-a00d-421a02add2ba')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-d51155a2-732c-4d57-9621-01077074b38e\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-d51155a2-732c-4d57-9621-01077074b38e')\"\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",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\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-quickchart: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-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart: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",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-d51155a2-732c-4d57-9621-01077074b38e button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-a942f4a6-1b9e-482f-a00d-421a02add2ba 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-a942f4a6-1b9e-482f-a00d-421a02add2ba');\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",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Разбейте нормализованный набор данных на три DataFrame, по одному для каждого сериала (\"The X-Files\", \"Lost\" и \"Buffy the Vampire Slayer\")"
      ],
      "metadata": {
        "id": "_M9h4lPUhUKK"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "xfiles = tv_shows_df[tv_shows_df[\"show\"] == \"The X-Files\"]\n",
        "lost = tv_shows_df[tv_shows_df[\"show\"] == \"Lost\"]\n",
        "buffy = tv_shows_df[tv_shows_df[\"show\"] == \"Buffy the Vampire Slayer\"]\n",
        "buffy.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "sJYM0wq-hRmX",
        "outputId": "cb327526-46a1-45f5-85d0-f84cc003d903"
      },
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "     season  episode                                name             air_date  \\\n",
              "339       1        1            Welcome to the Hellmouth  1997-03-11 01:00:00   \n",
              "340       1        2                         The Harvest  1997-03-11 01:00:00   \n",
              "341       1        3                               Witch  1997-03-18 01:00:00   \n",
              "342       1        4                       Teacher's Pet  1997-03-26 01:00:00   \n",
              "343       1        5  Never Kill a Boy on the First Date  1997-04-01 01:00:00   \n",
              "\n",
              "                         show runtime network  \n",
              "339  Buffy the Vampire Slayer      60     UPN  \n",
              "340  Buffy the Vampire Slayer      60     UPN  \n",
              "341  Buffy the Vampire Slayer      60     UPN  \n",
              "342  Buffy the Vampire Slayer      60     UPN  \n",
              "343  Buffy the Vampire Slayer      60     UPN  "
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-44aa1e06-1db3-443c-85f0-6c2c8e7f956d\">\n",
              "    <div 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>season</th>\n",
              "      <th>episode</th>\n",
              "      <th>name</th>\n",
              "      <th>air_date</th>\n",
              "      <th>show</th>\n",
              "      <th>runtime</th>\n",
              "      <th>network</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>339</th>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>Welcome to the Hellmouth</td>\n",
              "      <td>1997-03-11 01:00:00</td>\n",
              "      <td>Buffy the Vampire Slayer</td>\n",
              "      <td>60</td>\n",
              "      <td>UPN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>340</th>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>The Harvest</td>\n",
              "      <td>1997-03-11 01:00:00</td>\n",
              "      <td>Buffy the Vampire Slayer</td>\n",
              "      <td>60</td>\n",
              "      <td>UPN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>341</th>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>Witch</td>\n",
              "      <td>1997-03-18 01:00:00</td>\n",
              "      <td>Buffy the Vampire Slayer</td>\n",
              "      <td>60</td>\n",
              "      <td>UPN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>342</th>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>Teacher's Pet</td>\n",
              "      <td>1997-03-26 01:00:00</td>\n",
              "      <td>Buffy the Vampire Slayer</td>\n",
              "      <td>60</td>\n",
              "      <td>UPN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>343</th>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>Never Kill a Boy on the First Date</td>\n",
              "      <td>1997-04-01 01:00:00</td>\n",
              "      <td>Buffy the Vampire Slayer</td>\n",
              "      <td>60</td>\n",
              "      <td>UPN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-44aa1e06-1db3-443c-85f0-6c2c8e7f956d')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-ca82c1e3-3c1c-4e50-b95a-443e66414642\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-ca82c1e3-3c1c-4e50-b95a-443e66414642')\"\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",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\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-quickchart: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-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart: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",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-ca82c1e3-3c1c-4e50-b95a-443e66414642 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-44aa1e06-1db3-443c-85f0-6c2c8e7f956d 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-44aa1e06-1db3-443c-85f0-6c2c8e7f956d');\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",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Сохраните три DataFrame в книгу Excel episodes.xlsx, каждый в своем листе (имена листов выберите по своему вкусу)"
      ],
      "metadata": {
        "id": "wtd4mOwIiO3u"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "episodes = pd.ExcelWriter(\"episodes.xlsx\")\n",
        "episodes"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "BXzkgLChiMQ7",
        "outputId": "d4e8ab4f-e46c-4696-e222-1756ba641c5b"
      },
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<pandas.io.excel._openpyxl.OpenpyxlWriter at 0x77ff772e4400>"
            ]
          },
          "metadata": {},
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "xfiles.to_excel(\n",
        "                excel_writer = episodes, sheet_name = \"X-Files\", index = False\n",
        ")"
      ],
      "metadata": {
        "id": "osv6DifMiYqz"
      },
      "execution_count": 17,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "lost.to_excel(\n",
        "                excel_writer = episodes, sheet_name = \"Lost\", index = False\n",
        ")"
      ],
      "metadata": {
        "id": "riBRgKWhieAc"
      },
      "execution_count": 19,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        " buffy.to_excel(\n",
        "                excel_writer = episodes,\n",
        "                sheet_name = \"Buffy the Vampire Slayer\",\n",
        "                index = False\n",
        "            )"
      ],
      "metadata": {
        "id": "gN3KmoGpifoE"
      },
      "execution_count": 20,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "episodes.save()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "_pAb8mRRihKn",
        "outputId": "78acd44a-5278-48e8-f821-1ef0fc3ac008"
      },
      "execution_count": 21,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "<ipython-input-21-b30b182e7f81>:1: FutureWarning: save is not part of the public API, usage can give unexpected results and will be removed in a future version\n",
            "  episodes.save()\n"
          ]
        }
      ]
    }
  ]
}