Public knowledge pathNotebookpublishededitorial seed
Return to starting points
CPT data cleaning workflow
A reproducible starter path for importing, checking, and plotting cone penetration test data.
- Author
- Stratum Commons EditorVerified
- Visibility
- public
- Published
- May 16, 2026
- Revision
- Revision 1
Post content
Why it matters
Cone penetration test data often arrives with inconsistent headers, unit drift, and depth gaps that make early interpretation harder than it should be.
Workflow
- Import the raw CPT export without altering column names.
- Validate units, depth ordering, and null runs before plotting.
- Record assumptions beside the cleaned dataset so downstream readers can reproduce the choices.
Output expectations
- A cleaned tabular dataset with preserved provenance.
- A first-pass qc plot for tip resistance, sleeve friction, and pore pressure.
- Notes that explain where automated cleaning stopped and engineering judgement began.
Limitations
This seeded notebook is a starter read path, not a substitute for project-specific review, calibration, or site interpretation.