Time for action—calculating World Cup statistics by grouping data
Let's forget the examinations for a while, and retake the World Cup tutorial from the previous chapter. The file you obtained from that tutorial was a list of results of football matches. These are sample rows of the final file:
Match Date;Home Team;Away Team;Result 02/06;Italy;France;2-1 02/06;Argentina;Hungary;2-1 06/06;Italy;Hungary;3-1 06/06;Argentina;France;2-1 10/06;France;Hungary;3-1 10/06;Italy;Argentina;1-0 ...
Now you want to take that information to obtain some statistics such as the maximum number of goals per match in a given day. To do it, follow these instructions:
- Create a new transformation, give it a name and description, and save it.
- By using a Text file input