I have a data-set like:
org_id patient_id date
313 455259 2018-01-07
313 455259 2018-04-09
679 455259 2018-07-08
780 455259 2018-09-06
This patient was at the same org in the first two claims. After that, they changed orgs. How I find the first org they change to? For example, this is the output I am looking for -
org patient new_org
313 455259 679