2d:null 2e:["$","title",null,{"children":"Radar exportador: productos argentinos al mundo | Fer Aguirre | Observable"}] 33:Tb03,

## 📝 Metodología
Este dashboard presenta un análisis visual de los datos de exportaciones argentinas reportados oficialmente a la base de datos [Comtrade](https://comtradeplus.un.org/) de las Naciones Unidas, permitiendo explorar las tendencias comerciales del país durante la última década. La desagregación de los datos facilita un análisis granular tanto de productos específicos como por país de destino. La información abarca 96 tipos de productos distintos. Los productos se han clasificado según el Sistema Armonizado Internacional (código HS), utilizando los dos primeros dígitos que definen cada capítulo y representan categorías amplias de productos. Estos capítulos abarcan del 01 al 97, y la nomenclatura de códigos HS de dos dígitos fue obtenida del portal [Exporteers](https://exporteers.com/es/hs-code/), que ofrece descripciones de productos en español. El dashboard está estructurado en cinco secciones que permiten explorar distintos enfoques en el análisis de los datos. Cada sección incluye filtros interactivos para la exploración detallada de datos, genera insights contextualizados basados en las selecciones realizadas y presenta visualizaciones que se adaptan dinámicamente a los criterios elegidos por el usuario. - [GitHub del proyecto](https://github.com/fer-aguirre/argentrade) **Descarga de datos** Para la obtención de los datos se utilizó la librería de Python comtradeapicall, que facilita las consultas a la API de UN Comtrade. Mediante esta herramienta se automatizó la descarga de información de exportaciones argentinas, abarcando todos los códigos HS de dos dígitos para el período 2014-2024. Adicionalmente, se recopiló información desde la perspectiva de los países importadores, descargando los datos de todos los países que reportaron haber importado productos argentinos bajo los mismos códigos HS y período temporal. Esta aproximación permite contrastar y validar la información desde ambos lados del flujo comercial. A continuación se adjuntan los cuadernos de Jupyter utilizados para la descarga de datos: - [0.0-collect-exports.ipynb](https://github.com/fer-aguirre/argentrade/blob/main/_notebooks/0.0-collect-exports.ipynb) - [0.1-collect-imports.ipynb](https://github.com/fer-aguirre/argentrade/blob/main/_notebooks/0.1-collect-imports.ipynb) **Análisis de datos** La métrica considerada para el análisis fue el valor comercial en USD, que en los datos de exportaciones corresponde al valor FOB y en los datos de importaciones al valor CIF. En este caso, se consideró la variable `primaryValue` de los datos de Comtrade. Se utilizó el valor comercial ya que no todos los HS codes poseen información sobre el peso neto de los productos.34:T596,

## 🧮 4. Asimetrías en comercio bilateral
`Esta visualización permite contrastar los valores monetarios (USD) reportados por Argentina como exportaciones hacia cada país socio con los montos que esos mismos países declaran como importaciones procedentes de Argentina. El cálculo de la discrepancia se realiza mediante la fórmula: (valor de exportación argentina - valor de importación del socio).` `Los puntos a la derecha indican que Argentina reporta más; los de la izquierda muestran que el socio reporta más. Los países están ordenados de mayor a menor según la magnitud de la discrepancia, permitiendo identificar las mayores asimetrías.` `Se usa el producto y año seleccionados previamente en secciones 2 y 3.`
### ¿Cuál fue el país que presentó la mayor asimetría en el valor del intercambio comercial de *${productDescription.toLocaleLowerCase()}* en ${yearProduct}?
- ${d3.greatest(filteredComparison, (a, b) => Math.abs(a.valueDifference) - Math.abs(b.valueDifference)).partnerDesc} fue el país que tuvo la mayor asimetría con lo reportado por Argentina, esto se debió a que ${d3.greatest(filteredComparison, (a, b) => Math.abs(a.valueDifference) - Math.abs(b.valueDifference)).sourceFlagEs}.
### Asimetrias en comercio bilateral de *${productDescription.toLocaleLowerCase()}* en ${yearProduct}
35:T46b,Plot.plot({ grid: true, width: 800, height: Math.max(400, filteredComparison.length * 25), marginLeft: 150, insetBottom: 20, insetLeft: 20, x: { label: "Diferencia de valor", tickFormat: d => `$${formatTick(d)}` }, y: { label: "País", domain: d3.sort(filteredComparison, d => Math.abs(d.valueDifference)) .reverse() .map(d => d.partnerDesc) }, color: { label: "Tipo de diferencia", domain: [ "Export value is higher", "Import value is higher", "Match", "Only export reported", "Only import reported" ], range: ["#FFC107", "#FF5722", "#4CAF50", "#2196F3", "#9C27B0"], legend: true }, marks: [ Plot.ruleX([0], {stroke: "black", strokeWidth: 2}), Plot.dot(filteredComparison, { x: "valueDifference", y: "partnerDesc", fill: "sourceFlag", r: 6, stroke: "white", channels: { "País": "partnerDesc", "Valor de exportación": d => `$${formatTick(d.exportValue)}`, "Valor de importación": d => `$${formatTick(d.importValue)}`, }, tip: true }) ] })36:T4d6,`Las asimetrías en los datos de exportaciones e importaciones surgen por múltiples factores. La principal causa radica en los criterios de valoración: las exportaciones se registran bajo términos FOB (Free On Board), excluyendo costos de transporte y seguro, mientras que las importaciones se reportan en términos CIF (Cost, Insurance and Freight), que incorporan estos gastos adicionales.` `Otras razones de discrepancia incluyen la falta de reporte de datos por parte de algunos países en determinados períodos o productos, el uso de metodologías estadísticas distintas, errores de registro y desfases temporales entre el despacho y la recepción de mercancías. Estos factores explican por qué las cifras bilaterales de comercio raramente coinciden entre países.` `Sin embargo, el análisis de estas asimetrías constituye una herramienta útil para la investigación. Los patrones sistemáticos de discrepancia pueden revelar problemas de registro, comercio no declarado o diferencias metodológicas significativas. Cuando estas discrepancias son consistentes o desproporcionadamente grandes, señalan áreas que requieren investigación adicional y contribuyen a evaluar la calidad de los datos comerciales disponibles.`37:[{"id":"5313bbd78b069f1cd61bf2b70e4f20f85e0170231caadc13ec2e8f1d9426116a4d047da25d2ace3b33c93819e22c88e240d085841c2c685bcbc73cabcc1eac97","href":"https://static.observableusercontent.com/files/5313bbd78b069f1cd61bf2b70e4f20f85e0170231caadc13ec2e8f1d9426116a4d047da25d2ace3b33c93819e22c88e240d085841c2c685bcbc73cabcc1eac97","name":"comtrade_argentina_exports_2014-2024.parquet","type":"application/octet-stream","lastModified":1760042228388.706,"size":741010},{"id":"5e1c2056bb404e6559ec875106fdb5d4212cacd9ea2c73c70183db8b4b03dda577e4e3d636c2fad5ece47440afca7b121876a3cbcc2ba391d09ae199fd586534","href":"https://static.observableusercontent.com/files/5e1c2056bb404e6559ec875106fdb5d4212cacd9ea2c73c70183db8b4b03dda577e4e3d636c2fad5ece47440afca7b121876a3cbcc2ba391d09ae199fd586534","name":"comtrade_argentina_exports_vs_imports.parquet","type":"application/octet-stream","lastModified":1760490353474.663,"size":1880831},{"id":"80bb9bf3f6ba070d7a9850f1d4de3f9116c80aae7483e1c170b7fc660ac364592f904606667861254f07f726c6f153cc8e6392724d24f7d1f20fb981bd5437c0","href":"https://static.observableusercontent.com/files/80bb9bf3f6ba070d7a9850f1d4de3f9116c80aae7483e1c170b7fc660ac364592f904606667861254f07f726c6f153cc8e6392724d24f7d1f20fb981bd5437c0","name":"logo.png","type":"image/png","lastModified":1760065240777.436,"size":62832}] 31:{"id":"a527d65fadea3945","slug":"radarexportador","title":"Radar exportador: productos argentinos al mundo","thumbnail":"286bafbe0e0e182f56d924c679a69e9123ee83623858def95f8dcf6f846eb578","access_level":"public","create_time":"$D2025-10-08T21:56:04.051Z","update_time":"$D2025-10-20T12:20:53.223Z","view_time":null,"first_public_time":"$D2025-10-20T12:08:55.992Z","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":2181,"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":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Radar exportador: productos argentinos al mundo","cells":[{"id":1104,"value":"html`\n \n

Radar exportador: productos argentinos al mundo

\n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1175,"value":"ToC({\n title: \"🗂️ Tabla de contenidos\",\n invalidation,\n headers: [\"h2\"],\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1200,"value":"$33","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":367,"value":"
\n\n

\n\n## 🚢 1. Productos exportados\n\n
\n\n**Seleccioná un año:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":42,"value":"viewof yearSelection = Inputs.select([...new Set(exportsData.map(item => item.year))].sort(), {format: d => d.toString(), value: 2024})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":371,"value":"**Seleccioná un rango máximo de productos:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":187,"value":"viewof maxProducts = Inputs.range([20, filteredExports.length], {step: 1, value: 20})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":374,"value":"
\n\n### ¿Cuáles fueron los productos más exportados en ${yearSelection}?\n\n- **${topExports[0].descripcion}** fueron los productos más exportados desde Argentina en ${yearSelection} con un valor FOB de alrededor de **$${formatTick(topExports[0].primaryValue)} USD**\n\n
\n\n### Perfil exportador argentino en ${yearSelection}: productos por valor y sector","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":78,"value":"key = Swatches(treemap_chart.scales.color)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1203,"value":"`Pasá el cursor sobre el gráfico para ver más detalle de cada producto`","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":67,"value":"treemap_chart = Treemap(processedExports, {\n labelFillLight: \"000\",\n path: (d) => d?.sector,\n value: (d) => d?.primaryValue, \n group: (d) => d?.sector,\n label: (d, n) =>\n [\n d.descripcion,\n formatTick(n.value)\n ].join(\"\\n\"),\n title: (d, n) => `Sector: ${d.sector}\\nProducto: ${d.descripcion}\\nHS code: ${d.hs_code}\\nValor FOB (USD): ${formatTick(n.value)}`,\n width: 1200,\n height: 1200,\n style: {\n \"font-size\": \"16px\", // Increase this value for larger font\n \"font-family\": \"sans-serif\"\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1824,"value":"html`

\n Gráfico: Fernanda Aguirre Ruíz • Fuente: UN Comtrade, División de Estadísticas de las Naciones Unidas, datos consultados en octubre de 2025\n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":377,"value":"
\n\n

\n\n## 🔎 2. Exportaciones por producto específico\n\n
\n\n`Escribí el nombre de algún producto de tu interés o seleccioná alguna de las opciones. Para ver todas las alternativas, eliminá el texto del campo de búsqueda`","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":9,"value":"viewof productDescription = Inputs.text({\n placeholder: \"Escribe el nombre del producto\",\n datalist: hsCodes.map(d => d.descripcion), value: \"Cereales\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":612,"value":"
\n\n### ¿Cómo fueron las exportaciones argentinas de *${productDescription.toLocaleLowerCase()}* en la última década?\n\n- Argentina pasó de exportar alrededor de **${minValueWorld}** de USD en ${minYearWorld} a cerca de **$${maxValueWorld}** de USD en ${maxYearWorld}\n\n
\n\n### Exportaciones argentinas de ${productDescription.toLocaleLowerCase()} (2014–2024)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":583,"value":"Plot.plot({\n width:width,\n height:600,\n marginLeft:50,\n marginRight:50,\n caption: `Gráfico: Fernanda Aguirre Ruíz • Fuente: UN Comtrade, División de Estadísticas de las Naciones Unidas, datos consultados en octubre de 2025 • HS code ${product}`,\n x:{\n tickFormat:\"d\", \n label:\"Año\", \n },\n y:{zero:true, tickFormat: formatTick, label:\"Valor FOB (USD)\", grid:true},\n marks: [\n Plot.lineY(\n worldHSCode,\n {\n x: d=>+d.refYear,\n y: d=>+d.primaryValue,\n stroke: \"#F54927\",\n tip: true,\n }\n \n ),\n \n Plot.dot(\n worldHSCode,\n {\n x: d=>+d.refYear,\n y: d=>+d.primaryValue,\n fill: \"#F54927\",\n tip: true,\n }\n ),\n ],\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1525,"value":"
\n\n

\n\n## 🔀 3. Flujos de exportaciones\n\n
\n\n`Esta visualización muestra los principales 10 países de destino y el resto son agrupados como \"Resto de países\".`\n\n
\n\n**Elegí un año de exportaciones**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1529,"value":"viewof yearProduct = Inputs.select([...new Set(filteredHSCode.map(item => item.year))].sort(), {format: d => d.toString(), value: 2024})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1527,"value":"
\n\n### ¿A dónde fueron las exportaciones argentinas de *${productDescription.toLocaleLowerCase()}* en ${yearProduct}?\n\n- ${mainCountry} fue el destino con mayor valor comercial de exportaciones argentinas de *${productDescription.toLocaleLowerCase()}* durante ${yearProduct}.\n\n
\n\n### Principales países de destino de acuerdo al valor de exportaciones argentinas de ${productDescription.toLocaleLowerCase()} en ${yearProduct}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1567,"value":"SankeyChart({\n links: sankeyData\n}, {\n nodeGroup: d => d.id.split(/\\W/)[0],\n format: d => `${formatTick(d)} USD`,\n width,\n height: 500,\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1800,"value":"html`

\n Gráfico: Fernanda Aguirre Ruíz • Fuente: UN Comtrade, División de Estadísticas de las Naciones Unidas, datos consultados en octubre de 2025 • HS code ${product}\n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1950,"value":"$34","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1916,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1964,"value":"html`

\n Gráfico: Fernanda Aguirre Ruíz • Fuente: UN Comtrade, División de Estadísticas de las Naciones Unidas, datos consultados en octubre de 2025 • HS code ${product}\n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2125,"value":"$36","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":837,"value":"
\n\n

\n\n## 🌎 5. Países de destino\n\n
\n\n**Seleccioná un país de destino de exportaciones:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":842,"value":"viewof countrySelection = Inputs.select([...new Set(filteredHSCode.map(d => d.partnerDesc))].sort(), {value:`${mainCountry}`})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1181,"value":"
\n\n### ¿Cómo fue la dinámica de las exportaciones argentinas de *${productDescription.toLocaleLowerCase()}* hacia ${countrySelection} en los últimos 10 años?\n\n- En la última década, **${maxValueYear}** fue el año en que Argentina registró la exportación con mayor valor de *${productDescription.toLocaleLowerCase()}* hacia ${countrySelection} con un aproximado de **${formatTick(maxValueCountry)} USD**.\n\n
\n\n### Valor de exportaciones argentinas de *${productDescription.toLocaleLowerCase()}* a ${countrySelection}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1744,"value":"Plot.plot({\n width: width,\n height: 600,\n marginLeft: 50,\n marginRight: 50,\n insetTop: 30,\n caption: `Gráfico: Fernanda Aguirre Ruíz • Fuente: UN Comtrade, División de Estadísticas de las Naciones Unidas, datos consultados en octubre de 2025 • HS code ${product}`,\n x: {\n label: \"Año\",\n tickFormat: d => d.toString(),\n },\n y: {\n grid: true,\n tickFormat: formatTick,\n label: \"Valor FOB (USD)\",\n },\n marks: [\n Plot.barY(countryFilteredHSCode, {\n x: \"refYear\",\n y: \"primaryValue\",\n fill: \"#5F09C8\",\n }),\n Plot.text(countryFilteredHSCode, {\n x: \"refYear\",\n y: \"primaryValue\",\n text: d => formatTick(d.primaryValue),\n dy: -10,\n fill: \"#222\",\n }),\n Plot.ruleY([0])\n ]\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"
\n\n

\n\n# Code section","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1685,"value":"**Sección 1**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"hsCodesURL = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vQdWB-2PxwvwGuN6DVtOc_172L_i9c2_adkGS0MhUUZXFTAobsL9ELRy4RDmZ6mSvRL8vgL9znSSYbN/pub?gid=1107675439&single=true&output=csv\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"hsCodes = d3.csv(hsCodesURL)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"exportsURL = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vQdWB-2PxwvwGuN6DVtOc_172L_i9c2_adkGS0MhUUZXFTAobsL9ELRy4RDmZ6mSvRL8vgL9znSSYbN/pub?gid=723673453&single=true&output=csv\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"exportsRawData = d3.csv(exportsURL)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"exportsData = exportsRawData.map(item => {\n return {\n ...item,\n year: parseInt(item.year),\n primaryValue: parseFloat(item.primaryValue),\n };\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":59,"value":"filteredExports = exportsData\n .filter(d => d.year === yearSelection)\n .sort((a, b) => b.primaryValue - a.primaryValue)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":192,"value":"topExports = filteredExports.slice(0, maxProducts).sort((a, b) => b.primaryValue - a.primaryValue)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":194,"value":"groupedRest = Array.from(\n d3.rollup(\n filteredExports.slice(maxProducts),\n v => d3.sum(v, d => d.primaryValue),\n d => d.year\n ),\n ([year, total]) => ({\n year,\n primaryValue: total,\n descripcion: \"Resto de productos\",\n sector: \"Otro\"\n })\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":197,"value":"processedExports = [\n ...topExports,\n ...groupedRest\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1683,"value":"**Sección 2**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":504,"value":"parquet = FileAttachment(\"comtrade_argentina_exports_2014-2024.parquet\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":511,"value":"allExports = convertParquetToArray(parquet)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"product = parseInt(hsCodes.filter(d => d.descripcion === productDescription).map(d => d.hs_code)[0])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":576,"value":"worldHSCode = allExports.filter(d => d.cmdCode === product && d.partnerDesc === \"World\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":659,"value":"filteredHSCode = allExports.filter(d => d.cmdCode === product && d.partnerDesc !== \"World\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":623,"value":"minYearWorld = Math.min(...worldHSCode.map(d => +d.refYear))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":625,"value":"maxYearWorld = Math.max(...worldHSCode.map(d => +d.refYear))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":631,"value":"minValueWorld = formatTick(worldHSCode.filter(d => d.refYear === minYearWorld)[0].primaryValue)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":639,"value":"maxValueWorld = formatTick(worldHSCode.filter(d => d.refYear === maxYearWorld)[0].primaryValue)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1679,"value":"**Sección 3**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1569,"value":"groupedSankey = Array.from(\n d3.rollup(\n filteredHSCode.filter(d => d.refYear === yearProduct).sort((a, b) => b.primaryValue - a.primaryValue).slice(10),\n v => d3.sum(v, d => d.primaryValue),\n d => d.refYear\n ),\n ([refYear, total]) => ({\n refYear,\n primaryValue: total,\n partnerDesc: \"Resto de países\",\n reporterDesc: \"Argentina\"\n })\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1571,"value":"processedSankey = [\n ...filteredHSCode.filter(d => d.refYear === yearProduct).sort((a, b) => b.primaryValue - a.primaryValue).slice(0, 10),\n ...groupedSankey.filter(d => d.refYear === yearProduct)\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1564,"value":"sankeyData = processedSankey.map(({ reporterDesc, partnerDesc, primaryValue}) => ({\n source: reporterDesc,\n target: partnerDesc,\n value: primaryValue,\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1730,"value":"mainCountry = d3.greatest(filteredHSCode.filter(d => d.refYear === yearProduct), (a, b) => a.primaryValue - b.primaryValue).partnerDesc","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1955,"value":"**Sección 4**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1849,"value":"parquetComparison = FileAttachment(\"comtrade_argentina_exports_vs_imports.parquet\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1851,"value":"comparison = convertParquetToArray(parquetComparison)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2144,"value":"comparisonEs = comparison.map(item => {\n const translations = {\n \"Export value is higher\": \"el valor de exportación fue mayor\",\n \"Import value is higher\": \"el valor de importación fue mayor\",\n \"Match\": \"coinciden\",\n \"Only export reported\": \"solo se reportó la exportación\",\n \"Only import reported\": \"solo se reportó la importación\"\n };\n \n return {\n ...item,\n sourceFlagEs: translations[item.sourceFlag] || item.sourceFlag\n };\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1862,"value":"filteredComparison = comparisonEs.filter(d => d.hsCode === product && d.refYear === yearProduct)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1681,"value":"**Sección 5**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":849,"value":"countryFilteredHSCode = filteredHSCode.filter(d => d.partnerDesc === countrySelection)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1274,"value":"maxValueCountry = d3.greatest(countryFilteredHSCode, (a, b) => a.primaryValue - b.primaryValue).primaryValue","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1278,"value":"maxValueYear = d3.greatest(countryFilteredHSCode, (a, b) => a.primaryValue - b.primaryValue).refYear","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":144,"value":"**Functions**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":146,"value":"function formatTick(d) {\n if (d >= 1e9) {\n return (d / 1e9).toFixed(1) + ' B'; // Billions\n } else if (d >= 1e6) {\n return (d / 1e6).toFixed(1) + ' M'; // Millions\n } else if (d >= 1e3) {\n return (d / 1e3).toFixed(1) + ' K'; // Thousands\n } else {\n return d; // Less than a thousand\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"**Libraries**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":508,"value":"import {convertParquetToArray} from \"@fer-aguirre/parquet-data-loader\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":608,"value":"import {ToC} from \"@rmw4269/contents\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"import {Swatches} from \"@d3/color-legend\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":87,"value":"import {Treemap} from \"@categorise/treemap\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":81,"value":"import {schemeCategory10, main} from \"@categorise/data-vis-style-guide\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1560,"value":"import {SankeyChart} from \"@d3/sankey-component\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":516,"value":"**API calls**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":557,"value":"// tradeData = fetch(\"https://api.allorigins.win/raw?url=\" + \n// encodeURIComponent(`https://comtradeapi.un.org/public/v1/preview/C/A/HS?reporterCode=32&period=2024&cmdCode=${product}&flowCode=X`))\n// .then(response => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W37","stdlib":"1","titling":"auto"}} 32:"$31:body"