corrections to open lab exercises

swricci · swricci · commit 07a4685aabbe · 2023-10-12T11:32:24.000-04:00
PYOL4, answer key used paintings instead of photos dataset
diff --git a/Open_Lab_4_exploratory_analysis_with_pandas/Open_Lab_4_exploratory_analysis_with_pandas.ipynb b/Open_Lab_4_exploratory_analysis_with_pandas/Open_Lab_4_exploratory_analysis_with_pandas.ipynb
@@ -355,7 +355,7 @@
    "source": [
     "### Exercise 3: Grouping Values\n",
     "\n",
-    "Find the average year created for each department (Painting & Sculpture, Drawings & Prints, Film, Fluxus Collection, Media & Performance). Group the data using 'Department,' then show a table with the average 'YearCreated' for each department, sorted from oldest to newest.\n",
+    "Find the average year created for each department (Painting & Sculpture, Drawings & Prints, Film, Fluxus Collection, Media & Performance) in the photos collection. Group the data using 'Department,' then show a table with the average 'YearCreated' for each department, sorted from oldest to newest.\n",
     "\n",
     "> Bonus discussion question: does showing the data this way tell the whole story? What other factors could affect the average year the art was created?"
    ]
@@ -373,7 +373,7 @@
    "source": [
     "### Exercise 4: Group values by two factors\n",
     "\n",
-    "Find how many works of art each artist created using different mediums. Group by artist and medium to create a chart that shows how many works of art in the collection by each artist used each medium."
+    "Find how many works of art each artist created using different mediums. Group by artist and medium to create a chart that shows how many works of art in the photos collection by each artist used each medium."
    ]
   },
   {
diff --git a/Open_Lab_4_exploratory_analysis_with_pandas/filled_Open_Lab_4_exploratory_analysis_with_pandas.ipynb b/Open_Lab_4_exploratory_analysis_with_pandas/filled_Open_Lab_4_exploratory_analysis_with_pandas.ipynb
@@ -3379,7 +3379,7 @@
    "source": [
     "### Exercise 3: Grouping Values\n",
     "\n",
-    "Find the average year created for each department (Painting & Sculpture, Drawings & Prints, Film, Fluxus Collection, Media & Performance). Group the data using 'Department,' then show a table with the average 'YearCreated' for each department, sorted from oldest to newest.\n",
+    "Find the average year created for each department (Painting & Sculpture, Drawings & Prints, Film, Fluxus Collection, Media & Performance) in the photos collection. Group the data using 'Department,' then show a table with the average 'YearCreated' for each department, sorted from oldest to newest.\n",
     "\n",
     "> Bonus discussion question: does showing the data this way tell the whole story? What other factors could affect the average year the art was created?"
    ]
@@ -3581,7 +3581,7 @@
    ],
    "source": [
     "# Create the groupby object and store in a variable\n",
-    "departments = paintings.groupby('Department')\n",
+    "departments = photos.groupby('Department')\n",
     "\n",
     "# Find the mean of each group and sort values by YearCreated\n",
     "departments.mean().sort_values('YearCreated', ascending=True)"
@@ -3593,7 +3593,7 @@
    "source": [
     "### Exercise 4: Group values by two factors\n",
     "\n",
-    "Find how many works of art each artist created using different mediums. Group by artist and medium to create a chart that shows how many works of art in the collection by each artist used each medium. "
+    "Find how many works of art each artist created using different mediums. Group by artist and medium to create a chart that shows how many works of art in the photos collection by each artist used each medium. "
    ]
   },
   {
@@ -3626,10 +3626,10 @@
    ],
    "source": [
     "# Create the groupby object and store in a variable\n",
-    "test = paintings.groupby(['Artist', 'Medium'])\n",
+    "test = photos.groupby(['Artist', 'Medium'])\n",
     "\n",
     "# Find the mean of each group and sort values by YearCreated\n",
-    "test.size()"
+    "test.mean().sort_values('YearCreated', ascending= False)"
    ]
   },
   {

Original file line number	Diff line number	Diff line change
`@@ -355,7 +355,7 @@`
`355`	`355`	`"source": [`
`356`	`356`	`"### Exercise 3: Grouping Values\n",`
`357`	`357`	`"\n",`
`358`		`- "Find the average year created for each department (Painting & Sculpture, Drawings & Prints, Film, Fluxus Collection, Media & Performance). Group the data using 'Department,' then show a table with the average 'YearCreated' for each department, sorted from oldest to newest.\n",`
	`358`	`+ "Find the average year created for each department (Painting & Sculpture, Drawings & Prints, Film, Fluxus Collection, Media & Performance) in the photos collection. Group the data using 'Department,' then show a table with the average 'YearCreated' for each department, sorted from oldest to newest.\n",`
`359`	`359`	`"\n",`
`360`	`360`	`"> Bonus discussion question: does showing the data this way tell the whole story? What other factors could affect the average year the art was created?"`
`361`	`361`	`]`
`@@ -373,7 +373,7 @@`
`373`	`373`	`"source": [`
`374`	`374`	`"### Exercise 4: Group values by two factors\n",`
`375`	`375`	`"\n",`
`376`		`- "Find how many works of art each artist created using different mediums. Group by artist and medium to create a chart that shows how many works of art in the collection by each artist used each medium."`
	`376`	`+ "Find how many works of art each artist created using different mediums. Group by artist and medium to create a chart that shows how many works of art in the photos collection by each artist used each medium."`
`377`	`377`	`]`
`378`	`378`	`},`
`379`	`379`	`{`