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

Parsing Dates for Diabetic Patients to check changes in lab results

arsalan_karimarsalan_karim Member Posts: 14 Contributor II
edited November 2018 in Help

Hi Everyone...

 

I have a database of diabetic patients which includes patients demographics, dates when different diseases were diagnosed and a bunch of lab values with their dates. I need to do an analysis on Diabetic patients and analyse their lab results before and after they became diabetic.

 

I have the following information:

DM = 1 (to filter all diabetics)

DM start date - to tell me when they were diagnosed of Diabetes Millitus

Lab test dates

lab test values

 

So basically I need to use the DM start date of each patient in the dataset and look for all other lab test dates and values prior to this date and after this date...

 

(keep in mind I have 2000 patients and this date might be different for every patient)

 

How can I do this...and create some plots - sample data file attached

 

would be a great help if someone one can help...

 

Dr Arsalan 

 

Answers

  • Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,761 Unicorn

    Do you have a patient ID that can be associated with each Date? That would make it simple IMHO.

  • arsalan_karimarsalan_karim Member Posts: 14 Contributor II

    Hi T-Bone

    Thanks for getting back... yes I do have the patient ID.

    Please check attached file...

     

    Arsalan

     

Sign In or Register to comment.