29:null 2a:["$","title",null,{"children":"TP final (grupo 2) | MARIA SANZ BELLONI's Workspace | Observable"}] 2f:T63b,

UNIÓN POR LA PATRIA	LA LIBERTAD AVANZA	JUNTOS POR EL CAMBIO	HACEMOS POR NUESTRO PAIS	FIT - UNIDAD

UP	LLA	JxC	HACEMOS	FIT

30:T42e,vl({ data: { values: Dif }, mark: "bar", title: { text: "Votos en Segunda Vuelta Elecciones 2023: La libertad avanza vs Union por la patria", orient: "top", anchor: "start", font: "Benton Gothic Bold", fontSize: 20, color: "#000000" }, encoding: { x: { title: "Diferencia de votos", field: "diferencia_votos", scale: { domain: [-1100000, 1100000] } }, y: { title: "Provincia", field: "distrito_nombre", type: "nominal", sort: "x" }, color: { field: "agrupacion_nombre", type: "nominal", scale: { domain: ["LA LIBERTAD AVANZA", "UNION POR LA PATRIA"], range: [ d3.color("rgb(117, 59, 189)").hex(), d3.color("rgb(0, 156, 222)").hex() ] } } }, width: 500, height: 500, config: { axis: { labelFont: "Benton Gothic", labelFontSize: 13, labelFontWeight: "normal", titleFont: "Benton Gothic Bold, sans", titleFontSize: 13, titleFontWeight: "normal" } } })31:[{"id":"e99779c04f639a70f64fb46fddd02d9c713fad4bdda287bf99de5bc8499c3b1ae80acf1451204900968083f4e91ef65150a4139e403800375664f996fa83ac50","href":"https://static.observableusercontent.com/files/e99779c04f639a70f64fb46fddd02d9c713fad4bdda287bf99de5bc8499c3b1ae80acf1451204900968083f4e91ef65150a4139e403800375664f996fa83ac50","name":"porcentaje por provincia por tipo eleccion.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1699885731870.139,"size":22508},{"id":"ee1b27ac8bec65f6520e302227b430bd877353b93bf9f9504af6488e5898c4d1792e4d4aa8a8f4a8f9d952b23782c164da58109880822aee1f7ee21d7092cf2d","href":"https://static.observableusercontent.com/files/ee1b27ac8bec65f6520e302227b430bd877353b93bf9f9504af6488e5898c4d1792e4d4aa8a8f4a8f9d952b23782c164da58109880822aee1f7ee21d7092cf2d","name":"data.csv","type":"text/csv","lastModified":1699885880419.776,"size":12453},{"id":"1f07ea137d45cee8c70f77366454e84fd5cfce56a6fa233867a1ea9b401257bc030d92f386d591aba3e292d0df2e28f27d739a5321702ad30a457d5de2846138","href":"https://static.observableusercontent.com/files/1f07ea137d45cee8c70f77366454e84fd5cfce56a6fa233867a1ea9b401257bc030d92f386d591aba3e292d0df2e28f27d739a5321702ad30a457d5de2846138","name":"ResultadosElectoralesPaso23CABA.parquet","type":"application/octet-stream","lastModified":1698070971508.223,"size":5903431},{"id":"1fe25286dbe8d78a880675be41ace5b5f966f85a848dc662aa5300e45e9d1ee543f154fd1872acfe86eafe3d5a7f34ef5f523a81a7ab815e2cf7f12a2cf4b1dc","href":"https://static.observableusercontent.com/files/1fe25286dbe8d78a880675be41ace5b5f966f85a848dc662aa5300e45e9d1ee543f154fd1872acfe86eafe3d5a7f34ef5f523a81a7ab815e2cf7f12a2cf4b1dc","name":"GeneralesTierraDelFuego.parquet","type":"application/octet-stream","lastModified":1700682990668.404,"size":25096},{"id":"20b0ae4a71218d458f942af7186ff1a8ac6e4ea589cc811495c6c0d2ada9af1e6ed100677e43030a5d884704dad4e92a56098b71022f1478302606c6de5aaeb7","href":"https://static.observableusercontent.com/files/20b0ae4a71218d458f942af7186ff1a8ac6e4ea589cc811495c6c0d2ada9af1e6ed100677e43030a5d884704dad4e92a56098b71022f1478302606c6de5aaeb7","name":"ResultadosElectoralesTierraDelFuego@1.parquet","type":"application/octet-stream","lastModified":1700684489261.895,"size":122796},{"id":"7fe6d833e1cce19122afecfbcae5a65a0863e20f10a593615d45121006f33c8f76c1f48cbe0beae9ec969fc1cc9b0f0eb13d80ff59cf18e1a065eef1c044df41","href":"https://static.observableusercontent.com/files/7fe6d833e1cce19122afecfbcae5a65a0863e20f10a593615d45121006f33c8f76c1f48cbe0beae9ec969fc1cc9b0f0eb13d80ff59cf18e1a065eef1c044df41","name":"Elecciones_tierradelfuego.parquet","type":"application/octet-stream","lastModified":1700685773112.92,"size":13563},{"id":"0cfd12d82f164b57e0e8410dc40c975011a406f6af5fd67e63b9a3ad74440671e16c5ff778e614109655f18bb46e7189c2550abf3ef7cddf8bf2865d63282168","href":"https://static.observableusercontent.com/files/0cfd12d82f164b57e0e8410dc40c975011a406f6af5fd67e63b9a3ad74440671e16c5ff778e614109655f18bb46e7189c2550abf3ef7cddf8bf2865d63282168","name":"Balotajexdepto.parquet","type":"application/octet-stream","lastModified":1700701090781.59,"size":29972}] 2d:{"id":"4fd1fb0a57b7fe8a","slug":null,"title":"TP final (grupo 2)","thumbnail":"7d7c8ef3b7ddcbc0a3de772a154e2a910e177e5be05f102f95b83dd1346d5add","access_level":"public","create_time":"$D2023-10-23T13:47:19.990Z","update_time":"$D2023-11-29T18:34:42.043Z","view_time":null,"first_public_time":"$D2023-10-23T13:47:19.990Z","fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"192878ebfc74aef4","login":"maria-sanz-belloni-ws","name":"MARIA SANZ BELLONI's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/9a8e1a664a4b872571b8fc9ad57968c7e5cb294a2fe8f0e521c99b594299d9af","tier":"starter_2024"},"version":891,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"146b280a9d3740f7","login":"agustin-chaud","name":"Agustin Chaud","avatar_url":"https://avatars-next.observableusercontent.com/28de551589e241c9387ec689ed0d8b3877ad4a59486ba37abef4ee8b41d7ba40","tier":null},{"type":"individual","id":"92a0dcae069299fd","login":"micaela-banchik2","name":"MICAELA BANCHIK","avatar_url":"https://avatars-next.observableusercontent.com/7ad9a3f8b85039365e3355d994f48ffc0df50c77dc4df3b191f125a195b61f60","tier":null},{"type":"individual","id":"18cda2861cccb6b0","login":"maria-sanz-belloni","name":"MARIA SANZ BELLONI","avatar_url":"https://avatars-next.observableusercontent.com/9e25ca7fcc9ee97061f5b416be6265c4985dd617ce352767af341be3850e9a7a","tier":null},{"type":"individual","id":"c03f1f47fba01d23","login":"aaizemberg","name":"Ariel Aizemberg","avatar_url":"https://avatars-next.observableusercontent.com/ed6ddd5070826f572b9138f152d0a8186bfae935f311bbf11300e1fa71eae43c","tier":null}],"members":[{"type":"individual","id":"18cda2861cccb6b0","login":"maria-sanz-belloni","name":"MARIA SANZ BELLONI","avatar_url":"https://avatars-next.observableusercontent.com/9e25ca7fcc9ee97061f5b416be6265c4985dd617ce352767af341be3850e9a7a","tier":null,"role":"editor"},{"type":"team","id":"192878ebfc74aef4","login":"maria-sanz-belloni-ws","name":"MARIA SANZ BELLONI's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/9a8e1a664a4b872571b8fc9ad57968c7e5cb294a2fe8f0e521c99b594299d9af","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"TP final (grupo 2)","cells":[{"id":0,"value":"# TP final (grupo 2)\n\n## 2do cuatrimestre del 2023","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":5,"value":"1. Generar un notebook en Observable. \n2. Poner a todos los alumnos del grupo como editores de ese anotador.\n3. Agregar al docente como editor de dicho anotador.\n4. Cargar un conjunto de datos (uno o varios archivos en formato csv's o .tsv) de manera remota, los datos pueden salir del _github_ de Uds.\n5. Operaciones de data wrangling como: filtrado, generación de nuevas variables, join, etc. usando https://observablehq.com/@observablehq/data-wrangler o javascript.\n6. Realizar algunos gráficos exploratorios (EDA). \n7. Realizar una visualización interactiva, utilizando alguna de estas 3 librerías *Plot.js*, *vega-lite* o *D3* que responda alguna pregunta interesante planteada por Uds.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":17,"value":"## Grupo 2\n\n### Integrantes:\n1. [Banchik, Micaela](https://observablehq.com/@micaela-banchik2)\n2. [Chaud, Agustín](https://observablehq.com/@agustin-chaud)\n3. [Sanz Belloni, María](https://observablehq.com/@maria-sanz-belloni)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":105,"value":"colores = {\n let dict = {};\n dict[\"JUNTOS POR EL CAMBIO\"] = d3.color(\"rgb(254, 221, 0)\").hex();\n dict[\"UNION POR LA PATRIA\"] = d3.color(\"rgb(0, 156, 222)\").hex();\n dict[\"LA LIBERTAD AVANZA\"] = d3.color(\"rgb(117, 59, 189)\").hex();\n dict[\"FRENTE DE IZQUIERDA Y DE TRABAJADORES - UNIDAD\"] = d3\n .color(\"rgb(249, 84, 97)\")\n .hex();\n dict[\"HACEMOS POR NUESTRO PAIS\"] = d3.color(\"rgb(67, 72, 143)\").hex();\n return dict;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":107,"value":"$2f","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":219,"value":"viewof eleccion_tipo_menu = Inputs.select(\n Array.from(new Set(data.map((d) => d.eleccion_tipo))), // Use Set to get unique values\n {\n label: \"Seleccione un tipo de eleccion\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":884,"value":"votos_plot = Plot.plot({\n marginLeft: 250,\n marks: [\n Plot.barX(\n ProvinciasEleccionestotalvotos.filter(\n (d) => d.eleccion_tipo === eleccion_tipo_menu\n ),\n {\n x: \"votos\",\n y: \"provincia\",\n sort: \"agrupacion\",\n fill: (d) => colores[d.agrupacion],\n tip: true,\n title: (d) =>\n [\"Provincia: \" + d.provincia, d.agrupacion, d.votos].join(\"\\n\")\n }\n ),\n Plot.ruleX([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":204,"value":"porcentaje_plot = Plot.plot({\n marginLeft: 250,\n marks: [\n Plot.barX(\n porcentajes.filter((d) => d.eleccion_tipo === eleccion_tipo_menu),\n {\n x: \"porc_votos\",\n y: \"provincia\",\n sort: \"agrupacion\",\n fill: (d) => colores[d.agrupacion],\n tip: true,\n title: (d) =>\n [\n \"Provincia: \" + d.provincia,\n d.agrupacion,\n d.porc_votos.toFixed(1) + \"%\"\n ].join(\"\\n\")\n }\n ),\n Plot.ruleX([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":446,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":133,"value":"## Anexo ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":41,"value":"ResultadosCABA = DuckDBClient.of({\n caba: FileAttachment(\"ResultadosElectoralesPaso23CABA.parquet\")\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":141,"value":"Data CABA Completo Orignal PASO Presidente","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":34,"value":"CABAPasoParquetPresi = await FileAttachment(\"ResultadosElectoralesPaso23CABA.parquet\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":146,"value":"Data Votos Nacionales por Provincia con porcentaje (Paso y General juntas)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":115,"value":"workbook = FileAttachment(\n \"porcentaje por provincia por tipo eleccion.xlsx\"\n).xlsx()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":116,"value":"workbook.sheetNames","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":117,"value":"data = workbook.sheet(0, {\n headers: true\n // range: \"A1:J10\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":118,"value":"ProvinciasEleccionesPorc = data","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":877,"value":"select eleccion_tipo, provincia, agrupacion, porc_votos*100 as porc_votos from ProvinciasEleccionesPorc","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"porcentajes","database":"var:ProvinciasEleccionesPorc"},{"id":781,"value":"","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"var:data"},{"id":156,"value":"Data Votos Nacionales por Provincia con cantidad (Paso y General juntas)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":120,"value":"ProvinciasEleccionestotalvotos = await FileAttachment(\"data.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":221,"value":"Total votos Presidentes CABA","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":56,"value":"select agrupacion_nombre, format(sum(votos_cantidad),0)::INT as votos from caba where cargo_id=1 and votos_tipo='POSITIVO' group by agrupacion_nombre order by 2 desc limit 4\n","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"top5caba_presidente","database":"var:ResultadosCABA"},{"id":364,"value":"await FileAttachment(\"ResultadosElectoralesTierraDelFuego@1.parquet\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":383,"value":"SELECT * FROM \"ResultadosElectoralesTierraDelFuego\"","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"ResultadosElectoralesTierraDelFuego@1.parquet"},{"id":402,"value":"Plot.plot({\n marks: [\n Plot.auto(null, {})\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":403,"value":"","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"Elecciones_tierradelfuego.parquet"},{"id":405,"value":"data1 = await FileAttachment(\"Elecciones_tierradelfuego.parquet\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":415,"value":"SELECT format(sum(votos_cantidad),0)::INT as votos, seccion_nombre, eleccion_tipo, agrupacion_nombre from data1 group by seccion_nombre, eleccion_tipo, agrupacion_nombre","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"data2","database":"var:data1"},{"id":421,"value":"SELECT\n t1.max_votos,\n t1.seccion_nombre,\n t1.eleccion_tipo,\n t2.agrupacion_nombre\n \nFROM\n (\n SELECT\n MAX(votos) AS max_votos,\n seccion_nombre,\n eleccion_tipo\n FROM\n data2\n GROUP BY\n seccion_nombre, eleccion_tipo\n ) t1\nJOIN\n data2 t2 ON t1.seccion_nombre = t2.seccion_nombre AND t1.max_votos = t2.votos;","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"data3","database":"var:data2"},{"id":538,"value":"vl = require.alias({\n vega: \"vega@5.3.1\",\n \"vega-lite\": \"vega-lite@3.0.0\"\n})(\"vega-embed@4\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":448,"value":"balotaje = await FileAttachment(\"Balotajexdepto.parquet\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":450,"value":"select sum(votos) as votos, distrito_id, distrito_nombre, agrupacion_nombre from balotaje group by distrito_id, distrito_nombre, agrupacion_nombre","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"balotaje_prov","database":"var:balotaje"},{"id":459,"value":"balotaje_prov","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":525,"value":"SELECT\n distrito_nombre,\n SUM(CASE WHEN agrupacion_nombre = 'LA LIBERTAD AVANZA' THEN votos ELSE 0 END) -\n SUM(CASE WHEN agrupacion_nombre = 'UNION POR LA PATRIA' THEN votos ELSE 0 END) AS diferencia_votos\nFROM balotaje_prov\nGROUP BY distrito_nombre;\n","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"Diferencias","database":"var:balotaje_prov"},{"id":532,"value":"Diferencias","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":595,"value":"SELECT\n distrito_nombre,\n format(diferencia_votos)::INT as diferencia_votos,\n CASE\n WHEN diferencia_votos > 0 THEN 'LA LIBERTAD AVANZA'\n ELSE 'UNION POR LA PATRIA'\n END AS agrupacion_nombre\nFROM\n Diferencias\n order by \n diferencia_votos;\n","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"Dif","database":"var:Diferencias"},{"id":836,"value":"import {Pack} from \"@d3/pack-component\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W31","stdlib":"1","titling":"auto"}} 2e:"$2d:body"