Question: Consider the following CSV file 4 rows shown: quote|source|dob-dod|category There is no remedy but to love more.|Henry David Thoreau|1817-1862|romantic Work is the curse of the

Consider the following CSV file 4 rows shown:

quote|source|dob-dod|category

There is no remedy but to love more.|Henry David Thoreau|1817-1862|romantic

Work is the curse of the drinking classes.|Oscar Wilde|1854-1900|humourous

The paradise of the rich is made out of the hell of the poor.|Victor Hugo|1802-1885|political

Religion is what keeps the poor from murdering the rich.|Napoleon Bonaparte|1769-1821|political

a) Not using any external modules, write a PYTHON script to transform the above data to a valid XML structure using the header fields as element names. You should also generate a row-id as an attribute for each row in the file,

b) Only using the pymysql & csv modules, write a PYTHON script to create the three required tables and insert the CSV data above to a MySQL database.

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!

Read a csv ( Command - Separated Values ) file containing arithmetic expressions and their corresponding answers, generate questions and answer them, calculate and report the correct rate. Based on...

C + + CODE.Read a csv ( Command - Separated Values ) file containing arithmetic expressions and their corresponding answers, generate questions and answer them, calculate and report the correct rate....

Construct a single round of a game tournament in which different 2-player board games are played on different tables.Using C# User Requirements The user is holding a game tournament in which...

So, working on code and files I've been helped with and I'm struggling to figure out where I should be using System.out.printf( %.1f ); or such in order for the results to be printed out with only...

This question is super easy. All the sub-questions which I attached below are part of the same question. Please try it CSV Switch Backplate Keyboard KeysPressed RD NBP 1 28.15 EC NBP 1 35.14 FAF NBP...

Switch Backplate Keyboard KeysPressed RD NBP 1 21.56 EC NBP 1 28.7 FAF NBP 11 29.59 LMS NBP 1 23.44 RD PBP 1 21.82 EC PBP 1 28.45 FAF PBP 1 29.01 LMS PBP 1 21.2 RD ABP 1 28.53 EC ABP 1 33.03 FAF ABP...

Switch Backplate Keyboard KeysPressed RD NBP 1 21.27 EC NBP 1 23.61 FAF NBP 1 24.04 LMS NBP 1 21.18 RD PBP 1 23.98 EC PBP 1 22.88 FAF PBP 1 22.37 LMS PBP 1 22.76 RD ABP 1 33.46 EC ABP 1 31.32 FAF ABP...

A keyboard manufacturer is assessing the durability of keyboard designs for it's new line of gaming keyboards, the RGB Proking Deluxe (Over 16 trillion colours and 32 different lighting effects!)....

For this assignment, you are to write a program to multiply two sparse matrices. You will implement a data structure that facilitates efficient processing of sparse matrices so that your program will...

Write a program that reads a comma-separated file (CSV) with integer values. Your program will take the file name as the input. If the file does not exist, then the program must print. Error: input...

A rectangular playground is to be fenced off and divided into two parts by a fence parallel to one side of the playground. 720 feet of fencing is used. Find the dimensions of the playground that will...

Refer to the data on female wolves in Exercise 11.20. (a) Obtain the least squares fit of body length to the predictor body weight. (b) Calculate the residual sum of squares. (c) Estimate o2. (d)...

A past service pension adiustment ( PSPA ) can only occur under a: deferred profit sharing plan. defined - contribution pension plan. unregistered pension plan. defined - benefit pension plan.

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

It contained the correct shower gels, but not the correct body lotions. Instead of Jasmine and Ocean Mist, you received Country Rose and Citrus Breeze. File an e-mail claim with Soft n Glow, your...

You work for a company that owns several office buildings in your town. Your employers have decided to change all locks in their buildings from key to card access. Notify the tenants of each building...

For the past six years, Jet Printing has had a display at the regional business expo. Because booth spaces are assigned on a first-come, first-served basis, you always reserve your space and send...