2f:T407,plot_other_industry_co2_3 = Plot.plot({ title: "CO2 emissions per year - " + grafic3.key, subtitle: "from 1980 to 2020", width: 1100, height: 500, marginRight: 120, marginBottom: 60, x: {grid: true, label: "Year", labelAnchor: "center", labelArrow: false, labelOffset: 35}, y: {grid: true, label: grafic3.key, labelAnchor: "center", labelArrow: false, labelOffset: 40}, color:{ type: "categorical", legend: true, domain: ["Italy", "Spain"], range: ["green", "red"], }, marks: [ Plot.ruleY([0]), Plot.lineY(perIndustry, { x: "year", y: grafic3, z: "country", color: { legend: "country"}, stroke: "country" }), Plot.text(perIndustry, Plot.selectLast({x: "year", y: grafic3, z: "country", text: "country", textAnchor: "start", dx: 3})), Plot.text(perIndustry, {filter: (d) => d.year % 5 === 0, x: "year", y: grafic3, text: (d) => `${d[grafic3.value]}`, dy: -12}), Plot.circle(perIndustry, { x: "year", y: grafic3, fill: "country" }), ] });30:T722,ratioChart = { return(Plot.plot({ title: "Italy leads GDP/CO2 efficiency over Spain", subtitle: "Sustainable economies constrained by the environmental impact", marginLeft: 80, marginBottom: 80, x: {label: "Year", labelAnchor: "center", labelArrow: false, labelOffset: 35}, y: {label: "Ratio GDP/CO2", labelAnchor: "center", labelArrow: false, labelOffset: 40}, color: {legend:true}, marks: [ Plot.dot(scatterplotData, Plot.pointerX({x: "year", y: "ratio_italy", stroke: "red", strokeWidth:2, r: 5})), Plot.dot(scatterplotData, Plot.pointerX({x: "year", y: "ratio_spain", stroke: "red", strokeWidth: 2, fill: "yellow", r: 5})), Plot.lineY(scatterplotData, {x: "year", y: "ratio_italy", stroke: "green"}), Plot.lineY(scatterplotData, {x: "year", y: "ratio_spain", stroke: "red"}), Plot.ruleX(scatterplotData, Plot.pointerX({x: "year", py: "ratio_italy", stroke: "grey"})), Plot.text(scatterplotData, Plot.pointerX({px: "year", py: "ratio_italy", dx: 30, dy: 20, frameAnchor: "top-left", fontVariant: "tabular-nums", fontSize: 14, fontWeight: "bold", text: (d) => [` Year ${d.year.toFixed(0)}`].join(" ")})), Plot.text(scatterplotData, Plot.pointerX({px: "year", py: "ratio_italy", dx: 30, dy: 28, frameAnchor: "top-left", fontVariant: "tabular-nums", fontSize: 14, text: (d) => [`\n`, ` GDP ($B)`, `\n`, `Italy ${d.gdp_italy.toFixed(1)}`, `\n`,`Spain ${d.gdp_spain.toFixed(1)}`].join(" ")})), Plot.text(scatterplotData, Plot.pointerX({px: "year", py: "ratio_italy", dx: 170, dy: 28, frameAnchor: "top-left", fontVariant: "tabular-nums", fontSize: 14, text: (d) => [`\n`, `CO2 (Mt)`, `\n`, `${d.co2_italy.toFixed(2)}`, `\n`, `${d.co2_spain.toFixed(2)}`].join(" ")})), ] })) } 31:[{"id":"9a1e14ec4ca87607f4ebc6507bff1e37baedebc06708000c9e0a9e325552a76ee2429c3b3721ae8956c0747cd66877f0b6826e35638cbcef769824ffedc7cdfb","href":"https://static.observableusercontent.com/files/9a1e14ec4ca87607f4ebc6507bff1e37baedebc06708000c9e0a9e325552a76ee2429c3b3721ae8956c0747cd66877f0b6826e35638cbcef769824ffedc7cdfb","name":"6.pib-co2.jpg","type":"image/jpeg","lastModified":1705252559849.615,"size":22408},{"id":"4941d38be55311e10f486823a63df3707af1de807d2b0296704c388836131321863590f0e7bc07504cbb580774903c233cd34a50a057348085e06c491b62d4fe","href":"https://static.observableusercontent.com/files/4941d38be55311e10f486823a63df3707af1de807d2b0296704c388836131321863590f0e7bc07504cbb580774903c233cd34a50a057348085e06c491b62d4fe","name":"1.Europe map.jpg","type":"image/jpeg","lastModified":1705252559849.615,"size":21226},{"id":"ad57d0b394074116811d316f0ca883a1e64519af33dbfe1fe6a33f637b4141659ec1c9abb3b1979094e1dfe9befbad3ade101754499d0e49985087debb643003","href":"https://static.observableusercontent.com/files/ad57d0b394074116811d316f0ca883a1e64519af33dbfe1fe6a33f637b4141659ec1c9abb3b1979094e1dfe9befbad3ade101754499d0e49985087debb643003","name":"5.dif energy per capita.jpg","type":"image/jpeg","lastModified":1705252559849.615,"size":18825},{"id":"daa08525435add8d415e63368326d97ce23c67bcba9069859a893bb16b87aa429f0d80c5e05ca3d9a327d538dc7413bf873d7330b206b5d159c475402fb93b28","href":"https://static.observableusercontent.com/files/daa08525435add8d415e63368326d97ce23c67bcba9069859a893bb16b87aa429f0d80c5e05ca3d9a327d538dc7413bf873d7330b206b5d159c475402fb93b28","name":"4.dots energy country.jpg","type":"image/jpeg","lastModified":1705252559849.615,"size":24321},{"id":"5457611d9b20142d71a9e375c0334c559041609863f6ddd4fcd71dd4a6e22d30eb76e9ee0dd40f2b17283f099dd48d9e5cb60efce6c0ef56f9642241cc4d298b","href":"https://static.observableusercontent.com/files/5457611d9b20142d71a9e375c0334c559041609863f6ddd4fcd71dd4a6e22d30eb76e9ee0dd40f2b17283f099dd48d9e5cb60efce6c0ef56f9642241cc4d298b","name":"2.heatmap.jpg","type":"image/jpeg","lastModified":1705252559849.615,"size":27736},{"id":"b8f6ce46f64cf5282491dc844bd5892fe2d055d473ad390639b913b19e60122855d67975db0f0d30767b4084b203367043c48d29818171735a1a85a4a3ed7f0a","href":"https://static.observableusercontent.com/files/b8f6ce46f64cf5282491dc844bd5892fe2d055d473ad390639b913b19e60122855d67975db0f0d30767b4084b203367043c48d29818171735a1a85a4a3ed7f0a","name":"3.co2 industry.jpg","type":"image/jpeg","lastModified":1705252559849.615,"size":27108},{"id":"25104fb370e71fb6eba7cad27779645e9980f4f851ab64da185ba9587a255f250e48bd7384c0eee4917467e5850215415c4dc99d584985ddfc3aa3d0190430a9","href":"https://static.observableusercontent.com/files/25104fb370e71fb6eba7cad27779645e9980f4f851ab64da185ba9587a255f250e48bd7384c0eee4917467e5850215415c4dc99d584985ddfc3aa3d0190430a9","name":"eu_map_data.geojson","type":"application/geo+json","lastModified":1705252559849.615,"size":1605430}] 2d:{"title":"Final exercise bo:","cells":[{"id":0,"value":"# Final exercise bo:","pinned":false,"hidden":false,"mode":"md"},{"id":5,"value":"## Intro\nMy analytical goal ...","pinned":false,"hidden":false,"mode":"md"},{"id":179,"value":"---\n## Summary","pinned":true,"hidden":false,"mode":"md"},{"id":197,"value":"toc({\n title: null,\n headers: 'h1',\n headers: 'h2',\n headers: 'h3',\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1462,"value":"europeMap = FileAttachment(\"1.Europe map.jpg\").image()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1622,"value":"viewof selected_plot = Inputs.select(map_plots, {label: \"Choose a plot\", format: x => x.name, value: map_plots.find(t => t.variable === \"co2\")})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1625,"value":"Plot.plot({\n title: \"CO2 emissions in Europe per country\",\n subtitle: \"Data from 2022\",\n width: 500,\n projection: { type: \"conic-conformal\", domain: eu_data_map },\n color: {\n scheme: \"YlOrRd\",\n label: selected_plot.legend,\n legend: true\n },\n marks: [\n Plot.geo(eu_countries, { fill: (d) => d.properties[selected_plot.variable], opacity: 1 }),\n Plot.geo(other_eu, { fill: \"grey\" , stroke: \"white\", opacity: 0.15 }),\n Plot.geo(not_esp_ita, {stroke: \"black\",strokeWidth: 0.5 }),\n Plot.geo(esp_ita, {stroke: \"black\",strokeWidth: 2 }),\n Plot.dot(eu_countries, Plot.centroid({ fill: \"white\", stroke: \"black\" })),\n Plot.tip(eu_countries, Plot.pointer(\n Plot.centroid({\n stroke: \"white\",\n strokeWidth: 0.125,\n tip: true,\n channels: {\n \"Country\": d => d.properties.country,\n \" - CO2\": d => d.properties.co2,\n \" - CO2 per capita\": d => d.properties.co2_per_capita\n }\n })\n ))\n ]\n});","pinned":true,"hidden":false,"mode":"ojs"},{"id":1468,"value":"heatmap = FileAttachment(\"2.heatmap.jpg\").image()","pinned":false,"hidden":false,"mode":"ojs"},{"id":185,"value":"---\n### Per editar\n X axis tickmark cada 5 anys","pinned":false,"hidden":false,"mode":"md"},{"id":782,"value":"viewof includeOutliers = Inputs.toggle({label: \"Considering Luxembourg, Czechia and Estonia\", value: false})","pinned":false,"hidden":false,"mode":"ojs"},{"id":400,"value":"Plot.plot({\n title: \"Evolution of CO2 per capita in Europe\",\n subtitle: \"CO2 emissions are decreasing steadily over time\",\n width: 1000,\n marginLeft: 120,\n marginBottom: 80,\n padding: 0,\n x: {labelAnchor: \"center\", labelOffset: 70, ticks: 5, tickRotate: -90, tickSize: 20, tickPadding: 10},\n y: {labelOffset: 120},\n color: {\n legend: true,\n scheme: \"Turbo\"\n },\n marks: [\n \n Plot.cell(\n cellChartDataSource,\n {x: \"year\", fy: \"country\", inset: 0.1, fill: \"co2_per_capita\"}\n ),\n Plot.frame({fy: \"Italy\", strokeWidth: 2}),\n Plot.frame({fy: \"Spain\", strokeWidth: 2})\n \n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1470,"value":"co2Industry = FileAttachment(\"3.co2 industry.jpg\").image()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1370,"value":"viewof grafic3 = Inputs.select(tipusco2, {label: \"Select a CO2 plot\", format: x => x.key, value: tipusco2.find(t => t.key === \"CO2\")})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1450,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":1472,"value":"dotsEnergyCountry = FileAttachment(\"4.dots energy country.jpg\").image()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1409,"value":"viewof year = Scrubber(Array.from({ length: 2023 - 1980 }, (_, index) => 1980 + index), {loop: false, delay: 150, autoplay: false})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1683,"value":"{\n const svg = d3\n .create(\"svg\")\n .attr(\"width\", 1000)\n .attr(\"height\", 400)\n .attr(\"viewBox\", [-100000, -50000, 200000, 100000])\n \n svg.append('circle').attr('r', bubblePlot[0].energy_per_capita).attr('cx', -bubblePlot[0].energy_per_capita).attr('cy', 0).attr(\"fill\", \"green\");\n svg.append('circle').attr('r', bubblePlot[1].energy_per_capita).attr('cx', bubblePlot[1].energy_per_capita).attr('cy', 0).attr(\"fill\", \"red\");\n return svg.node();\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1405,"value":"Plot.plot({\n width: widthBubble,\n height: heightBubble,\n marginLeft: 80,\n marginBottom: 80,\n title: \"Comparing energy consumption between Spain and Italy\",\n subtitle: \"Difference in per capita yearly energy consumption\",\n \n marks: [\n \n Plot.circle(bubblePlot, {\n x: -bubblePlot[0].energy_per_capita, \n y: 0 , \n r: bubblePlot[0].energy_per_capita, \n fill: \"Green\"},\n ),\n \n Plot.circle(bubblePlot, {\n x: bubblePlot[1].energy_per_capita, \n y: 0 , \n r: bubblePlot[1].energy_per_capita, \n fill: \"Red\"},\n ),\n Plot.circle(bubblePlot, {\n x: 0, \n y: 0 , \n r: 50000, \n stroke: \"Black\"},\n )\n ]\n})\n\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":1767,"value":"d3 = require('d3')","pinned":true,"hidden":false,"mode":"ojs"},{"id":1769,"value":"{\n const svg = d3\n .create(\"svg\")\n .attr(\"width\", 500)\n .attr(\"height\", 200)\n .attr(\"viewBox\", [-100000, -50000, 200000, 100000])\n \n svg.append('circle').attr('r', bubblePlot[0].energy_per_capita).attr('cx', -bubblePlot[0].energy_per_capita).attr('cy', 0).attr(\"fill\", \"rgb(156 163 175)\");\n svg.append('circle').attr('r', bubblePlot[1].energy_per_capita).attr('cx', bubblePlot[1].energy_per_capita).attr('cy', 0).attr(\"fill\", \"red\");\n return svg.node();\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1473,"value":"difEnergyPerCapita = FileAttachment(\"5.dif energy per capita.jpg\").image()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1361,"value":"Plot.plot({\n marginLeft: 80,\n marginBottom: 80,\n title: \"Comparing energy consumption between Spain and Italy\",\n subtitle: \"Difference in per capita yearly energy consumption\",\n x: {label: \"Year\", labelAnchor: \"center\", labelArrow: false, labelOffset: 40},\n y: {label: \"Energy consumption (kWh)\",labelAnchor: \"center\", labelArrow: false, labelOffset: 60},\n \n marks: [\n Plot.ruleY([0]),\n Plot.ruleX([1965]),\n \n Plot.differenceY(energy_diff, {x: \"year\", y: \"diff\", positiveFill: \"red\", negativeFill: \"green\", fillOpacity: 0.3, strokeWidth: 1}),\n\n Plot.tip([\"Italy\"],{x: 1978, y: -8600, anchor: \"top-left\", fill: \"Green\", fillOpacity: 0.3, fontWeight: \"Bold\"}),\n Plot.tip([\"Spain\"],{x: 2001, y: 2350, anchor: \"bottom-right\", fill: \"Red\", fillOpacity: 0.3, fontWeight: \"Bold\"}),\n \n Plot.tip(energy_diff, Plot.pointerX({x: \"year\", y: \"diff\"})) \n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1476,"value":"pibCo2 = FileAttachment(\"6.pib-co2.jpg\").image()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1271,"value":"

${[ratioChart]}

${[scatterChart]}

","pinned":false,"hidden":false,"mode":"html"},{"id":905,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":1104,"value":"scatterChart = {\n return(Plot.plot({\n marginLeft: 80,\n marginBottom: 80,\n title: \"Evolving towards efficiency\",\n subtitle: \"1980 and 2005 were two inflection years in the co2 emissions reduction\",\n x: {label: \"CO2 emissions (Mt)\", labelAnchor: \"center\", labelArrow: false, labelOffset: 35},\n y: {label: \"GDP ($B)\", labelAnchor: \"center\", labelArrow: false, labelOffset: 50},\n marks: [\n Plot.dot(scatterplotData2, {\n x:\"co2\",\n y: \"gdp\",\n fill: d => d.country === \"Italy\" ? greens(d.year) : reds(d.year)\n }),\n \n Plot.tip(scatterplotData2, Plot.pointer({x: \"co2\", y: \"gdp\", channels: {year: \"year\", country: \"country\"}}))\n ]\n }))\n} ","pinned":false,"hidden":false,"mode":"ojs"},{"id":21,"value":"---\n## Other questions\nI haven't explored this ... but it might be something cool to do with this dataset.","pinned":false,"hidden":false,"mode":"md"},{"id":209,"value":"---\n### DATA GENERAL","pinned":false,"hidden":false,"mode":"md"},{"id":336,"value":"rawData = d3.csv(\"https://raw.githubusercontent.com/owid/co2-data/master/owid-co2-data.csv\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":379,"value":"keys = [\"country\",\"year\",\"iso_code\",\"population\",\"gdp\",\"co2\",\"co2_growth_abs\",\"co2_growth_prct\",\"co2_per_capita\",\"co2_per_gdp\",\"co2_per_unit_energy\",\"co2_including_luc\",\"co2_including_luc_growth_abs\",\"co2_including_luc_growth_prct\",\"co2_including_luc_per_capita\",\"co2_including_luc_per_gdp\",\"co2_including_luc_per_unit_energy\",\"cement_co2\",\"cement_co2_per_capita\",\"coal_co2\",\"coal_co2_per_capita\",\"consumption_co2\",\"consumption_co2_per_capita\",\"flaring_co2\",\"flaring_co2_per_capita\",\"gas_co2\",\"gas_co2_per_capita\",\"land_use_change_co2\",\"land_use_change_co2_per_capita\",\"oil_co2\",\"oil_co2_per_capita\",\"other_industry_co2\",\"other_co2_per_capita\",\"trade_co2\",\"primary_energy_consumption\",\"energy_per_capita\",\"energy_per_gdp\",\"temperature_change_from_co2\"]","pinned":false,"hidden":false,"mode":"ojs"},{"id":362,"value":"europeanCountries = [\"Austria\", \"Belgium\", \"Bulgaria\", \"Croatia\", \"Cyprus\", \"Czechia\", \"Denmark\", \"Estonia\", \"Finland\", \"France\", \"Germany\", \"Greece\", \"Hungary\", \"Iceland\", \"Ireland\", \"Italy\", \"Latvia\", \"Liechtenstein\", \"Lithuania\", \"Luxembourg\", \"Malta\", \"Netherlands\", \"Norway\", \"Poland\", \"Portugal\", \"Romania\", \"Slovakia\", \"Slovenia\", \"Spain\", \"Sweden\", \"Switzerland\", \"United Kingdom\"]\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":364,"value":"europeanDataRaw = rawData.filter(item => europeanCountries.includes(item.country) && item.year >= 1950)","pinned":false,"hidden":false,"mode":"ojs"},{"id":387,"value":"europeanData = europeanDataRaw.map(obj => filterObject(obj, keys));\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":532,"value":"spainData = europeanData.filter(item => item.country === 'Spain');","pinned":false,"hidden":false,"mode":"ojs"},{"id":529,"value":"italyData = europeanData.filter(item => item.country === 'Italy');\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":1607,"value":"### DATA MARTÍ","pinned":false,"hidden":false,"mode":"md"},{"id":1611,"value":"eu_data_map = FileAttachment(\"eu_map_data.geojson\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1634,"value":"eu_countries = {\n return eu_data_map.features.filter(feature => feature.properties.type === 0 ||feature.properties.type === 2);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1647,"value":"other_eu = {\n return eu_data_map.features.filter(feature => feature.properties.type === 1);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1637,"value":"esp_ita = {\n return eu_data_map.features.filter(feature => feature.properties.type === 2);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1640,"value":"not_esp_ita = {\n return eu_data_map.features.filter(feature => feature.properties.type === 0);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1620,"value":"map_plots = [\n {variable: \"co2\", name: \"Total CO2\", legend: \"CO2 Emissions (in million tonnes)\"},\n {variable: \"co2_per_capita\", name: \"CO2 per capita\", legend: \"CO2 per capita (in tonnes)\"},\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":649,"value":"### DATA MIREIA","pinned":false,"hidden":false,"mode":"md"},{"id":1382,"value":"perIndustry = europeanData\n .filter((value) => value.year >= 1980 && (value.country === 'Italy' || value.country === 'Spain'))\n .map((entry) => ({\n year: entry.year,\n country: entry.country,\n co2: convertToFloat(entry.co2),\n cement_co2: convertToFloat(entry.cement_co2),\n coal_co2: convertToFloat(entry.coal_co2),\n consumption_co2: convertToFloat(entry.consumption_co2),\n oil_co2: convertToFloat(entry.oil_co2),\n other_industry_co2: convertToFloat(entry.other_industry_co2),\n}));","pinned":false,"hidden":false,"mode":"ojs"},{"id":1445,"value":"tipusco2 = [\n {key: \"CO2\", value: \"co2\"},\n {key: \"Cement CO2\", value: \"cement_co2\"},\n {key: \"Coal CO2\", value: \"coal_co2\"},\n {key: \"Consumption based CO2\", value: \"consumption_co2\"},\n {key: \"Oil CO2\", value: \"oil_co2\"},\n {key: \"Other industry CO2\", value: \"other_industry_co2\"}]","pinned":false,"hidden":false,"mode":"ojs"},{"id":1407,"value":"bubblePlot = europeanData\n .filter((value) => value.year == year && (value.country === 'Italy' || value.country === 'Spain'))\n .map((entry) => ({\n year: entry.year,\n country: entry.country,\n energy_per_capita: convertToFloat(entry.energy_per_capita),\n}));","pinned":false,"hidden":false,"mode":"ojs"},{"id":1518,"value":"radius0 = bubblePlot[0].energy_per_capita","pinned":false,"hidden":false,"mode":"ojs"},{"id":1521,"value":"radius1 = bubblePlot[1].energy_per_capita","pinned":false,"hidden":false,"mode":"ojs"},{"id":1498,"value":"widthBubble = 4*Math.max(bubblePlot[0].energy_per_capita, bubblePlot[1].energy_per_capita)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1502,"value":"heightBubble = 2*Math.max(bubblePlot[0].energy_per_capita, bubblePlot[1].energy_per_capita)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1313,"value":"### DATA ALBERT","pinned":false,"hidden":false,"mode":"md"},{"id":744,"value":"#### Cell chart","pinned":false,"hidden":false,"mode":"md"},{"id":791,"value":"cellChartDataSource = includeOutliers ? cellChart1 : cellChart0;","pinned":false,"hidden":false,"mode":"ojs"},{"id":760,"value":"SELECT \n year,\n country,\n CAST(co2_per_capita AS FLOAT) AS co2_per_capita\nFROM europeanData\nWHERE year >= 1965 AND country NOT IN ('Luxembourg', 'Czechia', 'Estonia') ;","pinned":false,"hidden":false,"mode":"sql","output":"cellChart0","database":"var:europeanData"},{"id":785,"value":"SELECT \n year,\n country,\n CAST(co2_per_capita AS FLOAT) AS co2_per_capita\nFROM europeanData\nWHERE year >= 1965;","pinned":false,"hidden":false,"mode":"sql","output":"cellChart1","database":"var:europeanData"},{"id":829,"value":"#### energy diff","pinned":false,"hidden":false,"mode":"md"},{"id":823,"value":"SELECT\n CAST (ed1.year AS Float) AS year,\n CAST(ed1.energy_per_capita AS Float) AS epc_italy,\n CAST(ed2.energy_per_capita AS Float) AS epc_spain,\n CAST(ed2.energy_per_capita AS Float) - CAST(ed1.energy_per_capita AS Float) AS diff\nFROM\n europeanData ed1\n \nJOIN\n europeanData ed2 ON ed1.year = ed2.year\n AND ed1.country = 'Italy'\n AND ed2.country = 'Spain'\nWHERE\n ed1.year >= 1965\n\nORDER BY ed1.year\n\n","pinned":true,"hidden":false,"mode":"sql","output":"energy_diff","database":"var:europeanData"},{"id":1343,"value":"INSERT INTO energy_diff (year, epc_italy, epc_spain, diff)\nVALUES (1999.5, 5428, 5644, 0);","pinned":true,"hidden":false,"mode":"sql","output":"energy_diff2","database":"var:energy_diff"},{"id":874,"value":"#### scatterplot","pinned":false,"hidden":false,"mode":"md"},{"id":878,"value":"SELECT\n ed1.year AS year,\n CAST(ed1.gdp AS Float) / CAST(ed1.co2 AS Float) / 1000000000 AS ratio_italy,\n CAST(ed2.gdp AS Float) / CAST(ed2.co2 AS Float) / 1000000000 AS ratio_spain,\n CAST(ed1.gdp AS Float) / 1000000000 AS gdp_italy,\n CAST(ed2.gdp AS Float) / 1000000000 AS gdp_spain,\n CAST(ed1.co2 AS Float) AS co2_italy,\n CAST(ed2.co2 AS Float) AS co2_spain,\n \n\nFROM\n europeanData ed1\n \nJOIN\n europeanData ed2 ON ed1.year = ed2.year\n AND ed1.country = 'Italy'\n AND ed2.country = 'Spain'\nWHERE\n ed1.year >= 1965 AND ed1.year < 2019\n\n\nORDER BY ed1.year\n","pinned":true,"hidden":false,"mode":"sql","output":"scatterplotData","database":"var:europeanData"},{"id":1123,"value":"SELECT\n year AS year,\n country AS country,\n CAST(gdp AS Float) / 1000000000 AS gdp,\n CAST(co2 AS Float) AS co2\n\nFROM\n europeanData\n \nWHERE\n year >= 1965 AND year < 2019\n AND (country = 'Italy' OR country = 'Spain')\n","pinned":true,"hidden":false,"mode":"sql","output":"scatterplotData2","database":"var:europeanData"},{"id":437,"value":"europeanData2 = europeanData.map(obj => ({\n ...obj,\n date: `${obj.year}-01-01`\n}));","pinned":false,"hidden":false,"mode":"ojs"},{"id":463,"value":"europeanData2","pinned":false,"hidden":false,"mode":"ojs"},{"id":548,"value":"numericalEuropeanData = europeanData.map(item => ({\n ...item,\n year: parseFloat(item.year),\n}));","pinned":false,"hidden":false,"mode":"ojs"},{"id":539,"value":"{\n for (var i = 0; i < europeanData.length; i++) {\n europeanData[i].year = parseInt(europeanData[i].year, 10);\n }\n} ","pinned":false,"hidden":false,"mode":"ojs"},{"id":398,"value":"---\n#### Functions","pinned":false,"hidden":false,"mode":"md"},{"id":385,"value":"function filterObject(obj, keysToKeep) {\n return Object.fromEntries(Object.entries(obj).filter(([key]) => keysToKeep.includes(key)));\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":710,"value":"## IMPORTS","pinned":false,"hidden":false,"mode":"md"},{"id":19,"value":"import { toc } from \"@nebrius/indented-toc\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1135,"value":"greens = d3.scaleLinear([1965, 2020], [\"#ebf5ec\", \"#008001\"])","pinned":true,"hidden":false,"mode":"ojs"},{"id":1137,"value":"reds = d3.scaleLinear([1965, 2020], [\"#ffebec\", \"#fe0000\"]);","pinned":true,"hidden":false,"mode":"ojs"},{"id":1384,"value":"function convertToFloat(value){\n return value !== null ? parseFloat(value): null\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1419,"value":"import {Scrubber} from \"@mbostock/scrubber\"","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}