File size: 2,945 Bytes
56349b2 |
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 78 79 80 81 82 83 84 85 86 87 88 89 90 |
import os
import streamlit as st
from streamlit_chat import message
from pandasai import PandasAI
from constants import file_format, models
import matplotlib.pyplot as plt
@st.cache_data
def load_data(uploaded_file):
ext = os.path.splitext(uploaded_file.name)[1][1:].lower()
if ext in file_format:
return file_format[ext](uploaded_file)
def generate_response(question_input, dataframes, option, api_key):
llm = models[option](api_key)
pandas_ai = PandasAI(llm)
if len(dataframes) == 1:
return pandas_ai(dataframes[0], prompt = question_input, is_conversational_answer = True)
else:
return pandas_ai(dataframes, prompt = question_input, is_conversational_answer = True)
st.set_page_config(page_title="PandasAI Chat", page_icon=":panda_face:")
st.title("PandasAI Chat :panda_face:")
if "generated" not in st.session_state:
st.session_state["generated"] = []
if "past" not in st.session_state:
st.session_state["past"] = []
if "plots" not in st.session_state:
st.session_state["plots"] = []
left, right = st.columns([1, 2])
with left:
model_option = st.selectbox('Model', models.keys())
with right:
api_key = st.text_input('API Key', '', type = 'password')
if not api_key:
st.info(f"Please input API Token for {model_option}.")
question_input = None
uploaded_files = st.file_uploader("Upload a file", type=list(file_format.keys()), accept_multiple_files=True)
dataframes = []
if not uploaded_files:
st.info("Please upload your dataset(s) to begin asking questions!")
else:
for uploaded_file in uploaded_files:
dataframe = load_data(uploaded_file)
dataframes.append(dataframe)
with st.expander(uploaded_file.name):
st.write(dataframe.head())
question_input = st.text_input("Enter question")
st.markdown("---")
response = None
if question_input and uploaded_files and api_key:
with st.spinner("Generating..."):
try:
response = generate_response(question_input, dataframes, model_option, api_key)
except Exception as e:
st.error("An error occurred: either your API token is invalid \
or no code was found in the response generated.")
if len(plt.get_fignums()) > 0:
fig = plt.gcf()
st.session_state.plots.append(fig)
else:
st.session_state.plots.append("None")
if response:
st.session_state.past.append(question_input)
st.session_state.generated.append(response)
if "generated" in st.session_state and st.session_state['generated']:
for i in range(len(st.session_state['generated'])-1, -1, -1):
if st.session_state["plots"][i] != "None":
st.pyplot(st.session_state["plots"][i])
message(st.session_state["generated"][i], key=str(i))
message(st.session_state['past'][i], is_user=True, key=str(i) + '_user')
|