def pingju(level='A'):
'''
每轮的平局次数
:return:
'''
s = MsqService().search(f"select round,count(*) from j21 where level='{level}' and zj = kj group by round;")
a = np.array(s)
matchround = a[:, 0]
allconner = a[:, 1]
plt.plot(matchround,allconner,
linewidth=2,
color='steelblue',
marker='o',
markersize=6,
markeredgecolor='black',
markerfacecolor='brown') # 示例
plt.xlabel("比赛轮数") # 横坐标名字
plt.xticks(range(0, 24, 1)) # (0,23) 范围0-23 ，单位 1
plt.yticks(range(0, 8, 1)) # (0,23) 范围0-100 ，单位 4
plt.ylabel(f" {level} 平局次数") # 纵坐标名字
plt.legend(loc = "best") # 图例
plt.show()
def bestzhu(level='A'):
'''
主场战绩最好的队伍
:return:
'''
data = MsqService().search(f"select zhu,count(*) as total from j21 where level='{level}' and zj-kj >=0 group by zhu order by total desc")
a = np.array(data)
zhuteam = a[:, 0]
allcount = a[:, 1]
# plt.plot(zhuteam,allconner,'s-',color = 'g',label="ATT-RLSTM") # 示例
# plt.xlabel("比赛轮数") # 横坐标名字
# plt.xticks(range(0, 24, 1)) # (0,23) 范围0-23 ，单位 1
# plt.yticks(range(0, 12, 1)) # (0,23) 范围0-100 ，单位 4
# plt.ylabel(f" {level} 半场进球小于1.5的次数") # 纵坐标名字
# plt.legend(loc = "best") # 图例
# plt.show()
# zhuteam=['川崎Ｆ','横浜FM','浦和','神戸','鹿島','鳥栖','湘南']
# allcount=[13,11,10,9,9,8,8]
plt.bar(zhuteam,allcount,align='center',alpha=1)
plt.yticks(range(0, 15, 1))
plt.ylabel('次数')
plt.xlabel('队伍')
plt.title('主场战绩最好的队伍排列')
plt.show()
def bestke(level='A'):
'''
客场战绩最好的队伍
:return:
'''
data = MsqService().search(f"select ke,count(*) as total from j21 where level='{level}' and zj-kj <=0 group by ke order by total desc")
a = np.array(data)
zhuteam = a[:, 0]
allcount = a[:, 1]
plt.bar(zhuteam,allcount,align='center',alpha=1)
plt.yticks(range(0, 15, 1))
plt.ylabel('次数')
plt.xlabel('队伍')
plt.title('客场战绩最好的队伍排列')
plt.show()
def getbanchangjinqiu(level='A'):
'''
# 每轮上半场进球小于1.5 的
'''
s = MsqService().search(f"select round,count(*) from j21 where level='{level}' and left(bc,1) + right(bc,1) < 1.5 group by round")
a = np.array(s)
matchround = a[:, 0]
allconner = a[:, 1]
plt.plot(matchround,allconner,'s-',color = 'g',label="ATT-RLSTM") # 示例
plt.xlabel("比赛轮数") # 横坐标名字
plt.xticks(range(0, 24, 1)) # (0,23) 范围0-23 ，单位 1
plt.yticks(range(0, 12, 1)) # (0,23) 范围0-100 ，单位 4
plt.ylabel(f" {level} 半场进球小于1.5的总次数") # 纵坐标名字
plt.legend(loc = "best") # 图例
plt.show()
def getallxiao(level='B',team='大宫'):
s = MsqService().search(f"select * from j21 where level='{level}' and zj+kj <=2 and (zhu='{team}' or ke='{team}')")
a = np.array(s)
matchteam = a[:, 0]
matchround = a[:, 1]
allconner = a[:, 2]
print(matchteam)
# matchTeam = list(map(addSpecial, matchround))
# fix_matchTeam = splitlist(matchTeam)
print(matchteam)
plt.plot(matchround,allconner,'s-',color = 'blue',label="角球趋势图") # 示例
plt.xlabel("比赛轮数") # 横坐标名字
plt.xticks(range(0, 24, 1)) # (0,23) 范围0-23 ，单位 1
plt.yticks(range(0, 17, 1)) # (0,23) 范围0-100 ，单位 4
plt.ylabel(f" {level} f{team} 的角球走势图") # 纵坐标名字
plt.legend(loc = 0) # 图例
plt.show()
def getjq8zhu(level='A'):
'''
主场 角球>=8 的 总次数
:return:
'''
s = MsqService().search(f"select zhu,count(zhu) as total from j21 where level='{level}' and zc+kc >=8 group by zhu order by total desc")
a = np.array(s)
matchround = a[:, 0]
allconner = a[:, 1]
plt.plot(matchround,allconner,'s-',color = 'g',label="主场角球最多的球队") # 示例
plt.xlabel("比赛轮数") # 横坐标名字
plt.xticks(range(0, 24, 1)) # (0,23) 范围0-23 ，单位 1
plt.yticks(range(0, 12, 1)) # (0,23) 范围0-100 ，单位 4
plt.ylabel(f" {level} 主场角球大于8 的总数") # 纵坐标名字
plt.legend(loc = "best") # 图例
plt.show()
def getjq8ke(level='A'):
'''
客场 角球>=8 的 总次数
:return:
'''
s = MsqService().search(f"select ke,count(zhu) as total from j21 where level='{level}' and zc+kc >=8 group by ke order by total desc")
a = np.array(s)
matchround = a[:, 0]
allconner = a[:, 1]
print(matchround)
matchTeam = list(map(addSpecial, matchround))
fix_matchTeam = splitlist(matchTeam)
print(fix_matchTeam)
plt.plot(fix_matchTeam,allconner,'s-',color = 'g',label="客场角球最多的球队") # 示例
plt.xlabel("比赛轮数") # 横坐标名字
plt.xticks(range(0, 24, 1)) # (0,23) 范围0-23 ，单位 1
plt.yticks(range(0, 12, 1)) # (0,23) 范围0-100 ，单位 4
plt.ylabel(f" {level} 客场角球大于8的总数") # 纵坐标名字
plt.legend(loc = "best") # 图例
plt.show()
def getJq(level='A'):
'''
# 每轮的角球总数
y = 轮数，round
allconner = 总数，total conner
'''
s = MsqService().search(f"select round,sum(zc+kc) from j21 where level='{level}' group by round")
a = np.array(s)
matchround = a[:, 0]
allconner = a[:, 1]
# allconner = [0.8222,0.918,0.9344,0.9262,0.9371,0.9353] # 总角球
# k2 = [0.8988,0.9334,0.9435,0.9407,0.9453,0.9453]#线2的纵坐标
plt.plot(matchround,allconner,'s-',color = 'g',label="ATT-RLSTM") # 示例
# plt.plot(matchround,k2,'o-',color = 'g',label="CNN-RLSTM")#o-:圆形
plt.xlabel("比赛轮数") # 横坐标名字
plt.xticks(range(0, 23, 1)) # (0,23) 范围0-23 ，单位 1
plt.yticks(range(0, 135, 5)) # (0,23) 范围0-100 ，单位 4
plt.ylabel("每轮的角球总数") # 纵坐标名字
plt.legend(loc = "best") # 图例
plt.show()
def getteamqj(level='A',team='川崎Ｆ'):
'''
获取某个队伍的角球趋势图
:param level:
:param team:
:return:
'''
s = MsqService().search(f"SELECT CONCAT(zhu,'-',ke) as bisai,round,zc+kc as total from j21 WHERE `level`='{level}' and (zhu= '{team}' or ke ='{team}') order by round")
a = np.array(s)
matchteam = a[:, 0]
matchround = a[:, 1]
allconner = a[:, 2]
print(matchteam)
# matchTeam = list(map(addSpecial, matchround))
# fix_matchTeam = splitlist(matchTeam)
print(matchteam)
plt.plot(matchround,allconner,'s-',color = 'blue',label="角球趋势图") # 示例
plt.xlabel("比赛轮数") # 横坐标名字
plt.xticks(range(0, 24, 1)) # (0,23) 范围0-23 ，单位 1
plt.yticks(range(0, 17, 1)) # (0,23) 范围0-100 ，单位 4
plt.ylabel(f" {level} f{team} 的角球走势图") # 纵坐标名字
plt.legend(loc = 0) # 图例
plt.show()