class swat.cas.table.CASTableGroupBy(table, by, axis=0, level=None, as_index=True, sort=True, group_keys=True, squeeze=False, **kwargs)

Bases: object

Group CASTable / CASColumn objects by specified values

tableCASTable or CASColumn

The CASTable / CASColumn to group.

bystring or list-of-strings

The column name(s) that specify the group values.

axisint, optional


levelint or level-name, optional


as_indexboolean, optional

If True, the group labels become the index in the output.

sortboolean, optional

If True, the output is sorted by the group keys.

group_keysboolean, optional


squeezeboolean, optional


__init__(self, table, by, axis=0, level=None, as_index=True, sort=True, group_keys=True, squeeze=False, **kwargs)

Initialize self. See help(type(self)) for accurate signature.


__init__(self, table, by[, axis, level, …])

Initialize self.

css(self, \*args, \*\*kwargs)

Get css using groups

cv(self, \*args, \*\*kwargs)

Get cv using groups

describe(self, \*args, \*\*kwargs)

Get basic statistics using groups

get_group(self, name[, obj])

Construct a CASTable / CASColumn with the given group key


Get groupby variables from table

head(self, \*args, \*\*kwargs)

Retrieve first values of each group

kurt(self, \*args, \*\*kwargs)

Get kurtosis using groups

kurtosis(self, \*args, \*\*kwargs)

Get kurtosis using groups

max(self, \*args, \*\*kwargs)

Get maximum values using groups

mean(self, \*args, \*\*kwargs)

Get mean values using groups

median(self, \*args, \*\*kwargs)

Get median values using groups

min(self, \*args, \*\*kwargs)

Get minimum values using groups

mode(self, \*args, \*\*kwargs)

Get mode values using groups

nlargest(self, \*args, \*\*kwargs)

Return the n largest values ordered by columns

nmiss(self, \*args, \*\*kwargs)

Get nmiss using groups

nsmallest(self, \*args, \*\*kwargs)

Return the n smallest values ordered by columns

nth(self, n[, dropna])

Return the nth row from each group

nunique(self, \*args, \*\*kwargs)

Get number of unique values using groups

probt(self, \*args, \*\*kwargs)

Get probt using groups

quantile(self, \*args, \*\*kwargs)

Get quantiles using groups

query(self, \*args, \*\*kwargs)

Query the table with a boolean expression

skew(self, \*args, \*\*kwargs)

Get skewness using groups

skewness(self, \*args, \*\*kwargs)

Get skewness using groups

slice(self, \*args, \*\*kwargs)

Retrieve requested values of each group

std(self, \*args, \*\*kwargs)

Get std using groups

stderr(self, \*args, \*\*kwargs)

Get stderr using groups

sum(self, \*args, \*\*kwargs)

Get sum using groups

tail(self, \*args, \*\*kwargs)

Retrieve last values of each group

to_frame(self, \*\*kwargs)

Retrieve all values into a DataFrame

to_series(self[, name])

Retrieve all values into a Series

tvalue(self, \*args, \*\*kwargs)

Get tvalue using groups

unique(self, \*args, \*\*kwargs)

Get unique values using groups

uss(self, \*args, \*\*kwargs)

Get uss using groups

value_counts(self, \*args, \*\*kwargs)

Get value counts using groups

var(self, \*args, \*\*kwargs)

Get var using groups



Plot using groups