Installs into .claude/skills of the current project.
Are you the author of Test Assertion Patterns By Data Type?
Add the live security badge to your README. It updates with every re-scan.
[](https://www.skillsdirectory.com/skills/vamseeachanta-test-assertion-patterns-by-data-type)
---
name: xlsx-to-python-test-assertion-patterns-by-data-type
description: 'Sub-skill of xlsx-to-python: Test Assertion Patterns by Data Type (+1).'
version: 1.0.0
category: data
type: reference
scripts_exempt: true
---
# 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 |
