Consolidate and clean a database with 8 million records

En cours Publié le il y a 6 ans Paiement à la livraison
En cours Paiement à la livraison

We have acquired a database for marketing purposes with addresses and contact details of 8 million companies. We received the data in about 50 Excel-files (some of them are attached), with different columns, different formats for phone and fax numbers, invalid entries in some fields like "email address" (i.e. two addresses seperated by "/") and some UTF-8 encoding issues that have to be fixed.

The final result should be clean, nomalized CSV-files (one per country), with identical field structure and data formats and with proper seperation of delimited content.

Traitement de Données Excel SQL Web Scraping

Nº du projet : #15925339

À propos du projet

23 propositions Projet à distance Actif il y a 6 ans

23 freelances font une offre moyenne de 417 € pour ce travail

P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

€400 EUR en 3 jours
(345 Commentaires)
7.4
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Relevant Skills and Experi Plus

€750 EUR en 15 jours
(236 Commentaires)
6.9
dvcontact

Hi, Reading your project description about consolidating and cleaning a database makes me feel like you have me in mind when creating the project. I have all it takes to deliver. Relevant Skills and Experience You wil Plus

€300 EUR en 10 jours
(55 Commentaires)
6.5
xiqian88

Dear,Sir How are you? I am very interested in your project and am ready for starting for now as web scrapping developer. Relevant Skills and Experience I have experienced in developing Data Processing, Excel, SQL, Web Plus

€333 EUR en 10 jours
(5 Commentaires)
5.7
topithub

Consolidate and clean a database with 8 million records Relevant Skills and Experience Data Processing, Excel, SQL, Web Scraping 7 years experience Proposed Milestones €650 EUR - task

€650 EUR en 10 jours
(15 Commentaires)
5.4
royalwebraisers

HI, We can create database mysql from all excel files you have. Also, can show a search page where you may get all data acocording the search. Thanks. Relevant Skills and Experience Data Processing, Excel, SQL, Web Plus

€250 EUR en 10 jours
(19 Commentaires)
5.2
kahilH

Hello I am a highly skilled Software Architecture i can clean and rebuild the database you have lets discuss more on chat about that Relevant Skills and Experience Software Architecture ,Database Design Proposed Mil Plus

€250 EUR en 10 jours
(38 Commentaires)
5.2
vivirain

Hi there, I’m interested in the job and can help get the work well done quickly. Feel free to contact me and discuss more details. Best Regards,

€300 EUR en 5 jours
(11 Commentaires)
3.7
mwasim86

ok all clear , u have 8 milion companies data , i have checked the attached file also ,, u need us to clean the data and organized it in proper way , formatting of addresses etc Relevant Skills and Experience can u in Plus

€250 EUR en 10 jours
(5 Commentaires)
2.3
studio3dvisul

Hi,i am expert in data entry $ excel. i have 7 years experience in this field. I interested on your project ,give me the opportunity i will make you happy. Relevant Skills and Experience Call Center, Customer Service, Plus

€333 EUR en 10 jours
(1 Évaluation)
0.0
justdotweaks

Hello , We have Dedicated Team of developer to work on your project Titled: Consolidate and clean a database with 8 million records Relevant Skills and Experience Our specialities in Listed : - iOS/Android development Plus

€555 EUR en 10 jours
(0 Commentaires)
0.0
AnjaliSingh18

Hi, I am interested in your project & this is something i am good at. I am really good in typing and reconciliation & however not limited to wordpress/website development. Relevant Skills and Experience I have an exte Plus

€250 EUR en 10 jours
(0 Commentaires)
0.0
abbasabdullaali

Hi, My name is Abbas Abdulla, I have excellent skills and experience in dealing with data. I am interested to work on this project with you. I will deliver you the final result within 5 days from the awarding date. Loo Plus

€433 EUR en 5 jours
(0 Commentaires)
0.0
akj707

i will a good suggestion to do this type of work, as i have experience of doing work in excel and sql. And i have done a project based on sql and using excel from the school level, so won't be a prob. Relevant Skills Plus

€444 EUR en 10 jours
(0 Commentaires)
0.0
samihassen

300 Euro on 10 Days Relevant Skills and Experience I have manage many Strong Database Proposed Milestones €555 EUR - 10 Days

€555 EUR en 10 jours
(0 Commentaires)
0.0
arielantog

Buen día. Veo que eres español por lo que te responderé en castellano. Llevo 3 años trabajando en Business Intelligent por lo que tengo experiencia en lo que es Extracción, Transformación y Carga de datos. Hace un añ Plus

€255 EUR en 10 jours
(0 Commentaires)
0.0
rahulpipeline09

I have a great experience in data entry, like typing jpg to word or txt file and eating Excel sheet. I am a highly energetic, reliable, attentive and hardworking freelancer. Relevant Skills and Experience Relevant Ski Plus

€250 EUR en 20 jours
(0 Commentaires)
0.0
sureshpbabu

I'm ready complete the Project in 10 Days with the proposed Bid Amount Relevant Skills and Experience ETL, Data Cleansing, Data Analysis Proposed Milestones €333 EUR - Data Analysis, Data Cleansing Additional Servic Plus

€333 EUR en 10 jours
(0 Commentaires)
0.0
Kristine0777

You need to enter data into the database table and process errors that were allowed in Excel Relevant Skills and Experience I have many years of experience working with databases and information processing (cleaning). Plus

€277 EUR en 10 jours
(0 Commentaires)
0.0