Input DataFrame: rowsCount = 7, columnsCount = 5
nameagecityweightisHappy
firstNamelastName
AliceCooper15London54true
BobDylan45Dubai87true
CharlieDaniels20Moscownullfalse
CharlieChaplin40Milannulltrue
BobMarley30Tokyo68true
AliceWolf20null55false
CharlieByrd30Moscow90true

Step 1: Merge
mergedagecityweightisHappy
[Alice, Cooper]15London54true
[Bob, Dylan]45Dubai87true
[Charlie, Daniels]20Moscownullfalse
[Charlie, Chaplin]40Milannulltrue
[Bob, Marley]30Tokyo68true
[Alice, Wolf]20null55false
[Charlie, Byrd]30Moscow90true

Output DataFrame: rowsCount = 7, columnsCount = 5
fullNameagecityweightisHappy
Alice Cooper15London54true
Bob Dylan45Dubai87true
Charlie Daniels20Moscownullfalse
Charlie Chaplin40Milannulltrue
Bob Marley30Tokyo68true
Alice Wolf20null55false
Charlie Byrd30Moscow90true