app.py

import streamlit as st

from langchain.agents import create_pandas_dataframe_agent
from langchain.chat_models import ChatOpenAI
from langchain.agents.agent_types import AgentType

import pandas as pd

form = st.sidebar.form(key='my_form')
user_api_key = form.text_input(
    label="#### Your OpenAI API key 👇",
    placeholder="Paste your openAI API key, sk-",
    type="password")
uploaded_file = form.file_uploader("Choose a file")
text_prompt = form.text_area('Text Prompt', value='Hello, how are you?')
submit_button = form.form_submit_button(label='Submit')
if submit_button :
    df = pd.read_csv(uploaded_file)

    st.title("OpenAI Chatbot 🤖"
             )
    st.subheader("This is a simple chatbot that uses OpenAI's GPT-3 model to generate responses to your text prompt. ")
    
    st.subheader("Your data:")
    st.write(df)
    
    #horizontal line
    st.markdown("""---""")

    st.subheader("AI generated response:")
    
    agent = create_pandas_dataframe_agent(
        ChatOpenAI(temperature=0, model="gpt-3.5-turbo-16k", openai_api_key=user_api_key),
        df,
        verbose=True,
        agent_type=AgentType.OPENAI_FUNCTIONS,
    )
    
    result = agent.run(text_prompt)
    st.write(result)