Write a script to compare lines (all logic is drawn into tz)
15 USD At the beginning of the code, remove the following variables:
Method of calculation of weight (A or 😎
A = ( the order number of the letter in the alphabet * the order of this letter in the word + the rest of the letters in the cell similar ) * on the coeff 1 cell in the line + 2 cell and so on
B = ( the order number of the letter in the alphabet + the rest of the letters in the cell similarly ) * on the coeff 1 cell in a line + 2 cell, etc
2) Percentage of similarity
Less than 20 percent
in the bigger 20 %
Examples of filling 20–20 , 10--0, 0–20
3) coefficients-priorities of cells (e.g. 0–999–9–40–60)
This means
0 coeff (forgetting this cell, not calculating its weight)
2 cells in a line weigh the highest (999), 3 cells the lowest (9)
Variable debug true/false
if true then add columns with the weight of both matched lines to the output file.
If false, exclude the data.
The main actions of the program:
* Download input files to compare
* Formatting by leaving only numbers, letters and gap
* Go through each line and calculate the weight based on the data indicated at the beginning (data not to ask every time, but to read from the variables that are indicated in the code at the beginning)
It is counted as 11
Null as 10
* The weight of each line of the first file to compare with the weight of each line of the second file and leave only those lines that matched by weight in the specified transition (from the example it is 20% on both sides, but there may be settings 0-20 or 20-0 that allow only the bigger or smaller side)
For example
1 inches file 2 lines with a weight of each 100 and 200
2 inches file 3 lines with the weight of lines 50 170 220
Coefficient is 0.2 (20%) on both sides.
If 1 line of the first file coincides with one in the second, then in the second file the cells weight should be in the range of 80 to 120.
And if the 2 lines of the file coincide with any in the second, then in the second file the cells weight should be in the range of 160 to 240
from the example matching one line of the first file with two lines of the second file
2 lines 1 file and 2 lines 2 files
2 lines 1 file and 3 lines 2 files
* Save in the output file the two lines next to which coincide by adding a column with weight and the first and second if the parameters are dubug = true
and dop column with the parameter one coincidence or several coincidences
“One coincidence” or “more than one”
Client's review of cooperation with Mykhailo P.
Write a script to compare lines (all logic is drawn into tz)He managed the task well. The code is clear and understandable. I recommend !
Freelancer's review of cooperation with Aleksandr Ivankov
Write a script to compare lines (all logic is drawn into tz)A great customer.
I do not work with him for the first time. Payment, contact, and the task is all well!
-
Winning proposal2 days15 USD
4154 123 0 Winning proposal2 days15 USD
I met the task, everything is clear. I do it quickly and quality.
Current freelance projects in the category Python
It is necessary to develop the backend for the website.
178 USD
Need to develop the backend for the website, the frontend has already been done in Lovable.dev. Functionality: License system What should work: I create (or issue after payment) a license key to the user. The user activates the license on the site. The license is tied to the… Python, Web Programming ∙ 31 minutes back ∙ 36 proposals |
AI Commenting Platform for TikTok and Instagram.Project Goal Develop a system that allows managing a large number of TikTok and Instagram accounts and automatically posting relevant comments under selected videos using AI. Main Functionality1. Account Management It is necessary to implement the ability to connect accounts:… AI & Machine Learning, Python ∙ 22 hours 45 minutes back ∙ 15 proposals |
Build a customer classification model1. There is client data in Mongo/SQL (approximately 20,000 entries with raw data). 2. It is necessary to build features and a classification model of clients into behavioral groups based on this data. 3. The project should be completed in Python. AI & Machine Learning, Python ∙ 2 days 17 hours back ∙ 35 proposals |
IT Automation of VAT Reporting
223 USD
It is necessary to develop a system for automating the transfer of sales data from the CRM to the accounting system Wafeq. The system should import bank and payment reports, automatically reconcile payments with invoices, generate invoices for VAT reporting, and minimize manual… AI & Machine Learning, Python ∙ 2 days 22 hours back ∙ 44 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 ∙ 3 days 10 hours back ∙ 42 proposals |
Батуми