Loading...

Scatter Plots

General

Let’s begin by importing VerticaPy.

import verticapy as vp

Let’s also import numpy to create a random dataset.

import numpy as np

Let’s generate a dataset using the following data.

N = 20 # Number of records

data = vp.vDataFrame({
  "category": [np.random.choice(['A','B','C']) for _ in range(N)],
  "x": np.random.normal(5, 1, N),
  "y": np.random.normal(8, 1.5, N),
  "z": np.random.normal(10, 2, N),
})

In the context of data visualization, we have the flexibility to harness multiple plotting libraries to craft a wide range of graphical representations. VerticaPy, as a versatile tool, provides support for several graphic libraries, such as Matplotlib, Highcharts, and Plotly. Each of these libraries offers unique features and capabilities, allowing us to choose the most suitable one for our specific data visualization needs.

_images/plotting_libs.png

Note

To select the desired plotting library, we simply need to use the set_option function. VerticaPy offers the flexibility to smoothly transition between different plotting libraries. In instances where a particular graphic is not supported by the chosen library or is not supported within the VerticaPy framework, the tool will automatically generate a warning and then switch to an alternative library where the graphic can be created.

Please click on the tabs to view the various graphics generated by the different plotting libraries.

We can switch to using the plotly module.

vp.set_option("plotting_lib", "plotly")

In VerticaPy, you can generate various types of scatter plots by adjusting both the number of elements and the size of the data points (bubbles), providing you with versatile options for visualizing your data.

data.scatter(columns = ["x", "y"])

We load the VerticaPy chart extension.

%load_ext verticapy.chart

We write the SQL query using Jupyter magic cells.

%%chart -k scatter
SELECT x, y FROM :data;

data.scatter(columns = ["x", "y", "z"])

We load the VerticaPy chart extension.

%load_ext verticapy.chart

We write the SQL query using Jupyter magic cells.

%%chart -k scatter
SELECT x, y, z FROM :data;