How much the US imports from Mexico

Posted to Network Visualization  |  Tags: , ,  |  Nathan Yau

Most goods imported from Mexico are untaxed under the North American Free Trade Agreement. The Administration wants to tax those billions of dollars of goods coming in. David Yanofsky for Quartz plotted the imported products.

Quartz gathered import data from the US Census Bureau comprising 6,011 hierarchical product categories, the amount imported, and the tax collected. Every product the US buys at least $1 million worth from Mexico is shown below through the lens of the Harmonized System, the international standard for categorizing and taxing traded goods.

The x-axis shows the percentage of international imports for a product come from Mexico. The y-axis, as well as bubble size, shows how much the US spent in the year November 2015-2016. Color represents tax rate.

The hierarchical representation confused me at first. We typically see bubble plots charted on three dimensions from a flat, rectangular dataset. That is, there’s an x-value, a y-value, and a z-value (for bubble size), and each bubble represents a separate category. However, with this representation, each smaller circle is a subset of a larger circle.

For example, here’s the plot for avocados:

It’s a plot with five bubbles, which starts with the fruit and nuts category and goes down to a certified organic Hass avocados subcategory. So there’s the hierarchy, the x-y position, bubble size, and color. The color scale represents 0% to 20%, but only the really tiny bubbles fall in the high range, and at that point it’s hard to see what color it is.

I think it’s a good concept. But it might try to show too much at once.

Favorites

Marrying Age

People get married at various ages, but there are definite trends that vary across demographic groups. What do these trends look like?

10 Best Data Visualization Projects of 2015

These are my picks for the best of 2015. As usual, they could easily appear in a different order on a different day, and there are projects not on the list that were also excellent.

A Day in the Life of Americans

I wanted to see how daily patterns emerge at the individual level and how a person’s entire day plays out. So I simulated 1,000 of them.

Where Bars Outnumber Grocery Stores

A closer look at the age old question of where there are more bars than grocery stores, and vice versa.