LangChain, Pandas Dataframe Agent & OpenAI LLMs : Query Pandas DataFrame Using Natural Language

Make natural language queries to a Pandas DataFrame using LangChain & LLM's. In this video, you will discover how you can harness the power of LangChain, Pandas Dataframe Agent, and OpenAI LLMs to query pandas dataframe using natural language. This step-by-step tutorial will guide you through setting up a powerful, intuitive, and user-friendly dataframe querying system.

*I use affiliate links on the products that I recommend. These give me a small portion of the sales price at no cost to you. I appreciate the proceeds and they help me to improve my channel!

Equipments I use for recording the videos:

If you do have any questions with what we covered in this video then feel free to ask in the comment section below & I'll do my best to answer those.

If you enjoy these tutorials & would like to support them then the easiest way is to simply like the video & give it a thumbs up & also it's a huge help to share these videos with anyone who you think would find them useful.

Please consider clicking the SUBSCRIBE button to be notified for future videos & thank you all for watching.

You can find me on:

#langchain #pandas #python

[joseluisbeltramone]

Tremendous video!! Thank you very much for your willingness to share your knowledge with all of us!

[mahenderp]

Good example,
i tried a similar example, but the challenge is integrating above code with millions of data from Mongodb or sql server. another one is, as we are using OpenAI key, based on the number of requests the credits will be deducted from our openAi account.

[pinkfloyd]

can we do the same using any hugging face model with hugging face API? OpenAi is paid so I am looking for free option to achieve this.

[AliAlias]

Thanks very nice 🌹,
How to use open source LLM from hugging face locally using llama.cpp or ctransformer library without internet connection offline mode? for example codellama or pandalytic gguf type

[KP-mkwx]

df = pd.read_csv("data.csv") : missing file, from langchain.llms import OpenAI gives error :(

[REBEL_PRAJAPATI]

Really Mesmerizing and Great Content 👍👍

[jamesmcgonigle]

Hi! Great video - However, I am having a problem with the model's maximum context length - did you come across this too? Also, can this be used with Llama 2?

[michelemetta]

Where can I dowload the dataset that you use in the video?

[morancium]

Thanks you so much it was great
I was also using pandasAI

[manabchetia]

Great video. Can you please make it work with Llama 2 instead of open ai?

[joseluisbeltramone]

Thanks again for the excellent video. While doing analytics on a very wide dataframe (almost 2500 columns) I came across the model’s tokens limit. Is there any way to overcome it?

[Knight-Walker]

What if we have a huge data? I saw your video on Google's TAPAS but for some reason it's not working. I'm working on data which have entries in millions 😬

[yyjqnsx]

getting error: TypeError: issubclass() arg 1 must be a class
when trying to import OpenAI from langchain.llms

[ranmohamed]

Can we use this agent with other LLMs, specifically Vicuna 13B?

[rajatkumarsinha]

Hi Bhavesh,

Can you guide how to create a create a agent for Dolly 2.0?

[REBEL_PRAJAPATI]

Really Mesmerizing and Great Content 👍👍