Excel Analysis with Python and Pandas

Excel Analysis with Python and Pandas

Become an expert at using Python to process and generate Excel spreadsheets

Microsoft Excel has a long and proud history of bringing data analysis and processing to the masses with its intuitive interface and powerful functionality. However, it has important limitations that are only becoming more apparent in our current age of Big Data and that can only be surpassed by up-skilling to a more programming oriented context.

This lecture will introduce you to the ways in which Python and Pandas can be used to build up on your Excel analyses to bring the power of sophisticated Data Science and Machine Learning tools into your pipeline. We’ll also cover how to both read data from and write results to Excel spreadsheets.

Inside you'll find:

• Detailed slide deck
• 5 Jupyter notebooks:
  • Excel Pitfalls
  • Pandas DataFrames
  • Simple Data Modeling
  • Manipulating Excel Spreadsheets
  • Advanced Spreadsheet Functionality

With this course you'll learn:

• Importing csv files and Excel spreadsheets
• DataFrame Manipulations
• Generating simple Excel spreadsheets

• Pivot tables
• Curve fitting

• Adding sheets to a workbook
• Reading and formatting Excel files
• Appending a dataframe to an excel sheet
• Adding Excel Charts to a workbook
• Formatting cell fonts and font sizes

And much more!