Advertisement
Guest User

Untitled

a guest
Apr 6th, 2020
211
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.00 KB | None | 0 0
  1. with open('problem5.csv', 'rb') as f:
  2.     data = f.readlines()
  3.  
  4.     price_table = {}
  5.  
  6. for i, line in enumerate(data):
  7.     processed_line = line.decode().strip().split(';')
  8.     if i == 0:
  9.         product_names = [product_name for product_name in processed_line if len(product_name) > 0]
  10.     else:
  11.         supermarket = processed_line[0]
  12.  
  13.         price_table.update({
  14.             supermarket: {product_name: float(price) for product_name, price in zip(product_names, processed_line[1:])}
  15.         })
  16.        
  17. cheapest_product = []
  18. min_price = None
  19. for supermarket, products in price_table.items():
  20.     new_min = min(products.values())
  21.     if not min_price:
  22.         min_price = new_min
  23.    
  24.     elif new_min <= min_price:
  25.         min_price = new_min
  26.         for product_name, price in products.items():
  27.             if price == min_price:
  28.                 if not cheapest_product:
  29.                    cheapest_product = (product_name, supermarket, min_price)
  30.                    
  31. cheapest_product
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement