2d:null 2e:["$","title",null,{"children":"2022 Year Recap for French data scientists network | Lino Galiana | Observable"}] 33:Td8d,// Line for network evolution = { let p = addTooltips( Plot.plot({ y: { grid: true, label: "↑ Nombre d'inscrits à la liste de diffusion" }, marks: [ Plot.line(serie_contacts, { x: "date", y: "mail", stroke: "#6886bb" //marker: "circle", //curve: "step", strokeWidth: 1 }), Plot.dot(serie_contacts, { x: "date", y: "mail", title: (d) => `${new Date(d.date).toLocaleDateString("en-US", { timeZone: "UTC" })} \n ${d.mail} inscrits `, fill: "#6886bb" //marker: "circle", //curve: "step", strokeWidth: 1 }), // vertical rule to mark date/time of event Plot.ruleX([d3.utcParse("%Y-%m-%d")("2022-06-30"), d3.utcParse("%Y-%m-%d")("2022-09-05")], { stroke: "gray", strokeWidth: 2, strokeDasharray: "4 2" }), Plot.text([[0]], { text: ["Réseau en pause pendant \n les vacances d'été 🌞"], x: middleDate, fontSize: 15, fontWeight: "bold", y: 290, textAnchor: "center" //fill: "#6886bb" }), width > 500 ? Plot.text(annotations, { x: "date", y: "textCount", lineHeight: 1.3, width: 20, fontSize: 15, fontWeight: "bold", text: (d) => `${new Date(d.date).toLocaleDateString("en-US", { timeZone: "UTC" })} \n ${d.text} `, textAnchor: "start" }) : [ Plot.text(annotations, { x: "date", y: "textCount", lineHeight: 1.3, fontSize: 15, fontWeight: "bold", width: 20, fill: "#6886bb", text: (d, i) => i + 1, textAnchor: "center" }), Plot.dot(annotations, { x: "date", y: "textCount", r: 10 }) ], Plot.arrow(annotations, { x2: "date", y1: "textCount", x1: "endDate", y2: "endCount", // dx: 14, bend: 20, inset: 5, head: null, strokeOpacity: 0.5 }) ], marginLeft: 50, marginRight: 70, width: 900, height: 500, caption: width > 500 ? "" : html`

Dérouler la timeline du réseau

