Subtracting columns in a loop

user_13170140 0
Viewed 211

I've got a data frame like that:

df:
   A  B  C
1  1  2  3
2  2  2  4
3  2  2  3

I would like to subtract each column with the next smaler one (A-0, B-A, C-B). So my results should look like that:

df:
   A  B  C
1  1  1  1
2  2  0  2
3  2  0  1

I tried the following loop, but it didn't work.

for (i in 1:3) {
  j <- data[,i+1] - data[,i]
}
dataframe r loops
2 Answers

Try this

df - cbind(0, df[-ncol(df)])

#   A B C
# 1 1 1 1
# 2 2 0 2
# 3 2 0 1

Data

df <- data.frame(A = c(1, 2, 2), B = c(2, 2, 2), C = c(3, 4, 3))
user_100689850

We can also remove the first and last column and do the subtraction

df[-1] <- df[-1]-df[-length(df)]

data

df <- data.frame(A = c(1, 2, 2), B = c(2, 2, 2), C = c(3, 4, 3))
user_37322710
Related