Methodological Deep Dive Unraveling the Turkey-Germany asymmetry through the lens of trade data standards (GTS vs. STS). In bilateral trade, the math should be simple: what Country A reports as an export to Country B should theoretically match what Country B reports as an import. In practice, however, these numbers rarely align perfectly. I analyzed the trade relationship between Turkey (Reporter: Export) and Germany (Partner: Import) to quantify this "Asymmetry Gap." Using Databricks and PySpark, I processed annual trade records to distinguish between systemic reporting differences and massive, commodity-specific anomalies. Methodology Data Source UN Comtrade mont...
In global trade, "efficiency" often masks "fragility." We know that China is central to the global electronics supply chain, but how central? And if that node were to go dark, who would feel the shockwaves first? To answer this, I moved beyond standard trade statistics and built a network simulation using the OECD Inter-Country Input-Output (ICIO) Tables (2023 Edition) . This dataset maps the DNA of the global economy, tracking every dollar of input across 66 countries and 45 industries. 1. The Blast Radius: Tracing the Contagion I treated the global economy as a directed graph and simulated a total supply shock to Chinese Electronics (CHN_C26) . By tracing the flow of inputs across three tiers of buyers, I visualized the "Blast Radius" of this disruption. Fig 1: The Supply Chain Cascade. The shock originates in China (Red) and immediately hits "Tier 1" assembly hubs (Dark Blue) before cascading to global consumers...