2023-Wrapped.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Binärgewitter 2023\n",
    "\n",
    "So wenig wurde noch nie gepodcasted!   \n",
    "\n",
    "Let's take a look:\n",
    "Zuerst müssen wir alle librarys importieren und Daten laden."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import calmap"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "podcasts = pd.read_csv(\"data/2023.csv\", sep=\",\", index_col=1)\n",
    "podcasts.index = pd.to_datetime(podcasts.index, format=\"%Y-%m-%d\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Übersicht\n",
    "\n",
    "Diese Jahr habe wir einige Sendungen veröffentlicht:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Talk:      20\n",
      "Westcoast: 0\n",
      "Total:     20\n"
     ]
    }
   ],
   "source": [
    "total_count = len(podcasts.index)\n",
    "talk_count = len(podcasts[podcasts.Type == \"Talk\"].index)\n",
    "westcoast_count = len(podcasts[podcasts.Type == \"Westcoast\"].index)\n",
    "\n",
    "print(f\"Talk:      {talk_count}\")\n",
    "print(f\"Westcoast: {westcoast_count}\")\n",
    "print(f\"Total:     {total_count}\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "2023 haben wir 20 Sendungen gemacht! Genau gleichviel wie 2022."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Binärgewitter Talk"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Für Binärgewitter Talk sind das alle 2.6 Wochen eine Sendung.\n"
     ]
    }
   ],
   "source": [
    "distance_between_recordings = 52 / talk_count\n",
    "print(f\"Für Binärgewitter Talk sind das alle {distance_between_recordings} Wochen eine Sendung.\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Wir machen ein Kopie und schauen uns nur die BGT Talk Sendungen genauer an."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Record Date</th>\n",
       "      <th>Type</th>\n",
       "      <th>Duration</th>\n",
       "      <th>ingo</th>\n",
       "      <th>l33tname</th>\n",
       "      <th>madmas</th>\n",
       "      <th>makefu</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Release Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2023-12-30</th>\n",
       "      <td>Binärgewitter Talk #328: moderne Lava-Lampe am...</td>\n",
       "      <td>2023-12-30</td>\n",
       "      <td>Talk</td>\n",
       "      <td>00:48:35</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-12-19</th>\n",
       "      <td>Binärgewitter Talk #327: meine AI ist in der P...</td>\n",
       "      <td>2023-12-18</td>\n",
       "      <td>Talk</td>\n",
       "      <td>01:30:08</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-12-05</th>\n",
       "      <td>Binärgewitter Talk #326: AI-lluminaten</td>\n",
       "      <td>2023-12-04</td>\n",
       "      <td>Talk</td>\n",
       "      <td>02:24:19</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-11-18</th>\n",
       "      <td>Binärgewitter Talk #325: von Roboter für Roboter</td>\n",
       "      <td>2023-11-17</td>\n",
       "      <td>Talk</td>\n",
       "      <td>02:35:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-11-02</th>\n",
       "      <td>Binärgewitter Talk #324: im Keller ist es bill...</td>\n",
       "      <td>2023-11-01</td>\n",
       "      <td>Talk</td>\n",
       "      <td>02:09:14</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-10-05</th>\n",
       "      <td>Binärgewitter Talk #323: Curry mit OpenTofu</td>\n",
       "      <td>2023-10-04</td>\n",
       "      <td>Talk</td>\n",
       "      <td>01:53:13</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-09-20</th>\n",
       "      <td>Binärgewitter Talk #322: markus von den Medien</td>\n",
       "      <td>2023-09-18</td>\n",
       "      <td>Talk</td>\n",
       "      <td>02:48:08</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-09-02</th>\n",
       "      <td>Binärgewitter Talk #321: 8 Sekunden sind uns z...</td>\n",
       "      <td>2023-08-31</td>\n",
       "      <td>Talk</td>\n",
       "      <td>02:16:27</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-08-21</th>\n",
       "      <td>Binärgewitter Talk #320: Für die Liebe zu systemd</td>\n",
       "      <td>2023-08-18</td>\n",
       "      <td>Talk</td>\n",
       "      <td>01:47:35</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-08-10</th>\n",
       "      <td>Binärgewitter Talk #319: WireGuard curious</td>\n",
       "      <td>2023-08-08</td>\n",
       "      <td>Talk</td>\n",
       "      <td>01:55:33</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-07-20</th>\n",
       "      <td>Binärgewitter Talk #318: Linus Torwalds ruft z...</td>\n",
       "      <td>2023-07-19</td>\n",
       "      <td>Talk</td>\n",
       "      <td>01:59:23</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-06-30</th>\n",
       "      <td>Binärgewitter Talk #317: Virenschutz für deine...</td>\n",
       "      <td>2023-06-29</td>\n",
       "      <td>Talk</td>\n",
       "      <td>02:00:27</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-06-15</th>\n",
       "      <td>Binärgewitter Talk #316: Klobi der Reddit Client</td>\n",
       "      <td>2023-06-13</td>\n",
       "      <td>Talk</td>\n",
       "      <td>02:53:56</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-05-19</th>\n",
       "      <td>Binärgewitter Talk #315: ChatGPT, confident ab...</td>\n",
       "      <td>2023-05-18</td>\n",
       "      <td>Talk</td>\n",
       "      <td>03:34:07</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-04-21</th>\n",
       "      <td>Binärgewitter Talk #314: Influencer zu Heizung...</td>\n",
       "      <td>2023-04-20</td>\n",
       "      <td>Talk</td>\n",
       "      <td>02:31:03</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-28</th>\n",
       "      <td>Binärgewitter Talk #313: Die SMSAusdrucker</td>\n",
       "      <td>2023-03-27</td>\n",
       "      <td>Talk</td>\n",
       "      <td>02:13:14</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-10</th>\n",
       "      <td>Binärgewitter Talk #312: Wenn sich Deine Reali...</td>\n",
       "      <td>2023-03-09</td>\n",
       "      <td>Talk</td>\n",
       "      <td>01:32:17</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-18</th>\n",
       "      <td>Binärgewitter Talk #311: auch ein Host von Bin...</td>\n",
       "      <td>2023-02-18</td>\n",
       "      <td>Talk</td>\n",
       "      <td>01:36:49</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-28</th>\n",
       "      <td>Binärgewitter Talk #310: Java Opportunities</td>\n",
       "      <td>2023-01-26</td>\n",
       "      <td>Talk</td>\n",
       "      <td>01:33:42</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-06</th>\n",
       "      <td>Binärgewitter Talk #309: 10 von 10 would explo...</td>\n",
       "      <td>2023-01-05</td>\n",
       "      <td>Talk</td>\n",
       "      <td>01:55:32</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                           Name Record Date  \\\n",
       "Release Date                                                                  \n",
       "2023-12-30    Binärgewitter Talk #328: moderne Lava-Lampe am...  2023-12-30   \n",
       "2023-12-19    Binärgewitter Talk #327: meine AI ist in der P...  2023-12-18   \n",
       "2023-12-05               Binärgewitter Talk #326: AI-lluminaten  2023-12-04   \n",
       "2023-11-18     Binärgewitter Talk #325: von Roboter für Roboter  2023-11-17   \n",
       "2023-11-02    Binärgewitter Talk #324: im Keller ist es bill...  2023-11-01   \n",
       "2023-10-05          Binärgewitter Talk #323: Curry mit OpenTofu  2023-10-04   \n",
       "2023-09-20       Binärgewitter Talk #322: markus von den Medien  2023-09-18   \n",
       "2023-09-02    Binärgewitter Talk #321: 8 Sekunden sind uns z...  2023-08-31   \n",
       "2023-08-21    Binärgewitter Talk #320: Für die Liebe zu systemd  2023-08-18   \n",
       "2023-08-10           Binärgewitter Talk #319: WireGuard curious  2023-08-08   \n",
       "2023-07-20    Binärgewitter Talk #318: Linus Torwalds ruft z...  2023-07-19   \n",
       "2023-06-30    Binärgewitter Talk #317: Virenschutz für deine...  2023-06-29   \n",
       "2023-06-15     Binärgewitter Talk #316: Klobi der Reddit Client  2023-06-13   \n",
       "2023-05-19    Binärgewitter Talk #315: ChatGPT, confident ab...  2023-05-18   \n",
       "2023-04-21    Binärgewitter Talk #314: Influencer zu Heizung...  2023-04-20   \n",
       "2023-03-28           Binärgewitter Talk #313: Die SMSAusdrucker  2023-03-27   \n",
       "2023-03-10    Binärgewitter Talk #312: Wenn sich Deine Reali...  2023-03-09   \n",
       "2023-02-18    Binärgewitter Talk #311: auch ein Host von Bin...  2023-02-18   \n",
       "2023-01-28          Binärgewitter Talk #310: Java Opportunities  2023-01-26   \n",
       "2023-01-06    Binärgewitter Talk #309: 10 von 10 would explo...  2023-01-05   \n",
       "\n",
       "              Type  Duration  ingo  l33tname  madmas  makefu  \n",
       "Release Date                                                  \n",
       "2023-12-30    Talk  00:48:35     0         1       1       0  \n",
       "2023-12-19    Talk  01:30:08     1         0       1       1  \n",
       "2023-12-05    Talk  02:24:19     1         1       1       1  \n",
       "2023-11-18    Talk  02:35:00     1         1       1       1  \n",
       "2023-11-02    Talk  02:09:14     1         1       1       1  \n",
       "2023-10-05    Talk  01:53:13     1         1       1       0  \n",
       "2023-09-20    Talk  02:48:08     1         1       1       0  \n",
       "2023-09-02    Talk  02:16:27     0         1       1       1  \n",
       "2023-08-21    Talk  01:47:35     1         0       0       1  \n",
       "2023-08-10    Talk  01:55:33     0         1       1       0  \n",
       "2023-07-20    Talk  01:59:23     1         0       1       1  \n",
       "2023-06-30    Talk  02:00:27     1         0       1       1  \n",
       "2023-06-15    Talk  02:53:56     1         1       1       1  \n",
       "2023-05-19    Talk  03:34:07     1         1       1       1  \n",
       "2023-04-21    Talk  02:31:03     1         1       1       1  \n",
       "2023-03-28    Talk  02:13:14     1         0       1       1  \n",
       "2023-03-10    Talk  01:32:17     1         0       1       1  \n",
       "2023-02-18    Talk  01:36:49     1         0       1       1  \n",
       "2023-01-28    Talk  01:33:42     1         1       1       1  \n",
       "2023-01-06    Talk  01:55:32     1         1       1       1  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "talk = podcasts[podcasts.Type == \"Talk\"]\n",
    "talk.drop(columns=['pfleidi', 'marc'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Sendungen pro Host:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "ingo:     17\n",
      "l33tname: 13\n",
      "madmas:   19\n",
      "makefu:   16\n"
     ]
    }
   ],
   "source": [
    "ingo_count = talk[\"ingo\"].sum()\n",
    "l33tname_count = talk[\"l33tname\"].sum()\n",
    "madmas_count = talk[\"madmas\"].sum()\n",
    "makefu_count = talk[\"makefu\"].sum()\n",
    "\n",
    "\n",
    "print(f\"ingo:     {ingo_count}\")\n",
    "print(f\"l33tname: {l33tname_count}\")\n",
    "print(f\"madmas:   {madmas_count}\")\n",
    "print(f\"makefu:   {makefu_count}\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "In Prozen sind das:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "ingo:      85%\n",
      "makefu:    80%\n",
      "l33tname:  65%\n",
      "madmas:    95%\n"
     ]
    }
   ],
   "source": [
    "print(f\"ingo:      {ingo_count/talk_count:.0%}\")\n",
    "print(f\"makefu:    {makefu_count/talk_count:.0%}\")\n",
    "print(f\"l33tname:  {l33tname_count/talk_count:.0%}\")\n",
    "print(f\"madmas:    {madmas_count/talk_count:.0%}\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Damit ist madmas MVP der gerade mal 1 Sendung verpasst hat."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Duration"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Da der feed jetzt eine duration pro Sendung angibt kann man jetzt auch interessante Auswertungen machen."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "import datetime\n",
    "\n",
    "convert_duration_to_sec = lambda v: (int(v.split(\":\")[0]) * 60*60) + (int(v.split(\":\")[1]) * 60) + int(v.split(\":\")[2])\n",
    "talk['Duration_sec'] = talk['Duration'].transform(convert_duration_to_sec)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Unsere totale Sendezeit war diese Jahr:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'1 day, 17:58:42'"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "total_sec = int(talk['Duration_sec'].sum())\n",
    "str(datetime.timedelta(seconds=total_sec))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Im Durchschnitt ist eine Sendung:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2:05:56'"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "avg_sec = int(talk['Duration_sec'].mean())\n",
    "str(datetime.timedelta(seconds=avg_sec))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Die kürzeste Sendung die wir diese Jahr gemacht haben:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Record Date</th>\n",
       "      <th>Type</th>\n",
       "      <th>Duration</th>\n",
       "      <th>ingo</th>\n",
       "      <th>l33tname</th>\n",
       "      <th>madmas</th>\n",
       "      <th>makefu</th>\n",
       "      <th>pfleidi</th>\n",
       "      <th>marc</th>\n",
       "      <th>Duration_sec</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Release Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2023-12-30</th>\n",
       "      <td>Binärgewitter Talk #328: moderne Lava-Lampe am...</td>\n",
       "      <td>2023-12-30</td>\n",
       "      <td>Talk</td>\n",
       "      <td>00:48:35</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2915</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                           Name Record Date  \\\n",
       "Release Date                                                                  \n",
       "2023-12-30    Binärgewitter Talk #328: moderne Lava-Lampe am...  2023-12-30   \n",
       "\n",
       "              Type  Duration  ingo  l33tname  madmas  makefu  pfleidi  marc  \\\n",
       "Release Date                                                                  \n",
       "2023-12-30    Talk  00:48:35     0         1       1       0        0     0   \n",
       "\n",
       "              Duration_sec  \n",
       "Release Date                \n",
       "2023-12-30            2915  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "shortes_episode = talk[talk['Duration_sec'] == talk['Duration_sec'].min()]\n",
    "shortes_episode"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Und nicht zuletzt die längste Sendung:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Record Date</th>\n",
       "      <th>Type</th>\n",
       "      <th>Duration</th>\n",
       "      <th>ingo</th>\n",
       "      <th>l33tname</th>\n",
       "      <th>madmas</th>\n",
       "      <th>makefu</th>\n",
       "      <th>pfleidi</th>\n",
       "      <th>marc</th>\n",
       "      <th>Duration_sec</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Release Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2023-05-19</th>\n",
       "      <td>Binärgewitter Talk #315: ChatGPT, confident ab...</td>\n",
       "      <td>2023-05-18</td>\n",
       "      <td>Talk</td>\n",
       "      <td>03:34:07</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12847</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                           Name Record Date  \\\n",
       "Release Date                                                                  \n",
       "2023-05-19    Binärgewitter Talk #315: ChatGPT, confident ab...  2023-05-18   \n",
       "\n",
       "              Type  Duration  ingo  l33tname  madmas  makefu  pfleidi  marc  \\\n",
       "Release Date                                                                  \n",
       "2023-05-19    Talk  03:34:07     1         1       1       1        0     0   \n",
       "\n",
       "              Duration_sec  \n",
       "Release Date                \n",
       "2023-05-19           12847  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "longest_episode = talk[talk['Duration_sec'] == talk['Duration_sec'].max()]\n",
    "longest_episode"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Recording datum\n",
    "\n",
    "Hier sehen wir, an welchen Tagen wir aufnehmen."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAABkUAAADzCAYAAAA4qxECAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjguMCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy81sbWrAAAACXBIWXMAAA9hAAAPYQGoP6dpAAAsaUlEQVR4nO3de7hUdb0/8Pewt7CBLWpKggYIEiZHAYlE0SNslEDF1DRveEHE88NLmqXlJQRNQ+iQHvOCxxtYXlMj81ZJ7I7hFRNv8ZCZaB0xPYQVIhdlfn/0OA87KFH23iN7Xq/nmedZ811r1vuz9swsFvOZtaZQLBaLAQAAAAAAaOFalbsAAAAAAACA5qApAgAAAAAAVARNEQAAAAAAoCJoigAAAAAAABVBUwQAAAAAAKgImiIAAAAAAEBF0BQBAAAAAAAqgqYIAAAAAABQETRFAAAAAACAiqApAgAAAAAAVITqchewPpYtW9YsOe3atWv2zHLlymx5uTJbXm65M1f9v32bJXOTax4oTXtOZW5suTJbXq7Mlpcrs+Xlymx5uZWY+Xz37s2SmSQ7vfxyabpS/r4tObNcuTJbXm65M5cesFuzZNb+5LHSdLme0/ceuqlZMqv2ObY0XY7ndGPiTBEAAAAAAKAiaIoAAAAAAAAVQVMEAAAAAACoCJoiAAAAAABARdAUAQAAAAAAKoKmCAAAAAAAUBE0RQAAAAAAgIqgKQIAAAAAADSa0aNHp1AoZNy4cWvNO+WUU1IoFDJ69OjmLyyaIgAAAAAAQCPr0qVLbrvttrzzzjulseXLl+eWW25J165dy1aXpggAAAAAANCo+vfvny5duuTuu+8ujd19993p2rVrdtlll9LYihUrctppp+WTn/xkampqsueee+bJJ58sza+vr0+hUMisWbMyYMCAtGvXLoMGDcqCBQs+Ul2aIgAAAAAAQKMbM2ZMbrzxxtL9G264Iccff3yDZb7+9a/nrrvuyowZM/LrX/86PXv2zPDhw/PnP/+5wXLnnXdepk6dmrlz56a6ujpjxoz5SDVpigAAAAAAAI3u6KOPzq9+9au88soreeWVVzJnzpwcffTRpflvv/12rr766nznO9/Jvvvum969e+faa69N27Ztc/311zdY18UXX5zBgwend+/eOfvss/PII49k+fLlH7qm6g3eKgAAAAAAgH/QsWPH7L///pk+fXqKxWL233//bLXVVqX5L730UlatWpU99tijNLbJJptk1113zfz58xusq0+fPqXpzp07J0neeOOND/37JJoiAAAAAABAkxgzZkxOPfXUJMmVV175kdezySablKYLhUKSZPXq1R96PS6fBQAAAAAANIkRI0Zk5cqVWbVqVYYPH95g3vbbb5/WrVtnzpw5pbFVq1blySefTO/evZukHmeKAAAAAAAATaKqqqp0KayqqqoG89q3b5+TTjopZ511Vj7xiU+ka9eumTJlSpYtW5YTTjihSerRFAEAAAAAAJpMhw4d/um8Sy65JKtXr84xxxyTv/3tbxkwYEB++tOfZosttmiSWjRFAAAAAACARjN9+vR/OX/mzJml6Zqamlx++eW5/PLL17nskCFDUiwWG4z169dvrbH15TdFAAAAAACAiqApAgAAAAAAVARNEQAAAAAAoCJoigAAAAAAABVBUwQAAAAAAKgImiIAAAAAAEBF0BQBAAAAAAAqgqYIAAAAAABQEQrFYrFY7iIAAAAAAACamjNFAAAAAACAiqApAgAAAAAAVITqchewPpYtW9YsOe3atWv2zHLlymx5uTJbXq7Mlpcrs+Xlymx5uWtmPtG5a7Nk7rro1dK051TmxpRZrtw1M9+bcnKzZFZ9/arStOdU5saUWa5cmS0vV2bLy5XZ8nLLnbkxcaYIAAAAAABQETRFAAAAAACAiqApAgAAAAAAVARNEQAAAAAAoCJoigAAAAAAABVBUwQAAAAAAKgImiIAAAAAAECjKBQK//I2ceLEstZXXdZ0AAAAAACgxVi0aFFp+vbbb8/555+fBQsWlMZqa2vLUVaJM0UAAAAAAIBG0alTp9Jts802S6FQKN2fNm1a9txzzwbLX3bZZdluu+0ajF133XXZcccdU1NTk8985jO56qqrGq0+Z4oAAAAAAAAfCzfffHPOP//8XHHFFdlll13y9NNP58QTT0z79u1z3HHHbfD6NUUAAAAAAICPhQkTJmTq1Kn54he/mCTp3r17fvOb3+Saa67RFAEAAAAAAFqGt99+Oy+99FJOOOGEnHjiiaXxd999N5tttlmjZGiKAAAAAAAATa5Vq1YpFosNxlatWlWaXrp0aZLk2muvzcCBAxssV1VV1Sg1aIoAAAAAAABNrmPHjnn99ddTLBZTKBSSJPPmzSvN33rrrbPNNtvk97//fUaNGtUkNWiKAAAAAAAATW7IkCF58803M2XKlBx66KF58MEH88ADD6RDhw6lZS644IKcdtpp2WyzzTJixIisWLEic+fOzZIlS/LVr351g2totcFrAAAAAAAA+AA77rhjrrrqqlx55ZXp27dvnnjiiZx55pkNlhk7dmyuu+663Hjjjdl5550zePDgTJ8+Pd27d2+UGpwpAgAAAAAANLrRo0dn9OjRDcbGjRuXcePGNRg799xzG9w/6qijctRRRzVJTc4UAQAAAAAAKoKmCAAAAAAAUBE0RQAAAAAAgIqgKQIAAAAAAFQETREAAAAAAKAiaIoAAAAAAAAVQVMEAAAAAACoCJoiAAAAAABARSgUi8ViuYsAAAAAAABoas4UAQAAAAAAKoKmCAAAAAAAUBGqy13A+li2bFmz5LRr167ZM8uVK7Pl5cpsebkyW16uzJaXK7Pl5cpsebnlznzvwjHNkll1/g2lac+pzI0tV2bLy22wH7z09GbJrDrjv0rTntOmzXz39AObJbP6v35cmvacytyYMsuVW+7MjYkzRQAAAAAAgIqgKQIAAAAAAFQETREAAAAAAKAiaIoAAAAAAAAVQVMEAAAAAACoCJoiAAAAAADARqW+vj6FQiFvvfXWh3qcpggAAAAAANAopk2blk033TTvvvtuaWzp0qXZZJNNMmTIkAbLvt/YeOmll5qtPk0RAAAAAACgUdTV1WXp0qWZO3duaezhhx9Op06d8vjjj2f58uWl8dmzZ6dr167Zfvvtm60+TREAAAAAAKBR7LDDDuncuXPq6+tLY/X19TnwwAPTvXv3PPbYYw3G6+rqsnr16kyaNCndu3dP27Zt07dv39x5550N1nv//fenV69eadu2berq6rJw4cKPVJ+mCAAAAAAA0Gjq6uoye/bs0v3Zs2dnyJAhGTx4cGn8nXfeyeOPP566urpMmjQpN910U6ZNm5YXXnghZ5xxRo4++uj88pe/TJL84Q9/yBe/+MUccMABmTdvXsaOHZuzzz77I9VWveGbBwAAAAAA8Hd1dXX5yle+knfffTfvvPNOnn766QwePDirVq3KtGnTkiSPPvpoVqxYkSFDhqR379556KGHsvvuuydJevTokV/96le55pprMnjw4Fx99dXZfvvtM3Xq1CR/Pxvlueeey+TJkz90bZoiAAAAAABAoxkyZEjefvvtPPnkk1myZEl69eqVjh07ZvDgwTn++OOzfPny1NfXp0ePHlm6dGmWLVuWYcOGNVjHypUrs8suuyRJ5s+fn4EDBzaY/34D5cPSFAEAAAAAABpNz54986lPfSqzZ8/OkiVLMnjw4CTJNttsky5duuSRRx7J7NmzM3To0CxdujRJct9992XbbbdtsJ42bdo0em2aIgAAAAAAQKOqq6tLfX19lixZkrPOOqs0vtdee+WBBx7IE088kZNOOim9e/dOmzZt8uqrr5aaJ/9oxx13zD333NNgbM0fbP8wNEUAAAAAAIBGVVdXl1NOOSWrVq1q0OwYPHhwTj311KxcuTJ1dXXZdNNNc+aZZ+aMM87I6tWrs+eee+Yvf/lL5syZkw4dOuS4447LuHHjMnXq1Jx11lkZO3ZsnnrqqUyfPv0j1dWqkbYPAAAAAAAgyd+bIu+880569uyZrbfeujQ+ePDg/O1vf8sOO+yQzp07J0m+9a1vZfz48Zk0aVJ23HHHjBgxIvfdd1+6d++eJOnatWvuuuuuzJw5M3379s20adPy7W9/+yPV5UwRAAAAAACgUW233XYpFotrjXfr1m2t8UKhkNNPPz2nn376P13fyJEjM3LkyAZjxx9//Ieuy5kiAAAAAABARdAUAQAAAAAAKoKmCAAAAAAAUBE0RQAAAAAAgIqgKQIAAAAAAFQETREAAAAAAKAiaIoAAAAAAAAVQVMEAAAAAACoCIVisVgsdxEAAAAAAABNzZkiAAAAAABARdAUAQAAAAAAKkJ1uQtYH+9NOblZcqq+flVpetmyZc2SmSTt2rVr9tw1M9+777+bJbNq//8oTZdjOyvpOa2UzPcevL5ZMpOkasQJpelK+fu25Mxy5a6Z+Ze9+jRL5mb/82xp2nPatJnjCh2aJXNa8a+lac+pzMbIfG/i6GbJTJKqidNL05Xy923JmeXKldl8uStG79MsmW2mP1Sabsl/34/Dc9qSt7VSMsuVK7Pl5cpsebnlztyYOFMEAAAAAACoCJoiAAAAAABARdAUAQAAAAAAKoKmCAAAAAAAUBE0RQAAAAAAgIqgKQIAAAAAADSb+vr6FAqFvPXWW82erSkCAAAAAAA0ikKh8C9vEydOLGt91WVNBwAAAAAAWoxFixaVpm+//facf/75WbBgQWmstrY2c+fOLUdpSZwpAgAAAAAANJJOnTqVbptttlkKhUKDsdra2tKyTz31VAYMGJB27dpl0KBBDZono0ePzkEHHdRg3V/5ylcyZMiQDapPUwQAAAAAAGh25513XqZOnZq5c+emuro6Y8aMafJMl88CAAAAAACa3cUXX5zBgwcnSc4+++zsv//+Wb58eWpqapos05kiAAAAAABAs+vTp09punPnzkmSN954o0kzNUUAAAAAAIBmt8kmm5SmC4VCkmT16tVJklatWqVYLDZYftWqVRucqSkCAAAAAAB8rHTs2DGLFi1qMDZv3rwNXq+mCAAAAAAA8LEydOjQzJ07NzfddFNefPHFTJgwIc8///wGr1dTBAAAAAAA+FgZPnx4xo8fn69//ev53Oc+l7/97W859thjN3i91Y1QGwAAAAAAQAOjR4/O6NGj1xofMmTIWr8X0q9fv7XGLrjgglxwwQWNWpMzRQAAAAAAgIqgKQIAAAAAAFQETREAAAAAAKAiaIoAAAAAAAAVQVMEAAAAAACoCJoiAAAAAABARdAUAQAAAAAAKoKmCAAAAAAAUBEKxWKxWO4iAAAAAAAAmpozRQAAAAAAgIqgKQIAAAAAAFSE6nIXsD6WLVvWLDnt2rVr9sxy5cpsebkyW16uzJaXK7Pl5cpsebkyW16uzJaXW+7M9645t1kyq/7ft0vTnlOZG1uuzJaXW4mZbw78t2bJTJKOj79Qmq6Uv29LzixXbrkzNybOFAEAAAAAACqCpggAAAAAAFARNEUAAAAAAICKoCkCAAAAAABUBE0RAAAAAACgImiKAAAAAAAAFUFTBAAAAAAAKJtCoZCZM2c2S5amCAAAAAAA0GhGjx6dQqGw1u13v/vdOpdftGhR9t1332aprbpZUgAAAAAAgIoxYsSI3HjjjQ3GOnbs2OD+ypUr07p163Tq1KnZ6tIUAQAAAAAAGlWbNm3WanYMGTIkO+20U6qrq/ODH/wgO++8c2bPnp1CoZAf/ehHOeigg5q8Lk0RAAAAAACgWcyYMSMnnXRS5syZU5Z8TREAAAAAAKBR3XvvvamtrS3df/83Qz796U9nypQp5SpLUwQAAAAAAGhcdXV1ufrqq0v327dvnyOPPDKf/exny1iVpggAAAAAANDI2rdvn549e65zvJxalTUdAAAAAACgmWiKAAAAAAAAFUFTBAAAAAAAqAh+UwQAAAAAAGg006dPX+d4fX39OseLxWLTFfMPnCkCAAAAAABUBE0RAAAAAACgImiKAAAAAAAAFUFTBAAAAAAAqAiaIgAAAAAAQEXQFAEAAAAAACqCpggAAAAAAFARNEUAAAAAAICKUCgWi8VyFwEAAAAAANDUnCkCAAAAAABUBE0RAAAAAACgIlSXu4D1sWzZsmbJadeuXbNnlitXZvPlvvej7zVLZtXBXy5Nt+S/78fhOW3J21opmeXKldnycmW2vFyZLS9XZsvLldnycmW2vFyZLS9XZsvLldnyctfMzLK/NEtm2m3WPDmNzJkiAAAAAABARdAUAQAAAAAAKoKmCAAAAAAAUBE0RQAAAAAAgIqgKQIAAAAAAFQETREAAAAAAKAiaIoAAAAAAACN6s0338xJJ52Url27pk2bNunUqVOGDx+eOXPmrNfjp0+fns0337zR66pu9DUCAAAAAAAV7ZBDDsnKlSszY8aM9OjRI3/6058ya9asLF68uKx1OVMEAAAAAABoNG+99VYefvjhTJ48OXV1denWrVt23XXXnHPOOfnCF76QJPnud7+bnXfeOe3bt0+XLl1y8sknZ+nSpUmS+vr6HH/88fnLX/6SQqGQQqGQiRMnNkptmiIAAAAAAECjqa2tTW1tbWbOnJkVK1asc5lWrVrl8ssvzwsvvJAZM2bkF7/4Rb7+9a8nSQYNGpTLLrssHTp0yKJFi7Jo0aKceeaZjVKbpggAAAAAANBoqqurM3369MyYMSObb7559thjj5x77rl59tlnS8t85StfSV1dXbbbbrsMHTo0F110Ue64444kSevWrbPZZpulUCikU6dO6dSpU2praxulNk0RAAAAAACgUR1yyCF57bXXcs8992TEiBGpr69P//79M3369CTJQw89lL333jvbbrttNt100xxzzDFZvHhxli1b1qR1aYoAAAAAAACNrqamJsOGDcv48ePzyCOPZPTo0ZkwYUIWLlyYkSNHpk+fPrnrrrvy1FNP5corr0ySrFy5sklr0hQBAAAAAACaXO/evfP222/nqaeeyurVqzN16tTstttu6dWrV1577bUGy7Zu3Trvvfdeo9egKQIAAAAAADSaxYsXZ+jQofnBD36QZ599Ni+//HJ++MMfZsqUKTnwwAPTs2fPrFq1Kt/73vfy+9//Pt///vczbdq0BuvYbrvtsnTp0syaNSv/93//12iX1dIUAQAAAAAAGk1tbW0GDhyYSy+9NHvttVd22mmnjB8/PieeeGKuuOKK9O3bN9/97nczefLk7LTTTrn55pszadKkBusYNGhQxo0bl8MPPzwdO3bMlClTGqW26kZZCwAAAAAAQJI2bdpk0qRJazU61nTGGWfkjDPOaDB2zDHHNLh/9dVX5+qrr27U2pwpAgAAAAAAVARNEQAAAAAAoCJoigAAAAAAABVBUwQAAAAAAKgImiIAAAAAAEBF0BQBAAAAAAAqgqYIAAAAAABQETRFAAAAAACAilAoFovFchcBAAAAAADQ1JwpAgAAAAAAVARNEQAAAAAAoCJUf9gHLFu2rCnqWEu7du0qIrNcuTJbXq7Mlpcrs+Xlymx5uTJbXq7Mlpcrs+Xlymx5uTJbXq7Mlpcrs+Xlymx5ueXO3Jg4UwQAAAAAAKgImiIAAAAAAEBF0BQBAAAAAAAqgqYIAAAAAABQETRFAAAAAACAiqApAgAAAAAAVARNEQAAAAAAoFG9+eabOemkk9K1a9e0adMmnTp1yvDhwzNnzpyy1lVd1nQAAAAAAKDFOeSQQ7Jy5crMmDEjPXr0yJ/+9KfMmjUrixcvLmtdzhQBAAAAAAAazVtvvZWHH344kydPTl1dXbp165Zdd90155xzTr7whS9k4cKFKRQKmTdvXoPHFAqF1NfXJ0nq6+tTKBQya9asDBgwIO3atcugQYOyYMGCDapNUwQAAAAAAGg0tbW1qa2tzcyZM7NixYoNWtd5552XqVOnZu7cuamurs6YMWM2aH2aIgAAAAAAQKOprq7O9OnTM2PGjGy++ebZY489cu655+bZZ5/90Ou6+OKLM3jw4PTu3Ttnn312HnnkkSxfvvwj16YpAgAAAAAANKpDDjkkr732Wu65556MGDEi9fX16d+/f6ZPn/6h1tOnT5/SdOfOnZMkb7zxxkeuS1MEAAAAAABodDU1NRk2bFjGjx+fRx55JKNHj86ECRPSqtXfWxPFYrG07KpVq9a5jk022aQ0XSgUkiSrV6/+yDVpigAAAAAAAE2ud+/eefvtt9OxY8ckyaJFi0rz1vzR9aZU3SwpAAAAAABARVi8eHG+9KUvZcyYMenTp0823XTTzJ07N1OmTMmBBx6Ytm3bZrfddssll1yS7t2754033sg3v/nNZqlNUwQAAAAAAGg0tbW1GThwYC699NK89NJLWbVqVbp06ZITTzwx5557bpLkhhtuyAknnJDPfvaz2WGHHTJlypR8/vOfb/LaNEUAAAAAAIBG06ZNm0yaNCmTJk36p8vsuOOOeeSRRxqMrfkbI0OGDGlwP0n69eu31tiH5TdFAAAAAACAiqApAgAAAAAAVARNEQAAAAAAoCJoigAAAAAAABVBUwQAAAAAAKgImiIAAAAAAEBF0BQBAAAAAAAqgqYIAAAAAABQEQrFYrFY7iIAAAAAAACamjNFAAAAAACAiqApAgAAAAAAVARNEQAAAAAAoCJoigAAAAAAABVBUwQAAAAAAKgImiIAAAAAAEBF0BSBj7lCoZCZM2eWuwwAADaQ4zoAACg/TZEmNnr06Bx00EHlLoMyGz16dAqFwlq33/3ud+UujY/o/ed03Lhxa8075ZRTUigUMnr06OYvjA326KOPpqqqKvvvv3+5S2EjYp/Q8jmmY128LiqbY4aW580338xJJ52Url27pk2bNunUqVOGDx+eOXPmlLs0yuQPf/hDxowZk2222SatW7dOt27dcvrpp2fx4sXr9fj6+voUCoW89dZbTVsoTeb94/xLLrmkwfjMmTNTKBTKVBUbYs3P6DbZZJNsvfXWGTZsWG644YasXr263OXRTDRFoJmMGDEiixYtanDr3r17uctiA3Tp0iW33XZb3nnnndLY8uXLc8stt6Rr164btO5Vq1ZtaHl8RNdff32+/OUv53/+53/y2muvbdC63nvvPQdVFaQp9wkAfPw05jEDHw+HHHJInn766cyYMSO//e1vc88992TIkCHr/QE4Lcvvf//7DBgwIC+++GJuvfXW/O53v8u0adMya9as7L777vnzn/9c7hJpJjU1NZk8eXKWLFlS7lJoJO9/Rrdw4cI88MADqaury+mnn56RI0fm3XffLXd5NANNkWb04IMPZs8998zmm2+eLbfcMiNHjsxLL71Umr9w4cIUCoXcfffdqaurS7t27dK3b988+uijZayaxvL+N43WvFVVVeXHP/5x+vfvn5qamvTo0SMXXHDBWjvgRYsWZd99903btm3To0eP3HnnnWXaCtbUv3//dOnSJXfffXdp7O67707Xrl2zyy67lMbW971/++23Z/DgwampqcnNN9/crNvC3y1dujS33357TjrppOy///6ZPn16ad773/K677770qdPn9TU1GS33XbL888/X1pm+vTp2XzzzXPPPfekd+/eadOmTV599dUybAnl0Fj7hKFDh+bUU09tsO4333wzrVu3zqxZs5p+Q/hA2223XS677LIGY/369cvEiRNL9wuFQq677rocfPDBadeuXT796U/nnnvuad5CaVbr87qg5fhXxwzvHw+saV3fKL7ooovyyU9+MptuumnGjh2bs88+O/369Wv64lmnt956Kw8//HAmT56curq6dOvWLbvuumvOOeecfOELXygtM3bs2HTs2DEdOnTI0KFD88wzz5TWMXHixPTr1y/XXHNNunTpknbt2uWwww7LX/7yl3JtFhvglFNOSevWrfOzn/0sgwcPTteuXbPvvvvmoYceyv/+7//mvPPOS5KsWLEi3/jGN9KlS5e0adMmPXv2zPXXX5+FCxemrq4uSbLFFls4c3gjts8++6RTp06ZNGnSP13mrrvuyr/927+lTZs22W677TJ16tTSvHPPPTcDBw5c6zF9+/bNhRde2CQ186+9/xndtttum/79++fcc8/Nj3/84zzwwAOlf9M/aJ+fJD/5yU/yuc99LjU1Ndlqq61y8MEHl2Fr+Cg0RZrR22+/na9+9auZO3duZs2alVatWuXggw9e61vE5513Xs4888zMmzcvvXr1ypFHHqlL2UI9/PDDOfbYY3P66afnN7/5Ta655ppMnz49F198cYPlxo8fn0MOOSTPPPNMRo0alSOOOCLz588vU9WsacyYMbnxxhtL92+44YYcf/zxDZZZ3/f+2WefndNPPz3z58/P8OHDm6V+Grrjjjvymc98JjvssEOOPvro3HDDDSkWiw2WOeusszJ16tQ8+eST6dixYw444IAGZ/YsW7YskydPznXXXZcXXnghn/zkJ5t7MyijxtgnjB07NrfccktWrFhReswPfvCDbLvtthk6dGjzbAiN4oILLshhhx2WZ599Nvvtt19GjRrlW6XQQqzPMcO/cvPNN+fiiy/O5MmT89RTT6Vr1665+uqrm7BiPkhtbW1qa2szc+bMBv8Gr+lLX/pS3njjjTzwwAN56qmn0r9//+y9994N9u2/+93vcscdd+QnP/lJHnzwwTz99NM5+eSTm2szaCR//vOf89Of/jQnn3xy2rZt22Bep06dMmrUqNx+++0pFos59thjc+utt+byyy/P/Pnzc80116S2tjZdunTJXXfdlSRZsGBBFi1alP/6r/8qx+awgaqqqvLtb3873/ve9/LHP/5xrflPPfVUDjvssBxxxBF57rnnMnHixIwfP7704fqoUaPyxBNPNPgi1AsvvJBnn302Rx11VHNtBh9g6NCh6du3b+lLbh+0z7/vvvty8MEHZ7/99svTTz+dWbNmZddddy3nJvBhFGlSxx13XPHAAw9c57w333yzmKT43HPPFYvFYvHll18uJiled911pWVeeOGFYpLi/Pnzm6Ncmshxxx1XrKqqKrZv3750O/TQQ4t777138dvf/naDZb///e8XO3fuXLqfpDhu3LgGywwcOLB40kknNUvtrNv77+033nij2KZNm+LChQuLCxcuLNbU1BTffPPN4oEHHlg87rjj1vnYf/bev+yyy5pxC1iXQYMGlZ6HVatWFbfaaqvi7Nmzi8VisTh79uxikuJtt91WWn7x4sXFtm3bFm+//fZisVgs3njjjcUkxXnz5jV77ZRXY+4T3nnnneIWW2xRel0Vi8Vinz59ihMnTmyOTeGfWPOYrlu3bsVLL720wfy+ffsWJ0yYULqfpPjNb36zdH/p0qXFJMUHHnigGaqluXyU18WPfvSjZquPpvOvjhluvPHG4mabbdZg+R/96EfFNf/7PXDgwOIpp5zSYJk99tij2Ldv36Ysmw9w5513FrfYYotiTU1NcdCgQcVzzjmn+MwzzxSLxWLx4YcfLnbo0KG4fPnyBo/Zfvvti9dcc02xWCwWJ0yYUKyqqir+8Y9/LM1/4IEHiq1atSouWrSo+TaEDfbYY4/9y332d7/73WKS4uOPP15MUvz5z3++zuXe/z/EkiVLmq5YmtSa/9bvtttuxTFjxhSLxYb79aOOOqo4bNiwBo8766yzir179y7d79u3b/HCCy8s3T/nnHOKAwcObOLqWZd/9Vnt4YcfXtxxxx3Xa5+/++67F0eNGtXU5dJEnCnSjF588cUceeSR6dGjRzp06JDtttsuSda6tEqfPn1K0507d06SvPHGG81WJ02jrq4u8+bNK90uv/zyPPPMM7nwwgtL30qqra3NiSeemEWLFmXZsmWlx+6+++4N1rX77rs7U+RjomPHjqVLJtx4443Zf//9s9VWWzVYZn3f+wMGDGiuslmHBQsW5IknnsiRRx6ZJKmurs7hhx+e66+/vsFya74fP/GJT2SHHXZo8H5s3bp1g/04laUx9gk1NTU55phjcsMNNyRJfv3rX+f55593uYWN0Jr7gvbt26dDhw6O6aAFWN9jhg9axz9+m9S3S8vvkEMOyWuvvZZ77rknI0aMSH19ffr375/p06fnmWeeydKlS7Pllls2+P/byy+/3ODb3127ds22225bur/77rtn9erVWbBgQTk2iQ1U/IAzwBYuXJiqqqoMHjy4mSqinCZPnpwZM2as9XnM/Pnzs8ceezQY22OPPfLiiy/mvffeS/L3s0VuueWWJH9/Xd16660ZNWpU8xTOeisWiykUCuu1z583b1723nvvMlfMR1Vd7gIqyQEHHJBu3brl2muvzTbbbJPVq1dnp512ysqVKxsst8kmm5Sm37/urB/q3fi1b98+PXv2bDC2dOnSXHDBBfniF7+41vI1NTXNVRobaMyYMaXr/1955ZVrzV/f93779u2bpV7W7frrr8+7776bbbbZpjRWLBbTpk2bXHHFFeu9nrZt2651zXAqS2PsE8aOHZt+/frlj3/8Y2688cYMHTo03bp1a7Zt4F9r1arVWh+SrHkZvfeteUyX/P24zjFdy7W+rws2fh90zOC1sHGrqanJsGHDMmzYsIwfPz5jx47NhAkTcvLJJ6dz586pr69f6zH/+BsybPx69uyZQqGQ+fPnr/M3AubPn58ttthirUtr0bLttddeGT58eM4555wP/YWlI488Mt/4xjfy61//Ou+8807+8Ic/5PDDD2+aQvnI5s+fn+7du2fp0qUfuM/3/t+4aYo0k8WLF2fBggW59tpr8+///u9Jkl/96ldlropy69+/fxYsWLBWs+QfPfbYYzn22GMb3F/zR3sprxEjRmTlypUpFApr/RaI9/7G4d13381NN92UqVOn5vOf/3yDeQcddFBuvfXWfOYzn0ny9/df165dkyRLlizJb3/72+y4447NXjMfX42xT9h5550zYMCAXHvttbnllls+VGOOptexY8csWrSodP+vf/1rXn755TJWxMeB10VlWJ9jhm7duuVvf/tb3n777dKXXubNm9dg2R122CFPPvlkg2P8J598ssnr58Pr3bt3Zs6cmf79++f1119PdXV16SzPdXn11Vfz2muvlZpmjz32WFq1apUddtihmSqmMWy55ZYZNmxYrrrqqpxxxhkNPvx8/fXXc/PNN+fYY4/NzjvvnNWrV+eXv/xl9tlnn7XW07p16yQpnS3Axu+SSy5Jv379Grynd9xxx8yZM6fBcnPmzEmvXr1SVVWVJPnUpz6VwYMH5+abb84777yTYcOG+f3Jj5lf/OIXee6553LGGWfkU5/61Afu8/v06ZNZs2at9RuSbBw0RZrJFltskS233DL//d//nc6dO+fVV1/N2WefXe6yKLPzzz8/I0eOTNeuXXPooYemVatWeeaZZ/L888/noosuKi33wx/+MAMGDMiee+6Zm2++OU888cSHOj2fplVVVVU6ffb9A573ee9vHO69994sWbIkJ5xwQjbbbLMG8w455JBcf/31+c53vpMkufDCC7Pllltm6623znnnnZetttoqBx10UBmq5uOqsfYJY8eOzamnnpr27duv8xuKlM/QoUMzffr0HHDAAdl8881z/vnnr/VcU3m8LirD+hwz/PSnP027du1y7rnn5rTTTsvjjz9e+rHd9335y1/OiSeemAEDBmTQoEG5/fbb8+yzz6ZHjx7NuDWsafHixfnSl76UMWPGpE+fPtl0000zd+7cTJkyJQceeGD22Wef7L777jnooIMyZcqU9OrVK6+99lrph3bfvxRuTU1NjjvuuPznf/5n/vrXv+a0007LYYcdlk6dOpV5C/mwrrjiigwaNCjDhw/PRRddlO7du+eFF17IWWedlW233TYXX3xxPvGJT+S4447LmDFjcvnll6dv37555ZVX8sYbb+Swww5Lt27dUigUcu+992a//fZL27ZtU1tbW+5NYwPsvPPOGTVqVC6//PLS2Ne+9rV87nOfy7e+9a0cfvjhefTRR3PFFVfkqquuavDYUaNGZcKECVm5cmUuvfTS5i6dNaxYsSKvv/563nvvvfzpT3/Kgw8+mEmTJmXkyJE59thj06pVqw/c50+YMCF77713tt9++xxxxBF59913c//99+cb3/hGuTeP9eA3RZrY6tWrU11dnVatWuW2227LU089lZ122ilnnHFG6QM2Ktfw4cNz77335mc/+1k+97nPZbfddsull1661iVSLrjggtx2223p06dPbrrpptx6663p3bt3mapmXTp06JAOHTqsNe69v3G4/vrrs88++6z14Uby9w845s6dm2effTbJ378ZdPrpp+ezn/1sXn/99fzkJz8pfQMM3tcY+4Qjjzwy1dXVOfLII11S8WPg/WO6JDnnnHMyePDgjBw5Mvvvv38OOuigbL/99mWukHLwuqg863PM8Mc//jE/+MEPcv/992fnnXfOrbfemokTJzZYdtSoUTnnnHNy5plnpn///nn55ZczevRo+/syqq2tzcCBA3PppZdmr732yk477ZTx48fnxBNPzBVXXJFCoZD7778/e+21V44//vj06tUrRxxxRF555ZVsvfXWpfX07NkzX/ziF7Pffvvl85//fPr06bPWB6NsHD796U9n7ty56dGjRw477LBsv/32+Y//+I/U1dXl0UcfzSc+8YkkydVXX51DDz00J598cj7zmc/kxBNPzNtvv50k2XbbbXPBBRfk7LPPztZbb126xCobtwsvvLDBJVH79++fO+64I7fddlt22mmnnH/++bnwwgvXusTWoYcemsWLF2fZsmW+WFdmDz74YDp37pztttsuI0aMyOzZs3P55Zfnxz/+caqqqtZrnz9kyJD88Ic/zD333JN+/fpl6NCheeKJJ8q8ZayvQvGDfjWKDTJixIj07NnTZS8ANnL19fWpq6vLkiVLXDeaZrFw4cJsv/32efLJJ9O/f/9yl1PxHNOxLl4XNKZhw4alU6dO+f73v1/uUviIJk6cmJkzZ651uTQA4OPF5bOayJIlSzJnzpzU19dn3Lhx5S4HANhIrFq1KosXL843v/nN7LbbbhoiZeaYjnXxumBDLVu2LNOmTcvw4cNTVVWVW2+9NQ899FB+/vOfl7s0AIAWT1OkiYwZMyZPPvlkvva1r+XAAw8sdzkAwEZizpw5qaurS69evXLnnXeWu5yK55iOdfG6YEO9f1mOiy++OMuXL88OO+yQu+66a50/1AwAQONy+SwAAAAAAKAi+KF1AAAAAACgImiKAAAAAAAAFUFTBAAAAAAAqAiaIgAAAAAAQEXQFAEAAAAAACqCpggAAAAAAFARNEUAAAAAAICKoCkCAAAAAABUhP8Pdtc3YBtUKtAAAAAASUVORK5CYII=",
      "text/plain": [
       "<Figure size 2000x2000 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "plt.rcParams[\"figure.figsize\"]=20,20\n",
    "\n",
    "release_date = talk\n",
    "release_date.index = pd.to_datetime(release_date[\"Record Date\"], format=\"%Y-%m-%d\")\n",
    "calmap.yearplot(release_date['Duration_sec']);"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}