how to save user modified data table?
If you just want to load the table as an .csv or .xlsx, set export_format to ‘csv’ or ‘xlsx’, accordingly (see https://dash.plotly.com/datatable/reference).
If you want to persist the state of the table locally, use persistence=True with ‘data’ in persisted_props.
If you want to more permanently store table data, I recommend using Postgresql with psycopg2 or SQLAlchemy. Probably most straightforward is to store table data as json (for example in a callback when the user clicks a button).
Here is the code.
dash_table.DataTable(
id='kpi_retail_monthly',
data=df.to_dict('rows'),
persistence=True,
rsisted_props =['data'],
columns=[.......