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

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

Subscribe to our YouTube Channel here

Exercise on Pandas DataFrame Plots

Subhendu Mohapatra