Terminé

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.

Compétences : Python, Programmation C#

en voir plus : 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

Concernant l'employeur :
( 463 commentaires ) Austin, United States

Nº du projet : #21852841

Décerné à:

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 Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(17 Commentaires)
5.3

20 freelance font une offre moyenne de $139 pour ce travail

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(148 Commentaires)
7.1
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 Plus

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

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(7 Commentaires)
5.6
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(15 Commentaires)
5.4
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(20 Commentaires)
5.2
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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(29 Commentaires)
5.3
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' Plus

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(9 Commentaires)
4.2
ThilinaG01

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(16 Commentaires)
4.2
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(19 Commentaires)
4.1
umairkaramat24

Hello There. How are you doing?. I have read the description, I have great experience doing similar jobs related to these skills C# Programming, Python. Please start the chat so we can have detailed discussion. Thanks. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(7 Commentaires)
4.0
AntoXa01

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

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(4 Commentaires)
3.3
tharealist1990

I would use the openpyxl library to complete this task. Architecture would depend on pricing, but a simple script should get the job done and for a fair price!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)
1.1
arunprasathpgs

I Implemented similar excel and csv file processing with huge records,it uses less memory and time,i developed it for one of my client project, this looks similar ,i can implement it with best performance and quality,

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
mshoaibpk

I have read your description and I am interested to do a project for you. Steps to complete this project 1. First Create a desktop application that will take an excel file as input. 2. Process this file according to y Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
wo1211

i look through what you needs and think python script might be the best solution for you. 1. python have enough modules to handle numbers and files whatever needs you have 2. i saw you have some basic knowledge about c Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
syedhamzag

Hi there, I understand your point you need to compare two sheet and want to check email address has more than one record then concatenate the that. You need a professional developer for complete this task surely. I Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
0.0