In an earlier post I wrote about the role of Python in modern Excel and what spreadsheets users stand to gain by learning the programming language: In this post, we’ll compare and contrast two essential packages using Python with Excel: pandas and openpyxl. Why pandas for Excel? If you’... [...Read more...]

As the world of data analytics grows vaster and more complex, what role will Excel serve? Will it become obsolete in an AI-powered data ecosystem? This post explores the emergence of augmented analytics and the role Excel will play in this transformation. Data is getting more complex In 2017, the International ... [...Read more...]

This event has concluded. Thank you to the Financial Modeling Institute for the opportunity to present. In March 2023 I had the opportunity to lead a one-hour webinar with the Financial Modeling Institute (FMI) on an introduction to Python. Event description: If you’re a financial professional looking to grow your ... [...Read more...]

[...Read more...]

[...Read more...]

[...Read more...]

I’ve mentioned a few times on this blog (example) about the growing possibility for Python Excel interoperability. Here’s a simple task done in a way I wasn’t aware of (h/t — where else? — StackOverflow.) Usually when combining Python and Excel I use specific packages like openpyxl, xlwings ... [...Read more...]

[...Read more...]

[...Read more...]

A major reason I think it’s easier for Excel users to pick up R versus Python is that these tools tend to “think” more similarly than Python. See what I mean here: let’s take a range of numbers and attempt to multiply it by two using the built-in ... [...Read more...]