Plan the Transformation Before Coding

Unit ID: M10-U02 Estimated active time: 25-35 minutes

Write ordered steps in ordinary language:

1. load raw text fields;
2. verify source columns;
3. copy to working data;
4. clean identifiers and categories;
5. parse numeric fields;
6. collect every rejection reason;
7. create clean and rejected tables;
8. derive only documented fields;
9. calculate bounded summaries;
10. export and reload outputs; and
11. restart and run all.

For each step, name its input and output. If a step mixes validation, transformation, display, and file writing, divide it.

The plan is assessment evidence because it lets a reviewer compare intended rules with actual code.