Removing a specific character in the string from column of the data frame in R

Asked Jan 07 '20 at 13:03

Active Jan 07 '20 at 13:03

Viewed 19 times

I have a dataframe L with column price that I store in variable pr. I want to remove the "$" from the price column and then turn it into numeric. How do I do this please? I tried as followed.

This is my column before:

columnBefore

I tried this code:

pr = L$price
pr <- gsub("$", "", pr)
pr

But, instead of removing "$", it adds "" to the data

columnAfter

Could you please let me know how I can do this? Thank you in advance.

edited Jan 07 '20 at 13:03

Wiktor Stribiżew

607,720
39
448
563

asked Jan 07 '20 at 13:03

Shuti

1

`$` is an end of string position in regex. Escape it, or use in a bracket expression like `[$]`, or just use `fixed=TRUE` argument with your `gsub` code. – Wiktor Stribiżew Jan 07 '20 at 13:04
Ohhh thank you so much. Yes, it works with [$] :-) – Shuti Jan 07 '20 at 13:17
I think `gsub("$", "", pr, fixed=TRUE)` is more "idiomatic" since you do not even need to use a regex. – Wiktor Stribiżew Jan 07 '20 at 13:21
Thank you I will try this as well :) – Shuti Jan 09 '20 at 16:09

Removing a specific character in the string from column of the data frame in R

0 Answers0