Esempio n. 1
0
for hod in salesRead(input_file):  
    product_id = hod['Product ID']
    customer_id = hod['Customer ID']
    item_cost = hod['Item Cost']
    itemRevenue.put(product_id,float(item_cost))
    if(currentCustomer != customer_id):
        individual_cart = set()
    elif (product_id in individual_cart):
        continue
    individual_cart.add(product_id)
    item_set.add(product_id)
    itemCount.put(product_id,1)
    currentCustomer = customer_id
    


#  Now Write the stream data to file


header = [['Product ID','Customer Count','Total Revenue']]
with open(out_file, 'w') as writeFile:
    writer = csv.writer(writeFile)
    writer.writerows(header)
    for item in item_set:
        line =[[]]
        line=[[item,itemCount.get(item),round(itemRevenue.get(item),2)]]
        writer.writerows(line)
writeFile.close()