Streamlit and DataFrame Output - Options aren't showing up

[HarryMelamed]

I’m new to this streamlit

I’m trying to display DataFrames and I set the options for max and min rows and columns and the results aren’t reflecting the options I selected.

Here’'s a code snippet

pd.set_option(‘display.max_columns’, 12)
pd.set_option(‘display.min_rows’, 20)
pd.set_option(‘display.max_rows’, 50)

pd.get_option(“display.max_rows”)

result_dataFrame = pd.read_sql(query, mydb)
#result_dataFrame.columns()

st.title(‘BDK Services Group’)
st.write(result_dataFrame)

Any help would be most welcome.

[dataprofessor]

Hi @HarryMelamed

You can set the width and height of a dataframe via the st.dataframe() method by defining the height and width parameters.

The Docs page has further details:

st.dataframe - Streamlit Docs

Hope this helps!

[HarryMelamed]

this didn’t work

It seems there is a max size for these streamlit DF