From the course: Python in Excel: Working with pandas DataFrames

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Plotting

Plotting

From the course: Python in Excel: Working with pandas DataFrames

Start my 1-month free trial Buy for my team

Plotting

“

- [Instructor] Python in Excel gives you access to the plotting libraries Matplotlab and Seaborn. In comparison to native Excel charts, they offer additional and more complex chart types and they can plot bigger datasets. Matplotlib is Python's go-to library for static plotting. By static, I mean that the plot is really a picture without any interactivity. However, Matplotlib is a low-level library, so it can take a lot of code to achieve a fairly simple thing. This is why Pandas makes it easy for us to create a plot from a data frame without having to use Matplotlib directly. Seaborn is also built on top of Matplotlib. It provides a simpler way to generate complex statistical plots. We'll use Seaborn in the last part of this course, but in this video we're going to concentrate on using Matplotlib via Pandas. To learn how to use Pandas for plotting, let's visualize how many students come from each country. After turning the Excel table into a data frame in cell K1, we can use the…

Contents