Example of how to convert a csv file to a table of ranked headers for each row

ranker.py

#!/usr/bin/env python
import csv
import json
r = csv.reader(open("data.csv"))
headers = r.next()
countries = headers[1:]

def saveData(output):
    filename = "ranked"
    print "Writing JSON output to %s.json" % filename

    json_file = open('%s.json' % filename, 'w')

    json_file.write(json.dumps(output))

    json_file.close()

output = []
with open("ranked.csv","w") as f:
    w = csv.writer(f)
    w.writerow(['Area','#1','#2','#3','#4','#5'])
    for row in r:
        area = row[0]
        values = map(int,row[1:])
        vc = zip(values,countries)
        vc.sort()
        vc.reverse()
        out_row = [area]
        vcCount = -1
        rowSelect = -1
        adjust = 0
        once = 0
        for value, country in vc:
            vcCount = vcCount + 1
            rowSelect = rowSelect + 1 - adjust
            data = []
            if value != 0:
                if vcCount-1 != -1:
                    if value == vc[vcCount-1][0]:
                        if once == 0: 
                            adjust = adjust + 1
                            once = 1
                        out_row[rowSelect] = "[" + out_row[rowSelect].replace('[', '').replace(']','') + "," + country + "]"
                    else:
                        adjust = 0
                        once = 0
                        out_row.append(country)
                else:
                    out_row.append(country)
                if(len(out_row) == 6):
                    break
        output.append(out_row)
        w.writerow(out_row)
    f.close()
saveData(output)