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
From the course: Python in Excel: Working with pandas DataFrames
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.