Tags » Roger Sanchez

Rolling Self join with data.table to calculate differences when values are missing

I have a dataset of dt,id1,id2,value that I would like to process with data.table and fill missing values. I think I might need to use rolling self joins / cross joins. 391 more words

Recent Questions - Stack Overflow

Rolling Self join with data.table to calculate differences when values are missing

I have a dataset of this form that I would like to process with dplyr and/or data.table and I think I might need to use rolling self joins. 218 more words

Recent Questions - Stack Overflow

Self join with data.table to calculate differences when values are missing

I have a dataset of this form that I would like to process with dplyr and/or data.table and I think I might need to use rolling self joins. 245 more words

Recent Questions - Stack Overflow

Efficient calculation of changes with dplyr on large datasets with missing values

I have a dataset of this form that I would like to process with dplyr and/or data.table.

GeoCode   Block      ReportDate ReportType   Population
10000         A      3/31/2010  Initial      100
10000         B      3/31/2010  Initial      100    
10000         A      6/30/2010  Full         130
10000         B      7/15/2010  Partial      75
10000         A      9/30/2010  Partial      50
10000         B      12/31/2010 Full         90
… 150 more words
Recent Questions - Stack Overflow