Advertisement
Arfizato

Untitled

May 2nd, 2022
1,097
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.46 KB | None | 0 0
  1. import sys
  2. from datetime import datetime
  3.  
  4. for line in sys.stdin:
  5.     data = line.strip().split(",")
  6.     if len(data) == 7:
  7.         winery, wine, year, rating, numreviews, region, price = data
  8.         print ("{0}\t{1}".format(winery, price, rating, numreviews))
  9.  
  10.  
  11. #!/usr/bin/python
  12.  
  13. import sys
  14.  
  15. totalPrice = 0
  16. numberOfItems = 0
  17. totalRating=0
  18. totalReviews=0
  19.  
  20. oldKey = None
  21.  
  22.  
  23. print ("{:<70} {:<20} {:<10} {:<20}|| {:<20} {:<10}\n\n".format( "Winery Name","Total Revenue","Recurrence","Average Revenue","Average Rating","# Reviews"))
  24.  
  25. for line in sys.stdin:
  26.     data_mapped = line.strip().split("\t")
  27.     if len(data_mapped) != 4:
  28.         # Something has gone wrong. Skip this line.
  29.         continue
  30.  
  31.     thiskey, currentPrice, currentRating, numberOfReviews = data_mapped
  32.  
  33.     if oldKey and oldKey != thiskey:
  34.         print ("{:<70} {:<20} {:<10} {:<20}|| {:<20} {:<10}".format( oldKey,totalPrice,numberOfItems,totalPrice/numberOfItems,totalRating/numberOfItems,totalReviews))
  35.         oldKey = thiskey;
  36.         totalPrice = 0
  37.         numberOfItems=0
  38.         totalRating=0
  39.         totalReviews=0
  40.  
  41.  
  42.     oldKey = thiskey
  43.     numberOfItems+=1
  44.     totalPrice += float(currentPrice)
  45.  
  46.     totalRating+=float(currentRating)
  47.     totalReviews+=int(numberOfReviews)
  48.  
  49.  
  50. if oldKey != None:
  51.     print ("{:<70} {:<20} {:<10} {:<20}|| {:<20} {:<10}".format( oldKey,totalPrice,numberOfItems,totalPrice/numberOfItems,totalRating/numberOfItems,totalReviews))
  52.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement