Small program to compare .txt files

Suljettu Julkaistu 3 kuukautta sitten Maksettu toimituksen yhteydessä
Suljettu Maksettu toimituksen yhteydessä

I have 2 .txt files, they are aproximately 10 Million rows each; they have 15 columns and no headers; each column is separated by the "|" character.

The program in comparin real estate data where column 0 is region, column 1 is city and column 2 is a plt identifier.

I need a program that creates a new column with a key composed of the concatenated info form Col 0, Col 1 and Col 2; and then to compare the keys from both files in order to know which rown exist in file 1 but not file 2. They idea is to recognizer wich prots were eliminated from DB1 to DB2.

You may download the files "DB1" and "DB2", and i need to know wich rows exist in "DB1" but not in "DB2".

The program needs to run fast and take no longer than 2 hrs to comlpete the task. Outout should be excel file with all rows that exist in DB1 and not DB2

DB download: [login to view URL]

Tiedonsyöttö Python Tietojenkäsittely

Projektin tunnus: #37476470

Tietoa projektista

40 ehdotusta Etäprojekti Aktiivinen kuukausi sitten

40 freelanceria on tarjonnut keskimäärin $115 tähän työhön

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Lisää

$180 USD 3 päivässä
(506 arvostelua)
8.4
marfan080

I understand that you need a program that compares .txt files to create a new column with information from Col 0, Col 1 and Col 2 that can then be used to compare the keys from both files in order to identify which row Lisää

$99 USD 1 päivässä
(131 arvostelua)
5.4
iffi37

I understand that you are looking for a program that compares two .txt files, and I believe I am the perfect fit for this project. With my extensive experience in data processing and programming, I am confident that I Lisää

$140 USD 7 päivässä
(55 arvostelua)
5.3
AnjaliMehta

Hi There! I have understood the requirements for the task. I have 6+ years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot tabl Lisää

$100 USD 2 päivässä
(11 arvostelua)
4.8
vuyiswankosi

Greetings. I will be able to complete the task in 1 day and I am available to begin immediatley. I have substantial experience with big data searching and indexing tasks so I can say with certainty that I can complete Lisää

$80 USD 1 päivässä
(15 arvostelua)
4.5
matijamic

Hello there! My name is Matija and I am an expert in web programming and application development. With a high level of expertise in creating dynamic websites using HTML, JavaScript and PHP, I can create interactive and Lisää

$180 USD 7 päivässä
(1 arvostelu)
3.6
mwikalicarolyne2

Hi Sebastián H., Good morning I have read the project description, and I am convinced that I am the best person to help you. I have skills in Python, Data Entry and Data Processing. I have worked in many projects s Lisää

$30 USD 2 päivässä
(2 arvostelua)
3.3
saim2105

My name is Saim and I am a Python developer with extensive experience in software development. I understand that you are looking for a program that creates a new column with a key composed of the concatenated informati Lisää

$80 USD 1 päivässä
(6 arvostelua)
3.1
hotantai0902

hello, how are you? I'm interested to discuss more about your project after reading your description. I am Program developer with 7 years of experience. I have many experiences working on similar projects such as data Lisää

$50 USD 3 päivässä
(2 arvostelua)
3.4
Anujsp

Hello, I have checked the given link. We can even settle down at ****** 25$ ********** I will efficiently fulfill your data comparison needs by proposing the creation of a Python script utilizing Pandas for swift an Lisää

$30 USD 1 päivässä
(1 arvostelu)
1.8
DavidNimo

Hola mi nombre es Carlos David Nimo y me tomo el atrevimiento de escribir en español dado que tu perfil dice q eres de Chile. Soy ingeniero en telecomunicaciones y tengo amplia experiencia en python. Creo estar 100% ca Lisää

$100 USD 7 päivässä
(3 arvostelua)
1.9
Mdrop

Hello there! My name is Silvanus and I am an experienced Full Stack Developer with a robust background in frontend and backend technologies. I understand that you are looking for a program that compares .txt files. I w Lisää

$140 USD 1 päivässä
(2 arvostelua)
1.2
mikaelarhelger

Hello Sebastian, I'm interested in assisting with your task of comparing two large .txt files containing real estate data. To ensure efficiency, I would write a Python script to perform this operation. However, before Lisää

$50 USD 2 päivässä
(2 arvostelua)
1.2
paulbasht

Hi, Hoping you doing well. I'm glad to submit my proposal for your project. I have 5 years of experience with developing Python project. I have developed Data mining and Web Scraping programs. And also I have honed ope Lisää

$140 USD 7 päivässä
(1 arvostelu)
1.2
wilfrednjorog

Hey! I am always on the lookout for new and exciting projects that challenge my skills and push me to bring my best to the table. Your Small program to compare .txt files is exactly the type of project that sparks m Lisää

$155 USD 1 päivässä
(2 arvostelua)
0.6
joaovbb1994

Hey Mate Sebastián H., Good morning! I am professional mobile developer with skills including Python, Data Entry and Data Processing. "DB2" Please send a message to discuss more about this project. Appreciate your Lisää

$30 USD 2 päivässä
(0 arvostelua)
0.0
Yevgeny1977

I am Евгений, a technology freelancer with many different skill sets. I have been working with programming, databases and networks for over 20 years. I have completed many design and development projects for companies Lisää

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

I understand that you are looking for a program that compares .txt files and creates a new column with a key composed of the concatenated information from Col 0, Col 1 and Col 2. My team has experience in developing Re Lisää

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

Hello there! My name is Ahmed and I'm excited to help you with your project. I understand that you need a program that creates a new column with a key composed of the concatenated info form Col 0, Col 1 and Col 2; and Lisää

$200 USD 7 päivässä
(0 arvostelua)
0.0
GameOfWords

I understand you are looking for a program that compares .txt files and creates a new column with information from Col 0, Col 1 and Col 2 so that you can compare the keys from both files in order to know which rows exi Lisää

$140 USD 7 päivässä
(1 arvostelu)
0.0