27:null 28:["$","title",null,{"children":"Dia 18 — Challenge setmanal! | Laia's | Observable"}] 2d:Tb1f,## Context de les dades

- **Cobertura temàtica i estructura** Les dades disponibles cobreixen àmbits clau com **demografia**, **lloguer d’habitatge** i **turisme**. Tot i això, presenten limitacions de qualitat, interoperabilitat i documentació. - **Dificultats d’interoperabilitat** Les fonts no comparteixen un **identificador comú**, fet que complica l'encreuament entre conjunts. La normalització dels noms de municipi és necessària. - **Metadades i metodologia insuficients** No es detalla la metodologia per obtenir valors ni hi ha definicions clares sobre les variables més sensibles. - **Valors buits** Abunden les cel·les sense dades, especialment en els conjunts municipals i en el registre d’establiments. Això pot afectar fortament la consistència de qualsevol anàlisi. - **Granularitat i abast temporal** - `Cens` → anys disponibles: **2022** i **2024** - `Lloguer` → dades entre 2007 i 2025, cal filtrar **2024 i gener-desembre** - `Establiments turístics` → no inclouen data, només una situació **estàtica** i sense garanties d’actualització ## Limitacions específiques

- **Cens i població** - Valors duplicats o buits en alguns municipis - Només s’utilitzarà l’any **2024** per coherència - **Preus del lloguer** - Trams de preus textuals (ex. `> 600 €`) → limitats per a l’anàlisi estadística Farem ús de la variable `Renda mitjana` - Presència de valors buits o nuls en molts municipis - **Establiments turístics** - Sense data d’actualització ni camp de data → no apte per a anàlisi temporal - Possible presència d’establiments inactius o tancats ## Riscos ètics i privacitat

- **Dades identificatives** presents als registres turístics: - `Nom`, `Adreça`, `CIF`, `Referència cadastral` - Poden comprometre la privacitat. - **Risc de reidentificació** - Especialment en municipis amb pocs habitatges d'ús turístic llogats ## Preparació òptima per a l’anàlisi

- **Filtrar dades**: - `lloguer` → any 2024, període `gener-desembre` - `cens` → any 2024 - **Normalitzar** noms de municipi - **Agregació** - Comptar establiments per municipi - **Aplicació** - Fer una **foto fixa municipal** (2024) ## Límit analític i d’ús

