Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
390 views
in Technique[技术] by (71.8m points)

r - Factor with comma and percentage to numeric

I have a column ("rates")which is a factor with several levels such as:

16 Levels: -0,186% -0,229% -0,326% ...

When I try to convert it to numeric, NAs are introduced and I can't figure out how to do it properly.

rates=as.numeric(gsub(",", ".", rates))
rates=as.numeric(sub("%", "e-2", rates))

I also tried the following, which was the answer to a similar question, but it does not work either. rates=as.numeric(gsub("\%", "", rates))

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

Another option is to use the parse_number-function from the readr-package and specify that a comma is used as decimal mark:

library(readr)
parse_number(rates, locale = locale(decimal_mark = ','))

which gives:

[1] -0.186 -0.229 -0.326

Used data:

rates <- as.factor(c("-0,186%", "-0,229%", "-0,326%"))

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...