Repository navigation
feature request : transpose(keep.rownames = T)? #1886
Description
transposing up to now required this:
dt = data.table(x=1:5, y=6:10)
t(dt) %>% data.table(keep.rownames = T)
, so the transform function has potential to cut this short.
It has however no keep.rownames = T argument (or something similar), so the variable names disappear:
transpose(dt)
# V1 V2 V3 V4 V5
#1: 1 2 3 4 5
#2: 6 7 8 9 10
what I hoped to see was something like this:
# rn V1 V2 V3 V4 V5
#1: x 1 2 3 4 5
#2: y 6 7 8 9 10
Activity
juanpide commentedon Mar 8, 2017
This should be easy to implement and an important addition.
MichaelChirico commentedon Mar 8, 2017
juanpide commentedon Mar 8, 2017
Imagine you have a data.table with several columns, such as this toy example.
dt = data.table(A=1:5, B=c(NA,3,3,NA,NA), C=c(NA,NA,9,8,7))and you want to calculate several things to summarize the different variables.
Something similar to this:
t(apply(dt,2,function(x) rbind(sum(x,na.rm = T),sum(is.na(x)))))
But I having a result with colnames and rownames:
MichaelChirico commentedon Mar 21, 2017
This could have been useful in this SO post -- instead of needing the helper function
coefsplitto break apart the named result ofcoef(...), we could dotranspose(as.list(coef(...)), keep.rownames = TRUE).This comes at a sort of general thing that I run into a lot of needing to split the named result of a routine into separate columns because the names are important (most salient and consistent example being when I run
tableby group)Closes #1886 -- keep.rownames argument for transpose