Combination of 2 CSV tables
There is a large table (950 thousand lines) in one CSV file
There is also a small table (approximately 200 thousand lines) in the second file
Both tables have 2 identical columns, as well as the third column that is absent in the main large table.
It is necessary to add values from the third column to the main big table when values from two columns of one sheet coincide with the other sheet.
It is important that the solution works quickly with such a large amount of data (not more than an hour for the whole task). The coincidence can be only 1 for the entire table (if you have added one time to one cell, then you do not need to make a further search)
We have a fairly confidential base, so there will be a few positions for the test. We should be able to add the remaining lines ourselves and make a turnover.
Excel does not offer, it performs this function for 3 days.
Client's review of cooperation with Vladislav N.
Combination of 2 CSV tablesThank you very much for your help, the program works perfectly!
Freelancer's review of cooperation with Ivan Petrov
Combination of 2 CSV tablesClear and fast receipt of results. Thank you for cooperation!
-
366 25 1 Hello to you. Ready to perform within a few hours. I have done a similar task recently.
Examples of work see in the portfolio.
-
378 85 3 6 Good day, I can implement such a program, throw tables samples for testing
-
726 21 0 Good morning, I am interested in your task, I propose a solution on Python. The decision is ready immediately after the details are found.
-
5894 345 0 I can scroll a simple application under Windows, no Excel, but first you need to look at the structures of both files (change the data on what happened, it's important that the structure)... What the lists in them are such...
-
6055 284 0 Good day . I write a program under Windows - it will work very quickly (on such volumes it should take a few minutes). I do today. You need examples of both files.
-
Приложите файлы, и дело ускорится...
-
Скажите пожалуйста:
это новый проект или продолжение (переделка) этого
https://freelancehunt.com/project/microsoft-excel-sravnenie-perenos/1083131.html
? -
Current freelance projects in the category Desktop Apps
Add pauses of 10-30 seconds between sending emails.Hello! I am looking for an experienced 1C / BAS (BAF) programmer to promptly resolve a technical issue with email distribution.Problem essence: We use the accounting program BAF (Business Automation Framework), version 2.0. Once a month, there is a need to send about 300 emails… Web Programming, Desktop Apps ∙ 2 days 12 hours back ∙ 10 proposals |
Reverse engineering of console utilities for querying SSD controllers (Flash ID)1. Purpose of the work Extraction of the application programming interface (API) for interaction with SSD/NVMe controllers from the provided set of console utilities (Phison, Silicon Motion, Realtek, Maxiotek, Marvell, JMicron, etc.). The result should be working code in C/C++… C & C++, Desktop Apps ∙ 2 days 23 hours back ∙ 5 proposals |
Modification in the emulator's operation
45 USD
Hello. I downloaded the Gaminator CF Final slot machine emulator from the Internet. I really liked it, but there are some issues. There is an admin panel, but it opens freely and cannot be closed at all. It only closes along with the application. Also, the data does not save… Desktop Apps ∙ 10 days 13 hours back ∙ 10 proposals |