I have the following R data frame:
zed
# A tibble: 10 x 3
jersey_number first_name statistics.minutes
<chr> <chr> <chr>
1 20 Marques 8:20
2 53 Brennan 00:00
3 35 Marvin 40:00
4 50 Justin 00:00
5 14 Jordan 00:00
6 1 Trevon 31:00
7 15 Alex 2:00
8 51 Mike 00:00
9 12 Javin 17:00
10 3 Grayson 38:00
> dput(zed)
structure(list(jersey_number = c("20", "53", "35", "50", "14",
"1", "15", "51", "12", "3"), first_name = c("Marques", "Brennan",
"Marvin", "Justin", "Jordan", "Trevon", "Alex", "Mike", "Javin",
"Grayson"), statistics.minutes = c("8:20", "00:00", "40:00",
"00:00", "00:00", "31:00", "2:00", "00:00", "17:00", "38:00")), row.names = c(NA,
-10L), class = c("tbl_df", "tbl", "data.frame"))
这是我从API接收到的数据格式,所有列(有约100列)最初都是字符
类型。为了将其全部转换,我使用readr::type_convert()
,但出现以下错误:
> zed %>% readr::type_convert()
Parsed with column specification:
cols(
jersey_number = col_integer(),
first_name = col_character(),
statistics.minutes = col_time(format = "")
)
# A tibble: 10 x 3
jersey_number first_name statistics.minutes
<int> <chr> <time>
1 20 Marques 08:20
2 53 Brennan 00:00
3 35 Marvin NA
4 50 Justin 00:00
5 14 Jordan 00:00
6 1 Trevon NA
7 15 Alex 02:00
8 51 Mike 00:00
9 12 Javin 17:00
10 3 Grayson NA
不要抛出错误或混乱转换,我希望将这个分钟列更改为class == numeric。如果一行显示“8:20”这个列,我希望它被简单地转换为8.33。
您有任何想法吗?最好是使用type_convert
继续使用的方法。