- 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 index of the nearest smallest number in an R data frame column?
To find the index of the nearest smallest number in an R data frame column, we can use which function along with subsetting for the value for which we want to find the index of the nearest smallest number. To understand how it can be done check out the below examples.
Example1
Consider the below data frame −
ID<-1:20 Response<-rpois(20,10) df1<-data.frame(ID,Response) df1
Output
ID Response 1 1 14 2 2 3 3 3 9 4 4 8 5 5 12 6 6 7 7 7 16 8 8 6 9 9 7 10 10 7 11 11 9 12 12 12 13 13 7 14 14 6 15 15 12 16 16 14 17 17 13 18 18 12 19 19 11 20 20 10
x1<-5
Finding the index of value in Response column that is nearest smallest to value in x1 −
which(df1$Response==max(df1$Response[df1$Response<=x1]))
[1] 2
Example2
Y<-rpois(20,10) df2<-data.frame(group,Y) df2
Output
group Y 1 c 7 2 a 8 3 b 11 4 b 8 5 b 11 6 b 9 7 c 6 8 b 8 9 b 11 10 c 10 11 c 9 12 b 10 13 a 12 14 a 12 15 c 9 16 b 11 17 a 12 18 b 7 19 c 8 20 b 12
x2<-10
Finding the index of value in Response column that is nearest smallest to value in x1 −
which(df2$Y==max(df2$Y[df2$Y<=x2]))
[1] 10 12
Advertisements