Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
identify "consecutive dates"
AbbasZavar22
Member Posts: 6 Learner I
in Help
I have patients' data set and I have to identify two "consecutive dates" of lab test results dates which are between 90-700 days.
Each patient has several lab test results, how can I compare all two dates together and find the consecutive dates?
Patient_ID Performed_date TestResult
Each patient has several lab test results, how can I compare all two dates together and find the consecutive dates?
Patient_ID Performed_date TestResult
1.00100000023498E15 | Thu May 28 2015 | 54.0 |
1.00100000023498E15 | Thu Sep 26 2013 | 59.0 |
1.00100000023498E15 | Tue Oct 28 2014 | 53.0 |
1.00100000023498E15 | Wed May 06 2015 | 54.0 |
1.00100000023498E15 | Tue May 05 2015 | 55.0 |
1.00100000023498E15 | Fri May 01 2015 | 48.0 |
0