Skip to content

sxaxmz/PandasGPTAgent

Repository files navigation

PandasGPTAgent

Chat with your data utilizing powerful AI capabilities (OpenAI & LangChain).

PandasGPTAgent Demo

This tool utilizies powerful GPT model along with utilization of LangChain Agent to create a friendly UI to improve the experience and facilitate the usage of GPT models over various data files such as CSV, XLSX, or XLS.

This tool is the first UI prototype created for any Pandas Agent available for public to demonstrate the capabilities of what can be implemented. The focus here is on defining and extracting data from PandasGPT Agent to be integrated or embedded into existing systems.

Demonstration from here.

Abilities:

  • Query your data in plain language.
  • Facilitates and performs many Data Analysis related tasks.
  • Create plots/graphs/charts.
  • Accepts multiple files.
  • Conversations are stored including (Question, Steps to Produce, and Answer)

Conversation History Handle multiple files Visualize data through various plots Inspect Model's Steps To Answer
Conversation History Upload Multiple Files Plot Charts Read Steps to Produce Answer

Requirements:

You can use the demonstration without any installation by placing your Open AI Key in the sidebar API field (Ref: app.py).

Open AI Key Placement

  def setOpenAIKey(key):
     os.environ['OPENAI_API_KEY'] = key
  • Installation of the following libraries (requirements.txt):

    streamlit==1.22.0
    streamlit-chat==0.0.2.2
    openai==0.27.6
    streamlit-image-select==0.6.0
    langchain==0.0.181
    

Access Previous Conversations:

When accessing the convo_history.json file, the conversations shall be stored in the following format:

    "DATE_TIME_STAMP": [
            {
                "Question": "",
                "Answer": "",
                "Steps": ""
            }
        ]

All generated Charts/Graphs/Plots are stored in the project base directory (Agent Working Directory).

Usage:

When using or modifying this tool do always give appropriate credit.


References:

About

Chat with your data utilizing powerful AI capabilities (OpenAI & LangChain)

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages