df = aq
.fromCSV(await FileAttachment("WednesdayIndex@3.csv").text(), {
parse: { date: String }
})
.derive({
date2: aq.escape((d) => dateparser(d.date)),
page: (d) => op.replace(d.page, /_/g, " ")
})
.select(["date2", "page", "male", "female", "non-binary"])
df.view()
df_long = df
.fold(["male", "female", "non-binary"], { as: ["gender", "value"] })
.groupby(["date2", "page"])
.derive({ share: (d) => (100 * d.value) / op.sum(d.value) })
.ungroup()
df_aggregate = df_long
.groupby(["date2", "gender"])
.rollup({ value: (d) => op.sum(d.value) })
.ungroup()
.groupby("date2")
.derive({ share: (d) => (100 * d.value) / op.sum(d.value) })
df_long.view()
pages = df.dedupe("page").array("page")
pages.length
df_select = df_long.filter(aq.escape((d) => d.page === page))
// debugging thanks to https://stackoverflow.com/questions/4587060/determining-date-equality-in-javascript
df_wg = df_long
.filter(aq.escape((d) => d.date2.getTime() === week.getTime()))
.filter(aq.escape((d) => d.gender === g))
weeks = df.dedupe("date2").array("date2")
genders = ["male", "female", "non-binary"]
import { aq, op } from "@uwdata/arquero"
// inspired by https://stackoverflow.com/questions/10638529/how-to-parse-a-date-in-format-yyyymmdd-in-javascript
dateparser = function parse(str) {
if (!/^(\d){6}$/.test(str)) return "invalid date";
var y = "20" + str.substr(0, 2),
m = str.substr(2, 2),
d = str.substr(4, 2);
return new Date(y + "-" + m + "-" + d);
}
dateparser("211124")
WednesdayIndex.csv
Type Table, then Shift-Enter. Ctrl-space for more options.
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.
