Cleaned products final

₹12500-37500 INR

Posted 1 minute ago

•

Ends in 6 days

₹12500-37500 INR

Paid on delivery

I have an Excel file of product information that urgently needs attention. The sheet is cluttered with duplicate entries and inconsistent naming, making it hard to trust the data for reporting or uploads. Your task is straightforward: identify and remove every duplicate product line, then apply a clear, uniform naming convention across the remaining records so each product appears exactly once and is spelled the same way throughout. The cleaned file should be returned in the original Excel format, ready for immediate use without any extra adjustments on my side. I’d also like a brief note outlining the rules you applied for the name-standardization so I can keep future data consistent. Deliverables: • Cleaned Excel workbook with all duplicates removed • Standardized product names across every column that contains them • Short summary of the naming rules and any edge cases handled Please share a sample of past work that proves you have handled similar data-cleanup tasks—before-and-after screenshots or a short description is fine. Speed matters: I need the finished file ASAP.

Project ID: 40814412

About the project

2 proposals

Open for bidding

Remote project

Active 21 secs ago

Place your bid

Bid amount Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

It's free to sign up and bid on jobs

2 freelancers are bidding on average ₹18,000 INR for this job

User Avatar
Flag of INDIA

Cleaning your cluttered Excel file of duplicate product lines and inconsistent naming — that is exactly what this covers. You mentioned the data needs to be ready for reporting or uploads without extra adjustments on your side, so here is how I will get there: For duplicates, I will use Power Query rather than a basic filter. This catches near-duplicates caused by trailing spaces, case mismatches, or stray characters that a simple Remove Duplicates pass would leave behind — which matters because one missed near-duplicate still breaks your upload. For name standardisation, I will apply a consistent capitalisation rule, strip special characters, and collapse merged variants across every column that contains product names, not just the primary one. One problem you may not have considered: if product names are referenced in multiple columns like category or SKU fields, fixing only one column will leave contradictions in the remaining data. I will check all columns before delivering. I will document every ambiguous merge decision — for example, Widget Pro versus WidgetPro — in a rules summary tab inside the same workbook so you can keep future data consistent without guessing. Deliverable: one cleaned .xlsx file plus the naming rules note, returned within 24 hours. I have handled product catalogue cleanups with 5,000-plus SKUs where this exact naming inconsistency caused reporting failures.

User Avatar
Flag of GERMANY

Duplicate product lines and names spelled three different ways make a sheet useless for uploads, and the fix needs care, because two near-identical names are not always the same product. I would load the workbook in Python (pandas), match exact and near-duplicates after normalizing case, spacing, units and abbreviations, and list unclear pairs for you to confirm before anything is deleted. The standardized names are then written back into every column that holds them, and you get the file in its original Excel format with formatting kept. Alongside it comes a one-page note with the naming rules, the edge cases and a count of the rows removed. As a sample, I can clean the first 20 rows of your file for free before you award, so you see the before and after on your own data. I have worked with text and data cleanup in research at Goethe University Frankfurt since 2014 (PhD in NLP, 30+ publications). The full file is delivered within 2 days. Are the product names only in one column, or also inside description or category fields? Wahed

内容来自 Freelancer News,版权归原作者所有。

阅读原文 ↗

把喜欢的内容,留在你的新标签页。

打开我的订阅