ST2187 Lecture 5 — различия между версиями

Версия 17:52, 16 октября 2020

Home work

1. Home work from UoL

https://drive.google.com/file/d/1NDglH4KfC7L6AxPsHVZKcuwOf_7efoq7/view?usp=sharing

Data for home work https://drive.google.com/file/d/1siUVltHO-YhKwPJrauhlpAhihIell-9T/view?usp=sharing

Results should be in https://drive.google.com/drive/folders/1cipnGd8fKgh8RcUU3OwdqUNTPATTTSUw?usp=sharing as file ST2187-2020-FIO-FIO-task5.py and ST2187-2020-FIO-FIO-task5.png

Deadline passed to next week.

2. Backery orders data set

In HSE-Orders.zip https://drive.google.com/file/d/1dGeU4joCPjWMF9hXALPYRM8G7HxtAoAx/view?usp=sharing there are 7 files in xslx Excel format for clients requests and orders for the one week

Students should convert data to any format and get the acces from Python

The first case is to determine the HSE-bakery-ABC.csv

Not for delivery. Results should be in https://drive.google.com/drive/folders/1lz8LVI38hsnLD8wH6mejK4yko8lDDLIh?usp=sharing as file HSE-bakery-ABC-FIO-FIO.csv

The second case is to provide daily statistics for production delivery in boxes and items for A,B,C and D groups ant Total as a histogram HSE-bakery-OrdersHist-FIO-FIO.png

UPD: Due to problems with the dataset this task could be calculated in boxes. Students should ignore the items column.

• 

  The idea of histogram

3. Tableau

Students should connect Tableau to Backery orders data set , calc a histogram HSE-bakery-OrdersHistTableau-FIO-FIO.png and load it to https://drive.google.com/drive/folders/1bew3_vkcP-LPLO12svGb-av9DeVIeIF_?usp=sharing

Back to the course beginning ST2187_Business_analytics,_applied_modelling_and_prediction