Column-Comparision is a Python desktop application used for mapping 2 columns with a few similarities using fuzzywuzzy algorithm.
Use the package manager pip to install the required libraries.
pip install pandas
pip install tkintertable
pip install pandas
pip install xlwt
pip install fuzzywuzzy
git clone https://github.com/purvansh11/Column-Comparision.git
- Run code_p.py
- Click Import Excel File
- Import Mapped sku.xlsx from the cloned folder or any other similar file
- Close GUI window
- Navigate to the folder where git clone is done
- Comparision_Output.xls is the output file
- Sheet 1 : Green Highlighted cells display the correct matches with their score
- Sheet 2 : All correct matches from Sheet 1 collectively displayed