Write Python script to import 1.8M rows of CSV data

I have the following table in a MySQL 2nd Gen 5.7 InnoDB : CREATE TABLE [login to view URL] ( id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(256) DEFAULT NULL, source VARCHAR(64) DEFAULT NULL, price INT(11) NOT NULL, year INT(11) NOT NULL, make VARCHAR(64) NOT NULL DEFAULT '', model VARCHAR(64) NOT NULL DEFAULT '', mileage INT(11) NOT NULL, transmission VARCHAR(64) DEFAULT NULL, num_cylinders INT(11) DEFAULT NULL, drive_type VARCHAR(64) DEFAULT NULL, body_type VARCHAR(64) DEFAULT NULL, fuel_type VARCHAR(64) DEFAULT 'Other', title_type VARCHAR(64) DEFAULT NULL, vin VARCHAR(64) DEFAULT NULL, trim VARCHAR(64) DEFAULT NULL, color VARCHAR(128) DEFAULT NULL, location VARCHAR(256) DEFAULT NULL, source_id VARCHAR(24) DEFAULT '', url VARCHAR(512) DEFAULT '', date_listed DATETIME DEFAULT NULL, date_found DATETIME DEFAULT NULL, date_updated DATETIME DEFAULT NULL, num_doors INT(11) DEFAULT NULL, date_analyzed DATETIME DEFAULT NULL, seller_type VARCHAR(15) DEFAULT NULL, details LONGTEXT DEFAULT NULL, PRIMARY KEY (id) ) I have a CSV file of 1.8 million rows that I need to have inserted into this database. I need a Python script to do this for me. The CSV has the following columns: name, year, make, model, trim, mileage, price, transmission, num_cylinders, drive_type, fuel_type, body_type, color, location, url, sp_url, date_posted, date_found, vin, title_type, source The sp_url column from the CSV should not be imported. All other columns from the CSV need to be imported. The database columns num_doors, date_analyzed, seller_type, details, and source_id should all import NULL. Some of the fields have double quotes " in them. These need to be removed. Some of the fields are empty / blank. These need to be imported as NULL. I could not attach the CSV file here because it is too large (700 MB).