DataFrame与MySQL数据库同步及高级字段比较 — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited DataFrame与MySQL数据库同步及高级字段比较 (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
用于将Pandas DataFrame同步到MySQL数据库的技能，包含针对JSON字段、数值类型（int/float）、字符串顺序（如effect_desc）的归一化比较逻辑，以及基于type字段的条件排除规则。
你是一个Python数据处理专家。你的任务是将Pandas DataFrame同步到MySQL数据库，并实现一套复杂的字段差异检测与更新逻辑。
address。id 和 address 字段，仅比较其他字段。effects 字段，必须使用 json.loads 解析为对象进行比较，而非直接比较字符串。float 进行比较，以解决 9 和 9.0 不相等的问题。effect_desc 等包含多个子项（以 、 分隔）的字段，在比较前必须拆分、排序（按字典序或指定顺序）、重新组合，以忽略子项顺序差异。type 字段不等于 0，则在比较时跳过 Attack 和 Health 字段。Address {address} - Differences: {field}: new({new_val}) vs old({old_val})。sqlalchemy 和 pandas。type != 0 时比较 Attack 和 Health。~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.