💬 OpenAI Chat with Excel CSV using LangChain

ooking for a more intuitive way to manage your data? Look no further than LangChain and OpenAI! With our advanced language model, you can now chat with CSV and Excel like a pro, streamlining your data management process and boosting your productivity. Whether you're a business owner, a data analyst, or simply someone who wants to take their data skills to the next level, our revolutionary platform has you covered.

❤️ If you want to support the channel ❤️
Support here:

[Ryan-yjsd]

please make one on chatting with SQL database

[kumargaurav]

Maybe we can use prompt _template & agent module of Langchain to make it more robust at giving answers.

[Manali_]

It shows error during create an index using the loaded documents step, it asks to mention embeddings in first line

[anushv.]

Any having idea how to answer questions with multiple sheets instead of answering from 1 sheet?

[xevenau]

do you have one that uses llama3 for chatting to avoid cost?

[AkaThePistachio]

Hey for some reason when trying to create the vector store i get a conflict issue with pydantic saying "`BaseSettings` has been moved to the `pydantic-settings`" How can i fix this?

[bourbe]

Hello, I am wonderng About something, when WE se a csv agent, WE don't need to use embeding, Vector data base or a memory ? I am currenly confuse

[zpxbkfr]

First it worked fine but then when I increased the size of the file it became useless, avoid the question. Once I returned to the original file it remained useless. It seems that some limitations activated and made the code wrong.

[hariram-pzuz]

when i implement this using azure openai it throwing me too many input error. How to resolve this?

[chetan]

But can we somehow control the no of tokens being used ? I have csv files in GBs

[smart-sgcs]

dear little coder
if we want to set a system like this and want to use SQL data base instead of a vector DB .which one will have better and more accurate results .also do we necessarily use vector DB in case we want to use LLM like open ai

[nishkarve]

Why do I run into ChromaDB authentication errors? Is there some setup outside this notebook for ChromaDB?

[beinginlife]

I have 1 lakh rows, and giving limited token error …

[matthewpan]

thank you for your helpful video, i am a new learner in ai, i gotta a question:what is the difference between gpt-index and gpt-embedding? i am a little confused...

[thekaizer]

hey can you run a tutorial on how to code your own personal chatGPT text-davinci-003 + text-ada-002 embeddings, and integrate with a vector-database such as Chroma, Pinecone, or Milvus? plus, that its able to do live web-searches and scrape webs for information it doesnt currently have? "David Shapiro ~ AI" did a full tutorial on the very-basic level of it using Pinecone, but the bot is too basic and dull and doesnt really work that well. the video: "Chatbot with INFINITE MEMORY using OpenAI & Pinecone - GPT-3, Embeddings, ADA, Vector DB, Semantic"

[RetropunkAI]

Which OpenAI model does it use? I may have missed it.

[VK-zgbw]

This code will not provide proper results, it will only give 4 results (rows) in total, and i can not do much like total count, difference and so on,

And for the 4 rows, the similarity search in vectorstore gets only 4 rows in total, it's the default k value.

And if not wrong, little coder also know this, that's why he matched his results like I know only Pikachu so I will ask question with it in this video😅 and there is no proper response in any of the questions below.

[rheapoddar]

I am getting a rateLimit error, do you know what we can do about that?

[judickaelsam]

Hi everyone, I get this error "RateLimitError: You exceeded your current quota, please check your plan and billing details." when executing the same code. I just want to do the same tests. Why would my quota be exceeded even if it's the first time I use an open ai key? Anyone having the same issue? Do I really need to upgrade as I just want to do exactly the same tests? Please help

[feizaltoefy]

How would one interact with more than 1 csv file with different field names