Public
Edited
Dec 22, 2023
1 fork
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
dataset = FileAttachment("dataset.csv").csv()
Insert cell
dataset.csv
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
hale = filter.map(d => ({name: rename.get(d.Страна) || d.Страна, Курс_2023: +d[2023]}))
Insert cell
filter = bd.filter((d)=> (d["Индикатор"] == "Real Effective Exchange Rate,,,,") && ( d["2023"] != ".."))
Insert cell
Insert cell
countrymesh = topojson.mesh(world, world.objects.countries, (a, b) => a !== b)
Insert cell
countries = topojson.feature(world, world.objects.countries)
Insert cell
world = FileAttachment("countries-50m.json").json()
Insert cell
Insert cell
years = ["2017", "2018", "2019", "2020", "2021", "2022", "2023"]
Insert cell
Insert cell
Insert cell
russia_export = bd.filter((d)=> (d["Страна"] == "Russian Federation") && (d["Индикатор"] == "Exports Merchandise, Customs, current US$, millions, seas. adj."))
Insert cell
countries_export = bd.filter((d)=> (d["Страна"] == select1) && (d["Индикатор"] == "Exports Merchandise, Customs, current US$, millions, seas. adj."))
Insert cell
russia_export1 = transpose(russia_export).slice(0,7)
Insert cell
countries_export1 = transpose(countries_export).slice(0,7)
Insert cell
russia_import = bd.filter((d)=> (d["Страна"] == "Russian Federation") && (d["Индикатор"] == "Imports Merchandise, Customs, current US$, millions, seas. adj."))
Insert cell
countries_import = bd.filter((d)=> (d["Страна"] == select1) && (d["Индикатор"] == "Imports Merchandise, Customs, current US$, millions, seas. adj."))
Insert cell
russia_import1 = transpose(russia_import).slice(0,7)
Insert cell
countries_import1 = transpose(countries_import).slice(0,7)
Insert cell
russia_stock_market = bd.filter((d)=> (d["Страна"] == "Russian Federation") && (d["Индикатор"] == "Stock Markets, US$,,,") )
Insert cell
usa_stock_market = bd.filter((d)=> (d["Страна"] == "United States") && (d["Индикатор"] == "Stock Markets, US$,,,") )
Insert cell
russia_stock_market1 = transpose(russia_stock_market).slice(0,7)
Insert cell
usa_stock_market1 = transpose(usa_stock_market).slice(0,7)
Insert cell
russia_exchange_rate = bd.filter((d)=> (d["Страна"] == "Russian Federation") && (d["Индикатор"] == "Real Effective Exchange Rate,,,,") )
Insert cell
russia_exchange_rate1 = transpose(russia_exchange_rate).slice(0,7)
Insert cell
countries_all = new Set(bd.map(d => d['Страна']).sort())
Insert cell
tr_russia = total_reserves.filter((d)=> d["Country"] == "Russian Federation")
Insert cell
tr_select = total_reserves.filter( (x)=> String(x["Country"])==select)
Insert cell
tr_values_select = transpose(tr_select).slice(4,28)
Insert cell
Insert cell
tr_years = transpose2(tr_russia).slice(4,28)
Insert cell
total_reserves = FileAttachment("totalReserves_all_countries.csv").csv()
Insert cell

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.
Learn more