如何在Python中创建动态更新的SelectMultiple组件？解决单选失效问题

尝试创建一组SelectMultiple组件作为Pandas DataFrame的过滤器，实现单向依赖（从左到右）：选择左侧的分类后，自动限制后续所有组件的可选选项。示例数据如下：

import pandas as pd
data = {
    'category1': ['A', 'A', 'B', 'B', 'C', 'B'],
    'category2': ['X', 'Y', 'X', 'Z', 'Y', 'K'],
    'country': ['USA', 'USA', 'UK', 'UK', 'Canada', 'Germany'],
    'department': ['Dept1', 'Dept2', 'Dept1', 'Dept2', 'Dept1', 'Dept4'],
    'category3': ['Cat1', 'Cat2', 'Cat1', 'Cat2', 'Cat1', 'Cat2'],
    'gender': ['Male', 'Female', 'Male', 'Female', 'Male', 'Male'],
    'brand': ['Brand1', 'Brand2', 'Brand3', 'Brand4', 'Brand5', 'Brand2']
}
df = pd.DataFrame(data)

编写的代码如下：

import ipywidgets as widgets
from IPython.display import display

def update_options(category1, category2, country, department, category3, gender):
    filtered_df = df.copy()
    if category1:
        filtered_df = filtered_df[filtered_df['category1'].isin(category1)]
    if category2:
        filtered_df = filtered_df[filtered_df['category2'].isin(category2)]
    if country:
        filtered_df = filtered_df[filtered_df['country'].isin(country)]
    if department:
        filtered_df = filtered_df[filtered_df['department'].isin(department)]
    if category3:
        filtered_df = filtered_df[filtered_df['category3'].isin(category3)]
    if gender:
        filtered_df = filtered_df[filtered_df['gender'].isin(gender)]
   
    category2_options = filtered_df['category2'].unique().tolist()
    country_options = filtered_df['country'].unique().tolist()
    department_options = filtered_df['department'].unique().tolist()
    category3_options = filtered_df['category3'].unique().tolist()
    gender_options = filtered_df['gender'].unique().tolist()
    brand_options = filtered_df['brand'].unique().tolist()
   
    # Update options for dropdowns
    category2_dropdown.options = category2_options
    country_dropdown.options = country_options
    department_dropdown.options = department_options
    category3_dropdown.options = category3_options
    gender_dropdown.options = gender_options
    brand_dropdown.options = brand_options

# Define initial options for category1 and category2
category1_options = df['category1'].unique().tolist()
category2_options = df['category2'].unique().tolist()

# Create dropdown widgets
category1_dropdown = widgets.SelectMultiple(options=category1_options, description='Category 1:')
category2_dropdown = widgets.SelectMultiple(options=category2_options, description='Category 2:')
country_dropdown = widgets.SelectMultiple(description='Country:')
department_dropdown = widgets.SelectMultiple(description='Department:')
category3_dropdown = widgets.SelectMultiple(description='Category 3:')
gender_dropdown = widgets.SelectMultiple(description='Gender:')
brand_dropdown = widgets.SelectMultiple(description='Brand:')

# Use interact to dynamically update options
widgets.interact(update_options,
                 category1=category1_dropdown,
                 category2=category2_dropdown,
                 country=country_dropdown,
                 department=department_dropdown,
                 category3=category3_dropdown,
                 gender=gender_dropdown)

# Display widgets
display(brand_dropdown) # the others are displayed with widgets.interact() above

问题现象：后续组件的选项能正确更新，但当选项多于一个时，无法单独选择某一项，只能拖拽全选。比如选择category1=B后，category2显示选项X、Z、K，但点击单个选项无法选中，只能拖拽选中全部。

问题出在更新组件选项时没有保留当前选中状态，且widgets.interact的双向绑定会导致组件状态冲突。需要调整两点：

1. 更新选项前保存当前选中值，更新后恢复选中状态（过滤掉不在新选项里的选中值）
2. 使用observe替代interact，实现单向的依赖更新逻辑，避免双向绑定的冲突

修改后的完整代码：

import ipywidgets as widgets
from IPython.display import display
import pandas as pd

data = {
    'category1': ['A', 'A', 'B', 'B', 'C', 'B'],
    'category2': ['X', 'Y', 'X', 'Z', 'Y', 'K'],
    'country': ['USA', 'USA', 'UK', 'UK', 'Canada', 'Germany'],
    'department': ['Dept1', 'Dept2', 'Dept1', 'Dept2', 'Dept1', 'Dept4'],
    'category3': ['Cat1', 'Cat2', 'Cat1', 'Cat2', 'Cat1', 'Cat2'],
    'gender': ['Male', 'Female', 'Male', 'Female', 'Male', 'Male'],
    'brand': ['Brand1', 'Brand2', 'Brand3', 'Brand4', 'Brand5', 'Brand2']
}
df = pd.DataFrame(data)

