# Add new column from existing column
df$new_pages <- df$pages-2
df

# Output
#  id pages   name new_pages
#1 11    32  spark        30
#2 22    45 python        43