PAPER INVENTORY
Build and run a database that will hold data about paper imports that is taken from an Excel file.
I create a table called "product_data" with several fields such as HS Code, Product Description, Shipper and Consignee Names, Standard Quantity, and Country Details using SQL after reading the data using pandas. I use the "tabulate" programme to format and show the data as an orderly table, which improves readability and makes it easier to analyse paper inputs.
Jupyter Notebook : open-source software.
Language: Python.
Data manipulation: pandas, tabulate libraries for python and sqlite3.
Data Source: paper inventory