Pandas DateOffset, step back one dayHow 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

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















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.










share|improve this question


























    6















    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.










    share|improve this question
























      6












      6








      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.










      share|improve this question














      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













      share|improve this question











      share|improve this question




      share|improve this question










      asked Apr 21 '16 at 8:51









      tschmtschm

      1,30021932




      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
































            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






















              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


















              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















              Required, but never shown

























              2 Answers
              2






              active

              oldest

              votes








              2 Answers
              2






              active

              oldest

              votes









              active

              oldest

              votes






              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





























                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



























                  7












                  7








                  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















                  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














                  share|improve this answer



                  share|improve this answer








                  edited Mar 8 at 9:29

























                  answered Apr 21 '16 at 8:55









                  jezraeljezrael

                  351k26315391




                  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



























                        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

























                          1












                          1








                          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













                          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












                          share|improve this answer



                          share|improve this answer










                          answered Sep 24 '16 at 16:33









                          sdementensdementen

                          9924




                          9924



























                              draft saved

                              draft discarded
















































                              Thanks for contributing an answer to Stack Overflow!


                              • Please be sure to answer the question. Provide details and share your research!

                              But avoid …


                              • Asking for help, clarification, or responding to other answers.

                              • Making statements based on opinion; back them up with references or personal experience.

                              To learn more, see our tips on writing great answers.




                              draft saved


                              draft discarded














                              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















                              Required, but never shown





















































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown

































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown







                              Popular posts from this blog

                              Can't find variable: document ReactNative Js2019 Community Moderator ElectionReactNative: how to center text?Can't find variable: navigate - ReactNative navigationReact Native error: “Can't find variable: TouchableHighlight”How to use Expo.DocumentPicker.getDocumentAsync properly. [Expo] [ReactNative]Can't find variable: regeneratorRuntime (ReactNative)Reactnative Expo It is advisable for a StartUp?Can't find variable : Self / Can't install firebaseNPM Install Error in installing ReactNative CLIContacts Displaying in App using ReactnativeFacebook login error: can't find variable: Alert

                              Thal And Out Agency railway station See also References External links Navigation menuOfficial Web Site of Pakistan RailwaysArchivedOfficial Web Site of Pakistan Railwayseeexpanding ite

                              Posting a File and Associated Data to a RESTful WebService preferably as JSON2019 Community Moderator ElectionREST URI convention - Singular or plural name of resource while creating itUploading both data and files in one form using Ajax?How do I upload a file with metadata using a REST web service?REST API - file (ie images) processing - best practicesSpring: JSON data and file in the same requestREST API Put large dataPosting a file and JSON data to Spring rest serviceRESTful Web Service Upload/Download Large Data With JSONREST API Design sending JSON data and a file to the api in same requestPost JSONArray to REST servicePUT vs. POST in RESTParsing values from a JSON file?JavaScript/jQuery to download file via POST with JSON dataHow do I upload a file with metadata using a REST web service?How to POST JSON data with Curl from Terminal/Commandline to Test Spring REST?Separate REST JSON API server and client?what's the correct way to send a file from REST web service to client?How do I write JSON data to a file?What is “406-Not Acceptable Response” in HTTP?REST API - file (ie images) processing - best practices