Converting char dataframe column to int column


I imported csv. file to the R from Kaggle.
"Income" column of my dataset is in char type inside quotation marks:

$ Income : chr "$84,835.00 " "$57,091.00 " "$67,267.00 " "$32,474.00 "

How can I convert this column to int type? I tried some functions but I got full NA results.

In this way, I can not analyse this column in terms of mean,median,distribution etc.

Thank you.

I would use the sub() function to remove the dollar signs and commas.

DF <- data.frame(A=c("$84,235.00","$45,678.00"))
[1] "$84,235.00" "$45,678.00"
DF$A <- sub("\\$","",DF$A)
DF$A <- sub(",","",DF$A)
DF$A <- as.integer(DF$A)
[1] 84235 45678
1 Like

will probably help you, as you can let it do basic interpretation to at least get you to where the variable is a number without doing your own string manipulation.

oh my gosh, this function is so basic thanks!

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.