home/categories/scripting/ecnu-icalk-autoskill-skillbank-convskill-english-gpt3-5-8-glm4-7-python-excel-consolidation-with-multi-row-headers-and-splitting-skill-md
scriptingdevelopment
python-excel-consolidation-with-multi-row-headers-and-splitting
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.
maintainer
ECNU-ICALK
Updated 3/13/2026
Stars
304
Forks
34
quick start
Installation and usage
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.
Installation
$ install --globalskills.sh
Usage
Once installed, you can use this skill by running the following command in your terminal:
skills use python-excel-consolidation-with-multi-row-headers-and-splitting