From 360a7e8ee059d7060c373abb453e29dba8cfc015 Mon Sep 17 00:00:00 2001 From: Benjamin Mako Hill Date: Sat, 28 Sep 2024 20:10:18 -0700 Subject: [PATCH 1/1] updated code to better figure out whose not registered --- assessment_and_tracking/track_enrolled.R | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) diff --git a/assessment_and_tracking/track_enrolled.R b/assessment_and_tracking/track_enrolled.R index 47e50c2..06e4aba 100644 --- a/assessment_and_tracking/track_enrolled.R +++ b/assessment_and_tracking/track_enrolled.R @@ -1,5 +1,5 @@ -myuw <- read.csv("../data/2022_winter_COM_481_A_students.csv") -gs <- read.delim("../data/student_information.tsv") +myuw <- read.csv("data/2024_autumn_COM_481_A_students.csv") +gs <- read.delim("data/student_information.tsv") ## these are students who dropped the class (should be empty) gs[!gs$Your.UW.student.number %in% myuw$StudentNo,] @@ -7,6 +7,12 @@ gs[!gs$Your.UW.student.number %in% myuw$StudentNo,] ## these are students who are in the class but didn't reply to the form myuw[!myuw$StudentNo %in% gs$Your.UW.student.number,] +roster.merged <- merge(myuw, gs, by.x="StudentNo", by.y="Your.UW.student.number", all.x=TRUE, all.y=FALSE) + +roster.merged[,c("StudentNo", "Email", "FirstName", "LastName", "Your.username.on.the.class.Discord.server", "checked.off.on.discord")][!roster.merged$StudentNo %in% gs$Your.UW.student.number,] +## these are students who are in the class but didn't reply to the form + + ## read all the folks who have been called and see who is missing from ## the google sheet -- 2.39.5