25:["$","title",null,{"children":"Homework 1 | Julia Kieserman's Workspace | Observable"}] 49:T445,## Analysis 1. The teams that scored the most goals but also lost the most goals this season were Arsenal and Man United. This is easily determined by looking at the teams in the upper right quadrant of the graph. It is worth noting that these are not the teams that scored the most goals in the season, but the ones that scored a good number and lost a relatively high number as well. 2. There weren't any teams that scored few goals and lost few goals this season. The closest is probably either Newcastle or Brighton, but both had a considerable number of goals overall. 3. The teams with the most points in the league are Man City and Liverpool. Both had the highest number of goals won and lowest number of goals lost. From this chart, it really seems like teams that scored the most points had both a good attack and a good defense. The next closest team in attack was Arsenal, which still scored ~20 less points than the top two teams and lost nearly 30 more goals. The next closest team in defense was Tottenham, which similarly still was ~20 more points lost than the top two teams.4a:T645,function drawBubbles() { // basic graph setup const svg = d3.select("#chart") .append("svg") .attr("width", visWidth + margin.left + margin.right) .attr("height", visHeight + margin.top + margin.bottom) .append("g") .attr("transform", `translate(${margin.left}, ${margin.top})`); // add tooltip for team name const tooltip = d3tip() .style("background-color", "white") .html( (e, d) => `

${d.team}

${d.points} points

