Paginated Dataframe

Using Streamlit
#1

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

#2

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.

1 Like
#3

We also have a GitHub issue for making dataframes better, so keep an eye on this issue:

1 Like
#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

1 Like
#5

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

#6

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_size]
#7

check streamlit-aggrid. It has a pagination option.

Check a live example here. Just click Enable Pagination on the sidebar.

1 Like