Pagination in streamlit

shabtay · December 14, 2022, 6:51am

Summary

I’ve developed a small search engine (google style) so when I write the search term in the window the script go and search it in mysql db and display the results, for now I limit the results to 10 but I want to add a pagination functionality and I’m not so sure how to use the session state in that case.

Steps to reproduce

Code snippet:

    term = st.text_input('Enter search words:')
    if term:
        results = search(term) ### that's the function that do the search in the db
        st.caption(f'Number of results: {len(results)}')
        for item in results:
             st.write(item["url"])

Thanks

mathcatsand · December 14, 2022, 7:29am

Here’s an example with pagination with images.

github.com

MathCatsAnd/Streamlit-Mechanics-Examples/blob/main/pages/relabeling_images.py

import streamlit as st
from math import ceil
import pandas as pd

root = 'https://raw.githubusercontent.com/MathCatsAnd/Streamlit-Mechanics-Examples/main/'

def initialize():    
    df = pd.read_csv('file_list.csv')
    df['incorrect']=[False]*df.shape[0]
    df['label']=['']*df.shape[0]
    df['file']=df['file'].map(lambda x:x.replace("\\", "/"))
    df.set_index('file', inplace=True)
    return df

if 'relabeling_images__df' not in st.session_state:
    df = initialize()
    st.session_state.relabeling_images__df = df
else:
    df = st.session_state.relabeling_images__df

This file has been truncated. show original

Hosted here:
https://mathcatsand-examples.streamlit.app/relabeling_images

Let me know if you need the example simplified.

shabtay · December 14, 2022, 8:39am

Thanks a lot bro, I think I finally got it lol
it’s pretty much working for me now!