Question: USE python write two functions 1. to_table: This function takes a csv filename, an SQLite filename, and a table name with default valuenew1. It adds

USE python write two functions

1. to_table: This function takes a csv filename, an SQLite filename, and a table name with default value"new1". It adds a new table with the specified name to the db that has the information from the csv file in it. The first row of the csv file contains the column names. All columns are TEXT type. The first column is the primary key. I recommend using Python's csv module so you don't have to parse the rows of the csv file yourself. HINT: look into using qmark notation with the sqlite3 .execute() method, ex:

c.exectue(INSERT INTO

VALUES (?, ?), (var1, var2))

2. to_csv: This function takes an SQLite filename, a table name, and a csv filename with default value"data.csv". It takes the data from the table and writes the information in it to the csv file. You can and should look at the Python documentation for the sqlite3 module, but here is some code for you to enter that shows briefly how you can get the column names for the first row of the csv file:

>>> import sqlite3 >>> conn = sqlite3.connect('classes_redacted.db') >>> sqlite3.row_factory = sqlite3.Row >>> c = conn.cursor() >>> c.execute('SELECT * FROM ista_350_s18;') >>> c.description

This will get you the information you need in something called a tuple of tuples. You can deal with it like you would a list of lists you can traverse it with a for loop, index into it, etc. Or you could get all of the table schema information as demonstrated here and work with that.

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!

PYTHON 3 and SQLite 3, please help and explain. to table: This function takes a csv filename, an SQLite filename, and a table name with default value "new1". It adds a new table with the specified...

Stage 1 : Dataset Selection and Use - A suggested dataset is included on D 2 L . You may use the provided data or select data of your own choosing. - You must use at least three separate csv files...

PLEASE HELP C PROGRAM Problem Description : The company XYZ is looking for a system to keep track of each employees wages. Each employees name, salary and occupation must be stored in a database. The...

The company XYZ is looking for a system to keep track of each em- employee's wages. Each employees name, salary and occupation must be stored in a database. The system must also be able to generate a...

I have been asking for the solution of this c++ program for two weeks and no one is answering! Your task for this lab is to complete the implementation of a program that processes acsv file...

Assignment: Grade Processor Your task for this lab is to complete the implementation of a program that processes a .csv file containing raw grade data, and produces a report file as a .txt. Starter...

Your task for this lab is to complete the implementation of a program that processes a .csv file containing raw grade data, and produces a report file as a .txt. Starter Code The framework of the...

Problem 7: determine file type from a filename * * To identify the type of a file, the Operating System looks at the filename and * extension. The OS needs to know the file type to open it with the...

deducted if no header comments are included. Programming Problem In this exercise, you will write a program that loads information about dogs from a text file and displays the data to the user in a...

Hi, please help me with the following question and code it in C++. And please if you are not getting the question don't answer it because I already received 4 incorrect answers and this is 5th time...

What is the EPEAT tool? How is it used?

Refer to the temperature and precipitation data in Data Set 4 of Appendix B. Let the dependent variable be AVTEMP, and let the independent variables be those given in the exercise. (The data sets are...

You invest 5000 today for 10 years compounded semiannually at 5%. How much do you have then

Torstand Unadjusted to Balance Yor the Year fried December 31 Cash Dobit 40,000 12.000 560 200 17,700 Part zaru 9.160 115 DO Accounts receivel Supplies Vread croce Service pro Accumulated practat...

3. List and explain the characteristics of effective 360-degree feedback systems.

4. Mentor-protg matching is based on how the mentors skills can help meet the protgs needs.

9. The mentor program is evaluated. Interviews with mentors and protgs are used to obtain immediate feedback regarding specific areas of dissatisfaction. Surveys are used to gather more detailed...