Carregar arquivo csv no MySQL

csv2db.py

import csv
import MySQLdb

mydb = MySQLdb.connect(
    host='',
    user='root',
    passwd='',
    db='')
cursor = mydb.cursor()

csv_data = csv.reader(
            file('file.csv'))
for index, row in enumerate(csv_data):
    if index != 0:
        cursor.execute("INSERT INTO example(Advertiser, Site, Banner," \
              "Date, Impressions, Clicks, Sessions, KPI)" \
              "VALUES(%s, %s, %s, %s, %s, %s, %s, %s)",
              row)
#close the connection to the database.
mydb.commit()
cursor.close()
print "Done"