Excelython — Part 3: Project Description
Since we have a working Python System, now we can try to create a simple daily office task, that will prove you that by doing the same for all the similar things you are doing daily, you are going to save a lot of time and minimize the mistakes.
Project Description
You are working on a purchasing team and you want to check your sales and inventory, the pending orders you might have, where you need to place new orders and what are the products that need your attention as they are slow movers.
After you have done all the downloading, the processing and evaluation, you need to send to another colleague a file by email, that has all the products to be ordered, split by supplier and volume, per different sheet and you need a separate excel file with the products that you have stock greater than 4 weeks, ordered by the top 20 cost value, in order to create a plan to push their sales or return them back to the supplier.
Methodology
The way that I am going to show you how things are been done in Python, is in a parallel way.
I am going to demonstrate each step in the way that i would do it in excel and the same step how I am doing it in Python.
Step by step, in order to be easy to digest, easy to index and use this tutorial as a reference guide in the future and finally because i still don’t have a Python script that can write for me tutorials!!!!!!!!!!!
Scope
The scope of the project is not to show you how to do your job as product manager or how to do it in excel, but to show you how you can replicate the process you do in excel to python and how much time you are going to save.
You will learn methods and technics for a real life project in the Python Enviroment but at the end you will not be a Python Developer.
You are going to be familiarized with Python and Excel preprocessing, processing and evaluation and you will be one step inside in Python’s room.
Then it is up to you to close the door behind you and search the room to find all the great staff that Python can do, or step back and close the door in front of you and continue with the knowledge you already have.
If you follow me next post, we are going to be together in the First Chapter of this project.
Otherwise, thank you very much for reading and i wish you all the best.
