 Apr 13, 2018 815 views

## 1 answer to this question.

We can Drop Columns by name in a Data frame using following two methods:

Create a data frame

The following code creates a sample data frame which we will use for demonstration.
set.seed(556)
mydata <- data.frame(m=letters[1:5], x=runif(5,10,50), y=sample(5), z=rnorm(5))
# Delete column by name

Method I :

One of the most easiest way to drop columns is by using subset() function.
The following code tells R to drop variables x and z.
Note: Don't specify the variable names in quotes when using subset() function.

df = subset(mydata, select = -c(x,z) )

> mydata
m        x y           z
1 a 33.83910 2 -1.02569136
2 b 23.50851 3  0.59367584
3 c 22.91966 1 -0.06436851
4 d 33.18065 4 -0.04719129
5 e 13.79128 5 -1.80186137

> df
m y
1 a 2
2 b 3
3 c 1
4 d 4
5 e 5

Method II :

The function names() returns all the column names and the '!' sign indicates negation.
drop <- c("x","z") #we are creating a character vector named drop in which we are storing column names x and z
df = mydata[,!(names(mydata) %in% drop)] #Selecting all the variables except the column names specified in the vector drop. The '!' sign indicates negation.
> df
m y
1 a 2
2 b 3
3 c 1
4 d 4
5 e 5

It can also be written like :  df = mydata[,!(names(mydata) %in% c("x","z"))]

> set.seed(556)
> mydata <- data.frame(m=letters[1:5], x=runif(5,10,50), y=sample(5), z=rnorm(5))
> df = mydata[,!(names(mydata) %in% c("x","z"))]
> df
m y
1 a 2
2 b 3
3 c 1
4 d 4
5 e 5 answered Apr 13, 2018 by
• 3,750 points

## How to sort a data frame by columns in R?

You can use dplyr function arrange() like ...READ MORE

## How to drop data frame columns by name?

Easily you can do it: drops <- c("V2","V4") df1[ ...READ MORE

## How to use a function to repeat a set of procedures on specific set of columns in a data frame?

You can parse the strings to symbols. ...READ MORE

## How to drop factor levels in a subsetted data frame?

You can use factor(ff) to drop levels ...READ MORE

+1 vote

## How can I find number of columns in a dataframe

To know the number of columns in ...READ MORE

## Shiny r ,I'm doing a dashboard and I can not replace in the table below the name of the column by choosing the selectinput.

Hi, When you want to change any input ...READ MORE