I am unsure if you were looking for a drop down of if the user would type their search. In this case they can type “2T” or “3T” and it would show only their user info and if they type “T” it would show all of the other users info.
import streamlit as st
import pandas as pd
df=pd.read_csv(INSERT YOUR FILE PATH HERE)
user_input=st.text_input(“User Search”)
if df[“C”].str[1::].str.contains(user_input).any() and user_input!="":
st.write(df[df[“C”].str[1::].str.contains(user_input)])
elif df[“C”].str[1::].str.contains(user_input).any()==False:
st.write(‘Value not found in Table’)
else:
st.write(“Please make a selection”)
If what you wanted was a match for the last 2 letters, then that can be fixed with a drop down or just change “contains” to “match” like the example below: