This Python script provides a simple graphical user interface (GUI) created with Tkinter for anonymizing sensitive data in an Excel or CSV file. The tool allows users to select a specific column of data within the file and anonymize it using the SHA-512 hashing algorithm. The anonymized data is then associated with a new and simplified unique ID, ensuring that identical data values receive the same anonymized ID. Furthermore, the tool provides functionality to create or load a JSON mapping dictionary for future reference.
The key features of this tool are as follows:
- Anonymize sensitive data in an Excel or CSV file.
- Create or load a JSON map dictionary to track anonymized data.
- Export the anonymized data to a new Excel or CSV file.
- The entire application was packaged into an executable using PyInstaller for easy sharing.
To get started with the Anonymizer tool, follow these simple steps:
Launch the Application:
Run the anonymizer.exe executable to start the application.
Import Your Data:
Click the "Import File" button within the user-friendly interface.
Choose either an Excel or CSV file, depending on your project file format.
Manage Mapping:
If you have a pre-existing JSON mapping file for reference, select "Import JSON File" and choose the appropriate file.
Alternatively, create a new mapping file by selecting "Create New Map File" and save it to your preferred folder location.
Customize Anonymized IDs (Optional):
Personalize the anonymized IDs by adding a prefix of your choice. For example, if you choose "apple" as your prefix, the anonymized IDs will follow the pattern: apple1, apple2, apple3, and so forth.
Select the Column to Anonymize:
Pick the specific data column that you wish to anonymize.
Initiate the Anonymization Process:
Click "Proceed" to begin the anonymization process. Your data will be securely hashed and assigned unique IDs.
Save the Anonymized Data:
Once the anonymization is complete, click "Save DataFrame" to export the anonymized data as a new Excel or CSV file.
This tool is provided as-is, and the developers are not responsible for any data breaches or misuse of anonymized data.