import numpy

dataset = numpy.loadtxt(open('beeradvocate5.csv', "rb"), delimiter = ',')
dataset = [[(y-1)*5 for y in x] for x in dataset]

print("1) " + str(len(dataset)))
print("2) " + str(numpy.average([r[0] for r in dataset])))
print("3) " + str(numpy.average([r[1] for r in dataset])))
print("4) " + str(numpy.average([r[2] for r in dataset])))
print("5) " + str(numpy.average([r[3] for r in dataset])))
print("6) " + str(numpy.average([r[4] for r in dataset])))
print("7) " + str(max([r[0] for r in dataset])))
print("8) " + str(numpy.average([r[1] for r in dataset[:500]])))
print("9) " + str(numpy.average([r[1] for r in dataset[-500:]])))
print("10) " + str(numpy.median([dataset[i][1] for i in numpy.arange(start = 0, stop = len(dataset), step = 2)])))
print("11) " + str([r[4] for r in dataset].index(max([r[4] for r in dataset]))))
print("12) " + str([numpy.var([r[i] for r in dataset]) for i in numpy.arange(len(dataset[0]))]) + " => taste")
print("13) " + str(sum(1 for _ in filter(lambda x: x > 15.0, numpy.array(dataset).flatten()))))
print("14) " + str(sum(1 for _ in filter(lambda x: x > 15.0, [r[1] for r in dataset]))))
print("15) " + str(sum(1 for _ in filter(lambda x: x[0] > x[1], zip([r[1] for r in dataset], [numpy.average([r[1] for r in dataset])] * len(dataset))))))
print("16) " + str(sum(1 for _ in filter(lambda x: x[0] > x[1], zip([r[2] for r in dataset], [numpy.median([r[2] for r in dataset])] * len(dataset))))))
print("17) " + str(sum(1 for _ in filter(lambda x : all(y > 15.0 for y in x), dataset))))
print("18) " + str(numpy.average([a[4] for a in filter(lambda x: x[3] > 15.0, dataset)])))
print("19) " + str(sorted([(i, numpy.average(dataset[i])) for i in numpy.arange(len(dataset))], key=lambda x: x[1], reverse=True)[1][0]))
print("20) " + str(sorted(filter(lambda x: x[1]>15.0, [(i, numpy.average(dataset[i]), dataset[i][3]) for i in numpy.arange(len(dataset))]), key=lambda x: x[2])[0]))

med = numpy.median([r[4] for r in dataset])
print("21) " + str(numpy.average([r[1] for r in filter(lambda x: x[4] > med, dataset)])))

print("22) " + str(max([numpy.average(dataset[i], weights = [6.,1.,0.5,0.,2]) for i in numpy.arange(len(dataset))])))
print("23) " + str(list(map(lambda d: numpy.average(d, weights = [6.,1.,0.5,0.,2]), dataset)).index(max([numpy.average(dataset[i], weights = [6.,1.,0.5,0.,2]) for i in numpy.arange(len(dataset))]))))