Subsetting a dataframe for a specified month and year

by

Since you didn’t provide a data set I made my own from the link you provided. Your method works for me and I get an empty data set only if I don’t meet both of the conditions supplied (month and year) so I’m guessing you’re you’re attempting to subset a date series (month and year) that doesn’t exist (but can’t tell for certain without the code you’re using). Here’s the code I used:

sales <- read.table(text="2372  Kansas KS2000111 HUMBOLDT, CITY OF    ATRAZINE    1.3 05/07/2006
9104  Kansas KS2000111 HUMBOLDT, CITY OF    ATRAZINE   0.34 07/23/2006
9212  Kansas KS2000111 HUMBOLDT, CITY OF    ATRAZINE   0.33 02/11/2007
2094  Kansas KS2000111 HUMBOLDT, CITY OF    ATRAZINE    1.4 05/06/2007
16763 Kansas KS2000111 HUMBOLDT, CITY OF    ATRAZINE   0.61 05/11/2009
1076  Kansas KS2000111 HUMBOLDT, CITY OF METOLACHLOR   0.48 05/12/2002
1077  Kansas KS2000111 HUMBOLDT, CITY OF METOLACHLOR    0.3 05/07/2006")

sales$V9 <- as.Date(sales$V9, "%m/%d/%Y")
names(sales)[9] <- 'date'
subset(sales, format.Date(date, "%m")=="05" & format.Date(date, "%y")=="07")
#    V1     V2        V3        V4   V5 V6       V7  V8       date
#4 2094 Kansas KS2000111 HUMBOLDT, CITY OF ATRAZINE 1.4 2007-05-06

subset(sales, format.Date(date, "%m")=="05" & format.Date(date, "%y")=="10")
#[1] V1   V2   V3   V4   V5   V6   V7   V8   date
#<0 rows> (or 0-length row.names)

More Related Contents:

  1. Subset a dataframe between 2 dates
  2. Subset data.frame by date
  3. Convert date-time string to class Date
  4. How to subset matrix to one column, maintain matrix data type, maintain row/column names?
  5. How to drop columns by name in a data frame
  6. Subset / filter rows in a data frame based on a condition in a column
  7. Converting year and month (“yyyy-mm” format) to a date?
  8. Subset dataframe by multiple logical conditions of rows to remove
  9. Number of months between two dates
  10. Find which season a particular date belongs to
  11. as.Date with dates in format m/d/y in R
  12. Subset data to contain only columns whose names match a condition
  13. Subset and ggplot2
  14. Extract matrix column values by matrix column name
  15. R: How to handle times without dates?
  16. Extract Month and Year From Date in R
  17. How to subset data in R without losing NA rows?
  18. Using grep to help subset a data frame
  19. Converting date in Year.decimal form in R
  20. How to subtract years?
  21. Split/subset a data frame by factors in one column [duplicate]
  22. Looping through t.tests for data frame subsets in r
  23. R group by date, and summarize the values
  24. Delete duplicate rows in two columns simultaneously [duplicate]
  25. Filter data frame rows based on values in vector
  26. format year-month to POSIXct [duplicate]
  27. Convert integer as “20160119” to different columns of “day” “year” “month”
  28. Get date difference in years (floating point)
  29. How to remove rows of a matrix by row name, rather than numerical index?
  30. How to pass “nothing” as an argument to `[` for subsetting?

Leave a Comment