Python is coming to Excel

August 23, 2023

Topic

Software / Excel, Python

Excel is getting a bump in capabilities with Python integration. From Microsoft:

Excel users now have access to powerful analytics via Python for visualizations, cleaning data, machine learning, predictive analytics, and more. Users can now create end to end solutions that seamlessly combine Excel and Python – all within Excel. Using Excel’s built-in connectors and Power Query, users can easily bring external data into Python in Excel workflows. Python in Excel is compatible with the tools users already know and love, such as formulas, PivotTables, and Excel charts.

Sounds fun for both Excel users and Python developers.

It’s headed to the Beta Channel in Excel for Windows and then Excel for Windows proper. They didn’t announce a timeline for Mac.

Projects by FlowingData See All →

Bank Failures in the United States, Since 2001

These are all the failures since 2001, scaled by amount of assets in 2023 dollars.

How Much You Should Be Saving for Retirement

There are a lot of variables to consider, but for people of middle income, here’s a suggestion, based on when you start saving and when you want to retire.

Commonness of Divorce in America

I wondered how common it is for someone to get a divorce. While I’ve touched on the topic before, I’ve never calculated it directly, so I gave it a go.

Who Earned a Higher Salary Than You

Work changed over the years. Salaries changed over the years. I was curious: If you compared your personal income from present day, how would it compare to the distribution of salaries in previous decades?