2a:null 2b:["$","title",null,{"children":"Project - CS 725/825, Spring 2022 | Adeniyi | Observable"}] 30:Tfc4,{ // variables to get the dashboard to fit nicely const row_width = width * 0.45; const bar_chart_width = width * 0.45; const bar_chart_height = width * 0.5 const attributeSelect = vl.selectSingle().encodings("x"); const brush = vl.selectInterval().encodings('x'); const zscore = vl.markBar({width: 25}) .data(zScorePlot) .encode( vl.x().fieldN("Attribute").title(playerName +" Attribute"), vl.y().fieldQ("Zscores"), vl.tooltip(['Attribute', 'Zscores']), ) .width(row_width) .height(150) const teamAnalysisAge = vl.markBar({tooltip: true}) .data(selectedClub) .encode( vl.x().fieldQ('Age').axis({ format: 'd' }).title("Distribution of Age of players in " + clubchoice + " Club"), vl.y().count().axis({ }), vl.color( { // The first condition that is met applies. condition: [ { value: "red", test: { field: "Age", oneOf: [playerAge] } }, ], // Default color. value: "steelblue", } ), vl.tooltip(['Age']) ) .width(bar_chart_width) .height(100); const teamAnalysisbarchart = vl.markBar({tooltip: true}) .data(PostionGraph) .encode( vl.x().fieldQ("Total Count").title("Number of Players on " +clubchoice +" Club").axis({grid: true,tickCount: 5}), vl.y().fieldN("Position").sort("-x"), vl.color( { // The first condition that is met applies. condition: [ { value: "salmon", test: { field: "Position", oneOf: [playerPosition] } }, ], // Default color. value: "steelblue", } )) .width(row_width) .height(150); const ageDistribution = vl.markBar({tooltip: true}) .data(percentRankCategory) .params(brush) .encode( vl.x().fieldQ('Age').title("Distribution of Age of Other "+ outputPercentileName+" Picked players" ), vl.y().count().axis({ orient: 'right' }).axis({ }) //vl.color().value('steelblue') ) .width(bar_chart_width) .height(100); const zscoreTop50players = vl.markBar({tooltip: true}) .data(top50perpentile) .encode( vl.x().fieldN('Name').title( "Top 50 "+category + " "+positionSelect + " players names" ), vl.y().fieldQ('meanZscore'), vl.tooltip(['Name', 'meanZscore']), //vl.tooltip().fieldN(['meanZscore', 'Name']), vl.opacity().if(brush, vl.value(0.75)).value(0.05) ).select(attributeSelect).encode( vl.color().if(attributeSelect, vl.color().value("steelblue")).value("lightgrey") ) .width(row_width) .height(150); const lineChartTurnedPoint = vl.layer (vl.markCircle() .data(top50perpentile) .params(vl.selectInterval().bind("scales")) .encode( vl.x().fieldQ("avgCapability").scale({"domain": [0,100]}), vl.y().fieldQ(features).scale({"domain": [0,100]}), vl.tooltip().fieldN(['Name']), ).transform( vl.filter(attributeSelect) ) , vl.markCircle() .params(vl.selectInterval().bind("scales")) .data(selectedClub) .encode( vl.x().fieldQ("avgCapability").scale({"domain": [0,100]}), vl.y().fieldQ(features).scale({"domain": [0,100]}), vl.color( { // The first condition that is met applies. condition: [ { //param: "datum['Age'] === 20", oneOf: false, value: "salmon" value: "red", test: { field: "Name", oneOf: [playerName] } }, ], // Default color. value: "lightgrey", } ), vl.tooltip().fieldN(['Name']), ) ) .width(bar_chart_width).height(150) return vl.concat(teamAnalysisbarchart,zscore,teamAnalysisAge,ageDistribution,zscoreTop50players,lineChartTurnedPoint).spacing(8).columns(2).render(); }31:T554,pickFromAnalysisZscore = filtedByPosition.derive( { "PaceZscore" : aq.escape(d =>( d["Pace"] - picKFrombject.avgPace)/picKFrombject.stdPace), "DribblingZscore" : aq.escape(d =>( d["Dribbling"] - picKFrombject.avgDribble)/picKFrombject.stdDribble), "ShootingZscore" : aq.escape(d =>( d["Shooting"] - picKFrombject.avgShooting)/picKFrombject.stdShooting), "PassingZscore" : aq.escape(d =>( d["Passing"] - picKFrombject.avgPassing)/picKFrombject.stdPassing), "DefendingZscore" : aq.escape(d =>( d["Defending"] - picKFrombject.avgDefending)/picKFrombject.stdDefending), "PhysicalZscore" : aq.escape(d =>( d["Physical"] - picKFrombject.avgPhysical)/picKFrombject.stdPhysical), "GoalKeepingZscore" : aq.escape(d =>( d["GoalKeeping"] - picKFrombject.avgGoalKeeping)/picKFrombject.stdGoalKeeping), } ).select("Name","Age","Position","Club","Pace","Dribbling","Shooting","Defending","GoalKeeping","Physical","PaceZscore", "DribblingZscore", "ShootingZscore", "PassingZscore", "DefendingZscore","PhysicalZscore", "GoalKeepingZscore","avgCapability") .derive({ "meanZscore": aq.escape(d=> ((d['PaceZscore'] + d['DribblingZscore']+d['ShootingZscore'] + d['PassingZscore']+ d['DefendingZscore'] + d['GoalKeepingZscore'] + d["PhysicalZscore"])/6).toPrecision(4)), }).orderby("meanZscore") //aq.desc("meanZscore") "meanZscore" .reify()32:T8f5,{ const brush = vl.selectInterval().encodings('x'); const attributeSelect = vl.selectSingle().encodings("x"); const ageDistribution = vl.markBar({tooltip: true}) .data(percentRankCategory) .params(brush) .encode( vl.x().fieldQ('Age').title("Distribution of Age of Other "+ outputPercentileName+" Picked players" ), vl.y().count().axis({ orient: 'right' }).axis({ }) //vl.color().value('steelblue') ) .width(width/2.3) .height(400) .config({ view: { stroke: null }}) .padding(70); const zscoreTop50players = vl.markBar({tooltip: true}) .data(top50perpentile) .encode( vl.x().fieldN('Name').title("Names of players in" ), vl.y().fieldQ('meanZscore'), vl.tooltip(['Name', 'meanZscore']), //vl.tooltip().fieldN(['meanZscore', 'Name']), vl.opacity().if(brush, vl.value(0.75)).value(0.05) ).select(attributeSelect).encode( vl.color().if(attributeSelect, vl.color().value("steelblue")).value("lightgrey") ) .width(width/2.3) .height(250); const lineChartTurnedPoint = vl.layer (vl.markCircle() .data(top50perpentile) .params(vl.selectInterval().bind("scales")) .encode( vl.x().fieldQ("avgCapability").scale({"domain": [0,100]}), vl.y().fieldQ(features).scale({"domain": [0,100]}), vl.tooltip().fieldN(['Name']) ).transform( vl.filter(attributeSelect) ) , vl.markCircle() .params(vl.selectInterval().bind("scales")) .data(selectedClub) .encode( vl.x().fieldQ("avgCapability").scale({"domain": [0,100]}), vl.y().fieldQ(features).scale({"domain": [0,100]}), vl.color( { // The first condition that is met applies. condition: [ { //param: "datum['Age'] === 20", oneOf: false, value: "salmon" value: "red", test: { field: "Name", oneOf: [playerName] } }, ], // Default color. value: "lightgrey", } ), vl.tooltip().fieldN(['Name']) ) ) .width(width * 0.6).height(150) //.render() return vl.vconcat(vl.vconcat(ageDistribution,zscoreTop50players),lineChartTurnedPoint).render(); }33:T10bb, viewof sameple = embed({ "width": width/3, "height": 400, "padding": 60, "autosize": {"type": "none", "contains": "padding"}, "signals": [ {"name": "radius", "update": "width / 2"} ], "data": [ { "name": "table", "values":sampleFormat }, { "name": "keys", "source": "table", "transform": [ { "type": "aggregate", "groupby": ["key"] } ] } ], "scales": [ { "name": "angular", "type": "point", "range": {"signal": "[-PI, PI]"}, "padding": 0.5, "domain": {"data": "table", "field": "key"} }, { "name": "radial", "type": "linear", "range": {"signal": "[0, radius]"}, "zero": true, "nice": false, "domain": {"data": "table", "field": "value"}, "domainMin": 0 }, { "name": "color", "type": "ordinal", "domain": {"data": "table", "field": "category"}, "range": {"scheme": "category10"} } ], "encode": { "enter": { "x": {"signal": "radius"}, "y": {"signal": "radius"} } }, "marks": [ { "type": "group", "name": "categories", "zindex": 1, "from": { "facet": {"data": "table", "name": "facet", "groupby": ["category"]} }, "marks": [ { "type": "line", "name": "category-line", "from": {"data": "facet"}, "encode": { "enter": { "interpolate": {"value": "linear-closed"}, "x": {"signal": "scale('radial', datum.value) * cos(scale('angular', datum.key))"}, "y": {"signal": "scale('radial', datum.value) * sin(scale('angular', datum.key))"}, "stroke": {"scale": "color", "field": "category"}, "strokeWidth": {"value": 1}, "fill": {"scale": "color", "field": "category"}, "fillOpacity": {"value": 0.1} } } }, { "type": "text", "name": "value-text", "from": {"data": "category-line"}, "encode": { "enter": { "x": {"signal": "datum.x"}, "y": {"signal": "datum.y"}, "text": {"signal": "datum.datum.value"}, "align": {"value": "center"}, "baseline": {"value": "middle"}, "fill": {"value": "black"} } } } ] }, { "type": "rule", "name": "radial-grid", "from": {"data": "keys"}, "zindex": 0, "encode": { "enter": { "x": {"value": 0}, "y": {"value": 0}, "x2": {"signal": "radius * cos(scale('angular', datum.key))"}, "y2": {"signal": "radius * sin(scale('angular', datum.key))"}, "stroke": {"value": "lightgray"}, "strokeWidth": {"value": 1} } } }, { "type": "text", "name": "key-label", "from": {"data": "keys"}, "zindex": 1, "encode": { "enter": { "x": {"signal": "(radius + 5) * cos(scale('angular', datum.key))"}, "y": {"signal": "(radius + 5) * sin(scale('angular', datum.key))"}, "text": {"field": "key"}, "align": [ { "test": "abs(scale('angular', datum.key)) > PI / 2", "value": "right" }, { "value": "left" } ], "baseline": [ { "test": "scale('angular', datum.key) > 0", "value": "top" }, { "test": "scale('angular', datum.key) == 0", "value": "middle" }, { "value": "bottom" } ], "fill": {"value": "black"}, "fontWeight": {"value": "bold"} } } }, { "type": "line", "name": "outer-line", "from": {"data": "radial-grid"}, "encode": { "enter": { "interpolate": {"value": "linear-closed"}, "x": {"field": "x2"}, "y": {"field": "y2"}, "stroke": {"value": "lightgray"}, "strokeWidth": {"value": 1} } } } ] } ) 34:[{"id":"b68ac92a7b7d9df0e9fdf1a2e9b4b53eea810de9212edf95c7705c1c76cccf9a956fda7a3a510b65d627d8e8303112781212634cf09d15bfc5faac7b409a87aa","href":"https://static.observableusercontent.com/files/b68ac92a7b7d9df0e9fdf1a2e9b4b53eea810de9212edf95c7705c1c76cccf9a956fda7a3a510b65d627d8e8303112781212634cf09d15bfc5faac7b409a87aa","name":"england-premier-league-players-2018-to-2019-stats.csv","type":"text/csv","lastModified":1649337859906.048,"size":117204},{"id":"49cdf644dd1079c0fc14c64ea07feb92c2b728b186c9fe8483c2f3f632daebb6a91f3fd5d188f4972466f3d5f52d46ff4a5f7c90381147c24676cc4bc0e56ce2","href":"https://static.observableusercontent.com/files/49cdf644dd1079c0fc14c64ea07feb92c2b728b186c9fe8483c2f3f632daebb6a91f3fd5d188f4972466f3d5f52d46ff4a5f7c90381147c24676cc4bc0e56ce2","name":"data.csv","type":"text/csv","lastModified":1648729554169.103,"size":9140113}] 2e:{"id":"e8beb7504f6a9215","slug":"project-cs-725-825-spring-2022","title":"Project - CS 725/825, Spring 2022","thumbnail":"179e0ccda299095d95de826353ffa4e3be2420c75a713e03146e9fc8c24391ab","access_level":"public","create_time":"$D2022-03-29T21:49:55.779Z","update_time":"$D2022-05-31T22:12:34.715Z","view_time":null,"first_public_time":"$D2022-04-15T02:47:06.235Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"9c5cd9cf6b78af1c","login":"aaden001","name":"Adeniyi ","avatar_url":"https://avatars-next.observableusercontent.com/912b43f093c0aa354f0975eec9937fcfc34be3b20b6e10453c04605142abe64e","tier":"starter_2024"},"version":1488,"publish_version":1488,"role":null,"authored":false,"authors":[{"type":"individual","id":"94d2e0b182ec1917","login":"aaden001","name":"Adeniyi ","avatar_url":"https://avatars-next.observableusercontent.com/912b43f093c0aa354f0975eec9937fcfc34be3b20b6e10453c04605142abe64e","tier":null}],"members":[{"type":"individual","id":"94d2e0b182ec1917","login":"aaden001","name":"Adeniyi ","avatar_url":"https://avatars-next.observableusercontent.com/912b43f093c0aa354f0975eec9937fcfc34be3b20b6e10453c04605142abe64e","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Project - CS 725/825, Spring 2022","cells":[{"id":0,"value":"# [Project](https://github.com/odu-cs725-infovis/public/blob/main/spr22/project.md) - CS 725/825, Spring 2022\nName: Adeniran Adeniyi
\nTitle: English Premier League Recruiting/Scouting Dashboard
\nDescription: https://observablehq.com/@aaden001/project-report-cs-725-825-spring-2022\nDue: April 12th, 2022","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":575,"value":"viewof clubchoice = select(distinctPremierLeague.club) //distinctPremierLeague distinctFootballdata\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1397,"value":"viewof playerName = select(player.name) //distinctPremierLeague distinctFootballdata","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":560,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1420,"value":"Select what position you want to recruit players from","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1253,"value":"viewof positionSelect = select([\"Forwards\",\"MidFielders\", \"Defenders\",\"GK\"])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1256,"value":"viewof category = select([\"Very Poor\",\"Poor\", \"Average\",\"Excellent\"]) //Select from the percentage category of players based on overall performace in position metric.","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1418,"value":"viewof features = select([\"Pace\", \"Shooting\", \"Dribbling\", \"Defending\", \"GoalKeeping\",\"Passing\",\"Physical\"])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1361,"value":"top50perpentile.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"# Dataset\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":66,"value":"data was gotten and extracted from [FIFA]( https://github.com/amanthedorkknight/fifa18-all-player-statistics/tree/master/2019). \nand https://footystats.org/download-stats-csv","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":42,"value":"viewof football = aq.fromCSV(await FileAttachment(\"data.csv\").text())\n .view(1000\n )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":365,"value":"# Age Distribution","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":370,"value":"vl.markBar()\n .data(football)\n .encode(\n vl.x().fieldQ('Age').bin({ extent: [0, 50], maxbins: 50 }).axis({ format: 'd' }).title(\"Distribution of Age of players\"),\n vl.y().count().axis({ orient: 'right' }).axis({ })\n )\n .width(width)\n .height(200)\n .config({ view: { stroke: null }})\n .render()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":728,"value":"# Get English League Teams","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":203,"value":"viewof playerOnfield = aq.fromCSV(await FileAttachment(\"england-premier-league-players-2018-to-2019-stats.csv\").text())\n .view(1000\n )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":118,"value":"streamLined = football.select('ID','Name','Age','Nationality', 'Club', \"Position\",\n 'Crossing', 'Finishing','HeadingAccuracy','ShortPassing','Positioning', 'Volleys',//Attacking\n 'Dribbling','Curve', 'FKAccuracy', 'LongPassing', 'BallControl', // Skill\n 'Acceleration', 'SprintSpeed', 'Agility', 'Reactions', 'Balance', // Movement\n 'ShotPower', 'Jumping','Stamina','Strength', 'LongShots', //Power\n 'Aggression', 'Interceptions', 'Positioning', 'Vision','Penalties','Composure',//Mentality\n 'Marking', 'StandingTackle', 'SlidingTackle', //Defending\n 'GKDiving', 'GKHandling', 'GKKicking', 'GKPositioning', 'GKReflexes'// Goal Keeping\n).reify()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":218,"value":"//streamLinedOnfield = playerOnfield.select('full_name', 'age','position','minutes_played_overall', 'apperances_overall','goals_overall','assists_overall','clean_sheets_overall',)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":197,"value":"streamLined.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":228,"value":"Create statistic from player characteristics\n\nSetting up the main attributes for a better recruiting.\nReference From \n [FIFA](https://fifauteam.com/fifa-19-attributes-guide/) \n\nPace\n - Acceleration\n - Sprint Speed\n\nShooting\n - Finishing\n - Long Shots\n - Penalties\n - Positioning\n - Shot Power\n - Volleys\n\nPassing\n - Crossing\n - Curve\n - Free Kick\n - Long Passing\n - Short Passing\n - Vision\n\nDribbling\n - Agility\n - Balance\n - Ball Control\n - Composure\n - Dribbling\n - Reactions\n\nDefending\n - Heading\n - Interceptions\n - Marking\n - Sliding Tackle\n - Standing Tackle\n\nPhysical\n - Aggression\n - Jumping\n - Stamina\n - Strength\n\nGoalKeeping\n - Diving\n - Handling\n - Kicking\n - Positioning\n - Reflexes\n - Speed","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":232,"value":"computedStats = streamLined.derive({\n \"Pace\": d=> ((d['Acceleration'] + d['SprintSpeed'])/2),\n \"Shooting\": d => ((d['Finishing'] + d['LongShots']+d['Penalties'] +d['Positioning'] + d['ShotPower'] + d['Volleys'])/6),\n \"Passing\": d => ((d['Crossing'] + d['Curve']+ d['FKAccuracy']+d['LongPassing'] +d[\"ShortPassing\"]+d['Vision'] )/6),\n \"Dribbling\": d => ((d['Agility'] + d['Balance']+ d['BallControl']+d['Composure'] +d[\"Dribbling\"]+d['Reactions'] )/6),\n \"Defending\": d => ((d['HeadingAccuracy'] + d['Interceptions']+ d['Marking']+d['SlidingTackle'] +d[\"StandingTackle\"] )/5),\n \"Physical\": d => ((d['Aggression'] + d['Jumping']+ d['Stamina']+d['Strength'])/4),\n \"GoalKeeping\": d => ((d['GKDiving'] + d['GKHandling']+ d['GKKicking']+d['GKPositioning'] +d[\"GKReflexes\"]+d['SprintSpeed'] )/6)\n \n}).derive({\"avgCapability\": d=> (( d[\"Pace\"] + d[\"Shooting\"]+d[\"Passing\"] + d[\"Defending\"] + d[\"Physical\"] + d[\"GoalKeeping\"] +d[\"Dribbling\"])/7),})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":250,"value":"computedStats.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":139,"value":"# Distinct English Clubs \nGetting the total number of distinct Clubs and Nationalities of Players","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":132,"value":"distinctFootballdata = football.rollup({\n club: d => op.array_agg_distinct(d[\"Club\"]) ,// array of unique values for Club\n nation: d => op.array_agg_distinct(d[\"Nationality\"]), // array of unique values for Club\n position: d => op.array_agg_distinct(d[\"Position\"])\n})\n.objects()[0]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":207,"value":"distinctPremierLeague = playerOnfield.rollup({\n club: d => op.array_agg_distinct(d[\"Current Club\"]) ,// array of unique values for Club \n})\n.objects()[0]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":143,"value":"distinctFootballdata.nation","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":149,"value":"//viewof clubchoice = select(distinctPremierLeague.club) //distinctPremierLeague distinctFootballdata","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":145,"value":"selectedClub = computedStats\n .filter(aq.escape(d => d['Club'] === clubchoice))\n .reify()\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1277,"value":"experiment = selectedClub.reify()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1279,"value":"experiment.columnNames()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1288,"value":"experiment.objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1291,"value":"plotEx = experiment.rollup({values: d => op.array_agg(op.row_object(\"Name\", \"Dribbling\", \"Pace\", \"Shooting\", \"GoalKeeping\", \"Passing\"))}).objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":264,"value":"selectedClub.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":265,"value":"selectedClub.numRows() ///Total number of players in the team","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":294,"value":"PostionGraph = selectedClub.groupby('Position').count({as: 'Total Count'}).orderby(aq.desc(d => d[\"Total Count\"])).reify() ///Sort in descending order","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":375,"value":"PostionGraph.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":401,"value":"https://github.com/d3/d3-format#locale_format","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":379,"value":"vl.markBar({tooltip: true})\n .data(PostionGraph)\n .encode(\n vl.x().fieldQ(\"Total Count\").title(\"Number of Players\").axis({grid: true,tickCount: 5}),\n vl.y().fieldN(\"Position\").sort(\"-x\"),\n )\n .width(width/2)\n .height(200)\n .padding(\"1\")\n .render()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":286,"value":"# **${clubchoice}** Team Attribute Performance Metric","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":291,"value":"teamMetric = selectedClub.select('Pace','Dribbling','Shooting', 'Passing','Defending', 'Physical', 'GoalKeeping')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":322,"value":"teamMetric.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":298,"value":"teamMetricCalculated = teamMetric.rollup({\n avgPace: d => op.mean(d[\"Pace\"]),\n stdPace: d => op.stdev(d[\"Pace\"]),\n \n avgDribble: d => op.mean(d[\"Dribbling\"]) ,// The average score for dribble performance in the club\n stdDribble: d => op.stdev(d[\"Dribbling\"]), // The standard deviabtion for dribble performance in the club\n \n avgShooting: d => op.mean(d[\"Shooting\"]),\n stdShooting: d => op.stdev(d[\"Shooting\"]),\n \n avgPassing: d => op.mean(d[\"Passing\"]),\n stdPassing: d => op.stdev(d[\"Passing\"]),\n\n avgDefending: d => op.mean(d[\"Defending\"]),\n stdDefending: d => op.stdev(d[\"Defending\"]),\n\n avgPhysical: d => op.mean(d[\"Physical\"]),\n stdPhysical: d=> op.stdev(d[\"Physical\"]),\n\n avgGoalKeeping: d => op.mean(d[\"GoalKeeping\"]),\n stdGoalKeeping: d =>op.stdev(d['GoalKeeping'])\n}).reify()\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":326,"value":"teamMetricCalculated.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":345,"value":"converting it to an object","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":329,"value":"TMCObject = teamMetricCalculated.object()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":341,"value":"teamMetricCalculated.object().avgDribble","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":315,"value":"## **${clubchoice}** Adding Z-score computation/Standardization\n\nThis adds Z-score computation to a selected Team. For instance if we Picked Manchester United, the populated Man United Players Z-score gets calculated","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":321,"value":"teamAnalysisZscore = selectedClub.derive(\n {\n \"PaceZscore\" : aq.escape(d =>( d[\"Pace\"] - TMCObject.avgPace)/TMCObject.stdPace),\n \"DribblingZscore\" : aq.escape(d =>( d[\"Dribbling\"] - TMCObject.avgDribble)/TMCObject.stdDribble),\n \"ShootingZscore\" : aq.escape(d =>( d[\"Shooting\"] - TMCObject.avgShooting)/TMCObject.stdShooting),\n \"PassingZscore\" : aq.escape(d =>( d[\"Passing\"] - TMCObject.avgPassing)/TMCObject.stdPassing),\n \"DefendingZscore\" : aq.escape(d =>( d[\"Defending\"] - TMCObject.avgDefending)/TMCObject.stdDefending),\n \"PhysicalZscore\" : aq.escape(d =>( d[\"Physical\"] - TMCObject.avgPhysical)/TMCObject.stdPhysical),\n \"GoalKeepingZscore\" : aq.escape(d =>( d[\"GoalKeeping\"] - TMCObject.avgGoalKeeping)/TMCObject.stdGoalKeeping),\n }\n).select(\"Name\",\"PaceZscore\", \"DribblingZscore\", \"ShootingZscore\", \"PassingZscore\", \"DefendingZscore\",\"PhysicalZscore\", \"GoalKeepingZscore\").reify()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":427,"value":"teamAnalysisZscore.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":585,"value":"# **${clubchoice}** Team Age breakdown","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":362,"value":"vl.markBar({tooltip: true})\n .data(selectedClub)\n .encode(\n vl.x().fieldQ('Age').bin({ extent: [0, 50], maxbins: 50 }).axis({ format: 'd' }).title(\"Distribution of Age of players\"),\n vl.y().count().axis({ orient: 'right' }).axis({ })\n )\n .width(width)\n .height(200)\n .config({ view: { stroke: null }})\n .render()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":589,"value":"# Other Players (club or no club)\n\nAfter the seperation of players by club, the rest of the players that are not in the selected players are stored in the variable otherClubs","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":749,"value":"\n

\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":777,"value":"\n

\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":754,"value":"https://www.fifplay.com/encyclopedia/defender/","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":734,"value":"distinctFootballdata.position","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":799,"value":"This gives the image position of all forwards\n

\n","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":762,"value":"Forwards = [\"ST\",\"LW\", \"LF\", \"CF\", \"RF\", \"RW\",\"LS\",\"RS\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":785,"value":"This gives the image position of mid-fielders\n

\n","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":765,"value":"MidFielders = [\"CM\",\"RM\", \"LM\",\"CDM\",\"CAM\", \"RDM\", \"RAM\",\"LAM\",\"LDM\",\"LCM\",\"RCM\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":789,"value":"This gives the image position of defenders\n

\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":757,"value":"Defenders = [\n \"CB\",\"LB\", \"LWB\", \"RWB\",\"RB\",\"LCB\",\"RCB\"\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":884,"value":"GK = [\"GK\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":253,"value":"otherClubs = computedStats.filter(aq.escape(d => d['Club'] != clubchoice))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":258,"value":"otherClubs.view(1000)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":858,"value":"View the total number of players remaining in the dataset\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":855,"value":"otherClubs.numRows()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":862,"value":"# Position Search","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":831,"value":"positionSelect","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":901,"value":"A helper function used to select what position type we need","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":833,"value":"function SelectPositionVariable(pos, Forwards,MidFielders,Defenders,GK){\n if(pos === \"Forwards\"){\n return Forwards;\n }else if(pos===\"MidFielders\"){\n return MidFielders; \n }else if(pos ===\"GK\"){\n return GK;\n }\nreturn Defenders;\n\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":814,"value":"positionSet = new Set(SelectPositionVariable(positionSelect,Forwards,MidFielders,Defenders,GK))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":866,"value":"filtedByPosition = otherClubs\n .filter(aq.escape(d => positionSet.has(d[\"Position\"])))\n .reify()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":873,"value":"filtedByPosition.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":881,"value":"filtedByPosition.numRows()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":890,"value":"# **${positionSelect}** Analysis and computation","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":955,"value":"vl.markBar({tooltip: true})\n .data(filtedByPosition)\n .encode(\n vl.x().fieldQ('Age').title(\"Distribution of Age of Picked players\"),\n vl.y().count().axis({ orient: 'right' }).axis({ })\n )\n .width(width/2)\n .height(400)\n .config({ view: { stroke: null }})\n .padding(70)\n .render()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":905,"value":"pickFromCompute = filtedByPosition.rollup({\n avgPace: d => op.mean(d[\"Pace\"]),\n stdPace: d => op.stdev(d[\"Pace\"]),\n \n avgDribble: d => op.mean(d[\"Dribbling\"]) ,// The average score for dribble performance in the club\n stdDribble: d => op.stdev(d[\"Dribbling\"]), // The standard deviabtion for dribble performance in the club\n \n avgShooting: d => op.mean(d[\"Shooting\"]),\n stdShooting: d => op.stdev(d[\"Shooting\"]),\n \n avgPassing: d => op.mean(d[\"Passing\"]),\n stdPassing: d => op.stdev(d[\"Passing\"]),\n\n avgDefending: d => op.mean(d[\"Defending\"]),\n stdDefending: d => op.stdev(d[\"Defending\"]),\n\n avgPhysical: d => op.mean(d[\"Physical\"]),\n stdPhysical: d=> op.stdev(d[\"Physical\"]),\n\n avgGoalKeeping: d => op.mean(d[\"GoalKeeping\"]),\n stdGoalKeeping: d =>op.stdev(d['GoalKeeping'])\n}).reify()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":908,"value":"pickFromCompute.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":913,"value":"picKFrombject = pickFromCompute.object()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":916,"value":"$31","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":920,"value":"pickFromAnalysisZscore.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1041,"value":"totalSelected = pickFromAnalysisZscore.numRows()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1049,"value":"# **${positionSelect}** Percentile Calculation\n\nPercentile Rank = [n /N] x 100\n\nWhere, n =ordinal rank of a given value \n\n N = number of values in the data set,\n\n P = Percentile","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1011,"value":"percentRank = pickFromAnalysisZscore.derive({\n \"rank\": op.rank(d=> d[\"meanZscore\"])\n}).reify()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1013,"value":"descPercentRank = percentRank.derive({\n \"percentile\": aq.escape(d => d[\"rank\"]/totalSelected)\n}).orderby(aq.desc(\"meanZscore\")).reify()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1079,"value":"descPercentRank.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1099,"value":"# Range based Picking","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1061,"value":"//viewof category = select([\"Very Poor\",\"Poor\", \"Average\",\"Excellent\"])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1146,"value":"category","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1065,"value":"percentInterval =pickPlayerCategory(category)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1144,"value":"outputPercentileName = (category == \"Excellent\"? \"Excellent\": category) ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1056,"value":"function pickPlayerCategory(category){\n var rangeObj = { start: 0, finish: .25};\n if(category ===\"Poor\"){\n rangeObj.finish =.50;\n rangeObj.start =.25;\n }\n else if(category === \"Average\"){\n rangeObj.finish =.75;\n rangeObj.start =.50;\n }else if(category === \"Excellent\"){\n rangeObj.finish =1.00;\n rangeObj.start =.75;\n }\n return rangeObj;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1075,"value":"percentRankCategory = descPercentRank\n .filter(aq.escape(d =>(d[\"percentile\"] > percentInterval.start)))\n .filter(aq.escape(d =>(d[\"percentile\"] <=percentInterval.finish))).reify()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1108,"value":"top50perpentile = percentRankCategory.slice(0,50).reify() /// so much people, used this to get the top 50 player of each percentile","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1123,"value":"top50perpentile.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":933,"value":"pickFromAnalysisZscore.numRows()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":995,"value":"PostionGraph = selectedClub.groupby('Position').count({as: 'Total Count'}).orderby(aq.desc(d => d[\"Total Count\"])).reify() ///Sort in descending order","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":280,"value":"# Team Player Selection\nThis does the selection of individual players in a selected club","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":276,"value":"player = selectedClub.rollup({\n name: d => op.array_agg_distinct(d[\"Name\"]) ,// array of unique values for Club\n postion: d => op.array_agg_distinct(d[\"Position\"]) // array of unique values for Club\n})\n.objects()[0]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":594,"value":"playerMainInfor = selectedClub\n .filter( aq.escape(d => d['Name'] === playerName))\n .select(\"Age\", \"Position\")\n .reify()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":612,"value":"playerMainInfor2 = selectedClub\n .filter( aq.escape(d => d['Name'] === playerName))\n .select(\"Crossing\", \"Finishing\", \"HeadingAccuracy\", \"ShortPassing\",\"Positioning\",\"Volleys\", \"Curve\",\"FKAccuracy\",\"LongPassing\", \"BallControl\", \"Acceleration\", \"SprintSpeed\", \"Agility\", \"Reactions\", \"Balance\", \"ShotPower\", \"Jumping\", \"Stamina\", \"Strength\", \"LongShots\", \"Aggression\",\"Interceptions\",\"Vision\", \"Penalties\", \"Composure\", \"Marking\", \"StandingTackle\", \"SlidingTackle\",\"GKDiving\", \"GKHandling\", \"GKKicking\", \"GKPositioning\", \"GKReflexes\")\n .reify()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":949,"value":"# Player stats Displayed - **${playerName}** From **${clubchoice}**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":703,"value":"playerMainInfor2.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":610,"value":"playerBasicInfor = playerMainInfor.object()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":617,"value":"playerAge = playerBasicInfor.Age","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":619,"value":"playerPosition =playerBasicInfor.Position","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":272,"value":"//viewof playerName = select(player.name) //distinctPremierLeague distinctFootballdata","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":462,"value":"vl.markBar({tooltip: true})\n .data(zScorePlot)\n .encode(\n vl.x().fieldN(\"Attribute\"),\n vl.y().fieldQ(\"Zscores\"),\n )\n .width(width/3)\n .height(400)\n .render()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":444,"value":"zScorePlot = \n aq.fromArrow(\n aq.toArrow(\n formatZFunction(\n teamAnalysisZscore\n .filter(aq.escape(d => d[\"Name\"] === playerName))\n .select(\"PaceZscore\", \"DribblingZscore\", \"ShootingZscore\", \"PassingZscore\", \"DefendingZscore\",\"PhysicalZscore\", \"GoalKeepingZscore\")\n .object()\n )\n )\n )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1482,"value":"formatZFunction(\n teamAnalysisZscore\n .filter(aq.escape(d => d[\"Name\"] === playerName))\n .select(\"PaceZscore\", \"DribblingZscore\", \"ShootingZscore\", \"PassingZscore\", \"DefendingZscore\",\"PhysicalZscore\", \"GoalKeepingZscore\")\n .object()\n )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":484,"value":"zScorePlot.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":457,"value":"function was gotten from \nhttps://www.tutorialspoint.com/split-keys-and-values-into-separate-objects-javascript\n\nThe function was used to transpose the JSON format to an appropraite format used for ploting the barchart","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":449,"value":" formatZFunction = obj => {\n const keys = Object.keys(obj);\n const res = [];\n for(let i = 0; i < keys.length; i++){\n res.push({\n 'Attribute': keys[i],\n 'Zscores': obj[keys[i]]\n });\n };\n return res;\n};","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1404,"value":"$32","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":431,"value":"/**newtable = aq.fromJSON(teamAnalysisZscore\n .filter(aq.escape(d => d[\"Name\"] === playerName))\n .select(\"PaceZscore\", \"DribblingZscore\", \"ShootingZscore\", \"PassingZscore\", \"DefendingZscore\", \"GoalKeepingZscore\")\n .objects())**/","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":438,"value":"///newtable.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":112,"value":"# Experimental Testing","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":504,"value":"sampleFormat = [\n {\"key\": \"pace\", \"value\": 19, \"category\": 0},\n {\"key\": \"shooting\", \"value\": 22, \"category\": 0},\n {\"key\": \"passing\", \"value\": 14, \"category\": 0},\n {\"key\": \"dribbling\", \"value\": 38, \"category\": 0},\n {\"key\": \"defending\", \"value\": 50, \"category\": 0},\n {\"key\": \"physical\", \"value\": 5, \"category\": 0},\n {\"key\": \"goalkeeping\", \"value\": 27, \"category\": 0},\n {\"key\": \"pace\", \"value\": 12, \"category\": 1},\n {\"key\": \"shooting\", \"value\": 42, \"category\": 1},\n {\"key\": \"passing\", \"value\": 13, \"category\": 1},\n {\"key\": \"dribbling\", \"value\": 6, \"category\": 1},\n {\"key\": \"defending\", \"value\": 15, \"category\": 1},\n {\"key\": \"physical\", \"value\": 8, \"category\": 1},\n {\"key\": \"goalkeeping\", \"value\": 27, \"category\": 1},\n ]\n ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":507,"value":" zscore = vl.markBar({tooltip: true})\n .data(zScorePlot)\n .encode(\n vl.x().fieldN(\"Attribute\"),\n vl.y().fieldQ(\"Zscores\"),\n )\n .width(width/3)\n .height(400);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":108,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":550,"value":"sameple","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":543,"value":"{\n return vl.vconcat(sameple,zscore)\n .spacing(5)\n .render();\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"# Appendix","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":21,"value":"import { aq, op} from '@uwdata/arquero'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":147,"value":"import {select} from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":647,"value":"import {vl} from '@vega/vega-lite-api-v5'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":500,"value":"embed = require(\"vega-embed\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"# References\n\n\n1.https://www.includehelp.com/code-snippets/how-to-access-an-object-having-spaces-in-the-objects-key-using-javascript.aspx
\n2.https://uwdata.github.io/arquero/api/#loadArrow
\n3.https://observablehq.com/@mahog/vega-tutorial-1-lets-make-a-bar-chart
\n4.https://stackoverflow.com/questions/68805413/how-do-i-highlight-specific-bar-s-using-vega-lite
\n5.https://www.youtube.com/watch?v=WTB6peagZR8
\n6.https://observablehq.com/@uwdata/interaction
","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 2f:"$2e:body"