Subset a dataframe between 2 dates

by

As already pointed out by @MrFlick, you dont get around the basic logic of subsetting. One way to make it easier for you to subset your specific data.frame would be to define a function that takes two inputs like DATE1 and DATE2 in your example and then returns the subset of IBOV_RET according to those subset parameters.

myfunc <- function(x,y){IBOV_RET[IBOV_RET$DATE >= x & IBOV_RET$DATE <= y,]}

DATE1 <- as.Date("1993-04-29")
DATE2 <- as.Date("1993-05-04")

Test <- myfunc(DATE1,DATE2)    

#> Test
#        DATE  X1D_RETURN
#2 1993-04-29 -0.02469136
#3 1993-04-30  0.01687764
#4 1993-05-03  0.00000000
#5 1993-05-04  0.03319502

You can also enter the specific dates directly into myfunc:

myfunc(as.Date("1993-04-29"),as.Date("1993-05-04")) #will produce the same result

More Related Contents:

  1. Subsetting a dataframe for a specified month and year
  2. Subset data.frame by date
  3. Extract rows based on only one column using R [closed]
  4. Why is `[` better than `subset`?
  5. Selecting data frame rows based on partial string match in a column
  6. Looping over a Date or POSIXct object results in a numeric iterator
  7. Subset rows in a data frame based on a vector of values
  8. Generate a sequence of the last day of the month over two years
  9. Subset of rows containing NA (missing) values in a chosen column of a data frame
  10. Subset with unique cases, based on multiple columns
  11. Is there a more elegant way to convert two-digit years to four-digit years with lubridate?
  12. Split date into different columns for year, month and day
  13. Update subset of data.table based on join
  14. Converting Date formats in R [closed]
  15. R gotcha: logical-and operator for combining conditions is & not &&
  16. R keep rows with at least one column greater than value
  17. convert character to date *quickly* in R [duplicate]
  18. Change day of the month in a Date to first day (01)
  19. Sort year-month column by year AND month
  20. R ifelse avoiding change in date format [duplicate]
  21. Subsetting data.table using variables with same name as column
  22. Creating a unique sequence of dates
  23. How to account for leap years?
  24. Checking if Date is Between two Dates in R
  25. Order x axis day values in ggplot2
  26. R: How to get the Week number of the month
  27. How to subset a matrix with different column positions for each row? [duplicate]
  28. Subset data.table by logical column
  29. change a column from birth date to age in r
  30. Convert two-digit years to four-digit years with correct century

Leave a Comment