Prints usage for Amazon Route 53 zones for a given time period

parse_route53_usage.py

"""
Prints usage for Route 53 for a given time period
(exported from the Amazon Route 53 usage console).
"""

import csv
route53_reader = csv.reader(open('route_53_usage_february_2012.csv', 'rb'), delimiter=',', quotechar='|')
route53_reader.next() # Skip header

zone_lookup = dict('INSERT_ZONE_ID'='mydomain.com')

def lookup_zone(zone):
	n = zone_lookup.get(zone, None)
	if not n: return zone
	return n

dns_requests = {}
for row in route53_reader:
	if len(row) == 0: continue
	zone = row[3]
	num_requests = row[6]
	if not zone in dns_requests:
		dns_requests[zone] = 0

	dns_requests[zone] = dns_requests[zone] + int(num_requests)

dns_request_items = dns_requests.items()
dns_request_items.sort(key=lambda t: t[1], reverse=True)
for zone, num_requests in dns_request_items:
	print "%25s %11d" % (lookup_zone(zone), num_requests)