R help - Jun 2017 - Warning from reshape2 when melting a data frame with uneven number of columns.

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]]

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
and provide commented, minimal, self-contained, reproducible code.


   
	[[alternative HTML version deleted]]

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]]