Read csv file of patient data

hai iam having csv file of patient data i need analyze each treatment average waiting time as well as same patient different treatments waiting time kindly help me. can i use apache spark with scala or sparksql .still iam in confusion.my sample data

2 1 Rajesh male 34 Checkup Surgery Chen 2014 08:30:00 08:45:00 15
3 1 Rajesh male 34 payment cashier Null 2014 08:50:00 08:55:01 5
4 1 Rajesh male 34 CT-Scan Scan Lee 2014 09:00:00 09:10:00 10
5 1 Rajesh male 34 MR-Scan scan Pant 2014 09:15:00 09:20:00 5
6 1 Rajesh male 34 Take Medicine Pharmacy null 2014 09:25:00 09:30:00 5
7 2 Kalpana female 25 Checkup Surgery Chen 2014 10:10:00 10:40:00 30
8 2 Kalpana female 25 payment cashier Null 2014 10:45:00 10:47:00 2
9 2 Kalpana female 25 CT-Scan Scan Lee 2014 10:55:00 11:10:00 15

Hi @siva_prasad you can do using both the methods as per your convenience.
Kindly share the input file/Column headers if you need the solution code :slight_smile:

hai i attached dataset scrrenshot .kindly provide me solution.