[PYTHON] Display and analyze only some columns in CASTable

SAS Viya is an AI platform. It is available through languages such as Python, Java and R. A table object called CASTable is used in SAS Viya (CAS stands for Cloud Analytic Services). This time, I will introduce how to extract only some columns and display the information in CASTable.

Get a table from the database

First, connect to SAS Viya.

import swat
conn = swat.CAS('server-name.mycompany.com', 5570, 'username', 'password')

Then get the CASTable. This time, I will use CSV of IRIS data.

tbl = conn.loadtable('data/iris.csv', caslib='casuser').casTable

Get the column

You can retrieve the column by specifying the key with tbl as the dict.

col = tbl['sepal_width']
col

The output looks like this:

CASColumn('DATA.IRIS', caslib='CASUSER(username)')['sepal_width'].sort_values(['sepal_length', 'sepal_width'], ascending=[False, True])

View data

If you use the head method of a column, only the value of that column will be output.

col.head()

0    3.8
1    2.6
2    2.8
3    3.0
4    3.8
Name: sepal_width, dtype: float64

Get multiple columns

Similarly, if you give the key as an array, you can get multiple columns.

widths = tbl[['sepal_width', 'petal_width', 'species']]

The contents are as follows.

You can also check the summary of the data.

widths.describe()

The column information is displayed in the same way.

widths.columninfo()

Summary

If you get some columns, you can narrow down the analysis to only the ones you need even if the table has many columns. It can be used when there is too much numerical data and you do not know where to analyze.

SAS for Developers | SAS