Dataframe create new column based on other columns

by

One option is ifelse which is vectorized version of if/else. If we are doing this for each row, the if/else as showed in the OP’s pandas post can be done in either a for loop or lapply/sapply, but that would be inefficient in R.

df <- transform(df, c= ifelse(a==b, a+b, b-a))
df
#  a  b  c
#1 1  1  2
#2 2 20 18
#3 3  3  6
#4 4  4  8
#5 5 50 45

This can be otherwise written as

df$c <- with(df, ifelse(a==b, a+b, b-a))

to create the ‘c’ column in the original dataset

As the OP wants a similar option in R using if/else

df$c <- apply(df, 1, FUN = function(x) if(x[1]==x[2]) x[1]+x[2] else x[2]-x[1])

More Related Contents:

  1. Remove columns from dataframe where ALL values are NA
  2. R Apply() function on specific dataframe columns
  3. apply a function over groups of columns
  4. rbind data frames based on a common pattern in data frame name
  5. Calculate row-wise proportions
  6. Last Observation Carried Forward In a data frame? [duplicate]
  7. use multiple columns as variables with sapply
  8. Count number of rows within each group
  9. Drop unused factor levels in a subsetted data frame
  10. Why is it not advisable to use attach() in R, and what should I use instead?
  11. Create an empty data.frame
  12. Create a group number for each consecutive sequence
  13. Subset data frame based on multiple conditions [duplicate]
  14. R – Concatenate two dataframes?
  15. How to convert dataframe into time series?
  16. Merge unequal dataframes and replace missing rows with 0
  17. Is there a R function that applies a function to each pair of columns?
  18. What can R do about a messy data format?
  19. Removing display of row names from data frame
  20. How to delete rows from a data.frame, based on an external list, using R?
  21. Split one row into multiple rows [duplicate]
  22. Shift values in single column of dataframe up
  23. What is about the first column in R’s dataset mtcars?
  24. finding close match from data frame 1 in data fame 2
  25. Combine several data frames in the global environment by row (rbind)
  26. Extract text after “/” in a data frame column
  27. Reshape a dataframe to long format with multiple sets of measure columns [duplicate]
  28. Count number of non-NA values for every column in a dataframe [duplicate]
  29. Shifting a column down by one
  30. Identifying where value changes in R data.frame column

Leave a Comment