/
streamlit_app.py
77 lines (61 loc) · 2.77 KB
/
streamlit_app.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
import pandas
import requests
import streamlit
import snowflake.connector
from urllib.error import URLError
streamlit.title("Tutorial Healthy Dinner App")
streamlit.header("Breakfast Favorites")
streamlit.text("🥣 Omage 3 & Blueberry Oatmeal")
streamlit.text("🥗 Kale, Spinach & Rocket Smoothie")
streamlit.text("🐔 Hard-Boiled Free-Range Egg")
streamlit.text("🥑🍞 Avocado toast")
streamlit.header('🍌🥭 Build Your Own Fruit Smoothie 🥝🍇')
my_fruit_list = pandas.read_csv("https://uni-lab-files.s3.us-west-2.amazonaws.com/dabw/fruit_macros.txt")
my_fruit_list = my_fruit_list.set_index("Fruit")
# Let's put a pick list here so they can pick the fruit they want to include
fruits_selected = streamlit.multiselect("Pick some fruits:", list(my_fruit_list.index),["Avocado","Strawberries"])
fruits_to_show = my_fruit_list.loc[fruits_selected]
# Display the table on the page.
streamlit.dataframe(fruits_to_show)
def get_fruityvice_data(this_fruit_choice):
fruityvice_response = requests.get("https://fruityvice.com/api/fruit/" + fruit_choice)
# normalize json to panda dataframe
fruityvice_normalized = pandas.json_normalize(fruityvice_response.json())
return fruityvice_normalized
#NewSection to display fruitvice api response
streamlit.header("Fruityvice Fruit Advice")
try:
fruit_choice = streamlit.text_input('What fruit would you like information about?')
if not fruit_choice:
streamlit.error("Please select a fruit to get info")
else:
streamlit.write('The user entered ', fruit_choice)
# print the panda dataframe
back_from_function = get_fruityvice_data(fruit_choice)
streamlit.dataframe(back_from_function)
except URLError as e:
streamlit.error()
#streamlit.stop()
def get_fruit_load_list():
with my_cnx.cursor() as my_cur:
my_cur.execute("select * from fruit_load_list")
my_data_rows = my_cur.fetchall()
return my_data_rows
if streamlit.button('Get Fruit List'):
my_cnx = snowflake.connector.connect(**streamlit.secrets["snowflake"])
#my_cur.execute("SELECT CURRENT_USER(), CURRENT_ACCOUNT(), CURRENT_REGION()")
#streamlit.text("Hello from Snowflake:")
streamlit.header("The fruit load list contains:")
my_data_rows = get_fruit_load_list()
my_cnx.close()
streamlit.dataframe(my_data_rows)
def insert_row_snowflake(new_fruit):
with my_cnx.cursor() as my_cur:
my_cur.execute("insert into fruit_load_list values ('" + new_fruit + "')")
return "Thanks for adding " + new_fruit
add_fruit = streamlit.text_input('What fruit would you like to add?')
if streamlit.button('Add a Fruit to the list'):
my_cnx = snowflake.connector.connect(**streamlit.secrets["snowflake"])
back_from_function = insert_row_snowflake(add_fruit)
streamlit.text(back_from_function)
#tofix