CODEWITHSUNDEEP
rdataframe
R-obert
R-obert

Reputation: 1039

How to find highest value in a data frame?

I have a dataframe x with this values:

   x1  x2  x3
1  NA   4   1
2  NA   3  NA
3   4  NA   2
4  NA   1  11
5  NA   2  NA
6   5  NA   1
7   5   9  NA
8  NA   2  NA

A simple question: How do I get the highest value? (11)

Upvotes: 10

Views: 70712

Answers (3)

Al V
Al V

Reputation: 1286

you could write a column maximum function, colMax.

colMax <- function(data) sapply(data, max, na.rm = TRUE)

Use colMax function on sample data:

colMax(x)
#    x1     x2     x3
#   5.0    9.0    11.0

Upvotes: 1

Mahesh
Mahesh

Reputation: 3997

To find the sum of a column, you might want to unlist it first;

max(unlist(myDataFrame$myColumn), na.rm = TRUE)

Source

Upvotes: 2

Andrie
Andrie

Reputation: 179428

Use max() with the na.rm argument set to TRUE:

dat <- read.table(text="
   x1  x2  x3
1  NA   4   1
2  NA   3  NA
3   4  NA   2
4  NA   1  11
5  NA   2  NA
6   5  NA   1
7   5   9  NA
8  NA   2  NA", header=TRUE)

Get the maximum:

max(dat, na.rm=TRUE)
[1] 11

Upvotes: 30

Related Questions