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:
- Import a new data file
- 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.