Skip to content

LeandroBenjaminL/lend-ai / skills/data-profiling

data-profiling

Verified

Profiling automático de datasets — ydata-profiling, pandera, great expectations. Entendé cualquier dataset en minutos. Trigger: Cuando recibís un dataset nuevo y necesitás entenderlo rápido, o querés un reporte de calidad de datos.

FileKindSize
SKILL.mdskill md2.6 KB
assets/profile_report.pyscript1.3 KB

assets/profile_report.py

View on GitHub
"""
Perfil automático de dataset — genera reporte HTML de calidad.
USO: python profile_report.py datos.csv
"""

import sys

import numpy as np
import pandas as pd


def perfil_rapido(ruta: str) -> list:
    df = pd.read_csv(ruta, low_memory=False)
    print(f"📐 Shape: {df.shape[0]:,} × {df.shape[1]}")
    print(f"💾 Memoria: {df.memory_usage(deep=True).sum() / 1024**2:.1f} MB")

    problemas = []
    for col in df.columns:
        pct_nulo = df[col].isnull().mean()
        if pct_nulo > 0.5:
            problemas.append(f"🔴 {col}: {pct_nulo:.0%} nulos — eliminar?")
        elif pct_nulo > 0.2:
            problemas.append(f"🟡 {col}: {pct_nulo:.0%} nulos — imputar")

    for col in df.select_dtypes(include=[np.number]).columns:
        q1, q3 = df[col].quantile([0.25, 0.75])
        iqr = q3 - q1
        outliers = ((df[col] < q1 - 3 * iqr) | (df[col] > q3 + 3 * iqr)).sum()
        if outliers:
            problemas.append(f"📍 {col}: {outliers} outliers extremos")

    if problemas:
        print(f"\n⚠️  Alertas ({len(problemas)}):")
        for p in problemas:
            print(f"  {p}")
    else:
        print("\n✅ Sin problemas detectados")

    return problemas


if __name__ == "__main__":
    ruta = sys.argv[1] if len(sys.argv) > 1 else input("Ruta del CSV: ")
    perfil_rapido(ruta)
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 198kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 194kUpdated Claude CodeCodexVerifiedInstall