The previous section briefly introduced the R syntax. We worked with scalar variables and simple vectors. A set of vectors is called a data.frame. data.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:
- Read the ProductsWithCategories.csv file from disk to a data.frame
- Check for the data type of the ListPrice column, ...