R String Processing -

Question

I have below data frame with two input string (input1 & input2 column) and need help to convert the output string (as described in the output column). I am looking for solution using base R (preferably regular expression)

df <- data.frame(input1=c("0000.00", "0000.00", "0000.00"),
                 input2 = c("23.3", "23", "2323.23"), 
                 output = c("0023.30", "0023.00", "2323.23"))

Hi,Please try something like this.hope this will help.df$output <- paste0(df$input1,"",df$input2) you have split the data after this to get your answer. — Tushar Lad
– Tushar Lad, Commented Jan 27, 2020 at 5:31
If you want to format numbers, then you can use functions like format or formatC. There may be a better way if you try and approach it like that — Rohit
– Rohit, Commented Jan 27, 2020 at 6:12

Rui Barradas · Accepted Answer · 2020-01-27 06:27:06Z

3

Try the following, it uses formatC to get the right output width and decimal places. It determines the numbers of digits before and after the decimal point with strsplit/sapply/nchar.

fun <- function(X){
  sp <- strsplit(as.character(X[[1]]), "\\.")
  m <- max(nchar(sapply(sp, '[[', 1)))
  n <- max(nchar(sapply(sp, '[[', 2)))

  formatC(as.numeric(as.character(X[[2]])),
          digits = n, width = m + n + 1, 
          format = "f", flag = "0")
}

fun(df)
#[1] "0023.30" "0023.00" "2323.23"

answered Jan 27, 2020 at 6:27

Rui Barradas

78k8 gold badges41 silver badges75 bronze badges

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

Collectives™ on Stack Overflow

R String Processing -

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related