more pythonic answer

cconw · web-flow · commit ddddabb423f3 · 2017-05-14T10:48:26.000-05:00
more pythonic answer to guipsamora#8. uses .resample method.
diff --git a/04_Apply/US_Crime_Rates/Exercises_with_solutions.ipynb b/04_Apply/US_Crime_Rates/Exercises_with_solutions.ipynb
@@ -720,21 +720,10 @@
    ],
    "source": [
     "# select the first two columns from the origional dataset\n",
-    "population = crime.iloc[:, 0:1]\n",
-    "\n",
-    "# change the index for decades\n",
-    "population.index = (population.index.year//10)*10\n",
-    "\n",
-    "# group the index by decades and selecting the max value from the Population column \n",
-    "population1 = population.groupby(population.index).max()\n",
-    "population1\n",
-    "\n",
-    "# group the dataframe by decades and sum all values, including population\n",
-    "crime = crime.groupby((crime.index.year//10)*10).sum()\n",
-    "\n",
-    "# assing the right population value (max value) to the \n",
-    "crime['Population'] = population1['Population']\n",
-    "crime"
+    "crimes = crime.resample('10AS').sum()\n",
+    "population = crime['Population'].resample('10AS').max()\n",
+    "crimes['Population'] = population\n",
+    "crimes"
    ]
   },
   {
