Publicis Sapient interview question

write spark procejure to transform a dataset