Cleaning and Enriching Data with the CASE Expression

Cleaning and Enriching Data with the CASE Expression

The CASE expression is one of the most important functions for cleaning and enriching data. CASE evaluates a column or group of columns against one or more conditions and then returns an expression. This is  helpful for cutting data into…

When to use Relational Databases

When to use Relational Databases

Relational database management systems (RDBMS) provide a cornerstone for many apps and services. By technology standards, RDBMS are ancient. Strong theoretical underpinnings have kept RDBMS technologies relevant in a volatile industry. Even non-relational data stores have had to add RDBMS-like…

Can Today’s Headlines Predict Tomorrow’s Stock Prices?

Can Today’s Headlines Predict Tomorrow’s Stock Prices?

Let’s pretend we’re back in 2016 for a moment. It's the morning of Tuesday February 9th.  You are ready to take on the day right after you check Reuters news.  A bearish headline catches your eye:  “SE Asia…

Rstudio::conf 2019 Takeaways

Rstudio::conf 2019 Takeaways

The Rstudio team threw a solid conference 01/14/2019 - 01/18/2019 in Austin Texas. At one point I heard a conference speaker same something like, “R has something for everyone.” Trying to please everyone is risky, but…

Privacy Policy