python pandas iloc works on jupyter but not on flask











up vote
-3
down vote

favorite












I am developing an API from flask and for that I had to use pandas in between of a function. So to access a data I used pandas iloc but it shows an error 'IndexError: single positional indexer is out-of-bounds'.



Here's my code:



price = float(cf.loc[cf['company_name'] == 'Agricultural Development Bank Limited', 'Close'].iloc[0])
return price


If I run the same thing at jupyter then it works perfectly.



Cjeck out the screenshot of running this code in jupyter notebook



Please help.










share|improve this question




























    up vote
    -3
    down vote

    favorite












    I am developing an API from flask and for that I had to use pandas in between of a function. So to access a data I used pandas iloc but it shows an error 'IndexError: single positional indexer is out-of-bounds'.



    Here's my code:



    price = float(cf.loc[cf['company_name'] == 'Agricultural Development Bank Limited', 'Close'].iloc[0])
    return price


    If I run the same thing at jupyter then it works perfectly.



    Cjeck out the screenshot of running this code in jupyter notebook



    Please help.










    share|improve this question


























      up vote
      -3
      down vote

      favorite









      up vote
      -3
      down vote

      favorite











      I am developing an API from flask and for that I had to use pandas in between of a function. So to access a data I used pandas iloc but it shows an error 'IndexError: single positional indexer is out-of-bounds'.



      Here's my code:



      price = float(cf.loc[cf['company_name'] == 'Agricultural Development Bank Limited', 'Close'].iloc[0])
      return price


      If I run the same thing at jupyter then it works perfectly.



      Cjeck out the screenshot of running this code in jupyter notebook



      Please help.










      share|improve this question















      I am developing an API from flask and for that I had to use pandas in between of a function. So to access a data I used pandas iloc but it shows an error 'IndexError: single positional indexer is out-of-bounds'.



      Here's my code:



      price = float(cf.loc[cf['company_name'] == 'Agricultural Development Bank Limited', 'Close'].iloc[0])
      return price


      If I run the same thing at jupyter then it works perfectly.



      Cjeck out the screenshot of running this code in jupyter notebook



      Please help.







      python pandas flask






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 19 at 16:56









      davidism

      61.1k12154173




      61.1k12154173










      asked Nov 19 at 16:49









      Aabishkar Wagle

      12




      12
























          1 Answer
          1






          active

          oldest

          votes

















          up vote
          0
          down vote













          It's probably trying to index an empty dataframe. For illustration try running this:



          df = pd.DataFrame()
          df.iloc[0]





          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',
            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%2f53379242%2fpython-pandas-iloc-works-on-jupyter-but-not-on-flask%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








            up vote
            0
            down vote













            It's probably trying to index an empty dataframe. For illustration try running this:



            df = pd.DataFrame()
            df.iloc[0]





            share|improve this answer

























              up vote
              0
              down vote













              It's probably trying to index an empty dataframe. For illustration try running this:



              df = pd.DataFrame()
              df.iloc[0]





              share|improve this answer























                up vote
                0
                down vote










                up vote
                0
                down vote









                It's probably trying to index an empty dataframe. For illustration try running this:



                df = pd.DataFrame()
                df.iloc[0]





                share|improve this answer












                It's probably trying to index an empty dataframe. For illustration try running this:



                df = pd.DataFrame()
                df.iloc[0]






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 19 at 18:26









                Robert

                34429




                34429






























                     

                    draft saved


                    draft discarded



















































                     


                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53379242%2fpython-pandas-iloc-works-on-jupyter-but-not-on-flask%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

                    Wiesbaden

                    Marschland

                    Dieringhausen