How to filter the date column in pandas?
0
I want to remove the date in the column['DATE'] and use the quickfilter.
I do this:
quickfilter = (df_dexu.DATE < 2018-12-1)
df_dexu=df_dexu[quickfilter]
but it gives the error message:
TypeError: invalid type comparison
python pandas datetime dataframe
edited Jan 19 at 17:58
nick
674518
asked Jan 19 at 10:01
YeiBiYeiBi
136
add a comment |
0
I want to remove the date in the column['DATE'] and use the quickfilter.
I do this:
quickfilter = (df_dexu.DATE < 2018-12-1)
df_dexu=df_dexu[quickfilter]
but it gives the error message:
TypeError: invalid type comparison
python pandas datetime dataframe
edited Jan 19 at 17:58
nick
674518
asked Jan 19 at 10:01
YeiBiYeiBi
136
1
2018-12-1is not a date. That is 2018 minus 12 minus 1, i.e. number 2005. That cannot be compared to a date.
– zvone
Jan 19 at 15:00
add a comment |
0
0
0
I want to remove the date in the column['DATE'] and use the quickfilter.
I do this:
quickfilter = (df_dexu.DATE < 2018-12-1)
df_dexu=df_dexu[quickfilter]
but it gives the error message:
TypeError: invalid type comparison
python pandas datetime dataframe
edited Jan 19 at 17:58
nick
674518
asked Jan 19 at 10:01
YeiBiYeiBi
136
I want to remove the date in the column['DATE'] and use the quickfilter.
I do this:
quickfilter = (df_dexu.DATE < 2018-12-1)
df_dexu=df_dexu[quickfilter]
but it gives the error message:
TypeError: invalid type comparison
python pandas datetime dataframe
python pandas datetime dataframe
edited Jan 19 at 17:58
nick
674518
asked Jan 19 at 10:01
YeiBiYeiBi
136
edited Jan 19 at 17:58
nick
674518
asked Jan 19 at 10:01
YeiBiYeiBi
136
edited Jan 19 at 17:58
nick
674518
edited Jan 19 at 17:58
nick
674518
edited Jan 19 at 17:58
nick
674518
674518
asked Jan 19 at 10:01
YeiBiYeiBi
136
asked Jan 19 at 10:01
YeiBiYeiBi
136
asked Jan 19 at 10:01
YeiBiYeiBi
136
136
1
2018-12-1is not a date. That is 2018 minus 12 minus 1, i.e. number 2005. That cannot be compared to a date.
– zvone
Jan 19 at 15:00
add a comment |
1
2018-12-1is not a date. That is 2018 minus 12 minus 1, i.e. number 2005. That cannot be compared to a date.
– zvone
Jan 19 at 15:00
1
1
2018-12-1 is not a date. That is 2018 minus 12 minus 1, i.e. number 2005. That cannot be compared to a date.– zvone
Jan 19 at 15:00
2018-12-1 is not a date. That is 2018 minus 12 minus 1, i.e. number 2005. That cannot be compared to a date.– zvone
Jan 19 at 15:00
add a comment |
1 Answer
1
active
oldest
votes
3
Try convert column to_datetime:
quickfilter = (pd.to_datetime(df_dexu.DATE) < '2018-12-01')
Or:
df_dexu.DATE = pd.to_datetime(df_dexu.DATE)
quickfilter = (df_dexu.DATE < '2018-12-01')
answered Jan 19 at 10:02
jezraeljezrael
332k24273351
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
});
}
});
draft saved
draft discarded
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%2f54265952%2fhow-to-filter-the-date-column-in-pandas%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
3
Try convert column to_datetime:
quickfilter = (pd.to_datetime(df_dexu.DATE) < '2018-12-01')
Or:
df_dexu.DATE = pd.to_datetime(df_dexu.DATE)
quickfilter = (df_dexu.DATE < '2018-12-01')
answered Jan 19 at 10:02
jezraeljezrael
332k24273351
add a comment |
3
Try convert column to_datetime:
quickfilter = (pd.to_datetime(df_dexu.DATE) < '2018-12-01')
Or:
df_dexu.DATE = pd.to_datetime(df_dexu.DATE)
quickfilter = (df_dexu.DATE < '2018-12-01')
answered Jan 19 at 10:02
jezraeljezrael
332k24273351
add a comment |
3
3
3
Try convert column to_datetime:
quickfilter = (pd.to_datetime(df_dexu.DATE) < '2018-12-01')
Or:
df_dexu.DATE = pd.to_datetime(df_dexu.DATE)
quickfilter = (df_dexu.DATE < '2018-12-01')
answered Jan 19 at 10:02
jezraeljezrael
332k24273351
Try convert column to_datetime:
quickfilter = (pd.to_datetime(df_dexu.DATE) < '2018-12-01')
Or:
df_dexu.DATE = pd.to_datetime(df_dexu.DATE)
quickfilter = (df_dexu.DATE < '2018-12-01')
answered Jan 19 at 10:02
jezraeljezrael
332k24273351
edited Jan 19 at 10:04
answered Jan 19 at 10:02
jezraeljezrael
332k24273351
answered Jan 19 at 10:02
jezraeljezrael
332k24273351
answered Jan 19 at 10:02
jezraeljezrael
332k24273351
332k24273351
add a comment |
add a comment |
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f54265952%2fhow-to-filter-the-date-column-in-pandas%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
1
2018-12-1is not a date. That is 2018 minus 12 minus 1, i.e. number 2005. That cannot be compared to a date.– zvone
Jan 19 at 15:00