I want to sample a large data set of 100,000 rows and do a calculation with each of 10,000 random values chosen. The sampling chooses a random value called "unused", and based on the value chosen there are three choices using if statements, but for some reason the variable "carryover" is not found.
Code is:
options(width=10000)
unused <- round(runif(100000, 0, 600),0)
B <-10000
unused <-matrix(sample(unused,size=B,replace=TRUE),nrow=B)
for (i in 1:B){
if (unused[i]==0){
deduct[i] <- 0
carryover[i] <- 0
used[i] <- 0
if (unused[i] > 200)
deduct[i] <- unused[i]-200
carryover[i] <- 200
used[i] <- carryover[i]+400
if (unused[i] >0 & unused[i] <= 200)
deduct[i] <- 0
carryover[i] <- unused[i]
used[i] <- carryover[i]+400
}
}
View(data.frame(unused,deduct,carryover,used))
Aucun commentaire:
Enregistrer un commentaire