William Chiu comments

Results 6 comments of


                                            William Chiu

Stamp fails on a basic input

I was able to reproduce the bug using `lubridate_1.7.4`. ```r > library(lubridate) > > x myDateStamp > myDateStamp(x) [1] "My date is Saturday, July 19, 2700." ``` My session info:...

ODBC driver does not effectively take advantage of parallelization in Snowflake (INSERTs are sequential and slow)

A workaround to improve writes to a Snowflake table is to create a Snowflake "stage" and use the PUT-COPY-INTO commands. Examples adopted from https://github.com/snowflakedb/dplyr-snowflakedb (deprecated). Step 1: Write the data...

dbWriteTable unable to append data to existing Snowflake table

Reprex simplified. The work-around is to replace the second `dbWriteTable` with `dbAppendTable`.

dbWriteTable unable to append data to existing Snowflake table

I added the traceback manually. Reprex does not appear to support traceback.

Leave-one-out cross validation is very valuable

LOOCV is computationally prohibitive (which makes it unpopular). However, it has the least amount of bias and the lowest variance among the alternatives (e.g., 3-fold, 5-fold, and 10-fold): https://github.com/crossxwill/K_fold_cv/blob/main/k_fold_cv.pdf (scroll...

How exactly does "the usual bootstrap" work?

https://www.tmwr.org/resampling.html#bootstrap