Scala Programming Projects

Drawing more charts

Since our aggregate DataFrame is available in scope, we can create new cells to plot different charts. Create two new cells with the following code:

%sparkz.show(aggregate)

Then, on each new cell, click on the line chart button and drag the start column to the keys section. After that:

1. In the first chart, drag and drop sumAmount in the values section. The chart shows the evolution of the volume exchanged.

2. In the second chart, drag and drop stddevPrice in the values section. The chart shows the evolution of the standard deviation.

3. Click on settings on both cells to hide the settings.

4. Click on Hide editor on both cells.

You should obtain something like this:

We can observe spikes at around the same time—when there ...