[datatable-help] melt spread

Bacou, Melanie mel at mbacou.com
Wed Jan 18 05:17:10 CET 2017


Carl,
Have you look into the data.table::dcast function to reshape tables from 
long to wide formats? See e.g. 
ftp://cran.r-project.org/pub/R/web/packages/data.table/vignettes/datatable-reshape.html 


--Mel.


On 1/17/2017 8:27 PM, Carl Sutton wrote:
> Hi
>
> This question is for information, not a coding problem.
>
> Basic information:
> The data table I am attempting to melt has 363 columns and 85,074 rows 
> (246.5MB).  The first 14 are id variables and pose no problem.  One of 
> the measure vars has sequences of 2:9,  The other 34 have sequence of 
> 1:10.   think paste0("var_",1:10)
>
> What works:
> It is a simple matter to melt these measure var columns using columns 
> 15:363.   Thanks to an answer on a prior question I can use tstrsplit 
> to split the sequence number off the column heading,   So far, so good.
>
> The difficulty:
> The problems arises when I attempt to spread the variable column which 
> contains prior column names sans sequence numbers.   I have searched 
> but not found a data.table function to spread the contents of 
> "variable" into separate columns.  The tidyr "spread" command maxes 
> out my available memory of 12GB.  I have attempted to use patterns to 
> melt into separate columns but that results in column names of valuex, 
> not the original column name.  In searching the arguments for melt I 
> have not seen one for preserving the original column names.  Perhaps I 
> missed something?
>
> The solution:
> Am I stuck with either
>     a) splitting my data.table such that tidyr does not max out 
> available memory, or
> b)  use set names on 35 columns to get viable column names?
>  Any and all thoughts are appreciated.  I have 20 of these datasets to 
> mung and am starting on one of the smaller ones.  The goal is write 
> the code once and use it on all datasets.
>
> Carl Sutton
>
>
> _______________________________________________
> datatable-help mailing list
> datatable-help at lists.r-forge.r-project.org
> https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.r-forge.r-project.org/pipermail/datatable-help/attachments/20170117/31a29dce/attachment.html>


More information about the datatable-help mailing list