2d:null 2e:["$","title",null,{"children":"Paires entre commanditaires et entreprises de sondage | duong tam kien | Observable"}] 33:[] 31:{"id":"9ba7caba74e6c81c","slug":"presidentielle2022-commanditaires-sondeurs","title":"Paires entre commanditaires et entreprises de sondage","thumbnail":"6deb5e62b5b9f1b74a4bcee3853de61b05c91d0aa0b006c005c7071bf5a0f1d1","access_level":"public","create_time":"$D2022-02-17T09:58:05.032Z","update_time":"$D2022-02-18T10:58:05.465Z","view_time":null,"first_public_time":"$D2022-02-17T11:01:29.538Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"1f9cc8778f5cc6bc","login":"taniki","name":"duong tam kien","avatar_url":"https://avatars-next.observableusercontent.com/c36ffc09c10b04541407cfdcb63a4b49932d84cfacabc2b0c2e3a26a19f4cfd8","tier":"starter_2024"},"version":241,"publish_version":241,"role":null,"authored":false,"authors":[{"type":"individual","id":"043b76eec3017fff","login":"taniki","name":"duong tam kien","avatar_url":"https://avatars-next.observableusercontent.com/c36ffc09c10b04541407cfdcb63a4b49932d84cfacabc2b0c2e3a26a19f4cfd8","tier":null}],"members":[{"type":"individual","id":"043b76eec3017fff","login":"taniki","name":"duong tam kien","avatar_url":"https://avatars-next.observableusercontent.com/c36ffc09c10b04541407cfdcb63a4b49932d84cfacabc2b0c2e3a26a19f4cfd8","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"c38ef1694fe421f4","slug":"election-presidentielle-france-2022","title":"élection présidentielle - france - 2022","owner":{"id":"1f9cc8778f5cc6bc","login":"taniki","name":"duong tam kien"}},"type":"notebook","body":{"title":"Paires entre commanditaires et entreprises de sondage","cells":[{"id":0,"value":"# Paires entre commanditaires et entreprises de sondage\n## Élection présidentielle 2022","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":35,"value":"### To do\n\n- Ammoindrir la sur-représentation des rollings\n- Voir s'il y a des paires régulières et exclusives\n- Voir s'il y a des préférences d'hypothèse selon les commanditaires et entreprises de sondage","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":136,"value":"## Qui font les sondages électoraux ?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":40,"value":"Plot.plot({\n y: {\n grid: true,\n round: true\n },\n x: {\n domain: sondages\n .sort((a,b) => sondages\n .filter(d=> d.entreprise == a.entreprise).length - sondages.filter(d=> d.entreprise == b.entreprise)\n .length\n )\n .reverse()\n .map(d => d.entreprise)\n },\n marks: [\n Plot.barY(sondages, Plot.groupX({y: \"count\"}, {x: \"entreprise\"}))\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":140,"value":"## Qui commandent des sondages électoraux (publiés) ?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":55,"value":"Plot.plot({\n marginLeft: 150,\n x: { grid: true },\n y: {\n domain: commanditaires\n .sort((a,b) => commanditaires.filter(c => c.commanditaire == a.commanditaire).length - commanditaires.filter(c => c.commanditaire == b.commanditaire).length)\n .reverse()\n .map(d => d.commanditaire)\n },\n marks: [\n Plot.barX(commanditaires, Plot.groupY({x: \"count\"}, {y: \"commanditaire\"}))\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":126,"value":"## Qui travaille pour qui ?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":111,"value":"html`\n \n \n \n ${Array.from(d3.group(sondages, d => d.entreprise ), ([key, values]) => html`\n \n \n \n `)}\n

Entreprise	Commanditaires
${ key }	\n ${\n [...new Set(values.map(d => d.commanditaire).flat())]\n .filter(d => d != undefined)\n .map(c => ({ c, s: sondages.filter(s => s.commanditaire?.includes(c) && s.entreprise == key).length }))\n .sort((a,b) => a.s - b.s).reverse()\n .map(({c, s}) => `${c} (${s})`)\n .join(', ')\n }\n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":130,"value":"## Quelles sont les préférences des commanditaires pour certain·e·s candidat·e·s ?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":160,"value":"commanditaires_candidats = {\n const data = [ ... new Set(commanditaires.map(c => c.commanditaire))]\n .map(c => sondages.filter(s => s.commanditaire?.includes(c)).map(s => ({...s, commanditaire : c })) )\n .flat()\n .map(s => s.intentions.map(i => ({ id: s.id, candidat: i.candidat, commanditaire: s.commanditaire, tour: i.tour, hypothese: i.hypothese })))\n .flat()\n\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":203,"value":"### préférences exclusives","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":215,"value":"Inputs.table(exclusif_apparition, { columns: [\"commanditaire\", \"candidats_exclusifs\" ] })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":188,"value":"exclusif_apparition = {\n const l = [ ... new Set(commanditaires.map(c => c.commanditaire))]\n \n return l.map(c => {\n let candidats_in = [...new Set(\n commanditaires_candidats\n .filter(candidat => candidat.commanditaire == c)\n .map(candidat => candidat.candidat)\n )]\n\n let candidats_out = [...new Set(\n commanditaires_candidats\n .filter(candidat => candidat.commanditaire != c)\n .map(candidat => candidat.candidat)\n )]\n\n let candidats_exclusifs = candidats_in.filter(candidat => !candidats_out.includes(candidat))\n\n return { commanditaire: c, candidats_exclusifs, candidats_in, candidats_out}\n })\n .filter(commanditaire => commanditaire.candidats_exclusifs.length > 0)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":239,"value":"## absences exclusives","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":229,"value":"html`\n \n \n \n ${ exclusif_ommission.map(liste => html`\n \n \n \n `)}\n

Entreprise	Commanditaires
${ liste.commanditaire }	\n ${ liste.candidats_exclus.join(', ')}\n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":213,"value":"exclusif_ommission = {\n const l = [ ... new Set(commanditaires.map(c => c.commanditaire))]\n \n return l.map(c => {\n let candidats_in = [...new Set(\n commanditaires_candidats\n .filter(candidat => candidat.commanditaire == c)\n .map(candidat => candidat.candidat)\n )]\n\n let candidats_out = [...new Set(\n commanditaires_candidats\n .filter(candidat => candidat.commanditaire != c)\n .map(candidat => candidat.candidat)\n )]\n\n let candidats_exclus = candidats_out.filter(candidat => !candidats_in.includes(candidat))\n\n return { commanditaire: c, candidats_exclus, candidats_in, candidats_out}\n })\n .filter(commanditaire => commanditaire.candidats_exclus.length > 0)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":207,"value":"### sur-représentations","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":8,"value":"## Données\n\nhttps://github.com/nsppolls/nsppolls","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":67,"value":"Inputs.table(commanditaires)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":63,"value":"commanditaires = {\n const l = [ ... new Set(sondages.map(d => d.commanditaire).flat()) ].filter(d => d != undefined )\n\n return l.map(commanditaire => sondages.filter(s => s.commanditaire?.includes(commanditaire)).map(s => ({...s, commanditaire}))).flat()\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"Inputs.table(sondages)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"sondages = {\n const ids = [... new Set(brutes.map(d => d.id))]\n const data = ids.map(id => {\n const sondage = brutes.find(d=>d.id == id)\n\n const commanditaire = sondage.commanditaire?.split(',').map(d => d.trim() )\n const entreprise = sondage.nom_institut\n const echantillon = sondage.echantillon\n const intentions = brutes.filter(s => s.id == id)\n \n return { id, commanditaire, entreprise, echantillon, intentions }\n })\n\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"Inputs.table(brutes)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"brutes = d3.csv(\"https://raw.githubusercontent.com/nsppolls/nsppolls/master/presidentielle.csv\", d3.autoType)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 32:"$31:body"