25:["$","title",null,{"children":"Week 2 Assignment - Charlton | Berkeley MIDS W209 Information Visualization Course | Observable"}] 49:T79e,{ const target = html`

`; // Return the div first so the following code can find it yield target; var divElement = document.getElementById("viz1693869419340"); var vizElement = divElement.getElementsByTagName("object")[0]; if (divElement.offsetWidth > 800) { vizElement.style.width = "100%"; vizElement.style.height = divElement.offsetWidth * 0.75 + "px"; } else if (divElement.offsetWidth > 500) { vizElement.style.width = "100%"; vizElement.style.height = divElement.offsetWidth * 0.75 + "px"; } else { vizElement.style.width = "100%"; vizElement.style.height = "727px"; } var scriptElement = document.createElement("script"); scriptElement.src = "https://public.tableau.com/javascripts/api/viz_v1.js"; vizElement.parentNode.insertBefore(scriptElement, vizElement); yield target; }4a:[{"id":"14a345c239a2b7b1e171d0819bdfb71d46de5710f8f6f0d7329a60070da71ec3668b6705dfceee2ed21a467afc6bccf223ecfb1c3f7a10399695452367d560b8","href":"https://static.observableusercontent.com/files/14a345c239a2b7b1e171d0819bdfb71d46de5710f8f6f0d7329a60070da71ec3668b6705dfceee2ed21a467afc6bccf223ecfb1c3f7a10399695452367d560b8","name":"players_20.csv","type":"text/csv","lastModified":1693862568200.037,"size":8945067}] 29:{"id":"3e08455a82ffb70c","slug":null,"title":"Week 2 Assignment - Charlton","thumbnail":"2e314a72c5e084bb8c19f36d8c5413bf8fd3f245d3ba6b3aa1d604a9e0c6af62","access_level":"public","create_time":"$D2023-09-04T21:22:48.200Z","update_time":"$D2024-01-13T20:28:07.220Z","view_time":null,"first_public_time":"$D2023-12-07T20:41:19.318Z","has_unpublished_edits":null,"fork":true,"stars":1,"starred":false,"owner":{"type":"team","id":"70c3e45a1a202b95","login":"berkeleyvis","name":"Berkeley MIDS W209 Information Visualization Course","avatar_url":"https://avatars-next.observableusercontent.com/15549145605863403a5e1a9e52e5f27f9a102749b0a2c648195d93efe07a5f34","tier":"education_2026","bio":"","followed_by_you":false,"follows_you":false},"version":170,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"b13093b6da17d7ad","login":"mike2026","name":"Mike","avatar_url":"https://avatars-next.observableusercontent.com/2ca64027e3311796945848284060b3d94f6707d77e3f5ac75c399fada065f788","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"team","id":"70c3e45a1a202b95","login":"berkeleyvis","name":"Berkeley MIDS W209 Information Visualization Course","avatar_url":"https://avatars-next.observableusercontent.com/15549145605863403a5e1a9e52e5f27f9a102749b0a2c648195d93efe07a5f34","tier":"education_2026","role":"editor"},{"type":"individual","id":"b13093b6da17d7ad","login":"mike2026","name":"Mike","avatar_url":"https://avatars-next.observableusercontent.com/2ca64027e3311796945848284060b3d94f6707d77e3f5ac75c399fada065f788","tier":null,"role":"editor"},{"type":"group","id":"b793e25df42fbe4c","login":"b424d02872908082","name":"Fall 2023","avatar_url":null,"tier":"public","role":"viewer"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Week 2 Assignment - Charlton","cells":[{"id":0,"value":"md`# Week 2 Assignment - Charlton\n\nPlease complete and submit links to digital campus for **each of the three tracks**.\n\nFor \\`D3\\` and \\`Altair\\` sections, we want you to focus on getting familiar with reading and aggregating the data using the APIs. \nYou are welcome to create visualizations, but it is only required for the \\`Tableau\\` section.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"md`## D3\n\nThis weeks assignment is to take the attached dataset here (click on the pin on the right nav in Observable to see the data), group by nationality, count the number of players and the average age. You can fork this notebook and work here directly.\n\n${observable_instructions}.\n\nFile attachment code, so it will come with the fork:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"value":"data = FileAttachment(\"players_20.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":127,"value":"groupedData = data.reduce((acc, player) => {\n const { nationality, age } = player;\n\n const numAge = Number(age);\n\n let group = acc.find((g) => g.nationality === nationality);\n\n if (!group) {\n group = {\n nationality,\n averageAge: numAge,\n playerCount: 1\n };\n acc.push(group);\n } else {\n group.playerCount++;\n group.averageAge =\n (group.averageAge * (group.playerCount - 1) + numAge) / group.playerCount;\n }\n\n return acc;\n}, [])\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":129,"value":"groupedData","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":9,"value":"md`## Altair\n\nThis weeks assignment is to take the dataset attached above, and using Pandas group by nationality, count the number of players and average age. Submit the link to the Google Collaboratory notebook.\n[Here is a notebook to start from](https://colab.research.google.com/drive/12uAnzjxUjZBWnbkarmHX9dH7Np8XcXVG?usp=sharing).\n\nYou can upload the data (you downloaded from Observable) to your Google Collab workspace by running:\n\n\\`\\`\\`\nfrom google.colab import files\nfiles.upload()\n\\`\\`\\`\n\nwhich will prompt you to upload the data file to your workspace. You can then read in the file:\n\n\\`\\`\\`\ndf = pd.read_csv(\"/content/players_20.csv\")\ndf.head()\n\\`\\`\\`\n\nThe data goes away when the runtime shuts down, but the plots should still be there from altair.\n\nSolution Link: https://colab.research.google.com/drive/1qHUDxYrpJIizvgGM6XVX0eT5FjuK1J0s?usp=sharing\n\n${altair_instructions}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"md`## Tableau\n\nThis weeks assignment is to take the dataset attached above, and show a table of counts of players by nationality along with average age. Submit the Tableau Public or Observable link to your vis (you can embed Tableau Public into Observable [like this](https://observablehq.com/d/5a54f49de003fc8e?collection=@berkeleyvis/scratchbooks)).\n\nSolution Link: https://public.tableau.com/views/W209-Fall2023-Sec5-Charlton-HW2/Sheet1?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link\n\n${tableau_instructions}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":148,"value":"$49","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":53,"value":"md`# Peer Review Prompts\n\nJust one question prompt this week:\n\n- Does the aggregation in each tool appear correct?\n\n${peer_review_instructions}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":90,"value":"import {\n observable_instructions,\n altair_instructions,\n tableau_instructions,\n peer_review_instructions\n} from \"@berkeleyvis/how-to-submit-assignments\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4a","stdlib":"1"}} 24:null