Question: PLEASE help with python: I ALREADY HAVE THE FOLLOWING CODE for my database: NEED HELP FINISHING THIS SCRIPT: USING THIS CSV FILE: Part 2 Populate

PLEASE help with python:

PLEASE help with python: I ALREADY HAVE THE FOLLOWING CODE for my

I ALREADY HAVE THE FOLLOWING CODE for my database:

database: NEED HELP FINISHING THIS SCRIPT: USING THIS CSV FILE: Part 2

NEED HELP FINISHING THIS SCRIPT:

Populate the database Write a python script called import-mart a.py that reads

USING THIS CSV FILE:

in the given csv file and stores the information from the appropriate

Part 2 Populate the database Write a python script called import-mart a.py that reads in the given csv file and stores the information from the appropriate columns of the csv file into the appropriate table(s) of the database, which you can assume has already been created using your marta-schema.sql The name of the csv file and the database will be passed in as command line arguments to your program. Do not hard code the name of the csv file or the database. Your program must be able to read from the csv file whose name is given as the first command line argument and write to the database whose name is given in the second command line argument Your program will be run in the following manner: $python import marta.py passenger_data.csv marta localhost root Password for root@localhost: Importing data from passenger_data.csv into marta database on localhost... Done. Don't print the Done. line until the import is complete

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!