Getting next Timestamp Value

Question

What is the proper solution in pandas to get the next timestamp value?

I have the following timestamp:

Timestamp('2017-11-01 00:00:00', freq='MS')

I want to get this as the result for the next timestamp value:

Timestamp('2017-12-01 00:00:00', freq='MS')

Edit:

I am working with multiple frequencies (1min, 5min, 15min, 60min, D, W-SUN, MS).

Is there a generic command to get next value?

Is the best approach to build a function that behaves accordingly to each one of the frequencies?

jezrael · Accepted Answer · 2017-11-21T10:05:32.790

3

General solution is convert strings to offset and add to timestamp:

L = ['1min', '5min', '15min', '60min', 'D', 'W-SUN', 'MS']

t = pd.Timestamp('2017-11-01 00:00:00', freq='MS')

t1 = [t + pd.tseries.frequencies.to_offset(x) for x in L]
print (t1)
[Timestamp('2017-11-01 00:01:00', freq='MS'), 
 Timestamp('2017-11-01 00:05:00', freq='MS'),
 Timestamp('2017-11-01 00:15:00', freq='MS'), 
 Timestamp('2017-11-01 01:00:00', freq='MS'),
 Timestamp('2017-11-02 00:00:00', freq='MS'), 
 Timestamp('2017-11-05 00:00:00'), 
 Timestamp('2017-12-01 00:00:00')]

edited Nov 21 '17 at 10:05

answered Nov 21 '17 at 09:27

jezrael

822,522
95
1,334
1,252

Thanks @jezrael :) – joaoavf Nov 21 '17 at 09:28
oops, I have no idea. So rather remove it. – jezrael Nov 21 '17 at 09:37
I did update the original post, could you please take a look at it? – joaoavf Nov 21 '17 at 09:53
great! I will understand what you did and then implement it in my code. thank you! – joaoavf Nov 21 '17 at 10:09

Getting next Timestamp Value

1 Answers1