江财2学位python第11次实验

#代码：
import pandas as pd
df = pd.read_csv('/Users/caizuguang/Desktop/2018世界杯球队数据.csv',encoding = 'gbk')
print("2.净胜球大于0的队伍：")
print("-"*30)
print(df.球队[df.进球> df.失球])
print("="*30)
print(" ")
print("3.被罚红牌的队伍：")
print("-"*30)
print(df.球队[df.红牌==1])
print("="*30)
print(" ")
print("4.胜率大于10%的队伍：")
print("-"*30)
df1 = df[['球队','进球','射门']]
print(df1[(df1.进球 / df1.射门) > 0.1])
print(df['进球'].mean())
print("="*30)
print(" ")
print("5.进球数超过平均数且被罚黄牌少于5张的球队伍：")
print("-"*30)
df2 = df[['球队','进球','黄牌']]
print(df2[(df2.进球>df2.进球.mean()) & (df2.黄牌<5)] )
print("