Ggtcf

Trouble understanding overseas colleagues

Why are on-board computers allowed to change controls without notifying the pilots?

What would happen if the UK refused to take part in EU Parliamentary elections?

How does it work when somebody invests in my business?

Greatest common substring

Coordinate position not precise

Was the picture area of a CRT a parallelogram (instead of a true rectangle)?

Generic lambda vs generic function give different behaviour

Bash method for viewing beginning and end of file

Why is delta-v is the most useful quantity for planning space travel?

Why Were Madagascar and New Zealand Discovered So Late?

Irreducibility of a simple polynomial

Teaching indefinite integrals that require special-casing

Cynical novel that describes an America ruled by the media, arms manufacturers, and ethnic figureheads

Increase performance creating Mandelbrot set in python

What are the ramifications of creating a homebrew world without an Astral Plane?

How will losing mobility of one hand affect my career as a programmer?

Student evaluations of teaching assistants

Everything Bob says is false. How does he get people to trust him?

How to verify if g is a generator for p?

What is difference between behavior and behaviour

If you attempt to grapple an opponent that you are hidden from, do they roll at disadvantage?

Is HostGator storing my password in plaintext?

Personal Teleportation as a Weapon

Pandas DateOffset, step back one day

How to subtract a day from a date?Add days to JavaScript DateCalculate difference between two dates (number of days)?Renaming columns in pandasAdding new column to existing DataFrame in Python pandasDelete column from pandas DataFrame by column name“Large data” work flows using pandasHow to iterate over rows in a DataFrame in Pandas?Select rows from a DataFrame based on values in a column in pandasPandas 0.18 vs 0.12 performance

6

1

I try to understand why

print(pd.Timestamp("2015-01-01") - pd.DateOffset(day=1))

does not result in

pd.Timestamp("2014-12-31")

I am using Pandas 0.18. I run within the CET timezone.

date pandas

share|improve this question

asked Apr 21 '16 at 8:51

tschmtschm

1,30021932

add a comment | 

6

1

I try to understand why

print(pd.Timestamp("2015-01-01") - pd.DateOffset(day=1))

does not result in

pd.Timestamp("2014-12-31")

I am using Pandas 0.18. I run within the CET timezone.

date pandas

share|improve this question

asked Apr 21 '16 at 8:51

tschmtschm

1,30021932

add a comment | 

I try to understand why

print(pd.Timestamp("2015-01-01") - pd.DateOffset(day=1))

does not result in

pd.Timestamp("2014-12-31")

I am using Pandas 0.18. I run within the CET timezone.

date pandas

share|improve this question

asked Apr 21 '16 at 8:51

tschmtschm

1,30021932

print(pd.Timestamp("2015-01-01") - pd.DateOffset(day=1))

pd.Timestamp("2014-12-31")

share|improve this question

asked Apr 21 '16 at 8:51

tschmtschm

1,30021932

share|improve this question

asked Apr 21 '16 at 8:51

tschmtschm

1,30021932

asked Apr 21 '16 at 8:51

tschmtschm

1,30021932

asked Apr 21 '16 at 8:51

tschmtschm

1,30021932

2 Answers
2

active

oldest

votes

7

There is typo, you need add s to day - days. But it is very interesting, that it not raise error.

print(pd.Timestamp("2015-01-01") - pd.DateOffset(days=1))
2014-12-31 00:00:00

Another solution:

print(pd.Timestamp("2015-01-01") - pd.offsets.Day(1))
2014-12-31 00:00:00

Oalso is possible subtract Timedelta:

print(pd.Timestamp("2015-01-01") - pd.Timedelta(1, unit='d'))

share|improve this answer

edited Mar 8 at 9:29

answered Apr 21 '16 at 8:55

jezraeljezrael

351k26315391

add a comment | 

1

Day(d) and DateOffset(days=d) do not behave exactly the same when used on timestamps with timezone information (at least on pandas 0.18.0). It looks like DateOffset add 1 day while keeping the hour information while Day adds just 24 hours of elapsed time.

>>> # 30/10/2016 02:00+02:00 is the hour before the DST change
>>> print(pd.Timestamp("2016-10-30 02:00+02:00", tz="Europe/Brussels") + pd.offsets.Day(1))
2016-10-31 01:00:00+01:00
>>> print(pd.Timestamp("2016-10-30 02:00+02:00", tz="Europe/Brussels") + pd.DateOffset(days=1))
2016-10-31 02:00:00+01:00

share|improve this answer

answered Sep 24 '16 at 16:33

sdementensdementen

9924

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f36764487%2fpandas-dateoffset-step-back-one-day%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

7

There is typo, you need add s to day - days. But it is very interesting, that it not raise error.

print(pd.Timestamp("2015-01-01") - pd.DateOffset(days=1))
2014-12-31 00:00:00

Another solution:

print(pd.Timestamp("2015-01-01") - pd.offsets.Day(1))
2014-12-31 00:00:00

Oalso is possible subtract Timedelta:

print(pd.Timestamp("2015-01-01") - pd.Timedelta(1, unit='d'))