` ); svg.call(tooltip); // Add axes + labels svg.append("g") .attr("transform", `translate(${margin.left}, ${visHeight})`) .call(d3.axisBottom(goalsWonScale)); // x-axis svg.append("text") // x-axis label .attr("y", visHeight + margin.bottom) .attr("x", visWidth/2) .style("text-anchor", "middle") .text("Goals Won"); svg.append("g") .attr("transform", `translate(${margin.left}, 0)`) .call(d3.axisLeft(goalsLostScale)); // y-axis svg.append("text") // y-axis label .attr("y", -margin.left + 15) .attr("x", -(visHeight/2)) .attr("transform", "rotate(-90)") .text("Goals Lost"); // Add chart data svg.append("g") .selectAll("dot") .data(dataSorted) .join('circle') .attr("class", d => d.team) .attr("cx", d => goalsWonScale(d.goalsWon)) .attr("cy", d => goalsLostScale(d.goalsLost)) .attr("r", d => pointsScale(d.points)) .style("fill", d => colorScale(d.points)) .on("mouseover", tooltip.show) .on("mouseout", tooltip.hide) }4b:[{"id":"d5552301a1583fd72874b2f6ba47c5625bf911a1bc22d1a895e9cda9986383b93d3c39b7be020fb46f301957640eb3163181c0f0dbe8d27c5ef54da06d61e3c0","href":"https://static.observableusercontent.com/files/d5552301a1583fd72874b2f6ba47c5625bf911a1bc22d1a895e9cda9986383b93d3c39b7be020fb46f301957640eb3163181c0f0dbe8d27c5ef54da06d61e3c0","name":"season-1819_csv.csv","type":"text/csv","lastModified":1696013021523.893,"size":96144}] 29:{"id":"b7fda160a72afb92","slug":null,"title":"Homework 1","thumbnail":"03ffd5d2680134bb1bc756c92fca34911a5e10612d112a5d9b11db95078abc9b","access_level":"public","create_time":"$D2023-09-29T18:39:59.945Z","update_time":"$D2023-10-10T20:31:10.658Z","view_time":null,"first_public_time":"$D2023-10-08T10:18:44.176Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"6b6386cfd0f430bc","login":"julia-kieserman-ws","name":"Julia Kieserman's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/68e62baae9785057b3e25b19079803132fdb6457c20d938674876b8947fb6f41","tier":"starter_2024","bio":"","following":false},"version":1236,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"90f30427d41a2b02","login":"julia-kieserman","name":"Julia Kieserman","avatar_url":"https://avatars-next.observableusercontent.com/9e8cee257decd57951dfaa8cbeb46f78363a5f3d58388b43f3ee76ec2d5d3752","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"90f30427d41a2b02","login":"julia-kieserman","name":"Julia Kieserman","avatar_url":"https://avatars-next.observableusercontent.com/9e8cee257decd57951dfaa8cbeb46f78363a5f3d58388b43f3ee76ec2d5d3752","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Homework 1","cells":[{"id":0,"value":"# Homework 1\nJulia Kieserman, jbk392","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1191,"value":"# Data Transformation","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1111,"value":"await FileAttachment(\"season-1819_csv.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":3,"value":"// FTHG = full time home team goals \n// FTAG = full time away team goals\n// HS = home team shots\n// AS = away team shots\n// POINTS RULES = \n // (1) 3 points for a win\n // (2) 0 points for a loss\n // (3) 1 point for a draw\n\ndata = (await FileAttachment(\"season-1819_csv.csv\").csv()).map( match => {\n\n return {\n // only select necessary columns\n homeTeam: match.HomeTeam,\n awayTeam: match.AwayTeam,\n homeTeamGoals: +match.FTHG, // full-time home goals\n awayTeamGoals: +match.FTAG, // full-time away goals\n homeTeamPoints: +match.FTHG > +match.FTAG ? 3 : (+match.FTHG === +match.FTAG ? 1 : 0),\n awayTeamPoints: +match.FTAG > +match.FTHG ? 3 : (+match.FTHG === +match.FTAG ? 1 : 0)\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":922,"value":"Data Transformation","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1115,"value":"allData = {\n let finalOutput = [];\n for (const match of data) {\n // one row for the home team in the match\n finalOutput.push({\n team: match.homeTeam,\n goalsWon: match.homeTeamGoals,\n goalsLost: match.awayTeamGoals,\n points: match.homeTeamPoints\n })\n\n // one row for the away team in the match\n finalOutput.push({\n team: match.awayTeam,\n goalsWon: match.awayTeamGoals,\n goalsLost: match.homeTeamGoals,\n points: match.awayTeamPoints\n })\n }\n\n return finalOutput;\n\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":326,"value":"// transform data to desired format\n// {'team': 'Liverpool', 'goals for': 85, 'goals against': 35, 'points': 99}\naggregatedTeamStats = {\n let finalOutput = [];\n for (let i=0; i < allData.length; i++) {\n const row = allData[i];\n const team = row.team;\n\n // check if the team already exists\n const teamRow = finalOutput.findIndex(item => item['team'] === team );\n\n if (teamRow < 0 ) {\n finalOutput.push({\n team: team,\n goalsWon: row.goalsWon,\n goalsLost: row.goalsLost,\n points: row.points\n })\n } else {\n finalOutput[teamRow]['goalsWon'] += row.goalsWon,\n finalOutput[teamRow]['goalsLost'] += row.goalsLost,\n finalOutput[teamRow]['points'] += row.points\n }\n }\n return finalOutput;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":864,"value":"dataSorted = aggregatedTeamStats.sort((a,b) => a.points - b.points)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":748,"value":"margin = ({ top: 20, bottom: 30, left: 20, right: 20 })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":705,"value":"visWidth = width - margin.left - margin.right","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":719,"value":"visHeight = 500 - margin.top - margin.bottom","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":777,"value":"Graph Scales","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":796,"value":"pointsExtent = d3.extent(dataSorted, d => d.points)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":883,"value":"colorScale = d3.scaleSequentialLog(d3.interpolateCool).domain(pointsExtent)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1092,"value":"goalsWonMax = d3.max(aggregatedTeamStats, d => d.goalsWon)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1095,"value":"goalsLostMax = d3.max(aggregatedTeamStats, d => d.goalsLost)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1211,"value":"pointsMax = d3.max(aggregatedTeamStats, d => d.points)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":782,"value":"// x scale\ngoalsWonScale = d3.scaleLinear()\n .domain([0, goalsWonMax])\n .range([0, visWidth])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":786,"value":"// y scale\ngoalsLostScale = d3.scaleLinear()\n .domain([0, goalsLostMax])\n .range([visHeight, 0])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1209,"value":"pointsScale = d3.scaleLinear()\n .domain([0, pointsMax])\n .range([5, 15]);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1166,"value":"$49","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":928,"value":"chart = {\n yield html`\n

`;\n drawBubbles();\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":887,"value":"Legend(colorScale, { title: \"Points\" })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":937,"value":"$4a","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":868,"value":"import { Legend, Swatches } from \"@d3/color-legend\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1014,"value":"d3tip = require(\"d3-tip\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4b","stdlib":"1"}} 24:null