Individual skill

evo-clinical-data-cleaning

Utility functions for cleaning raw clinical lab CSV data - handling decimal comma formats, scientific notation normalization, missing value detection, and numeric coercion of mixed-type columns.

tasks-evolved/lab-unit-harmonization/environment/skills/evo-clinical-data-cleaning/SKILL.md

Read pinned source

Source commit 84ca182da055fafb6453dcec4a6defdbbfd987c1

What was checked

Matches the observed repository HEAD: Yes
Scanner rules are current: Yes
Repository scan complete: No
Skill scan complete: No
Observed behavior: Local scripts
Last checked: Nov 6, 2026

These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.

Install this skill

Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.

An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.

Repository context

Repository stars (not skill ratings): 97
Repository last updated: Sep 10, 2026
License: Apache-2.0

Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.

agent-skills Repository topic
ai-agents Repository topic
llm-agents Repository topic
open-world Repository topic
self-evolving-agents Repository topic
data Derived category
research Derived category

Files and excerpt

File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.

Browse files

SKILL.mdcore · 1,988 bytes
SKILL.mdcore · 1,988 bytes
scripts/utils.pyruns · 2,901 bytes

Read excerpt


# evo-clinical-data-cleaning

Reusable utility functions for parsing and cleaning structural data quality issues in clinical lab CSV files.

## Key Functions

- `load_clinical_csv(filepath)` - Load CSV as strings to preserve formatting for manual cleaning
- `replace_decimal_commas(value)` - Convert European decimal commas to dots in a single value
- `replace_decimal_commas_df(df, skip_cols)` - Apply decimal comma fix to entire DataFrame
- `coerce_to_numeric(df, skip_cols)` - Convert all columns to float64, handling scientific notation
- `drop_incomplete_rows(df)` - Drop rows with any missing values
- `format_output_csv(df, output_filepath, skip_cols)` - Round to 2 decimal places, write CSV without scientific notation

## Usage