Description Usage Arguments Value
This function is called automatically by load_sheet() if format.changed is false.
This function transforms the column types of the google sheet into appropriate data types. The location data is merged between the free-text "Other" field and the categorical choices the user can make. The other choices are transformed into factors, with the Length category transformed into an ordinal factor, increasing with the time spent at lunch. The timestamp is parsed into a POSIX-style datetime class, so that intuitive comparisons may be performed.
NOTE: If your google sheet departs from the format of the original, this function may introduce unexpected results. This function may be used as a model for any custom column transformation. I am not liable for any headache, heartache, or frustration induced by using this function on a custom sheet. You have been warned!
1 | set_columntypes(tibble)
|
tibble |
- the input data frame or tibble from the googlesheet |
tibble - transformed and renamed columns of the appropriate type
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.