turi-code / SFrame

SFrame: Scalable tabular and graph data-structures built for out-of-core data analysis and machine learning.
BSD 3-Clause "New" or "Revised" License
890 stars 331 forks source link

TimeSeries shift for multiple columns ? #150

Open asafyish opened 8 years ago

asafyish commented 8 years ago

Hi,

We are using a TimeSeries and shift, but we want the shift to the values for a certain group, something like that: We got the following data : ts, group, value 1 a q 1 b r 2 a w 2 b t 3 a e 3 b y 4 b u

We want to shift the values in column "value" for a group using timestamp: ts, group, value 1 a r 2 a w 3 a t 1 b e 2 b y 3 b u 4 b -

esoroush commented 8 years ago

Hi, I couldn't fully understand your question and would be great if you clarify the example. I think what you want is to group the timeseries object, extract one of the groups, and then shift values only for that group.

Have you looked at this?: https://dato.com/products/create/docs/generated/graphlab.TimeSeries.group.html

btw, can you post those issues in our forum: http://forum.dato.com/

Thank you

asafyish commented 8 years ago

Hi,

We want to shift values of multiple groups. What we have is a clickstream, with timestamp, userid and one more value. We need to shift the value, but only inside each group (which is actually a user).

Yeah maybe I should have posted in the forums, but it felt like a new feature that we need :)