Data Exploration in XDF Files using ScaleR Functions

[SQL-Server-Team]

First published on MSDN on Dec 28, 2016
In this article, let us see few examples to explore data in XDF Files using ScaleR functions. For all the following examples, we will be using input XDF file AirlineDemoSmall.xdf from the SampleData Directory in Microsoft R Server .

1. Obtain the different types of variables present in the dataset

OUTPUT :

2. Obtain the frequency table of different types of variables present in the dataset

OUTPUT :

3. Obtain the quantile of numeric variables in the dataset

OUTPUT :

4. Obtain the TOTAL_OBSERVATIONS, VALID_OBSERVATIONS, MISSING_OBSERVATIONS, MISSING_PERCENTAGE, DISTINCT_CATEGORIES of all variables in the dataset

OUTPUT :

5. Obtain the frequency table of a particular variable in the dataset

OUTPUT :

REFERENCES

RevoScaleR Functions

Comparison of Base R and ScaleR Functions

A simple Big Data analysis using the RevoScaleR package in Revolution R