/**
Alias Frequency
B: business day frequency
D: calendar day frequency
W: weekly frequency
M: month end frequency
BM: business month end frequency
MS: month start frequency
BMS: business month start frequency
Q: quarter end frequency
BQ: business quarter endfrequency
QS: quarter start frequency
BQS: business quarter start frequency
A: year end frequency
BA: business year end frequency
AS: year start frequency
BAS: business year start frequency
H: hourly frequency
T: minutely frequency
S: secondly frequency
L: milliseonds
U: microseconds
**/
import pandas as pd
from datetime import timedelta
import numpy as np
index = pd.date_range(‘20200101’, ‘20200331’, freq=‘D’)
data = np.random.random(len(index))
#print(data)
a = pd.Series(index=index, data=data)
print(a)
#ret = a.resample(‘MS’, closed=‘left’, label=‘left’).sum()
ret = a.resample(‘M’,closed=‘right’,label=‘right’).sum()
ret.index = ret.index - timedelta(days=1)
ret = ret.resample(‘M’).sum()
ret.index = ret.index.strftime(’%Y-%m’)
print(ret)