Translate MLB team schedule from csv into json

csv2json.py

# Go to http://mlb.mlb.com/mlb/schedule/team_by_team.jsp
# Click on Regular Schedule
# Scroll down and click on Downloadable schedule
# e.g. http://sanfrancisco.giants.mlb.com/schedule/downloadable.jsp?c_id=sf&year=2012
# Download Full Season Schedule

# Suggestions for future enhancements:
# TODO: come up with a column schema way of representing the csv
#       (referring to column names is more elegant than num indices)
# TODO: take file names as command line arguments

import csv
import json

source_csv = "test.csv"
destination_json = "test.json"

raw_schedule = csv.reader(open(source_csv, 'r'), delimiter=',')
schedule = []

# This CSV has 17 fields for each game, but we only want the following
# four fields, which will look like this:

# "date": "4/6/2012"        row[0]
# "opponent": "D-backs"     row[3]
# "time": "4:10pm"          row[2]
# "location":"Chase Field"  row[4]

for row in raw_schedule:
    # Remove the space and make "pm" lowercase
    time = ''.join(c.lower() for c in row[2] if not c.isspace())

    # Trim the subject description down to the opponent name
    opponent = row[3]
    opponent = opponent.replace('at', '').replace('Giants', '').strip()

    json_data = { "date": row[0],
                  "opponent": opponent,
                  "time": time,
                  "location": row[4] }
    schedule.append(json_data)

full_contents = { "title": "Giants Game Schedule",
                  "link": "http://www.isthereagiantsgametoday.com/",
                  "games": schedule }

# Pretty printing, just like in the json library docs example
# http://docs.python.org/library/json.html
f = open(destination_json, 'w')
f.write(json.dumps(full_contents, sort_keys=True, indent=4))