2e:null 2f:["$","title",null,{"children":"Colombianos rechazados por vía aérea en México (2019-2024) | Fer Aguirre | Observable"}] 34:T43c,*Última actualización: 22/02/2025* ## Acerca de este notebook - Los datos sobre aerolíneas contienen información de 2019 a 2024. ## Fuente de datos - Instituto Nacional de Migración (INM) a través de dos solicitudes de acceso a la información con folios *330020324001228* y *330020325000053*. - [Unidad de Política Migratoria, Registro e Identidad de Personas (UPMRIP)](https://portales.segob.gob.mx/es/PoliticaMigratoria/Direccion_de_Estadistica#est) ## Glosario: - **Eventos:** Las cifras se refieren a eventos debido a que una misma persona pudo haber entrado al país en más de una ocasión o fue rechazada más de una vez. - **Porcentaje de rechazos:** El porcentaje permite evaluar la proporción de eventos de rechazo en comparación con el total de eventos de ingreso. El porcentaje de rechazos se calcula utilizando la siguiente fórmula: ${tex`\text{Porcentaje de Rechazos} = \left( \frac{\text{Eventos de Rechazo}}{\text{Eventos de Rechazo + Eventos de Ingreso}} \right) \times 100`}

35:T4fb,Plot.plot({ width:width, marginRight: 40, marginLeft: 40, height:600, title: "Colombianos rechazados por año", color: { legend: true, domain: ["Subtotal anual de acuerdo a la UPMRIP¹", "Subtotal anual de acuerdo a solicitud de acceso a la información al INM²"], range: ["#4000ff", "#ff6200"] }, subtitle: "De 2019 a 2024", caption: "Gráfico: Fernanda Aguirre Ruíz • Fuente: Datos de la UPMRIP de 2019 a 2024¹, Datos obtenidos mediante solicitud de acceso a la información al INM de 2019 a 2024²", x:{ label:"Año", ticks:[...new Set(dataFlujoAnual.map(item => item.año))].length}, y:{zero:true, tickFormat:"s", label:"Rechazados", grid: true,}, marks: [ Plot.lineY(dataFlujoAnual.filter(d => d.fuente == "UPMRIP"), {x: "año", y: "total_rechazos", stroke: "#4000ff"}), Plot.lineY(dataFlujoAnual.filter(d => d.fuente == "solicitud al INM"), {x: "año", y: "total_rechazos", stroke: "#ff6200"}), Plot.dot(dataFlujoAnual.filter(d => d.fuente == "UPMRIP").filter(d => d.fuente == "UPMRIP"), {x: "año", y: "total_rechazos", stroke: "#4000ff", fill: "#4000ff"}), Plot.dot(dataFlujoAnual.filter(d => d.fuente == "solicitud al INM"), {x: "año", y: "total_rechazos", stroke: "#ff6200", fill: "#ff6200"}), ] });36:T57a,htl.html`

${Plot.plot({ width: 500, height: 300, marginLeft: 100, insetTop: 20, color: { legend: true }, x: { tickFormat: "d", label: "Año"}, y: { tickFormat: "s", zero: true, label: "Eventos", grid: true }, title: "Rechazos a colombianos vía aérea en México", marks: [ Plot.lineY(dataFlujoAnual.filter(d => d.fuente == "solicitud al INM"), { x: d => +d.año, y: d => +d.total_rechazos, stroke: "#0003ff", }), Plot.dot(dataFlujoAnual.filter(d => d.fuente == "solicitud al INM"), { x: d => +d.año, y: d => +d.total_rechazos, fill: "#0003ff", tip: true }), ] })} ${Plot.plot({ width: 500, height: 300, marginLeft: 100, insetTop: 20, color: { legend: true }, x: { tickFormat: "d", label: "Año"}, y: { tickFormat: "p", zero: true, label: "Porcentaje", grid: true }, title: "Porcentaje de rechazo a colombianos vía aérea en México", marks: [ Plot.lineY(dataFlujoAnual.filter(d => d.fuente == "solicitud al INM"), { x: d => +d.año, y: d => +d.porcentaje_rechazo, stroke: "#0003ff", }), Plot.dot(dataFlujoAnual.filter(d => d.fuente == "solicitud al INM"), { x: d => +d.año, y: d => +d.porcentaje_rechazo, fill: "#0003ff", tip: true }), ] })}

`37:T558,Plot.plot({ width:width, marginRight: 40, height:600, title: "Porcentaje mensual de rechazados", color: { type: "categorical", domain: dataMesesSolicitud.año, scheme: "YlOrRd", legend: true, }, subtitle: "De 2019 a 2024", caption: "Gráfico: Fernanda Aguirre Ruíz • Fuente: Datos obtenidos mediante solicitud de acceso a la información al INM", x:{ tickFormat: d => { const monthNames = ["Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre"]; return monthNames[new Date(2024, d - 1).getMonth()]; }, label:"Mes", ticks:Array.from(d3.group(dataMesesSolicitud, d => d.mes)).length}, y:{zero:true, tickFormat:"p", label:"Porcentaje", grid: true,}, marks: [ Plot.lineY( dataMesesSolicitud, { x: "mes", y:"porcentaje_rechazo", stroke: "año", }), Plot.dot( dataMesesSolicitud, { x: "mes", y: "porcentaje_rechazo", fill: "año", }), Plot.text( dataMesesSolicitud, Plot.selectMaxY({ x: "mes", y: "porcentaje_rechazo", text: d => d.año.toString(), dy: -10, fill: "año", stroke: "white", strokeWidth: 5, }) ) ], });38:T431,Plot.plot({ grid: true, inset: 10, width: width, height: 250, x: { tickFormat: "d", label: "Año", ticks: yearsRange.length}, y: { tickFormat: "s", zero: true, label: "Rechazos", grid: true }, title: "Aerolíneas donde viajan más colombianos rechazados en México", subtitle: "Desagregados por sexo", color: { legend: true, domain: ["hombre", "mujer", "total"], range: ["#7d2fff", "#ea7500", "#b8b8b8"] }, facet: { data: aerolineasRechazadosFiltered, x: "aerolínea", label: "Aerolínea" }, marks: [ Plot.frame(), Plot.line(aerolineasRechazadosFiltered, {x: "año", y: "hombre", stroke: "#7d2fff"}), Plot.dot(aerolineasRechazadosFiltered, {x: "año", y: "hombre", stroke: "#7d2fff", fill: "white", tip:false}), Plot.line(aerolineasRechazadosFiltered, {x: "año", y: "mujer", stroke: "#ea7500"}), Plot.dot(aerolineasRechazadosFiltered, {x: "año", y: "mujer", stroke: "#ea7500", fill: "white", tip:false}), Plot.line(aerolineasRechazadosFiltered, {x: "año", y: "total", stroke: "#b8b8b8"}), ] })39:T4ee,htl.html`

${d3.groups(groupedRechazosIngresos, (d) => d.aerolínea) .sort((a, b) => d3.descending(a[1].length, b[1].length)) .map(([caption, groupedRechazosIngresos]) => htl.html`

${Plot.plot({ grid: true, inset: 10, width: 250, height: 250, marginTop: 20, marginBottom: 40, insetTop: 20, x: { tickFormat: "d", label: "Año"}, y: { tickFormat: "p", zero: true, label: "Porcentaje de rechazos", grid: true }, marks: [ Plot.frame(), Plot.line(groupedRechazosIngresos, {x: "año", y: "per_rechazos", stroke: "#ff0000"}), Plot.dot(groupedRechazosIngresos, {x: "año", y: "per_rechazos", stroke: "#ff0000", fill: "white"}), Plot.text(groupedRechazosIngresos, Plot.selectMaxY( {x: "año", y: "per_rechazos", text: d=> Math.round(d.per_rechazos * 100) + "%", dy: -10, fill: "#606060"}) ), ] })}

${caption}

` )}

`3a:T5d2,htl.html`

hombre mujer

${d3.groups(dataRechazos, (d) => d.aerolínea) .sort((a, b) => d3.descending(a[1].length, b[1].length)) .map(([caption, dataRechazos]) => htl.html`

${Plot.plot({ grid: true, inset: 10, width: 250, height: 250, marginTop: 20, marginBottom: 40, x: { tickFormat: "d", label: "Año"}, y: { tickFormat: "s", zero: true, label: "Rechazos", grid: true }, marks: [ Plot.frame(), Plot.line(dataRechazos, {x: "año", y: "hombre", stroke: "#7d2fff"}), Plot.dot(dataRechazos, {x: "año", y: "hombre", stroke: "#7d2fff", fill: "white", tip:true}), Plot.line(dataRechazos, {x: "año", y: "mujer", stroke: "#ea7500"}), Plot.dot(dataRechazos, {x: "año", y: "mujer", stroke: "#ea7500", fill: "white", tip:true}), ] })}

${caption}

` )}

`3b:T44f,dataFlujoAnual = Object.values( [...dataMesesCol.map(d => ({ año: d.año, mes: d.mes, total_ingresos: d.eventos_de_entrada, total_rechazos: d.rechazados, total_eventos: d.total_de_eventos, fuente: "UPMRIP" })), ...dataMesesSolicitud.map(d => ({ año: d.año, mes: d.mes, total_ingresos: d.eventos_de_entrada, total_rechazos: d.rechazados, total_eventos: d.total_de_eventos, fuente: "solicitud al INM" }))] .reduce((acc, curr) => { const key = `${curr.año}-${curr.fuente}`; if (!acc[key]) { acc[key] = { año: curr.año, fuente: curr.fuente, total_ingresos: 0, total_rechazos: 0, total_eventos: 0 }; } acc[key].total_ingresos += curr.total_ingresos; acc[key].total_rechazos += curr.total_rechazos; acc[key].total_eventos += curr.total_eventos; return acc; }, {}) ).map(item => ({ ...item, porcentaje_rechazo: item.total_eventos > 0 ? item.total_rechazos / item.total_eventos : 0 // Avoid division by zero })).sort((a, b) => b.año - a.año);3c:[] 32:{"id":"9254e367bac6cbe1","slug":"colombianos-rechazados-por-via-aerea-en-mexico","title":"Colombianos rechazados por vía aérea en México (2019-2024)","thumbnail":"f65c05248d7cc23392244a3c5e316e5252139ce058233092319f25a12120d2e4","access_level":"public","create_time":"$D2024-11-23T14:52:29.835Z","update_time":"$D2025-02-22T17:48:07.774Z","view_time":null,"first_public_time":"$D2024-11-23T14:52:29.835Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"789e6ba9bbf11803","login":"fer-aguirre","name":"Fer Aguirre","avatar_url":"https://avatars-next.observableusercontent.com/f531eb1aface10aa40ec00b9dd17bd5b8a04204b1bccb07e46041ecf2a566a97","tier":"starter_2024"},"version":2376,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"11c69ba1437427e2","login":"fer-aguirre","name":"Fernanda Aguirre Ruíz","avatar_url":"https://avatars-next.observableusercontent.com/f531eb1aface10aa40ec00b9dd17bd5b8a04204b1bccb07e46041ecf2a566a97","tier":null}],"members":[{"type":"individual","id":"11c69ba1437427e2","login":"fer-aguirre","name":"Fernanda Aguirre Ruíz","avatar_url":"https://avatars-next.observableusercontent.com/f531eb1aface10aa40ec00b9dd17bd5b8a04204b1bccb07e46041ecf2a566a97","tier":null,"role":"editor"},{"type":"team","id":"789e6ba9bbf11803","login":"fer-aguirre","name":"Fer Aguirre","avatar_url":"https://avatars-next.observableusercontent.com/f531eb1aface10aa40ec00b9dd17bd5b8a04204b1bccb07e46041ecf2a566a97","tier":"starter_2024","role":"viewer"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"fe97b49b307e5aea","slug":"migracion-en-mexico","title":"Migración en México","owner":{"id":"789e6ba9bbf11803","login":"fer-aguirre","name":"Fer Aguirre"}},"type":"notebook","body":{"title":"Colombianos rechazados por vía aérea en México (2019-2024)","cells":[{"id":0,"value":"# Colombianos rechazados por vía aérea en México (2019-2024)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":9,"value":"$34","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1658,"value":"## Comparación de fuentes de datos\n\nEste dashboard cuenta con dos fuentes de información: los datos públicos de la Unidad de Política Migratoria, Registro e Identidad de Personas (UPMRIP) y datos obtenidos mediante solicitudes de acceso a la información al Instituto Nacional de Migración (INM). \n\nAmbas bases de datos contienen información de 2019 a 2024. Sin embargo, los datos de las solicitudes contienen información desagragada sobre las aerolíneas donde viajaban los colombianos. Por esta razón, se utilizaron los datos de las solicitudes con el fin de tener la fuente más detallada.\n\nA continuación un gráfico comparativo con el número de rechazados por año de acuerdo a cada fuente.\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1645,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":708,"value":"
\n\n## Historial de rechazos a colombianos en aeropuertos de México\n \n- A partir del año **2020**, comenzó a aumentar el porcentaje de colombianos que eran rechazados en aeropuertos de México.\n\n- Desde entonces el porcentaje de rechazos ha **incrementado** cada año.\n\n- De 2021 a 2022, el porcentaje de rechazos tuvo un aumento interanual del **67%**. \n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":947,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1419,"value":"
\n\n

\n\n## Flujo mensual\n\n- A excepción de enero, todos los meses del 2024 han marcado **máximos históricos** del porcentaje mensual de rechazados.\n- **Febrero de 2024** ha sido el mes con el porcentaje de rechazo más alto. Durante ese mes, 1 de cada 10 colombianos que viajó a México por vía aérea, fue rechazado.\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1524,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":970,"value":"
\n\n

\n\n## Rechazos por aerolínea\n\n- De acuerdo a los datos, las aerolíneas que concentran la mayoría de los casos son:\n\n${renderTermsMarkdown(topAerolineas)}\n\n- **Avianca** es la aerolínea que concentra la mayoría de los casos.\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":417,"value":"Plot.plot({\n width:width,\n height:600,\n color: { legend: true },\n title: \"Colombianos rechazados de acuerdo a la aerolínea en que viajaban\",\n x:{tickFormat:\"d\", label:\"Año\", ticks: yearsRange.length},\n y: {\n grid: true,\n label: \"Rechazos\",\n tickFormat:\"s\",\n },\n marks: [\n Plot.areaY(\n groupedAerolineasAcumuladas,\n {x:\"año\", y: \"total\", z:\"aerolínea\", fill:\"aerolínea\", offset:null}\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":490,"value":"
\n\n

\n\n## Pocentaje de rechazos por aerolínea \n\nEl porcentaje de rechazos se calculó con relación al número de ingresos de colombianos con esa misma aerolínea. Para analizar esto en detalle, a continuación se muestran las aerolíneas mencionadas previamente: \n\n- Durante los primeros 7 meses de 2024, **Viva Aerobus** obtuvo el mayor porcentaje de rechazos con el 11%. Dicho en otras palabras, **1 de cada 10** colombianos que viajó en esta aerolínea fue rechazado por autoridades del INM.\n- Después de Viva Aerobus, **Avianca** y **Volaris** obtuvieron un porcentaje de rechazo del 7% en este mismo periodo.\n- En general, estas 6 aerolíneas han ido **aumentando gradualmente** el porcentaje de rechazos a colombianos.\n- Algo que caracteriza a la mayoría de estas aerolíneas es que suelen ser de **bajo costo**.\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":604,"value":"Plot.plot({\n grid: true,\n inset: 10,\n width: width,\n height: 250,\n insetTop: 20,\n marginTop: 50,\n marginBottom: 50,\n x: { tickFormat: \"d\", label: \"Año\", ticks: yearsRange.length},\n y: { tickFormat: \"p\", zero: true, label: \"Porcentaje de rechazos\", grid: true },\n title: \"Porcentaje anual de colombianos rechazados por aerolínea\",\n subtitle: \"De 2019 a julio de 2024\",\n facet: {\n data: groupedAerolineasFiltered,\n x: \"aerolínea\",\n label: \"Aerolínea\"\n },\n marks: [\n Plot.frame(),\n Plot.line(groupedAerolineasFiltered, {x: \"año\", y: \"per_rechazos\", stroke: \"#ff0000\"}),\n Plot.dot(groupedAerolineasFiltered, {x: \"año\", y: \"per_rechazos\", stroke: \"#ff0000\", fill: \"white\", tip:false}),\n Plot.text(groupedAerolineasFiltered, {x: \"año\", y: \"per_rechazos\", text: d=> Math.round(d.per_rechazos * 100) + \"%\", dy: -10, fill: \"#606060\"}),\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":219,"value":"
\n\n

\n\n## Perfil de las personas rechazadas\n\n- Los **hombres** son los que reciben más rechazos sin importar la aerolínea en la que viajen.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":192,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1281,"value":"
\n\n

\n\n## Grupos etarios de los rechazados\n\n- Tanto en hombres como en mujeres, el grupo etario que recibe más rechazos es de **20 a 29** años.\n- El segundo grupo más rechazado es de **30 a 39** años.\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1189,"value":"Plot.plot({\n width: width,\n height: 400,\n marginLeft: 100,\n insetTop: 50,\n title: \"Grupos etarios de hombres rechazados por año\",\n x: {\n axis: null,\n domain: dataGruposEtariosFiltered.año,\n },\n y: {\n grid: true,\n tickFormat: \"s\"\n },\n color: {\n domain: dataGruposEtariosFiltered.grupo_etario,\n scheme: \"spectral\",\n legend: true\n },\n fx: {\n domain: d3.groupSort(dataGruposEtariosFiltered, d => -d.hombre, d => d.año),\n label: null,\n tickSize: 6\n },\n facet: {\n data: dataGruposEtariosFiltered,\n x: \"año\"\n },\n marks: [\n Plot.barY(dataGruposEtariosFiltered, {x: \"grupo_etario\", y: \"hombre\", fill: \"grupo_etario\", title: \"grupo_etario\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1269,"value":"Plot.plot({\n width: width,\n height: 400,\n marginLeft: 100,\n insetTop: 50,\n title: \"Grupos etarios de mujeres rechazadas por año\",\n x: {\n axis: null,\n domain: dataGruposEtariosFiltered.año,\n },\n y: {\n grid: true,\n tickFormat: \"s\"\n },\n color: {\n domain: dataGruposEtariosFiltered.grupo_etario,\n scheme: \"magma\",\n legend: true\n },\n fx: {\n domain: d3.groupSort(dataGruposEtariosFiltered, d => -d.mujer, d => d.año),\n label: null,\n tickSize: 6\n },\n facet: {\n data: dataGruposEtariosFiltered,\n x: \"año\"\n },\n marks: [\n Plot.barY(dataGruposEtariosFiltered, {x: \"grupo_etario\", y: \"mujer\", fill: \"grupo_etario\", title: \"grupo_etario\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2181,"value":"
\n\n

\n\n## ¿Cómo viajaron los colombianos que fueron rechazados en 2024?\n\nEste gráfico visualiza el país del vuelo proveniente y la aerolínea con la que viajaron.\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2187,"value":"sankeyAerolineas = SankeyChart({\n links: sankeyAerolineaRechazosData\n}, {\n nodeGroup: d => d.id.split(/\\W/)[0],\n format: (f => d => `${f(d)} TWh`)(d3.format(\",.1~f\")),\n width,\n height: 1000 \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1892,"value":"
\n\n

\n\n## ¿De qué países provenían los vuelos de los colombianos que viajaron en ${airline} en 2024?\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2142,"value":"**Selecciona una aerolínea:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1812,"value":"viewof airline = Inputs.select(Array.from(d3.group(sankeyAerolineaData, d => d.aerolínea).keys()).sort())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2226,"value":"**Selecciona un status:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2228,"value":"viewof statusAirlines = searchCheckbox( \n [...new Set(sankeyAerolineaData.filter(d => d.aerolínea == airline).map(item => item.target))].sort(), \n {\n value: [...new Set(sankeyAerolineaData.filter(d => d.aerolínea == airline).map(item => item.target))].sort(),\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2144,"value":"**Selecciona uno o varios países:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1867,"value":"viewof countriesAirlines = searchCheckbox( \n [...new Set(sankeyAerolineaData.filter(d => d.aerolínea == airline).filter(d => statusAirlines.includes(d.target)).map(item => item.source))].sort(), \n {\n value: [...new Set(sankeyAerolineaData.filter(d => d.aerolínea == airline).filter(d => statusAirlines.includes(d.target)).map(item => item.source))].sort(),\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1806,"value":"sankeyPaises = SankeyChart({\n links: sankeyFiltered\n}, {\n nodeGroup: d => d.id.split(/\\W/)[0],\n format: (f => d => `${f(d)} TWh`)(d3.format(\",.1~f\")),\n width,\n height: countriesAirlines.length / 5 * 100 \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":823,"value":"
\n\n

\n\n## Explora los datos","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":38,"value":"**Selecciona una o varias aerolíneas:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":40,"value":"viewof aerolineaSelection = searchCheckbox( \n [...new Set(dataRechazos.map(item => item.aerolínea))].sort(), \n {\n value: [...new Set(dataRechazos.map(item => item.aerolínea))].sort(),\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":238,"value":"
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":16,"value":"Plot.plot({\n width: width,\n height: 600,\n marginLeft: 100,\n insetTop: 50,\n color: { legend: true },\n x: { tickFormat: \"d\", label: \"Año\", ticks: yearsRange.length},\n y: { tickFormat: \"s\", zero: true, label: \"Rechazos\", grid: true },\n title: \"Aerolíneas donde viajan colombianos rechazados en México\",\n subtitle: \"De 2019 a julio de 2024\",\n marks: [\n Plot.lineY(aerolineaSelected, {\n x: d => +d.año,\n y: d => +d.total,\n stroke: \"aerolínea\",\n }),\n Plot.dot(aerolineaSelected, {\n x: d => +d.año,\n y: d => +d.total,\n fill: \"aerolínea\",\n tip: true\n }),\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":851,"value":"
\n\n

\n\n## Rechazos por aeropuerto","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":321,"value":"**Selecciona una aerolínea:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":325,"value":"viewof aerolinea = Inputs.select(Array.from(d3.group(dataRechazosAeropuertos, d => d.aerolínea).keys()).sort())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":330,"value":"Plot.plot({\n width: width,\n height: 600,\n marginLeft: 100,\n color: { legend: true },\n x: { tickFormat: \"d\", label: \"Año\", ticks: yearsRange.length},\n y: { tickFormat: \"s\", zero: true, label: \"Rechazos\", grid: true },\n title: `Aeropuertos donde rechazaron a colombianos que viajaron en ${aerolinea}`,\n subtitle: \"De 2019 a julio de 2024\",\n marks: [\n Plot.lineY(aerolineaAeropuerto, {\n x: d => +d.año,\n y: d => +d.total,\n stroke: \"aeropuerto\",\n }),\n Plot.dot(aerolineaAeropuerto, {\n x: d => +d.año,\n y: d => +d.total,\n fill: \"aeropuerto\",\n tip: true\n }),\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":323,"value":"
\n\n

\n\n## Porcentaje anual de colombianos rechazados por aerolínea","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":637,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":227,"value":"
\n\n

\n\n## Sexo de colombianos rechazados por aerolínea","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":141,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"
\n\n

\n\n### Code section","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":448,"value":"csvURL = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vSIpanNx_aFG0xJNYpht71XkhOBxPRixhIyOxadGg26fRofcVNc4V2-9OxRjmKoTWW1veFuJFgX5k63/pub?gid=40627714&single=true&output=csv\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"dataRaw = d3.csv(csvURL)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"data = dataRaw.map(item => {\n return {\n ...item,\n año: parseInt(item.año),\n hombre: parseInt(item.hombre),\n mujer: parseInt(item.mujer),\n total: parseInt(item.total),\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":472,"value":"dataRechazos = data.filter(d => d.tipo == \"rechazos\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1116,"value":"dataIngresos = data.filter(d => d.tipo == \"ingresos\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"yearsRange = Array.from(new Set(data.map(d => d.año))).sort((a, b) => a - b)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":407,"value":"totalAerolineas = Array.from(\n d3.rollup(\n dataRechazos,\n v => d3.sum(v, d => d.total), // Summing the 'total' for each group\n d => d.aerolínea // Grouping by 'aerolínea'\n ),\n ([aerolínea, total]) => ({ aerolínea, total }) // Mapping the result to an array of objects\n).sort((a, b) => b.total - a.total); // Sorting in descending order based on total","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1672,"value":"topAerolineas = totalAerolineas.slice(0, 6).map(item => item.aerolínea)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":409,"value":"aerolineasAcumuladasRechazos = dataRechazos.map(d => ({\n ...d,\n aerolínea: topAerolineas.includes(d.aerolínea) ? d.aerolínea : \"Otra\"\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":412,"value":"groupedAerolineasAcumuladas = Array.from(\n d3.rollup(\n aerolineasAcumuladasRechazos, \n v => d3.sum(v, d => d.total), // Summing the 'total' for each group\n d => d.aerolínea, // First level of grouping by 'aerolínea'\n d => d.año // Second level of grouping by 'año'\n )\n).flatMap(([aerolínea, yearValues]) => \n Array.from(yearValues, ([año, total]) => ({\n aerolínea: aerolínea,\n año: año,\n total: total\n }))\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":529,"value":"groupedRechazosIngresos = Array.from(\n d3.rollup(\n data,\n v => {\n const total_rechazos = d3.sum(v.filter(d => d.tipo === \"rechazos\"), d => d.total); // Sum for 'rechazos'\n const total_ingresos = d3.sum(v.filter(d => d.tipo === \"ingresos\"), d => d.total); // Sum for 'ingresos'\n return {\n total_rechazos,\n total_ingresos,\n total: total_rechazos + total_ingresos // Calculate total\n };\n },\n d => d.aerolínea, // Group by 'aerolínea'\n d => d.año // Then group by 'año'\n ),\n ([aerolinea, años]) => \n Array.from(años, ([año, totals]) => ({\n aerolínea: aerolinea,\n año: año,\n total_rechazos: totals.total_rechazos,\n total_ingresos: totals.total_ingresos,\n total: totals.total,\n per_rechazos: (totals.total_rechazos / totals.total),\n per_ingresos: (totals.total_ingresos / totals.total)\n }))\n).flat().sort((a, b) => a.año - b.año)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":606,"value":"groupedAerolineasFiltered = groupedRechazosIngresos.filter(d => topAerolineas.includes(d.aerolínea))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":"aerolineaSelected = dataRechazos.filter(d => aerolineaSelection.includes(d.aerolínea))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":506,"value":"aerolineasFiltered = data.filter(d => topAerolineas.includes(d.aerolínea))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"aerolineasRechazadosFiltered = dataRechazos.filter(d => topAerolineas.includes(d.aerolínea))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2372,"value":"**Grupos etarios**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1173,"value":"csvGruposEtariosURL = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vSIpanNx_aFG0xJNYpht71XkhOBxPRixhIyOxadGg26fRofcVNc4V2-9OxRjmKoTWW1veFuJFgX5k63/pub?gid=979970740&single=true&output=csv\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1175,"value":"dataGruposEtariosRaw = d3.csv(csvGruposEtariosURL)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1182,"value":"dataGruposEtarios = dataGruposEtariosRaw.map(item => {\n return {\n ...item,\n año: parseInt(item.año),\n hombre: parseInt(item.hombre),\n mujer: parseInt(item.mujer),\n total: parseInt(item.total),\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1266,"value":"dataGruposEtariosFiltered = dataGruposEtarios.filter(d => d.tipo == \"rechazos\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2368,"value":"**País de vuelo proveniente**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1721,"value":"csvAerolineaPaises = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vSIpanNx_aFG0xJNYpht71XkhOBxPRixhIyOxadGg26fRofcVNc4V2-9OxRjmKoTWW1veFuJFgX5k63/pub?gid=317877256&single=true&output=csv\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1723,"value":"arolineaPaisesRawData = d3.csv(csvAerolineaPaises)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1727,"value":"arolineaPaisesData = arolineaPaisesRawData.map(item => {\n return {\n ...item,\n año: parseInt(item.año),\n total: parseInt(item.total),\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2237,"value":"sankeyAerolineaRechazosData = arolineaPaisesData.filter(d => d.tipo == \"rechazos\").map(({ país_de_vuelo_proveniente, total, aerolínea}) => ({\n source: país_de_vuelo_proveniente,\n target: aerolínea,\n value: total,\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1825,"value":"sankeyAerolineaData = arolineaPaisesData.map(({ tipo, país_de_vuelo_proveniente, total, aerolínea}) => ({\n source: país_de_vuelo_proveniente,\n target: tipo,\n value: total,\n aerolínea: aerolínea\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1887,"value":"sankeyFiltered = sankeyAerolineaData.filter(d => d.aerolínea == airline).filter(d => countriesAirlines.includes(d.source)).filter(d => statusAirlines.includes(d.target))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2370,"value":"**Aeropuertos**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":315,"value":"csvAeropuertosURL = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vSIpanNx_aFG0xJNYpht71XkhOBxPRixhIyOxadGg26fRofcVNc4V2-9OxRjmKoTWW1veFuJFgX5k63/pub?gid=1512133585&single=true&output=csv\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":317,"value":"rawDataAeropuertos = d3.csv(csvAeropuertosURL)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":319,"value":"dataAeropuertos = rawDataAeropuertos.map(item => {\n return {\n ...item,\n año: parseInt(item.año),\n hombre: parseInt(item.hombre),\n mujer: parseInt(item.mujer),\n total: parseInt(item.total),\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1496,"value":"dataRechazosAeropuertos = dataAeropuertos.filter(item => item.tipo == \"rechazos\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":328,"value":"aerolineaAeropuerto = dataRechazosAeropuertos.filter( d => d.aerolínea == aerolinea)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":401,"value":"groupedAeropuertos = Array.from(\n d3.rollup(\n dataRechazosAeropuertos, \n v => d3.sum(v, d => d.total), // Summing the 'total' for each group\n d => d.aeropuerto, // First level of grouping by 'aeropuerto'\n d => d.año // Second level of grouping by 'año'\n )\n).flatMap(([aeropuerto, yearValues]) => \n Array.from(yearValues, ([año, total]) => ({\n aeropuerto: aeropuerto,\n año: año,\n total: total\n }))\n).sort((a, b) => a.año - b.año)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2158,"value":"import {data as dataMeses} from \"@fer-aguirre/extranjeros-rechazados-por-via-aerea-en-mexico\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1479,"value":"dataMesesCol = dataMeses.filter(item => item.pais == \"Colombia\" && \n yearsRange.includes(item.año)\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2374,"value":"**Desagregados por meses**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1511,"value":"csvMesesSolicitudURL = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vSIpanNx_aFG0xJNYpht71XkhOBxPRixhIyOxadGg26fRofcVNc4V2-9OxRjmKoTWW1veFuJFgX5k63/pub?gid=321170573&single=true&output=csv\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1513,"value":"dataMesesSolicitudRaw = d3.csv(csvMesesSolicitudURL)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1515,"value":"dataMesesSolicitud = dataMesesSolicitudRaw.map(item => {\n return {\n ...item,\n año: parseInt(item.año),\n mes: parseInt(item.mes),\n eventos_de_entrada: parseInt(item.eventos_de_entrada),\n rechazados: parseInt(item.rechazados),\n total_de_eventos: parseInt(item.total_de_eventos),\n porcentaje_rechazo: parseFloat(d3.format(\".2f\")(item.porcentaje_rechazo.replaceAll(\",\", \".\")))\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1682,"value":"$3b","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1697,"value":"**Functions**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1699,"value":"renderTermsMarkdown = (array) => \n array.map(item => ` - ${item}`).join('\\n')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"### Libraries","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":25,"value":"import {searchCheckbox} from \"@john-guerra/search-checkbox\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1695,"value":"marked = require('marked')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1745,"value":"import {SankeyChart} from \"@d3/sankey-component\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3c","stdlib":"1","titling":"auto"}} 33:"$32:body"