单击以更新另一张图
"悬停即更新"的图表收获了很多好评。真是妙极了!您的工作正在把枯燥、静态的可视化变成有互动的"体验"。
现在有人希望修改上一节中您创建的仪表板。该电商公司的汇报层级依次为:国家、一级品类、二级品类。因此,他们更希望悬停时不要再更新底部的柱状图。
相反,他们想看看能否通过单击"一级品类"柱状图来更新下面的柱状图。之所以提出这个需求,是为了比较不同国家之间各一级品类的销售占比差异。
基于您刚完成的点击与悬停交互,您已经知道如何实现了!
本练习是课程的一部分
使用 Dash 和 Plotly 构建仪表板
练习说明
- 确保
'Major Category'可用于点击数据:在第 37 行下方,将其添加到一级品类柱状图的custom_data参数中。 - 在第 45 行下方设置一个回调:当单击
major_cat图中的某个柱时,更新minor_cat图表。
交互式实操练习
通过完成这段示例代码来试试这个练习。
from dash import Dash, dcc, html, Input, Output, callback
import plotly.express as px
import pandas as pd
ecom_sales = pd.read_csv('/usr/local/share/datasets/ecom_sales.csv')
logo_link = 'https://assets.datacamp.com/production/repositories/5893/datasets/fdbe0accd2581a0c505dab4b29ebb66cf72a1803/e-comlogo.png'
ecom_country = ecom_sales.groupby('Country')['OrderValue'].agg(['sum', 'count']).reset_index().rename(columns={'count':'Sales Volume', 'sum':'Total Sales ($)'})
ecom_scatter = px.scatter(ecom_country, x='Total Sales ($)', y='Sales Volume', color='Country', width=350, height=550, custom_data=['Country'])
ecom_scatter.update_layout({'legend':dict(orientation='h', y=-0.7,x=1, yanchor='bottom', xanchor='right')})
app = Dash()
app.layout = [
html.Img(src=logo_link, style={'margin':'30px 0px 0px 0px'}),
html.H1('Sales breakdowns'),
html.Div([
html.H3('Sales Volume vs Sales Amount by Country'),
dcc.Graph(id='scatter', figure=ecom_scatter)],
style={'width':'350px', 'height':'650px', 'display':'inline-block',
'vertical-align':'top', 'border':'1px solid black', 'padding':'20px'}),
html.Div([
dcc.Graph(id='major_cat'),
dcc.Graph(id='minor_cat')],
style={'width':'700px', 'height':'650px','display':'inline-block'})
]
@callback(
Output('major_cat', 'figure'),
Input('scatter', 'hoverData'))
def update_major_cat_hover(hoverData):
hover_country = 'Australia'
if hoverData:
hover_country = hoverData['points'][0]['customdata'][0]
major_cat_df = ecom_sales[ecom_sales['Country'] == hover_country]
major_cat_agg = major_cat_df.groupby('Major Category')['OrderValue'].agg('sum').reset_index(name='Total Sales ($)')
ecom_bar_major_cat = px.bar(major_cat_agg, x='Total Sales ($)',
# Ensure the Major Category will be available
____=['Major Category'],
y='Major Category', height=300,
title=f'Sales by Major Category for: {hover_country}', color='Major Category',
color_discrete_map={'Clothes':'blue','Kitchen':'red', 'Garden':'green', 'Household':'yellow'})
ecom_bar_major_cat.update_layout({'margin':dict(l=10,r=15,t=40,b=0), 'title':{'x':0.5}})
return ecom_bar_major_cat
# Set up a callback for click data
@callback(
Output('minor_cat', 'figure'),
Input('____', '____'))
def update_major_cat_click(clickData):
click_cat = 'All'
major_cat_df = ecom_sales.copy()
total_sales = major_cat_df.groupby('Country')['OrderValue'].agg('sum').reset_index(name='Total Sales ($)')
if clickData:
click_cat = clickData['points'][0]['customdata'][0]
major_cat_df = ecom_sales[ecom_sales['Major Category'] == click_cat]
country_mj_cat_agg = major_cat_df.groupby('Country')['OrderValue'].agg('sum').reset_index(name='Total Sales ($)')
country_mj_cat_agg['Sales %'] = (country_mj_cat_agg['Total Sales ($)'] / total_sales['Total Sales ($)'] * 100).round(1)
ecom_bar_country_mj_cat = px.bar(country_mj_cat_agg, x='Sales %', y='Country',
orientation='h', height=450, range_x = [0,100], text='Sales %',
title=f'Global Sales % by Country for Major Category: {click_cat}')
ecom_bar_country_mj_cat.update_layout({'yaxis':{'dtick':1, 'categoryorder':'total ascending'}, 'title':{'x':0.5}})
return ecom_bar_country_mj_cat
if __name__ == '__main__':
app.run(debug=True)