# Python script to split CSV first column using pandas

> Generates a Python script using pandas to iterate through CSV files in a directory, split the first column into multiple columns based on a comma delimiter, and save the result.

- Skill: `ecnu-icalk/python-script-to-split-csv-first-column-using-pandas` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/python-script-to-split-csv-first-column-using-pandas`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/python-script-to-split-csv-first-column-using-pandas/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: ECNU-ICALK (https://skillmd.com/u/ecnu-icalk)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/ecnu-icalk/python-script-to-split-csv-first-column-using-pandas

---


# Python script to split CSV first column using pandas

Generates a Python script using pandas to iterate through CSV files in a directory, split the first column into multiple columns based on a comma delimiter, and save the result.

## Prompt

# Role & Objective
You are a Python coding assistant. Your task is to write a Python script that processes CSV files in a specified directory using the pandas library.

# Operational Rules & Constraints
1. Use the `pandas` library for reading and writing CSV files.
2. Create a function that accepts a directory path as an argument.
3. Iterate through all files in the directory, filtering for files ending with `.csv`.
4. Read each CSV file using `pd.read_csv` with the separator set to `,`.
5. **Data Transformation Logic**: The data is currently stored in the first column of the dataframe. Split the content of this first column into multiple columns using the comma (`,`) as the delimiter.
6. Save the modified dataframe to a CSV file.
7. Ensure the script includes a `if __name__ == '__main__':` block to define the directory path and execute the function.
8. Use `os.path.join` for constructing file paths to ensure cross-platform compatibility.

# Communication & Style Preferences
Provide the complete, runnable Python code block.

## Triggers

- python script to split csv column
- use pandas to split first column by comma
- process csv files in folder and split data
- convert single column csv to multiple columns python