Format numbers in R

Question

I have a dataframe with numbers. I need to format it by adding commas.

df
ColA   ColB
sd     68900744.0
fg     78900744.0
gh     88900744.0
fg     1375292.0

Expected output

df
ColA   ColB
sd     68,900,744
fg     78,900,744
gh     88,900,744
fg     1,375,292

https://stackoverflow.com/questions/3838774/comma-separator-for-numbers-in-r — user2974951, Jan 30 '20 at 11:51

jyr · Answer 1 · 2020-01-30T11:54:15.083

0

For more information see ?formatC

  df$ColB_new <- formatC(df$ColB, format="f", big.mark=",", digits=0)

edited Jan 30 '20 at 11:54

answered Jan 30 '20 at 11:44

jyr

thanks. But it is converting numeric to character? Is it not possible to keep as numeric only? – imran p Jan 30 '20 at 11:51
What do you need it for? – jyr Jan 30 '20 at 11:57
I need to sum as well. And also I need to show with commas – imran p Jan 30 '20 at 11:58
You can do your computation and just change it for the final output. Maybe try custom print function: `my_print <- function(dta){dta$ColB <- formatC(...); print(dta)}` – jyr Jan 30 '20 at 12:01

1 Answers1