root_convert.py

# Converts a Root.co.za CSV export of outgoing transactions
# into a format that can be imported into Google Maps

import csv
from datetime import datetime

# Parse:
with open('rootexport.csv') as data:
    rdr = csv.DictReader(data)
    transactions = [(
        datetime.strptime(tx['Date']+tx['Time'],'%Y/%m/%d%H:%M'), 
        tx['Description'].replace('ZAF','').strip(),
        float(tx['Amount'])
    ) for tx in rdr]

# Filter (Only payments larger than the R1 test payments):
transactions = [tx for tx in transactions if tx[2] < -2.0]

# Format:
formatted = [(
    tx[1],
    '%s - R%s' % (datetime.strftime(tx[0],'%a %d %b %H:%M'), abs(tx[2]))
    ) for tx in transactions]
formatted.insert(0, ('Address', 'Details'))
# Write to file for Google Maps import:
with open('maps.csv','w') as out:
    writer = csv.writer(out)
    writer.writerows(formatted)