Working example of Z-score computed in R

The previous section briefly introduced the R syntax. We worked with scalar variables and simple vectors. A set of vectors is called a data.framedata.frame is an important base for every further calculation over datasets. Let's make this calculation.

We calculated a standardized value called Z-score in the Introduction section. Now we will calculate the Z-score one more time, but with R. For the following example, we will use the ProductsWithCategories.csv file created in the Using Integraton Services for data transformation section. To calculate Z-score, perform the following steps:

  1. Read the ProductsWithCategories.csv file from disk to a data.frame
  2. Check for the data type of the ListPrice column, ...

Get Hands-On Data Science with SQL Server 2017 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.