image
項(xiàng)目全部代碼 & 數(shù)據(jù)集都可以訪問我的KLab --【Pyecharts】奧運(yùn)會數(shù)據(jù)集可視化分析～獲取辅柴，點(diǎn)擊Fork即可～
受疫情影響何暮，2020東京奧運(yùn)會將延期至2021年舉行审胸；
雖然延期，但此次奧運(yùn)會依舊會沿用「2020東京奧運(yùn)會」這個(gè)名稱；
這也將是奧運(yùn)會歷史上首次延期（1916年慷蠕、1940年、1944年曾因一戰(zhàn)，二戰(zhàn)停辦）讹语；
既然奧運(yùn)會延期了，那我們就來回顧下整個(gè)奧運(yùn)會的歷史吧????～
本項(xiàng)目將會從以下角度來呈現(xiàn)奧運(yùn)會歷史：
??各國累計(jì)獎(jiǎng)牌數(shù)蜂科；
??各項(xiàng)運(yùn)動(dòng)產(chǎn)生金牌數(shù)
-
??運(yùn)動(dòng)員層面
參賽人數(shù)趨勢
女性參賽比例趨勢
獲得金牌最多的運(yùn)動(dòng)員
獲得獎(jiǎng)牌/金牌比例
各項(xiàng)目運(yùn)動(dòng)員平均體質(zhì)數(shù)據(jù)
-
主要國家表現(xiàn)
????中國表現(xiàn)
????美國表現(xiàn)
??被單個(gè)國家統(tǒng)治的奧運(yùn)會項(xiàng)目
導(dǎo)入庫 & 數(shù)據(jù)
import pandas as pd
import numpy as np
import pyecharts
from pyecharts.charts import *
from pyecharts import options as opts
from pyecharts.commons.utils import JsCode
athlete_data = pd.read_csv('/home/kesci/input/olympic/athlete_events.csv')
noc_region = pd.read_csv('/home/kesci/input/olympic/noc_regions.csv')
# 關(guān)聯(lián)代表國家
data = pd.merge(athlete_data, noc_region, on='NOC', how='left')
data.head()
數(shù)據(jù)示例
累計(jì)獎(jiǎng)牌數(shù)
夏季奧運(yùn)會 & 冬季奧運(yùn)會分別統(tǒng)計(jì)
???夏季奧運(yùn)會開始于1896年雅典奧運(yùn)會顽决；
??冬季奧運(yùn)會開始于1924年慕尼黑冬奧會短条；
medal_data = data.groupby(['Year', 'Season', 'region',
'Medal'])['Event'].nunique().reset_index()
medal_data.columns = ['Year', 'Season', 'region', 'Medal', 'Nums']
medal_data = medal_data.sort_values(by="Year" , ascending=True)
medal_data = data.groupby(['Year', 'Season', 'region',
'Medal'])['Event'].nunique().reset_index()
medal_data.columns = ['Year', 'Season', 'region', 'Medal', 'Nums']
medal_data = medal_data.sort_values(by="Year" , ascending=True)
各國夏奧會累計(jì)獎(jiǎng)牌數(shù)
截止2016年夏季奧運(yùn)會，美俄分別獲得了2544和1577枚獎(jiǎng)牌才菠，位列一二位茸时；
中國由于參加奧運(yùn)會時(shí)間較晚，截止2016年累計(jì)獲得了545枚獎(jiǎng)牌赋访，位列第七位可都；
year_list = sorted(list(set(medal_data['Year'].to_list())), reverse=True)
tl = Timeline(init_opts=opts.InitOpts(theme='dark', width='1000px', height='1000px'))
tl.add_schema(is_timeline_show=True,is_rewind_play=True, is_inverse=False,
label_opts=opts.LabelOpts(is_show=False))
for year in year_list:
t_data = medal_stat(year)[::-1]
bar = (
Bar(init_opts=opts.InitOpts())
.add_xaxis([x[0] for x in t_data])
.add_yaxis("銅牌??", [x[3] for x in t_data],
stack='stack1',
itemstyle_opts=opts.ItemStyleOpts(border_color='rgb(220,220,220)',color='rgb(218,165,32)'))
.add_yaxis("銀牌??", [x[2] for x in t_data],
stack='stack1',
itemstyle_opts=opts.ItemStyleOpts(border_color='rgb(220,220,220)',color='rgb(192,192,192)'))
.add_yaxis("金牌???", [x[1] for x in t_data],
stack='stack1',
itemstyle_opts=opts.ItemStyleOpts(border_color='rgb(220,220,220)',color='rgb(255,215,0)'))
.set_series_opts(label_opts=opts.LabelOpts(is_show=True,
position='insideRight',
font_style='italic'),)
.set_global_opts(
title_opts=opts.TitleOpts(title="各國累計(jì)獎(jiǎng)牌數(shù)（夏季奧運(yùn)會）"),
xaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(rotate=45)),
legend_opts=opts.LegendOpts(is_show=True),
graphic_opts=[opts.GraphicGroup(graphic_item=opts.GraphicItem(
rotation=JsCode("Math.PI / 4"),
bounding="raw",
right=110,
bottom=110,
z=100),
children=[
opts.GraphicRect(
graphic_item=opts.GraphicItem(
left="center", top="center", z=100
),
graphic_shape_opts=opts.GraphicShapeOpts(
width=400, height=50
),
graphic_basicstyle_opts=opts.GraphicBasicStyleOpts(
fill="rgba(0,0,0,0.3)"
),
),
opts.GraphicText(
graphic_item=opts.GraphicItem(
left="center", top="center", z=100
),
graphic_textstyle_opts=opts.GraphicTextStyleOpts(
text=year,
font="bold 26px Microsoft YaHei",
graphic_basicstyle_opts=opts.GraphicBasicStyleOpts(
fill="#fff"
),
),
),
],
)
],)
.reversal_axis())
tl.add(bar, year)
tl.render_notebook()
各國冬奧會累計(jì)獎(jiǎng)牌數(shù)
year_list = sorted(list(set(medal_data['Year'][medal_data.Season=='Winter'].to_list())), reverse=True)
tl = Timeline(init_opts=opts.InitOpts(theme='dark', width='1000px', height='1000px'))
tl.add_schema(is_timeline_show=True,is_rewind_play=True, is_inverse=False,
label_opts=opts.LabelOpts(is_show=False))
for year in year_list:
t_data = medal_stat(year, 'Winter')[::-1]
bar = (
Bar(init_opts=opts.InitOpts(theme='dark'))
.add_xaxis([x[0] for x in t_data])
.add_yaxis("銅牌??", [x[3] for x in t_data],
stack='stack1',
itemstyle_opts=opts.ItemStyleOpts(border_color='rgb(220,220,220)',color='rgb(218,165,32)'))
.add_yaxis("銀牌??", [x[2] for x in t_data],
stack='stack1',
itemstyle_opts=opts.ItemStyleOpts(border_color='rgb(220,220,220)',color='rgb(192,192,192)'))
.add_yaxis("金牌???", [x[1] for x in t_data],
stack='stack1',
itemstyle_opts=opts.ItemStyleOpts(border_color='rgb(220,220,220)',color='rgb(255,215,0)'))
.set_series_opts(label_opts=opts.LabelOpts(is_show=True,
position='insideRight',
font_style='italic'),)
.set_global_opts(
title_opts=opts.TitleOpts(title="各國累計(jì)獎(jiǎng)牌數(shù)（冬季奧運(yùn)會）"),
xaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(rotate=45)),
legend_opts=opts.LegendOpts(is_show=True),
graphic_opts=[opts.GraphicGroup(graphic_item=opts.GraphicItem(
rotation=JsCode("Math.PI / 4"),
bounding="raw",
right=110,
bottom=110,
z=100),
children=[
opts.GraphicRect(
graphic_item=opts.GraphicItem(
left="center", top="center", z=100
),
graphic_shape_opts=opts.GraphicShapeOpts(
width=400, height=50
),
graphic_basicstyle_opts=opts.GraphicBasicStyleOpts(
fill="rgba(0,0,0,0.3)"
),
),
opts.GraphicText(
graphic_item=opts.GraphicItem(
left="center", top="center", z=100
),
graphic_textstyle_opts=opts.GraphicTextStyleOpts(
text='截止{}'.format(year),
font="bold 26px Microsoft YaHei",
graphic_basicstyle_opts=opts.GraphicBasicStyleOpts(
fill="#fff"
),
),
),
],
)
],)
.reversal_axis())
tl.add(bar, year)
tl.render_notebook()
各項(xiàng)運(yùn)動(dòng)產(chǎn)生金牌數(shù)
基于2016年夏奧會和2014年冬奧會統(tǒng)計(jì)；
- ??田徑 & 游泳是大項(xiàng)蚓耽，在2016年夏奧會上分別產(chǎn)生了47和34枚金牌渠牲；
background_color_js = """new echarts.graphic.RadialGradient(0.5, 0.5, 1, [{
offset: 0,
color: '#696969'
}, {
offset: 1,
color: '#000000'
}])"""
tab = Tab()
temp = data[(data['Medal']=='Gold') & (data['Year']==2016) & (data['Season']=='Summer')]
event_medal = temp.groupby(['Sport'])['Event'].nunique().reset_index()
event_medal.columns = ['Sport', 'Nums']
event_medal = event_medal.sort_values(by="Nums" , ascending=False)
pie = (Pie(init_opts=opts.InitOpts(bg_color=JsCode(background_color_js), width='1000px', height='800px'))
.add('金牌???', [(row['Sport'], row['Nums']) for _, row in event_medal.iterrows()],
radius=["30%", "75%"],
rosetype="radius")
.set_global_opts(title_opts=opts.TitleOpts(title="2016年夏季奧運(yùn)會各項(xiàng)運(yùn)動(dòng)產(chǎn)生金牌占比",
pos_left="center",
title_textstyle_opts=opts.TextStyleOpts(color="white", font_size=20), ),
legend_opts=opts.LegendOpts(is_show=False))
.set_series_opts(label_opts=opts.LabelOpts(formatter=": xdptuol%"),
tooltip_opts=opts.TooltipOpts(trigger="item", formatter="{a} <br/>步悠: {c} (8tv3gol%)"),)
)
tab.add(pie, '2016年夏奧會')
temp = data[(data['Medal']=='Gold') & (data['Year']==2014) & (data['Season']=='Winter')]
event_medal = temp.groupby(['Sport'])['Event'].nunique().reset_index()
event_medal.columns = ['Sport', 'Nums']
event_medal = event_medal.sort_values(by="Nums" , ascending=False)
pie = (Pie(init_opts=opts.InitOpts(bg_color=JsCode(background_color_js), width='1000px', height='800px'))
.add('金牌???', [(row['Sport'], row['Nums']) for _, row in event_medal.iterrows()],
radius=["30%", "75%"],
rosetype="radius")
.set_global_opts(title_opts=opts.TitleOpts(title="2014年冬季奧運(yùn)會各項(xiàng)運(yùn)動(dòng)產(chǎn)生金牌占比",
pos_left="center",
title_textstyle_opts=opts.TextStyleOpts(color="white", font_size=20), ),
legend_opts=opts.LegendOpts(is_show=False))
.set_series_opts(label_opts=opts.LabelOpts(formatter="签杈: l8klfhx%"),
tooltip_opts=opts.TooltipOpts(trigger="item", formatter="{a} <br/>: {c} (ijpm1xg%)"
),)
)
tab.add(pie, '2014年冬奧會')
tab.render_notebook()
運(yùn)動(dòng)員層面
歷年參賽人數(shù)趨勢
從人數(shù)來看鼎兽，每屆夏奧會參賽人數(shù)都是冬奧會的4-5倍答姥；
整體參賽人數(shù)是上漲趨勢，但由于歷史原因也出現(xiàn)過波動(dòng)谚咬，如1980年莫斯科奧運(yùn)會層遭遇65個(gè)國家抵制踢涌；
athlete = data.groupby(['Year', 'Season'])['Name'].nunique().reset_index()
athlete.columns = ['Year', 'Season', 'Nums']
athlete = athlete.sort_values(by="Year" , ascending=True)
x_list, y1_list, y2_list = [], [], []
for _, row in athlete.iterrows():
x_list.append(str(row['Year']))
if row['Season'] == 'Summer':
y1_list.append(row['Nums'])
y2_list.append(None)
else:
y2_list.append(row['Nums'])
y1_list.append(None)
background_color_js = (
"new echarts.graphic.LinearGradient(1, 1, 0, 0, "
"[{offset: 0, color: '#008B8B'}, {offset: 1, color: '#FF6347'}], false)"
)
line = (
Line(init_opts=opts.InitOpts(bg_color=JsCode(background_color_js), width='1000px', height='600px'))
.add_xaxis(x_list)
.add_yaxis("夏季奧運(yùn)會",
y1_list,
is_smooth=True,
is_connect_nones=True,
symbol="circle",
symbol_size=6,
linestyle_opts=opts.LineStyleOpts(color="#fff"),
label_opts=opts.LabelOpts(is_show=False, position="top", color="white"),
itemstyle_opts=opts.ItemStyleOpts(
color="green", border_color="#fff", border_width=3),
tooltip_opts=opts.TooltipOpts(is_show=True))
.add_yaxis("冬季季奧運(yùn)會",
y2_list,
is_smooth=True,
is_connect_nones=True,
symbol="circle",
symbol_size=6,
linestyle_opts=opts.LineStyleOpts(color="#FF4500"),
label_opts=opts.LabelOpts(is_show=False, position="top", color="white"),
itemstyle_opts=opts.ItemStyleOpts(
color="red", border_color="#fff", border_width=3),
tooltip_opts=opts.TooltipOpts(is_show=True))
.set_series_opts(
markarea_opts=opts.MarkAreaOpts(
label_opts=opts.LabelOpts(is_show=True, position="bottom", color="white"),
data=[
opts.MarkAreaItem(name="第一次世界大戰(zhàn)", x=(1914, 1918)),
opts.MarkAreaItem(name="第二次世界大戰(zhàn)", x=(1939, 1945)),
]
)
)
.set_global_opts(title_opts=opts.TitleOpts(title="歷屆奧運(yùn)會參賽人數(shù)",
pos_left="center",
title_textstyle_opts=opts.TextStyleOpts(color="white", font_size=20),),
legend_opts=opts.LegendOpts(is_show=True, pos_top='5%',
textstyle_opts=opts.TextStyleOpts(color="white", font_size=12)),
xaxis_opts=opts.AxisOpts(type_="value",
min_=1904,
max_=2016,
boundary_gap=False,
axislabel_opts=opts.LabelOpts(margin=30, color="#ffffff63",
formatter=JsCode("""function (value)
{return value+'年';}""")),
axisline_opts=opts.AxisLineOpts(is_show=False),
axistick_opts=opts.AxisTickOpts(
is_show=True,
length=25,
linestyle_opts=opts.LineStyleOpts(color="#ffffff1f"),
),
splitline_opts=opts.SplitLineOpts(
is_show=True, linestyle_opts=opts.LineStyleOpts(color="#ffffff1f")
),
),
yaxis_opts=opts.AxisOpts(
type_="value",
position="right",
axislabel_opts=opts.LabelOpts(margin=20, color="#ffffff63"),
axisline_opts=opts.AxisLineOpts(
linestyle_opts=opts.LineStyleOpts(width=2, color="#fff")
),
axistick_opts=opts.AxisTickOpts(
is_show=True,
length=15,
linestyle_opts=opts.LineStyleOpts(color="#ffffff1f"),
),
splitline_opts=opts.SplitLineOpts(
is_show=True, linestyle_opts=opts.LineStyleOpts(color="#ffffff1f")
),
),)
)
line.render_notebook()
歷年女性運(yùn)動(dòng)員占比趨勢
一開始奧運(yùn)會基本是「男人的運(yùn)動(dòng)」，女性運(yùn)動(dòng)員僅為個(gè)位數(shù)序宦，到近幾屆奧運(yùn)會男女參賽人數(shù)基本趨于相等睁壁；
# 歷年男性運(yùn)動(dòng)員人數(shù)
m_data = data[data.Sex=='M'].groupby(['Year', 'Season'])['Name'].nunique().reset_index()
m_data.columns = ['Year', 'Season', 'M-Nums']
m_data = m_data.sort_values(by="Year" , ascending=True)
# 歷年女性運(yùn)動(dòng)員人數(shù)
f_data = data[data.Sex=='F'].groupby(['Year', 'Season'])['Name'].nunique().reset_index()
f_data.columns = ['Year', 'Season', 'F-Nums']
f_data = f_data.sort_values(by="Year" , ascending=True)
t_data = pd.merge(m_data, f_data, on=['Year', 'Season'])
t_data['F-rate'] = round(t_data['F-Nums'] / (t_data['F-Nums'] + t_data['M-Nums'] ), 4)
x_list, y1_list, y2_list = [], [], []
for _, row in t_data.iterrows():
x_list.append(str(row['Year']))
if row['Season'] == 'Summer':
y1_list.append(row['F-rate'])
y2_list.append(None)
else:
y2_list.append(row['F-rate'])
y1_list.append(None)
background_color_js = (
"new echarts.graphic.LinearGradient(0, 0, 0, 1, "
"[{offset: 0, color: '#008B8B'}, {offset: 1, color: '#FF6347'}], false)"
)
line = (
Line(init_opts=opts.InitOpts(bg_color=JsCode(background_color_js), width='1000px', height='600px'))
.add_xaxis(x_list)
.add_yaxis("夏季奧運(yùn)會",
y1_list,
is_smooth=True,
is_connect_nones=True,
symbol="circle",
symbol_size=6,
linestyle_opts=opts.LineStyleOpts(color="#fff"),
label_opts=opts.LabelOpts(is_show=False, position="top", color="white"),
itemstyle_opts=opts.ItemStyleOpts(color="green", border_color="#fff", border_width=3),
tooltip_opts=opts.TooltipOpts(is_show=True),)
.add_yaxis("冬季季奧運(yùn)會",
y2_list,
is_smooth=True,
is_connect_nones=True,
symbol="circle",
symbol_size=6,
linestyle_opts=opts.LineStyleOpts(color="#FF4500"),
label_opts=opts.LabelOpts(is_show=False, position="top", color="white"),
itemstyle_opts=opts.ItemStyleOpts(color="red", border_color="#fff", border_width=3),
tooltip_opts=opts.TooltipOpts(is_show=True),)
.set_series_opts(tooltip_opts=opts.TooltipOpts(trigger="item", formatter=JsCode("""function (params)
{return params.data[0]+ '年: ' + Number(params.data[1])*100 +'%';}""")),)
.set_global_opts(title_opts=opts.TitleOpts(title="歷屆奧運(yùn)會參賽女性占比趨勢",
pos_left="center",
title_textstyle_opts=opts.TextStyleOpts(color="white", font_size=20),),
legend_opts=opts.LegendOpts(is_show=True, pos_top='5%',
textstyle_opts=opts.TextStyleOpts(color="white", font_size=12)),
xaxis_opts=opts.AxisOpts(type_="value",
min_=1904,
max_=2016,
boundary_gap=False,
axislabel_opts=opts.LabelOpts(margin=30, color="#ffffff63",
formatter=JsCode("""function (value)
{return value+'年';}""")),
axisline_opts=opts.AxisLineOpts(is_show=False),
axistick_opts=opts.AxisTickOpts(
is_show=True,
length=25,
linestyle_opts=opts.LineStyleOpts(color="#ffffff1f"),
),
splitline_opts=opts.SplitLineOpts(
is_show=True, linestyle_opts=opts.LineStyleOpts(color="#ffffff1f")
),
),
yaxis_opts=opts.AxisOpts(
type_="value",
position="right",
axislabel_opts=opts.LabelOpts(margin=20, color="#ffffff63",
formatter=JsCode("""function (value)
{return Number(value *100)+'%';}""")),
axisline_opts=opts.AxisLineOpts(
linestyle_opts=opts.LineStyleOpts(width=2, color="#fff")
),
axistick_opts=opts.AxisTickOpts(
is_show=True,
length=15,
linestyle_opts=opts.LineStyleOpts(color="#ffffff1f"),
),
splitline_opts=opts.SplitLineOpts(
is_show=True, linestyle_opts=opts.LineStyleOpts(color="#ffffff1f")
),
),)
)
line.render_notebook()
獲得金牌最多的運(yùn)動(dòng)員
排在第一的是美國泳壇名將「菲爾普斯」，截止2016年奧運(yùn)會總共獲得了23枚金牌互捌；
博爾特累計(jì)獲得8枚奧運(yùn)會金牌潘明；
temp = data[(data['Medal']=='Gold')]
athlete = temp.groupby(['Name'])['Medal'].count().reset_index()
athlete.columns = ['Name', 'Nums']
athlete = athlete.sort_values(by="Nums" , ascending=True)
background_color_js = (
"new echarts.graphic.LinearGradient(0, 0, 1, 1, "
"[{offset: 0, color: '#008B8B'}, {offset: 1, color: '#FF6347'}], false)"
)
pb = (
PictorialBar(init_opts=opts.InitOpts(bg_color=JsCode(background_color_js), width='1000px', height='800px'))
.add_xaxis([x.replace(' ','\n') for x in athlete['Name'].tail(10).tolist()])
.add_yaxis(
"",
athlete['Nums'].tail(10).tolist(),
label_opts=opts.LabelOpts(is_show=False),
symbol_size=25,
symbol_repeat='fixed',
symbol_offset=[0, 0],
is_symbol_clip=True,
symbol='image://https://cdn.kesci.com/upload/image/q8f8otrlfc.png')
.reversal_axis()
.set_global_opts(
title_opts=opts.TitleOpts(title="獲得金牌數(shù)量最多的運(yùn)動(dòng)員", pos_left='center',
title_textstyle_opts=opts.TextStyleOpts(color="white", font_size=20),),
xaxis_opts=opts.AxisOpts(is_show=False,),
yaxis_opts=opts.AxisOpts(
axistick_opts=opts.AxisTickOpts(is_show=False),
axisline_opts=opts.AxisLineOpts(
linestyle_opts=opts.LineStyleOpts(opacity=0)
),
),
))
pb.render_notebook()
獲得金牌/獎(jiǎng)牌比例
看菲爾普斯拿金牌拿到手軟，但實(shí)際上想獲得一塊金牌的難度高嗎秕噪？
整個(gè)奧運(yùn)會（包括夏季钳降，冬季奧運(yùn)會）歷史上參賽人數(shù)為134732，獲得過金牌的運(yùn)動(dòng)員只有10413腌巾，占比7.7%;
獲得過獎(jiǎng)牌（包括金銀銅）的運(yùn)動(dòng)員有28202人遂填，占比20.93%；
total_athlete = len(set(data['Name']))
medal_athlete = len(set(data['Name'][data['Medal'].isin(['Gold', 'Silver', 'Bronze'])]))
gold_athlete = len(set(data['Name'][data['Medal']=='Gold']))
l1 = Liquid(init_opts=opts.InitOpts(theme='dark', width='1000px', height='800px'))
l1.add("獲得獎(jiǎng)牌", [medal_athlete/total_athlete],
center=["70%", "50%"],
label_opts=opts.LabelOpts(font_size=50,
formatter=JsCode(
"""function (param) {
return (Math.floor(param.value * 10000) / 100) + '%';
}"""),
position="inside",
))
l1.set_global_opts(title_opts=opts.TitleOpts(title="獲得過獎(jiǎng)牌比例", pos_left='62%', pos_top='8%'))
l1.set_series_opts(tooltip_opts=opts.TooltipOpts(is_show=False))
l2 = Liquid(init_opts=opts.InitOpts(theme='dark', width='1000px', height='800px'))
l2.add("獲得金牌",
[gold_athlete/total_athlete],
center=["25%", "50%"],
label_opts=opts.LabelOpts(font_size=50,
formatter=JsCode(
"""function (param) {
return (Math.floor(param.value * 10000) / 100) + '%';
}"""),
position="inside",
),)
l2.set_global_opts(title_opts=opts.TitleOpts(title="獲得過金牌比例", pos_left='17%', pos_top='8%'))
l2.set_series_opts(tooltip_opts=opts.TooltipOpts(is_show=False))
grid = Grid().add(l1, grid_opts=opts.GridOpts()).add(l2, grid_opts=opts.GridOpts())
grid.render_notebook()
運(yùn)動(dòng)員平均體質(zhì)數(shù)據(jù)
根據(jù)不同的運(yùn)動(dòng)項(xiàng)目進(jìn)行統(tǒng)計(jì)
運(yùn)動(dòng)員平均身高最高的項(xiàng)目是籃球澈蝙，女子平均身高達(dá)182cm吓坚，男子平均身高達(dá)到194cm；
在男子項(xiàng)目中灯荧，運(yùn)動(dòng)員平均體重最大的項(xiàng)目是拔河礁击，平均體重達(dá)到96kg（拔河自第七屆奧運(yùn)會后已取消）；
運(yùn)動(dòng)員平均年齡最大的項(xiàng)目是Art competition（自行百度這奇怪的項(xiàng)目），平均年齡46歲哆窿，除此之外便是馬術(shù)和射擊链烈，男子平均年齡分別為34.4歲和34.2歲，女子平均年齡34.22歲和29.12s歲挚躯；
tool_js = """function (param) {return param.data[2] +'<br/>'
+'平均體重： '+Number(param.data[0]).toFixed(2)+' kg<br/>'
+'平均身高： '+Number(param.data[1]).toFixed(2)+' cm<br/>'
+'平均年齡： '+Number(param.data[3]).toFixed(2);}"""
background_color_js = (
"new echarts.graphic.LinearGradient(1, 0, 0, 1, "
"[{offset: 0, color: '#008B8B'}, {offset: 1, color: '#FF6347'}], false)"
)
temp_data = data[data['Sex']=='M'].groupby(['Sport'])['Age', 'Height', 'Weight'].mean().reset_index().dropna(how='any')
scatter = (Scatter(init_opts=opts.InitOpts(bg_color=JsCode(background_color_js), width='1000px', height='600px'))
.add_xaxis(temp_data['Weight'].tolist())
.add_yaxis("男性", [[row['Height'], row['Sport'], row['Age']] for _, row in temp_data.iterrows()],
# 漸變效果實(shí)現(xiàn)部分
color=JsCode("""new echarts.graphic.RadialGradient(0.4, 0.3, 1, [{
offset: 0,
color: 'rgb(129, 227, 238)'
}, {
offset: 1,
color: 'rgb(25, 183, 207)'
}])"""))
.set_series_opts(label_opts=opts.LabelOpts(is_show=False))
.set_global_opts(
title_opts=opts.TitleOpts(title="各項(xiàng)目運(yùn)動(dòng)員平均升高體重年齡",pos_left="center",
title_textstyle_opts=opts.TextStyleOpts(color="white", font_size=20)),
legend_opts=opts.LegendOpts(is_show=True, pos_top='5%',
textstyle_opts=opts.TextStyleOpts(color="white", font_size=12)),
tooltip_opts = opts.TooltipOpts(formatter=JsCode(tool_js)),
xaxis_opts=opts.AxisOpts(
name='體重/kg',
# 設(shè)置坐標(biāo)軸為數(shù)值類型
type_="value",
is_scale=True,
# 顯示分割線
axislabel_opts=opts.LabelOpts(margin=30, color="white"),
axisline_opts=opts.AxisLineOpts(is_show=True, linestyle_opts=opts.LineStyleOpts(color="#ffffff1f")),
axistick_opts=opts.AxisTickOpts(is_show=True, length=25,
linestyle_opts=opts.LineStyleOpts(color="#ffffff1f")),
splitline_opts=opts.SplitLineOpts(is_show=True, linestyle_opts=opts.LineStyleOpts(color="#ffffff1f")
)),
yaxis_opts=opts.AxisOpts(
name='身高/cm',
# 設(shè)置坐標(biāo)軸為數(shù)值類型
type_="value",
# 默認(rèn)為False表示起始為0
is_scale=True,
axislabel_opts=opts.LabelOpts(margin=30, color="white"),
axisline_opts=opts.AxisLineOpts(is_show=True, linestyle_opts=opts.LineStyleOpts(color="#ffffff1f")),
axistick_opts=opts.AxisTickOpts(is_show=True, length=25,
linestyle_opts=opts.LineStyleOpts(color="#ffffff1f")),
splitline_opts=opts.SplitLineOpts(is_show=True, linestyle_opts=opts.LineStyleOpts(color="#ffffff1f")
)),
visualmap_opts=opts.VisualMapOpts(is_show=False, type_='size', range_size=[5,50], min_=10, max_=40)
))
temp_data = data[data['Sex']=='F'].groupby(['Sport'])['Age', 'Height', 'Weight'].mean().reset_index().dropna(how='any')
scatter1 = (Scatter()
.add_xaxis(temp_data['Weight'].tolist())
.add_yaxis("女性", [[row['Height'], row['Sport'], row['Age']] for _, row in temp_data.iterrows()],
itemstyle_opts=opts.ItemStyleOpts(
color=JsCode("""new echarts.graphic.RadialGradient(0.4, 0.3, 1, [{
offset: 0,
color: 'rgb(251, 118, 123)'
}, {
offset: 1,
color: 'rgb(204, 46, 72)'
}])""")))
.set_series_opts(label_opts=opts.LabelOpts(is_show=False))
)
scatter.overlap(scatter1)
scatter.render_notebook()
????中國奧運(yùn)會表現(xiàn)
CN_data = data[data.region=='China']
CN_data.head()
歷屆奧運(yùn)會參賽人數(shù)
background_color_js = (
"new echarts.graphic.LinearGradient(1, 0, 0, 1, "
"[{offset: 0, color: '#008B8B'}, {offset: 1, color: '#FF6347'}], false)"
)
athlete = CN_data.groupby(['Year', 'Season'])['Name'].nunique().reset_index()
athlete.columns = ['Year', 'Season', 'Nums']
athlete = athlete.sort_values(by="Year" , ascending=False)
s_bar = (
Bar(init_opts=opts.InitOpts(theme='dark', width='1000px', height='300px'))
.add_xaxis([row['Year'] for _, row in athlete[athlete.Season=='Summer'].iterrows()])
.add_yaxis("參賽人數(shù)", [row['Nums'] for _, row in athlete[athlete.Season=='Summer'].iterrows()],
category_gap='40%',
itemstyle_opts=opts.ItemStyleOpts(
border_color='rgb(220,220,220)',
color=JsCode("""new echarts.graphic.LinearGradient(0, 0, 0, 1,
[{
offset: 1,
color: '#00BFFF'
}, {
offset: 0,
color: '#32CD32'
}])""")))
.set_series_opts(label_opts=opts.LabelOpts(is_show=True,
position='top',
font_style='italic'))
.set_global_opts(
title_opts=opts.TitleOpts(title="中國歷年奧運(yùn)會參賽人數(shù)-夏奧會", pos_left='center'),
xaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(rotate=45)),
legend_opts=opts.LegendOpts(is_show=False),
yaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(margin=20, color="#ffffff63")),
graphic_opts=[
opts.GraphicImage(
graphic_item=opts.GraphicItem(
id_="logo", right=0, top=0, z=-10, bounding="raw", origin=[75, 75]
),
graphic_imagestyle_opts=opts.GraphicImageStyleOpts(
image="https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1586619952245&di=981a36305048f93eec791980acc99cf7&imgtype=0&src=http%3A%2F%2Fimg5.mtime.cn%2Fmg%2F2017%2F01%2F06%2F172210.42721559.jpg",
width=1000,
height=600,
opacity=0.6,),
)
],)
)
w_bar = (
Bar(init_opts=opts.InitOpts(theme='dark',width='1000px', height='300px'))
.add_xaxis([row['Year'] for _, row in athlete[athlete.Season=='Winter'].iterrows()])
.add_yaxis("參賽人數(shù)", [row['Nums'] for _, row in athlete[athlete.Season=='Winter'].iterrows()],
category_gap='50%',
itemstyle_opts=opts.ItemStyleOpts(
border_color='rgb(220,220,220)',
color=JsCode("""new echarts.graphic.LinearGradient(0, 0, 0, 1,
[{
offset: 1,
color: '#00BFFF'
}, {
offset: 0.8,
color: '#FFC0CB'
}, {
offset: 0,
color: '#40E0D0'
}])""")))
.set_series_opts(label_opts=opts.LabelOpts(is_show=True,
position='top',
font_style='italic'))
.set_global_opts(
title_opts=opts.TitleOpts(title="中國歷年奧運(yùn)會參賽人數(shù)-冬奧會", pos_left='center'),
xaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(rotate=45)),
legend_opts=opts.LegendOpts(is_show=False),
yaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(margin=20, color="#ffffff63")),
graphic_opts=[
opts.GraphicImage(
graphic_item=opts.GraphicItem(
id_="logo", right=0, top=-300, z=-10, bounding="raw", origin=[75, 75]
),
graphic_imagestyle_opts=opts.GraphicImageStyleOpts(
image="https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1586619952245&di=981a36305048f93eec791980acc99cf7&imgtype=0&src=http%3A%2F%2Fimg5.mtime.cn%2Fmg%2F2017%2F01%2F06%2F172210.42721559.jpg",
width=1000,
height=600,
opacity=0.6,),
)
],)
)
page = (
Page()
.add(s_bar,)
.add(w_bar,)
)
page.render_notebook()
歷屆奧運(yùn)會獎(jiǎng)牌數(shù)
background_color_js = (
"new echarts.graphic.LinearGradient(1, 0, 0, 1, "
"[{offset: 0, color: '#008B8B'}, {offset: 1, color: '#FF6347'}], false)"
)
CN_medals = CN_data.groupby(['Year', 'Season', 'Medal'])['Event'].nunique().reset_index()
CN_medals.columns = ['Year', 'Season', 'Medal', 'Nums']
CN_medals = CN_medals.sort_values(by="Year" , ascending=False)
s_bar = (
Bar(init_opts=opts.InitOpts(theme='dark', width='1000px', height='300px'))
.add_xaxis(sorted(list(set([row['Year'] for _, row in CN_medals[CN_medals.Season=='Summer'].iterrows()])), reverse=True))
.add_yaxis("金牌", [row['Nums'] for _, row in CN_medals[(CN_medals.Season=='Summer') & (CN_medals.Medal=='Gold')].iterrows()],
category_gap='20%',
itemstyle_opts=opts.ItemStyleOpts(
border_color='rgb(220,220,220)',
color=JsCode("""new echarts.graphic.LinearGradient(0, 0, 0, 1,
[{
offset: 0,
color: '#FFD700'
}, {
offset: 1,
color: '#FFFFF0'
}])""")))
.add_yaxis("銀牌", [row['Nums'] for _, row in CN_medals[(CN_medals.Season=='Summer') & (CN_medals.Medal=='Silver')].iterrows()],
category_gap='20%',
itemstyle_opts=opts.ItemStyleOpts(
border_color='rgb(220,220,220)',
color=JsCode("""new echarts.graphic.LinearGradient(0, 0, 0, 1,
[{
offset: 0,
color: '#C0C0C0'
}, {
offset: 1,
color: '#FFFFF0'
}])""")))
.add_yaxis("銅牌", [row['Nums'] for _, row in CN_medals[(CN_medals.Season=='Summer') & (CN_medals.Medal=='Bronze')].iterrows()],
category_gap='20%',
itemstyle_opts=opts.ItemStyleOpts(
border_color='rgb(220,220,220)',
color=JsCode("""new echarts.graphic.LinearGradient(0, 0, 0, 1,
[{
offset: 0,
color: '#DAA520'
}, {
offset: 1,
color: '#FFFFF0'
}])""")))
.set_series_opts(label_opts=opts.LabelOpts(is_show=True,
position='top',
font_style='italic'))
.set_global_opts(
title_opts=opts.TitleOpts(title="中國歷年奧運(yùn)會獲得獎(jiǎng)牌數(shù)數(shù)-夏奧會", pos_left='center'),
xaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(rotate=45)),
legend_opts=opts.LegendOpts(is_show=False),
yaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(margin=20, color="#ffffff63")),
graphic_opts=[
opts.GraphicImage(
graphic_item=opts.GraphicItem(
id_="logo", right=0, top=0, z=-10, bounding="raw", origin=[75, 75]
),
graphic_imagestyle_opts=opts.GraphicImageStyleOpts(
image="https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1586619952245&di=981a36305048f93eec791980acc99cf7&imgtype=0&src=http%3A%2F%2Fimg5.mtime.cn%2Fmg%2F2017%2F01%2F06%2F172210.42721559.jpg",
width=1000,
height=600,
opacity=0.6,),
)
],)
)
w_bar = (
Bar(init_opts=opts.InitOpts(theme='dark', width='1000px', height='300px'))
.add_xaxis(sorted(list(set([row['Year'] for _, row in CN_medals[CN_medals.Season=='Winter'].iterrows()])), reverse=True))
.add_yaxis("金牌", [row['Nums'] for _, row in CN_medals[(CN_medals.Season=='Winter') & (CN_medals.Medal=='Gold')].iterrows()],
category_gap='20%',
itemstyle_opts=opts.ItemStyleOpts(
border_color='rgb(220,220,220)',
color=JsCode("""new echarts.graphic.LinearGradient(0, 0, 0, 1,
[{
offset: 0,
color: '#FFD700'
}, {
offset: 1,
color: '#FFFFF0'
}])""")))
.add_yaxis("銀牌", [row['Nums'] for _, row in CN_medals[(CN_medals.Season=='Winter') & (CN_medals.Medal=='Silver')].iterrows()],
category_gap='20%',
itemstyle_opts=opts.ItemStyleOpts(
border_color='rgb(220,220,220)',
color=JsCode("""new echarts.graphic.LinearGradient(0, 0, 0, 1,
[{
offset: 0,
color: '#C0C0C0'
}, {
offset: 1,
color: '#FFFFF0'
}])""")))
.add_yaxis("銅牌", [row['Nums'] for _, row in CN_medals[(CN_medals.Season=='Winter') & (CN_medals.Medal=='Bronze')].iterrows()],
category_gap='20%',
itemstyle_opts=opts.ItemStyleOpts(
border_color='rgb(220,220,220)',
color=JsCode("""new echarts.graphic.LinearGradient(0, 0, 0, 1,
[{
offset: 0,
color: '#DAA520'
}, {
offset: 1,
color: '#FFFFF0'
}])""")))
.set_series_opts(label_opts=opts.LabelOpts(is_show=True,
position='top',
font_style='italic'))
.set_global_opts(
title_opts=opts.TitleOpts(title="中國歷年奧運(yùn)會獲得獎(jiǎng)牌數(shù)-冬奧會", pos_left='center'),
xaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(rotate=45)),
legend_opts=opts.LegendOpts(is_show=False),
yaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(margin=20, color="#ffffff63")),
graphic_opts=[
opts.GraphicImage(
graphic_item=opts.GraphicItem(
id_="logo", right=0, top=-300, z=-10, bounding="raw", origin=[75, 75]
),
graphic_imagestyle_opts=opts.GraphicImageStyleOpts(
image="https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1586619952245&di=981a36305048f93eec791980acc99cf7&imgtype=0&src=http%3A%2F%2Fimg5.mtime.cn%2Fmg%2F2017%2F01%2F06%2F172210.42721559.jpg",
width=1000,
height=600,
opacity=0.6,),
)
],)
)
page = (
Page()
.add(s_bar,)
.add(w_bar,)
)
page.render_notebook()
優(yōu)勢項(xiàng)目
跳水强衡，體操，射擊码荔，舉重漩勤，乒乓球，羽毛球
background_color_js = (
"new echarts.graphic.LinearGradient(1, 0, 0, 1, "
"[{offset: 0.5, color: '#FFC0CB'}, {offset: 1, color: '#F0FFFF'}, {offset: 0, color: '#EE82EE'}], false)"
)
CN_events = CN_data[CN_data.Medal=='Gold'].groupby(['Year', 'Sport'])['Event'].nunique().reset_index()
CN_events = CN_events.groupby(['Sport'])['Event'].sum().reset_index()
CN_events.columns = ['Sport', 'Nums']
data_pair = [(row['Sport'], row['Nums']) for _, row in CN_events.iterrows()]
wc = (WordCloud(init_opts=opts.InitOpts(bg_color=JsCode(background_color_js), width='1000px', height='600px'))
.add("", data_pair,word_size_range=[30, 80])
.set_global_opts(title_opts=opts.TitleOpts(title="中國獲得過金牌運(yùn)動(dòng)項(xiàng)目",pos_left="center",
title_textstyle_opts=opts.TextStyleOpts(color="white", font_size=20)))
)
wc.render_notebook()
????美國奧運(yùn)會表現(xiàn)
USA_data = data[data.region=='USA']
USA_data.head()
歷屆奧運(yùn)會參加人數(shù)
background_color_js = (
"new echarts.graphic.LinearGradient(1, 0, 0, 1, "
"[{offset: 0, color: '#008B8B'}, {offset: 1, color: '#FF6347'}], false)"
)
athlete = USA_data.groupby(['Year', 'Season'])['Name'].nunique().reset_index()
athlete.columns = ['Year', 'Season', 'Nums']
athlete = athlete.sort_values(by="Year" , ascending=False)
s_bar = (
Bar(init_opts=opts.InitOpts(theme='dark', width='1000px', height='300px'))
.add_xaxis([row['Year'] for _, row in athlete[athlete.Season=='Summer'].iterrows()])
.add_yaxis("參賽人數(shù)", [row['Nums'] for _, row in athlete[athlete.Season=='Summer'].iterrows()],
category_gap='40%',
itemstyle_opts=opts.ItemStyleOpts(
border_color='rgb(220,220,220)',
color=JsCode("""new echarts.graphic.LinearGradient(0, 0, 0, 1,
[{
offset: 1,
color: '#00BFFF'
}, {
offset: 0,
color: '#32CD32'
}])""")))
.set_series_opts(label_opts=opts.LabelOpts(is_show=True,
position='top',
font_style='italic'))
.set_global_opts(
title_opts=opts.TitleOpts(title="美國歷年奧運(yùn)會參賽人數(shù)-夏奧會", pos_left='center'),
xaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(rotate=45)),
legend_opts=opts.LegendOpts(is_show=False),
yaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(margin=20, color="#ffffff63")),
graphic_opts=[
opts.GraphicImage(
graphic_item=opts.GraphicItem(
id_="logo", right=0, top=0, z=-10, bounding="raw", origin=[75, 75]
),
graphic_imagestyle_opts=opts.GraphicImageStyleOpts(
image="https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1586619952245&di=981a36305048f93eec791980acc99cf7&imgtype=0&src=http%3A%2F%2Fimg5.mtime.cn%2Fmg%2F2017%2F01%2F06%2F172210.42721559.jpg",
width=1000,
height=600,
opacity=0.6,),
)
],)
)
w_bar = (
Bar(init_opts=opts.InitOpts(theme='dark',width='1000px', height='300px'))
.add_xaxis([row['Year'] for _, row in athlete[athlete.Season=='Winter'].iterrows()])
.add_yaxis("參賽人數(shù)", [row['Nums'] for _, row in athlete[athlete.Season=='Winter'].iterrows()],
category_gap='50%',
itemstyle_opts=opts.ItemStyleOpts(
border_color='rgb(220,220,220)',
color=JsCode("""new echarts.graphic.LinearGradient(0, 0, 0, 1,
[{
offset: 1,
color: '#00BFFF'
}, {
offset: 0.8,
color: '#FFC0CB'
}, {
offset: 0,
color: '#40E0D0'
}])""")))
.set_series_opts(label_opts=opts.LabelOpts(is_show=True,
position='top',
font_style='italic'))
.set_global_opts(
title_opts=opts.TitleOpts(title="美國歷年奧運(yùn)會參賽人數(shù)-冬奧會", pos_left='center'),
xaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(rotate=45)),
legend_opts=opts.LegendOpts(is_show=False),
yaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(margin=20, color="#ffffff63")),
graphic_opts=[
opts.GraphicImage(
graphic_item=opts.GraphicItem(
id_="logo", right=0, top=-300, z=-10, bounding="raw", origin=[75, 75]
),
graphic_imagestyle_opts=opts.GraphicImageStyleOpts(
image="https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1586619952245&di=981a36305048f93eec791980acc99cf7&imgtype=0&src=http%3A%2F%2Fimg5.mtime.cn%2Fmg%2F2017%2F01%2F06%2F172210.42721559.jpg",
width=1000,
height=600,
opacity=0.6,),
)
],)
)
page = (
Page()
.add(s_bar,)
.add(w_bar,)
)
page.render_notebook()
歷屆奧運(yùn)會獲得獎(jiǎng)牌數(shù)
background_color_js = (
"new echarts.graphic.LinearGradient(1, 0, 0, 1, "
"[{offset: 0, color: '#008B8B'}, {offset: 1, color: '#FF6347'}], false)"
)
medals = USA_data.groupby(['Year', 'Season', 'Medal'])['Event'].nunique().reset_index()
medals.columns = ['Year', 'Season', 'Medal', 'Nums']
medals = medals.sort_values(by="Year" , ascending=False)
s_bar = (
Bar(init_opts=opts.InitOpts(theme='dark', width='1000px', height='300px'))
.add_xaxis(sorted(list(set([row['Year'] for _, row in medals[medals.Season=='Summer'].iterrows()])), reverse=True))
.add_yaxis("金牌", [row['Nums'] for _, row in medals[(medals.Season=='Summer') & (medals.Medal=='Gold')].iterrows()],
category_gap='20%',
itemstyle_opts=opts.ItemStyleOpts(
border_color='rgb(220,220,220)',
color=JsCode("""new echarts.graphic.LinearGradient(0, 0, 0, 1,
[{
offset: 0,
color: '#FFD700'
}, {
offset: 1,
color: '#FFFFF0'
}])""")))
.add_yaxis("銀牌", [row['Nums'] for _, row in medals[(medals.Season=='Summer') & (medals.Medal=='Silver')].iterrows()],
category_gap='20%',
itemstyle_opts=opts.ItemStyleOpts(
border_color='rgb(220,220,220)',
color=JsCode("""new echarts.graphic.LinearGradient(0, 0, 0, 1,
[{
offset: 0,
color: '#C0C0C0'
}, {
offset: 1,
color: '#FFFFF0'
}])""")))
.add_yaxis("銅牌", [row['Nums'] for _, row in medals[(medals.Season=='Summer') & (medals.Medal=='Bronze')].iterrows()],
category_gap='20%',
itemstyle_opts=opts.ItemStyleOpts(
border_color='rgb(220,220,220)',
color=JsCode("""new echarts.graphic.LinearGradient(0, 0, 0, 1,
[{
offset: 0,
color: '#DAA520'
}, {
offset: 1,
color: '#FFFFF0'
}])""")))
.set_series_opts(label_opts=opts.LabelOpts(is_show=True,
position='top',
font_style='italic'))
.set_global_opts(
title_opts=opts.TitleOpts(title="美國歷年奧運(yùn)會獲得獎(jiǎng)牌數(shù)數(shù)-夏奧會", pos_left='center'),
xaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(rotate=45)),
legend_opts=opts.LegendOpts(is_show=False),
yaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(margin=20, color="#ffffff63")),
graphic_opts=[
opts.GraphicImage(
graphic_item=opts.GraphicItem(
id_="logo", right=0, top=0, z=-10, bounding="raw", origin=[75, 75]
),
graphic_imagestyle_opts=opts.GraphicImageStyleOpts(
image="https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1586619952245&di=981a36305048f93eec791980acc99cf7&imgtype=0&src=http%3A%2F%2Fimg5.mtime.cn%2Fmg%2F2017%2F01%2F06%2F172210.42721559.jpg",
width=1000,
height=600,
opacity=0.6,),
)
],)
)
w_bar = (
Bar(init_opts=opts.InitOpts(theme='dark', width='1000px', height='300px'))
.add_xaxis(sorted(list(set([row['Year'] for _, row in medals[medals.Season=='Winter'].iterrows()])), reverse=True))
.add_yaxis("金牌", [row['Nums'] for _, row in medals[(medals.Season=='Winter') & (medals.Medal=='Gold')].iterrows()],
category_gap='20%',
itemstyle_opts=opts.ItemStyleOpts(
border_color='rgb(220,220,220)',
color=JsCode("""new echarts.graphic.LinearGradient(0, 0, 0, 1,
[{
offset: 0,
color: '#FFD700'
}, {
offset: 1,
color: '#FFFFF0'
}])""")))
.add_yaxis("銀牌", [row['Nums'] for _, row in medals[(medals.Season=='Winter') & (medals.Medal=='Silver')].iterrows()],
category_gap='20%',
itemstyle_opts=opts.ItemStyleOpts(
border_color='rgb(220,220,220)',
color=JsCode("""new echarts.graphic.LinearGradient(0, 0, 0, 1,
[{
offset: 0,
color: '#C0C0C0'
}, {
offset: 1,
color: '#FFFFF0'
}])""")))
.add_yaxis("銅牌", [row['Nums'] for _, row in medals[(medals.Season=='Winter') & (medals.Medal=='Bronze')].iterrows()],
category_gap='20%',
itemstyle_opts=opts.ItemStyleOpts(
border_color='rgb(220,220,220)',
color=JsCode("""new echarts.graphic.LinearGradient(0, 0, 0, 1,
[{
offset: 0,
color: '#DAA520'
}, {
offset: 1,
color: '#FFFFF0'
}])""")))
.set_series_opts(label_opts=opts.LabelOpts(is_show=True,
position='top',
font_style='italic'))
.set_global_opts(
title_opts=opts.TitleOpts(title="美國歷年奧運(yùn)會獲得獎(jiǎng)牌數(shù)-冬奧會", pos_left='center'),
xaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(rotate=45)),
legend_opts=opts.LegendOpts(is_show=False),
yaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(margin=20, color="#ffffff63")),
graphic_opts=[
opts.GraphicImage(
graphic_item=opts.GraphicItem(
id_="logo", right=0, top=-300, z=-10, bounding="raw", origin=[75, 75]
),
graphic_imagestyle_opts=opts.GraphicImageStyleOpts(
image="https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1586619952245&di=981a36305048f93eec791980acc99cf7&imgtype=0&src=http%3A%2F%2Fimg5.mtime.cn%2Fmg%2F2017%2F01%2F06%2F172210.42721559.jpg",
width=1000,
height=600,
opacity=0.6,),
)
],)
)
page = (
Page()
.add(s_bar,)
.add(w_bar,)
)
page.render_notebook()
優(yōu)勢項(xiàng)目
田徑目胡，游泳
background_color_js = (
"new echarts.graphic.LinearGradient(1, 0, 0, 1, "
"[{offset: 0.5, color: '#FFC0CB'}, {offset: 1, color: '#F0FFFF'}, {offset: 0, color: '#EE82EE'}], false)"
)
events = USA_data[USA_data.Medal=='Gold'].groupby(['Year', 'Sport'])['Event'].nunique().reset_index()
events = events.groupby(['Sport'])['Event'].sum().reset_index()
events.columns = ['Sport', 'Nums']
data_pair = [(row['Sport'], row['Nums']) for _, row in events.iterrows()]
wc = (WordCloud(init_opts=opts.InitOpts(bg_color=JsCode(background_color_js), width='1000px', height='600px'))
.add("", data_pair,word_size_range=[30, 80])
.set_global_opts(title_opts=opts.TitleOpts(title="美國獲得過金牌運(yùn)動(dòng)項(xiàng)目",pos_left="center",
title_textstyle_opts=opts.TextStyleOpts(color="white", font_size=20)))
)
wc.render_notebook()
被單個(gè)國家統(tǒng)治的奧運(yùn)會項(xiàng)目
很多運(yùn)動(dòng)長期以來一直是被某個(gè)國家統(tǒng)治，譬如我們熟知的中國????的乒乓球链快，美國????的籃球誉己；
此次篩選了近5屆奧運(yùn)會（2000年悉尼奧運(yùn)會之后）上累計(jì)產(chǎn)生10枚金牌以上且存在單個(gè)國家「奪金率」超過50%的項(xiàng)目；
俄羅斯????包攬了2000年以后花樣游泳 & 藝術(shù)體操兩個(gè)項(xiàng)目上所有的20枚金牌域蜗；
中國????在乒乓球項(xiàng)目上獲得了2000年之后10枚金牌中的9枚巨双，丟失金牌的一次是在04年雅典奧運(yùn)會男單項(xiàng)目上；
美國????在籃球項(xiàng)目上同樣獲得了過去10枚金牌中的9枚霉祸，丟失金牌的一次同樣在04年筑累，男籃半決賽中輸給了阿根廷，最終獲得銅牌丝蹭；
跳水項(xiàng)目上慢宗，中國????獲得了過去40枚金牌中的31枚，夢之隊(duì)名不虛傳奔穿；
射箭項(xiàng)目上镜沽，韓國????獲得了過去20枚金牌中的15枚；
羽毛球項(xiàng)目上贱田，中國????獲得了過去25枚金牌中的17枚缅茉；
沙灘排球項(xiàng)目上，美國????獲得了過去10枚金牌中的5枚男摧；
f1 = lambda x:max(x['Event']) / sum(x['Event'])
f2 = lambda x: x.sort_values('Event', ascending=False).head(1)
t_data = data[(data.Medal=='Gold') & (data.Year>=2000) &(data.Season=='Summer')].groupby(['Year', 'Sport', 'region'])['Event'].nunique().reset_index()
t_data = t_data.groupby(['Sport', 'region'])['Event'].sum().reset_index()
t1 = t_data.groupby(['Sport']).apply(f2).reset_index(drop=True)
t2 = t_data.groupby(['Sport'])['Event'].sum().reset_index()
t_data = pd.merge(t1, t2, on='Sport', how='inner')
t_data['gold_rate'] = t_data.Event_x/ t_data.Event_y
t_data = t_data.sort_values('gold_rate', ascending=False).reset_index(drop=True)
t_data = t_data[(t_data.gold_rate>=0.5) & (t_data.Event_y>=10)]
background_color_js = (
"new echarts.graphic.LinearGradient(1, 0, 0, 1, "
"[{offset: 0, color: '#008B8B'}, {offset: 1, color: '#FF6347'}], false)"
)
fn = """
function(params) {
if(params.name == '其他國家')
return '\\n\\n\\n' + params.name + ' : ' + params.value ;
return params.seriesName+ '\\n' + params.name + ' : ' + params.value;
}
"""
def new_label_opts():
return opts.LabelOpts(formatter=JsCode(fn), position="center")
pie = Pie(init_opts=opts.InitOpts(theme='dark', width='1000px', height='1000px'))
idx = 0
for _, row in t_data.iterrows():
if idx % 2 == 0:
x = 30
y = int(idx/2) * 22 + 18
else:
x = 70
y = int(idx/2) * 22 + 18
idx += 1
pos_x = str(x)+'%'
pos_y = str(y)+'%'
pie.add(
row['Sport'],
[[row['region'], row['Event_x']], ['其他國家', row['Event_y']-row['Event_x']]],
center=[pos_x, pos_y],
radius=[70, 100],
label_opts=new_label_opts(),)
pie.set_global_opts(
title_opts=opts.TitleOpts(title="被單個(gè)國家統(tǒng)治的項(xiàng)目",
subtitle='統(tǒng)計(jì)周期：2000年悉尼奧運(yùn)會起',
pos_left="center",
title_textstyle_opts=opts.TextStyleOpts(color="white", font_size=20)),
legend_opts=opts.LegendOpts(is_show=False),
)
pie.render_notebook()
歡迎點(diǎn)贊支持????????
