data analyst • mediapart
d3 = require("d3-array", "d3-dsv@2", "d3-time", "d3-time-format")
matches = d3.csvParse(await FileAttachment("matches.csv").text(), d3.autoType)
timeWasted = d3.sum(matches, d => d.gameDuration)
function minutes(duration){
return parseInt(duration/60)
}
function hours(duration){
return parseInt(duration/(60*60))
}
function days(duration){
return parseInt(duration/(24*60*60))
}
firstGame = d3.min(matches, d => d.gameCreation)
lastGame = d3.max(matches, d => d.gameCreation)
function formatDate(d) {
var format = d3.timeFormat("%d/%m/%Y");
return format(d);
}
daysList = [...new Set(d3.map(matches, d => {
var format = d3.timeFormat("%Y-%m-%d");
return format(d.gameCreation)
}))]
totalDurationByDay = d3.rollup(matches,
v => d3.sum(v, d => d.gameDuration),
d => {
var format = d3.timeFormat("%Y-%m-%d");
return format(d.gameCreation)
})
meanDuration = parseInt(d3.mean(d3.map(totalDurationByDay, d => d[1])) / 60)
interval = d3.utcDay.every(1) // sample frequency
stop = interval() // exclusive
start = interval.offset(stop, -d3.timeDay.count(firstGame, lastGame))
import { TimeAxis, TimeChart, wave } from "@observablehq/timechart"
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.
