Python Pandas DataFrame plot to draw different graphs with options

Pandas.DataFrame.plot to get line graphs using data

Let us create a DataFrame with name of the students and their marks.

Line Plot

A series of data joined by lines to draw a line graph.

Line Plot

Bar Graph

Data represented by set of vertical Bars .

Bar graph

Horizontal Bar

Data represented by set of Horizontal Bars .

HBar graph

Histogram

distribution of numerical or categorical data

Histogram

BoxPlot

depicting groups of numerical data through their quartiles
BoxPlot

Pie Chart

Pie Chart showing relative percentage distribution
Pie Chart

Density Chart

distribution of a numeric variable
Density

Area Chart

displays graphically quantitative data
Area

Scatter Chart

values for typically two variables for a set of data
Scatter

Hexbin Plot

relationship of 2 numerical variables
Hexbin

Graph using data from MySQL database

Saving graph as image

plot=df.plot.pie(title="Colors",y='MATH',autopct='%1.1f%%')
fig = plot.get_figure()
fig.savefig("D:\\my_data\\output2.png")

With subplots=True

plot=df.plot.line(subplots=True)[0].get_figure()
plot.savefig('my_pic.jpg')

Plotting graphs using DataFrame

plot-line	Plotting line graph with different options
plot-bar	Plotting bar graph with different options
plot-barh	Plotting Horizontal bar graph with different options
plot-hist	Histogram with different options
plot-boxplot	boxplot with different options
plot-pie	Pie diagram with different options
plot-density	Density diagram with different options
plot-area	Area diagram with different options
plot-scatter	Scatter plot with different options

Read how Excel or CSV file uploaded to Google drive and mounted to create Plots

Try the exercise on Pandas Plot
Graph using data from MySQL database Displaying graph on Tkinter GUI
Pandas to_csv() Filtering of Data

Numpy arrays Python & MySQL Python- Tutorials

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

Pandas DataFrame Plots

Saving graph as image

Subhendu Mohapatra