Data Cleansing & Enrichment

En curso Publicado hace 7 años Pagado a la entrega
En curso Pagado a la entrega

• 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

Procesamiento de datos Excel

Nº del proyecto: #10945680

Sobre el proyecto

24 propuestas Proyecto remoto Activo hace 7 años

Adjudicado a:

PhpWebD

- 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 Más

$90 USD en 2 días
(3 comentarios)
2.7

24 freelancers están ofertando un promedio de $77 por este trabajo

cgullapalli

Hi, I am good at Excel and can perform activities as given. I would also like to know the new procedure required.

$105 USD en 1 día
(966 comentarios)
8.1
sy3d

hi hru i read and understand what i've to do but you know that one excel sheet only support 1.048 M records (1,048,576) so its not possible to consolidate all entries in one sheet we can split it in two parts or ca Más

$100 USD en 1 día
(311 comentarios)
7.3
sisicirnes

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 Más

$83 USD en 5 días
(72 comentarios)
6.7
narsim3128

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 Más

$83 USD en 1 día
(61 comentarios)
6.0
sourabhg98

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 Más

$39 USD en 1 día
(149 comentarios)
6.1
choprac

Hello, Hope you are doing good, I read the job description. It’s my kind of work. I can complete the project timely and within your budget. I have an advanced knowledge of Internet research, PDF to word/excel Conver Más

$100 USD en 5 días
(97 comentarios)
5.6
crazynightwalker

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!

$100 USD en 1 día
(27 comentarios)
4.8
yaash105

Dear sir, Experts and top Data Entry, Data Processing people who are experts in Excel, Word, PDF and all other research works in website and internet are here ready to start work now. I can send you some samples of o Más

$61 USD en 1 día
(8 comentarios)
2.2
andojulius

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

$61 USD en 3 días
(3 comentarios)
2.1
rupshe23

Hi I am Afia Akter form Bangladesh. I am related with web research & data entry last three years. I am an expert in data entry and web research. I am good at all kind of Researches and Data Collection works. I am Expe Más

$61 USD en 1 día
(0 comentarios)
0.0
jefpoypeteza

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

$61 USD en 1 día
(0 comentarios)
0.0
anthonysamuel

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 Más

$61 USD en 1 día
(0 comentarios)
0.0
Namrata3012

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 Más

$55 USD en 3 días
(0 comentarios)
0.0
lucasedms

I have a lot of experience with excel. I work with data for 6 years. This project is perfect. Give me its please. Thanks.

$10 USD en 10 días
(0 comentarios)
0.0
lionsmover

A proposal has not yet been provided

$35 USD en 1 día
(0 comentarios)
0.0