Python vs Excel working with multiple csv files
This is comparison video about working with few csv files at the same time, comparing Excel and Python. As example is used buying process, where is given three files:
1. Master csv file with 2000 different SKUs supply by 30 suppliers.
2. Inventory csv file with 8000 stock locations where these 2000 SKUs are stored. Some locations are empty, most of products are store in multiple location to simulate real operational environment.
3. Undelivered csv file with current purchased orders which has not been delivered yet.
The task is to create a file which will suggest next purchase order. This is done in Excel, putting all 3 csv files to one spreadsheet and using formulas to get desired outcome. Then it is done again in Python script, which reads all 3 csv files and create outcome.csv and also outcome.json.
All code is visible in video and all codes and files are available in my github.
https://github.com/StefanGlova/purchase_order
In questa pagina del sito puoi guardare il video online Python vs Excel working with multiple csv files della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Stefan Glova 10 settembre 2023, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 64 volte e gli è piaciuto 6 spettatori. Buona visione!
