选择和将数据帧中的双类别数据分组 [英] Selecting & grouping dual-category data from a data frame

问题描述

我真的需要有关如何解决问题的帮助。我有一个看起来像这样的数据集。

I really need help on how to approach a problem. I have a data set that looks like this..

Name   Sex    Total    
Anna   F      10
Jamie  M      2
Jamie  F      7
Mike   M      13
Sam    F      6
Sam    M      3

structure(list(Name = c("Anna", "Jamie", "Jamie", "Mike", "Sam", "Sam"), 
Sex = c("F", "M", "F", "M", "F", "M"), Total = c(10L, 2L, 7L, 13L, 6L, 3L)), 
.Names = c("Name", "Sex", "Total"), class = "data.frame", row.names = c(NA, -6L))

我想做的就是得到

What I want to do is get the names that are both male and female names, so the results will look like..

Name   Sex  Total
Jamie  M    2
Jamie  F    7
Sam    M    3
Sam    F    6

但是我真的很困惑如何处理它。

But I'm really stumped on how to approach it.

推荐答案

如果数据是存储在 d 中：

# get a vector (set) of names that are use by both M and F
dual.names <- intersect(d$Name[d$Sex=='M'], d$Name[d$Sex=='F'])

# use set of dual names to filter data
d[d$Name %in% dual.names, ]

这篇关于选择和将数据帧中的双类别数据分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！