df.innerJoin(other) { name and city }

Input DataFrame: rowsCount = 7, columnsCount = 5

name		age	city	weight	isHappy
firstName	lastName
Alice	Cooper	15	London	54	true
Bob	Dylan	45	Dubai	87	true
Charlie	Daniels	20	Moscow	null	false
Charlie	Chaplin	40	Milan	null	true
Bob	Marley	30	Tokyo	68	true
Alice	Wolf	20	null	55	false
Charlie	Byrd	30	Moscow	90	true

Output DataFrame: rowsCount = 7, columnsCount = 6

name		age	city	weight	isHappy	year
firstName	lastName
Alice	Cooper	15	London	54	true	2006
Bob	Dylan	45	Dubai	87	true	1976
Charlie	Daniels	20	Moscow	null	false	2001
Charlie	Chaplin	40	Milan	null	true	1981
Bob	Marley	30	Tokyo	68	true	1991
Alice	Wolf	20	null	55	false	2001
Charlie	Byrd	30	Moscow	90	true	1991

df.leftJoin(other) { name and city }

Input DataFrame: rowsCount = 7, columnsCount = 5

name		age	city	weight	isHappy
firstName	lastName
Alice	Cooper	15	London	54	true
Bob	Dylan	45	Dubai	87	true
Charlie	Daniels	20	Moscow	null	false
Charlie	Chaplin	40	Milan	null	true
Bob	Marley	30	Tokyo	68	true
Alice	Wolf	20	null	55	false
Charlie	Byrd	30	Moscow	90	true

Output DataFrame: rowsCount = 7, columnsCount = 6

name		age	city	weight	isHappy	year
firstName	lastName
Alice	Cooper	15	London	54	true	2006
Bob	Dylan	45	Dubai	87	true	1976
Charlie	Daniels	20	Moscow	null	false	2001
Charlie	Chaplin	40	Milan	null	true	1981
Bob	Marley	30	Tokyo	68	true	1991
Alice	Wolf	20	null	55	false	2001
Charlie	Byrd	30	Moscow	90	true	1991

df.rightJoin(other) { name and city }

Input DataFrame: rowsCount = 7, columnsCount = 5

name		age	city	weight	isHappy
firstName	lastName
Alice	Cooper	15	London	54	true
Bob	Dylan	45	Dubai	87	true
Charlie	Daniels	20	Moscow	null	false
Charlie	Chaplin	40	Milan	null	true
Bob	Marley	30	Tokyo	68	true
Alice	Wolf	20	null	55	false
Charlie	Byrd	30	Moscow	90	true

Output DataFrame: rowsCount = 7, columnsCount = 6

name		age	city	weight	isHappy	year
firstName	lastName
Alice	Cooper	15	London	54	true	2006
Bob	Dylan	45	Dubai	87	true	1976
Charlie	Daniels	20	Moscow	null	false	2001
Charlie	Chaplin	40	Milan	null	true	1981
Bob	Marley	30	Tokyo	68	true	1991
Alice	Wolf	20	null	55	false	2001
Charlie	Byrd	30	Moscow	90	true	1991

df.fullJoin(other) { name and city }

Input DataFrame: rowsCount = 7, columnsCount = 5

name		age	city	weight	isHappy
firstName	lastName
Alice	Cooper	15	London	54	true
Bob	Dylan	45	Dubai	87	true
Charlie	Daniels	20	Moscow	null	false
Charlie	Chaplin	40	Milan	null	true
Bob	Marley	30	Tokyo	68	true
Alice	Wolf	20	null	55	false
Charlie	Byrd	30	Moscow	90	true

Output DataFrame: rowsCount = 7, columnsCount = 6

name		age	city	weight	isHappy	year
firstName	lastName
Alice	Cooper	15	London	54	true	2006
Bob	Dylan	45	Dubai	87	true	1976
Charlie	Daniels	20	Moscow	null	false	2001
Charlie	Chaplin	40	Milan	null	true	1981
Bob	Marley	30	Tokyo	68	true	1991
Alice	Wolf	20	null	55	false	2001
Charlie	Byrd	30	Moscow	90	true	1991

df.excludeJoin(other) { name and city }

Input DataFrame: rowsCount = 7, columnsCount = 5

name		age	city	weight	isHappy
firstName	lastName
Alice	Cooper	15	London	54	true
Bob	Dylan	45	Dubai	87	true
Charlie	Daniels	20	Moscow	null	false
Charlie	Chaplin	40	Milan	null	true
Bob	Marley	30	Tokyo	68	true
Alice	Wolf	20	null	55	false
Charlie	Byrd	30	Moscow	90	true

Output DataFrame: rowsCount = 0, columnsCount = 5

name		age	city	weight	isHappy
firstName	lastName