Excel merging and transformation pipeline

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

AutoSkill: Experience-Driven Lifelong Learning via Skill Self-Evolution

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.

What its author says it does

Copied from the file, not written here

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.

SKILL.md

1.8 KB, 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