Displaying 1 result from an estimated 1 matches for "percentstudentsabsent".
2010 Mar 10
1
trouble calculating rates--sometimes the denominator is missing
...y(ggplot2)
library(doBy)
library(reshape)
data <- read.csv("C:/DATA/BCHD/schoolsurveillance/Broome_02MAR10.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...