Converting data into binary within a data frame

Question

This table is called 'temp'

   No. of times   Clear   Included    Percentage
         2           1        1           0.50
         4           0        1           0.60
         0           0        0           0.20

For example, if I have this data set, I want to be converting all numbers above 0 under the 'No. of times' column to a 1 and leaving the 0 as it is.

Overall I'm wanting a data set looking like this

    No. of times   Clear   Included    Percentage
         1           1        1           0.50
         1           0        1           0.60
         0           0        0           0.20

How can I do this?

Hi, you are using the terms data.frame, data.table and table interchangeably, which is a mistake. They are distinct classes of R objects and you should not use them interchangeably. — Ricardo Saporta
– Ricardo Saporta, Commented Jan 14, 2014 at 22:49

Wilmer E. Henao · Accepted Answer · 2014-01-14 22:41:36Z

5

temp[ ,"No. of times"] <- sign(temp[ ,"No. of times"])

answered Jan 14, 2014 at 22:41

Wilmer E. Henao

4,3402 gold badges34 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3192175 Over a year ago

I tried your way but the output was a list of all the numbers. I want the numbers to be incorporated back within the data table format I've shown above. How is this done?

Wilmer E. Henao Over a year ago

Sounds like you only ran the right part. sign(temp[ ,"No. of times"]) If you type print(temp) you will see the whole thing :)

Uli Köhler · Accepted Answer · 2014-01-15 01:53:06Z

3

great place to use ifelse

 temp$`No. of times` <- ifelse(temp$`No. of times` > 0, 1, 0)

As an aside, you might want to use

names(temp) <- make.names(names(temp))

edited Jan 15, 2014 at 1:53

Uli Köhler

13.9k17 gold badges75 silver badges127 bronze badges

answered Jan 14, 2014 at 22:38

Ricardo Saporta

55.5k17 gold badges149 silver badges180 bronze badges

3 Comments

user3192175 Over a year ago

I tried your first method with ifelse, but the output was a list of all the numbers. I want the numbers to be incorporated within the data table format I've shown above. How is this done?

Ricardo Saporta Over a year ago

Did you run what I have above? It is getting assigned back into temp, so use print(temp). Also, is your object a data.table or a data.frame (are you calling library(data.table) in your code?)

Ricardo Saporta Over a year ago

No prob, glad it helped. Personally, I like @WilmerEHenaoH 's method better. You might want to give it a check mark ;)

Gavin Simpson · Accepted Answer · 2014-01-14 23:06:42Z

2

A trick, but

temp[ , "No. of times"] <- (temp[ , "No. of times"] > 0) + 0

will also do the operation you want. I say a trick, because the part in parentheses (temp[ , "No. of times"] > 0) evaluates to a logical which is then coerced to 0 or 1 through the addition with 0.

answered Jan 14, 2014 at 23:06

Gavin Simpson

176k28 gold badges405 silver badges461 bronze badges

Collectives™ on Stack Overflow

Converting data into binary within a data frame

3 Answers 3

2 Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related