def reviewmain(): input_file_name = 'data/reviews.xlsx' output_file_name = 'data/reviews_out' input_sheet_name = 'reviews' output_sheet_name = 'reviews' #Initialize from given settings book_in = open_workbook(input_file_name) sheet_in = book_in.sheet_by_name(input_sheet_name) amzn = AmazonScraper(AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_ASSOCIATE_TAG) book_out = Workbook() sheet_out = book_out.add_sheet(output_sheet_name) ids = sheet_in.col_values(0,1) io = input('starting point?') i = io while i < len(ids): row = ids[i][:-1] print 'Item ',i+1 result = 0 count = 0.0 for j in row.split(','): r = amzn.review(Id=j) count +=1 result += r.rating*5 add_data(sheet_out, i, [result/count]) book_out.save(output_file_name + 'helpdec19.xls') i += 1