how to retrieve values from csv file within specific period using R [duplicate]

Question

let say i have dataset for State , year , week and location in csv format i want retrieve all data for specific state for year 2014 from week 36 to week 53 as follow

i've already do this but still have another not need states, thnx

LH14 <- (function(){
 x <- read.csv("LocationHotspot2014.csv")
 x[,"State"] <- toupper(lh14[,"State"])
 x[x$State=="California",],
 x[x$Week== c(36:53) ,] 
 })()

You will need %in% insteed of == for checking whther the weeks match. — Jaap
– Jaap, Commented Aug 4, 2015 at 9:54

Josh · Accepted Answer · 2015-08-04 10:41:51Z

2

Your code has several errors. This should run, assuming the csv file exists and has the appropriate columns.

LH14 <- function() { 
  x <- read.csv("LocationHotspot2014.csv")
  x$State <- toupper(x$State)
  x <- x[x$State == "CALIFORNIA" & x$Week %in% 36:53, ]
  x
}
lh14 <- LH14()

edit: Replaced subset with indexing per Roman's suggestion.

edited Aug 4, 2015 at 10:41

answered Aug 4, 2015 at 10:08

Josh

1,27812 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Roman Luštrik Over a year ago

FWIW, for non-interactive use, subset is not recommended.

Josh Over a year ago

@RomanLuštrik I've not heard that before, why is that?

Roman Luštrik Over a year ago

See ?subset: "This is a convenience function intended for use interactively. For programming it is better to use the standard subsetting functions like [, and in particular the non-standard evaluation of argument subset can have unanticipated consequences."

Adam Over a year ago

Thank you guys Josh u r right its work now thnaks

Collectives™ on Stack Overflow

how to retrieve values from csv file within specific period using R [duplicate]

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related