Platform
Resources
Pricing
Sign in
Get started
huw
Workspace
Fork
Public
By
huw
Edited
Aug 12, 2024
1 fork
Importers
2
Insert cell
Insert cell
Insert cell
API_IT@1.NET.USER.ZS_DS2_en_csv_v2_2789860.csv
Filter
Columns
66
Sort
Slice
Save
Type Table, then Shift-Enter. Ctrl-space for more options.
Insert cell
dataFolded
=
aq
.
from
(
dataPivoted
)
.
fold
(
aq
.
not
(
[
"Name"
,
"Code"
]
)
,
{
as
:
[
"Year"
,
"Proportion"
]
}
)
.
derive
(
{
Proportion
:
(
d
)
=>
d
[
"Proportion"
]
/
100
||
undefined
}
)
Insert cell
dataFolded
Filter
Columns
Sort
Slice
Save
Type Table, then Shift-Enter. Ctrl-space for more options.
Insert cell
data
Filter
1
Columns
3
Sort
Slice
Save
Type Table, then Shift-Enter. Ctrl-space for more options.
Insert cell
import
{
countries110m
as
countries
}
from
"@visionscarto/geo"
Insert cell
import
{
fixCode
,
codeToName
}
from
"@huw/iso-3166-1"
Insert cell
geo
=
(
{
...
countries
,
features
:
countries
.
features
.
map
(
(
d1
)
=>
(
{
...
d1
,
properties
:
{
...
dataLatest
.
find
(
(
d2
)
=>
d2
[
"Code"
]
===
fixCode
(
d1
.
properties
.
a3
)
)
,
Name
:
codeToName
[
fixCode
(
d1
.
properties
.
a3
)
]
}
}
)
)
}
)
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
dataPivoted
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
File attachments
API_IT.NET.USER.ZS_DS2_en_csv_v2_2789860.csv
CSV
API_IT@1.NET.USER.ZS_DS2_en_csv_v2_2789860.csv
CSV
Databases
Filter
Column
Operator
Columns
Sort
Column
Direction
Descending
Ascending
Slice
From
Start
To
End
dataFolded
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
data
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
Cells
dataFolded
File attachments
API_IT.NET.USER.ZS_DS2_en_csv_v2_2789860.csv
CSV
API_IT@1.NET.USER.ZS_DS2_en_csv_v2_2789860.csv
CSV
Databases
Filter
Column
Operator
Columns
Sort
Column
Direction
Descending
Ascending
Slice
From
Start
To
End
dataLatest
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
Cells
data
File attachments
API_IT.NET.USER.ZS_DS2_en_csv_v2_2789860.csv
CSV
API_IT@1.NET.USER.ZS_DS2_en_csv_v2_2789860.csv
CSV
Databases
Filter
Year
Operator
Column
Operator
Columns
Sort
Column
Direction
Descending
Ascending
Slice
From
Start
To
End
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
geo
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML