The avatar for @miker
miker
Public
Edited
Oct 15, 2024
Fork of NFL Draft: Sankey Diagram
4
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
teammovement_cleancomb2-5.csv
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
Insert cell
byseason
Insert cell
playermovements
(SELECT
team_2024 as id,
season as source,
move_extend as target,
COUNT(*) as value
FROM playermovements
WHERE player_event = player_total and team_2024 = ${team}
GROUP BY team_2024, season, move_extend
ORDER BY season asc)
UNION
--
SELECT
team_2024 as id,
move_extend as source,
team_2024 as target,
COUNT(*) as value
FROM playermovements
WHERE player_event = player_total and team_2024 = ${team}
GROUP BY team_2024, move_extend
ORDER BY season asc
Insert cell
playermoves_2024lists_clean-1.csv
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
d3Sankey = require.alias({"d3-array": d3, "d3-shape": d3, "d3-sankey": "d3-sankey@0.12.3/dist/d3-sankey.min.js"})("d3-sankey")
Insert cell
import {howto} from "@d3/example-components"
Insert cell
Insert cell

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.
Learn more