- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
我有以下我试图传播的数据集。
#create df
df <- structure(list(file_number = c("3098129", "3096451", "3096774",
"3095276", "3095464", "3096846", "3097132", "3096355", "3096951",
"3096328", "3095441", "3096325", "3094412", "3096366", "3096372",
"3096507", "3098510", "3096335", "3096403", "3094343", "3096941",
"3096419", "3094431", "3096495", "3094647", "3094487", "3094947",
"3094398", "3094386", "3094367", "3097480", "3096425", "3095193",
"3095839a", "3097197", "3098453", "3098549", "3098428", "3096427",
"3096895", "3096434", "3094835", "3096312", "3094517", "3094372",
"3096387", "3096480", "3098504", "3096338", "3094615", "3096382",
"3096638", "3096750", "3096418", "3094734", "3098503", "3096311",
"3097197", "3094353", "3098442", "3097111", "3097325", "3096531",
"3096405", "3096301", "3096692", "3096495", "3098406", "3098422",
"3096315", "3096951", "3094491", "3096304", "3098416", "3096332",
"3098404", "3098419", "3095225", "3094404", "3096374", "3098411",
"3098556", "3096398", "3094421b", "3098477", "3094369b", "3098463",
"3096893", "3098514", "3098477", "3098465", "3094560", "3098409",
"3096434", "3097557", "3095061", "3098419", "3096404", "3095441",
"3096537", "3098503", "3098400", "3097808", "3096389b", "3098446",
"3096330", "3095533", "3094421a", "3094339", "3095578", "3094404",
"3098552", "3098514", "3096630", "3096941", "3097027", "3096322",
"3096514", "3098484", "3097038", "3096672", "3098483", "3094373",
"3096774", "3096677", "3096408", "3096664", "3096365", "3096491",
"3096820", "3096514", "3096556", "3096292", "3096495", "3094781",
"3094344", "3094487", "3094690", "3098504", "3096503"), reader = c("aa",
"aa", "aa", "aa", "aa", "aa", "aa", "aa", "aa", "aa", "aa", "aa",
"aa", "aa", "aa", "aa", "aa", "aa", "aa", "aa", "ae", "ae", "ae",
"ae", "ae", "ae", "ae", "ae", "ae", "ae", "ae", "ae", "ae", "ae",
"ae", "ae", "ae", "ae", "ae", "ae", "db", "db", "db", "db", "db",
"db", "db", "db", "db", "db", "db", "db", "db", "db", "db", "db",
"db", "db", "db", "db", "dl", "dl", "dl", "dl", "dl", "dl", "dl",
"dl", "dl", "dl", "dl", "dl", "dl", "dl", "dl", "dl", "dl", "dl",
"dl", "dl", "mk", "mk", "mk", "mk", "mk", "mk", "mk", "mk", "mk",
"mk", "mk", "mk", "mk", "mk", "mk", "mk", "mk", "mk", "mk", "mk",
"mm", "mm", "mm", "mm", "mm", "mm", "mm", "mm", "mm", "mm", "mm",
"mm", "mm", "mm", "mm", "mm", "mm", "mm", "mm", "mm", "np", "np",
"np", "np", "np", "np", "np", "np", "np", "np", "np", "np", "np",
"np", "np", "np", "np", "np", "np", "np"), event = c("fail",
"fail", "fail", "fail", "pass", "fail", "fail", "pass", "fail",
"fail", "pass", "pass", "pass", "fail", "fail", "pass", "pass",
"fail", "pass", "pass", "pass", "pass", "pass", "pass", "fail",
"fail", "pass", "pass", "fail", "pass", "pass", "pass", "pass",
"pass", "fail", "pass", "fail", "fail", "fail", "pass", "pass",
"pass", "fail", "pass", "pass", "fail", "pass", "fail", "fail",
"pass", "fail", "fail", "pass", "fail", "pass", "fail", "pass",
"fail", "fail", "fail", "fail", "pass", "pass", "fail", "pass",
"pass", "fail", "pass", "fail", "pass", "pass", "fail", "pass",
"fail", "fail", "pass", "pass", "fail", "pass", "pass", "fail",
"pass", "fail", "pass", "fail", "pass", "pass", "pass", "pass",
"fail", "pass", "pass", "fail", "pass", "fail", "pass", "fail",
"pass", "pass", "fail", "pass", "pass", "fail", "pass", "pass",
"fail", "pass", "fail", "fail", "fail", "pass", "pass", "pass",
"fail", "fail", "fail", "fail", "fail", "fail", "fail", "fail",
"fail", "pass", "fail", "fail", "fail", "pass", "pass", "pass",
"pass", "fail", "pass", "pass", "fail", "fail", "pass", "pass",
"fail", "fail", "fail")), class = c("tbl_df", "tbl", "data.frame"
), row.names = c(NA, -140L))
>head(df)
file_number reader event
3098129 aa fail
3096451 aa fail
3096774 aa fail
3095276 aa fail
tidyr::pivot_wider
时,我得到了输出
<S3: vctrs_list_of>
。我认为这与
names_from
列中有多个相同类型的值有关。
df %>%
tidyr::pivot_wider(id_cols = file_number, names_from = reader, values_from = event)
id aa ae
3098129 <S3: vctrs_list_of> <S3: vctrs_list_of>
3096451 <S3: vctrs_list_of> <S3: vctrs_list_of>
Values in `event` are not uniquely identified; output will contain list-cols.
* Use `values_fn = list(event = list)` to suppress this warning.
* Use `values_fn = list(event = length)` to identify where the duplicates arise
* Use `values_fn = list(event = summary_fun)` to summarise duplicates
最佳答案
一般来说,如果我们有 names_from
没有重复行的序列标识符的列,这可能发生
library(tidyr)
library(dplyr)
df %>%
pivot_wider(names_from = reader, values_from = event)
# A tibble: 124 x 8
# file_number aa ae db dl mk mm np
# <chr> <list<chr>> <list<chr>> <list<chr>> <list<chr>> <list<chr>> <list<chr>> <list<chr>>
# 1 3098129 [1] [0] [0] [0] [0] [0] [0]
# 2 3096451 [1] [0] [0] [0] [0] [0] [0]
# 3 3096774 [1] [0] [0] [0] [0] [0] [1]
# 4 3095276 [1] [0] [0] [0] [0] [0] [0]
# 5 3095464 [1] [0] [0] [0] [0] [0] [0]
# 6 3096846 [1] [0] [0] [0] [0] [0] [0]
# 7 3097132 [1] [0] [0] [0] [0] [0] [0]
# 8 3096355 [1] [0] [0] [0] [0] [0] [0]
# 9 3096951 [1] [0] [0] [1] [0] [0] [0]
#10 3096328 [1] [0] [0] [0] [0] [0] [0]
# … with 114 more rows
df %>%
group_by(reader) %>%
mutate(rn = row_number()) %>% # recreated unique identifier column
pivot_wider(names_from = reader, values_from = event)
# A tibble: 139 x 9
# file_number rn aa ae db dl mk mm np
# <chr> <int> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
# 1 3098129 1 fail <NA> <NA> <NA> <NA> <NA> <NA>
# 2 3096451 2 fail <NA> <NA> <NA> <NA> <NA> <NA>
# 3 3096774 3 fail <NA> <NA> <NA> <NA> <NA> <NA>
# 4 3095276 4 fail <NA> <NA> <NA> <NA> <NA> <NA>
# 5 3095464 5 pass <NA> <NA> <NA> <NA> <NA> <NA>
# 6 3096846 6 fail <NA> <NA> <NA> <NA> <NA> <NA>
# 7 3097132 7 fail <NA> <NA> <NA> <NA> <NA> <NA>
# 8 3096355 8 pass <NA> <NA> <NA> <NA> <NA> <NA>
# 9 3096951 9 fail <NA> <NA> <NA> <NA> <NA> <NA>
#10 3096328 10 fail <NA> <NA> <NA> <NA> <NA> <NA>
# … with 129 more rows
factors
因为在
data.frame
打电话,如果我们不。指定
stringsAsFactors = FALSE
, 默认情况下是
TRUE
str(df)
#'data.frame': 10 obs. of 3 variables:
# $ id : Factor w/ 5 levels "1","2","3","4",..: 1 2 3 4 5 1 2 3 4 5
# $ reader: Factor w/ 2 levels "aa","bb": 1 1 1 1 1 2 2 2 2 2
# $ event : Factor w/ 2 levels "0","1": 2 2 1 1 1 2 1 2 1 2
stringsAsFactors = FALSE
列将是
character
df <- data.frame(id = as.character(rep(seq(1:5),2)),
reader = c("aa","aa","aa","aa","aa","bb","bb","bb","bb","bb"),
event = as.character(rbinom(10, size = 1, prob=0.5)),
stringsAsFactors = FALSE
)
关于r - pivot_wider 输出 <S3 : vctrs_list_of> objects,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/58035452/
我可以使用以下方法对特定列进行 pivot_wider: new_df % pivot_longer(!c(id, value_col), names_to = "Cols", values_to
这个问题在这里已经有了答案: How to reshape data from long to wide format (11 个回答) 11 个月前关闭。 我想用pivot_wider为单个日期创建
我正在尝试转换长数据,以便重复行值成为标题。数据如下所示: # A tibble: 12 x 2 x1 x2 1 Position
我正在尝试将数据集从长到宽 reshape 。以下代码有效,但我很好奇是否有办法不提供值列并仍然使用 pivot_wider .在以下示例中,我必须创建一个临时列“val”才能使用 pivot_wid
我有什么: Symbol Date Value A. 07/20 10 A. 09/20. 12 B. 07/20. 15 B. 08/20. 19 VFINX. 07/20. 22 VFINX 08
Dataframe indrur 由变量 S447.1 组成,表示运输方式。我使用 dplyr 按变量分组并将其转换为宽格式。 library(dplyr) indrurmodes%
如果因子的级别存在,但在用作 names_from 参数时从未出现在数据中,我真的希望 pivot_wider 创建一个带有 NA 的列。例如,第一行给了我一个两列的 tibble,但我真的很喜欢下面
我试图从长到宽 reshape 我的数据,但在这里我需要创建名称列,例如 event1、event2、event3 等。换句话说,names_from 没有自然的候选者。争论。我尝试了几种不同的方法,
我有一个数据框,行和列中的变量都包含变量,因此我尝试使用数据透视表来整理数据。我的数据如下所示: head(df) # A tibble: 6 x 4 State Year Var
我的数据目前看起来像这样,列“Number_Code 基于每个不同的 Side_Effect: Session_ID Side_Effect Number_Code 1
这个问题在这里已经有了答案: Reshape multiple value columns to wide format (5 个答案) 关闭 2 年前。 我无法让我的数据框 pivot_wider
这个问题在这里已经有了答案: Reshape multiple value columns to wide format (5 个答案) 关闭 2 年前。 我无法让我的数据框 pivot_wider
我有以下类型的表: 经济特区类值1_1_1121_1_1521_1_2521_1_3111_1_3521_1_4111_1_5211_2_1121_2_152 为了在多个新列中传播“Class”列,从
我正在尝试转动它 df 1 38320858 recreation 6 11 2 38408709 business
我有一个在各个列中包含大量 NaN 的数据框。 df values 并使用 pivot_wider 将正数重新放回到它们原来的列中,然而,这失败了: library(tidyr) df %>% p
我有一个在各个列中包含大量 NaN 的数据框。 df values 并使用 pivot_wider 将正数重新放回到它们原来的列中,然而,这失败了: library(tidyr) df %>% p
我有以下用例 pivot_wider : 我有一个用逗号分隔的字符串的数据集。我想为每个逗号分隔值创建唯一的列,就像一个虚拟变量采用 1 s(存在值)和 0 s(值不存在)。 我可以使用下面显示的方法
我有这个数据: df_1 % pivot_longer(cols = c(x, y), names_to = 'factor', values_to = 'values',
我有以下我试图传播的数据集。 #create df df head(df) file_number reader event 3098129 aa fail
我对新的 tidyr::pivot_wider() 很着迷具有缺失值功能的函数。 它有时有效,有时无效。 这是一个可重现的示例: require('tidyr') df > green yellow
我是一名优秀的程序员,十分优秀!