How to replace string from numeric value in R?

Question

I have a dataset that contains the number of app installers, the data recorded with units M and K, like: 19M, 199K.

How to replace the prefixes with their values to convert values to numeric.

k to e+3

M to e+6

strsplit(), type.convert(), and switch() will be your friends — MichaelChirico
– MichaelChirico, Commented Mar 1, 2020 at 3:56
Check stackoverflow.com/questions/45972571/… , stackoverflow.com/questions/38013217/… and stackoverflow.com/questions/36806215/… — Ronak Shah
– Ronak Shah, Commented Mar 1, 2020 at 3:59

Edward · Accepted Answer · 2020-03-01 07:20:44Z

2

Edit: For values that have non-integer values.

x <- c("19M","20K","1K", "1.25M", "1.5K"); x
x <- sub("M", "e6", x); x
x <- sub("K", "e3", x); x
as.numeric(x)
[1] 19000000    20000     1000  1250000     1500

For integer values, the following is sufficient.

x <- c("19M","20K","1K")

x <- sub("M","000000", x)
x <- sub("K","000", x)
as.numeric(x)

1.9e+07 2.0e+04 1.0e+03

edited Mar 1, 2020 at 7:20

answered Mar 1, 2020 at 3:59

Edward

22.3k3 gold badges18 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Andrey Shabalin Over a year ago

1.5K is not 1.5e+00

Collectives™ on Stack Overflow

How to replace string from numeric value in R?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related