Randomly insert NAs into dataframe proportionaly

by 
df <- data.frame(A = 1:10, B = 11:20, c = 21:30)
head(df)
##   A  B  c
## 1 1 11 21
## 2 2 12 22
## 3 3 13 23
## 4 4 14 24
## 5 5 15 25
## 6 6 16 26

as.data.frame(lapply(df, function(cc) cc[ sample(c(TRUE, NA), prob = c(0.85, 0.15), size = length(cc), replace = TRUE) ]))
##     A  B  c
## 1   1 11 21
## 2   2 12 22
## 3   3 13 23
## 4   4 14 24
## 5   5 NA 25
## 6   6 16 26
## 7  NA 17 27
## 8   8 18 28
## 9   9 19 29
## 10 10 20 30

It’s a random process, so it might not give 15% every time.

More Related Contents:

  1. How do I replace NA values with zeros in an R dataframe?
  2. Replace all NA with FALSE in selected columns in R
  3. Remove rows with all or some NAs (missing values) in data.frame
  4. Replacing character values with NA in a data frame
  5. How to replace NA values in a table for selected columns
  6. Replace NA in column with value in adjacent column
  7. Coalesce two string columns with alternating missing values to one
  8. Omit rows containing specific column of NA
  9. Count NAs per row in dataframe [duplicate]
  10. Subset of rows containing NA (missing) values in a chosen column of a data frame
  11. Remove columns from dataframe where some of values are NA
  12. How to subset data in R without losing NA rows?
  13. How to delete columns that contain ONLY NAs?
  14. Select last non-NA value in a row, by row
  15. Replace in a factor column
  16. Select NA in a data.table in R
  17. Find columns with all missing values
  18. R: replacing NAs in a data.frame with values in the same position in another dataframe
  19. Move NAs to the end of each column in a data frame
  20. Merging a lot of data.frames [duplicate]
  21. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  22. Calculating statistics on subsets of data [duplicate]
  23. Identifying duplicate columns in a dataframe
  24. R pass variable column indices to ggplot2 [duplicate]
  25. How to access the last value in a vector?
  26. Why is plyr so slow?
  27. How to add multiple columns to a data.frame in one go?
  28. Transforming a time-series into a data frame and back
  29. Convert a data frame to a data.table without copy
  30. What is the first column in R’s mtcars dataset?

Leave a Comment