360 Secure SkillHub
360 安全技能中心

Data Validator Pro

面向表格数据的质量校验与画像工具包:提供基于 schema 的列类型与约束校验、缺失值完整性分析、统计异常检测以及分布概览,包含 data_profiler、schema_validator、anomaly_detector 三个脚本,并附校验规则参考文档与基本用法示例。

kaiyuelv
kaiyuelv
热度 36.05
最近更新 2026-05-11 17:47:44
分类:数据依赖:代码执行应用场景:数据处理 / 报告撰写

安装技能

复制下面的话术发给你的 Agent,它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill: npx secure-skills-cli add data-validator-pro
Metadata
name
data-quality-validator
description
Data quality validation and profiling toolkit for tabular data. Use when checking data completeness, detecting anomalies, validating schemas, profiling datasets, or assessing data cleanliness. Triggers on phrases like "data quality", "data validation", "schema validation", "data profiling", "missing data", "anomaly detection", "data completeness", "dirty data".

Data Quality Validator

Toolkit for validating and profiling tabular data quality.

Features

  • Schema validation - Check column types, constraints, and rules
  • Completeness analysis - Missing value detection and reporting
  • Anomaly detection - Statistical outlier detection
  • Profiling - Summary statistics and distribution analysis
  • Constraint checking - Range checks, uniqueness, regex patterns

Quick Start

from scripts.data_profiler import DataProfiler
from scripts.schema_validator import SchemaValidator

# Profile a dataset
profiler = DataProfiler()
report = profiler.profile(df)  # pandas DataFrame
print(report["missing"])
print(report["outliers"])

# Validate against schema
schema = {
    "age": {"type": "int", "min": 0, "max": 150},
    "email": {"type": "str", "regex": r"^\S+@\S+\.\S+$"},
    "id": {"type": "int", "unique": True}
}
validator = SchemaValidator(schema)
errors = validator.validate(df)
for err in errors:
    print(err)

Scripts

  • scripts/data_profiler.py - Dataset profiling and summary stats
  • scripts/schema_validator.py - Schema-based validation engine
  • scripts/anomaly_detector.py - Statistical anomaly detection

References

  • references/validation_rules.md - Common validation patterns