Mixing
python pandas iloc works on jupyter but not on flask
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
edited Nov 19 '18 at 16:56
davidism
62.2k12157176
asked Nov 19 '18 at 16:49
Aabishkar Wagle
12
add a comment |
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
edited Nov 19 '18 at 16:56
davidism
62.2k12157176
asked Nov 19 '18 at 16:49
Aabishkar Wagle
12
add a comment |
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
edited Nov 19 '18 at 16:56
davidism
62.2k12157176
asked Nov 19 '18 at 16:49
Aabishkar Wagle
12
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
python pandas flask
edited Nov 19 '18 at 16:56
davidism
62.2k12157176
asked Nov 19 '18 at 16:49
Aabishkar Wagle
12
edited Nov 19 '18 at 16:56
davidism
62.2k12157176
asked Nov 19 '18 at 16:49
Aabishkar Wagle
12
edited Nov 19 '18 at 16:56
davidism
62.2k12157176
edited Nov 19 '18 at 16:56
davidism
62.2k12157176
edited Nov 19 '18 at 16:56
davidism
62.2k12157176
62.2k12157176
asked Nov 19 '18 at 16:49
Aabishkar Wagle
12
asked Nov 19 '18 at 16:49
Aabishkar Wagle
12
asked Nov 19 '18 at 16:49
Aabishkar Wagle
12
12
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
It's probably trying to index an empty dataframe. For illustration try running this:
df = pd.DataFrame()
df.iloc[0]
answered Nov 19 '18 at 18:26
Robert
33429
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
});
}
});
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
Required, but never shown
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
It's probably trying to index an empty dataframe. For illustration try running this:
df = pd.DataFrame()
df.iloc[0]
answered Nov 19 '18 at 18:26
Robert
33429
add a comment |
It's probably trying to index an empty dataframe. For illustration try running this:
df = pd.DataFrame()
df.iloc[0]
answered Nov 19 '18 at 18:26
Robert
33429
add a comment |
It's probably trying to index an empty dataframe. For illustration try running this:
df = pd.DataFrame()
df.iloc[0]
answered Nov 19 '18 at 18:26
Robert
33429
It's probably trying to index an empty dataframe. For illustration try running this:
df = pd.DataFrame()
df.iloc[0]
answered Nov 19 '18 at 18:26
Robert
33429
answered Nov 19 '18 at 18:26
Robert
33429
answered Nov 19 '18 at 18:26
Robert
33429
answered Nov 19 '18 at 18:26
Robert
33429
33429
add a comment |
add a comment |
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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.
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
Required, but never shown
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
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
