Python - Running Command Based on Result of If Statement
I am fairly new to Python and coming from a JavaScript background where I am familiar with capturing the output of a command (success, error) and chaining that result to indicate my application's next command. Is there an approach to do something similar in Python?
For example, I am using the gspread package to interact with a Google Sheet. I am running the command gc.open(*Name*) that searches for a Google Sheet when provided a string (*Name*), but if this does not return a value or if it returns an error as it currently does, SpreadsheetNotFound:, then I would create a sheet with gc.create(*Name) criteria. I was playing around with try/exception, but felt like I was approaching it incorrectly.
This is what I'm hoping to achieve:
if (API Call Finds the Sheet):
Set regression_output = sheet
else:
Set regression_output = creation of sheet with specified name
Current Code:
open_regression_output_sheet = gc.open(file_name)
for value in open_regression_output_sheet:
try:
regression_output = print("Test")
except:
regression_output = print("Error")
Error:
SpreadsheetNotFound:
python
asked Nov 13 '18 at 18:53
cphillcphill
1,68063375
add a comment |
I am fairly new to Python and coming from a JavaScript background where I am familiar with capturing the output of a command (success, error) and chaining that result to indicate my application's next command. Is there an approach to do something similar in Python?
For example, I am using the gspread package to interact with a Google Sheet. I am running the command gc.open(*Name*) that searches for a Google Sheet when provided a string (*Name*), but if this does not return a value or if it returns an error as it currently does, SpreadsheetNotFound:, then I would create a sheet with gc.create(*Name) criteria. I was playing around with try/exception, but felt like I was approaching it incorrectly.
This is what I'm hoping to achieve:
if (API Call Finds the Sheet):
Set regression_output = sheet
else:
Set regression_output = creation of sheet with specified name
Current Code:
open_regression_output_sheet = gc.open(file_name)
for value in open_regression_output_sheet:
try:
regression_output = print("Test")
except:
regression_output = print("Error")
Error:
SpreadsheetNotFound:
python
asked Nov 13 '18 at 18:53
cphillcphill
1,68063375
add a comment |
I am fairly new to Python and coming from a JavaScript background where I am familiar with capturing the output of a command (success, error) and chaining that result to indicate my application's next command. Is there an approach to do something similar in Python?
For example, I am using the gspread package to interact with a Google Sheet. I am running the command gc.open(*Name*) that searches for a Google Sheet when provided a string (*Name*), but if this does not return a value or if it returns an error as it currently does, SpreadsheetNotFound:, then I would create a sheet with gc.create(*Name) criteria. I was playing around with try/exception, but felt like I was approaching it incorrectly.
This is what I'm hoping to achieve:
if (API Call Finds the Sheet):
Set regression_output = sheet
else:
Set regression_output = creation of sheet with specified name
Current Code:
open_regression_output_sheet = gc.open(file_name)
for value in open_regression_output_sheet:
try:
regression_output = print("Test")
except:
regression_output = print("Error")
Error:
SpreadsheetNotFound:
python
asked Nov 13 '18 at 18:53
cphillcphill
1,68063375
I am fairly new to Python and coming from a JavaScript background where I am familiar with capturing the output of a command (success, error) and chaining that result to indicate my application's next command. Is there an approach to do something similar in Python?
For example, I am using the gspread package to interact with a Google Sheet. I am running the command gc.open(*Name*) that searches for a Google Sheet when provided a string (*Name*), but if this does not return a value or if it returns an error as it currently does, SpreadsheetNotFound:, then I would create a sheet with gc.create(*Name) criteria. I was playing around with try/exception, but felt like I was approaching it incorrectly.
This is what I'm hoping to achieve:
if (API Call Finds the Sheet):
Set regression_output = sheet
else:
Set regression_output = creation of sheet with specified name
Current Code:
open_regression_output_sheet = gc.open(file_name)
for value in open_regression_output_sheet:
try:
regression_output = print("Test")
except:
regression_output = print("Error")
Error:
SpreadsheetNotFound:
python
python
asked Nov 13 '18 at 18:53
cphillcphill
1,68063375
asked Nov 13 '18 at 18:53
cphillcphill
1,68063375
asked Nov 13 '18 at 18:53
cphillcphill
1,68063375
asked Nov 13 '18 at 18:53
cphillcphill
1,68063375
asked Nov 13 '18 at 18:53
cphillcphill
1,68063375
1,68063375
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
How about a logic breakdown as such:
try:
open_regression_output_sheet = gc.open(file_name)
except:
print 'SpreadsheetNotFound raised, creating new spreadsheet'
open_regression_output_sheet = gc.create('A new spreadsheet')
answered Nov 13 '18 at 19:01
LeKhan9LeKhan9
931112
Be careful with this. This will catch all exceptions that could occur within that function call, i.e., not just theSpreadsheetNotFounderror.
– Kirk
Nov 13 '18 at 22:54
add a comment |
You're on the right track with try/except, but pay careful attention to where the traceback says the exception was raised. I'm guessing it was actually the
open_regression_output_sheet = gc.open(file_name) line that raised the exception.
If that's the case, you need to wrap that line in a try/except like
try:
open_regression_output_sheet = gc.open(file_name)
except SpreadsheetNotFound:
# handle the exception or whatever
else:
for value in open_regression_output_sheet:
...
answered Nov 13 '18 at 19:04
KirkKirk
556414
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%2f53287738%2fpython-running-command-based-on-result-of-if-statement%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
How about a logic breakdown as such:
try:
open_regression_output_sheet = gc.open(file_name)
except:
print 'SpreadsheetNotFound raised, creating new spreadsheet'
open_regression_output_sheet = gc.create('A new spreadsheet')
answered Nov 13 '18 at 19:01
LeKhan9LeKhan9
931112
Be careful with this. This will catch all exceptions that could occur within that function call, i.e., not just theSpreadsheetNotFounderror.
– Kirk
Nov 13 '18 at 22:54
add a comment |
How about a logic breakdown as such:
try:
open_regression_output_sheet = gc.open(file_name)
except:
print 'SpreadsheetNotFound raised, creating new spreadsheet'
open_regression_output_sheet = gc.create('A new spreadsheet')
answered Nov 13 '18 at 19:01
LeKhan9LeKhan9
931112
Be careful with this. This will catch all exceptions that could occur within that function call, i.e., not just theSpreadsheetNotFounderror.
– Kirk
Nov 13 '18 at 22:54
add a comment |
How about a logic breakdown as such:
try:
open_regression_output_sheet = gc.open(file_name)
except:
print 'SpreadsheetNotFound raised, creating new spreadsheet'
open_regression_output_sheet = gc.create('A new spreadsheet')
answered Nov 13 '18 at 19:01
LeKhan9LeKhan9
931112
How about a logic breakdown as such:
try:
open_regression_output_sheet = gc.open(file_name)
except:
print 'SpreadsheetNotFound raised, creating new spreadsheet'
open_regression_output_sheet = gc.create('A new spreadsheet')
answered Nov 13 '18 at 19:01
LeKhan9LeKhan9
931112
answered Nov 13 '18 at 19:01
LeKhan9LeKhan9
931112
answered Nov 13 '18 at 19:01
LeKhan9LeKhan9
931112
answered Nov 13 '18 at 19:01
LeKhan9LeKhan9
931112
931112
Be careful with this. This will catch all exceptions that could occur within that function call, i.e., not just theSpreadsheetNotFounderror.
– Kirk
Nov 13 '18 at 22:54
add a comment |
Be careful with this. This will catch all exceptions that could occur within that function call, i.e., not just theSpreadsheetNotFounderror.
– Kirk
Nov 13 '18 at 22:54
Be careful with this. This will catch all exceptions that could occur within that function call, i.e., not just the
SpreadsheetNotFound error.– Kirk
Nov 13 '18 at 22:54
Be careful with this. This will catch all exceptions that could occur within that function call, i.e., not just the
SpreadsheetNotFound error.– Kirk
Nov 13 '18 at 22:54
add a comment |
You're on the right track with try/except, but pay careful attention to where the traceback says the exception was raised. I'm guessing it was actually the
open_regression_output_sheet = gc.open(file_name) line that raised the exception.
If that's the case, you need to wrap that line in a try/except like
try:
open_regression_output_sheet = gc.open(file_name)
except SpreadsheetNotFound:
# handle the exception or whatever
else:
for value in open_regression_output_sheet:
...
answered Nov 13 '18 at 19:04
KirkKirk
556414
add a comment |
You're on the right track with try/except, but pay careful attention to where the traceback says the exception was raised. I'm guessing it was actually the
open_regression_output_sheet = gc.open(file_name) line that raised the exception.
If that's the case, you need to wrap that line in a try/except like
try:
open_regression_output_sheet = gc.open(file_name)
except SpreadsheetNotFound:
# handle the exception or whatever
else:
for value in open_regression_output_sheet:
...
answered Nov 13 '18 at 19:04
KirkKirk
556414
add a comment |
You're on the right track with try/except, but pay careful attention to where the traceback says the exception was raised. I'm guessing it was actually the
open_regression_output_sheet = gc.open(file_name) line that raised the exception.
If that's the case, you need to wrap that line in a try/except like
try:
open_regression_output_sheet = gc.open(file_name)
except SpreadsheetNotFound:
# handle the exception or whatever
else:
for value in open_regression_output_sheet:
...
answered Nov 13 '18 at 19:04
KirkKirk
556414
You're on the right track with try/except, but pay careful attention to where the traceback says the exception was raised. I'm guessing it was actually the
open_regression_output_sheet = gc.open(file_name) line that raised the exception.
If that's the case, you need to wrap that line in a try/except like
try:
open_regression_output_sheet = gc.open(file_name)
except SpreadsheetNotFound:
# handle the exception or whatever
else:
for value in open_regression_output_sheet:
...
answered Nov 13 '18 at 19:04
KirkKirk
556414
answered Nov 13 '18 at 19:04
KirkKirk
556414
answered Nov 13 '18 at 19:04
KirkKirk
556414
answered Nov 13 '18 at 19:04
KirkKirk
556414
556414
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.
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%2f53287738%2fpython-running-command-based-on-result-of-if-statement%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
