df1 = get_namedentities(articles[0], articles[1])
.then(d => aq.from(d))
df2 = get_namedentities(articles[2], articles[3])
.then(d => aq.from(d))
similarity = 100 * df1.semijoin(df2, 'item').numRows() / df1.join_full(df2, 'item').numRows()
df_summary = aq.from([
{ label: "Intersection", value: df1.semijoin(df2, 'item').numRows()},
{ label: "Article 1 only", value: df1.antijoin(df2, 'item').numRows()},
{label: "Article 2 only", value: df2.antijoin(df1, "item").numRows()}
])
df_summary.view()
get_namedentities = (article, project = "en.wikipedia.org" ) => {
const query = `SELECT ?item ?itemLabel ?gender ?genderLabel
WHERE {
SERVICE wikibase:mwapi {
bd:serviceParam wikibase:endpoint "` + project + `";
wikibase:api "Generator";
mwapi:generator "links";
mwapi:titles "` + article + `";.
?item wikibase:apiOutputItem mwapi:item.
}
FILTER BOUND (?item)
?item wdt:P31 wd:Q5 .
?item wdt:P21 ?gender .
?item rdfs:label ?itemLabel filter (lang(?itemLabel) = "en") .
?gender rdfs:label ?genderLabel filter (lang(?genderLabel) = "en") .
}
`
return fetch(`https://query.wikidata.org/sparql?query=${encodeURIComponent(query)}`, {headers: {accept: "application/sparql-results+json"}})
.then(response => response.json())
.then( d => d.results.bindings.map(res => ({
project: project,
article: article,
item: res.item.value,
itemLabel: res.itemLabel.value,
gender: res.gender.value,
genderLabel: res.genderLabel.value,
}))
)
}
get_namedentities("Économie (discipline)", "fr.wikipedia.org")
get_namedentities("Économie (discipline)", "fr.wikipedia.org")
.then(d => aq.from(d))
.then(d => d.view())
function wikilink(article, wikipedia) {
let url = "https://" + wikipedia + "/wiki/" + article.replace(/ /g, '_');
return `[${article}](${url})`;
}
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.
