separating a ReadList of a CSV file into columns using Case

I have a really large file and would like to determine the pattern required for separating the columns by the different headers. I attempted to use Cases but it's been a long time since I've utilize the function Cases.

Mathematica seems to have a very poor source of information when it comes to data manipulation of imported CSV files.

raw_data = ReadList["file_name.csv", Word, RecordLists -> True]


The file can be uploaded from: https://ufile.io/mdvjz

Any help is appreciated.

It is not a .csv file but a semicolon separated values file, with missing values and even missing headers. So:

data = ReadList["...//rawdatatest.csv"
, Word, WordSeparators -> {";"}, RecordLists -> True, NullWords -> True
]

data[[;; 15, ;; 15]] // Dataset


• Is there a good text for learning importing and "cleaning" of data? – Physkid Mar 2 '18 at 7:44
• Maybe, but I'm not aware of any except sources here or in documentation of ReadList and friends. – Kuba Mar 2 '18 at 7:45
• All those values are strings because it is not clear what to expect. So you need to use ToExpression if you want to do calculations. – Kuba Mar 2 '18 at 8:03
• @Physkid it is for me but travel_time is not a valid variable name... – Kuba Mar 2 '18 at 8:11
• @Physkid how about you start investigating the content by yourself: InputForm@data[[2 ;; 15, 15]] – Kuba Mar 2 '18 at 8:27