This repository contains a practical solution for inventory data management using Python. The project focuses on automating the ingestion of external files and transforming raw data into manageable structures.
The primary goal was to efficiently process CSV inventory files, extracting specific information (such as product names) to generate quick reports and facilitate technical and administrative decision-making.
- Data Ingestion: Effective use of the Pandas library to load and read data structures from flat files.
- Data Transformation: Converting
DataFrameobjects into native Python structures likeListsfor seamless process integration. - Debugging & Problem Solving: Resolved syntax and definition errors (e.g.,
NameError) and managed file pathing. - IT Automation: Creating repeatable workflows for automated inventory analysis.
catalog_manager.ipynbβ The main Jupyter Notebook containing the data loading logic and processing.inventory.csvβ The source database containing the product listings.