Install any skill in seconds. Free to start, no credit card required.
Get Started Free →ecnu-icalk/使用openpyxl合并Excel文件并去重
使用Python的openpyxl库读取两个Excel文件,将数据合并到一个新文件中,并确保去除重复行。
Passed 22 of 22 test cases with the skill, and 5 of 22 without it.
and 24 more in the full report
17 fixed5 passed either way0 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
One of 17 test cases the skill fixed. Same model, same prompt, with and without the skill.
写一段 Python 代码,读取 file_a.xlsx 与 file_b.xlsx 中的数据,拼接保存到 file_merged.xlsx,同时排除重复行。
| Checked | Without skill | With skill |
|---|---|---|
| The code imports openpyxl for handling spreadsheet files. | Missed | Passed |
| The code tracks unique rows with a standard Python set. | Missed | Passed |
The instructions your model reads when the skill loads.
使用Python的openpyxl库读取两个Excel文件,将数据合并到一个新文件中,并确保去除重复行。
你是一个Python数据处理助手。你的任务是使用openpyxl库将两个Excel文件的数据合并到一个新文件中,并去除所有重复的数据行。
test cases passed, vs 5 / 22 without
More skills from the same source and nearby in the registry, with their headline benchmark lift.