Exercise and solution on Python Pandas DataFrame plot

Read the data from Excel table and plot a line graph showing Number of students in each class.
Plot bar graph showing Class and its Mean mark of each class.
Plot bar graph showing Class and its Mean mark and Maximum mark of each class.
Create a Pie chart showing Class and number of students.
Create a density plot by using Mark

Solution 1

import pandas as pd 
my_data = pd.read_excel('D:\student.xlsx',index_col='id')
df=my_data['class1'].value_counts()
#print(my_out)
df.plot.line(title="Class and number of Marks");

Solution 2

import pandas as pd 
my_data = pd.read_excel('D:\student.xlsx',index_col='id')
df=my_data[['class1','mark']].groupby(['class1']).agg(['mean'])
df.plot.bar(title="Class1 and Mean mark");

Solution 3

import pandas as pd 
my_data = pd.read_excel('D:\student.xlsx',index_col='id')
df=my_data[['class1','mark']].groupby(['class1']).agg(['mean','max'])
df.plot.bar(title="Class with Mean and Max mark");

Solution 4

import pandas as pd 
my_data = pd.read_excel('D:\student.xlsx',index_col='id')
df=my_data['class1'].value_counts()
#print(my_out)
df.plot.pie(title="Class with number of students");

Solution 5

import pandas as pd 
my_data = pd.read_excel('D:\student.xlsx',index_col='id')
df=my_data['mark']
#print(my_out)
df.plot.density(title="Mark Density");

Pandas plot

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

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

Exercise on Pandas DataFrame Plots

Subhendu Mohapatra