X-Git-Url: https://code.communitydata.science/coldcallbot-discord.git/blobdiff_plain/d6b74612e3a2f01112fa14c6c86bec9c20093ed3..HEAD:/assessment_and_tracking/track_participation.R diff --git a/assessment_and_tracking/track_participation.R b/assessment_and_tracking/track_participation.R index 37898e7..b8b6e1c 100644 --- a/assessment_and_tracking/track_participation.R +++ b/assessment_and_tracking/track_participation.R @@ -1,4 +1,4 @@ -setwd("~/online_communities/coldcallbot/data/") +setwd("~/online_communities/coldcall_scripts-COM481-2024Q4/data/") library(data.table) @@ -6,9 +6,11 @@ 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]) @@ -29,7 +31,7 @@ absence.data.cols <- c("unique.name", "date.absent", "reported") 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) @@ -37,7 +39,7 @@ 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 @@ -105,7 +107,7 @@ ggplot(d) + 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()