How do I convert multiple columns into one from Binary data?

Question

My data has 3 surveys per year (for 10 years) where 1 represents presence and 0s present absence. The subset looks like this

x <- structure(c(0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 
                 0, 1, 1, 1, 0, 1, 1, 1, 0, 1, 1, 1, 
                 0, 1, 1, 1, 0, 1, 1, 1, 0, 1, 1, 1, 
                 0, 1, 1, 1, 0, 1, 1, 1, 0, 1, 1, 1), 
               .Dim = c(4L, 3L, 4L))

I want to collapse these three columns into one in a way that every row that has 1 in any survey, shows 1 in the final otherwise shows 0.

What do the dimensions of your array represent? ie, is it [subject, survey, year], or [year, survey, subject]…? — zephryl
– zephryl, Commented Feb 9, 2022 at 12:41
Provide reproducible data dput(mydata). Solution would something like as.integer(rowSums(x)>0) — zx8754
– zx8754, Commented Feb 9, 2022 at 13:14
Please have a look at the How to make a great R reproducible example discussion in order to improve your question. — Konrad
– Konrad, Commented Feb 9, 2022 at 14:32

Mikael Jagan · Accepted Answer · 2022-02-09 15:33:52Z

2

Collapse the second dimension of the array with apply:

apply(x, c(1L, 3L), function(y) as.integer(any(as.logical(y))))
##      [,1] [,2] [,3] [,4]
## [1,]    0    0    0    0
## [2,]    1    1    1    1
## [3,]    0    1    1    1
## [4,]    1    1    1    1

The result is a [site, year] matrix.

answered Feb 9, 2022 at 15:33

Mikael Jagan

11.5k2 gold badges23 silver badges54 bronze badges

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

Comments

akrun · Accepted Answer · 2022-02-09 15:51:28Z

1

We could use max

apply(x, c(1, 3), FUN = max)
     [,1] [,2] [,3] [,4]
[1,]    0    0    0    0
[2,]    1    1    1    1
[3,]    0    1    1    1
[4,]    1    1    1    1

answered Feb 9, 2022 at 15:51

akrun

891k38 gold badges590 silver badges700 bronze badges

1 Comment

Mikael Jagan Over a year ago

Yes, that is much better!

Collectives™ on Stack Overflow

How do I convert multiple columns into one from Binary data?

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related