Pandas DataFrame.resample() Function
-
Syntax of
pandas.DataFrame.resample()
: -
Example Codes:
DataFrame.resample()
Method to Resample the Data of Series on Weekly Basis -
Example Codes:
DataFrame.resample()
Method to Resample the Data of Series on Monthly Basis
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.
Contribute
DelftStack is a collective effort contributed by software geeks like you. If you like the article and would like to contribute to DelftStack by writing paid articles, you can check the write for us page.