[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