如何基于多列合并重复数据行？附操作规范与示例

合并规则 #

• 以PIN和TIN列为主键合并重复记录
• 可将DOB列与其他列拼接作为辅助键
• 确保所有相似记录均按上述规则合并

示例输入 #

DID        FIRST NAME  MIDDLE NAME  LAST NAME  STREET  CITY  STATE  ZIP    DOB        PIN                TIN
CRA0012347129   John JR       Nan      Doe      Nan     Nan   Nan 1124.0 02-07-2020 12345678998765432 268869162.0
CRA0012347152   John          Nan      Doe      Nan     Nan   Nan  201.0 12-12-2020 12261986          Nan
CRA0012347286   John          Nan      Doe      Nan     Nan   Nan   Nan Nan 12261986      268869162.0

操作说明 #

1. 以PIN和TIN列为主键合并重复记录
2. 可将DOB列与其他列拼接作为辅助键
3. 确保所有相似记录均按上述两点合并

预期输出 #

DID                                          FIRST NAME      MIDDLE NAME LAST NAME STREET CITY  STATE  ZIP         
CRA0012347129, CRA0012347152, CRA0012347286  John JR, John       NaN        Doe     NaN    NaN   NaN   1124, 201   

 DOB                          PIN                        TIN
02/07/2020, 12/12/2020  12345678998765432,'012261986  '268869162

内容的提问来源于stack exchange，提问作者Chaitanya Teli