我有一个制表符分隔的文本文件,其格式如下:
TITLE FSAL
Professor "30,000.00"
Professor 0
Staff "90,000.00"
Professor "50,000.00"
Manager "80,000.00"
Professor "40,000.00"
我的目标是按最高的平均工资来排列职位。到目前为止,我掌握的代码是:
from collections import Counter
job_file = open("jobs.txt", "r")
headers = job_file.readline()
titles = []
salaries = []
for line in job_file.readlines():
line.rstrip()
(title, fsal) = line.split('\t')
#convert fsal from string to float,
fsal = float(fsal.replace('"', '').replace(',', ''))
titles.append(title)
salaries.append(fsal)
#Average salary for all titles
avg_salary = sum(salaries)/len(titles)
print "Average salary for all titles = ", avg_salary
#Average salary for all titles = 48333.3333333
如何按职务输出平均工资,以便使用.sort()按最高平均工资对他们进行排序,即:
average salary for Professor = 30000.0 #(30000.0 + 0.0 + 50000.0 + 40000.0)/4
average salary for Staff = 90000.0 #90000.0/1
average salary for Manager = 80000.0 #80000.0/1
最终输出应如下所示:
1. Staff 90000.0
2. Manager 80000.0
3. Professor 30000.0
编辑:OP希望每个职位的平均值:
相关问题 更多 >
编程相关推荐