Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- with open('problem5.csv', 'rb') as f:
- data = f.readlines()
- price_table = {}
- for i, line in enumerate(data):
- processed_line = line.decode().strip().split(';')
- if i == 0:
- product_names = [product_name for product_name in processed_line if len(product_name) > 0]
- else:
- supermarket = processed_line[0]
- price_table.update({
- supermarket: {product_name: float(price) for product_name, price in zip(product_names, processed_line[1:])}
- })
- cheapest_product = []
- min_price = None
- for supermarket, products in price_table.items():
- new_min = min(products.values())
- if not min_price:
- min_price = new_min
- elif new_min <= min_price:
- min_price = new_min
- for product_name, price in products.items():
- if price == min_price:
- if not cheapest_product:
- cheapest_product = (product_name, supermarket, min_price)
- cheapest_product
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement