import panel as pn
import pandas as pd
from panel_gwalker import GraphicWalker
pn.extension(template="fast")
df_exp = pd.read_excel('WtoData_CommServExports.xlsx', skiprows=2)
df_exp_long = pd.melt(
df_exp,
id_vars=['Reporting Economy', 'Product/Sector', 'Partner Economy'], # Columns to keep in the long format
var_name='Year', # Name of the new column for years
value_name='Export Value ($mill)' # Name of the new column for values
)
GraphicWalker(df_exp_long).servable()