Design Automated Inventory Management System In Google Sheets And Excel

Overview:

Provide services using Python for:

• Data Collection and Parsing (txt, log, csv, html, xls, xlsx, bin)
• Data Validation and Comparison
• Data Analysis
• Graphs plotting (matplotlib)

Descriptions:

Using Python to collect data in the form of txt, log, csv, html, xls, xlsx and bin, and then parse and covert them into more structural data.

Check and verify the validity of the collected data. Compare the data with your expectation and flag out if there is any error.

Using the collected data to:

• Analyze (min, mean, max, median, xth percentile, and etc…)
• Sort and Grouping (smallest to largest, largest to smallest, by type, by date, by name and etc…)
• Filter, delete or append new data

After data analysis and data processing, visualize them into clear and colorful graphs/charts by matplotlib.