作者nmamtb (南无 阿弥陀佛)
看板R_Language
标题[问题] factor转成numeric是否有数值的上限?
时间Tue May 1 19:41:40 2018
[问题类型]:
程式谘询(我想用R 做某件事情，但是我不知道要怎麽用R 写出来)
[软体熟悉度]:
新手(没写过程式，R 是我的第一次)
[问题叙述]:
大家好，我的问题是在 convert factor to numeric 时，会将遇到超过1,000的数值变成
NA，爬过网路上不少文章，集合了几种方法都无效。
#convert a factor to a numeric
##way1
library(varhandle)
unfactor(f)
##way2
as.numeric(levels(f))[f]
as.numeric(levels(f))[as.integer(f)]
as.numeric(as.character(f))
##way3
as.numeric.factor <- function(x) {as.numeric(levels(x))[x]}
##way4
,stringsAsFactors=FALSE
[程式范例]:
https://pastebin.com/2DQDxYAn
请注意第18个数值"1,130.00"变成了NA。
[环境叙述]:
R version 3.4.4 (2018-03-15)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows >= 8 x64 (build 9200)
Matrix products: default
locale:
[1] LC_COLLATE=Chinese (Traditional)_Taiwan.950 LC_CTYPE=Chinese
(Traditional)_Taiwan.950
[3] LC_MONETARY=Chinese (Traditional)_Taiwan.950 LC_NUMERIC=C
[5] LC_TIME=Chinese (Traditional)_Taiwan.950
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] survival_2.41-3
loaded via a namespace (and not attached):
[1] compiler_3.4.4 Matrix_1.2-12 tools_3.4.4 yaml_2.1.18
splines_3.4.4
[6] grid_3.4.4 lattice_0.20-35
[关键字]:
factor,as.numeric
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 111.252.215.235
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/R_Language/M.1525174911.A.550.html
※ 编辑: nmamtb (111.252.215.235), 05/01/2018 20:04:59
1F：→ x88776544pc: 逗号的问题, 先 a = gsub(",", "",a) 再做看看 05/01 22:16
2F：→ nmamtb: 感恩，感恩，成功了。原来要去除逗号阿。 05/02 00:56