MySQL connection in python

importcsvintomysql.py

import MySQLdb
import pandas as pd
from sqlalchemy import create_engine

# read the csv into pandas and then export to MySQL
template_lines = 1000
df = pd.read_csv(
    'example.csv', nrows=template_lines, low_memory=False)
# 2nd argument replaces where conditions is False
df = df.where(pd.notnull(df), None)
df.head()
# <user>:<password>@<host>[:<port>]/<dbname>
conn_str = "mysql+mysqldb://root:qwerty@127.0.0.1/testdb?charset=utf8&use_unicode=0"
engine = create_engine(conn_str)
conn = engine.connect()
df.to_sql("data", con=conn)
conn.close()