2f:T953,graph_temp = Plot.plot({ marginLeft: 50, marginTop: 20, marginBottom: 40, width: 640, height: 500, y: { grid: true, label: "Température °c", domain: [-30, 45] //[extend_tmin[0] * 1.2, extend_tmax[1] * 1.2] }, x: { ticks: minDate > 1940 ? temp_max_annee.map((d) => d.annee).filter((d, i) => i % 5 === 0) : temp_max_annee.map((d) => d.annee).filter((d, i) => i % 10 === 0), tickFormat: ".0f", grid: true, domain: [minDate, 2023], label: "Année" }, style: { background: "#000", color: "#fff", fontSize: "12px" }, caption: html`Historique des températures maximales et minimales à ${localite} - Source Météo-France `, marks: [ Plot.frame(), Plot.line(temp_max_annee, { x: "annee", y: "temp", stroke: "red" }), Plot.line(temp_min_annee, { x: "annee", y: "temp", stroke: "lightblue" }), Plot.line(regression_gen_temp(temp_max_annee), { x: "0", y: "1", stroke: "orange" }), Plot.line(regression_gen_temp(temp_min_annee), { x: "0", y: "1", stroke: "orange" }), Plot.text( [ `température max\n` + extent_date_temp_max_annee[0] + ` : ` + reg_min_tmax.toFixed(1) + `°c => ` + extent_date_temp_max_annee[1] + ` : ` + reg_max_tmax.toFixed(1) + `°c \nÉvolution = ` + reg_tmax_diff + `°C` ], { frameAnchor: "middle", fontSize: 14, x: minDate + 5, y: extend_tmax[1] * 1.1, lineWidth: 50, textAnchor: "start", lineHeight: 1.2, monospace: true, clip: true, fill: "orange" } ), Plot.text( [ `température min\n` + extent_date_temp_max_annee[0] + ` : ` + reg_min_tmin.toFixed(1) + `°c => ` + extent_date_temp_max_annee[1] + ` : ` + reg_max_tmin.toFixed(1) + `°c \nÉvolution = ` + reg_tmin_diff + `°c` ], { frameAnchor: "middle", fontSize: 14, x: minDate + 5, y: 5, //extend_tmin[0], lineWidth: 50, textAnchor: "start", lineHeight: 1.2, monospace: true, clip: true, fill: "orange" } ) ] })30:[{"id":"91a306301c34ec791adcb8cfdf01f6b8e8f7b7faab15390b06b05d83298e57f3a7fc996a01cee0af9877f9e94b29a9997718a16132cc357cc5fefe2ec7c9b8ac","href":"https://static.observableusercontent.com/files/91a306301c34ec791adcb8cfdf01f6b8e8f7b7faab15390b06b05d83298e57f3a7fc996a01cee0af9877f9e94b29a9997718a16132cc357cc5fefe2ec7c9b8ac","name":"meteo_france_selection_historique.parquet","type":"application/octet-stream","lastModified":1706451895698.228,"size":3006155}] 2d:{"title":" HISTORIQUE DES DONNÉES CLIMATIQUES","cells":[{"id":4,"value":"note = md`\n# HISTORIQUE DES DONNÉES CLIMATIQUES\n## Historique des températures de localités françaises de 1900-2020 à partir des données Météo-France.\nVersion DuckDB\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":7695,"value":"{\n data\n let tm1 = performance.now() \n return \"Chargement : \" + ~~(tm1 - time_js1) + ' ms'\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2455,"value":"Text3 = md`\n## INTERACTION \n\n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":6112,"value":"text4 = md`Sélectionnez l’échelle de temps et visualisez comment ont évolué les températures depuis cette date.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":6601,"value":"viewof localite = Inputs.select(liste_localite.map(d => d.NOM_USUEL), {\n label: \"Choisir une ville\",\n value: liste_localite[liste_localite.length - 5].NOM_USUEL\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":5229,"value":"viewof annee_debut = Inputs.select(range(1900, 2000), {\n value: 1923,\n label: \"Choisir l'année de départ\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":5001,"value":"md`## TABLEAU de DONNEES `","pinned":false,"hidden":false,"mode":"ojs"},{"id":6713,"value":"viewof table_actions = Inputs.table(data, {height:160, layout:'auto'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":5014,"value":"md`\n## GRAPHICS \n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":5798,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":5052,"value":"md`\n## DATA \n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":6796,"value":"db = DuckDBClient.of({\n meteofr: FileAttachment(\"meteo_france_selection_historique.parquet\"),\n //meteofr: FileAttachment(\"Meteo_france_selection_historique.csv\")\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":7000,"value":"data = db.query(`FROM meteofr \nSELECT nom_usuel as localite, \"DATE\" AS \"date\",\nyear(date) AS annee, month(date) AS mois, \nday(date) AS jour, dayofyear(date) AS jour_annee,\nIFNULL(TN, -99) AS tmin,\nIFNULL(TX, -99) AS tmax,\nIFNULL(DG, -99) AS dg,\nIFNULL(RR, -99) AS rr\nWHERE annee >= ? AND localite = ?`, [+annee_debut, localite])","pinned":true,"hidden":false,"mode":"ojs"},{"id":6865,"value":"liste_localite = db.query(\"select distinct NOM_USUEL from meteofr ORDER BY 1\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":5061,"value":"md`\n## DATA TREATMENT \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":7693,"value":"time_js1 = performance.now()","pinned":false,"hidden":false,"mode":"ojs"},{"id":5800,"value":"temp_max_annee_temporary = d3.rollups(\n data,\n (v) => d3.max(v, (d) => d.tmax),\n (d) => d.annee\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":5803,"value":"temp_max_annee = {\n const temp = temp_max_annee_temporary.map((row) => ({\n annee: row[0],\n temp: row[1]\n }));\n return temp.filter((d) => d.temp != -99);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5854,"value":"temp_min_annee_temporary = d3.rollups(\n data,\n (v) => d3.min(v, (d) => d.tmin),\n (d) => d.annee\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":5856,"value":"temp_min_annee = {\n const temp = temp_min_annee_temporary.map((row) => ({\n annee: row[0],\n temp: row[1]\n }));\n return temp.filter((d) => d.temp != -99);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":6356,"value":"precipitation_annee_temporary = d3.rollups(\n data,\n (v) => d3.sum(v, (d) => d.rr),\n (d) => d.annee\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":6360,"value":"precipitation_annee = {\n const parseDate = d3.timeParse(\"%Y-%m\");\n const temp = precipitation_annee_temporary.map((row) => ({\n annee: parseDate(row[0] + \"-06\"),\n nbjour: row[1]\n }));\n return temp.filter((d) => d.nbjour > 0);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5351,"value":"regression_gen_nbj = d3\n .regressionLinear()\n .x((d) => d.annee)\n .y((d) => d.nbjour)\n//.domain([1960, 2000])","pinned":false,"hidden":false,"mode":"ojs"},{"id":5879,"value":"regression_gen_temp = d3\n .regressionLinear()\n .x((d) => d.annee)\n .y((d) => d.temp)","pinned":false,"hidden":false,"mode":"ojs"},{"id":7208,"value":"annees = d3.range(\n d3.extent(data, (d) => d.annee)[0],\n d3.extent(data, (d) => d.annee)[1],\n 1\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":7243,"value":"minDate = d3.min(data, (d) => d.annee)","pinned":false,"hidden":false,"mode":"ojs"},{"id":5764,"value":"annee_fin = 2023","pinned":false,"hidden":false,"mode":"ojs"},{"id":7365,"value":"extent_date_temp_max_annee = d3.extent(temp_max_annee.map((d) => d.annee))","pinned":false,"hidden":false,"mode":"ojs"},{"id":5258,"value":"extend_tmax = d3.extent(data.filter((d) => d.tmax != -99).map((d) => d.tmax))","pinned":false,"hidden":false,"mode":"ojs"},{"id":5241,"value":"extend_tmin = d3.extent(data.filter((d) => d.tmin != -99).map((d) => d.tmin))","pinned":false,"hidden":false,"mode":"ojs"},{"id":6456,"value":"reg_min_tmax = +regression_gen_temp(temp_max_annee)[0][1].toFixed(1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":6460,"value":"reg_max_tmax = +regression_gen_temp(temp_max_annee)[1][1].toFixed(1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":6462,"value":"reg_tmax_diff = (reg_max_tmax - reg_min_tmax).toFixed(1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":6466,"value":"reg_tmax_delta_pourcent = (100 * (reg_max_tmax / reg_min_tmax - 1)).toFixed(\n 1\n) == 0\n ? (100 * (reg_max_tmax / reg_min_tmax - 1)).toFixed(1)\n : (100 * (reg_max_tmax / reg_min_tmax - 1)).toFixed(0)","pinned":false,"hidden":false,"mode":"ojs"},{"id":6478,"value":"reg_min_tmin = +regression_gen_temp(temp_min_annee)[0][1].toFixed(1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":6480,"value":"reg_max_tmin = +regression_gen_temp(temp_min_annee)[1][1].toFixed(1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":6482,"value":"reg_tmin_diff = (reg_max_tmin - reg_min_tmin).toFixed(1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":6486,"value":"reg_tmin_delta_pourcent = (100 * (reg_max_tmin / reg_min_tmin - 1)).toFixed(0)","pinned":false,"hidden":false,"mode":"ojs"},{"id":6450,"value":"--------------------------","pinned":false,"hidden":false,"mode":"md"},{"id":6350,"value":"--------------------------","pinned":false,"hidden":false,"mode":"md"},{"id":7358,"value":"extent_date_precipitation_annee = d3.extent(\n precipitation_annee.map((d) => d3.timeFormat(\"%Y\")(new Date(d.annee)))\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":6354,"value":"extend_nb_jour_precipitation = d3.extent(\n precipitation_annee.filter((d) => d.nbjour != -99).map((d) => d.nbjour)\n) //","pinned":false,"hidden":false,"mode":"ojs"},{"id":6392,"value":"reg_max_nb_jour_precipitation = +regression_gen_nbj(\n precipitation_annee\n)[0][1].toFixed(1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":6397,"value":"reg_min_nb_jour_precipitation = +regression_gen_nbj(\n precipitation_annee\n)[1][1].toFixed(1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":6400,"value":"reg_nbJ_precipitation_annee_diff = (\n reg_min_nb_jour_precipitation - reg_max_nb_jour_precipitation\n).toFixed(1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":6404,"value":"reg_nbJ_precipitation_delta_pourcent = (\n 100 *\n (reg_min_nb_jour_precipitation / reg_max_nb_jour_precipitation - 1)\n).toFixed(0)","pinned":false,"hidden":false,"mode":"ojs"},{"id":7490,"value":"--------------------------","pinned":false,"hidden":false,"mode":"md"},{"id":7459,"value":"function range(start, end) {\n var ans = [];\n for (let i = start; i <= end; i++) {\n ans.push(i.toString());\n }\n return ans;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5078,"value":"md`\n## IMPORT \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":5116,"value":"d3 = require(\"d3@6\", \"d3-regression\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":5146,"value":"md``","pinned":false,"hidden":false,"mode":"ojs"},{"id":5148,"value":"md``","pinned":false,"hidden":false,"mode":"ojs"},{"id":5150,"value":"md``","pinned":false,"hidden":false,"mode":"ojs"},{"id":2528,"value":"md``","pinned":false,"hidden":false,"mode":"ojs"},{"id":1862,"value":"md``","pinned":false,"hidden":false,"mode":"ojs"},{"id":2285,"value":"md``","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W30","stdlib":"1","titling":"auto"}