1. Missing values and duplicate records
List the missing quantity, exact duplicate and conflicting-key rows. Define a disposition for each. Predict the number of accepted and quarantined records before checking expected_results.json.Write your answer in learner_worksheet.txt and retain the evidence file. Attempt this before opening the solution.
Your method:
Your result and evidence:
Limitations:
Independent extension:


2. Inconsistent categories and safe corrections
Create the channel map and correction log for accepted records. Explain how ONLINE, surrounding spaces and P99 should be treated. Test a new channel value wholesale in a separate source copy.Write your answer in learner_worksheet.txt and retain the evidence file. Attempt this before opening the solution.
Your method:
Your result and evidence:
Limitations:
Independent extension:


3. Document corrections and reconcile the result
Prepare a short acceptance note containing the row equation, accepted value, key uniqueness, quarantined reasons and limitations. Alter one accepted quantity in a separate copy and explain what should change.Write your answer in learner_worksheet.txt and retain the evidence file. Attempt this before opening the solution.
Your method:
Your result and evidence:
Limitations:
Independent extension: