# python小练习 求姓张的薪资平均值

import pandas as pd
emp=[['张三','财务部',5000],
     ['李四','财务部',5800],
     ['王五','行政部',5100],
     ['赵六','行政部',5300],
     ['张华','技术部',6200],
     ['李八','技术部',6500],
     ['张扬','技术部',6300],
     ['陈九','技术部',6500]]
data = pd.DataFrame(emp, columns=["name", "partion", "salary"])

total_count = 0
num = 0
for index, i in enumerate(data['name']):
    if i[0]=="张":
        total_count = total_count + data['salary'][index]
        num = num + 1

print("平均值为:{}".format(total_count/num))

这里的重点就是下面这条代码，我们需要使用索引和迭代函数去对应和匹配

for index, i in enumerate(data['name']):