OECD International Student Assessment 2012 - Transposed.csv

OECD International Student Assessment 2012.csv

transpose.py

import csv

with open('OECD International Student Assessment 2012 - Transposed.csv', 'wb') as destfile:
    writer = csv.writer(destfile)
    writer.writerow(['country', 'subject', 'gender', 'value'])
    with open('OECD International Student Assessment 2012.csv', 'rb') as sourcefile:
        for d in csv.DictReader(sourcefile):
            country = d.pop('Country')
            for variable, value in sorted(d.items()):
                i = variable.find(" ")
                row = [country, variable[0:i].lower(), variable[i+1:].lower(), value]
                writer.writerow(row)