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
-
__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.
Methods
__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_vars(self)
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
Attributes
plot
Plot using groups