Small program to compare .txt files

Fermé Publié le il y a 3 mois Paiement à la livraison
Fermé Paiement à la livraison

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]

Saisie de Données Python Traitement de Données

Nº du projet : #37476470

À propos du projet

40 propositions Projet à distance Actif il y a un mois

40 freelances font une offre moyenne de 115 $ pour ce travail

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 Plus

$180 USD en 3 jours
(506 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(131 Commentaires)
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 Plus

$140 USD en 7 jours
(55 Commentaires)
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 Plus

$100 USD en 2 jours
(11 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(15 Commentaires)
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 Plus

$180 USD en 7 jours
(1 Évaluation)
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 Plus

$30 USD en 2 jours
(2 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(6 Commentaires)
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 Plus

$50 USD en 3 jours
(2 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
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 Plus

$100 USD en 7 jours
(3 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
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 Plus

$50 USD en 2 jours
(2 Commentaires)
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 Plus

$140 USD en 7 jours
(1 Évaluation)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
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 Plus

$30 USD en 2 jours
(0 Commentaires)
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 Plus

$140 USD en 7 jours
(0 Commentaires)
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 Plus

$140 USD en 7 jours
(0 Commentaires)
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 Plus

$200 USD en 7 jours
(0 Commentaires)
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 Plus

$140 USD en 7 jours
(1 Évaluation)
0.0