The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Lead-Lag Effect in time series | How to find cross-correlations?

eldenosoeldenoso Member Posts: 65 Contributor II
edited November 2018 in Help

Hello altogether,

 

currently I am trying to find correlations between different time series. In my case it is possible that the time series are shifted to each other, thus that a possible correlation between the time series would also be shifted.
My question is, whether cross or auto-correlations are the right thing to do here (I've also read that rainflow could do the job?!). If so, are there any operators concerning this? I couldn't find cross or auto correlation functions in RM.

Thank you for your help.

Philipp :-)

EDIT:
If there is no such operator maybe there is a way to use the optimize parameters operator in which the two time series are shifted (is there an operator for that?) until highest correlation between both is achieved, so that at the end they are synchronized.

Answers

  • sgenzersgenzer Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager

    hmm good question.  @tftemme?

  • Telcontar120Telcontar120 RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn

    There is a Lag Series operator that you can use for this, but I don't think there is something that will automatically search and find the best auto-correlations.  But as you suggested, you may be able to do this using the Lag operator and putting it into a loop and then generating correlations and logging those to find the best values.

    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
  • tftemmetftemme Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, RMResearcher, Member Posts: 164 RM Research

    Hi Philipp,

     

    The Value Series extension on the Marketplace has the Operator Autocorrelation Transformation Operator, which calculates the autocorrelation coefficients for different lags. Before using this you have to convert your ExampleSet to a SeriesObject with the Data to Series Operator, and after the Transformation you have to convert it back with the Series to Data Operator.

     

    As Brian correctly mentioned, you can also use the Lag Series Operator from the Series extension, to calculate the lagged values and calculates the correlation for you self.

     

    Hope this helps,

    Best regards,
    Fabian

Sign In or Register to comment.