Streamlit doesn't display pandas data frame

Using Streamlit
1

Hello, I am transposing a pandas df, and trying to print out using st.table().
The code:

from astroquery.ipac.ned import Ned

objectInput = 'ABELL 2218'
result_tableNED = Ned.query_object(objectInput)
dataFrameObjectNED = result_tableNED.to_pandas()
st.table(dataFrameObjectNED.T)

Error:

StreamlitAPIException: ("Could not convert 'ABELL 2218' with type str: tried to convert to int64", 'Conversion failed for column 0 with type object')

Same code in jupyter works fine but without using streamlit.
Thank you

2

It’s a bit of a hack, but if you’re just trying to display the data, you can convert it all to strings, then either display it with st.table or st.dataframe

import streamlit as st
from astroquery.ipac.ned import Ned

objectInput = "ABELL 2218"
result_tableNED = Ned.query_object(objectInput)
dataFrameObjectNED = result_tableNED.to_pandas()

dataFrameObjectNED = dataFrameObjectNED.astype(str)

st.table(dataFrameObjectNED.T)
st.dataframe(dataFrameObjectNED.T)
3

Thank you, will try it!

4

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.