How to substract a column by row?

Question

I want to do an easy subtract in R, but I don't know how to solve it. I would like to know if I have to do a loop or if there is a function. I have a column with numeric variables, and I would like to subtract n by n-1. Time_Day Diff 10 10 15 5 45 30 60 15 Thus, I would like to find the variable "Diff".

Answer 1

Hello,

Whenever I am manipulating data in R, I have found that the dplyr package can be quite useful. For your question, I used the mutate function, which can create a new column using existing columns. Please reference the below code and let me know if this helps!

## Load the dplyr package

library(dplyr)

## Generate Data

TIME_DAY <- c(10,10,15,5,45,30,60,15)

data <- data.frame(TIME_DAY)

## Create the column 'DIFF' by subtracting 1 from the column 'TIME_DAY' using the ## mutate function from dplyr

new_data <-

data %>% mutate(DIFF <- TIME_DAY - 1)

head(new_data)