In R’s “relevent” (Butts, 2015), the identifiers of sender and receiver have to be integers, rather than strings. For example, if we have a sequence data with 12 ordered events like this:<\/p>\n
we need\u00a0to assign “a,” “b,” “c,” and “d” to integers 1, 2, 3, and 4.<\/p>\n Assumption:<\/strong><\/p>\n Receiver’s set R<\/em> is a subset of sender’s set S<\/em>.<\/p>\n Procedure:<\/strong><\/p>\n 1) Assign unique integers to objects in S<\/em>.<\/p>\n 2) Match objects in R<\/em> to the\u00a0assigned integers in S<\/em>.<\/p>\n How to do it in OpenRefine:<\/strong><\/p>\n 1) Move the column “s” to beginning. That is, let the column be the first column from the left.<\/p>\n 2) Sort the column “s” and reorder rows permanently.<\/p>\n 3) Blank down “s” and switch to the “records” mode. The result is:<\/p>\n Similar cells in “s” become “records” under each unique value. The purpose of this step is to group values of “a,” “b,” “c,” and “d” with the row indexes 1, 2, 3, and 4 (imagine these numbers as group labels).<\/p>\n 4) In “records” mode, for the column “s,” use “Edit column -> Add a column based on this column” to create a new column “sID.” Use the GREL expression “row.record.index+1.” Result:<\/p>\n 5) Fill down “s,” which is a reverse of Step 3. Result:<\/p>\n Now, Procedure 1 has been done. We have assigned unique integers to objects in S<\/em>.<\/p>\n 6) For the column “r,” use “Edit column -> Add a column based on this column” to create another new column “rID.” Use the GREL function “cross():”<\/p>\n![\"sample](\"https:\/\/sites.temple.edu\/tudsc\/files\/2016\/11\/Screen-Shot-2016-11-28-at-9.42.17-AM.png\")
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n