sql, python, mysql, code
Budget: $15 – $25 USD
The objective is to be able to create a database, create a table within that database , and load data from a given csv file into that table. This all to be done using SQL in python using mysql connector.
nj_teachers_salaries_cls.csv
eem to load the data into the table, I am not sure why. It's maybe because of the datatypes I defined or maybe something with "optionally enclosed" statement but I'm not really sure.
Please see attached, I am including the following:
the instructions document
python code file
screen shot of the error I get
the csv file from which data need to be imported into table created (google drive link)
Let me know if you have any questions, or issues, etc.
nj_teachers_salaries_cls.csv
eem to load the data into the table, I am not sure why. It's maybe because of the datatypes I defined or maybe something with "optionally enclosed" statement but I'm not really sure.
Please see attached, I am including the following:
the instructions document
python code file
screen shot of the error I get
the csv file from which data need to be imported into table created (google drive link)
Let me know if you have any questions, or issues, etc.