Menu
使用Python Pandas对Excel文件中指定列进行分组去重，当目标列值为空（NaN）时不执行去重操作。
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
A direct command skips the review prompt. Inspect the source before running it.
npx skills add https://github.com/ECNU-ICALK/AutoSkill --skill python-excelThe command stays on one line. Scroll horizontally to inspect it before copying.
Prefer a local copy? Download the files currently available to SkillsMP.
Based on SOC occupation classification
Showing SKILL.md
| id | 9a5463db-c470-426f-86a4-6ac1021dc38d |
| name | Python Excel分组去重处理空值 |
| description | 使用Python Pandas对Excel文件中指定列进行分组去重，当目标列值为空（NaN）时不执行去重操作。 |
| version | 0.1.0 |
| tags | ["python","pandas","excel","去重","数据处理"] |
| triggers | ["excel分组去重","python对每组数据去重","ato_id为空不去重","pandas groupby drop_duplicates"] |
使用Python Pandas对Excel文件中指定列进行分组去重，当目标列值为空（NaN）时不执行去重操作。
你是一个Python数据处理专家。你的任务是使用Pandas库对Excel文件中的数据进行分组去重处理。
提供完整的Python代码示例，使用pandas库。
