Based on pizza orders, determining the ingredients Pizza Maven should buy in order to become a more efficient restaurant in terms of stock management and saving the results of such suggestions to a xml file. To do so, in the first place you have to run in the python terminal the following command: "pip install -r requirements.txt", which will automatically download the necessary libraries for the actual program to work correctly. The program is called "maven_pizzas_2016_XML.py" and uses the files given by Maven Pizzas "order_details.csv", "orders.csv", "pizzas.csv" and "pizza_types.csv" to predict and estimate the ingredients Pizza Maven´s manager should by each week of the following year. Additionaly, the program generates an xml file ("informe_pizzas_maven_2016.xml") which corresponds to a brief report and analysis of the data's quality.
To build such prediction, the program processes the "order_details.csv" file, applying some indispensable changes to the pizza names and the quantity, so that every one of them has the same structure to simplify the next operations and treatment of the dataframes. Then, the program sums up all the pizzas that were ordered last year, differentiating pizza type and size. Then, divides that total quantity by 52 (number of weeks in a year) and takes the roof of the result of the division (for example, 300/52 = 5,769 => 6). Once this procediture has been done for every kind of pizza, we have the number of pizzas of each type ordered in an average week. Now, the program multiplies each pizza´s ingredientes by the number of pizzas of such type ordered in one week by another factor, related with the size. For each size, we consider the following units of each ingredient in one particular pizza: {s:1, m:2, l:3, xl: 4, xxl: 5}
Once the number of ingredients has been calculated, leaving room for some misestimation, the final xml file is generated with the name "compra_semanal_ingredientes.xml" This file is a kind of shopping list Pizza Maven´s manager should follow each week to be efficient and throw almost no food at all.