Conditional replacement of values in a data.frame

by

Since you are conditionally indexing df$est, you also need to conditionally index the replacement vector df$a:

index <- df$b == 0
df$est[index] <- (df$a[index] - 5)/2.533

Of course, the variable index is just temporary, and I use it to make the code a bit more readible. You can write it in one step:

df$est[df$b == 0] <- (df$a[df$b == 0] - 5)/2.533

For even better readibility, you can use within:

df <- within(df, est[b==0] <- (a[b==0]-5)/2.533)

The results, regardless of which method you choose:

df
          a b      est
1  11.77000 2 0.000000
2  10.90000 3 0.000000
3  10.32000 2 0.000000
4  10.96000 0 2.352941
5   9.90600 0 1.936834
6  10.70000 0 2.250296
7  11.43000 1 0.000000
8  11.41000 2 0.000000
9  10.48512 4 0.000000
10 11.19000 0 2.443743

As others have pointed out, an alternative solution in your example is to use ifelse.

More Related Contents:

  1. Filter data.frame rows by a logical condition
  2. Split column at delimiter in data frame [duplicate]
  3. Pass a data.frame column name to a function
  4. How to convert a list consisting of vector of different lengths to a usable data frame in R?
  5. Select groups based on number of unique / distinct values
  6. Assign multiple columns using := in data.table, by group
  7. R spreading multiple columns with tidyr [duplicate]
  8. Unlist data frame column preserving information from other column
  9. Create a data.frame where a column is a list
  10. How to quickly form groups (quartiles, deciles, etc) by ordering column(s) in a data frame
  11. Take random sample by group
  12. Split dataframe into multiple output files
  13. How do I delete rows in a data frame?
  14. Replacing values from a column using a condition in R
  15. Split data.frame by value
  16. Convert data.frame column to a vector?
  17. Add new row to dataframe, at specific row-index, not appended?
  18. How to use a string variable to select a data frame column using $ notation [duplicate]
  19. Growing a data.frame in a memory-efficient manner
  20. R list of lists to data.frame
  21. Remove columns from dataframe where some of values are NA
  22. Check whether values in one data frame column exist in a second data frame
  23. How do you remove columns from a data.frame?
  24. Deleting columns from a data.frame where NA is more than 15% of the column length [duplicate]
  25. DT[!(x == .)] and DT[x != .] treat NA in x inconsistently
  26. Return df with a columns values that occur more than once [duplicate]
  27. Replicate each row of data.frame and specify the number of replications for each row?
  28. How can I merge more than 2 dataframes in R by rownames?
  29. Shifting a column down by one
  30. Identifying where value changes in R data.frame column

Leave a Comment