Pandas Groupby¶
Indexing, iteration¶
- GroupBy.__iter__
Groupby iterator.
Unsupported by Intel SDC.
- GroupBy.groups
Dict {group name -> group labels}.
Unsupported by Intel SDC.
- GroupBy.indices
Dict {group name -> group indices}.
Unsupported by Intel SDC.
- GroupBy.get_group
Construct DataFrame from group with provided name.
Unsupported by Intel SDC.
- Grouper
A Grouper allows the user to specify a groupby instruction for a target object
Unsupported by Intel SDC.
Function application¶
- GroupBy.apply
Apply function func group-wise and combine the results together.
Unsupported by Intel SDC.
- GroupBy.agg
Unsupported by Intel SDC.
- GroupBy.aggregate
Unsupported by Intel SDC.
- GroupBy.transform
Unsupported by Intel SDC.
- GroupBy.pipe
Apply a function func with arguments to this GroupBy object and return the function’s result.
Unsupported by Intel SDC.
Computations / descriptive stats¶
- GroupBy.all
Return True if all values in the group are truthful, else False.
Unsupported by Intel SDC.
- GroupBy.any
Return True if any value in the group is truthful, else False.
Unsupported by Intel SDC.
- GroupBy.bfill
Backward fill the values.
Unsupported by Intel SDC.
- GroupBy.count
Compute count of group, excluding missing values.
- GroupBy.cumcount
Number each item in each group from 0 to the length of that group - 1.
Unsupported by Intel SDC.
- GroupBy.cummax
Cumulative max for each group.
Unsupported by Intel SDC.
- GroupBy.cummin
Cumulative min for each group.
Unsupported by Intel SDC.
- GroupBy.cumprod
Cumulative product for each group.
Unsupported by Intel SDC.
- GroupBy.cumsum
Cumulative sum for each group.
Unsupported by Intel SDC.
- GroupBy.ffill
Forward fill the values.
Unsupported by Intel SDC.
- GroupBy.first
Compute first of group values.
Unsupported by Intel SDC.
- GroupBy.head
Return first n rows of each group.
Unsupported by Intel SDC.
- GroupBy.last
Compute last of group values.
Unsupported by Intel SDC.
- GroupBy.max
Compute max of group values.
- GroupBy.mean
Compute mean of groups, excluding missing values.
- GroupBy.median
Compute median of groups, excluding missing values.
- GroupBy.min
Compute min of group values.
- GroupBy.ngroup
Number each group from 0 to the number of groups - 1.
Unsupported by Intel SDC.
- GroupBy.nth
Take the nth row from each group if n is an int, or a subset of rows if n is a list of ints.
Unsupported by Intel SDC.
- GroupBy.ohlc
Compute sum of values, excluding missing values.
Unsupported by Intel SDC.
- GroupBy.prod
Compute prod of group values.
- GroupBy.rank
Provide the rank of values within each group.
Unsupported by Intel SDC.
- GroupBy.pct_change
Calculate pct_change of each value to previous entry in group.
Unsupported by Intel SDC.
- GroupBy.size
Compute group sizes.
Unsupported by Intel SDC.
- GroupBy.sem
Compute standard error of the mean of groups, excluding missing values.
Unsupported by Intel SDC.
- GroupBy.std
Compute standard deviation of groups, excluding missing values.
- GroupBy.sum
Compute sum of group values.
- GroupBy.var
Compute variance of groups, excluding missing values.
- GroupBy.tail
Return last n rows of each group.
Unsupported by Intel SDC.
The following methods are available in both SeriesGroupBy and DataFrameGroupBy objects, but may differ slightly,
usually in that the DataFrameGroupBy version usually permits the specification of an axis argument,
and often an argument indicating whether to restrict application to columns of a specific data type.
- DataFrameGroupBy.all
Return True if all values in the group are truthful, else False.
Unsupported by Intel SDC.
- DataFrameGroupBy.any
Return True if any value in the group is truthful, else False.
Unsupported by Intel SDC.
- DataFrameGroupBy.bfill
Backward fill the values.
Unsupported by Intel SDC.
- DataFrameGroupBy.corr
Compute pairwise correlation of columns, excluding NA/null values.
Unsupported by Intel SDC.
- DataFrameGroupBy.count
Compute count of group, excluding missing values.
Unsupported by Intel SDC.
- DataFrameGroupBy.cov
Compute pairwise covariance of columns, excluding NA/null values.
Unsupported by Intel SDC.
- DataFrameGroupBy.cummax
Cumulative max for each group.
Unsupported by Intel SDC.
- DataFrameGroupBy.cummin
Cumulative min for each group.
Unsupported by Intel SDC.
- DataFrameGroupBy.cumprod
Cumulative product for each group.
Unsupported by Intel SDC.
- DataFrameGroupBy.cumsum
Cumulative sum for each group.
Unsupported by Intel SDC.
- DataFrameGroupBy.describe
Generate descriptive statistics that summarize the central tendency, dispersion and shape of a dataset’s distribution, excluding
NaNvalues.Unsupported by Intel SDC.
- DataFrameGroupBy.diff
First discrete difference of element.
Unsupported by Intel SDC.
- DataFrameGroupBy.ffill
Forward fill the values.
Unsupported by Intel SDC.
- DataFrameGroupBy.fillna
Fill NA/NaN values using the specified method.
Unsupported by Intel SDC.
- DataFrameGroupBy.filter
Return a copy of a DataFrame excluding elements from groups that do not satisfy the boolean criterion specified by func.
Unsupported by Intel SDC.
- DataFrameGroupBy.hist
Make a histogram of the DataFrame’s.
Unsupported by Intel SDC.
- DataFrameGroupBy.idxmax
Return index of first occurrence of maximum over requested axis. NA/null values are excluded.
Unsupported by Intel SDC.
- DataFrameGroupBy.idxmin
Return index of first occurrence of minimum over requested axis. NA/null values are excluded.
Unsupported by Intel SDC.
- DataFrameGroupBy.mad
Return the mean absolute deviation of the values for the requested axis.
Unsupported by Intel SDC.
- DataFrameGroupBy.nunique
Return DataFrame with number of distinct observations per group for each column.
Unsupported by Intel SDC.
- DataFrameGroupBy.pct_change
Calculate pct_change of each value to previous entry in group.
Unsupported by Intel SDC.
- DataFrameGroupBy.plot
Class implementing the .plot attribute for groupby objects.
Unsupported by Intel SDC.
- DataFrameGroupBy.quantile
Return group values at the given quantile, a la numpy.percentile.
Unsupported by Intel SDC.
- DataFrameGroupBy.rank
Provide the rank of values within each group.
Unsupported by Intel SDC.
- DataFrameGroupBy.resample
Provide resampling when using a TimeGrouper.
Unsupported by Intel SDC.
- DataFrameGroupBy.shift
Shift each group by periods observations.
Unsupported by Intel SDC.
- DataFrameGroupBy.size
Compute group sizes.
Unsupported by Intel SDC.
- DataFrameGroupBy.skew
Return unbiased skew over requested axis Normalized by N-1.
Unsupported by Intel SDC.
- DataFrameGroupBy.take
Return the elements in the given positional indices along an axis.
Unsupported by Intel SDC.
- DataFrameGroupBy.tshift
Shift the time index, using the index’s frequency if available.
Unsupported by Intel SDC.
The following methods are available only for SeriesGroupBy objects.
- SeriesGroupBy.nlargest
Return the largest n elements.
Unsupported by Intel SDC.
- SeriesGroupBy.nsmallest
Return the smallest n elements.
Unsupported by Intel SDC.
- SeriesGroupBy.nunique
Return number of unique elements in the group.
Unsupported by Intel SDC.
- SeriesGroupBy.unique
Return unique values of Series object.
Unsupported by Intel SDC.
- SeriesGroupBy.value_counts
Unsupported by Intel SDC.
- SeriesGroupBy.is_monotonic_increasing
Return boolean if values in the object are monotonic_increasing.
Unsupported by Intel SDC.
- SeriesGroupBy.is_monotonic_decreasing
Return boolean if values in the object are monotonic_decreasing.
Unsupported by Intel SDC.
The following methods are available only for DataFrameGroupBy objects.
- DataFrameGroupBy.corrwith
Compute pairwise correlation between rows or columns of DataFrame with rows or columns of Series or DataFrame. DataFrames are first aligned along both axes before computing the correlations.
Unsupported by Intel SDC.
- DataFrameGroupBy.boxplot
Make box plots from DataFrameGroupBy data.
Unsupported by Intel SDC.