Warning from reshape2 when melting a data frame with uneven number of columns.
Is this the solution?
d1<- as.data.frame(lapply(data,as.character),stringsAsFactors=FALSE) str(d1)
'data.frame': 3 obs. of 5 variables: $ V1: chr "Name1" "Name2" "Name3" $ V2: chr "nam1" "name_12" "name-1" $ V3: chr "nam2" "nam_34" "name-2" $ V4: chr "nam3" "nam_56" "" $ V5: chr "" "name_78" ""
melt(d1,id.vars="V1")
V1 variable value 1 Name1 V2 nam1 2 Name2 V2 name_12 3 Name3 V2 name-1 4 Name1 V3 nam2 5 Name2 V3 nam_34 6 Name3 V3 name-2 7 Name1 V4 nam3 8 Name2 V4 nam_56 9 Name3 V4 10 Name1 V5 11 Name2 V5 name_78 12 Name3 V5
On Sun, Jun 4, 2017 at 8:14 PM, John Kane <jrkrideau at yahoo.ca> wrote:
I am not really sure what the warning means but I think your underlying
problem is that all your variables are factors. Did you intend the values
in each variable to be character?
data.frame': 3 obs. of 5 variables:
$ V1: Factor w/ 3 levels "Name1","Name2",..: 1 2 3
$ V2: Factor w/ 3 levels "nam1","name-1",..: 1 3 2
$ V3: Factor w/ 3 levels "nam2","nam_34",..: 1 2 3
$ V4: Factor w/ 3 levels "","nam3","nam_56": 2 3 1
$ V5: Factor w/ 2 levels "","name_78": 1 2 1
On Sunday, June 4, 2017 6:48 AM, Ashim Kapoor <ashimkapoor at gmail.com>
wrote:
Here is a small reproducible example:
data <-
structure(list(V1 = structure(1:3, .Label = c("Name1", "Name2",
"Name3"), class = "factor"), V2 = structure(c(1L, 3L, 2L), .Label =
c("nam1",
"name-1", "name_12"), class = "factor"), V3 = structure(1:3, .Label =
c("nam2",
"nam_34", "name-2"), class = "factor"), V4 = structure(c(2L,
3L, 1L), .Label = c("", "nam3", "nam_56"), class = "factor"),
V5 = structure(c(1L, 2L, 1L), .Label = c("", "name_78"), class =
"factor")), .Names = c("V1",
"V2", "V3", "V4", "V5"), class = "data.frame", row.names = c(NA,
-3L))
library(reshape2)
data_long <- melt(data,id.vars="V1")
Warning message:
attributes are not identical across measure variables; they will be dropped
Can someone please tell me how to correct this?
Best Regards,
Ashim
[[alternative HTML version deleted]]
______________________________________________ R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/ posting-guide.html <http://www.r-project.org/posting-guide.html> and provide commented, minimal, self-contained, reproducible code.