2f:T939,Plot.plot({ grid: true, width: width, height: 700, marginBottom: 40, padding: 40, x: { ticks: 38 }, y: { ticks: 20, domain: [1, 20], reverse: true }, marks: [ Plot.lineX(sel_team_data, { // filter: d => (d['home_team'] == sel_team || d['away_team'] == sel_team), x: 'match_week_no', y: d => { if(d['home_team'] == sel_team) return d['home_standings'] if(d['away_team'] == sel_team) return d['away_standings'] }, stroke: 'black', strokeWidth: 3 }), Plot.dot(epl_1516, { x: 'match_week_no', y: 'home_standings', // home and away team's standings both stroke: d => { if(d['home_score'] > d['away_score']) return 'green' if(d['home_score'] < d['away_score']) return 'red' if(d['home_score'] == d['away_score']) return 'orange' }, strokeWidth: 3, r: 11, opacity: d => d['home_team'] == sel_team || d['away_team'] == sel_team ? 1 : 0.1 }), Plot.dot(epl_1516, { x: 'match_week_no', y: 'away_standings', // home and away team's standings both stroke: d => { if(d['away_score'] > d['home_score']) return 'green' if(d['away_score'] < d['home_score']) return 'red' if(d['away_score'] == d['home_score']) return 'orange' }, strokeWidth: 3, r: 11, opacity: d => d['home_team'] == sel_team || d['away_team'] == sel_team ? 1 : 0.1 }), Plot.image(epl_1516, { x: 'match_week_no', y: 'home_standings', src: d => get_logo(d['home_team']), width: 20, opacity: d => d['home_team'] == sel_team || d['away_team'] == sel_team ? 1 : 0.1 }), Plot.image(epl_1516, { x: 'match_week_no', y: 'away_standings', src: d => get_logo(d['away_team']), width: 20, opacity: d => d['home_team'] == sel_team || d['away_team'] == sel_team ? 1 : 0.1 }), Plot.tip(epl_1516, Plot.pointer({ x: 'match_week_no', y: 'home_standings', title: d => `${d.home_team} ${d.home_score}-${d.away_score} ${d.away_team}` })), // Plot.tip(epl_1516, Plot.pointer({ // x: 'match_week_no', // y: 'away_standings', // title: d => `${d.away_team} ${d.away_score}-${d.home_score} ${d.home_team}` // })) ], color: { legend: true, domain: [-1, 0, 1], reverse: true }, })30:T4f7,## Leicester Tactics Calduio Reniari when appointed as manager in _2015_ was coming from _Monaco FC_ which was placed 2nd in Ligue 1 at 80 points, 9 points away from PSG - a massive success for the French club. His appointment was initially met with scepticism, as a Guardian journalist said > If Leicester wanted someone nice, they’ve got him. If they wanted someone to keep them in the Premier League, then they may have gone for the wrong guy[^guardian] -- - Leicester at the time of his arrival barely kept itself together in the premierely and merely avoided relegation by Nigel Pearson the previous season Reniari mostly played 4-4-2 formation (with the wingers pressing high) and was known for pressing high up the pitch and fast break attack His key players in Leicester were Vardy, Mahrez He made history by winning the for the first time in their 132 years of existence home team and away team starting formation (values in [0, 1, 2, 3, 4]: - 0 for 2 defenders and 1 forward - 1 for 3 defenders and 1 forward - 2 for 2 defenders and 2 forwards - 3 for 3 defenders and 2 forwards - 4 if otherwise **Footnotes** - [^guardian]: [the guardian article](https://www.theguardian.com/football/blog/2015/jul/14/claudio-ranieri-leicester-city-nigel-pearson)31:T470,Plot.plot({ title: `${sel} team\'s performance against ${opp} team`, subtitle: `colour is based on whether the ${sel} team (y-axis) has won, lost or drew against the opponent (x-axis). The size of the circles are the xG (expected goals) or chances the ${sel} team.`, marginBottom: 120, marginLeft: 120, width: width, height: 800, grid: true, color: { legend: true, scheme: 'Observable10', reverse: true, type: 'categorical' }, y: { label: `${sel} team` }, x: { tickRotate: 50, label: `${opp} team ->` }, marks: [ Plot.dot(epl_1516, { x: `${opp}_team`, y: `${sel}_team`, r: `${sel}_xg`, fill: d => { if(d[`${sel}_score`] > d[`${opp}_score`]) return 'green' if(d[`${sel}_score`] == d[`${opp}_score`]) return 'orange' if(d[`${sel}_score`] < d[`${opp}_score`]) return 'red' }, sort: { 'channel': 'y', 'order': 'descending' } }), Plot.tip(epl_1516, Plot.pointer({ x: `${opp}_team`, y: `${sel}_team`, title: d => `(xg: ${d.home_xg}) ${d.home_team} ${d.home_score}-${d.away_score} ${d.away_team} (xg: ${d.away_xg})` })) ] })32:T777,function get_logo(name) { const logos = { 'Leicester': 'https://resources.premierleague.com/premierleague/badges/50/t13@x2.png', 'Arsenal': 'https://resources.premierleague.com/premierleague/badges/50/t3@x2.png', 'Aston Villa': 'https://resources.premierleague.com/premierleague/badges/50/t7@x2.png', 'Manchester United': 'https://resources.premierleague.com/premierleague/badges/50/t1@x2.png', 'Manchester City': 'https://resources.premierleague.com/premierleague/badges/50/t43@x2.png', 'Tottenham': 'https://resources.premierleague.com/premierleague/badges/50/t6@x2.png', 'Southampton': 'https://resources.premierleague.com/premierleague/badges/50/t20@x2.png', 'West Ham': 'https://resources.premierleague.com/premierleague/badges/50/t21@x2.png', 'Liverpool': 'https://resources.premierleague.com/premierleague/badges/50/t14@x2.png', 'Swansea': 'https://resources.premierleague.com/premierleague/badges/50/t80@x2.png', 'Newcastle United': 'https://resources.premierleague.com/premierleague/badges/50/t4@x2.png', 'Stoke': 'https://resources.premierleague.com/premierleague/badges/50/t110@x2.png', 'Sunderland': 'https://resources.premierleague.com/premierleague/badges/50/t56@x2.png', 'Chelsea': 'https://resources.premierleague.com/premierleague/badges/50/t8@x2.png', 'Watford': 'https://resources.premierleague.com/premierleague/badges/50/t57@x2.png', 'Everton': 'https://resources.premierleague.com/premierleague/badges/50/t11@x2.png', 'Norwich': 'https://resources.premierleague.com/premierleague/badges/50/t45@x2.png', 'West Bromwich Albion': 'https://resources.premierleague.com/premierleague/badges/50/t35@x2.png', 'Crystal Palace': 'https://resources.premierleague.com/premierleague/badges/50/t31@x2.png', 'Bournemouth': 'https://resources.premierleague.com/premierleague/badges/50/t91@x2.png' } return logos[name] }33:[{"id":"e667d5dcf2532c6d4448a50ed562d30e99a83c31c6777ac9fb24bdede43b202dcb816154bcc6542bd616626fd5d17cb0872b3b0545724eff38b42434ee0320d8","href":"https://static.observableusercontent.com/files/e667d5dcf2532c6d4448a50ed562d30e99a83c31c6777ac9fb24bdede43b202dcb816154bcc6542bd616626fd5d17cb0872b3b0545724eff38b42434ee0320d8","name":"football_matches_dataset.csv","type":"text/csv","lastModified":1748840900955.431,"size":7145895}] 2d:{"title":"Tidy Tuesday 05 - Football","cells":[{"id":0,"value":"# Tidy Tuesday 05 - Football\n\nThe story of how Leicester City FC won the premier league in 2015/2016 EPL season for their first time in history","pinned":false,"hidden":false,"mode":"md"},{"id":69,"value":"## Overview\n\nLeicester city won their first title in 2015/16 season with a total of **`${t_points}`**. They had won **`${t_won.length}`** matches, drew **`${t_draw.length}`** and had lost only **`${t_lost.length}`** matches including, against **`${home_lost_against}`** at home and against **`${away_lost_against}`** away from home. Leicester also drew against **`${draw_against}`**.\n\nThis total points wasn't as staggering as other teams in other seasons winning the premier league titles.","pinned":false,"hidden":false,"mode":"md"},{"id":802,"value":"You can see the how the teams moved positions over the match weeks, their wins (bordered green), draws (bordered orange) and losses (bordered red). You'll also see each team's opposition highlighted for the same week.","pinned":false,"hidden":false,"mode":"md"},{"id":1068,"value":"viewof sel_team = Inputs.select([...new Set(epl_1516.map(d => d['home_team']))].sort(), { label: 'see movement for team:' })","pinned":false,"hidden":false,"mode":"ojs"},{"id":712,"value":"$2f","pinned":true,"hidden":false,"mode":"ojs"},{"id":410,"value":"## Leicester Matches and Standings\n\nLeicester city, never dropped position below the **9th position** in the table. It also remained consistent in the last **14 matches** of the season, by being at the top of the table. They briefly dropped position between the week of **18th and 22nd**. Notice, how the loss against Arsenal in Week 6 had a massive drop in position, as well as losing points in Week 17 impacted in dropping to 2nd position as well.","pinned":false,"hidden":false,"mode":"md"},{"id":246,"value":" Plot.plot({\n grid: true,\n width: width,\n height: 700,\n x: { ticks: 38 },\n y: { ticks: 20, domain: [1, 20], reverse: true },\n marks: [\n Plot.line(data, {\n x: 'week_no',\n y: 'lfc_standings'\n }),\n Plot.dot(data, {\n x: 'week_no',\n y: 'lfc_standings',\n stroke: 'outcome',\n strokeWidth: 5,\n r: 11\n }),\n Plot.image(data, {\n x: 'week_no',\n y: 'lfc_standings',\n src: 'https://resources.premierleague.com/premierleague/badges/50/t13@x2.png',\n width: 20,\n opacity: 1,\n }),\n Plot.tip(data, Plot.pointer({\n x: 'week_no',\n y: 'lfc_standings',\n title: d => `${d.home_team} ${d.home_score}-${d.away_score} ${d.away_team}`\n }))\n ],\n color: { legend: true, domain: [-1, 0, 1], reverse: true },\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":825,"value":"$30","pinned":false,"hidden":false,"mode":"md"},{"id":832,"value":"data.map(d => {\n if(d['home_team'] == 'Leicester') return d['home_formation']\n if(d['away_team'] == 'Leicester') return d['away_formation']\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":72,"value":"-----","pinned":false,"hidden":false,"mode":"md"},{"id":141,"value":"## Questions\n\n- How did Leicester fare against opponents at home vs away / how good/bad were they at home vs away\n- Whom did they never lose against\n- Whom did they lost against\n- How did their formation change against home vs away & win vs lost\n\n**Beyond the data**\n- who was the owner\n- when was Claudio Ranieri signed?\n- which players did he sign?\n- what was Claudio Ranieri's playing style and where did he come from prior to Leicester?\n- formation changes? it's effects? _possible to find with this dataset_","pinned":false,"hidden":false,"mode":"md"},{"id":465,"value":"-----","pinned":false,"hidden":false,"mode":"md"},{"id":143,"value":"lfc = null","pinned":true,"hidden":false,"mode":"ojs"},{"id":85,"value":"SummaryTable(lfc)","pinned":true,"hidden":false,"mode":"ojs"},{"id":148,"value":"# Leicester City Matches","pinned":false,"hidden":false,"mode":"md"},{"id":79,"value":"lfc = epl_1516.filter(d => d['home_team'] == 'Leicester' || d['away_team'] == 'Leicester')","pinned":true,"hidden":false,"mode":"ojs"},{"id":320,"value":"## Cleaning LFC data & deriving new cols","pinned":false,"hidden":false,"mode":"md"},{"id":450,"value":"home_lost_against = data.filter(d => (d['outcome'] == -1) && (d['home_team'] == 'Leicester')).map(d => d['away_team']).join(', ')","pinned":true,"hidden":false,"mode":"ojs"},{"id":460,"value":"away_lost_against = data.filter(d => (d['outcome'] == -1) && (d['away_team'] == 'Leicester')).map(d => d['home_team']).join(', ')","pinned":true,"hidden":false,"mode":"ojs"},{"id":467,"value":"draw_against = [...new Set(data.filter(d => (d['outcome'] == 0)).map(d => (d['home_team'] == 'Leicester') ? d['away_team'] : d['home_team']))].join(', ')","pinned":true,"hidden":false,"mode":"ojs"},{"id":137,"value":"t_points = t_won.length * 3 + t_draw.length","pinned":false,"hidden":false,"mode":"ojs"},{"id":101,"value":"t_lost = data.filter(d => {\n const lost = (d['home_team'] == 'Leicester' && d['home_score'] < d['away_score']) || \n (d['away_team'] == 'Leicester' && d['away_score'] < d['home_score'])\n return lost\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":113,"value":"t_won = data.filter(d => {\n const won = (d['home_team'] == 'Leicester' && d['home_score'] > d['away_score']) || \n (d['away_team'] == 'Leicester' && d['away_score'] > d['home_score'])\n return won\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":117,"value":"t_draw = data.filter(d => {\n const draw = (d['home_team'] == 'Leicester' && d['home_score'] == d['away_score']) || \n (d['away_team'] == 'Leicester' && d['away_score'] == d['home_score'])\n return draw\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":395,"value":"data = lfc_updated.map((d, i) => {\n let lfc_standings\n if(d['home_team'] == 'Leicester') {\n lfc_standings = d['home_standings']\n } else {\n lfc_standings = d['away_standings']\n }\n return {...d, 'lfc_standings': lfc_standings, 'week_no': i }\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":401,"value":"data","pinned":true,"hidden":false,"mode":"ojs"},{"id":378,"value":"lfc_updated = lfc.map(d => {\n let outcome = 0\n if(d['home_team'] == 'Leicester') {\n if(d['home_score'] > d['away_score']) outcome = 1\n if(d['home_score'] < d['away_score']) outcome = -1\n if(d['home_score'] == d['away_score']) outcome = 0\n }\n\n if(d['away_team'] == 'Leicester') {\n if(d['home_score'] < d['away_score']) outcome = 1\n if(d['home_score'] > d['away_score']) outcome = -1\n if(d['home_score'] == d['away_score']) outcome = 0\n }\n \n return {...d, 'outcome': outcome }\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":791,"value":"epl_1516_updated = {\n for(let i = 0; i < home_teams.length; i++) {\n epl_1516.map(d => {\n let outcome = 0\n if(d['home_team'] == home_teams[i]) {\n if(d['home_score'] > d['away_score']) outcome = 1\n if(d['home_score'] < d['away_score']) outcome = -1\n if(d['home_score'] == d['away_score']) outcome = 0\n }\n \n if(d['away_team'] == home_teams[i]) {\n if(d['home_score'] < d['away_score']) outcome = 1\n if(d['home_score'] > d['away_score']) outcome = -1\n if(d['home_score'] == d['away_score']) outcome = 0\n }\n let team_name = home_teams[i].toLowerCase().replace(' ', '_')\n d[`outcome_${team_name}`] = outcome\n return d\n }) \n }\n\n return epl_1516\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":386,"value":"lfc_updated","pinned":true,"hidden":false,"mode":"ojs"},{"id":367,"value":"# LFC Matches for EPL Season 2015/16","pinned":false,"hidden":false,"mode":"md"},{"id":331,"value":"lfc","pinned":true,"hidden":false,"mode":"ojs"},{"id":150,"value":"# EPL Matches for season 2015/16\nThis dataset only contains EPL matches for the 2015/16 season. There are a total of **`${epl_1516.length}`** matches played, starting from **`${d3.min(epl_1516, d => d['datetime'])}`** to **`${d3.max(epl_1516, d => d['datetime'])}`**","pinned":false,"hidden":false,"mode":"md"},{"id":5,"value":"epl_1516 = await FileAttachment(\"football_matches_dataset.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":636,"value":"----","pinned":false,"hidden":false,"mode":"md"},{"id":363,"value":"# Entire football match dataset\n\nThis dataset contains **`${all_matches.length}`** matches, across **`${[... new Set(all_matches.map(d => d['league']))].join(', ')}`** leagues and **`${[... new Set(all_matches.map(d => d['season']))].join(', ')}`** seasons","pinned":false,"hidden":false,"mode":"md"},{"id":324,"value":"all_matches = await FileAttachment(\"football_matches_dataset.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":574,"value":"## Interpretation of the below graph\n- This graph only shows home matches for the teams shown on the `y-axis` i.e. row wise.\n- Look at the chart horizontally, (row-wise), you'll see how many matches did that row's team win in green, drew in orange and lost in red.\n- You can also see how 'exciting' the match was for the home team, based on the size of the circle representing the `xg` for the row's team\n- You can identify which teams performed good at home, by looking for more greens in a row. Similarly, which teams were bad at home by looking at more reds in a row","pinned":false,"hidden":false,"mode":"md"},{"id":577,"value":"viewof view = Inputs.select(['Home', 'Away'], { label: 'Select point of view:' })","pinned":false,"hidden":false,"mode":"ojs"},{"id":50,"value":"$31","pinned":true,"hidden":false,"mode":"ojs"},{"id":87,"value":"import {SummaryTable} from \"@observablehq/summary-table\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":152,"value":"## Links & Sources\n\n- [Wiki page](https://en.wikipedia.org/wiki/2015%E2%80%9316_Leicester_City_F.C._season)\n- [Google result for the 15/16 season](https://www.google.com/search?q=epl+fixtures+2015+16&oq=epl+fixt&gs_lcrp=EgZjaHJvbWUqBggAEEUYOzIGCAAQRRg7MgYIARBFGDsyBggCEEUYOTIMCAMQIxgnGIAEGIoFMgcIBBAAGIAEMg0IBRAAGIMBGLEDGIAEMgYIBhAAGAMyBwgHEAAYgAQyBwgIEAAYgAQyBwgJEAAYjwLSAQgyOTY4ajBqN6gCALACAA&sourceid=chrome&ie=UTF-8#wptab=si:AMgyJEu4cRbybpVbRS3u81ldjFydThwRiIENUrCRN8VynKCdr5SDVBU2T6SPAHP95hcHUrY7dtRQRmxrsf_2UTRpvLp8-1tzR1txhWA9d16UG1ym4K0vkdZOXhgCvHEn8DJOHEbD0hecAYQvWftFO05Q-u3E-YND3BGMaSZo5cJOYmzmCtCeaTFEe1TdCm2pE-b7EtEXZ77-3fX40iWBBg6BjiRxKh3fzvb2PS8sm7SQg2eKPQ5G7zszN_s4brBjaKgFLkXHz5kXbbfPcGl5b_pc9yrj05ir7EzD8N1BRF4xwPQWwdPrxopoRnnNeboMJzvV6TagNYv_)\n- [Data source from Kaggle](https://www.kaggle.com/datasets/leonidkiselev/football-matches-statistics?resource=download)","pinned":false,"hidden":false,"mode":"md"},{"id":781,"value":"## Rough / Functions / Variables","pinned":false,"hidden":false,"mode":"md"},{"id":638,"value":"// @date - the string format of the date\nweekOfYear = (date) => {\n const startOfYear = new Date(date.getFullYear(), 0, 1);\n startOfYear.setDate(startOfYear.getDate() + (startOfYear.getDay() % 7));\n return Math.round((date - startOfYear) / (7 * 24 * 3600 * 1000));\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":213,"value":"","pinned":true,"hidden":false,"mode":"sql","output":"epl_1516","database":"football_matches_dataset.csv"},{"id":560,"value":"home_teams = [...new Set(epl_1516.map(d => d['home_team']))].sort()","pinned":true,"hidden":false,"mode":"ojs"},{"id":662,"value":"// to scale any team's position to \nposition_scale = d3.scaleLinear([1, 20], [1, 20])","pinned":true,"hidden":false,"mode":"ojs"},{"id":664,"value":"updated_epl_1516 = {\n let updated_epl_1516 = []\n for(let tind = 0; tind < home_teams.length; tind++) {\n // console.log(home_teams[tind])\n let home_team_matches = epl_1516.filter(d => (d['home_team'] == home_teams[tind] || d['away_team'] == home_teams[tind]))\n home_team_matches.map((d, i) => {\n d['match_week_no'] = i + 1\n return d\n })\n // console.log(home_team_matches)\n updated_epl_1516 = updated_epl_1516.concat(home_team_matches)\n }\n return updated_epl_1516\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":746,"value":"updated_epl_1516_away = {\n let updated_epl_1516_away = []\n for(let tind = 0; tind < home_teams.length; tind++) {\n // console.log(home_teams[tind])\n let home_team_matches = epl_1516.filter(d => (d['away_team'] == home_teams[tind] || d['home_team'] == home_teams[tind]))\n home_team_matches.map((d, i) => {\n d['match_week_no'] = i + 1\n return d\n })\n // console.log(home_team_matches)\n updated_epl_1516_away = updated_epl_1516_away.concat(home_team_matches)\n }\n return updated_epl_1516_away\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":709,"value":"updated_epl_1516","pinned":true,"hidden":false,"mode":"ojs"},{"id":600,"value":"opp = view.toLowerCase() == 'home' ? 'away' : 'home'","pinned":false,"hidden":false,"mode":"ojs"},{"id":598,"value":"sel = view.toLowerCase()","pinned":false,"hidden":false,"mode":"ojs"},{"id":727,"value":"$32","pinned":true,"hidden":false,"mode":"ojs"},{"id":516,"value":"-----","pinned":false,"hidden":false,"mode":"md"},{"id":518,"value":"## TODO\n\n- [ ] sort the `y` axis by their end of the season position\n- [ ] 'home_team'\n- [ ] data structure to build the final table\n - home_team\n - away_team\n - home_score\n - away_score\n - home_standings\n - away_standings\n - match_week_no (x-axis)\n - [0 - 20 standings (y-axis)] - generic scale","pinned":false,"hidden":false,"mode":"md"},{"id":868,"value":"","pinned":true,"hidden":false,"mode":"ojs"},{"id":848,"value":"data1 = epl_1516","pinned":true,"hidden":false,"mode":"ojs"},{"id":869,"value":"// grouping matches by the date\nd3.group(epl_1516, d => new Date(d.date))","pinned":true,"hidden":false,"mode":"ojs"},{"id":882,"value":"// get a week number from a given string date\nfunction getISOWeekNumber(date) {\n const target = new Date(date);\n target.setHours(0, 0, 0, 0);\n\n // Thursday in current week decides the year.\n target.setDate(target.getDate() + 3 - ((target.getDay() + 6) % 7));\n\n const firstThursday = new Date(target.getFullYear(), 0, 4);\n firstThursday.setDate(firstThursday.getDate() + 3 - ((firstThursday.getDay() + 6) % 7));\n\n const w = 1 + Math.round(\n ((target - firstThursday) / 86400000 - 3 + ((firstThursday.getDay() + 6) % 7)) / 7\n );\n\n return w;\n}\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":975,"value":"// array with index of the week_year of that date\nyear_weeks = [...new Set(epl_1516.map(d => getISOWeekNumber(d.date)))]","pinned":true,"hidden":false,"mode":"ojs"},{"id":987,"value":"// you can now get the `indexOf` method from this array to get the match_week of that date\nyear_weeks.indexOf(50) + 1","pinned":true,"hidden":false,"mode":"ojs"},{"id":989,"value":"## Match Week wise matches","pinned":false,"hidden":false,"mode":"md"},{"id":992,"value":"d3.group(epl_1516, d => d.match_week_no).get(25)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1046,"value":"sel_team_data = epl_1516.filter(d => d['home_team'] == sel_team || d['away_team'] == sel_team)","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}