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: -
__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