Question: I want to solve a python 3 program in version 3 . 1 1 Question: Document Merge Programming challenge description: Write a program that will
I want to solve a python program in version
Question: Document Merge
Programming challenge description:
Write a program that will parse, combine, and output CSV documents. This will require you to work through the data and merge the data sets appropriately based on a unique ID identifier for each row.
For example:
IDName,Start,End
Abraham Lincoln,
Merged with:
IDName,Start,End
James Buchanan,
Would result in:
IDName,Start,End
James Buchanan,
Abraham Lincoln,
Input:
Two CSVlike documents split by an empty line. The first line of each "document" will be the header, with data following afterwards. Each value should always be treated as a string and will be separated by a comma as a control character. Each individual document should only contain unique IDs. The ID value should always be a string with a valid numeric value. The headers of both documents will be consistent. Each document will have at least one row in addition to the header. For example:
IDName,Start,End
Abraham Lincoln,
IDName,Start,End
James Buchanan,
Output:
A single CSVlike document as a result of the provided original documents. The first line should be the header with merged data on subsequent rows, sorted by the ID column. The output should only present one row per unique ID value. If a duplicate ID is provided, use the value in the second document in the results. For example:
IDName,Start,End
James Buchanan,
Abraham Lincoln,
Test
Test Input
Download Test Input
IDName,Start,End
Abraham Lincoln,
IDName,Start,End
James Buchanan,
Expected Output
Download Test Output
IDName,Start,End
James Buchanan,
Abraham Lincoln,
Test
Test Input
Download Test Input
IDFirst,Status,Title
Tim,Part Time,Accountant
Allison,Full Time,Information Security
IDFirst,Status,Title
Tim,Full Time,Senior Accountant
Sally,Full Time,Line Manager
Expected Output
Download Test Output
IDFirst,Status,Title
Sally,Full Time,Line Manager
Allison,Full Time,Information Security
Tim,Full Time,Senior Accountant
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
