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%
(43 Değerlendirme)
5.4

Bu iş için 28 freelancer ortalamada €388 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%
(272 Değerlendirme)
7.1
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%
(198 Değerlendirme)
6.7
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%
(31 Değerlendirme)
5.4
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
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%
(15 Değerlendirme)
5.0
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%
(11 Değerlendirme)
4.4
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
sumonahmed1122

Dear Sir, Cordial greetings from self side! Sir with due to respect and humble i would like to inform you that i want do this job with less price, if you select me. Thank you with regards! Relevant Skills and Expe Daha Fazla

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 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
shubhamj1995

I have good knowledge of Python which I will be using for this project. Contact if you have any query Relevant Skills and Experience Python, Data Cleaning Proposed Milestones €250 EUR - After work completion

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
0.3
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 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
athminteam

We have experience of more than 5 years in this field. Together we can finish your project. Relevant Skills and Experience We deal in Data Processing, Excel, SQL, Web [login to view URL] believe only in quality work. Building 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
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 Daha Fazla

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

in %bids___i_period_sub_35% gün içinde444%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
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