LangChain Pandas DataFrame Agent for Data Analysis

Today, I'll show you how to use pandas dataframe agent for data analysis and monitor an LLM app in LangSmith.
00:01 Introduction
00:54 Setup
01:23 Install libraries
02:52 Set environment variables
04:24 Load the dataframe
05:11 Create an agent
07:13 Monitor the app
LangChain Tutorials ➡️ bit.ly/langcha...
Generative AI for DS ➡️ bit.ly/genai-f...
HuggingFace Tutorials ➡️ bit.ly/hugging...
Generative AI Tutorials ➡️ bit.ly/generat...
LLMs Tutorials ➡️ bit.ly/llm-tut...
Subscribe ➡️ bit.ly/subscri...
Project files: github.com/Tir...
Medium ➡️ / tirendazacademy
X ➡️ / tirendazacademy
LinkedIn ➡️ / tirendaz-academy
Hi, I am Tirendaz, PhD. I create content on generative AI & data science. My goal is to make the latest technologies understandable for everyone. Don't forget to subscribe and turn on notifications so you don't miss the latest videos.
#ai #generativeai #datascience

[@luanorionbarauna8555]

Very interesting. Now how can I pass rules to the agent such as "information to be returned" or "perform a specific date cut" and even "ALWAYS return a numeric value"?

[@TirendazAI]

You can set your prompt with rules to pass it to the agent. Garbage in, garbage out.

[@luanorionbarauna8555]

@@TirendazAI but who? I want to show some exemples of code for some questions. Is the possible for this agent?

[@infinityseekers]

hey there, Openai taking charges now insted of giving free credits on new accounts, what can i do here

[@TirendazAI]

You can use free credits given by the Anthropic or Groq API.

[@charlesoni2787]

I don’t actually like the ideal of using openai. It’s there anyway to use open source libraries instead of openai ?

[@TirendazAI]

You can use Ollama as an alternative to OpenAI. Ollama includes open source models such as Llama2 and Mistral.

[@drslax2662]

​@@TirendazAI can you do a video using only opensource 🙏🙏

[@atulkishore9159]

Yes please because openAI api is not free.
Make a video on how one can build a custom chatbot for their website. Using the knowledge base stuff

[@atulkishore9159]

​@@TirendazAIplease 😭😭

[@user-wr4yl7tx3w]

does it only work with OpenAI api currently?

[@TirendazAI]

No, you can also use the Groq API or Anthropic API to create a pandas dataframe agent.