Small program to compare .txt files

Kapalı İlan edilme: 3 ay önce Teslim sırasında ödenir
Kapalı Teslim sırasında ödenir

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]

Veri Girişi Python Veri İşleme

Proje NO: #37476470

Proje hakkında

40 teklif Uzak proje Aktif 2 ay önce

Bu iş için 40 freelancer ortalamada $115 teklif veriyor

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 Daha Fazla

$180 USD in 3 gün içinde
(506 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(131 Değerlendirme)
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 Daha Fazla

$140 USD in 7 gün içinde
(55 Değerlendirme)
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 Daha Fazla

$100 USD in 2 gün içinde
(11 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(15 Değerlendirme)
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 Daha Fazla

$180 USD in 7 gün içinde
(1 Yorum)
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 Daha Fazla

$30 USD in 2 gün içinde
(2 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(6 Değerlendirme)
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 Daha Fazla

$50 USD in 3 gün içinde
(2 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
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 Daha Fazla

$100 USD in 7 gün içinde
(3 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
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 Daha Fazla

$50 USD in 2 gün içinde
(2 Değerlendirme)
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 Daha Fazla

$140 USD in 7 gün içinde
(1 Yorum)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
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 Daha Fazla

$30 USD in 2 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$140 USD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$140 USD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$200 USD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$140 USD in 7 gün içinde
(1 Yorum)
0.0