You can just use the output of is.na
to replace directly with subsetting:
bothbeams.data[is.na(bothbeams.data)] <- 0
Or with a reproducible example:
dfr <- data.frame(x=c(1:3,NA),y=c(NA,4:6)) dfr[is.na(dfr)] <- 0 dfr x y 1 1 0 2 2 4 3 3 5 4 0 6
However, be careful using this method on a data frame containing factors that also have missing values:
> d <- data.frame(x = c(NA,2,3),y = c("a",NA,"c")) > d[is.na(d)] <- 0 Warning message: In `[<-.factor`(`*tmp*`, thisvar, value = 0) : invalid factor level, NA generated
It “works”:
> d x y 1 0 a 2 2 <NA> 3 3 c
…but you likely will want to specifically alter only the numeric columns in this case, rather than the whole data frame. See, eg, the answer below using dplyr::mutate_if
.
Related Posts:
- R Hex to RGB converter
- How do I select the first row in an R data frame that meets certain criteria?
- Poker hand range chart visualization in R
- Error in plot.new() : figure margins too large, Scatter plot
- How to join (merge) data frames (inner, outer, left, right)
- Interpreting “condition has length > 1” warning from `if` function
- rbind error: “names do not match previous names”
- rbind error: “names do not match previous names”
- $ operator is invalid for atomic vectors for dataframe R
- adding x and y axis labels in ggplot2
- Update R using RStudio
- ‘x’ and ‘y’ lengths differ ERROR when plotting
- What are the “standard unambiguous date” formats for string-to-date conversion in R?
- What does “Error: object ‘
‘ not found” mean? - mean() warning: argument is not numeric or logical: returning NA
- Difference between paste() and paste0()
- How do I delete rows in a data frame?
- Error in grid.Call(L_textBounds, as.graphicsAnnot(x$label), x$x, x$y, : Polygon edge not found
- Remove duplicated rows
- Drop data frame columns by name
- How to find the statistical mode?
- Error in colMeans(x, na.rm = TRUE) : ‘x’ must be numeric in KNN classification
- Error in ggplot.data.frame : Mapping should be created with aes or aes_string
- Editing legend (text) labels in ggplot
- case_when in mutate pipe
- “Error: Continuous value supplied to discrete scale” in default data set example mtcars and ggplot2
- Logistic Regression on factor: Error in eval(family$initialize) : y values must be 0 <= y <= 1
- Error: Incorrect number of dimensions in R
- dim(X) must have a positive length when applying function in data frame
- Basic – T-Test -> Grouping Factor Must have Exactly 2 Levels
- Error: attempt to use zero-length variable name
- How to debug “contrasts can be applied only to factors with 2 or more levels” error?
- R error: cannot coerce type ‘closure’ to vector of type ‘double’
- Error in lm.fit(x, y, offset = offset, singular.ok = singular.ok, …) : NA/NaN/Inf in ‘y’, tried every possible way
- Error in lm.fit(x, y, offset = offset, singular.ok = singular.ok, …) 0 non-na cases
- Why I get this error writing data to a file
- How to save a data frame as CSV to a user selected location using tcltk
- Error in lis[[i]] : attempt to select less than one element
- Plot a line graph, error in xy.coords(x, y, xlabel, ylabel, log) : ‘x’ and ‘y’ lengths differ
- How to compute weighted mean in R?
- Subscript out of bounds – general definition and solution?
- R: Error in eval(predvars, data, env) : numeric ‘envir’ arg not of length one in intrinsic.pars() in multgee package
- Calculate correlation for more than two variables?
- Convert a list to a data frame
- How to count the number of observations in R like Stata command count
- Remove all of x axis labels in ggplot
- Create an empty data.frame
- Can’t draw Histogram, ‘x’ must be numeric
- How can I plot data with confidence intervals?
- MLE error in R: initial value in ‘vmmin’ is not finite
- Rename multiple columns by names
- Unimplemented type list when trying to write.table
- What is the difference between rm() and rm(list=ls())?
- Remove rows with all or some NAs (missing values) in data.frame
- Subscript out of bounds – general definition and solution?
- Convert date-time string to class Date
- Reshaping data.frame from wide to long format
- Remove rows with all or some NAs (missing values) in data.frame
- How to set limits for axes in ggplot2 R plots?
- duplicate ‘row.names’ are not allowed error
- predict.lm() in a loop. warning: prediction from a rank-deficient fit may be misleading
- Nested ifelse statement
- Convert categorical variables to numeric in R
- How do I get RSS from a linear model output
- Warning message: In `…` : invalid factor level, NA generated
- Mean of a column in a data frame, given the column’s name
- How to overcome error:”attempt to set ‘colnames’ on an object with less than two dimension” in xts object
- grep using a character vector with multiple patterns
- remove all variables except functions
- Error: Invalid input: date_trans works with objects of class Date only
- How to avoid “Error in stripchart.default(x1, …) : invalid plotting method” error?
- Matrix expression causes error “requires numeric/complex matrix/vector arguments”?
- ‘height’ must be a vector or a matrix. barplot error
- NAs are not allowed in subscripted assignments
- install.packages fails in knitr document: “trying to use CRAN without setting a mirror”
- How to convert a data frame column to numeric type?
- How do I install an R package from source?
- How can I convert Json to data frame in R
- Optimization of a function in R ( L-BFGS-B needs finite values of ‘fn’)
- R apply function with multiple parameters
- Error in eval(predvars, data, env) : invalid ‘envir’ argument of type ‘character’
- Error in
: target of assignment expands to non-language object - run a for loop in parallel in R
- How do I combine two data-frames based on two columns?
- Error: Invalid number of ‘breaks’ in R
- Efficiently sum across multiple columns in R
- How to eliminate “NA/NaN/Inf in foreign function call (arg 7)” running predict with randomForest
- Indicator function in R
- IF “OR” multiple conditions
- R4DS error comparison (1) is possible only for atomic and list types
- Replace all 0 values to NA
- Error in x[[i]] : recursive indexing failed at level 2
- Merge error : negative length vectors are not allowed
- non-numeric argument to binary operator
- How to avoid “operations are possible only for numeric, logical or complex types” when computing top 3 elements in each group
- Column standard deviation R [duplicate]
- Difference between as.POSIXct/as.POSIXlt and strptime for converting character vectors to POSIXct/POSIXlt
- invalid (do_set) left-hand side to assignment in R
- How do I print a hexadecimal number with leading 0 to have width 2 using sprintf?
- In R, dealing with Error: ggplot2 doesn’t know how to deal with data of class numeric