Skip to content

Instantly share code, notes, and snippets.

@philipefarias

philipefarias/data_munging.md

Last active June 22, 2017 03:38
Show Gist options
  • Save philipefarias/827455679d55759e119f9aff53e7d320 to your computer and use it in GitHub Desktop.
Save philipefarias/827455679d55759e119f9aff53e7d320 to your computer and use it in GitHub Desktop.
Download ZIP
Code Kata: Data Munging. Here’s an exercise in three parts to do with real world data. Try hard not to read ahead—do each part in turn.
Raw
data_munging.md

Code Kata: Data Munging

Part One: Weather Data

In weather.dat you'll find daily weather data for Morristown, NJ for June 2002. Download this text file, then write a program to output the day number (column one) with the smallest temperature spread (the maximum temperature is the second column, the minimum the third column).

Part Two: Soccer League Table

The file football.dat contains the results from the English Premier League for 2001/2. The columns labeled 'F' and 'A' contain the total number of goals scored for and against each team in that season (so Arsenal scored 79 goals against opponents, and had 36 goals scored against them). Write a program to print the name of the team with the smallest difference in 'for' and 'against' goals.

Part Three: DRY Fusion

Take the two programs written previously and factor out as much common code as possible, leaving you with two smaller programs and some kind of shared functionality.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment