Data Cleansing & Enrichment
$10-100 USD
S-au achitat serviciile după ce au fost prestate
• I have 44 excel files all with the same structure that need to be consolidated into a single excel file – this excel file should be named “directory” and saved. I expect about 700K records on this file.
• I have another excel file named “aggregate” that contains about 500K records but with a different structure to the “directory” file to be created above.
• I want all data from the file named “directory” to be copied to the matching column within the file named “aggregate”. A new file should be created and named “combined” and the source column value for records should be “directory”. I expect the file “combined” to contain about 1.2m records.
• Perform the following tasks to enrich the data
o Sort by “name”
o Find duplicate “names”
o Update blank cell values in source row with values from different sources matching the same “name”.
o Flag duplicate rows – so they can be removed from file
o Make all data values capital letters
o Save “combined file” as “Enriched”
• Perform other cleansing based on validation rules provided during the project
• Finish
ID Proiect: #10945680
Detalii despre proiect
Acordat lui:
- I am a professional back-end developer. - 3 years experience in PHP,HTML,CSS,jQuery, Codeiginiter,Laravel and Bootstrap. - I also develop Wordpress Themes/Plugins. - I deliver simple and quick to load web Mai multe
24 freelanceri plasează o ofertă medie de 77$ pentru proiect
Hi, I am good at Excel and can perform activities as given. I would also like to know the new procedure required.
I did already similar project and i can share a link to you if needed. Hello, I'm Irnes, data entry and web research worker from Bosnia-Herzegovina. I'm here to find a good, paid job and prove my skills. I'm very s Mai multe
With respect to this project I would like to present myself as a candidate for your consideration. I have more than 6 years of experience. I have successfully completed few projects for US clients which involved web sc Mai multe
Hello This is Sourabh Gupta from New Delhi. I am an advanced VBA programmer and I am really interested in doing your job. I am among top 111 members at EXCEL FORUM,, with over 300 questions answered and 1000+ r Mai multe
Hi! I can provide you with all the Excel operations on the large files you mentioned and I am willing to discuss further details. I can have it all done in a few hours!
hi dear hiring manager i'm an expert in excel work and a good typist so i'll wish to make perfect your project and finish it at right time without any errors thanks so much best regards
HI IM JEFF PETEZA FROM PHILIPPINES I'D LIKE TO WORK ON YOUR PROJECT TO APPLY MY SKILLS AND ABILITY ON THIS KIND OF WORK
besides having strong reading and writing skills you also possess an extensive knowledge of using the numeric keys and spreadsheet programs. Many of the clerical jobs are related to the data entry of the numerics or fi Mai multe
Hi, I am excellent with excel and have been using it for a decade working on it day and night. You can easily send it to me to do. I am in need of extra money and so am doing it at a very reasonable cost in minimum Mai multe
I have a lot of experience with excel. I work with data for 6 years. This project is perfect. Give me its please. Thanks.