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 get list of all columns except one or more columns from an R data frame?
Sometimes, we want to use some columns of an R data frame for analysis, therefore, it is better to get a list of all the columns that we need. In this way, we don’t have to worry about the column operations, if required because we will be having only necessary columns. To get the list of all columns except one or more columns can be done with the help of single square brackets.
Example
Consider the below data frame −
set.seed(100) x1 <-LETTERS[1:20] x2 <-sample(1:100,20) x3 <-sample(1:10,20,replace=TRUE) x4 <-rnorm(20) df <-data.frame(x1,x2,x3,x4) df
Output
x1 x2 x3 x4 1 A 74 2 -0.69001432 2 B 89 3 -0.22179423 3 C 78 4 0.18290768 4 D 23 4 0.41732329 5 E 86 4 1.06540233 6 F 70 5 0.97020202 7 G 4 7 -0.10162924 8 H 55 9 1.40320349 9 I 95 4 -1.77677563 10 J 7 2 0.62286739 11 K 91 6 -0.52228335 12 L 93 7 1.32223096 13 M 43 1 -0.36344033 14 N 82 6 1.31906574 15 O 61 9 0.04377907 16 P 12 9 -1.87865588 17 Q 51 9 -0.44706218 18 R 72 6 -1.73859795 19 S 18 8 0.17886485 20 T 25 7 1.89746570
Example
df[,1] [1] A B C D E F G H I J K L M N O P Q R S T Levels: A B C D E F G H I J K L M N O P Q R S T df[,1:3]
Output
x1 x2 x3 1 A 74 2 2 B 89 3 3 C 78 4 4 D 23 4 5 E 86 4 6 F 70 5 7 G 4 7 8 H 55 9 9 I 95 4 10 J 7 2 11 K 91 6 12 L 93 7 13 M 43 1 14 N 82 6 15 O 61 9 16 P 12 9 17 Q 51 9 18 R 72 6 19 S 18 8 20 T 25 7
Example
df[,c(2,4)]
Output
df[,c(2,4)]
Example
x2 x4 1 74 -0.69001432 2 89 -0.22179423 3 78 0.18290768 4 23 0.41732329 5 86 1.06540233 6 70 0.97020202 7 4 -0.10162924 8 55 1.40320349 9 95 -1.77677563 10 7 0.62286739 11 91 -0.52228335 12 93 1.32223096 13 43 -0.36344033 14 82 1.31906574 15 61 0.04377907 16 12 -1.87865588 17 51 -0.44706218 18 72 -1.73859795 19 18 0.17886485 20 25 1.89746570
Example
df[,-c(2,4)]
Output
x1 x3 1 A 2 2 B 3 3 C 4 4 D 4 5 E 4 6 F 5 7 G 7 8 H 9 9 I 4 10 J 2 11 K 6 12 L 7 13 M 1 14 N 6 15 O 9 16 P 9 17 Q 9 18 R 6 19 S 8 20 T 7
Example
df[,-1]
Output
x2 x3 x4 1 74 2 -0.69001432 2 89 3 -0.22179423 3 78 4 0.18290768 4 23 4 0.41732329 5 86 4 1.06540233 6 70 5 0.97020202 7 4 7 -0.10162924 8 55 9 1.40320349 9 95 4 -1.77677563 10 7 2 0.62286739 11 91 6 -0.52228335 12 93 7 1.32223096 13 43 1 -0.36344033 14 82 6 1.31906574 15 61 9 0.04377907 16 12 9 -1.87865588 17 51 9 -0.44706218 18 72 6 -1.73859795 19 18 8 0.17886485 20 25 7 1.89746570
Example
df[,-4]
Output
x1 x2 x3 1 A 74 2 2 B 89 3 3 C 78 4 4 D 23 4 5 E 86 4 6 F 70 5 7 G 4 7 8 H 55 9 9 I 95 4 10 J 7 2 11 K 91 6 12 L 93 7 13 M 43 1 14 N 82 6 15 O 61 9 16 P 12 9 17 Q 51 9 18 R 72 6 19 S 18 8 20 T 25 7
Updated on: 21-Aug-2020
1K+ Views
Advertisements