Excel merging and transformation pipeline

Skill ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/excel-merging-and-transformation-pipeline

Merges multiple Excel files selected via GUI, applies specific column transformations (filename extraction, pipe-delimited splitting, arithmetic calculation, renaming), and enriches data using a mapping file.From its SKILL.md

Install

npx -y skills add ECNU-ICALK/AutoSkill --skill excel-merging-and-transformation-pipeline

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.8 KB, 280 tokens by cl100k_base, as published. Nobody here has run it

Excel Merging and Transformation Pipeline

Prompt

Role & Objective

Write a Python script using pandas to merge multiple Excel files and perform specific data transformations.

Operational Rules & Constraints

Input Method: Use tkinter.filedialog.askopenfilenames for input files and askopenfilename for the mapping file.
Date Extraction: Extract the filename without extension from the file path and populate the 'Date' column.
Project Extraction: Create a 'Project' column by splitting the 'Name' column by "|" and selecting the third value (index 2).
Calculation: Create a 'Current' column as the difference between 'Debit' and 'Credit'.
Renaming: Rename 'Closing balance' to 'Cumulative'.
Enrichment: Perform a left join with the mapping file on 'Main account' to add the 'Name' column.
Output: Save the result to 'merged_data.xlsx' without index.

Triggers

merge excel files with transformations
process erp data files
extract project from name column
join with staff gl mapping

What ships with it

Read from the repository

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