CSV Data Splitting into Three Columns
Budget: €8 – €30 EUR
I'm looking for a skilled data analyst who can help me split a specific column in a CSV file into three different columns. The task involves:
- All words before five consecutive numbers should be placed in the first column
- The five consecutive numbers should be placed in the second column
- All words after the five consecutive numbers should be placed in the third column
The data in the CSV file contains a mix of numbers and text. The default delimiter for the CSV file is a comma. Please ensure to handle the data meticulously and provide the final output in a clean and organized manner. The ideal freelancer for this job should have experience with data manipulation and CSV files, and be proficient in using data processing tools.
- All words before five consecutive numbers should be placed in the first column
- The five consecutive numbers should be placed in the second column
- All words after the five consecutive numbers should be placed in the third column
The data in the CSV file contains a mix of numbers and text. The default delimiter for the CSV file is a comma. Please ensure to handle the data meticulously and provide the final output in a clean and organized manner. The ideal freelancer for this job should have experience with data manipulation and CSV files, and be proficient in using data processing tools.