system error when creating date_range with pandas










0















I would like to create a date_range() with using pandas. I am kinda sure it worked before I updated pandas package.



with following line of code, I am trying to create the date_range():



date_time_index = pd.date_range(start='1/1/2018', periods=8760, freq='H')


and here is the error message:



ValueError: Error parsing datetime string "1/1/2018" at position 1

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "main.py", line 36, in <module>
date_time_index = pd.date_range(start='1/1/2018', periods=8760, freq='H')
File "/usr/local/lib/python3.6/dist-packages/pandas/tseries/index.py", line 2024, in date_range
closed=closed, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/pandas/util/decorators.py", line 91, in wrapper
return func(*args, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/pandas/tseries/index.py", line 301, in __new__
ambiguous=ambiguous)
File "/usr/local/lib/python3.6/dist-packages/pandas/tseries/index.py", line 403, in _generate
start = Timestamp(start)
File "pandas/tslib.pyx", line 406, in pandas.tslib.Timestamp.__new__ (pandas/tslib.c:9940)
File "pandas/tslib.pyx", line 1401, in pandas.tslib.convert_to_tsobject (pandas/tslib.c:25239)
File "pandas/tslib.pyx", line 1516, in pandas.tslib.convert_str_to_tsobject (pandas/tslib.c:26859)
File "pandas/src/datetime.pxd", line 141, in datetime._string_t
SystemError: <class 'str'> returned a result with an error set


What am I doing wrong?










share|improve this question






















  • work fine on my side, what is your pandas version ?

    – W-B
    Nov 13 '18 at 15:15












  • maybe corrupted pandas?

    – oakca
    Nov 13 '18 at 15:15











  • works fine for me, you may have corrupted your library so I suggest reinstalling

    – EdChum
    Nov 13 '18 at 15:15











  • me too. what version of pandas? pd.__version__

    – piRSquared
    Nov 13 '18 at 15:15






  • 1





    okay it works now thank you ^^

    – oakca
    Nov 13 '18 at 15:20















0















I would like to create a date_range() with using pandas. I am kinda sure it worked before I updated pandas package.



with following line of code, I am trying to create the date_range():



date_time_index = pd.date_range(start='1/1/2018', periods=8760, freq='H')


and here is the error message:



ValueError: Error parsing datetime string "1/1/2018" at position 1

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "main.py", line 36, in <module>
date_time_index = pd.date_range(start='1/1/2018', periods=8760, freq='H')
File "/usr/local/lib/python3.6/dist-packages/pandas/tseries/index.py", line 2024, in date_range
closed=closed, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/pandas/util/decorators.py", line 91, in wrapper
return func(*args, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/pandas/tseries/index.py", line 301, in __new__
ambiguous=ambiguous)
File "/usr/local/lib/python3.6/dist-packages/pandas/tseries/index.py", line 403, in _generate
start = Timestamp(start)
File "pandas/tslib.pyx", line 406, in pandas.tslib.Timestamp.__new__ (pandas/tslib.c:9940)
File "pandas/tslib.pyx", line 1401, in pandas.tslib.convert_to_tsobject (pandas/tslib.c:25239)
File "pandas/tslib.pyx", line 1516, in pandas.tslib.convert_str_to_tsobject (pandas/tslib.c:26859)
File "pandas/src/datetime.pxd", line 141, in datetime._string_t
SystemError: <class 'str'> returned a result with an error set


What am I doing wrong?










share|improve this question






















  • work fine on my side, what is your pandas version ?

    – W-B
    Nov 13 '18 at 15:15












  • maybe corrupted pandas?

    – oakca
    Nov 13 '18 at 15:15











  • works fine for me, you may have corrupted your library so I suggest reinstalling

    – EdChum
    Nov 13 '18 at 15:15











  • me too. what version of pandas? pd.__version__

    – piRSquared
    Nov 13 '18 at 15:15






  • 1





    okay it works now thank you ^^

    – oakca
    Nov 13 '18 at 15:20













0












0








0








I would like to create a date_range() with using pandas. I am kinda sure it worked before I updated pandas package.



with following line of code, I am trying to create the date_range():



date_time_index = pd.date_range(start='1/1/2018', periods=8760, freq='H')


and here is the error message:



ValueError: Error parsing datetime string "1/1/2018" at position 1

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "main.py", line 36, in <module>
date_time_index = pd.date_range(start='1/1/2018', periods=8760, freq='H')
File "/usr/local/lib/python3.6/dist-packages/pandas/tseries/index.py", line 2024, in date_range
closed=closed, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/pandas/util/decorators.py", line 91, in wrapper
return func(*args, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/pandas/tseries/index.py", line 301, in __new__
ambiguous=ambiguous)
File "/usr/local/lib/python3.6/dist-packages/pandas/tseries/index.py", line 403, in _generate
start = Timestamp(start)
File "pandas/tslib.pyx", line 406, in pandas.tslib.Timestamp.__new__ (pandas/tslib.c:9940)
File "pandas/tslib.pyx", line 1401, in pandas.tslib.convert_to_tsobject (pandas/tslib.c:25239)
File "pandas/tslib.pyx", line 1516, in pandas.tslib.convert_str_to_tsobject (pandas/tslib.c:26859)
File "pandas/src/datetime.pxd", line 141, in datetime._string_t
SystemError: <class 'str'> returned a result with an error set


