Expand rows by date range using start and end date

by

Using data.table:

require(data.table) ## 1.9.2+
setDT(df)[ , list(idnum = idnum, month = seq(start, end, by = "month")), by = 1:nrow(df)]

# you may use dot notation as a shorthand alias of list in j:
setDT(df)[ , .(idnum = idnum, month = seq(start, end, by = "month")), by = 1:nrow(df)]

setDT converts df to a data.table. Then for each row, by = 1:nrow(df), we create idnum and month as required.

More Related Contents:

  1. Formatting Decimal places in R
  2. In R, how to get an object’s name after it is sent to a function?
  3. How to name variables on the fly?
  4. Plot multiple columns on the same graph in R [duplicate]
  5. Concatenate a vector of strings/character
  6. Dummy variables from a string variable
  7. How to swap values between two columns
  8. Latitude Longitude Coordinates to State Code in R
  9. Function to clear the console in R and RStudio
  10. Converting two columns of a data frame to a named vector
  11. Animated sorted bar chart with bars overtaking each other
  12. R command for setting working directory to source file location in Rstudio
  13. Pretty ticks for log normal scale using ggplot2 (dynamic not manual)
  14. What is the meaning of the dollar sign “$” in R function()?
  15. Practical limits of R data frame
  16. Set NA to 0 in R
  17. How to convert time (mm:ss) to decimal form in R
  18. how to change the color in geom_point or lines in ggplot [duplicate]
  19. Simplified dput() in R
  20. How to append a whole dataframe to a CSV in R
  21. Unicode with knitr and Rmarkdown
  22. activate tabpanel from another tabpanel
  23. Save imported csv data in vector – R
  24. Non-numeric Argument to Binary Operator Error in R
  25. Special characters and superscripts on plot axis titles
  26. print to pdf file using grid.table in r – too many rows to fit on one page
  27. Obtaining connected components of neighboring values
  28. how to start a for loop in R programming
  29. error in strsplit when trying to separate by a comma
  30. Administrative regions map of a country with ggmap and ggplot2

Leave a Comment