pandas_export_to_mysql.py

import pandas as pd
from sqlalchemy import *

engine = create_engine('mysql://username:pass@server_address', pool_recycle=60)
DF = pd.io.parsers.read_csv('csv/file/path.csv')
DF = DF.dropna()
DF.to_sql('table_name', con=engine, if_exists='replace', flavor='mysql') # replace truncates the existing table and creates a new one