Semiconductor Demand

Semiconductor demand in the past 35 years.

Alex Kuai
2022-08-07

Raw Data

This is the raw data from the original xls file downloaded from the website.

Looking at this, it isn’t pretty. The years are in the same column as the countries, column names are all messed up do to how this was formatted; so then it was time to wrangle it into place.

Wrangling

Scanning through the data, it was clear that we needed to first change the names of these columns, because they were all messed up.

Furthermore, the countries column has the years in it. That isn’t right. So we need a new column to hold the years, then delete all of the ones from where they aren’t supposed to be.

After polishing this dataset into something usable, here it is!

Semiconductor Demand From Four Regions

Historical billings of semiconductor demand from the Americas, the Asia Pacific, Europe, and Japan are shown here.

(WSTS 2022)

There is massive growth in semiconductor demand in the Asia Pacific Region, peaking at almost 343 million semiconductor units reported to be purchased.

The semiconductor demand in the Americas have steadily increased, but nowhere near the growth of the Asia Pacific region.

Demand for semiconductors in Europe and Japan have been relatively low, and there haven’t been any particularly high amounts of growth demand for them either.

WSTS. 2022. World Semiconductor Trade Statistics Historical Billigns Report. WSTS. https://www.wsts.org/67/Historical-Billings-Report.

References