Скачать или смотреть Export of Made in Sialkot product to United States of America | Excel Vlookup and Pivot Table

In this video I have demonstrated my method of collection of trade data of made in Sialkot products to United States of America.

The table contains following three data fields;
-Pakistan's export to USA
-USA Imports from World
-Pakistan's export to world

Values were in million USD.

I had already collected Sialkot specific product HS-Codes which I filtered out from the entire datasheet using pandas library of Python programming language. The same can be performed with excel's vlookup funtion. Which I later used in writing the categories.

The data collected from trademap was in thousand USD therefore the values must be converted into Millions before final presentation. For that purpose I divided the values with 1000.

data source: https://www.trademap.org