The avatar for @sigma-toulouse
Sigma
Geomatics Master at Toulouse Jean-Jaurès university and INP-ENSAT.
Public
Plot et BDD
Edited
Dec 8, 2022
2 forks
1
Insert cell
Insert cell
sicoval_data = DuckDBClient.of({
// Définition de table à partir d'un fichier CSV
sicoval: FileAttachment("Sicoval_alluvial_2019.csv")
})
Insert cell
Insert cell
sicoval_data
SELECT "CS1", sum(poids) as poids FROM sicoval GROUP BY sicoval."CS1" ORDER BY sicoval."CS1"
Insert cell
Insert cell
sicoval_data
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Plot.plot({
width: 1400,
grid: true,
facet: {
data: sicoval_table,
y: "CS1"
},
x: {
label: "TYPMR"
},
fx: {label: null},
marks: [
Plot.barY(sicoval_table, {x: "TYPMR", y: "CS1", fill: "CS1"}),
Plot.ruleY([0]),
Plot.frame()
]
})
Insert cell
Insert cell
Plot.plot({
width: 1400,
grid: true,
facet: {
data: sicoval_table,
y: "CS1"
},
x: {
label: "DIPL"
},
marks: [
Plot.barY(sicoval_table, {x: "DIPL", y: "CS1", fill: "CS1"}),
Plot.ruleY([0]),
Plot.frame()
]
})
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