902 cesta písničky do éteru.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "1f3b4f06",
   "metadata": {},
   "source": [
    "Podklady pro články Anety Martínkové na iROZHLAS.cz v prosinci 2023."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "9b7d68a1",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "cc4bab96",
   "metadata": {},
   "outputs": [],
   "source": [
    "from src.tabulka import tabulka\n",
    "from src.graf import graf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "9b075d93",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(os.path.join(\"data\",\"CZ_RADIO_TOP_100_tydenni.csv\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "d04f9277",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.sort_values(by = ['rok','tyden','pozice'], ascending=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "921755f2",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['wk'] = df['week'].rank(method='dense').astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "166610ad",
   "metadata": {},
   "outputs": [],
   "source": [
    "premiery_pisni = pd.DataFrame(df.groupby(['interpret_hlavni','track'])['wk'].min()).reset_index().rename(columns={'wk': 'wk_poprve'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "30d4755a",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.merge(premiery_pisni, on=['interpret_hlavni','track'], how='outer')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "0089f5b6",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['tyden_pisne'] = df['wk'] - df['wk_poprve'] + 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "f2f7a602",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['tyden_pisne_bez_pauz'] = df.groupby(['interpret_hlavni', 'track']).cumcount() + 1"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2376c033",
   "metadata": {},
   "source": [
    "## Kontrola"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "0f26d586",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Axes: xlabel='week'>"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAB88AAAHsCAYAAABc9ezwAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjcuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8pXeV/AAAACXBIWXMAAA9hAAAPYQGoP6dpAAB820lEQVR4nOzdeZydVX0/8O+9s89kMtkzWUmABAiBAIlA2MIuCBTEioJ1r0VxC1qxlFajCBSslFasYquCC6L+gJ+t+lNwAYtojWiKgqJWyiKGKMSAEBKSOb8/6L3OTGbPncwzz/N+v173dZKZez/znXPuc57lzL23lFJKAQAAAAAAAAAFVh7rAgAAAAAAAABgrFk8BwAAAAAAAKDwLJ4DAAAAAAAAUHgWzwEAAAAAAAAoPIvnAAAAAAAAABSexXMAAAAAAAAACs/iOQAAAAAAAACFZ/EcAAAAAAAAgMKrH+sCRqKrqyseeeSRaG9vj1KpNNblAAAAAAAAADDGUkrx5JNPxuzZs6NcHv7ryMfl4vkjjzwS8+bNG+syAAAAAAAAAMiYhx56KObOnTvsx43LxfP29vaIeO6Xnjhx4hhXAwAAAAAAAMBYe+KJJ2LevHnV9eThGpeL55W3ap84caLFcwAAAAAAAACqRvrR38N/o3cAAAAAAAAAyBmL5wAAAAAAAAAUnsVzAAAAAAAAAArP4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOFZPAcAAAAAAACg8CyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAUnsVzAAAAAAAAAArP4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOFZPAcAAAAAAACg8CyeA8AYWvBXXx7rEgAAAAAAgLB4DgAAAAAAAAAWzwEAAAAAAADA4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOFZPAcAAAAAAACg8CyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAUnsVzAAAAAAAAAArP4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOFZPAcAAAAAAACg8CyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAUnsVzAAAAAAAAAArP4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOFZPAcAAAAAAACg8CyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAU3rAXz7/97W/HaaedFrNnz45SqRT/9//+3x7fTynFmjVrYvbs2dHS0hJHH3103HPPPT3us2XLlnjzm98c06ZNi7a2tviTP/mTePjhh3fqFwEAAAAAAACAkRr24vlTTz0Vy5Yti6uvvrrP719xxRVx5ZVXxtVXXx1r166Nzs7OOOGEE+LJJ5+s3mf16tVx8803xw033BB33HFH/OEPf4hTTz01tm/fPvLfBAAAAAAAAABGqH64Dzj55JPj5JNP7vN7KaW46qqr4qKLLoozzzwzIiKuu+66mDlzZlx//fVx7rnnxqZNm+JjH/tYfOpTn4rjjz8+IiI+/elPx7x58+LrX/96PP/5z9+JXwcAAAAAAAAAhq+mn3l+//33x/r16+PEE0+sfq2pqSlWrVoVd955Z0RE3HXXXfHss8/2uM/s2bNj6dKl1fv0tmXLlnjiiSd63AAAAAAAAACgVmq6eL5+/fqIiJg5c2aPr8+cObP6vfXr10djY2NMnjy53/v0dtlll0VHR0f1Nm/evIiIWPrur9WyfCJiwV99uUfb3/eH8tj+sgb7GUPJGihjpD+3+9eH+/Nr+bvUoo7ubVYyavU79fe1nVXLrN6ZO5M9koxa9O3O2JXPuYFqGGwO2Jl5pZYZw7lfFrZB88royVLfZn18xnO/6NvaZPRVf976tr/fc7htVsa4lv0y1n1ay34ZzYzh/q6DfW+gzOEYzjiNNLOv79XSSPpnvG0/u8p465fRzBgP88p469uhyGPf5sFwf5c8PW/NK9ns274el6dtbriyNj7Dec7197v09fWBxn+g7OHMy7t6Ds/C9lyrusb7vJLl+Xao201/z/2BDPWxffVtfxnDea4NVU0XzytKpVKP/6eUdvhabwPd58ILL4xNmzZVbw899FDNagUAAAAAAACAmi6ed3Z2RkTs8AryDRs2VF+N3tnZGVu3bo2NGzf2e5/empqaYuLEiT1uAAAAAAAAAFArNV08X7hwYXR2dsatt95a/drWrVvj9ttvj8MOOywiIpYvXx4NDQ097vOb3/wmfvKTn1TvAwAAAAAAAAC70rAXz//whz/EunXrYt26dRERcf/998e6deviwQcfjFKpFKtXr45LL700br755vjJT34Sr3rVq6K1tTXOOeeciIjo6OiI1772tfH2t789vvGNb8SPfvSj+LM/+7PYb7/94vjjjx/RL1GL9/mvhTx8DsNgv1NfXx9qHw70M3Z2PAaqY7i/284Y6HMYGD21fO7XYo4Y6nOur+ftcLfJWmw/Q/05Q2l3taHUMRrzynAyRuO+jL7hfpZOX48Z6c8CBleU7aYov+euUrT+HM1jw4F+1s4eL47kvHmgjKHWNZzz975+3nB+x/GgFv0yUGae+orsqsXzdjwaybWR4WbXwlDO37N6LYLiGei5NtJraCM55hmtjOH+LuNZf79LLa4tjuR5Mpz71WKMs6Cv5y3ZNpzzwd7/35nHDnbf0VQ/3Af84Ac/iGOOOab6/7e97W0REfHKV74yrr322rjgggti8+bNcd5558XGjRvjkEMOiVtuuSXa29urj/mHf/iHqK+vj7POOis2b94cxx13XFx77bVRV1dXg18JAAAAAAAAAIZn2IvnRx99dKSU+v1+qVSKNWvWxJo1a/q9T3Nzc3zwgx+MD37wg8P98QAAAAAAAABQczX9zPPxrBZvgQLkVy3frnCgfCBbRrJtjte3zQIA2BmOeWD82plzl8HeAnko9zNPAABZYvEcAAAAAAAAgMKzeA4AAAAAAABA4Vk8BwAAAABgSIbyNu5DuS8AQBZZPAcAAAAAAACg8CyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAUnsVzAAAAAAAAAArP4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOFZPAcAAAAAAACg8CyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAUnsVzAAAAAAAAAArP4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOFZPAcAAAAAAACg8CyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAUnsVzAAAAAAAAAArP4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOFZPAcAAAAAAACg8CyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAUnsVzAAAAAAAAAArP4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOFZPAcAAAAAAACg8CyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAUnsVzAAAAAAAAAArP4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOFZPAcAAAAAAACg8CyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAUnsVzAAAAAAAAAArP4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOFZPAcAAAAAAACg8CyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAUXs0Xz7dt2xZ/8zd/EwsXLoyWlpbYfffd473vfW90dXVV75NSijVr1sTs2bOjpaUljj766LjnnntqXQoAAAAAAAAADEnNF88vv/zy+MhHPhJXX311/PSnP40rrrgi3v/+98cHP/jB6n2uuOKKuPLKK+Pqq6+OtWvXRmdnZ5xwwgnx5JNP1rocAAAAAAAAABhUzRfPv/vd78bpp58ep5xySixYsCD+9E//NE488cT4wQ9+EBHPver8qquuiosuuijOPPPMWLp0aVx33XXx9NNPx/XXX1/rcgAAAAAAAABgUDVfPD/iiCPiG9/4Rvz85z+PiIj/+q//ijvuuCNe8IIXRETE/fffH+vXr48TTzyx+pimpqZYtWpV3HnnnX1mbtmyJZ544okeNwAAAAAAAAColfpaB77zne+MTZs2xd577x11dXWxffv2uOSSS+Lss8+OiIj169dHRMTMmTN7PG7mzJnxwAMP9Jl52WWXxXve855alwoAAAAAAAAAETEKrzz/3Oc+F5/+9Kfj+uuvjx/+8Idx3XXXxd///d/Hdddd1+N+pVKpx/9TSjt8reLCCy+MTZs2VW8PPfRQrcsGAAAAAAAAoMBq/srzd7zjHfFXf/VX8dKXvjQiIvbbb7944IEH4rLLLotXvvKV0dnZGRHPvQJ91qxZ1cdt2LBhh1ejVzQ1NUVTU1OtSwUAAAAAAACAiBiFV54//fTTUS73jK2rq4uurq6IiFi4cGF0dnbGrbfeWv3+1q1b4/bbb4/DDjus1uUAAAAAAAAAwKBq/srz0047LS655JKYP39+7LvvvvGjH/0orrzyynjNa14TEc+9Xfvq1avj0ksvjUWLFsWiRYvi0ksvjdbW1jjnnHNqXQ4AAAAAAAAADKrmi+cf/OAH42//9m/jvPPOiw0bNsTs2bPj3HPPjXe9613V+1xwwQWxefPmOO+882Ljxo1xyCGHxC233BLt7e21LgcAAAAAAAAABlXzxfP29va46qqr4qqrrur3PqVSKdasWRNr1qyp9Y8HAAAAAAAAgGGr+WeeAwAAAAAAAMB4Y/EcAAAAAAAAgMKzeA4AAAAAAABA4Vk8BwAAAAAAAKDwLJ4DAAAAAAAAUHgWzwEAAAAAAAAoPIvnAAAAAAAAABSexXMAAAAAAAAACs/iOQAAAAAAAACFZ/EcAAAAAAAAgMKzeA4AAAAAAABA4Vk8BwAAAAAAAKDwLJ4DAAAAAAAAUHgWzwEAAAAAAAAoPIvnAAAAAAAAABSexXMAAAAAAAAACs/iOQAAAAAAAACFZ/EcAAAAAAAAgMKzeA4AAAAAAABA4Vk8BwAAAAAAAKDwLJ4DAAAAAAAAUHgWzwEAAAAAAAAoPIvnAAAAAAAAABSexXMAAAAAAAAACs/iOQAAAAAAAACFZ/EcAAAAAAAAgMKzeA4AAAAAAABA4Vk8BwAAAAAAAKDwLJ4DAAAAAAAAUHgWzwEAAAAAAAAoPIvnAAAAAAAAABSexXMAAAAAAAAACs/iOQAAAAAAAACFZ/EcAAAAAAAAgMKzeA4AAAAAAABA4Vk8BwAAAAAAAKDwLJ4DAAAAAAAAUHgWzwEAAAAAAAAoPIvnAAAAAAAAABSexXMAAAAAAAAACs/iOQAAAAAAAACFZ/EcAAAAAAAAgMKzeA4AAAAAAABA4Vk8BwAAAAAAAKDwLJ4DAAAAAAAAUHgWzwEAAAAAAAAoPIvnAAAAAAAAABSexXMAAAAAAAAACs/iOQAAAAAAAACFZ/EcAAAAAAAAgMKzeA4AAAAAAABA4Vk8BwAAAAAAAKDwLJ4DAAAAAAAAUHgWzwEAAAAAAAAoPIvnAAAAAAAAABSexXMAAAAAAAAACs/iOQAAAAAAAACFNyqL57/+9a/jz/7sz2Lq1KnR2toaBxxwQNx1113V76eUYs2aNTF79uxoaWmJo48+Ou65557RKAUAAAAAAAAABlXzxfONGzfG4YcfHg0NDfH//t//i3vvvTc+8IEPxKRJk6r3ueKKK+LKK6+Mq6++OtauXRudnZ1xwgknxJNPPlnrcgAAAAAAAABgUPW1Drz88stj3rx58YlPfKL6tQULFlT/nVKKq666Ki666KI488wzIyLiuuuui5kzZ8b1118f5557bq1LAgAAAAAAAIAB1fyV5//2b/8WK1asiBe/+MUxY8aMOPDAA+Nf/uVfqt+///77Y/369XHiiSdWv9bU1BSrVq2KO++8s8/MLVu2xBNPPNHjBgAAAAAAAAC1UvPF81/96lfx4Q9/OBYtWhRf+9rX4vWvf3285S1viU9+8pMREbF+/fqIiJg5c2aPx82cObP6vd4uu+yy6OjoqN7mzZtX67IBAAAAAAAAKLCaL553dXXFQQcdFJdeemkceOCBce6558brXve6+PCHP9zjfqVSqcf/U0o7fK3iwgsvjE2bNlVvDz30UK3LBgAAAAAAAKDAar54PmvWrFiyZEmPr+2zzz7x4IMPRkREZ2dnRMQOrzLfsGHDDq9Gr2hqaoqJEyf2uAEAAAAAAABArdR88fzwww+P++67r8fXfv7zn8duu+0WERELFy6Mzs7OuPXWW6vf37p1a9x+++1x2GGH1bocAAAAAAAAABhUfa0Dzz///DjssMPi0ksvjbPOOiu+//3vx0c/+tH46Ec/GhHPvV376tWr49JLL41FixbFokWL4tJLL43W1tY455xzal0OAAAAAAAAAAyq5ovnz3ve8+Lmm2+OCy+8MN773vfGwoUL46qrroqXvexl1ftccMEFsXnz5jjvvPNi48aNccghh8Qtt9wS7e3ttS4HAAAAAAAAAAZV88XziIhTTz01Tj311H6/XyqVYs2aNbFmzZrR+PEAAAAAAAAAMCw1/8xzAAAAAAAAABhvLJ4DAAAAAAAAUHgWzwEAAAAAAAAoPIvnAAAAAAAAABSexXMAAAAAAAAACs/iOQAAAAAAAACFZ/EcAAAAAAAAgMKzeA4AAAAAAABA4Vk8BwAAAAAAAKDwLJ4DAAAAAAAAUHgWzwEAAAAAAAAoPIvnAAAAAAAAABSexXMAAAAAAAAACs/iOQAAAAAAAACFZ/EcAAAAAAAAgMKzeA4AAAAAAABA4Vk8BwAAAAAAAKDwLJ4DAAAAAAAAUHgWzwEAAAAAAAAoPIvnAAAAAAAAABSexXMAAAAAAAAACs/iOQAAAAAAAACFZ/EcAAAAAAAAgMKzeA4AAAAAAABA4Vk8BwAAAAAAAKDwLJ4DAAAAAAAAUHgWzwEAAAAAAAAoPIvnAAAAAAAAABSexXMAAAAAAAAACs/iOQAAAAAAAACFZ/EcAAAAAAAAgMKzeA4AAAAAAABA4Vk8BwAAAAAAAKDwLJ4DAAAAAAAAUHgWzwEAAAAAAAAoPIvnAAAAAAAAABSexXMAAAAAAAAACs/iOQAAAAAAAACFZ/EcAAAAAAAAgMKzeA4AAAAAAABA4Vk8BwAAAAAAAKDwLJ4DAAAAAAAAUHgWzwEAAAAAAAAoPIvnAAAAAAAAABSexXMAAAAAAAAACs/iOQAAAAAAAACFZ/EcAAAAAAAAgMKzeA4AAAAAAABA4Vk8BwAAAAAAAKDwLJ4DAAAAAAAAUHgWzwEAAAAAAAAoPIvnAAAAAAAAABSexXMAAAAAAAAACs/iOQAAAAAAAACFZ/EcAAAAAAAAgMKzeA4AAAAAAABA4Y364vlll10WpVIpVq9eXf1aSinWrFkTs2fPjpaWljj66KPjnnvuGe1SAAAAAAAAAKBPo7p4vnbt2vjoRz8a+++/f4+vX3HFFXHllVfG1VdfHWvXro3Ozs444YQT4sknnxzNcgAAAAAAAACgT6O2eP6HP/whXvayl8W//Mu/xOTJk6tfTynFVVddFRdddFGceeaZsXTp0rjuuuvi6aefjuuvv360ygEAAAAAAACAfo3a4vkb3/jGOOWUU+L444/v8fX7778/1q9fHyeeeGL1a01NTbFq1aq48847+8zasmVLPPHEEz1uAAAAAAAAAFAr9aMResMNN8QPf/jDWLt27Q7fW79+fUREzJw5s8fXZ86cGQ888ECfeZdddlm85z3vqX2hAAAAAAAAABCj8Mrzhx56KN761rfGpz/96Whubu73fqVSqcf/U0o7fK3iwgsvjE2bNlVvDz30UE1rBgAAAAAAAKDYav7K87vuuis2bNgQy5cvr35t+/bt8e1vfzuuvvrquO+++yLiuVegz5o1q3qfDRs27PBq9IqmpqZoamqqdakAAAAAAAAAEBGj8Mrz4447Ln784x/HunXrqrcVK1bEy172sli3bl3svvvu0dnZGbfeemv1MVu3bo3bb789DjvssFqXAwAAAAAAAACDqvkrz9vb22Pp0qU9vtbW1hZTp06tfn316tVx6aWXxqJFi2LRokVx6aWXRmtra5xzzjm1LgcAAAAAAAAABlXzxfOhuOCCC2Lz5s1x3nnnxcaNG+OQQw6JW265Jdrb28eiHAAAAAAAAAAKbpcsnt922209/l8qlWLNmjWxZs2aXfHjAQAAAAAAAGBANf/McwAAAAAAAAAYbyyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAUnsVzAAAAAAAAAArP4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOFZPAcAAAAAAACg8CyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAUnsVzAAAAAAAAAArP4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOFZPAcAAAAAAACg8CyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAUnsVzAAAAAAAAAArP4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOFZPAcAAAAAAACg8CyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAUnsVzAAAAAAAAAArP4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOFZPAcAAAAAAACg8CyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAUnsVzAAAAAAAAAArP4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOFZPAcAAAAAAACg8CyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAUnsVzAAAAAAAAAArP4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOFZPAcAAAAAAACg8CyeAwAAAAAAAFB4Fs8BAAAAAAAAKDyL5wAAAAAAAAAUnsVzAAAAAAAAAArP4jkAAAAAAAAAhWfxHAAAAAAAAIDCs3gOAAAAAAAAQOHVfPH8sssui+c973nR3t4eM2bMiDPOOCPuu+++HvdJKcWaNWti9uzZ0dLSEkcffXTcc889tS4FAAAAAAAAAIak5ovnt99+e7zxjW+M733ve3HrrbfGtm3b4sQTT4ynnnqqep8rrrgirrzyyrj66qtj7dq10dnZGSeccEI8+eSTtS4HAAAAAAAAAAZVX+vAr371qz3+/4lPfCJmzJgRd911Vxx11FGRUoqrrroqLrroojjzzDMjIuK6666LmTNnxvXXXx/nnnturUsCAAAAAAAAgAGN+meeb9q0KSIipkyZEhER999/f6xfvz5OPPHE6n2amppi1apVceedd/aZsWXLlnjiiSd63AAAAAAAAACgVkZ18TylFG9729viiCOOiKVLl0ZExPr16yMiYubMmT3uO3PmzOr3ervsssuio6Ojeps3b95olg0AAAAAAABAwYzq4vmb3vSmuPvuu+Ozn/3sDt8rlUo9/p9S2uFrFRdeeGFs2rSpenvooYdGpV4AAAAAAAAAiqnmn3le8eY3vzn+7d/+Lb797W/H3Llzq1/v7OyMiOdegT5r1qzq1zds2LDDq9ErmpqaoqmpabRKBQAAAAAAAKDgav7K85RSvOlNb4qbbropvvnNb8bChQt7fH/hwoXR2dkZt956a/VrW7dujdtvvz0OO+ywWpcDAAAAAAAAAIOq+SvP3/jGN8b1118fX/ziF6O9vb36OeYdHR3R0tISpVIpVq9eHZdeemksWrQoFi1aFJdeemm0trbGOeecU+tyAAAAAAAAAGBQNV88//CHPxwREUcffXSPr3/iE5+IV73qVRERccEFF8TmzZvjvPPOi40bN8YhhxwSt9xyS7S3t9e6HAAAAAAAAAAYVM0Xz1NKg96nVCrFmjVrYs2aNbX+8QAAAAAAAAAwbDX/zHMAAAAAAAAAGG8sngMAAAAAAABQeBbPAQAAAAAAACg8i+cAAAAAAAAAFJ7FcwAAAAAAAAAKz+I5AAAAAAAAAIVn8RwAAAAAAACAwrN4DgAAAAAAAEDhWTwHAAAAAAAAoPAsngMAAAAAAABQeBbPAQAAAAAAACg8i+cAAAAAAAAAFJ7FcwAAAAAAAAAKz+I5AAAAAAAAAIVn8RwAAAAAAACAwrN4DgAAAAAAAEDhWTwHAAAAAAAAoPAsngMAAAAAAABQeBbPAQAAAAAAACg8i+cAAAAAAAAAFJ7FcwAAAAAAAAAKz+I5AAAAAAAAAIVn8RwAAAAAAACAwrN4DgAAAAAAAEDhWTwHAAAAAAAAoPAsngMAAAAAAABQeBbPAQAAAAAAACg8i+cAAAAAAAAAFJ7FcwAAAAAAAAAKz+I5AAAAAAAAAIVn8RwAAAAAAACAwrN4DgAAAAAAAEDhWTwHAAAAAAAAoPAsngMAAAAAAABQeBbPAQAAAAAAACg8i+cAAAAAAAAAFJ7FcwAAAAAAAAAKz+I5AAAAAAAAAIVn8RwAAAAAAACAwrN4DgAAAAAAAEDhWTwHAAAAAAAAoPAsngMAAAAAAABQeBbPAQAAAAAAACg8i+cAAAAAAAAAFJ7FcwAAAAAAAAAKz+I5AAAAAAAAAIVn8RwAAAAAAACAwrN4DgAAAAAAAEDhWTwHAAAAAAAAoPAsngMAAAAAAABQeBbPAQAAAAAAACg8i+cAAAAAAAAAFJ7FcwAAAAAAAAAKz+I5AAAAAAAAAIVn8RwAAAAAAACAwrN4DgAAAAAAAEDhjeni+T//8z/HwoULo7m5OZYvXx7/8R//MZblAAAAAAAAAFBQY7Z4/rnPfS5Wr14dF110UfzoRz+KI488Mk4++eR48MEHx6okAAAAAAAAAApqzBbPr7zyynjta18bf/7nfx777LNPXHXVVTFv3rz48Ic/PFYlAQAAAAAAAFBQY7J4vnXr1rjrrrvixBNP7PH1E088Me68886xKAkAAAAAAACAAqsfix/6u9/9LrZv3x4zZ87s8fWZM2fG+vXrd7j/li1bYsuWLdX/b9q0KSIiurY8HU888cSQ2ogY8n2znvHEE08M+/cfrYws9Uve+jZv45Olfslb3+ZtfLLUL3nr27yNT5b6JW99m7fxyVK/6NtsZ2Spb/M2Plnql7z1bd7GJ0v9kre+zdv4ZKlf8ta3eRufLPVL3vo2b+OTpX7JW9/mbXyy1C9569u8jU+W+iVvfZu38clSv+SlbyMiUkoxEqU00kfuhEceeSTmzJkTd955Z6xcubL69UsuuSQ+9alPxc9+9rMe91+zZk285z3v2dVlAgAAAAAAADDOPPTQQzF37txhP25M3rZ92rRpUVdXt8OrzDds2LDDq9EjIi688MLYtGlT9bZx48ZYt25dRDz3iz/00EMREXHvvfeOqK1FRi2zZGS7njxlZK0eGdmuJ08ZWasnTxlZq0dGtuvJU0bW6slTRtbqkZHtevKUkbV68pSRtXpkZLuePGVkrZ48ZWStnjxlZK0eGdmuJ08ZWasnTxlZq0dGtuvJU0bW6tkVGbNnz46RGJO3bW9sbIzly5fHrbfeGi984QurX7/11lvj9NNP3+H+TU1N0dTU1ONr5fJz6/4TJ06sfq29vX1EbS0yapklI9v15Ckja/XIyHY9ecrIWj15yshaPTKyXU+eMrJWT54yslaPjGzXk6eMrNWTp4ys1SMj2/XkKSNr9eQpI2v15Ckja/XIyHY9ecrIWj15yshaPTKyXU+eMrJWz2hnzJkzp7qWPFxjsngeEfG2t70tXv7yl8eKFSti5cqV8dGPfjQefPDBeP3rXz9WJQEAAAAAAABQUGO2eP6Sl7wkHnvssXjve98bv/nNb2Lp0qXxla98JXbbbbexKgkAAAAAAACAghqzxfOIiPPOOy/OO++8ET22qakp3v3ud1ffzv3d7353TJw4cURtLTJqmSUj2/XkKSNr9cjIdj15yshaPXnKyFo9MrJdT54yslZPnjKyVo+MbNeTp4ys1ZOnjKzVIyPb9eQpI2v15Ckja/XkKSNr9cjIdj15yshaPXnKyFo9MrJdT54yslbPaGf0/jjw4SillNKIHw0AAAAAAAAAOTCyT0oHAAAAAAAAgByxeA4AAAAAAABA4Vk8BwAAAAAAAKDwLJ4DAAAAAAAAUHgWzwEAAAAAAAAovNwunt92222xefPmiIjYsmVL/Pd//3ds2bIlIiK2b98eP/nJT+Kee+6J7du3x6OPPhobNmyI7du3jzgzIuKRRx6JH//4x/Hoo4/WLLNS69133z2izIF+/+FkDlbrSDOH2g/6dnQyh7sNDCV7pDXnpW8jsvN8He7PydJzbbSfY1l/3g6lZn07us/XkRgv/dA7c2fqG+z3ztK8MpTskdacl31YluaVvrJ3dT/ktW+zsO/KW98ap6H1Q1aOkcfTvDKcnzHSnzOe+mO8PG/7yh7P/ZClvh3t82Z9Oz7ml6HUPB77dijnoeNpXhlOdp6PkcfLvDKcnzHSn5O3Ps7C87av7F3dD7XIfPrpp8fdnD1e9l3jcX9Yy3llp6RxaN26deniiy9O55xzTjrrrLPS+973vjR37tz02c9+Ns2cOTO1tLSkiEgLFixI7e3tKSKqt87OzlQul3t8LSJSqVRKdXV1adq0aenwww9PH//4x9NXvvKVNG3atAEzS6VSev7zn59mzpy5Q2ZEDJpZKpVSW1tbam5u7vG4efPmpcMPP7zPWntn3nvvvWny5Mlp0aJFqampKZVKpTR37ty0ePHiPn//UqnUZ+bChQvTq1/96vSKV7yi2qcf+9jHUktLS5o1a9aAfdpf5vOe97x05ZVXVsfrzDPPTEcccYS+3cm+ra+vT/PmzUtHHXVUOuuss4b8fB1oGyiXy6mxsTEtW7YsnXPOOemcc85JJ510Upo2bZq+3QXP10rmxIkTh9WnCxcuTNddd11at25destb3pLa2tqq21nvPn7Na16z0/2xq+fb4fbHeJgTGhoa0mGHHVadG1/84henBQsW6NsMzAnd6yyXy2nJkiXp4osvTr/97W/TTTfdlCZNmjSkfVkt+nbx4sWpqakpRURqa2tL06ZNS9OnTx9yP/TXt+VyOZVKpXTJJZekWbNmpYaGhjR16tS0zz77jGicsjSvNDQ09NiH9TdOtXi+jvY4Za1vR2NeGeyYQ99ma17pb7yK2LcLFy5Ml19+eerq6qrOpXV1dam+vn7M55Xu8+CHPvShdNlll6U99thjXB8j53nOrqurS9OnT09vetObUkopvf3tb0/lcjm1tbWlJUuWZHpOGK3+GC/ndoMdc+jbbM0J/Y2Xvs3mOV0R92V1dXU9fta8efPSqaeeOi7m7IsvvjhdfPHF6dRTT01tbW3pQx/6UDrzzDMzexxX9P3hX/zFX6Tf/va3fV5DzOqcsCvm2Syffwx1H5bVvu2vH6ZNm9bn40eSlYX94Wgea+zs83U87Q93dl6ZOHFiKpVKqVwup/r6+nTuueemZ555ZsTr0ONu8fxrX/taamxsrA58pTMinrvQ3f2Ao69JrL6+PjU0NKSISIsXL07Tp09PEyZMSBHRY+LqPlADZU6dOrW6gZTL5dTU1JQmTZqU5s+fX61vuJm77bZbiojqk6ipqSmtWrUqTZ48ufp7dM+cNm1aiogdduy9f273vuqdWS6Xq/3S1NSU6uvrezy296TevU+7Z+63337Vx1UuZFce398krW+H1rerVq1KnZ2d1edr90mm++88km1g8uTJqaOjI73pTW/qc5LSt2PzfK1sT/31ablcTq2trdWc7jVExKB9PJL+GMv5drD+yOqc0NDQUO2Pyty4bNmyaj9Ufoa+Hds5ob6+PrW0tKQpU6ak4447rvr7lcvlNGHChGrWcPdlI+3b/g5EK2NeLpf77Yfh9G3l+Vn5/86OU/c+He15Zc6cOdXHlUql1NzcvMv2Ybt6nHZ1347mvNLZ2ZkmT56cWlpaBhwvfZuNeaW/8SrqsUb3/p02bVr1Z/d12xXzSu9jjEpuqVSqHiNGRO6OkfMwZ1cuSM2dOzdFRFq5cuUOj83inDAa/TEezu2611X590AXfPXt2M4J/c2NlfvXYh9W1L7dFefLle8XZV/W0dGRpk+fntrb23vMDb0fn8V5pbLg3NraWv0ZlZqzeBxX9P1hR0dHtX8qf0TfV85YzwljMc9m6fxjsH1Y5TZe+nao82zlNnfu3EzP2bvyWKMWz9fxtD+s1bxSmev+9m//Ni1evDi94x3vGPFa9LhYPD///POrt1mzZqWDDz44TZkyJZ100kk9Ou/5z39+j4Eol597Je28efN2eGL9zd/8TZowYUI666yzUrlcTlOmTEkNDQ3ppJNO2qHD+8vs/gQol8vpX//1X9M555xTvbh08MEHp8bGxjRjxowBMyMivfCFL0zNzc3VC8GVk+lXvvKV6ZxzzkkTJkxIU6dOTQ0NDf1mvuENb+jx/8mTJ6fGxsZ0+OGH9/j929radshcvHhxamhoqB4wVJ5kRx99dIqIHn3YV5+2tbWltWvXpsbGxvTyl788tbW1pcWLF6f6+vrqhtN7vPTt8Pq2r+fr0qVLd5hERrIN1NfXp0mTJqW6uro0c+bMVF9f3+ekpm9H9/laLpfTUUcdlerq6qo/d8WKFSki0vnnn7/D7z9p0qTU0dFRzagc5BxyyCF99nFlpzNx4sR++6PyM/rrj1093w6nP7I6J+y3336pvb09nXXWWdW/Yo547gStXC6nY489Vt9mZE5oampK55xzTiqXy2mfffapzo3d54Gh7Mtq0bd/+Zd/2Wc/VPq2crDbVz8MtW8rv38la8aMGf1mLVq0KHPzSl/HHJWD98pftI7287UW45TFvh3NeaUyVnV1ddUT9L6OOfRtNuaV/sar94lqUfq2+1wRseOFrF09r/Q+xqgcCx544IGpXC6nPfbYI0WM/2Pksejb0Z5XSqVS6uzsTB0dHamzs7N6n4jI9JwwGv0xHs7t9ttvv9Ta2pra2trS6tWrq9taf8cc+nZs54T+5sbKeNXifLmofbsrzpeLuC874YQTqn+U197enhobG3fIyuK80tTUVH3skiVLejwmi8dxRd8fdnR0pPnz51dr7O8FAmM9J4xGf4yn84/B9mG9x2us+3Zn5tmJEyemU089NUU89+KIa665JpVKpczP2bvqWKNWz9fxtD/c2XnlqKOOSqeddloql5/7w5CXvOQladasWSNelx4Xi+flcjkddNBB6eijj051dXXpkEMOSeVyOR166KHpwAMPrD45L7nkkupfblduzc3N6X/+539SU1NTj7+mOOCAA1JEpL322itFRNp3331TRKRDDz007bPPPj0y+su87bbbenz9gAMO6PFEO+SQQ1Kp9NxbdvSXWXnifO1rX0utra3p1ltvTRGRXv3qV+/whCiXy9WF6L4yf/zjH/f4f2dnZ7+/f+/Mgw46KEVE9dWQlduNN96YIiJNmTJl0D6t/LX8F77whR59W9kx77XXXjts5Pp2eH3b+/m6bNmyVCr98RX+A/XpYNtAZZLq/lYc3S8O6tvRfb5WbmvXrk2tra3phhtuSBF/fGXlXnvtVc2s/P69+6VyO+yww3r8/+67704RkSZNmpQinvvLrMH6uNK3vftjV8+3w+mPrM4JlVcvV26Vvq3Uv3z58hQR+jYjc0LlL2srfVmZBysXMIayL6tF365fv756v+79UOnbd7zjHTvdt//zP/+Tmpubh5R18MEH9/h+VuaV3scce+65Z/U+/Y1TLZ+vtRinrPbtaM0r/d16H3Po22zMK/3der8dXFH6dvHixX32x1jNK72PMSrZlcdWjjEqt/F4jJznObuyn6q8srJy30MPPbS6CJG1OWE0+mM8nNu1tLRUn4sHHXTQDudjvY859O3Yzgn9zY2V79fifLmofdvf87WW58tF35dV+rX3MUdW55X999+/WnclIyKbx3H2hzsec0TsmvPmsb7OU7mNh/OPyjFHf/uw3uM11n27M/NsU1NTuv/++1PEc3+kcu+99444K4/HGrV8vo7H/eFI5pW1a9emlFK67bbbUmtra/VV7StXrkwf+9jHhr8uHePAokWL4vzzz49vfetbMWXKlPjQhz4UkydPjo9//OPxwx/+ML71rW9FRMRFF10U8+fPrz6urq4uGhsb48Ybb4y5c+fGtm3bor6+PhoaGuL3v/99REQceuihUVdXF+973/siIuLjH/94nHzyyXHAAQdUc/rLnDNnTkRElMvlaGhoqH4Ifblcjrq6uvjQhz4UkyZNisbGxn4zU0oREfGBD3wg9thjj7jjjjuiVCrFd7/73YiIWLZsWbS1tUVERGtra+y+++47ZDY0NERExMc+9rEe/fbiF794h98/ImLChAk7ZH7uc5+LiIgDDjggli9fHmvWrImIiDe+8Y0REfHUU0/126eVzEmTJkVExA9+8INobGyM173udRERceSRR0a5XI4HHngg3vjGN0apVNK3I+zb3s/XAw44IA466KD43e9+N2ifDrQNNDY2xsUXXxwREd/61reiubk5lixZEnfeeWef46Vva/98rWS+973vjT322CN++tOfRqlUivb29oiI2LhxY/U+ld9/9913j6ampmhpaYm99947WltbIyLi5S9/eZTL5Zg4cWJERJx88skREfH0009HRMSJJ544aB+/9rWv7bM/dvV8O5z+yOqcUFdXF11dXTF9+vSYPXt29Xl7+OGHR0TEKaecEuVyWd9mYE6YPHlydVxOPfXUHnPjJz7xiYiIIe3LatG3//RP/xQREV1dXT364Rvf+EaUSqVqn/fVD0Pp21KpFF/60pdi4cKF0dDQEOVyOUqlUr9ZRxxxRCxfvjxz80rvY44bbrghGhoaolQq9TtOtXi+1nKcstq3ozWvzJw5M+bOnRtTpkyJ5ubmfo859G025pX+xuvb3/52IY81vvzlL1ePt5qbm2PFihUREbF9+/aI2PXzSu9jjEmTJkVTU1N1PCrHGOP5GDnPc/b73//+KJVKcdRRR0VExN/93d9FxHPP2y9+8YvV+/fVx1k51qhFf4yHc7vNmzdHRERjY2Ocf/751W2tv2MOfTu2c0J/c2NlvGpxvlzUvt0V58tF3Jcdd9xx0djYWO3bPfbYo8cxR0R255X99tsv6urq4vzzz4+IiAsvvDAisnkcV/T9YeWYo76+Pu64447q82s0z5uzcJ1nvJ1/bN68OUqlUr/7sMp4ZaVvRzrPVubUD33oQ1Eul+Opp56Kt771rSPKyuuxRi2erzs7TuPtWOO9731v/OEPf4g5c+ZESikOOeSQWLFiReyxxx7xlre8JYZtpK8G35XOOeectHr16pRSSieccEJ6//vfnw4//PB0ww03pJRSWrduXYrY8W1Gmpubd/g8qpaWlupnsnT/q7hly5al+vr6NHfu3DRhwoT07W9/u89XyHTPrPylRKlUSk1NTT3uP3369PSCF7wgTZo0KTU0NAyYGf/7lza935an8tclEX98xdu+++67Q2bl9+99W7Vq1Q6/f/ef0T2z8ja0TU1NA2b21aeVnMpfgZRKpTR37ty02267Vd/aYb/99ktvfvObq5+HoG+H37eVt8CfPn169S8oK5kppUH7dKBtYM6cOT3eqqVcLqd3v/vdad26ddW/8NG3o/98bW5uTs3NzUPu01mzZqW6urpUV1eX3vCGN1T/6rGynfXXHytWrBi0j+v+9y1Ze/fHrp5vh9MfWZ4TKs+L3XffPZ100kk93vam8teK+nZs54S6urrq5543Nzenurq6tGLFinTSSSel9vb2dP7556eIGNK+bDT6tns/9M4ZSd9OnDgx1dXVVT9GYO+9996pcRqreaVUKvW5D3vRi1404Djt7PN1V43TWPbtaM0rlblw6tSp1bfaH8oxh74dm3llsPEqWt+edNJJ1b/g7ytvLOaV7scYlXGaMGFCn8cYff3+4+EYeaz6djTnlSlTpqRly5ZV31JwxYoV1WONG264If37v/97Wrp0aebmhNHoj+7bV9bP7ebMmZMOP/zwHnPiUI459O2unxP6mht7j5e+zc45XZH3ZTNnzqw+JydPnpxKpVJ69atfnT796U+nAw88MNPzSvdrvpdffnmKiB0eP9A4jedj5NHu29GYV7ofc7z//e/f4RpiluaEWvdH5d/j5fxjZ/Zh4+W6evdb9+0t63P2rjzWqMXzdTztD2sxrzQ3N6fW1tY0e/bsVCqV0vz589N9992XUkpp06ZNw16XLqX0v8v9GbZ+/frYsmVL7LbbbnHzzTfHt7/97fjTP/3TaGtrq/4Fw+233x4REZ///OfjE5/4RGzevDmWLVsWs2bNisceeyzWr18fzc3NMXXq1HjyySfj2WefjWeffTZKpVJs3rw5nnrqqZg1a1asXLky3v3ud8eCBQuGlLnHHnvE6aefHtddd13cf//9USqVYtKkSdW/Tu7s7Ix99tknrrzyyn4zp0yZEgcddFCUy+V48MEHo6GhIY499thYu3Zt/Pa3v43HHnus+tdvEbFDZuX37545Z86cOPnkk+Phhx/e4fd/7LHHdshctGhRzJw5M97whjfEC17wgmrmN77xjfjCF74QKaW47777+u3Txx57LDZu3BjPPPNMdHV1RWdnZ0yYMCFmzJgR8+fPj9e85jXR1tYWP/3pT+OjH/1o9S+Z9O3Q+3b79u1RX18f9fX10dXVFc973vN2yBzpNhARsXXr1mhqaorJkyfHO9/5zthzzz0H3L70be2fr5XMrq6uIfXpggULYq+99opjjjkmfvazn1Xnxcp29q1vfatHf2zcuDEeffTReNGLXhRPPfXUgH3c3NwcpVKp5s+1kcy3Q+2PrM4J69evj2effTba29tjwoQJMW3atOjo6KjOjd/+9rfjlltuqY6Xvh2bOaG9vT2efPLJaGpqitbW1pg0aVJcd9118bOf/Sx+/OMfx69+9asdtrGB9mW17NsFCxbE8ccfHw8//HDcc889kVKKJUuWxBNPPNFnPwzUt9dcc01s3749zj333PizP/uz+M///M9Yv3593HjjjfHkk09GV1fXkLKyMK88+eST8cwzz8TkyZP73IcNNE47+3wdzXHKQt+O5rzS0NBQfZVRc3NzvPvd7x70mEPfjt28Mth4Fa1vFy1aFMuWLYvjjjsuZs2aFQ8//HBcfPHFcd9990Vzc3McccQRu3Re6X2MURmnf//3f49f//rXOxxjjNdj5DzO2Q0NDTFx4sRYtmxZvOENb4jf/va3Pa5z3HnnndHV1RX77bdfpuaE0eiP7ttXVs/tKplTpkyJlNIOc+JAxxz6dtfPCf3Njb3Ha2fOl4vat7vifLlo+7LvfOc7sWnTptiyZUs0NDTES1/60uq+YPv27fHoo49mdl7pfl2jco3+s5/9bFxxxRVx1VVXZe44ruj7w+OOO67PY47RPG8eyZwwGv0xns4/hrsPG+u+Hek8u3jx4iiVSvHMM8/EY489FimlaG5ujq6urkzP2bvyWKNWz9fxsj+s1bzS1dUVGzdujPnz58d1113X4928hmtcLJ4PV1dXVzz55JMxceLEHm87IjN7uaOVPV4yRyvXeI1e7njJ3FU/R+bojdt4qXm8ZI5m7mhlj4fM8VDjaGePp+freMkc7ezx0g/jJXO087OemfX6dlV+kTNHM3e0f8Z46o/xkjna2eOlH8ZL5mjnyzReWT/mGM3c0coeL5mjleuYY/Rzx0vmaGdnvR+yXt+uypc5euM17hbPH3jggVi/fn2USqV49tlno76+PtavXx8ppernkAy1nT17dsycOTN22223sf61hiWlNKTfr1wuD/m+n/zkJ+OFL3xh3HzzzT3ajo6OuPbaa/v83mBtR0dHRPxxzHZmnCpjXSqVxt2Y9TcGwxmf/sZrZ8anVuPVfXx6P2Y8bmOVMdmZ8elrjPvbxoYzPr3HujJmEf2P20DjU9S5cTjb4lDHbTjbYkdHh31ZFGdf1tc2OJ7GbLC+H8lc2XucarEvsw97Tu+xqNW+rBbj09c+bKjjNZR92Xgcr4iR77sGGuPhHnMMZRscaLwca4zuMcbOjtNIxsc4DX+8RrIv634sH1HcY42K/sYgK+fN3TPsw7J33jzQGNuHPWek4zSW58v2Zfnfh+V9nGpxvlzL6xoVzpvzdd48nDlyPI2XY43xMU7dZfVYo/ccOJxfaFy48sor09y5c1O5XB7wMxKGeyuVnvt87n/4h3+o/qx169ZVP5NgOO0//dM/pYhIxx13XIqIdOaZZ6bjjz8+RUQ67bTT0rRp0/ps582bl/7+7/8+zZo1K5166qlp+vTp6dRTT03Tpk1Lhx56aFq2bFnq6OhIK1euTM3Nzf1+VkDvr7e1tfV539L/fsZB5fNdGxsbq79HQ0NDuvfee6ttSmmHr/Vu6+rq0t13350aGhrSv/zLv6RyuZz22muv6mc71Hq8yuVyjzEb6Xh96UtfSi984Qt7jFlf4zVv3rz0gQ98YIfxmT59ejrzzDOr9z3llFPSxIkTdxivSh8MdXyGM15DGZ++2n/5l39J9fX11faKK65Is2fPrulY9beNDXV8et+3VCr1O15DGZ/ebWW8DjjggLTbbrult7/97T0+r2Oo49PXNlgqlVJjY2M66KCDUmtr64Db2FDH69lnn61ua+VyOS1evLj6+SdjMW7DGcvec2P3OXKgubG/bXDatGlpxYoVacKECemII44YdG4cylxZ+Xynoc6NQ5krK+PVvZ0+ffouGa9a7MvOPPPMAedG+7KxmRt7b4MDzY3D2Zf1tw/r3ffD3ZcNZZyGuy8bD/uw4Y7TUI81+jvmOOyww9KkSZNSfX39sMZnKOP1ile8YkT7rv72YbtyLhzuscZAxxwXXXRRiohhHWt0b+fOnZte9apXpYkTJ6ZDDz00TZw4Mc2fP39Ev2P3f3d2dqbW1tYR7bv62gbHct+Vh2ON0TjGyOo4jWROHOvz5YHGqfe2NdzxGmhf1td4zZ07NzU0NFSP58fzscbO7sPGy3lzZV82HvdhRThvTillYm4c7r6s+3j99V//dY9xG+6xRmVb7OzsrO7DKsccCxYscL6ck33ZWO/Dul+PamxsHPb2P5xx2pXXNbJ8vryz1zXmzp2bWlpa0owZM1JHR8eYzoljde3XeXO292GONUY2TkPd1op8rNH9eyMxLhbP3/ve96aJEyemv/u7v0tveMMbUnt7ezrqqKNSS0tLWrhwYYqINGvWrOoF7oFuDQ0N6cADD0ytra3pyCOPTBMmTEgnnHBC6ujoSBdffHFK6Y8niMNpI6LPRazuG2pf7WAnyXV1ddX7Tps2LUVEmjBhQo+M7j+38rWmpqYebS0PZkZymz17dqqvr0+lUql6cWCwcZo1a1aKiLRgwYLU0tKSjjrqqNTe3p7OO++89Hd/93fVMduZ8dprr712anz66tve49X9gv5g49O7HYtb5XeuPPf6Gq/u4zNp0qQe7UEHHZRe+9rX9ruNDXWcum+Ll156aYqIHcZrOOPTX99Wtp/m5uYdMgcbn762wbG6da+lXC6nBQsW9Dk+/c2Vg82NA43PSObGwcZnsDGuZJbL5X7nxoHGqfe2uKu3ucrPmzx5coqI6oFW1vZlg42Pfdng+7DKtrdw4cLU2tqaXvnKV6a//uu/HvHc2H0b7G9uHMm+rHff9x6n4YyPfdjwxmkk+7LeX1+yZEmKiNTQ0FD93lCPNbKwL+trvAYap8pcOdx911D2Zb3Ha2eONfob45GcMww0N4/FeDnWyO4xRuVnzpkzJ0X88RhjsPEZ7jgN91hjpM/9WhxjDOdYYyzGqvv/x9uxRi32YeP1vLn3czCL+7CdGafefZuX8+ZdtQ8bylxZGa8jjzxyxOPT3xhXjgm7f308nS9XfqZ92fjYh1Xmhcr1jQULFoyr6xpFOF9ubGzs8f+snDfvqmu/lf/n6bx5KMca42Uf1v33i3CsUcvzZccaz+VOnjw5TZ48edjr0uNi8Xzu3Lnp5ptv7vHv7u073/nOVC6X080335ymTp2aJk+e3G970003pebm5nTIIYekcrlc3bH3NdjDfUJVBr/yJKk86SMiTZkypc/2la98ZYqIdPDBB6eIqP4VSGWn1tzcXM3r6zZp0qTqpFmp4S/+4i9SxB//guR1r3tdjw208oRsaGio/hVHf79Xpc7KX6a1tLT02c6bN6/HE7ylpSXNmjUrNTc3p1e+8pWpoaEh3XzzzamjoyPtueeeQxqncrmc3vnOd/Y5Xt3/+mikG3zlokT3ce89XoONT2NjY/W+lXHqPV7dn1NDGZ/ebfeD4N12261H9lDHp3fb+1ZfX18dr+7j1N94dR+f3m1zc3N64QtfmCZPntxjG+jvwGU4B6+9v1e5wDKU8endVsapMsaV2/vf//5hjU/vbbBUKqV99903RfzxYHrevHk96h5sfPo6iDj00ENTxB9PRiZPnpyam5vTrFmzUlNTU4/xev/7358aGhr6HJ/+5spDDjkkNTc3V8et99w4kpOL/ubGytcHGp/BtsHBThIHG6e+tsXuB9Hd58be49bXc7a/bbEy9q2trSkiUnt7ezr99NPTlClTqnNjpd3V+7LBDmQmTpzY79xoXzbwvqyvObL7eFUOlHtv50MZn762wVrsy/rbh3X/GcMZn77G6dhjj+0zd7j7st63sdiH1XKchnOs0d8xR++fO9xjjco22P33rBxzTJ06dVjjM5R9WHt7e2pubk5vfvOb+x2vgcapMlf23nf1t88ayYWyyn0mTpzYox3OsUbvbbCyDfzpn/5pioj0spe9bFjj09c2OHfu3Op4DbTvGs4+rK99V+/xcqwxOscYtRqnyvj0PsYYyrFGZZz6O8bYmQuZY3W+PNRxqmyL/R1jVH7n4RwL9ndMGBHppJNOSlOmTEnTp09P5XJ5XB5r1GIfVrll6by5rz6rLN5Nnz593OzD8nrePNA2uGzZsh7b2mjtwyrjNdi4DWWu7D6fRUSaMWPGkMenv7nyta99bY+MyvhUblk+X7Yv27nz5V2xD5s8eXI6/fTTU319fdp///17jFP3fdl4ua6RlfPl0bquEfHcH9g1NzdXjzmKdu03j+fNQznWGC/7MMcao3e+XMtxGi/HGitWrEilUiktX748lcvl9KIXvShde+216dprrx32uvS4WDxvaWmpvry+8u/u7Re/+MUUEenee+9Nzc3Nqampqd/2Jz/5SYr4419bzJw5s8cTZzh/ndL91QjdMyp/9TOUv+ioTA6Vja3S/vM//3OKiPTnf/7nAz6+8nt1f6LecccdKSLSZz7zmRQR6Zvf/Gb1vpW3OqhM9CeeeGL1/5WcyoW9Y489Ni1fvrzHE7e/9qtf/WqPJ3Nzc3OaMmVKampqSl/5yld6jM+ECROGPE6Vse09Xt0vOgx1fHq3bW1t1fv2d0FhsPF5zWteM2gdlefFUMand1sZr3K5nJqamtL+++/f4/ca6vh0bytj3/0vWysTZFNT0w7j1Nd49R6f3u3JJ5/cb58OdXyG8gqiynNuZ8an94HvXXfdNeTx6WsbbG5uTvvvv3+KiLRo0aJUV1dXHadK3YONz4033thjW4yI9Ktf/SpF9Fw8b2pqSlOmTKkeyFfG67777htwfPqaK+vr66tzQURU30q291/7DWV8eo9x77nxoIMOGvb49B7ja665JkX0P0cONk59bYv77bffDnNj73Hra3wGmiu/+tWv9hi3jo6OdNddd6WWlpbq3Fhpd/W+rL9tsJKx2267DbodDzZORd2X9TdHVsar8gqKkYzPQNvgaO7LhjM+/Y3TmWeeWf3Zld9jOOOTpX1YLcepFuPTe5yGc6zRfRusvPVguVxOS5cuTXV1dWnp0qXDGp+h7MM6OjoGHa/Bxunee+/dYd9Vi/HpfaucXFfuuzPHGr3H+P/8n/8zrPHpaxusvDJjyZIl/e67BhqfvrbBvvZdvcfLsUbtjzFqOU6V8el9jDGUY43KOJ1xxhkpYsdjjJGMz1ifLw91nL75zW/2e4xRGa/hHgv2NV6Vfrn11ltTS0tL9SLreDzWqOU+LCvnzd3HuPL4UqlUveg6nvZheTxvHmwb3FX7sMqtcl1pZ8apMh6VubHymFoca1T2ZatXr+5ze8vi+bJ9Wd/zY1b2YZW2MgdU3h699/WN8XRdIyvny6N1XaOyD2tqaqoecxTt2m9/4zWez5uHcqwxXvZhvbfFyq3oxxq1OF+u5TiNh2ONUqmUvv/976f6+vp0zz33VNuRKsc4cPDBB8cll1wS27Ztq/77ec97XlxyySWxYsWKeOtb3xodHR1x8cUXR3t7e3R0dPTbvu9974u2trbYunVrtLW1xYIFC6KtrS2WLVsWbW1tcc0118SiRYuiVCoN2v7gBz+IiIi/+Zu/iYiIa665JiIi/u7v/i4iIq644orqh9G3tLT02Z5xxhkREXHkkUf2aL///e9HRMRnPvOZaG5ujoiIUqkUERHl8nPDVl9fH6VSKZYsWRKlUil23333KJVK8dhjj0VExJYtWyIiYvv27dX77rvvvtHS0hLTp0+PlFI0NjZGV1dXRERs3bo1yuVyLFiwoFrjxo0bo1QqxRNPPNFvGxHx8pe/vJoTEbHHHnvEli1bYsmSJfHhD384yuVyXHLJJbF06dLYvHnzkMapo6Mj3vrWt0Zra+sO4/UP//APMWnSpFi8ePGQx6d3+/Wvfz2mTZsWpVIppk6dGqVSaYfxGmx8PvvZz1bvWxmn3uM1bdq0iIghjU/vtjJe06ZNi61bt8Zf/uVfRl1dXTV/KOPT13il5/5wpjpec+fOrY5XZZyeeeaZfser+/j0btva2uKMM86Ijo6OWLRoUUyaNKnadh+vwcan+7ZYGafe4/XhD394yOPTu62MU2WMJ0+eHBERH/nIR4Y8Pn1tg/X19fGZz3wmSqVS/OEPf+gxTimlIY3P6tWre2yLERFHHHFERPxx+y+Xy7H77rvHli1bYo899qiO1zPPPFPdlvsan/7myra2tthjjz2q43bEEUf0mBsHGp/BtsHec+Nb3/rWQcdnsG2wkl3p6+59M5Rx6r0t1tXVxb//+7/vMDf2Hre+xqe/uTLiubmxe21bt26NrVu3xsEHH1ydGyvtrt6X9bcNVsbrhhtu6HdutC8beF/W1xzZfV/2rne9q9+5cThzZH9z40j2Zf3twyrjNJzx6W+ctm7dGps3b45yuVzdlw11fLK2D6vlOA3nWKO/Y47p06dHRMSkSZMiIoZ1rNF9G6yvr49ly5ZFXV1dbNq0KUqlUmzatCkiYsjjM5R92NatWwcdr4HGqTJX9t539R6v4Rxr9HfM8W//9m8REfGOd7xjyOPT3xx5zDHH9GhvvPHGYY1P722wrq4uPvShD1WPOfrbdw1nHxbR976r93g51qj9MUYtx6kyPr2PMYZyrFEZp9bW1j6PMUYyPmN9vjycY43+jjEq4zWU8RnsmLCS89///d+x7777xtatW6vnNuPtWKMW+7DKuGXlvLn7GEdE9diwkjee9mF5PG/uPj69t8GIXbcPq4zX6aef3uc+bChzZWWcvvOd70TEH+fGyjHHSI41KmNbOdaoPI8+8pGPjJvzZfuykZ8v74p9WKW97777oqmpKb7whS/0GKdKO56ua2TlfHm0rmtEPLcP23333avHHEW79pvH8+ahHGuMl32YY43RO18u2rFGRMSLXvSiHtcMd8qIl913obvvvjt1dnamyZMnp2OOOSa1trZWPxcghvjXFX3dKn+Z3NDQkFpbW9MZZ5yRzjvvvHTGGWek9vb2Qdt77703TZgwIZ199tmppaUlveENb+jRvutd70rHHntsamtr6/F2BN3byl/49H67jEpbeSuHSr2VtvS/bzuxYMGC9PnPf776WeB9tddee22P+y5fvjx9/vOfT4sWLUrTpk2r/pVM5e0oX/e616W6uro0a9asdPbZZ6eISC94wQsGbPu7NTc3V3+Xnf3MiXK5nOrr61NnZ2dqampKLS0t6aUvfemQxqd32318Ojo6erTdx2uw8XnFK14x5Fe4D2V8erd9jVdnZ2f1eTvU8RnOeDU1NdXs80Eq21hjY+MO4zXQ+EyYMKHHttjXOHV0dKR77703NTU1DWl8ere9x6f725R0H6+BxqevbbAyXsuXL0/vete7UmNjY3WcKtvYUMepsi1G9P+K0og/fgTBUO471HGr9GtlbhxofAbaBvuaGyvtQOMz2DZYGafec2T3uXGgcerdLl++PKWUBpwb+xufgebKvm6tra3pmGOOqf4OtRivkezL+toG+9qH9TU32peNbKxKpVJqaWkZcG4czhzZ39w4kn1Zf/uwyjgNZ3yGMk5Tp04d9vhkaR9Wy3EazrFGf8ccvfdlwznW6Gu8uu/DDj/88GGNz1D3YbtivIZzrNHfMUf3fVlfxxzD2Zf1PtaotMM91ujrmOMb3/jGkPZdQ9mHDWX7cqwxuscYOztO9fX11Vcu7Ow21fsYY7jjk4Xz5eEcawzlGGM4x4IDjVfv7Wg8HmvUYh/mvHn09mF5P2/uaxscynjV6vyrsbExzZo1q8992FDmyr6ONfo65hjJvqz3OFXmyvFwvmxfNvLz5bHYh7W0tKRSqTSij0Pta6zG4rpGFs+XR+O6Rvdb0a79Om/O9j7MsUbf41SL8+UiH2u87nWvSw0NDTv1yvNSSrVahh9dTz75ZHz605+O733ve/Hwww/Hb37zm9i8eXM888wz0dXVFc8888yw8lpaWmLSpEmx//77x5FHHhkvfvGLY/LkybF9+/aoq6sbUtva2hpbtmyJ7du3x9q1a+POO++Mww47rM+2paUlPvWpT8XLX/7yHu0HPvCBuPzyy2Pu3Lnx8MMP92gfe+yx+MAHPhB33HFHfPGLX4zTTz+9R7ty5cpoamqKKVOmxIYNG/r9XU8//fS46aabqvetr6+Pbdu2RX19fWzcuDE+9rGPxU9+8pPYc88944EHHohDDjkk1q5dG//v//2/uOKKK+Ib3/hGHHLIIfGf//mffbbf/e5344ADDoh169bF3nvvHT/72c/ii1/8YsycOTO+8pWvxI033hgPPvhgdHV1xRNPPFH9y5HBlEqlaGpqqrYtLS3R2dkZc+fOjYMPPjjOPvvsaGtrG9L49P7eUMdroPF5+OGH46ijjqred/Xq1X2O05ve9Kb4p3/6pzjqqKMGHZ8tW7b0aPsbr3vuuSf++q//Ou66665Bx6evdv/99+8xXp/85Cdj8eLF8ZWvfCV+9KMfxW233RZPP/10bN26td/xqoxLuVyOxsbG2Lp1a3R1dcXmzZujVCpVt7Fly5bF4YcfvsN4DTQ+Qx2vCy+8MG6//fb49Kc/Pej49N72KuNVGZ8Xv/jF8YUvfKHaVsZroPHpPk6VbXD27NnV8dq2bVts3rw5vvzlL8dXv/rVHtvYUMdr7dq18fGPfzyuueaa+I//+I9YsmRJ3HvvvfGv//qvsc8++0RDQ0NcfPHF8T//8z/x4IMPVsctIqK9vX2H8elvrkz/+xdclXE76KCDYuXKlSOaG7uP8e233z6iuXGgOfKxxx6rjlNfc2RlbhxonHqbPXt2nHXWWXH99dcPODf2NT79zZWVufGHP/xhLFmyJH72s5/FZz/72fjpT38aP/nJT2Lt2rXx+9//PrZu3Rrbtm2LpqamXbov62sbtC+r3b6s9xxZ+UvZyl+89zc3DmeOrOW+bO7cuX2OT6U988wzhzw+g+3DKuP00EMPDXl8srYPq+U4rVy5csjHGr33Yb2PNXrvwwYan8GOOSr7sI985CNx7733xuGHHz6sY43+9mHd58LBxqu/carMlb33Xb3HazjHGv2NV+VYo/K13sccAx1rdJ8j+zrW6L4vG86xRkX3Y46zzjorrrnmmiHtuwbahw207+o9XhGONUbzGGNnx2nz5s3Vv7jv6OgYdHx6j1Nra2t0dHTk4nx5KONUmSu/+93vDukYYyjHggMdE370ox+NffbZJyZPnhyf+cxn4u67764ez4+nY41a7MOyft589913xxVXXBHXX399/PCHPxxX+7AinDd33wZvvfXWXbYPq4zXq171qmhqahrRPqwyXr2PNXofcwz1WKOyLXbfh/W1LxsP58v2ZSM7X94V+7Du16MmT54cN954Y/zXf/1X3HfffT2uSTU0NAw4Rt2N9XWNrJ4v1+q6xkc/+tGYP39+tLW1xVe+8pW4++67o1wuF+rab17Pmwc71ug9J2Z1H+ZYo+9xqsX5ctGPNdauXRvf+973Yq+99up3fh7IuFk8BwAAAAAAAIDRMi4+87wvp5xySvzmN7/p8e+RtrXIyFo9ecrIWj15yshaPTKyXU+eMrJWT54yslaPjGzXk6eMrNWTp4ys1SMj2/XkKSNr9eQpI2v1yMh2PXnKyFo9ecrIWj15yshaPTKyXU+eMrJWT54yslaPjGzXk6eMrNUz2hk7ZcRv+D7GJkyYkP77v/+7x79H2tYiI2v15Ckja/XkKSNr9cjIdj15yshaPXnKyFo9MrJdT54yslZPnjKyVo+MbNeTp4ys1ZOnjKzVIyPb9eQpI2v15Ckja/XkKSNr9cjIdj15yshaPXnKyFo9MrJdT54yslbPaGfsjHH7ynMAAAAAAAAAqJVxu3i+2267RUNDQ49/j7StRUbW6slTRtbqyVNG1uqRke168pSRtXrylJG1emRku548ZWStnjxlZK0eGdmuJ08ZWasnTxlZq0dGtuvJU0bW6slTRtbqyVNG1uqRke168pSRtXrylJG1emRku548ZWStntHO2BmllFLaqQQAAAAAAAAAGOfqx7qAkfj9738fX/jCF+LBBx+M6dOnR0TEQw89FI8++mh0dHTEpk2bhtzOnDkz5s2bt1MZtczKS8avfvWrWLJkSUREzJs3L+6+++449NBDY9GiRbFq1aq46667Yvny5f22ETHofWTULisiYsOGDXHPPffE/Pnz48EHH4zW1tb4+Mc/HnV1dbFhw4aYMWNGj3bBggXx5JNPxh/+8IdoaGiIhoaGOProo+Pb3/52v4+RMXDGSLIWLFgQjz/+ePzud7+LRx55JJ599tmYOnVqTJ48OVpaWmLGjBnx7LPPRrlcjkcffTQ2b94c9fX1sW3btiG1ecrISj3PPvtsNDQ0REtLS0ydOjWefvrpSCnFk08+GU888USUSqVIKQ2pnTBhQnR0dEREjGlG1uqpdcakSZNi+vTpMXPmzDjssMNi0aJFERHx1FNPjWguPuqoo0b82FpmZK2e0co46qijanD0Sa1t37496urqqu2dd94Z27Zt2+F+dXV1sXXr1mhsbIytW7fGEUccEWvXru3zvv2RsfMZ3cdq+/bt8bGPfSwuu+yyuOiii+KSSy6ptrNnz45Xv/rVPb423FZGbbLe8Y53xFNPPRUtLS2xefPmmDVrVrS1tcUvf/nL6teG2+YpI2v1VDJ+9KMfxQ9+8IP47W9/O6xz8CxcAyjC9ZW1a9dGqVSKLVu2RFNTU6SUYtWqVTtc54jI/jWAImRE9H+do729fUzO32UMnNHX9Y158+bF4sWLx/x6goz+s6ZPnx7btm2LUqkUjz766Jifv4/3jNGuJ6UUCxYsiH333Xenrm9k+RrAeK9nKBmuc2RLf9c3snINoJZZ4yGj9/WLlStXjuxV6CP5oPRd7UUvelG68cYbU0opnXDCCam9vT01Njam+fPnp4jYqVu5XN7pjFpm5Smjv8zZs2enUqmUdtttt37bSy65JJVKpbT77rsPel8ZO5/12te+NrW2tqaISKVSqeZj7+bm5jbeb21tbamjoyOVy+V0+umnp02bNqV169alcrk87DalNOLH1jIja/WMNKNUKqVXvvKVKSJSZ2dnmjRpUoqIajt16tQe7bRp01JEpGOOOSZFRJoxY0aPtrOzc4fH9NfWIqtoGVOmTEkRfzzeGI1jTrddc3vxi1+cyuVyOu2006rt2972tuo2WSqV0mmnndZv2/uxRc/YmayISC972ctSqVRKb37zmx3PF/CWlWsARby+0td1jvFwDaAIGa5zuLm5ue14q+y3Ghoadur6xni/jpDlelJKae3atSki0ty5c1NE7HCdYzxdA8jz9RXXN7J/K5VKafHixemRRx4Z9rr0uFg8nzZtWvr5z3+eUkqpoaEhnXrqqWnatGnpqKOOSk1NTWnmzJmpVCqlww8/PJXL5TRp0qR+2z322COVSqU0b9681NDQUH3scDJqmZXXjIjnFhp6P1H7+n9fbWNjY4qIatZA95Wx81mV26RJk9Jee+2VGhsbU2dnZ7Utl8vVg6qGhoY0YcKEVFdXlxoaGlJDQ0P1QkFra2sqlUp9PkbGwBkjyaqvr091dXWpvr4+1dfXpwkTJqSGhobqdhwRaeLEidXHRzx3kDVx4sQUEam5ubnftlQqpY6OjlxkZKmexsbG6rZWKpXS3LlzU6lUSnvuuWdqbm5Os2fPTnvssUdqb28f8Lbnnnum2bNnp+bm5jRt2rQe7a7MyFo9tc5YuXJl2n///dPJJ5+c9t9///SKV7wife9736v+e6xPpvJ4gjiSx0b88SSnra2terJSaevq6nq0TU1NPfaNlW24vr6+2vZ+TH9tLbKKltF7XNrb26tjVxm3UqmUmpubU7lc7rHPq+zbKv+v3Le/VsbOZ0SM/cmu287fKtti5Xhk5cqVKeKPF+P6aivbau/teTxmZK2e7hn19fU95sq6urq0ZMmSFPHc+dp4ugZQhOsrEZHmzJkz4PY2Xq4BFCGjv+scs2fPTu3t7bv8/F3GwBm9r2/Mnz8/NTc3p+bm5tTQ0DCur0nkKaN7VuU4vr29vcf1jWXLlo3bawB5vr5Sub7R/bpG92sd4+kaQK0zslZPSimde+65KSLSoYcemiL+eH2j0o6nawB5vr5SGY/e1zcWLFhQ/f5YXgMY6+sJuzpj4sSJacqUKWnChAlpxowZ6eCDD06veMUr0pFHHpne+MY3Dntdelwsnre0tKRf/vKXKaWUIiJ98YtfTC0tLWn69Ompubm5+hce06dPrx5I99fefPPNKSLSP//zP6eIP/51yHAyapmV54zKhexLLrmkx4QzlFv3ySjijxdUZYw8Y6Csykll9/udccYZPca1paWl2lYeW9kxfPWrX00RkT70oQ/1+xgZA2eMNKty8tLS0lL968P/+I//SBGR3vCGN6SISOeff371JLSuri41NjZWd/z9te973/tyk5GVeipjVcl461vfmsrlcvrLv/zLVC6X07/+67+miEjf+9730oQJE1JbW1u/7Xe/+90UEdXH9G53VUbW6ql1RvcLAm7j99Z7WzzllFNSRKQVK1akiEhHHnlkiojqRfFZs2YNeV6pRVbRMionopW2r9vkyZOrJ0cRz51wXn755Ski0ute97oUEemyyy6r3re/VkZtMrof81fGsFQqVY9Vuv8l/kEHHZQiorr4t2jRon7bcrlcfW7I2Pmst73tbSkiqgsTEZHe9a53VRcBI/642LTvvvvuMLa929e//vUpIqrv7DGeM7JWT/eMUqlUXYytLGRMnz49NTQ0VI8t+8rJ6jWAIlxfmTFjRiqVStXzsb5u4+EawFjUk4WMM844I9XX16e2trYxOX+XMXBG9+sblVddVs7lxvM1iTxl9M6qLPD1vr4xXq8BjGXGaNfT/frGSPYlbtm6jadrAHm+vtLf9Y3u29hYXgOoZdZ4ybjppptSqVRKs2bNSt/85jfT7rvvXm2HqxzjwP777x/f/OY3IyKitbU1vvrVr8b+++8fzc3NMX/+/Kirq4u6urpobm6O6dOnR7lc7rddt25dRER85StfiYaGhupjh5NRy6y8ZkREtLe3R0TEnnvuGRERP/rRjyIiolQqRUREY2Njv+327dsjIqqfc/DUU09FRMRzfz8RMWfOHBnDzBgoKz33hzRRLpdj5syZERHxpS99KSIiLrjggoiIKJfL1barqytKpVK1ffzxxyMi4ne/+11ERGzcuHGHx8gYOGOkWXV1ddW2MrbPPPNMRET1829WrlwZ27dvj5RSbN++PbZv3z5oLUcffXRuMrJST319fY+M/fffP7q6uuKQQw6pjnfEH+fIgfS+b3/taGdkrZ5aZ6SU4rTTTouIiEMPPTQiIvbbb78ol8tRKpX6zd9tt90iImLGjBl9tnPnzh20xlpkZK2e0czYd999IyLiJS95SXVerNi8eXOP9mc/+1lEPPcZmBERDzzwQERE/Ou//mtEPDfGvR/TX1uLrKJlbN26NSKi2val8jnNXV1d0dzcHF1dXdV598QTT4yIiMMPP7x63/5aGTuf0dLS0uPYsa2tLbZt21b9HMXS/36WYqXda6+9IiJi4cKFERGxePHiftuurq646qqrZNQoqzIPPv3009U587jjjouIiCeeeKJH+8gjj0SpVIqtW7f2255xxhkREXHyySeP+4ys1dM9o1QqxcaNG6NUKkVbW1tERDQ3N8fcuXNj+/bt4+oaQBGur0Q8d+yRUqpun1OnTo2Intc5xsM1gLGoZywyGv738y0r52Jf+tKXYtu2bfHMM8+Myfm7jIEzul/fqGxTla+N52sSecronbV8+fKI6P/6xkCyeA1gLDNGu57u1zee//znR11dXZTL5X6vb2T9GkDRro30vs4xnq4B5Pn6Sn/XN1paWiIixvwaQC2zxkvGfvvtFy0tLfH444/HHnvsEb/5zW+q7bCN4IXgu9yXvvSlNGXKlPSJT3wirV69OpXL5XT88cenlpaW6l8lVt7WJ2Lwt23q/TkGlb+IHGpGLbPymhHxx78A7ujoSKVSKV111VUpItJ5552XyuVyOvPMM/ttv/71r6dSqZS+8IUv9Nk++uijMoaZMVDW3Llz06GHHpqmT5+e5s+fn1paWlK5XK6+DUZdXV2PdsKECalcLlefGy0tLT3u09zcvMNjZAycMdKsyl8JNzc3V9+ueL/99qu+VVZEpLPOOqvHeLa2tqb58+eniOi3Xb16dYqIXGRkpZ699947RUQ6++yzU8RzrxRraGhIixYtqo7t7Nmz06JFiwZ9C67FixdX34Kr8i4slXZXZmStnlpntLe3pzlz5qTJkyenOXPmpOnTp6e3ve1tqa2tLa1YsSItW7asuq11bytvJf6Od7yjz/aqq67q97G1zMhaPaOZcc0116SISF//+tfTnDlzUqn03NtCRuz4NoOVvxpeunRpj7byqs65c+cO6a0Ka5VVtIzef5ldOd6stG1tbWnixInp1a9+dSqXy+nUU09N5XI5fepTn0qlUil95CMfSaVSKd1yyy3V+/bXytj5jFe/+tVpypQp6YQTTkjl8h8/g7ty7F8ul6uvzjz99NOrb9fZ+62SB2pl7HxWRKQJEyZUt6HKOdrrXve6VCqVdng1xVDeVaVyvHLmmWf2eOx4zMhaPd0zGv/3I30qx/2V+bEyr0aMn2sARbi+EhHpec97Xor447F95fMwu1/nGA/XAMainl2dcdhhh6XZs2enpUuXptbW1up1jjlz5vR4e/Bdef4uY+CM7tc39t1331QqldKUKVNSqVQa19ck8pTRO6vy2cDdr29U2vF4DSDP11cq1ze6X9fYZ599+r2+kfVrAHm/NlK5rtG7rVznGE/XAPJ8faW/6xu77bZbiogxvwYw1tcTdnVGS0tLeuyxx6rXMdatW5emTZtWbYdrXCyep5TS//k//6fH54O5jb9bZRJ55JFHqic1/bUppUHvI6N2WT//+c/TnnvumSL++HZ1lQsIbuPzVrmAWl9fv8NYDnVsK58XkoeMrNRT+X5dt7fhdBsft4aGhtTc/Nxnuy1evDj91V/9VbrgggvSAQccsEP74IMPpoMOOiidf/75fbZr1qzp97G1zMhaPaOVsWjRovSSl7wkLVq0KL3mNa9JL33pS9OiRYvSS1/60rRgwYLqZ/dV2sr+rrLA0bt9yUtessNj+mtrkVW0jMofV/bVlkqltN9++6VFixalq6++Ok2bNi296EUv6rO96qqrqvftr5Wx8xlXX311OvbYY9PVV1+djjjiiLRkyZLqeFbG7KCDDkp1dXXpyCOPTAcffHB1HIfTyti5rMp+qvt+q66uLk2ZMqW6KBHxx8/k634M01/be1F4PGdkrZ7uGU1NTdXPCN4VxzNutb/1dZ1jPFwDKEKG6xz5ubW2to77axJ5yqjcKn8AFhGu14+jW/cxK5X6v76R5WsARbg20v26Ru92wYIF4+oaQJ6vr/R3faOSMdbXAMb6esKuzjj22GNTSqnHdYzu7XCVUvrf9zYaB7Zv3x533XVX3H///bFt27Z44oknoqmpKX7961/Hli1bhpVVLpdj/vz58eyzz444o5ZZecvYvHlz7LbbbvHwww/H0qVL43e/+1288pWvjLvvvjsOP/zw+M53vjNgW19fH7fffvuQ7itj57Mqb2H22GOPxdSpU6vtTTfdFI2NjfH444/HlClTdmifffbZ2Lx5c7S0tMTmzZvj+c9/ftx+++0DPkZGbbMiIr73ve/Fk08+Gc8++2w0NDTEnDlzYu7cubHffvvFz3/+89iwYUNs27Yt6uvrh9VOnTo1NxlZqWfq1KmxYMGC+O1vfxvr16+PDRs2xKZNm6Krqyv+8Ic/xBNPPFF9O62htO3t7TFhwoTqW+SNVUbW6ql1xqRJk2L69OnR2dkZK1eujL333ntY+0VG1wMPPBA/+9nPYu+99+6znTJlSnzuc5+Ll7zkJfG5z30u3v72t8f1118fs2fPjkceeWSHdunSpTs8pr+2FllFy9h///3jlltuiRNPPLHPdsmSJdV930Dt0qVLY+3atUO6r4zaZtx0003x3e9+N/bdd9945JFH4sADD4wf/ehH8cEPfjBuuumm+Na3vlX92nBbGbXL+uAHPxhz586NiOeOFZuammLLli3R1NQUBx544A5fG26bp4ws1FNfXx933313rF+/Prq6uuK///u/o76+PmbOnDng8UqpVIr58+fHtm3borGxMR555JF45plnhnXMk5WMrNXTV8Z9990X8+fPj4cffjiOOOKIeOqpp/q8zjEergEUIWOw6xxjcf4uY+CMyj6rcn1j0qRJ8YIXvCAeffTRcX9NIk8Z3bOOPfbYKJfL8d3vfjfuvvvueOihh8b8/H28Z4x2PRER8+fPj/3228/1jQwb7DrH/vvvP26uAeT5+srb3/72EV3fyMo1gKzVM9oZS5cuHdZ2OK4WzwEAAAAAAABgNJTHuoChSinFrbfeGu95z3vi9a9/fZx22mlx9NFHx6GHHhorVqyIxYsXD/m21157xfLly+PQQw+NVatWjSijllkyBs5auXLlTtcjI5v1yMh2PXnKyEo9e+21V6xYsSL+5E/+JNasWRNf//rXo/I3bBs3boxPfvKTPf490jYrGVmrR0a268lTRtbqyVNG1uqRke168pSRtXrylJG1emRku548ZWStnjxlZK2ePGVkrR4ZG+Paa6/doY2I2LZtWzz44IODtl1dXfE///M/O7RFzchaPXnKyFo9MrJdT54yslbPaGd0dXVV79O9HbZB39g9Ax5++OF0wAEHpLq6uh6fszfcz2Jxc3Nzc3Mb61vls8BaWlpSXV1dOuigg9LDDz+c1q1bl8rlckopVf890jYrGVmrR0a268lTRtbqyVNG1uqRke168pSRtXrylJG1emRku548ZWStnjxlZK2ePGVkrZ4iZ5RKpXTCCSekiOc+/7x729TUlMrlco9rIL3burq6FBFp8eLFMjJYT54yslaPjGzXk6eMrNWzKzJmzJiR3va2t6VSqZTWr1+fyuVytR2u5z4AKOPOO++8mDJlSjz00EPx+te/Pjo7O6ufr7J9+/a4++67o76+Pvbaa6+49957B8zaZ5994uc//3ls27at+nkflXaoGbXMkpHtevKUkbV6ZGS7njxlZKWeRYsWxYQJE+LZZ5+NUqnUoz377LPjL/7iL6KrqyvWrl0b69ati66urvj+97/fZ/vjH/94wHZXZWStHhnZridPGVmrJ08ZWatHRrbryVNG1urJU0bW6pGR7XrylJG1evKUkbV68pSRtXpk9J+VUop77rknIiJaW1tj69at1XfWSylFQ0NDbNmypd+2o6MjHn/88fjVr34VERETJ06M3/3ud9VrKEXLyFo9ecrIWj0ysl1PnjKyVs+uyJg5c2Z8/vOfj5TSDvulYRv2cvsYaGtrS+vWrevx7+7tDTfckCIirVu3LrW0tKTm5uZ+2x/+8IcpIqqP6d0OJaOWWTKyXU+eMrJWj4xs15OnjKzUU3m3lMpfyrm5ubm5ubm5ubm5ubm5ubnl7bb33nunpqamFBH9tocffniKiLR06dIUEWnZsmUpItKiRYsKmZG1evKUkbV6ZGS7njxlZK2eXZFx8MEHV+9z9NFH93gF+nCNi888b2lpiccff7zHv7u3Dz/8cJRKpXj88cejsbFxwNvGjRujVCpVH9O7HUpGLbNkZLuePGVkrR4Z2a4nTxlZqae1tTVaW1vj7//+7yMi4tRTT42IiJUrV0ZExP777x8REYcddljU1dVFRPTbHnPMMT0e07vdVRlZq0dGtuvJU0bW6slTRtbqkZHtevKUkbV68pSRtXpkZLuePGVkrZ48ZWStnjxlZK0eGQNnnXLKKRER8ed//ucREfHud787IiLa29vj2WefjYjot928eXNERPXVgNu2bYuIiH/8x38sZEbW6slTRtbqkZHtevKUkbV6dkVGc3Nz9T5PPPFEpJTi6aefjhEZ4YvBd6k3velNad68eekLX/hCet3rXpfmzZuXTjrppDR79uzqZ6HPmzcvTZkyJTU1NQ14mzJlSpo7d26qq6tL06ZN69EONaOWWTKyXU+eMrJWj4xs15OnjKzUU19fn/bcc880d+7cNGXKlNTR0ZGmTJmSJk2alObMmZPe+ta3pohIl19+eVqxYkWKiH7bdevWpYioPqZ3u6syslaPjGzXk6eMrNWTp4ys1SMj2/XkKSNr9eQpI2v1yMh2PXnKyFo9ecrIWj15yshaPTIGzvrgBz/YZ7v33nvv8Dm0vdvKqwZ32223Hu3ChQsLmZG1evKUkbV6ZGS7njxlZK2e0c4olUpp5cqV1ft0f3V6bj/z/AMf+EBs27YtXvayl8Wzzz4b5XI5HnrooYiIeOSRRyIiqv8fzJYtW6qvYq+8F36lHWpGLbNkZLuePGVkrR4Z2a4nTxlZqueXv/xlj//X1dXFoYceGi972cvi8ccfj9NOOy2am5vjpS99aUybNi2OP/74PtvOzs447bTTYvr06X22uyoja/XIyHY9ecrIWj15yshaPTKyXU+eMrJWT54yslaPjGzXk6eMrNWTp4ys1ZOnjKzVI6P/rIMPPji+9rWv9dnOnj07Nm7cGI8++mhMnjy5z7atrS0iIp588ske7aZNmyIiYu+99y5URtbqyVNG1uqRke168pSRtXpGO6NUKsXXvva1OOGEE6JUKkVbW1uUSqVobm6OkSillNKIHjkGnnjiifjBD34Qjz76aDz99NPx+9//Ppqbm+M3v/lNbNmyZVhZTU1NMWvWrHjmmWdGnFHLLBnZridPGVmrR0a268lTRlbqaWpqit133z0WLlwYy5cvj4kTJ47k1wAAAAAYExs3boxHHnkkZs+e3Wc7ceLE+MY3vhHHHXdcn+2f/umfxm233RYzZ86MRx99dId24cKFhcrIWj15yshaPTKyXU+eMrJWz2hnPP3007Fq1ar4wx/+EHfddVcsX768R7tq1aph7efG1eI5AAAAAAAAAIyGcfG27RERTz31VFx//fVx5513xsMPPxzr16+Pp59+Op555pno6uqKZ555Job6dwCVl+qXy+VobGyMrVu3Djujllkysl1PnjKyVo+MbNeTp4ys1ZOnjKzVIyPb9eQpI2v15Ckja/XIyHY9ecrIWj15yshaPTKyXU+eMrJWT54yslZPnjKyVo+MbNeTp4ys1ZOnjKzVIyPb9eQpI2v1jHZGRERra2tMmTIlDjjggFi1alWcffbZ1bd7H45x8crze++9N0444YR4+umn48ADD4z//M//jGeffTa2b98eXV1dY10eAAAAAAAAALtYqVSKiIhyuRzlcjnq6uqisbEx2tvb45ZbboklS5YML288LJ4fc8wx0dnZGdddd108//nPj87OzvjNb34Ts2bNil//+tfxwAMPxKZNm+L5z39+fOtb3xo062tf+1p0dHTEpk2bdmiHklHLLBnZridPGVmrR0a268lTRtbqyVNG1uqRke168pSRtXrylJG1emRku548ZWStnjxlZK0eGdmuJ08ZWasnTxlZqydPGVmrR0a268lTRtbqyVNG1uqRke168pSRtXpGO2PBggVx6623xqte9ar49a9/HXPmzKm2v/nNb4bcX1VpHGhpaUn33HNPj393b//v//2/KSLSPffck5qbm1NTU1O/7Y9//OMUEdXH9G6HklHLLBnZridPGVmrR0a268lTRtbqyVNG1uqRke168pSRtXrylJG1emRku548ZWStnjxlZK0eGdmuJ08ZWasnTxlZqydPGVmrR0a268lTRtbqyVNG1uqRke168pSRtXpGO6OlpSWllNKPf/zj1NLSskM7XOPiM88nT54cv/jFL2LJkiXVf3dvv/e970W5XI5f/OIX0draGimlKJVKfba//OUvo1wuVx/Tux1KRi2zZGS7njxlZK0eGdmuJ08ZWasnTxlZq0dGtuvJU0bW6slTRtbqkZHtevKUkbV68pSRtXpkZLuePGVkrZ48ZWStnjxlZK0eGdmuJ08ZWasnTxlZq0dGtuvJU0bW6hntjMmTJ0dExC9/+cuYPHnyDu2wpXHg3e9+d+ro6Ejvf//707nnnpsmTpyYjjrqqNTa2poWLlyYIiLNmjUrNTY2pnK5nOrq6vptGxsb06xZs1JEpEmTJvVoh5pRyywZ2a4nTxlZq0dGtuvJU0bW6slTRtbqkZHtevKUkbV68pSRtXpkZLuePGVkrZ48ZWStHhnZridPGVmrJ08ZWasnTxlZq0dGtuvJU0bW6slTRtbqkZHtevKUkbV6Rjtj+fLl6S/+4i9SW1tbWrVqVWpvb08nnnhimjx5cnrPe94z7HXpcfGZ5xERl19+efzjP/5jrF+/PiIixknZAAAAAAAAAOwCpVIpOjs7Y/Xq1XHBBRcM//HjZfG84v77768uoD/77LPR0NAQjzzyyIiyZs+evdMZtcySke168pSRtXpkZLuePGVkrZ48ZWStHhnZridPGVmrJ08ZWatHRrbryVNG1urJU0bW6pGR7XrylJG1evKUkbV68pSRtXpkZLuePGVkrZ48ZWStHhnZridPGVmrZ7QzZs+eHZ2dnbFw4cIRZUeMw8VzAAAAAAAAAKi1+rEuYKg2b94cd911V0yZMiUWLlwYd911V7S2tsbTTz8ddXV18eUvfznOPPPM2LhxY3znO9+Jww8/vN/2+9//frz+9a+PD3zgA3HKKafEl7/85Wo71IxaZsnIdj15yshaPTKyXU+eMrJWT54yslaPjGzXk6eMrNWTp4ys1SMj2/XkKSNr9eQpI2v1yMh2PXnKyFo9ecrIWj15yshaPTKyXU+eMrJWT54yslaPjGzXk6eMrNUz2hnnnHNO7L777vH5z38+zjrrrB7tK17xiuEtSg/7U9LHwH333Zd22223VCqVUqlUSk1NTSkidupWi4xaZsnIdj15yshaPTKyXU+eMrJWT54yslaPjGzXk6eMrNWTp4ys1SMj2/XkKSNr9eQpI2v1yMh2PXnKyFo9ecrIWj15yshaPTKyXU+eMrJWT54yslaPjGzXk6eMrNUzmhnlcjmtXLkylUqltH79+lQul6vtcJVjHHjnO98Z++23X2zYsCGOP/74mDRpUrS0tMTKlStjxowZ0dTUFBERzc3NMXny5IiIfttDDz00IiLa2toiImLFihUREcPKqGWWjGzXk6eMrNUjI9v15Ckja/XkKSNr9cjIdj15yshaPXnKyFo9MrJdT54yslZPnjKyVo+MbNeTp4ys1ZOnjKzVk6eMrNUjI9v15Ckja/XkKSNr9cjIdj15yshaPbsiY/bs2VFfXx8ppXj44Ydjp9T+deK1N2PGjHT33Xf3+HdLS0vq7OxMU6dOTaeffnqKiHTKKaekcrlc/QuDvto5c+akiEgzZszo0Q4no5ZZMrJdT54yslaPjGzXk6eMrNWTp4ys1SMj2/XkKSNr9eQpI2v1yMh2PXnKyFo9ecrIWj0ysl1PnjKyVk+eMrJWT54yslaPjGzXk6eMrNWTp4ys1SMj2/XkKSNr9eyKjD/7sz+r3mfOnDk9XoE+XOPileebN2+O+vr6Hv+ur6+PY489Nh5//PF40YteFBERP/jBD6Jcfu5X6q895JBDIiJi//3379EOJ6OWWTKyXU+eMrJWj4xs15OnjKzVk6eMrNUjI9v15Ckja/XkKSNr9cjIdj15yshaPXnKyFo9MrJdT54yslZPnjKyVk+eMrJWj4xs15OnjKzVk6eMrNUjI9v15Ckja/Xsiozbbrutep9DDjkkUkrx85//PEakxi8SHxXPe97z0ic/+cke/660M2bMSK2trSki0vHHH5/q6upSRPTbTpo0KUVE9TG926Fk1DJLRrbryVNG1uqRke168pSRtXrylJG1emRku548ZWStnjxlZK0eGdmuJ08ZWasnTxlZq0dGtuvJU0bW6slTRtbqyVNG1uqRke168pSRtXrylJG1emRku548ZWStntHOKJfL6Y1vfGP1Pt3bcl5fef7CF74wPvvZz/b4d6VdvXp1TJs2LSIiGhoaqu9x31979tlnR0RUH9O7HUpGLbNkZLuePGVkrR4Z2a4nTxlZqydPGVmrR0a268lTRtbqyVNG1uqRke168pSRtXrylJG1emRku548ZWStnjxlZK2ePGVkrR4Z2a4nTxlZqydPGVmrR0a268lTRtbqGe2MlFJcffXVcfbZZ0epVOrRppRiuEppJI8CAAAAAAAAgBwZF688BwAAAAAAAIDRZPEcAAAAAAAAgMKzeA4AAAAAAABA4Vk8BwAAgIK49tprY9KkSWNdBgAAAGSSxXMAAAAAAAAACs/iOQAAAAAAAACFZ/EcAAAAxsi///u/x6RJk6KrqysiItatWxelUine8Y53VO9z7rnnxtlnnx0REXfeeWccddRR0dLSEvPmzYu3vOUt8dRTT1Xvu3Xr1rjgggtizpw50dbWFoccckjcdttt/f78xx57LA4++OD4kz/5k3jmmWdG55cEAACAccLiOQAAAIyRo446Kp588sn40Y9+FBERt99+e0ybNi1uv/326n1uu+22WLVqVfz4xz+O5z//+XHmmWfG3XffHZ/73OfijjvuiDe96U3V+7761a+O73znO3HDDTfE3XffHS9+8YvjpJNOil/84hc7/OyHH344jjzyyNh7773jpptuiubm5tH/hQEAACDDSimlNNZFAAAAQFEtX748zjnnnHj7298eL3zhC+N5z3tevOc974nf/e538dRTT8WsWbPipz/9aVx66aXR0tIS11xzTfWxd9xxR6xatSqeeuqp+PWvfx2LFi2Khx9+OGbPnl29z/HHHx8HH3xwXHrppXHttdfG6tWr4/vf/36ccMIJcfrpp8c//uM/RqlUGotfHQAAADKlfqwLAAAAgCI7+uij47bbbou3ve1t8R//8R/xvve9L2688ca444474ve//33MnDkz9t5777jrrrvil7/8ZXzmM5+pPjalFF1dXXH//ffHT37yk0gpxeLFi3vkb9myJaZOnVr9/+bNm+OII46Is88+O/7xH/9xl/2eAAAAkHUWzwEAAGAMHX300fGxj30s/uu//ivK5XIsWbIkVq1aFbfffnts3LgxVq1aFRERXV1dce6558Zb3vKWHTLmz58fd999d9TV1cVdd90VdXV1Pb4/YcKE6r+bmpri+OOPjy9/+cvxjne8I+bOnTu6vyAAAACMExbPAQAAYAxVPvf8qquuilWrVkWpVIpVq1bFZZddFhs3boy3vvWtERFx0EEHxT333BN77rlnnzkHHnhgbN++PTZs2BBHHnlkvz+vXC7Hpz71qTjnnHPi2GOPjdtuu63H27wDAABAUZXHugAAAAAoso6OjjjggAPi05/+dBx99NER8dyC+g9/+MP4+c9/Xv3aO9/5zvjud78bb3zjG2PdunXxi1/8Iv7t3/4t3vzmN0dExOLFi+NlL3tZvOIVr4ibbrop7r///li7dm1cfvnl8ZWvfKXHz6yrq4vPfOYzsWzZsjj22GNj/fr1u/JXBgAAgEyyeA4AAABj7Jhjjont27dXF8onT54cS5YsienTp8c+++wTERH7779/3H777fGLX/wijjzyyDjwwAPjb//2b2PWrFnVnE984hPxile8It7+9rfHXnvtFX/yJ38S//mf/xnz5s3b4WfW19fHZz/72dh3333j2GOPjQ0bNuyS3xUAAACyqpRSSmNdBAAAAAAAAACMJa88BwAAAAAAAKDwLJ4DAAAAAAAAUHgWzwEAAAAAAAAoPIvnAAAAAAAAABSexXMAAAAAAAAACs/iOQAAAAAAAACFZ/EcAAAAAAAA/n97diAAAAAAIMjfepBLI2BPngMAAAAAAACwJ88BAAAAAAAA2JPnAAAAAAAAAOzJcwAAAAAAAAD25DkAAAAAAAAAewEMRlRPBhVpngAAAABJRU5ErkJggg==",
      "text/plain": [
       "<Figure size 2500x500 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df.groupby('week')['track'].nunique().plot.bar(figsize=(25,5))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "54d5126f",
   "metadata": {},
   "source": [
    "## Pozoruhodné tracky"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "14ec18b6",
   "metadata": {},
   "source": [
    "### Ve kterém týdnu (ne od začátku vysílání, ale od prvního průniku do top 100!) se píseň stala #1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "ef569b2d",
   "metadata": {},
   "outputs": [],
   "source": [
    "nepocitat = df[df['week'] == '2006-01']['track'].to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "d5213635",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "interpret_hlavni    track                \n",
       "Chinaski            Láska a data             3\n",
       "Miley Cyrus         Flowers                  3\n",
       "Adele               Hello                    4\n",
       "Chinaski            Měl bych si boty zout    4\n",
       "Support Lesbiens    English Stereo           4\n",
       "George Ezra         Shotgun                  5\n",
       "Mirai               I přes to všechno        5\n",
       "Adele               Skyfall                  6\n",
       "Don Omar            Danza Kuduro             6\n",
       "Ed Sheeran          Bad Habits               6\n",
       "                    Shape of You             6\n",
       "Gabry Ponte, Lum!X  Thunder                  6\n",
       "Lewis Capaldi       Before You Go            6\n",
       "Psy                 Gangnam Style            6\n",
       "Václav Neckář       Půlnoční                 6\n",
       "Adele               Easy On Me               7\n",
       "Alec Benjamin       Let Me Down SLowly       7\n",
       "Avicii              Wake Me Up               7\n",
       "Carly Rae Jepsen    Call Me Maybe            7\n",
       "Coldplay            Higher Power             7\n",
       "Name: tyden_pisne, dtype: int32"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[(~df['track'].isin(nepocitat)) & (df['pozice'] == 1)].groupby(['interpret_hlavni','track'])['tyden_pisne'].min().nsmallest(20)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d5320f19",
   "metadata": {},
   "source": [
    "### Těmto to naopak trvalo:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "e7c5b103",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "interpret_hlavni  track                \n",
       "Ewa Farna         Vánoce na míru           256\n",
       "Chinaski          Slovenský klín            36\n",
       "Avicii            Without You               24\n",
       "Morandi           Save Me                   24\n",
       "September         Cry For You               23\n",
       "Chinaski          Hlavolam                  22\n",
       "Lenny Kravitz     I´ll Be Waiting           22\n",
       "Coldplay          Paradise                  21\n",
       "Klingande         Jubel                     21\n",
       "Pussycat Dolls    Hush Hush                 21\n",
       "Shaun Baker       Hey Hi Hello              21\n",
       "Divokej Bill      Čmelák                    20\n",
       "Flipsyde          Happy Birthday            20\n",
       "Adele             Set Fire To The Rain      19\n",
       "Alan Walker       Alone                     19\n",
       "B.O.B.            Airplanes                 19\n",
       "Black Eyed Peas   Just Can´t Get Enough     19\n",
       "Charli Xcx        Boom Clap                 19\n",
       "Enrique Iglesias  Do You Know               19\n",
       "Milky Chance      Stolen Dance              19\n",
       "Name: tyden_pisne, dtype: int32"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['pozice'] == 1].groupby(['interpret_hlavni','track'])['tyden_pisne'].min().nlargest(20)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b82fcc72",
   "metadata": {},
   "source": [
    "### Nejpozdější top 1 (tentokrát i ty co byly top 1 dříve)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "54fe98a2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "interpret_hlavni   track                     \n",
       "Ewa Farna          Vánoce na míru                257\n",
       "Chinaski           Slovenský klín                 43\n",
       "Mirai              Když nemůžeš, tak přidej       41\n",
       "Ed Sheeran         Bad Habits                     33\n",
       "Mirai              Vedle tebe usínám              31\n",
       "Kryštof            Zůstaň tu se mnou (Za sny)     29\n",
       "Alesha Dixon       Boy Does Nothing               27\n",
       "Coldplay           Viva La Vida                   27\n",
       "Miley Cyrus        Flowers                        27\n",
       "Nelly Furtado      Say It Right                   26\n",
       "Edward Maya        Stereo Love                    25\n",
       "Katy Perry         Hot ´N´ Cold                   25\n",
       "Michael Schulte    Waterfall                      25\n",
       "The Weeknd         Blinding Lights                25\n",
       "Avicii             Without You                    24\n",
       "Kryštof            Cesta                          24\n",
       "Morandi            Save Me                        24\n",
       "Peter Bič Project  Hey Now                        24\n",
       "Lenny Kravitz      I´ll Be Waiting                23\n",
       "Mandrage           Šrouby a matice                23\n",
       "Name: tyden_pisne, dtype: int32"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['pozice'] == 1].groupby(['interpret_hlavni','track'])['tyden_pisne'].max().nlargest(20)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9332ca44",
   "metadata": {},
   "source": [
    "### Držáci top 10"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f5d4027d",
   "metadata": {},
   "source": [
    "#### Nejdéle od prvního výskytu v žebříčku (vč. pauz, kdy vypadly z top 100!):"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "d22dd12e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "interpret_hlavni  track                   \n",
       "Ewa Farna         Vánoce na míru              258\n",
       "Václav Neckář     Půlnoční                    111\n",
       "Kryštof           Vánoční                     109\n",
       "Mirai             OTCHI                        88\n",
       "Michal Hrůza      Pro Emu                      82\n",
       "Jelen             Ještě jednu noc              76\n",
       "Slza              Bouře                        68\n",
       "O5                BRA3                         65\n",
       "Mirai             Když nemůžeš, tak přidej     64\n",
       "Kryštof           Co bude pak                  63\n",
       "Mirai             I přes to všechno            62\n",
       "Miley Cyrus       Angels Like You              60\n",
       "Marek Ztracený    Naše cesty                   57\n",
       "Mirai             Vedle tebe usínám            56\n",
       "Lucie Bílá        Dobrý kafe                   54\n",
       "Sunrise Avenue    Hollywood Hills              53\n",
       "Alvaro Soler      Sofia                        52\n",
       "Chinaski          Každý ráno                   52\n",
       "                  Slovenský klín               52\n",
       "Harry Styles      As it Was                    52\n",
       "Name: tyden_pisne, dtype: int32"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['pozice'] <= 10].groupby(['interpret_hlavni','track'])['tyden_pisne'].max().nlargest(20)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8b3afa4d",
   "metadata": {},
   "source": [
    "#### Nejvíce jednotlivých týdnů:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "be24f5ca",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "interpret_hlavni  track                   \n",
       "Mirai             Vedle tebe usínám           46\n",
       "Jelen             Ještě jednu noc             44\n",
       "Miley Cyrus       Flowers                     41\n",
       "Ed Sheeran        Bad Habits                  40\n",
       "Xindl X           V blbým věku                40\n",
       "Chinaski          Měl bych si boty zout       39\n",
       "Mirai             Když nemůžeš, tak přidej    39\n",
       "                  I přes to všechno           37\n",
       "Xindl X           Cudzinka v tvojej zemi      37\n",
       "Kryštof           Co bude pak                 36\n",
       "Chinaski          Slovenský klín              33\n",
       "Shawn Mendes      Senorita                    33\n",
       "Ava Max           Kings & Queens              32\n",
       "O5                BRA3                        32\n",
       "Ava Max           Sweet but Psycho            31\n",
       "Chinaski          Potkal jsem tě po letech    31\n",
       "Kryštof           Ty a já                     31\n",
       "Alesha Dixon      Boy Does Nothing            30\n",
       "Lewis Capaldi     Before You Go               30\n",
       "Harry Styles      As it Was                   29\n",
       "Name: tyden_pisne, dtype: int64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['pozice'] <= 10].groupby(['interpret_hlavni','track'])['tyden_pisne'].nunique().nlargest(20)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "995d2e16",
   "metadata": {},
   "source": [
    "### Držáci kdekoliv"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9970779d",
   "metadata": {},
   "source": [
    "#### Nejdéle od prvního výskytu v žebříčku (vč. pauz, kdy vypadly úplně):"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "364ae977",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "interpret_hlavni  track                          \n",
       "Wham!             Last Christmas                     764\n",
       "Chinaski          Hvězdy nad hlavou                  718\n",
       "Divokej Bill      Pocit                              685\n",
       "Dan Bárta         On My Head                         618\n",
       "Maroon 5          This Love                          581\n",
       "Václav Neckář     Půlnoční                           569\n",
       "Linkin Park       Breaking The Habit                 567\n",
       "Billy Mack        Christmas Is All Around            564\n",
       "Daniel Landa      Touha                              564\n",
       "Lucie             Medvídek                           563\n",
       "Janek Ledecký     Sliby se maj plnit o Vánocích      562\n",
       "Mariah Carey      All I Want For Christmas Is You    562\n",
       "David Guetta      Love Is Gone                       531\n",
       "John Lennon       Happy Xmas (War Is Over)           511\n",
       "Queen             Thank God It´s Christmas           511\n",
       "Mandrage          Hledá se žena                      507\n",
       "Coldplay          Viva La Vida                       491\n",
       "Evanescence       Bring Me To Life                   491\n",
       "Dan Bárta         Na nebi svítí                      461\n",
       "Limp Bizkit       Behind Blue Eyes                   460\n",
       "Name: tyden_pisne, dtype: int32"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby(['interpret_hlavni','track'])['tyden_pisne'].max().nlargest(20)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f42216d9",
   "metadata": {},
   "source": [
    "#### Nejvíce jednotlivých týdnů:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "fa22a450",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "interpret_hlavni  track                              \n",
       "Karel Gott        Srdce nehasnou                         180\n",
       "Mirai             Když nemůžeš, tak přidej               176\n",
       "Mandrage          Motýli                                 169\n",
       "Michal Hrůza      Pro Emu                                165\n",
       "Marek Ztracený    Naše cesty                             150\n",
       "Mirai             Chci tančit                            150\n",
       "                  OTCHI                                  140\n",
       "Slza              Na srdci (feat. Celeste Buckingham)    139\n",
       "Chinaski          Láska a data                           138\n",
       "Marek Ztracený    Tak se nezlob (Podpantoflák)           134\n",
       "O5                BRA3                                   134\n",
       "Kelly Clarkson    Stronger (What Doesn´t Kill You)       129\n",
       "The Weeknd        Blinding Lights                        128\n",
       "Kryštof           Hned teď (pojď být světlometem)        125\n",
       "Shawn Mendes      Senorita                               122\n",
       "Jelen             Ještě jednu noc                        121\n",
       "Lewis Capaldi     Before You Go                          121\n",
       "Alvaro Soler      La Cintura                             120\n",
       "Ph Electro        Stereo Mexico                          120\n",
       "Train             Drive By                               120\n",
       "Name: tyden_pisne, dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['pozice'] <= 100].groupby(['interpret_hlavni','track'])['tyden_pisne'].nunique().nlargest(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "13230ee3",
   "metadata": {},
   "outputs": [],
   "source": [
    "top10 = pd.DataFrame(df[df['pozice'] <= 100].groupby(['interpret_hlavni','track'])['tyden_pisne'].nunique().nlargest(10)).reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "bd9bde2f",
   "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>interpret_hlavni</th>\n",
       "      <th>track</th>\n",
       "      <th>tyden_pisne</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Karel Gott</td>\n",
       "      <td>Srdce nehasnou</td>\n",
       "      <td>180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mirai</td>\n",
       "      <td>Když nemůžeš, tak přidej</td>\n",
       "      <td>176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mandrage</td>\n",
       "      <td>Motýli</td>\n",
       "      <td>169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Michal Hrůza</td>\n",
       "      <td>Pro Emu</td>\n",
       "      <td>165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Marek Ztracený</td>\n",
       "      <td>Naše cesty</td>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Mirai</td>\n",
       "      <td>Chci tančit</td>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Mirai</td>\n",
       "      <td>OTCHI</td>\n",
       "      <td>140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Slza</td>\n",
       "      <td>Na srdci (feat. Celeste Buckingham)</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Chinaski</td>\n",
       "      <td>Láska a data</td>\n",
       "      <td>138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Marek Ztracený</td>\n",
       "      <td>Tak se nezlob (Podpantoflák)</td>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  interpret_hlavni                                track  tyden_pisne\n",
       "0       Karel Gott                       Srdce nehasnou          180\n",
       "1            Mirai             Když nemůžeš, tak přidej          176\n",
       "2         Mandrage                               Motýli          169\n",
       "3     Michal Hrůza                              Pro Emu          165\n",
       "4   Marek Ztracený                           Naše cesty          150\n",
       "5            Mirai                          Chci tančit          150\n",
       "6            Mirai                                OTCHI          140\n",
       "7             Slza  Na srdci (feat. Celeste Buckingham)          139\n",
       "8         Chinaski                         Láska a data          138\n",
       "9   Marek Ztracený         Tak se nezlob (Podpantoflák)          134"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top10"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "d6384e36",
   "metadata": {},
   "outputs": [],
   "source": [
    "top10['Track'] = top10.apply(lambda x: f\"\"\"{x['interpret_hlavni']}: {x['track'].split(\"(\")[0]}\"\"\", axis=1)\n",
    "top10['Týdnů v TOP 100'] = top10['tyden_pisne']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "700cfb67",
   "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>interpret_hlavni</th>\n",
       "      <th>track</th>\n",
       "      <th>tyden_pisne</th>\n",
       "      <th>Track</th>\n",
       "      <th>Týdnů v top 100</th>\n",
       "      <th>Týdnů v TOP 100</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Karel Gott</td>\n",
       "      <td>Srdce nehasnou</td>\n",
       "      <td>180</td>\n",
       "      <td>Karel Gott: Srdce nehasnou</td>\n",
       "      <td>180</td>\n",
       "      <td>180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mirai</td>\n",
       "      <td>Když nemůžeš, tak přidej</td>\n",
       "      <td>176</td>\n",
       "      <td>Mirai: Když nemůžeš, tak přidej</td>\n",
       "      <td>176</td>\n",
       "      <td>176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mandrage</td>\n",
       "      <td>Motýli</td>\n",
       "      <td>169</td>\n",
       "      <td>Mandrage: Motýli</td>\n",
       "      <td>169</td>\n",
       "      <td>169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Michal Hrůza</td>\n",
       "      <td>Pro Emu</td>\n",
       "      <td>165</td>\n",
       "      <td>Michal Hrůza: Pro Emu</td>\n",
       "      <td>165</td>\n",
       "      <td>165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Marek Ztracený</td>\n",
       "      <td>Naše cesty</td>\n",
       "      <td>150</td>\n",
       "      <td>Marek Ztracený: Naše cesty</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Mirai</td>\n",
       "      <td>Chci tančit</td>\n",
       "      <td>150</td>\n",
       "      <td>Mirai: Chci tančit</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Mirai</td>\n",
       "      <td>OTCHI</td>\n",
       "      <td>140</td>\n",
       "      <td>Mirai: OTCHI</td>\n",
       "      <td>140</td>\n",
       "      <td>140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Slza</td>\n",
       "      <td>Na srdci (feat. Celeste Buckingham)</td>\n",
       "      <td>139</td>\n",
       "      <td>Slza: Na srdci</td>\n",
       "      <td>139</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Chinaski</td>\n",
       "      <td>Láska a data</td>\n",
       "      <td>138</td>\n",
       "      <td>Chinaski: Láska a data</td>\n",
       "      <td>138</td>\n",
       "      <td>138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Marek Ztracený</td>\n",
       "      <td>Tak se nezlob (Podpantoflák)</td>\n",
       "      <td>134</td>\n",
       "      <td>Marek Ztracený: Tak se nezlob</td>\n",
       "      <td>134</td>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  interpret_hlavni                                track  tyden_pisne  \\\n",
       "0       Karel Gott                       Srdce nehasnou          180   \n",
       "1            Mirai             Když nemůžeš, tak přidej          176   \n",
       "2         Mandrage                               Motýli          169   \n",
       "3     Michal Hrůza                              Pro Emu          165   \n",
       "4   Marek Ztracený                           Naše cesty          150   \n",
       "5            Mirai                          Chci tančit          150   \n",
       "6            Mirai                                OTCHI          140   \n",
       "7             Slza  Na srdci (feat. Celeste Buckingham)          139   \n",
       "8         Chinaski                         Láska a data          138   \n",
       "9   Marek Ztracený         Tak se nezlob (Podpantoflák)          134   \n",
       "\n",
       "                             Track  Týdnů v top 100  Týdnů v TOP 100  \n",
       "0       Karel Gott: Srdce nehasnou              180              180  \n",
       "1  Mirai: Když nemůžeš, tak přidej              176              176  \n",
       "2                 Mandrage: Motýli              169              169  \n",
       "3            Michal Hrůza: Pro Emu              165              165  \n",
       "4       Marek Ztracený: Naše cesty              150              150  \n",
       "5               Mirai: Chci tančit              150              150  \n",
       "6                     Mirai: OTCHI              140              140  \n",
       "7                  Slza: Na srdci               139              139  \n",
       "8           Chinaski: Láska a data              138              138  \n",
       "9   Marek Ztracený: Tak se nezlob               134              134  "
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top10"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "85f7b2cf",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'<table class=\"dataframe table table--responsive table--w100p table--striped-red table--plain\"><caption>Držáci hitparády</caption><thead><tr style=\"text-align: right;\"><th class=\"text-nowrap\"></th><th class=\"text-nowrap\">Track</th><th class=\"text-nowrap\">Týdnů v TOP 100</th></tr></thead><tbody class=\"text-sm\"><tr><td>1.</td><td>Karel Gott: Srdce nehasnou</td><td>180</td></tr><tr><td>2.</td><td>Mirai: Když nemůžeš, tak přidej</td><td>176</td></tr><tr><td>3.</td><td>Mandrage: Motýli</td><td>169</td></tr><tr><td>4.</td><td>Michal Hrůza: Pro Emu</td><td>165</td></tr><tr><td>5.</td><td>Marek Ztracený: Naše cesty</td><td>150</td></tr><tr><td>6.</td><td>Mirai: Chci tančit</td><td>150</td></tr><tr><td>7.</td><td>Mirai: OTCHI</td><td>140</td></tr><tr><td>8.</td><td>Slza: Na srdci</td><td>139</td></tr><tr><td>9.</td><td>Chinaski: Láska a data</td><td>138</td></tr><tr><td>10.</td><td>Marek Ztracený: Tak se nezlob</td><td>134</td></tr></tbody><tfoot><tr style=\"text-align: center;\"><td colspan=3>Písně, které se od roku 2006 držely nejvíce týdnů v TOP 100 českého rádiového žebříčku.</td></tr></tfoot></table>'"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tabulka(top10[['Track','Týdnů v TOP 100']], titulek=\"Držáci hitparády\", podtitulek=\"Písně, které se od roku 2006 držely nejvíce týdnů v TOP 100 českého rádiového žebříčku.\", poradi=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b2d07404",
   "metadata": {},
   "source": [
    "## Graf pozoruhodných písní"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "c694e1b0",
   "metadata": {},
   "outputs": [],
   "source": [
    "vsechnytydny = df['week'].drop_duplicates().to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "32f2cd48",
   "metadata": {},
   "outputs": [],
   "source": [
    "def cesta_pisne(interpretstvo, pisen, graf=False):\n",
    "    pracovni = df\n",
    "    pracovni = pracovni[(pracovni['track'] == pisen) & (pracovni['interpret_hlavni'] == interpretstvo)].drop_duplicates(subset=['rok','tyden']).set_index(\"week\", drop=True)\n",
    "    pracovni = pracovni.reindex(vsechnytydny, fill_value=101).sort_index()\n",
    "    if graf == True:\n",
    "        return pracovni['pozice'].plot(figsize=(20,5)).invert_yaxis()\n",
    "    else:\n",
    "        return pd.Series(pracovni['pozice'], name=f\"\"\"{interpretstvo}: {pisen}\"\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "51d7e87a",
   "metadata": {},
   "outputs": [],
   "source": [
    "pozoruhodne = [\n",
    "    [\"Chinaski\",\"Láska a data\"],\n",
    "    [\"Miley Cyrus\", \"Flowers\"], \n",
    "#    [\"Adele\",\"Hello\"],\n",
    "    [\"Ewa Farna\",\"Vánoce na míru\"],\n",
    "    [\"Chinaski\",\"Slovenský klín\"], \n",
    "#    [\"Avicii\", \"Without You\"],\n",
    "    [\"Karel Gott\",\"Srdce nehasnou\"],\n",
    "    [\"Mirai\",\"Když nemůžeš, tak přidej\"],\n",
    "    [\"Mandrage\",\"Motýli\"]\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "334bd1f6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "track\n",
       "Slovenský klín              2015-48\n",
       "Když nemůžeš, tak přidej    2017-05\n",
       "Vánoce na míru              2017-48\n",
       "Motýli                      2017-49\n",
       "Srdce nehasnou              2019-19\n",
       "Láska a data                2019-42\n",
       "Flowers                     2023-04\n",
       "Name: week, dtype: object"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[(df['interpret_hlavni'].isin([p[0] for p in pozoruhodne])) & (df['track'].isin([p[1] for p in pozoruhodne]))].groupby('track')['week'].min().sort_values()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "4539bf3c",
   "metadata": {},
   "outputs": [],
   "source": [
    "tydny = [x for x in df['week'].drop_duplicates().to_list() if int(x[:4]) >= 2015]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "94562338",
   "metadata": {},
   "outputs": [],
   "source": [
    "tydny.sort()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "ecc82c85",
   "metadata": {},
   "outputs": [],
   "source": [
    "pozoruhodne_g = []\n",
    "for p in pozoruhodne:\n",
    "    pozoruhodne_g.append(cesta_pisne(p[0],p[1],graf=False).reindex(tydny[40:]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "a9cc9738",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Graf uložen.\n"
     ]
    }
   ],
   "source": [
    "graf(carovy=pozoruhodne_g, target=\"pozoruhodne_pisne\", titulek='Hitparádové trajektorie vybraných písní', podtitulek=f'''Srovnání dvou nejrychlejších hitparádových jedniček (Láska a data, Flowers), dvou nejpomalejších jedniček (Vánoce na míru, Slovenský klín) a tří písní, které se v TOP 100 držely nejdéle (Srdce nehasnou, Když nemůžeš, tak přidej, Motýli).''', kredity=[\"Zdroj dat: ifpicr.cz | Vizualizace: Michal Kašpárek, iROZHLAS.cz\",\"https://www.irozhlas.cz/zpravy-tag/datova-zurnalistika\"], prvni=True, osay=' ', osay2=' ', skladany=False, naopak=False, vzhurunohama=True, osaymin=1, osaymax=100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "f3059170",
   "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>hitparada</th>\n",
       "      <th>rok</th>\n",
       "      <th>tyden</th>\n",
       "      <th>week</th>\n",
       "      <th>pozice</th>\n",
       "      <th>track</th>\n",
       "      <th>interpret</th>\n",
       "      <th>interpret_hlavni</th>\n",
       "      <th>vydavatel</th>\n",
       "      <th>wk</th>\n",
       "      <th>wk_poprve</th>\n",
       "      <th>tyden_pisne</th>\n",
       "      <th>tyden_pisne_bez_pauz</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>71460</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-01</td>\n",
       "      <td>48</td>\n",
       "      <td>Srdce nehasnou</td>\n",
       "      <td>Karel Gott/Charlotte Ella Gottová</td>\n",
       "      <td>Karel Gott</td>\n",
       "      <td>Supraphon</td>\n",
       "      <td>867</td>\n",
       "      <td>682</td>\n",
       "      <td>186</td>\n",
       "      <td>153</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73350</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-01</td>\n",
       "      <td>64</td>\n",
       "      <td>Naše cesty</td>\n",
       "      <td>Marek Ztracený</td>\n",
       "      <td>Marek Ztracený</td>\n",
       "      <td>Supraphon</td>\n",
       "      <td>867</td>\n",
       "      <td>701</td>\n",
       "      <td>167</td>\n",
       "      <td>132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75299</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-01</td>\n",
       "      <td>95</td>\n",
       "      <td>Tak se nezlob (Podpantoflák)</td>\n",
       "      <td>Marek Ztracený</td>\n",
       "      <td>Marek Ztracený</td>\n",
       "      <td>Supraphon</td>\n",
       "      <td>867</td>\n",
       "      <td>721</td>\n",
       "      <td>147</td>\n",
       "      <td>118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78314</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-01</td>\n",
       "      <td>72</td>\n",
       "      <td>Báseň</td>\n",
       "      <td>Chinaski</td>\n",
       "      <td>Chinaski</td>\n",
       "      <td>Brainzone</td>\n",
       "      <td>867</td>\n",
       "      <td>753</td>\n",
       "      <td>115</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78573</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-01</td>\n",
       "      <td>96</td>\n",
       "      <td>I přes to všechno</td>\n",
       "      <td>Mirai</td>\n",
       "      <td>Mirai</td>\n",
       "      <td>Universal Music</td>\n",
       "      <td>867</td>\n",
       "      <td>756</td>\n",
       "      <td>112</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88724</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-01</td>\n",
       "      <td>56</td>\n",
       "      <td>Belly Dancer</td>\n",
       "      <td>Imanbek &amp; Byor</td>\n",
       "      <td>Imanbek</td>\n",
       "      <td>Warner Music</td>\n",
       "      <td>867</td>\n",
       "      <td>867</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88738</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-01</td>\n",
       "      <td>65</td>\n",
       "      <td>Potion</td>\n",
       "      <td>Calvin Harris &amp; Dua Lipa &amp; Young Thug</td>\n",
       "      <td>Calvin Harris</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>867</td>\n",
       "      <td>867</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88747</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-01</td>\n",
       "      <td>70</td>\n",
       "      <td>WOW (feat. Asdis)</td>\n",
       "      <td>Toby Romeo &amp; Keanu Silva &amp; Izko</td>\n",
       "      <td>Toby Romeo</td>\n",
       "      <td>Universal Music</td>\n",
       "      <td>867</td>\n",
       "      <td>867</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88767</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-01</td>\n",
       "      <td>81</td>\n",
       "      <td>Back To You</td>\n",
       "      <td>Lost Frequencies &amp; Elley Duhé &amp; X Ambassadors</td>\n",
       "      <td>Lost Frequencies</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>867</td>\n",
       "      <td>867</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88799</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>1</td>\n",
       "      <td>2023-01</td>\n",
       "      <td>98</td>\n",
       "      <td>Another Life</td>\n",
       "      <td>Celeste Buckingham</td>\n",
       "      <td>Celeste Buckingham</td>\n",
       "      <td>Ruka Hore</td>\n",
       "      <td>867</td>\n",
       "      <td>867</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  hitparada   rok  tyden     week  pozice  \\\n",
       "71460  CZ - RADIO - TOP 100  2023      1  2023-01      48   \n",
       "73350  CZ - RADIO - TOP 100  2023      1  2023-01      64   \n",
       "75299  CZ - RADIO - TOP 100  2023      1  2023-01      95   \n",
       "78314  CZ - RADIO - TOP 100  2023      1  2023-01      72   \n",
       "78573  CZ - RADIO - TOP 100  2023      1  2023-01      96   \n",
       "...                     ...   ...    ...      ...     ...   \n",
       "88724  CZ - RADIO - TOP 100  2023      1  2023-01      56   \n",
       "88738  CZ - RADIO - TOP 100  2023      1  2023-01      65   \n",
       "88747  CZ - RADIO - TOP 100  2023      1  2023-01      70   \n",
       "88767  CZ - RADIO - TOP 100  2023      1  2023-01      81   \n",
       "88799  CZ - RADIO - TOP 100  2023      1  2023-01      98   \n",
       "\n",
       "                              track  \\\n",
       "71460                Srdce nehasnou   \n",
       "73350                    Naše cesty   \n",
       "75299  Tak se nezlob (Podpantoflák)   \n",
       "78314                         Báseň   \n",
       "78573             I přes to všechno   \n",
       "...                             ...   \n",
       "88724                  Belly Dancer   \n",
       "88738                        Potion   \n",
       "88747             WOW (feat. Asdis)   \n",
       "88767                   Back To You   \n",
       "88799                  Another Life   \n",
       "\n",
       "                                           interpret    interpret_hlavni  \\\n",
       "71460              Karel Gott/Charlotte Ella Gottová          Karel Gott   \n",
       "73350                                 Marek Ztracený      Marek Ztracený   \n",
       "75299                                 Marek Ztracený      Marek Ztracený   \n",
       "78314                                       Chinaski            Chinaski   \n",
       "78573                                          Mirai               Mirai   \n",
       "...                                              ...                 ...   \n",
       "88724                                 Imanbek & Byor             Imanbek   \n",
       "88738          Calvin Harris & Dua Lipa & Young Thug       Calvin Harris   \n",
       "88747                Toby Romeo & Keanu Silva & Izko          Toby Romeo   \n",
       "88767  Lost Frequencies & Elley Duhé & X Ambassadors    Lost Frequencies   \n",
       "88799                             Celeste Buckingham  Celeste Buckingham   \n",
       "\n",
       "             vydavatel   wk  wk_poprve  tyden_pisne  tyden_pisne_bez_pauz  \n",
       "71460        Supraphon  867        682          186                   153  \n",
       "73350        Supraphon  867        701          167                   132  \n",
       "75299        Supraphon  867        721          147                   118  \n",
       "78314        Brainzone  867        753          115                    89  \n",
       "78573  Universal Music  867        756          112                   100  \n",
       "...                ...  ...        ...          ...                   ...  \n",
       "88724     Warner Music  867        867            1                     1  \n",
       "88738       Sony Music  867        867            1                     1  \n",
       "88747  Universal Music  867        867            1                     1  \n",
       "88767       Sony Music  867        867            1                     1  \n",
       "88799        Ruka Hore  867        867            1                     1  \n",
       "\n",
       "[100 rows x 13 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['week'] == '2023-01']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "1cab715c",
   "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>hitparada</th>\n",
       "      <th>rok</th>\n",
       "      <th>tyden</th>\n",
       "      <th>week</th>\n",
       "      <th>pozice</th>\n",
       "      <th>track</th>\n",
       "      <th>interpret</th>\n",
       "      <th>interpret_hlavni</th>\n",
       "      <th>vydavatel</th>\n",
       "      <th>wk</th>\n",
       "      <th>wk_poprve</th>\n",
       "      <th>tyden_pisne</th>\n",
       "      <th>tyden_pisne_bez_pauz</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>88938</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>4</td>\n",
       "      <td>2023-04</td>\n",
       "      <td>41</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>870</td>\n",
       "      <td>870</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88939</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>5</td>\n",
       "      <td>2023-05</td>\n",
       "      <td>20</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>871</td>\n",
       "      <td>870</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88940</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>6</td>\n",
       "      <td>2023-06</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>872</td>\n",
       "      <td>870</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88941</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>7</td>\n",
       "      <td>2023-07</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>873</td>\n",
       "      <td>870</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88942</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>8</td>\n",
       "      <td>2023-08</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>874</td>\n",
       "      <td>870</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88943</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>9</td>\n",
       "      <td>2023-09</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>875</td>\n",
       "      <td>870</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88944</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>10</td>\n",
       "      <td>2023-10</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>876</td>\n",
       "      <td>870</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88945</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>11</td>\n",
       "      <td>2023-11</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>877</td>\n",
       "      <td>870</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88946</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>12</td>\n",
       "      <td>2023-12</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>878</td>\n",
       "      <td>870</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88947</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>13</td>\n",
       "      <td>2023-13</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>879</td>\n",
       "      <td>870</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88948</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>14</td>\n",
       "      <td>2023-14</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>880</td>\n",
       "      <td>870</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88949</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>15</td>\n",
       "      <td>2023-15</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>881</td>\n",
       "      <td>870</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88950</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>16</td>\n",
       "      <td>2023-16</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>882</td>\n",
       "      <td>870</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88951</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>17</td>\n",
       "      <td>2023-17</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>883</td>\n",
       "      <td>870</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88952</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>18</td>\n",
       "      <td>2023-18</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>884</td>\n",
       "      <td>870</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88953</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>19</td>\n",
       "      <td>2023-19</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>885</td>\n",
       "      <td>870</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88954</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>20</td>\n",
       "      <td>2023-20</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>886</td>\n",
       "      <td>870</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88955</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>21</td>\n",
       "      <td>2023-21</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>887</td>\n",
       "      <td>870</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88956</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>22</td>\n",
       "      <td>2023-22</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>888</td>\n",
       "      <td>870</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88957</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>23</td>\n",
       "      <td>2023-23</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>889</td>\n",
       "      <td>870</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88958</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>24</td>\n",
       "      <td>2023-24</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>890</td>\n",
       "      <td>870</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88959</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>25</td>\n",
       "      <td>2023-25</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>891</td>\n",
       "      <td>870</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88960</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>26</td>\n",
       "      <td>2023-26</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>892</td>\n",
       "      <td>870</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88961</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>27</td>\n",
       "      <td>2023-27</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>893</td>\n",
       "      <td>870</td>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88962</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>28</td>\n",
       "      <td>2023-28</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>894</td>\n",
       "      <td>870</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88963</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>29</td>\n",
       "      <td>2023-29</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>895</td>\n",
       "      <td>870</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88964</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>30</td>\n",
       "      <td>2023-30</td>\n",
       "      <td>1</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>896</td>\n",
       "      <td>870</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88965</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>31</td>\n",
       "      <td>2023-31</td>\n",
       "      <td>5</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>897</td>\n",
       "      <td>870</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88966</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>32</td>\n",
       "      <td>2023-32</td>\n",
       "      <td>12</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>898</td>\n",
       "      <td>870</td>\n",
       "      <td>29</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88967</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>33</td>\n",
       "      <td>2023-33</td>\n",
       "      <td>5</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>899</td>\n",
       "      <td>870</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88968</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>34</td>\n",
       "      <td>2023-34</td>\n",
       "      <td>7</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>900</td>\n",
       "      <td>870</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88969</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>35</td>\n",
       "      <td>2023-35</td>\n",
       "      <td>6</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>901</td>\n",
       "      <td>870</td>\n",
       "      <td>32</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88970</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>36</td>\n",
       "      <td>2023-36</td>\n",
       "      <td>8</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>902</td>\n",
       "      <td>870</td>\n",
       "      <td>33</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88971</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>37</td>\n",
       "      <td>2023-37</td>\n",
       "      <td>7</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>903</td>\n",
       "      <td>870</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88972</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>38</td>\n",
       "      <td>2023-38</td>\n",
       "      <td>5</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>904</td>\n",
       "      <td>870</td>\n",
       "      <td>35</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88973</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>39</td>\n",
       "      <td>2023-39</td>\n",
       "      <td>8</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>905</td>\n",
       "      <td>870</td>\n",
       "      <td>36</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88974</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>40</td>\n",
       "      <td>2023-40</td>\n",
       "      <td>6</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>906</td>\n",
       "      <td>870</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88975</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>41</td>\n",
       "      <td>2023-41</td>\n",
       "      <td>4</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>907</td>\n",
       "      <td>870</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88976</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>42</td>\n",
       "      <td>2023-42</td>\n",
       "      <td>8</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>908</td>\n",
       "      <td>870</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88977</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>43</td>\n",
       "      <td>2023-43</td>\n",
       "      <td>3</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>909</td>\n",
       "      <td>870</td>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88978</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>44</td>\n",
       "      <td>2023-44</td>\n",
       "      <td>3</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>910</td>\n",
       "      <td>870</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88979</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>45</td>\n",
       "      <td>2023-45</td>\n",
       "      <td>7</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>911</td>\n",
       "      <td>870</td>\n",
       "      <td>42</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88980</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>46</td>\n",
       "      <td>2023-46</td>\n",
       "      <td>6</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>912</td>\n",
       "      <td>870</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88981</th>\n",
       "      <td>CZ - RADIO - TOP 100</td>\n",
       "      <td>2023</td>\n",
       "      <td>47</td>\n",
       "      <td>2023-47</td>\n",
       "      <td>6</td>\n",
       "      <td>Flowers</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Miley Cyrus</td>\n",
       "      <td>Sony Music</td>\n",
       "      <td>913</td>\n",
       "      <td>870</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  hitparada   rok  tyden     week  pozice    track  \\\n",
       "88938  CZ - RADIO - TOP 100  2023      4  2023-04      41  Flowers   \n",
       "88939  CZ - RADIO - TOP 100  2023      5  2023-05      20  Flowers   \n",
       "88940  CZ - RADIO - TOP 100  2023      6  2023-06       1  Flowers   \n",
       "88941  CZ - RADIO - TOP 100  2023      7  2023-07       1  Flowers   \n",
       "88942  CZ - RADIO - TOP 100  2023      8  2023-08       1  Flowers   \n",
       "88943  CZ - RADIO - TOP 100  2023      9  2023-09       1  Flowers   \n",
       "88944  CZ - RADIO - TOP 100  2023     10  2023-10       1  Flowers   \n",
       "88945  CZ - RADIO - TOP 100  2023     11  2023-11       1  Flowers   \n",
       "88946  CZ - RADIO - TOP 100  2023     12  2023-12       1  Flowers   \n",
       "88947  CZ - RADIO - TOP 100  2023     13  2023-13       1  Flowers   \n",
       "88948  CZ - RADIO - TOP 100  2023     14  2023-14       1  Flowers   \n",
       "88949  CZ - RADIO - TOP 100  2023     15  2023-15       1  Flowers   \n",
       "88950  CZ - RADIO - TOP 100  2023     16  2023-16       1  Flowers   \n",
       "88951  CZ - RADIO - TOP 100  2023     17  2023-17       1  Flowers   \n",
       "88952  CZ - RADIO - TOP 100  2023     18  2023-18       1  Flowers   \n",
       "88953  CZ - RADIO - TOP 100  2023     19  2023-19       1  Flowers   \n",
       "88954  CZ - RADIO - TOP 100  2023     20  2023-20       1  Flowers   \n",
       "88955  CZ - RADIO - TOP 100  2023     21  2023-21       1  Flowers   \n",
       "88956  CZ - RADIO - TOP 100  2023     22  2023-22       1  Flowers   \n",
       "88957  CZ - RADIO - TOP 100  2023     23  2023-23       1  Flowers   \n",
       "88958  CZ - RADIO - TOP 100  2023     24  2023-24       1  Flowers   \n",
       "88959  CZ - RADIO - TOP 100  2023     25  2023-25       1  Flowers   \n",
       "88960  CZ - RADIO - TOP 100  2023     26  2023-26       1  Flowers   \n",
       "88961  CZ - RADIO - TOP 100  2023     27  2023-27       1  Flowers   \n",
       "88962  CZ - RADIO - TOP 100  2023     28  2023-28       1  Flowers   \n",
       "88963  CZ - RADIO - TOP 100  2023     29  2023-29       1  Flowers   \n",
       "88964  CZ - RADIO - TOP 100  2023     30  2023-30       1  Flowers   \n",
       "88965  CZ - RADIO - TOP 100  2023     31  2023-31       5  Flowers   \n",
       "88966  CZ - RADIO - TOP 100  2023     32  2023-32      12  Flowers   \n",
       "88967  CZ - RADIO - TOP 100  2023     33  2023-33       5  Flowers   \n",
       "88968  CZ - RADIO - TOP 100  2023     34  2023-34       7  Flowers   \n",
       "88969  CZ - RADIO - TOP 100  2023     35  2023-35       6  Flowers   \n",
       "88970  CZ - RADIO - TOP 100  2023     36  2023-36       8  Flowers   \n",
       "88971  CZ - RADIO - TOP 100  2023     37  2023-37       7  Flowers   \n",
       "88972  CZ - RADIO - TOP 100  2023     38  2023-38       5  Flowers   \n",
       "88973  CZ - RADIO - TOP 100  2023     39  2023-39       8  Flowers   \n",
       "88974  CZ - RADIO - TOP 100  2023     40  2023-40       6  Flowers   \n",
       "88975  CZ - RADIO - TOP 100  2023     41  2023-41       4  Flowers   \n",
       "88976  CZ - RADIO - TOP 100  2023     42  2023-42       8  Flowers   \n",
       "88977  CZ - RADIO - TOP 100  2023     43  2023-43       3  Flowers   \n",
       "88978  CZ - RADIO - TOP 100  2023     44  2023-44       3  Flowers   \n",
       "88979  CZ - RADIO - TOP 100  2023     45  2023-45       7  Flowers   \n",
       "88980  CZ - RADIO - TOP 100  2023     46  2023-46       6  Flowers   \n",
       "88981  CZ - RADIO - TOP 100  2023     47  2023-47       6  Flowers   \n",
       "\n",
       "         interpret interpret_hlavni   vydavatel   wk  wk_poprve  tyden_pisne  \\\n",
       "88938  Miley Cyrus      Miley Cyrus  Sony Music  870        870            1   \n",
       "88939  Miley Cyrus      Miley Cyrus  Sony Music  871        870            2   \n",
       "88940  Miley Cyrus      Miley Cyrus  Sony Music  872        870            3   \n",
       "88941  Miley Cyrus      Miley Cyrus  Sony Music  873        870            4   \n",
       "88942  Miley Cyrus      Miley Cyrus  Sony Music  874        870            5   \n",
       "88943  Miley Cyrus      Miley Cyrus  Sony Music  875        870            6   \n",
       "88944  Miley Cyrus      Miley Cyrus  Sony Music  876        870            7   \n",
       "88945  Miley Cyrus      Miley Cyrus  Sony Music  877        870            8   \n",
       "88946  Miley Cyrus      Miley Cyrus  Sony Music  878        870            9   \n",
       "88947  Miley Cyrus      Miley Cyrus  Sony Music  879        870           10   \n",
       "88948  Miley Cyrus      Miley Cyrus  Sony Music  880        870           11   \n",
       "88949  Miley Cyrus      Miley Cyrus  Sony Music  881        870           12   \n",
       "88950  Miley Cyrus      Miley Cyrus  Sony Music  882        870           13   \n",
       "88951  Miley Cyrus      Miley Cyrus  Sony Music  883        870           14   \n",
       "88952  Miley Cyrus      Miley Cyrus  Sony Music  884        870           15   \n",
       "88953  Miley Cyrus      Miley Cyrus  Sony Music  885        870           16   \n",
       "88954  Miley Cyrus      Miley Cyrus  Sony Music  886        870           17   \n",
       "88955  Miley Cyrus      Miley Cyrus  Sony Music  887        870           18   \n",
       "88956  Miley Cyrus      Miley Cyrus  Sony Music  888        870           19   \n",
       "88957  Miley Cyrus      Miley Cyrus  Sony Music  889        870           20   \n",
       "88958  Miley Cyrus      Miley Cyrus  Sony Music  890        870           21   \n",
       "88959  Miley Cyrus      Miley Cyrus  Sony Music  891        870           22   \n",
       "88960  Miley Cyrus      Miley Cyrus  Sony Music  892        870           23   \n",
       "88961  Miley Cyrus      Miley Cyrus  Sony Music  893        870           24   \n",
       "88962  Miley Cyrus      Miley Cyrus  Sony Music  894        870           25   \n",
       "88963  Miley Cyrus      Miley Cyrus  Sony Music  895        870           26   \n",
       "88964  Miley Cyrus      Miley Cyrus  Sony Music  896        870           27   \n",
       "88965  Miley Cyrus      Miley Cyrus  Sony Music  897        870           28   \n",
       "88966  Miley Cyrus      Miley Cyrus  Sony Music  898        870           29   \n",
       "88967  Miley Cyrus      Miley Cyrus  Sony Music  899        870           30   \n",
       "88968  Miley Cyrus      Miley Cyrus  Sony Music  900        870           31   \n",
       "88969  Miley Cyrus      Miley Cyrus  Sony Music  901        870           32   \n",
       "88970  Miley Cyrus      Miley Cyrus  Sony Music  902        870           33   \n",
       "88971  Miley Cyrus      Miley Cyrus  Sony Music  903        870           34   \n",
       "88972  Miley Cyrus      Miley Cyrus  Sony Music  904        870           35   \n",
       "88973  Miley Cyrus      Miley Cyrus  Sony Music  905        870           36   \n",
       "88974  Miley Cyrus      Miley Cyrus  Sony Music  906        870           37   \n",
       "88975  Miley Cyrus      Miley Cyrus  Sony Music  907        870           38   \n",
       "88976  Miley Cyrus      Miley Cyrus  Sony Music  908        870           39   \n",
       "88977  Miley Cyrus      Miley Cyrus  Sony Music  909        870           40   \n",
       "88978  Miley Cyrus      Miley Cyrus  Sony Music  910        870           41   \n",
       "88979  Miley Cyrus      Miley Cyrus  Sony Music  911        870           42   \n",
       "88980  Miley Cyrus      Miley Cyrus  Sony Music  912        870           43   \n",
       "88981  Miley Cyrus      Miley Cyrus  Sony Music  913        870           44   \n",
       "\n",
       "       tyden_pisne_bez_pauz  \n",
       "88938                     1  \n",
       "88939                     2  \n",
       "88940                     3  \n",
       "88941                     4  \n",
       "88942                     5  \n",
       "88943                     6  \n",
       "88944                     7  \n",
       "88945                     8  \n",
       "88946                     9  \n",
       "88947                    10  \n",
       "88948                    11  \n",
       "88949                    12  \n",
       "88950                    13  \n",
       "88951                    14  \n",
       "88952                    15  \n",
       "88953                    16  \n",
       "88954                    17  \n",
       "88955                    18  \n",
       "88956                    19  \n",
       "88957                    20  \n",
       "88958                    21  \n",
       "88959                    22  \n",
       "88960                    23  \n",
       "88961                    24  \n",
       "88962                    25  \n",
       "88963                    26  \n",
       "88964                    27  \n",
       "88965                    28  \n",
       "88966                    29  \n",
       "88967                    30  \n",
       "88968                    31  \n",
       "88969                    32  \n",
       "88970                    33  \n",
       "88971                    34  \n",
       "88972                    35  \n",
       "88973                    36  \n",
       "88974                    37  \n",
       "88975                    38  \n",
       "88976                    39  \n",
       "88977                    40  \n",
       "88978                    41  \n",
       "88979                    42  \n",
       "88980                    43  \n",
       "88981                    44  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['track'] == 'Flowers']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f266d7fd",
   "metadata": {},
   "source": [
    "## Graf typické trajektorie"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "7bca7b2b",
   "metadata": {},
   "outputs": [],
   "source": [
    "def graf_stredni_pisne(nazev, tydny, filtr=df['track'].drop_duplicates().to_list()):\n",
    "    \n",
    "    pocet_nasazenych = [i for i in range (1, df[df['track'].isin(filtr)].groupby('tyden_pisne').size().iloc[0] + 1)]\n",
    "    tydny_pisni = [i for i in range(1,tydny + 1)]\n",
    "    \n",
    "    def spocti_stredni_pisen(tyden, pocet):\n",
    "        jak_si_vedou = pd.Series(df[(df['tyden_pisne'] == tyden) & (df['track'].isin(filtr))]['pozice'])\n",
    "        jak_si_vedou = jak_si_vedou.reset_index(drop = True)\n",
    "        jak_si_vedou = jak_si_vedou.reindex(pocet_nasazenych, fill_value=101).sort_index()\n",
    "        return jak_si_vedou\n",
    "    \n",
    "    cesta_stredni_pisne = {}\n",
    "    for t in tydny_pisni:\n",
    "        cesta_stredni_pisne[t] = spocti_stredni_pisen(t, pocet_nasazenych).median()\n",
    "    \n",
    "    return pd.Series(cesta_stredni_pisne, name=nazev)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "cd9caffa",
   "metadata": {},
   "outputs": [],
   "source": [
    "h1 = graf_stredni_pisne('Hity č. 1',52, filtr=df[df['pozice'] == 1]['track'].drop_duplicates().to_list())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "68261eb3",
   "metadata": {},
   "outputs": [],
   "source": [
    "h2 = graf_stredni_pisne('Písně z TOP 10',52, filtr=df[df['pozice'] <= 10]['track'].drop_duplicates().to_list())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "8a5f405a",
   "metadata": {},
   "outputs": [],
   "source": [
    "h3 = graf_stredni_pisne('Písně z TOP 100',52, filtr=df[df['pozice'] <= 100]['track'].drop_duplicates().to_list())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "3b6e9f7b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Graf uložen.\n"
     ]
    }
   ],
   "source": [
    "graf(carovy=[h1, h2, h3], target=\"typicka_trajektorie\", titulek='Typická cesta písně hitparádou', podtitulek=f'''Graf zobrazuje střední pozici vybrané kategorie podle týdnu od prvního proniknutí mezi 100 nejhranějších písní v českých rádiích.''', kredity=[\"Zdroj dat: ifpicr.cz | Vizualizace: Michal Kašpárek, iROZHLAS.cz\",\"https://www.irozhlas.cz/zpravy-tag/datova-zurnalistika\"], prvni=True, skladany=False, naopak=False, osay=\"Pozice\", vzhurunohama=True, osaymax=100)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "76c62f86",
   "metadata": {},
   "source": [
    "## Vydavatelství"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "c8e426e6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0           Warner Music\n",
       "1           Warner Music\n",
       "2           Warner Music\n",
       "3           Warner Music\n",
       "4           Warner Music\n",
       "              ...       \n",
       "91395    Universal Music\n",
       "91396       Warner Music\n",
       "91397       Warner Music\n",
       "91398                Nan\n",
       "91399         Sony Music\n",
       "Name: vydavatel, Length: 91400, dtype: object"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['vydavatel']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "cb429ac9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Warner Music',\n",
       " 'Universal Music',\n",
       " 'Sony Music',\n",
       " 'Agentura Goja',\n",
       " 'Um/Mp',\n",
       " 'Pm',\n",
       " 'Wave Rec.',\n",
       " 'Popron Traxx',\n",
       " 'Hfr',\n",
       " 'Rgme',\n",
       " 'Ir',\n",
       " 'Tiger',\n",
       " 'Supraphon',\n",
       " 'Tah',\n",
       " 'Orpheus Production',\n",
       " 'E2',\n",
       " 'Fajnr.',\n",
       " 'Tr',\n",
       " 'Curepink',\n",
       " 'Prospero In',\n",
       " 'Lp',\n",
       " 'Next Era',\n",
       " 'Nettwerk',\n",
       " 'Brjan Music',\n",
       " 'Nan',\n",
       " 'Starshit-Recordings',\n",
       " 'Pony Canyon',\n",
       " 'Wm/Forza',\n",
       " 'Leftout',\n",
       " 'Kontor Records',\n",
       " 'Championship Music',\n",
       " 'Colosseum Rec.',\n",
       " 'Homerun Records',\n",
       " 'Sl/Um',\n",
       " 'Klubbstyle Rec.',\n",
       " 'M&M Brothers',\n",
       " 'Bpm Rec.',\n",
       " 'Toka Beatz',\n",
       " 'Wg',\n",
       " 'Altantic',\n",
       " 'Big Demoiselles',\n",
       " 'Fm1/Promoprodukce',\n",
       " 'Panther',\n",
       " 'Onairmusic',\n",
       " 'Vis-A-Vis Prod.',\n",
       " 'Chm/Parlophone',\n",
       " 'X Production',\n",
       " \"H'Art\",\n",
       " 'Patricie',\n",
       " 'Fn',\n",
       " 'Richmondrecords',\n",
       " 'Rm Records',\n",
       " 'Brainzone',\n",
       " 'Cox',\n",
       " 'Singlton/Universal Music',\n",
       " 'Česká Muzika',\n",
       " 'Hm/Emi',\n",
       " 'Am',\n",
       " 'Pink Panther Desing/Warner Music',\n",
       " 'Mafia Records',\n",
       " 'Pop Off Production',\n",
       " 'Richmondrecords/Emi',\n",
       " 'Petarda Production',\n",
       " 'Mc Production',\n",
       " 'Ultrarecords',\n",
       " 'Bohemian Recordings',\n",
       " 'Brainzone/Tommü Records',\n",
       " 'Art One/Um',\n",
       " 'Um/Richrec',\n",
       " 'Um/Hitfactory Rec.',\n",
       " 'Revealed',\n",
       " 'Distribuce Závodský',\n",
       " 'Lewron Music Center',\n",
       " 'Cmh',\n",
       " 'Studio Fontána',\n",
       " 'Promoteam',\n",
       " 'Hurikán Records',\n",
       " 'Raego Tv',\n",
       " 'Olga Lounová Records',\n",
       " 'Magic Records',\n",
       " 'B&M Music',\n",
       " 'R48 Agency S.R.O.',\n",
       " 'Wait For Waves',\n",
       " 'Clockwise',\n",
       " 'Biograf Jan Svěrák',\n",
       " 'Cross Audio Production',\n",
       " 'Dade Music/Supraphon',\n",
       " 'Kudykam',\n",
       " 'Art Shock/Supraphon',\n",
       " 'I.Richmond.P./Universal Music',\n",
       " 'Bookin Agency',\n",
       " 'Pink Panther',\n",
       " 'Popron Music',\n",
       " 'Ty Nikdy / Universal Music',\n",
       " 'Tescoma Music',\n",
       " 'Tomáš Klus',\n",
       " 'Lch',\n",
       " 'Maxi Records',\n",
       " 'Harix S.R.O.',\n",
       " 'Lotus Line',\n",
       " 'Tranzistor',\n",
       " 'Samonáklad',\n",
       " 'Xl Recordings',\n",
       " 'We On The Moon',\n",
       " 'Mistamusic',\n",
       " 'Foret Records',\n",
       " 'Hr',\n",
       " 'Marlene Film Production',\n",
       " 'Studio Citron',\n",
       " 'Sukuba Agency',\n",
       " 'Lake Malawi',\n",
       " 'Eleven Seven',\n",
       " 'Paf Music',\n",
       " 'Ewolution/Warner Music',\n",
       " 'Goja',\n",
       " 'Blakkwood/Universal Music',\n",
       " 'Ego',\n",
       " 'Mikael Music',\n",
       " 'Armada',\n",
       " 'Buckingham Entertainment Group',\n",
       " 'Sagl Production',\n",
       " 'The Silver Spoons',\n",
       " 'Edel',\n",
       " 'Ty Nikdy/Warner Music',\n",
       " 'Lauv',\n",
       " 'Bigg Boss',\n",
       " 'Universal Music/Warner Music',\n",
       " 'Kali Records',\n",
       " 'Vivienne Records',\n",
       " 'Niko',\n",
       " 'Bmg/Dream Music',\n",
       " 'Surikata Rec.',\n",
       " 'Nn Music',\n",
       " 'Peter Fider',\n",
       " 'Hm Productions',\n",
       " 'Wisemusic',\n",
       " 'Cap-Sounds',\n",
       " 'Mida',\n",
       " 'Mu-Zi-Ka!',\n",
       " 'Petarda/Brainzone',\n",
       " 'Mike Roft Records/Warner Music',\n",
       " '100Promotion',\n",
       " 'Alma Matters',\n",
       " 'Daniell',\n",
       " 'Pias',\n",
       " 'Fck Them/Universal Music',\n",
       " 'Easy Life Records',\n",
       " 'Domi',\n",
       " 'Marek Ztracený/Supraphon',\n",
       " 'Autentik Music/Universal Music',\n",
       " 'Timbre Music',\n",
       " 'Ewolution',\n",
       " 'Irascible Music',\n",
       " 'Ingrooves',\n",
       " 'Tomáš Klus / Supraphon',\n",
       " 'Super Projects',\n",
       " 'Holidays Forever',\n",
       " 'Ruka Hore',\n",
       " 'Global Records',\n",
       " 'Adam Janota',\n",
       " 'Fate Magazine',\n",
       " 'Dimitrije Maksimovic',\n",
       " 'Bmg Rights Management',\n",
       " 'Mark Dann',\n",
       " 'Championship M./Universal M.',\n",
       " 'Better Noise Music',\n",
       " 'Viktor Sheen/Mikeroft/Warner M.',\n",
       " 'Promuziku']"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['vydavatel'].drop_duplicates().to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "10fef159",
   "metadata": {},
   "outputs": [],
   "source": [
    "vydavatelstvo = df.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "d818b3fd",
   "metadata": {},
   "outputs": [],
   "source": [
    "vydavatelstvo['vydavatel'] = vydavatelstvo['vydavatel'].apply(lambda x: x.split(\"/\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "ddc2fc06",
   "metadata": {},
   "outputs": [],
   "source": [
    "vydavatelstvo = vydavatelstvo.explode('vydavatel')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "cae5782a",
   "metadata": {},
   "outputs": [],
   "source": [
    "vydavatelstvo['vydavatel'] = vydavatelstvo['vydavatel'].apply(lambda x: x.strip())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "4ec0ad18",
   "metadata": {},
   "outputs": [],
   "source": [
    "vydavatelstvo['vydavatel'] = vydavatelstvo['vydavatel'].replace('Nan',None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "30de9614",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "vydavatel\n",
       "Universal Music         41406\n",
       "Warner Music            21238\n",
       "Sony Music              17961\n",
       "Supraphon                2434\n",
       "Brainzone                2429\n",
       "Singlton                  996\n",
       "I.Richmond.P.             886\n",
       "Championship Music        290\n",
       "Marek Ztracený            289\n",
       "Rgme                      206\n",
       "Olga Lounová Records      176\n",
       "Kontor Records            133\n",
       "Um                        122\n",
       "Lewron Music Center       121\n",
       "Tr                        111\n",
       "Forza                     105\n",
       "Onairmusic                105\n",
       "Wm                        105\n",
       "Chm                        99\n",
       "Parlophone                 99\n",
       "Dade Music                 88\n",
       "Vivienne Records           85\n",
       "Hfr                        82\n",
       "Vis-A-Vis Prod.            80\n",
       "Ty Nikdy                   76\n",
       "The Silver Spoons          74\n",
       "Am                         72\n",
       "Ingrooves                  72\n",
       "Art Shock                  66\n",
       "Richrec                    66\n",
       "Homerun Records            63\n",
       "Biograf Jan Svěrák         57\n",
       "M&M Brothers               50\n",
       "Tranzistor                 50\n",
       "Tomáš Klus                 49\n",
       "Xl Recordings              49\n",
       "Ewolution                  47\n",
       "Popron Music               47\n",
       "Panther                    43\n",
       "Wait For Waves             43\n",
       "Eleven Seven               42\n",
       "Mike Roft Records          41\n",
       "Pm                         40\n",
       "Wisemusic                  38\n",
       "Pop Off Production         37\n",
       "Pink Panther               36\n",
       "Sl                         36\n",
       "Wave Rec.                  36\n",
       "Richmondrecords            35\n",
       "Timbre Music               35\n",
       "dtype: int64"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vydavatelstvo.groupby('vydavatel').size().nlargest(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "b6e513ea",
   "metadata": {},
   "outputs": [],
   "source": [
    "top_vydavatele = vydavatelstvo.groupby('vydavatel').size().nlargest().index.to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "482d28bf",
   "metadata": {},
   "outputs": [],
   "source": [
    "vydavatelstvo_graf = []\n",
    "for v in top_vydavatele:\n",
    "    serie = pd.Series(vydavatelstvo[vydavatelstvo['vydavatel'] == v].groupby('rok').size() / vydavatelstvo.groupby('rok').size(), name=v)\n",
    "    vydavatelstvo_graf.append(serie)\n",
    "serie_ostatni = pd.Series(vydavatelstvo[~vydavatelstvo['vydavatel'].isin(top_vydavatele)].groupby('rok').size()  / vydavatelstvo.groupby('rok').size(), name='ostatní')\n",
    "vydavatelstvo_graf.append(serie_ostatni)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "1105653a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Graf uložen.\n"
     ]
    }
   ],
   "source": [
    "graf(carovy=vydavatelstvo_graf, target='vydavatelstvo', titulek='Podíl vydavatelů na hitparádových příčkách', podtitulek=\"Malým vydavatelům se vede lépe než před 15 lety, dominanci velkých však zásadně nenabourali. V řadě případů jde o hudební samizdat – mimo jiné u singlů Marka Ztraceného, Olgy Lounové nebo Tomáše Kluse.\", procenta=vydavatelstvo_graf, kredity=[\"Zdroj dat: ifpicr.cz | Vizualizace: Michal Kašpárek, iROZHLAS.cz\",\"https://www.irozhlas.cz/zpravy-tag/datova-zurnalistika\"])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "97ac03f1",
   "metadata": {},
   "source": [
    "### Největší úspěchy malých: týdny na vrcholu hitparády"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "641d2ee9",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "vydavatel         interpret_hlavni  track                                   \n",
       "I.Richmond.P.     Kryštof           Ty a já                                     9\n",
       "                                    Srdcebeat                                   6\n",
       "                                    Zůstaň tu se mnou (Za sny)                  5\n",
       "Richrec           Kryštof           Inzerát                                     5\n",
       "Um                Kryštof           Inzerát                                     5\n",
       "I.Richmond.P.     Kryštof           Hvězdáři (feat. Sima Martausová)            3\n",
       "Marek Ztracený    Marek Ztracený    Originál                                    3\n",
       "Ewolution         Ewa Farna         Vánoce na míru                              2\n",
       "I.Richmond.P.     Kryštof           Hned teď (pojď být světlometem)             2\n",
       "Vivienne Records  Mikolas Josef     Acapella (feat. Fito Blanko & Frankie J)    2\n",
       "Chm               Xindl X           Láska v housce                              1\n",
       "I.Richmond.P.     Kryštof           Vánoční                                     1\n",
       "Onairmusic        Nightwork         Čekám na signál                             1\n",
       "Parlophone        Xindl X           Láska v housce                              1\n",
       "Name: week, dtype: int64"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vydavatelstvo[(vydavatelstvo['pozice'] == 1) & (~vydavatelstvo['vydavatel'].isin(top_vydavatele))].groupby(['vydavatel','interpret_hlavni','track'])['week'].nunique().nlargest(20)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "20ebdf64",
   "metadata": {},
   "source": [
    "### Největší úspěchy malých: písní v top 100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "37e1474a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "vydavatel\n",
       "Singlton                44\n",
       "Championship Music      29\n",
       "I.Richmond.P.           14\n",
       "Rgme                    12\n",
       "Tr                       9\n",
       "Kontor Records           8\n",
       "Vis-A-Vis Prod.          8\n",
       "Lewron Music Center      7\n",
       "Olga Lounová Records     7\n",
       "Pm                       7\n",
       "Hfr                      6\n",
       "Marek Ztracený           6\n",
       "Um                       6\n",
       "Armada                   5\n",
       "Onairmusic               5\n",
       "Pink Panther             5\n",
       "The Silver Spoons        5\n",
       "Tomáš Klus               5\n",
       "Ty Nikdy                 5\n",
       "Wisemusic                5\n",
       "Name: track, dtype: int64"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vydavatelstvo[(~vydavatelstvo['vydavatel'].isin(top_vydavatele))].groupby(['vydavatel'])['track'].nunique().nlargest(20)"
   ]
  }
 ],
 "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.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}