Python. Removing implicit word duplicates along with the entire row in Excel.
Hello! Who has had such experience? You can write about it in your bid. We continue to improve the program. When collecting information, there is information in Excel that repeats in various duplicates, both direct and duplicates with words in a different order. For example:
buy a samsung phone and an implicit duplicate: samsung phone buy, and buy samsung phone. And of course, a regular duplicate is when the same words are simply repeated several times. Buy a samsung phone and even so, at least 10 times. The words are located in one column. And they go in a column. 1 word 1 line. Each word is in a different line. In Excel itself, only simple duplicates are removed. Well, you know that yourself. There are many options for solving such a task. Something similar has been done for me before. Only there the Levenshtein formula worked. And it is too smart for such a task. Because it can remove not just obvious duplicates, but rather more than necessary. Therefore, something much simpler is needed here. Like based on the logic of the order of words. And ideally, if possible and not difficult, then if a word has a change at the end, like phones, phone, car, car's. The logic should also understand that these are duplicates. But this is if possible.
My program is written in python. It has a local server. It opens the Excel file that I give it in the browser. And there it can already perform various operations with it that I need and download it back to me. In short, we will copy the code that does this. And we will make a clone of the button, or a clone of the page, and rename it to delete-duplicate, so you only need to add the logic of the code for the actual removal of implicit duplicates. And the process of uploading the file, its processing and uploading, as well as all the necessary libraries, are already there.
Client's review of cooperation with Danilo K.
Python. Removing implicit word duplicates along with the entire row in Excel.Great specialist. I recommend to everyone. For collaboration!
Freelancer's review of cooperation with Aleksandr Kremenyuk
Python. Removing implicit word duplicates along with the entire row in Excel.Thank you for the collaboration. Interesting project, glad to help!
-
3700 17 0 Good day, Oleksandr!
I will fulfill your request, ready to move on to the discussion.
I have experience and know how to parse messages, and how to avoid messages with the same words, and if there is duplication.
I am waiting in private messages!
-
289 Hello, I did something similar for keywords in the marketplace
I will write it in Python - feel free to reach out
There is an opportunity to discuss the budget downwards
-
316 6 0 Simple task, I will complete it quickly, feel free to contact me privately.
I have experience with similar tasks when it was necessary to parse messages from a Telegram chat, and it was required to avoid messages with the same words, and if the order was different, to avoid those as well.
-
250 37 1 2 Hello!
Ready to complete the project, write the details in private.
Interesting project
-
2264 82 1 2 Good afternoon, I am interested in your project. I am ready to help you with the solution. Please write in private messages to discuss everything in more detail.
Current freelance projects in the category Data Parsing
Database of websites on WooCommerceIt is necessary to compile a database of Ukrainian online store websites on WooCommerce with the contact information provided on the sites. Only active websites (indicator: updated catalog/content, working domain) Table format - website address, phone number, e-mail. Data Parsing ∙ 2 days 2 hours back ∙ 21 proposals |
Create a dashboard in https://airtable.com/ for the performance of advertising creatives from Facebook ads.Full specification https://docs.google.com/document/d/1_n_oYRNZWYxalUA---DM5AD1b5ZSrtePw5J4G42svGw/edit?usp=sharing Databases & SQL, Data Parsing ∙ 3 days 17 hours back ∙ 17 proposals |
Creation of an Excel file for uploading products to the websites of other partners.I am interested in creating an Excel table with all parameters. Here is the website - https://heiztechnik.com.ua/ And the positions I am interested in to be transferred: Manual boilers: 1) TIS UNI 15-95 kW (10) pcs 2)TIS HARD 150-500 kW (7) pcs Pellet boilers: 1)TIS PELLET… Data Parsing ∙ 3 days 21 hours back ∙ 35 proposals |
A developer is required for parsing the catalog and automating data import.Detailed technical specifications in the attached document Please indicate the estimated cost and timeline in your response Do you have experience working with parsing large catalogs What possible difficulties or limitations do you see in this task Databases & SQL, Data Parsing ∙ 4 days back ∙ 40 proposals |
Find a product feed (Google Merchant XML) for a website on OpenCart
16 USD
It is necessary to find a direct link to the active product feed (XML) of a competitor for Google Merchant Center Platform (CMS): OpenCart / ocStore Find the original feedRequirements for the result: Working link to the XML file Python, Data Parsing ∙ 4 days 5 hours back ∙ 25 proposals |