Как создать динамически обновляемый виджет SelectMultiple в Python?

Мне удалось сделать это правильно. Проблема заключалась в том, что виджеты путались, если все это было в одной функции (своего рода ссылка на цикл). Их нужно распределить вниз.

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

# Sample DataFrame
data = {
    'category1': ['A', 'A', 'B', 'B', 'C'],
    'category2': ['X', 'Y', 'X', 'Z', 'Y'],
    'country': ['USA', 'USA', 'UK', 'UK', 'Canada'],
    'department': ['Dept1', 'Dept2', 'Dept1', 'Dept2', 'Dept1'],
    'category3': ['Cat1', 'Cat2', 'Cat1', 'Cat2', 'Cat1'],
    'gender': ['Male', 'Female', 'Male', 'Female', 'Male'],
    'brand': ['Brand1', 'Brand2', 'Brand3', 'Brand4', 'Brand5']
}

df = pd.DataFrame(data)

# Function to update options of category2_dropdown based on category1 selection
def update_category2_options(change):
    if change.new:        
        filtered_df = df[df['category1'].isin(change.new)]
        options = filtered_df['category2'].unique()
        category2_dropdown.options = options
    else:
        category2_dropdown.options = []

# Function to update options of country_dropdown based on category1 and category2 selections
def update_country_options(change):
    if change.new:
        filtered_df = df[df['category1'].isin(category1_dropdown.value)]
        if category2_dropdown.value:
            filtered_df = filtered_df[df['category2'].isin(category2_dropdown.value)]
        options = filtered_df['country'].unique()
        country_dropdown.options = options
    else:
        country_dropdown.options = []

# Function to update options of department_dropdown based on category1, category2, and country selections
def update_department_options(change):
    if change.new:
        filtered_df = df[df['category1'].isin(category1_dropdown.value)]
        if category2_dropdown.value:
            filtered_df = filtered_df[df['category2'].isin(category2_dropdown.value)]
        if country_dropdown.value:
            filtered_df = filtered_df[df['country'].isin(country_dropdown.value)]
        options = filtered_df['department'].unique()
        department_dropdown.options = options
    else:
        department_dropdown.options = []

# Function to update options of category3_dropdown based on category1, category2, country, and department selections
def update_category3_options(change):
    if change.new:
        filtered_df = df[df['category1'].isin(category1_dropdown.value)]
        if category2_dropdown.value:
            filtered_df = filtered_df[df['category2'].isin(category2_dropdown.value)]
        if country_dropdown.value:
            filtered_df = filtered_df[df['country'].isin(country_dropdown.value)]
        if department_dropdown.value:
            filtered_df = filtered_df[df['department'].isin(department_dropdown.value)]
        options =  filtered_df['category3'].unique()
        category3_dropdown.options = options
    else:
        category3_dropdown.options = []

# Function to update options of gender_dropdown based on category1, category2, country, department, and category3 selections
def update_gender_options(change):
    if change.new:
        filtered_df = df[df['category1'].isin(category1_dropdown.value)]
        if category2_dropdown.value:
            filtered_df = filtered_df[df['category2'].isin(category2_dropdown.value)]
        if country_dropdown.value:
            filtered_df = filtered_df[df['country'].isin(country_dropdown.value)]
        if department_dropdown.value:
            filtered_df = filtered_df[df['department'].isin(department_dropdown.value)]
        if category3_dropdown.value:
            filtered_df = filtered_df[df['category3'].isin(category3_dropdown.value)]
        options = filtered_df['gender'].unique()
        gender_dropdown.options = options
    else:
        gender_dropdown.options = []

def update_brand_options(change):
    if change.new:
        filtered_df = df[df['category1'].isin(category1_dropdown.value)]
        if category2_dropdown.value:
            filtered_df = filtered_df[df['category2'].isin(category2_dropdown.value)]
        if country_dropdown.value:
            filtered_df = filtered_df[df['country'].isin(country_dropdown.value)]
        if department_dropdown.value:
            filtered_df = filtered_df[df['department'].isin(department_dropdown.value)]
        if category3_dropdown.value:
            filtered_df = filtered_df[df['category3'].isin(category3_dropdown.value)]
        if gender_dropdown.value:
            filtered_df = filtered_df[df['gender'].isin(gender_dropdown.value)]
        options = filtered_df['brand'].unique()
        brand_dropdown.options = options
    else:
        brand_dropdown.options = []

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

# Use observe to dynamically update options
category1_dropdown.observe(update_category2_options, names='value')
category1_dropdown.observe(update_country_options, names='value')
category1_dropdown.observe(update_department_options, names='value')
category1_dropdown.observe(update_category3_options, names='value')
category1_dropdown.observe(update_gender_options, names='value')
category1_dropdown.observe(update_brand_options, names='value')

category2_dropdown.observe(update_country_options, names='value')
category2_dropdown.observe(update_department_options, names='value')
category2_dropdown.observe(update_category3_options, names='value')
category2_dropdown.observe(update_gender_options, names='value')
category2_dropdown.observe(update_brand_options, names='value')

country_dropdown.observe(update_department_options, names='value')
country_dropdown.observe(update_category3_options, names='value')
country_dropdown.observe(update_gender_options, names='value')
country_dropdown.observe(update_brand_options, names='value')

department_dropdown.observe(update_category3_options, names='value')
department_dropdown.observe(update_gender_options, names='value')
department_dropdown.observe(update_brand_options, names='value')

category3_dropdown.observe(update_gender_options, names='value')
category3_dropdown.observe(update_brand_options, names='value')

gender_dropdown.observe(update_brand_options, names='value')

# Display widgets
display(category1_dropdown, category2_dropdown, country_dropdown, department_dropdown, category3_dropdown, gender_dropdown, brand_dropdown)