Hi, May I ask please, if there is a solution for showing large data frames in a paginated form, e.g. 20 rows at a time, apart from manually implementing this using a slider? I mean something like Jupyter itables: https://github.com/mwouts/itables Many thanks Best

Hi @aghasemi , I think there’s no way to do it apart from manually implementing this using a num_count or slider, I had added this workaround on one of the posts, you might find it helpful. [image] Streamlit app disconnects and stops before displaying data 🎈 Using Streamlit …

We also have a GitHub issue for making dataframes better, so keep an eye on this issue: Make st.dataframe more awesome opened 08:20AM - 14 May 20 UTC (UTC) [tvst] tvst …

Maybe take a look at https://github.com/datapane/datapane . This application paginates pandas dataframes.

You may use this simple method if you want pagination for a backend pandas dataframe:- def paginate_dataframe(dataframe, page_size, page_num): page_size = page_size if page_size is None: return None offset = page_size*(page_num-1) return dataframe[offset:offset + page_s…

check streamlit-aggrid . It has a pagination option. Check a live example here . Just click Enable Pagination on the sidebar.

Once dataframe is in order, you can take help of Index (which is default in pandas dataframe) and use query function. Following solution is keeping in mind that you are loading large data in dataframe. #load large data from database ex query = “select top 1000000 * from [transaction];” df = pd.…

Paginated Dataframe

Using Streamlit

andfanilo September 30, 2020, 2:13pm 4

Last but not least, if you feel HTML-adventurous, you could build a static paginated MaterialUI Table by editing this solution on the MaterialUI paginated dataframe example

Topic		Replies	Views
St.dataframe can only handle 50mb Using Streamlit	2	1054	January 12, 2022
Navigating through dataframe records Using Streamlit	3	2058	December 2, 2022
How can I get next button to display only limited rows of a dataframe and then have next buttton Custom Components	5	4909	May 13, 2022
Paginate large dataframe ("server side") AND use dynamic widgets for dataframe filtering? Using Streamlit session-state , pandas	1	1678	November 1, 2022
Scalabilty of streamlit for pandas Using Streamlit cache , pandas	4	9194	November 19, 2021

Paginated Dataframe

Related topics