28sungmin/m4-add-skills/date-validity

1. dateutil.parse()          → 표준 날짜 형식 (ISO, US, EU 등)
2. _valid_date_custom()      → 한국어 날짜 (e.g. "2024년 3월 15일")
3. LLM fallback (선택)       → 위 두 방법 실패 시 Claude CLI에 yes/no 질의

import os
import duckdb
skill_dir = os.path.dirname(os.path.abspath(__file__))
with open(os.path.join(skill_dir, "scripts/duckdb.sql")) as f:
    sql = f.read()
quiq_csv = "/path/to/quiq_3patients.csv"
sql = sql.replace("{quiq_csv}", quiq_csv)
df = duckdb.sql(sql).df()
total_date = df["Total_date"].sum()
invalid_date = df["Invalid_date"].sum()
date_validity = round((total_date - invalid_date) / total_date * 100, 2)
print(f"Date Validity (%) = {date_validity}")
save_path = "/path/to/output"
os.makedirs(save_path, exist_ok=True)
df.to_csv(f"{save_path}/date_validity_summary.csv", index=False, encoding="utf-8-sig")
with open(f"{save_path}/date_validity_total.txt", "w") as f:
    f.write(f"Date Validity (%) = {date_validity}\n")
    f.write(f"Total dates = {total_date}\n")
    f.write(f"Invalid dates = {invalid_date}\n")
print(f"Saved {len(df):,} rows → {save_path}")

import pandas as pd
import sys, os
skill_dir = os.path.dirname(os.path.abspath(__file__))
sys.path.insert(0, skill_dir)
from scripts.date_validity import get_date_validity
quiq = pd.read_csv("/path/to/quiq.csv")
valid_results_df, summary_df = get_date_validity(
    quiq=quiq,
    use_llm=True   # False 로 설정하면 LLM fallback 비활성화
)

# config.yaml
quiq_path:  /path/to/quiq.csv
save_path:  /path/to/output
use_llm:    true   # false 로 설정하면 LLM fallback 없음

python scripts/date_validity.py --config config.yaml