Converting "1000,00+" values to numeric in R gives warning "NAs introduced by coercion"?

Question

My dataset has column "Installs" which has values like ("5,000+", "10,000+", .... )

When I try to convert it to numeric, it gives me NA values with an error:

df <- as.numeric(gsub(",","",df_dataset$Installs))

Warning message:
NAs introduced by coercion

I want to replace both "+" and "," symbols. How can I acheive that?

Possible duplicate https://stackoverflow.com/questions/31944103/convert-currency-with-commas-into-numeric — Ronak Shah, Dec 20 '20 at 08:41

score 1 · Accepted Answer · answered Dec 20 '20 at 06:44

1

Try removing all non numeric characters:

Installs_Numeric <- as.numeric(gsub("[,+]+", "", df_dataset$Installs))

answered Dec 20 '20 at 06:44

Tim Biegeleisen

1

Thanks, I will accept this as correct answer. – Biswas Khayargoli Dec 20 '20 at 06:46

1 Answers1