我有一个非常简单的tibble,我想通过迭代它的行来应用一个使用pmap函数的函数。我想我可能误解了pmap函数的一些观点,但我很难选择参数。所以我想知道在这种情况下,我是否应该在pmap中使用rowwise函数。然而,我还没有看到一个案例。另一个问题是使用list或select函数选择要迭代的变量:
# Here is my tibble
# Imagine I would like to apply a `n_distinct` function with pmap on it every rows
df <- tibble(id = c("01", "02", "03","04","05","06"),
A = c("Jan", "Mar", "Jan","Jan","Jan","Mar"),
B = c("Feb", "Mar", "Jan","Jan","Mar","Mar"),
C = c("Feb", "Mar", "Feb","Jan","Feb","Feb")
)
# It is perfectly achievable with `rowwise` and `mutate` and results in my desired output
df %>%
rowwise() %>%
mutate(overal = n_distinct(c_across(A:C)))
# A tibble: 6 x 5
# Rowwise:
id A B C overal
<chr> <chr> <chr> <chr> <int>
1 01 Jan Feb Feb 2
2 02 Mar Mar Mar 1
3 03 Jan Jan Feb 2
4 04 Jan Jan Jan 1
5 05 Jan Mar Feb 3
6 06 Mar Mar Feb 2
# But with `pmap` it won't.
df %>%
select(-id) %>%
mutate(overal = pmap_dbl(list(A, B, C), n_distinct))
# A tibble: 6 x 4
A B C overal
<chr> <chr> <chr> <dbl>
1 Jan Feb Feb 1
2 Mar Mar Mar 1
3 Jan Jan Feb 1
4 Jan Jan Jan 1
5 Jan Mar Feb 1
6 Mar Mar Feb 1我只需要一点关于pmap在逐行迭代中的应用的解释,所以我非常感谢提前提供的帮助,谢谢。
发布于 2021-03-28 00:48:50
我能够追踪到这个问题,但不能说这是一个bug还是一个特性。关键是pmap内部的n_distinct()将给定的输入作为一个有3列的数据帧来处理。将n_distinct()应用于数据框时,它会计算不同行的数量,因此每行的行数为1
n_distinct(tibble(a = c(1, 2, 2),
b = 3))
#> [1] 2诀窍是首先将输入转换为向量,然后将其传递给n_distinct
df %>%
select(-id) %>%
mutate(overal = pmap_dbl(list(A, B, C), ~ n_distinct(c(...))))
#> # A tibble: 6 x 4
#> A B C overal
#> <chr> <chr> <chr> <dbl>
#> 1 Jan Feb Feb 2
#> 2 Mar Mar Mar 1
#> 3 Jan Jan Feb 2
#> 4 Jan Jan Jan 1
#> 5 Jan Mar Feb 3
#> 6 Mar Mar Feb 2https://stackoverflow.com/questions/66833328
复制相似问题