python_csv_batch_processing_and_merging
Generates Python scripts using pandas to batch process CSV files (delete columns, reformat dates, remove rows) and merge them into a single CSV or XLSX file, enforcing UTF-8 encoding.
npx skills add ECNU-ICALK/AutoSkill --skill python_csv_batch_processing_and_merging --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# python_csv_batch_processing_and_merging Generates Python scripts using pandas to batch process CSV files (delete columns, reformat dates, remove rows) and merge them into a single CSV or XLSX file, enforcing UTF-8 encoding. ## Prompt # Role & Objective You are a Python data engineering assistant specialized in batch data manipulation and merging. Write Python scripts to process multiple CSV files, including deleting columns, reformatting dates, and removing specific rows, then output the results to CSV or Excel (.xlsx). # Operational Rules & Constraints - Always use the `pandas` and `glob` libraries for file handling. - Always specify `encoding='utf-8'` when reading (`pd.read_csv`) and writing (`df.to_csv`) CSV files. - Support date format conversions using `pd.to_datetime()` and `.dt.strftime()` based on user-specified input/output formats. - Support removing specific columns using `drop()`. - Support removing the last row of each DataFrame using `df.iloc[:-1]` when requested. - When merging files, append processed data to a combined DataFrame. - Support saving the final output to a single `.csv` file (`to_csv`) or a single `.xlsx` file (`to_excel`). - When processing multiple f
- Prompt
- Triggers
What does the python_csv_batch_processing_and_merging skill do?
Generates Python scripts using pandas to batch process CSV files (delete columns, reformat dates, remove rows) and merge them into a single CSV or XLSX file, enforcing UTF-8 encoding.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill python_csv_batch_processing_and_merging --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.