How to join different examples generated with overlapping start and stoptime
Hi,
Examples have as attributes: Patient ID, LOS (Length of stay), Admissiondate, Dischargedate.
Some patients have multiple admissions which is normal but some patients have a first Dischargedate being the same as the second Admissiondate resulting in 2 admissions where in reality the patient was only admitted once. How to have 2 examples "joined" in one when in fact one event was timestamped as 2 events. When 2 events are put in one, the Length of stay should be added.
Thanks
Sven
Find more posts tagged with
Aggregation of LOS by patient ID but how to distinguish 2 events which are real (discharge 1 and admission 2) are completely different in time, from 2 events that actually are only one event because discharge 1 and admission 2 are identical or almost identical)
Altair EmployeeHi Sven,
Balasz posted on his blog a generic join script: https://datascientist.at/2016/06/generic-joins-in-rapidminer/
You can also join on date in range and so on.
Cheers,
Martin
hi @SvenVanPoucke - can you Aggregate LOS by Patient ID?