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 remove at the rate sign @ at last position from every value in R data frame column?
To remove at the rate sign @ at last position from every value in R data frame column, we can follow the below steps −
First of all, create a data frame with a column having at the rate sign @ at last position in every value.
Then, use gsub function to remove the at the rate sign @ at last position from every value in the column.
Example
Create the data frame
Let’s create a data frame as shown below −
Names<-
sample(c("emily@","sherjil@","nizam@","john@","michelle@","ronak@"),25,replace=TRUE)
df<-data.frame(Names)
dfOutput
On executing, the above script generates the below output(this output will vary on your system due to randomization) −
Names 1 michelle@ 2 michelle@ 3 sherjil@ 4 nizam@ 5 sherjil@ 6 john@ 7 michelle@ 8 nizam@ 9 nizam@ 10 emily@ 11 john@ 12 john@ 13 ronak@ 14 michelle@ 15 michelle@ 16 ronak@ 17 emily@ 18 sherjil@ 19 ronak@ 20 sherjil@ 21 michelle@ 22 emily@ 23 sherjil@ 24 sherjil@ 25 sherjil@
Remove at the rate (@) sign from last position
Using gsub function to remove the at the rate sign that is @ at last position from every value in column Names of data frame df as shown below −
Names<-
sample(c("emily@","sherjil@","nizam@","john@","michelle@","ronak@"),25,replace=TRUE)
df<-data.frame(Names)
df$new_Names<-gsub("@$","",df$Names)
dfOutput
Names new_Names 1 michelle@ michelle 2 michelle@ michelle 3 sherjil@ sherjil 4 nizam@ nizam 5 sherjil@ sherjil 6 john@ john 7 michelle@ michelle 8 nizam@ nizam 9 nizam@ nizam 10 emily@ emily 11 john@ john 12 john@ john 13 ronak@ ronak 14 michelle@ michelle 15 michelle@ michelle 16 ronak@ ronak 17 emily@ emily 18 sherjil@ sherjil 19 ronak@ ronak 20 sherjil@ sherjil 21 michelle@ michelle 22 emily@ emily 23 sherjil@ sherjil 24 sherjil@ sherjil 25 sherjil@ sherjil
Updated on: 12-Nov-2021
44 Views
Advertisements