Tuesday, 19 March 2013

Dealing with different object types in a vector in R

I came across a little problem while dealing with a vector in R which had one of the most simple solutions. These are, in my opinion, the most annoying problems with the most simple and commonsensical solution. Anyways, yet again Utkarsh comes to rescue and slaps me with the realization that no matter what one does nothing can match an open mind and common sense.Well, I hope someone struggling with a similar problem might bump into this post and might save him/her some frustration and time.

Problem:

How to deal with different object types in one vector.

Example:

> testdata <- data.frame(id = c(1:5), x = c(1,2,3,NA,"Shre"))
> testdata
  id    x
1  1    1
2  2    2
3  3    3
4  4 <NA>
5  5 Shre
 
Here we have a data frame "testdata" where we have a variable "x" which say is supposed to be numeric but due to that funny entry "Shre" in the 5th row, the variable becomes a "factor".

> sapply(testdata[1,],class)
       id         x 
"integer"  "factor" 
 

 Now, if I try to convert the the variable "x" to numeric using as.numeric() this is what happens.
 
> testdata$x <- as.numeric(testdata$x) 
> testdata$x
[1]  1  2  3 NA  4
R understands "x" to be a factor and tries to coerce it to a numeric, which is a common mistake that I make in data analysis. This does not throw any error which makes it all the more difficult to detect/debug. Treating "x" to be factor the new value "Shre" is treated as the 4th category of the factor and is assigned numeric value "4" which is not what you want.

Solution:
So an elegant way of dealing with this is:

> testdata$x <- as.numeric(as.character(testdata$x)) 
Warning message:
NAs introduced by coercion 
> testdata$x
[1]  1  2  3 NA NA
Tada! We have coerced "NA's" but at least we do not have a random value "4" assigned to an observation.

5 comments:

  1. This is essentially Circle 8.2.1 of 'The R Inferno': http://www.burns-stat.com/documents/books/the-r-inferno/

    ReplyDelete
    Replies
    1. This book is certainly a must have for novice R coders like myself. Thanks for sharing this Mr. Burns.

      Delete
  2. you can also find this kind of stuff on this website :
    http://abcdr.2sigma.fr/435-comment-transromer-un-vecteur-de-class-factor-vers-la-class-numeric-dans-r/

    ReplyDelete
  3. Incredible post! You well described how to deal with different object types. Indeed, You are very experienced person. Thanks!
    where to buy stocks

    ReplyDelete
  4. This type of article is interesting and fun to read. I like reading and I am always searching for informative info like this. four county mental health center independence ks

    ReplyDelete