Fill missing combinations in a dataframe

by

Using complete from tidyr:

library(tidyr)
as.data.frame(complete(df,REGION,CATEGORY,fill=list(VALUE1=0,VALUE2=0)))

Output:

    REGION CATEGORY VALUE1 VALUE2
1 REGION A        A      2      1
2 REGION A        B      3      2
3 REGION B        A      0      0
4 REGION B        B      4      3

If there are many variables, you could also just do as.data.frame(complete(df,REGION,CATEGORY)) and replace the NA‘s afterwards.

Hope this helps!

More Related Contents:

  1. Select rows from a data frame based on values in a vector
  2. Round up from .5
  3. What does “The following object is masked from ‘package:xxx'” mean?
  4. Replace NA in column with value in adjacent column
  5. Remove columns with zero values from a dataframe
  6. How to display the frequency at the top of each factor in a barplot in R [duplicate]
  7. efficiently generate a random sample of times and dates between two dates
  8. Export data from R to Excel
  9. Create new dummy variable columns from categorical variable
  10. How to draw lines outside of plot area in ggplot2?
  11. drop-down checkbox input in shiny
  12. Write many files in a for loop
  13. duplicate ‘row.names’ are not allowed error
  14. Subfigures or Subcaptions with knitr?
  15. Return a data frame from function
  16. use ggpairs to create this plot
  17. How to make grouped layout in igraph?
  18. Update handsontable by editing table and/or eventReactive
  19. Why is as.Date slow on a character vector?
  20. Alternative to expand.grid for data.frames
  21. Changing Million/Billion abbreviations into actual numbers? ie. 5.12M -> 5,120,000 [duplicate]
  22. Apply a function to a subset of data.table columns, by column-indices instead of name
  23. Creating (and Accessing) a Sparse Matrix with NA default entries
  24. Deleting specific rows from a data frame
  25. How to increase the size of points in legend of ggplot2? [duplicate]
  26. Creating a named list from two vectors (names, values)
  27. R: How to split a data frame into training, validation, and test sets?
  28. Match legend text color in geom_text to symbol [duplicate]
  29. Multiply columns in a data frame by a vector
  30. R – What algorithm does geom_density() use and how to extract points/equation of curves?

Leave a Comment