CekatanBiz.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "gpuType": "T4"
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    },
    "accelerator": "GPU"
  },
  "cells": [
    {
      "cell_type": "code",
      "execution_count": 4,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "xXS_6QlZUkYI",
        "outputId": "ba842fcf-d307-47c5-b38e-aeef4c3b7740"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "\u001b[31mERROR: Could not find a version that satisfies the requirement odoo (from versions: none)\u001b[0m\u001b[31m\n",
            "\u001b[0m\u001b[31mERROR: No matching distribution found for odoo\u001b[0m\u001b[31m\n",
            "\u001b[0m"
          ]
        }
      ],
      "source": [
        "pip install odoo"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from pyspark.sql import SparkSession\n",
        "from pyspark.sql.functions import col\n",
        "#from odoo import models, fields, api\n",
        "import plotly.express as px\n",
        "\n",
        "class Menu():\n",
        "    @staticmethod\n",
        "    def MenuCekBiz():\n",
        "        print(\"Menu CekatanBiz:\\n\")\n",
        "        print(\"1. Data Analyst PySpark\")\n",
        "        #print(\"2. Data Analyst Odoo\")\n",
        "        print(\"2. Business Analyst PySpark\")\n",
        "        print(\"3. Business Intelligence PySpark\")\n",
        "        #print(\"5. Business Analyst Odoo\")\n",
        "        #print(\"6. Business Intelligence Odoo\")\n",
        "\n",
        "class DAPySpark():\n",
        "    @staticmethod\n",
        "    def DatAnPS():\n",
        "        print(\"You choose Data Analyst PySpark ^-^\")\n",
        "        # Create App\n",
        "        createapp = SparkSession.builder.appName(\"Data_Analayst_PySpark\").getOrCreate()\n",
        "        print(\"Sucessfull Created App!\")\n",
        "        print(createapp)\n",
        "\n",
        "        # Data File CSV\n",
        "        datafile = createapp.read.csv(\"climate_change_indicators.csv\", header=True, inferSchema=True)\n",
        "        datafile.show()\n",
        "        datafile.printSchema()\n",
        "        print(\"Number of rows:\", datafile.count())\n",
        "        print(\"Columns:\", len(datafile.columns))\n",
        "        datafile.describe().show()\n",
        "\n",
        "        createapp.stop()\n",
        "\n",
        "#class DAOdoo(models.Model):\n",
        " #   _name = 'data.analyst.odoo'\n",
        "\n",
        "  #  name = fields.Char(string='Name')\n",
        "   # data = fields.Text(string='Data')\n",
        "#    result = fields.Text(string='Result', readonly=True)\n",
        "\n",
        " #   @api.multi\n",
        "  #  def DAnOd(self):\n",
        "   #     print(\"You Chosse Data Analyst Odoo ^-^\")\n",
        "        # Implement your data analysis logic here\n",
        "        # For example, let's say we just reverse the data\n",
        "    #    for record in self:\n",
        "     #       record.result = record.data[::-1]\n",
        "\n",
        "      #  return True\n",
        "\n",
        "class BAPySpark:\n",
        "    def BAnPS(self):\n",
        "        # Inisialisasi SparkSession\n",
        "        print(\"You Chosse Business Analyst PySpark ^-^\")\n",
        "        spark = SparkSession.builder \\\n",
        "            .appName(\"Business Analyst PySpark\") \\\n",
        "            .getOrCreate()\n",
        "\n",
        "        # Buat DataFrame dengan data contoh\n",
        "        data = [(\"John\", \"Doe\", 25, \"Sales\", 50000),\n",
        "                (\"Jane\", \"Smith\", 30, \"Marketing\", 60000),\n",
        "                (\"Tom\", \"Brown\", 35, \"IT\", 75000)]\n",
        "        columns = [\"first_name\", \"last_name\", \"age\", \"department\", \"salary\"]\n",
        "        df = spark.createDataFrame(data, columns)\n",
        "\n",
        "        # Tampilkan data\n",
        "        print(\"Dataframe:\")\n",
        "        df.show()\n",
        "\n",
        "        # Analisis sederhana menggunakan PySpark\n",
        "        print(\"Summary:\")\n",
        "        df_summary = df.groupBy(\"department\").agg({\"salary\": \"avg\", \"age\": \"max\"})\n",
        "        df_summary.show()\n",
        "\n",
        "        # Penghentian SparkSession\n",
        "        spark.stop()\n",
        "\n",
        "class BIPySpark:\n",
        "    def BInPS():\n",
        "        print(\"You Chosse Business Intelligence PySpark ^-^\")\n",
        "        # Inisialisasi SparkSession\n",
        "        spark = SparkSession.builder \\\n",
        "            .appName(\"Business Intelligence PySpark\") \\\n",
        "            .getOrCreate()\n",
        "\n",
        "        # Buat DataFrame dengan data contoh\n",
        "        data = [(\"John\", \"Doe\", 25, \"Sales\", 50000),\n",
        "                (\"Jane\", \"Smith\", 30, \"Marketing\", 60000),\n",
        "                (\"Tom\", \"Brown\", 35, \"IT\", 75000)]\n",
        "        columns = [\"first_name\", \"last_name\", \"age\", \"department\", \"salary\"]\n",
        "        df = spark.createDataFrame(data, columns)\n",
        "\n",
        "        # Tampilkan data\n",
        "        print(\"Dataframe:\")\n",
        "        df.show()\n",
        "\n",
        "        # Analisis sederhana menggunakan PySpark\n",
        "        print(\"Summary:\")\n",
        "        df_summary = df.groupBy(\"department\").agg({\"salary\": \"avg\", \"age\": \"max\"})\n",
        "        df_summary.show()\n",
        "\n",
        "        # Visualisasi menggunakan Plotly\n",
        "        fig = px.bar(df_summary.toPandas(), x='department', y='avg(salary)', title='Average Salary by Department')\n",
        "        fig.show()\n",
        "\n",
        "        # Penghentian SparkSession\n",
        "        spark.stop()\n",
        "\n",
        "#class BAOdoo(models.Model):\n",
        " #   _name = 'business.analysis'\n",
        "  #  _description = 'Business Analysis'\n",
        "\n",
        "   # name = fields.Char(string='Name', required=True)\n",
        "    #revenue = fields.Float(string='Revenue', required=True)\n",
        "    #expenses = fields.Float(string='Expenses', required=True)\n",
        "\n",
        "    #@api.depends('revenue', 'expenses')\n",
        "    #def BAnOd(self):\n",
        "     #   print(\"You Chosse Business Analyst Odoo ^-^\")\n",
        "\n",
        "      #  for record in self:\n",
        "        #  record.profit = record.revenue - record.expenses\n",
        "       #     profit = fields.Float(string='Profit', compute='BAnOd', store=True)\n",
        "\n",
        "    #def action_view_profit_report(self):\n",
        "        # Contoh logika untuk melihat laporan profit\n",
        "     #   pass\n",
        "\n",
        "#class BIOdoo(models.Model):\n",
        " #   _name = 'business.intelligence'\n",
        "  #  _description = 'Business Intelligence'\n",
        "\n",
        "   # name = fields.Char(string='Name', required=True)\n",
        "    #revenue = fields.Float(string='Revenue', required=True)\n",
        "   # expenses = fields.Float(string='Expenses', required=True)\n",
        "\n",
        "    #@api.depends('revenue', 'expenses')\n",
        "    #def BInOd(self):\n",
        "     #   print(\"You Chosse Business Intelligence Odoo ^-^\")\n",
        "      #  for record in self:\n",
        "      #      record.profit = record.revenue - record.expenses\n",
        "       #     profit = fields.Float(string='Profit', compute='BInOd', store=True)\n",
        "\n",
        "Menu.MenuCekBiz()\n",
        "\n",
        "choose = int(input(\"Please Input Number Menu: \"))\n",
        "\n",
        "if choose == 1:\n",
        "    DAPySpark.DatAnPS()\n",
        "elif choose == 2:\n",
        "    #DAOdoo.DAnOd()\n",
        "    BAPySpark().BAnPS()\n",
        "\n",
        "elif choose == 3:\n",
        "    BIPySpark.BInPS()\n",
        "\n",
        "\n",
        "#elif choose == 4:\n",
        " #   BIPySpark().BInPS()\n",
        "#elif choose == 5:\n",
        " #   BAOdoo().BAnOd()\n",
        "#elif choose == 6:\n",
        " #   BIOdoo().BInOd()\n",
        "else:\n",
        "    print(\"Sorry, number not available!\")\n",
        "    exit()\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 976
        },
        "id": "tmAnpjiPU0w8",
        "outputId": "b88770b1-481e-4611-f2f5-633a2e5dcd7b"
      },
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Menu CekatanBiz:\n",
            "\n",
            "1. Data Analyst PySpark\n",
            "2. Business Analyst PySpark\n",
            "3. Business Intelligence PySpark\n",
            "Please Input Number Menu: 3\n",
            "You Chosse Business Intelligence PySpark ^-^\n",
            "Dataframe:\n",
            "+----------+---------+---+----------+------+\n",
            "|first_name|last_name|age|department|salary|\n",
            "+----------+---------+---+----------+------+\n",
            "|      John|      Doe| 25|     Sales| 50000|\n",
            "|      Jane|    Smith| 30| Marketing| 60000|\n",
            "|       Tom|    Brown| 35|        IT| 75000|\n",
            "+----------+---------+---+----------+------+\n",
            "\n",
            "Summary:\n",
            "+----------+-----------+--------+\n",
            "|department|avg(salary)|max(age)|\n",
            "+----------+-----------+--------+\n",
            "|     Sales|    50000.0|      25|\n",
            "| Marketing|    60000.0|      30|\n",
            "|        IT|    75000.0|      35|\n",
            "+----------+-----------+--------+\n",
            "\n"
          ]
        },
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<html>\n",
              "<head><meta charset=\"utf-8\" /></head>\n",
              "<body>\n",
              "    <div>            <script src=\"https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.5/MathJax.js?config=TeX-AMS-MML_SVG\"></script><script type=\"text/javascript\">if (window.MathJax && window.MathJax.Hub && window.MathJax.Hub.Config) {window.MathJax.Hub.Config({SVG: {font: \"STIX-Web\"}});}</script>                <script type=\"text/javascript\">window.PlotlyConfig = {MathJaxConfig: 'local'};</script>\n",
              "        <script charset=\"utf-8\" src=\"https://cdn.plot.ly/plotly-2.24.1.min.js\"></script>                <div id=\"2b71f37f-bc7c-4000-8b46-3549c4955f70\" class=\"plotly-graph-div\" style=\"height:525px; width:100%;\"></div>            <script type=\"text/javascript\">                                    window.PLOTLYENV=window.PLOTLYENV || {};                                    if (document.getElementById(\"2b71f37f-bc7c-4000-8b46-3549c4955f70\")) {                    Plotly.newPlot(                        \"2b71f37f-bc7c-4000-8b46-3549c4955f70\",                        [{\"alignmentgroup\":\"True\",\"hovertemplate\":\"department=%{x}\\u003cbr\\u003eavg(salary)=%{y}\\u003cextra\\u003e\\u003c\\u002fextra\\u003e\",\"legendgroup\":\"\",\"marker\":{\"color\":\"#636efa\",\"pattern\":{\"shape\":\"\"}},\"name\":\"\",\"offsetgroup\":\"\",\"orientation\":\"v\",\"showlegend\":false,\"textposition\":\"auto\",\"x\":[\"Sales\",\"Marketing\",\"IT\"],\"xaxis\":\"x\",\"y\":[50000.0,60000.0,75000.0],\"yaxis\":\"y\",\"type\":\"bar\"}],                        {\"template\":{\"data\":{\"histogram2dcontour\":[{\"type\":\"histogram2dcontour\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"choropleth\":[{\"type\":\"choropleth\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}],\"histogram2d\":[{\"type\":\"histogram2d\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"heatmap\":[{\"type\":\"heatmap\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"heatmapgl\":[{\"type\":\"heatmapgl\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"contourcarpet\":[{\"type\":\"contourcarpet\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}],\"contour\":[{\"type\":\"contour\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"surface\":[{\"type\":\"surface\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"mesh3d\":[{\"type\":\"mesh3d\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}],\"scatter\":[{\"fillpattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2},\"type\":\"scatter\"}],\"parcoords\":[{\"type\":\"parcoords\",\"line\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatterpolargl\":[{\"type\":\"scatterpolargl\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"bar\":[{\"error_x\":{\"color\":\"#2a3f5f\"},\"error_y\":{\"color\":\"#2a3f5f\"},\"marker\":{\"line\":{\"color\":\"#E5ECF6\",\"width\":0.5},\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"bar\"}],\"scattergeo\":[{\"type\":\"scattergeo\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatterpolar\":[{\"type\":\"scatterpolar\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"histogram\":[{\"marker\":{\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"histogram\"}],\"scattergl\":[{\"type\":\"scattergl\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatter3d\":[{\"type\":\"scatter3d\",\"line\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scattermapbox\":[{\"type\":\"scattermapbox\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatterternary\":[{\"type\":\"scatterternary\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scattercarpet\":[{\"type\":\"scattercarpet\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"carpet\":[{\"aaxis\":{\"endlinecolor\":\"#2a3f5f\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"minorgridcolor\":\"white\",\"startlinecolor\":\"#2a3f5f\"},\"baxis\":{\"endlinecolor\":\"#2a3f5f\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"minorgridcolor\":\"white\",\"startlinecolor\":\"#2a3f5f\"},\"type\":\"carpet\"}],\"table\":[{\"cells\":{\"fill\":{\"color\":\"#EBF0F8\"},\"line\":{\"color\":\"white\"}},\"header\":{\"fill\":{\"color\":\"#C8D4E3\"},\"line\":{\"color\":\"white\"}},\"type\":\"table\"}],\"barpolar\":[{\"marker\":{\"line\":{\"color\":\"#E5ECF6\",\"width\":0.5},\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"barpolar\"}],\"pie\":[{\"automargin\":true,\"type\":\"pie\"}]},\"layout\":{\"autotypenumbers\":\"strict\",\"colorway\":[\"#636efa\",\"#EF553B\",\"#00cc96\",\"#ab63fa\",\"#FFA15A\",\"#19d3f3\",\"#FF6692\",\"#B6E880\",\"#FF97FF\",\"#FECB52\"],\"font\":{\"color\":\"#2a3f5f\"},\"hovermode\":\"closest\",\"hoverlabel\":{\"align\":\"left\"},\"paper_bgcolor\":\"white\",\"plot_bgcolor\":\"#E5ECF6\",\"polar\":{\"bgcolor\":\"#E5ECF6\",\"angularaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"},\"radialaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"}},\"ternary\":{\"bgcolor\":\"#E5ECF6\",\"aaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"},\"baxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"},\"caxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"}},\"coloraxis\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"colorscale\":{\"sequential\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]],\"sequentialminus\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]],\"diverging\":[[0,\"#8e0152\"],[0.1,\"#c51b7d\"],[0.2,\"#de77ae\"],[0.3,\"#f1b6da\"],[0.4,\"#fde0ef\"],[0.5,\"#f7f7f7\"],[0.6,\"#e6f5d0\"],[0.7,\"#b8e186\"],[0.8,\"#7fbc41\"],[0.9,\"#4d9221\"],[1,\"#276419\"]]},\"xaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\",\"title\":{\"standoff\":15},\"zerolinecolor\":\"white\",\"automargin\":true,\"zerolinewidth\":2},\"yaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\",\"title\":{\"standoff\":15},\"zerolinecolor\":\"white\",\"automargin\":true,\"zerolinewidth\":2},\"scene\":{\"xaxis\":{\"backgroundcolor\":\"#E5ECF6\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"white\",\"gridwidth\":2},\"yaxis\":{\"backgroundcolor\":\"#E5ECF6\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"white\",\"gridwidth\":2},\"zaxis\":{\"backgroundcolor\":\"#E5ECF6\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"white\",\"gridwidth\":2}},\"shapedefaults\":{\"line\":{\"color\":\"#2a3f5f\"}},\"annotationdefaults\":{\"arrowcolor\":\"#2a3f5f\",\"arrowhead\":0,\"arrowwidth\":1},\"geo\":{\"bgcolor\":\"white\",\"landcolor\":\"#E5ECF6\",\"subunitcolor\":\"white\",\"showland\":true,\"showlakes\":true,\"lakecolor\":\"white\"},\"title\":{\"x\":0.05},\"mapbox\":{\"style\":\"light\"}}},\"xaxis\":{\"anchor\":\"y\",\"domain\":[0.0,1.0],\"title\":{\"text\":\"department\"}},\"yaxis\":{\"anchor\":\"x\",\"domain\":[0.0,1.0],\"title\":{\"text\":\"avg(salary)\"}},\"legend\":{\"tracegroupgap\":0},\"title\":{\"text\":\"Average Salary by Department\"},\"barmode\":\"relative\"},                        {\"responsive\": true}                    ).then(function(){\n",
              "                            \n",
              "var gd = document.getElementById('2b71f37f-bc7c-4000-8b46-3549c4955f70');\n",
              "var x = new MutationObserver(function (mutations, observer) {{\n",
              "        var display = window.getComputedStyle(gd).display;\n",
              "        if (!display || display === 'none') {{\n",
              "            console.log([gd, 'removed!']);\n",
              "            Plotly.purge(gd);\n",
              "            observer.disconnect();\n",
              "        }}\n",
              "}});\n",
              "\n",
              "// Listen for the removal of the full notebook cells\n",
              "var notebookContainer = gd.closest('#notebook-container');\n",
              "if (notebookContainer) {{\n",
              "    x.observe(notebookContainer, {childList: true});\n",
              "}}\n",
              "\n",
              "// Listen for the clearing of the current output cell\n",
              "var outputEl = gd.closest('.output');\n",
              "if (outputEl) {{\n",
              "    x.observe(outputEl, {childList: true});\n",
              "}}\n",
              "\n",
              "                        })                };                            </script>        </div>\n",
              "</body>\n",
              "</html>"
            ]
          },
          "metadata": {}
        }
      ]
    }
  ]
}