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:
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).
12 freelancers are bidding on average $31 for this job
Hi. I have done many jobs with CSV -> Mysql using PYTHON. I have read your job carefully, so I am sure I will do it perfectly. Please ping me to discuss. Regards.
Hello,I have read yr job carefully. I am talented in Python&Excell. If u r excell is large,I need some data for test. If u hire me,I will do my best and u will receive great resutls. Thanks 4 reading.
Hi~ I have read your description carefully and checked your all rquirements fully like following: [login to view URL] sp_url column from the CSV should not be imported. [login to view URL] other columns from the CSV need to be imported. [login to view URL] da More
Hi, I have a good typing speed and can perform your task with ease. I have gone through your details already and can perform your task on priority basis. please share details once.
Hi, I already made it. Do you need any kind of validation in the CSV fields? My other question is if you will send the CSV and do you expect just the script or the database to be imported? Let me know.