Format numeric to two-digits

Question

I have a column of numeric class, e.g.: v <- c(12345, 2345, 7689900).

I know that every number is actually of the form 12.345, 23.45, 76.89900, ie every numeric has two digits and the rest is decimals.

How can I convert the vector to this format? No decimal should be cropped in the process.

What happens when the input is 1 digit or 2 digits? – zx8754 Jun 22 '20 at 09:51 — zx8754, Jun 22 '20 at 09:51

score 2 · Accepted Answer · edited Jun 22 '20 at 09:50

2

If you are looking for a numeric vector, one option could be:

v/10^(nchar(v) - 2)

[1] 12.345 23.450 76.899

Edit:

In cases when we have more than 20 digits, we can Count the number of integer digits using log10:

v/10^(floor(log10(abs(v))) + 1 - 2)

edited Jun 22 '20 at 09:50

zx8754

answered Jun 22 '20 at 09:00

tmfmnk

3

Just to note: `nchar(1234567890123456789012345)` would give you 20 not 25. – zx8754 Jun 22 '20 at 09:13
1

@zx8754 thank you for your edit, very interesting :) – tmfmnk Jun 22 '20 at 10:26
No problems! Since this is an accepted solution **and** I stole the idea from the linked post, I didn't want to post yet another answer. – zx8754 Jun 22 '20 at 10:28

score 1 · Answer 2 · answered Jun 22 '20 at 08:59

1

Using regex we can capture the data in two groups separated by ".".

sub('(..)(.*)', '\\1.\\2', v)
#[1] "12.345"   "23.45"    "76.89900"

You can wrap this in as.numeric if you want to perform some manipulation on this.

answered Jun 22 '20 at 08:59

Ronak Shah

score 1 · Answer 3 · answered Jun 22 '20 at 09:28

1

as.numeric(paste0(substring(v,1,2), ".", substring(v,3)))
# [1] 12.345 23.450 76.899

answered Jun 22 '20 at 09:28

s_baldur

3 Answers3