[R] Warning from reshape2 when melting a data frame with uneven number of columns.
Ashim Kapoor
ashimkapoor at gmail.com
Sun Jun 4 17:03:38 CEST 2017
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.
>
>
>
[[alternative HTML version deleted]]
More information about the R-help
mailing list