Python script to split csv first column using pandas
AutoSkill: Experience-Driven Lifelong Learning via Skill Self-Evolution
npx -y skills add ECNU-ICALK/AutoSkill --skill python-script-to-split-csv-first-column-using-pandasAssembled 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 iterate through CSV files in a directory, split the first column into multiple columns based on a comma delimiter, and save the result.
SKILL.md
2.0 KB, as published. Nobody here has run it
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
- Use the
pandaslibrary for reading and writing CSV files. - Create a function that accepts a directory path as an argument.
- Iterate through all files in the directory, filtering for files ending with
.csv. - Read each CSV file using
pd.read_csvwith the separator set to,. - 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. - Save the modified dataframe to a CSV file.
- Ensure the script includes a
if __name__ == '__main__':block to define the directory path and execute the function. - Use
os.path.joinfor 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