MySQL database with PandasAI & Ollama & Streamlit

Today, we'll cover how to analyze data in a MySQL database with local Llama 3 using Pandas AI, Ollama and Streamlit for free. Happy learning.

00:01 Introduction
01:06 Setup
02:47 Create a new database
04:43 Load the model with Ollama
06:41 Initialize the model
08:29 Connect to the database
10:45 Build the app
12:41 Inference
13:31 Data visualization

RELATED VIDEOS:

FOLLOW ME:

Don't forget to subscribe and turn on notifications so you don't miss the latest videos.

Hi there, I'm a content creator on generative AI & data science, PhD. My goal is to make the latest technologies understandable for everyone.

#ai #generativeai #datascience

[Airsoftshowoffs]

Great video. Thank you for making this easy.

[jackgaleras]

12:26 Gracias mil, la animación es muy adecuada cuando se intenta estas cosas y se consiguen mil errores hasta que por fin se logra el objetivo ja

[nguyenngothuong]

Can you make a video tutorial on role configuration for Botchat?. For example, only respond in English, and focus on using SQL to query data and respond to

[zainmunir]

Hi. I love your videos. Is there anyway to do same with MongoDB or any NoSQL database?

[erdemkoraysanl]

Hello, I wrote the same code, it works, but it is very slow, for example, when I say bring the first 4 data, it responds in 2 minutes 3 minutes, but it is very very fast in you. It is very fast when chatting normally with llama3. It is very fast in my database, but when I write this code, it works very slowly.

[DarkNessShadow-]

Hi, awesome videos, can you make a video using agent pandasai with the explain and clarification questions features, i try to use it but doesn't work for me

[AbhinavKumar-txer]

Hi, I followed the same but I am getting error as
"Unfortunately, I was not able to answer your question, because of the following error: No code found in the response" .

[atharvaghale]

is there any solution to make the queries run faster? will gpu help?

[suffympm]

thanks for your video. from indonesia.. but why in my laptop result data is so long.. any idea ?. my spec is asus ryzen 7 gen 5

[HimanshuSaxenanovember]

Can we get data from multiple tables using prompts?

[TheBestgoku]

bro please tell me if pandasAI is free if, i host on my own server. why is PandasAI so expensive?

[ByteBop]

Is it possible to use agents without the pandasapi and use ollama?