import csv answer_views = 0.0 question_views = 0.0 missing_answer = 0.0 missing_question = 0.0 with open("akc_views.txt", "r") as f: reader = csv.reader(filter(lambda row: row[0]!="#", f), delimiter=",") for row in reader: answer_views += int(row[2]) question_views += int(row[3]) try: missing_answer += int(row[4]) missing_question += int(row[5]) except IndexError: pass # add 1 to https://www.wolframalpha.com/input/?i=number%20of%20days%20from%20april%201%2C%202015%20to%20december%2031%2C%202015 days = 275 #missing_answer += 12 #missing_question += 12 # prorate answer_views = (days/(days - missing_answer)) * answer_views question_views = (days/(days - missing_question)) * question_views money_due = answer_views/500.0 + question_views/30000.0 if __name__ == "__main__": print("money due: ${}".format(money_due))