Finding the max of a R dataframe column ignoring -Inf and NA

user_3841581 0
Viewed 13567

I have a R dataFrame from which some columns have -Inf and Na. I would like to find the max of a specific column ignoring the Inf and NA. My dataFrame df is as follow:

column1     column2
  -Inf        2
   4          8
   Na         5
   7          4
   10         4

I tried using 

temp=df
temp[is.infinite(temp)]<-NA
my_max=max(temp$column1, na.rm=TRUE)

but I get the following error:

Error in is.infinite(temp) : default method not implemented for type 'list'

I would like to my_max to be equal to 10. How can I tackle this problem?

dataframe r
4 Answers

There is a simple solution in the hablar package. BY adding s() before max you avoid this problem.

data <- data.frame(column1 = c(-Inf, 4, NA, 7, 10), column2 = c(2, 8, 5, 4, 4))

max(s(data$column1))

Return 10 and have ignores the Inf and NA of the vector.

user_78164820
Related