Tamamlanmış

Excel files merge with fuzzy match

We’d like to merge a main database with three (maybe 4) other databases based on a company’s name for each of the years 2005-2017.

The names are not identical across all databases.

For example- JPMorgan & company vs. J.P. Morgan investment.

There are cases with more than one match per company every year (for example, one parent company and few subsidiaries). In other cases there are no matches at all.

If the databases contain empty years, we ask to fill in the empty years. For example if there is data for a specific company in database #2 in 2007 and 2009 but empty in 2008, replicate 2007’s data into 2008 only in this database. Do the same in all cases.

Each database contains the name of the company and its ID number (a different ID number in each database). The goal is to create a merged database that contains the following columns each year. We attach a theoretical example below:

Year

Company name (as it appears) in main database

Company ID number in main database

Company ID number in database #2

Company ID number in database #3

Company ID number in database #4

(attached example of the desired target file).

Some firms have different names under the same ID at the same year (due to mergers or other reasons). Although the matching is based on the company’s name, we need the ID numbers. If 2 different names appear in the same database under the same ID number at the same year, refer to them as one company with the common ID.

Attached:

1. sample from one of the source DB's

2. example of desired output file after merging all the DB's.

The challenge in this project is to do heuristic/similarity search of the firms names (fuzzy search , spacy similarity, cosine similarity in python/vb/excel macro or any other methods).

Project budget - 100$.

Beceriler: Veri İşleme, Excel VBA, Excel Macros, Data Analysis, Data Cleansing

Daha fazlasını gör: merge excel files, create excel files mysql, create stand alone excel files, merge excel files delete duplicates, merge excel files download, mapbasic create excel files, merge excel files remove doubles, vbscript merge excel files, fuzzy logic project matlab source files, create excel files using, merge excel files remove data, remove duplicates merge excel files, script excel merge excel files, merge excel files using vbs, merge excel files duplicates, merge excel files remove duplicate, script merge different excel files excel file, create excel files php mysql, excel 2007 vba fuzzy match

İşveren Hakkında:
( 6 değerlendirme ) Modiin, Israel

Proje NO: #28315637

Seçilen:

dhanrajkarthick

Hi there, I can help you to get the desired result based on fuzzy lookup. I am a Microsoft Certified Professional. Awaiting your response. Regards, Karthick G.

%selectedBids___i_period_sub_7% gün içinde 150%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(34 Değerlendirme)
5.1

Bu iş için 20 freelancer ortalamada $104 teklif veriyor

sevillajk01

Hello! let me help you with your excel match project. I can help you cleanse the data accurately and with quality. Please feel free to message me for discussion. thanks!

$100 USD in 5 gün içinde
(37 Değerlendirme)
5.0
kingqueen369

Hi, Greetings! ✅checked your project details: Excel files merge with fuzzy match ✅Completed Time: 24 hours or your requirement deadline . I have 5 + years of the experience in same kind of projects. If you are looking Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(17 Değerlendirme)
4.2
zu02

Hi I'll do it via ms Access app. Is it acceptable for you? I'm Access/Excel/vba Expert from Georgia- full time freelancer. Please visit https://www.freelancer.com/u/zu02?w=f Here you can find feedback from one of my Daha Fazla

$100 USD in 2 gün içinde
(10 Değerlendirme)
4.1
Akib2020

✅ Expert on Advanced Excel ✅ Hi there! I’m expert on Advanced Excel, VBA, Macro, Complex Formula & Function, Compare/Combine Multiple Excel Sheet, Vlookup, Hlookup, Find, Array, Nested IF, Match, Index, Excel automatio Daha Fazla

$100 USD in 3 gün içinde
(28 Değerlendirme)
3.9
chintuag

Dear Hiring Manager, I will help in merging the database as required. would like to discuss the same in detail to have a clear understanding. I am an expert in Excel and macros and worked on several automation proj Daha Fazla

$109 USD in 5 gün içinde
(9 Değerlendirme)
3.8
nandu1290

Hello Sir I have gone through your project details. I am interested in this project. I am Excel expert. Please message me for more discussion. Will be waiting for your response. Thanks & Regards Nandu

$90 USD in 2 gün içinde
(10 Değerlendirme)
3.6
(3 Değerlendirme)
3.5
prasannjeetp

Hi, I can do this project. I have experience mergining databases using VBA. Please award the project to proceed further Thanks

$100 USD in 2 gün içinde
(31 Değerlendirme)
4.0
Sergiobusquets

Hi, bro! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with file processing using Excel macro. Everyone call me a "Prince of Excel". I promise I will finish th Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
3.0
AnuradhaVM

Hi, Greetings! ✅checked your project details. I have completed the M.SC. (Statistics) . I Have 4 years’ experience with Data entry, Data analysis and MIS Management. I have strong analysis, and Excel skills and am able Daha Fazla

$100 USD in 7 gün içinde
(5 Değerlendirme)
2.8
chnsci

Greetings, I think here you are looking for someone to work on Excel files merge with fuzzy match. I understood your project description. I am an expert in Data Processing, Excel VBA, Excel Macros, Data Cleansing, Daha Fazla

$100 USD in 3 gün içinde
(3 Değerlendirme)
2.1
setiaakanksha86

Dear Hiring Manager, I would like to express my interest in the Data Entry posting with you and pursue the opportunity to apply my expertise in the industry. When reviewing the job description, I was thrilled to disc Daha Fazla

$140 USD in 7 gün içinde
(0 Değerlendirme)
0.0
adeelhassan347

Hello! I'm a data entry expert and would love to merge 4 of your databases according to your given instruction. You can contact me for more details or to check out my previous work. Thanks!

$100 USD in 5 gün içinde
(0 Değerlendirme)
0.0
SaimaTajik

Dear Hiring Manager/Hello I’ve carefully gone through your job posting. I’m an expert in MS Excel with more than six years of experience. I am very much interested in your project with all of your requirements. If you Daha Fazla

$100 USD in 7 gün içinde
(0 Değerlendirme)
0.0
irhazimazhar

Hello and Hi, I’m data entry expert which is full time working as a freelancer. I’m expert with Microsoft Office products such as Words, Excel, PowerPoint and other software or application related to Data Entry. By o Daha Fazla

$200 USD in 7 gün içinde
(0 Değerlendirme)
0.0
bhargavissrl

Hi, I can start working on this right away. Ping me so we can talk further on what your specific requirements are. You can see my reviews. I have a fairly very good experience in Python. __ABOUT ME__ I have more than Daha Fazla

$80 USD in 6 gün içinde
(0 Değerlendirme)
0.0
jessdan86

I am a very meticulous person who gives careful consideration to information given and have a wealth of experience with Microsoft applications. I believe I can help you on this project and provide your results within a Daha Fazla

$90 USD in 3 gün içinde
(0 Değerlendirme)
0.0
ulmerm

Hey, I analyze data from different stock companys on spare time. I can help u out cleaning and merging your data. Kind regards Marius

$100 USD in 7 gün içinde
(0 Değerlendirme)
0.0
anizasri

Hi, I would love to work on your project to merge database into one Excel file. I will attentively prepare and update the file. I hope you will contact me to discuss further. I look forward to being worthwhile and wor Daha Fazla

$100 USD in 2 gün içinde
(0 Değerlendirme)
0.0