df.update { age }.with { it * 2 }

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

Step 1: Update

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

DataFrame [7 x 5]

Output DataFrame: rowsCount = 7, columnsCount = 5

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

df.update { colsAtAnyDepth().colsOf<String>() }.with { it.uppercase() }

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

Step 1: Update

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

DataFrame [7 x 5]

Output 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

df.update { weight }.at(1..4).notNull { it / 2 }

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

Step 1: Update

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

DataFrame [7 x 5]

Step 2: Update

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

DataFrame [7 x 5]

Output DataFrame: rowsCount = 7, columnsCount = 5

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

df.update { name.lastName and age }.at(1, 3, 4).withNull()

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

Step 1: Update

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

DataFrame [7 x 5]

Step 2: Update

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

DataFrame [7 x 5]

Output DataFrame: rowsCount = 7, columnsCount = 5

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