Replace NA with previous or next value, by group, using dplyr

by 
require(tidyverse) #fill is part of tidyr

ps1 %>% 
  group_by(userID) %>% 
  fill(color, age, gender) %>% #default direction down
  fill(color, age, gender, .direction = "up")

Which gives you:

Source: local data frame [9 x 4]
Groups: userID [3]

  userID  color    age gender
   <dbl> <fctr> <fctr> <fctr>
1     21   blue   3yrs      F
2     21   blue   2yrs      F
3     21    red   2yrs      M
4     22   blue   3yrs      F
5     22   blue   3yrs      F
6     22   blue   3yrs      F
7     23    red   4yrs      F
8     23    red   4yrs      F
9     23   gold   4yrs      F

More Related Contents:

  1. Fill missing dates by group
  2. Summarizing multiple columns with dplyr? [duplicate]
  3. Relative frequencies / proportions with dplyr
  4. How to create a lag variable within each group?
  5. Filter data frame by character column name (in dplyr)
  6. How to number/label data-table by group-number from group_by?
  7. Remove duplicated rows using dplyr
  8. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  9. dplyr: “Error in n(): function should not be called directly”
  10. dplyr: inner_join with a partial string match
  11. Can dplyr summarise over several variables without listing each one? [duplicate]
  12. Change value of variable with dplyr
  13. sample rows of subgroups from dataframe with dplyr
  14. Assigning Dates to Fiscal Year
  15. filter function in dplyr errors: object ‘name’ not found
  16. Create a ranking variable with dplyr?
  17. How to pass dynamic column names in dplyr into custom function?
  18. R – Group by variable and then assign a unique ID [duplicate]
  19. Sparklyr: how to center a Spark table based on column?
  20. dplyr::mutate to add multiple values
  21. R sum a variable by two groups [duplicate]
  22. Join two data frames in R based on closest timestamp
  23. Conditionally Count in dplyr
  24. data.table row-wise sum, mean, min, max like dplyr?
  25. Update/Replace Values in Dataframe with Tidyverse Join
  26. merging a large list of xts objects
  27. dplyr: put count occurrences into new variable [duplicate]
  28. Add row in each group using dplyr and add_row()
  29. How to replace certain values in a specific rows and columns with NA in R?
  30. Add margin row totals in dplyr chain

Leave a Comment