How do I make a new column and calculate with R?

In R, creating a new column and performing calculations on existing columns is a common task when manipulating data frames. Here's how you can achieve it, along with examples and explanations:

1. Using Base R:

- You can directly add a new column to a data frame using the $ operator and assigning the result of your calculation to it. For instance, if you have a data frame named df, and want to create a new column called new_column, the syntax would look like df$new_column <- calculation.

- Example: Let's say you have a data frame with columns a and b, and you want to create a new column that is the sum of these two. Here's the R code:

# Sample data frame
df <- data.frame(a = c(1, 2, 3), b = c(4, 5, 6))

# Create a new column 'c' that is the sum of 'a' and 'b'
df$c <- df$a + df$b

# Print the updated data frame
print(df)

- This will output the data frame with the added column c. The calculations can be any valid R expression, such as subtraction, multiplication, division, or more complex functions.

2. Using the 'dplyr' Package (Recommended):

- The 'dplyr' package from the 'tidyverse' is a more modern and readable way to manipulate data frames. The mutate() function is used to add new columns.

- Example: Using the same example as above, here's the code using 'dplyr':

# Load the dplyr package
library(dplyr)

# Sample data frame
df <- data.frame(a = c(1, 2, 3), b = c(4, 5, 6))

# Create a new column 'c' that is the sum of 'a' and 'b'
df <- df %>% mutate(c = a + b)

# Print the updated data frame
print(df)

- The %>% is the pipe operator from 'dplyr'. It passes the data frame from the left-hand side as the first argument to the function on the right-hand side. This helps to chain multiple operations together, making the code easier to read and understand.

3. More Complex Calculations:

- You can perform any function within these methods. For example, you can calculate the mean, standard deviation, logarithm, etc., for your new columns. Here is an example of creating a column with the square root of the sum:

# Using Base R
df$d <- sqrt(df$a + df$b)

# Using dplyr
df <- df %>% mutate(d = sqrt(a + b))

4. Conditional Calculations:

- You can use ifelse() statements within these calculations to assign different values based on conditions.

- Example using dplyr: Create a new column 'status' that outputs "Positive" if column `c` is greater than 7 and "Negative" otherwise

df <- df %>% mutate(status = ifelse(c > 7, "Positive", "Negative"))


In summary, R provides flexible and diverse ways to create new columns and calculate on existing columns. Base R is direct and simple, while 'dplyr' from the 'tidyverse' provides a more readable and streamlined method, especially when performing multiple calculations.

Learn more about this