Merge pull request guipsamora#7 from manjunath24/improved_solutions

guipsamora · web-flow · commit baf920aaa443 · 2017-04-06T18:43:09.000-03:00
some improvements
diff --git a/03_Grouping/Regiment/Exercises_solutions.ipynb b/03_Grouping/Regiment/Exercises_solutions.ipynb
@@ -204,7 +204,7 @@
     }
    ],
    "source": [
-    "regiment = pd.DataFrame(raw_data, columns = ['regiment', 'company', 'name', 'preTestScore', 'postTestScore'])\n",
+    "regiment = pd.DataFrame(raw_data, columns = raw_data.keys())\n",
     "regiment"
    ]
   },
@@ -273,7 +273,7 @@
     }
    ],
    "source": [
-    "regiment.groupby(regiment['regiment']).mean()"
+    "regiment[regiment['regiment'] == 'Nighthawks'].groupby('regiment').mean()"
    ]
   },
   {
@@ -423,7 +423,7 @@
     }
    ],
    "source": [
-    "regiment.groupby(regiment['company']).describe()"
+    "regiment.groupby('company').describe()"
    ]
   },
   {
@@ -455,7 +455,7 @@
     }
    ],
    "source": [
-    "regiment['preTestScore'].groupby(regiment['company']).mean()"
+    "regiment.groupby('company').preTestScore.mean()"
    ]
   },
   {
@@ -491,7 +491,7 @@
     }
    ],
    "source": [
-    "regiment['preTestScore'].groupby([regiment['regiment'], regiment['company']]).mean()"
+    "regiment.groupby(['regiment', 'company']).preTestScore.mean()"
    ]
   },
   {
@@ -559,7 +559,7 @@
     }
    ],
    "source": [
-    "regiment['preTestScore'].groupby([regiment['regiment'], regiment['company']]).mean().unstack()"
+    "regiment.groupby(['regiment', 'company']).preTestScore.mean().unstack()"
    ]
   },
   {

Original file line number	Diff line number	Diff line change
`@@ -204,7 +204,7 @@`
`204`	`204`	`}`
`205`	`205`	`],`
`206`	`206`	`"source": [`
`207`		`- "regiment = pd.DataFrame(raw_data, columns = ['regiment', 'company', 'name', 'preTestScore', 'postTestScore'])\n",`
	`207`	`+ "regiment = pd.DataFrame(raw_data, columns = raw_data.keys())\n",`
`208`	`208`	`"regiment"`
`209`	`209`	`]`
`210`	`210`	`},`
`@@ -273,7 +273,7 @@`
`273`	`273`	`}`
`274`	`274`	`],`
`275`	`275`	`"source": [`
`276`		`- "regiment.groupby(regiment['regiment']).mean()"`
	`276`	`+ "regiment[regiment['regiment'] == 'Nighthawks'].groupby('regiment').mean()"`
`277`	`277`	`]`
`278`	`278`	`},`
`279`	`279`	`{`
`@@ -423,7 +423,7 @@`
`423`	`423`	`}`
`424`	`424`	`],`
`425`	`425`	`"source": [`
`426`		`- "regiment.groupby(regiment['company']).describe()"`
	`426`	`+ "regiment.groupby('company').describe()"`
`427`	`427`	`]`
`428`	`428`	`},`
`429`	`429`	`{`
`@@ -455,7 +455,7 @@`
`455`	`455`	`}`
`456`	`456`	`],`
`457`	`457`	`"source": [`
`458`		`- "regiment['preTestScore'].groupby(regiment['company']).mean()"`
	`458`	`+ "regiment.groupby('company').preTestScore.mean()"`
`459`	`459`	`]`
`460`	`460`	`},`
`461`	`461`	`{`
`@@ -491,7 +491,7 @@`
`491`	`491`	`}`
`492`	`492`	`],`
`493`	`493`	`"source": [`
`494`		`- "regiment['preTestScore'].groupby([regiment['regiment'], regiment['company']]).mean()"`
	`494`	`+ "regiment.groupby(['regiment', 'company']).preTestScore.mean()"`
`495`	`495`	`]`
`496`	`496`	`},`
`497`	`497`	`{`
`@@ -559,7 +559,7 @@`
`559`	`559`	`}`
`560`	`560`	`],`
`561`	`561`	`"source": [`
`562`		`- "regiment['preTestScore'].groupby([regiment['regiment'], regiment['company']]).mean().unstack()"`
	`562`	`+ "regiment.groupby(['regiment', 'company']).preTestScore.mean().unstack()"`
`563`	`563`	`]`
`564`	`564`	`},`
`565`	`565`	`{`