Infosys Interview Question

given a csv file, load the employee data in dataframe and apply transformations on them. Simple transformations like add a derived column, group by, save output to file (other file format), etc