${annotations .map( (d, i) => `(${i + 1}) ${new Date(d.date).toLocaleDateString("en-US", { timeZone: "UTC" })} – ${d.text} ` ) .join("
")}

` }), { fill: "red", stroke: "blue", r: 8 } ) let sel = d3.select(p).selectAll("svg > g > text").style("font-size", "15px").style("font-weight", "bold"); let sel2 = d3.select(p).selectAll("svg g.tick > text").style("font-size", "15px").style("font-weight", "bold"); let sel3 = d3.select(p).selectAll("svg .hover").style("font-size", "15px") ; return p } 34:T5cb,// Source: https://observablehq.com/@mbostock/dashboard grid = width > 500 ? html`

${viewof input_date}

${plt2}

${plt1}

${plt3}

` : html`

${viewof input_date}

${plt2}

${plt1}

${plt3}

` 35:Tc23,// Line for network plt1 = { let p = addTooltips( Plot.plot({ y: { domain: [110,320], grid: true, label: "↑ Nombre d'inscrits à la liste de diffusion" }, marks: [ Plot.dot(serie_contacts, { x: "date", y: "mail", fill: "#6886bb", title: (d) => `${new Date(d.date).toLocaleDateString("en-US", { timeZone: "UTC" })} \n ${d.mail} inscrits ` //marker: "circle", //curve: "step", strokeWidth: 1 }), Plot.line(serie_contacts, { x: "date", y: "mail", stroke: "#6886bb" //marker: "circle", //curve: "step", strokeWidth: 1 }), Plot.dot(serie_contacts.filter(d => dateFormat(d.date) <= dateFormat(input_date)), { x: "date", y: "mail", fill: "red", title: (d) => `${new Date(d.date).toLocaleDateString("en-US", { timeZone: "UTC" })} \n ${d.mail} inscrits ` //marker: "circle", //curve: "step", strokeWidth: 1 }), Plot.line(serie_contacts.filter(d => dateFormat(d.date) <= dateFormat(input_date)), { x: "date", y: "mail", stroke: "red" //marker: "circle", //curve: "step", strokeWidth: 1 }), Plot.arrow(annotations.filter(d => dateFormat(d.date) == dateFormat(input_date)), { x2: "date", y1: "textCount", x1: "endDate", y2: "endCount", // dx: 14, bend: 20, inset: 5, head: null, strokeOpacity: 0.5 }), Plot.text(annotations.filter(d => dateFormat(d.date) == dateFormat(input_date)), { x: "date", y: "textCount", lineHeight: 1.3, width: 20, text: (d) => `${new Date(d.date).toLocaleDateString("en-US", { timeZone: "UTC" })} \n ${d.text} `, textAnchor: "start" }) ], marginLeft: 50, width: 500, height: 300, }), { fill: "green", stroke: "black", r: 8 } ) let sel = d3.select(p).selectAll("svg > g > text").style("font-size", "15px").style("font-weight", "bold"); let sel2 = d3.select(p).selectAll("svg g.tick > text").style("font-size", "15px").style("font-weight", "bold"); let sel3 = d3.select(p).selectAll("svg .hover").style("font-size", "15px") ; return p }36:T59d,plt2 = { let p = addTooltips( Plot.plot({ //width: DOM.width, paddingTop: 80, projection: { // equal-area is crucial to maintain comparability of the slices, // but it could be any other equal-area projection type: "azimuthal-equal-area", rotate: [0, 180 - 90] }, color: { type: "categorical", legend: false, label: "Institution", domain: ssp.concat(autres_ssp).concat(hors_ssp), range: [ "#5a5758", "#9cb5b8", "forestgreen", "#e8d630", "gold", "#2d378c", "brown", "lavender" ].concat(colors_autres_ssp).concat(colors_hors_ssp) }, sort: { color: "stroke", reduce: "count", reverse: true, domain: ssp.concat(autres_ssp).concat(hors_ssp) }, marks: [ pie( subset, { value: "mail", fill: "domain", title: d => `${d.domain}: ${d.mail} \n\n (${(d.mail / d3.sum(subset, d => d.mail)).toLocaleString(undefined, {style: "percent"})} du total)` }) ] }), { fill: "gray", opacity: 0.5, "stroke-width": "3px", stroke: "red" } ) ; let sel = d3.select(p).selectAll("svg .hover").style("font-size", "30px") ; return p; }37:T5cd,plt3 = { let p = addTooltips( Plot.plot({ y: { label: "Institution" }, x: { label: "Nombre d'inscrits à la liste de diffusion →" }, marginLeft: 150, color: { type: "categorical", legend: false, label: "Institution", domain: ssp.concat(autres_ssp).concat(hors_ssp), range: [ "#5a5758", "#9cb5b8", "forestgreen", "#e8d630", "gold", "#2d378c", "brown", "lavender" ].concat(colors_autres_ssp).concat(colors_hors_ssp), }, marks: [ Plot.barX( subset, { x: "mail", y: "domain", fill: "domain", sort: {y: "x", reverse: true}, title: d => `${d.domain}: ${d.mail} \n (${(d.mail / d3.sum(subset, d => d.mail)).toLocaleString(undefined, {style: "percent"})} du total)`, }), Plot.ruleX([0]), Plot.text(subset, { x: "mail", y: "domain", dx: 5, text: d => `${d.mail} (${(d.mail / d3.sum(subset, d => d.mail)).toLocaleString(undefined, {style: "percent"})})`, textAnchor: "start" }) ] }), { fill: "gray", opacity: 0.5, "stroke-width": "3px", stroke: "red" } ) let sel2 = d3.select(p).selectAll("svg g.tick > text").style("font-weight", "bold"); let sel3 = d3.select(p).selectAll("svg > g > text").style("font-weight", "bold"); return p }38:T464,repartition = addTooltips( Plot.plot({ x: { domain: order_domain_all, label: "Institution" }, y: { grid: true, label: "↑ Nombre d'inscrits" }, color: { legend: true, type: "categorical", scheme: "pastel1", domain: ["Diffusion mail et Tchap", "Diffusion mail"] // setting the order manually by specifying the array }, marks: [ Plot.barY(stats_tchap_vs_outlook, { x: "domain", y: "count", sort: "source", fill: "source", title: d => `${d.source}: ${d.count} \n (${(d.count / d3.sum(stats_tchap_vs_outlook.filter(t => t.domain == d.domain), d => d.count)).toLocaleString(undefined, {style: "percent"})})` }), Plot.ruleY([0]) ], style: { paddingTop: 50}, caption: html`

Dérouler la note:

Seules les institutions comportant au moins 10 inscrits sont présentées dans ce graphique

` }), // Set styles for the hovered element { fill: "gray", opacity: 0.5, "stroke-width": "3px", stroke: "red" } )39:T4bf,treemap_network = { let p = addTooltips( Treemap(stats_all, { value: d => d?.count, // size of each node (file); null for internal nodes (folders) path: d => d.domain + "/" + d.source, // e.g., "flare/animate/Easing" group: d => d.domain, // e.g., "animate" in "flare.animate.Easing"; for color label: d => `${d.domain}\n${d.source}\n${d.count.toLocaleString()}`, //title: d => `${d.domain}\n${d.count.toLocaleString()}\n`, // text to show on title: d => `${d.domain}\n${d.source}\n${d.count} \n(${(d.count / d3.sum(stats_all.filter(t => t.domain == d.domain), d => d.count)).toLocaleString(undefined, {style: "percent"})} des inscrits ${d.domain})`, width: 1152, height: 1152, tile: d3.treemapSquarify, colors: ["#5a5758", "#9cb5b8", "forestgreen", "#e8d630", "gold", "#2d378c", "brown", "lavender"].concat(colors_autres_ssp).concat(colors_hors_ssp), // array of colors zDomain: ssp.concat(autres_ssp).concat(hors_ssp), // array of values for the color scale stroke: d => d.domain }), { fill: "gray", opacity: 0.5, "stroke-width": "3px", stroke: "red" } ) let sel = d3.select(p).selectAll("svg .hover").style("font-size", "15px") return p } 3a:Tabc,3b:T88c,githubchart = addTooltips( Plot.plot({ marks: [ Plot.ruleY([0]), Plot.dot(data, { x: "date", y: "count", stroke: "#6886bb", strokeWidth: 2.5, r: 2, title: (d) => `+1 ⭐️ par ${d.login}\n Total ⭐️: ${d.count}\n\n ${rep_starts(d.count)}` }), Plot.line(data, { x: "date", y: "count", stroke: "#6886bb", strokeWidth: 2.5 }), Plot.text(data, Plot.selectMaxX({ x: "date", y: "count", text: d => d.count.toLocaleString("en-US"), textAnchor: "start", dx: 3, dy: 6 })), width > 500 ? Plot.text(annotations_10p, { x: "endDate", y: "textCount", dx: 14, lineHeight: 1.3, width: 20, text: (d) => `${new Date(d.date).toLocaleDateString("en-US", { timeZone: "UTC" })} \n ${d.text} `, textAnchor: "start" }) : [ Plot.text(annotations_10p, { x: "endDate", y: "textCount", lineHeight: 1.3, width: 20, fill: "#6886bb", text: (d, i) => i + 1, textAnchor: "center" }), Plot.dot(annotations_10p, { x: "date", y: "textCount", r: 10 }) ], Plot.arrow(annotations_10p, { x2: "date", y1: "textCount", x1: "endDate", y2: 0, dx: 14, bend: 20, inset: 5, head: null, strokeOpacity: 0.5 }), githubrepo == "inseefrlab/cartiflette" ? [ Plot.image(data_image,{ x: "date", y: "y", width: 180, src: "url", title: "title" }) ] : [] ], x: { grid: true }, y: { type: "linear", nice: true, grid: true, label: `⭐️ Stargazers for ${githubrepo}` }, width, marginRight: 40, }), { fill: "gray", opacity: 0.5, "stroke-width": "3px", stroke: "red" } )3c:T4cc,animation = { replay; const height = 70; const marginLeft = 40; const marginRight = 40; const duration = 5000; const x = d3.scaleLinear( d3.extent(data, (d) => d.date), [marginLeft, width - marginRight] ); const t = d3.scaleLinear( d3.extent(data, (d) => d.date), [0, duration] ); const r = d3.randomNormal(0, height / 4); const sel = d3 .create("svg") .attr("width", width) .attr("height", height) .style("overflow", "visible"); const g = sel.append("g").attr("transform", `translate(0, ${height / 2})`); if (pages_remaining === 0) { g.append("text") .text("•") .attr("transform", `translate(${x.range()[0]}, 0)`) .transition() .ease(d3.easeLinear) .duration(t.range()[1]) .attr("transform", `translate(${x.range()[1]}, 0)`) .remove(); g.selectAll("text.star") .data(dates) .join("text") .attr("class", "star") .attr("transform", (date) => `translate(${x(date)}, 0)`) .attr("opacity", 0) .text("⭐️") .transition() .delay((date) => t(date)) .attr("transform", (date) => `translate(${x(date)}, ${r()})`) .attr("opacity", 1); } return sel.node(); }3d:Ta84,annotations = [ { date: d3.utcParse("%Y-%m-%d")("2022-02-22"), endDate: d3.utcParse("%Y-%m-%d")("2022-02-22"), endCount: 112, text: "Newsletter n°1 🚀", textDate: "2022-02-23", textCount: 250, bend: 20 }, { date: d3.utcParse("%Y-%m-%d")("2022-03-17"), endDate: d3.utcParse("%Y-%m-%d")("2022-03-17"), endCount: 153, text: "Newsletter n°2", textDate: "2022-02-23", textCount: 230, bend: -5 }, { date: d3.utcParse("%Y-%m-%d")("2022-04-22"), endDate: d3.utcParse("%Y-%m-%d")("2022-04-22"), endCount: 188, text: "Newsletter n°3", textDate: "2022-04-14", textCount: 140, bend: 20 }, { date: d3.utcParse("%Y-%m-%d")("2022-05-14"), endDate: d3.utcParse("%Y-%m-%d")("2022-05-14"), endCount: 212, text: "Newsletter n°4", textDate: "2022-05-23", textCount: 180, bend: 20 }, { date: d3.utcParse("%Y-%m-%d")("2022-06-14"), endDate: d3.utcParse("%Y-%m-%d")("2022-06-17"), endCount: 227, text: "Newsletter n°5", textDate: "2022-06-15", textCount: 160, bend: -20 }, { date: d3.utcParse("%Y-%m-%d")("2022-10-26"), endDate: d3.utcParse("%Y-%m-%d")("2022-10-26"), endCount: 261, text: "Newsletter n°6", textDate: "2022-10-26", textCount: 295, bend: -20 }, { date: d3.utcParse("%Y-%m-%d")("2022-11-30"), endDate: d3.utcParse("%Y-%m-%d")("2022-11-30"), endCount: 282, text: "Newsletter n°7", textDate: "2022-11-30", textCount: 230, bend: -20 }, { date: d3.utcParse("%Y-%m-%d")("2022-04-22"), endDate: d3.utcParse("%Y-%m-%d")("2022-04-22"), endCount: 188, text: "OpenHour n°1", textDate: "2022-04-22", textCount: 240, bend: -20 }, { date: d3.utcParse("%Y-%m-%d")("2022-06-03"), endDate: d3.utcParse("%Y-%m-%d")("2022-06-03"), endCount: 220, text: "OpenHour n°2", textDate: "2022-06-03", textCount: 270, bend: -20 }, { date: d3.utcParse("%Y-%m-%d")("2022-09-13"), endDate: d3.utcParse("%Y-%m-%d")("2022-09-13"), endCount: 232, text: "Nouvelle version\ndu site web 🎉", textDate: "2022-09-13", textCount: 150 }, { date: d3.utcParse("%Y-%m-%d")("2022-09-30"), endDate: d3.utcParse("%Y-%m-%d")("2022-09-30"), endCount: 245, text: "Premier post de blog", textDate: "2022-09-30", textCount: 205, bend: 20 }, { date: d3.utcParse("%Y-%m-%d")("2022-11-16"), endDate: d3.utcParse("%Y-%m-%d")("2022-11-16"), endCount: 275, text: `Présentation observable\npar Nicolas Lambert`, textDate: "2022-09-13", textCount: 150, bend: 20 }, ] 3e:T867,function Scrubber( values, { format = value => value, initial = 0, delay = null, autoplay = true, loop = true, alternate = false, width = 500 } = {} ) { values = Array.from(values); const form = html``; let timer = null; let direction = 1; function start() { form.b.textContent = "Pause"; timer = delay === null ? requestAnimationFrame(tick) : setInterval(tick, delay); } function stop() { form.b.textContent = "Play"; if (delay === null) cancelAnimationFrame(timer); else clearInterval(timer); timer = null; } function tick() { if (delay === null) timer = requestAnimationFrame(tick); if ( form.i.valueAsNumber === (direction > 0 ? values.length - 1 : direction < 0 ? 0 : NaN) ) { if (!loop) return stop(); if (alternate) direction = -direction; } form.i.valueAsNumber = (form.i.valueAsNumber + direction + values.length) % values.length; form.i.dispatchEvent(new CustomEvent("input", { bubbles: true })); } form.i.oninput = event => { if (event && event.isTrusted && timer) form.b.onclick(); form.value = values[form.i.valueAsNumber]; form.o.value = format(form.value, form.i.valueAsNumber, values); }; form.b.onclick = () => { if (timer) return stop(); direction = alternate && form.i.valueAsNumber === values.length - 1 ? -1 : 1; form.i.valueAsNumber = (form.i.valueAsNumber + direction) % values.length; form.i.dispatchEvent(new CustomEvent("input", { bubbles: true })); start(); }; form.i.oninput(); if (autoplay) start(); else stop(); disposal(form).then(stop); return form; }3f:T575,data = { // Start with an empty array of results; we'll yield it repeatedly as more results come in const S = []; yield S; // Get total number of pages from response headers let pages = await fetchGithubResponse(`/repos/${githubrepo}/stargazers`, {per_page: 100}, fetchOptions) .then(d => [...d.headers].find(d => d[0] === "link")?.[1].split(/,/).pop().match(/&page=(\d+)/)?.[1] || 1); let l = Math.min(maxPages, pages); mutable pages_remaining = l; // Fetch the first page, last page, and then remaining pages shuffled for (const page of new Set([1, +pages].concat(d3.shuffle(d3.range(2, +pages))))) { const s = await fetchGithub(`/repos/${githubrepo}/stargazers`, {per_page: 100, page}, fetchOptions); // If there's an error, return if (!s) return; if (s.message) return mutable error_message = s.message; // Push a transformed version of the stargazer response, sort it, and yield it s.forEach((u, i) => { S.push({ login: u.user.login, id: u.user.id, date: new Date(u.starred_at), count: 100 * (page - 1) + i + 1, githubrepo }); }); S.sort((a, b) => a.count - b.count); yield S; // Decrement log of remaining pages mutable pages_remaining = --l; if (l === 0) break; // Wait before next request await Promises.delay(150); } // Final results yield S; }40:[] 31:{"id":"d4ed7a1ba81a0a02","slug":"2022-year-recap-data-scientists-network","title":"2022 Year Recap for French data scientists network","thumbnail":"f8a7b54036d02e4270f07a96a5f124a337318b63912cb268b795c104be9d4a8d","access_level":"public","create_time":"$D2023-01-07T18:51:13.912Z","update_time":"$D2023-01-18T17:02:46.394Z","view_time":null,"first_public_time":"$D2023-01-07T18:51:13.912Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"c861da44f1c38139","login":"linogaliana","name":"Lino Galiana","avatar_url":"https://avatars-next.observableusercontent.com/a68859cd8680b94e9f566939a8aaff21178c54a6221567a94798ca456c6a82d7","tier":"starter_2024"},"version":653,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"b03130f8204b0f4b","login":"linogaliana","name":"Lino Galiana","avatar_url":"https://avatars-next.observableusercontent.com/a68859cd8680b94e9f566939a8aaff21178c54a6221567a94798ca456c6a82d7","tier":null}],"members":[{"type":"individual","id":"b03130f8204b0f4b","login":"linogaliana","name":"Lino Galiana","avatar_url":"https://avatars-next.observableusercontent.com/a68859cd8680b94e9f566939a8aaff21178c54a6221567a94798ca456c6a82d7","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"2022 Year Recap for French data scientists network","cells":[{"id":62,"value":"# 2022 Year Recap for French data scientists network\n\nCe notebook centralise le contenu nécessaire pour répliquer le bilan du réseau présenté sur le [site web du réseau (https://ssphub.netlify.app)](https://ssphub.netlify.app/post/recap2022/).\n\nLa première partie présente les visualisations. Les étapes préliminaires sont reportées à la fin du _notebook_.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":82,"value":"## Evolution du réseau","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":84,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"value":"## Composition du réseau","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":116,"value":"viewof input_date = Scrubber(\n serie_contacts_domain.map(d => d.date), {\n delay: 50,\n loop: false,\n autoplay: false,\n unique: true,\n sort: true,\n format: date => date.toLocaleString(\"en\", {month: \"long\", day: \"numeric\"})\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":121,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":148,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":154,"value":"## Répartition des modes d'accès au réseau","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":164,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":528,"value":"d3.sum(stats_all, d => d.count)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":530,"value":"d3.sum(stats_all.filter(d => d.source != \"Diffusion mail\"), d => d.count)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":532,"value":"d3.sum(stats_all.filter(d => d.source != \"Diffusion mail\"), d => d.count) / d3.sum(stats_all, d => d.count)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":182,"value":"## Composition du réseau","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":184,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":545,"value":"d3.sum(\n stats_all.filter(d => d.domain == \"INSEE\"), d => d.count\n ) / d3.sum(\n stats_all, d => d.count\n )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":540,"value":"## Stats `Github`","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":189,"value":"viewof githubrepo = Inputs.select([\"inseefrlab/cartiflette\",\"spyrales/gouvdown\", \"etalab-ia/Socratext\", \"etalab/matchSIRET\"], {label: \"Choisissez un dépôt\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":287,"value":"viewof replay = Inputs.button(\"Replay\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":346,"value":"containeur_github = html`

${viewof githubrepo}

Cliquer pour soutenir le projet ${githubrepo.split(\"/\")[1]}: ${button_like}

${githubchart}

${animation}

${viewof replay}

${animation}

${table_github}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":194,"value":"html``","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":203,"value":"$3a","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":232,"value":"api_stars=`https://ghbtns.com/github-btn.html?user=${githubrepo.split(\"/\")[0]}&repo=${githubrepo.split(\"/\")[1]}&type=star&count=true&size=large`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":225,"value":"button_like = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":309,"value":"rep_starts=function insertNewlines(n) {\n const arr = Array(n).fill(\"⭐️\");\n\n let result = \"\";\n\n for (let i = 0; i < arr.length; i++) {\n result += arr[i];\n\n // Insert a newline character every 5 values\n if ((i + 1) % 5 === 0) {\n result += \"\\n\";\n } else {\n result += \" \";\n }\n }\n\n return result;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":289,"value":"$3b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":469,"value":"data_image = [{\n date: d3.utcParse(\"%Y-%m-%d\")(\"2022-07-05\"),\n url: \"https://raw.githubusercontent.com/InseeFrLab/cartiflette/main/cartiflette.png\",\n y: 15,\n title: \"Une belle cartiflette\"\n}]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":285,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":352,"value":"table_github = html`

\n \n \n \n \n \n ${topDays.slice(0, 5).map(d => htl.html.fragment`\n \n \n `)}\n \n

Top days
${d[0].toLocaleDateString(\"en-US\", {dateStyle: \"full\"})}	+${d[1].length}

\n \n \n \n \n \n \n ${milestones.map(d => htl.html.fragment`\n \n \n `)}\n \n \n \n \n \n

Milestones
${d[0] === 1 ? `First` : `${d[0]}th`} stargazer	${d[1] ? `${d[1].login} (${d[1].date.toLocaleDateString(\"en-US\", {dateStyle: \"long\"})})` : \"Unknown\"}
Latest stargazer	${d3.greatest(data, d => d.date).login} (${d3.greatest(data, d => d.date).date.toLocaleDateString(\"en-US\", {dateStyle: \"long\"})})

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":405,"value":"point_to_anchor_start = data.filter(d => d.date >= d3.utcParse(\"%Y-%m-%d\")(\"2022-06-13\")).map(d => d.count)[0]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":418,"value":"point_to_anchor_end = data.filter(d => d.date <= d3.utcParse(\"%Y-%m-%d\")(\"2022-12-15\")).map(d => d.count).at(-1)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":393,"value":"annotations_10p = [\n {\n date: d3.utcParse(\"%Y-%m-%d\")(\"2022-06-13\"),\n endDate: d3.utcParse(\"%Y-%m-%d\")(\"2022-06-13\"),\n endCount: point_to_anchor_start,\n text: \"Bootcamp de lancement 🚀\",\n textDate: \"2022-06-13\",\n textCount: point_to_anchor_start+8,\n bend: 20,\n dx: 14\n },\n {\n date: d3.utcParse(\"%Y-%m-%d\")(\"2022-12-15\"),\n endDate: d3.utcParse(\"%Y-%m-%d\")(\"2022-10-25\"),\n endCount: 4,\n text: \"Événement de clôture 🎉\",\n textDate: \"2022-06-13\",\n textCount: 2,\n bend: -20,\n dx: 0 \n }\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":94,"value":"## Données","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":96,"value":"configuredClient = {\n const client = await DuckDBClient.of();\n await client.sql`\n SET s3_endpoint='minio.lab.sspcloud.fr'\n `;\n return client;\n}\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":98,"value":"url_latest = 's3://lgaliana/ssphub/files/retrospective2022-observable/list_contacts_latest.parquet'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":101,"value":"url_latest2 = 's3://lgaliana/ssphub/files/retrospective2022-observable/series_nombre_contact.parquet'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"value":"db = {\n await configuredClient.query(`\n CREATE VIEW latest AS \n SELECT * FROM read_parquet('${url_latest}') ;\n `);\n await configuredClient.query(`\n CREATE VIEW serie AS \n SELECT * FROM read_parquet('${url_latest2}') ;\n `);\n return configuredClient\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":105,"value":"serie_contacts = db.sql`\nSELECT date, CAST(SUM(mail) AS int) AS mail\nFROM serie\nGROUP BY date\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":107,"value":"serie_contacts_domain = db.sql`\nSELECT date, domain, CAST(mail AS int) AS mail\nFROM serie\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":158,"value":"stats_tchap_vs_outlook = db.sql`\nSELECT source, domain, CAST(COUNT(*) AS int) AS count\nFROM latest\nWHERE domain IN (SELECT domain\n FROM latest\n GROUP BY domain\n HAVING COUNT(*) > 10)\nGROUP BY source, domain\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":161,"value":"stats_all = db.sql`\nSELECT source, domain, CAST(COUNT(*) AS int) AS count\nFROM latest\nGROUP BY source, domain\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"## Eléments d'environnements\n\nLa suite de ce `notebook` définit l'ensemble des éléments nécessaires pour reproduire l'analyse:\n\n- du CSS pour customiser l'apparence de certains éléments\n- des imports directs de fonctions\n- des fonctions récupérées d'autres _notebooks_","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":109,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"Plot = require('@observablehq/plot@0.6.1/dist/plot.umd.min.js')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"import { style as faStyle, fa, fas } from \"@airbornemint/fontawesome\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"import {Treemap} from \"@d3/treemap\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"import {SummaryTable} from \"@observablehq/summary-table\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"import {addTooltips} from \"@mkfreeman/plot-tooltip\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":45,"value":"import {disposal} from \"@mbostock/disposal\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"$3e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"pie = (data, { value, ...options }) => {\n const cs = d3.cumsum(data, (d) => d[value]);\n const r = 360 / cs[cs.length - 1];\n for (let i = 0; i < cs.length; ++i) cs[i] *= r;\n for (const d of data)\n return Plot.geo(\n {\n type: \"GeometryCollection\",\n geometries: data.map((d, i) => {\n const a = -(cs[i - 1] || 0);\n const b = -cs[i];\n return {\n type: \"Polygon\",\n ...d,\n coordinates: [\n [\n [0, 90],\n [a, 0],\n [(2 * a + b) / 3, 0], // add intermediate points for sectors larger than a half-circle\n [(a + 2 * b) / 3, 0],\n [b, 0],\n [0, 90]\n ]\n ]\n };\n })\n },\n { ...options }\n );\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":166,"value":"order_domain_all = d3.groupSort(\n stats_tchap_vs_outlook,\n (g) => d3.sum(g, (d) => -d.count),\n (d) => d.domain\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":87,"value":"### Styling","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":66,"value":"faStyle({regular: true, solid: true, brands: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"html``","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":89,"value":"### Dates","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":69,"value":"parseDate = d3.utcParse(\"%Y-%m-%d\"); //function to parse dates","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":72,"value":"startDate = parseDate(\"2022-06-30\");","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"endDate = parseDate(\"2022-09-05\");","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"daysBetween = d3.utcDay.count(startDate, endDate);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"middleDate = d3.utcDay.offset(startDate, Math.floor(daysBetween / 2));","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":125,"value":"dateFormat = d3.utcFormat(\"%Y-%m-%d\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":127,"value":"subset = serie_contacts_domain.filter(d => dateFormat(d.date) == dateFormat(input_date))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":129,"value":"order_domain = d3.groupSort(\n serie_contacts_domain,\n (g) => d3.max(g, (d) => d.mail),\n (d) => d.domain\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":131,"value":"array1 = ssp.concat(autres_ssp)\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":134,"value":"array2 = subset.map(d => d.domain)\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":136,"value":"hors_ssp_all = serie_contacts_domain.map(d => d.domain).filter(d => !array1.includes(d))\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":138,"value":"hors_ssp = [... new Set(hors_ssp_all)]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":140,"value":"colors_hors_ssp = Array(hors_ssp.length).fill(\"#fb9a99\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":142,"value":"ssp = [\n 'INSEE', 'Santé', 'Développement Durable', 'Agriculture', 'Finances', 'Travail', 'Intérieur', 'Recherche'\n ]\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":144,"value":"autres_ssp = ['Justice', 'Culture', \"Collectivités Locales\", \"Enseignement Supérieur\",\n \"Jeunesse Sports\", \"Défense\"]\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":146,"value":"colors_autres_ssp = Array(6).fill(\"orange\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":240,"value":"### Données `Github`","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":242,"value":"$3f","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":238,"value":"tags = {\n const tags = await fetchGithub(`/repos/${githubrepo}/tags`);\n for (const tag of tags) {\n const commit = await fetchGithub(`/repos/${githubrepo}/commits/${tag.commit.sha}`);\n tag.commit = commit;\n tag.date = new Date(commit.commit.author.date);\n }\n return tags;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":260,"value":"dates = {\n const D = [];\n const max = data[data.length - 1].count;\n let i = 0;\n for (let count = 1; count <= max; count++) {\n while (data[i].count < count) i++;\n const date =\n data[i].count === count\n ? data[i].date\n : d3.interpolate(\n data[i - 1].date,\n data[i].date\n )((count - data[i - 1].count) / (data[i].count - data[i - 1].count));\n D.push(date);\n }\n return D;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":262,"value":"topDays = d3.groups(data, d => d3.utcDay.floor(d.date)).sort((a, b) => d3.descending(a[1].length, b[1].length))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":264,"value":"milestones = d3\n .range(Math.ceil(Math.log10(data[data.length - 1].count)))\n .map((n) => 10 ** n)\n .map((n) => [n, data.find((d) => d.count === n)])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":266,"value":"fetchOptions = ({\n headers: {\n accept: \"application/vnd.github.v3.star+json\" // necessary to get the starred_at field\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":268,"value":"import {\n fetchGithub,\n fetchGithubResponse,\n hasApiKey,\n apiKeyStatus,\n rateLimitSummary\n} from \"@observablehq/github-actions-workflows-api\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":271,"value":"import {maxPages} from \"@observablehq/github-stargazer-history\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":276,"value":"mutable error_message = {}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":278,"value":"mutable pages_remaining = null","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W40","stdlib":"1","titling":"auto"}} 32:"$31:body"