Dan Dan - 2 months ago 12
R Question

adding commas into number for output

i'm outputting a dataframe to html via xtable now (tip to Shane, little nicer than r2html). I want to add commas to numbers in a couple columns of the table. I figured before i did my own paste hack I'd check if there is a built in way to do this. Anyone.

Answer

You might want to consider transforming the column using formatC

> formatC(1:10 * 100000, format="d", big.mark=',')
 [1] "100,000"   "200,000"   "300,000"   "400,000"   "500,000"   "600,000"  
 [7] "700,000"   "800,000"   "900,000"   "1,000,000"
Comments