Data Conversion to CSV
Budget: $10 – $30 USD
I am looking for a freelancer who specializes in data management. The task involves converting data from a text format into a CSV format. This data is a mix of numerical and textual content. The resulting CSV file should be structured in a row-based presentation.
Here's a bit more details about the project:
- The CSV file must respect data field priority in structuring and organizing the data.
- Because the data in question is mixed, you should have experience in handling both numerical and textual data.
- Familiarity with writing scripts to automate conversion tasks is strongly preferred.
- Attention to detail is crucial to ensure accurate data conversion.
The ideal candidate should have a significant background in data management, specifically with CSV files. Previous work with data conversion will also work in your favor. Let's convert this data accurately and efficiently.
I have data in text format that requires conversion into CSV (Comma-Separated Values). The text file includes diverse information, and the resulting CSV file requires a specific presentation for certain data.
To elaborate, the text file apply to a particular timeframe, specifically from 01/01/2023 to 31/01/2023, and revolves around the number of employees. Each employee is assigned a unique employee ID and possesses two schedules: the actual schedule and the published (PLANNING) schedule.
The conversion process should focus on extracting the actual schedule for each employee, emphasizing the duty assigned on each day (first line of duty required). This process should be replicated for the published (PLANNING) schedule as well. The desired presentation in the CSV file is as follows:
Date,Staff,Duty,Status
01/01/2023,30106,,ACTUAL
02/01/2023,30106,SBY,ACTUAL
03/01/2023,30106,113,ACTUAL
04/01/2023,30106,OFF,ACTUAL
05/01/2023,30106,114,ACTUAL
01/01/2023,30106,SBY,PLANNING
02/01/2023,30106,SBY,PLANNING
03/01/2023,30106,113,PLANNING
04/01/2023,30106,OFF,PLANNING
05/01/2023,30106,114,PLANNING
I am seeking a method that allows me to perform this conversion seamlessly on text files with a similar format, accommodating variations in periods, employees, and duties.
Here's a bit more details about the project:
- The CSV file must respect data field priority in structuring and organizing the data.
- Because the data in question is mixed, you should have experience in handling both numerical and textual data.
- Familiarity with writing scripts to automate conversion tasks is strongly preferred.
- Attention to detail is crucial to ensure accurate data conversion.
The ideal candidate should have a significant background in data management, specifically with CSV files. Previous work with data conversion will also work in your favor. Let's convert this data accurately and efficiently.
I have data in text format that requires conversion into CSV (Comma-Separated Values). The text file includes diverse information, and the resulting CSV file requires a specific presentation for certain data.
To elaborate, the text file apply to a particular timeframe, specifically from 01/01/2023 to 31/01/2023, and revolves around the number of employees. Each employee is assigned a unique employee ID and possesses two schedules: the actual schedule and the published (PLANNING) schedule.
The conversion process should focus on extracting the actual schedule for each employee, emphasizing the duty assigned on each day (first line of duty required). This process should be replicated for the published (PLANNING) schedule as well. The desired presentation in the CSV file is as follows:
Date,Staff,Duty,Status
01/01/2023,30106,,ACTUAL
02/01/2023,30106,SBY,ACTUAL
03/01/2023,30106,113,ACTUAL
04/01/2023,30106,OFF,ACTUAL
05/01/2023,30106,114,ACTUAL
01/01/2023,30106,SBY,PLANNING
02/01/2023,30106,SBY,PLANNING
03/01/2023,30106,113,PLANNING
04/01/2023,30106,OFF,PLANNING
05/01/2023,30106,114,PLANNING
I am seeking a method that allows me to perform this conversion seamlessly on text files with a similar format, accommodating variations in periods, employees, and duties.