` import pandas as pd
pd.set_option("display.width",1000) url ="https://raw.githubusercontent.com/jokecamp/FootballData/master/UEFA_European_Championship/Euro%202012/Euro%202012%20stats%20TEAM.csv"
euro12 = pd.read_csv(url, sep=',')
print(euro12["Goals"])
print(euro12.Goals)
print(euro12.shape[0])
print(euro12.info())
discipline = euro12[["Team","Yellow Cards","Red Cards"]]
print(discipline)
print(discipline.sort_values(["Red Cards","Yellow Cards"],ascending=False))
print(discipline['Yellow Cards'].mean())
print(round(discipline['Yellow Cards'].mean()))
print(euro12[euro12.Goals>6])
print(euro12[euro12.Team.str.startswith("G")])
print(euro12.iloc[:,0:7])
print(euro12.iloc[:,:-3])
print(euro12.loc[euro12.Team.isin(["England","Italy","Russia"]),['Team',"Shooting Accuracy"]])
本文由 所长 创作,采用 知识共享署名4.0 国际许可协议进行许可 本站文章除注明转载/出处外,均为本站原创或翻译,转载前请务必署名 最后编辑时间为: Apr 23, 2018 at 08:08 am