Data Wrangling Kata

Inspired by Dave Thomas' Data Munging Kata

Kata

Part 1

• Download Daily Weather data for Morristown, NJ for June 2002
• Output the day number (column one) with the smallest temperature spread (the max temperature is the second column, the min is in the third column).

Part 2

• Download 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 (e.g. Arsenal scored 79 goals against opponents, and had 36 goals scored against them).
• Print the name of the team with the smallest difference in ‘for’ and ‘against’ goals.

Format

• Pair Programming
  • One laptop per pair
  • Driver - Navigator or Ping Pong
• Test-Driven Development (TDD)
• Write Clean Code
• Pomodoro Sessions 30-45 minutes
• Small Discussion after each session

Themes

• File I/O
• String Parsing
• Regular Expressions
• Refactoring