vizzu.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "102360cc-0243-4dc9-b77f-6b52a70250b1",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Django setup.\n",
    "import os\n",
    "os.environ['DJANGO_SETTINGS_MODULE'] = 'bookmark_db.settings'\n",
    "os.environ['DJANGO_ALLOW_ASYNC_UNSAFE'] = 'True'\n",
    "\n",
    "import django\n",
    "django.setup()\n",
    "\n",
    "# Django database connection and helper query functions.\n",
    "from django.db import connection\n",
    "cursor = connection.cursor()\n",
    "\n",
    "def execute(query, params=None):\n",
    "    cursor.execute(query, params)\n",
    "\n",
    "def fetch_row(query):\n",
    "    cursor.execute(query)\n",
    "    return cursor.fetchone()\n",
    "\n",
    "def fetch_rows(query):\n",
    "    cursor.execute(query)\n",
    "    columns = [col[0] for col in cursor.description]\n",
    "    return [dict(zip(columns, row)) for row in cursor.fetchall()]\n",
    "\n",
    "# Regular imports.\n",
    "import calendar\n",
    "import collections\n",
    "from pprint import pprint\n",
    "from urllib.parse import urlparse\n",
    "\n",
    "from ipyvizzu import Data, Config, Style\n",
    "from ipyvizzustory import Story, Slide, Step\n",
    "\n",
    "# Common data.\n",
    "min_year = fetch_row(\"SELECT EXTRACT(YEAR FROM MIN(created_on))::INT FROM bookmarks_bookmark;\")[0]\n",
    "max_year = fetch_row(\"SELECT EXTRACT(YEAR FROM MAX(created_on))::INT FROM bookmarks_bookmark;\")[0]\n",
    "MODE_AGGREGATE = 'aggregate'\n",
    "MODE_BY_YEAR = 'by_year'\n",
    "MODE = MODE_AGGREGATE"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "df86008f-8501-4811-919c-74f4a0442002",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "'bookmark_created_ons:'\n",
      "[{'count': 0, 'month': 'Jan', 'year': 2023},\n",
      " {'count': 0, 'month': 'Feb', 'year': 2023},\n",
      " {'count': 0, 'month': 'Mar', 'year': 2023}]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "\n",
       "<div>\n",
       "    <vizzu-player id=\"be7e37f\"   controller></vizzu-player>\n",
       "    <script type=\"module\">\n",
       "        import VizzuPlayer from \"https://cdn.jsdelivr.net/npm/vizzu-story@0.4/dist/vizzu-story.min.js\";\n",
       "\n",
       "        const vp = document.getElementById(\"be7e37f\");\n",
       "        import(vp.vizzuUrl).then(vizzuLoaded => {\n",
       "            const lib = vizzuLoaded.default;\n",
       "            const vizzuPlayerData = {\"data\": {\"series\": [{\"name\": \"Year\", \"type\": \"dimension\", \"values\": [\"2023\", \"2023\", \"2023\", \"2023\", \"2023\", \"2023\", \"2023\", \"2023\", \"2023\", \"2023\", \"2023\", \"2023\"]}, {\"name\": \"Month\", \"type\": \"dimension\", \"values\": [\"Jan\", \"Feb\", \"Mar\", \"Apr\", \"May\", \"Jun\", \"Jul\", \"Aug\", \"Sep\", \"Oct\", \"Nov\", \"Dec\"]}, {\"name\": \"Count\", \"type\": \"measure\", \"values\": [0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0]}]}, \"slides\": [[{\"config\": {\"channels\": {\"x\": null, \"y\": \"Count\", \"label\": \"Count\"}, \"title\": \"Bookmarks\"}}], [{\"config\": {\"channels\": {\"x\": \"Year\", \"y\": \"Count\", \"label\": \"Count\", \"lightness\": \"Count\"}, \"title\": \"Bookmarks by year\"}}], [{\"config\": {\"channels\": {\"x\": \"Month\", \"y\": \"Count\", \"label\": \"Count\", \"lightness\": \"Count\"}, \"title\": \"Bookmarks by month\"}}], [{\"config\": {\"channels\": {\"x\": \"Month\", \"y\": \"Count\", \"label\": \"Count\", \"lightness\": null}, \"geometry\": \"area\", \"title\": \"Bookmarks by month\"}}], [{\"config\": {\"channels\": {\"x\": \"Month\", \"y\": [\"Count\", \"Year\"], \"color\": \"Year\", \"label\": null}, \"geometry\": \"area\", \"title\": \"Bookmarks by month\"}}], [{\"config\": {\"channels\": {\"x\": \"Month\", \"y\": [\"Count\", \"Year\"], \"color\": \"Year\", \"label\": null}, \"geometry\": \"area\", \"title\": \"Bookmarks by month 2023 - 2023\"}, \"filter\": record => { return (record['Year'] <= '2023') }}], [{\"config\": {\"channels\": {\"x\": \"Month\", \"y\": \"Count\", \"color\": \"Year\", \"label\": null}, \"geometry\": \"line\", \"title\": \"Bookmarks by month\"}, \"filter\": null}], [{\"config\": {\"channels\": {\"x\": \"Month\", \"y\": \"Count\", \"color\": \"Year\", \"label\": null}, \"geometry\": \"line\", \"title\": \"Bookmarks by month 2013 - 2014\"}, \"filter\": record => { return (record['Year'] >= '2013' && record['Year'] <= '2014') }}], [{\"config\": {\"channels\": {\"x\": \"Month\", \"y\": [\"Count\", \"Year\"], \"color\": \"Year\", \"label\": null}, \"geometry\": \"rectangle\", \"title\": \"Bookmarks by month 2013 - 2014\"}, \"filter\": record => { return (record['Year'] >= '2013' && record['Year'] <= '2014') }}], [{\"config\": {\"channels\": {\"x\": \"Count\", \"y\": \"Year\", \"color\": \"Year\", \"label\": null}, \"geometry\": \"rectangle\", \"reverse\": true, \"title\": \"Bookmarks by month 2013 vs 2014\"}, \"filter\": record => { return (record['Year'] >= '2013' && record['Year'] <= '2014') }}], [{\"config\": {\"channels\": {\"x\": [\"Count\", \"Month\"], \"y\": \"Year\", \"color\": \"Month\", \"label\": \"Month\"}, \"geometry\": \"rectangle\", \"reverse\": true, \"title\": \"Bookmarks by month 2013 vs 2014\"}, \"filter\": record => { return (record['Year'] >= '2013' && record['Year'] <= '2014') }}]]};\n",
       "            // story.set_size()\n",
       "            \n",
       "            vp.slides = vizzuPlayerData;\n",
       "            vp.initializing.then(chart => {\n",
       "                // story.set_feature()\n",
       "                chart.feature('tooltip', true);\n",
       "                // story.add_event()\n",
       "                \n",
       "            });\n",
       "        });\n",
       "    </script>\n",
       "</div>\n"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# bookmark_created_ons\n",
    "min_year_start = f'{min_year}-01-01'\n",
    "max_year_end = f'{max_year}-12-12'\n",
    "execute(\"CREATE OR REPLACE VIEW all_dates AS SELECT EXTRACT(YEAR FROM series)::INT AS year, EXTRACT(MONTH FROM series)::INT AS month FROM GENERATE_SERIES(%s::TIMESTAMP, %s, '1 MONTH') AS series;\", [min_year_start, max_year_end])\n",
    "execute(\"CREATE OR REPLACE VIEW all_data AS SELECT EXTRACT(YEAR FROM created_on)::INT AS year, EXTRACT(MONTH FROM created_on)::INT AS month, COUNT(*) FROM bookmarks_bookmark GROUP BY year, month ORDER BY year, month;\")\n",
    "bookmark_created_ons = fetch_rows(\"SELECT year, month, COALESCE(count, 0) AS count FROM all_dates FULL OUTER JOIN all_data USING (year, month);\")\n",
    "for bookmark_created_on in bookmark_created_ons:\n",
    "    bookmark_created_on['month'] = calendar.month_name[bookmark_created_on['month']][:3]\n",
    "pprint('bookmark_created_ons:')\n",
    "pprint(bookmark_created_ons[:3])\n",
    "data = Data()\n",
    "data.add_series('Year', [str(x['year']) for x in bookmark_created_ons], type='dimension')\n",
    "data.add_series('Month', [x['month'] for x in bookmark_created_ons], type='dimension')\n",
    "data.add_series('Count', [x['count'] for x in bookmark_created_ons], type='measure')\n",
    "story = Story(data=data)\n",
    "story.set_feature('tooltip', True)\n",
    "slide = Slide(\n",
    "    Step(\n",
    "        Config({\n",
    "            'channels': {\n",
    "                'x': None,\n",
    "                'y': 'Count',\n",
    "                'label': 'Count',\n",
    "            },\n",
    "            'title': 'Bookmarks',\n",
    "        }),\n",
    "    ),\n",
    ")\n",
    "story.add_slide(slide)\n",
    "slide = Slide(\n",
    "    Step(\n",
    "        Config({\n",
    "            'channels': {\n",
    "                'x': 'Year',\n",
    "                'y': 'Count',\n",
    "                'label': 'Count',\n",
    "                'lightness': 'Count',\n",
    "            },\n",
    "            'title': 'Bookmarks by year',\n",
    "        }),\n",
    "    ),\n",
    ")\n",
    "story.add_slide(slide)\n",
    "slide = Slide(\n",
    "    Step(\n",
    "        Config({\n",
    "            'channels': {\n",
    "                'x': 'Month',\n",
    "                'y': 'Count',\n",
    "                'label': 'Count',\n",
    "                'lightness': 'Count',\n",
    "            },\n",
    "            'title': 'Bookmarks by month',\n",
    "        }),\n",
    "    ),\n",
    ")\n",
    "story.add_slide(slide)\n",
    "slide = Slide(\n",
    "    Step(\n",
    "        Config({\n",
    "            'channels': {\n",
    "                'x': 'Month',\n",
    "                'y': 'Count',\n",
    "                'label': 'Count',\n",
    "                'lightness': None,\n",
    "            },\n",
    "            'geometry': 'area',\n",
    "            'title': 'Bookmarks by month',\n",
    "        }),\n",
    "    ),\n",
    ")\n",
    "story.add_slide(slide)\n",
    "slide = Slide(\n",
    "    Step(\n",
    "        Config({\n",
    "            'channels': {\n",
    "                'x': 'Month',\n",
    "                'y': ['Count', 'Year'],\n",
    "                'color': 'Year',\n",
    "                'label': None,\n",
    "            },\n",
    "            'geometry': 'area',\n",
    "            'title': 'Bookmarks by month',\n",
    "        }),\n",
    "    ),\n",
    ")\n",
    "story.add_slide(slide)\n",
    "slide = Slide()\n",
    "for year in range(min_year, max_year + 1):\n",
    "    step = Step(\n",
    "        Config({\n",
    "            'channels': {\n",
    "                'x': 'Month',\n",
    "                'y': ['Count', 'Year'],\n",
    "                'color': 'Year',\n",
    "                'label': None,\n",
    "            },\n",
    "            'geometry': 'area',\n",
    "            'title': f'Bookmarks by month {min_year} - {year}',\n",
    "        }),\n",
    "        Data.filter(f\"record['Year'] <= '{year}'\"),\n",
    "    )\n",
    "    slide.add_step(step)\n",
    "story.add_slide(slide)\n",
    "slide = Slide(\n",
    "    Step(\n",
    "        Config({\n",
    "            'channels': {\n",
    "                'x': 'Month',\n",
    "                'y': 'Count',\n",
    "                'color': 'Year',\n",
    "                'label': None,\n",
    "            },\n",
    "            'geometry': 'line',\n",
    "            'title': 'Bookmarks by month',\n",
    "        }),\n",
    "        Data.filter(None),\n",
    "    ),\n",
    ")\n",
    "story.add_slide(slide)\n",
    "slide = Slide(\n",
    "    Step(\n",
    "        Config({\n",
    "            'channels': {\n",
    "                'x': 'Month',\n",
    "                'y': 'Count',\n",
    "                'color': 'Year',\n",
    "                'label': None,\n",
    "            },\n",
    "            'geometry': 'line',\n",
    "            'title': 'Bookmarks by month 2013 - 2014',\n",
    "        }),\n",
    "        Data.filter(f\"record['Year'] >= '2013' && record['Year'] <= '2014'\"),\n",
    "    ),\n",
    ")\n",
    "story.add_slide(slide)\n",
    "slide = Slide(\n",
    "    Step(\n",
    "        Config({\n",
    "            'channels': {\n",
    "                'x': 'Month',\n",
    "                'y': ['Count', 'Year'],\n",
    "                'color': 'Year',\n",
    "                'label': None,\n",
    "            },\n",
    "            'geometry': 'rectangle',\n",
    "            'title': 'Bookmarks by month 2013 - 2014',\n",
    "        }),\n",
    "        Data.filter(f\"record['Year'] >= '2013' && record['Year'] <= '2014'\"),\n",
    "    ),\n",
    ")\n",
    "story.add_slide(slide)\n",
    "slide = Slide(\n",
    "    Step(\n",
    "        Config({\n",
    "            'channels': {\n",
    "                'x': 'Count',\n",
    "                'y': 'Year',\n",
    "                'color': 'Year',\n",
    "                'label': None,\n",
    "            },\n",
    "            'geometry': 'rectangle',\n",
    "            'reverse': True,\n",
    "            'title': 'Bookmarks by month 2013 vs 2014',\n",
    "        }),\n",
    "        Data.filter(f\"record['Year'] >= '2013' && record['Year'] <= '2014'\"),\n",
    "    ),\n",
    ")\n",
    "story.add_slide(slide)\n",
    "slide = Slide(\n",
    "    Step(\n",
    "        Config({\n",
    "            'channels': {\n",
    "                'x': ['Count', 'Month'],\n",
    "                'y': 'Year',\n",
    "                'color': 'Month',\n",
    "                'label': 'Month',\n",
    "            },\n",
    "            'geometry': 'rectangle',\n",
    "            'reverse': True,\n",
    "            'title': 'Bookmarks by month 2013 vs 2014',\n",
    "        }),\n",
    "        Data.filter(f\"record['Year'] >= '2013' && record['Year'] <= '2014'\"),\n",
    "    ),\n",
    ")\n",
    "story.add_slide(slide)\n",
    "story.play()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "29636a39-8b80-4690-b178-68644d78a856",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "'bookmark_domains:'\n",
      "[{'domain': 'old-bookmark-c.db', 'year': 2023},\n",
      " {'domain': 'old-bookmark-a.db', 'year': 2023},\n",
      " {'domain': 'old-bookmark-b.db', 'year': 2023}]\n",
      "'top_bookmark_domains:'\n",
      "[{'count': 1, 'domain': 'old-bookmark-c.db', 'year': 2023},\n",
      " {'count': 1, 'domain': 'old-bookmark-a.db', 'year': 2023},\n",
      " {'count': 1, 'domain': 'old-bookmark-b.db', 'year': 2023}]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "\n",
       "<div>\n",
       "    <vizzu-player id=\"33c87b3\"   controller></vizzu-player>\n",
       "    <script type=\"module\">\n",
       "        import VizzuPlayer from \"https://cdn.jsdelivr.net/npm/vizzu-story@0.4/dist/vizzu-story.min.js\";\n",
       "\n",
       "        const vp = document.getElementById(\"33c87b3\");\n",
       "        import(vp.vizzuUrl).then(vizzuLoaded => {\n",
       "            const lib = vizzuLoaded.default;\n",
       "            const vizzuPlayerData = {\"data\": {\"series\": [{\"name\": \"Year\", \"type\": \"dimension\", \"values\": [\"2023\", \"2023\", \"2023\", \"2023\", \"2023\"]}, {\"name\": \"Domain\", \"type\": \"dimension\", \"values\": [\"old-bookmark-c.db\", \"old-bookmark-a.db\", \"old-bookmark-b.db\", \"old-bookmark-no-name.db\", \"new-bookmark-d.db\"]}, {\"name\": \"Count\", \"type\": \"measure\", \"values\": [1, 1, 1, 1, 1]}]}, \"slides\": [[{\"config\": {\"channels\": {\"x\": \"Count\", \"y\": \"Domain\", \"color\": \"Domain\", \"label\": \"Count\"}, \"sort\": \"byValue\", \"title\": \"Top 10 domains 2023 - 2023\"}, \"filter\": record => { return (record['Year'] == '2023') }, \"style\": {\"plot\": {\"paddingLeft\": 250}}}]]};\n",
       "            // story.set_size()\n",
       "            \n",
       "            vp.slides = vizzuPlayerData;\n",
       "            vp.initializing.then(chart => {\n",
       "                // story.set_feature()\n",
       "                \n",
       "                // story.add_event()\n",
       "                \n",
       "            });\n",
       "        });\n",
       "    </script>\n",
       "</div>\n"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# bookmark_domains\n",
    "bookmark_domains = fetch_rows(\"SELECT EXTRACT(YEAR FROM created_on)::INT AS year, url FROM bookmarks_bookmark ORDER BY year;\")\n",
    "for bookmark_domain in bookmark_domains:\n",
    "    domain = urlparse(bookmark_domain['url']).netloc\n",
    "    if domain.startswith('www.'):\n",
    "        domain = domain[4:]\n",
    "    bookmark_domain['domain'] = domain\n",
    "    del bookmark_domain['url']\n",
    "bookmark_domains = [x for x in bookmark_domains if x['domain'] != '']\n",
    "pprint('bookmark_domains:')\n",
    "pprint(bookmark_domains[:3])\n",
    "top_bookmark_domains = []\n",
    "for year in range(min_year, max_year + 1):\n",
    "    domain_counter = collections.Counter([x['domain'] for x in bookmark_domains if (x['year'] <= year if MODE == MODE_AGGREGATE else x['year'] == year)])\n",
    "    for domain, count in domain_counter.most_common(10):\n",
    "        top_bookmark_domains.append({\n",
    "            'year': year,\n",
    "            'domain': domain,\n",
    "            'count': count,\n",
    "        })\n",
    "pprint('top_bookmark_domains:')\n",
    "pprint(top_bookmark_domains[:3])\n",
    "data = Data()\n",
    "data.add_series('Year', [str(x['year']) for x in top_bookmark_domains], type='dimension')\n",
    "data.add_series('Domain', [x['domain'] for x in top_bookmark_domains], type='dimension')\n",
    "data.add_series('Count', [x['count'] for x in top_bookmark_domains], type='measure')\n",
    "story = Story(data=data)\n",
    "for year in range(min_year, max_year + 1):\n",
    "    slide = Slide(\n",
    "        Step(\n",
    "            Config({\n",
    "                'channels': {\n",
    "                    'x': 'Count',\n",
    "                    'y': 'Domain',\n",
    "                    'color': 'Domain',\n",
    "                    'label': 'Count',\n",
    "                },\n",
    "                'sort': 'byValue',\n",
    "                'title': f'Top 10 domains {min_year} - {year}' if MODE == MODE_AGGREGATE else f'Top 10 domains {year}',\n",
    "            }),\n",
    "            Data.filter(f\"record['Year'] == '{year}'\"),\n",
    "            Style({\n",
    "                'plot': {'paddingLeft': 250},\n",
    "            }),\n",
    "        ),\n",
    "    )\n",
    "    story.add_slide(slide)\n",
    "story.play()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "8e135118-3d31-4f97-9eed-fc973db699bf",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "'bookmark_labels:'\n",
      "[{'label': 'new folder d', 'year': 2023},\n",
      " {'label': 'new folder e', 'year': 2023},\n",
      " {'label': 'old folder a', 'year': 2023}]\n",
      "'top_bookmark_labels:'\n",
      "[{'count': 2, 'label': 'old folder a', 'year': 2023},\n",
      " {'count': 1, 'label': 'new folder d', 'year': 2023},\n",
      " {'count': 1, 'label': 'new folder e', 'year': 2023}]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "\n",
       "<div>\n",
       "    <vizzu-player id=\"3fe8ed2\"   controller></vizzu-player>\n",
       "    <script type=\"module\">\n",
       "        import VizzuPlayer from \"https://cdn.jsdelivr.net/npm/vizzu-story@0.4/dist/vizzu-story.min.js\";\n",
       "\n",
       "        const vp = document.getElementById(\"3fe8ed2\");\n",
       "        import(vp.vizzuUrl).then(vizzuLoaded => {\n",
       "            const lib = vizzuLoaded.default;\n",
       "            const vizzuPlayerData = {\"data\": {\"series\": [{\"name\": \"Year\", \"type\": \"dimension\", \"values\": [\"2023\", \"2023\", \"2023\", \"2023\", \"2023\"]}, {\"name\": \"Label\", \"type\": \"dimension\", \"values\": [\"old folder a\", \"new folder d\", \"new folder e\", \"old folder b\", \"old sub-folder c\"]}, {\"name\": \"Count\", \"type\": \"measure\", \"values\": [2, 1, 1, 1, 1]}]}, \"slides\": [[{\"config\": {\"channels\": {\"x\": \"Count\", \"y\": \"Label\", \"color\": \"Label\", \"label\": \"Count\"}, \"sort\": \"byValue\", \"title\": \"Top 10 labels 2023 - 2023\"}, \"filter\": record => { return (record['Year'] == '2023') }, \"style\": {\"plot\": {\"paddingLeft\": 250}}}]]};\n",
       "            // story.set_size()\n",
       "            \n",
       "            vp.slides = vizzuPlayerData;\n",
       "            vp.initializing.then(chart => {\n",
       "                // story.set_feature()\n",
       "                \n",
       "                // story.add_event()\n",
       "                \n",
       "            });\n",
       "        });\n",
       "    </script>\n",
       "</div>\n"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# bookmark_labels\n",
    "bookmark_labels = fetch_rows(\"SELECT EXTRACT(YEAR FROM b.created_on)::INT AS year, LOWER(l.name) AS label FROM bookmarks_bookmark b JOIN bookmarks_bookmark_labels bl ON b.id = bl.bookmark_id JOIN bookmarks_label l ON l.id = bl.label_id WHERE lower(l.name) != 'bookmarks bar' ORDER BY year, label;\")\n",
    "pprint('bookmark_labels:')\n",
    "pprint(bookmark_labels[:3])\n",
    "top_bookmark_labels = []\n",
    "for year in range(min_year, max_year + 1):\n",
    "    label_counter = collections.Counter([x['label'] for x in bookmark_labels if (x['year'] <= year if MODE == MODE_AGGREGATE else x['year'] == year)])\n",
    "    for label, count in label_counter.most_common(10):\n",
    "        top_bookmark_labels.append({\n",
    "            'year': year,\n",
    "            'label': label,\n",
    "            'count': count,\n",
    "        })\n",
    "pprint('top_bookmark_labels:')\n",
    "pprint(top_bookmark_labels[:3])\n",
    "data = Data()\n",
    "data.add_series('Year', [str(x['year']) for x in top_bookmark_labels], type='dimension')\n",
    "data.add_series('Label', [x['label'] for x in top_bookmark_labels], type='dimension')\n",
    "data.add_series('Count', [x['count'] for x in top_bookmark_labels], type='measure')\n",
    "story = Story(data=data)\n",
    "for year in range(min_year, max_year + 1):\n",
    "    slide = Slide(\n",
    "        Step(\n",
    "            Config({\n",
    "                'channels': {\n",
    "                    'x': 'Count',\n",
    "                    'y': 'Label',\n",
    "                    'color': 'Label',\n",
    "                    'label': 'Count',\n",
    "                },\n",
    "                'sort': 'byValue',\n",
    "                'title': f'Top 10 labels {min_year} - {year}' if MODE == MODE_AGGREGATE else f'Top 10 labels {year}',\n",
    "            }),\n",
    "            Data.filter(f\"record['Year'] == '{year}'\"),\n",
    "            Style({\n",
    "                'plot': {'paddingLeft': 250},\n",
    "            }),\n",
    "        ),\n",
    "    )\n",
    "    story.add_slide(slide)\n",
    "story.play()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}