Sum values based on comparison of two different DataFrames
I try to check if a value in one df is between two values of another df. If so the values of the first df shall be summed.
df1['MyNewCol'] = df2[(df2['date'] >= df1['Startdate']) and (df2['date'] <= df1['enddate'])].sum('values', axis = 1)
This is what my code looks like and it shall check if the date mentioned in df2 is between startdate and enddate. If so it shall print the sum of values.
I get "Can only compare identically-labeled Series objects" as error. Is there an easy way to solve the problem?
python pandas dataframe
asked Nov 20 '18 at 11:28
Agostino Agostino
113
add a comment |
I try to check if a value in one df is between two values of another df. If so the values of the first df shall be summed.
df1['MyNewCol'] = df2[(df2['date'] >= df1['Startdate']) and (df2['date'] <= df1['enddate'])].sum('values', axis = 1)
This is what my code looks like and it shall check if the date mentioned in df2 is between startdate and enddate. If so it shall print the sum of values.
I get "Can only compare identically-labeled Series objects" as error. Is there an easy way to solve the problem?
python pandas dataframe
asked Nov 20 '18 at 11:28
Agostino Agostino
113
3
Can you add some data sample?
– jezrael
Nov 20 '18 at 11:31
andtests whether both expressions are logically True while&(when used with True/False values) tests if both are True
– anky_91
Nov 20 '18 at 11:32
add a comment |
I try to check if a value in one df is between two values of another df. If so the values of the first df shall be summed.
df1['MyNewCol'] = df2[(df2['date'] >= df1['Startdate']) and (df2['date'] <= df1['enddate'])].sum('values', axis = 1)
This is what my code looks like and it shall check if the date mentioned in df2 is between startdate and enddate. If so it shall print the sum of values.
I get "Can only compare identically-labeled Series objects" as error. Is there an easy way to solve the problem?
python pandas dataframe
asked Nov 20 '18 at 11:28
Agostino Agostino
113
I try to check if a value in one df is between two values of another df. If so the values of the first df shall be summed.
df1['MyNewCol'] = df2[(df2['date'] >= df1['Startdate']) and (df2['date'] <= df1['enddate'])].sum('values', axis = 1)
This is what my code looks like and it shall check if the date mentioned in df2 is between startdate and enddate. If so it shall print the sum of values.
I get "Can only compare identically-labeled Series objects" as error. Is there an easy way to solve the problem?
python pandas dataframe
python pandas dataframe
asked Nov 20 '18 at 11:28
Agostino Agostino
113
asked Nov 20 '18 at 11:28
Agostino Agostino
113
asked Nov 20 '18 at 11:28
Agostino Agostino
113
asked Nov 20 '18 at 11:28
Agostino Agostino
113
asked Nov 20 '18 at 11:28
Agostino Agostino
113
113
3
Can you add some data sample?
– jezrael
Nov 20 '18 at 11:31
andtests whether both expressions are logically True while&(when used with True/False values) tests if both are True
– anky_91
Nov 20 '18 at 11:32
add a comment |
3
Can you add some data sample?
– jezrael
Nov 20 '18 at 11:31
andtests whether both expressions are logically True while&(when used with True/False values) tests if both are True
– anky_91
Nov 20 '18 at 11:32
3
3
Can you add some data sample?
– jezrael
Nov 20 '18 at 11:31
Can you add some data sample?
– jezrael
Nov 20 '18 at 11:31
and tests whether both expressions are logically True while & (when used with True/False values) tests if both are True– anky_91
Nov 20 '18 at 11:32
and tests whether both expressions are logically True while & (when used with True/False values) tests if both are True– anky_91
Nov 20 '18 at 11:32
add a comment |
1 Answer
1
active
oldest
votes
Size of series of two dataframes are not the same for comparison or the indexes aren't similar. So, the operator >= can't compare in these cases.
and is a python operator. You need logical & for your case
(df2['date'] >= df1['Startdate']) & (df2['date'] <= df1['enddate'])
answered Nov 20 '18 at 11:29
VishnudevVishnudev
1,156517
Thank you. How can I make the indexes similar without deleting data out of one of the dataframes?
– Agostino
Nov 20 '18 at 12:30
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%2f53392035%2fsum-values-based-on-comparison-of-two-different-dataframes%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
Size of series of two dataframes are not the same for comparison or the indexes aren't similar. So, the operator >= can't compare in these cases.
and is a python operator. You need logical & for your case
(df2['date'] >= df1['Startdate']) & (df2['date'] <= df1['enddate'])
answered Nov 20 '18 at 11:29
VishnudevVishnudev
1,156517
Thank you. How can I make the indexes similar without deleting data out of one of the dataframes?
– Agostino
Nov 20 '18 at 12:30
add a comment |
Size of series of two dataframes are not the same for comparison or the indexes aren't similar. So, the operator >= can't compare in these cases.
and is a python operator. You need logical & for your case
(df2['date'] >= df1['Startdate']) & (df2['date'] <= df1['enddate'])
answered Nov 20 '18 at 11:29
VishnudevVishnudev
1,156517
Thank you. How can I make the indexes similar without deleting data out of one of the dataframes?
– Agostino
Nov 20 '18 at 12:30
add a comment |
Size of series of two dataframes are not the same for comparison or the indexes aren't similar. So, the operator >= can't compare in these cases.
and is a python operator. You need logical & for your case
(df2['date'] >= df1['Startdate']) & (df2['date'] <= df1['enddate'])
answered Nov 20 '18 at 11:29
VishnudevVishnudev
1,156517
Size of series of two dataframes are not the same for comparison or the indexes aren't similar. So, the operator >= can't compare in these cases.
and is a python operator. You need logical & for your case
(df2['date'] >= df1['Startdate']) & (df2['date'] <= df1['enddate'])
answered Nov 20 '18 at 11:29
VishnudevVishnudev
1,156517
edited Nov 20 '18 at 11:37
answered Nov 20 '18 at 11:29
VishnudevVishnudev
1,156517
answered Nov 20 '18 at 11:29
VishnudevVishnudev
1,156517
answered Nov 20 '18 at 11:29
VishnudevVishnudev
1,156517
1,156517
Thank you. How can I make the indexes similar without deleting data out of one of the dataframes?
– Agostino
Nov 20 '18 at 12:30
add a comment |
Thank you. How can I make the indexes similar without deleting data out of one of the dataframes?
– Agostino
Nov 20 '18 at 12:30
Thank you. How can I make the indexes similar without deleting data out of one of the dataframes?
– Agostino
Nov 20 '18 at 12:30
Thank you. How can I make the indexes similar without deleting data out of one of the dataframes?
– Agostino
Nov 20 '18 at 12:30
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%2f53392035%2fsum-values-based-on-comparison-of-two-different-dataframes%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
3
Can you add some data sample?
– jezrael
Nov 20 '18 at 11:31
andtests whether both expressions are logically True while&(when used with True/False values) tests if both are True– anky_91
Nov 20 '18 at 11:32