31:[] 2f:{"title":"📻 Wikidata's analytics for Radio France's podcasts 📻","cells":[{"id":0,"value":"# 📻 Wikidata's analytics for Radio France's podcasts 📻\n## Analyzing the list of recent participants of a Radio France podcast using Wikidata \n\nUsing [Wikidata's P10780 property](https://m.wikidata.org/wiki/Property:P10780) as a matching key, this notebook provides a set of features to analyse people mentioned in recent episodes of a Radio France podcast.\n\n⚠️CAVEAT⚠️: Wikidata is a very imperfect knowledge base. Data aren't always complete or accurate. The Radio France website is also very perfectible. Sometimes there is no identifier for the people involved in the program. So all results should be interpreted with caution. This notebook is an exploratory tool. ","pinned":false,"hidden":false,"mode":"md"},{"id":60,"value":"viewof url = Inputs.url({\n label: \"Enter the RSS feed of a podcast\",\n value: get_default().url\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":216,"value":"viewof property = Inputs.select(labels_map, {\n label: \"Select a property\",\n value: get_default().property\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":192,"value":"viewof lang = Inputs.text({\n label: \"Choose a language code\",\n value: get_default().lang\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":275,"value":"*${title}*: \n* RSS feed : ${url} ","pinned":false,"hidden":false,"mode":"md"},{"id":188,"value":"Share the link: https://observablehq.com/@pac02/radio-France-Wikidata?url=${url}&lang=${lang}&property=${property} ","pinned":false,"hidden":false,"mode":"md"},{"id":257,"value":"⚠️WARNING⚠️: Before looking at the results, you should check that the matching is mostly OK. Have a look at https://observablehq.com/@pac02/radio-france-wikidata?url=${url}. ","pinned":false,"hidden":false,"mode":"md"},{"id":176,"value":"## Aggregated results ","pinned":false,"hidden":false,"mode":"md"},{"id":226,"value":"Inputs.table(match2, {\n columns: [\"wikidata\", \"count\"],\n format: {\n wikidata: (d) => html`${d} `\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":234,"value":"## Details","pinned":false,"hidden":false,"mode":"md"},{"id":101,"value":"Inputs.table(match1, {\n columns: [\"date\", \"radiofrance\", \"wikidata\", \"valueLabel\"],\n format: {\n radiofrance: (d) => html`${d} `,\n wikidata: (d) => html`${d} `\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":97,"value":"## Appendix ","pinned":false,"hidden":false,"mode":"md"},{"id":279,"value":"title = await getTitle(url)","pinned":true,"hidden":false,"mode":"ojs"},{"id":36,"value":"lastpodcasts = getRSS(url)","pinned":true,"hidden":false,"mode":"ojs"},{"id":50,"value":"results = await Promise.all(lastpodcasts.map(async (d) => await getPeople(d)))\n .then((d) => d.flat())\n .then((d) => aq.from(d))","pinned":true,"hidden":false,"mode":"ojs"},{"id":203,"value":"import { get_labels } from \"@pac02/what-kind-of-articles-have-you-created\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":207,"value":"claim_labels = get_labels(\n [\n \"P21\",\n \"P27\",\n \"P106\",\n \"P101\",\n \"P103\",\n \"P1412\",\n \"P6886\",\n \"P140\",\n \"P69\",\n \"P166\",\n \"P1387\",\n \"P1142\",\n \"P136\"\n ],\n lang\n).then((d) => d.objects())","pinned":true,"hidden":false,"mode":"ojs"},{"id":210,"value":"labels_map = new Map(\n claim_labels.map(({ label, qid }) => [label + \" (\" + qid + \")\", qid])\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":106,"value":"query = `\nPREFIX rdfs: \nPREFIX schema: \nPREFIX wd: \nPREFIX wdt: \nSELECT ?item ?itemLabel ?value\n?valueLabel \n?radiofrance WHERE {\n ?item wdt:P10780 ?radiofrance;\n wdt:P31 wd:Q5 ;\n wdt:${property} ?value. \n OPTIONAL {?item rdfs:label ?itemLabel.\n FILTER((LANG(?itemLabel)) = \"${lang}\")}\nOPTIONAL {?value rdfs:label ?valueLabel.\n FILTER((LANG(?valueLabel)) = \"${lang}\")}}\n`","pinned":true,"hidden":false,"mode":"ojs"},{"id":108,"value":"data = fetch(\n `https://query.wikidata.org/sparql?query=${encodeURIComponent(query)}`,\n { headers: { accept: \"application/sparql-results+json\" } }\n).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs"},{"id":110,"value":"array = aq.from(\n data.results.bindings.map((d) => ({\n item: d.item.value,\n itemLabel: d.itemLabel?.value,\n value: d.value.value,\n valueLabel: d.valueLabel?.value,\n radiofrance: d.radiofrance.value\n }))\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":124,"value":"match = results\n .join_left(array, [\"people\", \"radiofrance\"])\n .filter((d) => d.item !== undefined)\n .derive({ radiofrance: (d) => ` ${d.people}` })\n .derive({\n wikidata: (d) =>\n ` ${d.itemLabel} (${op.replace(\n d.item,\n \"http://www.wikidata.org/entity/\",\n \"\"\n )})`\n })\n .derive({\n radiofrance2: (d) =>\n ` ${d.people}`\n })\n .orderby(aq.desc(\"date\"))","pinned":true,"hidden":false,"mode":"ojs"},{"id":242,"value":"match1 = results\n .join_left(array, [\"people\", \"radiofrance\"])\n .filter((d) => d.item !== undefined)\n .derive({ radiofrance: (d) => ` ${d.people}` })\n .derive({\n wikidata: (d) =>\n ` ${d.itemLabel} (${op.replace(\n d.item,\n \"http://www.wikidata.org/entity/\",\n \"\"\n )})`\n })\n .derive({\n radiofrance2: (d) =>\n ` ${d.people}`\n })\n .dedupe([\"date\", \"people\", \"item\", \"value\"])\n .orderby(aq.desc(\"date\"))","pinned":true,"hidden":false,"mode":"ojs"},{"id":246,"value":"match2 = match1\n .dedupe([\"people\", \"item\", \"value\"])\n .groupby([\"value\", \"valueLabel\"])\n .count()\n .derive({\n wikidata: (d) =>\n ` ${d.valueLabel} (${op.replace(\n d.value,\n \"http://www.wikidata.org/entity/\",\n \"\"\n )})`\n })\n .orderby(aq.desc(\"count\"))","pinned":true,"hidden":false,"mode":"ojs"},{"id":90,"value":"import { getPeople } from \"@pac02/how-to-get-the-list-of-participants-to-a-radio-program\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":112,"value":"import { aq, op } from \"@uwdata/arquero\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":115,"value":"import { getPodcasts } from \"@pac02/radio-france-podcast\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":154,"value":"import { getRSS, getTitle } from \"@pac02/get-rss-from-radiofrance\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":141,"value":"moment = require(\"moment\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":139,"value":"moment.locale(\"fr\", {\n months:\n \"janvier_février_mars_avril_mai_juin_juillet_août_septembre_octobre_novembre_décembre\".split(\n \"_\"\n ),\n monthsShort:\n \"janv._févr._mars_avr._mai_juin_juil._août_sept._oct._nov._déc.\".split(\"_\"),\n weekdays: \"dimanche_lundi_mardi_mercredi_jeudi_vendredi_samedi\".split(\"_\"),\n weekdaysShort: \"dim._lun._mar._mer._jeu._ven._sam.\".split(\"_\"),\n weekdaysMin: \"di_lu_ma_me_je_ve_sa\".split(\"_\")\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":184,"value":"get_default = () => {\n const params = new URL(document.URL).searchParams;\n const defaults = {\n url: \"https://radiofrance-podcast.net/podcast09/rss_10239.xml\",\n lang: \"fr\",\n property: \"P21\"\n };\n if (params.has(\"url\")) {\n defaults.url = params.get(\"url\");\n }\n if (params.has(\"property\")) {\n defaults.property = params.get(\"property\");\n }\n if (params.has(\"lang\")) {\n defaults.lang = params.get(\"lang\");\n }\n return defaults;\n}","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}