Create a group index for values connected directly and indirectly

by

Using igraph get membership, then map on names:

library(igraph)

# convert to graph, and get clusters membership ids
g <- graph_from_data_frame(df1[, c(2, 3, 1)])
myGroups <- components(g)$membership

myGroups 
# A B C D E F Z X Y W V U s T 
# 1 1 2 3 4 4 1 1 1 2 2 2 3 4 

# then map on names
df1$group <- myGroups[df1$G1]


df1
#    id G1 G2 group
# 1   1  A  Z     1
# 2   2  A  X     1
# 3   3  B  X     1
# 4   4  B  Y     1
# 5   5  C  W     2
# 6   6  C  V     2
# 7   7  C  U     2
# 8   8  D  s     3
# 9   9  E  T     4
# 10 10  F  T     4

More Related Contents:

  1. Use dynamic name for new column/variable in `dplyr`
  2. data.table vs dplyr: can one do something well the other can’t or does poorly?
  3. Extract a dplyr tbl column as a vector
  4. Pass arguments to dplyr functions
  5. dplyr::select function clashes with MASS::select
  6. Sum across multiple columns with dplyr
  7. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  8. dplyr filter: Get rows with minimum of variable, but only the first if multiple minima
  9. dplyr mutate/replace several columns on a subset of rows
  10. dplyr: How to use group_by inside a function?
  11. Count non-NA values by group [duplicate]
  12. dplyr mutate with conditional values
  13. Get last row of each group in R [duplicate]
  14. ignore NA in dplyr row sum
  15. Set certain values to NA with dplyr
  16. How to select last N observation from each group in dplyr dataframe?
  17. mutate function is not updating
  18. Switch displayed traces via plotly dropdown menu
  19. Create column with grouped values based on another column
  20. Rename multiple columns given character vectors of column names and replacement [duplicate]
  21. combine two data frames with all posible combinations
  22. Error: could not find function “%>%”
  23. Network chord diagram woes in R
  24. dplyr change many data types
  25. How to perform multiple left joins using dplyr in R [duplicate]
  26. Add a column with count of NAs and Mean
  27. How does one stop using rowwise in dplyr?
  28. select columns based on multiple strings with dplyr contains()
  29. Error with select function from dplyr
  30. Collapse all columns by an ID column [duplicate]

Leave a Comment