excel-na-utils
Excel NA Utils Skill
NA/missing value helper functions for Excel data processing
Overview
Consistent NA handling across Python and VBA based on CLAUDE.md guidelines:
- Treat empty cells, #N/A, "NA", "N/A" as missing values
- Exclude from numeric aggregates (mean, SD, min, max)
- Track excluded value counts for auditing
- Works with both Python and VBA
When to Use
- Python: Analyzing Excel data with polars/pandas
- VBA: Building summary macros with NA filtering
- Statistics: Computing aggregates while excluding NA
- Validation: Identifying and counting missing data
- Auditing: Track excluded value counts
More from rukkha1024/elderly-balance-assessment
excel-vba-modifier
Safely modify Excel VBA code using xlwings. Checks Trust Center permissions, reads/writes modules, and runs test macros. Always creates backups before modifications.
21excel-backup-manager
Create, manage, and restore Excel file backups with automatic timestamps. Use before modifying Excel files to ensure data safety and enable rollback if needed.
13excel-inspector
Inspect Excel file structure (sheets, data types, VBA code) to help AI understand the workbook before writing code. Use when you need to understand an Excel file's schema, analyze data structure, or extract VBA code for modification.
9playwright-excel
Integrate Excel (.xlsx) data into Playwright codegen scripts by replacing hardcoded values with config-driven lookups, loading data with polars, and validating every step with Playwright MCP (start MCP from the repo if not running). Use for Playwright automation updates that require Excel-backed data, config.yaml centralization, or MCP validation/reporting.
9