7

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
DK2
  • 651
  • 1
  • 7
  • 34

1 Answers1

22

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)
David Arenburg
  • 91,361
  • 17
  • 137
  • 196