Agent skill
xlsx-to-python-test-assertion-patterns-by-data-type
Sub-skill of xlsx-to-python: Test Assertion Patterns by Data Type (+1).
Install this agent skill to your Project
npx add-skill https://github.com/vamseeachanta/workspace-hub/tree/main/.claude/skills/_archive/data/office/xlsx-to-python/test-assertion-patterns-by-data-type
SKILL.md
Test Assertion Patterns by Data Type (+1)
Test Assertion Patterns by Data Type
| Excel Cell Type | Python Test Pattern |
|---|---|
| Number (float) | assert result == pytest.approx(expected, rel=1e-6) |
| Integer | assert result == expected |
| Boolean | assert result is True/False |
| String | assert result == "expected_string" |
| Date | assert result == datetime(YYYY, M, D) |
| Error (#REF!, #N/A) | Skip — log as extraction gap |
Tolerance Selection
| Domain | Typical Tolerance | Rationale |
|---|---|---|
| Structural (stress, force) | rel=1e-4 |
4 sig figs standard in engineering |
| Geotechnical (soil params) | rel=1e-3 |
Higher uncertainty in soil data |
| Financial (currency) | abs=0.01 |
Cent-level precision |
| General engineering | rel=1e-6 |
Default — tighten if needed |
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
vamseeachanta/workspace-hub
gsd-complete-milestone
Archive completed milestone and prepare for next version
vamseeachanta/workspace-hub
gsd-reapply-patches
Reapply local modifications after a GSD update
vamseeachanta/workspace-hub
gsd-verify-work
Validate built features through conversational UAT
vamseeachanta/workspace-hub
gsd-thread
Manage persistent context threads for cross-session work
vamseeachanta/workspace-hub
clinical-trial-protocol
Generate clinical trial protocols for medical devices or drugs through a modular, waypoint-based architecture with research-only and full protocol modes.
vamseeachanta/workspace-hub
single-cell-rna-qc
Performs quality control on single-cell RNA-seq data (.h5ad or .h5 files) using scverse best practices with MAD-based filtering and comprehensive visualizations.
Didn't find tool you were looking for?