https://twitter.com/JoshuaFeIdman
Inputs.table(df.filter(d => +d.rating_match1 + +d.rating_match2 + +d.rating_match3 + +d.rating_match4 + +d.rating_match5 + +d.rating_match6 + +d.rating_match7 > 0).filter(d => position.includes(d.position)), {columns: ["team", "name", "position", "club", "league", "avgRating", "gamesPlayed", "rating_match1", "rating_match2", "rating_match3", "rating_match4", "rating_match5", "rating_match6", "rating_match7"], sort: "avgRating", reverse: true})
positions = new Set(df.map(d => d.position))
width
startingPosition = function(numPlayers) {
if(numPlayers == 5){return 1}
if(numPlayers == 4){return 1.5}
if(numPlayers == 3){return 2}
if(numPlayers == 2){return 2.5}
if(numPlayers == 1){return 3}
}
height = 700
x = d3.scaleLinear()
.domain([1, 5])
.range([150, width - 150])
y = d3.scaleBand()
.domain(["Goalkeeper", "Defender", "Midfielder", "Forward"])
.range([0, height])
y("Defender")
dreamTeam = [
topPlayerPerPosition('Goalkeeper'),
topPlayerPerPosition('Defender'),
topPlayerPerPosition('Midfielder'),
topPlayerPerPosition('Forward')
]
topPlayers = {
let combined = [].concat(topGoalkeeper, topDefenders, topMidfielders, topForwards)
combined.forEach((o, i) => o.overallId = i + 1);
return(combined)
}
maxGames = d3.max(df, d => d.gamesPlayed)
topGoalkeeper = {
update;
let filteredData = df.filter(d => d.avgRating > 0 & d.position == "Goalkeeper" & d.gamesPlayed >= (maxGames / 2)).sort(function(a, b) {
let random1 = Math.random();
let random2 = Math.random();
return d3.descending(+a.avgRating, +b.avgRating) || d3.descending(+a.gamesPlayed, +b.gamesPlayed) || d3.descending(random1, random2);
}).slice(0, 1)
filteredData.forEach(d => d.id = 3);
return filteredData;
}
topDefenders = {
update;
let numDefenders = formation.split("-")[0];
let filteredData = df.filter(d => d.avgRating > 0 & d.position == "Defender" & d.gamesPlayed >= (maxGames / 2)).sort(function(a, b) {
let random1 = Math.random();
let random2 = Math.random();
return d3.descending(+a.avgRating, +b.avgRating) || d3.descending(+a.gamesPlayed, +b.gamesPlayed) || d3.descending(random1, random2);
}).slice(0, numDefenders)
filteredData.forEach((o, i) => o.id = i + startingPosition(numDefenders));
return filteredData;
}
topMidfielders = {
update;
let numMidfielders = formation.split("-")[1];
let filteredData = df.filter(d => d.avgRating > 0 & d.position == "Midfielder" & d.gamesPlayed >= (maxGames / 2)).sort(function(a, b) {
let random1 = Math.random();
let random2 = Math.random();
return d3.descending(+a.avgRating, +b.avgRating) || d3.descending(+a.gamesPlayed, +b.gamesPlayed) || d3.descending(random1, random2);
}).slice(0, numMidfielders)
filteredData.forEach((o, i) => o.id = i + startingPosition(numMidfielders));
return filteredData;
}
topForwards = {
update;
let numForwards = formation.split("-")[2];
let filteredData = df.filter(d => d.avgRating > 0 & d.position == "Forward" & d.gamesPlayed >= (maxGames / 2)).sort(function(a, b) {
let random1 = Math.random();
let random2 = Math.random();
return d3.descending(+a.avgRating, +b.avgRating)|| d3.descending(+a.gamesPlayed, +b.gamesPlayed) || d3.descending(random1, random2);
}).slice(0, numForwards)
filteredData.forEach((o, i) => o.id = i + startingPosition(numForwards));
return filteredData;
}
topPlayerPerPosition = function(position) {
let data = df.filter(d => d.position == position);
let maxRating = d3.max(data.map(d => d.avgRating));
let topPlayer = data.filter(d => d.avgRating == maxRating).map(d => d.name);
return({
name: topPlayer,
position: position,
})
}
df.forEach(function(d) {
let gamesPlayed = +(d.rating_match1 != "") + +(d.rating_match2 != "") + +(d.rating_match3 != "") + +(d.rating_match4 != "") + +(d.rating_match5 != "") + +(d.rating_match6 != "") + +(d.rating_match7 != "");
let ratingSum = +d.rating_match1 + +d.rating_match2 + +d.rating_match3 + +d.rating_match4 + +d.rating_match5 + +d.rating_match6 + +d.rating_match7;
d.gamesPlayed = gamesPlayed;
d.avgRating = ratingSum / gamesPlayed;
if(d.position == "Forward (winger)") {d.position = "Forward"};
});
import {data as df} from "@joshua-feldman/euro-2020-squads-by-age"
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
