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

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

Output DataFrame: rowsCount = 7, columnsCount = 5
nameagecityweightisHappy
Cooper (Alice)15London54true
Dylan (Bob)45Dubai87true
Daniels (Charlie)20Moscownullfalse
Chaplin (Charlie)40Milannulltrue
Marley (Bob)30Tokyo68true
Wolf (Alice)20null55false
Byrd (Charlie)30Moscow90true