Suljettu

Firms databases join

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

Taidot: Tietojenkäsittely, Python, Data Cleansing, Excel VB Capabilities, Data Extraction

Näytä lisää: barter matching engine free join business, assign specific method payment especific product zen cart, html forms attached databases rsvp, decryption method access databases, magento force specific shipping method, send igmpv3 join specific source using iperf, bb bgnjkòwww search ask com gct hp&o apn10644a&qrsc 2871&l dis&sver 3&apnptnrs ag5&dateofinstall 2015 08 01&d 533796&v 1.1 7, http www search ask com gct hp&o apn10644a&qrsc 2871&l dis&sver 3&apn_ptnrs ag5&dateofinstall 2015 04 07&d 533_257&v 1.1 _675, We have an existing app (see attached PDF) that needs a matching website roughly like the attached website proposal., We have an existing app (see attached PDF) that needs a matching website roughly like the attached website proposal, fake objects respond with specific data for each method, do law firms ask for official transcripts, how to ask someone to join your team examples, some specific examples of things people can do to practice electricity safety, questions to ask about databases, woocommerce: disable payment method for specific category, magento 1 create custom payment method, how to ask someone to join your group, what happens when you ask to join a group on facebook, what is the method name to fetch specific data for a entity from database in repository class?

Tietoa työnantajasta:
( 6 arvostelua ) Modiin, Israel

Projektin tunnus: #27982506

15 freelanceria on tarjonnut keskimäärin $93 tähän työhön

(20 arvostelua)
5.2
writingapp

Hi. I have written many automation Database, Excel projects. Ready to write your project. Will complete within 2 days

$95 USD 2 päivässä
(51 arvostelua)
5.2
narsim3128

NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. I CAN COMPLETE THIS TASK IN QUICK TIME. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT expe Lisää

$100 USD 4 päivässä
(9 arvostelua)
3.9
sujon214

Sir, I have 7 years experience in this relevant task. I am a professional freelancer. I will do your task within your budget. So you can select me as a right freelancer. Please hire me. Thanks

$30 USD 2 päivässä
(8 arvostelua)
3.4
kayarshadi

Hi, Dear Employer I could apply fuzzy matching. I am an Excel , Access, VBA , Power BI expert. I have good experiences in T-SQL and designing and implementation Information Systems in MS Sharepoint. Please tell me more Lisää

$70 USD 3 päivässä
(8 arvostelua)
3.3
(5 arvostelua)
2.9
ZaidMoh

I can complete the job within a week, details expiation will be much appreciated fee would be 200$ for completing the job

$56 USD 7 päivässä
(0 arvostelua)
0.0
nyarOnyari

Hello, I have read your project description about Database Design. I am an expert in database systems and I have developed many database systems including but not limited to a database system for a School, County Burs Lisää

$100 USD 1 päivässä
(0 arvostelua)
0.0
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. Lisää

$80 USD 3 päivässä
(0 arvostelua)
0.0
royoamy0515

Hi, Hope you have a safe and wonderful day! I have seen the attached documents and I would like to propose $72 rate for this task to be completed in 3 days or less depending on the volume of data within 2005-2017. I Lisää

$55 USD 3 päivässä
(0 arvostelua)
0.0
Tonyspychenko

Hi! I have read your requirement very carefully and understood wht you want. For over 8 years, I have developed many Python, Data Processing projects. I am glad to bid to you about one of my major skills. I can work w Lisää

$150 USD 2 päivässä
(0 arvostelua)
0.0
simpliumgroup

Hi, I have more than 11 years of experience in BI and Analytics with expertise in Tableau, Qlik, Power BI, Web Development, Web Maintenance, Content Management, Data Entry and SQL platform (development and maintenance Lisää

$67 USD 1 päivässä
(0 arvostelua)
0.0
himanshikhatuja

Hello, my name is Himanshi khatuja. I am a dedicated and hard working person who believes in honesty and good working relation. Though i am new at this sector of job but i have certain qualities which makes me good at Lisää

$30 USD 5 päivässä
(0 arvostelua)
0.0
anpilogovfree

Hello! As a database expert, I can complete your project successfully as soon as possible. I can even make script for faster processing. Hope to work with you. Best regards

$100 USD 2 päivässä
(0 arvostelua)
0.0
SSPshiva

1) “I can complete your project on time and within your budget.” 2) “I have worked. ... 3) “I can achieve the results that you are asking for.” 4) “I have attached samples of work very similar to what you are seeking.” Lisää

$140 USD 5 päivässä
(0 arvostelua)
0.0