How to write a python script to pair two values between columns together?
I have ColumnA that uses a regular expression to generate non-unique employee IDs.
Now I have a ColumnB that I want to use to generate a similarly random ID for the employee.
And I want to ensure they always pair up. So if ColumnA = 02200, and ColumnB = AA98, then the subsequent occurrences of ColumnA = 02200, ColumnB should equal AA98.
Perhaps there is a Python Script that accomplishes this? I'm not quite sure where to go from here.
0 · Share on Twitter