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
