I have a | delimited csv file with data as shown below. However, when the data is read from csv into a data frame, the dataframe output is as below: |Name|Age|Address|Occupation| |Tom|20|Houston Texas USA|Doctor| |Brad|21|Austin Texas USA|Chef| |Harry|22|Chicago|NULL| |Illinois|NULL|NULL|NULL| |USA|Student|NULL|NULL| How can I read the data in pyspark in proper format where the data can be written in table as shown below Continue reading...