anonyxel

Excel Sheet Data Anonymizer for Machine Learning. https://anonyxel.pythonanywhere.com/

Usage:

online

https://anonyxel.pythonanywhere.com/ is using the same codebase so check below as well.

as a commandline tool

 anonyxel_cmd.py [-h] [-d DATA_FILE] [-w WORKSHEET] [-i ID_COLUMN] [-o OUTCOME_COLUMN]

Anonyxel takes DATA_FILE.xlsx with ID, Outcome and some data columns 
in the DATA worksheet. 



Hashes IDs, keeps Outcome(0/1) cleartext. 
Numbers(integers) excluding float are first hashed to a string.
Afterwards all categorical and string columns are encoded into levels. 
Floats are scaled. 

The Results are written to DATA_FILE.anon.xlsx. 



An ID map for joining back to the original data is written 
into DATA_FILE.id_map.xlsx



optional arguments:
  -h, --help            show this help message and exit
  -d DATA_FILE, --data_file DATA_FILE
                        Excel File to anonymize with a single worksheet called DATA.
  -w WORKSHEET, --worksheet WORKSHEET
                        Excel worksheet to use. If omitted we will try to use the DATA worksheet.
  -i ID_COLUMN, --id_column ID_COLUMN
                        A column that represents a Unique ID to identify your cases, 
                        must not repeat within the dataset.
  -o OUTCOME_COLUMN, --outcome_column OUTCOME_COLUMN
                        A 0/1 column that represents the outcome of your cases. Empty cells 
                        represent rows/cases that you want to predict. It will not be anonymized 
                        because we need it in clear text. 

Acknowledgments

1183632.svg icon from Flaticon https://www.flaticon.com/free-icon/encryption_1183632