How to find the extremes of a data frame column in R if infinity exists in the column?
To find the extremes of a data frame column that is numeric can be done with the help of min and max function but if we want to get the same in single line code then range function can be used. If there are some infinity values in the column then range.default function will be used as shown in the below example.
Example
Live Demo
Consider the below data frame −
set.seed(214)
x1<−sample(c(1,5,Inf,10),20,replace=TRUE)
x2<−rpois(20,5)
df1<−data.frame(x1,x2)
df1
Output
x1 x2
1 Inf 0
2 10 5
3 1 3
4 10 7
5 10 3
6 5 5
7 1 4
8 Inf 2
9 10 3
10 Inf 9
11 1 4
12 Inf 3
13 5 3
14 5 5
15 1 6
16 Inf 1
17 10 6
18 Inf 3
19 10 4
20 10 8
Finding the extremes of column x1 −
Example
range.default(df1$x1,finite=TRUE)
Output
[1] 1 10
Example2
Live Demo
y1<−rnorm(20,5,2.3)
y2<−sample(c(Inf,rnorm(5,2)),20,replace=TRUE)
df2<−data.frame(y1,y2)
df2
Output
y1 y2
1 5.711206 2.367679
2 3.891755 2.367679
3 8.345217 1.529547
4 4.316907 1.888925
5 5.945366 Inf
6 8.204934 1.888925
7 9.634025 Inf
8 5.096354 Inf
9 8.186749 2.367679
10 6.808151 Inf
11 6.310553 2.586410
12 5.207341 2.586410
13 4.190045 1.888925
14 6.570371 Inf
15 1.553658 2.367679
16 5.869204 2.367679
17 7.211524 2.586410
18 7.517553 1.888925
19 7.224195 3.003426
20 4.105865 1.888925
Finding the extremes of column x1 −
Example
range.default(df2$y2,finite=TRUE)
Output
[1] 1.529547 3.003426
Published on 08-Feb-2021 11:57:38
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP