past-activity-summary.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9a5f38cc",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from IPython.display import HTML, display\n",
    "from ipywidgets import interact\n",
    "\n",
    "pd.set_option(\"display.max_rows\", None)\n",
    "pd.set_option(\"display.max_columns\", None)\n",
    "pd.set_option(\"display.width\", None)\n",
    "pd.set_option(\"display.max_colwidth\", None)\n",
    "\n",
    "cols_to_print = [\"number\", \"title\", \"repository\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8a7da137",
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"github-activity.csv\")\n",
    "\n",
    "cond = [column.startswith(\"Unnamed:\") for column in df.columns]\n",
    "for column in df.columns[cond].tolist():\n",
    "    df.drop(column, axis=1, inplace=True)\n",
    "\n",
    "month_cond = [\"last_month\" in filter_name for filter_name in df[\"filter\"]]\n",
    "week_cond = [\"last_week\" in filter_name for filter_name in df[\"filter\"]]\n",
    "\n",
    "monthly_df = df[month_cond]\n",
    "monthly_df = monthly_df[monthly_df[\"state\"] == \"closed\"]\n",
    "weekly_df = df[week_cond]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ae1609da",
   "metadata": {},
   "source": [
    "# 🚀 Activity Summary\n",
    "\n",
    "## 📮 Closed in the Last Month"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ab995e70",
   "metadata": {},
   "outputs": [],
   "source": [
    "repo_names = [\"All\"] + sorted(monthly_df[\"repo_name\"].unique().tolist())\n",
    "sort_columns = [\"closed_at\", \"repo_name\"]\n",
    "\n",
    "\n",
    "@interact\n",
    "def view_monthly_summmary(\n",
    "    repo=repo_names,\n",
    "    sort=sort_columns,\n",
    "    sort_ascending=False,\n",
    "    assigned=False,\n",
    "    created=False,\n",
    "    issues=False,\n",
    "    pull_requests=False,\n",
    "):\n",
    "    if sort != \"repo_name\":\n",
    "        columns_to_print = cols_to_print + [sort]\n",
    "    else:\n",
    "        columns_to_print = cols_to_print\n",
    "\n",
    "    if repo == \"All\":\n",
    "        filtered = monthly_df.sort_values(sort, ascending=sort_ascending)\n",
    "    else:\n",
    "        filtered = monthly_df.loc[monthly_df[\"repo_name\"] == repo].sort_values(\n",
    "            sort, ascending=sort_ascending\n",
    "        )\n",
    "\n",
    "    if assigned and (not created):\n",
    "        # Only show tickets that I was assigned to\n",
    "        cond = [\"assigned\" in filter_name for filter_name in monthly_df[\"filter\"]]\n",
    "        filtered = filtered[cond]\n",
    "    elif (not assigned) and created:\n",
    "        # Only show tickets that I created\n",
    "        cond = [\"created\" in filter_name for filter_name in monthly_df[\"filter\"]]\n",
    "        filtered = filtered[cond]\n",
    "    else:\n",
    "        # No change. Show everything.\n",
    "        pass\n",
    "\n",
    "    if issues and (not pull_requests):\n",
    "        filtered = filtered[filtered[\"pull_request\"] == False]\n",
    "    elif (not issues) and pull_requests:\n",
    "        filtered = filtered[filtered[\"pull_request\"] == True]\n",
    "    else:\n",
    "        # No change. Show everything.\n",
    "        pass\n",
    "\n",
    "    print(f\"Total: {len(filtered[columns_to_print])}\")\n",
    "    display(HTML(filtered[columns_to_print].to_html(escape=False)))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e4f7034c",
   "metadata": {},
   "source": [
    "## ✅ Activity in the Last Week"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c1560cd5",
   "metadata": {},
   "outputs": [],
   "source": [
    "repo_names = [\"All\"] + sorted(weekly_df[\"repo_name\"].unique().tolist())\n",
    "sort_columns = [\"created_at\", \"updated_at\", \"repo_name\"]\n",
    "\n",
    "\n",
    "@interact\n",
    "def view_weekly_summmary(\n",
    "    repo=repo_names,\n",
    "    sort=sort_columns,\n",
    "    sort_ascending=False,\n",
    "    assigned=False,\n",
    "    created=False,\n",
    "    issues=False,\n",
    "    pull_requests=False,\n",
    "):\n",
    "    if sort != \"repo_name\":\n",
    "        columns_to_print = cols_to_print + [sort]\n",
    "    else:\n",
    "        columns_to_print = cols_to_print\n",
    "\n",
    "    if repo == \"All\":\n",
    "        filtered = weekly_df.sort_values(sort, ascending=sort_ascending)\n",
    "    else:\n",
    "        filtered = weekly_df.loc[weekly_df[\"repo_name\"] == repo].sort_values(\n",
    "            sort, ascending=sort_ascending\n",
    "        )\n",
    "\n",
    "    if assigned and (not created):\n",
    "        # Only show tickets that I was assigned to\n",
    "        cond = [\"assigned\" in filter_name for filter_name in weekly_df[\"filter\"]]\n",
    "        filtered = filtered[cond]\n",
    "    elif (not assigned) and created:\n",
    "        # Only show tickets that I created\n",
    "        cond = [\"created\" in filter_name for filter_name in weekly_df[\"filter\"]]\n",
    "        filtered = filtered[cond]\n",
    "    else:\n",
    "        # No change. Show everything.\n",
    "        pass\n",
    "\n",
    "    if issues and (not pull_requests):\n",
    "        filtered = filtered[filtered[\"pull_request\"] == False]\n",
    "    elif (not issues) and pull_requests:\n",
    "        filtered = filtered[filtered[\"pull_request\"] == True]\n",
    "    else:\n",
    "        # No change. Show everything.\n",
    "        pass\n",
    "\n",
    "    filtered.dropna(inplace=True)\n",
    "\n",
    "    print(f\"Total: {len(filtered[columns_to_print])}\")\n",
    "    display(HTML(filtered[columns_to_print].to_html(escape=False)))"
   ]
  }
 ],
 "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}