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.
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
20 freelance font une offre moyenne de $139 pour ce travail
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
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
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.
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
⭐⭐⭐⭐⭐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
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
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
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
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
Hi, I can build a windows 10 application for this. please send me a message so that we can discuss more
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
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
Hi I can create exe on .NET Framework It will be fast I need 2h to finish, can start immediately Regards, Anton
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
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!
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,
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
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. ｉ saw you have some basic knowledge about c Plus
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