Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sys
- from datetime import datetime
- for line in sys.stdin:
- data = line.strip().split(",")
- if len(data) == 7:
- winery, wine, year, rating, numreviews, region, price = data
- print ("{0}\t{1}".format(winery, price, rating, numreviews))
- #!/usr/bin/python
- import sys
- totalPrice = 0
- numberOfItems = 0
- totalRating=0
- totalReviews=0
- oldKey = None
- print ("{:<70} {:<20} {:<10} {:<20}|| {:<20} {:<10}\n\n".format( "Winery Name","Total Revenue","Recurrence","Average Revenue","Average Rating","# Reviews"))
- for line in sys.stdin:
- data_mapped = line.strip().split("\t")
- if len(data_mapped) != 4:
- # Something has gone wrong. Skip this line.
- continue
- thiskey, currentPrice, currentRating, numberOfReviews = data_mapped
- if oldKey and oldKey != thiskey:
- print ("{:<70} {:<20} {:<10} {:<20}|| {:<20} {:<10}".format( oldKey,totalPrice,numberOfItems,totalPrice/numberOfItems,totalRating/numberOfItems,totalReviews))
- oldKey = thiskey;
- totalPrice = 0
- numberOfItems=0
- totalRating=0
- totalReviews=0
- oldKey = thiskey
- numberOfItems+=1
- totalPrice += float(currentPrice)
- totalRating+=float(currentRating)
- totalReviews+=int(numberOfReviews)
- if oldKey != None:
- print ("{:<70} {:<20} {:<10} {:<20}|| {:<20} {:<10}".format( oldKey,totalPrice,numberOfItems,totalPrice/numberOfItems,totalRating/numberOfItems,totalReviews))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement