# Row wise minimum – row min in R dataframe

Row wise minimum of the dataframe in R or minimum value of each row is calculated using rowMins() function. Other method to get the row minimum in R is by using apply() function. row wise minimum of the dataframe is also calculated using dplyr package. rowwise() function of dplyr package along with the min function is used to calculate row wise min. we will be looking at the following examples

• Row wise minimum of R dataframe using rowMins()
• Row minimum of the dataframe using apply() function.
• Row wise minimum of the dataframe using dplyr package. First let’s create the dataframe

```
### Create Data Frame

df1 = data.frame( Name = c('George','Andrea', 'Micheal','Maggie','Ravi','Xien','Jalpa'),
Mathematics1_score=c(62,47,55,74,32,77,86),
Mathematics2_score=c(45,78,44,89,66,49,72),
Science_score=c(56,52,45,88,33,90,47))

df1

```

df1 will be #### Row wise min in R dataframe using rowMins()

Let’s calculate the row wise min in R using rowMins() function as shown below. rowMins() function takes up column 2 to 4 and finds row wise minimum value.

```
## row wise minimum using rowMins()

install.packages("matrixStats")
library(matrixStats)

df1\$row_minimum = rowMins(as.matrix(df1[,c(2,3,4)]))
df1
```

## or

```
## row wise min using rowMins()

install.packages("matrixStats")
library(matrixStats)

df1\$row_minimum = rowMins(as.matrix(df1[,c(-1)]))
df1

```

So the resultant dataframe will be #### Row wise minimum in R dataframe using apply() function

Let’s calculate the row wise min in R using apply() function as shown below.apply() function takes three arguments first argument is dataframe without first column and second argument is used to perform row wise operation (argument 1- row wise ; 2 – column wise ). third argument minimum function which calculates minimum values.  so here it performs row wise minimum.

```### Row wise minimum using apply() function

df1\$row_minimum = apply(df1[,-1], 1, min)
df1
```

So the resultant dataframe will be #### Row wise min of the dataframe in R using dplyr: Method 1

rowMins() function of matrixStats package. takes up the columns 2 to 4 and performs the row wise operation with NA values replaced to zero.  row wise min is calculated using pipe (%>%) operator of the dplyr package.

```##### Dplyr row wise min
library(dplyr)
library(matrixStats)

df1 %>% replace(is.na(.), 0) %>% mutate(row_wise_min = rowMins(as.matrix(df1[,c(2,3,4)])))
```

So the resultant dataframe with row wise min calculated will be #### Row wise minimum of the dataframe using dplyr: Method 2

Row wise minimum is calculated with the help rowwise() function of dplyr package  and min() function as shown below

```## row wise minimum using dplyr

library(dplyr)
library(matrixStats)

df1 %>%
rowwise() %>%
mutate(
Min_price = min(c(Mathematics1_score,Mathematics2_score,Science_score))
)
```

row wise minimum of “Mathematics1_score” , “Mathematics2_score” and “Science_score” is calculated and populated for each row as shown below For more Details kindly refer to matrixStats package in R

## Author

• With close to 10 years on Experience in data science and machine learning Have extensively worked on programming languages like R, Python (Pandas), SAS, Pyspark.