The avatar for @antoine-richard
Antoine RICHARD
Public
Edited
Mar 6, 2023
3 forks
1 star
2
Insert cell
Insert cell
Insert cell
xls=FileAttachment("grille_densite_7_niveaux_detaille_2022@1.xlsx").xlsx()
Insert cell
Insert cell
InputData
select substring(A,1,2) as DEPARTEMENT, sum(E) as Pop, D as Typo, C as Categorie from InputData where DEPARTEMENT in ('08','10','51','52','54','55','57','88','67','68') group by DEPARTEMENT,Typo , C order by C, Typo ;
Insert cell
Query
select DEPARTEMENT, Categorie, Pop as Repartition,
from Query
where DEPARTEMENT='67'
group by DEPARTEMENT,Categorie, Repartition
order by DEPARTEMENT;
Insert cell
Query
select
DEPARTEMENT, sum(Pop) as PopTot,
from Query
group by DEPARTEMENT, pop
order by DEPARTEMENT;
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
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
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