In R; I would like to do something in R rather than excel because excel can’t handle the calculation. In excel the calculation is: =A2+SUM($B$2:B2)

by

Look into dplyr https://cran.rstudio.com/web/packages/dplyr/vignettes/introduction.html

install.packages("dplyr")

library(dplyr)

df <- df %>% mutate(phys_pos=cumsum(length)+position)

I am assuming your data.frame is named df

Or with base R

df$phys_pos <- cumsum(df$length) + df$position

More Related Contents:

  1. How can I generate a user password in R [closed]
  2. How to plot intersecting ranges in Excel/R/Matlab [closed]
  3. How can I read multiple (excel) files into R? [duplicate]
  4. How to convert Excel date format to proper date in R
  5. Easy way to export multiple data.frame to multiple Excel worksheets
  6. Read all worksheets in an Excel workbook into an R list with data.frames
  7. Export data from R to Excel
  8. melt / reshape in excel using VBA?
  9. Read Excel file from a URL using the readxl package
  10. Is there an R function to reshape this data from long to wide?
  11. Is it possible to get the number of rows in a CSV file without opening it?
  12. How do you read a password protected excel file into r?
  13. Importing a big xlsx file into R?
  14. Using R to read out excel-colorinfo
  15. How do I modify an existing a sheet in an Excel Workbook using Openxlsx package in R?
  16. Naming columns in a data table in R
  17. Split data frame string column into multiple columns
  18. How do I arrange a variable list of plots using grid.arrange?
  19. Selecting only numeric columns from a data frame
  20. Conditional merge/replacement in R
  21. Rotate a Matrix in R by 90 degrees clockwise
  22. gsub() in R is not replacing ‘.’ (dot)
  23. How to pass dynamic column names in dplyr into custom function?
  24. Line break in expression()?
  25. Library is not writable
  26. How to stop bookdown tables from floating to bottom of the page in pdf?
  27. Elegant way to select the color for a particular segment of a line plot?
  28. What does the error “arguments imply differing number of rows: x, y” mean?
  29. Removing multiple columns from R data.table with parameter for columns to remove
  30. How to calculate time difference with previous row of a data.frame by group

Leave a Comment