-setwd("~/online_communities/coldcallbot/data/")
+setwd("~/online_communities/coldcall_scripts-COM481-2024Q4/data/")
library(data.table)
## LOAD call_list TSV data
################################################
-call.list <- do.call("rbind", lapply(list.files(".", pattern="^call_list-.*tsv$"), function (x) {read.delim(x, stringsAsFactors=FALSE)[,1:4]}))
+call.list <- do.call("rbind", lapply(list.files(".", pattern="^call_list-.*tsv$"), function (x) {read.delim(x, stringsAsFactors=FALSE)[,1:5]}))
colnames(call.list) <- gsub("_", ".", colnames(call.list))
+colnames(call.list)[1] <- "unique.name"
+colnames(call.list)[2] <- "preferred.name"
table(call.list$unique.name[call.list$answered])
missing.in.class <- call.list.full[!call.list.full$answered,
c("unique.name", "timestamp")]
missing.in.class$date.absent <- as.Date(missing.in.class$timestamp)
-missing.in.class$reported <- FALSE
+missing.in.class$reported <- rep(FALSE, nrow(missing.in.class))
missing.in.class <- missing.in.class[,absence.data.cols]
missing.in.class <- unique(missing.in.class)
## LOAD absence data TSV data
################################################
-absence.google <- read.delim("absence_poll_data.tsv")
+absence.google <- read.delim("optout_poll_data.tsv")
colnames(absence.google) <- c("timestamp", "unique.name", "date.absent")
absence.google$date.absent <- as.Date(absence.google$date.absent, format="%m/%d/%Y")
absence.google$reported <- TRUE
scale_x_discrete("Number of questions answered") +
scale_y_continuous("Number of students") +
##scale_fill_brewer("Absences", palette="Blues") +
- scale_fill_manual("Absences", values=color.gradient) +
+ scale_fill_manual("Opt-outs", values=color.gradient) +
theme_bw()
dev.off()