Practical Predictive Analytics

Importing the CSV file to databricks

Databricks contains a simple user interface which allows you to load a file to the Databricks HDFS filesystem. Alternatively, you can load the file directly to Amazon Web Services (AWS) and read the file directly from the Databricks API.

1. Switch to the Databricks application, select Tables, and then Data Import. Note that in some of the versions of Databricks this is embedded under the Data menu: Select "Tables", and then click the +.
2. You may be prompted to create a new cluster. If so, first follow the instructions for creating a new cluster as we did in Chapter 9.
3. Drag the file named 2015_sqf_csv from the PracticalPredictiveAnalytics directory to the data import box, as shown next:

4. Click on Preview ...