Pandas resample changes dates

Question

Why is df.resample() changing the dates when I resample?

X

What I want this to do is insert one row with index '2014-07-01' and value NaN.

X.resample('12M').last()

`

score 2 · Accepted Answer · answered Aug 26 '21 at 23:46

2

Try with MS

out = df.resample('12MS').first()
Out[33]: 
              0
2014-07-01  1.0
2015-07-01  NaN
2016-07-01  2.0
2017-07-01  3.0

answered Aug 26 '21 at 23:46

BENY

This worked! Thank you. Can you explain the difference, and where I can find more info about these codes? – Mose Wintner Aug 26 '21 at 23:50
@MoseWintner MS is for Month start , default is Month End ~ – BENY Aug 26 '21 at 23:58

1 Answers1