Python-Powered Excel (O’Reilly Online Learning)

This article was first published on George J. Mount , and kindly contributed to python-bloggers. (You can report issue about the content on this page here)
Want to share your content on python-bloggers? click here.

I’m pleased to present a new O’Reilly Online Learning session on Python-Powered Excel on Friday Sept 18th at 12p Eastern.

The session is free to attend for all subscribers to the fantastic O’Reilly Online Learning platform. Check your employer or university for an institutional account, or really, consider signing up — and not just for this session! You’ll get access to an untold number of similarly insightful workshops and a vast multimedia library.

Driving Excel from Python

Excel has a lot going for it: it’s great for distributing data to people of all technical abilities to interact with and prototype on.

Python’s got a lot going for it too: it allows for fast, reproducible workflows driven by code.

Combining data products is often where the magic happens in analytics. You’ll see that in action at this O’Reilly Media Online learning session on Friday Sept 18th at 12p Eastern.

In this workshop, you’ll learn how to build fully automated workbooks from Python. It’s the ease of Excel combined with the power of Python.

You can register and see the full event description here on the O’Reilly platform.

Schedule here:

Up and running with Python in Excel (55 minutes)

  • Presentation: Reading in data from Excel—working with Jupyter notebooks, assigning Python objects to imported Excel data, setting column names and attributes, working with multiple worksheets; beginning the workbook do-over—adding rows, columns, and formulas to a workbook from Python, customizing workbook settings (changing fonts and sizes, adding borders, freezing panes, etc.)
  • Jupyter Notebook exercise: Read Excel data into Python and customize the workbook
  • Q&A

Break (5 minutes)

Managing workbooks (55 minutes)

  • Presentation: Customizing cells and ranges—defining names and ranges, adding cell comments, setting conditional formatting; customizing worksheets—adding data validation and worksheet protection, hiding and grouping rows, columns, and worksheets
  • Jupyter Notebook exercise: Customize ranges and worksheets from Python
  • Q&A

Break (5 minutes)

Python for data analysis (60 minutes)

  • Presentation: Using pandas with Excel—exploring and summarizing Excel data in Python, operating on tabular data in Python with pandas; data visualization—adding Excel sparklines and charts from Python, inserting Python visualizations into Excel
  • Jupyter Notebook exercise: Analyze and visualize Excel data from Python
  • Q&A

Excited? Me too! And so are lots of other people, so you should register now 🙂

You can also view the preliminary slides, datasets and demo notes at the course’s GitHub repo.

I hope to see you there — the more attendees I get, the more awesome programs I can provide.

To leave a comment for the author, please follow the link and comment on their blog: George J. Mount .

Want to share your content on python-bloggers? click here.