# 创建所有SelectMultiple组件
category1_dropdown = widgets.SelectMultiple(options=df['category1'].unique().tolist(), description='Category 1:')
category2_dropdown = widgets.SelectMultiple(options=df['category2'].unique().tolist(), description='Category 2:')
country_dropdown = widgets.SelectMultiple(options=df['country'].unique().tolist(), description='Country:')
department_dropdown = widgets.SelectMultiple(options=df['department'].unique().tolist(), description='Department:')
category3_dropdown = widgets.SelectMultiple(options=df['category3'].unique().tolist(), description='Category 3:')
gender_dropdown = widgets.SelectMultiple(options=df['gender'].unique().tolist(), description='Gender:')
brand_dropdown = widgets.SelectMultiple(options=df['brand'].unique().tolist(), description='Brand:')

def update_filters(_):
    # 从左到右逐步过滤数据
    filtered_df = df.copy()
    
    # 应用category1过滤
    if category1_dropdown.value:
        filtered_df = filtered_df[filtered_df['category1'].isin(category1_dropdown.value)]
    
    # 更新category2选项，保留有效选中值
    current_category2 = category2_dropdown.value
    new_category2_options = filtered_df['category2'].unique().tolist()
    category2_dropdown.options = new_category2_options
    # 只保留存在于新选项中的选中值
    category2_dropdown.value = [v for v in current_category2 if v in new_category2_options]
    
    # 应用category2过滤
    if category2_dropdown.value:
        filtered_df = filtered_df[filtered_df['category2'].isin(category2_dropdown.value)]
    
    # 更新country选项
    current_country = country_dropdown.value
    new_country_options = filtered_df['country'].unique().tolist()
    country_dropdown.options = new_country_options
    country_dropdown.value = [v for v in current_country if v in new_country_options]
    
    # 应用country过滤
    if country_dropdown.value:
        filtered_df = filtered_df[filtered_df['country'].isin(country_dropdown.value)]
    
    # 更新department选项
    current_dept = department_dropdown.value
    new_dept_options = filtered_df['department'].unique().tolist()
    department_dropdown.options = new_dept_options
    department_dropdown.value = [v for v in current_dept if v in new_dept_options]
    
    # 应用department过滤
    if department_dropdown.value:
        filtered_df = filtered_df[filtered_df['department'].isin(department_dropdown.value)]
    
    # 更新category3选项
    current_cat3 = category3_dropdown.value
    new_cat3_options = filtered_df['category3'].unique().tolist()
    category3_dropdown.options = new_cat3_options
    category3_dropdown.value = [v for v in current_cat3 if v in new_cat3_options]
    
    # 应用category3过滤
    if category3_dropdown.value:
        filtered_df = filtered_df[filtered_df['category3'].isin(category3_dropdown.value)]
    
    # 更新gender选项
    current_gender = gender_dropdown.value
    new_gender_options = filtered_df['gender'].unique().tolist()
    gender_dropdown.options = new_gender_options
    gender_dropdown.value = [v for v in current_gender if v in new_gender_options]
    
    # 应用gender过滤
    if gender_dropdown.value:
        filtered_df = filtered_df[filtered_df['gender'].isin(gender_dropdown.value)]
    
    # 更新brand选项
    current_brand = brand_dropdown.value
    new_brand_options = filtered_df['brand'].unique().tolist()
    brand_dropdown.options = new_brand_options
    brand_dropdown.value = [v for v in current_brand if v in new_brand_options]

# 为每个左侧组件添加观察器，触发更新
category1_dropdown.observe(update_filters, names='value')
category2_dropdown.observe(update_filters, names='value')
country_dropdown.observe(update_filters, names='value')
department_dropdown.observe(update_filters, names='value')
category3_dropdown.observe(update_filters, names='value')
gender_dropdown.observe(update_filters, names='value')

# 显示所有组件
display(category1_dropdown, category2_dropdown, country_dropdown, department_dropdown, category3_dropdown, gender_dropdown, brand_dropdown)

关键修改点说明 #

• 使用observe替代interact：避免interact的双向绑定导致的状态冲突，只在组件值变化时触发单向更新
• 保存并恢复选中状态：更新选项前记录当前选中值，更新后只保留存在于新选项中的选中值，确保组件可正常选择单个选项
• 严格单向过滤顺序：从左到右依次应用过滤条件，保证依赖逻辑的正确性

内容的提问来源于stack exchange，提问作者Harrv7