Download All Column Names R
- 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
Published on 21-Aug-2020 11:42:53
- Related Questions & Answers
- How to create a data frame with one or more columns as a list in R?
- How to apply one sample t-test on all columns of an R data frame?
- How to create histogram of all columns in an R data frame?
- How to add all columns of an R data frame by row?
- How to find standard deviations for all columns of an R data frame?
- How to find the median of all columns in an R data frame?
- How to select only numeric columns from an R data frame?
- How to standardize columns in an R data frame?
- How to extract only factor columns name from an R data frame?
- How to convert columns of an R data frame into rows?
- How to find the mean of columns of an R data frame or a matrix?
- How to perform Wilcoxon test for all columns in an R data frame?
- How to perform shapiro test for all columns in an R data frame?
- How to find the class of columns of an R data frame?
- How to reorder the columns in an R data frame?
Source: https://www.tutorialspoint.com/how-to-get-list-of-all-columns-except-one-or-more-columns-from-an-r-data-frame
Posted by: blackcurrent05.blogspot.com