change value to percentage of row in R

DK2 picture DK2 · Jul 26, 2015 · Viewed 7.5k times · Source

this is my data

  A B C
A 9 1 0 
B 2 2 2
C 3 3 3

I want to get percentage of each row

my expect data is

     A    B    C
A  0.9  0.1    0 
B 0.33 0.33 0.33
C 0.33 0.33 0.33

I made my data with 'dcast' and there is column name on A,B and C. so actually my real data is

  Name    A    B    C
1    A  0.9  0.1    0 
2    B 0.33 0.33 0.33
3    C 0.33 0.33 0.33

Answer

David Arenburg picture David Arenburg · Jul 26, 2015

Seems a fair case for

df/rowSums(df)
#           A         B         C
# A 0.9000000 0.1000000 0.0000000
# B 0.3333333 0.3333333 0.3333333
# C 0.3333333 0.3333333 0.3333333

If you don't want so many digits after the dot set options(digits = 2) or use print(df/rowSums(df), digits = 2) or use round

round(df/rowSums(df), 2)
#      A    B    C
# A 0.90 0.10 0.00
# B 0.33 0.33 0.33
# C 0.33 0.33 0.33

Or as suggested by @akrun

round(prop.table(as.matrix(df1),1),2)