Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The csv file looks like this but much longer Write a python script called import_marta.py that reads in the given csv file and stores the

image text in transcribedThe csv file looks like this but much longer

image text in transcribed

Write a python script called import_marta.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 script. 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Hands-On Database

Authors: Steve Conger

2nd Edition

0133024415, 978-0133024418

More Books

Students also viewed these Databases questions

Question

Use 3 6 0 count convention. Find the yield on the bond.TARGET CORP

Answered: 1 week ago