Interactive Data Tool

U.S.–China Trade Partner Analysis

Explore how national trade relationships with China and the United States have shifted over time. Filter countries by continent, move through individual years, or play the full time series to compare each country's relative trade orientation.

Python Pandas Plotly Excel Interactive HTML

Import Share by Country

Export Share by Country

How to Read the Visualization

Each point represents one country. China is plotted on the horizontal axis and the United States on the vertical axis. A point above the dashed diagonal has a larger value for the United States, while a point below the line has a larger value for China. Point color reinforces the same comparison.

Use the year slider or Play button to follow changes through time. Countries can be included or excluded individually or by continent, and the chart automatically rescales around the countries currently selected.

About the Project

This visualization is generated by a reusable Python-based trade visualization engine. The underlying data is stored in a tidy master dataset with separate metric and country metadata, allowing additional U.S.–China trade measures to be added without rewriting the visualization logic.

The current engine supports multiple metrics, including import share and export share, with each enabled metric exported as its own standalone interactive HTML visualization for deployment on Agitlytics.