Great Deal! Get Instant $25 FREE in Account on First Order + 10% Cashback on Every Order Order Now

For this scenario, you are going to pretend that you have an IT system that spits out data like the file below: customer_export.txt(attached) Your job is to take this data and: Re-format into a JSON...

1 answer below »

For this scenario, you are going to pretend that you have an IT system that spits out data like the file below:
customer_export.txt(attached)

Your job is to take this data and:

  • Re-format into a JSON file (called customers.json) so it can be imported into another IT system
  • Re-format it into CSV format (called customers.csv)so it can be imported into yet another IT system
  • Add it to two other databases tables that power other applications (attached)

The data file you get doesn't always have "clean" data coming out of it, so you will have to work out how to deal with that problem (you may not manually edit the original file, however!). It also must make an attempt to remove duplicate information. Fields between the two database tables and the original file are not the same, so you will have to figure out how to get your data set to load into each database properly.

When your program loads, you must provide the user with the following options:

  1. Import a new data file
  2. Show data currently in a database

When a user imports data from a file, all data currently in the databases is removed before importing. Files on the file system must be backed up before being overwritten.

When a user chooses to show data currently in a database, allow them to choose which database they'd like to show data for. You must print out each individual row of data using a loop, not by printing out the variable containing all of your data.

Please note, however, that youmustorganize any classes/functions into modules and produce documentation (using Pydoc) for your work using the principles discussed in your program of study. You must also include exception handling in your code according to the principles previously discussed.


Answered 1 days AfterMar 09, 2022

Solution

Sandeep Kumar answered on Mar 10 2022
29 Votes
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here