Public
Edited
Nov 29, 2023
coutriesEnergyRawData = FileAttachment("Energy data 1990 - 2020.csv").csv({typed:true})
coutriesEnergyData = {
let newList = []
coutriesEnergyRawData.forEach((obj) => {
newList.push({
"Country": obj.country,
"Year": obj.Year,
"Region": obj.Region,
"Total energy consumption (Mtoe)": obj["Total energy consumption (Mtoe)"]
})
})
return newList
}
allCountry = {
let newList = []
coutriesEnergyRawData.forEach((obj) => {
newList.push(obj.country)
})
return new Array(... new Set(newList))
}
coutriesGDPRawData = FileAttachment("Countries GDP 1960-2020.csv").csv({typed:true})
allCountryGDP = {
let newList = []
coutriesGDPRawData.forEach((obj) => {
newList.push(obj["Country Name"])
})
return new Array(... new Set(newList))
}
countriesInGDPandEnergy = {
let count = []
allCountry.forEach((country) => {
if (allCountryGDP.includes(country)) {
count.push(country)
}
})
return count;
}
delyears = {
let startyear = 1960
let endyear = 1990
let newlist = []
while (startyear < endyear){
newlist.push(startyear)
startyear++
}
return newlist
}
countriesNeedGDPEnergyList = {
let newlist = []
countriesGDPNeeded.forEach((obj1) => {
countriesInGDPandEnergyList.forEach((obj2) => {
if(obj1["Country Name"] == obj2["Country"]) {
for (let key in obj1) {
if (parseInt(key) == obj2["Year"]) {
newlist.push({
... obj2,
"GDP": obj1[key]
})
}
}
}
})
})
return newlist
}
populationRawData = FileAttachment("pop.csv").csv({typed:true})
needPopulationData = {
let newList = []
populationRawData.forEach((obj) => {
if (countriesInGDPandEnergy.includes(obj["country"])) {
newList.push(obj)
}
if(obj["country"] == "USA") {
newList.push({
... obj,
"country": "United States"
})
}
if(obj["country"] == "UK") {
newList.push({
... obj,
"country": "United Kingdom"
})
}
})
return newList.sort()
}
cleanPop = FileAttachment("cleaned_pop.csv").csv({typed:true})
data = {
let newlist = []
cleanPop.forEach((obj1) => {
countriesNeedGDPEnergyList.forEach((obj2) => {
if(obj1["Country"] == obj2["Country"]) {
for (let key in obj1) {
if (parseInt(key) == obj2["Year"]) {
newlist.push({
... obj2,
"Population": obj1[key]
})
}
}
}
})
})
return newlist
}
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