share|improve this answer

edited Mar 8 at 9:29

answered Apr 21 '16 at 8:55

jezraeljezrael

351k26315391

add a comment | 

7

There is typo, you need add s to day - days. But it is very interesting, that it not raise error.

print(pd.Timestamp("2015-01-01") - pd.DateOffset(days=1))
2014-12-31 00:00:00

Another solution:

print(pd.Timestamp("2015-01-01") - pd.offsets.Day(1))
2014-12-31 00:00:00

Oalso is possible subtract Timedelta:

print(pd.Timestamp("2015-01-01") - pd.Timedelta(1, unit='d'))

share|improve this answer

edited Mar 8 at 9:29

answered Apr 21 '16 at 8:55

jezraeljezrael

351k26315391

add a comment | 

There is typo, you need add s to day - days. But it is very interesting, that it not raise error.

print(pd.Timestamp("2015-01-01") - pd.DateOffset(days=1))
2014-12-31 00:00:00

Another solution:

print(pd.Timestamp("2015-01-01") - pd.offsets.Day(1))
2014-12-31 00:00:00

Oalso is possible subtract Timedelta:

print(pd.Timestamp("2015-01-01") - pd.Timedelta(1, unit='d'))

share|improve this answer

edited Mar 8 at 9:29

answered Apr 21 '16 at 8:55

jezraeljezrael

351k26315391

print(pd.Timestamp("2015-01-01") - pd.DateOffset(days=1))
2014-12-31 00:00:00

print(pd.Timestamp("2015-01-01") - pd.offsets.Day(1))
2014-12-31 00:00:00

print(pd.Timestamp("2015-01-01") - pd.Timedelta(1, unit='d'))

share|improve this answer

edited Mar 8 at 9:29

answered Apr 21 '16 at 8:55

jezraeljezrael

351k26315391

answered Apr 21 '16 at 8:55

jezraeljezrael

351k26315391

answered Apr 21 '16 at 8:55

jezraeljezrael

351k26315391

1

Day(d) and DateOffset(days=d) do not behave exactly the same when used on timestamps with timezone information (at least on pandas 0.18.0). It looks like DateOffset add 1 day while keeping the hour information while Day adds just 24 hours of elapsed time.

>>> # 30/10/2016 02:00+02:00 is the hour before the DST change
>>> print(pd.Timestamp("2016-10-30 02:00+02:00", tz="Europe/Brussels") + pd.offsets.Day(1))
2016-10-31 01:00:00+01:00
>>> print(pd.Timestamp("2016-10-30 02:00+02:00", tz="Europe/Brussels") + pd.DateOffset(days=1))
2016-10-31 02:00:00+01:00

share|improve this answer

answered Sep 24 '16 at 16:33

sdementensdementen

9924

add a comment | 

1

Day(d) and DateOffset(days=d) do not behave exactly the same when used on timestamps with timezone information (at least on pandas 0.18.0). It looks like DateOffset add 1 day while keeping the hour information while Day adds just 24 hours of elapsed time.

>>> # 30/10/2016 02:00+02:00 is the hour before the DST change
>>> print(pd.Timestamp("2016-10-30 02:00+02:00", tz="Europe/Brussels") + pd.offsets.Day(1))
2016-10-31 01:00:00+01:00
>>> print(pd.Timestamp("2016-10-30 02:00+02:00", tz="Europe/Brussels") + pd.DateOffset(days=1))
2016-10-31 02:00:00+01:00

share|improve this answer

answered Sep 24 '16 at 16:33

sdementensdementen

9924

add a comment | 

Day(d) and DateOffset(days=d) do not behave exactly the same when used on timestamps with timezone information (at least on pandas 0.18.0). It looks like DateOffset add 1 day while keeping the hour information while Day adds just 24 hours of elapsed time.

>>> # 30/10/2016 02:00+02:00 is the hour before the DST change
>>> print(pd.Timestamp("2016-10-30 02:00+02:00", tz="Europe/Brussels") + pd.offsets.Day(1))
2016-10-31 01:00:00+01:00
>>> print(pd.Timestamp("2016-10-30 02:00+02:00", tz="Europe/Brussels") + pd.DateOffset(days=1))
2016-10-31 02:00:00+01:00

share|improve this answer

answered Sep 24 '16 at 16:33

sdementensdementen

9924

>>> # 30/10/2016 02:00+02:00 is the hour before the DST change
>>> print(pd.Timestamp("2016-10-30 02:00+02:00", tz="Europe/Brussels") + pd.offsets.Day(1))
2016-10-31 01:00:00+01:00
>>> print(pd.Timestamp("2016-10-30 02:00+02:00", tz="Europe/Brussels") + pd.DateOffset(days=1))
2016-10-31 02:00:00+01:00

share|improve this answer

answered Sep 24 '16 at 16:33

sdementensdementen

9924

answered Sep 24 '16 at 16:33

sdementensdementen

9924

answered Sep 24 '16 at 16:33

sdementensdementen

9924