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:

tableCASTable or CASColumn

The CASTable / CASColumn to group.

bystring or list-of-strings

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

axisint, optional

Unsupported.

levelint or level-name, optional

Unsupported.

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

Unsupported.

squeezeboolean, optional

Unsupported.

Returns:

CASTableGroupBy

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

Methods

__init__(table, by[, axis, level, as_index, ...])
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

Attributes

plot	Plot using groups