32:[] 30:{"title":"Mise en forme du compte des APU (2024-2025) issu de Mélodi","cells":[{"id":0,"value":"# Mise en forme du compte des APU (2024-2025) issu de Mélodi","pinned":false,"hidden":false,"mode":"md"},{"id":39,"value":"Ce petit *notebook* permet de mettre en forme les sorties brutes de l'API Mélodi. Les résultats sont en euros courants et correspondent aux secteurs institutionnels les plus similaires aux concepts de versants de la fonction publique. \n\n
","pinned":false,"hidden":false,"mode":"md"},{"id":20,"value":"html`\n

\n\n

\n Évolution par secteur (2024 → 2025)\n

\n ${viewof tab_evol}\n\n

\n Données en niveau\n

\n ${viewof tab_niveau}\n\n

\n Source : INSEE – API Mélodi
\n \n DD_CNA_AGREGATS – D11, secteurs S13/S1311/S1313/S1314, 2024-2025\n \n

\n\n

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":28,"value":"
\n## Code\n\nCode généré principalement par *Claude*","pinned":false,"hidden":false,"mode":"md"},{"id":10,"value":"viewof tab_evol = Inputs.table(evol.sort((a, b) => a.sector.localeCompare(b.sector)), {\n columns: [\"sector\", \"v2024\", \"v2025\", \"v2025_constant\", \"evol_pct_courant\", \"evol_pct_constant\"],\n header: {\n sector: \"Secteur\",\n v2024: \"2024 (M€)\",\n v2025: \"2025 courants (M€)\",\n evol_pct_courant: \"Évol. courants (%)\",\n v2025_constant: \"2025 constants (M€)\",\n evol_pct_constant: \"Évol. constants (%)\"\n },\n format: {\n sector: s => s === \"S13\"\n ? html`${s}`\n : html`${s}`,\n v2024: v => v?.toLocaleString(\"fr-FR\") ?? \"–\",\n v2025: v => v?.toLocaleString(\"fr-FR\") ?? \"–\",\n v2025_constant: v => v != null ? Math.round(v).toLocaleString(\"fr-FR\") : \"–\",\n evol_pct_courant: v => v != null ? (v > 0 ? \"+\" : \"\") + v.toFixed(2) + \" %\" : \"–\",\n evol_pct_constant: v => v != null ? (v > 0 ? \"+\" : \"\") + v.toFixed(2) + \" %\" : \"–\"\n }\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":26,"value":"// Cellule 3 : Affichage en tableau interactif\nviewof tab_niveau = Inputs.table(rows, {\n columns: [\"TIME_PERIOD\", \"REF_SECTOR\", \"REF_SECTOR_label\", \"STO\", \"value\", \"status\"],\n header: {\n TIME_PERIOD: \"Période\",\n REF_SECTOR: \"Secteur (code)\",\n REF_SECTOR_label: \"Secteur (libellé)\",\n STO: \"Indicateur\",\n value: \"Valeur (M€)\",\n status: \"Statut\"\n },\n format: {\n value: v => v != null ? v.toLocaleString(\"fr-FR\") : \"–\"\n },\n sort: \"TIME_PERIOD\",\n reverse: true\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":5,"value":"// Cellule 1 : Fetch des données\ndata = {\n const url = \"https://api.insee.fr/melodi/data/DD_CNA_AGREGATS?\" + new URLSearchParams([\n [\"REF_SECTOR\", \"S13\"],\n [\"REF_SECTOR\", \"S1311\"],\n [\"REF_SECTOR\", \"S1313\"],\n [\"REF_SECTOR\", \"S1314\"],\n [\"STO\", \"D11\"],\n [\"TIME_PERIOD\", \"2025\"],\n [\"TIME_PERIOD\", \"2024\"]\n ]);\n\n const response = await fetch(url, {\n headers: {\n \"Accept\": \"application/json\"\n }\n });\n\n if (!response.ok) throw new Error(`Erreur HTTP ${response.status}: ${response.statusText}`);\n return response.json();\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":7,"value":"// Cellule 2 corrigée\nrows = data.observations.map(obs => ({\n TIME_PERIOD: obs.dimensions.TIME_PERIOD,\n REF_SECTOR: obs.dimensions.REF_SECTOR,\n STO: obs.dimensions.STO,\n FREQ: obs.dimensions.FREQ,\n PRICES: obs.dimensions.PRICES,\n value: obs.measures.OBS_VALUE_NIVEAU?.value,\n status: obs.attributes.OBS_STATUS,\n status_fr: obs.attributes.OBS_STATUS_FR,\n unit_mult: obs.attributes.UNIT_MULT, // \"6\" = millions\n decimals: obs.attributes.DECIMALS\n}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":17,"value":"// Cellule evol mise à jour\nevol = {\n const INFLATION = 0.009; // 0.9%\n const by_sector = d3.group(rows, d => d.REF_SECTOR);\n\n return Array.from(by_sector, ([sector, obs]) => {\n const v2024 = obs.find(d => d.TIME_PERIOD === \"2024\")?.value;\n const v2025 = obs.find(d => d.TIME_PERIOD === \"2025\")?.value;\n\n // Euros courants\n const evol_abs_courant = (v2025 != null && v2024 != null) ? v2025 - v2024 : null;\n const evol_pct_courant = (evol_abs_courant != null && v2024 !== 0) ? (evol_abs_courant / v2024) * 100 : null;\n\n // Euros constants : on déflate v2025\n const v2025_constant = v2025 != null ? v2025 / (1 + INFLATION) : null;\n const evol_abs_constant = (v2025_constant != null && v2024 != null) ? v2025_constant - v2024 : null;\n const evol_pct_constant = (evol_abs_constant != null && v2024 !== 0) ? (evol_abs_constant / v2024) * 100 : null;\n\n return { sector, v2024, v2025, v2025_constant, evol_abs_courant, evol_pct_courant, evol_abs_constant, evol_pct_constant };\n });\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":12,"value":"data.structure","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}