Julia 1.0 Programming Complete Reference Guide

Loading the data

Loading this dataset is going to be a bit more challenging, as we have to work with three distinct files, and due to the particularities of the data itself. Here is the head of the BX-Users.csv file, in a plain text editor:

We have to explicitly handle the following formatting particularities, which will otherwise cause the import to fail:

• The columns are separated by ; instead of the more customary comma or Tab
• Missing values are represented by the string NULL
• The first row is the header, representing the column names
• The data is enclosed in double quotes " ", and double quotes within the data itself are escaped by backslashes, ...