Python Panel Select com Dataframe

Criando painel com select e dataframe

Select com Gráfico
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
import panel as pn
import pandas as pd
import matplotlib.pyplot as plt
import numpy as np


# Carregando dados
df = pd.read_excel('dados.xlsx')
# print(df.head())

# melhor apresentar como string
df['CD_DEPE'] = df['CD_DEPE'].astype(str)

# separando os combos
combo_depe = df['CD_DEPE'].unique().tolist()


# elementos que serão utilizados
# select para dependencias
# dataframe utilizado
depes_select  = pn.widgets.Select(options=combo_depe, name="Escolha")
df_widget = pn.widgets.DataFrame(df, name='Dados')

# Define a callback function to update the DataFrame widget based on the selected date
def update_df(event):
    selected_date = event.new
    filtered_df = df[df['CD_DEPE'] == selected_date]
    df_widget.value = filtered_df

# Link the Select widget to the callback function
depes_select.param.watch(update_df, 'value')


pn.template.MaterialTemplate(
    site="Painel",
    title="Dados",
    # sidebar=[variable_widget, window_widget, sigma_widget],
    main=[depes_select, df_widget],
).servable();