swat.cas.table.CASTableGroupBy

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

Parameters:
table : CASTable or CASColumn

The CASTable / CASColumn to group.

by : string or list-of-strings

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

axis : int, optional

Unsupported.

level : int or level-name, optional

Unsupported.

as_index : boolean, optional

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

sort : boolean, optional

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

group_keys : boolean, optional

Unsupported.

squeeze : boolean, optional

Unsupported.

Returns:
CASTableGroupBy
__init__(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.

Methods

__init__(table, by[, axis, level, as_index, …]) Initialize self.
css(*args, **kwargs) Get css using groups
cv(*args, **kwargs) Get cv using groups
describe(*args, **kwargs) Get basic statistics using groups
get_group(name[, obj]) Construct a CASTable / CASColumn with the given group key
get_groupby_vars() Get groupby variables from table
head(*args, **kwargs) Retrieve first values of each group
kurt(*args, **kwargs) Get kurtosis using groups
kurtosis(*args, **kwargs) Get kurtosis using groups
max(*args, **kwargs) Get maximum values using groups
mean(*args, **kwargs) Get mean values using groups
median(*args, **kwargs) Get median values using groups
min(*args, **kwargs) Get minimum values using groups
mode(*args, **kwargs) Get mode values using groups
nlargest(*args, **kwargs) Return the n largest values ordered by columns
nmiss(*args, **kwargs) Get nmiss using groups
nsmallest(*args, **kwargs) Return the n smallest values ordered by columns
nth(n[, dropna]) Return the nth row from each group
nunique(*args, **kwargs) Get number of unique values using groups
probt(*args, **kwargs) Get probt using groups
quantile(*args, **kwargs) Get quantiles using groups
query(*args, **kwargs) Query the table with a boolean expression
skew(*args, **kwargs) Get skewness using groups
skewness(*args, **kwargs) Get skewness using groups
slice(*args, **kwargs) Retrieve requested values of each group
std(*args, **kwargs) Get std using groups
stderr(*args, **kwargs) Get stderr using groups
sum(*args, **kwargs) Get sum using groups
tail(*args, **kwargs) Retrieve last values of each group
to_frame(**kwargs) Retrieve all values into a DataFrame
to_series([name]) Retrieve all values into a Series
tvalue(*args, **kwargs) Get tvalue using groups
unique(*args, **kwargs) Get unique values using groups
uss(*args, **kwargs) Get uss using groups
value_counts(*args, **kwargs) Get value counts using groups
var(*args, **kwargs) Get var using groups