python - Plotly 下拉选择无法正确更新绘图
问题描述
我想创建一个具有选择可能性的交互式绘图来保存独立的 HTML 文件,因此我不想使用破折号。
目标是显示房价趋势,并可以选择区域和房间数量。问题是,一旦我更改了选择,所有绘图仍然处于活动状态而没有正确更新。有人可以帮助解决这个问题吗?我已经用我自己的语言(立陶宛语)进行了绘图。为了方便起见,我翻译了代码中的变量名。
示例输入数据
df = pd.DataFrame({'Region_title': {0: 'Kaunas',
1: 'Kaunas',
2: 'Kaunas',
3: 'Kaunas',
4: 'Kaunas',
5: 'Kaunas',
6: 'Vilnius',
7: 'Vilnius',
8: 'Vilnius',
9: 'Vilnius',
10: 'Vilnius',
11: 'Vilnius'},
'Room_number': {0: 1,
1: 2,
2: 1,
3: 2,
4: 1,
5: 2,
6: 1,
7: 2,
8: 1,
9: 2,
10: 1,
11: 2},
'Year_quarter': {0: '2010-01',
1: '2010-01',
2: '2014-01',
3: '2014-01',
4: '2019-01',
5: '2019-01',
6: '2010-01',
7: '2010-01',
8: '2014-01',
9: '2014-01',
10: '2019-01',
11: '2019-01'},
'Price': {0: 100,
1: 200,
2: 300,
3: 400,
4: 500,
5: 600,
6: 300,
7: 500,
8: 700,
9: 900,
10: 1100,
11: 1300}})
import plotly.offline as pyo
import plotly.graph_objs as go
import numpy as np
def compare_elements_with_single_value(all_list, value):
all_comparison = []
for elem in all_list:
comp = elem == value
all_comparison.append(comp)
return(all_comparison) #e.g. [False, False, ...., True]
df = df.sort_values(["Region_title", "Room_number", "Year_quarter"])
fig = go.Figure()
region_list = df['Region_title'].unique()
room_number_list = df['Room number'].unique()
all_list = []
for region in region_list:
for room_number in room_number_list:
all_list.append(str(region) + " Room number " + str(room_number))
for region in region_list:
for room_number in room_number_list:
region_room_number = str(region) + " Room number " + str(room_number)
fig.add_trace(go.Scatter(
x = df[(df['Region_title'] == region)
& (df['Room_number'] == room_number)]['Year_quarter'],
y = df[(df['Region_title'] == region)
& (df['Room_number'] == room_number)]['price'],
text = "Average price",
hoverinfo = "x+y",
name = region_room_number,
mode ='lines+markers',
marker={'size': 10, 'opacity': 0.5, 'line': {'width': 0.5, 'color': 'white'
}}))
updatemenu= []
buttons=[]
for region in region_list:
for room_number in room_number_list:
region_room_number = str(region) + " Room number " + str(room_number)
buttons.append(dict(method='restyle',
label = str(region) + " Room_number " + str(room_number),
args = [{'x':[df[(df['Region_title'] == region)
& (df['Room_number'] == room_number)]['Year_quarter']]},
{'y':[df[(df['Region_title'] == region)
& (df['Room_number'] == room_number)]['Price']]},
{'visible': compare_elements_with_single_value(all_list, region_room_number)}
]
))
updatemenu=[]
your_menu=dict()
updatemenu.append(your_menu)
updatemenu[0]['buttons']=buttons
updatemenu[0]['direction']='down'
updatemenu[0]['showactive']=True
fig.update_layout(updatemenus=updatemenu,
showlegend=True,
yaxis_title="EUR / m2")
fig.show()
pyo.plot(fig, filename='Output/Flat price.html')
解决方案
您是否正在寻找类似的东西:
对数据进行排序并将下拉列表添加到 df
import plotly.graph_objects as go
import pandas as pd
df = df.sort_values(["Region_title", "Room_number", "Year_quarter"])\
.reset_index(drop=True)
df["dropdown"] = df.apply(lambda x: '{} - Room nbr {}'.format(x['Region_title'], x["Room_number"]),
axis=1)
轨迹和按钮
colors_list = ['#1f77b4', # muted blue
'#ff7f0e', # safety orange
'#2ca02c', # cooked asparagus green
'#d62728', # brick red
'#9467bd', # muted purple
'#8c564b', # chestnut brown
'#e377c2', # raspberry yogurt pink
'#7f7f7f', # middle gray
'#bcbd22', # curry yellow-green
'#17becf' # blue-teal
]
dfs = list(df.groupby('dropdown'))
first_title = dfs[0][0]
traces = []
buttons = []
for i,d in enumerate(dfs):
visible = [False]*4
visible[i] = True
name = d[0]
traces.append(
go.Scatter(x = d[1]["Year_quarter"],
y = d[1]["Price"],
text = "Average price",
hoverinfo = "x+y",
mode = 'lines+markers',
visible = True if i==0 else False,
name = name,
marker = {'color':colors_list[i%len(colors_list)],
'size': 10,
'opacity': 0.5,
'line': {'width': 0.5,
'color': 'white'}
}
))
buttons.append(dict(label=name,
method="update",
args=[{"visible":visible},
{"title":f"Title {name}"}]))
updatemenus = [{'active':0, "buttons":buttons}]
fig = go.Figure(data=traces,
layout=dict(updatemenus=updatemenus))
fig.update_layout(title=first_title, title_x=0.5)
fig.update_yaxes(range=[0, df["Price"].max()*1.2])
fig.show()
这里的想法是通过下拉列表中所需的按钮拆分 df 并使用可见的痕迹。
推荐阅读
- sql - 计算每个用户在 sql 问题中花费的时间
- kubernetes - kubernetes:通过选择最近的节点来运行 pod/deployment
- spring - 迁移到 Spring Boot 2.1.7 RELEASE-initializeBean 后不起作用
- javascript - 如何设置级联select2值onClick
- python - 如何在循环中更新数据框中的值?
- javascript - 逻辑运算符 || 不知何故没有给出预期的结果
- prestashop - 在 prestashop 中为模块添加许可证密钥的最佳方法
- c# - MVC4 到 MV5 机器密钥验证
- javascript - 单击div时如何显示另一个div?
- c++ - C++ Windows - 通过可执行文件路径获取进程的 PID