Public
Edited
Jan 28, 2024
db = DuckDBClient.of({
meteofr: FileAttachment("meteo_france_selection_historique.parquet"),
//meteofr: FileAttachment("Meteo_france_selection_historique.csv")
})
data = db.query(`FROM meteofr
SELECT nom_usuel as localite, "DATE" AS "date",
year(date) AS annee, month(date) AS mois,
day(date) AS jour, dayofyear(date) AS jour_annee,
IFNULL(TN, -99) AS tmin,
IFNULL(TX, -99) AS tmax,
IFNULL(DG, -99) AS dg,
IFNULL(RR, -99) AS rr
WHERE annee >= ? AND localite = ?`, [+annee_debut, localite])
liste_localite = db.query("select distinct NOM_USUEL from meteofr ORDER BY 1")
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.
