From: Benjamin Mako Hill <mako@atdot.cc>
Date: Thu, 15 Oct 2020 02:42:07 +0000 (-0700)
Subject: simple R script to track participation
X-Git-Url: https://code.communitydata.science/coldcallbot-discord.git/commitdiff_plain/e98bacabb8a1e7095a966f1461bf4a345a60433e?hp=--cc

simple R script to track participation

lits two things:

- number of times folks have been called on
- number of times folks have bee absent/present
---

e98bacabb8a1e7095a966f1461bf4a345a60433e
diff --git a/data/track_participation.R b/data/track_participation.R
new file mode 100644
index 0000000..d44e74d
--- /dev/null
+++ b/data/track_participation.R
@@ -0,0 +1,24 @@
+library(ggplot2)
+
+gs <- read.delim("student_information.tsv")
+d <- gs[,c(2,5)]
+colnames(d) <- c("student.num", "discord.name")
+
+call.list <- do.call("rbind", lapply(list.files(".", pattern="^call_list-.*tsv$"), function (x) {read.delim(x)}))
+colnames(call.list) <- gsub("_", ".", colnames(call.list))
+
+call.counts <- data.frame(table(call.list$discord.name))
+colnames(call.counts) <- c("discord.name", "num.calls")
+
+d <- merge(d, call.counts, all.x=TRUE, all.y=TRUE, by="discord.name"); d
+
+## set anything that's missing to zero
+d$num.calls[is.na(d$num.calls)] <- 0
+      
+attendance <- unlist(lapply(list.files(".", pattern="^attendance-.*tsv$"), function (x) {d <- read.delim(x); strsplit(d[[2]], ",")}))
+
+attendance.counts <- data.frame(table(attendance))
+colnames(attendance.counts) <- c("discord.name", "num.present")
+
+d <- merge(d, attendance.counts, all.x=TRUE, all.y=TRUE, by="discord.name"); d
+