From Matplotlib
Matplotlib contains a number of tools that can graphically model PostgreSQL data after being fed a data frame From Pandas.
Using PyPlot
Before any Matplotlib tool, such as pyplot, can be used, it must be imported:from matplotlib import pyplot as plt
Once a Pandas data frame is obtained, it can be used to create a plot visualizing PostgreSQL data. For example, the following plot generates and displays a bar graph relating ShipName and Freight values:
df.plot(kind="bar", x="ShipName", y=["Freight"]) plt.show()