2c:null 2d:["$","title",null,{"children":"Final exercise (pol)-A | UdG | Master's in Data Science | Observable"}] 32:T47b,**Links** - [Datos y visulaizaciones oficiales de emisión de gases para los estados participantes en la Climate Change Convention](https://unfccc.int/topics/mitigation/resources/registry-and-data/ghg-data-from-unfccc?gclid=CjwKCAiAnL-sBhBnEiwAJRGigiAKapCRCS3k7EC_XIZW2a50mVin4jdmtrRFlNkyzaNCC72w_ItwlBoCE38QAvD_BwE) - [Datos y muchos ejemplos de visualizaciones en tópicos parecidos](https://www.iea.org/data-and-statistics/) - [Bar chart resultados primer período](https://www.eea.europa.eu/data-and-maps/daviz/total-ghg-emissions-and-kyoto#tab-chart_3) - https://unfccc.int/news/kyoto-protocol-paves-the-way-for-greater-ambition-under-paris-agreement - https://www.europarl.europa.eu/RegData/etudes/BRIE/2021/696185/EPRS_BRI(2021)696185_EN.pdf (Single country analysis) - [Dataset oficial UNFCCC (Dataset 3)](https://www.eea.europa.eu/en/datahub/datahubitem-view/3b7fe76c-524a-439a-bfd2-a6e4046302a2) - [Visualitzador de les dades amb les que treballem](https://www.eea.europa.eu/data-and-maps/data/data-viewers/greenhouse-gases-viewer) - [Extreure datasets de les dades amb les que treballem (Dataset 2)](https://di.unfccc.int/time_series)33:T8cf,- **Visualization 1**: Visualize the fact that the Kyoto Protocol recognized: 'developed countries are principally responsible for the high levels of GHG emissions in the atmosphere as a result of more than 150 years of industrial activity' (use this to compare the % of emissions on developed countries vs non developed countries, and visualize the past years on the countries that we are going to analyze ) - **Visualization 2 (2-3 plots)**: How have the emissions on Europe countries evolved after the appliance of the Kyoto Protocol? - First and second plot: The First plot will be a 'Interactive Heatmap'. Each row will be a Country, each column a year. The cell will have a red tone if the year has been worse than the year before. It will have a green tone on the contrary. Each cell will be clickable and will change the view on the second plot. - Second plot: Density line chart that changes when interacting. It will ahve two inputs: Year and Country. - Third plot (optional) : - Diverging 'bar plot' with circles instead of bars. Each circle will start at the middle point (0 on Y) and start fluctuating depending on if the emissions have lowered or not. The objective on emissions will also be represnted according to the document on 15 december 2010. The size of the circle will encode the percentage on emissions of each country during the time. - (Another option) : Encontramos en el pasado una reducción en las emisiones a nivel Europeo/Global del mismo nivel que el conseguido mediante el tratado de Kyoto? - **Volem poder tenir conclusions com:** 'Romania generates 3 % of the EU-27's total greenhouse gas (GHG) emissions and reduced emissions faster than the EU average between 2005 and 2019. With several energy-intensive industries present in Romania, the country's carbon intensity is much higher than the EU average, but decreasing rapidly.' - **Visualization 3**: Multiple detail visualizations to treat (some of) these questions: - Economic recession - Milder winters - Switch from coal to gas - Increase on use of renewable energies - Increase on number of sustainability policies - - **Visualization 4** : Interactive plot with multi-select to have freedom to search through the data. 34:T511,function calcularPromedioGHG1(data) { const promedioPorPais = {}; data.forEach(entry => { if (!promedioPorPais[entry.Country]) { promedioPorPais[entry.Country] = { total_08_12: 0, count_08_12: 0, total_13_20: 0, count_13_20: 0, ghg1990: 0, }; } if (entry.year === 1990) { promedioPorPais[entry.Country].ghg1990 = entry.ghg; } else if (entry.year >= 2008 && entry.year <= 2012) { promedioPorPais[entry.Country].total_08_12 += entry.ghg; promedioPorPais[entry.Country].count_08_12 += 1; } else if (entry.year >= 2013 && entry.year <= 2020) { promedioPorPais[entry.Country].total_13_20 += entry.ghg; promedioPorPais[entry.Country].count_13_20 += 1; } }); const resultados = Object.keys(promedioPorPais).map(pais => { const { total_08_12, count_08_12, total_13_20, count_13_20, ghg1990 } = promedioPorPais[pais]; const ghgPromedio_08_12 = count_08_12 > 0 ? total_08_12 / count_08_12 : 0; const ghgPromedio_13_20 = count_13_20 > 0 ? total_13_20 / count_13_20 : 0; return { Country: pais, ghg1990: ghg1990, ghgPromedio_08_12: ghgPromedio_08_12.toFixed(2), ghgPromedio_13_20: ghgPromedio_13_20.toFixed(2), }; }); return resultados; } 35:T471,Plot.plot({ height: 780, width: 1000, marginLeft: 100, grid: true, x: { axis: "top", round: true, label: "Avg GHG dec (%) 2008-2012", labelAnchor: "center", type: "linear", }, y: { label: null, }, marks: [ Plot.barX(Informacion_plot, { y: "Country", x: "percentage", sort: { y: "-x" }, fill: d => { if (d.percentage >= 0) { return (d.percentage) >= (d['Burden_Sharing(%)']) ? "#e15759" : "#4e79a7"; } else { return Math.abs(d.percentage) < Math.abs(d['Burden_Sharing(%)']) ? "#e15759" : "#4e79a7"; } }, channels: {'GHG 1990': "ghg_1990", 'GHG Avg (2008-2012)': "ghgAverage_2008_2012", 'Burden Sharing (%)': 'Burden_Sharing(%)'}, tip: { format: { y: true, 'Burden Sharing (%)': true, x: true, 'GHG 1990': true, 'GHG Avg (2008-2012)': true, fill: false, }, } }), Plot.dot(Informacion_plot, { y: "Country", x: "Burden_Sharing(%)", fill: "currentColor", color: "black", size: 6, }), Plot.ruleX([0]), ], });36:T47a,Plot.plot({ height: 780, width: 1000, marginLeft: 100, grid: true, x: { axis: "top", round: true, label: "Avg GHG dec (%) 2013 - 2020", labelAnchor: "center", type: "linear", }, y: { label: null, }, marks: [ Plot.barX(Informacion_plot1, { y: "Country", x: "percentage_13_20", sort: { y: "-x" }, fill: d => { if (d['percentage_13_20'] >= 0) { return (d['percentage_13_20']) >= (d['Goal_2020(%)']) ? "#e15759" : "#4e79a7"; } else { return Math.abs(d['percentage_13_20']) < Math.abs(d['Goal_2020(%)']) ? "#e15759" : "#4e79a7"; } }, channels: {'GHG 1990': "ghg_1990", 'GHG Avg (2013-2020)': "ghgAverage_2013_2020", 'Goal 2020 (%)': 'Goal_2020(%)'}, tip: { format: { y: true, 'Goal 2020 (%)': true, x: true, 'GHG 1990': true, 'GHG Avg (2013 - 2020)': true, fill: false, }, } }), Plot.dot(Informacion_plot1, { y: "Country", x: "Goal_2020(%)", fill: "currentColor", color: "black", size: 6, }), Plot.ruleX([0]), ], });37:T523,Plot.plot({ height: 780, width: 1000, marginLeft: 100, grid: true, title: `Performance of EU countries against the GHG reduction of the Kyoto Protocol (Period ${option})`, subtitle: "In blue, the countries that achieved the reduction goal; in red, that did not meet it.", x: { axis: "top", round: true, label: `Avg GHG dec (%) ${option}`, labelAnchor: "center", type: "linear", }, y: { label: null, }, marks: [ Plot.barX(Informacion_plot1, { y: "Country", x: x_b, sort: { y: "-x" }, fill: d => { if (d.Country === "European Union (27)") {return "#a2a2a2"} else if (d[x_b] >= 0) { return (d[x_b]) >= (d[x_d]) ? "#e15759" : "#4e79a7"; } else { return Math.abs(d[x_b]) < Math.abs(d[x_d]) ? "#e15759" : "#4e79a7"; } }, channels: {'GHG 1990': "ghg_1990", 'GHG Avg over time period': Selec, 'Goal (%)': x_d}, tip: { format: { y: true, 'Goal (%)': true, x: true, 'GHG 1990': true, 'GHG Avg over time period': true, fill: false, }, } }), Plot.dot(Informacion_plot1, { y: "Country", x: x_d, fill: "currentColor", color: "black", size: 6, }), Plot.ruleX([0]), ], });38:T550,// Afegir ordre aquí si es vol ordenar el Heatmap enhancedSortedEmissionsByCountry = { const dataCountries = new Map(); var countryIdx = 0; sortedEmissionsByCountry.forEach((countryData, key, map) => { const dataYears = []; const baseYearGhg = map.get(key)[0].total_ghg; countryData.forEach((yearData, index) => { const ghgPercentageDecrease = index == 0 ? 0 : Math.round( (percentageDecrease( map.get(key)[index - 1].total_ghg, yearData.total_ghg ) + Number.EPSILON) * 100 ) / 100; dataYears.push({ index, country_idx: countryIdx, //isoCodes.indexOf(yearData.iso_code) iso_code: yearData.iso_code, year: yearData.year, total_ghg: yearData.total_ghg, // Emissions de ghg totals difference_from_base: Math.round(((percentageDecrease(baseYearGhg, yearData.total_ghg)) + Number.EPSILON) * 100) / 100, // Diferència amb l'any 1990 yearly_change: ghgPercentageDecrease, // Diferència amb l'any anterior ghg_increased: ghgPercentageDecrease >= 0 ? false : true, ghg_per_cap: parseFloat(yearData.ghg_per_capita) }); }); dataYears.push() dataCountries.set(key, dataYears); countryIdx += 1; }); return dataCountries; }39:T69e,**Canvi de plan: els colors codificaran si el total de ghg d'aquell all per aquell país està per sobre o per sota el valor de 1990** - **Podem seguir utilitzant la diferència entre anys per codificar altres scales, com la mida** - **3 modes: Emissions totals de ghg / Diferència amb l'any 1990 / Millora d'un any per l'altre** - **Reconsiderar si és correcte utilitzar una normalització pels valors positius i negatius per mantenir l'any del 1990 com a punt 0** - Falta: - REVISAR ELS VALORS DE RUMANIA (Dataset 1) / LATVIA (Dataset 2) - Arreglar els colors perquè tingui sentit les dades de **diferència amb 1990 (amb el primer dataset funciona)** - Afegir la opció de normalitzar / no normalitzar les dades **X** (Ara mateix està mantinguent el valor 0) **SAUVITZAR ELS VALORS DEL COSTAT QUE N'HI HAGIN MENYS** - Provar altres escales de color (threshold, multiples escales) - Highlight valors interessants - Afegir tooltip - Afegir llegenda - Afegir separadors per quan les dades estiguin normalitzades (que s'entengui que les dades van per cada país) - Fer la línia menys marcada (no volem mostrar tant contrast) - Fer-lo interactiu - **Ordenar**: Fer l'ordenació interactiva (per emissions totals, per baixada més ràpida..., per categoria de país (economia en procés de canvi o no)) **També es podrien fer varis heatmaps per anar comentant les dades a poc a poc** - Per cada **mode** - Explicació - Llegenda - Text al tooltip/hover Opcional: - Afegir banderes **Pel mode 'Difference from 1990', les dades normalitzades, al passar-hi per sobre haurien de dir el % de creixement o decreixement** (Utilitzar aquesta dada directament)3a:Tbf7,viewof plot = { // Declare the chart dimensions and margins. const marginTop = 20; const marginRight = 1; const marginBottom = 40; const marginLeft = 40; const rowHeight = 20; const width = 1200; const height = rowHeight * plotData2.names.length + marginTop + marginBottom; const color = (d) => { return heatmapColorScale(d, heatmapMode); } const format = (d) =>{ return accessHeatMapValue(d); } // Create the SVG container. const svg = d3.create("svg") .attr("viewBox", [0, 0, width, height]) .attr("viewBox", [0, 0, width, height]) .attr("width", width) .attr("height", height) .attr("style", "max-width: 100%; height: auto;"); // Create the scales. const x = d3.scaleLinear() .domain([d3.min(plotData2.years), d3.max(plotData2.years) + 1]) .rangeRound([marginLeft, width - marginRight]) const y = d3.scaleBand() .domain(plotData2.names) .rangeRound([marginTop, height - marginBottom]) svg.append("g") .attr("transform", `translate(${marginLeft - 10},0)`) .call(d3.axisLeft(y).tickSize(0)) .call(g => g.select(".domain").remove()); // Create a cell for each (state, year) value. const f = d3.format(",d"); const index = d3.local(); svg.append("g") .selectAll("g") .data(plotData2.values) .join("g") .attr("transform", (d, i) => `translate(0,${y(plotData2.names[i])})`) // .each(function(d, i) { // index.set(this, i); // console.log(index.get(this));// Store index in local variable. // }) .selectAll("rect") .data(d => d) // Buscar manera de conservar l'index del país a baix .join("rect") .attr("x", (d, i) => x(plotData2.years[i]) + 1) //.attr("cx", (d, i) => x(plotData2.years[i])) // .attr("cy", y.bandwidth() - 8) .attr("height", y.bandwidth() - 1) // .attr("r", 6) .attr("width", (d, i) => x(plotData2.years[i] + 1) - x(plotData2.years[i]) - 1) .attr("fill", d => index == 0 ? "black" : d === 0 ? "#339cff" : color(d)) // .on("mouseover", function(event,d){ // console.log(index.get(this)); // }) .append("title") .text((d, i) => `${format(d)} in ${plotData2.years[i]}`); // Append the axes. svg.append("g") .call(g => g.append("g") .attr("transform", `translate(0,${marginTop})`) .call(d3.axisTop(x).ticks(null, "d")) .call(g => g.select(".domain").remove())) .call(g => g.append("g") .attr("transform", `translate(0,${height - marginBottom + 4})`) .call(d3.axisBottom(x) .tickValues([plotData2.year]) .tickFormat(x => x) .tickSize(marginTop + marginBottom - height - 10)) .call(g => g.select(".tick text") .clone() .attr("dy", "2em") .style("font-weight", "bold") .text("First commitment period started")) .call(g => g.select(".domain").remove())); return Object.assign(svg.node(), {scales: {color}}); //return svg.node(); }3b:T68c,- **Tipo overview + detalles** - Visualización general de la evolución de cada país a partir del 1990. Tendria que ser interactivo para poder ver detalles concretos de la visualización (slider de tiempo?) **(plot 1)**. Acompañado de un plot que vaya acumulando los puntos conforme pasan los años **(plot 2)**. (Lo mismo que el pot 3 del tipo historia - Alternativa: Grid de plots que muestran la evolución de cada país + un área que muestre la rapidez con que llegaron a las emisiones acordadas. - Alternativa: tenim un cercle (buit) per a cada país. A mesura que passa el temps, emplenem els cercles en el moment en que un país arribi a les emissions acordades. Al final tenim uns quants cercles buits (o no). Si n’hi han, podem investigar aquests casos. Al clicar cada cercle, podem veure el gràfic d’emissions per aquest (mirar esquema abajo) - Alternativa: Mapa donde salgan los países que firmaron. El color codifica las emisiones totales. Un plot muestra los datos durante el primer período. Otro plot muestra los del segundo período. - **Alternativa**: Grid de puntos/cells. Las filas son los países y las columnas los años. El punto se pondrà de color rojo si el país aún no ha llegado a los valores acordados ese año (se pone un rojo más suave a medida que se acerque). El punto se pone verde cuando el país ha llegado al valor acordado. Éste podria ser una especie de 'heatmap' para poner en detalle qué países llegan a los valores acordados durante cada período (serian 2 heatmaps) y lo rápido que lo hacen). Al pulsar uno de los puntos/cells, un plot inferior muestra los datos de ese país por ese año. 3c:[{"id":"0b9c827b561ee172a7480d0e2eeba777a0fbf5ba4991d50887e5d16f18a9200b8bf9b5599a7b7768c586edfeda0bd6e88cc05690b97d62444fcaedfc27849f0c","href":"https://static.observableusercontent.com/files/0b9c827b561ee172a7480d0e2eeba777a0fbf5ba4991d50887e5d16f18a9200b8bf9b5599a7b7768c586edfeda0bd6e88cc05690b97d62444fcaedfc27849f0c","name":"countries@2.csv","type":"text/csv","lastModified":1705620570083.88,"size":6367},{"id":"3e360c5611eebfc109a786426787464fe3b1b3d8eef9fcb8202359f8e38c28a936593748946b04e9738d78d23ef3f3995f4ef4924a6ed8d7561b59d53a9272d3","href":"https://static.observableusercontent.com/files/3e360c5611eebfc109a786426787464fe3b1b3d8eef9fcb8202359f8e38c28a936593748946b04e9738d78d23ef3f3995f4ef4924a6ed8d7561b59d53a9272d3","name":"countries@3.csv","type":"text/csv","lastModified":1705621205122.8,"size":6102},{"id":"2c2591f88b37fd7019a88b3824ed9d66e5314350dcc407eae0270a46a1e90175e793549c7ab700aae5c09856639197ff01e7b919591c0d50b09238b78f81f065","href":"https://static.observableusercontent.com/files/2c2591f88b37fd7019a88b3824ed9d66e5314350dcc407eae0270a46a1e90175e793549c7ab700aae5c09856639197ff01e7b919591c0d50b09238b78f81f065","name":"UNFCCC_emissions.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1705085118099.922,"size":39634},{"id":"10104ac18f1129a1bc055f69b6206b0150eb62e7d67ad3d6e2a911340c3d8901f30519d59b8d58b0c167ccd307703bf5aad265ff82dc4ba3df030f42dea9a1fc","href":"https://static.observableusercontent.com/files/10104ac18f1129a1bc055f69b6206b0150eb62e7d67ad3d6e2a911340c3d8901f30519d59b8d58b0c167ccd307703bf5aad265ff82dc4ba3df030f42dea9a1fc","name":"Time Series - GHG total with LULUCF, in kt CO₂ equivalent@4.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1705085118099.922,"size":31581},{"id":"ba4a96dc7973db3c27d8b5a3ad2fbd389ae7c95fac682e53d08faa6c6459b37c7775aebd6aa0c7ffd2bc52aaa696250b5325112fe3162b301e029b0ca02fc237","href":"https://static.observableusercontent.com/files/ba4a96dc7973db3c27d8b5a3ad2fbd389ae7c95fac682e53d08faa6c6459b37c7775aebd6aa0c7ffd2bc52aaa696250b5325112fe3162b301e029b0ca02fc237","name":"image.png","type":"image/png","lastModified":1705085118099.922,"size":37807},{"id":"2d8da64dbc72f78c701bcd41ed20cb0a6ac3ce8a0ff1a3d59fe05a94a836a7d42d30b024e504d4383d0501da0797ea346452cb56f18a5fec44cdc48d74a2fce1","href":"https://static.observableusercontent.com/files/2d8da64dbc72f78c701bcd41ed20cb0a6ac3ce8a0ff1a3d59fe05a94a836a7d42d30b024e504d4383d0501da0797ea346452cb56f18a5fec44cdc48d74a2fce1","name":"g2324.png","type":"image/png","lastModified":1705085118099.922,"size":257971},{"id":"c84a90db19c1a63739b4b92badbdfcd49fffaa0b3d3c64a203efcd15ee703310565793e20a3c06675fa67224b288fcffc7295265c685cd56df5cec65e6dc4cf4","href":"https://static.observableusercontent.com/files/c84a90db19c1a63739b4b92badbdfcd49fffaa0b3d3c64a203efcd15ee703310565793e20a3c06675fa67224b288fcffc7295265c685cd56df5cec65e6dc4cf4","name":"Captura2.PNG","type":"image/png","lastModified":1705085118099.922,"size":134588},{"id":"8818a9c7b214afbfd9685f88a8115e463e1239fbfc8b740b02bf138eccbf709334482f726ddbeb5be891f6e6c711e119c6b3a9d89259f483b5ce9c3dcfe4afbe","href":"https://static.observableusercontent.com/files/8818a9c7b214afbfd9685f88a8115e463e1239fbfc8b740b02bf138eccbf709334482f726ddbeb5be891f6e6c711e119c6b3a9d89259f483b5ce9c3dcfe4afbe","name":"Captura3.PNG","type":"image/png","lastModified":1705085118099.922,"size":151521},{"id":"1a580b20888187ce218d3256dfc376ee1d73a671989491af4de005abdbbcaa8364d0d5d61427dbfcacb1052f7b1df95bd74671249f258e03a8d1857bc7fbcddb","href":"https://static.observableusercontent.com/files/1a580b20888187ce218d3256dfc376ee1d73a671989491af4de005abdbbcaa8364d0d5d61427dbfcacb1052f7b1df95bd74671249f258e03a8d1857bc7fbcddb","name":"owid-co2-data.csv","type":"text/csv","lastModified":1705085118099.922,"size":13516864},{"id":"ae1a0a6c525885bf9993c6d23c021139497804fa6e3d2006f9eed784dd2ab44c501098e6898538834545bd2b511559b1861ac37eaf6825cafe1076e48e280c7d","href":"https://static.observableusercontent.com/files/ae1a0a6c525885bf9993c6d23c021139497804fa6e3d2006f9eed784dd2ab44c501098e6898538834545bd2b511559b1861ac37eaf6825cafe1076e48e280c7d","name":"countries.csv","type":"text/csv","lastModified":1705244203335.711,"size":6084}] 30:{"id":"90c12ba95d8184f6","slug":null,"title":"Final exercise (pol)-A","thumbnail":"2f7986acbd8e77b886538583cd9bbbbb79c7c5961135629001fcc8297b04b964","access_level":"public","create_time":"$D2024-01-12T18:45:18.099Z","update_time":"$D2024-01-19T10:15:50.766Z","view_time":null,"first_public_time":"$D2024-01-12T18:45:18.099Z","has_unpublished_edits":null,"fork":{"id":"dcf65b8d7aaf5a16","slug":null,"title":"Final exercise (pol)","owner":{"id":"f6d094e91910d678","login":"udg-master-data-science","name":"UdG | Master's in Data Science"}},"stars":0,"starred":false,"owner":{"type":"team","id":"f6d094e91910d678","login":"udg-master-data-science","name":"UdG | Master's in Data Science","avatar_url":"https://avatars-next.observableusercontent.com/43ba1b8a69dd1722287c44e61dfee202393e63b350f5814991b6b0af9418435e","tier":"starter_2024"},"version":2378,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"74fdac553df41c0e","login":"armando-nicolas-acuna-zambrano","name":"Armando Nicolas Acuña Zambrano","avatar_url":"https://avatars-next.observableusercontent.com/09b04c80681c3b78916578c72f7bc0e69cc4692e1f1e858e5dc4052a24744273","tier":null}],"members":[{"type":"team","id":"f6d094e91910d678","login":"udg-master-data-science","name":"UdG | Master's in Data Science","avatar_url":"https://avatars-next.observableusercontent.com/43ba1b8a69dd1722287c44e61dfee202393e63b350f5814991b6b0af9418435e","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Final exercise (pol)-A","cells":[{"id":0,"value":"# Final exercise (pol)-A","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":100,"value":"Clara, Armando, Pol","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":11,"value":"[Data codebook](https://github.com/owid/co2-data/blob/master/owid-co2-codebook.csv)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":400,"value":"**POSIBLES PREGUNTAS**\n\n- Han cumplido los países con los objetivos propuestos durante los dos períodos de commitment?\n- Encontramos en el pasado una reducción en las emisiones a nivel Europeo/Global del mismo nivel que el conseguido mediante el tratado de Kyoto?\n- Qué porcentage de emisiones nivel global representan los países que participaron en el tratado? (Son considerable a nivel global las mejoras en emision conseguidas?)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":405,"value":"$32","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":976,"value":"#### Facts\n- The EU and its Member States have met their international climate commitment under the UNFCCC to reduce GHG emissions by 20% compared to 1990 levels by 2020.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":419,"value":"## Intro\nThe Kyoto Protocol recognized that** developed countries are principally responsible for the high levels of GHG emissions in the atmosphere as a result of more than 150 years of industrial activity**\nMy analitical goal...","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":421,"value":"---\n## Summary","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":450,"value":"$33","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":152,"value":"## VISUALIZATIONS","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1673,"value":"data = emissions","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1676,"value":"data","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":53,"value":"viewof country = Inputs.select(sortedEmissionsByCountry, {label: \"Country:\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"Plot.plot({\n subtitle: \"Plot auxiliar\",\n width,\n y: {\n grid: true\n },\n marks: [\n Plot.barY(country.filter(d => d.year > 1970), {y: (d) => d.total_ghg == '' ? NaN : Number(d.total_ghg), x: \"year\", tip: true}),\n ]\n})\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1774,"value":"entriesArray = Array.from(sortedEmissionsByCountry.entries())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1779,"value":"f1 = entriesArray\n .flatMap(([key, values]) => values.filter(entry => entry.year === Years))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1782,"value":"transformedData = f1.map(entry => {\n return {\n Country: entry.country, \n ghg: entry.total_ghg \n };\n });","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1787,"value":"function transformData(sortedEmissionsByCountry) {\n\n const entriesArray = Array.from(sortedEmissionsByCountry.entries());\n const filteredData = entriesArray.flatMap(([key, values]) => values.filter(entry => entry.year === Years));\n\n const transformedData = filteredData.map(entry => {\n return {\n Country: entry.country,\n ghg: entry.total_ghg\n };\n });\n return transformedData;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1790,"value":"toyData = transformData(sortedEmissionsByCountry);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1819,"value":"viewof Years = slider({\n min: 1990, \n max: 2020, \n step: 1, \n value: 1990, \n title: \"Year\", \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1813,"value":"chart1 = embed({\n \"$schema\": \"https://vega.github.io/schema/vega/v4.json\",\n \"width\": 1500,\n \"height\": 100,\n \"data\": [\n {\n \"name\": \"places\",\n \"values\": toyData\n }\n ],\n \"scales\": [\n {\n \"name\": \"xscale\",\n \"type\": \"point\",\n \"domain\": {\"data\": \"places\", \"field\": \"Country\"},\n \"range\": \"width\"\n },\n {\n \"name\": \"sizescale\",\n \"type\": \"linear\",\n \"domain\": {\"data\": \"places\", \"field\": \"ghg\"},\n \"range\": [0, 3000]\n }\n ],\n\n \"axes\": [\n { \"orient\": \"bottom\", \"scale\": \"xscale\" }\n ],\n\n \"marks\": [\n {\n \"type\": \"symbol\",\n \"from\": {\"data\": \"places\"},\n \"encode\": {\n \"enter\": {\n \"fill\": {\"value\": \"seagreen\"},\n \"size\": {\"scale\": \"sizescale\", \"field\": \"ghg\"},\n \"x\": {\"scale\": \"xscale\", \"field\": \"Country\"},\n \"y\": {\"value\": 50}\n },\n \"update\": {\n \"tooltip\": {\n \"signal\": \"{Country: datum.Country, GHG: datum.ghg}\"\n }\n }\n }\n }\n ]\n})\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1769,"value":"embed = require('vega-embed@3')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1887,"value":"anos= entriesArray.flatMap(([key, values]) => values.filter(entry => entry.year === 1990 || (entry.year >= 2008 && entry.year <= 2012)))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2162,"value":"anos1= entriesArray.flatMap(([key, values]) => values.filter(entry => entry.year === 1990 || (entry.year >= 2008 && entry.year <= 2020)))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1882,"value":"transformedData_all = anos.map(entry => {\n return {\n Country: entry.country,\n year: entry.year,\n ghg: entry.total_ghg,\n }\n })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2164,"value":"transformedData_all1 = anos1.map(entry => {\n return {\n Country: entry.country,\n year: entry.year,\n ghg: entry.total_ghg,\n }\n })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1901,"value":"function calcularPromedioGHG(data) {\n const promedioPorPais = {};\n\n data.forEach(entry => {\n if (!promedioPorPais[entry.Country]) {\n promedioPorPais[entry.Country] = {\n total: 0,\n count: 0,\n };\n }\n if (entry.year >= 2008 && entry.year <= 2012) {\n promedioPorPais[entry.Country].total += entry.ghg;\n promedioPorPais[entry.Country].count += 1;\n }\n });\n const resultados = Object.keys(promedioPorPais).map(pais => {\n const { total, count } = promedioPorPais[pais];\n const ghgPromedio = count > 0 ? total / count : 0;\n return {\n Country: pais,\n ghg1990: data.find(entry => entry.Country === pais && entry.year === 1990)?.ghg || 0,\n ghgPromedio: ghgPromedio.toFixed(2),\n };\n });\n return resultados;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2169,"value":"$34","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1903,"value":"Country_90_promedio = calcularPromedioGHG(transformedData_all)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2171,"value":"Country_90_promedio1 = calcularPromedioGHG1(transformedData_all1)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1951,"value":"Informacion_plot= Country_90_promedio.map(entry => {\n const { Country, ghg1990, ghgPromedio } = entry;\n const porcentajeReduccion = ghg1990 !== 0\n ? ((ghgPromedio - ghg1990) / ghg1990) * 100\n : 0;\n const matchingEntry = filteredResults_A.find(filteredEntry => filteredEntry.country === Country);\n\n const burdenSharingPercentage = matchingEntry ? matchingEntry['Burden_Sharing(%)'] : null;\n\n return {\n Country: Country,\n ghg_1990: ghg1990,\n ghgAverage_2008_2012: ghgPromedio,\n percentage: porcentajeReduccion.toFixed(2),\n 'Burden_Sharing(%)': burdenSharingPercentage,\n };\n});","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2328,"value":"Plot.plot({\n height: 1000,\n width: 500,\n marginLeft: 100,\n grid: true,\n y: {\n label: null,\n },\n marks: [\n Plot.dot(Informacion_plot1,{\n y: \"Country\",\n r: d => d.ghg_1990,\n fill: \"currentColor\",\n color: \"black\",\n }\n)\n ] \n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2175,"value":"Informacion_plot1= Country_90_promedio1.map(entry => {\n const { Country, ghg1990, ghgPromedio_08_12, ghgPromedio_13_20 } = entry;\n const porcentajeReduccion_08_12 = ghg1990 !== 0\n ? ((ghgPromedio_08_12 - ghg1990) / ghg1990) * 100\n : 0;\n const porcentajeReduccion_13_20 = ghg1990 !== 0\n ? ((ghgPromedio_13_20 - ghg1990) / ghg1990) * 100\n : 0;\n const matchingEntry = filteredResults_A.find(filteredEntry => filteredEntry.country === Country);\n\n const burdenSharingPercentage = matchingEntry ? matchingEntry['Burden_Sharing(%)'] : null;\n const burdenSharingPercentage_1 = matchingEntry ? matchingEntry['Goal_2020(%)'] : null;\n\n return {\n Country: Country,\n ghg_1990: ghg1990,\n ghgAverage_2008_2012: ghgPromedio_08_12,\n percentage_08_12: porcentajeReduccion_08_12.toFixed(2),\n ghgAverage_2013_2020: ghgPromedio_13_20,\n percentage_13_20: porcentajeReduccion_13_20.toFixed(2),\n 'Burden_Sharing(%)': burdenSharingPercentage,\n 'Goal_2020(%)': burdenSharingPercentage_1,\n };\n});","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1962,"value":"Plot.plot({\n height: 500,\n width: 1500,\n y: {\n grid: true,\n type: \"linear\",\n },\n marks: [\n Plot.barY(Informacion_plot, {\n x: \"Country\",\n y: \"percentage\",\n sort: { x: \"-y\" },\n fill: \"#4CAF50\",\n }),\n Plot.ruleY([0]),\n Plot.dot(Informacion_plot, {\n x: \"Country\",\n y: \"Burden_Sharing(%)\",\n fill: \"currentColor\",\n color: \"black\",\n size: 6,\n }),\n ],\n});","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2036,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2180,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2191,"value":"viewof option = Inputs.radio([\"2008 - 2012\",\"2013 - 2020\"], {label: \"Select time\", value: \"2008 - 2012\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2193,"value":"$37","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2195,"value":"x_b = option === \"2008 - 2012\" ? \"percentage_08_12\" : (option === \"2013 - 2020\" ? \"percentage_13_20\" : null)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2206,"value":"x_d = option === \"2008 - 2012\" ? \"Burden_Sharing(%)\" : (option === \"2013 - 2020\" ? \"Goal_2020(%)\" : null)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2242,"value":"Selec = option === \"2008 - 2012\" ? \"ghgAverage_2008_2012\" : (option === \"2013 - 2020\" ? \"ghgAverage_2013_2020\" : null)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":149,"value":"## DATA TRANSFORMATIONS","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":501,"value":"### Data cleaning","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":599,"value":"//viewof summary_raw_data = SummaryTable(emissions_raw, {label: \"Emissions Data\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":547,"value":"ue_countries = countries_csv.filter(d => d.UE === \"Yes\").map(d => {return d.country})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1144,"value":"emissionsDataset = {\n switch(emissionsHeatmapDatasetString) {\n case(\"emissions_raw\"): return emissions_raw;\n case(\"ghg_emissions_formatted\"): return ghg_emissions_formatted;\n case(\"unfccc_emissions_formatted\"): return unfccc_emissions_formatted;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":506,"value":"emissions = emissionsDataset\n .map((d) => {\n d.year = parseInt(d.year);\n d.total_ghg = parseFloat(d.total_ghg);\n return d;\n })\n .filter(\n (d) =>\n d.year >= 1990 &&\n ue_countries.indexOf(d.country) !== -1 &&\n !isNaN(d.total_ghg) && d.country != \"Romania\"\n ).sort(function(a, b) {\n if(a.sumGhg > b.sumGhg) return -1;\n else return 1;\n });","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1181,"value":"sortedCountryCodes = d3\n .flatRollup(\n emissions,\n (v) => d3.sum(v, (d) => d.total_ghg),\n (d) => d.iso_code)\n// .reduce(function(r, e) {\n// r[e[0]] = e[1];\n// return r;\n// }, {});\n .map(([iso_code, sumGhg]) => ({\n iso_code,\n sumGhg,\n })).sort(function(a, b) {\n if(a.sumGhg > b.sumGhg) return -1;\n else return 1;\n }).reduce(function(r, e, id) {\n r[e.iso_code] = id;\n return r;\n}, {});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":694,"value":"isoCodes = {\n const codes = Object.keys(sortedCountryCodes)\n return codes;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1247,"value":"sortedEmissions = {\n return emissions.sort(function(a, b) {\n if(sortedCountryCodes[a.iso_code] < sortedCountryCodes[b.iso_code]) {\n return -1;\n }\n else if(sortedCountryCodes[a.iso_code] == sortedCountryCodes[b.iso_code]) {\n return a.year - b.year\n }\n else return 1;\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":466,"value":"#### ----","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":49,"value":"sortedEmissionsByCountry = d3.group(sortedEmissions, d => d.country)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":571,"value":"function percentageDecrease(initial, final) {\n return ((initial - final) / initial) * 100\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":470,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1416,"value":"d3.max(heatMapValuesStruct[1], (d) => d.ghg);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1504,"value":"d3.min(heatMapValuesStruct, (d, i) => d3.min(heatMapValuesStruct[i], (d) => d.ghg));","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1545,"value":"d3.max(heatMapValuesStruct[0], (d) => d[heatmapChosenData])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1389,"value":"heatMapValuesStruct = {\n const struct = [];\n enhancedSortedEmissionsByCountry.forEach((countryData, key, map) => {\n // year, i, improvementValue, diffValue, ghg\n const countryArray = [];\n countryData.forEach((yearData, index) => {\n countryArray.push({\n year: yearData.year,\n yearly_change: yearData.yearly_change,\n diff_from_base: yearData.difference_from_base,\n ghg: yearData.total_ghg,\n ghg_per_cap: yearData.ghg_per_cap\n })\n })\n struct.push(countryArray);\n });\n\n return struct;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1430,"value":"function accessHeatMapValue(index) {\n debugger\n const countryIdx = parseInt(index.slice(0, 2));\n const yearIdx = parseInt(index.slice(-2));\n\n return heatMapValuesStruct[countryIdx][yearIdx][heatmapChosenData];\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1419,"value":"indexingStruct = {\n const struct = [];\n for (let i = 0; i < heatMapValuesStruct.length; ++i) {\n const countryArray = [];\n for (let j = 0; j < heatMapValuesStruct[0].length; ++j) {\n countryArray.push(('0' + i).slice(-2) + ('0' + j).slice(-2));\n }\n struct.push(countryArray);\n }\n return struct;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1434,"value":"accessHeatMapValue(\"0501\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1624,"value":"## Visualization: Line chart for the evolution of co2 emissions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":609,"value":"### Visualization 1: Interactive heatmap","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":867,"value":"function normalizeArray(array) {\n //normalized = np.where(r>0,r/r.max(),np.where(r<0,-r/r.min(),r))\n let min = d3.min(array);\n let max = d3.max(array);\n\n if (heatmapMode === \"Total emissions\") {\n return array.map(d => (d - min) / (max - min));\n }\n else {\n return array.map(d => d > 0 ? d / max : d < 0 ? -d / min : d)\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":960,"value":"#### Ordre aquí","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":619,"value":"heatMapValues= {\n const values = [];\n enhancedSortedEmissionsByCountry.forEach((countryData, key, map) => {\n countryData.forEach((yearData, index) => {\n values.push({\n year: yearData.year,\n idx: yearData.country_idx,\n yearly_change_value: yearData.yearly_change,\n diff_value: yearData.difference_from_base,\n ghg_value: yearData.total_ghg,\n });\n });\n });\n return values\n .sort(function (a, b) {\n if (a.year > b.year) return 1;\n else if (a.year == b.year) {\n if (a.idx > b.index) return 1;\n } else return -1;\n })\n .map(Object.values);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":702,"value":"heatmapData = [\n {\n id: \"percentageImprovement\",\n title: \"Percentage Improvement\",\n note: \"Note\",\n data: {\n chart_options: {\n key_year: 2005\n },\n values: {\n heatMapValues\n }\n }\n }\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1153,"value":"[year, countryIdx, yearlyChange, diffFromBase, totalGhg]","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1449,"value":"plotData2 = {\n const names = isoCodes;\n const values = indexingStruct;\n const year0 = d3.min(heatMapValuesStruct[0], (d) => d.year);\n const year1 = d3.max(heatMapValuesStruct[0], (d) => d.year);\n const years = d3.range(year0, year1 + 1);\n return {\n values,\n names,\n years,\n year: 2008,\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":732,"value":"$39","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1366,"value":"heatmapChosenData = {\n switch(heatmapMode) {\n case \"Total emissions\":\n return \"ghg\";\n case \"Change from 1990\": // En %\n return \"diff_from_base\";\n case \"Ghg per capita\":\n return \"ghg_per_cap\";\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1497,"value":"[{year: 1990, yearly_change: 0, diff_from_base: 0, ghg: 1096.99, ghg_per_cap: \"13.821\"}]","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1493,"value":"function getMinMaxValues(countryIdx) {\n var minVal = 0;\n var maxVal = 0;\n \n if (countryIdx === undefined) { // A nivell global\n maxVal = d3.max(heatMapValuesStruct, (d, i) => d3.max(heatMapValuesStruct[i], (d) => d[heatmapChosenData]));\n minVal = d3.min(heatMapValuesStruct, (d, i) => d3.min(heatMapValuesStruct[i], (d) => d[heatmapChosenData]));\n }\n else { // A nivell de país\n maxVal = d3.max(heatMapValuesStruct[countryIdx], (d) => d[heatmapChosenData]);\n minVal = d3.min(heatMapValuesStruct[countryIdx], (d) => d[heatmapChosenData]);\n }\n\n return {min: minVal, max: maxVal};\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1382,"value":"heatmapColorScale = (val, heatmapMode) => {\n const value = accessHeatMapValue(val);\n const countryIdx = parseInt(val.slice(0, 2));\n const yearIdx = parseInt(val.slice(-2));\n var colorScale = null;\n\n const minMaxValues = dataMode == 'Normal' ? getMinMaxValues() : getMinMaxValues(countryIdx);\n const maxValue = Math.max([Math.abs(minMaxValues.min), Math.abs(minMaxValues.max)]);\n \n switch(heatmapMode) {\n case \"Change from 1990\": // Divergent\n var colorScale = d3.scaleDiverging()\n .domain([minMaxValues.min, 0, minMaxValues.max])\n .interpolator(d3.interpolateRdYlGn)\n break;\n case \"Total emissions\": // Seqüencial\n var colorScale = d3.scaleSequential(d3.interpolateGreys).domain([minMaxValues.min, minMaxValues.max]);\n break;\n case \"Ghg per capita\": // Seqüencial\n var colorScale = d3.scaleSequential(d3.interpolateGreys).domain([minMaxValues.min, minMaxValues.max]);\n break;\n } \n \n return colorScale(value);\n }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1178,"value":"**Falta afegir LATVIA (arreglar les dades) i ROMANIA**\n**Falta marcar que Xipre no va firmar (i buscar l'altre que tampoc) Afegir una separacio per aquests?**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1340,"value":"- No fer servir dades normalitzades de primera, jugar amb els thresholds i les mides per mostrar el de total emissions millor","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1080,"value":"viewof emissionsHeatmapDatasetString = Inputs.select([\"emissions_raw\", \"ghg_emissions_formatted\", \"unfccc_emissions_formatted\"], {label: \"Dataset (RECORDAR ELIMINAR)\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":863,"value":"viewof dataMode = Inputs.select([\"Normalize\", \"Normal\"], {label: \"Mode\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":932,"value":"viewof heatmapMode = Inputs.select([\"Total emissions\", \"Change from 1990\", \"Ghg per capita\"], {label: \"Data\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":717,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":104,"value":"data1 = FileAttachment(\"countries@3.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1947,"value":"//filteredResults_A = data1\n// .filter(entry => entry.UE === 'Yes' && entry.country !== 'Romania')\n\nfilteredResults_A = data1\n .filter(entry => entry.UE === 'Yes')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":106,"value":"data2 = data1","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"data2","database":"$undefined"},{"id":119,"value":"Transformaciones para representar los paises de la UE que firmaron el acuerdo, la reduccion a la que tenian que llegar y donde llegaron","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1573,"value":"data_UE_World = {\nconst countriesInData4 = data2.map(item => item.country);\n\nconst filteredData4 = emissionsDataset .filter(item => countriesInData4.includes(item.country));\n\nreturn filteredData4;\n}\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1620,"value":"select country,year,sum(co2) from data_UE_World\ngroup by country,year","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"group_data_UE_World","database":"var:data_UE_World"},{"id":127,"value":"data_UE = {\nconst countriesInData2 = data2.map(item => item.country);\n\nconst filteredData = emissions.filter(item => countriesInData2.includes(item.country));\nconsole.log(filteredData);\n\nreturn filteredData;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":117,"value":"SELECT\n YEAR,\n COUNTRY,\n CO2,\n CO2_1990::DOUBLE AS CO2_1990,\n CO2_1990*0.95 AS REDUCTION_CO2_1990 \nFROM\n (SELECT \n year,\n country,\n co2::DOUBLE AS CO2,\n (SELECT co2::double FROM data_UE t2 WHERE t2.country = t1.country AND t2.year = 1990) AS co2_1990\n FROM \n data_UE t1\n where co2 <> '')\n\n--WHERE country = 'Austria'","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"kioto_UE","database":"var:data_UE"},{"id":168,"value":"kioto_UE","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":170,"value":"CO2_1990 = data_UE.filter(d => d.year === \"1990\")\n .map((d) => {\n return {\n country: d.country,\n co2_1990: d.co2,\n reduction_co2_1990: d.co2 * 0.95\n }\n });\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":194,"value":"kioto_UE_2 = {\n const dataZ = [];\n kioto_UE\n .forEach((yearData) => {\n const year = parseInt(yearData.year);\n const quinquennium = year + (5 - year % 5);\n dataZ.push({\n country: yearData.country,\n year: year,\n quinquennium: quinquennium,\n co2: yearData.CO2,\n co2_1990: yearData.CO2_1990,\n red_co2_1990: yearData.REDUCTION_CO2_1990\n });\n });\n return dataZ;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":230,"value":"countries_data = d3.group(kioto_UE_2, d => d.country)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":236,"value":"viewof country_data = Inputs.select(countries_data, {label: \"Country:\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":297,"value":"\n// Faltaria normalitzar el punt de l'eix de les X\n\nPlot.plot({\n width: 600,\n height: 400,\n marginBottom: 100,\n x: {label: null, tickRotate: 90},\n y: {grid: true},\n color: {\n type: \"threshold\",\n scheme: \"tableau10\",\n domain: [country_data[0].co2_1990 * 0.8, country_data[0].red_co2_1990, country_data[0].co2_1990 * 1.14],\n range: [\n \"#539430\",\n \"#79B758\",\n \"#ff8389\",\n \"#da1e28\",\n ],\n legend: true\n },\n marks: [\n // Plot.barY(kioto_UE_Austria, Plot.groupX({y: \"sum\"}, {x: \"quinquennium\", y: \"co2\"})),\n Plot.dot(country_data.filter(d => d.year <= 2005 && d.year > 1950), {x: \"year\", y:\"co2\", fill:\"grey\", opacity: \"co2\"}),\n Plot.dot(country_data.filter(d => d.year > 2005), {x: \"year\", y:\"co2\", fill:\"co2\"}),\n Plot.ruleX([2008], {strokeDasharray: 2}),\n Plot.ruleX([2012], {strokeDasharray: 2}),\n Plot.ruleX([2013], {strokeDasharray: 2}),\n Plot.ruleX([2022], {strokeDasharray: 2}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":316,"value":"![g2324.png](${await FileAttachment(\"g2324.png\").url()})","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":300,"value":" La idea con este plot seria hacer una grid con plots de este tipo (uno por cada país) por una banda, y por la otra tener un plot que vaya \n apilando o agrupando los puntos rojos y azules para poder ver la situación en general y la evolución. Responderia a la pregunta\n 'Han cumplido los países? Y cuanto han tardado? (Deberia de ser una paleta sequencial)**(plot 4)**\n - Situación concreta 1 / Plot para ver la rapidez con que cada país llegó a las emisiones acordadas. (carrera)\n - Situació concreta 2 / Plot para ver que passó con los que no llegaron a las emisiones acordadas (si n’hi ha algun) (mapa interactiu) categoritzar per tipus de govern/zona… / plot para ver el impacto a nivel mundial de este tratado (poner los datos que hemos estado tratando a un contexto más general).\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":304,"value":"$3b","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":282,"value":"![image.png](${await FileAttachment(\"image.png\").url()})","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":323,"value":" - Detalle de la primera visualización para cada país a partir del 1990. La línea 0 seria el número de emisiones a las que debe llegar, o bien la diferencia de emisiones con el 1990. Ejemplo: **(plot 3)**\n![Captura2.PNG](${await FileAttachment(\"Captura2.PNG\").url()})","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":329,"value":" - Detalle: desglosar las emisiones por alguna categoria (tipo de gas?) **(Plot 4 )**Ejemplo:\n ![Captura3.PNG](${await FileAttachment(\"Captura3.PNG\").url()})","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":332,"value":"- Situación concreta 1 / Plot para ver la rapidez con que cada país llegó a las emisiones acordadas\n\n- Situació concreta 2 / Plot para ver que passó con los que no llegaron a las emisiones acordadas (si n’hi ha algun) / plot para ver el impacto a nivel mundial de este tratado (poner los datos que hemos estado tratando a un contexto más general).\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":423,"value":"---\n#### Addendum: data, libraries, other ...","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1085,"value":"### Datasets","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1131,"value":"**EU countries**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":543,"value":"countries_csv = FileAttachment(\"countries@3.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1088,"value":"---\n**Emissions dataset 1 (original)**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":429,"value":"emissions_raw = FileAttachment(\"owid-co2-data.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1090,"value":"**Emissions dataset 2 (time series)**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1011,"value":"ghg_emissions_workbook = FileAttachment(\"Time Series - GHG total with LULUCF, in kt CO₂ equivalent@4.xlsx\").xlsx()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1013,"value":"ghg_emissions = ghg_emissions_workbook.sheet(0, {\n headers: true,\n // range: \"A1:J10\"\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1028,"value":"ghg_emissions_formatted = {\n const dataZ = [];\n ghg_emissions\n .forEach((countryData) => {\n for (let i = 1990; i < 2022; i++) {\n dataZ.push(\n {\n country: countryData.Party,\n iso_code: countryData.iso,\n year: i,\n total_ghg: countryData[i]\n }\n )\n }\n });\n return dataZ;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1092,"value":"**Emission dataset 3 (UNFCCC official)**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1094,"value":"unfccc_emissions_workbook = FileAttachment(\"UNFCCC_emissions.xlsx\").xlsx()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1096,"value":"unfccc_emissions = unfccc_emissions_workbook.sheet(0, {\n headers: true,\n // range: \"A1:J10\"\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1116,"value":"unfccc_emissions_formatted = {\n const dataZ = [];\n unfccc_emissions\n .forEach((yearData) => {\n dataZ.push(\n {\n country: yearData.Country,\n iso_code: yearData.Country_code,\n year: yearData.Year,\n total_ghg: yearData.emissions\n }\n )\n });\n \n return dataZ.sort(function(a, b) {\n if(a.country > b.country) return 1\n else if (a.country == b.country) {\n if (a.year < b.year) return -1\n }\n else return -1;\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1129,"value":"---\n**Imports**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":425,"value":"import { toc } from \"@nebrius/indented-toc\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":520,"value":"import {SummaryTable} from \"@observablehq/summary-table\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1821,"value":"import {select, slider} from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3c","stdlib":"1","titling":"auto"}} 31:"$30:body"