Data Wrangling: Product Inventory Management for Momezon Korean Market

I produced a data pipeline for product inventory management for Momezon Korean Market, a local grocery market I worked at when I was in high school. The manager still uses MS Excel to handle inventory management to this day, so I offered help by creating a workflow that automates the process of transferring his spreadsheets into a MySQL database controlled by phpMyAdmin, an open source database management tool. Through a workflow that involves reading, cleaning, and scripts that query the data, the result will be a more powerful way of managing data for my old boss.