Excel database files merge

Lukket Opslået 3 år siden Betalt ved levering
Lukket Betalt ved levering

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$.

Databehandling Excel VB Capabilities Excel Macros Data Analysis Excel VBA

Projekt ID: #28121234

Om projektet

35 bud Remote projekt Aktiv 3 år siden

35 freelancere byder i gennemsnit $117 timen for dette job

schoudhary1553

Hi, Greetings! ✅checked your project details: Excel database files merge ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If yo Flere

$100 USD in 4 dage
(276 bedømmelser)
8.0
ShakeelASESE

Excel Formula, Advance Excel, Excel VBA, Excel Power Query, Excel Integration, Excel Macro, Excel Data Entry, Excel Data Scrapping, Excel Dashboard and API Integration, Excel financial models, Excel Flow Chart, Excel C Flere

$350 USD in 7 dage
(51 bedømmelser)
5.8
swarnali2017

Hi, I am Swarnali, available online more than 16 hours everyday. I have read your project details. Recently, I have completed the excel formula, google sheet script and excel VBA macro based projects (see in portfoli Flere

$90 USD in 4 dage
(27 bedømmelser)
5.4
reubengi

Hi there, I can assist in cleaning up your database and get into the output format you want. How many records are there in each database? Regards Reuben

$100 USD in 5 dage
(18 bedømmelser)
4.9
ARTICLEYOUWANT

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

$200 USD in 7 dage
(8 bedømmelser)
4.7
hdlong66

Hello, I have prepared a sample for your review and comment. I can't automate a process but I have a solution for this. Could you please share all your files? Please drop a PM if you’re interested. Best regards, Hoang

$100 USD in 7 dage
(37 bedømmelser)
4.7
dpune

Hi, l have more than 14 years of experience and completed more than 300 projects. please look at my feedbacks to know more about me. thanks.

$100 USD in 5 dage
(22 bedømmelser)
4.8
zu02

Hi there! I'm Access/Excel/vba Expert from Georgia- full time freelancer. I can code this merging process via MS Access APP. You will be very happy. Please visit https://www.freelancer.com/u/zu02?w=f Here you can fin Flere

$100 USD in 2 dage
(11 bedømmelser)
4.3
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 Flere

$100 USD in 7 dage
(26 bedømmelser)
4.2
Jayant222

I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to per Flere

$80 USD på 1 dag
(11 bedømmelser)
3.8
adilsyed123

ok sure i can marge data base as you want i have check attachment files pls PM me can we discuss more ill do sample first wait for reply thanks.

$167 USD på 1 dag
(5 bedømmelser)
2.4
chnsci

Greetings, I think here you are looking for someone to merge a main database with three to four other databases. I have seen the attached file and understood your project description. I am an expert in Data Process Flere

$100 USD in 5 dage
(3 bedømmelser)
2.1
sadikkhan491

Hi there, I can start to work immediately. INBOX ME FOR SAMPLE I have just read your project description and I can help you with my experiences. I am able to work on your timezone. I did this kind of project before. Flere

$75 USD på 1 dag
(1 bedømmelse)
1.8
ZyedMezzi

Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be my great pleasure to work on your project. I have checked your requirement, yes I can do it, because I already work on simila Flere

$140 USD in 7 dage
(0 bedømmelser)
0.0
umairmusakhan

Excel Formula, Advance Excel, Excel VBA, Excel Power Query, Excel Integration, Excel Macro, Excel Data Entry, Excel Data Scrapping, Excel Dashboard and API Integration, Excel financial models, Excel Flow Chart, Excel C Flere

$60 USD in 2 dage
(0 bedømmelser)
0.0
Nandipu

Ready to work. Your project will be delivered within given time with accuracy. I have knowledge in Excel for 8 years.

$111 USD in 2 dage
(0 bedømmelser)
0.0
KhizraQamar

I am a senior accountant in UAE with over 9 years of work experience. I am confident about my abilities of doing any task with 100% accuracy and can exceed any one's expectations. Kindly give me a chance. I assure you Flere

$100 USD in 7 dage
(0 bedømmelser)
0.0
MahmoudEssam14

Hello Sir, My name is Mahmoud Essam. Recently, I started to work as Data Analyst. I work through many projects through my courses studying. I am able to do data analysis process from raw data collection till final com Flere

$50 USD på 1 dag
(0 bedømmelser)
0.6
IRUNGOVEL

i have enough experience normally i do this type of job japan customer I have skills on VBA Programming

$120 USD in 7 dage
(0 bedømmelser)
0.0
capnasrahmed

Hey, I've got 2 years of experience in data analysis, and in dealing with Excel, I can do as soon as possible ,need more details.

$140 USD in 7 dage
(0 bedømmelser)
0.0