31: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; }32:[] 2f:{"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"},{"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"},{"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"},{"id":134,"value":"Inputs.table(rank)","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":92,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":52,"value":"Inputs.table(table)","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":71,"value":"goals = [...ESPJPNgoals, ...CRCGERgoals].sort((a, b) =>\n d3.ascending(a.time, b.time)\n)","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"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"},{"id":35,"value":"import { Scrubber } from \"@mbostock/scrubber\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":122,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":230,"value":" ","pinned":false,"hidden":false,"mode":"md"}],"files":"$W32","stdlib":"1","titling":"auto"}