Matplotlib is a comprehensive library for creating static, animated, and interactive visualizations in Python. It is a plotting library for the Python programming language and its numerical mathematics extension NumPy. In this article, we will learn how to plot data from an excel file in Matplotlib.
If you had not installed the Matplotlib and Pandas library you can install them using the pip command as follows:
pip install matplotlib pip install pandas
Excel Data Used
You can download the above excel sheet from here.
Plot Data from an Excel File in Matplotlib
Here, we can plot any graph from the excel file data by following 4 simple steps as shown in the example.
Example 1
Import Matplotlib and Pandas module, and read the excel file using the Pandas read_excel() method. After reading data for the x-axis and y-axis from the excel file. Plot the graph using the Matplotlib library. Here, we are plotting a bar graph hence using the bar() method and the show() method to display the graph.
Python3
import matplotlib.pyplot as plt import pandas as pd file = pd.read_excel('data.xlsx') x_axis = file['X values'] y_axis = file['Y values'] plt.bar(x_axis, y_axis, width=5) plt.xlabel("X-Axis") plt.ylabel("Y-Axis") plt.show() |
Output:
Example 2
Now, we can plot other graphs and charts by using data from an excel file. Let’s plot a pie chart from the excel file which we used earlier.
Python3
import matplotlib.pyplot as plt import pandas as pd file = pd.read_excel('data.xlsx') plt.pie(file['Value'],labels=file['Label']) plt.show() |
Output:
