Accessing another row's data

CarlosML27CarlosML27 Member Posts: 1 Contributor I
edited December 2018 in Help

Hi! I'm making a machine learning model to predict sports results (concretely, NFL results).


I have a table containing all the stats for the match for one team (i.e. Team#1 will have a different row than Team#2 for the same match, each match has 2 rows in this version of the table). I grouped this stats from another table that I have with each play from each match, using a "play team" attribute as the grouping attribute.


The problem that I have is for the defense plays that involves scoring as a counter attack when the defensive team intercepts the ball. Those plays are part of the offense team plays as they started them, so I cannot access this data from the other row. I know there's the "lag series" operator, but I cannot use it because I have to do it both ways (I can only use it from higher to lower rows, but no backwards as it doesn't accept negative numbers).


Do you know any other way to access the data from other rows? Do you recommend me other aproach instead of the one I'm using?





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

    hello @CarlosML27 - so my first thought is "if this guy can predict NFL game results with RapidMiner..."  :)  My second thought is that I would definitely need to see your example set and your process to make sense of what you're trying to do.  You can attach the example set to a message here on the forum, and you can use the </> feature to insert your process XML.



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

    Take a look at the Series extension (free) and the lag operators.  They give you the functionality to compare different rows (depending on exactly what you want to do you should be able to configure it).



    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
Sign In or Register to comment.