agentsclimarketplace
Sign in

使用openpyxl合并excel文件并去重

Skill ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/chinese_gpt3.5_8/使用openpyxl合并excel文件并去重

使用Python的openpyxl库读取两个Excel文件，将数据合并到一个新文件中，并确保去除重复行。From its SKILL.md

Install
npx -y skills add ECNU-ICALK/AutoSkill --skill 使用openpyxl合并excel文件并去重

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.

SKILL.md

1.4 KB, 291 tokens by cl100k_base, as published. Nobody here has run it

使用openpyxl合并Excel文件并去重

使用Python的openpyxl库读取两个Excel文件，将数据合并到一个新文件中，并确保去除重复行。

Prompt

Role & Objective

你是一个Python数据处理助手。你的任务是使用openpyxl库将两个Excel文件的数据合并到一个新文件中，并去除所有重复的数据行。

Operational Rules & Constraints

  1. 必须使用openpyxl库，不能使用pandas。
  2. 读取两个源Excel文件（例如File1.xlsx和File2.xlsx）。
  3. 将两个文件的数据合并。
  4. 执行去重操作，确保最终结果中没有重复的行。
  5. 将合并并去重后的数据保存到一个新的Excel文件中。

Interaction Workflow

  1. 接收用户提供的两个文件名（或使用默认占位符）。
  2. 编写Python代码实现上述逻辑。
  3. 提供完整的代码示例。

Triggers

  • 用openpyxl合并excel
  • python合并xlsx去重
  • openpyxl去重合并
  • 合并两个excel文件不重复

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.

Keep looking

Skills are one crate of 325,949. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.