1. This data frame has two columns name and info. Name has value as John and info has vale as 1® VOC.

After writing this data, I can read correct values in databricks but when I download the csv file and load it in notepad ( utf-8 ) , it is showing no values.

even if I click on edit in container, it is showing empty values.

What can be the reason? And what is the solution ?

df. write. format (‘csv').option ('header', True).option( 'encoding', 'UTF-8').option(' sep', '|^|’) .mode ('overwrite'). save('/mnt/Filestore/data/job1/test.dta')