Type JavaScript, then Shift-Enter. Ctrl-space for more options. Arrow ↑/↓ to switch modes.
df_fr.dedupe().filter(d => d.itemLabel === d.maleform & d.itemLabel != d.femaleform).view()
Type JavaScript, then Shift-Enter. Ctrl-space for more options. Arrow ↑/↓ to switch modes.
df_fr.dedupe().filter(d => d.itemLabel != d.maleform & d.itemLabel === d.femaleform).view()
df_fr.dedupe().filter(d => d.itemLabel === d.maleform & d.itemLabel === d.femaleform).view()
Type JavaScript, then Shift-Enter. Ctrl-space for more options. Arrow ↑/↓ to switch modes.
df_fr.dedupe().filter(d => d.itemLabel != d.maleform & d.itemLabel != d.femaleform).view()
data_fr = fetch(`https://query.wikidata.org/sparql?query=${encodeURIComponent(query_fr)}`, {headers: {accept: "application/sparql-results+json"}}).then(response => response.json())
df_fr = aq.from(data_fr.results.bindings.map(res => ({
item: res.item.value,
itemLabel: res.itemLabel.value,
maleform: res.maleform.value,
femaleform: res.femaleform.value,
lang: res.lang.value,
})))
df_fr2 = df_fr.derive(
{id: d => 1*(d.itemLabel === d.maleform & d.itemLabel != d.femaleform)
+ 2*(d.itemLabel !== d.maleform & d.itemLabel === d.femaleform)
+ 3*(d.itemLabel === d.maleform & d.itemLabel === d.femaleform)
+ 4*(d.itemLabel !== d.maleform & d.itemLabel !== d.femaleform)
}
).join_left(
aq.table({ id: [1, 2, 3, 4], type: ["male-generic", "female-generic", "epicene", "different"] }),
"id"
).dedupe()
Type JavaScript, then Shift-Enter. Ctrl-space for more options. Arrow ↑/↓ to switch modes.
male_generic = df_fr.dedupe().filter(d => d.itemLabel === d.maleform & d.itemLabel != d.femaleform).numRows()
female_generic = df_fr.dedupe().filter(d => d.itemLabel !== d.maleform & d.itemLabel === d.femaleform).numRows()
male_female_label = df_fr.dedupe().filter(d => d.itemLabel === d.maleform & d.itemLabel === d.femaleform).numRows()
other_label = df_fr.dedupe().filter(d => d.itemLabel !== d.maleform & d.itemLabel !== d.femaleform).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.
