"outputs": [],
"source": [
"\n",
- "grp_df = df.groupby(['mile', 'closed_month']).count().reset_index()\n",
- "grp_df.drop(columns=['milestone', 'title', 'url'], inplace=True)"
+ "dfg = df.groupby(['mile', 'closed_month']).count().reset_index()\n",
+ "dfg.drop(columns=['milestone', 'title', 'url'], inplace=True)\n"
]
},
{
"outputs": [],
"source": [
"\n",
- "print(grp_df)"
+ "print(dfg)"
]
},
{
"#### Plot of closed issues by month and milestone for one project\n"
]
},
+ {
+ "cell_type": "code",
+ "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,
"outputs": [],
"source": [
"plt.figure(figsize=(10, 6))\n",
- "sns.barplot(x='closed_month', y='url', hue='mile', data=grp_df)\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",