You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello,
I need some help with the following use case. I have 2 data frames that I am trying to link;
ACB ['ACB_CR_ID', 'ACB_RID', 'ACB_R_DATE', 'FIRST_NAME', 'LAST_NAME', 'DATE_OF_BIRTH', 'Program']
&
PRG ['PRG', 'PRG_ID', 'PRG_FIRST_NAME', 'PRG_LAST_NAME', 'PRG__DATE_OF_BIRTH']
I want to write a link_only version, where I fuzzy match on ACB.'FIRST_NAME' =PRG.'PRG_FIRST_NAME' and ACB.'LAST_NAME' = PRG.'PRG_LAST_NAME' and ACB.'DATE_OF_BIRTH' = PRG.'PRG__DATE_OF_BIRTH'. I tried to read the documentation but I can't seem to wrap my head around how to structure this. The biggest issue is that the two dataframes' column names don't match.
Thank you
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hello,
I need some help with the following use case. I have 2 data frames that I am trying to link;
ACB ['ACB_CR_ID', 'ACB_RID', 'ACB_R_DATE', 'FIRST_NAME', 'LAST_NAME', 'DATE_OF_BIRTH', 'Program']
&
PRG ['PRG', 'PRG_ID', 'PRG_FIRST_NAME', 'PRG_LAST_NAME', 'PRG__DATE_OF_BIRTH']
I want to write a link_only version, where I fuzzy match on ACB.'FIRST_NAME' =PRG.'PRG_FIRST_NAME' and ACB.'LAST_NAME' = PRG.'PRG_LAST_NAME' and ACB.'DATE_OF_BIRTH' = PRG.'PRG__DATE_OF_BIRTH'. I tried to read the documentation but I can't seem to wrap my head around how to structure this. The biggest issue is that the two dataframes' column names don't match.
Thank you
Beta Was this translation helpful? Give feedback.
All reactions