I have got a huge csv file. Some sample records are given below:
#station,t1,t2,t3,É,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Parliament,-,-,-,-,-,5:30,-,5:46,-,5:57,-,6:16,6:27
Melbourne Central,-,-,-,-,-,5:32,-,5:48,-,5:59,-,6:18
Flagstaff,-,-,-,-,-,5:33,-,5:49,-,6:00,-,6:19,6:30
Southern Cross,-,-,-,-,-,5:35,-,5:51,-,6:02,-,6:21,6:32
Detail records can be seen here
webpage. (Each train schedule needs to be one object in this case)
I want to create each column as an object (not row) i.e t1,-,-,- (column 2) as one object and then t2,-,,(column 3) as another and so on.
What is the best way for accomplishing this? Will appreciate your response.