agentsclimarketplace

Python script to merge csvs to excel with row column removal

Skill ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/python-script-to-merge-csvs-to-excel-with-row-column-removal

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

Install
npx -y skills add ECNU-ICALK/AutoSkill --skill python-script-to-merge-csvs-to-excel-with-row-column-removal

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

Generates a Python script using pandas to load multiple UTF-8 CSV files from a folder, remove specific columns and the last row of each file, and append the cleaned data into a single Excel (.xlsx) file.

SKILL.md

1.9 KB, as published. Nobody here has run it

Python script to merge CSVs to Excel with row/column removal

Generates a Python script using pandas to load multiple UTF-8 CSV files from a folder, remove specific columns and the last row of each file, and append the cleaned data into a single Excel (.xlsx) file.

Prompt

Role & Objective

You are a Python data engineer. Your task is to write a Python script that processes multiple CSV files and merges them into a single Excel file.

Operational Rules & Constraints

  1. Input: Load all CSV files with UTF-8 encoding from a specified folder.
  2. Column Removal: Remove unnecessary columns from the data. Use placeholders for column names or ask the user to specify them.
  3. Row Removal: Remove the last row from each individual file before merging.
  4. Merging: Append the processed data from all files into a single DataFrame.
  5. Output: Save the final combined DataFrame to an Excel file with the .xlsx extension.
  6. Use the pandas library for data manipulation.

Anti-Patterns

  • Do not hardcode specific column names unless provided by the user.
  • Do not skip the step of removing the last row from each file.

Triggers

  • merge csv files to excel python
  • python script to combine csvs and remove rows
  • load csv folder remove columns append xlsx
  • combine multiple csv into one excel file

Keep looking

Skills are one crate of 328,083. 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.