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

Link to Pandas tips and tricks video:

Subscribe to our other channel:

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

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

#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

[BiInsightsInc]

Related Videos on this topic covering Excel reporting:

[nicolassangregorio]

excelent explain, thanks ! work's great

[martincho]

thanks you, but I have a warning message on my app about version in pandas, and recommended using sqlalchemy. Do you know about that ?

[meshwar]

We need to change the file name everytime if we run again and again

[meshwar]

If we run second time or multiple times it will showing error
The same file not updating data from sql

[stayhumble]

Code doesn’t work now
Throws dozens of tracbacks