Analyze AppStore Daily Reports

proceedsappstore.py

import glob

d = {}
for fn in glob.glob('appsales/*.txt'):
    lines = open(fn, 'r').readlines()[1:]
    # print fn
    for l in lines:
        l = l.split('\t')
        if len(l) == 18: # only newest format
            proceeds = float(l[8])
            customerPrice = float(l[15])
            country = l[12]
            if proceeds > 0 and l[11]==l[13]: # and country not in d:
                # print country, proceeds, customerPrice, l, fn
                d[country] = d.get(country, []) + [proceeds / customerPrice]
                
for k in sorted(d.keys()):
    print "%s   %.2f%%" % (k, d[k][0] * 100)