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.
???? Code: https://github.com/hnawaz007/pythondataanalysis/tree/main/MySQL%20to%20Excel
Link to docker MySQL image: https://hub.docker.com/_/mysql
Link to MySQL sample database: https://www.mysqltutorial.org/mysql-sample-database.aspx
Link to Pandas tips and tricks video:
https://www.youtube.com/watch?v=-jerzfh2bS0&t
Subscribe to our other channel:
https://www.youtube.com/c/HaqNawaz
---------------------------------------------
Follow me on social media!
Github: https://github.com/hnawaz007
Instagram: https://www.instagram.com/bi_insights_inc
LinkedIn: https://www.linkedin.com/in/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