Overview

Spotfire makes it easy for you to analyze data from any number of data sources. Using this data, you can create predictive models and apply advanced techniques within the Spotfire environment. You can also use R models and run them within Spotfire using the in-built Spotfire® Enterprise Runtime for R (TERR)  engine, as well as leveraging advanced analytics from Python. You can seamlessly go from data to charts, charts to charts, and charts to data which gives you complete flexibility in how you want to analyze data and take advantage of advanced modeling techniques. You spend time generating insights from your data rather than working on the logistics of data and multiple tools.

Once you create an analysis, you can easily share this interactive analysis with others via the Spotfire Library and Spotfire Web Player.

What's a Data Function

In the broadest sense, a Data Function is an operation you perform on your data. In the simplest terms, for the purposes of this page, Data Functions are R and Python scripts to extend your Spotfire analytics experience. The functions themselves operate on Spotfire input data in the form of Data Tables, Data Columns, and Property variables. If you'd like, the Data Functions may be dynamically re-computed using interactive chart selections (markings) and filters, all triggering new calculations in Spotfire's memory and not requiring the user to manage the storage of resulting information. The resulting information (data results) is outputted in the same format types as input data: Data Tables, Columns, and Property variables.

Data Functions may be extended to uses with other languages like Statistica®, KNIME, and more. These concepts are excluded from this companion, but good to be aware of.

Useful Resources: 

• Watch this tutorial: Script with Python and R using Data Functions
• FAQ: Python Data Functions in Spotfire®
• Tips and Tricks for Working with Python in Spotfire
• Tips on Debugging TIBCO® Enterprise Runtime for R Scripts in Spotfire® Data/Expression Functions
• How to Install R Packages for use with Spotfire Analyst Client

Available Data Functions

While you can always create your own data functions, this page is a guide to easy-to-use prebuilt functions from Spotfire's Data Science Team. These data functions are all built in a generalized format -- something you can quickly plug-and-play into your own Spotfire analyses. Many are hosted for FREE DOWNLOAD on the Community Exchange. Here's a 90-second helper video if you need it.

Download the following available Data Functions: 

Exploratory Data Analysis

• Column Correlation [Python]
• Distribution Testing **
• Statistical Outlier Analysis **

Data Preparation / Feature Engineering and Transformation

• One-Hot Encoder [Python]
• Time-Series Feature Generation [Python] **
• PCA Principal Component Analysis [Python]
• Dynamic Unpivot [TERR]
• Sort Data Table  [TERR/R] 
• Identify Duplicates  [TERR/R]
• Remove Duplicates [TERR/R]
• Fuzzy String Match [Python]
• NLP Tagging [Python]
• Linear Interpolation [TERR/R]
• Decline Curve Analysis [TERR/R]

Modeling and Prediction

• Random Forest [Python]
• Isolation Forest [Python]
• SVM Support Vector Machine [Python]
• Logistic Regression [Python]
• Local Outlier Factor [Python]
• TensorFlow Regression and Classification [Python]
• TensorFlow Autoencoder [Python]
• K-Means Clustering [Python]
• GBM Gradient Boosted Machines Regression [TERR/R]
• NLP Toolkit - Features, Entities, Sentiment [Python]
• Data Smoothing [TERR/R]
• Holt Winters Forecasting [TERR/R]
• Market Basket Analysis [Python]

Model Evaluation

• Model Evaluation Python Toolkit [Python]
• Dunn Index [Python]

Model Explainability

• Model Explainability Python Toolkit [Python]

Cloud Vendor Tools

• Sagemaker Autopilot [AWS]

Geospatial Analysis

• Spatial Heatmap [TERR/R]
• Spatial Density Heatmap [TERR]
• Contour Plot [TERR/R]
• Points-in-Polygons (Geofencing) [TERR/R]
• Voronoi Polygons [TERR]
• Spatial Interpolation [TERR/R]
• Convert Lines to Points [TERR/R]
• Convert Points to Polygon [TERR/R]
• Hexbin [TERR]
• Spatial Join [TERR/R]
• Geocoder [TERR]
• Reverse Geocoder [TERR/R]
• Calculate Travel Route [TERR]
• Trade Area from GPS Coordinate [TERR/R]
• Trade Area from Address [TERR]
• Driving Distance Matrix [TERR]
• Area of Polygons [TERR/R]
• Draw Circular Radius [TERR/R]
• Draw Bounding Box [TERR/R]
• Transform CRS from Shapefile by EPSG Code [TERR]
• Transform CRS from Shapefile by PROJ.4 String [TERR]
• Transform CRS for Points by EPSG Code [TERR]
• Transform CRS for Points by PROJ.4 String [TERR/R]
• Nearest Neighbors [TERR/R]
• Distance Matrix [TERR/R]
• Export to Shapefile [TERR]

Dataset Downloaders

• COVID-19 Data [TERR/R]
• Twitter Search [TERR]
• Online CSV Reader [TERR/R]

** Coming Soon!