Return a header with a conditional statement on a dataframe
My data:
Header
Case | PD | PP | 50 | 80 | FW | BA | IA | EA | NA
Case1 | 00 | 23 | 00 | 00 | 21 | 00 | 00 | 00 | 00
Case2 | 00 | 23 | 00 | 00 | 12 | 32 | 14 | 00 | 00
What I want: For every case, I want to return the last header. For example: Case1 would be FW, because FW is the last header with a value (21).
For Case2 it would be "IA", because it is the last header with a value (14).
Right now I have the following:
def getStatus(dataframe):
for index, row in dataframe.iterrows():
def lookup(phase, name):
if phase is not '00':
return name
x = lookup(row['FW'], "FW")
x = lookup(row['BA'], "BA")
x = lookup(row['IA'], "IA")
x = lookup(row['EA'], "EA")
x = lookup(row['NA'], "NA")
x = lookup(row['PP'], "PP")
From a logical view, I thought something like x will do several lookups (def lookup) and always overwrite the value above, if existent.
What I am doing wrong here, what would be a good approach? My approach is not well designed I guess, but I also think a big function with a lot of if and elif is also bad.
python dataframe if-statement
asked Nov 21 '18 at 10:04
JohnDoleJohnDole
356
add a comment |
My data:
Header
Case | PD | PP | 50 | 80 | FW | BA | IA | EA | NA
Case1 | 00 | 23 | 00 | 00 | 21 | 00 | 00 | 00 | 00
Case2 | 00 | 23 | 00 | 00 | 12 | 32 | 14 | 00 | 00
What I want: For every case, I want to return the last header. For example: Case1 would be FW, because FW is the last header with a value (21).
For Case2 it would be "IA", because it is the last header with a value (14).
Right now I have the following:
def getStatus(dataframe):
for index, row in dataframe.iterrows():
def lookup(phase, name):
if phase is not '00':
return name
x = lookup(row['FW'], "FW")
x = lookup(row['BA'], "BA")
x = lookup(row['IA'], "IA")
x = lookup(row['EA'], "EA")
x = lookup(row['NA'], "NA")
x = lookup(row['PP'], "PP")
From a logical view, I thought something like x will do several lookups (def lookup) and always overwrite the value above, if existent.
What I am doing wrong here, what would be a good approach? My approach is not well designed I guess, but I also think a big function with a lot of if and elif is also bad.
python dataframe if-statement
asked Nov 21 '18 at 10:04
JohnDoleJohnDole
356
add a comment |
My data:
Header
Case | PD | PP | 50 | 80 | FW | BA | IA | EA | NA
Case1 | 00 | 23 | 00 | 00 | 21 | 00 | 00 | 00 | 00
Case2 | 00 | 23 | 00 | 00 | 12 | 32 | 14 | 00 | 00
What I want: For every case, I want to return the last header. For example: Case1 would be FW, because FW is the last header with a value (21).
For Case2 it would be "IA", because it is the last header with a value (14).
Right now I have the following:
def getStatus(dataframe):
for index, row in dataframe.iterrows():
def lookup(phase, name):
if phase is not '00':
return name
x = lookup(row['FW'], "FW")
x = lookup(row['BA'], "BA")
x = lookup(row['IA'], "IA")
x = lookup(row['EA'], "EA")
x = lookup(row['NA'], "NA")
x = lookup(row['PP'], "PP")
From a logical view, I thought something like x will do several lookups (def lookup) and always overwrite the value above, if existent.
What I am doing wrong here, what would be a good approach? My approach is not well designed I guess, but I also think a big function with a lot of if and elif is also bad.
python dataframe if-statement
asked Nov 21 '18 at 10:04
JohnDoleJohnDole
356
My data:
Header
Case | PD | PP | 50 | 80 | FW | BA | IA | EA | NA
Case1 | 00 | 23 | 00 | 00 | 21 | 00 | 00 | 00 | 00
Case2 | 00 | 23 | 00 | 00 | 12 | 32 | 14 | 00 | 00
What I want: For every case, I want to return the last header. For example: Case1 would be FW, because FW is the last header with a value (21).
For Case2 it would be "IA", because it is the last header with a value (14).
Right now I have the following:
def getStatus(dataframe):
for index, row in dataframe.iterrows():
def lookup(phase, name):
if phase is not '00':
return name
x = lookup(row['FW'], "FW")
x = lookup(row['BA'], "BA")
x = lookup(row['IA'], "IA")
x = lookup(row['EA'], "EA")
x = lookup(row['NA'], "NA")
x = lookup(row['PP'], "PP")
From a logical view, I thought something like x will do several lookups (def lookup) and always overwrite the value above, if existent.
What I am doing wrong here, what would be a good approach? My approach is not well designed I guess, but I also think a big function with a lot of if and elif is also bad.
python dataframe if-statement
python dataframe if-statement
asked Nov 21 '18 at 10:04
JohnDoleJohnDole
356
asked Nov 21 '18 at 10:04
JohnDoleJohnDole
356
asked Nov 21 '18 at 10:04
JohnDoleJohnDole
356
asked Nov 21 '18 at 10:04
JohnDoleJohnDole
356
asked Nov 21 '18 at 10:04
JohnDoleJohnDole
356
356
add a comment |
add a comment |
0
active
oldest
votes
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%2f53409576%2freturn-a-header-with-a-conditional-statement-on-a-dataframe%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53409576%2freturn-a-header-with-a-conditional-statement-on-a-dataframe%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
