Read CSV file in pyspark with ANSI encoding

Question

I am trying to read in a csv/text file that requires it to be read in using ANSI encoding. However this is not working. Any ideas?

mainDF= spark.read.format("csv")\
                  .option("encoding","ANSI")\
                  .option("header","true")\
                  .option("maxRowsInMemory",1000)\
                  .option("inferSchema","false")\
                  .option("delimiter", "¬")\
                  .load(path)

java.nio.charset.UnsupportedCharsetException: ANSI

The file is over 5GB hence the spark requirement.

I have also tried ANSI in lower case

Answer 1

ISO-8859-1 is the same as ANSI so replace that as above