且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

检查所有值是否在多个列上都是数字并将其转换为数字

更新时间:2023-11-26 09:14:28

我们可以使用中的 parse_guess 函数readr 包,该包基本上试图猜测列的类型。

We can use parse_guess function from readr package which basically tries to guess the type of columns.

library(readr)
library(dplyr)

df1 <- df %>% mutate_all(parse_guess)


str(df1)
#'data.frame':  16 obs. of  11 variables:
# $ ID         : chr  "A" "A" "A" "A" ...
# $ ToolID     : chr  "CCP_A" "CCP_A" "CCQ_A" "CCQ_A" ...
# $ Step       : chr  "Step_A" "Step_A" "Step_B" "Step_C" ...
# $ Measurement: chr  "Length" "Breadth" "Width" "Height" ...
# $ Passfail   : chr  "Pass" "Pass" "Fail" "Fail" ...
# $ Points     : int  7 5 3 4 0 0 0 0 17 15 ...
# $ Average    : num  7.5 6.5 7.1 6.6 NA NA NA NA 17.5 16.5 ...
# $ Sigma      : num  2.5 2.5 2.1 2.6 NA NA NA NA 12.5 12.5 ...
# $ Tool       : chr  "ABC_1" "ABC_2" "ABD_1" "ABD_2" ...
# $ Dose       : num  NA NA NA NA 17.1 NA NA 17.3 NA NA ...
# $ Machine    : chr  "CO2" "CO6" "CO3" "CO6" ...