DanielHannon

QtySold

Jan 22nd, 2019
157
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.59 KB | None | 0 0
  1. Itemref = []
  2. Itemqty = []
  3. Itemqtysold = []
  4. indexVal = 0
  5. text = open("SampleData.txt","r")
  6. for line in text:
  7.   Rline = line.split()
  8.   if (Rline[0] != "OrderDate"):
  9.     if(Rline[3] not in Itemref):
  10.       Itemref.append(Rline[3])
  11.       Itemqty.append(int(Rline[4]))
  12.       Itemqtysold.append(float(Rline[6]))
  13.     else:
  14.       indexVal = Itemref.index(Rline[3])
  15.       Itemqty[indexVal] += int(Rline[4])
  16.       Itemqtysold[indexVal] += float(Rline[6])
  17. text.close()
  18. print("Item   Qty sold    Total")
  19. for a in range(len(Itemref)):
  20.     print("%s  %s  %s"%(Itemref[a],Itemqty[a],Itemqtysold[a]))
Advertisement
Add Comment
Please, Sign In to add comment