xlsx-to-python-test-assertion-patterns-by-data-type
Sub-skill of xlsx-to-python: Test Assertion Patterns by Data Type (+1).
Best use case
xlsx-to-python-test-assertion-patterns-by-data-type is best used when you need a repeatable AI agent workflow instead of a one-off prompt.
Sub-skill of xlsx-to-python: Test Assertion Patterns by Data Type (+1).
Teams using xlsx-to-python-test-assertion-patterns-by-data-type should expect a more consistent output, faster repeated execution, less prompt rewriting.
When to use this skill
- You want a reusable workflow that can be run more than once with consistent structure.
When not to use this skill
- You only need a quick one-off answer and do not need a reusable workflow.
- You cannot install or maintain the underlying files, dependencies, or repository context.
Installation
Claude Code / Cursor / Codex
Manual Installation
- Download SKILL.md from GitHub
- Place it in
.claude/skills/test-assertion-patterns-by-data-type/SKILL.mdinside your project - Restart your AI agent — it will auto-discover the skill
How xlsx-to-python-test-assertion-patterns-by-data-type Compares
| Feature / Agent | xlsx-to-python-test-assertion-patterns-by-data-type | Standard Approach |
|---|---|---|
| Platform Support | Not specified | Limited / Varies |
| Context Awareness | High | Baseline |
| Installation Complexity | Unknown | N/A |
Frequently Asked Questions
What does this skill do?
Sub-skill of xlsx-to-python: Test Assertion Patterns by Data Type (+1).
Where can I find the source code?
You can find the source code on GitHub using the link provided at the top of the page.
Related Guides
SKILL.md Source
# 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 |
Related Skills
test-oversized-skill
A test fixture skill that exceeds 200 lines with multiple H2/H3 sections for split testing.
data-validation-reporter
Generate interactive validation reports with quality scoring, missing data analysis, and type checking. Combines Pandas validation, Plotly visualization, and YAML configuration for comprehensive data quality reporting.
digitalmodel-worktree-test-execution-with-shared-venv
Run digitalmodel tests from isolated worktrees without uv editable-dependency failures by using the main repo's existing virtualenv and PYTHONPATH.
blender-worktree-test-hardening
Recover and harden digitalmodel Blender automation work in isolated worktrees when uv/editable dependency paths break and local machines lack a Blender executable.
worldenergydata-source-readiness
Route agents to the canonical worldenergydata source-readiness skill and summary script. Use when asked for worldenergydata data completeness, data locations, latest known data dates, scheduler freshness, source-readiness status, or acceptance-criteria inputs across the repo ecosystem.
sodir-data-extractor
Extract and process Norwegian Petroleum Directorate field and production data from SODIR
metocean-data-fetcher
Fetch real-time and historical metocean data from NDBC, CO-OPS, Open-Meteo, ERDDAP, and MET Norway. Use for buoy data retrieval, tidal observations, marine forecasts, and multi-source data fusion.
energy-data-visualizer
Interactive visualization for oil and gas production data analysis using Plotly dashboards
bsee-data-extractor
Extract and process BSEE (Bureau of Safety and Environmental Enforcement) data including production, WAR (Well Activity Reports), and APD (Application for Permit to Drill) data. Use for querying production data, well activities, drilling permits, completions, and workovers by API number, block, lease, or field with automatic data normalization and caching.
work-around-merge-conflicts-in-test-execution
Run tests when repo has unresolved merge conflicts in config files by bypassing broken configs and executing tests directly
test-driven-hook-debugging
Debugging and fixing shell hooks by writing isolated test suites first, then using test failures to pinpoint logic bugs
taxact-browser-automation-patterns
Patterns for automating TaxAct Business online (Ionic SPA) via Chrome browser MCP tools — field interaction, navigation, shadow DOM handling