Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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
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
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
Updated on: 08-Feb-2021
161 Views
Advertisements