Looking for advice for what looks to me like clumsy code.
I have a large csv (effectively garbage) dump. I have to pull out sales
information per employee and count them by price range. I've got my code
working, but I'm thinking there must be a more refined way of doing this.
---snippet of what I have---
EMP1 = [0,0]
EMP2 = [0,0]
EMP3 = [0,0]
for line in (inputfile):
content = line.split(",")
if content[18] == "EMP1":
if float(content[24]) < 99.75:
EMP1[0] += 1
elif float(content[24]) > 99.74:
EMP1[1] += 1
if content[18] == "EMP2":
if float(content[24]) < 99.75:
EMP2[0] += 1
elif float(content[24]) > 99.74:
EMP2[1] += 1
if content[18] == "EMP3":
if float(content[24]) < 99.75:
EMP3[0] += 1
elif float(content[24]) > 99.74:
EMP3[1] += 1
and repeat if statements for the rest of 25+ employees. I can make a
list of the employees, but I'd prefer to pull them from the csv, as our
turnover is rather high (however this is not important). I'm thinking
another "for employee in content[18]" should be there, but when I tried,
my numbers were incorrect.
Any help / advice is appreciated,
Matt
--
https://mail.python.org/mailman/listinfo/python-list
