Only when I am specifying nrows with pd.read_excel Streamlit accepts the dataframe
df = pd.read_excel(io=uploaded_file, engine=“openpyxl”, sheet_name=“data”, skiprows=3,
usecols=[0, 1, 2, 3, 7], names=[‘year’, ‘month’, ‘day’, ‘hour’, ‘Hm0’], nrows=8767)
When nrows is omitted I get an error message, the excel sheet is clean and filled with proper data
What could this error be and how can I read in any Excel sheet with a certain given rows?
When running the code in jupyter notebook or other code editor there are no errors.