Pandas DataFrame.resample() Function

Minahil Noor Jan 30, 2023
  1. Syntax of pandas.DataFrame.resample():
  2. Example Codes: DataFrame.resample() Method to Resample the Data of Series on Weekly Basis
  3. Example Codes: DataFrame.resample() Method to Resample the Data of Series on Monthly Basis
Pandas DataFrame.resample() Function

Python Pandas DataFrame.resample() function resamples the time-series data.

Syntax of pandas.DataFrame.resample():

DataFrame.resample(
    rule,
    axis=0,
    closed=None,
    label=None,
    convention="start",
    kind=None,
    loffset=None,
    base=None,
    on=None,
    level=None,
    origin="start_day",
    offset=None,
)

Parameters

rule It is the offset string or object representing target conversion.
axis It specifies which axis to use for up or down-sampling. For Series, this will default to 0, which means along the rows.
closed It specifies which side of the bin interval is closed. It has two options: right or left.
label It specifies bin edge label to label bucket with. It has two options: right or left.
convention It has four options: start, end, s, or e. For PeriodIndex only, it uses the start or end of the rule.
kind It specifies the kind of resulting index. It has two options: timestamp or period. Timestamp converts the resulting index to a DateTimeIndex, and period converts it to a PeriodIndex.
loffset It adjusts the resampled time labels.
base It is an integer. Its default value is 0.
on It represents the name of the column to use instead of the index for resampling. The column must be datetime-like.
level It represents the name of level to use for resampling. The level must be datetime-like.
origin It is the timestamp on which to adjust the grouping. It has three options: epoch, start, or start_day.
offset It represents an offset timedelta added to the origin parameter.

Return

It returns the resampled object.

Example Codes: DataFrame.resample() Method to Resample the Data of Series on Weekly Basis

import pandas as pd

index = pd.date_range('1/1/2021', periods=30, freq='D')
series = pd.Series(range(30), index=index)
print("The Original Series is: \n")
print(series)

series1= series.resample('W').sum()
print("The Resampled Data is: \n")
print(series1)

Output:

The Original Series is: 

2021-01-01     0
2021-01-02     1
2021-01-03     2
2021-01-04     3
2021-01-05     4
2021-01-06     5
2021-01-07     6
2021-01-08     7
2021-01-09     8
2021-01-10     9
2021-01-11    10
2021-01-12    11
2021-01-13    12
2021-01-14    13
2021-01-15    14
2021-01-16    15
2021-01-17    16
2021-01-18    17
2021-01-19    18
2021-01-20    19
2021-01-21    20
2021-01-22    21
2021-01-23    22
2021-01-24    23
2021-01-25    24
2021-01-26    25
2021-01-27    26
2021-01-28    27
2021-01-29    28
2021-01-30    29
Freq: D, dtype: int64
The Resampled Data is: 

2021-01-03      3
2021-01-10     42
2021-01-17     91
2021-01-24    140
2021-01-31    159
Freq: W-SUN, dtype: int64

The function has returned the resampled sum on a weekly basis.

Example Codes: DataFrame.resample() Method to Resample the Data of Series on Monthly Basis

import pandas as pd

index = pd.date_range('1/1/2021', periods=30, freq='D')
series = pd.Series(range(30), index=index)
print("The Original Series is: \n")
print(series)

series1= series.resample('M').sum()
print("The Resampled Data is: \n")
print(series1)

Output:

The Original Series is: 

2021-01-01     0
2021-01-02     1
2021-01-03     2
2021-01-04     3
2021-01-05     4
2021-01-06     5
2021-01-07     6
2021-01-08     7
2021-01-09     8
2021-01-10     9
2021-01-11    10
2021-01-12    11
2021-01-13    12
2021-01-14    13
2021-01-15    14
2021-01-16    15
2021-01-17    16
2021-01-18    17
2021-01-19    18
2021-01-20    19
2021-01-21    20
2021-01-22    21
2021-01-23    22
2021-01-24    23
2021-01-25    24
2021-01-26    25
2021-01-27    26
2021-01-28    27
2021-01-29    28
2021-01-30    29
Freq: D, dtype: int64
The Resampled Data is: 

2021-01-31    435
Freq: M, dtype: int64

The function has returned the resampled sum on a monthly basis.

Related Article - Pandas DataFrame