Publications by rstats-tips.net

Custom Formats in gt Tables

The “grammar of tables” is used to build tables with the R-package gt. Thomas Mock published an extension package called gtExtras which is used all over in tweets about NFL and Fantasy Football such as win and loss history information in a table. gt follows a similar philosophy such as ggplot2. On the one hand there is the data to be shown (i...

1958 sym R (1491 sym/10 pcs) 9 tbl

Accessing Snowflake with R

Snowflake is a well known cloud-based database. It’s used for Data Warehouses and other big data applications. In this article and the following ones I want to show how to setup and access a snowflake database from various clients such as R, Tableau and PowerBI. So let’s start using R. Setup Snowflake Assuming that we already have access to a...

3626 sym R (4183 sym/30 pcs) 18 img 15 tbl

Lists to Data.Frames with imap

When working with data which is a result of json-data converted to a list of lists of lists of lists … (you know what mean ;-)) I often want to convert it a data.frame. Unfortunately there’s often a list in the source data which is unnamed. Or the list in one row is longer than the one in another row. So converting it straight forward into a ...

1739 sym R (1408 sym/18 pcs) 9 tbl