other.into("fullName").cast<Right>()
Input DataFrame: rowsCount = 7, columnsCount = 3
namecityyear
firstNamelastName
AliceCooperLondon2006
BobDylanDubai1976
CharlieDanielsMoscow2001
CharlieChaplinMilan1981
BobMarleyTokyo1991
AliceWolfnull2001
CharlieByrdMoscow1991

Step 1: DataFrame: rowsCount = 7, columnsCount = 3
fullNamecityyear
firstNamelastName
AliceCooperLondon2006
BobDylanDubai1976
CharlieDanielsMoscow2001
CharlieChaplinMilan1981
BobMarleyTokyo1991
AliceWolfnull2001
CharlieByrdMoscow1991

Output DataFrame: rowsCount = 7, columnsCount = 3
fullNamecityyear
firstNamelastName
AliceCooperLondon2006
BobDylanDubai1976
CharlieDanielsMoscow2001
CharlieChaplinMilan1981
BobMarleyTokyo1991
AliceWolfnull2001
CharlieByrdMoscow1991


df.join(other) { name match right.fullName }
Input DataFrame: rowsCount = 7, columnsCount = 5
nameagecityweightisHappy
firstNamelastName
AliceCooper15London54true
BobDylan45Dubai87true
CharlieDaniels20Moscownullfalse
CharlieChaplin40Milannulltrue
BobMarley30Tokyo68true
AliceWolf20null55false
CharlieByrd30Moscow90true

Output DataFrame: rowsCount = 7, columnsCount = 7
nameagecityweightisHappycity1year
firstNamelastName
AliceCooper15London54trueLondon2006
BobDylan45Dubai87trueDubai1976
CharlieDaniels20MoscownullfalseMoscow2001
CharlieChaplin40MilannulltrueMilan1981
BobMarley30Tokyo68trueTokyo1991
AliceWolf20null55falsenull2001
CharlieByrd30Moscow90trueMoscow1991


joined.df
Input DataFrame: rowsCount = 7, columnsCount = 7
nameagecityweightisHappycity1year
firstNamelastName
AliceCooper15London54trueLondon2006
BobDylan45Dubai87trueDubai1976
CharlieDaniels20MoscownullfalseMoscow2001
CharlieChaplin40MilannulltrueMilan1981
BobMarley30Tokyo68trueTokyo1991
AliceWolf20null55falsenull2001
CharlieByrd30Moscow90trueMoscow1991

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


joined.df
Input DataFrame: rowsCount = 7, columnsCount = 7
nameagecityweightisHappycity1year
firstNamelastName
AliceCooper15London54trueLondon2006
BobDylan45Dubai87trueDubai1976
CharlieDaniels20MoscownullfalseMoscow2001
CharlieChaplin40MilannulltrueMilan1981
BobMarley30Tokyo68trueTokyo1991
AliceWolf20null55falsenull2001
CharlieByrd30Moscow90trueMoscow1991

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