2c:null 2d:["$","title",null,{"children":"Consommation et production électrique française de 2012 à 2020 | Vincent VIVANLOC | Observable"}] 32:T648,lineMultiStacked = { const filteredData = dataParTypeWithoutConsumption .filter((d) => categoriesToShow.indexOf(d.type) > -1) .filter((d) => filterDate(d)); return addTooltips( Plot.plot({ y: { //type: "log", //domain: [1, 60000], label: " ↑ " + capitalize(stat) + " en MW", tickFormat: (f) => f.toLocaleString("FR-fr") }, marks: [ Plot.areaY(filteredData, { x: "date", y: "puissance", fill: "type", curve, stroke: "type", order: [ "fioul", "charbon", "gaz", "nucléaire", "eolien", "solaire", "hydraulique", "pompage", "bioénergies" ] }), Plot.text( filteredData, Plot.selectLast( Plot.stackY({ x: "date", y: "puissance", text: "type", fill: "type", textAnchor: "start", dx: 5, fontSize: 14, order: [ "fioul", "charbon", "gaz", "nucléaire", "eolien", "solaire", "hydraulique", "pompage", "bioénergies" ] }) ) ) ], color, marginLeft: 60, marginRight: 100, width, height: 500, caption: html`Production d'électricité en France de 2012 à 2020.` }) ); }33:T43d,function heatmapFacet(type1, type2) { const dataParTypeFilter = dataParTypeMois .filter((d) => { return (d.type === type1 || d.type === type2); }) .filter((d) => filterDate(d)); return Plot.plot({ height: 320*2, width, marginLeft: 100, padding: 0.05, grid: true, x: { axis: "top", label: "Mois" }, y: { label: "Année" }, facet: { data: dataParTypeFilter, y: (d) => d.type, // replace with the name of the column marginRight: 100, tickFormat: (f) => f.toLocaleString("FR-fr") }, fy: { domain: [ type1, type2] }, color: { // scheme: "RdYlBu" scheme: "YlOrRd" }, marks: [ Plot.cell(dataParTypeFilter, { sort: { y: "y", reverse: true }, x: "mois", y: "année", fill: (d) => d.puissance }), Plot.text(dataParTypeFilter, { x: "mois", y: "année", text: (d) => d.puissance.toLocaleString("FR-fr"), title: "puissance", fill: "black" }) ] }); }34:[{"id":"576646fd437867f6690b98a4a93ab65e6d08d593d6e6a8f87f41b8a5c32d84b42b67d35ea309e31d4c656167466b48bca25735b21b3ac988aaddebcdfaab6e20","href":"https://static.observableusercontent.com/files/576646fd437867f6690b98a4a93ab65e6d08d593d6e6a8f87f41b8a5c32d84b42b67d35ea309e31d4c656167466b48bca25735b21b3ac988aaddebcdfaab6e20","name":"puissance_mois_moy.csv","type":"text/csv","lastModified":1654469527622.66,"size":8748},{"id":"5a501fcd37cc6e843c58654ddd61e58c557b0128d1d3aee102407765a4d5473e208ba54652d8e52b774925b3e4361983705706349a44db777124c5f0dd53f3fc","href":"https://static.observableusercontent.com/files/5a501fcd37cc6e843c58654ddd61e58c557b0128d1d3aee102407765a4d5473e208ba54652d8e52b774925b3e4361983705706349a44db777124c5f0dd53f3fc","name":"puissance_annee_moy.csv","type":"text/csv","lastModified":1654469527622.66,"size":821},{"id":"6dd22aff00246e7cef3f8614b06af5dd9acc39d5ddc7ee2acb4ff7e34025779ad44e5b4ae93c34573f8752f4b4a6741a360199412cbe59e2008c547487501e7e","href":"https://static.observableusercontent.com/files/6dd22aff00246e7cef3f8614b06af5dd9acc39d5ddc7ee2acb4ff7e34025779ad44e5b4ae93c34573f8752f4b4a6741a360199412cbe59e2008c547487501e7e","name":"puissance_demiheure.csv","type":"text/csv","lastModified":1654469527622.66,"size":13679908},{"id":"b9adca4c806f9100594f63dcffb0e1a8e274127c0703feeab7c6dc2bb5a3f57eb792b09eaa96bf3871e93050ff9d0107f7f7e969ae4571fa2e2a698f7a8b2174","href":"https://static.observableusercontent.com/files/b9adca4c806f9100594f63dcffb0e1a8e274127c0703feeab7c6dc2bb5a3f57eb792b09eaa96bf3871e93050ff9d0107f7f7e969ae4571fa2e2a698f7a8b2174","name":"puissance_jour_min.csv","type":"text/csv","lastModified":1654469527622.66,"size":252834},{"id":"6dee2ba8239c34fd7411cf944b9e8ea30dd1b6e22365949832113a25c4b56b407de6ce67047177cac3550170f5ca6678429478b8cbcd631876de98bacb0956ab","href":"https://static.observableusercontent.com/files/6dee2ba8239c34fd7411cf944b9e8ea30dd1b6e22365949832113a25c4b56b407de6ce67047177cac3550170f5ca6678429478b8cbcd631876de98bacb0956ab","name":"puissance_jour_max.csv","type":"text/csv","lastModified":1654469527622.66,"size":261737},{"id":"c3dfd6e37e17936f07cdb5c2e197535b961e0070ddac56f3c4dded2609bb4e5ea7ada201b6d492eec50ae80a4039e1a8b1834020d57aaf9c441fb574484e2dfb","href":"https://static.observableusercontent.com/files/c3dfd6e37e17936f07cdb5c2e197535b961e0070ddac56f3c4dded2609bb4e5ea7ada201b6d492eec50ae80a4039e1a8b1834020d57aaf9c441fb574484e2dfb","name":"puissance_jour_moy.csv","type":"text/csv","lastModified":1654469527622.66,"size":261857}] 30:{"id":"589713af5a8fd153","slug":"consommation-et-production-electrique-francaise-de-2012-a","title":"Consommation et production électrique française de 2012 à 2020 ","thumbnail":"8962d3935d0e19a15c5717dc651289b140fbefbb7d82909fa561e048f7eff3d6","access_level":"public","create_time":"$D2022-06-05T22:52:07.622Z","update_time":"$D2022-09-20T21:18:13.818Z","view_time":null,"first_public_time":"$D2022-06-05T22:52:26.793Z","fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"66fa4f7125e7dd55","login":"vvivanloc","name":"Vincent VIVANLOC","avatar_url":"https://avatars-next.observableusercontent.com/3805f5966b13c10af07bad51a9da6491b27c8d208657dce68a8cfb60a9ab85db","tier":"starter_2024"},"version":2319,"publish_version":2319,"role":null,"authored":false,"authors":[{"type":"individual","id":"c522b6e3c699beb9","login":"vvivanloc","name":"Vincent VIVANLOC","avatar_url":"https://avatars-next.observableusercontent.com/3805f5966b13c10af07bad51a9da6491b27c8d208657dce68a8cfb60a9ab85db","tier":null}],"members":[{"type":"individual","id":"c522b6e3c699beb9","login":"vvivanloc","name":"Vincent VIVANLOC","avatar_url":"https://avatars-next.observableusercontent.com/3805f5966b13c10af07bad51a9da6491b27c8d208657dce68a8cfb60a9ab85db","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Consommation et production électrique française de 2012 à 2020 ","cells":[{"id":0,"value":"title = md`

Consommation et production électrique française de 2012 à 2020

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2313,"value":"intro = md`# Introduction\n\n**Que peut-on raconter avec ce jeu de données sur les consommations électriques en France ? **\n\nLa source des données provient de [RTE](https://www.rte-france.com/eco2mix/telecharger-les-indicateurs). \nCe jeu de données contient la puissance consommée en France ainsi que le type de génération (nucléaire, charbon, éolien...) sur les années 2012 à 2020 avec un pas de 30 minutes.\n\n\nUn [travail préparatoire](https://www.kaggle.com/vincentvivanloc/eco2-energy-mix/) a été effectué sur ces jeux de données :\n- Concaténation des 9 fichiers \"annuel définitif\" des années 2012 à 2020. \n- Un certain nombre de colonnes des fichiers originaux ont été supprimées. \n- Les données sont regroupées par jour, mois ou année donnent la somme, la valeur moyenne, min et max par jour avec un fichier par regroupement. \n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2310,"value":"intro","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1755,"value":"table2 = Inputs.table(\n data.filter((d) => filterDate(d)),\n { locale: \"FR-fr\" }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2242,"value":"viewof table3 = Inputs.table(\n dataParType.filter((d) => filterDate(d)),\n { locale: \"FR-fr\" }\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2246,"value":"viewof table4 = Inputs.table(\n dataParTypeMois.filter((d) => filterDate(d)),\n { locale: \"FR-fr\" }\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":535,"value":"# Graphiques","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":35,"value":"## 1 : graphique en lignes \n\nVoir les données ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2227,"value":"viewof curve = Inputs.select(\n [\n \"linear\",\n \"step\",\n \"step-after\",\n \"step-before\",\n // \"linear-closed\",\n \"basis\",\n // \"basis-closed\",\n // \"basis-open\",\n // \"bundle\",\n \"cardinal\",\n // \"cardinal-closed\",\n // \"cardinal-open\",\n \"catmull-rom\",\n // \"catmull-rom-closed\",\n // \"catmull-rom-open\",\n \"monotone-x\",\n // \"monotone-y\",\n \"bump-x\",\n // \"bump-y\",\n \"natural\"\n ],\n { label: \"Courbe\", value: \"linear\" }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":208,"value":"viewof production = Inputs.select(\n types,\n { label: \"Selectionner le type de données \", value: \"Consommation\" }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1258,"value":"viewof sampling = Inputs.radio([\"jour\", \"mois\", \"annee\"], {\n label: \"Période d'échantillonage\",\n value: \"jour\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":131,"value":"viewof stat = Inputs.radio(sampling===\"jour\"?[\"moyenne\", \"max\", \"min\"]:[\"moyenne\"], {\n label: \"Indicateur statistique\",\n value: \"moyenne\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":729,"value":"viewof slider1 = rangeSlider({\n min: 0,\n max: d3.timeDay.count(dateExtent1[0], dateExtent1[1]),\n step: 1,\n format: (d) => formatDate(d3.timeDay.offset(dateExtent1[0], d)),\n title: \"\",\n description: \"Selectionnez les dates d'analyse\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":41,"value":"lineSimple = {\n return addTooltips(\n Plot.plot({\n y: {\n label: \" ↑ \" + capitalize(production) + \" \" + stat + \" en MW\",\n tickFormat: (f) => f.toLocaleString(\"FR-fr\")\n },\n marks: [\n Plot.line(\n data.filter((d) => filterDate(d)),\n { x: \"date\", y: production, curve, stroke: myPieColor[production] }\n )\n ],\n width,\n height: 500,\n marginLeft: 70,\n caption: html`Figure 1. ${\n production === \"consommation\" ? \"consommation\" : \"production\"\n } journalière d'électricité en France de 2012 à 2020.`\n })\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1761,"value":"function filterDate(d) {\n return (d.date >= slider1Dates[0]) & (d.date <= slider1Dates[1])\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":299,"value":"## 2a : graphique en ligne - tout ensemble ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":440,"value":"

\n\nCe n'est pas très lisible, mais cela permet de dégager des grandes tendances.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1314,"value":"lineMulti = {\n const dataFiltered = dataParType\n .filter((d) => categoriesToShow.indexOf(d.type) > -1)\n .filter((d) => filterDate(d));\n return addTooltips(\n Plot.plot({\n y: {\n label: \" ↑ \" + capitalize(stat) + \" en MW\",\n tickFormat: (f) => f.toLocaleString(\"FR-fr\")\n },\n marginLeft: 100,\n marginRight: 100,\n marks: [\n Plot.line(dataFiltered, {\n x: \"date\",\n y: \"puissance\",\n curve,\n stroke: (d) => myPieColor[d.type]\n }),\n Plot.text(\n dataFiltered,\n Plot.selectLast({\n x: \"date\",\n y: \"puissance\",\n text: \"type\",\n fill: (d) => myPieColor[d.type],\n textAnchor: \"start\",\n dx: 5,\n fontSize: 14\n })\n )\n ],\n width,\n height: 500,\n caption: html`Consommation et production d'électricité en France de 2012 à 2020.`\n })\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1312,"value":"legendLineMulti = lineMultiStacked.legend(\"color\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1867,"value":"## 2b : graphique en ligne empilé - tout ensemble ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1163,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1871,"value":"## 2c : Tout ensemble offset empilés ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1881,"value":"md` A faire ! `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1875,"value":"md`Expanded offset stacked plot https://observablehq.com/@observablehq/plot-stack#cell-289`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1039,"value":"## 3 : Graphique en aires à facettes ordonnées! ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":991,"value":"viewof categoriesToShow = Inputs.checkbox(types, {\n label: \"Choisir les puits et sources d'énergie à inclure\",\n value: types.filter((d) => (d != \"consommation\") & (d != \"pompage\")) // default selection\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1002,"value":"viewof selectedSortOption = Inputs.radio(Object.keys(sortOptions), {\n label: \"Tri\",\n value: \"décroissant\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1006,"value":"viewof normalizeY = Inputs.toggle({\n label: \"Utilisation d'echelles indépendantes\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":999,"value":"lineMultiFacette = {\n const dataFilteredByDate = dataFiltered.filter((d) => filterDate(d));\n return addTooltips(\n Plot.plot({\n facet: {\n data: dataFilteredByDate,\n y: (d) => d[categoriesName], // replace with the name of the column\n marginRight: 200,\n tickFormat: (f) => f.toLocaleString(\"FR-fr\")\n },\n fy: {\n domain: categoriesFilteredSorted\n },\n marks: [\n Plot.lineY(\n dataFilteredByDate,\n (normalizeY ? Plot.normalizeY : (x) => x)({\n x: \"date\",\n y: (d) => d[metricName],\n curve,\n basis: \"max\",\n stroke: \"type\"\n })\n )\n ],\n width,\n marginLeft: 70,\n height: categoriesFilteredSorted.length * 120,\n color,\n caption: html`Consommation et production d'électricité en France de 2012 à 2020.`\n })\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1843,"value":"## Regroupement par mois ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1691,"value":" dataFilteredByDate=dataFiltered.filter(\n (d) => filterDate(d))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1834,"value":"## 4 : Graphique à cellules - échelles indépendantes","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1949,"value":"Ajouter choix echelle fixe ?\nClarifier le warning ? \nRemplacer le 2ieme graphique à cellules par des small multiples ? ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1503,"value":"viewof production1 = Inputs.select(\n types,\n { label: \"Selectionner le type de données \", value: \"Consommation\" }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1501,"value":"cell = heatmap(production1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1750,"value":"globalHeatmap.legend(\"color\",{label: \"puissance (MW) →\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1498,"value":"viewof production2 = Inputs.select(\n types,\n { label: \"Selectionner le type de données \", value: \"nucléaire\" }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1640,"value":"cell2 = heatmap(production2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1649,"value":"heatmap(production1).legend(\"color\",{label: \"puissance (MW) →\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1436,"value":"function heatmap(type) {\n const dataParTypeFilter = dataParTypeMois\n .filter((d) => {\n return d.type === type;\n })\n .filter((d) => filterDate(d));\n\n return Plot.plot({\n height: 320,\n width,\n marginLeft: 100,\n padding: 0.05,\n grid: true,\n\n x: {\n axis: \"top\",\n label: \"Mois\"\n },\n y: {\n label: \"Année\"\n },\n color: {\n // scheme: \"RdYlBu\"\n scheme: \"YlOrRd\"\n },\n marks: [\n Plot.cell(dataParTypeFilter, {\n sort: { y: \"y\", reverse: true },\n x: \"mois\",\n y: \"année\",\n fill: (d) => d.puissance\n }),\n Plot.text(dataParTypeFilter, {\n x: \"mois\",\n y: \"année\",\n text: (d) => d.puissance.toLocaleString(\"FR-fr\"),\n title: \"puissance\",\n fill: \"black\"\n })\n ]\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2131,"value":"## 4 bis: Graphique à cellules - échelles non indépendantes ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2113,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2117,"value":"heatmapFacet(production1,production2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2138,"value":"heatmapFacet(production1,production2).legend(\"color\",{label: \"puissance (MW) →\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1928,"value":"## 5a: Graphique à barres","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1932,"value":"-","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1910,"value":"## 5b: Graphique à barres à facettes ordonnées!","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1919,"value":"A corriger","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1029,"value":"barMultiFacette = {\n return addTooltips(\n Plot.plot({\n facet: {\n data: dataFilteredByDate,\n y: (d) => d[categoriesName], // replace with the name of the column\n marginRight: 200,\n tickFormat: (f) => f.toLocaleString(\"FR-fr\")\n },\n fy: {\n domain: categoriesFilteredSorted\n },\n marks: [\n Plot.barY(\n dataFilteredByDate,\n (normalizeY ? Plot.normalizeY : (x) => x)({\n // A CORRIGER\n x: \"date\",\n y: (d) => d[metricName],\n\n fill: \"type\"\n })\n )\n ],\n width,\n marginLeft: 70,\n height: categoriesFilteredSorted.length * 120,\n color\n })\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1345,"value":"## 6: Le fameux camembert ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1392,"value":"consommationTotale = categoriesRolledUp\n .filter((d) => d[0]===\"consommation\") [0][1]\n ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1353,"value":"categoriesFilteredSortedPie = categoriesRolledUp\n .filter((d) => d[0]!==\"consommation\")\n .filter((d) => categoriesToShow.includes(d[0]))\n .sort(sortOptions[selectedSortOption])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1375,"value":" myPieData = categoriesFilteredSortedPie.reduce((accumulator, element, index) => {\n return {...accumulator, [element[0]]: element[1]/consommationTotale};\n}, {});","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1410,"value":"myPieColorPre = color","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1542,"value":"myPieColor=myPieColorPre.domain.reduce((a,e,i)=>{return {...a, [e]:myPieColorPre.range[i]}},{})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1335,"value":"pie = chart","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1459,"value":"myBarDataReduce = categoriesRolledUp.filter(d=>categoriesToShow.indexOf(d[0])>-1).reduce((accumulator, element, index) => {\n return {...accumulator, [element[0]]: element[1]};\n}, {});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1471,"value":"myBarData=Object.keys((myBarDataReduce)).map(item=>{return {type:item, puissance:myBarDataReduce[item]}})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1800,"value":"# RAJOUTER DES Couleurs ?","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1418,"value":"bar = Plot.plot({\n x: {\n tickFormat: (f) => f.toLocaleString(\"FR-fr\")\n },\n marginLeft: 100,\n marks: [Plot.barX(myBarData, { y: \"type\", x: \"puissance\" })],\n width,\n height: 500,\n caption: html`Consommation et production d'électricité en France de 2012 à 2020.`,\n color\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1783,"value":"# A FAIRE: stacked bar plot : https://observablehq.com/@observablehq/plot-bar?collection=@observablehq/plot#cell-862","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1724,"value":"Plot.plot({\n x: {\n percent:true,\n tickFormat: (f) => f.toLocaleString(\"FR-fr\")\n },\n marginLeft: 100,\n marks: [\n Plot.ruleX([0, 1]),\n Plot.barX(myBarData, Plot.stackX({order: \"type\", y: \"type\", x:\"puissance\", insetLeft: 1}))\n ],\n width,\n height: 500,\n caption: html`Consommation et production d'électricité en France de 2012 à 2020.`,\n color, \n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1427,"value":"globalHeatmap = {\n return Plot.plot({\n height: 640,\n marginLeft: 100,\n padding: 0.05,\n width,\n height: 500,\n grid: true,\n x: {\n axis: \"top\",\n label: \"Date\"\n },\n y: {\n label: \"Type\"\n },\n color: {\n //scheme: \"RdYlBu\"\n scheme: \"YlOrRd\"\n },\n marks: [\n Plot.cell(\n dataParTypeMois\n .filter((d) => categoriesToShow.indexOf(d.type) > -1)\n .filter((d) => filterDate(d)),\n {\n x: \"date\",\n y: \"type\",\n fill: \"puissance\"\n }\n )\n ]\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1652,"value":"heatmap(production2).legend(\"color\" ,{label: \"puissance (MW) →\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":24,"value":"## Source de données ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":282,"value":"Les données sont issues de la concaténation des 9 fichiers RTE où les valeurs sont prises toutes les 30 minutes. Il est donné à titre informatif et ne sera pas utilisé dans ce bloc-note.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":227,"value":"FileAttachment(\"puissance_demiheure.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1991,"value":"### Chargement des fichiers données ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":275,"value":"Les données ont été traitées au préalable avec un bloc-note [Jupyter](https://www.kaggle.com/vincentvivanloc/eco2-energy-mix/) selon les indicateurs statistiques (somme, moyenne, max et min). Chaque traitement a donné un fichier CSV importé dans ce bloc-note ObservableHQ. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1188,"value":"p_jour_max=FileAttachment(\"puissance_jour_max.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1189,"value":"p_jour_min=FileAttachment(\"puissance_jour_min.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1214,"value":"p_jour_moy=FileAttachment(\"puissance_jour_moy.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1216,"value":"p_mois_moy=FileAttachment(\"puissance_mois_moy.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1222,"value":"p_annee_moy=FileAttachment(\"puissance_annee_moy.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1999,"value":"### Création des fichiers de données pour les graphiques ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2028,"value":"##### Traitement des données en fonction des sélecteurs statistique (moy,min, max ou somme) ET période (jour, mois ou année) ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":140,"value":"getSelectedFile = {\n let fileName = p_jour_max;\n if (sampling === \"jour\") {\n if (stat === \"moyenne\") {\n fileName = p_jour_moy;\n } else if (stat === \"max\") {\n fileName = p_jour_max;\n } else if (stat == \"min\") {\n fileName = p_jour_min;\n }\n return fileName;\n }\n\n return getSelectedFileMonthYear();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1616,"value":"function getSelectedFileMonthYear() {\n let fileName= p_mois_moy;\n if (sampling===\"mois\") {\n fileName = p_mois_moy;\n } \n\n if (sampling===\"annee\") {\n fileName = p_annee_moy;\n } \n return fileName;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":53,"value":"function typeData(sourceFile) {\n return sourceFile\n .map(function (e) {\n return {\n date: d3.utcParse(\"%Y-%m-%d\")(e.Date_ISO),\n année: d3.timeFormat(\"%Y\")(d3.timeParse(\"%Y-%m-%d\")(e.Date_ISO)),\n mois: d3.timeFormat(\"%m\")(d3.timeParse(\"%Y-%m-%d\")(e.Date_ISO)),\n jour: d3.timeFormat(\"%d\")(d3.timeParse(\"%Y-%m-%d\")(e.Date_ISO)),\n consommation: +e.Consommation,\n fioul: +e.Fioul,\n charbon: +e.Charbon,\n gaz: +e.Gaz,\n nucléaire: +e.Nucléaire,\n eolien: +e.Eolien,\n solaire: +e.Solaire,\n hydraulique: +e.Hydraulique,\n pompage: +e.Pompage,\n bioénergies: +e.Bioénergies\n //...e\n };\n })\n .sort((a, b) => a.date - b.date);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1601,"value":"data = typeData(getSelectedFile)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":579,"value":"Ces mêmes données ventilées par type.","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":353,"value":" types = [\n \"consommation\",\n \"fioul\",\n \"charbon\",\n \"gaz\",\n \"nucléaire\",\n \"eolien\",\n \"solaire\",\n \"hydraulique\",\n \"pompage\",\n \"bioénergies\"\n ]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":600,"value":"dataParType = getDataPerType","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1262,"value":"dataParTypeWithoutConsumption = getDataPerType.filter((d) => d.type != \"consommation\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1593,"value":"dataParTypeMois= buildDatePerType(typeData(getSelectedFileMonthYear()))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1608,"value":"getDataPerType= buildDatePerType(data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":702,"value":"function buildDatePerType(dataSource) {\n const dataParType = [];\n dataSource.forEach((d) => {\n types.forEach((t) => {\n dataParType.push({\n date: d.date,\n année: d.année,\n mois: d.mois,\n jour: d.jour,\n type: t,\n puissance: +d[t]\n });\n });\n });\n\n return dataParType;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1046,"value":"## Paramétrages graphiques ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":733,"value":"formatDate = d3.timeFormat(\"%Y-%m-%d\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1050,"value":"Slider de sélection des dates ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":739,"value":"dateExtent1 = d3.extent(data.map((d) => d.date))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":759,"value":"slider1Dates = slider1.map((d) => d3.timeDay.offset(dateExtent1[0], d))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1019,"value":"categoriesName = \"type\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1021,"value":"metricName = \"puissance\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1015,"value":"categories = categoriesRolledUp.map((d) => d[0])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1009,"value":"// a few functions to choose from for sorting the categories\nsortOptions = ({\n \"alphabétique\": (a, b) => (a[0] > b[0] ? 1 : -1),\n \"décroissant\": (a, b) => b[1] - a[1],\n \"croissant\": (a, b) => a[1] - b[1]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1733,"value":"dataParTypeFilteredByDate = dataParType.filter(\n (d) => filterDate(d));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1017,"value":"categoriesRolledUp = d3.rollups( dataParTypeFilteredByDate,\n (v) => d3.mean(v, (d) => d[metricName]),\n (d) => d[categoriesName])\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1011,"value":"// filter and sort the categorical strings based on the selections from the checkboxes and radio buttons\ncategoriesFilteredSorted = categoriesRolledUp\n .filter((d) => categoriesToShow.includes(d[0]))\n .sort(sortOptions[selectedSortOption])\n .map((d) => d[0])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1024,"value":"dataFiltered = dataParType.filter((d) =>\n categoriesFilteredSorted.includes(d[categoriesName])\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":268,"value":"\nmd`\n## Fonctions \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":340,"value":"function capitalize(string) { return string[0].toUpperCase() + string.slice(1)}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1118,"value":"color = ({\n domain: [\n \"fioul\",\n \"charbon\",\n \"gaz\",\n \"nucléaire\",\n \"eolien\",\n \"solaire\",\n \"hydraulique\",\n \"pompage\",\n \"bioénergies\",\n \"consommation\"\n ],\n range: [\n \"#5e4fa2\",\n \"#fdae61\",\n \"#FEC704\",\n \"#5C9631\",\n \"#664F06\",\n \"#BD7229\",\n \"#A1333F\",\n \"#0395D6\",\n \"#ADADAD\",\n \"#CCCC66\"\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":28,"value":"md`\n## Libraires externes \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":31,"value":"d3 = require(\"d3@6\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":33,"value":"import { rasterize, serialize } from \"@mbostock/saving-svg\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":453,"value":"import {addTooltips} from \"@mkfreeman/plot-tooltip\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":501,"value":"import {toFrenchNumber} from \"3084cf5b1d2439cf\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":735,"value":"import { rangeSlider as rangeSlider } from \"@mootari/range-slider\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1329,"value":"import {chart} with {myPieData as dataset, myPieColor as color} from \"@vvivanloc/pie-chart\" \n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2087,"value":"md`\n## Annexes \n\nhttps://developer.mozilla.org/fr/docs/Web/JavaScript/Reference/Global_Objects/Array/Reduce\n\nhttps://observablehq.com/@d3/d3-group\n\nlineMultiFacette réalisé à partir de l'exemple https://observablehq.com/@zanarmstrong/instead-of-a-stacked-area-chart-try-an-ordered-faceted-chart\n\n\nheatmap https://observablehq.com/@observablehq/plot-cell\n\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":744,"value":"//dateExtent2 = d3.extent(dataParType.map((d) => d.date))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":847,"value":"//puissanceExtent2 = d3.extent(dataParType.map((d) => d.puissance))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":39,"value":"/*graph_dom = DOM.download(\n await rasterize(graph_simple),\n \"grapheSimple.png\",\n \"Récupérer le lien pour intégrer le graphique dans un site web\"\n) */","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 31:"$30:body"