Input 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

Step 1: Split
split1agecityweightisHappy
Cooper (Alice)15London54true
Dylan (Bob)45Dubai87true
Daniels (Charlie)20Moscownullfalse
Chaplin (Charlie)40Milannulltrue
Marley (Bob)30Tokyo68true
Wolf (Alice)20null55false
Byrd (Charlie)30Moscow90true

Step 2: SplitWithTransform
split1split2agecityweightisHappy
CooperAlice15London54true
DylanBob45Dubai87true
DanielsCharlie20Moscownullfalse
ChaplinCharlie40Milannulltrue
MarleyBob30Tokyo68true
WolfAlice20null55false
ByrdCharlie30Moscow90true

Output DataFrame: rowsCount = 7, columnsCount = 5
nameagecityweightisHappy
firstNamelastName
CooperAlice15London54true
DylanBob45Dubai87true
DanielsCharlie20Moscownullfalse
ChaplinCharlie40Milannulltrue
MarleyBob30Tokyo68true
WolfAlice20null55false
ByrdCharlie30Moscow90true