a quick and dirty way to convert US dates to British dates generated by Facebook Page Insights

convertDates.py

import csv
import re

with open("test.csv", "r+") as f:
    with open("testoutput.csv", "w+") as g:
        reader = csv.DictReader(f)
        writer = csv.DictWriter(g, reader.fieldnames)
        for row in reader:
            date = row["Posted"]
            m = re.match(r"^(\d\d)/(\d\d)(.*)$", date)
            month = m.group(1)
            day = m.group(2)
            rest = m.group(3)
            row["Posted"] = day + "/" + month + rest
            writer.writerow(row)