Platform
Resources
Pricing
Sign in
Get started
Алина Галицына's Workspace
Workspace
Fork
Public
By
Алина Галицына
Edited
Dec 22, 2023
1 fork
4
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
dataset
=
FileAttachment
(
"dataset.csv"
)
.
csv
(
)
Insert cell
dataset.csv
Filter
1
Columns
Sort
Slice
Save
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.
Try it for free
Learn more
Fork
View
Export
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
dataset
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
File attachments
countries-50m.json
JSON
dataset.csv
CSV
totalReserves.csv
CSV
totalReserves_all_countries.csv
CSV
Databases
Filter
Series
Operator
Column
Operator
Columns
Sort
Column
Direction
Descending
Ascending
Slice
From
Start
To
End
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
select1
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
select
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
bd
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
transpose
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
transpose2
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
hale
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
filter
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
rename
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
countrymesh
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
countries
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
world
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
tr
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
years
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
years2022
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
years2000_2023
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
russia_export
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
countries_export
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
russia_export1
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
countries_export1
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
russia_import
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
countries_import
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
russia_import1
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
countries_import1
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
russia_stock_market
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
usa_stock_market
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
russia_stock_market1
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
usa_stock_market1
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
russia_exchange_rate
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
russia_exchange_rate1
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
countries_all
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
tr_russia
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
tr_select
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
tr_values_select
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
tr_values_russia
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
tr_years
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
total_reserves
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML