Tamamlanmış

Consolidate and clean a database with 8 million records

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.

Beceriler: Veri İşleme, Excel, SQL, Web Scraping

Daha fazlasını gör: clean database tabel wordpress, clean database joomla, access clean database, access database check duplicate records visual basic, database find similar records, clean database zen cart, clean database javascript, mysql database slow update records, mysql million records, clean database wordpress, clean database, joomla clean database, zen cart clean database, creloaded clean database, wordpress clean database

İşveren Hakkında:
( 1 değerlendirme ) Manchester, United Kingdom

Proje NO: #15925339

Seçilen:

mateenbhatti94

Dear sir I have been in this industry for 1 year and such jobs are my daily practice. I can assure you that if you work with me once, you will always work with me for these kind of projects. Relevant Skills and Exper Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 250%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(51 Değerlendirme)
5.6

Bu iş için 25 freelancer ortalamada €403 teklif veriyor

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.

in %bids___i_period_sub_35% gün içinde400%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(280 Değerlendirme)
7.2
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(210 Değerlendirme)
6.8
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
5.7
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(37 Değerlendirme)
5.8
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

in %bids___i_period_sub_35% gün içinde650%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(13 Değerlendirme)
5.2
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)
5.0
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(34 Değerlendirme)
5.1
krishan725

I have gone through your project requirement and would like to discuss further on it. Please send me personal message for more clarification. [login to view URL] Relevant Skills and Experience Relevant exper Daha Fazla

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
3.9
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,

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
2.3
itoasis1

Hi. Thanks for posting such a job. I have full experiences on arrange data as what you need. Hope you will reply soon. Best regards. Relevant Skills and Experience Arrange, Desktop application Proposed Milestones €2 Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
1.8
in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
1.4
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
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, Daha Fazla

in %bids___i_period_sub_35% gün içinde333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
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). Daha Fazla

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
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ñ Daha Fazla

in %bids___i_period_sub_35% gün içinde255%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
samihassen

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

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0