Min for Each Row in a Data Frame

min for each row in a data frame

You can use apply to go through each row

apply(df, 1, FUN = min)

Where 1 means to apply FUN to each row of df, 2 would mean to apply FUN to columns.

To remove missing values, use:

apply(df, 1, FUN = min, na.rm = TRUE)

Computing the minimum value for each row in a Pandas DataFrame

Use pandas.DataFrame.min with axis=1:

df['Dmin'] = df.min(axis=1)

Minimum value for each row in pandas dataframe

Convert values to numeric with non numeric to NaNs by errors='coerce' in to_numeric and DataFrame.apply so is possible use min:

df['Min'] = df.apply(pd.to_numeric, errors='coerce').min(axis=1)
print (df)
   A   B    C   D  Min
0  1   3  2.0  WD  1.0
1  3  WD  NaN   2  2.0

How to find the indexes of minimum value for each row of a dataframe?

We can use apply to loop over the rows (MARGIN =1), compare the elements in the row with min of the row

t(apply(df, 1, function(x) x == min(x)))

-output

#  [,1]  [,2]  [,3]  [,4]
#x TRUE FALSE FALSE  TRUE
#y TRUE FALSE  TRUE FALSE

---

Or make it compact with rowMins from matrixStats

library(matrixStats)
df == rowMins(df)
#  [,1]  [,2]  [,3]  [,4]
#x TRUE FALSE FALSE  TRUE
#y TRUE FALSE  TRUE FALSE

---

Or if we want to stick with base R and use a vectorized option then pmin is another way (after converting the matrix to data.frame)

df == do.call(pmin, as.data.frame(df))

Substract minimum value of row from each element of row in dataframe,

You can also use the apply fonction with :

# 1 for the rows
apply(d, 1, function(x){x-min(x)}
# 2 for the columns 
apply(d, 2, function(x){x-min(x)}

How to get row-wise absolute minimum value in pandas dataframe

Use np.argmin (numpy counterpart of DataFrame.idxmin). Since you want to extract the original values, it's more convenient to access those values at the numpy level.

I added an extra row to your MRE for demonstration:

cols = np.argmin(df.abs().to_numpy(), axis=1) # [0, 2]
rows = range(len(cols))                       # [0, 1]
df['Result'] = df.to_numpy()[rows, cols]

#    Col1  Col2  Col3  Result
# 0    -1     2    -3      -1
# 1    10    -5     4       4

print the minimum for each row in a dataset in R

You can use the apply function to run methods over each row of a data frame. For example, the following will find the minimum value of each row of the data frame dataset:

apply(dataset, 1, min)

Min value per row, Python Pandas

Use filter for get only column with Dist with min function:

df['MinDistance'] = df.filter(like='Dist').min(axis=1)

Or if possible select columns by positions use iloc:

df['MinDistance'] = df.iloc[:, 2:].min(axis=1)

---

Related Topics