Lengkap

python or c# desktop app for comparing csv to master csv data

I have a master list of email addresses that we manage and I need to be able to compare a csv against that master list to see what the status is for each of the emails. I see the solution like this

we have 2 csv files

[login to view URL] - 3 columns of data (email, Status 1, Status 2)

[login to view URL] - 1 column (email)

each row in [login to view URL] will be looked up in master.csv. there are cases when an email will live more than 1 time in the master, in that case we get all of the matches for it, dedup, and concate to a single column. then for status 2 there are most cases where this empty

I would like an exe or cli method where i run it and give it both sheets and then it outputs a [login to view URL] file will all of the lookup results. the output of that file should be

email, found/not found, status 1, status 2

the master will need to be able to handle upwards of a million rows, the lookup csv will have 100-300K at its upper range.

you can assume windows 10 machine, lots of cores if you want to parallel the task, and plenty of memory (20gb free ram is np) if you want to load both sets of data to some B-tree or binary tree in memory or something like that.

when done we need some basic document on how the solution is structured and how to run it.

I have put this sample together for you to see what we need.

[login to view URL]

it covers each output file needed, the issue with duplicates as well as the issue of not found.

Kemahiran: Python, Pengaturcaraan C#

Lihat lagi: upload data csv file mysql, python web service app engine sample, countdown timer desktop app, source code export sql data csv file vb6, turn desktop app web app, import data csv file sql 2005, php script form data csv, search data csv excel vba, retrieve data csv file, using dts import data csv database, changing data csv file python, data csv python, create facebook desktop app python, python code convert binary data csv, example facebook desktop app python, grab data csv python, desktop app c#, desktop app c, mobile app , C# , desktop ,java, python - Loops, data, csv

Tentang Majikan:
( 456 ulasan ) Austin, United States

ID Projek: #21852841

Dianugerahkan kepada:

AutomationAdept

Hello! This should be very simple. Let me summarize the project in my own words to make sure I understand everything: There's a master csv and a lookup csv. In the master csv, there are 3 columns: email, status 1, an Lagi

$75 USD dalam sehari
(15 Ulasan)
5.2

31 pekerja bebas membida secara purata $150 untuk pekerjaan ini

sumon355

Hello, As an experienced C# developer, i am very much interested to provide you an EXE file to make processing you are looking for. Please let me know if you are interested in my bid. What is the size of the master Lagi

$98 USD dalam 2 hari
(138 Ulasan)
7.0
huangxiangyan

⭐How are you ?⭐ I have a detail look to your project, and I'm sure that I will complete your project surely. I am professional Software and website developer. My main skill is java, c#, c++, python, php and javascript. Lagi

$220 USD dalam 3 hari
(23 Ulasan)
5.9
valor312

VERY EASY FOR ME As you can see in my review, I've done similar with yours Hello. I have read your description and I am so interested in your project. I am confident in your project and I can finish it clearly on Lagi

$100 USD dalam sehari
(69 Ulasan)
6.1
naravila

⭐⭐⭐⭐⭐Dear clent! ✅I am very interested in your project and I am exciting. ✅I read your project details carefully and I thought that I am the best fit developer for your project. ✅I have rich experience with your projec Lagi

$200 USD dalam 2 hari
(14 Ulasan)
5.4
Yourn1freelancer

Hello, I read the description of the project and I can produce a nice, fast solution in C# (or python if needed). Please contact me if interested in my offer. Cheers, G

$127 USD dalam 3 hari
(5 Ulasan)
5.5
AlexanderPGR

hi nice to meet you i have read your requirement carefully and understood fully. in my opinion, we can use python pandas for checking your csv. pandas is powerful tool which can handle excel and csv files so if you giv Lagi

$140 USD dalam 7 hari
(19 Ulasan)
5.2
topexpert713

Hi, Nice to meet you! I have read your requirements carefully and I am very interesting for your project. I am confident of this project as I'm a professional Python expert with over 5 years of experience. It seems to Lagi

$140 USD dalam 7 hari
(26 Ulasan)
5.3
dineshmore

Hi Myself expert in Dot net technologies with 14 yrs of experience in software development. Developed various web and desktop based projects in Finance, Insurance, Research, Education , Research and Retail Domains. Lagi

$250 USD dalam 10 hari
(24 Ulasan)
5.2
ayeilyurt

Hello, I will use pandas and python for this project the compare your [login to view URL] to [login to view URL] file. The performance will be handled by parallel threads.

$200 USD dalam sehari
(10 Ulasan)
4.8
Assistant4me

Hello I am very professional in C# and I will develop it as multi-thread. Regarding the hardware you have, I can develop a fast program for you and will deliver it quickly. I have worked 14 years in this field and won' Lagi

$70 USD dalam sehari
(8 Ulasan)
4.5
ganeshrasekar

I can do it

$140 USD dalam 7 hari
(19 Ulasan)
4.7
shakiralimit9

Hello Sir, I have gone through your description and got a pretty much idea of what you want to do. I can assure you that I can do this task. My developed applications are light weight, faster and have rich UI. The ski Lagi

$140 USD dalam 7 hari
(8 Ulasan)
4.1
Stallone83

Hi I can generate the output csv file from those given csv files. I will use C# for this and will provide installer with full source code. Please let me know if you are interested. Thanks

$100 USD dalam 3 hari
(11 Ulasan)
3.6
sulemanmehm00d

Hi I think I got the point you mean, basically you want from 2 existing files a new file with all the emails from the look file and with additional column of "Found/Not Found" and the concatenation and distinction rul Lagi

$450 USD dalam 10 hari
(4 Ulasan)
3.3
AntoXa01

Hi I can create exe on .NET Framework It will be fast I need 2h to finish, can start immediately Regards, Anton

$30 USD dalam sehari
(11 Ulasan)
3.7
ThilinaG01

Hi, I can build a windows 10 application for this. please send me a message so that we can discuss more

$100 USD dalam 4 hari
(13 Ulasan)
3.3
TopDesign731

⭐⭐Hello. I'm a python developer. I am familiar in python scripts. Python is my main skill. I have done many python works successfully. I'm full stack developer and I have enough time. Thanks.

$100 USD dalam 7 hari
(5 Ulasan)
3.1
rayfigs

Hi, Dear Client. I read your requirements very carefully. In your project, the main problem is deal with large data and processing speed. I have experience to develop python program like your project. Regards.

$250 USD dalam 7 hari
(2 Ulasan)
2.8
liujianmin

Hello, Client. Nice to meet you. I saw your job description carefully and understood what you want I am so interested in your project and want to work with you, I am senior web developer with rich experience of python Lagi

$121 USD dalam sehari
(8 Ulasan)
2.9
staratnight

Hello, Sir. I read your opinion seriously. I have experience of 7 years and done similar projects before. As a man of trust, I can develop your website with full perfection. Let me go on, you can get the best project t Lagi

$120 USD dalam 2 hari
(8 Ulasan)
3.0