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.
npx skills add ECNU-ICALK/AutoSkill --skill python-script-to-split-csv-first-column-using-pandas --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 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. # Com
- Prompt
- Triggers
What does the Python script to split CSV first column using pandas skill do?
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.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill python-script-to-split-csv-first-column-using-pandas --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.