Screenshots of Maping
Example of data in the source file is https://docs.google.com/spreadsheets/d/1lQCAop1wJlWd-C_QGJt-6RfRpeFqKPgCN7qiSeWlIL8/edit?usp=sharing
Examples of the algorithm of work with data from the file:
1 .Take url_id_vbr = 1, it is attached to 30 frazes/id
2ndThe task is to find in the url_banki column, the url to which the largest call-to phrase/id phrase attached to url_id_vbr = 1 and assign to that url (all of this url) in the mapping_url_id column, id = 1
We then take url_id_vbr = 2, we find in the url_banki column, the url to which the largest call-to-frase/id phrase attached to url_id_vbr = 2 and assign to that url in the mapping_url_id column, id = 2
and so on.If in step 2, in the url_banki column the chosen url already stands the value in the mapping_url_id column, then we do not re-writ this value in it, but add the new through the scratch without a gap - 1.2,3
The original file can be several hundred thousand lines, usually about 100,000.
In the application, write what the implementation is planned
Client's review of cooperation with Andrey Ganotsky
Screenshots of MapingAndrei fulfilled the task in the framework of the described tz. pleasant in communication.
![]()
Freelancer's review of cooperation with client
Screenshots of MapingEverything is great.
It is detailed and understandable.
Operational coordination of working moments
I recommend it.
-
1213 70 0 1 Everything is clear.
Ready to perform.
Application under Windows.
The language is Delphi.
Data download is a XLSX file.
The result is either in this file or in a copy.
Go back (it’s already ready)
-
1141 37 3 3 Hello, the algorithm is simple, the question is where to enter that script, it will be on the server or anyway in which language?
Current freelance projects in the category Desktop Apps
Small edit on the website
16 USD
Need to update the offer agreement in the footer to a new one, the company has changed its regulations Task will take 20 minutes Web Programming, Desktop Apps ∙ 14 hours 5 minutes back ∙ 94 proposals |
Account reconciliation tool with the bank, cards, and accountantTechnical Assignment: Tool for Reconciling Accounts with Bank, Cards, and AccountantGeneral Goal A local tool (script/small application in Python) is needed, which is manually run once every 1-2 months on my computer and performs reconciliation between: Invoices I issued to… Python, Desktop Apps ∙ 2 days 21 hours back ∙ 42 proposals |
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 ∙ 8 days 13 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 ∙ 9 days back ∙ 6 proposals |