In this second part of Task 2, you should write a Python script that reads and analyses the ice cream data file (Weekly_Sales.csv) and merge it with the store details file (StoreDetails.csv) and region file (Region.csv) to produce at least FOUR useful graphs that give insight into the ice cream sales trends.
For example, here are some suggestions:
There are three deliverables in two parts. Part A Due on Friday September 11 and Part B Due on Saturday September 12. The following are what you will be submitting for each part.
For improving the business there are many parts need to upgrade. Human errors leads to huge losses to the organization. Errors are common for everyone but sometimes minimal errors leads to big problem. This topic also states the human error in the ice cream store that leads to business loss. In this assignment the management of the ice cream shop wants implement the automation system for the entire billing system. Because this process involves too much complexity. So the automation is the only solution for improvement of the effective process.
which is done by the computer itself. In this topic various things will be going to done like the automatic billing system and automatic customer payment etc. the other things like graphical representation for the things like temperature for knowing the temperature and total sales for finding the total amount received by the given region are going to be analyzed in this part.
Ordering system
Coding and screenshots
Main python file
Checkoutregister python file
Product python file
Output
The above figure represents the output for the ice cream shop. The billing process is automatically done by the system. For example the input was taken from the customer like whatever they want. Later it shows the payment due for the customer products. So again the customer needs enter the payment amount to the billing process. Then it will show the total amount and with the return amount which is the minus amount from the given total.
The above figure represents the different cones, toppings and different flavors which are available in the ice cream shop.
Ice cream trends
All most all the business are upgraded according to the time changes. In previous days the up gradation of the particular product is very slow. Whereas now a days the updating of the product is very fast and becomes trending. Due to the population increases and modern era updating makes every product impressive (Amador, Hartel & Rankin, 2017). In the same way this topic also states the up gradation of the ice cream store. Below zero is the local ice cream store that wants to improve. Improvement in the sense is not only with the products and also needs improvement in other various things like the system needs to automatically calculate the total price without anyone help.
The automatic calculation includes the input from the user like their name, address and their payable amount etc. the customers must need to choose the orders by their own. The things like cone shapes, flavors and toppings are up to their wish. The system just need to calculate the total price according to the total. The code must have some logic like the minimum and maximum things. For example sometimes some the lazy customers can able misuse the system like pressing all the options at a same time. So the code must need to avoid these kind of things. For that the algorithm and logic should be coded. In our code we avoided these kind of errors by means minimum and maximum logic.
The minimum logic contains the user must select at least one cone type for further proceedings. The maximum logic contains the user not permitted to select the 4 toppings per ice cream. If they try to do that then the system will prints the error message. The maximum logic also includes the user not permitted to select the scoops more than 3 times for an ice cream (Warren & Hartel, 2014).
The above figure represents the working of the project in the jupyter notebook. All the csv files are converted in to txt files to minimize the output time for the jupyter notebook. The StoreDetails.csv and WeeklySales.csv and Region.csv files are need to upload in a same project in the jupyter notebook. Otherwise the graph won’t be generated.
The above graph represents the values which is taken as an output during the jupyter notebook execution. The details like store, date, temperature and unemployment are there in the StoreDetails.csv file. Where the store column represents the details of the different stores. The value 1 represents the store with name 1. The date column represents the different dates which is used to know about the different transactions held on the particular date. The temperature column represents the different the highest temperature of the particular date for the particular store.
This temperature column is the important column because for an ice cream shop the temperature plays the major role. Because if the temperature is too high then the coolness of the ice cream may also less and leads to wastage. So temperature is also noted for the each and every stores. The unemployment column denotes the number of the people who are not working yet.
The above figure represents the different variables which are used to represent the values in a graphical representation. The variable (? store) represented in the x axis and Date is represented in the y axis.
The above figure represents the graphical representation of the different dates for a store 1. The different dates are represented in the y axis and store 1 in the x axis.
The above graph represents the actual output for the whole data in the store details csv file. There lot of data are there in the given csv file. Among the data are combined and shown together in the graph. The x axis represents the store details for the different stores. The store details represents the name of the stores. The y axis represents the different dates for the different stores.
From this topic various things were done successfully. The automatic billing system for the below zero ice cream shop was done. The coding and logic of the program was also done successfully. The logic for the minimum and maximum also executed and completed. Taking inputs from the users and calculation of billing process was also done successfully. From this analysis the users input errors were minimized mostly and a good interface between the ice cream shop and customers was created the successfully. The customers can able to select their own from this automatic system. Hence the time saved and error minimized and also customers can select according to their wish. Hence the improvement for the business shown.
Amador, J., Hartel, R., & Rankin, S. (2017). The Effects of Fat Structures and Ice Cream Mix Viscosity on Physical and Sensory Properties of Ice Cream. Journal Of Food Science, 82(8), 1851-1860. doi: 10.1111/1750-3841.13780
Warren, M., & Hartel, R. (2014). Structural, Compositional, and Sensorial Properties of United States Commercial Ice Cream Products. Journal Of Food Science, 79(10), E2005-E2013. doi: 10.1111/175To export a reference to this article please select a referencing stye below:
My Assignment Help. (2021). Data Visualization. Retrieved from https://myassignmenthelp.com/free-samples/ict702-data-visualization/cream-store.html.
"Data Visualization." My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/ict702-data-visualization/cream-store.html.
My Assignment Help (2021) Data Visualization [Online]. Available from: https://myassignmenthelp.com/free-samples/ict702-data-visualization/cream-store.html
[Accessed 07 March 2021].
My Assignment Help. 'Data Visualization' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/ict702-data-visualization/cream-store.html> accessed 07 March 2021.
My Assignment Help. Data Visualization [Internet]. My Assignment Help. 2021 [cited 07 March 2021]. Available from: https://myassignmenthelp.com/free-samples/ict702-data-visualization/cream-store.html.
Get started with MyAssignmenthelp.com for all the critical academic tasks including referencing of your paper. We have a separate team who makes sure every page is cited correctly as per your reference citation style. We have got all the equipment like advanced paraphrasing tools, APA citation machine, MLA citation machine and many more to scan your paper thoroughly.
It is not always possible to remember every referencing style by heart. And now, there’s no need for that as our experts are well versed at following every referencing and citation style including Vancouver referencing and MHRA referencing with perfection.
Answer: Introduction: Hans Rosling in his presentations entitled as ‘Hans Rosling shows the best stats you’ve ever seen’ describes how the security of the nations can get affected by the international trends of data on health (Rosling, 2006). In the video, Dr. Rosling illustrated the endless use of graphical data, summarization of visual data and relevant quantitative analysis that includes wide range of tables that ran...
Read MoreAnswer: The business rules from the case study are; MPloy airline has many flights. A flight has many passengers on board. A flight uses one and only one airplane. A flight has one and only one pilot who flies the single plane. The airline has many maintenance procedures that are done on airplanes. A maintenance event involves one airplane undergoing one procedure. Entities and attributes Based on the business rules and the case st...
Read MoreAnswer: Introduction Database industry has been undergoing through waves of changes in recent past. These waves of changes have been engineered by technological advancements and the need to make database development and maintenance simple, reliable and efficient. It is important for database developers, architects and IT specialist to understand some of these changes so that they are prepared for any changes (Wang et al., 2012). These technol...
Read MoreAnswer Database design and development ER Diagram The ER Diagram is very important step to be taken before the physical design of the database...
Read MoreAnswer: A booking can contain more than one passenger with multiple booking. Each booking should have a maximum number of passengers for which booking on a flight can be done. There will be only one employee/pilot for a flight at an instance. An employee may have multiple flights but not on same date. The employees with training status could not be assigned to a flight. The booking for a flight would have a highest limit...
Read MoreJust share requirement and get customized Solution.
Orders
Overall Rating
Experts
Our writers make sure that all orders are submitted, prior to the deadline.
Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.
Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.
Our writers can provide you professional writing assistance on any subject at any level.
Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.
Get all your documents checked for plagiarism or duplicacy with us.
Get different kinds of essays typed in minutes with clicks.
Calculate your semester grades and cumulative GPa with our GPA Calculator.
Balance any chemical equation in minutes just by entering the formula.
Calculate the number of words and number of pages of all your academic documents.
Our Mission Client Satisfaction
It was delivered in time and I have had a good mark. I recommend this site and I am getting more assignments from them
Australia
Awesome! If you could please provide me with accessible links for references because the ones were provided need to create an account. Regards
Australia
Within a short time, the expert manages to complete the assignment beautifully! I scored well and I am very happy with it. Thanks
Australia
It's amazing solution and still I will apply it in university system, hopefully it's got high score Thanks
Australia