I have written a Dash app to sample and plot values into SQLite db then plot it into live graph.
I want then to download those tables from SQLite, but to pull all of them together into one Excel file. Is there any way to merge all tables into one big table, although all tables have the same structure.
Any help ?
Welcome to the community!
If I understand it, all you need to do is concat all the dataframes together and then download it, is that correct?
Hello, thanks for the replay, yes that’s actually what I want.
You should be able to use pd.concat for this and then export it.
Just bring in all the target table’s data and merge them together and use a dcc.Download to give the prompt to the user: