Replacing occurrences of a number in multiple columns of data frame with another value in R

by

you want to search through the whole data frame for any value that matches the value you’re trying to replace. the same way you can run a logical test like replacing all missing values with 10..

data[ is.na( data ) ] <- 10

you can also replace all 4s with 10s.

data[ data == 4 ] <- 10

at least i think that’s what you’re after?

and let’s say you wanted to ignore the first row (since it’s all letters)

# identify which columns contain the values you might want to replace
data[ , 2:3 ]

# subset it with extended bracketing..
data[ , 2:3 ][ data[ , 2:3 ] == 4 ]
# ..those were the values you're going to replace

# now overwrite 'em with tens
data[ , 2:3 ][ data[ , 2:3 ] == 4 ] <- 10

# look at the final data
data

More Related Contents:

  1. Replace values greater than zero with 1 in r
  2. Is there an R function for finding the index of an element in a vector?
  3. How to replace NA values in a table for selected columns
  4. Replace NA in column with value in adjacent column
  5. Replace specific characters within strings
  6. Create group number for contiguous runs of equal values
  7. Index values from a matrix using row, col indices
  8. Replace all particular values in a data frame
  9. Match values in data frame with values in another data frame and replace former with a corresponding pattern from the other data frame
  10. Remove all text before colon
  11. How to replace NaN value with zero in a huge data frame?
  12. How can I remove an element from a list?
  13. Replace given value in vector
  14. Replace values in a vector based on another vector
  15. in R, use gsub to remove all punctuation except period
  16. Getting the last n elements of a vector. Is there a better way than using the length() function?
  17. Get row and column indices of matches using `which()`
  18. How to index an element of a list object in R
  19. R: Replace multiple values in multiple columns of dataframes with NA
  20. Extract a column from a data.table as a vector, by position
  21. Using get() with replacement functions
  22. Replace a value NA with the value from another column in R
  23. Replace all values in a matrix
  24. Replace in a factor column
  25. Replace empty values with value from other column in a dataframe
  26. Keyed lookup on data.table without ‘with’
  27. replacing values in a column with another column R
  28. In R, what does a negative index do?
  29. Create grouping variable for consecutive sequences and split vector
  30. Add a new column between other dataframe columns [duplicate]

Leave a Comment