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

Step 1: Merge
namemergedcityweightisHappy
firstNamelastName
AliceCooper[15]London54true
BobDylan[45]Dubai87true
CharlieDaniels[20]Moscownullfalse
CharlieChaplin[40]Milannulltrue
BobMarley[30]Tokyo68true
AliceWolf[20]null55false
CharlieByrd[30]Moscow90true

Output DataFrame: rowsCount = 7, columnsCount = 5
namedatacityweightisHappy
firstNamelastName
AliceCooper[15]London54true
BobDylan[45]Dubai87true
CharlieDaniels[20]Moscownullfalse
CharlieChaplin[40]Milannulltrue
BobMarley[30]Tokyo68true
AliceWolf[20]null55false
CharlieByrd[30]Moscow90true