xlsx-to-python-test-assertion-patterns-by-data-type

Sub-skill of xlsx-to-python: Test Assertion Patterns by Data Type (+1).

Repository: vamseeachanta/workspace-hub
Last source activity: May 4, 2026 at 15:05
Detected SKILL.md language: English
Stars: 16
Forks: 7

Install options

The review-first prompt is selected by default. You can switch to a direct command or download a local copy.

Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.

A direct command skips the review prompt. Inspect the source before running it.

npx skills add https://github.com/vamseeachanta/workspace-hub --skill xlsx-to-python-test-assertion-patterns-by-data-type

The command stays on one line. Scroll horizontally to inspect it before copying.

Prefer a local copy? Download the files currently available to SkillsMP.

Review the source files

Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.

SKILL.md

Source instructions · Read-only preview

Back to search Back to installation

communication-voice

Write outbound email and external messages in Vamsee Achanta's voice — a subtle offer to help, never bold or rash claims. Load before drafting ANY email, LinkedIn/Collide reply, proposal note, or outreach sent under his name.

2026-07-30

hf-dataset-publishing

Save/publish analysis or computation results from ANY ecosystem repo to Hugging Face as a queryable, viewer-renderable dataset. Use when the user wants to "save results to hugging face", "publish dataset to HF", "hugging face data saving", "save analysis results", "hf dataset", "make results queryable", or "render via datasets-server API". Reshapes nested results into flat parquet tables, writes a dataset card with a viewer `configs:` block and provenance, applies license/public-vs-private routing, enforces a domain data-quality gate (faithful-to-source != correct), publishes to `aceengineer/<repo>-<projection>`, and verifies via the datasets-server API.

2026-07-28

github-repo-management

Clone, create, fork, configure, and manage GitHub repositories. Manage remotes, secrets, releases, and workflows. Works with gh CLI or falls back to git + GitHub REST API via curl.

2026-07-23

View all from this repository

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

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

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

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

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

xlsx-to-python-test-assertion-patterns-by-data-type

Install options

Review the source files

Test Assertion Patterns by Data Type (+1)

Test Assertion Patterns by Data Type

Tolerance Selection

Test Assertion Patterns by Data Type (+1)

Test Assertion Patterns by Data Type

Tolerance Selection

xlsx-to-python-test-assertion-patterns-by-data-type

Source facts

Install options

Review the source files

More from this repository

More from this repository

Test Assertion Patterns by Data Type (+1)

Test Assertion Patterns by Data Type

Tolerance Selection

Test Assertion Patterns by Data Type (+1)

Test Assertion Patterns by Data Type

Tolerance Selection