40:null 41:["$","title",null,{"children":"TP : Députés Actifs de l'Assemblée Nationale | tropel | Observable"}] 47:T11cf,dataanalyse = { // le résultat à créer : const r = []; // On récupère les IDs : const ids = [... new Set(deputes.map(d => d.id))]; // Pour chaque ID : ids.forEach ((i) => { // On récupère les variables que l'on souhaite : const civ = deputes.filter(d => d.id === i).map(d => d.civ); const nom = deputes.filter(d => d.id === i).map(d => d.nom); const prenom = deputes.filter(d => d.id === i).map(d => d.prenom); const villeNaissance = deputes.filter(d => d.id === i).map(d => d.villeNaissance); const naissance = deputes.filter(d => d.id === i).map(d => d.naissance); const groupe = deputes.filter(d => d.id === i).map(d => d.groupe); const groupeAbrev = deputes.filter(d => d.id === i).map(d => d.groupeAbrev); const departementNom = deputes.filter(d => d.id === i).map(d => d.departementNom); const departementCode = deputes.filter(d => d.id === i).map(d => d.departementCode); const circo = deputes.filter(d => d.id === i).map(d => d.circo); const datePriseFonction = deputes.filter(d => d.id === i).map(d => d.datePriseFonction); const job = deputes.filter(d => d.id === i).map(d => d.job); const nombreMandats = deputes.filter(d => d.id === i).map(d => +d.nombreMandats); // Changement de type : variable texte en numérique. const scoreParticipation = deputes.filter(d => d.id === i).map(d => +d.scoreParticipation); const scoreParticipationSpecialite = deputes.filter(d => d.id === i).map(d => +d.scoreParticipationSpecialite); const scoreLoyaute = deputes.filter(d => d.id === i).map(d => +d.scoreLoyaute); const scoreMajorite = deputes.filter(d => d.id === i).map(d => +d.scoreMajorite); const age = deputes.filter(d => d.id === i).map(d => +d.age); const age2 = deputes.find(d => d.id === i).age; // Création de classes d'age let classeAge; if (age2 < 20) { classeAge = "Moins de 20 ans"; } else if (age2 >= 20 && age2 < 30) { classeAge = "20-29 ans"; } else if (age2 >= 30 && age2 < 40) { classeAge = "30-39 ans"; } else if (age2 >= 40 && age2 < 50) { classeAge = "40-49 ans"; } else if (age2 >= 50 && age2 < 60) { classeAge = "50-59 ans"; } else if (age2 >= 60 && age2 < 70) { classeAge = "60-79 ans"; } else if (age2 >= 70 && age2 < 80) { classeAge = "70-79 ans"; } else if (age2 >= 80 && age2 < 90) { classeAge = "80-89 ans"; } else { classeAge = "90 ans ou plus"; } const civ2 = deputes.find(d => d.id === i).civ; let genre; if (civ == "M.") { genre = "Homme"; } else if (civ == "Mme") { genre = "Femme"; } else { genre = "Autre"; } const experienceDepute = deputes.find(d => d.id === i).experienceDepute; let expe; if (experienceDepute.includes("an")) { expe = +experienceDepute.replace('ans', ''); } else if (experienceDepute.includes("mois")) { expe = +experienceDepute.replace('mois', '')/12; } else if (experienceDepute.includes("jours")) { expe = +experienceDepute.replace('jours', '')/365; } let classeexpe; if (expe < 1) { classeexpe = "Moins de 1 an"; } else if (expe >= 1 && expe < 5) { classeexpe = "1-4 ans"; } else if (expe >= 5 && age < 10) { classeexpe = "5-9 ans"; } else if (expe >= 10 && expe < 15) { classeexpe = "10-14 ans"; } else if (expe >= 15 && expe < 20) { classeexpe = "15-19 ans"; } else { classeexpe = "Plus de 20 ans"; } r.push({ id : i, Genre : genre, Prénom : prenom[0], VilleNaissance : villeNaissance[0], Naissance : new Date(naissance[0]), // Changement de type : variable texte en date. Age : age[0], ClasseAge : classeAge, Groupe : groupe[0], GroupeAbrev : groupeAbrev[0], DepartementNom : departementNom[0], DepartementCode : departementCode[0], Circo : circo[0], DatePriseFonction : new Date(datePriseFonction[0]), Job : job[0], NombreMandats : nombreMandats[0], ExperienceDepute : expe, ClasseExperienceDepute : classeexpe, ScoreParticipation : scoreParticipation[0], ScoreParticipationSpecialite : scoreParticipationSpecialite[0], ScoreLoyaute : scoreLoyaute[0], ScoreMajorite : scoreMajorite[0] }) }) return r } 48:[{"id":"3585e19913d7a4872517f2785e5dc86961705fe9a52df4ad68787b01ecc6653705948baea68d09db7e5fb212c5f661423914822b7962d885bee32dcab60acbdc","href":"https://static.observableusercontent.com/files/3585e19913d7a4872517f2785e5dc86961705fe9a52df4ad68787b01ecc6653705948baea68d09db7e5fb212c5f661423914822b7962d885bee32dcab60acbdc","name":"LOGO SD.png","type":"image/png","lastModified":1699895692101.819,"size":33827},{"id":"8e9b7fed4ed7b6a603e62a0e02fb36065ba3737494d4c6a5c4bcc11877ac55afe60d975c55d8db7dd55bf1ca01fd54457f543f52977d078b04a577b9de2315c7","href":"https://static.observableusercontent.com/files/8e9b7fed4ed7b6a603e62a0e02fb36065ba3737494d4c6a5c4bcc11877ac55afe60d975c55d8db7dd55bf1ca01fd54457f543f52977d078b04a577b9de2315c7","name":"datagouv.PNG","type":"image/png","lastModified":1699895692101.819,"size":90527},{"id":"7fa30f62b898e08523b5afc5852834fdad21d12015926cadef9d9e591f363c05939a00fda4acbc29795b891a77fb0102192ac2798876b0a45fe709679585a21a","href":"https://static.observableusercontent.com/files/7fa30f62b898e08523b5afc5852834fdad21d12015926cadef9d9e591f363c05939a00fda4acbc29795b891a77fb0102192ac2798876b0a45fe709679585a21a","name":"france-metrop-et-dom-2022.geojson","type":"application/geo+json","lastModified":1699904277213.479,"size":1149337}] 45:{"id":"a1127bff3140f526","slug":null,"title":"TP : Députés Actifs de l'Assemblée Nationale","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2023-11-13T17:14:52.101Z","update_time":"$D2023-11-13T19:40:09.307Z","view_time":null,"first_public_time":"$D2023-11-13T17:14:52.101Z","has_unpublished_edits":null,"fork":{"id":"c1e253fd5a7fc1f4","slug":null,"title":"TP : Députés Actifs de l'Assemblée Nationale","owner":{"id":"fcae29e32f0626b5","login":"tropel2-ws","name":"tropel's Workspace"}},"stars":0,"starred":false,"owner":{"type":"team","id":"cbb2972d53922130","login":"tropel2","name":"tropel","avatar_url":"https://avatars-next.observableusercontent.com/78e06d63a652141a3bda8338552a110c1420fdd87f29366566cb604873bbd108","tier":"starter_2024","bio":"","following":false},"version":968,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"7d16d7b5ea6e4410","login":"tropel2","name":"tropel","avatar_url":"https://avatars-next.observableusercontent.com/78e06d63a652141a3bda8338552a110c1420fdd87f29366566cb604873bbd108","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"7d16d7b5ea6e4410","login":"tropel2","name":"tropel","avatar_url":"https://avatars-next.observableusercontent.com/78e06d63a652141a3bda8338552a110c1420fdd87f29366566cb604873bbd108","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"TP : Députés Actifs de l'Assemblée Nationale","cells":[{"id":0,"value":"---\n# *TP : Députés Actifs de l'Assemblée Nationale* \n\nRES 5.VCOD.07 Programmation web pour la visualisation. \nGroupe VCOD, BUT Science des Données, IUT 2 de Grenoble. \n\nGomes Pedro et Tropel Célia.\n\n---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":435,"value":"

\n ${logo}\n

\n ${datagouv}\n

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":37,"value":"---\n## Nettoyage des données ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":552,"value":"$47","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":709,"value":"---\n## Résumé","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":765,"value":"Statistiques_Age = new Map([[\"moyenne\" , d3.mean(dataanalyse, d => d.Age).toFixed(2)],\n [\"minimum\" , d3.min(dataanalyse, d => d.Age)],\n [\"maximum\" , d3.max(dataanalyse, d => d.Age)]])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":780,"value":"Statistiques_Experience = new Map([[\"moyenne\" , d3.mean(dataanalyse, d => d.ExperienceDepute).toFixed(2)],\n [\"minimum\" , d3.min(dataanalyse, d => d.ExperienceDepute).toFixed(2)],\n [\"maximum\" , d3.max(dataanalyse, d => d.ExperienceDepute)]])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":753,"value":"\n| Variable | Moyenne | Minimum | Maximum |\n| --------- | --------- | --------- | --------- |\n| Age | `${Statistiques_Age.get(\"moyenne\")}` | `${Statistiques_Age.get(\"minimum\")}` | `${Statistiques_Age.get(\"maximum\")}` |\n| Expérience en année(s) | `${Statistiques_Experience.get(\"moyenne\")}` | `${Statistiques_Experience.get(\"minimum\")}` | `${Statistiques_Experience.get(\"maximum\")}` |","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":946,"value":"Ce tableau permet d'obtenir un résumé statistiques des variables quantitatives que nous allons observé ci-dessous dans l'analyse univariée permettant l'observer le profil des députés. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":208,"value":"---\n## Gaphiques","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":228,"value":"### Partie I : Résumé univarié, description des députés","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":323,"value":"// Création d'une liste contenant le nom des variables que l'on souhaite analyser en univarié.\nvariables = [\"ClasseAge\", \"Genre\", \"GroupeAbrev\", \"ClasseExperienceDepute\", \"NombreMandats\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":320,"value":"// Liste déroulante des variables à analyser. \nviewof choix = Inputs.select(\n variables,\n { label: \"Sélectionner une variable à visualiser\" }\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":315,"value":"// Table des modalités possibles de la variable sélectionné. \nmodalites = Array.from(new Set(dataanalyse.map(d => d[`${choix}`]))).sort();","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":339,"value":"// Tableau contenant les modalités et le nombre de députés associé. \nnb_par_choix = {\n const r = [];\n modalites.forEach((m) =>{\n const nb = dataanalyse.filter(d => d[`${choix}`] === m).length;\n r.push({\n [`${choix}`]: m,\n Nb_Députés : nb,\n }); \n })\n return r;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":696,"value":"*Représentation sous forme de tableau des données*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":695,"value":"nb_par_choix","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":344,"value":"Plot.plot({\n //className: 'my-plot',\n marks: [\n Plot.barY(\n nb_par_choix,\n {\n x: `${choix}`,\n y: \"Nb_Députés\",\n sort: {y: \"x\", reverse: true },\n fill: \"teal\", \n },\n {\n text: { field: \"Nb_Députés\", type: \"quantitative\" },\n align: \"center\", // Alignement horizontal\n baseline: \"bottom\", // Alignement vertical\n }\n ),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":854,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":353,"value":"// Liste des commentaires par variables.\ncommentaires = new Map([[\"GroupeAbrev\",\"blabla\"],\n [\"Genre\", \"L'objectif de ce graphique est d'identifier la proportion d'homme, de femme ou autre parmis les députés siégeant actuellement à l'Assemblée Nationale\"],\n [\"ClasseAge\", \"blbla3\"],\n [\"ExperienceDepute\", \"blablabla4\"]])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":895,"value":"$${commentaires.get(`${choix}`)}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":672,"value":"---\n## Analyses Bivariées","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":799,"value":"liste_variables = [\"ScoreParticipationSpecialite\", \"ScoreLoyaute\", \"ScoreMajorite\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":803,"value":"viewof variable_Bivar = Inputs.select(\n liste_variables,\n { label: \"Sélectionner la variable à observer\" }\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":503,"value":"Plot.plot({\n marginLeft: 100,\n marks: [\n Plot.ruleX({ stroke: 'grey', strokeDasharray: '5 20', strokeWidth:0.5 }),\n Plot.boxX(dataanalyse,{x: `${variable_Bivar}`, y: \"GroupeAbrev\", sort: {x: \"y\"}}),\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":817,"value":"// Liste des groupes (abrégés) :\nliste_groupes = [... new Set(dataanalyse.map(d => d.GroupeAbrev))].sort()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":815,"value":"// Tableau contenant les modalités et le nombre de députés associé. \nmoyenne_par_variable = {\n const r = [];\n liste_groupes.forEach((g) =>{\n const moyenne = d3.mean(dataanalyse.filter(d => d.GroupeAbrev === g, [`${variable_Bivar}`]), d => d[`${variable_Bivar}`]).toFixed(2);\n\n r.push({\n GroupeAbrev : g,\n Moyenne : moyenne,\n }); \n })\n return r;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":545,"value":"Plot.plot({\n marks: [\n Plot.barY(\n moyenne_par_variable,\n {\n x: \"GroupeAbrev\",\n y: \"Moyenne\",\n sort: {y: \"x\", reverse: true },\n fill: \"lightblue\", \n }\n ),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":892,"value":"Statistiques_loyauté = new Map([[\"moyenne\" , d3.mean(dataanalyse, d => d.ScoreLoyaute).toFixed(2)],\n [\"minimum\" , d3.min(dataanalyse, d => d.ScoreLoyaute).toFixed(2)],\n [\"maximum\" , d3.max(dataanalyse, d => d.ScoreLoyaute)]])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":929,"value":"| Variable | Moyenne | Minimum | Maximum |\n| --------- | --------- | --------- | --------- |\n| Age | `${Statistiques_Age.get(\"moyenne\")}` | `${Statistiques_Age.get(\"minimum\")}` | `${Statistiques_Age.get(\"maximum\")}` |\n| Expérience en année(s) | `${Statistiques_Experience.get(\"moyenne\")}` | `${Statistiques_Experience.get(\"minimum\")}` | `${Statistiques_Experience.get(\"maximum\")}` |","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":677,"value":"---\n# Tests","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":680,"value":"Reste à faire : \n- mettre des info-bulles / mettre des étiquettes de données\n- changer les couleurs des graphiques\n- mettre les commentaires sur chaque graph\n- test d'une cartographie\n- changer les titres des parties\n- résumé : ajouter des variables ? faire pareil avec les scores de participation\n- Faire qui est l'individu le plus loyal etc ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":959,"value":"import { proj4d3 } from \"@fil/proj4js-d3\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":962,"value":"franceMetropEtDom2022 = FileAttachment(\"france-metrop-et-dom-2022.geojson\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":968,"value":"{\nconst container = yield htl.html`

`;\nconst map = L.map(container);\nconst layer = L.geoJSON(franceMetropEtDom2022).addTo(map);\nmap.fitBounds(layer.getBounds(), {maxZoom: 9});\nL.tileLayer(\"https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png\", {\n attribution: \"© OpenStreetMap contributors\"\n}).addTo(map);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":967,"value":"Plot.plot({ projection: \"equal-earth\", marks: [Plot.geo(franceMetropEtDom2022)] })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":964,"value":"Plot.plot({\n // Dans la propriété \"projection\" :\n projection: {\n // On utilise la propriété 'type' en lui donnant comme valeur\n // une fonction qui retourne le résultat de la fonction 'proj4d3'\n type: () => proj4d3(\"+proj=lcc +lat_0=46.5 +lon_0=3 +lat_1=49 +lat_2=44 +x_0=700000 +y_0=6600000 +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=m +no_defs +type=crs\"),\n // On utilise la propriété domain\n // pour center la visualisation sur notre jeu de données\n domain: dataset\n },\n inset: 4, // Une marge autour du jeu de données\n marks: [\n // La marque Plot.geo pour afficher le tracé du jeu de données\n Plot.geo(dataanalyse, {\n stroke: \"black\",\n strokeWidth: 0.5,\n fill: \"rgba(0,0,0,0.3)\"\n }),\n Plot.frame()\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":444,"value":"---\n ## Illustrations","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":422,"value":"logo = {\n const logoSd = new Image();\n logoSd.src = URL.createObjectURL(await FileAttachment(\"LOGO SD.png\").blob());\n logoSd.width = 500; // specify your desired width\n logoSd.height = 100; // specify your desired height\n return logoSd\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":474,"value":"datagouv = {\n const datagouv= new Image();\n datagouv.src = URL.createObjectURL(await FileAttachment(\"datagouv.PNG\").blob());\n datagouv.width = 700; // specify your desired width\n datagouv.height = 500; // specify your desired height\n return datagouv\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":608,"value":"---\n# POUBELLE","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":45,"value":"// Transformer naissance (chaine de caractères) en date : \nfunction new_date(table, colonne){\n for (const i of table) {\n i[colonne] = new Date(i[colonne]);\n};\n return table;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"//converttypecolonne(deputes, \"legislature\", Number)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"function converttypecolonne(table, nomcolonne, nouveauType) {\n for (const row of table) {\n row[nomcolonne] = nouveauType (row[nomcolonne]);\n }\n return table;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":47,"value":"//new_date(deputes, \"naissance\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":128,"value":"//dataanalyse = deputes2.map(({ mail,twitter,facebook,website,datemaj,...rest}) => rest)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":246,"value":"liste_groupes_ab = Array.from(new Set(dataanalyse.map(item => item.GroupeAbrev)));","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":256,"value":"nb_par_groupe = {\n const r = [];\n liste_groupes_ab.forEach((g) =>{\n const nb = dataanalyse.filter(d => d.GroupeAbrev === g).length;\n r.push({\n Groupe : g,\n Nb_Députés : nb,\n });\n })\n return r;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":268,"value":"Plot.plot({\n marks: [\n Plot.barY(\n nb_par_groupe,\n {\n x: \"Groupe\",\n y: \"Nb_Députés\",\n sort: {x: \"y\", reverse: true },\n fill: \"lightblue\", \n }\n ),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":295,"value":"viewof groupe = Inputs.select(\n liste_groupes_ab,\n { label: \"Groupe\" }\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":306,"value":"ages = Array.from(new Set(dataanalyse.map(item => item.ClasseAge))).sort();","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":308,"value":"nb_par_age = {\n const r = [];\n ages.forEach((a) =>{\n const nb = dataanalyse.filter(d => d.ClasseAge === a).length;\n r.push({\n ClasseAge : a,\n Nb_Députés : nb,\n });\n })\n return r;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":312,"value":"Plot.plot({\n marks: [\n Plot.barY(\n nb_par_age,\n {\n x: \"ClasseAge\",\n y: \"Nb_Députés\",\n sort: {y: \"x\", reverse: true },\n fill: \"lightblue\", \n }\n ),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W48","stdlib":"1"}} 46:"$45:body"