3e:null 3f:["$","title",null,{"children":"MVTEC Workshop 1 - Election Analysis: Data Exploration | Joseph Ricafort | Observable"}] 45:T758, addedField= newData.map(d => ({ ...d, // copy all the existing properties of each object main_party: (() => { if (d.party.includes('JpC') || d.party.includes('JxC') || d.party.includes('JXCAT') || d.party.includes('JUNTS')) { return 'JxC'; } else if (d.party.includes('PSC') || d.party.includes('-PM') || d.party === "CP" || d.party.includes("-CP") || d.party.includes("- CP")) { return 'PSC'; } else if (d.party === "CiU" || d.party === "CIU" || d.party === "C.I.U" || d.party === "C.I.U.P." || d.party.includes('CIU') || d.party === "CD" || d.party === "CD'A" || d.party.includes('CD') || d.party.includes('CC-UCD') || d.party === "A" ) { return 'CIU'; } else if (d.party === "PP" || d.party === "P.P" || d.party.includes('AP-') || d.party === 'A.P.') { return 'PP'; } else if (d.party.includes('ERC') || d.party.includes('ESQUERRA') || d.party.includes('-AM') || d.party.includes('- AM') || d.party.includes('- Am')) { return 'ERC'; } else if (d.party.includes('CUP') || d.party === 'C.U.P.' || d.party.includes('AMUNT')) { return 'CUP'; } else if (d.party.includes('C\'s') || d.party.includes('C\'S') || d.party === 'Cs' || d.party === "UPyD") { return 'Ciutadans'; } else if (d.party === "VOX" || d.party === "PXC" || d.party == 'PxCat') { return 'VOX'; } else if (d.party === "PODEMOS" || d.party.includes('PEC') || d.party === 'COMU' || d.party.includes("BARCELONA EN CO") || d.party.includes("En comú") || d.party.includes("PODEMOS") || d.party === "PSUC" || d.party === "IC" || d.party.includes('IC') || d.party.includes('IC-') || d.party === "PCC" || d.party === "PCPC") { return 'Podem'; } else if (d.party === "PACMA") { return 'PACMA'; } else { return 'Others'; } })() // create a new property 'main_party' based on the includes() method }))46:T780, councilorsDifferencesByParty2= councilorsDifferencesByParty.map(d => ({ ...d, // copy all the existing properties of each object main_party: (() => { if (d.party.includes('JpC') || d.party.includes('JxC') || d.party.includes('JXCAT') || d.party.includes('JUNTS')) { return 'JxC'; } else if (d.party.includes('PSC') || d.party.includes('-PM') || d.party === "CP" || d.party.includes("-CP") || d.party.includes("- CP")) { return 'PSC'; } else if (d.party === "CiU" || d.party === "CIU" || d.party === "C.I.U" || d.party === "C.I.U.P." || d.party.includes('CIU') || d.party === "CD" || d.party === "CD'A" || d.party.includes('CD') || d.party.includes('CC-UCD') || d.party === "A" ) { return 'CIU'; } else if (d.party === "PP" || d.party === "P.P" || d.party.includes('AP-') || d.party === 'A.P.') { return 'PP'; } else if (d.party.includes('ERC') || d.party.includes('ESQUERRA') || d.party.includes('-AM') || d.party.includes('- AM') || d.party.includes('- Am')) { return 'ERC'; } else if (d.party.includes('CUP') || d.party === 'C.U.P.' || d.party.includes('AMUNT')) { return 'CUP'; } else if (d.party.includes('C\'s') || d.party.includes('C\'S') || d.party === 'Cs' || d.party === "UPyD") { return 'Ciutadans'; } else if (d.party === "VOX" || d.party === "PXC" || d.party == 'PxCat') { return 'VOX'; } else if (d.party === "PODEMOS" || d.party.includes('PEC') || d.party === 'COMU' || d.party.includes("BARCELONA EN CO") || d.party.includes("En comú") || d.party.includes("PODEMOS") || d.party === "PSUC" || d.party === "IC" || d.party.includes('IC') || d.party.includes('IC-') || d.party === "PCC" || d.party === "PCPC") { return 'Podem'; } else if (d.party === "PACMA") { return 'PACMA'; } else { return 'Others'; } })() // create a new property 'main_party' based on the includes() method }))47:T9aa,barChart = { const margin = ({top: 30, right: 20, bottom: 20, left: 40}); //margin object const width = 1200; //width of SVG in pixels const height = 400; //height of SVG in pixels const svg = d3.create("svg") .attr("width", width) .attr("height", height) .attr("viewBox",[0, 0, width, height]); const yScale = d3.scaleLinear() .domain([d3.min(filtered_results, d => d.votes), d3.max(filtered_results, d => d.votes)]) .range([height - margin.bottom, margin.top]); const xScale = d3.scaleBand() .domain(filtered_results.map(d=>d.main_party)) .range([margin.left, width - margin.right]) .padding(0.2); const selection = svg.selectAll('rect'); const colorScale = d3.scaleOrdinal() .domain(filtered_results.map(d => d.year)) .range(d3.schemeCategory10); selection.data(filtered_results) .join('rect') .attr('x', d => xScale(d.main_party)) .attr('y', d => d.votes < 0 ? yScale(0) : yScale(d.votes)) .attr('width', xScale.bandwidth()*0.9) .attr('height', d => Math.abs(yScale(0) - yScale(d.votes))) .style('fill', d => colorScale(d.year)) const xAxis = g => g .attr("transform", `translate(0,${height - margin.bottom})`) .call(d3.axisBottom(xScale) .ticks(width / 80) .tickSizeOuter(0) ) const yAxis = g => g .attr("transform", `translate(${margin.left},0)`) .call(d3.axisLeft(yScale)) .call(g => g.select(".domain").remove()) .call(g => g.select(".tick:last-of-type text").clone() .attr("x", -30) .attr("y", -20) .attr("text-anchor", "start") .text("Percentage change") ) svg.append("g") .call(xAxis); svg.append("g") .call(yAxis); const legend = svg.append('g') .attr('transform', `translate(${width - margin.right - 120}, ${margin.top})`); const legendItems = legend.selectAll('g') .data(colorScale.domain()) .join('g') .attr('transform', (d, i) => `translate(0, ${i * 20})`); legendItems.append('rect') .attr('width', 18) .attr('height', 18) .style('fill', colorScale); legendItems.append('text') .attr('x', 24) .attr('y', 9) .attr('dy', '0.35em') .text(d => d); legend.append('text') .attr('x', 0) .attr('y', -6) .attr('font-weight', 'bold') .text('Year'); return svg.node(); }48:[{"id":"e34b6486bdd683f280fd8992eaff92725a4900e6c1def895a0cb3fc828be3070e79b206175b2d05b67ffe6e1bfc1e1139f68b0999380dd34c7957b1634c343b7","href":"https://static.observableusercontent.com/files/e34b6486bdd683f280fd8992eaff92725a4900e6c1def895a0cb3fc828be3070e79b206175b2d05b67ffe6e1bfc1e1139f68b0999380dd34c7957b1634c343b7","name":"image.png","type":"image/png","lastModified":1681293347143.685,"size":31707},{"id":"2528b3a53401b7ca9b89f5111933016595423009089723ee559152bceaec6aaeebd8f390218af048b10b86a969761f364d26bdac96a7f0d229c5af1d68113076","href":"https://static.observableusercontent.com/files/2528b3a53401b7ca9b89f5111933016595423009089723ee559152bceaec6aaeebd8f390218af048b10b86a969761f364d26bdac96a7f0d229c5af1d68113076","name":"vq27-2ky2_version_217.csv","type":"text/csv","lastModified":1680601702552.536,"size":1584530}] 43:{"id":"7eb01f000c28ad2e","slug":null,"title":"MVTEC Workshop 1 - Election Analysis: Data Exploration","thumbnail":"5c6f7d2d2b4d9491ce3ed1b5d3838a6c1f8ee32a0579f12010699275ab6dfd9f","access_level":"public","create_time":"$D2023-04-02T14:58:09.593Z","update_time":"$D2023-04-16T08:15:29.627Z","view_time":null,"first_public_time":"$D2023-04-02T14:58:09.593Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"3d0b4e3ec7e42220","login":"josephricafort","name":"Joseph Ricafort","avatar_url":"https://avatars-next.observableusercontent.com/98de557fc6705b8929316825ea99a949993910a62c69bd71444237f50c5077af","tier":"starter_2024","bio":"See the world 🌏 through data and visuals 🚀","following":false},"version":696,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"13742c0768377f5c","login":"josephricafort","name":"Joseph Ricafort","avatar_url":"https://avatars-next.observableusercontent.com/98de557fc6705b8929316825ea99a949993910a62c69bd71444237f50c5077af","tier":null,"bio":"See the world 🌏 through data and visuals 🚀.","following":false}],"members":[{"type":"individual","id":"f516a9299bdd3a0b","login":"f516a9299bdd3a0b","name":"Anton Bardera","avatar_url":"https://avatars-next.observableusercontent.com/8fb3a7c84b2e63279eb0f25584b2e18c81ea98edf972c95dfa5420aeb55bd79c","tier":null,"role":"editor"},{"type":"individual","id":"13742c0768377f5c","login":"josephricafort","name":"Joseph Ricafort","avatar_url":"https://avatars-next.observableusercontent.com/98de557fc6705b8929316825ea99a949993910a62c69bd71444237f50c5077af","tier":null,"role":"editor"},{"type":"individual","id":"dfba2a4585880f39","login":"marinaroviraiboix","name":"Marina Rovira Boix","avatar_url":"https://avatars-next.observableusercontent.com/fa8e8a184bc84b385e7da333fee77207f16b5f927a6522905e41f0266f55ec2b","tier":null,"role":"editor"},{"type":"individual","id":"5f923798a401228f","login":"matto","name":"Matt Osborn","avatar_url":"https://avatars-next.observableusercontent.com/1fe6fb6273803470f49db6f86c1395aeea6e9626254561617127288f709874bd","tier":null,"role":"editor"},{"type":"individual","id":"f5f56b36d10ccd0b","login":"perikut","name":"pere roca ristol","avatar_url":"https://avatars-next.observableusercontent.com/56ba36bd2e20eeb52df640d17ea1083f66526c5beef466fdb3f528cc3ea0e0e0","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"MVTEC Workshop 1 - Election Analysis: Data Exploration","cells":[{"id":0,"value":"# MVTEC Workshop 1 - Election Analysis: Data Exploration","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":9,"value":"Analyze data from the most recent municipal elections in Catalonia hold in 2019 and other elections, looking at **key indicators** such as **voter turnout**, **party affiliations**, and **regional trends**.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":13,"value":"## Data previews","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":335,"value":"import { require } from \"@observablehq/stdlib\";","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"analiTransiRaw = FileAttachment(\"vq27-2ky2_version_217.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"analiTransiRaw","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"## About the data\n- Catalan elections results: https://eleccions.gencat.cat/ca/resultats-electorals/ \n- Shapefiles https://www.icgc.cat/Descarregues/Cartografia-vectorial/Seccions-censals\n- Transparencia Catalunya https://analisi.transparenciacatalunya.cat/Sector-P-blic/Eleccions-municipals-Vots/vq27-2ky2\n\n## Inspiration / Examples \n- RTVE: https://www.rtve.es/noticias/20220216/auge-vox-cambio-mapa-politico-derecha-pp-ciudadanos/2290631.shtml\n- Vilaweb: https://www.vilaweb.cat/noticies/mapa-partits-vot-eleccions-catalunya-2021/","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":36,"value":"newData = analiTransiRaw.map(d => { \n var newd = {\n councilors : +d[\"regidors\"],\n voted_proportion : +d[\"vots_1\"],\n votes : +d[\"vots\"],\n year : +d[\"any_eleccio\"], \n municipality_code : String(d[\"codi_ens\"].substring(0,5)),\n party : d[\"sigles_candidatura\"],\n municipality : d[\"municipi\"]\n}\n return newd;\n});\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":110,"value":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":455,"value":"// if the thing above works this should work too and add a new colum with the region. The main idea is to do a chart with the rotation for each main_party in each region\ndataset = addedField.map((d) => ({\n ...d,\n \n region: regions[d.municipality_code.toString().substring(0,1)] || \"Unkwon\",\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":459,"value":"filtered_results = dataset.filter(d => d.year >= 2015 && d.year <= 2019)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":687,"value":"DOM.download(serialize(filtered_results), null, \"Download JSON\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":594,"value":"filteredResults3= dataset.filter(d => d.year >= 2011 && d.year <= 2019)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":650,"value":"filtered5years= dataset.filter(d => d.year >= 2003 && d.year <= 2019)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":178,"value":"filtered5years","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":691,"value":"DOM.download(serialize(filtered5years), null, \"Download JSON\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":504,"value":"

Using party

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":282,"value":"//list of parties in all the municipalities\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":666,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":280,"value":"//difference of councilors by party and year\ncouncilorsDifferencesByParty = partyNames.map(partyName => {\n const year1Data = filtered5years.find(d => d.year === 2003 && d.party === partyName);\n const year2Data = filtered5years.find(d => d.year === 2007 && d.party === partyName);\n const year3Data = filtered5years.find(d => d.year === 2011 && d.party === partyName);\n const year4Data = filtered5years.find(d => d.year === 2015 && d.party === partyName);\n const year5Data = filtered5years.find(d => d.year === 2019 && d.party === partyName);\n const year1Votes = year1Data ? year1Data.councilors : 0;\n const year2Votes = year2Data ? year2Data.councilors : 0;\n const year3Votes = year3Data ? year3Data.councilors : 0;\n const year4Votes = year4Data ? year4Data.councilors : 0;\n const year5Votes = year5Data ? year5Data.councilors : 0;\n const difference = year5Votes - year1Votes;\n return { party: partyName, difference: difference }\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":303,"value":"//votes by party,municipality and year \nvoteByPartyAndYear = filtered_results.reduce((accumulator, current) => {\n let key = current.year + '_' + current.municipality + '_' + current.party;\n if (!accumulator[key]) {\n accumulator[key] = {year: current.year, municipality: current.municipality, party: current.party, votes: 0};\n }\n accumulator[key].votes += current.votes;\n return accumulator;\n}, {});\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":314,"value":"//councilors by party, municipality and year\ncouncilorByPartyAndYear = filtered_results.reduce((accumulator, current) => {\n let key = current.year + '_' + current.municipality + '_' + current.party;\n if (!accumulator[key]) {\n accumulator[key] = {year: current.year, municipality: current.municipality, party: current.party, councilors: 0};\n }\n accumulator[key].councilors += current.councilors;\n return accumulator;\n}, {});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":316,"value":"votesByPartyAndYear = Object.keys(voteByPartyAndYear).map(key => voteByPartyAndYear[key]);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":321,"value":"councilorsByPartyAndYear = Object.keys(councilorByPartyAndYear).map(key => councilorByPartyAndYear[key]);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":332,"value":"//to calculate the votes difference by municipality per year \ngroupedVotes = filtered_results.reduce((acc, curr) => {\n const key = curr.municipality + curr.party;\n const yearDiff = curr.year - (acc[key]?.year || 0);\n acc[key] = {\n municipality: curr.municipality,\n party: curr.party,\n year: curr.year,\n vote_diff: yearDiff === 4 ? curr.votes - acc[key].votes : null,\n votes: curr.votes,\n };\n return acc;\n}, {});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":353,"value":"resultVotesDifference = Object.values(groupedVotes);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":359,"value":"//to calculate the councilors difference by municipality per year \ngroupedCouncilors = filtered5years.reduce((acc, curr) => {\n const key = curr.municipality + curr.party;\n const yearDiff = curr.year - (acc[key]?.year || 0);\n acc[key] = {\n municipality: curr.municipality,\n party: curr.party,\n year: curr.year,\n councilor_diff: yearDiff === 4 ? curr.councilors - acc[key].councilors : null,\n councilors: curr.councilors,\n };\n return acc;\n}, {});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":361,"value":"resultCouncilorsDifference = Object.values(groupedCouncilors);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":506,"value":"

Using main party

2 years

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":520,"value":"Plot.plot({\n marks: [\n Plot.dot(councilorsDifferencesByMainParty, {x:\"party\", y:\"difference\", fill:\"blue\", opacity:0.2, xlim: 200})\n ] \n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":530,"value":"$47","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":588,"value":"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":527,"value":"//difference of votes by municipality, main party and year\nvoteDifferencesByMainParty = MainPartyNames.map(partyName => {\n const year1Data = filtered_results.find(d => d.year === 2015 && d.party === partyName);\n const year2Data = filtered_results.find(d => d.year === 2019 && d.party === partyName);\n const year1Votes = year1Data ? year1Data.votes : 0;\n const year2Votes = year2Data ? year2Data.votes : 0;\n const difference = year2Votes - year1Votes;\n return { party: partyName, difference: difference };\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":380,"value":"//to calculate the councilors difference by municipality per year (main parties) \ngroupedCouncilorsMainParty = filtered_results.reduce((acc, curr) => {\n const key = curr.municipality + curr.main_party;\n const yearDiff = curr.year - (acc[key]?.year || 0);\n acc[key] = {\n municipality: curr.municipality,\n main_party: curr.main_party,\n year: curr.year,\n councilor_diff: yearDiff === 4 ? curr.councilors - acc[key].councilors : null,\n councilors: curr.councilors,\n };\n return acc;\n}, {});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":524,"value":"// difference of councilors by main party, municipality and year\ncouncilorsDifferencesByMainParty = MainPartyNames.map(partyName => {\n const year1Data = filtered_results.find(d => d.year === 2015 && d.party === partyName );\n const year2Data = filtered_results.find(d => d.year === 2019 && d.party === partyName);\n const year1Votes = year1Data ? year1Data.councilors : 0;\n const year2Votes = year2Data ? year2Data.councilors : 0;\n const difference = year2Votes - year1Votes;\n return { party: partyName, difference: difference };\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":383,"value":"resultCouncilorsDifferenceMainParties = Object.values(groupedCouncilorsMainParty);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":637,"value":"//to calculate the councilors difference by region per year (main parties) \ngroupedCouncilorsMainPartyRegion = filtered_results.reduce((acc, curr) => {\n const key = curr.region + curr.main_party;\n const yearDiff = curr.year - (acc[key]?.year || 0);\n acc[key] = {\n region: curr.region,\n main_party: curr.main_party,\n year: curr.year,\n councilor_diff: yearDiff === 4 ? curr.councilors - acc[key].councilors : null,\n councilors: curr.councilors,\n };\n return acc;\n}, {});","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":570,"value":"Plot.plot({\n marks: [\n Plot.barY(resultCouncilorsDifferenceMainParties, {x: \"main_party\", y: \"councilor_diff\", sort: {x: \"y\", reverse: true}}),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":600,"value":"

Using party

Using main party

2 years

3 years

Calculations

Other charts