while try to read a csv file using data frame , read csv using a file format , but fail in case of formatting and column error while loading how the data in databricks ,the code i used for
df = spark.read.format("csv") \
.option("header", "true") \
.option("quote", '"') \
.option("delimiter", ",") \
.option("nullValue", "") \
.option("emptyValue", "NULL") \
.schema(schema) \
.load(f"{bronze_folder_path}/Test.csv")
this is actually data format