Advertisement
sergefr

Sales

Apr 19th, 2019
427
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.84 KB | None | 0 0
  1. REGION = 0
  2. PROFIT = 13
  3.  
  4. def read_data(file_name):
  5.     data = []
  6.     with open(file_name, 'r', encoding='utf-8') as f:
  7.         f.readline()
  8.         for line in f:
  9.             parts = line.split(',')
  10.             row = [parts[0], parts[1], parts[2], parts[3],
  11.                    parts[4], parts[5], int(parts[6]), parts[7],
  12.                    int(parts[8]), float(parts[9]), float(parts[10]),
  13.                    float(parts[11]), float(parts[12]), float(parts[13])]
  14.             data.append(row)
  15.     return data
  16.  
  17.  
  18. # https://pastebin.com/sjymFP0U
  19. def profit_for_region(data, region):
  20.     total_profit = 0
  21.     for row in data:
  22.         if row[REGION] == region:
  23.             total_profit += row[PROFIT]
  24.     return total_profit
  25.  
  26.  
  27. data = read_data('sales.csv')
  28. print(data[0])
  29. print(profit_for_region(data, 'Europe'))
  30. print(profit_by_region(data))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement