English | 1h 22m | Video 720p | Subtitles | Project File

Python is the world's fastest growing programming language. It's a powerful tool that is helping to streamline development and data science. In this course from Madecraft, you can learn how to combine the power of the Python language with the data analysis and reporting tools in Microsoft Excel. Discover how to leverage the pandas and openpyxl libraries to inspect, filter, clean, and convert data and how to build solid reports that help businesses take action. Discover how to work with large amounts of data that would be unmanageable in Excel alone. By the end of this course, viewers will learn how this combination of tools can lead businesses to better insights than ever before.

 

 

This course was created by Madecraft. We are pleased to host this content in our library.

Topics include:

 

Loading and saving data with pandas

Filtering and sorting data with pandas

Formatting workbooks with openpyxl

Creating graphs and charts with openpyxl

Converting data

Advanced graphing

 

Homepage:

https://www.lynda.com/Python-tutorials/Using-Python-Excel/2243053-2.html