当存在多个需要转换的变量时,如何保留转化后分类变量variable的值,而不是变为1,2, 3,...
如如下代码中,我希望变量year的值保留为2017、2018、2019,而不是1、2、3
s <- "bank, s2017, s2018, s2019, p2017, p2018, p2019
A, 10, 12, 11, 2, 5, 2
B, 20, 28, 18, 8, 10, 6
C, 8, 20, 18, 6, 6, 2"
wdt <- fread(text = s, header = TRUE)
ldt <- melt(wdt,
id.vars = "bank",
measure.vars = patterns(sale = "^s", profit = "^p"),
variable.name = "year")[order(bank)]
谢谢