Add ability to exclude milestones to allow focus on bigger ones

[dotfiles.git] / data / issues.ipynb

diff --git a/data/issues.ipynb b/data/issues.ipynb
index 3340aaf7fa1346863cb8dd42e539c3eb0c4719e5..011beec2ea3144c44dfd250c94619c3e28411f66 100644 (file)
--- a/data/issues.ipynb
+++ b/data/issues.ipynb
@@ -2,17 +2,9 @@
  "cells": [
   {
    "cell_type": "code",
  "cells": [
   {
    "cell_type": "code",

-   "execution_count": 5,
+   "execution_count": null,

    "metadata": {},
    "metadata": {},

-   "outputs": [
-    {
-     "name": "stdout",
-     "output_type": "stream",
-     "text": [
-      "3.12.2\n"
-     ]
-    }
-   ],
+   "outputs": [],

    "source": [
     "import platform\n",
     "print(platform.python_version())"
    "source": [
     "import platform\n",
     "print(platform.python_version())"


@@ -20,7 +12,7 @@
   },
   {
    "cell_type": "code",
   },
   {
    "cell_type": "code",

-   "execution_count": 92,
+   "execution_count": null,

    "metadata": {},
    "outputs": [],
    "source": [
    "metadata": {},
    "outputs": [],
    "source": [


@@ -53,7 +45,7 @@
     "\n",
     "data_sets = []\n",
     "\n",
     "\n",
     "data_sets = []\n",
     "\n",

-    "file = data_files[6]\n",
+    "file = data_files[2]\n",

     "print(file)\n",
     "\n",
     "f = open(file, encoding='utf-8')\n",
     "print(file)\n",
     "\n",
     "f = open(file, encoding='utf-8')\n",


@@ -62,7 +54,7 @@
   },
   {
    "cell_type": "code",
   },
   {
    "cell_type": "code",

-   "execution_count": 94,
+   "execution_count": null,

    "metadata": {},
    "outputs": [],
    "source": [
    "metadata": {},
    "outputs": [],
    "source": [


@@ -73,17 +65,18 @@
   },
   {
    "cell_type": "code",
   },
   {
    "cell_type": "code",

-   "execution_count": 95,
+   "execution_count": null,

    "metadata": {},
    "outputs": [],
    "source": [
     "closed_months = pd.to_datetime(df['closedAt'], format='ISO8601')\n",
    "metadata": {},
    "outputs": [],
    "source": [
     "closed_months = pd.to_datetime(df['closedAt'], format='ISO8601')\n",

-    "df['closed_month'] = closed_months.dt.month"
+    "df['closed_month'] = closed_months.dt.month\n",
+    "df.drop(columns=['closedAt'], inplace=True)"

    ]
   },
   {
    "cell_type": "code",
    ]
   },
   {
    "cell_type": "code",

-   "execution_count": 97,
+   "execution_count": null,

    "metadata": {},
    "outputs": [],
    "source": [
    "metadata": {},
    "outputs": [],
    "source": [


@@ -92,12 +85,13 @@
   },
   {
    "cell_type": "code",
   },
   {
    "cell_type": "code",

-   "execution_count": 98,
+   "execution_count": null,

    "metadata": {},
    "outputs": [],
    "source": [
     "\n",
    "metadata": {},
    "outputs": [],
    "source": [
     "\n",

-    "grp_df = df.groupby(['mile', 'closed_month']).count().reset_index()"
+    "dfg = df.groupby(['mile', 'closed_month']).count().reset_index()\n",
+    "dfg.drop(columns=['milestone', 'title', 'url'], inplace=True)\n"

    ]
   },
   {
    ]
   },
   {


@@ -106,7 +100,8 @@
    "metadata": {},
    "outputs": [],
    "source": [
    "metadata": {},
    "outputs": [],
    "source": [

-    "print(grp_df)"
+    "\n",
+    "print(dfg)"

    ]
   },
   {
    ]
   },
   {


@@ -118,7 +113,20 @@
   },
   {
    "cell_type": "code",
   },
   {
    "cell_type": "code",

-   "execution_count": 99,
+   "execution_count": 32,
+   "metadata": {},
+   "outputs": [],
+   "source": [
+    "exclude_from_chart = [\n",
+    "\t'Job Aid Ideas']\n",
+    "\n",
+    "for ex in exclude_from_chart:\n",
+    "\tdfg = dfg[dfg['mile'] != ex]\n"
+   ]
+  },
+  {
+   "cell_type": "code",
+   "execution_count": null,

    "metadata": {},
    "outputs": [],
    "source": [
    "metadata": {},
    "outputs": [],
    "source": [


@@ -134,7 +142,7 @@
    "outputs": [],
    "source": [
     "plt.figure(figsize=(10, 6))\n",
    "outputs": [],
    "source": [
     "plt.figure(figsize=(10, 6))\n",

-    "sns.lineplot(x='closed_month', y='url', hue='mile', data=grp_df, marker='o', ci=None)\n",
+    "sns.barplot(x='closed_month', y='count', hue='mile', data=dfg)\n",

     "plt.xlabel('Closed Month')\n",
     "plt.ylabel('ClosedAt')\n",
     "plt.title('Stacked Line Chart: Milestone Effort by Issue Close Date')\n",
     "plt.xlabel('Closed Month')\n",
     "plt.ylabel('ClosedAt')\n",
     "plt.title('Stacked Line Chart: Milestone Effort by Issue Close Date')\n",