Category Archives: TidyX Screen Cast

TidyX Episode 136: Fuzzy Joins on Dates

This week, Ellis Hughes and I dig into the mailbag and respond to a viewers question regarding Fuzzy Joining with dates. We’ve previously done two episodes on Fuzzy Joining for names ( Episode 127 & Episode 132) but the viewer brought up an interesting scenario (common in sports science) where you might be trying to match the date of a discrete test with a series of days within a window of time either before or after that test date. So, we go through the ways of handling this issue and build a function to specify the type of matching you might be interested in.

To watch the screen cast, CLICK HERE.

To access our code, CLICK HERE.

TidyX Episode 134: Conditional Formatting DT tables

Last week, a viewer sent us a request via the YouTube channel asking if we could go over various ways of conditioning formatting DT tables.

We use DT a lot, especially in shiny apps, flexdahboards, and Rmarkdown reports. DT is my preferred table package when I need to make interactive tables that allow the user to sort and filter data. Conditional formatting is pretty easy in DT and this week, Ellis and I talk through using the basic functions, styleEqual() and styleInterval() to create conditionally formatted columns. We also go through more advanced conditional formatting features such as gradient conditional formatting and conditionally formatting entire rows based on the conditions of a single column.

To watch our screen cast, CLICK HERE.

To access our code, CLICK HERE.

TidyX Episode 133: Intro to Flexdashboard

Somehow we made it through 132 episodes WITHOUT talking about {Flexdashboard}!! This week, Ellis Hughes and I remedy this and go through creating a basic Flexdashboard for training load monitoring.

In the sports science and sports medicine fields building dashboards for reporting training outcomes is incredibly popular. Most are doing so in excel, which can get messy given the amount of daily work one needs to do to keep it up to date (copying, pasting, pivot tabling, etc.). Let us help you simply your life and teach you how to build an automated report in {Flexdashboard}.

To watch our screen cast, CLICK HERE.

To access our code, CLICK HERE.

TidyX Episode 132: Shiny app for fuzzy name joining

This week, Ellis Hughes and I revisit the fuzzy name joining function we wrote in Episode 127 and build it into a {shiny} app that allows users to upload a file of new data and a file of “gold standard” key names and then have the fuzzy name joining function run in the background and produce an output file of matched names.

To watch the screen cast, CLICK HERE.

To access our code, CLICK HERE.