Tabulator columns not resizing after re-populating with new data

Panel
1

When I do my_tabulator.value = my_df with new data frame data, the columns do not resize to fit the new data. I have found a workaround where I populate it with an empty dataframe, then populate it with the new data, but that has been causing weird behaviors lately. I can’t seem to find any info anywhere about this. Is there a solution to this?

2

Can you share a minimal example? Thanks!

3 
def pop_table(self, id=None, filters=None):
        self.df = self.crud_manager.custom_df(filters=filters)
        self.table.value = self.df
4

Sorry I meant a fully runnable, copy-pastable example with minimum dependencies

6

sorry. That was not minimal. Let me make one

7 
import panel as pn
import pandas as pd
from random import randint

# Enable Tabulator extension
pn.extension('tabulator')

# Sample initial data
data = {'Name': ['Alice', 'Bob', 'Charlie'], 'Age': [24, 30, 22]}
df = pd.DataFrame(data)

# Class definition
class SimpleTabulatorApp:
    def __init__(self):
        # Define the Tabulator widget with the initial DataFrame
        self.tabulator = pn.widgets.Tabulator(df, height=300, width=400)

        # Define the Button widget
        self.button = pn.widgets.Button(name='Update Data', button_type='primary')

        # Set up the on_click method for the button
        self.button.on_click(self.update_data)

        # Layout for the app
        self.layout = pn.Column(self.tabulator, self.button)

    # Method to update the DataFrame and repopulate the Tabulator
    def update_data(self, event):
        # Update the DataFrame with new random ages
        new_data = {'Name': ['Alice', 'Bob', 'Charlie with a Long Last name'], 'Age': [randint(20, 40) for _ in range(3)]}
        new_df = pd.DataFrame(new_data)

        # Repopulate the Tabulator with the updated DataFrame
        self.tabulator.value = new_df

    # Method to display the app
    def show(self):
        return self.layout

# Instantiate the app
app = SimpleTabulatorApp()

# Display the app
app.show().servable()
8

Thanks for the MRVE. Here’s a workaround to use placeholder. Otherwise, you may want to report it on GitHub issues.

import panel as pn
import pandas as pd
from random import randint

# Enable Tabulator extension
pn.extension('tabulator')

# Sample initial data
data = {'Name': ['Alice', 'Bob', 'Charlie'], 'Age': [24, 30, 22]}
df = pd.DataFrame(data)

# Class definition
class SimpleTabulatorApp:
    def __init__(self):
        # Define the Tabulator widget with the initial DataFrame
        self.placeholder = pn.pane.Placeholder()
        tabulator = pn.widgets.Tabulator(df, height=300, width=400, layout="fit_data")
        self.placeholder.object = tabulator

        # Define the Button widget
        self.button = pn.widgets.Button(name='Update Data', button_type='primary')

        # Set up the on_click method for the button
        self.button.on_click(self.update_data)

        # Layout for the app
        self.layout = pn.Column(self.placeholder, self.button)

    # Method to update the DataFrame and repopulate the Tabulator
    def update_data(self, event):
        # Update the DataFrame with new random ages
        new_data = {'Name': ['Alice', 'Bob', 'Charlie with a Long Last name'], 'Age': [randint(20, 40) for _ in range(3)]}
        new_df = pd.DataFrame(new_data)

        # Repopulate the Tabulator with the updated DataFrame
        tabulator = pn.widgets.Tabulator(new_df, height=300, width=400, layout="fit_data")
        self.placeholder.object = tabulator

    # Method to display the app
    def show(self):
        return self.layout

# Instantiate the app
app = SimpleTabulatorApp()

# Display the app
app.show().show()