Data Frame question in selectbox

Using Streamlit
1

Hi All,

Working on a project here: https://desolate-ocean-14363.herokuapp.com/

I’m trying to python my way through as an easy button, but here’s the situation.
Restaurant names are selected, and the name is used to do a df.loc[‘name’] and pull up the stats for the restaurant. The problem is some restaurants show up more than once in a NYC borough, like “Sweet Chick”, and this will cause an error as pandas can’t pick just one. So I created an index for the data frame, and I want pandas to select the entry by index, but in the selectbox, to keep the user experience friendly, I want to retain the name.

Here’s what my dataframe looks like:

Screen Shot 2020-02-10 at 1.40.58 PM
Screen Shot 2020-02-10 at 1.40.58 PM1458×1264 92.1 KB

I was curious if you can think of a way to python around this, or are aware of any additional parameters to st.selectbox that i might not be aware of that will accept the name, as well as the index location.
Currently, I have it set up to populate the selectbox with a list of the restaurant names, and also as an experiment, to just use the restaurant name as index to populate the select box.
Github is here: https://github.com/hamiltonchangcodes/yelp_report_cards/tree/master/frontend

Thanks in advance!!

  • Hamilton
1 Like
2

yes, this can be done using format_funct and lambda functions. Have a look at
@Jonathan_Rhone s answer to my similar question: Label and values in in selectbox.

3

Thanks for the reply godot63! This is actually very cool to know, but I don’t want to actually display the number…

I want to store it for an df.iloc so i don’t have to manually rename the duplicates, just do an index based access. Code below for what I intend.

Screen Shot 2020-02-12 at 9.11.24 AM
Screen Shot 2020-02-12 at 9.11.24 AM1738×616 49.3 KB

I’m thinking about how i might be able to make this work, it could work with some wrangling maybe? Either that or maybe i’m just not comprehending the full utility of format_func

4

I tried to make an example that comes closer to what you are describing, just run the following code:

import streamlit as st
import pandas as pd

# initialize list of lists
data = [['Le goumet', 10], ['The Alcove', 15], ['Mojo Restaurant', 14], ['Mojo Restaurant', 1]]

# Create the pandas DataFrame
df = pd.DataFrame(data, columns=['Name', 'ID'])

values = df['Name'].tolist()
options = df['ID'].tolist()
dic = dict(zip(options, values))

a = st.sidebar.selectbox('Choose a restaurant', options, format_func=lambda x: dic[x])

st.write(a)

The select box shows names, but when selecting an item, a number is returned. The trick is not create a dictionary with names and respective ids. it also works if 2 names are identical. I hope this is what you were looking for.

3 Likes
5

godot63. I see now what you mean. You’re a wizard thank you so much!!!

1 Like
6

You are welcome. Wizard apprentice I would rather say, the wizard was @Jonathan_Rhone who answered my very similar question originally :grinning:

2 Likes
7

What I was looking for. Precisely! Thank you! :slight_smile:

1 Like
8

@ [godot63

Thank you for the useful sharing codes. I’m new to using streamlit, but it helps a lot.

9

Hello guys,

I’m trying to put the value into the field which is the same as the value of the previous field on the form, could you please help?
I have tried this but not working. Thank you.

mean_temperature = st.number_input(“Mean radiant temperature(Tmr (0C))”, user_input.range(‘C8’).value, key=‘mean_temperature1’)

10

for some reasons dic is not accessible in lambda in python 3.11 is this any problem?

11

It is for me. You must be doing something different.

12

yep, thanks

13

Hi @Bebe

Can you try deleting this and see if this works?

In essence, the following should allow you to accept numbers as input:

mean_temperature = st.number_input(“Mean radiant temperature(Tmr (0C))”)

Hope this helps!