How to read csv file in spark using multiple delimiter

Hi Guys,

I have described the read csv file in spark using multiple delimiter & done practically with code.

Also please find below link for setup spark project:

[isharkpraveen]

He is showing with single delimiter in a file. where is multiple delimiter in a file?


Example:-

1, Mumbai, Maharashtra
2, Amirtsar, Punjab
3!Chennai, TamilNadu

[dinsan]

Hi,
Could you please create a video to combine below 3 csv data files into one data frame dynamically

File name: Class_01.csv
StudentID Student Name Gender Subject B Subject C Subject D
1 Balbinder Male 91 56 65
2 Sushma Female 90 60 70
3 Simon Male 75 67 89
4 Banita Female 52 65 73
5 Anita Female 78 92 57

File name: Class_02.csv
StudentID Student Name Gender Subject A Subject B Subject C Subject E
1 Richard Male 50 55 64 66
2 Sam Male 44 67 84 72
3 Rohan Male 67 54 75 96
4 Reshma Female 64 83 46 78
5 Kamal Male 78 89 91 90

File name: Class_03.csv
StudentID Student Name Gender Subject A Subject D Subject E
1 Mohan Male 70 39 45
2 Sohan Male 56 73 80
3 shyam Male 60 50 55
4 Radha Female 75 80 72
5 Kirthi Female 60 50 55