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. ▶ Subscribe: https://bit.ly/subscribe-tirendazai ▶ Join my channel: https://bit.ly/join-tirendazai 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: ▶ PandasAI Tutorials: https://bit.ly/pandasai ▶ Ollama Tutorials: https://bit.ly/ollama-tutorials ▶ LangChain Tutorials: https://bit.ly/langchain-tutorials ▶ Generative AI for DS: https://bit.ly/genai-for-data-science ▶ HuggingFace Tutorials: https://bit.ly/hugging-face-tutorials FOLLOW ME: ▶ Medium: https://tirendazacademy.medium.com ▶ X: https://twitter.com/TirendazAcademy ▶ LinkedIn: https://www.linkedin.com/in/tirendaz-academy Don't forget to subscribe and turn on notifications so you don't miss the latest videos. ▶ Project files: https://github.com/TirendazAcademy/PandasAI-Tutorials ▶ MySQL Download: https://dev.mysql.com/downloads/ ▶ Dataset: https://www.kaggle.com/datasets/uom190346a/e-commerce-customer-behavior-dataset/data 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