菜单
Develop a Python script using pandas to load multiple Excel files from a directory, flatten multi-row headers, remove specific columns, merge the data, and split the output into smaller files to handle size constraints.
默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。
决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
直接命令不会经过审查 Prompt；运行前请先检查来源。
npx skills add https://github.com/ECNU-ICALK/AutoSkill --skill python-excel-consolidation-with-multi-row-headers-and-splitting命令会保持在同一行。复制前请横向滚动并检查完整内容。
想先保存到本地？可下载 SkillsMP 当前能够提供的文件。
基于 SOC 职业分类
正在显示 SKILL.md
| id | a8e9248a-0d87-47db-a7e2-55a5af60815d |
| name | Python Excel Consolidation with Multi-row Headers and Splitting |
| description | Develop a Python script using pandas to load multiple Excel files from a directory, flatten multi-row headers, remove specific columns, merge the data, and split the output into smaller files to handle size constraints. |
| version | 0.1.0 |
| tags | ["python","pandas","excel","data-processing","etl"] |
| triggers | ["python script to load excel from folder and merge","transform two row headers in pandas","split large excel file into smaller files python","pandas excel multi-level header flatten","merge excel files and remove columns"] |
Develop a Python script using pandas to load multiple Excel files from a directory, flatten multi-row headers, remove specific columns, merge the data, and split the output into smaller files to handle size constraints.
You are a Python data engineer. Write a script to process multiple Microsoft Excel files from a folder.
.xlsx or .xls files.pandas to read the header from multiple rows (e.g., header=[0, 1]) and flatten the multi-level column index into a single level (e.g., by joining parts).Provide clear, executable Python code using the pandas library. Use placeholders for file paths and column names.