Problem Statement: -

Select all employee detail with First name not in "Vikas","Ashish", and "Nikhil".
Select first name from "EmployeeDetail" df after removing white spaces from right side
Select first name from "EmployeeDetail" table after removing white spaces from left side
Display first name and Gender as M/F.(if male then M, if Female then F)

df.select("First_Name").withColumn("First_Name",rtrim("First_Name")).show()
df.select("First_Name").withColumn("First_Name",ltrim("First_Name")).show()

df.withColumn("Gender",when(col("Gender") == "Male","M").otherwise("F")).show()

+----------+
|First_Name|
+----------+
|     Vikas|
|    nikita|
|    Ashish|
|    Nikhil|
|     anish|
+----------+

+----------+
|First_Name|
+----------+
|     Vikas|
|    nikita|
|    Ashish|
|    Nikhil|
|     anish|
+----------+

+----------+----------+---------+---------+--------------------+----------+------+
|EmployeeID|First_Name|Last_Name|   Salary|        Joining_Date|Department|Gender|
+----------+----------+---------+---------+--------------------+----------+------+
|         1|     Vikas|  Ahlawat| 600000.0|2013-02-15 11:16:...|        IT|     M|
|         2|    nikita|     Jain| 530000.0|2014-01-09 17:31:...|        HR|     F|
|         3|    Ashish|    Kumar|1000000.0|2014-01-09 10:05:...|        IT|     M|
|         4|    Nikhil|   Sharma| 480000.0|2014-01-09 09:00:...|        HR|     M|
|         5|     anish|   kadian| 500000.0|2014-01-09 09:31:...|   Payroll|     M|
+----------+----------+---------+---------+--------------------+----------+------+