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.

Taidot: Python, C# -ohjelmointi

Näytä lisää: 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

Tietoa työnantajasta:
( 456 arvostelua ) Austin, United States

Projektin tunnus: #21852841

Myönnetty käyttäjälle:


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 Lisää

$75 USD 1 päivässä
(15 Arvostelua)

31 freelanceria on tarjonnut keskimäärin 150$ tähän työhön


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 Lisää

$98 USD 2 päivässä
(138 arvostelua)

⭐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. Lisää

$220 USD 3 päivässä
(23 arvostelua)

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 Lisää

$100 USD 1 päivässä
(69 arvostelua)

⭐⭐⭐⭐⭐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 Lisää

$200 USD 2 päivässä
(14 arvostelua)

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 3 päivässä
(5 arvostelua)

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 Lisää

$140 USD 7 päivässä
(19 arvostelua)

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 Lisää

$140 USD 7 päivässä
(26 arvostelua)

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. Lisää

$250 USD 10 päivässä
(24 arvostelua)

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 1 päivässä
(10 arvostelua)

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' Lisää

$70 USD 1 päivässä
(8 arvostelua)

I can do it

$140 USD 7 päivässä
(19 arvostelua)

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 Lisää

$140 USD 7 päivässä
(8 arvostelua)

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 3 päivässä
(11 arvostelua)

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 Lisää

$450 USD 10 päivässä
(4 arvostelua)

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

$30 USD 1 päivässä
(11 arvostelua)

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

$100 USD 4 päivässä
(13 arvostelua)

⭐⭐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 7 päivässä
(5 arvostelua)

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 7 päivässä
(2 arvostelua)

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 Lisää

$121 USD 1 päivässä
(8 arvostelua)

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 Lisää

$120 USD 2 päivässä
(8 arvostelua)