pyufunc.group_dt_weekly#

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

Group the DataFrame by week.

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 week 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_weekly(df, interval=1, col=["datetime", "value"])
The group_weekly require at least two columns
first column: datetime
second column: value
   datetime     count   mean    sum
0       2020-01-05      5       2.0     10
1       2020-01-12      7       8.0     56
2       2020-01-19      7       15.0    105
3       2020-01-26      7       22.0    154
4       2020-02-02      7       29.0    203