Completed

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.

Skills: Python, C# Programming

See more: 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

About the Employer:
( 456 reviews ) Austin, United States

Project ID: #21852841

Awarded to:

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 More

$75 USD in 1 day
(15 Reviews)
5.2

31 freelancers are bidding on average $150 for this job

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 More

$98 USD in 2 days
(138 Reviews)
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. More

$220 USD in 3 days
(23 Reviews)
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 More

$100 USD in 1 day
(69 Reviews)
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 More

$200 USD in 2 days
(14 Reviews)
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 in 3 days
(5 Reviews)
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 More

$140 USD in 7 days
(19 Reviews)
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 More

$140 USD in 7 days
(26 Reviews)
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. More

$250 USD in 10 days
(24 Reviews)
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 in 1 day
(10 Reviews)
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' More

$70 USD in 1 day
(8 Reviews)
4.5
ganeshrasekar

I can do it

$140 USD in 7 days
(19 Reviews)
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 More

$140 USD in 7 days
(8 Reviews)
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 in 3 days
(11 Reviews)
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 More

$450 USD in 10 days
(4 Reviews)
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 in 1 day
(11 Reviews)
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 in 4 days
(13 Reviews)
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 in 7 days
(5 Reviews)
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 in 7 days
(2 Reviews)
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 More

$121 USD in 1 day
(8 Reviews)
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 More

$120 USD in 2 days
(8 Reviews)
3.0