2d:null 2e:["$","title",null,{"children":"How each team's ranking changed during the final matches of Group E? | SUGIMOTO Tatsuo | Observable"}] 33:Tac9,points = { const points = table .map((d) => d3.range(91).map((time) => ({ ...d, time, goal: 0 })) ) .flat(); goals.forEach((goal) => { points .filter((d) => d.team === goal.team && d.time >= goal.time) .forEach((d) => { d.goal++; d.scored++; // d.won++; // d.drawn--; }); points .filter((d) => d.team === goal.match && d.time >= goal.time) .forEach((d) => { d.conceded++; // d.lost++; // d.drawn--; }); }); { const teams = ["JPN", "ESP"]; d3.range(91).forEach((time) => { const goal1 = points.find( (d) => d.team === teams.at(0) && d.time === time ).goal; const goal2 = points.find( (d) => d.team === teams.at(1) && d.time === time ).goal; if (goal1 === goal2) { } if (goal1 > goal2) { points.find((d) => d.team === teams.at(0) && d.time === time).won++; points.find((d) => d.team === teams.at(1) && d.time === time).lost++; points.find((d) => d.team === teams.at(0) && d.time === time).drawn--; points.find((d) => d.team === teams.at(1) && d.time === time).drawn--; } if (goal1 < goal2) { points.find((d) => d.team === teams.at(0) && d.time === time).lost++; points.find((d) => d.team === teams.at(1) && d.time === time).won++; points.find((d) => d.team === teams.at(0) && d.time === time).drawn--; points.find((d) => d.team === teams.at(1) && d.time === time).drawn--; } }); } { const teams = ["GER", "CRC"]; d3.range(91).forEach((time) => { const goal1 = points.find( (d) => d.team === teams.at(0) && d.time === time ).goal; const goal2 = points.find( (d) => d.team === teams.at(1) && d.time === time ).goal; if (goal1 === goal2) { } if (goal1 > goal2) { points.find((d) => d.team === teams.at(0) && d.time === time).won++; points.find((d) => d.team === teams.at(1) && d.time === time).lost++; points.find((d) => d.team === teams.at(0) && d.time === time).drawn--; points.find((d) => d.team === teams.at(1) && d.time === time).drawn--; } if (goal1 < goal2) { points.find((d) => d.team === teams.at(0) && d.time === time).lost++; points.find((d) => d.team === teams.at(1) && d.time === time).won++; points.find((d) => d.team === teams.at(0) && d.time === time).drawn--; points.find((d) => d.team === teams.at(1) && d.time === time).drawn--; } }); } // update points.forEach((d) => { d.difference = d.scored - d.conceded; d.points = d.won * 3 + d.drawn; }); return points; }34:[] 31:{"id":"90ca56f65fafb986","slug":"how-each-teams-ranking-changed-during-the-final-matches","title":"How each team's ranking changed during the final matches of Group E?","thumbnail":"178c201c03c709f476c3769f763b43489d7ebb3f94c82e89ed70c873fa7b2dc7","access_level":"public","create_time":"$D2022-12-05T12:35:01.666Z","update_time":"$D2022-12-16T02:13:59.416Z","view_time":null,"first_public_time":"$D2022-12-16T01:55:48.357Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"350b55c00cc281fb","login":"sugi2000","name":"SUGIMOTO Tatsuo","avatar_url":"https://avatars-next.observableusercontent.com/aa2e590c6e4574dde26ce160f882c7074c3f190de1894c0dd147878beed52f39","tier":"starter_2024"},"version":278,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"99e57c8b5dcd5ca6","login":"sugi2000","name":"SUGIMOTO Tatsuo","avatar_url":"https://avatars-next.observableusercontent.com/aa2e590c6e4574dde26ce160f882c7074c3f190de1894c0dd147878beed52f39","tier":null}],"members":[{"type":"individual","id":"99e57c8b5dcd5ca6","login":"sugi2000","name":"SUGIMOTO Tatsuo","avatar_url":"https://avatars-next.observableusercontent.com/aa2e590c6e4574dde26ce160f882c7074c3f190de1894c0dd147878beed52f39","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"How each team's ranking changed during the final matches of Group E?","cells":[{"id":0,"value":"# How each team's ranking changed during the final matches of Group E?\n## FIFA World Cup Qatar 2022\n\nTwo matches were held at the same time in the group E stage.\nThe teams advancing to the tournament stage changed rapidly, so every team had time to advance and lose.\nThe race became a hot topic of conversation in Japan.\n\nreference.\n- https://www.fifa.com/fifaplus/en/match-centre/match/17/255711/285063/400235473?country=JP&wtw-filter=ALL\n- https://www3.nhk.or.jp/news/html/20221127/k10013904701000.html\n- https://twitter.com/michu22_yone/status/1598421381091594240","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":32,"value":"viewof min = Scrubber(d3.range(91), {\n autoplay: false,\n loop: false,\n delay: 250\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":88,"value":"

${points.find(d => d.team==='JPN' && d.time===min).goal} – ${points.find(d => d.team==='ESP' && d.time===min).goal}

${points.find(d => d.team==='GER' && d.time===min).goal} – ${points.find(d => d.team==='CRC' && d.time===min).goal}

\n ${rank.map((d,i) => `

${i+1}

${d.team} ${d.points} (${d3.format('+d')(d.difference)})

`)}\n

\n ${d3.format('02d')(min)} min\n

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":134,"value":"Inputs.table(rank)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":162,"value":"rank = points\n .filter((d) => d.time === min)\n .sort((a, b) => d3.descending(a.difference, b.difference))\n .sort((a, b) => d3.descending(a.points, b.points))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":92,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"Inputs.table(table)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"table = d3\n .csvParse(\n `team,played,won,drawn,lost,scored,conceded,difference,points\nJPN,2,1,0,1,2,2,0,3\nESP,2,1,1,0,8,1,6,4\nGER,2,0,1,1,2,3,-1,1\nCRC,2,1,0,1,1,7,-6,3\n`,\n d3.autoType\n )\n .map((d) => ({\n ...d,\n played: d.played + 1,\n drawn: d.drawn + 1,\n points: d.won * 3 + d.drawn + 1\n }))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":71,"value":"goals = [...ESPJPNgoals, ...CRCGERgoals].sort((a, b) =>\n d3.ascending(a.time, b.time)\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"ESPJPNgoals = d3.csvParse(\n `time,team,match,player\n11,ESP,JPN,Alvaro MORATA\n48,JPN,ESP,Ritsu DOAN\n51,JPN,ESP,Ao TANAKA`,\n d3.autoType\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"CRCGERgoals = d3.csvParse(\n `time,team,match,player\n89,GER,CRC,Niclas FUELLKRUG\n85,GER,CRC,Kai HAVERTZ\n73,GER,CRC,Kai HAVERTZ\n70,CRC,GER,Juan VARGAS\n58,CRC,GER,Yeltsin TEJEDA\n10,GER,CRC,Serge GNABRY\n`,\n d3.autoType\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":117,"value":"flag = (team) =>\n `https://cloudinary.fifa.com/api/v3/picture/flags-sq-4/${team}?tx=c_fill,g_auto,q_auto,w_48`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"import { Scrubber } from \"@mbostock/scrubber\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":122,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":230,"value":" ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"}],"files":"$W34","stdlib":"1"}} 32:"$31:body"