Notebooks/Spark.NET C#/Tweets/02_TweetAnalysis_Analysis.ipynb

{
  "metadata": {
    "description": "Notebook to show some interesting Analysis and visualization over Mentions and Topics.",
    "saveOutput": true,
    "language_info": {
      "name": "csharp"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 2,
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {},
      "source": [
        "# TweetAnalysis - Data Analysis\n",
        "\n",
        "This Spark .NET notebook shows how you can use .NET for Spark and the .NET notebook experience to analyze data.\n",
        "\n",
        "The data to be analyzed has been previously prepared into the Spark tables `Topics` and `Mentions` in the `TweetAnalysis` database.\n",
        ""
      ],
      "attachments": {}
    },
    {
      "cell_type": "markdown",
      "metadata": {},
      "source": [
        "## This notebook gives us interactive C#!"
      ],
      "attachments": {}
    },
    {
      "cell_type": "code",
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": "<table><thead><tr><th><i>index</i></th><th>value</th></tr></thead><tbody><tr><td>0</td><td>a</td></tr><tr><td>1</td><td>b</td></tr><tr><td>2</td><td>c</td></tr></tbody></table>"
          },
          "execution_count": 4,
          "metadata": {}
        }
      ],
      "metadata": {},
      "source": [
        "\"a b c\".Split(' ')"
      ],
      "attachments": {}
    },
    {
      "cell_type": "markdown",
      "metadata": {},
      "source": [
        "## Show daily count of distinct authors and overall daily count of how often a topic has been tagged\n",
        "Using .NET for Spark's C# methods."
      ],
      "attachments": {}
    },
    {
      "cell_type": "code",
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": "+------------+----------+-----+-----------------+\n|       topic|      date|count|dist_author_count|\n+------------+----------+-----+-----------------+\n| sqlsatparis|05/09/2015|  128|               10|\n|   sqlsat109|03/03/2012|  100|                2|\n|     jss2014|02/12/2014|   85|               18|\n|     jss2014|01/12/2014|   48|               13|\n|   hackfort2|26/03/2015|   47|                3|\n|hadoopsummit|26/06/2013|   46|                1|\n|  strataconf|29/02/2012|   45|                2|\n|     sqlpass|13/10/2011|   38|                2|\n|  mstechdays| 11/2/2015|   36|               12|\n|     bigdata|29/02/2012|   36|                1|\n|    sqlrally|10/05/2012|   34|                1|\n|     sqlpass|08/11/2012|   33|                5|\n|   build2015|29/04/2015|   32|               27|\n|     jss2013|03/12/2013|   31|               10|\n|  mstechdays| 12/2/2014|   28|               13|\n|     sql2012|07/03/2012|   27|                2|\n| sqlsatparis|13/09/2014|   26|               10|\n|  mstechdays|13/02/2014|   25|               10|\n|     sqlpass|12/10/2011|   25|                2|\n|   sqlserver|03/03/2012|   25|                2|\n+------------+----------+-----+-----------------+\nonly showing top 20 rows"
          },
          "execution_count": 3,
          "metadata": {}
        }
      ],
      "metadata": {},
      "source": [
        "var topics = spark.Table(\"buildtweetanalysis.Topics\");\n",
        "\n",
        "topics.GroupBy(Lower(Col(\"topic\")).As(\"topic\"), Col(\"date\"))\n",
        "      .Agg(Count(\"author\").As(\"count\"), CountDistinct(\"author\").As(\"dist_author_count\"))\n",
        "      .OrderBy(Desc(\"count\")).Show();"
      ],
      "attachments": {}
    },
    {
      "cell_type": "markdown",
      "metadata": {},
      "source": [
        "## .NET based notebooks can do cool visualizations too!\n",
        ""
      ],
      "attachments": {}
    },
    {
      "cell_type": "markdown",
      "metadata": {},
      "source": [
        "### Show Michael's top 5 quarterly tweet topics in bar chart format\n",
        "First show the data in raw form and with the custom DataFrame formatter"
      ],
      "attachments": {}
    },
    {
      "cell_type": "code",
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": "+------------+----------------+-----------+\n|year_quarter|           topic|topic_count|\n+------------+----------------+-----------+\n|    2010 - 4|         spatial|          2|\n|    2010 - 4|          denali|          2|\n|    2010 - 4|       sqlserver|          3|\n|    2010 - 4|         sqlpass|         13|\n|    2010 - 4|       filetable|          3|\n|    2011 - 1|           azure|          1|\n|    2011 - 1|             w2e|          4|\n|    2011 - 1|       webmatrix|          1|\n|    2011 - 1|        bizspark|          1|\n|    2011 - 2|        sqlazure|          2|\n|    2011 - 2|           nosql|          2|\n|    2011 - 2|beyondrelational|          5|\n|    2011 - 2|       sqlserver|          5|\n|    2011 - 2|        msteched|          7|\n|    2011 - 3|        sqlazure|          3|\n|    2011 - 3|        nosqlnow|         24|\n|    2011 - 3|           nosql|          4|\n|    2011 - 3|       sqlserver|          4|\n|    2011 - 3|          hadoop|          3|\n|    2011 - 4|       sqlserver|          9|\n+------------+----------------+-----------+\nonly showing top 20 rows"
          },
          "execution_count": 11,
          "metadata": {}
        }
      ],
      "metadata": {},
      "source": [
        "var michaels_top_5_quarterly_topics = spark.Sql(@\"\n",
        "    WITH michaels_topics_raw AS (SELECT TO_DATE(date,'dd/M/yyyy') AS date, topic FROM BuildTweetAnalysis.Topics WHERE author = 'MikeDoesBigData')\n",
        "    ,    michaels_topics AS (SELECT YEAR(date) AS year, QUARTER(date) AS quarter, topic FROM michaels_topics_raw )\n",
        "    ,    michaels_quarterly_topic_count AS (SELECT year, quarter, LOWER(topic) AS topic, COUNT(topic) AS topic_count FROM michaels_topics GROUP BY year, quarter, LOWER(topic))\n",
        "    ,    all_michaels_topics_ranked_by_quarter AS (SELECT year, quarter, topic, topic_count, ROW_NUMBER () OVER (PARTITION BY year, quarter ORDER BY topic_count DESC) AS quarterly_rank FROM michaels_quarterly_topic_count)\n",
        "    SELECT CONCAT(year, ' - ', quarter) AS year_quarter, topic, topic_count FROM all_michaels_topics_ranked_by_quarter WHERE quarterly_rank < 6\n",
        "    \")\n",
        "    .OrderBy(Col(\"year_quarter\"));\n",
        "    \n",
        "michaels_top_5_quarterly_topics.Show();\n",
        ""
      ],
      "attachments": {}
    },
    {
      "cell_type": "markdown",
      "metadata": {},
      "source": [
        "Now let's use the Plotly library to generate an interesting bar chart visualization of the data "
      ],
      "attachments": {}
    },
    {
      "cell_type": "code",
      "execution_count": 12,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": "<div id=\"bedc6374-cb70-4a98-a338-76238dc1d21f\" style=\"width: 1400px; height: 1000px;\"></div>\r\n<script type=\"text/javascript\">\n\r\nvar renderPlotly = function() {\r\n    var xplotRequire = requirejs.config({context:'xplot-3.0.1',paths:{plotly:'https://cdn.plot.ly/plotly-1.49.2.min'}});\r\n    xplotRequire(['plotly'], function(Plotly) {\n\n            var data = [{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,13,null,null,null,39,null,null,2,6,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"sqlpass\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,3,null,5,4,9,null,7,2,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"sqlserver\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"filetable\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,2,null,null,null,3,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"spatial\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"denali\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"w2e\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"webmatrix\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,1,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,2,14,4,null,5,null,null,null,3,4,5,2,null,null,null,null,null,null,null,null,null,null],\"name\":\"azure\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"bizspark\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,7,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"msteched\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,5,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"beyondrelational\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,2,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"sqlazure\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,2,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"nosql\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"nosqlnow\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"hadoop\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,6,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"xquery\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,6,11,5,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"sql2012\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"sqlbits\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"sqlsat109\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"sqlserver2012\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"strataconf\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,5,null,null,1,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"seascale\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"24hop\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"semanticsearch\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"geospatial\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"townhall\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"hdinsight\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"bigdata\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"spacecurve\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"hbase\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,27,28,36,54,38,29,32,27,20,8,null,null,1,null,null,null,null,null,null,null],\"name\":\"usql\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,24,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"u-sql\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"scope\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,3,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"datalake\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"summit15\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,10,null,10,11,12,15,17,14,6,null,null,null,null,null,null,null,null,null,null],\"name\":\"azuredatalake\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"dataexposed\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,null,null],\"name\":\"msignite\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"msdatasciencesummit\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"msftconnect\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"sqlsummit\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"tsql\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"datawarehouse\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"sqlkonferenz\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,4,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"python\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"bigcognition\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"datafactory\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,4,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"r\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null],\"name\":\"adls\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null],\"name\":\"json\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null],\"name\":\"federatedquery\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null],\"name\":\"adla\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null],\"name\":\"adlsgen1\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,4,null,null,null,2,null,null],\"name\":\"dotnet\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,10,2,5,null,null],\"name\":\"dotnetforspark\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,null,1,null,null,null],\"name\":\"apachespark\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null],\"name\":\"sparkaisummit\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,3,null,null],\"name\":\"msbuild\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,1,4,null,null],\"name\":\"azuresynapse\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null],\"name\":\"azuresynapseanalytics\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null],\"name\":\"msignite2019\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null],\"name\":\"hdinsight…\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null],\"name\":\"azuredatabricks\"},{\"type\":\"bar\",\"x\":[\"2010 - 1\",\"2010 - 2\",\"2010 - 3\",\"2010 - 4\",\"2011 - 1\",\"2011 - 2\",\"2011 - 3\",\"2011 - 4\",\"2012 - 1\",\"2012 - 2\",\"2012 - 3\",\"2012 - 4\",\"2013 - 1\",\"2013 - 2\",\"2013 - 3\",\"2013 - 4\",\"2014 - 1\",\"2014 - 2\",\"2014 - 3\",\"2014 - 4\",\"2015 - 1\",\"2015 - 2\",\"2015 - 3\",\"2015 - 4\",\"2016 - 1\",\"2016 - 2\",\"2016 - 3\",\"2016 - 4\",\"2017 - 1\",\"2017 - 2\",\"2017 - 3\",\"2017 - 4\",\"2018 - 1\",\"2018 - 2\",\"2018 - 3\",\"2018 - 4\",\"2019 - 1\",\"2019 - 2\",\"2019 - 3\",\"2019 - 4\",\"2020 - 1\",\"2020 - 2\",\"2020 - 3\",\"2020 - 4\"],\"y\":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null],\"name\":\"azure…\"}];\n            var layout = {\"title\":\"Michael's Quarterly Top Tweet Topics\",\"xaxis\":{\"title\":\"Yearly Quarters\",\"_isSubplotObj\":true},\"yaxis\":{\"title\":\"Number of Topic Mentions\",\"_isSubplotObj\":true},\"barmode\":\"stack\"};\n            Plotly.newPlot('bedc6374-cb70-4a98-a338-76238dc1d21f', data, layout);\n        \n});\r\n};\r\nif ((typeof(requirejs) !==  typeof(Function)) || (typeof(requirejs.config) !== typeof(Function))) { \r\n    var script = document.createElement(\"script\"); \r\n    script.setAttribute(\"src\", \"https://cdnjs.cloudflare.com/ajax/libs/require.js/2.3.6/require.min.js\"); \r\n    script.onload = function(){\r\n        renderPlotly();\r\n    };\r\n    document.getElementsByTagName(\"head\")[0].appendChild(script); \r\n}\r\nelse {\r\n    renderPlotly();\r\n}\n</script>\n"
          },
          "execution_count": 12,
          "metadata": {}
        }
      ],
      "metadata": {},
      "source": [
        "using XPlot.Plotly;\n",
        "\n",
        "// Prepare the Bar Charts\n",
        "var barlist = new List<Graph.Bar>();\n",
        "\n",
        "//Create the full quarter range to provide a complete and ordered X-axis\n",
        "var fullrange = Enumerable.Range(2010,11).SelectMany(y=>Enumerable.Range(1,4),  (y,q) => $\"{y} - {q}\");\n",
        "\n",
        "// Transform the Spark DataFrame into a .NET IEnumerable to avoid hitting the Spark cluster more than once\n",
        "var topics_table = michaels_top_5_quarterly_topics.Collect().ToArray()\n",
        "                   .Select(x=>new {topic = x.GetAs<string>(\"topic\"), yq = x.GetAs<string>(\"year_quarter\"), cnt = x.GetAs<int>(\"topic_count\")});\n",
        "\n",
        "// Add one Bar Chart per topic\n",
        "foreach (var topic in topics_table.Select(x=>x.topic).Distinct()) \n",
        "{\n",
        "   // Get the data for the specific topic. Join the full range to fill in the missing quarters\n",
        "   var partialdata = topics_table.Where(x=>x.topic==topic).Select(x => new {x.yq, x.cnt});\n",
        "   var data = from q in fullrange\n",
        "          join entry in partialdata on q equals entry.yq into gj\n",
        "          from subq in gj.DefaultIfEmpty()\n",
        "          select new { q, cnt = subq?.cnt };\n",
        "\n",
        "   // The following assumes that LINQ will preserve the order and thus correlation of the values. Otherwise additional code to guarantee the correlation is needed.\n",
        "   var arr_year_quarter = data.Select(x=>x.q); \n",
        "   var arr_topic_count = data.Select(x=>x.cnt); \n",
        "  \n",
        "   var bar = new Graph.Bar\n",
        "   {\n",
        "     name = topic,\n",
        "     x = arr_year_quarter,\n",
        "     y = arr_topic_count\n",
        "   };\n",
        "   barlist.Add(bar);\n",
        "}\n",
        "\n",
        "var layout = new XPlot.Plotly.Layout.Layout{barmode=\"stack\", title=\"Michael's Quarterly Top Tweet Topics\"};\n",
        "var chart = Chart.Plot(barlist);\n",
        "chart.WithLayout(layout);\n",
        "chart.WithHeight(1000);\n",
        "chart.WithWidth(1400);\n",
        "chart.WithXTitle(\"Yearly Quarters\");\n",
        "chart.WithYTitle(\"Number of Topic Mentions\");\n",
        "chart"
      ],
      "attachments": {}
    },
    {
      "cell_type": "code",
      "execution_count": 8,
      "outputs": [],
      "metadata": {},
      "source": [
        "// Run this if you need to refresh the Spark Table cache when the tables got recreated\n",
        "//spark.Sql(\"REFRESH TABLE BuildTweetAnalysis.Topics\");\n",
        "//spark.Sql(\"REFRESH TABLE BuildTweetAnalysis.Mentions\");"
      ],
      "attachments": {}
    }
  ]
}