Question: how to export mysql data to excel using python?
Answer: Import all the modules (pymysql, xlwt, pandas. ... 
connect() method of pymysql will connect the mysql with the python. ... 
read_sql() method of pandas. ... 
Print the data frame.
to_excel() method of xlwt module will save the data in the excel sheet where ds.