Drop multiple columns using Dplyr package in R

In this article, we will discuss how to drop multiple columns using dplyr package in R programming language.

Dataset in use:

Drop multiple columns by using the column name

We can remove a column with select() method by its column name

Syntax:

select(dataframe,-c(column_name1,column_name2,.,column_name n)

Where, dataframe is the input dataframe and -c(column_names) is the collection of names of the column to be removed.

Example: R program to remove multiple columns by column name

Output:

Drop multiple columns by using column index

We can remove a column with select() method by its column index/position. Index starts with 1.

Syntax:

select(dataframe,-c(column_index1,column_index2,.,column_index n)

Where, dataframe is the input dataframe and c(column_indexes) is the position of the columns to be removed.

Example: R program to remove multiple columns by position

Output:

Drop column which contains a value or matches a pattern

Let’s see how to remove the column that contains the character/string.

Method 1: Using contains()

Display the column that contains the given substring and then -contains() removes the column that contains the given substring.

Syntax:

select(dataframe,-contains(‘sub_string’))

Here, dataframe is the input dataframe and the sub_string is the string present in the column name that will be removed.

Method 2: Using matches()

Display the column that contains the given substring and then -matches() removes the column that contains the given substring

Syntax:

select(dataframe,-matches(‘sub_string’))

Here, dataframe is the input dataframe and the sub_string is the string present in the column name that will be removed.

Example: R program that removes column using contains() method

Output:

Remove column which starts with or ends with certain character

Here we can also select columns based on starting and ending characters.

• starts_with() is used to return the column that starts with the given character and -starts_with() is used to remove  the column that starts with the given character.

Syntax:

select(dataframe,-starts_with(‘substring’))

Where, dataframe is the input dataframe and substring is the character/string that starts with it

• ends_with() is used to return the column that ends with the given character and -ends_with() is used to remove the column that ends with the given character.

Syntax:

select(dataframe,-ends_with(‘substring’))

Where, dataframe is the input dataframe and substring is the character/string that ends with it.

Example 1: R program to remove a column that starts with character/substring

Output:

Example 2: R program to remove column that ends with character/substring

Output:

Drop column name with Regular Expression

Here we are going to drop the column based on the pattern given in grepl() function. It will find a pattern and remove the column based on the given pattern

Syntax:

dataframe[,!grepl(“pattern”,names(dataframe))]

Here, dataframe is the input dataframe and pattern is the expression to remove the column.

Pattern to remove the column where starting character in column starts is

Syntax:

data[,!grepl(“^letter”,names(data))]

Example: R program to remove column that starts with a letter

Output: