Modify Columns

Existing columns can be modified by assigning new values to desired columns.

Syntax:

 mutate(dataframe,column_name=new_values)

Parameters: It will take two parameters

  • dataframe is the input dataframe
  • column_name is the name of the column to modify the values

Example:

R




library(dplyr)
  
# Create a data frame
d < - data.frame(FirstName=c("Suresh", "Ramesh", "Tanya", "Sujata"),
                 Salary=c(50000, 60000, 70000, 80000),
                 Expenses=c(20000, 15000, 30000, 25000))
  
print(d)
  
# Modify FirstName, Salary  column
d < - mutate(d, FirstName=c("Mahesh", "Jignesh", "Ria", "Tanya"),
             Salary=c(60000, 30000, 50000, 75000))
  
print(d)


FirstName  Salary  Expenses

Suresh       50000   20000
Ramesh     60000   15000
Tanya      70000   30000
Sujata     80000   25000

FirstName  Salary  Expenses 

Mahesh       60000   20000   
Jignesh    30000   15000   
Ria        50000   30000   
Tanya      75000   25000


Create, modify, and delete columns using dplyr package in R

In this article, we will discuss mutate function present in dplyr package in R Programming Language to create, modify, and delete columns of a dataframe.

Similar Reads

Create new columns

Columns can be inserted either by appending a new column or using existing columns to evaluate a new column. By default, columns are added to the far right. Although columns can be added to any desired position using .before and .after arguments...

Delete Columns

...

Modify Columns

Columns can be deleted from the existing data frame by setting the value of the desired column to NULL....