Error "KeyError: 'id'" on st.dataframe where style.format is used - sensitive to dataframe size

Steve_Hawkins · June 30, 2022, 11:29pm

Issue using st.dataframe with df.styles.format to format floats with 2 decimal places. See gist containing minimal case with 2 files at:

gist.github.com

https://gist.github.com/evoshawkins/1432dc9dd3c6a4358c8eb28688519734

issue-fail.py

import streamlit as st
import pandas as pd

df = pd.read_csv("https://leg-2-lou-docs-pics.s3.us-west-2.amazonaws.com/reports/invoices_fail_8193_rows.csv", dtype=str, parse_dates=[8,9])

col1, col2 = st.columns(2)

with col1:
    st.markdown("# Invoices ")

This file has been truncated. show original

issue.py

import streamlit as st
import pandas as pd

df = pd.read_csv("https://leg-2-lou-docs-pics.s3.us-west-2.amazonaws.com/reports/invoices_success_8192_rows.csv", dtype=str, parse_dates=[8,9])

col1, col2 = st.columns(2)

with col1:
    st.markdown("# Invoices ")

This file has been truncated. show original

ERROR occurs at line containing this statement:
st.dataframe(df.style.format({‘ItemSubTotalAmount’: ‘{:.2f}’, ‘TaxAmount’: ‘{:.2f}’, ‘TotalAmount’: ‘{:.2f}’}))

REPRODUCTION STEPS:

SUCCESS CASE:
streamlit run https://gist.github.com/evoshawkins/1432dc9dd3c6a4358c8eb28688519734/raw/5bc7998d663779150389973313c4a1396348ded2/issue.py

FAIL CASE:
streamlit run https://gist.github.com/evoshawkins/1432dc9dd3c6a4358c8eb28688519734/raw/5bc7998d663779150389973313c4a1396348ded2/issue-fail.py

The 1st example reads the CSV file from:
“https://leg-2-lou-docs-pics.s3.us-west-2.amazonaws.com/reports/invoices_success_8456_rows.csv”

The 2nd example points read the CSV file from: (it has one more row):
“https://leg-2-lou-docs-pics.s3.us-west-2.amazonaws.com/reports/invoices_fail_8457_rows.csv”