how to divide a number of columns by one column in r

r divide
paploo picture paploo · Dec 14, 2017 · Viewed 8.5k times · Source

I have the below dataset: I am doing the below in r:

Monday Tuesday Wednesday Friday Saturday Total
2       3      4          5      6        20
3       6      7          5      1        22

I need to divide 2/20, 3/20, 4/20,5/20,6/20 and on the second row, 3/22,6/22,7/22,5/22,1/22. I can do this by extracting the columns but it is long and tedious,please there must be an easier way please

Answer

mtoto picture mtoto · Dec 14, 2017

You can simply do

df[,1:5] / df[,6]

Related questions

Divide each data frame row by vector in R

I'm trying to divide each number within a data frame with 16 columns by a specific number for each column. The numbers are stored as a data frame with 1-16 corresponding to the samples in the larger data frames columns 1-16. …

Read More
Remove rows with all or some NAs (missing values) in data.frame

I'd like to remove the lines in this data frame that: a) contain NAs across all columns. Below is my example data frame. gene hsap mmul mmus rnor cfam 1 ENSG00000208234 0 NA NA NA NA 2 ENSG00000199674 0 2 2 2 2 3 ENSG00000221622 0 NA NA NA NA 4 …

Read More
Drop data frame columns by name

I have a number of columns that I would like to remove from a data frame. I know that we can delete them individually using something like: df$x <- NULL But I was hoping to do this with …

Read More