Скачать или смотреть How to connect to MySQL and export data from MySQL to excel | Python | Pandas | Export dataframe

Python Export data from MySQL to Excel.
In this tutorial we will create a MySQL database in a docker container. We we connect and read data from this database using pandas library. Finally, we will output this data to excel.

Python MySQL library: pip install mysql-connector-python

💻 Code: https://github.com/hnawaz007/pythonda...

Link to docker MySQL image: https://hub.docker.com/_/mysql
Link to MySQL sample database: https://www.mysqltutorial.org/mysql-s...

Link to Pandas tips and tricks video:
   • Python Pandas Data Science Tutorial (Read ...  

Subscribe to our other channel:
   / haqnawaz  

---------------------------------------------
Follow me on social media!

Github: https://github.com/hnawaz007
Instagram:   / bi_insights_inc  
LinkedIn:   / haq-nawaz  

---------------------------------------------

Link to docker MySQL image: https://hub.docker.com/_/mysql

#MySQL #Pandas #Excel

Topics covered in this video:
0:00 - Introduction
0:29 - docker hub & mysql image
1:04 - docker command to create an image
1:50 - docker create mysql database
2:54 - connect to docker image from host
4:13 - download & create sample database
5:42 - import libraries & sql statement
6:26 - create connection to mysql database
7:33 - query database & save to dataframe
8:06 - export to Excel