Build a chat application that interacts with CSV and Excel files using LanceDB’s hybrid search capabilities. LanceDB simplifies handling large datasets, making it efficient and scalable.
-
Hybrid Search: Combines Full-Text Search (FTS) and semantic search for accurate results.
-
Scalability: Efficiently handles large datasets with billions of rows.
-
Integration with Pandas: Passes search results to a pandas DataFrame agent for further processing.
-
Uses LangChain and OpenAI LLM .
Install dependencies:
pip install -U openai lancedb langchain-experimental langchain-openai langchain sentence-transformers
For a detailed tutorial, check out our blog post.
For a detailed, interactive walkthrough of this implementation, you can explore the Google Colab notebook provided below.
For a detailed explanation of agentic rag, check out blog link .