Remove characters from field in dataframe

Question

I'm using superstore dataset from kaggle. Sales and profit column has $ symbol so R stored it as character datatype how to change it back to an integer data type. Can someone help

Answer 1

Use the below code to update the sales and profit field data type and values.

superstore$Sales = substring(superstore$Sales,2)
superstore$Profit = substring(superstore$Profit,2)
# Change the data type as integer/ numeric
class(superstore$Sales) = "Numeric"
# Or
superstore$Sales= as.numeric(superstore$Sales)