From the course: Complete Guide to Advanced SQL Server
Unlock the full course today
Join today to access over 24,400 courses taught by industry experts.
Functions in the revoscalepy package - SQL Server Tutorial
From the course: Complete Guide to Advanced SQL Server
Functions in the revoscalepy package
In addition to the libraries provided by Anaconda, Microsoft includes two of their own libraries when you install Machine Learning Services. The first one is called revoscalepy. revoscalepy contains a number of functions that are useful for working with the kinds of data sources that you're likely to find in large-scale SQL Server environments, such as big data clusters. For instance, there are functions that will help you access data stored in Apache Parquet files or dive into data that's on a Hadoop distributed file system. You can work with data through an ODBC connection or load data from a text file such as CSV. revoscalepy contains additional functions for creating statistical models, and statisticians might find these functions useful in their analysis work. Functions such as rx_lin_mod, which creates linear regression models, or rx_dforest that fit classification and regression decision forests. Then once a model is created, rx_predict can generate predictions and scores on a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
(Locked)
The Anaconda open-source packages7m 27s
-
(Locked)
Functions in the revoscalepy package1m 48s
-
(Locked)
Model, train, and score with microsoftml1m 16s
-
(Locked)
Produce graphics with Matplotlib7m 53s
-
(Locked)
Get descriptive statistics with pandas7m 45s
-
(Locked)
Challenge: Sample a DataFrame1m 12s
-
(Locked)
Solution: Sample a DataFrame5m 21s
-
(Locked)
-
-
-
-
-