Shift values in single column of dataframe up

by

Your problem simplifies to:

  • Drop the first n elements in a vector
  • Pad n values of NA at the end

You can do this with a simple function:

shift <- function(x, n){
  c(x[-(seq(n))], rep(NA, n))
}

example$z <- shift(example$z, 2)

The result:

example
  x y  z
1 1 1  3
2 2 2  4
3 3 3  5
4 4 4  6
5 5 5  7
6 6 6  8
7 7 7 NA
8 8 8 NA

More Related Contents:

  1. Sort (order) data frame rows by multiple columns
  2. Subset data frame based on number of rows per group
  3. Drop data frame columns by name
  4. Convert data.frame columns from factors to characters
  5. Compare two data.frames to find the rows in data.frame 1 that are not present in data.frame 2
  6. R Reshape data frame from long to wide format? [duplicate]
  7. Sum rows in data.frame or matrix
  8. Select the first and last row by group in a data frame
  9. Calculate row means on subset of columns
  10. Update data frame via function doesn’t work
  11. R spreading multiple columns with tidyr [duplicate]
  12. Unlist data frame column preserving information from other column
  13. How to quickly form groups (quartiles, deciles, etc) by ordering column(s) in a data frame
  14. Split dataframe into multiple output files
  15. Replacing values from a column using a condition in R
  16. Split data.frame by value
  17. How to use a string variable to select a data frame column using $ notation [duplicate]
  18. Growing a data.frame in a memory-efficient manner
  19. R list of lists to data.frame
  20. Remove columns from dataframe where some of values are NA
  21. Splitting a data.frame by a variable [duplicate]
  22. Check whether values in one data frame column exist in a second data frame
  23. How do you remove columns from a data.frame?
  24. mutate_each / summarise_each in dplyr: how do I select certain columns and give new names to mutated columns?
  25. Print pretty data.frames/tables to console
  26. Replace in a factor column
  27. write.csv for large data.table
  28. Selecting columns in R data frame based on those *not* in a vector
  29. How can I change XTS to data.frame and keep Index?
  30. How to dplyr rename a column, by column index?

Leave a Comment