Combine all colums with duplicated and empty data into a vector?

Question

In a data frame where all colums contain either missing or the same data, how can I get a vector with all the data and nothing missing, assuming no colum has all the values.

Example data frame here as I'm struggling to describe what I mean

x <-data.frame(c( "r", "t", "", "y"), c("", "t", "x", "y"), c("r","","x", ""))

desired output would be a vector like the one given with c("r", "t", "x", "y"), or a column like that.

I have tried using duplicated and distinct but haven't managed to work it.

This gives me the values, but the order is important and it returns y before x, I'll read up on what unlist is doing to see if I can maintain the order. — mmm, Aug 23 '17 at 18:46

d.b · Answer 1 · 2017-08-23T19:08:07.903

2

temp = unique(c(t(x)))
temp = temp[temp != ""]
temp
#[1] "r" "t" "x" "y"

edited Aug 23 '17 at 19:08

answered Aug 23 '17 at 18:49

d.b

32,245
6
36
77

score 0 · Answer 2 · answered Aug 23 '17 at 18:56

0

My solution is a bit more convoluted, but here it goes.

apply(x, 1, function(y) names(table(y)[max(table(y))]))
[1] "r" "t" "x" "y"

answered Aug 23 '17 at 18:56

Rui Barradas

70,273
8
34
66

Combine all colums with duplicated and empty data into a vector?

2 Answers2