The first lesson explores how the Pandas module can support standard business analytics commonly done in a spreadsheet.
By the end of this lesson, you will understand how Python, and in particular the pandas module, can support many common Excel tasks.
Approximately 1 hour.
Video: Watch the Excel in Python video, which will discuss how many spreadsheet tasks can be performed effectively (and on very large data) by using a Python data analytics script.
Reading: A discussion on performing simple Excel tasks in Python by using the Pandas Module. Note, you do not need to master these skills, this is just a demonstration of how one migrates from Excel (or spreadsheets in general) to analytics with Python. Thus, you do not need to install the fuzzywuzzy module (unless you so wish).
© 2017: Robert J. Brunner at the University of Illinois.
This notebook is released under the Creative Commons license CC BY-NC-SA 4.0. Any reproduction, adaptation, distribution, dissemination or making available of this notebook for commercial use is not allowed unless authorized in writing by the copyright holder.