pyufunc.group_dt_monthly#

pyufunc.group_dt_monthly(df, interval=1, col=None)#

Group the DataFrame by month.

Parameters:

  • df (pd.DataFrame) – input DataFrame with datetime and value columns

  • interval (int, optional) – the time interval to groupby. Defaults to 1.

  • col (list, optional) – specify input column names. if your input column name is not same as default col name, use your own col name. e.g. [“your_datetime_col_name”, “your_value_col_name”]. Defaults to [“datetime”, “value”].

Returns:

grouped DataFrame by month with count, mean and sum.

Return type:

pd.DataFrame

Example

>>> import pyufunc as pf
>>> import pandas as pd
>>> df = pd.DataFrame({"datetime": pd.date_range(start="2020-01-01",
end="2020-12-31", freq="D"), "value": range(366)})
>>> pf.group_monthly(df, interval=1, col=["datetime", "value"])
The group_monthly require at least two columns
first column: datetime
second column: value
   datetime     count   mean    sum
0       2020-01-31      31      15.0    465
1       2020-02-29      29      45.0    1305
2       2020-03-31      31      75.0    2325
3       2020-04-30      30      105.5   3165
4       2020-05-31      31      136.0   4216
5       2020-06-30      30      166.5   4995
6       2020-07-31      31      197.0   6107
7       2020-08-31      31      228.0   7068
8       2020-09-30      30      258.5   7755
9       2020-10-31      31      289.0   8959
10      2020-11-30      30      319.5   9585
11      2020-12-31      31      350.0   10850