In Bearbeitung

Merge Data in CSV using Script $$$

***Do NOT bid on this project until you read the details CAREFULLY. Otherwise, I will mark the bid as spam. ***

I need someone to create a script/program/etc. to perform a data merge operation for me.

I have a CSV file that is 1.5GB with 4 million rows of data. I need to merge rows together based on a set of conditions.

Because of the file size, I cannot open it with Excel and breaking it into groups of 1 million is not an option.

Open the attached Excel file so that you can see a BEFORE shot of how my data looks as well as an AFTER shot of how I want it to look once completed.

Condition 1

If the Phone and URL are the same as another records Phone and URL… AND fields First, Last, and Email are blank, copy data from any other record with a matching Phone and URL.

Goal: The goal of this tasks is to ensure that there are no records that have a blank First and Last name if another record exist with the same Phone and URL. (Later, I will run another program that will remove the duplicate row. I do not want to do that now unless it is a requirement.

Condition 2

If the URL is the same as another records URL… and the email address is info@ and there is only 1 record with a First name (and blank email with that First name), copy the info@ email address to the record WITH a First and Last name.

Goal: The goal here is to assign the info@ email account to a name. Most of my records are small businesses and the info@ should go to the contact I have on file.

My ultimate goal is to merge data together so that I can remove records that do not provide any new (non-duplicate) data. Meaning, if I have two records that have the same data, I will purge it using another merging software that I have.

NOTE: My tab delimiter is currently a ^ instead of a comma. The reason is because I am using another program for another portion of the merge and commas have caused issues but ^ does not.

If you can help me accomplish this task, add the following line above your bid…

I have read the details in full and reviewed the Excel file.

Give me an idea of how you will accomplish this tasks. You can tell me in private message.

Let me know of any questions that you have.

Although there are other fields, I do not need those copied over – just the fields we have mentioned. The other program will take care of that.

NOTE: I will be away Friday - Sunday afternoon. If you have a working solution, show me or send it to me and that will greatly help me in selecting you. I will respond to messages once I return for any messages sent Friday - Sunday.

I cannot provide the CSV file. Only a sample.

Fähigkeiten: .NET, Excel VBA, Java, Perl, Python

Mehr sehen: merge csv files command line, merge csv files online, merge csv files ubuntu, merge csv files linux, merge csv files without header, combine multiple csv files into one excel workbook, merge csv files mac, csv merge tool, parse text file data csv ruby script, mysql export view data csv shell script, import text data excel using script, save html form data csv java script, data csv file mysql database using aspnet, data txt csv using, export database csv using php script

Über den Arbeitgeber:
( 46 Bewertungen ) Lexington, United States

Projekt-ID: #15493303

Vergeben an:

zu02

p.s. so if I awarded then you have send me this csv zipped and with ms Access I can merge rows etc and to export that to Excel -- but that will be a GUI , so you'll have buttons to export result file to Excel with ask Mehr

$225 USD in 5 Tagen
(3 Bewertungen)
2.8

16 Freelancer bieten im Durchschnitt $213 für diesen Job

liangjongai

Hi, sir I have looked your requirements and I get what u want. I think this program should be made by c/c++ or c# for performance. My price and period is negotiable We can discuss the details via chat Relevant Skills Mehr

$222 USD in 3 Tagen
(146 Bewertungen)
6.4
$140 USD in 3 Tagen
(69 Bewertungen)
5.9
wassily

I have read the details in full and reviewed the Excel file. My bid stands for a command line application in C# (.NET) running like: [url removed, login to view] <csv-file> [delimiter-char] Relevant Skills and Experience C# P Mehr

$100 USD in 2 Tagen
(5 Bewertungen)
5.2
$555 USD in 3 Tagen
(12 Bewertungen)
4.2
anuragiitk

I am an IITK graduate and I have 9 years of experience in software development. I have 100% completion rate and I have finished all the projects with the highest level of customer satisfaction. Relevant Skills and Exp Mehr

$155 USD in 3 Tagen
(20 Bewertungen)
5.4
NayaPakistan

Hello, I have read the details in full and reviewed the Excel file. Relevant Skills and Experience Expert in Data Processing Proposed Milestones $250 USD - Default Do you want the script or just the new merged file?

$250 USD in 3 Tagen
(11 Bewertungen)
3.7
vmadhavan15

I have gone throw your entire message and I hope I can do this one. but one quick question can you provide few lines from the CSV file that will understand how the data is actully coming, so I can do Relevant Skills a Mehr

$250 USD in 5 Tagen
(9 Bewertungen)
4.0
carlosperezit

hi there if you need to manahe large amount of data i suggest you to use a database instead of a file or excel what i can do is to load thw data in a sql server and apply then the rules that you sent.. if you wabt i c Mehr

$222 USD in 5 Tagen
(11 Bewertungen)
3.9
$222 USD in 3 Tagen
(1 Bewertung)
3.4
sun0815

I have read the details in full and reviewed the Excel file. Hello,client. I have built many scripts for parse excel and csv files. Relevant Skills and Experience They are all similar to your files. Because these are Mehr

$222 USD in 1 Tag
(1 Bewertung)
3.2
shihan033010

I have read the details full and reviewed the excel file. I can compete the functionality using php script with arrays. Please allow me to start the project. accept the bid and create the milestone. Regards SHIH Mehr

$200 USD in 3 Tagen
(7 Bewertungen)
2.5
rumarahman

I have read the details in full and reviewed the Excel file. Relevant Skills and Experience Web Search Web Scrapping Excel Data Processing Data Collecting (Using Macro) VBA Mathematics Excel VBA Macro Mehr

$200 USD in 3 Tagen
(1 Bewertung)
2.1
gopiande

I have read the details in full and reviewed the Excel file. I am planing to write some java or python program to solve this problem. Relevant Skills and Experience I feel Hashmaps concept work for both conditions. So Mehr

$140 USD in 7 Tagen
(3 Bewertungen)
1.6
brianconey

Hello How are you this is very big data . I can treat big data with php No problem Relevant Skills and Experience PHP Proposed Milestones $155 USD - price of project

$155 USD in 3 Tagen
(0 Bewertungen)
0.0
bouslimi1979

I have read the details in full and reviewed the Excel file. I was thinking about doing this jointure using Acces and sql requests than using Excel. Expérience et Compétences appropriées Excel/VBA Access Étapes Mehr

$150 USD in 5 Tagen
(0 Bewertungen)
0.0