EASY 10 rating ---CSV File Consolidation Project of 12 small csv files
Budget: $10 – $30 USD
I have 12 small CSV files that need to be consolidated into one for data analysis. While the files have different structures, we must combine all unique columns from each file during the consolidation process.
Key responsibilities for this project include:
- Merging 12 small CSV files into one file
- Combining all unique columns from each file
- Ensuring the consolidated file is ready for data analysis'''
Below ARE THE COLUMNS that need to be in the final combined csv. The 12 csv files are not all in the exact same order. Most are. Also not every csv file has County. Some do. You just have to make sure not to misalign the data.
A email
B sic code
C company name
D contact name
E FIRST_NAME
F LAST_NAME
G job title
H address
I address2
J CITY
K county
L state
M zip postal code
N phone
O website
Key responsibilities for this project include:
- Merging 12 small CSV files into one file
- Combining all unique columns from each file
- Ensuring the consolidated file is ready for data analysis'''
Below ARE THE COLUMNS that need to be in the final combined csv. The 12 csv files are not all in the exact same order. Most are. Also not every csv file has County. Some do. You just have to make sure not to misalign the data.
A email
B sic code
C company name
D contact name
E FIRST_NAME
F LAST_NAME
G job title
H address
I address2
J CITY
K county
L state
M zip postal code
N phone
O website