26:null 27:["$","title",null,{"children":"Consommation et production électrique française de 2012 à 2020 - v0.4 | Vincent VIVANLOC | Observable"}] 2c:[{"id":"5a501fcd37cc6e843c58654ddd61e58c557b0128d1d3aee102407765a4d5473e208ba54652d8e52b774925b3e4361983705706349a44db777124c5f0dd53f3fc","href":"https://static.observableusercontent.com/files/5a501fcd37cc6e843c58654ddd61e58c557b0128d1d3aee102407765a4d5473e208ba54652d8e52b774925b3e4361983705706349a44db777124c5f0dd53f3fc","name":"puissance_annee_moy.csv","type":"text/csv","lastModified":1663711888583.561,"size":821},{"id":"576646fd437867f6690b98a4a93ab65e6d08d593d6e6a8f87f41b8a5c32d84b42b67d35ea309e31d4c656167466b48bca25735b21b3ac988aaddebcdfaab6e20","href":"https://static.observableusercontent.com/files/576646fd437867f6690b98a4a93ab65e6d08d593d6e6a8f87f41b8a5c32d84b42b67d35ea309e31d4c656167466b48bca25735b21b3ac988aaddebcdfaab6e20","name":"puissance_mois_moy.csv","type":"text/csv","lastModified":1663711888600.727,"size":8748}] 2a:{"id":"e101edf719c2bb79","slug":"consommation-et-production-electrique-francaise-de-2012-a/3","title":"Consommation et production électrique française de 2012 à 2020 - v0.4","thumbnail":"842a3d0887bde8734852f68665f62e1d34662c1ccd9e02f58890046d0f961552","access_level":"public","create_time":"$D2022-09-19T17:41:23.014Z","update_time":"$D2022-09-20T22:46:01.786Z","view_time":null,"first_public_time":"$D2022-09-20T22:02:47.542Z","fork":{"id":"40b64d25c60c7882","slug":"rte2022","title":"Consommation et production électrique française de 2012 à 2020 ","owner":{"id":"66fa4f7125e7dd55","login":"vvivanloc","name":"Vincent VIVANLOC"}},"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":1075,"publish_version":1075,"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 - v0.4","cells":[{"id":439,"value":"

Consommation et production électrique française de 2012 à 2020 - v0.4

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":582,"value":" # Introduction\n\n*Que peut-on raconter avec ce jeu de données sur les consommations électriques en France ?*\n\n Ce jeu de données, issu de [RTE](https://www.rte-france.com/eco2mix), 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\nUn travail préparatoire a été effectué sur ces jeux de données :\n\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 de pompage ont été retranchées de l'énergie hydraulique\n - Les données sont regroupées par mois ou année donnent la valeur moyenne avec un fichier par regroupement.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":121,"value":"## Contrôles globaux \nCes contrôles s'appliquent à toutes les tables et graphiques de ce bloc-note.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":86,"value":"viewof sampling = Inputs.radio([\"mois\", \"annee\"], {\n label: \"Période d'échantillonage\",\n value: \"mois\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":88,"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":58,"value":"## Données sous forme de tableau","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":885,"value":"viewof table = Inputs.table(\n dataEx.filter((d) => filterDate(d)),\n { locale: \"FR-fr\" }\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":893,"value":"## Exploration statistique \nCette représentation permet d'avoir en un coup d'œil, un résumé statistique sur les données à la [skimr](https://github.com/ropensci/skimr).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":866,"value":"import { SummaryTable } from \"@observablehq/summary-table\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":879,"value":"SummaryTable(dataEx.filter((d) => filterDate(d)))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":79,"value":"# Graphiques","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":428,"value":"## Palette de couleur","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":371,"value":"viewof colorConsommation = colorOpacity({\n value: \"#f24646ff\",\n label: \"Consommation\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":348,"value":"viewof colorFioul = colorOpacity({\n value: \"#969696ff\",\n label: \"Fioul\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":366,"value":"viewof colorCharbon = colorOpacity({\n value: \"#000000ff\",\n label: \"Charbon\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":375,"value":"viewof colorGaz = colorOpacity({\n value: \"#3584E4ff\",\n label: \"Gaz\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":379,"value":"viewof colorNucléaire = colorOpacity({\n value: \"#5C9631ff\",\n label: \"Nucléaire\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":381,"value":"viewof colorEolien = colorOpacity({\n value: \"#c000c7ff\",\n label: \"Eolien\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":383,"value":"viewof colorSolaire = colorOpacity({\n value: \"#FF7800ff\",\n label: \"Solaire\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":373,"value":"viewof colorHydraulique = colorOpacity({\n value: \"#0395D6ff\",\n label: \"Hydraulique\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":394,"value":"viewof colorBioénergies = colorOpacity({\n value: \"#caf0afff\",\n label: \"Bioénergies\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":355,"value":"color = ({\n domain: typesEx,\n range: [\n colorConsommation,\n colorFioul,\n colorCharbon,\n colorGaz,\n colorNucléaire,\n colorEolien,\n colorSolaire,\n colorHydraulique,\n colorBioénergies\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":81,"value":"## 1 . Evolution sur 10 ans par catégorie","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":83,"value":"viewof production = Inputs.select(typesEx, {\n label: \"Selectionner le type de données \",\n value: \"Consommation\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":97,"value":"lineSimple = {\n return addTooltips(\n Plot.plot({\n y: {\n label: \" ↑ \" + capitalize(production) + \" \" + \"moyenne\" + \" en MW\",\n tickFormat: (f) => f.toLocaleString(\"FR-fr\")\n },\n marks: [\n Plot.line(\n dataEx.filter((d) => filterDate(d)),\n {\n x: \"date\",\n y: production,\n //curve: \"step-after\",\n stroke: getColor(production)\n }\n )\n ],\n width,\n height: 500,\n marginLeft: 70,\n caption: html`Figure 1. ${\n production === \"consommation\" ? \"consommation\" : \"production\"\n } par ${sampling} d'électricité en France de 2012 à 2020.`\n })\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":131,"value":"## 2. Evolution sur 10 ans comparée ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":135,"value":"viewof categoriesToShow = Inputs.checkbox(typesEx, {\n label: \"Choisir les puits et sources d'énergie à inclure\",\n value: typesEx.filter((d) => (d != \"consommation\") & (d != \"pompage\")) // default selection\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":835,"value":"### Superposé","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":158,"value":"lineMulti = {\n const dataFiltered = dataParTypeEx\n .filter((d) => categoriesToShow.indexOf(d.type) > -1)\n .filter((d) => filterDate(d));\n return addTooltips(\n Plot.plot({\n y: {\n label: \" ↑ \" + capitalize(\"moyenne\") + \" 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: \"step-after\",\n stroke: (d) => getColor(d.type)\n }),\n Plot.text(\n dataFiltered,\n Plot.selectLast({\n x: \"date\",\n y: \"puissance\",\n text: \"type\",\n fill: (d) => getColor(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":837,"value":"### Multiples","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":140,"value":"viewof normalizeY = Inputs.toggle({\n label: \"Utilisation d'echelles indépendantes\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":142,"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":154,"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: 100,\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":896,"value":"## 3. Evolution annuelle en proportions\nReprésentons les contributions de chacune des sources en fonction des années.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":923,"value":"viewof yearselect = Inputs.select(years, {\n label: \"Choisir l'année\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1000,"value":"Sous forme de camembert","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":961,"value":"PieChart(myPieData2, {\n name: (d) => d.name,\n value: (d) => d3.format(\".0f\")(d.value),\n colors: myPieColors\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1002,"value":"Sous forme de diagramme en barre","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":181,"value":"bar = Plot.plot({\n x: {\n tickFormat: (f) => f.toLocaleString(\"FR-fr\")\n },\n marginLeft: 100,\n marks: [\n Plot.barX(myBarData, {\n y: \"type\",\n x: \"puissance\",\n fill: (d) => getColor(d.type),\n rx: 3\n })\n ],\n width,\n\n height: 500,\n caption: html`Consommation et production d'électricité moyenne en France de 2012 à 2020 en MW.`\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1065,"value":" # A vous de jouer\n\n“Racontez une histoire“ à partir des données ouvertes RTE (Réseau de Transport d'Électricité).\n\nCommençons à explorer le jeu de données.\n- Quelles informations peuvent révéler ce jeu de données ?\n- Après avoir exploré chaque type de source d’énergie plus en détail, quelles nouvelles informations apparaissent ?\n \nQuelle histoire souhaitons-nous raconter et quels pourraient être les graphiques associés ?\n- Comment mettre en évidence les informations nécessaires pour raconter l'histoire ?\n- Proposition d'histoire : en équipe, choisissez un des rôles suivants,\n - data-journaliste le monde\n - data journaliste sciences et vie junior\n - Orano **(**ex AREVA)\n - Greenpeace\n - EDF\n - Ministère de l’Ecologie","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":850,"value":"# Données\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1045,"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":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1027,"value":"typesEx = [\n \"consommation\",\n \"fioul\",\n \"charbon\",\n \"gaz\",\n \"nucléaire\",\n \"eolien\",\n \"solaire\",\n \"hydraulique\",\n \"bioénergies\"\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":731,"value":"dataFiltered = dataParTypeEx.filter((d) =>\n categoriesFilteredSorted.includes(d[categoriesName])\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":665,"value":"getSelectedFile = {\n return getSelectedFileMonthYear();\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":663,"value":"dataEx = typeDataEx(getSelectedFile)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":711,"value":"dataParTypeEx = getDataPerTypeEx","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":713,"value":"getDataPerTypeEx = buildDatePerType(dataEx, false)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":742,"value":"dataParTypeFilteredByDate = dataParTypeEx.filter((d) => filterDate(d))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":988,"value":"dataParTypeFilteredByYear = buildDatePerType(\n typeDataEx(p_annee_moy).filter((d) => d.année === yearselect)\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":671,"value":"dataParTypeMoisEx = buildDatePerType(\n typeDataEx(getSelectedFileMonthYear()),\n false\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":738,"value":"categoriesRolledUp = d3.rollups(\n dataParTypeFilteredByYear,\n (v) => d3.mean(v, (d) => d[metricName]),\n (d) => d[categoriesName]\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":736,"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":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":929,"value":"years = d3.range(2012, 2021).map((d) => d.toString())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":943,"value":"consommationTotale = categoriesRolledUp.filter(\n (d) => d[0] === \"consommation\"\n)[0][1]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":981,"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":955,"value":"categoriesFilteredSortedPie2 = categoriesFilteredSortedPie.map((item) => {\n return { name: item[0], value: item[1] };\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":957,"value":"myPieData2 = WSJPieSorting(categoriesFilteredSortedPie2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":777,"value":"myBarDataReduce = categoriesRolledUp\n .filter((d) => categoriesToShow.indexOf(d[0]) > -1)\n .reduce((accumulator, element, index) => {\n return { ...accumulator, [element[0]]: element[1] };\n }, {})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":773,"value":"myBarData = Object.keys(myBarDataReduce).map((item) => {\n return { type: item, puissance: myBarDataReduce[item] };\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1058,"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":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":828,"value":"# Fonctions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1050,"value":"formatDate = d3.timeFormat(\"%Y-%m-%d\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1055,"value":"function capitalize(string) {\n return string[0].toUpperCase() + string.slice(1);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":721,"value":"function getColor(typeEnergie) {\n return color.range[color.domain.indexOf(typeEnergie)];\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":740,"value":"categoriesName = \"type\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":744,"value":"metricName = \"puissance\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":277,"value":"locale = await d3.json(\n \"https://cdn.jsdelivr.net/npm/d3-format@3/locale/fr-FR.json\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":270,"value":"d3.formatDefaultLocale(locale)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":661,"value":"function typeDataEx(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 + +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":686,"value":"dateExtent1 = d3.extent(dataEx.map((d) => d.date))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":684,"value":"slider1Dates = slider1.map((d) => d3.timeDay.offset(dateExtent1[0], d))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":680,"value":"function filterDate(d) {\n return (d.date >= slider1Dates[0]) & (d.date <= slider1Dates[1]);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":656,"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":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":951,"value":"//import { WSJPieSorting } from \"@alainro/rte2012-2020\";\n// WSL recommended sorting for pie chart\nfunction WSJPieSorting(array) {\n let WSJproportion = [array[0]]\n .concat(array.slice(2).reverse())\n .concat(array[1]);\n return WSJproportion;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":959,"value":"function filterPieColor() {\n let myPieColorPreFiltered = [];\n for (let i = 0; i < myPieData2.length; i++) {\n myPieColorPreFiltered.push(getColor(myPieData2[i].name));\n }\n return myPieColorPreFiltered;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":983,"value":"myPieColors = filterPieColor()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1042,"value":"function buildDatePerType(dataSource, addPompage) {\n const dataParType = [];\n dataSource.forEach((d) => {\n const dataArray = addPompage ? types : typesEx;\n dataArray.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":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":822,"value":"# Imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":609,"value":"import { colorOpacity } from \"@mootari/color-opacity\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1052,"value":"import { rangeSlider } from \"@mootari/range-slider\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":644,"value":"import { addTooltips } from \"@mkfreeman/plot-tooltip\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":953,"value":"import { PieChart } from \"@d3/pie-chart\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1029,"value":"### Chargement des fichiers données ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1035,"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":1033,"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":1037,"value":"p_mois_moy = FileAttachment(\"puissance_mois_moy.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1039,"value":"p_annee_moy = FileAttachment(\"puissance_annee_moy.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W2c","stdlib":"1","titling":"auto"}} 2b:"$2a:body"