Chat with a CSV file using Functions as Tools, Gemini 2.0 Flash, Sqlite3 & Streamlit frontend!

In this video, I show how to talk to your tabular data in a CSV file using natural language. Get both text response to your query and a chart that helps visualize the answer!!
Basically, we take the user's question related to the CSV data and pass it to Gemini 2.0 along with couple of tools for the LLM to utilize to answer the question.
What's most important, from my experience building this, was that providing a schematic about your metadata including field description is critical. Plus, providing detailed systems prompt/message with plenty of examples goes a long way.

Here is a link to my Githup repo that has the code and everything that was showcased in the video: https://github.com/mktaop/talk_2_csv_...

#ai #google #sqlite #sqlquery #sql #howto #streamlit #visualizedata #googlegemini #webapp #generativeai #python #pythonprogramming