What am I doing wrong?










share|improve this question














I would like to create a date_range() with using pandas. I am kinda sure it worked before I updated pandas package.



with following line of code, I am trying to create the date_range():



date_time_index = pd.date_range(start='1/1/2018', periods=8760, freq='H')


and here is the error message:



ValueError: Error parsing datetime string "1/1/2018" at position 1

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "main.py", line 36, in <module>
date_time_index = pd.date_range(start='1/1/2018', periods=8760, freq='H')
File "/usr/local/lib/python3.6/dist-packages/pandas/tseries/index.py", line 2024, in date_range
closed=closed, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/pandas/util/decorators.py", line 91, in wrapper
return func(*args, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/pandas/tseries/index.py", line 301, in __new__
ambiguous=ambiguous)
File "/usr/local/lib/python3.6/dist-packages/pandas/tseries/index.py", line 403, in _generate
start = Timestamp(start)
File "pandas/tslib.pyx", line 406, in pandas.tslib.Timestamp.__new__ (pandas/tslib.c:9940)
File "pandas/tslib.pyx", line 1401, in pandas.tslib.convert_to_tsobject (pandas/tslib.c:25239)
File "pandas/tslib.pyx", line 1516, in pandas.tslib.convert_str_to_tsobject (pandas/tslib.c:26859)
File "pandas/src/datetime.pxd", line 141, in datetime._string_t
SystemError: <class 'str'> returned a result with an error set


What am I doing wrong?







python pandas date-range






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 13 '18 at 15:14









oakcaoakca

317112




317112












  • work fine on my side, what is your pandas version ?

    – W-B
    Nov 13 '18 at 15:15












  • maybe corrupted pandas?

    – oakca
    Nov 13 '18 at 15:15











  • works fine for me, you may have corrupted your library so I suggest reinstalling

    – EdChum
    Nov 13 '18 at 15:15











  • me too. what version of pandas? pd.__version__

    – piRSquared
    Nov 13 '18 at 15:15






  • 1





    okay it works now thank you ^^

    – oakca
    Nov 13 '18 at 15:20

















  • work fine on my side, what is your pandas version ?

    – W-B
    Nov 13 '18 at 15:15












  • maybe corrupted pandas?

    – oakca
    Nov 13 '18 at 15:15











  • works fine for me, you may have corrupted your library so I suggest reinstalling

    – EdChum
    Nov 13 '18 at 15:15











  • me too. what version of pandas? pd.__version__

    – piRSquared
    Nov 13 '18 at 15:15






  • 1





    okay it works now thank you ^^

    – oakca
    Nov 13 '18 at 15:20
















work fine on my side, what is your pandas version ?

– W-B
Nov 13 '18 at 15:15






work fine on my side, what is your pandas version ?

– W-B
Nov 13 '18 at 15:15














maybe corrupted pandas?

– oakca
Nov 13 '18 at 15:15





maybe corrupted pandas?

– oakca
Nov 13 '18 at 15:15













works fine for me, you may have corrupted your library so I suggest reinstalling

– EdChum
Nov 13 '18 at 15:15





works fine for me, you may have corrupted your library so I suggest reinstalling

– EdChum
Nov 13 '18 at 15:15













me too. what version of pandas? pd.__version__

– piRSquared
Nov 13 '18 at 15:15





me too. what version of pandas? pd.__version__

– piRSquared
Nov 13 '18 at 15:15




1




1





okay it works now thank you ^^

– oakca
Nov 13 '18 at 15:20





okay it works now thank you ^^

– oakca
Nov 13 '18 at 15:20












1 Answer
1






active

oldest

votes


















0














Pandas version 0.19.1 date_range() does not work with the input I gave. I updated pandas to 0.23.4 now everything is fine.



Meanwhile:



pip3 install --upgrade pandas





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%2f53284048%2fsystem-error-when-creating-date-range-with-pandas%23new-answer', 'question_page');

    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    Pandas version 0.19.1 date_range() does not work with the input I gave. I updated pandas to 0.23.4 now everything is fine.



    Meanwhile:



    pip3 install --upgrade pandas





    share|improve this answer



























      0














      Pandas version 0.19.1 date_range() does not work with the input I gave. I updated pandas to 0.23.4 now everything is fine.



      Meanwhile:



      pip3 install --upgrade pandas





      share|improve this answer

























        0












        0








        0







        Pandas version 0.19.1 date_range() does not work with the input I gave. I updated pandas to 0.23.4 now everything is fine.



        Meanwhile:



        pip3 install --upgrade pandas





        share|improve this answer













        Pandas version 0.19.1 date_range() does not work with the input I gave. I updated pandas to 0.23.4 now everything is fine.



        Meanwhile:



        pip3 install --upgrade pandas






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 13 '18 at 15:21









        oakcaoakca

        317112




        317112



























            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%2f53284048%2fsystem-error-when-creating-date-range-with-pandas%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







            這個網誌中的熱門文章

            How to read a connectionString WITH PROVIDER in .NET Core?

            In R, how to develop a multiplot heatmap.2 figure showing key labels successfully

            Museum of Modern and Contemporary Art of Trento and Rovereto