Displaying 1 result from an estimated 1 matches for "senthometotal".
2010 Mar 10
1
trouble calculating rates--sometimes the denominator is missing
...0.csv",
header=TRUE, sep=",", fill=TRUE)
data$date <- as.character(data$ReportingDate)
data$date <- as.Date(data$ReportingDate, format="%d%b%y")
####
data$PercentStudentsAbsent <-
data$StudentsAbsentTotal/data$TotalStudentsEnrolled
data$PercentSentHome <- data$SentHomeTotal/data$TotalStudentsEnrolled
####
attach(data)
The problem is that sometimes, in some of the daily files, the
TotalStudentsEnrolled field is left entirely blank--in every record.
Unfortunately the data collection system is out of my hands, and still a
little rough around the edges. The powers-tha...