Excel to Spotfire: Targeting Missing Values
In Data Science, prior to using any analytics we always face the problem of having missing values. Deciding when to delete cases or fill missing values is totally dependent on …
TERR Errors with tidyr Package
Have you had problems with TERR since the rollout of TERR 4.4 in Spotfire 7.11? Are you running into compatibility problems between package versions? Would you like to be able …
Spatial Objects Using TERR
A key part of analytics in the oil and gas industry is evaluating opportunities at different locations. Space is always present when looking for profitable development projects. We usually look …
TERR Code for Installing & Attaching CRAN Packages
Are you working with a team that shares DXPs amongst team members? Do your TERR data functions require CRAN packages to be installed? Are you worried your teammates won’t be …
TERR — Converting strings to date and time
This post explains my struggle to convert strings to Date or Time with TERR. I recently spent so much time on this that I thought it deserved a blog post. Here’s …
Part 5 – Data Function Properties
This is the fifth part of a series on Spotfire Properties. In previous posts, I discussed Document Properties, Data Table Properties, Column Properties, and Data Connection Properties. This week we’ll take a look …
RStudio Error – “ERROR r error 4”
A few weeks ago, I wrote a post on TERR compatible versions of R and RStudio. At that time, I realized I needed to update my RStudio and R versions. …
TERR Scripts to Read/Write to MS Access
Ruths.ai recently published a free template on the Ruths.ai Exchange that reads and writes data from/to MS Access. Under the covers, you’ll find two property controls and two data functions working with the …
Installing Packages in TERR versus RStudio and R
Are you just getting started with R or TERR? Are you struggling with installing packages? Does it seem like RStudio or R and TERR work differently when it comes to …
Compatible Versions of TERR, RStudio and R
Do you know how to check which version of TERR is installed on your Spotfire installation? Are you unsure of which versions of R or RStudio to download so that …