How to filter a database and show all the information in the row?

Using Streamlit
,
1

Hey! I need some help with my streamlit project.

I have an excel file with 24 columns and 192 rows, and I want to show all the information of a specific data. I mean all the columns of the filtered data using multiple selectbox. I can do it with a variable, but when I add another filter I get an error. I have an example to explain myself (my english isn’t the best)

A B C D E F
1 a aa 12 p f q
2 a bb 13 o t w
3 b cc 14 e n k
4 b dd 15 r g v

When I filter by “a” the application shows me all the information related to “a” (row 1 and 2, and columns A, B, C, D, E, F), but when I add a filter with respect to column B, I have an error. Can someone help me? thanks a lot.

2

try this to capture your excel file columns

df=pd.read_excel(yourexcelfile)
header=df.columns.to_list()
a=st.selectbox("请选择要对原始表格的哪一列做透视",(header))