Function reference • dfeR

Database connection

Helpful functions for connecting to databases in DfE

get_clean_sql(): Get a cleaned SQL script into R

Presentation prettifiers

Functions for presenting pretty versions of numbers with readable code

pretty_filesize(): Pretty numbers into readable file size

pretty_num(): Prettify big numbers into a readable format

pretty_time_taken(): Calculate elapsed time between two points and present prettily

Specific formats

Functions for converting to specific formats

format_ay(): Format academic year

format_ay_reverse(): Undo academic year formatting

format_fy(): Format financial year

format_fy_reverse(): Undo financial year formatting

Helpers

Functions used in other functions across the package, also useful in their own right

round_five_up(): Round five up

comma_sep(): Comma separate