40:null 41:["$","title",null,{"children":"TP NOTÉ ARBAUT/DESCHAMPS RENDU INTERMÉDIAIRE | Jean-Baptiste Arbaut's Workspace | Observable"}] 47:T589,

Il y a ${data.length} individus et ${Object.keys(data[0]).length} colonnes dans le fichier.

Le fichier provient du site data.gouv.fr, il a été créé le 4 octobre 2023. Il possède une licence ouverte / open licence, ce qui autorise sa réutilisation. Vous pouvez le retrouver à l'adresse suivante : ${url}.

Ces données concernent les députés actifs de l'Assemblée nationale. Nous disposons des principales variables socio-démographiques des députés, telles que le sexe, l'âge, le lieu et la date de naissance ou le métier. Nous avons également des variables plus spécifiques sur le métier de député, comme la date de prise de fonction, le groupe parlementaire, le nombre de mandats et l'expérience parlementaire.

Enfin, nous avons plusieurs variables de type "score" permettant de mesurer l'activité des députés dans l'hémicycle. Parmi ces variables, on trouve le score de participation, le score de loyauté ou le score de majorité. La description de toutes ces variables est disponible sur data.gouv.fr.

` 48:T699,##### Nous souhaitons réalisé les graphiques suivants : - La répartition de l'assemblée suivant groupeAbrev - Explication : Ce graphique servira à visualiser la répartition des groupes au sein de l'assemblée. - Dans l'idéal, nous souhaitons si possible créer un graphique demi-circulaire avec des points. Un points représentant un député et une couleur pour son appartenance politique. - Nous souhaitons aussi rajouter un filtre interactif sur le département. - La répartition homme/femme suivant age - Explication : Ce graphique servira à voir les indicateurs concernant l'âge entre les hommes et femmes députés. - Nous souhaitons créer un boxplot pour réaliser ce graphique. - Toutes les variables quantitatives en fonction du groupeAbrev - Explication : Ce graphique servira à voir les indicateurs concernant la répartition des différentes variables numériques des députés selon leur appartenance politique. - Nous souhaitons créer plusieurs boxplots. - Nous souhaitons aussi ajouter un filtre interactif en fonction des variables. - Le scoreParticipation suivant le groupeAbrev - Explication : Ce graphique servira à visualiser les indicateurs de la participation des députés au sein des groupes. - Nous souhaitons un boxplot pour réaliser le graphique. - De plus, nous souhaitons ajouter un filtre interactif sur le sexe. - Nous avons également d'autres idées de graphiques que nous allons possiblement réaliser si nous avons le temps. Parmi ces graphiques il y a : - La loyauté selon le groupeAbrev. - Le scoreParticipation suivant experienceDepute - L'age en fonction du groupeAbrev 49:T454,data2 = data.map((d) => { let experienceDepute = parseInt(d.experienceDepute); const unit = d.experienceDepute.includes("an") ? "an" : d.experienceDepute.includes("mois") ? "mois" : d.experienceDepute.includes("jours") ? "jours" : null; if (unit === "mois") { experienceDepute /= 12; } else if (unit === "jours") { experienceDepute /= 365.25; } // Recodage de civ let civRecode; if (d.civ === "M.") { civRecode = "Homme"; } else if (d.civ === "Mme") { civRecode = "Femme"; } // Création du champ NomPrenom let nomPrenom = `${d.nom.toUpperCase()} ${d.prenom}`; return { id: d.id, NomPrenom: nomPrenom, civ: civRecode, groupeAbrev: d.groupeAbrev, naissance: new Date(d.naissance), age: +d.age, experienceDepute: experienceDepute, scoreParticipation: +d.scoreParticipation, scoreLoyaute: +d.scoreLoyaute, departementCode: +d.departementCode, departementNom: d.departementNom }; }); 4a:T5bd,{ let filteredData = data2; // Initialisez filteredData avec l'ensemble des données par défaut // Créez et retournez le graphique en utilisant filteredData return Plot.plot({ marginLeft: 100, style: { border: "2px solid black", borderRadius: "10px", padding: "10px" }, title : "Age en fonction du groupeAbrev", grid: true, marks: [ Plot.ruleY({ stroke: 'grey', strokeDasharray: '5 20', strokeWidth: 0.5 }), Plot.boxY(filteredData, { y: `${choixV}`, x: "groupeAbrev", sort: {y: "y"}, fill: d => { if (d.groupeAbrev === "GDR-NUPES") { return "red"; } else if (d.groupeAbrev === "LFI-NUPES") { return "darkred"; } else if (d.groupeAbrev === "ECOLO") { return "green"; } else if (d.groupeAbrev === "SOC-A") { return "pink"; } else if (d.groupeAbrev === "RE") { return "yellow"; } else if (d.groupeAbrev === "DEM") { return "orange"; } else if (d.groupeAbrev === "HOR") { return "darkblue"; } else if (d.groupeAbrev === "LIOT") { return "lightpink"; } else if (d.groupeAbrev === "LR") { return "lightblue"; } else if (d.groupeAbrev === "RN") { return "navy"; } else if (d.groupeAbrev === "NI") { return "gray"; } } }), ] }); } 4b:T6a2,{ let filteredData = data2; // Initialisez filteredData avec l'ensemble des données par défaut if (choixS !== "Tout") { // Filtrez les données en fonction du choix de l'utilisateur, sauf si "TOUT" est sélectionné filteredData = data2.filter(d => d.civ === `${choixS}`); } // Créez et retournez le graphique en utilisant filteredData return Plot.plot({ marginLeft: 100, style: { border: "2px solid black", borderRadius: "10px", padding: "10px" }, title : "scoreParticipation en fonction du groupeAbrev et du sexe", grid: true, marks: [ Plot.ruleY({ stroke: 'grey', strokeDasharray: '5 20', strokeWidth: 0.5 }), Plot.boxY(filteredData, { y: "scoreParticipation", x: "groupeAbrev", sort: {y: "y"}, fill: d => { if (d.groupeAbrev === "GDR-NUPES") { return "red"; } else if (d.groupeAbrev === "LFI-NUPES") { return "darkred"; } else if (d.groupeAbrev === "ECOLO") { return "green"; } else if (d.groupeAbrev === "SOC-A") { return "pink"; } else if (d.groupeAbrev === "RE") { return "yellow"; } else if (d.groupeAbrev === "DEM") { return "orange"; } else if (d.groupeAbrev === "HOR") { return "darkblue"; } else if (d.groupeAbrev === "LIOT") { return "lightpink"; } else if (d.groupeAbrev === "LR") { return "lightblue"; } else if (d.groupeAbrev === "RN") { return "navy"; } else if (d.groupeAbrev === "NI") { return "gray"; } } }), ] }); } 4c:T593,{ function getColorByGroupeAbrev(groupeAbrev) { switch (groupeAbrev) { case "GDR-NUPES": return "red"; case "LFI-NUPES": return "darkred"; case "ECOLO": return "green"; case "SOC-A": return "pink"; case "RE": return "yellow"; case "DEM": return "orange"; case "HOR": return "darkblue"; case "LIOT": return "lightpink"; case "LR": return "lightblue"; case "RN": return "navy"; case "NI": return "gray"; } } function plotGraph() { const nonFilteredPoints = data2.filter(d => d.groupeAbrev !== choixG); const filteredPoints = data2.filter(d => d.groupeAbrev === choixG); return Plot.plot({ width: width * 2/3, height: width * 2/4, marginLeft: 100, style: { border: "2px solid black", borderRadius: "10px", padding: "10px" }, title : "scoreParticipation en fonction de l'experiance et du groupeabv ", grid: true, marks: [ Plot.dot(nonFilteredPoints, {x: "experienceDepute", y: "scoreParticipation", fill: "rgb(180,180,180)"}), Plot.dot(filteredPoints, {x: "experienceDepute", y: "scoreParticipation", channels : {id: "id", NomPrenom : "NomPrenom", age : "age"}, tip: true, fill: d => getColorByGroupeAbrev(d.groupeAbrev), r: 6}), Plot.crosshair(data2, {x: "experienceDepute", y: "scoreParticipation"}), ] }); } var test = plotGraph(); return test; } 4d:T56f,{ let filteredData = data2; if (choixD !== "Tout") { filteredData = data2.filter(d => d.departementNom === choixD); } // Create the chart with the filtered data return Plot.plot({ marginLeft: 100, style: { border: "2px solid black", borderRadius: "10px", padding: "10px" }, title: `Number of Deputies by Group and Department (${choixD})`, marks: [ Plot.barY( filteredData, { x: "groupe", y: "nombre_deputé", fill: d => { // Use a switch statement for better readability switch (d.groupe) { case "GDR-NUPES": return "red"; case "LFI-NUPES": return "darkred"; case "ECOLO": return "green"; case "SOC": return "pink"; case "RE": return "yellow"; case "DEM": return "orange"; case "HOR": return "darkblue"; case "LIOT": return "lightpink"; case "LR": return "lightblue"; case "RN": return "navy"; case "NI": return "gray"; default: return "black"; } }, }, { sort: { x: "nombre_deputé", reverse: true } } // Sorting configuration ), Plot.ruleY([0]) ], grid: true }); }4e:[] 45:{"id":"9b14e72263a3be49","slug":null,"title":"TP NOTÉ ARBAUT/DESCHAMPS RENDU INTERMÉDIAIRE","thumbnail":"a768d20f0b90163c8a008be21ca11202f6b2b11ac9cade69fc62366296077a27","access_level":"public","create_time":"$D2023-10-17T08:21:58.264Z","update_time":"$D2023-11-15T08:54:20.917Z","view_time":null,"first_public_time":"$D2023-10-17T08:21:58.264Z","has_unpublished_edits":null,"fork":{"id":"c61081479a7f5a6a","slug":null,"title":"TP NOTÉ ARBAUT/DESCHAMPS RENDU INTERMÉDIAIRE","owner":{"id":"9c1988ea8630cae5","login":"jean-baptiste-arbaut-ws","name":"Jean-Baptiste Arbaut's Workspace"}},"stars":0,"starred":false,"owner":{"type":"team","id":"9c1988ea8630cae5","login":"jean-baptiste-arbaut-ws","name":"Jean-Baptiste Arbaut's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/19220edebb45ce4958aa8dbc84a4101c75beca26357819776db7de929ff4ffd1","tier":"starter_2024","bio":"","following":false},"version":653,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"b29a681da3ab0294","login":"jean-baptiste-arbaut","name":"Jean-Baptiste","avatar_url":"https://avatars-next.observableusercontent.com/26706a849f6d4075427b1853171e3eb755cf4a6ee70f9fdc1f26b6ac49b4015e","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"b29a681da3ab0294","login":"jean-baptiste-arbaut","name":"Jean-Baptiste","avatar_url":"https://avatars-next.observableusercontent.com/26706a849f6d4075427b1853171e3eb755cf4a6ee70f9fdc1f26b6ac49b4015e","tier":null,"role":"editor"},{"type":"team","id":"9c1988ea8630cae5","login":"jean-baptiste-arbaut-ws","name":"Jean-Baptiste Arbaut's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/19220edebb45ce4958aa8dbc84a4101c75beca26357819776db7de929ff4ffd1","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"TP NOTÉ ARBAUT/DESCHAMPS RENDU INTERMÉDIAIRE","cells":[{"id":0,"value":"# TP NOTÉ ARBAUT/DESCHAMPS RENDU INTERMÉDIAIRE","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":7,"value":"## Récupération du jeu de données","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":10,"value":"url = \"https://www.data.gouv.fr/fr/datasets/r/092bd7bb-1543-405b-b53c-932ebb49bb8e\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"data = d3.csv(url);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":557,"value":"$47","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":40,"value":"#### Après analyse du fichier nous allons retenir les variables :\n- ID\n- civ\n- groupeAbrev\n- naissance\n- age\n- experienceDepute\n- scoreParticipation\n- scoreLoyaute\n- Nom\n- Prenom\n- departementCode\n- departementNom","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":72,"value":"$48","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":87,"value":"## Modification des données ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":89,"value":"#### Dans la suite du projet, nous allons réaliser des modifications sur les données afin de pouvoir les utilisés dans nos graphiques.\n\n| Variables | Modifications \n| :--------------- |:--------------- \n| civ | Recoder par Homme et Femme \n| age | Convertir en numérique \n| experienceDepute | Les modalités sont composées de l'âge et de an(s) ex: 21 ans. Il va revoir extraire le nombre. Il faudra également faire attention à l'unité, certain député ont des années d'autres des mois ou des jours.\n| scoreParticipation | Convertir en numérique \n| scoreLoyaute | Convertir en numérique\n| NomPrenom | On va créer une variable qui comprends le nom et le prénom des personnes en une seule variable","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":108,"value":"# Réalisation du projet","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":123,"value":"## Importation des données avec traitements","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":111,"value":"$49","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":587,"value":"# Réalisation des graphiques","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":145,"value":"## 1er graphique","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":165,"value":"Plot.plot({\n marginLeft: 100,\n style: { border: \"2px solid black\", borderRadius: \"10px\", padding: \"10px\" }, \n title : \"Répartition Homme/Femme suivant l'âge\",\n grid: true,\n marks: [\n Plot.ruleY({ stroke: 'grey', strokeDasharray: '5 20', strokeWidth: 0.5 }),\n Plot.boxY(data2, {\n y: \"age\",\n x: \"civ\",\n sort: {y: \"y\"},\n fill: d => d.civ === \"Homme\" ? \"blue\" : \"pink\" \n }),\n ]\n})\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":188,"value":"## 2ème graphique","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":248,"value":"viewof choixV = (function() {\n let groupes = [\"age\",\"experienceDepute\",\"scoreParticipation\",\"scoreLoyaute\"].sort();\n return Inputs.select(groupes, { label: \"Choix de la variable\" });\n})();","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":195,"value":"$4a","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":260,"value":"## 3ème graphique","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":269,"value":"viewof choixS = (function() {\n let sexe = [...new Set(data2.map(item => item.civ))].sort();\n sexe.push(\"Tout\");\n return Inputs.select(sexe, { label: \"Choix du sexe\" });\n})();","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":275,"value":"$4b","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":316,"value":"## 4ème graphique ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":347,"value":"viewof choixG = (function() {\n let groupe = [...new Set(data2.map(item => item.groupeAbrev))].sort();\n return Inputs.select(groupe, { label: \"Choix du groupe\" });\n})();","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":369,"value":"$4c","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":629,"value":"## 5ème graphique","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":612,"value":"uniqueGroups = [...new Set(data2.map(d => d.groupeAbrev))];","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":615,"value":"tab = {\n const uniqueValuesParType = [];\n \n for (const grp of uniqueGroups) {\n const valeursUniques = [...new Set(data.filter(d => d.groupeAbrev === grp).map(d => d.id))];\n const nb = valeursUniques.length;\n \n uniqueValuesParType.push({\n groupe: grp,\n nombre_deputé: nb\n });\n }\n \n return uniqueValuesParType;\n\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":635,"value":"viewof choixD = (function() {\n let dep = [...new Set(data2.map(item => item.departementNom))].sort();\n dep.push(\"Tout\");\n return Inputs.select(dep, { label: \"Choix du département\" });\n})();","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":601,"value":"$4d","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":509,"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"}],"files":"$W4e","stdlib":"1"}} 46:"$45:body"