DataAnalysis

Description

Script reads data from test files. Each test file consists of header of code of names of drinks e.g.:

• DE double espresso
  
• SE Espresso
  
• DMC Double Macciato
  
• MC Macciato
  

Then there is row consists of time of the order and ordered drinks e.g.:

• 11:54 DE SE
  
• 11:51 MC SE
  
• 11:46 2DMC
  

Digit before drink code says number of ordered drinks. In case of ordered whole bottle of wine there is "b" before wine code e.g.:
'11:44 bCasaPiane' says it was ordered 1 bottle of CasaPiane

How it works?

Script creates array of drinks symbols as keys, and number of ordered drinks as values. Script gives quick, short report which says how many drinks was ordered/made.
Current script creates also second array of drinks symbols as keys, and then creates array of time of order for each drink (3-d array).
It allows to check how many drinks was ordered in particular period of time.

Features:

• counting drinks (total and in periods of time)
  
• sorting:
  
  • by name
    
  • by type (coffee or not)
    
  • by time of order
    
  • by type of coffee (latte, cappucino etc)
    
• data visualisation using JpGraph version 3.5.0b1