This script will support a research effort to determine how frequently some keywords are associated with each other.
The script should be developed with the sample CSV provided as an attachment. I can provide a larger data sample for performance assessment and optimization.
In the CSV there are unique IDs (numbers) and keywords (text). The script has to create all the possible pairings of keywords for a given ID.
For example, if you have 3 keywords A, B and C - there would be 3 pairs: AB, AC, and BC. The keywords are sorted alphabetically so combinations like BA, CA and CB can be ignored... that divides the volume of data by 2.
I attached a graphic file that shows how the pairing works up to 7 keywords, but there could be more than 7 keywords for a given unique ID.
The output would be a CSV with unique IDs and all the unique keyword pairings generated by the script.
This is not a very complex programming task, please bid accordingly.
DM if you have any questions.