Python Script for Excel Data Processing

Python Data Processing Project Brief

Project Overview

Development of a Python script that processes company name data from Excel files with the following functionality:

1. Identify and extract unique company names from a source Excel file
2. Generate unique IDs for each distinct company
3. Create a new Excel file mapping company names to their unique IDs
4. Replace company names in the original Excel file with their corresponding IDs
5. Handle variations of the same company name (e.g., "Cashew" and "Cashew..,") as a single entity

Key Requirements

Duplicate Name Detection:

Implement fuzzy matching to identify similar company names (e.g., with minor variations in punctuation or spacing)
Consider names like "Cashew" and "Cashew..," as the same entity


ID Generation:

Create a consistent system for generating unique IDs for each company


Output Files:

1. A reference Excel file containing unique company names and their corresponding IDs
2. An updated version of the original Excel file with company names replaced by IDs

Timeline

Development and Testing: within next few hours
Final Delivery: by end of the day

Kindly refer the example screenshot of the file.