Platform
Resources
Pricing
Sign in
Get started
Lino Galiana
Workspace
Fork
Public
By
Lino Galiana
Edited
Jun 19, 2023
Insert cell
Insert cell
viewof
search
=
Inputs
.
search
(
data
,
{
datalist
:
d
=>
d
.
Code
,
placeholder
:
"Taper une catégorie"
}
)
Insert cell
Inputs
.
table
(
search
)
Insert cell
viewof
coicop_selected
=
Inputs
.
text
(
{
label
:
"Choix de la catégorie"
,
placeholder
:
"Entrer un libellé de COICOP"
,
datalist
:
data_raw
.
map
(
d
=>
d
.
Libellé
)
,
submit
:
true
//value: "Toulouse"
}
)
Insert cell
data
=
data_raw
.
map
(
d
=>
(
{
Code
:
d
.
Code
.
replace
(
"\'"
,
''
)
,
Libellé
:
d
.
Libellé
}
)
)
Insert cell
data_raw
Insert cell
xlsx
=
require
(
"xlsx@0.17.0/dist/xlsx.core.min.js"
)
Insert cell
import
{
getExcel
}
from
"@neocartocnrs/fetch-an-excel-sheet"
Insert cell
proxy
=
"https://corsproxy.io/?"
Insert cell
url
=
"https://www.insee.fr/fr/statistiques/fichier/2402696/coicop2016_liste_n5.xls"
Insert cell
data_raw
=
getExcel
(
proxy
+
url
,
"Sheet1"
,
0
,
1
)
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
search
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
coicop_selected
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
data
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
xlsx
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
proxy
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
url
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
data_raw
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML