read_vis: Reading VIS Registrations

In c403: Exam Tools for Department of Statistics (c403), Uni Innsbruck

Reading VIS Registrations

Description

Read registration lists (for exams or courses) from the Excel export of VIS (which actually may or may not be XLS or HTML files).

Usage

read_vis(file, ...)

vis_register(file = Sys.glob("*.xls"), subset = TRUE)

Arguments

file	character with file name of an XLS file from VIS.
...	additional arguments passed to read.xlsx.
subset	logical. Should students without confirmed registration be omitted?

Details

VIS offers Excel exports but in case of registration lists these are actually HTML files containing an HTML table. (Note that as of 2021 VIS offers an additional “real Excel” export.) HTMLtables are read using the XML package. However, some exports are also converted to actual Excel files which are read using the xlsx package. In either case some basic cleaning is done and additional meta-information is extracted.

The vis_register function loops over reading several VIS exports and then consolidates the resulting data frames.

Value

A data.frame with an additional attribute "info" providing details about the type of course ("LV") or exam ("GP").

c403 documentation built on Oct. 20, 2023, 3:01 p.m.