Pagination size (custom range set)

HHaleshot

CC: @tripleshot "does anyone know how to adjust the pagination size when working with pandas dataframes? it's stuck at 10 rows per page. I tried pd.set_option("display.min_rows", 20) but doesn't do anything and I can't find any docs"; message link - https://discord.com/channels/1059888774789730424/1179936876103225354/1303649800654159965

11 comments

HHaleshot

Using mo.ui.table can help in this regard.

HHaleshot

Sample code:

Plain Text

df = pd.read_csv("<dataset-path>")

table = mo.ui.table(
    data=df,
    pagination=True,  # Enable pagination
    page_size=4,     # Set the number of rows per page
    label="Label name"
)
table

HHaleshot

Relevant marimo documentation - mo.ui.table

ttripleshot

thanks @Haleshot but may I ask why the need for workaround since in Jupyter notebook this can be adjusted using standard pandas config. It seems like added complication every time you want to view a df for what should be a config. What am I missing?

ttripleshot

why is 10 rows a hardcoded config

MMyles Scolnick

@tripleshot
we default rendering rich dataframes using our table, since it supports pagination, filtering, sorting, etc.

we found 10 to be a good default because of these navigation features (pagination, filtering, sorting).

you can however turn off "rich dataframes" in your User Configuration in the editor UI (let me know if you can't find this setting)

if you want to revert to the plain html ui without a rich datatable, you can use mo.plain

Plain Text

import marimo as mo
mo.plain(df) # This renders pandas as its plain html

for the above, you don't need to include all the configuration, you can instead do

Plain Text

mo.ui.table(df, page_size=40)

ttripleshot

thank you for the great answer. Lots of options in there to choose from and the last one is short enough to be relatively pain free. Would be great to see this configurable in future though!

MMyles Scolnick

@tripleshot, would you want to configure the default dataframe size but still using the rich tables? and this configuratoin to apply to ALL tables? and on a per notebook basis? or as your own user?
(just want to clarify to log the feature request)

ttripleshot

per notebook basis. So my current use-case is I am doing exploration work on a small df of 34 rows. I need to filter and twist it in different ways. if I can just df[....] at the end of a cell with all the "query" logic that's way more intuitive for me than to have to wrap it inside some other code. I think the pandas set_option mechanism works really well tbh and you can choose when/how to use it. It would just be nice if that got respected since that's how people use it?

ttripleshot

it's what I tried first by the way (coming from prior knowledge of pandas and notebooks)

MMyles Scolnick

got it, your use-case makes sense. thanks for elaborating

Add a reply

Get help from the marimo community

Pagination size (custom range set)