Filter df according to multiple conditions with dyplr in RHow to sort a dataframe by multiple column(s)?Quickly reading very large tables as dataframesGrouping functions (tapply, by, aggregate) and the *apply familyDrop data frame columns by nameHow to design RESTful search/filtering?Why is `[` better than `subset`?data.table vs dplyr: can one do something well the other can't or does poorly?Summarizing multiple columns with dplyr?Can dplyr package be used for conditional mutating?Extract rows from a data frame under certain conditions
Confused about a passage in Harry Potter y la piedra filosofal
Is the destination of a commercial flight important for the pilot?
Trouble understanding overseas colleagues
Short story about space worker geeks who zone out by 'listening' to radiation from stars
when is out of tune ok?
voltage of sounds of mp3files
Greatest common substring
Print name if parameter passed to function
Do I need a multiple entry visa for a trip UK -> Sweden -> UK?
Was the picture area of a CRT a parallelogram (instead of a true rectangle)?
Is it correct to write "is not focus on"?
Generic lambda vs generic function give different behaviour
How does residential electricity work?
Why are on-board computers allowed to change controls without notifying the pilots?
Valid Badminton Score?
Is this Spell Mimic feat balanced?
Why is delta-v is the most useful quantity for planning space travel?
Increase performance creating Mandelbrot set in python
Everything Bob says is false. How does he get people to trust him?
Should my PhD thesis be submitted under my legal name?
Where in the Bible does the greeting ("Dominus Vobiscum") used at Mass come from?
Go Pregnant or Go Home
Mapping a list into a phase plot
Curses work by shouting - How to avoid collateral damage?
Filter df according to multiple conditions with dyplr in R
How to sort a dataframe by multiple column(s)?Quickly reading very large tables as dataframesGrouping functions (tapply, by, aggregate) and the *apply familyDrop data frame columns by nameHow to design RESTful search/filtering?Why is `[` better than `subset`?data.table vs dplyr: can one do something well the other can't or does poorly?Summarizing multiple columns with dplyr?Can dplyr package be used for conditional mutating?Extract rows from a data frame under certain conditions
I have a df structured like this:
a. b.
L. 1
L. 2
M. 3
M. 2
"a" and "b" are columns names.
I want to filter the dataframe using dplyr. The conditions are: if (a == L & b > 1) and at the same time if (a == M & b > 2)
the result would be:
a. b.
L. 2
M. 3
how can I do?
thank you in advance!
r filter dplyr
edited Mar 9 at 21:44
JJJ
69611221
asked Mar 8 at 9:42
Silvia Silvia
1598
add a comment |
I have a df structured like this:
a. b.
L. 1
L. 2
M. 3
M. 2
"a" and "b" are columns names.
I want to filter the dataframe using dplyr. The conditions are: if (a == L & b > 1) and at the same time if (a == M & b > 2)
the result would be:
a. b.
L. 2
M. 3
how can I do?
thank you in advance!
r filter dplyr
edited Mar 9 at 21:44
JJJ
69611221
asked Mar 8 at 9:42
Silvia Silvia
1598
add a comment |
I have a df structured like this:
a. b.
L. 1
L. 2
M. 3
M. 2
"a" and "b" are columns names.
I want to filter the dataframe using dplyr. The conditions are: if (a == L & b > 1) and at the same time if (a == M & b > 2)
the result would be:
a. b.
L. 2
M. 3
how can I do?
thank you in advance!
r filter dplyr
edited Mar 9 at 21:44
JJJ
69611221
asked Mar 8 at 9:42
Silvia Silvia
1598
I have a df structured like this:
a. b.
L. 1
L. 2
M. 3
M. 2
"a" and "b" are columns names.
I want to filter the dataframe using dplyr. The conditions are: if (a == L & b > 1) and at the same time if (a == M & b > 2)
the result would be:
a. b.
L. 2
M. 3
how can I do?
thank you in advance!
r filter dplyr
r filter dplyr
edited Mar 9 at 21:44
JJJ
69611221
asked Mar 8 at 9:42
Silvia Silvia
1598
edited Mar 9 at 21:44
JJJ
69611221
asked Mar 8 at 9:42
Silvia Silvia
1598
edited Mar 9 at 21:44
JJJ
69611221
edited Mar 9 at 21:44
JJJ
69611221
edited Mar 9 at 21:44
JJJ
69611221
69611221
asked Mar 8 at 9:42
Silvia Silvia
1598
asked Mar 8 at 9:42
Silvia Silvia
1598
asked Mar 8 at 9:42
Silvia Silvia
1598
1598
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
>tibble(a=c('L','L','M','M'),b=c(1:3,2)) %>%
+ dplyr::filter((a == 'L' & b > 1) | (a == 'M' & b > 2))
# A tibble: 2 x 2
# a b
# <chr> <dbl>
#1 L 2
#2 M 3
answered Mar 8 at 9:52
quanquan
485
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%2f55060481%2ffilter-df-according-to-multiple-conditions-with-dyplr-in-r%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
>tibble(a=c('L','L','M','M'),b=c(1:3,2)) %>%
+ dplyr::filter((a == 'L' & b > 1) | (a == 'M' & b > 2))
# A tibble: 2 x 2
# a b
# <chr> <dbl>
#1 L 2
#2 M 3
answered Mar 8 at 9:52
quanquan
485
add a comment |
>tibble(a=c('L','L','M','M'),b=c(1:3,2)) %>%
+ dplyr::filter((a == 'L' & b > 1) | (a == 'M' & b > 2))
# A tibble: 2 x 2
# a b
# <chr> <dbl>
#1 L 2
#2 M 3
answered Mar 8 at 9:52
quanquan
485
add a comment |
>tibble(a=c('L','L','M','M'),b=c(1:3,2)) %>%
+ dplyr::filter((a == 'L' & b > 1) | (a == 'M' & b > 2))
# A tibble: 2 x 2
# a b
# <chr> <dbl>
#1 L 2
#2 M 3
answered Mar 8 at 9:52
quanquan
485
>tibble(a=c('L','L','M','M'),b=c(1:3,2)) %>%
+ dplyr::filter((a == 'L' & b > 1) | (a == 'M' & b > 2))
# A tibble: 2 x 2
# a b
# <chr> <dbl>
#1 L 2
#2 M 3
answered Mar 8 at 9:52
quanquan
485
answered Mar 8 at 9:52
quanquan
485
answered Mar 8 at 9:52
quanquan
485
answered Mar 8 at 9:52
quanquan
485
485
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%2f55060481%2ffilter-df-according-to-multiple-conditions-with-dyplr-in-r%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
