This is a minor issue, but I didn't expect this behavior:
# Create some dummy data:
library(data.table)
a <- as.data.table(matrix(1:4, ncol = 4))
a[, V1 := "x"]
setnames(a, 2:4, letters[2:4])
# make a new data.table out of the first one, transposing one of the vectors:
b <- data.table(name = names(a)[2:4], value = t(a[, 2:4]))
# produces:
b
name value.V1
1: b 2
2: c 3
3: d 4
I didn't expect my defined name value would become value.V1.
I'm aware I could have done b <- melt(a, 1)[, 2:3] (and then rename the first column) to obtain the correct result.
Reactions are currently unavailable
This is a minor issue, but I didn't expect this behavior:
# Create some dummy data: library(data.table) a <- as.data.table(matrix(1:4, ncol = 4)) a[, V1 := "x"] setnames(a, 2:4, letters[2:4]) # make a new data.table out of the first one, transposing one of the vectors: b <- data.table(name = names(a)[2:4], value = t(a[, 2:4])) # produces: b name value.V1 1: b 2 2: c 3 3: d 4I didn't expect my defined name value would become value.V1.
I'm aware I could have done b <- melt(a, 1)[, 2:3] (and then rename the first column) to obtain the correct result.