Adding new column with diff() function when there is one less row in R

by

Here are two approaches. Both put an NA in the first row of diff_qsec and put diff(qsec) in the remaining rows:

library(dplyr)  
mtcars %>% mutate(diff_qsec = qsec - lag(qsec)) # dplyr has its own version of lag

transform(mtcars, diff_qsec = c(NA, diff(qsec)))

Also, on the general issue of padding see: How can I pad a vector with NA from the front?

More Related Contents:

  1. R how can I calculate difference between rows in a data frame
  2. How can i create a contingency table in R? [closed]
  3. Cannot install R-forge package using install.packages
  4. Change the Blank Cells to “NA”
  5. Stacked Bar Plot in R
  6. Sum across multiple columns with dplyr
  7. dplyr mutate/replace several columns on a subset of rows
  8. Proper/fastest way to reshape a data.table
  9. Global variables in R
  10. Cumulative sum that resets when 0 is encountered
  11. Efficiently sum across multiple columns in R
  12. Error in grid.Call(L_textBounds, as.graphicsAnnot(x$label), x$x, x$y, : Polygon edge not found
  13. What can R do about a messy data format?
  14. Remove duplicates keeping entry with largest absolute value
  15. R ifelse statement
  16. Reproducing lattice dendrogram graph with ggplot2
  17. Changing the line type in the ggplot legend
  18. Switch displayed traces via plotly dropdown menu
  19. ggplot replace count with percentage in geom_bar
  20. R grep: is there an AND operator?
  21. How to replace NA with most recent non-NA by group? [duplicate]
  22. combine two data frames with all posible combinations
  23. How to check if CSV file has a comma or a semicolon as separator?
  24. Add a column with count of NAs and Mean
  25. stat_contour not able to generate contour lines
  26. Make R exit with non-zero status code
  27. LDA with topicmodels, how can I see which topics different documents belong to?
  28. How to add Rtools\bin to the system path in R
  29. How to calculate adjacency matrices in R
  30. Removing Unused Factors from a Facet in ggplot2

Leave a Comment