Olympic medals by group of countries 🥇🥈🥉Olympic medals by continent 🥇🥈🥉
Unequal distribution of medals 🥇🥈🥉
athletes = aq.loadCSV(
"https://raw.githubusercontent.com/taniki/paris2024-data/main/datasets/athletes.csv"
)
athletes.view()
countries = athletes.dedupe(["country_code", "country_name"])
countries1 = athletes
.groupby(["country_code", "country_name"])
.count()
.orderby(aq.desc("count"))
.derive({
share: (d) => d.count / op.sum(d.count)
})
.derive({
cumshare: aq.rolling((d) => op.sum(d.share)),
row: op.row_number()
})
Inputs.table(countries1, { layout: "auto" })
medals = aq.loadCSV(
"https://raw.githubusercontent.com/taniki/paris2024-data/main/datasets/medal_countries.long.auto.csv"
)
Inputs.table(medals, { layout: "auto" })
gold = countries
.select({ country_code: "code" })
.join_left(
medals.filter((d) => d.medal == "gold"),
"code"
)
.impute({ quantity: () => 0 })
.derive({
share: (d) => d.quantity / op.sum(d.quantity)
})
.orderby(aq.desc("quantity"))
.derive({
cumshare: aq.rolling((d) => op.sum(d.share)),
row: op.row_number()
})
all = countries
.select({ country_code: "code" })
.join_left(
medals
.groupby(["code", "country"])
.rollup({ quantity: (d) => op.sum(d.quantity) }),
"code"
)
.impute({ quantity: () => 0 })
.derive({
share: (d) => d.quantity / op.sum(d.quantity)
})
.orderby(aq.desc("quantity"))
.derive({
cumshare: aq.rolling((d) => op.sum(d.share)),
row: op.row_number()
})
gold.view()
Inputs.table(gold, { layout: "auto" })
gold.numRows()
import { aq, op } from "@uwdata/arquero"
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.