- No apte per a **anàlisi temporal ni evolutiva** - Les mancances metodològiques poden conduir a **conclusions errònies** - Sense documentació ni codificació comuna, cal fer **neteja, validació i agregació** per garantir fiabilitat
2e:T4c4,majTitol = nom => { if (!nom) return ""; const MINUSCULES = [ "de", "del", "la", "el", "i", "e", "les", "al", "a", "dels", "els", "en", "des", "per", "amb", "d'", "l'" ]; return nom .toLowerCase() .split(" ") .map((paraula, i) => { // Tractament especial per apòstrofs dins paraula if (paraula.includes("'")) { const [pre, post] = paraula.split("'"); // "d'" i "l'" minúscules si no és la primera paraula const preOK = (i === 0 || !MINUSCULES.includes(pre + "'")) ? pre.charAt(0).toUpperCase() + pre.slice(1) : pre; const postOK = post.charAt(0).toUpperCase() + post.slice(1); return preOK + "'" + postOK; } // Tractament per guions if (paraula.includes("-")) { return paraula .split("-") .map((part, j) => (i === 0 && j === 0) || !MINUSCULES.includes(part) ? part.charAt(0).toUpperCase() + part.slice(1) : part ) .join("-"); } // Normal return (i === 0 || !MINUSCULES.includes(paraula)) ? paraula.charAt(0).toUpperCase() + paraula.slice(1) : paraula; }) .join(" "); } 2f:T527,Plot.plot({ width: 900, height: 600, marginLeft: 80, marginTop: 80, grid: true, x: { label: "Cens (habitants, log)", type: "log", domain: [210, 2500000] }, y: { label: "Preu mitjà lloguer (€)", tickFormat: formatCat,}, color: { label: "Província" }, size: { label: "Establiments turístics" }, marks: [ Plot.dot( dadesPerGrafic.filter(d => d.cens >= 100 && d.cens < 7000000), { x: "cens", y: "preuLloguerMostrat", fill: "provincia", r: d => Math.sqrt(d["Establiments"]) * 1.5 + 2, stroke: "white", strokeWidth: 0.5, fillOpacity: 0.5, title: "tooltip", tip: true } ), Plot.crosshair( dadesPerGrafic.filter(d => d.cens >= 100 && d.cens < 7000000), { x: "cens", y: "preuLloguerMostrat" }, ), Plot.tip( ["**Sant Vicenç de Montalt**\nMunicipi amb preus de lloguer més alts de Catalunya 💰 "], { x: puntSantVicenç.cens, y: puntSantVicenç.preuLloguerMostrat, anchor: "bottom-left", dy: -10 }), Plot.dot([puntSantVicenç], { x: puntSantVicenç.cens, y: puntSantVicenç.preuLloguerMostrat, stroke: "YellowGreen", strokeDasharray: 4, strokeWidth: 2, r: 13, }) ] })30:T5cf,{ if (form.preuMin >= form.preuMax) { return html`

⚠️ El preu mínim ha de ser inferior al preu màxim.

`; } if (dadesFiltrades.length === 0) { return html`

⚠️ Cap municipi compleix els criteris seleccionats.

`; } // Escales adaptatives const censExtent = d3.extent(dadesFiltrades, d => d.cens); const lloguerExtent = d3.extent(dadesFiltrades, d => d.preuLloguer); return Plot.plot({ width: 900, height: 600, marginLeft: 80, marginTop: 80, grid: true, x: { label: "Cens (habitants, log)", type: "log", domain: [Math.max(censExtent[0], 100), censExtent[1]] }, y: { label: "Preu mitjà lloguer (€)", domain: [Math.floor(lloguerExtent[0] / 50) * 50, Math.ceil(lloguerExtent[1] / 50) * 50], }, color: { legend: true, label: "Província" }, size: { label: "Establiments turístics" }, marks: [ Plot.dot(dadesFiltrades, { x: "cens", y: "preuLloguer", fill: "provincia", r: d => Math.sqrt(d.numEstabliments) * 1.5 + 2, stroke: "white", strokeWidth: 0.5, fillOpacity: 0.5, title: d => `${majTitol(d.municipi)} Cens: ${d.cens.toLocaleString("ca")} Lloguer: ${d.preuLloguer.toFixed(2)} € Establiments: ${d.numEstabliments}`, tip: true }), Plot.crosshair(dadesFiltrades, { x: "cens", y: "preuLloguer" }) ] }); } 31:T68f,{ if (form.preuMin >= form.preuMax) { return html`

⚠️ El preu mínim ha de ser inferior al preu màxim.

`; } if (dadesFiltrades.length === 0) { return html`

⚠️ Cap municipi compleix els criteris seleccionats.

`; } const censExtent = d3.extent(dadesFiltrades, d => d.cens); const lloguerExtent = d3.extent(dadesFiltrades, d => d.preuLloguer); return Plot.plot({ width: 1000, height: 1000, marginLeft: 80, marginTop: 80, grid: true, facet: { data: dadesFiltrades, y: "marcaTuristica", marginRight: 150, }, x: { label: "Cens (habitants, log)", type: "log", domain: [Math.max(censExtent[0], 100), censExtent[1]] }, y: { label: "Preu mitjà lloguer (€)", domain: [Math.floor(lloguerExtent[0] / 50) * 50, Math.ceil(lloguerExtent[1] / 50) * 50] }, color: { label: "Província", legend: true }, size: { label: "Establiments turístics" }, marks: [ Plot.dot(dadesFiltrades, { facet: "auto", x: "cens", y: "preuLloguer", fill: "provincia", r: d => Math.sqrt(d.numEstabliments) * 1.5 + 2, stroke: "white", strokeWidth: 0.5, fillOpacity: 0.5, title: d => `${majTitol(d.municipi)} Cens: ${d.cens.toLocaleString("ca")} Lloguer: ${d.preuLloguer.toFixed(2)} € Establiments: ${d.numEstabliments}`, tip: true }), Plot.crosshair(dadesFiltrades, { facet: "auto", x: "cens", y: "preuLloguer" }), Plot.frame({ facet: "auto", stroke: "gray", strokeWidth: 1 }) ] }); } 32:[{"id":"5f1503ccbc79b410d991af18cd7511b3bf0ef3ca8954782a2844e5c6ee75dc228603c66862bde8cb93c5156ae830dd1a8d601ca23f99e7de4921c0ad969076b9","href":"https://static.observableusercontent.com/files/5f1503ccbc79b410d991af18cd7511b3bf0ef3ca8954782a2844e5c6ee75dc228603c66862bde8cb93c5156ae830dd1a8d601ca23f99e7de4921c0ad969076b9","name":"Dades_generals_dels_ens_locals_de_Catalunya_20250718.csv","type":"text/csv","lastModified":1752921708060.952,"size":4636853},{"id":"4bd8c96167d7e4ae4ab1d6ff5545aa63731be8ac877eaec5c1f652d687e9aaee94fea79bc1d82809484bdf930470cd520a8c1e446e92ec6f8702a3868cc2f987","href":"https://static.observableusercontent.com/files/4bd8c96167d7e4ae4ab1d6ff5545aa63731be8ac877eaec5c1f652d687e9aaee94fea79bc1d82809484bdf930470cd520a8c1e446e92ec6f8702a3868cc2f987","name":"Preu_mitj__del_lloguer_d_habitatges_per_municipi_20250718.csv","type":"text/csv","lastModified":1752921702286.904,"size":3129377},{"id":"28285b71848e338a85ccb0d35cd38971ce0ad179af99b632a5a11aba443d5abbbb22537ecfa756d4e27d0407f53e4900b74feb10755fbf91801e432defba6760","href":"https://static.observableusercontent.com/files/28285b71848e338a85ccb0d35cd38971ce0ad179af99b632a5a11aba443d5abbbb22537ecfa756d4e27d0407f53e4900b74feb10755fbf91801e432defba6760","name":"Establiments_d_allotjament_tur_stic_inscrits_al_Registre_de_Turisme_de_Catalunya_20250718.csv","type":"text/csv","lastModified":1752921751778.581,"size":29433069}] 2b:{"id":"b9fcbda1f1146bbf","slug":null,"title":"Dia 18 — Challenge setmanal!","thumbnail":"ea990ee96be05b318d1332e2043d013a165da26ff2b2dbf1c5b62b45c05641f6","access_level":"public","create_time":"$D2025-07-19T10:40:50.514Z","update_time":"$D2025-07-21T21:29:57.262Z","view_time":null,"first_public_time":"$D2025-07-21T17:14:42.598Z","has_unpublished_edits":null,"fork":{"id":"65025c46f83dc6db","slug":null,"title":"Dia 18 — Challenge setmanal!","owner":{"id":"4bce174a609780f2","login":"fndvit","name":"Visualization for Transparency Foundation (Fundació ViT)"}},"stars":0,"starred":false,"owner":{"type":"team","id":"d731b32f3012da30","login":"laias","name":"Laia's","avatar_url":"https://avatars-next.observableusercontent.com/be24205c7ed3d33bf874278d51cb377c2d0246a6222168762353f5f1973f8a76","tier":"starter_2024"},"version":1373,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"3e5bb3ad8262f4d8","login":"laia2","name":"Laia","avatar_url":"https://avatars-next.observableusercontent.com/9582edf1c51ba105ebf719ebab95f698e1e0902126e3b0aad3431a2320f9bafa","tier":null}],"members":[{"type":"individual","id":"3e5bb3ad8262f4d8","login":"laia2","name":"Laia","avatar_url":"https://avatars-next.observableusercontent.com/9582edf1c51ba105ebf719ebab95f698e1e0902126e3b0aad3431a2320f9bafa","tier":null,"role":"editor"},{"type":"team","id":"d731b32f3012da30","login":"laias","name":"Laia's","avatar_url":"https://avatars-next.observableusercontent.com/be24205c7ed3d33bf874278d51cb377c2d0246a6222168762353f5f1973f8a76","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":3,"collection":null,"type":"notebook","body":{"title":"Dia 18 — Challenge setmanal!","cells":[{"id":0,"value":"# Dia 18 — Challenge setmanal!","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"### EXERCICI\n🎯 Objectiu: descarregar i analitzar de manera crítica diversos conjunts de dades del portal de transparència i crear-ne una representació gràfica amb la llibreria Plot, que permeti a l'usuari el filtratge de dades i analitzar-ne relacions\n\nDades: \n- [Establiments d’allotjament turístic inscrits al Registre de Turisme de Catalunya](https://analisi.transparenciacatalunya.cat/Turisme/Establiments-d-allotjament-tur-stic-inscrits-al-Re/t2h3-cgys/about_data).\n- [Preu mitjà del lloguer d’habitatges per municipi](https://analisi.transparenciacatalunya.cat/Habitatge/Preu-mitj-del-lloguer-d-habitatges-per-municipi/qww9-bvhh/about_data)\n- [Dades generals dels ens locals de Catalunya](https://analisi.transparenciacatalunya.cat/Sector-P-blic/Dades-generals-dels-ens-locals-de-Catalunya/6nei-4b44/about_data)\n\n*Documentació*: \n- [Arrays en JS](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array)\n- [referència a la llibreria Plot](https://observablehq.com/plot/what-is-plot)\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":645,"value":"
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":643,"value":"# PAS 1\n#### Crea un fork d'aquest notebook, descarrega del portal de transparència els diferents fitxers, penja'ls al notebook i mostra'ls\n

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":35,"value":"# Les Dades\n\n#### Dades obertes:\n- [Establiments d’allotjament turístic inscrits al Registre de Turisme de Catalunya](https://analisi.transparenciacatalunya.cat/Turisme/Establiments-d-allotjament-tur-stic-inscrits-al-Re/t2h3-cgys/about_data)\n- [Preu mitjà del lloguer d’habitatges per municipi](https://analisi.transparenciacatalunya.cat/Habitatge/Preu-mitj-del-lloguer-d-habitatges-per-municipi/qww9-bvhh/about_data)\n- [Dades generals dels ens locals de Catalunya](https://analisi.transparenciacatalunya.cat/Sector-P-blic/Dades-generals-dels-ens-locals-de-Catalunya/6nei-4b44/about_data)\n\n

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":127,"value":"dades_generals = await FileAttachment(\"Dades_generals_dels_ens_locals_de_Catalunya_20250718.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"dades_generals","database":"$undefined"},{"id":128,"value":"preus_lloguer = await FileAttachment(\"Preu_mitj__del_lloguer_d_habitatges_per_municipi_20250718.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"preus_lloguer","database":"$undefined"},{"id":129,"value":"establiments = await FileAttachment(\"Establiments_d_allotjament_tur_stic_inscrits_al_Registre_de_Turisme_de_Catalunya_20250718.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"establiments","database":"$undefined"},{"id":649,"value":"# PAS 2\n#### Fes un comentari crític de les dades i digues si creus que tenen alguna mancança.\n

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1074,"value":"$2d","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1142,"value":"
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":651,"value":"# PAS 3\n#### Crea una array a on les files corresponguin a municipis i hi guardeu informació respecte el nombre d'establiments turístics, el preu mitjà del lloguer d'habitatges, el cens i la província.\n

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":426,"value":"#### Data Prep\n

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":136,"value":"//Funció per normalitzar noms de municipi\nnormalitzaNom = nom =>\n nom?.toLowerCase()\n .normalize(\"NFD\").replace(/[\\u0300-\\u036f]/g, \"\") // treu accents\n .replace(/\\s+/g, \" \") // un sol espai\n .trim();","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":138,"value":"//Agrupació d’establiments per municipi (amb nom normalitzat)\nestablimentsAgrupatPerMunicipi = Object.groupBy(establiments, d => normalitzaNom(d[\"Municipi\"]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"//comptatge d’establiments per municipi\ntotalEstablimentsPerMunicipi = Object.fromEntries(\n Object.entries(establimentsAgrupatPerMunicipi).map(([municipi, estabs]) => [\n municipi,\n estabs.length\n ])\n)\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":143,"value":"//Filtrat i lookup dels preus de lloguer (amb nom normalitzat)\npreusLloguerFiltrat = preus_lloguer.filter(\n d => d.Any === 2024 && d[\"Període\"] === \"gener-desembre\"\n)\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":145,"value":"preusLloguerPerMunicipi = Object.fromEntries(\n preusLloguerFiltrat.map(d => [normalitzaNom(d[\"Nom territori\"]), +d[\"Renda\"]])\n)\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":147,"value":"//Filtrat de dades generals per 2024 i lookup cens/província (amb nom normalitzat)\ndadesGenerals2024 = dades_generals.filter(d => d.ANY_CENS === 2024)\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":149,"value":"// Filtrem bé només els NOMTIPUS === \"Municipis\"\ncensProvPerMunicipi = Object.fromEntries(\n dadesGenerals2024\n .filter(d => d[\"NOMTIPUS\"] === \"Municipis\")\n .map(d => [normalitzaNom(d[\"MUNICIPI\"]), {\n cens: +d[\"CENS\"],\n provincia: d[\"PROVINCIA\"]\n }])\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":151,"value":"//Llista de municipis únics (normalitzats)\nmunicipisUnics = Array.from\n(new Set(\n dadesGenerals2024\n .map(d => normalitzaNom(d[\"MUNICIPI\"]))\n .filter(nom => nom) // <-- treu cadenes buides!\n )\n)\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":432,"value":"

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":434,"value":"#### Array on les files corresponen a municipis i hi guardem informació respecte el nombre d'establiments turístics, el preu mitjà del lloguer d'habitatges, el cens i la província.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":153,"value":"//Unificació final (join per municipi normalitzat)\ndadesUnificades = municipisUnics.map(municipi => ({\n municipi,\n cens: censProvPerMunicipi[municipi]?.cens ?? null,\n provincia: censProvPerMunicipi[municipi]?.provincia ?? null,\n preuLloguer: preusLloguerPerMunicipi[municipi] ?? null,\n numEstabliments: totalEstablimentsPerMunicipi[municipi] ?? 0\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":437,"value":"#### A Catalunya hi tenim 947 Municipis i l'array que tenim coincideix amb aquests 947 objectes, però en molts municipis hi ha valors nuls del Cens o del Preu del lloguer. Eliminiem els municipis que tenen algun valor nul en aquestes dues variables:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":155,"value":"//Neteja final (municipis amb cens i preu de lloguer vàlids)\ndadesFinalsNetes = dadesUnificades.filter(d =>\n d.cens != null &&\n d.cens > 0 &&\n d.preuLloguer != null &&\n !isNaN(d.preuLloguer)\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":459,"value":"#### Fem una funció que ens torni a escriure els noms dels municipis amb les majúscules corresponents i l'apliquem al nostre array:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":159,"value":"$2e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":448,"value":"dadesFinalsNetesMunicipi = dadesFinalsNetes.map(d => ({\n ...d,\n municipi: majTitol(d.municipi)\n}))\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":661,"value":"# PAS 4\n#### Crea una visualització general de les dades amb un tooltip que permeti comprendre millor les dades.\n

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":655,"value":"#### Preparem un nou array amb el tooltip que desitgem que surti al nostre gràfic:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":157,"value":"dadesPerGrafic = dadesFinalsNetesMunicipi.map(d => ({\n ...d,\n preuLloguerOr: d.preuLloguer,\n preuLloguerMostrat: d.preuLloguer,\n Establiments: d.numEstabliments,\n tooltip: `${d.municipi}\nProvíncia: ${d.provincia}\nCens: ${formatCat(d.cens)}\nPreu lloguer: ${formatCat(d.preuLloguer)} €\nEstabliments: ${formatCat(d.numEstabliments)}`\n}))\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":657,"value":"#### Creem una funció per a la transformació dels valors de les escales dels gràfics que farem en format català (milers amb punts i decimals amb comes):","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":557,"value":"function formatCat(n) {\n const valor = Number(n);\n if (isNaN(valor)) return \"No disponible\";\n return valor\n .toFixed(0)\n .replace(\".\", \",\")\n .replace(/\\B(?=(\\d{3})+(?!\\d))/g, \".\");\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":428,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":507,"value":"### Enfoc Visual

\n\nRecorrerem als boxplots per grup de província i, posteriorment, a la visualització directa de la distribució dels valors individuals mitjançant barcode i scatterplot, utilitzant —en aquest darrer cas— una escala logarítmica per fer visibles possibles patrons ocults.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":665,"value":"
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":514,"value":"# Boxplot

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":189,"value":"## Variabilitat del preu del lloguer als municipis catalans per província l'any 2024
\nAquest boxplot mostra la mitjana del preu del lloguer per província, l’interval interquartílic, els valors atípics (outliers) i la dispersió interna de cada província segons la posició dels municipis dins del conjunt","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":565,"value":"Plot.plot({\n width: 800,\n height: 600,\n marginLeft: 60,\n x: { label: \"\",\n padding: 0.5},\n y: { \n label: \"Preu mitjà del lloguer (€)\", \n tickFormat: formatCat,\n ticks: [0, 100, 200, 300, 400, 500, 600, 700, 800, 900, 1000, 1100, 1200, 1300, 1400, 1500, 1600]\n },\n color: { label: \"Província\" },\n marks: [\n Plot.boxY(dadesFinalsNetes, {\n x: \"provincia\",\n y: \"preuLloguer\",\n fill: \"provincia\",\n opacity: 0.3\n }),\n Plot.dot(dadesPerGrafic, {\n x: \"provincia\",\n y: \"preuLloguer\",\n fill: \"provincia\",\n opacity: 0.2,\n title: d =>\n `${d.municipi}\nPreu lloguer: ${formatCat(d.preuLloguer)} €`,\n tip: true\n }),\n Plot.crosshairX(dadesPerGrafic, {\n x: \"provincia\",\n y: \"preuLloguer\",\n stroke: \"provincia\",\n tip: true\n })\n ]\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":520,"value":"# Barcode plot\n

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":193,"value":"## Visualització detallada del preu mitjà del lloguer per municipi l'any 2024\n\nAquest gràfic permet observar la concentració de municipis en determinats intervals de preu, sense dependre d’agrupacions predefinides. Mostra la variabilitat real de les dades d’una manera clara i intuïtiva.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":198,"value":"Plot.plot({\n width: 900,\n height: 150,\n marginLeft: 60,\n marginTop:20,\n marginBottom: 40,\n x: { label: \"Preu mitjà del lloguer (€)\",\n tickFormat: formatCat},\n y: { axis: null },\n color: { legend: true, label: \"Província\" },\n marks: [\n Plot.ruleX(dadesPerGraficBarcode, {\n x: \"preuLloguer\",\n stroke: \"Província\",\n strokeOpacity: 0.6,\n title: d =>\n `${d.Municipi}\nProvíncia: ${d.Província}\nCens: ${d[\"Cens\"]}\nPreu lloguer: ${formatCat(d.preuLloguer)} €,\nEstabliments: ${d[\"Establiments\"]}`,\n tip: true\n})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":583,"value":"#### Separem per provincies:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":200,"value":"Plot.plot({\n width: 900,\n height: 180,\n marginLeft: 60,\n facet: { \n data: dadesPerGraficBarcode, \n y: \"Província\",\n label: null,\n },\n x: { label: \"Preu mitjà del lloguer (€)\",\n tickFormat: formatCat},\n\n marks: [\n Plot.frame({\n stroke: \"#ccc\",\n strokeOpacity: 0.8,\n strokeWidth: 1.2\n}),\n Plot.ruleX(dadesPerGraficBarcode, {\n x: \"preuLloguer\",\n stroke: \"Província\",\n strokeOpacity: 0.8,\n title: d =>\n `${d.Municipi}\nProvíncia: ${d.Província}\nCens: ${d[\"Cens\"].toLocaleString(\"ca\")}\nPreu lloguer: ${formatCat(d.preuLloguer)} €,\nEstabliments: ${d[\"Establiments\"].toLocaleString(\"ca\")}`,\n tip: true\n })\n ]\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":195,"value":"dadesPerGraficBarcode = dadesFinalsNetesMunicipi.map(d => ({\n Municipi: d.municipi,\n \"Província\": d.provincia, // Ús únic\n \"Cens\": d.cens,\n \"Preu mitjà lloguer (€)\": d.preuLloguer,\n \"Establiments\": d.numEstabliments,\n preuLloguer: d.preuLloguer\n}))\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":578,"value":"# Scatterplot

\n## Relació entre el cens municipal, el preu mitjà del lloguer i el nombre d’establiments turístics a Catalunya l'any 2024\n Aquest scatterplot permet analitzar la relació entre la mida de la població (cens) i el preu mitjà del lloguer a cada municipi de Catalunya.\n \n
\n\nLa posició de cada punt reflecteix aquesta relació, mentre que la mida del punt indica el **nombre d’establiments turístics**.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":173,"value":"Plot.plot({\n width:800,\n height: 600,\n marginLeft:90,\n grid: true,\n x: {\n label: \"Cens (habitants)\",\n tickFormat: formatCat\n },\n y: {\n label: \"Preu de lloguer (€)\",\n tickFormat: formatCat,\n },\n color: {\n legend: true,\n domain: [\"Barcelona\", \"Girona\", \"Lleida\", \"Tarragona\"]\n \n },\n size: {\n label: \"Nombre d’establiments\"\n },\n marks: [\n Plot.dot(dadesPerGrafic, {\n x: \"cens\",\n y: \"preuLloguerMostrat\",\n fill: \"provincia\", // color segons província\n r: d => radiEstabliments(d.numEstabliments),\n stroke: \"white\",\n strokeWidth: 0.5,\n fillOpacity: 0.5,\n title: \"tooltip\",\n tip: true\n })\n ]\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1229,"value":"Plot.plot({\n width: 840,\n height: 160,\n marginTop: 20,\n marginLeft: 700,\n marginRight: 50,\n marginBottom: 5,\n x: { axis: false },\n y: { axis: false },\n marks: [\n Plot.dot(dadesLlegenda, {\n x: \"x\",\n y: \"y\",\n r: \"r\",\n fill: \"#999\",\n fillOpacity: 0.7,\n }),\n Plot.text(dadesLlegenda.map(d => ({\n ...d,\n\n })), {\n x: \"x\",\n y: \"y\",\n text: \"text\",\n textAnchor: \"start\",\n dx: 14,\n fontSize: 11,\n fill: \"#333\"\n })\n ]\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":591,"value":"
Com que el cens municipal presenta valors molt dispars —amb diferències molt grans entre la capital i la resta de municipis—, la majoria de punts queden visualment concentrats en la zona aprop de l’eix Y. Per tal de representar millor aquesta variabilitat i detectar possibles patrons o agrupacions, s’aplica una **escala logarítmica** que permet expandir els valors baixos i comprimir els valors extrems.\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":175,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":177,"value":"puntSantVicenç = dadesPerGrafic.find(\n d => d.municipi.toLowerCase().normalize(\"NFD\").replace(/[\\u0300-\\u036f]/g, \"\") === \"sant vicenc de montalt\"\n)\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1214,"value":"radiEstabliments = n => Math.sqrt(n) * 1.5 + 2\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1227,"value":"dadesLlegenda = {\n const valors = [15000, 3000, 1000, 400, 100, 25, 5]; // de gran a petit\n const xBase = 1_600_000; // zona dreta del gràfic\n const yBase = 1600; // zona alta\n\n return valors.map((n, i) => {\n const r = radiEstabliments(n);\n return {\n x: xBase,\n y: yBase - i * 80,\n r,\n text: n.toLocaleString(\"ca\") + \" \" + \"HUT\"\n };\n });\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1225,"value":"valorsEstabliments = [5, 25, 100, 400, 1000, 3000, 11252]\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":586,"value":"# PAS 5\n#### Crea una visualització que mostri les dades en diferents facets.

\n
\n\"Facetem\" l'Scatterplot per Província:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":206,"value":"Plot.plot({\n width: 950,\n height: 600,\n grid: true,\n marginLeft: 60,\n marginTop: 60,\n marginRight: 60,\n facet: { data: dadesPerGrafic, y: \"provincia\", label: null},\n x: { label: \"Cens (habitants, log)\", type: \"log\", domain: [210, 2500000] },\n y: { label: \"Preu mitjà lloguer (€)\" },\n marks: [\n Plot.frame({stroke: \"#ccc\",\n strokeOpacity: 1,\n strokeWidth: 1.3}),\n Plot.dot(dadesPerGrafic, {\n x: \"cens\",\n y: \"preuLloguerMostrat\",\n fill: \"provincia\",\n r: d => Math.sqrt(d[\"Establiments\"]) * 1.5 + 2,\n stroke: \"white\",\n strokeWidth: 0.5,\n fillOpacity: 0.5,\n title: \"tooltip\", \n tip: true\n })\n ]\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1351,"value":"Plot.plot({\n width: 840,\n height: 160,\n marginTop: 20,\n marginLeft: 700,\n marginRight: 50,\n marginBottom: 5,\n x: { axis: false },\n y: { axis: false },\n marks: [\n Plot.dot(dadesLlegenda, {\n x: \"x\",\n y: \"y\",\n r: \"r\",\n fill: \"#999\",\n fillOpacity: 0.7,\n }),\n Plot.text(dadesLlegenda.map(d => ({\n ...d,\n\n })), {\n x: \"x\",\n y: \"y\",\n text: \"text\",\n textAnchor: \"start\",\n dx: 14,\n fontSize: 11,\n fill: \"#333\"\n })\n ]\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":238,"value":"# PAS 6\n#### Crea un formulari amb diferents opcions de filtratge de les dades i fes un gràfic que permeti visualitzar les dades filtrades segons aquests criteris\n

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":996,"value":"#### Data Prep\n

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":844,"value":"preuMin = Math.floor(d3.min(dadesFinalsNetesMunicipi, d => d.preuLloguer) / 50) * 50\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":846,"value":"preuMax = Math.ceil(d3.max(dadesFinalsNetesMunicipi, d => d.preuLloguer) / 50) * 50\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1034,"value":"function normalitzaMarca(nom) {\n return nom?.trim().toLowerCase()\n .replace(\"l'ebre\", \"l'ebre\") // assegura apòstrofs consistents\n .replace(/\\s+/g, \" \") // espais múltiples → 1 espai\n .replace(/\\b\\w/g, l => l.toUpperCase()); // Capitalitza cada paraula\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":815,"value":"conteigMarques = Object.fromEntries(\n dadesFinalsAmbMarca.reduce((acc, d) => {\n const marca = d.marcaTuristica || \"No assignada\";\n const trobat = acc.find(([m]) => m === marca);\n if (trobat) {\n trobat[1]++;\n } else {\n acc.push([marca, 1]);\n }\n return acc;\n }, [])\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1031,"value":"dadesFinalsAmbMarca = dadesFinalsNetesMunicipi.map(d => {\n const estab = establiments.find(e =>\n normalitzaNom(e[\"Municipi\"]) === normalitzaNom(d.municipi)\n );\n const marcaBruta = estab ? estab[\"Marca turística\"] : \"No assignada\";\n const marcaTuristica = normalitzaMarca(marcaBruta);\n \n return {\n ...d,\n marcaTuristica\n };\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":887,"value":"dadesFiltrades = dadesFinalsAmbMarca.filter(d => {\n \n if (d.preuLloguer < form.preuMin || d.preuLloguer > form.preuMax) return false;\n\n switch (form.tramCens) {\n case \"< 1.000\": if (d.cens >= 1000) return false; break;\n case \"1.000 – 10.000\": if (d.cens < 1000 || d.cens > 10000) return false; break;\n case \"10.000 – 100.000\": if (d.cens < 10000 || d.cens > 100000) return false; break;\n case \"> 100.000\": if (d.cens <= 100000) return false; break;\n }\n\n const e = d.numEstabliments ?? 0;\n switch (form.tramEstabliments) {\n case \"Cap\": return e === 0;\n case \"1-10\": return e >= 1 && e <= 10;\n case \"11-50\": return e > 10 && e <= 50;\n case \"Més de 50\": return e > 50;\n }\n\n // ✅ Filtra per marques seleccionades\n if (!form.marquesTuristiques.includes(d.marcaTuristica)) return false;\n\n return true;\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":703,"value":"dadesFiltradesTrams = dadesFiltrades.map(d => ({\n ...d,\n tramEstabliments:\n d.numEstabliments === 0\n ? \"Cap\"\n : d.numEstabliments <= 10\n ? \"1-10\"\n : d.numEstabliments <= 50\n ? \"11-50\"\n : \"Més de 50\"\n}))\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":709,"value":"

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1090,"value":"# Formulari i filtratge de les dades

\n Introduïm la variable \"Marca turística\"\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":885,"value":"viewof form = Inputs.form({\n // Rang de preus\n preuMin: Inputs.range([preuMin, preuMax], {\n step: 50,\n value: preuMin,\n label: \"Preu mínim (€)\"\n }),\n preuMax: Inputs.range([preuMin, preuMax], {\n step: 50,\n value: preuMax,\n label: \"Preu màxim (€)\"\n }),\n\n // Trams de cens\n tramCens: Inputs.select(\n [\"Tots\", \"< 1.000\", \"1.000 – 10.000\", \"10.000 – 100.000\", \"> 100.000\"],\n { label: \"Tram de població (cens)\" }\n ),\n\n // Trams d’establiments turístics\n tramEstabliments: Inputs.select(\n [\"Tots\", \"Cap\", \"1-10\", \"11-50\", \"Més de 50\"],\n { label: \"Nombre d’establiments turístics\" }\n ),\n\n // 🔍 Marques turístiques\n marquesTuristiques: Inputs.checkbox(\n Array.from(new Set(dadesFinalsAmbMarca.map(d => d.marcaTuristica))).sort(),\n {\n label: \"Marca turística\",\n value: Array.from(new Set(dadesFinalsAmbMarca.map(d => d.marcaTuristica)))\n }\n )\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":412,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1354,"value":"Plot.plot({\n width: 840,\n height: 160,\n marginTop: 20,\n marginLeft: 700,\n marginRight: 50,\n marginBottom: 5,\n x: { axis: false },\n y: { axis: false },\n marks: [\n Plot.dot(dadesLlegenda, {\n x: \"x\",\n y: \"y\",\n r: \"r\",\n fill: \"#999\",\n fillOpacity: 0.7,\n }),\n Plot.text(dadesLlegenda.map(d => ({\n ...d,\n\n })), {\n x: \"x\",\n y: \"y\",\n text: \"text\",\n textAnchor: \"start\",\n dx: 14,\n fontSize: 11,\n fill: \"#333\"\n })\n ]\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1022,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1135,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"}],"files":"$W32","stdlib":"1","titling":"auto"}} 2c:"$2b:body"